· 9 years ago · Feb 04, 2017, 11:26 AM
1[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
2
3
4-- ----------------------------
5-- Event structure for `daily_respect_poi' at line 1
6[Err] CREATE TABLE `user_wardrobe` (
7 `id` int(11) NOT NULL AUTO_INCREMENT,
8 `user_id` int(10) unsigned NOT NULL,
9 `slot_id` int(10) unsigned NOT NULL,
10 `look` varchar(120) NOT NULL,
11 `gender` enum('F','M') NOT NULL DEFAULT 'M',
12 PRIMARY KEY (`id`),
13 KEY `user_id` (`user_id`) USING BTREE,
14 KEY `slot_id` (`slot_id`)
15) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=latin1;
16
17-- ----------------------------
18-- Records of user_wardrobe
19-- ----------------------------
20
21-- ----------------------------
22-- Table structure for `wired_items`
23-- ----------------------------
24DROP TABLE IF EXISTS `wired_items`;
25CREATE TABLE `wired_items` (
26 `id` int(11) NOT NULL,
27 `items` varchar(5000) NOT NULL,
28 `delay` int(11) NOT NULL,
29 `string` varchar(5000) NOT NULL,
30 `bool` enum('0','1') NOT NULL DEFAULT '0',
31 PRIMARY KEY (`id`),
32 UNIQUE KEY `id` (`id`)
33) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34
35-- ----------------------------
36-- Records of wired_items
37-- ----------------------------
38
39-- ----------------------------
40-- Table structure for `wordfilter`
41-- ----------------------------
42DROP TABLE IF EXISTS `wordfilter`;
43CREATE TABLE `wordfilter` (
44 `word` varchar(100) NOT NULL,
45 `replacement` varchar(255) NOT NULL DEFAULT '("****")',
46 `strict` enum('1','0') NOT NULL DEFAULT '1',
47 `addedby` varchar(100) NOT NULL DEFAULT '',
48 `bannable` enum('0','1') NOT NULL DEFAULT '0',
49 PRIMARY KEY (`word`),
50 UNIQUE KEY `word` (`word`)
51) ENGINE=InnoDB DEFAULT CHARSET=latin1;
52
53-- ----------------------------
54-- Records of wordfilter
55-- ----------------------------
56INSERT INTO `wordfilter` VALUES ('. c o m', '(\"*Verboden woord*\")', '1', '', '0');
57INSERT INTO `wordfilter` VALUES ('.be', '(\"*Verboden woord*\")', '1', '', '0');
58INSERT INTO `wordfilter` VALUES ('.c0m', '(\"*Verboden woord*\")', '1', '', '0');
59INSERT INTO `wordfilter` VALUES ('.com', '(\"*Verboden woord*\")', '1', '', '0');
60INSERT INTO `wordfilter` VALUES ('.cqm', '(\"*Verboden woord*\")', '1', '', '0');
61INSERT INTO `wordfilter` VALUES ('.de', '(\"*Verboden woord*\")', '1', '', '0');
62INSERT INTO `wordfilter` VALUES ('.eu', '(\"*Verboden woord*\")', '1', '', '0');
63INSERT INTO `wordfilter` VALUES ('.home', '(\"*Verboden woord*\")', '1', '', '0');
64INSERT INTO `wordfilter` VALUES ('.io', '(\"*Verboden woord*\")', '1', '', '0');
65INSERT INTO `wordfilter` VALUES ('.me', '(\"*Verboden woord*\")', '1', '', '0');
66INSERT INTO `wordfilter` VALUES ('.net', '(\"*Verboden woord*\")', '1', '', '0');
67INSERT INTO `wordfilter` VALUES ('.nl', '(\"*Verboden woord*\")', '1', '', '0');
68INSERT INTO `wordfilter` VALUES ('.tk', '(\"*Verboden woord*\")', '1', '', '0');
69INSERT INTO `wordfilter` VALUES ('.ws', '(\"*Verboden woord*\")', '1', '', '0');
70INSERT INTO `wordfilter` VALUES ('178.18.93.224', '* Ban me *', '1', '', '1');
71INSERT INTO `wordfilter` VALUES ('bobbahotel', '(\"*Verboden woord*\")', '1', '', '0');
72INSERT INTO `wordfilter` VALUES ('D o x', '(\"*Verboden woord*\")', '1', '', '0');
73INSERT INTO `wordfilter` VALUES ('D0x', '(\"*Verboden woord*\")', '1', '', '0');
74INSERT INTO `wordfilter` VALUES ('Dox', '(\"*Verboden woord*\")', '1', '', '0');
75INSERT INTO `wordfilter` VALUES ('drabbo', '(\"*Verboden woord*\")', '1', '', '0');
76INSERT INTO `wordfilter` VALUES ('gay', '(\"****\")', '1', '', '0');
77INSERT INTO `wordfilter` VALUES ('h0er', '(\"****\")', '1', '', '0');
78INSERT INTO `wordfilter` VALUES ('hadd0', '(\"*Verboden woord*\")', '1', '', '0');
79INSERT INTO `wordfilter` VALUES ('haddo', '(\"*Verboden woord*\")', '1', '', '0');
80INSERT INTO `wordfilter` VALUES ('haddo.nl', '(\"*Verboden woord*\")', '1', '', '0');
81INSERT INTO `wordfilter` VALUES ('hoe.r', '(\"****\")', '1', '', '0');
82INSERT INTO `wordfilter` VALUES ('hoer', '(\"****\")', '1', '', '0');
83INSERT INTO `wordfilter` VALUES ('hoeren', '(\"****\")', '1', '', '0');
84INSERT INTO `wordfilter` VALUES ('hoertjes', '(\"****\")', '1', '', '0');
85INSERT INTO `wordfilter` VALUES ('homo', '(\"****\")', '1', '', '0');
86INSERT INTO `wordfilter` VALUES ('kanker', '(\"****\")', '1',
87[Msg] Finished - Unsuccessfully
88--------------------------------------------------