CREATE TABLE `[clans]`(
  `name` VARCHAR(16) NOT NULL,
  PRIMARY KEY(`name`),
  `owner` VARCHAR(16) NOT NULL,
  `started` DATETIME NOT NULL,
  `type` INT(1) NOT NULL,
  `info` TEXT NOT NULL,
  `clicks` INT(5) NOT NULL,
  `clickstoday` INT(3) NOT NULL,
  `cash` INT(9) NOT NULL,
  `bank` INT(9) NOT NULL DEFAULT '10000',
  `bankleft` INT(2) NOT NULL DEFAULT '10',
  `bankmax` INT(5) NOT NULL DEFAULT '10000',
  `attwins` INT(6) NOT NULL,
  `attlosses` INT(6) NOT NULL,
  `defwins` INT(6) NOT NULL,
  `deflosses` INT(6) NOT NULL,
  `land` INT(6) NOT NULL DEFAULT '300',
  `homes` INT(3) NOT NULL DEFAULT '2',
  `money_lvl1` INT(3) NOT NULL,
  `money_lvl2` INT(3) NOT NULL,
  `money_lvl3` INT(3) NOT NULL,
  `def_lvl1` INT(3) NOT NULL,
  `def_lvl2` INT(3) NOT NULL,
  `def_lvl3` INT(3) NOT NULL,
  `IPs` TEXT NOT NULL
);





CREATE TABLE `[cron]`(
  `time` DATETIME,
  `name` VARCHAR(16) NOT NULL,
  PRIMARY KEY(`name`)
);

INSERT INTO `[cron]` VALUES('2004-03-16 08:02:48','hour');
INSERT INTO `[cron]` VALUES('2004-03-16 08:02:48','day');
INSERT INTO `[cron]` VALUES('2004-03-11 20:10:31','week');
INSERT INTO `[cron]` VALUES('2004-03-07 16:03:54','month');
INSERT INTO `[cron]` VALUES('2004-03-15 16:20:15','horserace');





CREATE TABLE `[logs]`(
  `time` DATETIME,
  `IP` VARCHAR(32),
  `forwardedFor` VARCHAR(32),
  `login` VARCHAR(16),
  `person` VARCHAR(16),
  `code` INT(10),
  `area` VARCHAR(32)
);





CREATE TABLE `[messages]`(
  `id` INT(9) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY(`id`),
  `IP` VARCHAR(32) NOT NULL,
  `forwardedFor` VARCHAR(32),
  `time` DATETIME,
  `from` VARCHAR(16),
  `to` VARCHAR(16),
  `subject` VARCHAR(50) NOT NULL,
  `message` TEXT NOT NULL,
  `read` INT(1) NOT NULL,
  `inbox` INT(1) DEFAULT '1',
  `outbox` INT(1) DEFAULT '1'
);





CREATE TABLE `[omnilog]`(
  `time` DATETIME,
  `login` VARCHAR(16),
  `IP` VARCHAR(32),
  `forwardedFor` VARCHAR(32),
  `file` VARCHAR(64),
  `$_POST` TEXT,
  `$_GET` TEXT
);





CREATE TABLE `[online]`(
  `time` DATETIME,
  `IP` VARCHAR(32),
  `login` VARCHAR(16) NOT NULL,
  PRIMARY KEY(`login`),
  `validate` VARCHAR(32),
  KEY(`IP`)
);





CREATE TABLE `[temp]`(
  `id` INT(16) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY(`id`),
  `time` DATETIME,
  `login` VARCHAR(16),
  `IP` VARCHAR(32),
  `forwardedFor` VARCHAR(32),
  `code` INT(10) unsigned NOT NULL,
  `area` VARCHAR(32)
);





CREATE TABLE `[users]`(
  `id` INT(4) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY(`id`),
  `signup` DATETIME,
  `login` VARCHAR(16),
  UNIQUE KEY(`login`),
  `pass` VARCHAR(32),
  `level` INT(3) NOT NULL DEFAULT '1',
  `IP` VARCHAR(32),
  `email` VARCHAR(64),
  `type` INT(1),
  `url` VARCHAR(128) NOT NULL,
  `info` TEXT NOT NULL,
  `cash` INT(9) NOT NULL DEFAULT '500',
  `bank` INT(9) NOT NULL DEFAULT '500',
  `bankleft` INT(1) NOT NULL DEFAULT '5',
  `bankmax` INT(4) NOT NULL DEFAULT '2500',
  `clicks` INT(4) NOT NULL,
  `clickstoday` INT(3) NOT NULL,
  `attack` INT(6) NOT NULL,
  `defence` INT(6) NOT NULL,
  `attwins` INT(6) NOT NULL,
  `attlosses` INT(6) NOT NULL,
  `defwins` INT(6) NOT NULL,
  `deflosses` INT(6) NOT NULL,
  `clan` VARCHAR(26) NOT NULL,
  `clanlevel` INT(3) NOT NULL,
  `bonus` TEXT NOT NULL,
  `turns` INT(3) NOT NULL DEFAULT '100',
  `showonline` INT(1) NOT NULL DEFAULT '1',
  `online` DATETIME NOT NULL,
  `activated` INT(1) NOT NULL,
  `Mes` INT(5) NOT NULL,
  `Walter P99` INT(5) NOT NULL,
  `Uzi` INT(5) NOT NULL,
  `MP5k` INT(5) NOT NULL,
  `Flashbang` INT(5) NOT NULL,
  `Granaat` INT(5) NOT NULL,
  `Shotgun` INT(5) NOT NULL,
  `G36C` INT(5) NOT NULL,
  `SIG 552` INT(5) NOT NULL,
  `Ak47` INT(5) NOT NULL,
  `Ak Beta` INT(5) NOT NULL,
  `Scherpschut geweer` INT(5) NOT NULL,
  `M4` INT(5) NOT NULL,
  `Granaat Lanceerder` INT(5) NOT NULL,
  `Bazooka` INT(5) NOT NULL,
  `Kogelvrij vest` INT(5) NOT NULL,
  `Bulldog` INT(5) NOT NULL,
  `Camera` INT(5) NOT NULL,
  `Hek` INT(5) NOT NULL,
  `Muur` INT(5) NOT NULL,
  `Bunker` INT(5) NOT NULL,
  `Mobieltje` INT(1) NOT NULL,
  `FN P90` INT(5) NOT NULL,
  `Chip` INT(5) NOT NULL,
  `Helm` INT(5) NOT NULL,
  `Politie wagen` INT(5) NOT NULL,
  `IPs` TEXT NOT NULL,
  `blocklist` TEXT NOT NULL
);





CREATE TABLE `[weapons]`(
  `id` INT(4) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY(`id`),
  `name` VARCHAR(30) NOT NULL,
  `area` INT(2),
  `costs` INT(7),
  `url` VARCHAR(40),
  `attack` INT(5),
  `defence` INT(5),
  `max` TEXT,
  `eval` TEXT,
  `error` TEXT,
  `extra` TEXT
);

INSERT INTO `[weapons]` VALUES(1,'Mes',1,2000,'item-Knife',20,20,'1 per $type_s (Je hebt $num $type_p die dit wapen nog niet hebben)','$num = $data->clicks-$data->Mes; return $num;','Al je $type_p hebben al een mes',NULL);
INSERT INTO `[weapons]` VALUES(2,'Walter P99',1,5000,'item-Walter_P99',50,50,'1 per $type_s (Je hebt $num $type_p die dit wapen nog niet hebben)','$num = $data->clicks-$data->{\'Walter P99\'}; return $num;','Al je $type_p hebben al een Walter P99',NULL);
INSERT INTO `[weapons]` VALUES(3,'Uzi',1,6000,'item-Uzi',65,65,'1 per $type_s (Je hebt $num $type_p die dit wapen nog niet hebben)','$num = $data->clicks-$data->Uzi; return $num;','Al je $type_p hebben al een 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,'Huis',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*150+$clan->money_lvl3*200+$clan->def_lvl1*25+$clan->def_lvl2*100+$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,'Muur',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*150+$clan->money_lvl3*200+$clan->def_lvl1*25+$clan->def_lvl2*100+$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,'Coffeeshop',9,90000,'item-Joint',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*150+$clan->money_lvl3*200+$clan->def_lvl1*25+$clan->def_lvl2*100+$clan->def_lvl3*150); return ($num >= 100) ? 1 : 0;','Je hebt niet genoeg land om een coffeeshop te bouwen','Met een coffeeshop verdient elke clan-member per uur:<br>Bank: $150,contant: $50');
INSERT INTO `[weapons]` VALUES(30,'Chemie Lab',10,90000,'item-Alchemy',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*150+$clan->money_lvl3*200+$clan->def_lvl1*25+$clan->def_lvl2*100+$clan->def_lvl3*150); return ($num >= 100) ? 1 : 0;','Je hebt niet genoeg land om een lab te bouwen','Met een chemie lab verdient elke clan-member per uur:<br>Bank: $100,contant: $100');
INSERT INTO `[weapons]` VALUES(31,'Aandeel',11,90000,'item-Business',NULL,NULL,'1 Manager (Je hebt nog $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;','Je hebt geen manager om deze aandelen in de gaten te houden','Per manager verdient iedereen in het corps:<br>Bank: $200 tot $400 per uur');