I am running a PERP server and it gets stuck at "Getting account info"... It is due to the fact I need a SQL database.
Where is the module I go to for SQL implementation?
How to go about MySQL on PERP
-
- New to forums
- Posts: 8
- https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
- Joined: Mon Mar 12, 2012 2:58 am
Re: How to go about MySQL on PERP
is it a game server you are running or a dedicated ?
you might have to setup the database yourself or import a templated database structure for the game to make it work
i was able to find this via gooogle search hope it helps you on your issue
you might have to setup the database yourself or import a templated database structure for the game to make it work
i was able to find this via gooogle search hope it helps you on your issue
Code: Select all
1.
2.
3.SET FOREIGN_KEY_CHECKS=0;
4.-- ----------------------------
5.-- Table structure for bans
6.-- ----------------------------
7.DROP TABLE IF EXISTS `bans`;
8.CREATE TABLE `bans` (
9. `ID` text,
10. `UNBAN` int(255) DEFAULT NULL,
11. `BANNER` text,
12. `NAME` text,
13. `REASON` text,
14. `BANNER_STEAMID` text
15.) ENGINE=InnoDB DEFAULT CHARSET=latin1;
16.
17.-- ----------------------------
18.-- Table structure for cms_news
19.-- ----------------------------
20.DROP TABLE IF EXISTS `cms_news`;
21.CREATE TABLE `cms_news` (
22. `date` date NOT NULL DEFAULT '0000-00-00',
23. `title` text,
24. `poster` text,
25. `news` text,
26. PRIMARY KEY (`date`)
27.) ENGINE=InnoDB DEFAULT CHARSET=latin1;
28.
29.-- ----------------------------
30.-- Table structure for global_chat
31.-- ----------------------------
32.DROP TABLE IF EXISTS `global_chat`;
33.CREATE TABLE `global_chat` (
34. `user_name` text,
35. `message` text,
36. `server_id` int(1) NOT NULL DEFAULT '0',
37. PRIMARY KEY (`server_id`)
38.) ENGINE=InnoDB DEFAULT CHARSET=latin1;
39.
40.-- ----------------------------
41.-- Table structure for rp_auth
42.-- ----------------------------
43.DROP TABLE IF EXISTS `rp_auth`;
44.CREATE TABLE `rp_auth` (
45. `server` int(11) DEFAULT NULL,
46. `steamid` text NOT NULL,
47. PRIMARY KEY (`steamid`(40))
48.) ENGINE=InnoDB DEFAULT CHARSET=latin1;
49.
50.-- ----------------------------
51.-- Table structure for rp_items
52.-- ----------------------------
53.DROP TABLE IF EXISTS `rp_items`;
54.CREATE TABLE `rp_items` (
55. `steamid` text,
56. `item_id` text,
57. `item_quantity` int(11) DEFAULT '0'
58.) ENGINE=InnoDB DEFAULT CHARSET=latin1;
59.
60.-- ----------------------------
61.-- Table structure for rp_lottery
62.-- ----------------------------
63.DROP TABLE IF EXISTS `rp_lottery`;
64.CREATE TABLE `rp_lottery` (
65. `steamid` text,
66. `claimed` int(1) NOT NULL DEFAULT '0',
67. PRIMARY KEY (`claimed`)
68.) ENGINE=InnoDB DEFAULT CHARSET=latin1;
69.
70.-- ----------------------------
71.-- Table structure for rp_org
72.-- ----------------------------
73.DROP TABLE IF EXISTS `rp_org`;
74.CREATE TABLE `rp_org` (
75. `id` int(11) NOT NULL AUTO_INCREMENT,
76. `owner_steamid` text,
77. `motd` text,
78. `name` text,
79. PRIMARY KEY (`id`)
80.) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;
81.
82.-- ----------------------------
83.-- Table structure for rp_system
84.-- ----------------------------
85.DROP TABLE IF EXISTS `rp_system`;
86.CREATE TABLE `rp_system` (
87. `redownload_inventory` int(200) NOT NULL DEFAULT '0',
88. `cash_flow` text,
89. PRIMARY KEY (`redownload_inventory`)
90.) ENGINE=InnoDB DEFAULT CHARSET=latin1;
91.
92.-- ----------------------------
93.-- Table structure for rp_users
94.-- ----------------------------
95.DROP TABLE IF EXISTS `rp_users`;
96.CREATE TABLE `rp_users` (
97. `steamid` text NOT NULL,
98. `name` text,
99. `money` int(255) DEFAULT '10000',
100. `org` text,
101. `blacklist` text,
102. `model` text,
103. `vehicles` text,
104. `vehicle_skins` text,
105. `time_played` text,
106. `free_points` int(3) DEFAULT '6',
107. `fat` text,
108. `skill_dexterity` text,
109. `skill_stamina` text,
110. `skill_intelligence` text,
111. `skill_strength` text,
112. `skill_craftiness` text,
113. `ammo_pistol` text,
114. `ammo_rifle` text,
115. `ammo_shotgun` text,
116. `bbcu` text,
117. `rank` int(11) DEFAULT '5',
118. PRIMARY KEY (`steamid`(40))
119.) ENGINE=InnoDB DEFAULT CHARSET=latin1;
120.
121.-- ----------------------------
122.-- Table structure for site_blacklist
123.-- ----------------------------
124.DROP TABLE IF EXISTS `site_blacklist`;
125.CREATE TABLE `site_blacklist` (
126. `IP` text,
127. `Why` text
128.) ENGINE=InnoDB DEFAULT CHARSET=latin1;
129.
130.-- ----------------------------
131.-- Records
132.-- ----------------------------
133.----------------------------------------------VUAL-----------------------------------------------
What is Fackstah ?
I used to work for acclaim games on 2moons then i opened fussion-networks.com we had over 28 thousand players on our dekaron servers in its prime i create Games in Unity on my spare time
http://fussion-networks.com/desolate/
I used to work for acclaim games on 2moons then i opened fussion-networks.com we had over 28 thousand players on our dekaron servers in its prime i create Games in Unity on my spare time
http://fussion-networks.com/desolate/