· 7 years ago · Nov 11, 2018, 01:56 PM
1[Err] 2006 - MySQL server has gone away
2[Err] -- phpMyAdmin SQL Dump
3-- version 3.2.4
4-- http://www.phpmyadmin.net
5--
6-- Machine: localhost
7-- Genereertijd: 09 Apr 2017 om 13:53
8-- Serverversie: 5.1.41
9-- PHP-Versie: 5.3.1
10
11SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `1.0.5`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Tabelstructuur voor tabel `achievements`
27--
28
29DROP TABLE IF EXISTS `achievements`;
30CREATE TABLE IF NOT EXISTS `achievements` (
31 `id` int(10) NOT NULL AUTO_INCREMENT,
32 `name` varchar(64) NOT NULL DEFAULT 'ACH_',
33 `category` enum('identity','explore','music','social','games','room_builder','pets','tools','events') NOT NULL DEFAULT 'identity',
34 `level` int(11) NOT NULL DEFAULT '1',
35 `pixels` int(11) NOT NULL DEFAULT '100',
36 `points` int(11) DEFAULT '10',
37 `progress_needed` int(11) NOT NULL DEFAULT '1',
38 PRIMARY KEY (`name`,`level`),
39 UNIQUE KEY `id` (`id`)
40) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2576 ;
41
42--
43-- Gegevens worden uitgevoerd voor tabel `achievements`
44--
45
46INSERT INTO `achievements` (`id`, `name`, `category`, `level`, `pixels`, `points`, `progress_needed`) VALUES
47(435, 'Guide', 'identity', 1, 5, 0, 1),
48(436, 'Guide', 'identity', 2, 10, 5, 3),
49(437, 'Guide', 'identity', 3, 15, 10, 5),
50(438, 'Guide', 'identity', 4, 20, 15, 10),
51(439, 'Guide', 'identity', 5, 25, 20, 25),
52(440, 'Guide', 'identity', 6, 30, 25, 55),
53(441, 'Guide', 'identity', 7, 35, 30, 90),
54(442, 'Guide', 'identity', 8, 40, 35, 120),
55(443, 'Guide', 'identity', 9, 45, 40, 160),
56(444, 'Guide', 'identity', 10, 50, 45, 200),
57(445, 'Graduate', 'identity', 1, 5, 0, 1),
58(447, 'Login', 'identity', 1, 5, 0, 5),
59(448, 'Login', 'identity', 2, 10, 5, 13),
60(449, 'Login', 'identity', 3, 15, 10, 28),
61(450, 'Login', 'identity', 4, 20, 15, 56),
62(451, 'Login', 'identity', 5, 25, 20, 91),
63(452, 'Login', 'identity', 6, 30, 25, 141),
64(453, 'Login', 'identity', 7, 35, 30, 201),
65(454, 'Login', 'identity', 8, 40, 35, 271),
66(455, 'Login', 'identity', 9, 45, 40, 351),
67(456, 'Login', 'identity', 10, 50, 45, 451),
68(457, 'GamePlayed', 'games', 1, 5, 0, 1),
69(458, 'GamePlayed', 'games', 2, 10, 5, 6),
70(459, 'GamePlayed', 'games', 3, 15, 10, 26),
71(460, 'GamePlayed', 'games', 4, 20, 15, 76),
72(461, 'GamePlayed', 'games', 5, 25, 20, 176),
73(462, 'GamePlayed', 'games', 6, 30, 25, 336),
74(463, 'GamePlayed', 'games', 7, 35, 30, 536),
75(464, 'GamePlayed', 'games', 8, 40, 35, 816),
76(465, 'GamePlayed', 'games', 9, 45, 40, 1176),
77(466, 'GamePlayed', 'games', 10, 50, 45, 1616),
78(467, 'AvatarLooks', 'identity', 1, 5, 0, 1),
79(468, 'Student', 'identity', 1, 5, 0, 1),
80(469, 'RoomEntry', 'explore', 1, 5, 0, 5),
81(470, 'RoomEntry', 'explore', 2, 10, 5, 20),
82(471, 'RoomEntry', 'explore', 3, 15, 10, 50),
83(472, 'RoomEntry', 'explore', 4, 20, 15, 100),
84(473, 'RoomEntry', 'explore', 5, 25, 20, 160),
85(474, 'RoomEntry', 'explore', 6, 30, 25, 240),
86(475, 'RoomEntry', 'explore', 7, 35, 30, 360),
87(476, 'RoomEntry', 'explore', 8, 40, 35, 500),
88(477, 'RoomEntry', 'explore', 9, 45, 40, 660),
89(478, 'RoomEntry', 'explore', 10, 50, 45, 860),
90(479, 'Motto', 'identity', 1, 5, 0, 1),
91(480, 'HappyHour', 'events', 1, 5, 0, 1),
92(481, 'RegistrationDuration', 'identity', 1, 5, 0, 3),
93(482, 'RegistrationDuration', 'identity', 2, 10, 5, 21),
94(483, 'RegistrationDuration', 'identity', 3, 15, 10, 56),
95(484, 'RegistrationDuration', 'identity', 4, 20, 15, 112),
96(485, 'RegistrationDuration', 'identity', 5, 25, 20, 168),
97(486, 'RegistrationDuration', 'identity', 6, 30, 25, 365),
98(487, 'RegistrationDuration', 'identity', 7, 35, 30, 730),
99(488, 'RegistrationDuration', 'identity', 8, 40, 35, 1095),
100(489, 'RegistrationDuration', 'identity', 9, 45, 40, 1460),
101(490, 'RegistrationDuration', 'identity', 10, 50, 45, 1825),
102(491, 'HabboClub', 'identity', 1, 5, 0, 0),
103(492, 'HabboClub', 'identity', 2, 10, 5, 12),
104(493, 'HabboClub', 'identity', 3, 15, 10, 36),
105(494, 'HabboClub', 'identity', 4
106[Err] 1146 - Table 'databeest.items_base' doesn't exist
107[Err] INSERT INTO `items_base` (`id`, `sprite_id`, `public_name`, `item_name`, `type`, `width`, `length`, `stack_height`, `allow_stack`, `allow_walk`, `allow_sit`, `allow_lay`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `interaction_modes_count`, `vending_ids`, `effect_id_male`, `effect_id_female`, `multiheight`) VALUES
108(2079, 3672, 'Hidden Pyramid', 'wf_pyramid', 's', 1, 1, 0.10, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'pyramid', 0, '0', 0, 0, ''),
109(2080, 3673, 'WIRED Trigger: Score Is Achieved', 'wf_trg_score_achieved', 's', 1, 1, 0.65, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'wf_trg_score_achieved', 4, '0', 0, 0, ''),
110(2081, 3674, 'WIRED Effect: Teleport To Furni', 'wf_act_teleport_to', 's', 1, 1, 0.65, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'wf_act_teleport_to', 1, '0', 0, 0, ''),
111(2082, 3675, 'WIRED Trigger: User Says Keyword', 'wf_trg_says_something', 's', 1, 1, 0.65, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'wf_trg_says_something', 4, '0', 0, 0, ''),
112(2083, 3676, 'Color Wheel', 'wf_colorwheel', 's', 1, 1, 1.00, 0, 0, 0, 0, 1, 1, 1, 1, 1, 'default', 10, '0', 0, 0, ''),
113(2084, 3677, 'Three Way Wires', 'wf_wire4', 's', 1, 1, 0.10, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'default', 2, '0', 0, 0, ''),
114(2085, 3678, 'WIRED Trigger: User Walks Off Furni', 'wf_trg_walks_off_furni', 's', 1, 1, 0.65, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'wf_trg_walks_off_furni', 4, '0', 0, 0, ''),
115(2086, 3679, 'WIRED Trigger: At Set Time', 'wf_trg_at_given_time', 's', 1, 1, 0.65, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'wf_trg_at_given_time', 4, '0', 0, 0, ''),
116(2087, 3680, 'WIRED Trigger: Game Ends', 'wf_trg_game_ends', 's', 1, 1, 0.65, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'wf_trg_game_ends', 5, '0', 0, 0, ''),
117(2088, 3681, 'WIRED Effect: Show Message', 'wf_act_show_message', 's', 1, 1, 0.65, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'wf_act_show_message', 4, '0', 0, 0, ''),
118(2089, 3682, 'WIRED Condition: Less Than x Secs Elapsed Since Timer Reset', 'wf_cnd_time_less_than', 's', 1, 1, 0.65, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'wf_cnd_time_less_than', 2, '0', 0, 0, ''),
119(2090, 3683, 'WIRED Trigger: User Enters Room', 'wf_trg_enter_room', 's', 1, 1, 0.65, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'wf_trg_enter_room', 4, '0', 0, 0, ''),
120(2091, 3684, 'ads_hh_safe name', 'ads_hh_safe', 's', 1, 1, 1.00, 0, 0, 0, 0, 1, 1, 1, 1, 1, 'default', 2, '0', 0, 0, ''),
121(2092, 3685, 'WIRED Effect: Toggle Furni State', 'wf_act_toggle_state', 's', 1, 1, 0.65, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'wf_act_toggle_state', 4, '0', 0, 0, ''),
122(2093, 3686, 'Wall Of Flame', 'wf_firegate', 's', 1, 1, 0.10, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'default', 2, '0', 0, 0, ''),
123(2094, 3687, 'Ringplate', 'wf_ringplate', 's', 1, 1, 0.00, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'pressureplate', 2, '0', 0, 0, ''),
124(2095, 3688, 'Pressure Plate', 'wf_pressureplate', 's', 1, 1, 0.00, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'pressureplate', 2, '0', 0, 0, ''),
125(2096, 3689, 'Glowball', 'wf_glowball', 's', 1, 1, 1.00, 0, 0, 0, 0, 1, 1, 1, 1, 1, 'default', 2, '0', 0, 0, ''),
126(2097, 3690, 'bb_lightstrip name', 'bb_lightstrip', 's', 1, 1, 0.20, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'default', 2, '0', 0, 0, ''),
127(2098, 3691, 'WIRED Effect: Timer Reset', 'wf_act_reset_timers', 's', 1, 1, 0.65, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'wf_act_reset_timers', 4, '0', 0, 0, ''),
128(2099, 3692, 'WIRED Condition: Furni has users', 'wf_cnd_furnis_hv_avtrs', 's', 1, 1, 0.65, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'wf_cnd_furnis_hv_avtrs', 2, '0', 0, 0, ''),
129(2100, 3693, 'Arrow Plate', 'wf_arrowplate', 's', 1, 1, 0.00, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'pressureplate', 4, '0', 0, 0, ''),
130(2101, 3694, 'WIRED Condition: Triggering User Is On Furni', 'wf_cnd_trggrer_on_frn', 's', 1, 1, 0.65, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'wf_cnd_trggrer_on_frn', 2, '0', 0, 0, ''),
131(2102, 3695, 'WIRED Condition: Furni States And Positions Match', 'wf_cnd_match_snapshot', 's', 1, 1, 0.65, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'wf_cnd_match_snapshot', 2, '0', 0, 0, ''),
132(2103, 3696, 'Floor Wiring', 'wf_wire1', 's', 1, 1, 0.10, 0, 1, 0, 0, 1, 1, 1, 1, 1, 'default', 2, '0', 0, 0, ''),
133(2104, 3697, 'WIRED Effect: Give Points', 'wf_act_give_score', 's', 1, 1, 0.65, 0, 1, 0, 0, 1, 1, 1, 1, 1
134[Err] 1146 - Table 'databeest.emulator_texts' doesn't exist
135[Err] CREATE TABLE IF NOT EXISTS `room_trade_log` (
136 `id` int(11) NOT NULL AUTO_INCREMENT,
137 `user_one_id` int(11) NOT NULL,
138 `user_two_id` int(11) NOT NULL,
139 `user_one_ip` varchar(45) NOT NULL,
140 `user_two_ip` varchar(45) NOT NULL,
141 `timestamp` int(11) NOT NULL,
142 `user_one_item_count` int(11) NOT NULL,
143 `user_two_item_count` int(11) NOT NULL,
144 PRIMARY KEY (`id`),
145 KEY `user_one_id` (`user_one_id`),
146 KEY `user_two_id` (`user_two_id`)
147) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
148
149--
150-- Gegevens worden uitgevoerd voor tabel `room_trade_log`
151--
152
153
154-- --------------------------------------------------------
155
156--
157-- Tabelstructuur voor tabel `room_trade_log_items`
158--
159
160DROP TABLE IF EXISTS `room_trade_log_items`;
161CREATE TABLE IF NOT EXISTS `room_trade_log_items` (
162 `id` int(11) NOT NULL,
163 `item_id` int(11) NOT NULL,
164 `user_id` int(11) NOT NULL,
165 UNIQUE KEY `id` (`id`,`item_id`,`user_id`),
166 KEY `id_2` (`id`),
167 KEY `user_id` (`user_id`),
168 KEY `id_3` (`id`,`user_id`)
169) ENGINE=InnoDB DEFAULT CHARSET=latin1;
170
171--
172-- Gegevens worden uitgevoerd voor tabel `room_trade_log_items`
173--
174
175
176-- --------------------------------------------------------
177
178--
179-- Tabelstructuur voor tabel `room_votes`
180--
181
182DROP TABLE IF EXISTS `room_votes`;
183CREATE TABLE IF NOT EXISTS `room_votes` (
184 `user_id` int(11) NOT NULL,
185 `room_id` int(11) NOT NULL
186) ENGINE=MyISAM DEFAULT CHARSET=latin1;
187
188--
189-- Gegevens worden uitgevoerd voor tabel `room_votes`
190--
191
192
193-- --------------------------------------------------------
194
195--
196-- Tabelstructuur voor tabel `room_wordfilter`
197--
198
199DROP TABLE IF EXISTS `room_wordfilter`;
200CREATE TABLE IF NOT EXISTS `room_wordfilter` (
201 `room_id` int(11) NOT NULL,
202 `word` varchar(25) NOT NULL,
203 UNIQUE KEY `unique_index` (`room_id`,`word`)
204) ENGINE=MyISAM DEFAULT CHARSET=latin1;
205
206--
207-- Gegevens worden uitgevoerd voor tabel `room_wordfilter`
208--
209
210
211-- --------------------------------------------------------
212
213--
214-- Tabelstructuur voor tabel `soundtracks`
215--
216
217DROP TABLE IF EXISTS `soundtracks`;
218CREATE TABLE IF NOT EXISTS `soundtracks` (
219 `id` int(6) NOT NULL AUTO_INCREMENT,
220 `code` varchar(32) NOT NULL,
221 `name` varchar(100) NOT NULL,
222 `author` varchar(50) NOT NULL,
223 `track` text NOT NULL,
224 `length` int(4) NOT NULL DEFAULT '0',
225 PRIMARY KEY (`id`)
226) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ;
227
228--
229-- Gegevens worden uitgevoerd voor tabel `soundtracks`
230--
231
232INSERT INTO `soundtracks` (`id`, `code`, `name`, `author`, `track`, `length`) VALUES
233(1, 'ballad_of_bonnie', 'The Ballad of Bonnie Blonde', 'Pixel! at the Disco', '1:371,8;374,4;378,4;0,4;378,4;0,4;377,4;378,4;0,6;371,4;0,4;370,3;377,2;0,7:2:353,24;358,4;363,4;353,10;367,4;353,4;367,4;353,8:3:0,4;291,2;365,2;0,2;365,2;377,2;365,2;377,2;365,2;377,2;0,2;359,4;352,4;357,1;0,1;365,2;0,2;292,4;0,3;357,1;292,4;0,3;357,1;292,4;296,4:4:0,2;368,22;354,4;368,26;361,8:', 124),
234(2, 'bossa_nova', 'Push the Call for Help', 'BanzaiBabes', '1:317,6;318,4;319,4;317,4;319,4;0,2:2:0,2;316,4;0,4;316,4;0,4;316,4;0,2:3:0,6;321,4;323,4;322,10:4:0,18;321,2;324,2;0,2:', 48),
235(3, 'doorman_frank', 'Monotone Hotel Sounds', 'Doorman Frank', '1:4,24:2:2,24:3:0,24:4:0,24:', 48),
236(4, 'pianissimo', 'Haven''t Friend Request You Yet', 'Micheal Bauble', '1:280,4;281,4;282,4;283,4;284,4;285,4;286,4;287,4;288,4:2:0,36:3:0,36:4:0,36:', 72),
237(5, '', 'Sounds That Fit Double Rainbows', 'Kallomies', '1:200,12;199,3;201,1;200,28:2:0,2;190,1;0,1;191,1;0,1;192,1;0,1;190,2;191,1;192,1;190,2;0,1;193,2;190,2;191,1;0,1;190,1;192,2;0,1;191,2;178,2;0,1;178,2;0,1;178,2;0,2;177,2;0,1;176,4:3:0,8;176,2;0,1;177,2;0,3;179,2;0,2;177,2;0,2;176,2;0,1;178,6;0,1;178,2;0,2;177,4;176,2:4:0,8;197,16;0,20:', 88),
238(6, 'gold_coin_digger', 'Gold Coin Digger', 'Kayne Quest', '1:104,10;102,8;104,4;102,8;104,4:2:0,2;181,8;182,8;181,4;182,8;130,2;106,2:3:0,2;105,2;106,2;186,3;187,1;185,1;184,1;185,1;184,1;185,1;184,1;185,1;187,1;186,3;187,1;185,1;184,1;185,1;184,1;185,1;184,1;185,1;184,1;72,1;100,2;0,1:4:0,4;103,6;133,1;101,1;133,1;101,1;133,1;101,1;133,1;101,1;103,4;133,1;101,1;133,1;101,1;133,1;101,1;133,1;101,1;105,2;101,1;0
239[Err] 1146 - Table 'databeest.camera_web' doesn't exist
240[Err] CREATE TABLE `support_cfh_categories` (
241 `id` int(11) NOT NULL AUTO_INCREMENT,
242 `name_internal` varchar(255) DEFAULT NULL,
243 `name_external` varchar(255) DEFAULT NULL,
244 PRIMARY KEY (`id`)
245) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
246
247INSERT INTO `support_cfh_categories` VALUES ('1', 'cyber', 'Cyber sex');
248INSERT INTO `support_cfh_categories` VALUES ('2', 'scamming', 'Scamming');
249INSERT INTO `support_cfh_categories` VALUES ('3', 'badwords', 'Inappropriate words');
250INSERT INTO `support_cfh_categories` VALUES ('4', 'badbehavior', 'Bad behavior');
251INSERT INTO `support_cfh_categories` VALUES ('5', 'account', 'Account Issues');
252INSERT INTO `support_cfh_categories` VALUES ('6', 'hacking', 'Hacking');
253
254DROP TABLE IF EXISTS `support_cfh_topics`;
255CREATE TABLE `support_cfh_topics` (
256 `id` int(11) NOT NULL AUTO_INCREMENT,
257 `category_id` int(11) DEFAULT NULL,
258 `name_internal` varchar(255) DEFAULT NULL,
259 `name_external` varchar(255) DEFAULT NULL,
260 `action` enum('mods','auto_ignore','auto_reply') DEFAULT 'mods',
261 `auto_reply` text DEFAULT NULL,
262 PRIMARY KEY (`id`)
263) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;
264
265INSERT INTO `support_cfh_topics` VALUES ('1', '1', 'cyber.sextalk', 'Sexual talk', 'auto_ignore', 'Thank you for reporting someone for sexual talk. We have put this user on ignore for you. This means that you can no longer see what they are saying. To turn ignore off for this person you need to click on them and press \'Listen\'. We will take a look at this.');
266INSERT INTO `support_cfh_topics` VALUES ('2', '1', 'cyber.asking', 'Asking for cyber sex', 'auto_ignore', 'Thank you for reporting someone for sexual talk. We have put this user on ignore for you. This means that you can no longer see what they are saying. To turn ignore off for this person you need to click on them and press \'Listen\'. We will take a look at this.');
267INSERT INTO `support_cfh_topics` VALUES ('3', '1', 'cyber.offering', 'Offering cyber sex', 'auto_ignore', 'Thank you for reporting someone for sexual talk. We have put this user on ignore for you. This means that you can no longer see what they are saying. To turn ignore off for this person you need to click on them and press \'Listen\'. We will take a look at this.');
268INSERT INTO `support_cfh_topics` VALUES ('4', '1', 'cyber.porn', 'Sending porn', 'mods', null);
269INSERT INTO `support_cfh_topics` VALUES ('5', '2', 'scamming.scamsite', 'Promoting scam sites', 'mods', null);
270INSERT INTO `support_cfh_topics` VALUES ('6', '2', 'scamming.sellingirl', 'Selling virtual items for real money', 'mods', null);
271INSERT INTO `support_cfh_topics` VALUES ('7', '2', 'scamming.stealingfurni', 'Stealing furni or coins', 'mods', null);
272INSERT INTO `support_cfh_topics` VALUES ('8', '2', 'scamming.account', 'Stealing account information', 'mods', null);
273INSERT INTO `support_cfh_topics` VALUES ('9', '2', 'scamming.casino', 'Casino scamming', 'auto_reply', 'Habbo does not get involved with the casino community due to cases being complex and hard to track. Players gamble at their own risk. When the fun stops, stop.');
274INSERT INTO `support_cfh_topics` VALUES ('10', '3', 'badwords.roomname', 'Room name', 'mods', null);
275INSERT INTO `support_cfh_topics` VALUES ('11', '3', 'badwords.roomdesc', 'Room description', 'mods', null);
276INSERT INTO `support_cfh_topics` VALUES ('12', '3', 'badwords.username', 'Username', 'mods', null);
277INSERT INTO `support_cfh_topics` VALUES ('13', '3', 'badwords.motto', 'Moto', 'mods', null);
278INSERT INTO `support_cfh_topics` VALUES ('14', '3', 'badwords.grouporevent', 'Group or event name', 'mods', null);
279INSERT INTO `support_cfh_topics` VALUES ('15', '4', 'badbehavior.trolling', 'Trolling', 'auto_reply', 'Thanks for your report. Please call a moderator to the room by following these steps.\r\n1. Under the Help window click on \'Get immediate help\'.\r\n2. Then click on \'Chat to a Moderator\'.\r\n3. Let them know that somebody is trolling in the room.\r\n4. A moderator will open a chat session with you to resolve the problem.');
280INSERT INTO `support_cfh_topics` VALUES ('16'
281[Err] 1146 - Table 'databeest.navigator_filter' doesn't exist
282[Err] ALTER TABLE `navigator_filter` ADD PRIMARY KEY ( `key` );
283ALTER TABLE `navigator_filter` CHANGE `database_query` `database_query` VARCHAR( 1024 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;
284UPDATE `navigator_filter` SET `compare` = 'contains' WHERE `navigator_filter`.`key` = 'roomname';
285UPDATE `navigator_filter` SET `database_query` = 'SELECT * FROM rooms WHERE name COLLATE UTF8_GENERAL_CI LIKE ? ', `compare` = 'contains' WHERE `navigator_filter`.`key` = 'roomname';
286UPDATE `navigator_filter` SET `database_query` = 'SELECT rooms.*, CONCAT_WS(rooms.owner_name, rooms.name, rooms.description, rooms.tags, guilds.name, guilds.description) as whole FROM rooms LEFT JOIN guilds ON rooms.guild_id = guilds.id HAVING whole LIKE ? ' WHERE `navigator_filter`.`key` = 'anything';
287ALTER TABLE `users_settings` ADD `mute_end_timestamp` INT( 11 ) NOT NULL DEFAULT '0' AFTER `nux`;
288ALTER TABLE `wordfilter` ADD `mute` INT( 3 ) NOT NULL DEFAULT '0' COMMENT 'Time user gets muted for mentioning this word.' AFTER `report`;
289
290
291#END DATABASE UPDATE: 1.8.0 -> 1.9.0
292
293#DATABASE UPDATE: 1.9.0 -> 1.10.0
294
295ALTER TABLE `support_tickets` ADD `category` INT( 3 ) NOT NULL DEFAULT '0' AFTER `issue`;
296INSERT INTO `emulator_texts` (`key`, `value`) VALUES ('supporttools.not_ticket_owner', 'You are not the moderator currently handling the ticket.');
297ALTER TABLE `support_cfh_topics` ADD `default_sanction` INT( 3 ) NOT NULL DEFAULT '0' AFTER `auto_reply`;
298INSERT INTO `emulator_texts` (`key`, `value`) VALUES ('commands.success.cmd_setmax', 'Success! Maximum users in this room changed to %value%.');
299
300CREATE TABLE `calendar_rewards` (
301 `id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
302 `name` VARCHAR( 128 ) NOT NULL ,
303 `custom_image` VARCHAR( 128 ) NOT NULL ,
304 `credits` INT( 11 ) NOT NULL DEFAULT '0',
305 `points` INT( 11 ) NOT NULL DEFAULT '0',
306 `points_type` INT( 3 ) NOT NULL DEFAULT '0',
307 `badge` VARCHAR( 25 ) NOT NULL DEFAULT '',
308 `catalog_item_id` INT( 11 ) NOT NULL DEFAULT '0',
309PRIMARY KEY ( `id` )
310) ENGINE = MYISAM ;
311
312CREATE TABLE `calendar_rewards_claimed` (
313 `user_id` INT NOT NULL ,
314 `reward_id` INT NOT NULL ,
315 `timestamp` INT NOT NULL
316) ENGINE = MYISAM ;
317
318ALTER TABLE `permissions` ADD `cmd_changename` ENUM( '0', '1' ) NOT NULL DEFAULT '0' AFTER `cmd_bundle`;
319INSERT INTO `emulator_texts` (`key`, `value`) VALUES ('commands.description.cmd_changename', ':changename'), ('commands.keys.cmd_changename', 'changename;flagme;change_name;namechange');
320ALTER TABLE `users_settings` ADD `allow_name_change` ENUM( '0', '1' ) NOT NULL DEFAULT '0';
321
322CREATE TABLE `namechange_log` (
323 `user_id` INT( 11 ) NOT NULL ,
324 `old_name` VARCHAR( 32 ) NOT NULL ,
325 `new_name` VARCHAR( 32 ) NOT NULL ,
326 `timestamp` INT( 11 ) NOT NULL
327) ENGINE = MYISAM ;
328
329INSERT INTO `emulator_settings` (`key`, `value`) VALUES
330('basejump.url', 'http://localhost/game/BaseJump.swf'),
331('basejump.assets.url', 'http://localhost/gamecenter/gamecenter_basejump/BasicAssets.swf');
332
333DROP INDEX `user_id` ON users_recipes;
334ALTER TABLE `users_recipes` ADD UNIQUE KEY ( `user_id`, `recipe` );
335
336DELETE FROM emulator_settings WHERE `key` LIKE 'hotel.max.bots.inventory';
337UPDATE `emulator_settings` SET `key` = 'hotel.inventory.max.items' WHERE `emulator_settings`.`key` = 'inventory.max.items';
338INSERT INTO `emulator_texts` (`key` , `value` ) VALUES
339('commands.error.cmd_credits.user_not_found', 'Could net send %amount% credits to %user%. %user% does not exist.');
340
341INSERT INTO `emulator_settings` (`key`, `value`) VALUES ('hotel.marketplace.currency', '0');
342INSERT INTO `emulator_texts` (`key`, `value`) VALUES ('commands.error.cmd_pull.invalid', 'You cannot pull %username% to there.');
343INSERT INTO `emulator_texts` (`key`, `value`) VALUES ('commands.error.cmd_push.invalid', 'You cannot push %username% to there.');
344ALTER TABLE `marketplace_items` ADD `sold_timestamp` INT( 11 ) NOT NULL DEFAULT '0' AFTER `timestamp`;
345UPDATE permissions SET acc_debug = '0';
346
347ALTER TABLE `permissions` ADD `level` INT( 2 ) NOT NULL DEFAULT '1' AFTE
348[Err] 1146 - Table 'databeest.catalog_items' doesn't exist
349[Err] ALTER TABLE `catalog_items` ADD `order_number` TINYINT(2) NOT NULL DEFAULT '0' AFTER `offer_id`;
350
351ALTER TABLE `permissions` CHANGE `acc_inifnite_friends` `acc_infinite_friends` ENUM('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0';
352
353UPDATE `emulator_texts` SET `value` = 'Superwired Usage Information. Possible reward types:<br/>badge: BADGE CODE<br/>Credits: credits#amount<br/>Pixels: pixels#amount<br/>Points: points#amount<br/>Respect: respect#amount<br/>Furniture: furni#FurnitureID<br/>Catalog Item: cata#CatalogItemID<br/>' WHERE `emulator_texts`.`key` = 'hotel.wired.superwired.info';
354ALTER TABLE `navigator_publiccats` ADD `order_num` INT(3) NOT NULL DEFAULT '0' AFTER `visible`;
355ALTER TABLE `navigator_flatcats` ADD `order_num` INT(3) NOT NULL DEFAULT '0' AFTER `list_type`;
356INSERT INTO `emulator_settings` (`key`, `value`) VALUES ('hotel.wordfilter.automute', '1');
357#END DATABASE UPDATE: 1.13.0 -> 1.14.0
358
359#DATABASE UPDATE: 1.14.0 -> 1.15.0
360
361ALTER TABLE `pet_commands_data` ADD PRIMARY KEY(`command_id`);
362
363INSERT INTO `pet_breeding_races` (`pet_type`, `rarity_level`, `breed`) VALUES ('28', '1', '1');
364INSERT INTO `pet_breeding_races` (`pet_type`, `rarity_level`, `breed`) VALUES ('28', '1', '2');
365INSERT INTO `pet_breeding_races` (`pet_type`, `rarity_level`, `breed`) VALUES ('28', '1', '3');
366INSERT INTO `pet_breeding_races` (`pet_type`, `rarity_level`, `breed`) VALUES ('28', '1', '4');
367INSERT INTO `pet_breeding_races` (`pet_type`, `rarity_level`, `breed`) VALUES ('28', '1', '5');
368INSERT INTO `pet_breeding_races` (`pet_type`, `rarity_level`, `breed`) VALUES ('28', '1', '6');
369INSERT INTO `pet_breeding_races` (`pet_type`, `rarity_level`, `breed`) VALUES ('28', '1', '7');
370INSERT INTO `pet_breeding_races` (`pet_type`, `rarity_level`, `breed`) VALUES ('28', '2', '8');
371INSERT INTO `pet_breeding_races` (`pet_type`, `rarity_level`, `breed`) VALUES ('28', '2', '9');
372INSERT INTO `pet_breeding_races` (`pet_type`, `rarity_level`, `breed`) VALUES ('28', '2', '10');
373INSERT INTO `pet_breeding_races` (`pet_type`, `rarity_level`, `breed`) VALUES ('28', '2', '11');
374INSERT INTO `pet_breeding_races` (`pet_type`, `rarity_level`, `breed`) VALUES ('28', '2', '12');
375INSERT INTO `pet_breeding_races` (`pet_type`, `rarity_level`, `breed`) VALUES ('28', '2', '13');
376INSERT INTO `pet_breeding_races` (`pet_type`, `rarity_level`, `breed`) VALUES ('28', '3', '14');
377INSERT INTO `pet_breeding_races` (`pet_type`, `rarity_level`, `breed`) VALUES ('28', '3', '15');
378INSERT INTO `pet_breeding_races` (`pet_type`, `rarity_level`, `breed`) VALUES ('28', '3', '16');
379INSERT INTO `pet_breeding_races` (`pet_type`, `rarity_level`, `breed`) VALUES ('28', '3', '17');
380INSERT INTO `pet_breeding_races` (`pet_type`, `rarity_level`, `breed`) VALUES ('28', '4', '18');
381INSERT INTO `pet_breeding_races` (`pet_type`, `rarity_level`, `breed`) VALUES ('28', '4', '19');
382INSERT INTO `pet_breeding_races` (`pet_type`, `rarity_level`, `breed`) VALUES ('28', '4', '20');
383
384ALTER TABLE `pet_actions` ADD `offspring_type` INT(3) NOT NULL DEFAULT '-1' AFTER `pet_name`;
385
386INSERT INTO `achievements` (`id`, `name`, `category`, `level`, `reward_amount`, `reward_type`, `points`, `progress_needed`) VALUES (NULL, 'Trampolinist', 'games', '1', '10', '0', '10', '1');
387INSERT INTO `achievements` (`id`, `name`, `category`, `level`, `reward_amount`, `reward_type`, `points`, `progress_needed`) VALUES (NULL, 'Trampolinist', 'games', '2', '20', '0', '20', '10');
388INSERT INTO `achievements` (`id`, `name`, `category`, `level`, `reward_amount`, `reward_type`, `points`, `progress_needed`) VALUES (NULL, 'Trampolinist', 'games', '3', '30', '0', '30', '30');
389INSERT INTO `achievements` (`id`, `name`, `category`, `level`, `reward_amount`, `reward_type`, `points`, `progress_needed`) VALUES (NULL, 'Trampolinist', 'games', '4', '40', '0', '40', '60');
390INSERT INTO `achievements` (`id`, `name`, `category`, `level`, `reward_amount`, `reward_type`, `points`, `progress_needed`) VALUES (NULL, 'Trampolinist', 'games', '5', '50', '0', '50', '120');
391INSERT INTO `achievements` (`id`, `name`, `category`, `level`,
392[Msg] Finished - Unsuccessfully
393--------------------------------------------------