9YPB1Gcr

1UPDATE `players`
2SET `cop_licenses` = replace(cop_licenses, '``', '`'),
3`aliases` = replace(aliases, '``', '`'),
4`cop_gear` = replace(cop_gear, '``', '`')
5WHERE `cop_licenses` LIKE '"[[``%';
6
7UPDATE `players`
8SET `civ_licenses` = replace(civ_licenses, '``', '`'),
9`civ_gear` = replace(civ_gear, '``', '`'),
10`aliases` = replace(aliases, '``', '`')
11WHERE `civ_licenses` LIKE '"[[``%';
12
13UPDATE `players`
14SET `med_licenses` = replace(med_licenses, '``', '`'),
15`aliases` = replace(aliases, '``', '`'),
16`med_gear` = replace(med_gear, '``', '`')
17WHERE `med_licenses` LIKE '"[[``%';
18
19UPDATE `gangs`
20SET `members` = replace(members, '``', '`')
21WHERE `members` LIKE '"[``%';
22
23UPDATE `containers`
24SET `gear` = replace(gear, '``', '`')
25WHERE `gear` LIKE '"[[``%';
26
27UPDATE `containers`
28SET `inventory` = replace(inventory, '``', '`')
29WHERE `inventory` LIKE '"[[[``%';
30
31UPDATE `vehicles`
32SET `gear` = replace(gear, '``', '`')
33WHERE `gear` LIKE '"[[``%';
34
35UPDATE `vehicles`
36SET `inventory` = replace(inventory, '``', '`')
37WHERE `inventory` LIKE '"[[[``%';
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54---- Also
55
56
57CREATE TABLE IF NOT EXISTS `messages` (
58`uid` int(12) NOT NULL AUTO_INCREMENT,
59`fromID` varchar(50) NOT NULL,
60`toID` varchar(50) NOT NULL,
61`message` text,
62`fromName` varchar(32) NOT NULL,
63`toName` varchar(32) NOT NULL,
64`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
65PRIMARY KEY (`uid`)
66) ENGINE=InnoDB DEFAULT CHARSET=latin1;
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84--- Also
85
86CREATE TABLE `dynmarket` (
87`id` INT NOT NULL DEFAULT 1,
88`prices` TEXT NOT NULL,
89PRIMARY KEY (`id`));
90INSERT INTO `dynmarket` VALUES (1,'[]');