aMgWeSut

1DROP TABLE IF EXISTS bot_bot;
2CREATE TABLE bot_bot (
3 id int(11) NOT NULL auto_increment,
4 bot tinyint(4) NOT NULL default '0',
5 name varchar(255) NOT NULL default '',
6 value text NOT NULL,
7 PRIMARY KEY (id),
8 KEY botname (bot,name)
9) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
10
11DROP TABLE IF EXISTS bot_bots;
12CREATE TABLE bot_bots (
13 id tinyint(3) unsigned NOT NULL auto_increment,
14 botname varchar(255) NOT NULL default '',
15 PRIMARY KEY (botname),
16 KEY id (id)
17) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
18
19DROP TABLE IF EXISTS bot_conversationlog;
20CREATE TABLE bot_conversationlog (
21 bot tinyint(3) unsigned NOT NULL default '0',
22 id int(11) NOT NULL auto_increment,
23 input text,
24 response text,
25 uid varchar(255) default NULL,
26 enteredtime timestamp NOT NULL,
27 PRIMARY KEY (id),
28 KEY botid (bot)
29) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
30
31DROP TABLE IF EXISTS bot_dstore;
32CREATE TABLE bot_dstore (
33 uid varchar(255) default NULL,
34 name text,
35 value text,
36 enteredtime timestamp NOT NULL,
37 id int(11) NOT NULL auto_increment,
38 PRIMARY KEY (id),
39 KEY nameidx (name(40))
40) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
41
42DROP TABLE IF EXISTS bot_gmcache;
43CREATE TABLE bot_gmcache (
44 id int(11) NOT NULL auto_increment,
45 bot tinyint(3) unsigned NOT NULL default '0',
46 template int(11) NOT NULL default '0',
47 inputstarvals text,
48 thatstarvals text,
49 topicstarvals text,
50 patternmatched text,
51 inputmatched text,
52 combined text NOT NULL,
53 PRIMARY KEY (id),
54 KEY combined (bot,combined(255))
55) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
56
57DROP TABLE IF EXISTS bot_gossip;
58CREATE TABLE bot_gossip (
59 bot tinyint(3) unsigned NOT NULL default '0',
60 gossip text,
61 id int(11) NOT NULL auto_increment,
62 PRIMARY KEY (id),
63 KEY botidx (bot)
64) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
65
66DROP TABLE IF EXISTS bot_patterns;
67CREATE TABLE bot_patterns (
68 bot tinyint(3) unsigned NOT NULL default '0',
69 id int(11) NOT NULL auto_increment,
70 word varchar(255) default NULL,
71 ordera tinyint(4) NOT NULL default '0',
72 parent int(11) NOT NULL default '0',
73 isend tinyint(4) NOT NULL default '0',
74 PRIMARY KEY (id),
75 KEY wordparent (parent,word),
76 KEY botid (bot)
77) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
78
79DROP TABLE IF EXISTS bot_templates;
80CREATE TABLE bot_templates (
81 bot tinyint(3) unsigned NOT NULL default '0',
82 id int(11) NOT NULL default '0',
83 template text NOT NULL,
84 pattern varchar(255) default NULL,
85 that varchar(255) default NULL,
86 topic varchar(255) default NULL,
87 KEY bot (id)
88) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
89
90DROP TABLE IF EXISTS bot_thatindex;
91CREATE TABLE bot_thatindex (
92 uid varchar(255) default NULL,
93 enteredtime timestamp NOT NULL,
94 id int(11) NOT NULL auto_increment,
95 PRIMARY KEY (id)
96) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
97
98DROP TABLE IF EXISTS bot_thatstack;
99CREATE TABLE bot_thatstack (
100 thatid int(11) NOT NULL default '0',
101 id int(11) NOT NULL auto_increment,
102 value varchar(255) default NULL,
103 enteredtime timestamp NOT NULL,
104 PRIMARY KEY (id)
105) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
106
107DROP TABLE IF EXISTS c_ban_users;
108CREATE TABLE c_ban_users (
109 username varchar(30) NOT NULL default '',
110 latin1 tinyint(1) NOT NULL default '0',
111 ip varchar(100) NOT NULL default '',
112 rooms varchar(100) NOT NULL default '',
113 ban_until int(11) NOT NULL default '0',
114 reason varchar(100) NOT NULL default '',
115 country_code varchar(3) NOT NULL default '',
116 country_name varchar(100) NOT NULL default ''
117) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
118
119DROP TABLE IF EXISTS c_config;
120CREATE TABLE c_config (
121 ID tinyint(1) NOT NULL default '0',
122 MSG_DEL tinyint(1) NOT NULL default '96',
123 USR_DEL tinyint(1) NOT NULL default '10',
124 REG_DEL tinyint(1) NOT NULL default '0',
125 LANGUAGE varchar(40) NOT NULL default 'english',
126 MULTI_LANG enum('0','1') NOT NULL default '1',
127 REQUIRE_REGISTER enum('0','1') NOT NULL default '0',
128 REQUIRE_NAMES enum('0','1') NOT NULL default '0',
129 EMAIL_PASWD enum('0','1') NOT NULL default '0',
130 PASS_LENGTH tinyint(1) NOT NULL default '6',
131 ADMIN_NOTIFY enum('0','1') NOT NULL default '1',
132 ADMIN_NAME varchar(35) NOT NULL default 'Your name/chat name here',
133 ADMIN_EMAIL varchar(35) NOT NULL default 'Your email address here',
134 CHAT_URL varchar(100) NOT NULL default 'Your server/chat URL here',
135 SHOW_ADMIN enum('0','1') NOT NULL default '1',
136 SHOW_DEL_PROF enum('0','1') NOT NULL default '1',
137 VERSION enum('0','1','2') NOT NULL default '2',
138 BANISH tinyint(1) NOT NULL default '1',
139 NO_SWEAR enum('0','1') NOT NULL default '0',
140 SWEAR_EXPR varchar(5) NOT NULL default '@#$*!',
141 SAVE varchar(5) NOT NULL default '*',
142 USE_SMILIES enum('0','1') NOT NULL default '1',
143 HTML_TAGS_KEEP enum('none','simple') NOT NULL default 'simple',
144 HTML_TAGS_SHOW enum('0','1') NOT NULL default '0',
145 TMZ_OFFSET tinyint(1) NOT NULL default '0',
146 MSG_ORDER enum('0','1') NOT NULL default '1',
147 MSG_NB tinyint(1) NOT NULL default '10',
148 MSG_REFRESH tinyint(1) NOT NULL default '20',
149 SHOW_TIMESTAMP enum('0','1') NOT NULL default '1',
150 NOTIFY enum('0','1') NOT NULL default '1',
151 WELCOME enum('0','1') NOT NULL default '1',
152 SMILEY_COLS tinyint(1) NOT NULL default '10',
153 SMILEY_COLS_POP tinyint(1) NOT NULL default '5',
154 ALLOW_ENTRANCE_SOUND enum('0','1','2','3') NOT NULL default '1',
155 ENTRANCE_SOUND varchar(255) NOT NULL default 'sounds/chimeup.wav',
156 ALLOW_BUZZ_SOUND enum('0','1') NOT NULL default '1',
157 BUZZ_SOUND varchar(255) NOT NULL default 'sounds/chimedwn.wav',
158 TOPIC_DIFF enum('0','1') NOT NULL default '1',
159 SHOW_TUT enum('0','1') NOT NULL default '1',
160 SHOW_INFO enum('0','1') NOT NULL default '0',
161 SET_CMDS enum('0','1') NOT NULL default '1',
162 CMDS varchar(255) NOT NULL default '/away /buzz /demote /dice /dice2 /dice3 /high /img /math /mr<br />/room /size /sort /topic /utube /video /wisp',
163 SET_MODS enum('0','1') NOT NULL default '1',
164 MODS varchar(255) NOT NULL default 'Advanced Admin, (GR)Avatars, Smilies Popup, Color Drop Box, Private Popup,<br />Quick Menu, Logs Archive, Lurking, Color names, WorldTime, UTF-8, Birthdays, MathJax',
165 SET_BOT enum('0','1') NOT NULL default '1',
166 ROOM_SAYS varchar(255) NOT NULL default 'Attention Room:',
167 DEMOTE_MOD enum('0','1') NOT NULL default '0',
168 PRIV_POPUP enum('0','1') NOT NULL default '1',
169 SHOW_ETIQ_IN_HELP enum('0','1') NOT NULL default '1',
170 SHOW_LOGO enum('0','1') NOT NULL default '1',
171 LOGO_IMG varchar(255) NOT NULL default 'images/icon.gif',
172 LOGO_OPEN varchar(255) NOT NULL default './',
173 LOGO_ALT varchar(255) NOT NULL default 'My Chat based on phpMyChat-Plus',
174 SHOW_OWNER enum('0','1') NOT NULL default '1',
175 SHOW_PRIV enum('0','1') NOT NULL default '1',
176 SHOW_PRIV_MOD enum('0','1') NOT NULL default '1',
177 SHOW_PRIV_USR enum('0','1') NOT NULL default '1',
178 SHOW_COUNTER enum('0','1') NOT NULL default '1',
179 INSTALL_DATE date NOT NULL default '0000-00-00',
180 USE_SKIN enum('0','1') NOT NULL default '1',
181 ROOM1 varchar(25) NOT NULL default 'Public Room 1',
182 ROOM2 varchar(25) NOT NULL default 'Public Room 2',
183 ROOM3 varchar(25) NOT NULL default 'Public Room 3',
184 ROOM4 varchar(25) NOT NULL default 'Public Room 4',
185 ROOM5 varchar(25) NOT NULL default 'Public Room 5',
186 ROOM6 varchar(25) NOT NULL default 'Private Room 1',
187 ROOM7 varchar(25) NOT NULL default 'Private Room 2',
188 ROOM8 varchar(25) NOT NULL default 'Staff Only',
189 ROOM9 varchar(25) NOT NULL default 'Support Room',
190 SWEAR1 varchar(25) NOT NULL default 'Public Room 5',
191 SWEAR2 varchar(25) NOT NULL default 'Staff Only',
192 SWEAR3 varchar(25) NOT NULL default 'Support Room',
193 SWEAR4 varchar(25) NOT NULL default '',
194 COLOR_FILTERS enum('0','1') NOT NULL default '1',
195 COLOR_ALLOW_GUESTS enum('0','1') NOT NULL default '1',
196 ROOM_SKIN1 tinyint(1) NOT NULL default '1',
197 ROOM_SKIN2 tinyint(1) NOT NULL default '2',
198 ROOM_SKIN3 tinyint(1) NOT NULL default '3',
199 ROOM_SKIN4 tinyint(1) NOT NULL default '4',
200 ROOM_SKIN5 tinyint(1) NOT NULL default '5',
201 ROOM_SKIN6 tinyint(1) NOT NULL default '6',
202 ROOM_SKIN7 tinyint(1) NOT NULL default '7',
203 ROOM_SKIN8 tinyint(1) NOT NULL default '8',
204 ROOM_SKIN9 tinyint(1) NOT NULL default '9',
205 COLOR_CA varchar(25) NOT NULL default 'red',
206 COLOR_CA1 varchar(25) NOT NULL default 'crimson',
207 COLOR_CA2 varchar(25) NOT NULL default 'orangered',
208 COLOR_CM varchar(25) NOT NULL default 'blue',
209 COLOR_CM1 varchar(25) NOT NULL default 'mediumblue',
210 COLOR_CM2 varchar(25) NOT NULL default 'royalblue',
211 QUICKA longtext NOT NULL,
212 QUICKM longtext NOT NULL,
213 QUICKU longtext NOT NULL,
214 COLOR_NAMES enum('0','1') NOT NULL default '1',
215 USE_AVATARS enum('0','1') NOT NULL default '1',
216 NUM_AVATARS smallint(1) NOT NULL default '80',
217 AVA_RELPATH varchar(255) NOT NULL default 'images/avatars/',
218 DEF_AVATAR varchar(255) NOT NULL default 'def_avatar.gif',
219 AVA_WIDTH tinyint(1) NOT NULL default '30',
220 AVA_HEIGHT tinyint(1) NOT NULL default '30',
221 AVA_PROFBUTTON enum('0','1') NOT NULL default '1',
222 MAX_DICES tinyint(1) NOT NULL default '99',
223 MAX_ROLLS tinyint(1) NOT NULL default '6',
224 BOT_CONTROL enum('0','1') NOT NULL default '1',
225 MAX_PIC_SIZE smallint(1) NOT NULL default '350',
226 USERS_SORT_ORD enum('0','1') NOT NULL default '0',
227 CHAT_LOGS enum('0','1') NOT NULL default '1',
228 LOG_DIR varchar(25) NOT NULL default 'logsadmin',
229 SHOW_LOGS_USR enum('0','1') NOT NULL default '1',
230 CHAT_LURKING enum('0','1') NOT NULL default '1',
231 SHOW_LURK_USR enum('0','1') NOT NULL default '1',
232 BAN_IP enum('0','1') NOT NULL default '0',
233 REG_CHARS_ALLOWED varchar(50) NOT NULL default 'a-zA-Z0-9_.-@#$%^&*()=<>?~{}|`:',
234 EXIT_LINK_TYPE enum('0','1') NOT NULL default '1',
235 CHAT_EXTRAS enum('0','1') NOT NULL default '1',
236 EMAIL_USER enum('0','1') NOT NULL default '1',
237 BOT_HELLO varchar(100) NOT NULL default 'Hello People!!! Have you been missing me?',
238 BOT_BYE varchar(100) NOT NULL default 'Bye Bye everyone! See you when I see you...',
239 BOT_PUBLIC enum('0','1') NOT NULL default '1',
240 ENABLE_PM enum('0','1') NOT NULL default '1',
241 EN_ROOM1 enum('0','1','2') NOT NULL default '1',
242 EN_ROOM2 enum('0','1','2') NOT NULL default '1',
243 EN_ROOM3 enum('0','1','2') NOT NULL default '1',
244 EN_ROOM4 enum('0','1','2') NOT NULL default '1',
245 EN_ROOM5 enum('0','1','2') NOT NULL default '1',
246 EN_ROOM6 enum('0','1','2') NOT NULL default '1',
247 EN_ROOM7 enum('0','1','2') NOT NULL default '1',
248 EN_ROOM8 enum('0','1','2') NOT NULL default '1',
249 EN_ROOM9 enum('0','1','2') NOT NULL default '1',
250 CHAT_BOOT enum('0','1') NOT NULL default '1',
251 WELCOME_SOUND varchar(255) NOT NULL default 'sounds/hello.wav',
252 WORLDTIME enum('0','1','2') NOT NULL default '2',
253 UPD_CHECK enum('0','1') NOT NULL default '1',
254 QUOTE enum('0','1') NOT NULL default '1',
255 QUOTE_TIME tinyint(1) NOT NULL default '5',
256 QUOTE_COLOR varchar(25) NOT NULL default 'brown',
257 QUOTE_PATH varchar(255) NOT NULL default 'files/quotes/quotes_all.txt',
258 HIDE_ADMINS enum('0','1') NOT NULL default '0',
259 HIDE_MODERS enum('0','1') NOT NULL default '0',
260 LAST_SAVED_ON datetime NOT NULL default '0000-00-00 00:00:00',
261 LAST_SAVED_BY varchar(30) NOT NULL default 'installer (upgrade)',
262 CHAT_SYSTEM enum('standalone','phpnuke','phpbb') NOT NULL default 'standalone',
263 NUKE_BB_PATH varchar(255) NOT NULL default '',
264 CHAT_NAME varchar(255) NOT NULL default 'My WonderfulWorldWide Chat',
265 ENGLISH_FORMAT enum('UK','US') NOT NULL default 'UK',
266 FLAGS_3D enum('0','1') NOT NULL default '1',
267 ALLOW_REGISTER enum('0','1') NOT NULL default '1',
268 DISP_GENDER enum('0','1') NOT NULL default '0',
269 SPECIAL_GHOSTS varchar(255) NOT NULL default '',
270 FILLED_LOGIN enum('0','1') NOT NULL default '0',
271 BACKGR_IMG enum('0','1') NOT NULL default '0',
272 BACKGR_IMG_PATH varchar(255) NOT NULL default '',
273 POPUP_LINKS enum('0','1') NOT NULL default '0',
274 ITALICIZE_POWERS enum('0','1') NOT NULL default '1',
275 MAIL_GREETING varchar(255) NOT NULL default 'Best regards,',
276 PM_KEEP_DAYS tinyint(1) NOT NULL default '30',
277 ALLOW_PM_DEL enum('0','1') NOT NULL default '1',
278 LOGIN_COUNTER enum('0','1','60','1440','10080') NOT NULL default '60',
279 ALLOW_GRAVATARS enum('0','1','2') NOT NULL default '1',
280 GRAVATARS_CACHE enum('0','1') NOT NULL default '1',
281 GRAVATARS_CACHE_EXPIRE tinyint(1) NOT NULL default '7',
282 GRAVATARS_RATING enum('G','PG','R','X','ANY') NOT NULL default 'G',
283 GRAVATARS_DYNAMIC_DEF enum('mm','identicon','monsterid','wavatar','retro') default 'monsterid',
284 GRAVATARS_DYNAMIC_DEF_FORCE enum('0','1') NOT NULL default '0',
285 ALLOW_UPLOADS enum('0','1') NOT NULL default '0',
286 RES_ROOM1 enum('0','1') NOT NULL default '0',
287 RES_ROOM2 enum('0','1') NOT NULL default '0',
288 RES_ROOM3 enum('0','1') NOT NULL default '0',
289 RES_ROOM4 enum('0','1') NOT NULL default '0',
290 RES_ROOM5 enum('0','1') NOT NULL default '0',
291 EN_STATS enum('0','1') NOT NULL default '0',
292 ALLOW_VIDEO enum('0','1','2') NOT NULL default '1',
293 VIDEO_WIDTH smallint(1) NOT NULL default '425',
294 VIDEO_HEIGHT smallint(1) NOT NULL default '344',
295 REQUIRE_BDAY enum('0','1') NOT NULL default '0',
296 SEND_BDAY_EMAIL enum('0','1') NOT NULL default '0',
297 SEND_BDAY_TIME tinyint(1) NOT NULL default '0',
298 SEND_BDAY_INTVAL tinyint(1) NOT NULL default '7',
299 SEND_BDAY_PATH varchar(255) NOT NULL default 'files/birthday/bday_greetings.txt',
300 EN_WMPLAYER enum('0','1','2') NOT NULL default '0',
301 WMP_STREAM varchar(255) default NULL,
302 OPEN_ALL_BEG time NOT NULL default '00:00:00',
303 OPEN_ALL_END time NOT NULL default '00:00:00',
304 OPEN_SUN_BEG time NOT NULL default '00:00:00',
305 OPEN_SUN_END time NOT NULL default '00:00:00',
306 OPEN_MON_BEG time NOT NULL default '00:00:00',
307 OPEN_MON_END time NOT NULL default '00:00:00',
308 OPEN_TUE_BEG time NOT NULL default '00:00:00',
309 OPEN_TUE_END time NOT NULL default '00:00:00',
310 OPEN_WED_BEG time NOT NULL default '00:00:00',
311 OPEN_WED_END time NOT NULL default '00:00:00',
312 OPEN_THU_BEG time NOT NULL default '00:00:00',
313 OPEN_THU_END time NOT NULL default '00:00:00',
314 OPEN_FRI_BEG time NOT NULL default '00:00:00',
315 OPEN_FRI_END time NOT NULL default '00:00:00',
316 OPEN_SAT_BEG time NOT NULL default '00:00:00',
317 OPEN_SAT_END time NOT NULL default '00:00:00',
318 ALLOW_TEXT_COLORS enum('0','1') NOT NULL default '1',
319 TAGS_POWERS set('b','i','u') default NULL,
320 ALLOW_MATH enum('0','1') NOT NULL default '0',
321 SRC_MATH varchar(255) NOT NULL default 'http://cdn.mathjax.org/mathjax/latest/MathJax.js?config=TeX-AMS-MML_HTMLorMML',
322 USE_FLAGS enum('0','1') NOT NULL default '1',
323 SHOW_FLAGS enum('0','1') NOT NULL default '1',
324 NOTIFY_SOUND varchar(255) NOT NULL default 'sounds/notify.wav',
325 PRIMARY KEY (ID)
326) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
327
328INSERT INTO c_config (id, MODS, INSTALL_DATE, QUICKA, QUICKM, QUICKU, LAST_SAVED_ON, CHAT_SYSTEM, ALLOW_TEXT_COLORS) VALUES ('0', 'Advanced Admin, (GR)Avatars, Smilies Popup, Color Drop Box, Private Popup,<br />Quick Menu, Logs Archive, Lurking, Color names, WorldTime, UTF-8, Birthdays, MathJax', NOW(), 'Greetings|\r\nWelcome|\r\nThanks for coming by|\r\nLoL|\r\n:rofl|\r\n/announce I have to go now!|\r\n/away be right back...|\r\n/away ...I\'m back!|\r\n/bot start|\r\n/bot stop|\r\n/buzz|\r\n/buzz ~chimeup|\r\n/me is busy right now!|\r\n/mr is watching TV|\r\n/bye See you around!|\r\n/high user|\r\n/join 0 #%s|\r\n/join 1 #%s|\r\n/invite %s|\r\n/img http://www.path_to_image|\r\n/promote %s|\r\n/demote %s|\r\n/demote * %s|\r\n/room Please follow the topic|\r\n/size 12|\r\n/size|\r\n/sort|\r\n/topic |\r\n/topic reset|\r\n/video url_to_video|\r\n/wisp %s Hey, in which room ru?|\r\n/whois %s', 'Greetings|\r\nWelcome|\r\nThanks for coming by|\r\nLoL|\r\n:rofl|\r\n/away be right back...|\r\n/away ...I\'m back!|\r\n/buzz|\r\n/buzz ~chimeup|\r\n/me is busy right now!|\r\n/mr is reading|\r\n/bye cyall!|\r\n/high %s|\r\n/join 0 #%s|\r\n/join 1 #%s|\r\n/invite %s|\r\n/img http://www.path_to_image|\r\n/promote %s|\r\n/room Please follow the topic|\r\n/size 12|\r\n/size|\r\n/sort|\r\n/topic |\r\n/topic reset|\r\n/video url_to_video|\r\n/wisp %s Hey, in which room ru?|\r\n/whois %s', 'Hello everyone|\r\nlol|\r\n:rofl|\r\n/away brb...|\r\n/away ...back!|\r\n/me is busy!|\r\n/mr is lurking|\r\n/bye ttyl!|\r\n/high %s|\r\n/join 0 #%s|\r\n/join 1 #%s|\r\n/invite %s|\r\n/img http://www.path_to_image|\r\n/size 12|\r\n/size|\r\n/sort|\r\n/wisp %s Hey, in which room ru?|\r\n/whois %s', NOW(), 'standalone', '1');
329
330DROP TABLE IF EXISTS c_lurkers;
331CREATE TABLE c_lurkers (
332 time int(15) NOT NULL default '0',
333 ip varchar(100) NOT NULL default '',
334 browser varchar(255) NOT NULL default '',
335 file varchar(50) NOT NULL default '',
336 username varchar(30) NOT NULL default '',
337 status varchar(1) NOT NULL default '',
338 country_code varchar(3) NOT NULL default '',
339 country_name varchar(100) NOT NULL default '',
340 PRIMARY KEY (time),
341 KEY ip (ip),
342 KEY file (file)
343) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
344
345DROP TABLE IF EXISTS c_messages;
346CREATE TABLE c_messages (
347 type tinyint(1) NOT NULL default '0',
348 room varchar(30) NOT NULL default '',
349 username varchar(30) NOT NULL default '',
350 latin1 tinyint(1) NOT NULL default '0',
351 m_time int(11) NOT NULL default '0',
352 address varchar(30) NOT NULL default '',
353 message text NOT NULL,
354 pm_read varchar(19) NOT NULL default '',
355 room_from varchar(30) NOT NULL default ''
356) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
357
358DROP TABLE IF EXISTS c_reg_users;
359CREATE TABLE c_reg_users (
360 id int(11) NOT NULL default '0',
361 cid int(11) NOT NULL auto_increment,
362 username varchar(30) NOT NULL default '',
363 latin1 tinyint(1) NOT NULL default '0',
364 password varchar(32) NOT NULL default '',
365 firstname varchar(64) NOT NULL default '',
366 lastname varchar(64) NOT NULL default '',
367 country varchar(64) NOT NULL default '',
368 website varchar(64) NOT NULL default '',
369 email varchar(64) NOT NULL default '',
370 showemail tinyint(1) NOT NULL default '0',
371 perms varchar(9) NOT NULL default '',
372 rooms varchar(128) NOT NULL default '',
373 reg_time int(11) NOT NULL default '0',
374 ip varchar(100) NOT NULL default '',
375 gender tinyint(1) NOT NULL default '0',
376 allowpopup tinyint(1) NOT NULL default '1',
377 picture varchar(255) NOT NULL default '',
378 description text NOT NULL,
379 favlink varchar(255) NOT NULL default '',
380 favlink1 varchar(255) NOT NULL default '',
381 slang varchar(255) NOT NULL default '',
382 colorname varchar(25) NOT NULL default '',
383 avatar varchar(255) NOT NULL default 'images/avatars/def_avatar.gif',
384 s_question enum('0','1','2','3','4') NOT NULL default '0',
385 s_answer varchar(64) NOT NULL default '',
386 last_login int(11) NOT NULL default '0',
387 login_counter bigint(20) NOT NULL default '0',
388 use_gravatar enum('0','1') NOT NULL default '0',
389 join_room varchar(5) NOT NULL default '',
390 birthday date default NULL,
391 show_bday enum('0','1') NOT NULL default '1',
392 show_age enum('0','1') NOT NULL default '1',
393 bday_email_sent int(11) NOT NULL default '0',
394 country_code varchar(3) NOT NULL default '',
395 country_name varchar(100) NOT NULL default '',
396 PRIMARY KEY (cid),
397 UNIQUE KEY username (username)
398) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
399
400INSERT INTO c_reg_users VALUES ('', '1', 'admin', '0', '21232f297a57a5a743894a0e4a801fc3', '', '', '', '', '', 0, 'admin', '', '', '', 0, 1, '', '', 'http://sourceforge.net/projects/phpmychat', 'http://ciprianmp.com/plus', '', 'red', 'images/avatars/def_avatar.gif', '0', '', '', '', '', '', '', '', '', '', '', '');
401INSERT INTO c_reg_users VALUES ('', '2', 'plusbot', '0', '3901e4a6c3d27909afef4c22f8337da8', 'Bot', 'phpMyChat - Plus', 'WorldWideWeb', '', 'bot@bot.com', '0', 'topmod', '', 1130763311, '-No tracking IP-', '1', '0', 'images/alice.gif', 'I am a Robot originally called <a href=http://www.alicebot.org/documentation/ target=_blank>Alice</a>. I am proud to be the first Artificial Intelligence on the net! Please test my capabilities as you wish! To start a public conversation with me just type "hello myname" in the room I am active in, to stop the conversation type "bye myname" or "myname> bye". But we can also talk in private - just click on my name whenever you need a shoulder to cry on :p Ohhh... I wish to express my gratitude to Roy, Popeye and <a href=http://www.ciprianmp.com/plus/ target=_blank>Ciprian</a> for making me available for chatting in here. :)', 'http://www.alicebot.org/documentation/', 'http://sourceforge.net/forum/?group_id=43190', 'English, German', 'olive', 'images/avatars/bot_avatar.gif', '0', '', '', '', '', '', '', '', '', '', '', '');
402INSERT INTO c_reg_users VALUES ('', '3', 'Random_Quote', '0', 'ef93e0948b007826a1a7a49a17b72a59', 'Random Quote', 'phpMyChat - Plus', 'WorldWideWeb', '', 'quote@quote.com', '0', 'topmod', '', 1130763311, '-No tracking IP-', '1', '0', 'images/avatars/avatar56.gif', 'I am a virtual user, added here to post random quotes at my admin’s will. Ohhh... I wish to express my gratitude to <a href=http://www.ciprianmp.com/plus/ target=_blank>Ciprian</a> for making me available for enlighting you in here. :)', 'http://sourceforge.net/projects/phpmychat', 'http://ciprianmp.com/plus', 'English (any actually)', 'limegreen', 'images/avatars/quote_avatar.gif', '0', '', '', '', '', '', '', '', '', '', '', '');
403
404DROP TABLE IF EXISTS c_stats;
405CREATE TABLE IF NOT EXISTS c_stats (
406 stat_date date NOT NULL,
407 room varchar(30) DEFAULT NULL,
408 username varchar(30) DEFAULT NULL,
409 reguser enum('0','1') NOT NULL DEFAULT '0',
410 last_in int(11) NOT NULL DEFAULT '0',
411 seconds_in int(11) NOT NULL DEFAULT '0',
412 longest_in int(11) NOT NULL DEFAULT '0',
413 last_away int(11) NOT NULL DEFAULT '0',
414 seconds_away int(11) NOT NULL DEFAULT '0',
415 longest_away int(11) NOT NULL DEFAULT '0',
416 times_away tinyint(4) NOT NULL DEFAULT '0',
417 logins smallint(5) NOT NULL DEFAULT '0',
418 posts_sent smallint(5) NOT NULL DEFAULT '0',
419 pms_sent smallint(5) NOT NULL DEFAULT '0',
420 cmds_used smallint(5) NOT NULL DEFAULT '0',
421 profile_viewed smallint(5) NOT NULL DEFAULT '0',
422 profiles_checked smallint(5) NOT NULL DEFAULT '0',
423 imgs_posted smallint(5) NOT NULL DEFAULT '0',
424 urls_posted smallint(5) NOT NULL DEFAULT '0',
425 emails_posted smallint(5) NOT NULL DEFAULT '0',
426 swears_posted smallint(5) NOT NULL DEFAULT '0',
427 smilies_posted smallint(5) NOT NULL DEFAULT '0',
428 bans_rcvd tinyint(4) NOT NULL DEFAULT '0',
429 bans_sent tinyint(4) NOT NULL DEFAULT '0',
430 kicks_rcvd tinyint(4) NOT NULL DEFAULT '0',
431 kicks_sent tinyint(4) NOT NULL DEFAULT '0',
432 vids_posted smallint(5) NOT NULL DEFAULT '0',
433 maths_posted smallint(5) NOT NULL DEFAULT '0',
434 ip varchar(100) NOT NULL default '',
435 country_code varchar(3) NOT NULL default '',
436 country_name varchar(100) NOT NULL default ''
437) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
438
439DROP TABLE IF EXISTS c_users;
440CREATE TABLE c_users (
441 room varchar(30) NOT NULL default '',
442 username varchar(30) NOT NULL default '',
443 latin1 tinyint(1) NOT NULL default '0',
444 u_time int(11) NOT NULL default '0',
445 status char(1) NOT NULL default '',
446 ip varchar(100) NOT NULL default '',
447 awaystat char(1) NOT NULL default '0',
448 r_time int(11) NOT NULL default '0',
449 email varchar(64) NOT NULL default '',
450 country_code varchar(3) NOT NULL default '',
451 country_name varchar(100) NOT NULL default '',
452 UNIQUE KEY room (room,username)
453) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;