📄 database.sql
字号:
--
-- Gegevens worden uitgevoerd voor tabel `[online]`
--
-- --------------------------------------------------------
--
-- Tabel structuur voor tabel `[orgcrime]`
--
CREATE TABLE `[orgcrime]` (
`id` int(100) NOT NULL auto_increment,
`name1` varchar(100) default NULL,
`name2` varchar(100) default NULL,
`name3` varchar(100) default NULL,
`name4` varchar(100) default NULL,
`WEA` int(1) NOT NULL default '0',
`BEA` int(1) NOT NULL default '0',
`DRA` int(1) NOT NULL default '0',
`wapens` varchar(100) NOT NULL default '',
`kogels` int(100) NOT NULL default '0',
`bommen` varchar(100) NOT NULL default '',
`aantal` int(100) NOT NULL default '0',
`auto` varchar(100) NOT NULL default '',
`klaar` int(1) NOT NULL default '0',
`autoid` int(255) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Gegevens worden uitgevoerd voor tabel `[orgcrime]`
--
-- --------------------------------------------------------
--
-- Tabel structuur voor tabel `[temp]`
--
CREATE TABLE `[temp]` (
`id` int(16) NOT NULL auto_increment,
`time` datetime default NULL,
`login` varchar(16) default NULL,
`IP` varchar(32) default NULL,
`forwardedFor` varchar(32) default NULL,
`code` int(10) unsigned NOT NULL default '0',
`area` varchar(32) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=70 ;
--
-- Gegevens worden uitgevoerd voor tabel `[temp]`
--
-- --------------------------------------------------------
--
-- Tabel structuur voor tabel `[users]`
--
CREATE TABLE `[users]` (
`id` int(4) NOT NULL auto_increment,
`signup` datetime default NULL,
`login` varchar(50) default NULL,
`pass` varchar(32) default NULL,
`level` int(3) NOT NULL default '1',
`IP` varchar(32) default NULL,
`email` varchar(64) default NULL,
`url` varchar(128) NOT NULL default '',
`info` text NOT NULL,
`music` varchar(225) NOT NULL default 'http://www.worldcrime.nl/Akcent - Kylie.mp3',
`cash` int(9) NOT NULL default '10000',
`bank` int(9) NOT NULL default '2500',
`lotto` int(1) NOT NULL default '1',
`attack` int(6) NOT NULL default '0',
`defence` int(6) NOT NULL default '0',
`bonus` text NOT NULL,
`missie` int(5) NOT NULL default '1',
`bullets` int(11) NOT NULL default '10',
`smstegoed` int(5) NOT NULL default '30',
`City` varchar(128) NOT NULL default 'California',
`Citynumb` int(1) NOT NULL default '1',
`showonline` int(1) NOT NULL default '1',
`online` datetime NOT NULL default '0000-00-00 00:00:00',
`activated` int(1) NOT NULL default '1',
`Knife` int(5) NOT NULL default '0',
`Walter P99` int(5) NOT NULL default '0',
`Uzi` int(5) NOT NULL default '0',
`MP5k` int(5) NOT NULL default '0',
`Flashbang` int(5) NOT NULL default '0',
`Granaat` int(5) NOT NULL default '0',
`Shotgun` int(5) NOT NULL default '0',
`G36C` int(5) NOT NULL default '0',
`SIG 552` int(5) NOT NULL default '0',
`Ak47` int(5) NOT NULL default '0',
`Ak Beta` int(5) NOT NULL default '0',
`Scherpschut geweer` int(5) NOT NULL default '0',
`Granaat Lanceerder` int(5) NOT NULL default '0',
`Bazooka` int(5) NOT NULL default '0',
`Kogelvrij vest` int(5) NOT NULL default '0',
`Bulldog` int(5) NOT NULL default '0',
`Camera` int(5) NOT NULL default '0',
`Hek` int(5) NOT NULL default '0',
`Muur` int(5) NOT NULL default '0',
`Bunker` int(5) NOT NULL default '0',
`Mobieltje` int(1) NOT NULL default '1',
`FN P90` int(5) NOT NULL default '0',
`Chip` int(5) NOT NULL default '0',
`Helm` int(5) NOT NULL default '0',
`Politie wagen` int(5) NOT NULL default '0',
`IPs` text NOT NULL,
`blocklist` text NOT NULL,
`recruiters` int(26) NOT NULL default '0',
`Scorpion` int(5) NOT NULL default '0',
`Tigher` int(5) NOT NULL default '0',
`Hellbender` int(5) NOT NULL default '0',
`Bankpas` int(5) NOT NULL default '0',
`PIN` int(4) NOT NULL default '1234',
`avatar` varchar(225) NOT NULL default 'http://worldcrime.nl/images/no.gif',
`change` int(2) NOT NULL default '2',
`health` int(5) NOT NULL default '100',
`GoliathTank` int(5) NOT NULL default '0',
`Shield` int(5) NOT NULL default '0',
`drug1` int(11) NOT NULL default '0',
`drug2` int(11) NOT NULL default '0',
`drug3` int(11) NOT NULL default '0',
`drug4` int(11) NOT NULL default '0',
`drug5` int(11) NOT NULL default '0',
`drug6` int(11) NOT NULL default '0',
`strength` int(11) NOT NULL default '0',
`won` int(11) NOT NULL default '0',
`lost` int(11) NOT NULL default '0',
`gstart` int(1) NOT NULL default '0',
`orgtime` datetime NOT NULL default '0000-00-00 00:00:00',
`land` varchar(225) NOT NULL default 'Onbekend',
`woonplaats` varchar(225) NOT NULL default 'Onbekend',
`realname` varchar(225) NOT NULL default 'Onbekend',
`age` int(11) NOT NULL default '0',
`opdruktijd` datetime NOT NULL default '0000-00-00 00:00:00',
`opdruktijd1` int(200) NOT NULL default '0',
`m1` int(50) NOT NULL default '0',
`misdaad` datetime NOT NULL default '0000-00-00 00:00:00',
`m2` int(10) NOT NULL default '0',
`m3` int(10) NOT NULL default '0',
`m4` int(10) NOT NULL default '0',
`m5` int(10) NOT NULL default '0',
`m6` int(10) NOT NULL default '0',
`codechecker` int(50) NOT NULL default '0',
`Apache` int(5) NOT NULL default '0',
`posts` int(50) NOT NULL default '0',
`postdate` datetime NOT NULL default '0000-00-00 00:00:00',
`auto` datetime NOT NULL default '0000-00-00 00:00:00',
`weapon` int(2) NOT NULL default '0',
`protection` int(2) NOT NULL default '0',
`messages` int(225) NOT NULL default '0',
`recruiter` varchar(225) NOT NULL default '',
`octime` datetime NOT NULL default '0000-00-00 00:00:00',
`OCstatus` int(1) NOT NULL default '0',
`testament` varchar(255) NOT NULL default '',
`a1` int(10) NOT NULL default '0',
`a2` int(10) NOT NULL default '0',
`a3` int(10) NOT NULL default '0',
`a4` int(10) NOT NULL default '0',
`a5` int(10) NOT NULL default '0',
`burg` varchar(255) NOT NULL default 'Onbekend',
`gevangenis` datetime NOT NULL default '0000-00-00 00:00:00',
`gevangenistijd` int(250) NOT NULL default '0',
`drank1` int(11) NOT NULL default '0',
`drank2` int(11) NOT NULL default '0',
`drank3` int(11) NOT NULL default '0',
`drank4` int(11) NOT NULL default '0',
`drank5` int(11) NOT NULL default '0',
`drank6` int(11) NOT NULL default '0',
`faminvite` varchar(255) NOT NULL default '',
`capoinvite` varchar(255) NOT NULL default '',
`family` varchar(255) NOT NULL default '',
`capo` varchar(255) NOT NULL default '',
`famleader` int(1) NOT NULL default '0',
`famsotto` int(1) NOT NULL default '0',
`famconsig` int(1) NOT NULL default '0',
`honourpoints` int(225) NOT NULL default '0',
`maxpoints` int(225) NOT NULL default '150',
`hulpadmin` int(2) NOT NULL default '0',
`type` int(2) NOT NULL default '1',
`rankpoint` int(6) NOT NULL default '0',
`werken` datetime NOT NULL default '0000-00-00 00:00:00',
`werken1` int(255) NOT NULL default '5',
`profiel` text NOT NULL,
`profielv` int(5) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `login` (`login`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=70 ;
--
-- Gegevens worden uitgevoerd voor tabel `[users]`
--
-- --------------------------------------------------------
--
-- Tabel structuur voor tabel `[weapons]`
--
CREATE TABLE `[weapons]` (
`id` int(4) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`area` int(2) default NULL,
`costs` int(7) default NULL,
`url` varchar(40) default NULL,
`attack` int(5) default NULL,
`defence` int(5) default NULL,
`max` text,
`eval` text,
`error` text,
`extra` text,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `area` (`area`)
) TYPE=MyISAM AUTO_INCREMENT=58 ;
--
-- Gegevens worden uitgevoerd voor tabel `[weapons]`
--
INSERT INTO `[weapons]` VALUES (1, 'Knife', 1, 2000, 'item-Knife', 20, 20, '1 per $type_s (You have $num $type_p who haven''t got a Knife)', '$num = $data->clicks-$data->{''Knife''}; return $num;', 'All your $type_s already have a Knife.', NULL);
INSERT INTO `[weapons]` VALUES (35, 'Scorpion', 12, 60000, 'item-Scorpion', 1300, 730, '1 per $type_s (You have $num $type_p who havent got this weapon)', '$num = $data->clicks-$data->Scorpion; return $num;', 'All your $type_p have a Scorpion', '');
INSERT INTO `[weapons]` VALUES (2, 'Walter P99', 1, 5000, 'item-Walter_P99', 50, 50, '1 per $type_s (You have $num $type_p who haven''t got a Walter P99)', '$num = $data->clicks-$data->{''Walter P99''}; return $num;', 'All your $type_p already have a Walter P99', NULL);
INSERT INTO `[weapons]` VALUES (3, 'Uzi', 1, 6000, 'item-Uzi', 65, 65, '1 per $type_s (You have $num $type_p who haven''t got a Uzi)', '$num = $data->clicks-$data->Uzi; return $num;', 'All of your $type_p already have an Uzi.', NULL);
INSERT INTO `[weapons]` VALUES (4, 'Flashbang', 1, 10000, 'item-Flashbang', 110, 110, '1 per $type_s (Je hebt $num $type_p die deze granaat nog niet hebben)', '$num = $data->clicks-$data->Flashbang; return $num;', 'Al je $type_p hebben al een flashbang', NULL);
INSERT INTO `[weapons]` VALUES (5, 'Granaat', 1, 15000, 'item-Grenade', 170, 170, '1 per $type_s (Je hebt $num $type_p die deze granaat nog niet hebben)', '$num = $data->clicks-$data->Granaat; return $num;', 'Al je $type_p hebben al een granaat', NULL);
INSERT INTO `[weapons]` VALUES (6, 'MP5k', 1, 7500, 'item-MP5k', 80, 80, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL);
INSERT INTO `[weapons]` VALUES (7, 'Shotgun', 1, 17500, 'item-Shotgun', 200, 200, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL);
INSERT INTO `[weapons]` VALUES (8, 'G36C', 1, 22500, 'item-G36C', 270, 270, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL);
INSERT INTO `[weapons]` VALUES (9, 'SIG 552', 1, 25000, 'item-SIG_552', 310, 310, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL);
INSERT INTO `[weapons]` VALUES (10, 'Ak47', 1, 30000, 'item-Ak47', 390, 390, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL);
INSERT INTO `[weapons]` VALUES (11, 'Ak Beta', 1, 40000, 'item-Ak_Beta', 570, 570, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL);
INSERT INTO `[weapons]` VALUES (12, 'Scherpschut geweer', 1, 45000, 'item-Sniper_rifle', 670, 670, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL);
INSERT INTO `[weapons]` VALUES (13, 'M4', 1, 50000, 'item-M4', 780, 780, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL);
INSERT INTO `[weapons]` VALUES (14, 'Granaat Lanceerder', 1, 60000, 'item-Grenade_Launcher', 1030, 1030, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL);
INSERT INTO `[weapons]` VALUES (15, 'Bazooka', 1, 75000, 'item-Bazooka', 1490, 1490, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL);
INSERT INTO `[weapons]` VALUES (16, 'Kogelvrij vest', 2, 12500, 'item-Bulletproof_vest', 140, 140, '1 per $type_s (Je hebt $num $type_p die dit vest nog niet hebben)', '$num = $data->clicks-$data->{''Kogelvrij vest''}; return $num;', 'Je hebt geen $type_s die dit vest kan dragen', NULL);
INSERT INTO `[weapons]` VALUES (17, 'Bulldog', 3, 2500, 'item-Bulldog', 0, 30, '5 (Je kan nog $num honden meer hebben)', '$num = 5-$data->Bulldog; return $num;', 'Je hebt al 5 honden', NULL);
INSERT INTO `[weapons]` VALUES (18, 'Camera', 3, 8000, 'item-Cam', 0, 90, '7 (Je kan nog $num cameras plaatsen)', '$num = 7-$data->Camera; return $num;', 'Je hebt al 7 cameras', NULL);
INSERT INTO `[weapons]` VALUES (19, 'Hek', 3, 15000, 'item-Barbed_wire', 0, 170, '3 (Je kan nog $num hekken neerzetten)', '$num = 3-$data->Hek; return $num;', 'Je hebt al 3 hekken', NULL);
INSERT INTO `[weapons]` VALUES (20, 'Muur', 3, 20000, 'item-Stone_wall', 0, 240, '3 (Je kan nog $num muren bouwen)', '$num = 3-$data->Muur; return $num;', 'Je hebt al 3 muren', NULL);
INSERT INTO `[weapons]` VALUES (21, 'Bunker', 3, 35000, 'item-Bunker', 0, 470, '5 (Je kan nog $num bunkers bouwen)', '$num = 5-$data->Bunker; return $num;', 'Je hebt al 5 bunkers', NULL);
INSERT INTO `[weapons]` VALUES (22, 'Mobieltje', 4, 1000, 'item-Cellphone', NULL, NULL, '1 (Je kan nog $num mobieltjes kopen)', '$num = 1-$data->Mobieltje; return $num;', 'Je hebt al een mobieltje', 'Als je een mobiel hebt kun je berichten versturen en ontvangen');
INSERT INTO `[weapons]` VALUES (23, 'FN P90', 5, 50000, 'item-FN_P90', 900, 900, '1 per junkie (Je hebt nog $num junkies die dit wapen kunnen dragen)', '$num = $data->clicks-$data->{''FN P90''}; return $num;', 'Al je junkies hebben dit wapen al', NULL);
INSERT INTO `[weapons]` VALUES (24, 'Chip', 6, 25000, 'item-Chip', 400, 400, '1 per kloon (Je hebt $num klonen die nog geen chip hebben)', '$num = $data->clicks-$data->Chip; return $num;', 'Al je klonen hebben al een chip in hun hoofd', NULL);
INSERT INTO `[weapons]` VALUES (25, 'Helm', 7, 20000, 'item-Helmet', 240, 240, '1 per agent (Je hebt nog $num agenten zonder helm)', '$num = $data->clicks-$data->Helm; return $num;', 'Elke agent heeft al een helm', NULL);
INSERT INTO `[weapons]` VALUES (26, 'Politie wagen', 7, 35000, 'item-Police_car', 470, 470, '1 per agent (Je kan nog $num wagens kopen)', '$num = $data->clicks-$data->{''Politie wagen''}; return $num;', 'Elke agent heeft al een wagen', NULL);
INSERT INTO `[weapons]` VALUES (27, 'Home', 8, 25000, 'item-Home', NULL, NULL, '100m<sup>2</sup> (Je hebt nog ${num}m<sup>2</sup>)', '$num = $clan->land-($clan->homes*100+$clan->money_lvl2*500+$clan->money_lvl3*200+$clan->def_lvl1*100+$clan->def_lvl2*25+$clan->def_lvl3*150); $num -= ($clan->type == 3) ? 0 : $clan->money_lvl1*100; return ($num >= 100) ? 1 : 0;', 'Je hebt niet genoeg land om een huis te bouwen', 'In ieder huis kunnen 5 clan-members');
INSERT INTO `[weapons]` VALUES (28, 'Wall', 8, 50000, 'item-Stone_wall', NULL, 3000, '100m<sup>2</sup> (Je hebt nog ${num}m<sup>2</sup>)', '$num = $clan->land-($clan->homes*100+$clan->money_lvl2*500+$clan->money_lvl3*200+$clan->def_lvl1*100+$clan->def_lvl2*25+$clan->def_lvl3*150); $num -= ($clan->type == 3) ? 0 : $clan->money_lvl1*100; return ($num >= 100) ? 1 : 0;', 'Je hebt niet genoeg land om een muur te bouwen', NULL);
INSERT INTO `[weapons]` VALUES (29, 'Sattelite', 9, 90000, 'item-Sattelite', NULL, NULL, '100m<sup>2</sup> (Je hebt nog ${num}m<sup>2</sup>)', '$num = $clan->land-($clan->homes*100+$clan->money_lvl1*100+$clan->money_lvl2*500+$clan->money_lvl3*200+$clan->def_lvl1*100+$clan->def_lvl2*25+$clan->def_lvl3*150); return ($num >= 100) ? 1 : 0;', 'You haven''t got enough land to buy a sattelite.', 'Every members will get for every hour: Bank: $150,contant: $50');
INSERT INTO `[weapons]` VALUES (30, 'Casino', 10, 90000, 'item-Alchemy', NULL, NULL, '100m<sup>2</sup> (You still have ${num}m<sup>2</sup>)', '$num = $clan->land-($clan->homes*100+$clan->money_lvl1*100+$clan->money_lvl2*500+$clan->money_lvl3*200+$clan->def_lvl1*100+$clan->def_lvl2*25+$clan->def_lvl3*150); return ($num >= 100) ? 1 : 0;', 'You haven''t got enough money to buy a Casino', 'Every crew-members get every hour:<br>Bank: $100,contant: $100');
INSERT INTO `[weapons]` VALUES (31, 'Stock', 11, 90000, 'item-Business', NULL, NULL, '1 Manager (You still have $num managers)', '$dbresX = mysql_query("SELECT `id` FROM `[users]` WHERE `clan`=''{$clan->name}'' AND `clanlevel`=''6''"); $num = (mysql_num_rows($dbresX)+1)-$clan->money_lvl1; return $num;', 'You need a manager to look at the stocks', 'Per manager verdient iedereen in het corps:<br>Bank: $200 tot $400 per uur');
INSERT INTO `[weapons]` VALUES (34, 'Hellbender', 12, 100000, 'item-Hellbender', 2000, 1800, '1 (You can buy $num Hellbenders)', '$num = 1-$data->Hellbender; return $num;', 'You already have a Hellbender!', NULL);
INSERT INTO `[weapons]` VALUES (33, 'GoliathTank', 12, 495000, 'item-GoliathTank', 10000, 10000, '1 per $type_s (Je hebt $num $type_p die dit wapen nog niet hebben)', '$num = $data->clicks-$data->{''GoliathTank''}; return $num;', 'Al je $type_p hebben al een GoliathTank', '');
INSERT INTO `[weapons]` VALUES (56, 'Bullet Factory', 8, 750000, 'item-Bullet_Factory', NULL, NULL, '500m<sup>2</sup> (You have ${num}m<sup>2</sup>)', '$num = $clan->land-($clan->homes*100+$clan->money_lvl1*100+$clan->money_lvl2*500+$clan->money_lvl3*200+$clan->def_lvl1*100+$clan->def_lvl2*25+$clan->def_lvl3*150); return ($num >= 500) ? 1 : 0;', 'You haven''t got enough land to buy a Bullet Factory.', 'With a Bullet Factory every members will recieve every hour 10 Bullet. You''ll need atleast 1 sattelite to control them!');
INSERT INTO `[weapons]` VALUES (36, 'Tigher', 12, 649000, 'item-tank', 12000, 15000, '10 (You can buy $num Tighers)', '$num = 10-$data->Tigher; return $num;', 'You already have 10 Tighers!', NULL);
INSERT INTO `[weapons]` VALUES (52, 'Shield', 2, 49500, 'item-Shield', 200, 1000, '1 per $type_s (You have $num $type_p who haven''t got this weapon)', '$num = $data->clicks-$data->{''Shield''}; return $num;', 'All your $type_p have a Shield', '');
INSERT INTO `[weapons]` VALUES (57, 'Apache', 1, 250000, 'item-apache', 4500, 4500, '1 per $type_s (You have $num $type_p who haven\\''t got this weapon)', '$num = $data->clicks-$data->{''Apache''}; return $num;', 'All your $type_p already have a Apache.', '');
-- --------------------------------------------------------
--
-- Tabel structuur voor tabel `attempts`
--
CREATE TABLE `attempts` (
`id` int(225) NOT NULL auto_increment,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`login` varchar(225) NOT NULL default '',
`defender` varchar(225) NOT NULL default '',
`bullets` int(50) NOT NULL default '0',
`result` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -