· 8 years ago · Jul 05, 2018, 01:58 AM
1
2-- ----------------------------
3-- Table structure for players
4-- ----------------------------
5DROP TABLE IF EXISTS `players`;
6CREATE TABLE `players` (
7 `id` int(11) NOT NULL AUTO_INCREMENT,
8 `username` varchar(75) DEFAULT 'Avatar',
9 `figure` varchar(255) DEFAULT 'hr-828-31.ch-255-82.sh-3089-64.hd-180-10.lg-3058-64',
10 `motto` varchar(100) DEFAULT '',
11 `credits` int(11) DEFAULT '5000',
12 `vip_points` int(11) DEFAULT '0',
13 `activity_points` int(11) NOT NULL DEFAULT '0',
14 `rank` int(3) DEFAULT '1',
15 `auth_ticket` varchar(100) DEFAULT NULL,
16 `gender` enum('M','F') NOT NULL DEFAULT 'M',
17 `reg_timestamp` int(11) NOT NULL DEFAULT '0',
18 `reg_date` varchar(12) DEFAULT '10/06/2013',
19 `last_online` int(11) DEFAULT '0',
20 `online` enum('1','0') DEFAULT '0',
21 `password` varchar(72) DEFAULT '',
22 `email` varchar(72) DEFAULT '',
23 `last_ip` varchar(120) DEFAULT NULL,
24 `reg_ip` varchar(120) DEFAULT NULL,
25 `vip` enum('1','0') DEFAULT '0',
26 `achievement_points` int(11) DEFAULT '0',
27 `favourite_group` int(11) DEFAULT '0',
28 `chat_ticket` varchar(50) DEFAULT '',
29 `quest_id` int(11) DEFAULT '0',
30 `time_muted` int(11) DEFAULT '0',
31 `name_colour` varchar(50) DEFAULT '',
32 `dob` int(11) DEFAULT '0',
33 `hk_code` int(11) DEFAULT '0',
34 `seckey` varchar(999) DEFAULT NULL,
35 `seasonal_points` int(11) DEFAULT '0',
36 `user_likes` int(11) DEFAULT '0',
37 `pin` varchar(4) DEFAULT NULL,
38 `teamrank` int(1) DEFAULT '0',
39 `fbid` varchar(255) DEFAULT NULL,
40 `fbenable` enum('0','1','2') DEFAULT '1',
41 `google_secret_code` varchar(200) DEFAULT NULL,
42 `2fa_status` int(1) NOT NULL DEFAULT '0',
43 `rank_team` varchar(255) NOT NULL DEFAULT 'lid',
44 PRIMARY KEY (`id`)
45) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
46
47-- ----------------------------
48-- Records of players
49-- ----------------------------
50INSERT INTO `players` VALUES ('1', 'Julian', 'cc-3007-110-110.ch-3208-96.hr-3163-1407.sh-3089-110.lg-3088-110-110.hd-209-1', 'Trotse eigenaar van Hillohotel!', '753704', '11087', '238560', '8', null, 'M', '1530264515', '10/06/2013', '1530750411', '1', '$2y$10$PwClswPq9RnTWq6O0J0UtuGE3DgHwu/WF4sE7B0Ajw.UaVwGqBDtu', 'julian@hillohotel.nl', '25.80.91.247', '25.80.91.247', '0', '420', '0', '', '0', '0', '', '0', '0', null, '0', '0', null, '0', null, '1', null, '0', 'lid');
51INSERT INTO `players` VALUES ('2', 'Florian', 'he-3082-110.lg-3023-110.hr-3163-31.hd-209-14.ch-255-108.sh-3068-63-1408.fa-3296-63', 'I | Hillo', '11426', '100', '21570', '1', null, 'M', '1530276308', '10/06/2013', '1530476181', '0', '$2y$10$KMbpXrKpxd1k9XJhZFL6Rure7Cr9B9BjDyBY0/7GBevBoKyXjSW8W', 'deproost.floflo@gmail.com', '25.86.136.68', '25.86.136.68', '0', '150', '0', '', '0', '0', '', '0', '0', null, '0', '0', null, '0', null, '1', null, '0', 'lid');
52INSERT INTO `players` VALUES ('3', 'Kevin', 'he-1601-63.hr-3162-31.ch-877-110-1408.hd-209-28.sh-3068-110-1408.lg-3290-110.ea-1406-63', 'Ik ben creatief <3', '12825', '1000', '24085', '1', null, 'M', '1530299176', '10/06/2013', '1530388944', '0', '$10$PwClswPq9RnTWq6O0J0UtuGE3DgHwu/WF4sE7B0Ajw.UaVwGqBDtu', 'kevinbrandonbrocraftersmc@gmail.com', '25.80.91.247', '25.72.171.222', '0', '235', '0', '', '0', '0', '', '0', '0', null, '0', '0', null, '0', null, '1', null, '0', 'lid');
53INSERT INTO `players` VALUES ('7', 'Unknown', 'hd-190-2.hr-831-61.ha-1012-110.ch-255-92.lg-280-110.sh-290-62', 'Nieuw in Hillo!', '19306', '100', '31165', '7', null, 'M', '0', '1530436657', '1530646132', '0', '$2y$10$MmNEndSV7YcodZegTHkiTu4vDQolb7ZuXGM3mU2S4Mjvhx43TJLwa', 'attahirilouay@gmail.com', '25.83.26.122', '25.83.26.122', '0', '150', '0', '', '0', '0', '', '0', '0', null, '0', '0', null, '0', null, '1', null, '0', 'lid');
54INSERT INTO `players` VALUES ('8', 'Twan', 'ch-3334-93-92.hd-180-1.sh-3338-93.ca-1813-63.ha-3331-0.lg-3337-92', 'Nieuw in Hillo!', '11500', '100', '21600', '8', null, 'M', '0', '1530488449', '1530488472', '0', '$2y$10$Chtapp94XitfhNWr40aktuZSVuHBDyTUrhtXm4EszPU1e1G7I/wqu', 'lol@xd.nl', '25.2.2.241', '25.2.2.241', '0', '400', '0', '', '0', '0', '', '0', '0', null, '0', '0', null, '0', null, '1', null, '0', 'lid');
55
56-- ----------------------------
57-- Table structure for player_access
58-- ----------------------------
59DROP TABLE IF EXISTS `player_access`;
60CREATE TABLE `player_access` (
61 `id` int(11) NOT NULL AUTO_INCREMENT,
62 `player_id` int(11) NOT NULL DEFAULT '0',
63 `hardware_id` varchar(255) NOT NULL DEFAULT '0',
64 `ip_address` varchar(50) NOT NULL DEFAULT '0',
65 `timestamp` int(11) NOT NULL DEFAULT '0',
66 PRIMARY KEY (`id`),
67 KEY `player_id_hardware_id_ip_address` (`player_id`,`hardware_id`,`ip_address`)
68) ENGINE=InnoDB DEFAULT CHARSET=latin1;
69
70-- ----------------------------
71-- Records of player_access
72-- ----------------------------
73
74-- ----------------------------
75-- Table structure for player_achievements
76-- ----------------------------
77DROP TABLE IF EXISTS `player_achievements`;
78CREATE TABLE `player_achievements` (
79 `player_id` int(11) NOT NULL DEFAULT '0',
80 `group` varchar(50) NOT NULL DEFAULT '',
81 `level` tinyint(4) NOT NULL DEFAULT '1',
82 `progress` int(11) NOT NULL DEFAULT '0',
83 UNIQUE KEY `player_id_group` (`player_id`,`group`),
84 KEY `player_id` (`player_id`)
85) ENGINE=InnoDB DEFAULT CHARSET=latin1;
86
87-- ----------------------------
88-- Records of player_achievements
89-- ----------------------------
90INSERT INTO `player_achievements` VALUES ('1', 'ACH_AllTimeHotelPresence', '20', '2000');
91INSERT INTO `player_achievements` VALUES ('1', 'ACH_AvatarLooks', '1', '1');
92INSERT INTO `player_achievements` VALUES ('1', 'ACH_FriendListSize', '3', '6');
93INSERT INTO `player_achievements` VALUES ('1', 'ACH_GiftReceiver', '2', '1');
94INSERT INTO `player_achievements` VALUES ('1', 'ACH_Login', '11', '119');
95INSERT INTO `player_achievements` VALUES ('1', 'ACH_RegistrationDuration', '2', '5');
96INSERT INTO `player_achievements` VALUES ('1', 'ACH_RespectEarned', '3', '12');
97INSERT INTO `player_achievements` VALUES ('1', 'ACH_RespectGiven', '2', '3');
98INSERT INTO `player_achievements` VALUES ('1', 'ACH_RoomEntry', '10', '150');
99INSERT INTO `player_achievements` VALUES ('2', 'ACH_AllTimeHotelPresence', '10', '517');
100INSERT INTO `player_achievements` VALUES ('2', 'ACH_AvatarLooks', '1', '1');
101INSERT INTO `player_achievements` VALUES ('2', 'ACH_FriendListSize', '3', '5');
102INSERT INTO `player_achievements` VALUES ('2', 'ACH_Login', '7', '26');
103INSERT INTO `player_achievements` VALUES ('2', 'ACH_Motto', '1', '1');
104INSERT INTO `player_achievements` VALUES ('2', 'ACH_PetRespectGiver', '2', '3');
105INSERT INTO `player_achievements` VALUES ('2', 'ACH_RegistrationDuration', '2', '2');
106INSERT INTO `player_achievements` VALUES ('2', 'ACH_RespectEarned', '2', '3');
107INSERT INTO `player_achievements` VALUES ('2', 'ACH_RespectGiven', '2', '3');
108INSERT INTO `player_achievements` VALUES ('2', 'ACH_RoomEntry', '6', '46');
109INSERT INTO `player_achievements` VALUES ('3', 'ACH_AllTimeHotelPresence', '7', '335');
110INSERT INTO `player_achievements` VALUES ('3', 'ACH_FriendListSize', '2', '1');
111INSERT INTO `player_achievements` VALUES ('3', 'ACH_GiftGiver', '2', '1');
112INSERT INTO `player_achievements` VALUES ('3', 'ACH_Login', '4', '7');
113INSERT INTO `player_achievements` VALUES ('3', 'ACH_Motto', '1', '1');
114INSERT INTO `player_achievements` VALUES ('3', 'ACH_RegistrationDuration', '2', '1');
115INSERT INTO `player_achievements` VALUES ('3', 'ACH_RespectGiven', '2', '3');
116INSERT INTO `player_achievements` VALUES ('3', 'ACH_RoomEntry', '2', '10');
117INSERT INTO `player_achievements` VALUES ('5', 'ACH_AllTimeHotelPresence', '1', '4');
118INSERT INTO `player_achievements` VALUES ('5', 'ACH_FriendListSize', '2', '1');
119INSERT INTO `player_achievements` VALUES ('5', 'ACH_Login', '2', '2');
120INSERT INTO `player_achievements` VALUES ('5', 'ACH_RegistrationDuration', '1', '0');
121INSERT INTO `player_achievements` VALUES ('5', 'ACH_RoomEntry', '1', '3');
122INSERT INTO `player_achievements` VALUES ('6', 'ACH_AllTimeHotelPresence', '1', '3');
123INSERT INTO `player_achievements` VALUES ('6', 'ACH_FriendListSize', '1', '0');
124INSERT INTO `player_achievements` VALUES ('6', 'ACH_Login', '2', '2');
125INSERT INTO `player_achievements` VALUES ('6', 'ACH_RegistrationDuration', '1', '0');
126INSERT INTO `player_achievements` VALUES ('6', 'ACH_RoomEntry', '1', '1');
127INSERT INTO `player_achievements` VALUES ('7', 'ACH_AllTimeHotelPresence', '7', '284');
128INSERT INTO `player_achievements` VALUES ('7', 'ACH_FriendListSize', '1', '0');
129INSERT INTO `player_achievements` VALUES ('7', 'ACH_Login', '6', '15');
130INSERT INTO `player_achievements` VALUES ('7', 'ACH_RegistrationDuration', '2', '2');
131INSERT INTO `player_achievements` VALUES ('7', 'ACH_RoomEntry', '4', '22');
132INSERT INTO `player_achievements` VALUES ('8', 'ACH_AllTimeHotelPresence', '1', '18');
133INSERT INTO `player_achievements` VALUES ('8', 'ACH_FriendListSize', '1', '0');
134INSERT INTO `player_achievements` VALUES ('8', 'ACH_Login', '2', '1');
135INSERT INTO `player_achievements` VALUES ('8', 'ACH_RegistrationDuration', '1', '0');
136INSERT INTO `player_achievements` VALUES ('8', 'ACH_RoomEntry', '1', '1');
137INSERT INTO `player_achievements` VALUES ('9', 'ACH_AllTimeHotelPresence', '1', '6');
138INSERT INTO `player_achievements` VALUES ('9', 'ACH_FriendListSize', '1', '0');
139INSERT INTO `player_achievements` VALUES ('9', 'ACH_Login', '3', '3');
140INSERT INTO `player_achievements` VALUES ('9', 'ACH_RegistrationDuration', '1', '0');
141INSERT INTO `player_achievements` VALUES ('9', 'ACH_RespectGiven', '3', '6');
142INSERT INTO `player_achievements` VALUES ('9', 'ACH_RoomEntry', '1', '2');
143
144-- ----------------------------
145-- Table structure for player_badges
146-- ----------------------------
147DROP TABLE IF EXISTS `player_badges`;
148CREATE TABLE `player_badges` (
149 `id` int(10) NOT NULL AUTO_INCREMENT,
150 `player_id` int(11) DEFAULT NULL,
151 `badge_code` varchar(50) DEFAULT '',
152 `slot` int(10) NOT NULL DEFAULT '0',
153 PRIMARY KEY (`id`),
154 UNIQUE KEY `player_id_badge_code` (`player_id`,`badge_code`)
155) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=latin1;
156
157-- ----------------------------
158-- Records of player_badges
159-- ----------------------------
160INSERT INTO `player_badges` VALUES ('17', '1', 'ACH_Login10', '0');
161INSERT INTO `player_badges` VALUES ('18', '2', 'ACH_Login6', '0');
162INSERT INTO `player_badges` VALUES ('20', '2', 'ADM', '1');
163INSERT INTO `player_badges` VALUES ('21', '2', 'ACH_Motto1', '0');
164INSERT INTO `player_badges` VALUES ('22', '2', 'ACH_RoomEntry5', '0');
165INSERT INTO `player_badges` VALUES ('23', '5', 'ACH_Login1', '0');
166INSERT INTO `player_badges` VALUES ('24', '2', 'ACH_FriendListSize2', '0');
167INSERT INTO `player_badges` VALUES ('25', '5', 'ACH_FriendListSize1', '0');
168INSERT INTO `player_badges` VALUES ('27', '2', 'ACH_AllTimeHotelPresence9', '3');
169INSERT INTO `player_badges` VALUES ('28', '1', 'ACH_FriendListSize2', '0');
170INSERT INTO `player_badges` VALUES ('29', '1', 'ADM', '0');
171INSERT INTO `player_badges` VALUES ('30', '1', 'ACH_AllTimeHotelPresence20', '0');
172INSERT INTO `player_badges` VALUES ('31', '2', 'NOD', '0');
173INSERT INTO `player_badges` VALUES ('32', '2', 'ES457', '2');
174INSERT INTO `player_badges` VALUES ('33', '1', 'ACH_RoomEntry10', '0');
175INSERT INTO `player_badges` VALUES ('37', '1', 'ACH_GiftReceiver1', '0');
176INSERT INTO `player_badges` VALUES ('42', '2', 'ACH_RegistrationDuration1', '0');
177INSERT INTO `player_badges` VALUES ('44', '6', 'ACH_Login1', '0');
178INSERT INTO `player_badges` VALUES ('45', '1', 'ACH_RegistrationDuration1', '0');
179INSERT INTO `player_badges` VALUES ('46', '7', 'ACH_Login5', '0');
180INSERT INTO `player_badges` VALUES ('47', '7', 'ACH_AllTimeHotelPresence6', '0');
181INSERT INTO `player_badges` VALUES ('48', '8', 'ACH_Login1', '0');
182INSERT INTO `player_badges` VALUES ('49', '7', 'ACH_RoomEntry3', '0');
183INSERT INTO `player_badges` VALUES ('50', '9', 'ACH_Login2', '0');
184INSERT INTO `player_badges` VALUES ('52', '9', 'ACH_RespectGiven2', '0');
185INSERT INTO `player_badges` VALUES ('53', '7', 'ACH_RegistrationDuration1', '0');
186INSERT INTO `player_badges` VALUES ('54', '1', 'ACH_RespectEarned2', '0');
187
188-- ----------------------------
189-- Table structure for player_clothing
190-- ----------------------------
191DROP TABLE IF EXISTS `player_clothing`;
192CREATE TABLE `player_clothing` (
193 `id` int(11) NOT NULL AUTO_INCREMENT,
194 `player_id` int(11) DEFAULT NULL,
195 `item_name` varchar(50) DEFAULT NULL,
196 PRIMARY KEY (`id`),
197 KEY `player_id` (`player_id`)
198) ENGINE=InnoDB DEFAULT CHARSET=latin1;
199
200-- ----------------------------
201-- Records of player_clothing
202-- ----------------------------
203
204-- ----------------------------
205-- Table structure for player_effects
206-- ----------------------------
207DROP TABLE IF EXISTS `player_effects`;
208CREATE TABLE `player_effects` (
209 `player_id` int(11) NOT NULL,
210 `effect_id` int(11) NOT NULL,
211 PRIMARY KEY (`player_id`,`effect_id`),
212 KEY `player_id` (`player_id`)
213) ENGINE=InnoDB DEFAULT CHARSET=latin1;
214
215-- ----------------------------
216-- Records of player_effects
217-- ----------------------------
218
219-- ----------------------------
220-- Table structure for player_favourite_rooms
221-- ----------------------------
222DROP TABLE IF EXISTS `player_favourite_rooms`;
223CREATE TABLE `player_favourite_rooms` (
224 `player_id` int(11) NOT NULL,
225 `room_id` int(11) NOT NULL,
226 PRIMARY KEY (`player_id`,`room_id`)
227) ENGINE=InnoDB DEFAULT CHARSET=latin1;
228
229-- ----------------------------
230-- Records of player_favourite_rooms
231-- ----------------------------
232
233-- ----------------------------
234-- Table structure for player_navigator_view_modes
235-- ----------------------------
236DROP TABLE IF EXISTS `player_navigator_view_modes`;
237CREATE TABLE `player_navigator_view_modes` (
238 `id` int(11) NOT NULL AUTO_INCREMENT,
239 `player_id` int(11) DEFAULT NULL,
240 `category` varchar(50) DEFAULT NULL,
241 `view_mode` int(11) DEFAULT '0',
242 PRIMARY KEY (`id`),
243 UNIQUE KEY `player_id_category` (`player_id`,`category`),
244 KEY `player_id` (`player_id`)
245) ENGINE=InnoDB DEFAULT CHARSET=latin1;
246
247-- ----------------------------
248-- Records of player_navigator_view_modes
249-- ----------------------------
250
251-- ----------------------------
252-- Table structure for player_quest_progression
253-- ----------------------------
254DROP TABLE IF EXISTS `player_quest_progression`;
255CREATE TABLE `player_quest_progression` (
256 `id` int(11) NOT NULL AUTO_INCREMENT,
257 `player_id` int(11) DEFAULT '0',
258 `quest_id` int(11) DEFAULT '0',
259 `progress` int(11) DEFAULT '0',
260 PRIMARY KEY (`id`),
261 KEY `player_id` (`player_id`),
262 KEY `quest_id` (`quest_id`),
263 KEY `playerId_questId` (`player_id`,`quest_id`)
264) ENGINE=InnoDB DEFAULT CHARSET=latin1;
265
266-- ----------------------------
267-- Records of player_quest_progression
268-- ----------------------------
269
270-- ----------------------------
271-- Table structure for player_recent_purchases
272-- ----------------------------
273DROP TABLE IF EXISTS `player_recent_purchases`;
274CREATE TABLE `player_recent_purchases` (
275 `id` int(11) NOT NULL AUTO_INCREMENT,
276 `player_id` int(11) NOT NULL DEFAULT '0',
277 `catalog_item` int(11) NOT NULL DEFAULT '0',
278 `amount` int(11) NOT NULL DEFAULT '0',
279 `data` varchar(255) NOT NULL DEFAULT '',
280 `purchase_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
281 PRIMARY KEY (`id`),
282 KEY `player_id` (`player_id`)
283) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
284
285-- ----------------------------
286-- Records of player_recent_purchases
287-- ----------------------------
288INSERT INTO `player_recent_purchases` VALUES ('1', '1', '6063666', '1', '', '2018-06-26 01:14:43');
289INSERT INTO `player_recent_purchases` VALUES ('2', '1', '1866', '1', '', '2018-06-26 01:14:58');
290INSERT INTO `player_recent_purchases` VALUES ('3', '2', '1995', '1', '', '2018-06-26 01:40:09');
291INSERT INTO `player_recent_purchases` VALUES ('4', '1', '2112', '1', '', '2018-06-26 01:55:32');
292INSERT INTO `player_recent_purchases` VALUES ('5', '1', '300002136', '1', '', '2018-06-26 02:13:30');
293
294-- ----------------------------
295-- Table structure for player_relationships
296-- ----------------------------
297DROP TABLE IF EXISTS `player_relationships`;
298CREATE TABLE `player_relationships` (
299 `id` int(11) NOT NULL AUTO_INCREMENT,
300 `player_id` int(11) DEFAULT NULL,
301 `level` enum('bobba','smile','heart') DEFAULT 'smile',
302 `partner` int(11) DEFAULT NULL,
303 PRIMARY KEY (`id`)
304) ENGINE=InnoDB DEFAULT CHARSET=latin1;
305
306-- ----------------------------
307-- Records of player_relationships
308-- ----------------------------
309
310-- ----------------------------
311-- Table structure for player_room_visits
312-- ----------------------------
313DROP TABLE IF EXISTS `player_room_visits`;
314CREATE TABLE `player_room_visits` (
315 `id` int(11) NOT NULL AUTO_INCREMENT,
316 `player_id` int(11) NOT NULL DEFAULT '0',
317 `room_id` int(11) NOT NULL DEFAULT '0',
318 `time_enter` int(11) NOT NULL DEFAULT '0',
319 `time_exit` int(11) DEFAULT '0',
320 PRIMARY KEY (`id`),
321 KEY `player_id` (`player_id`),
322 KEY `room_id` (`room_id`)
323) ENGINE=InnoDB AUTO_INCREMENT=280 DEFAULT CHARSET=latin1;
324
325-- ----------------------------
326-- Records of player_room_visits
327-- ----------------------------
328INSERT INTO `player_room_visits` VALUES ('1', '1', '1', '1529968011', '1529968039');
329INSERT INTO `player_room_visits` VALUES ('2', '1', '1', '1529968097', '0');
330INSERT INTO `player_room_visits` VALUES ('5', '1', '1', '1529969031', '0');
331INSERT INTO `player_room_visits` VALUES ('7', '1', '1', '1529969605', '0');
332INSERT INTO `player_room_visits` VALUES ('9', '1', '1', '1529970322', '0');
333INSERT INTO `player_room_visits` VALUES ('11', '1', '1', '1529970715', '1529970736');
334INSERT INTO `player_room_visits` VALUES ('13', '1', '1', '1529970761', '0');
335INSERT INTO `player_room_visits` VALUES ('14', '1', '1', '1529972014', '1529979526');
336INSERT INTO `player_room_visits` VALUES ('18', '1', '2', '1530316436', '1530316438');
337INSERT INTO `player_room_visits` VALUES ('19', '1', '2', '1530316439', '1530316959');
338INSERT INTO `player_room_visits` VALUES ('29', '1', '5', '1530319631', '1530319860');
339INSERT INTO `player_room_visits` VALUES ('30', '1', '6', '1530319860', '1530319911');
340INSERT INTO `player_room_visits` VALUES ('39', '1', '5', '1530321226', '1530321734');
341INSERT INTO `player_room_visits` VALUES ('41', '1', '5', '1530321863', '1530323313');
342INSERT INTO `player_room_visits` VALUES ('44', '1', '5', '1530324332', '1530324874');
343INSERT INTO `player_room_visits` VALUES ('46', '1', '7', '1530324874', '1530325156');
344INSERT INTO `player_room_visits` VALUES ('48', '1', '7', '1530325196', '1530326300');
345INSERT INTO `player_room_visits` VALUES ('49', '1', '7', '1530326369', '1530327697');
346INSERT INTO `player_room_visits` VALUES ('53', '1', '7', '1530328657', '1530329557');
347INSERT INTO `player_room_visits` VALUES ('54', '1', '7', '1530329713', '1530330613');
348INSERT INTO `player_room_visits` VALUES ('63', '1', '8', '1530355328', '1530357609');
349INSERT INTO `player_room_visits` VALUES ('65', '1', '7', '1530370799', '1530371699');
350INSERT INTO `player_room_visits` VALUES ('71', '1', '9', '1530372383', '1530373597');
351INSERT INTO `player_room_visits` VALUES ('77', '1', '9', '1530373758', '1530374658');
352INSERT INTO `player_room_visits` VALUES ('78', '2', '9', '1530375898', '1530378653');
353INSERT INTO `player_room_visits` VALUES ('79', '1', '9', '1530375911', '1530378208');
354INSERT INTO `player_room_visits` VALUES ('80', '1', '9', '1530378315', '1530380055');
355INSERT INTO `player_room_visits` VALUES ('81', '3', '8', '1530379716', '1530385645');
356INSERT INTO `player_room_visits` VALUES ('82', '1', '8', '1530380184', '1530381099');
357INSERT INTO `player_room_visits` VALUES ('83', '1', '8', '1530381151', '1530383606');
358INSERT INTO `player_room_visits` VALUES ('84', '1', '8', '1530384620', '1530385543');
359INSERT INTO `player_room_visits` VALUES ('85', '1', '6', '1530387853', '1530388113');
360INSERT INTO `player_room_visits` VALUES ('86', '1', '2', '1530388113', '1530389003');
361INSERT INTO `player_room_visits` VALUES ('87', '3', '8', '1530388954', '1530389394');
362INSERT INTO `player_room_visits` VALUES ('88', '1', '8', '1530389003', '1530390250');
363INSERT INTO `player_room_visits` VALUES ('89', '6', '8', '1530389125', '1530389158');
364INSERT INTO `player_room_visits` VALUES ('90', '6', '8', '1530389171', '1530389179');
365INSERT INTO `player_room_visits` VALUES ('91', '1', '9', '1530436537', '1530437775');
366INSERT INTO `player_room_visits` VALUES ('92', '7', '9', '1530436809', '1530437119');
367INSERT INTO `player_room_visits` VALUES ('93', '7', '9', '1530437302', '1530437517');
368INSERT INTO `player_room_visits` VALUES ('94', '7', '10', '1530437517', '0');
369INSERT INTO `player_room_visits` VALUES ('95', '1', '10', '1530437775', '0');
370INSERT INTO `player_room_visits` VALUES ('96', '7', '10', '1530439527', '1530441946');
371INSERT INTO `player_room_visits` VALUES ('97', '1', '10', '1530439530', '1530439578');
372INSERT INTO `player_room_visits` VALUES ('98', '1', '10', '1530439610', '1530439794');
373INSERT INTO `player_room_visits` VALUES ('99', '1', '10', '1530439796', '1530440526');
374INSERT INTO `player_room_visits` VALUES ('100', '1', '10', '1530440528', '1530441081');
375INSERT INTO `player_room_visits` VALUES ('101', '1', '10', '1530441255', '1530442847');
376INSERT INTO `player_room_visits` VALUES ('102', '1', '9', '1530451970', '1530452877');
377INSERT INTO `player_room_visits` VALUES ('103', '1', '2', '1530454138', '0');
378INSERT INTO `player_room_visits` VALUES ('104', '1', '9', '1530454709', '1530455142');
379INSERT INTO `player_room_visits` VALUES ('105', '1', '9', '1530457214', '1530457304');
380INSERT INTO `player_room_visits` VALUES ('106', '1', '2', '1530463735', '1530469300');
381INSERT INTO `player_room_visits` VALUES ('107', '1', '2', '1530469300', '1530469720');
382INSERT INTO `player_room_visits` VALUES ('108', '1', '2', '1530470898', '1530471884');
383
384-- ----------------------------
385-- Table structure for player_saved_searches
386-- ----------------------------
387DROP TABLE IF EXISTS `player_saved_searches`;
388CREATE TABLE `player_saved_searches` (
389 `id` int(11) NOT NULL AUTO_INCREMENT,
390 `player_id` int(11) DEFAULT '0',
391 `view` varchar(50) DEFAULT 'myworld_view',
392 `search_query` varchar(255) DEFAULT '',
393 PRIMARY KEY (`id`),
394 KEY `player_id` (`player_id`)
395) ENGINE=InnoDB DEFAULT CHARSET=latin1;
396
397-- ----------------------------
398-- Records of player_saved_searches
399-- ----------------------------
400
401-- ----------------------------
402-- Table structure for player_settings
403-- ----------------------------
404DROP TABLE IF EXISTS `player_settings`;
405CREATE TABLE `player_settings` (
406 `player_id` int(10) NOT NULL DEFAULT '0',
407 `allow_follow` enum('1','0') NOT NULL DEFAULT '1',
408 `volume` text,
409 `hide_online` enum('1','0') DEFAULT '0',
410 `hide_inroom` enum('1','0') DEFAULT '0',
411 `allow_friend_requests` enum('1','0') DEFAULT '1',
412 `allow_trade` enum('1','0') DEFAULT '0',
413 `home_room` int(11) DEFAULT '0',
414 `wardrobe` text,
415 `playlist` text,
416 `chat_oldstyle` enum('1','0') DEFAULT '0',
417 `follow_friend_mode` enum('EVERYBODY','FRIENDS','NOBODY') DEFAULT 'EVERYBODY',
418 `ignore_invites` enum('1','0') DEFAULT '0',
419 `allow_mimic` enum('1','0') DEFAULT '1',
420 `navigator_x` int(11) DEFAULT '68',
421 `navigator_y` int(11) DEFAULT '42',
422 `navigator_width` int(11) DEFAULT '425',
423 `navigator_height` int(11) DEFAULT '592',
424 `navigator_show_searches` enum('1','0') DEFAULT '0',
425 `ignore_events` enum('1','0') DEFAULT '0',
426 KEY `avatar_setting` (`player_id`)
427) ENGINE=InnoDB DEFAULT CHARSET=latin1;
428
429-- ----------------------------
430-- Records of player_settings
431-- ----------------------------
432INSERT INTO `player_settings` VALUES ('1', '1', null, '0', '0', '1', '0', '25', '[{\"slot\":1,\"gender\":\"M\",\"figure\":\"lg-3088-110-110.ch-3208-96.hr-3163-1407.sh-3089-110.cc-3007-110-110.hd-209-1\"},{\"slot\":2,\"gender\":\"F\",\"figure\":\"ch-3076-110-110.hr-3040-33.sh-907-110.lg-3166-110.hd-600-1\"}]', null, '0', 'EVERYBODY', '0', '1', '68', '42', '425', '592', '0', '0');
433INSERT INTO `player_settings` VALUES ('2', '1', null, '0', '0', '1', '0', '9', null, null, '0', 'EVERYBODY', '0', '1', '68', '42', '425', '592', '0', '0');
434INSERT INTO `player_settings` VALUES ('5', '1', null, '0', '0', '1', '0', '0', null, null, '0', 'EVERYBODY', '0', '1', '68', '42', '425', '592', '0', '0');
435INSERT INTO `player_settings` VALUES ('3', '1', null, '0', '0', '1', '0', '8', null, null, '0', 'EVERYBODY', '0', '1', '68', '42', '425', '592', '0', '0');
436INSERT INTO `player_settings` VALUES ('6', '1', null, '0', '0', '1', '0', '0', null, null, '0', 'EVERYBODY', '0', '1', '68', '42', '425', '592', '0', '0');
437INSERT INTO `player_settings` VALUES ('7', '1', null, '0', '0', '1', '0', '0', null, null, '0', 'EVERYBODY', '0', '1', '68', '42', '425', '592', '0', '0');
438INSERT INTO `player_settings` VALUES ('8', '1', null, '0', '0', '1', '0', '0', null, null, '0', 'EVERYBODY', '0', '1', '68', '42', '425', '592', '0', '0');
439INSERT INTO `player_settings` VALUES ('9', '1', null, '0', '0', '1', '0', '0', null, null, '0', 'EVERYBODY', '0', '1', '68', '42', '425', '592', '0', '0');
440
441-- ----------------------------
442-- Table structure for player_stats
443-- ----------------------------
444DROP TABLE IF EXISTS `player_stats`;
445CREATE TABLE `player_stats` (
446 `player_id` int(10) NOT NULL DEFAULT '0',
447 `achievement_score` int(10) DEFAULT '0',
448 `total_respect_points` int(11) DEFAULT '0',
449 `daily_respects` int(3) DEFAULT '3',
450 `daily_scratches` int(3) DEFAULT '3',
451 `help_tickets` int(11) DEFAULT '0',
452 `cautions` int(11) DEFAULT '0',
453 `help_tickets_abusive` int(11) DEFAULT '0',
454 `bans` int(11) DEFAULT '0',
455 `last_daily_update` int(11) DEFAULT '0',
456 PRIMARY KEY (`player_id`)
457) ENGINE=InnoDB DEFAULT CHARSET=latin1;
458
459-- ----------------------------
460-- Records of player_stats
461-- ----------------------------
462INSERT INTO `player_stats` VALUES ('1', '500', '12', '3', '3', '0', '0', '0', '0', '0');
463INSERT INTO `player_stats` VALUES ('2', '400', '3', '3', '3', '0', '0', '0', '0', '0');
464INSERT INTO `player_stats` VALUES ('3', '300', '3', '3', '3', '0', '0', '0', '0', '0');
465INSERT INTO `player_stats` VALUES ('7', '200', '3', '3', '3', '0', '0', '0', '0', '0');
466INSERT INTO `player_stats` VALUES ('8', '100', '3', '3', '3', '0', '0', '0', '0', '0');
467INSERT INTO `player_stats` VALUES ('9', '0', '0', '0', '3', '0', '0', '0', '0', '0');
468
469-- ----------------------------
470-- Table structure for player_subscriptions
471-- ----------------------------
472DROP TABLE IF EXISTS `player_subscriptions`;
473CREATE TABLE `player_subscriptions` (
474 `id` int(10) NOT NULL AUTO_INCREMENT,
475 `type` varchar(50) DEFAULT 'habbo_vip',
476 `start` int(255) DEFAULT '0',
477 `expire` int(255) DEFAULT '0',
478 `user_id` int(11) DEFAULT '0',
479 PRIMARY KEY (`id`)
480) ENGINE=InnoDB DEFAULT CHARSET=latin1;
481
482-- ----------------------------
483-- Records of player_subscriptions
484-- ----------------------------