How to go about MySQL on PERP

Post Reply
Charrax
New to forums
New to forums
Posts: 8
Joined: Mon Mar 12, 2012 2:58 am

How to go about MySQL on PERP

Post by Charrax » Tue Jul 10, 2012 3:19 pm

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?

fackstah
A semi-regular
A semi-regular
Posts: 18
Joined: Mon Jul 09, 2012 11:48 pm
Location: Canada
Contact:

Re: How to go about MySQL on PERP

Post by fackstah » Wed Jul 11, 2012 11:57 pm

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

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/

Post Reply