Posts by Bosske

Bosske · 11 Juli 2012

Is bij alle missie zo en ook als je leden wilt zien online staat alles langs onder bij mijn op chrome.

Bosske · 11 Juli 2012

Hoe staat het met de beveiliging van deze site want ik zie meteen al fout je kan blijven uitvoeren met solo missie.

Bosske · 8 Juni 2012

Zie ook in .htaccess bestand daar moet je tal van dingen veranderen om ze te doen werken op je eigen url.

Bosske · 8 Juni 2012

Denk dat hij bedoeld een maffiastarter.nl deze stond hier laatst over te nemen, alleen kan ik hier niet echt iets van terug vinden en het zoeksysteem doet niet wat ik vraag

Toch gevonden.

http://www.criminalspoint.com/…/16981/MaffiaStarter.html

Bosske · 8 Juni 2012

Beste crime source is in mijn ogen mafiaforce en zeer uitgebreid ook, altijd goeie omzet mee gehad. Deze is hier ergens te downloaden (gratis) pas deze aan en je hebt een uniek stukje rpg game.
http://www.criminalspoint.com/…l-Gratis-vrijgegeven.html
Succes

Bosske · 3 April 2012

Is jammer dat het zo is moeten lopen met deze leuke source toch wel.

Bosske · 3 April 2012

Mafiaforce sql bestand aub.

PHP

-- --------------------------------------------------------


--
-- Table structure for table `ajax_chat_bans`
--


CREATE TABLE IF NOT EXISTS `ajax_chat_bans` (
  `userID` int(11) NOT NULL,
  `userName` varchar(64) COLLATE utf8_bin NOT NULL,
  `dateTime` datetime NOT NULL,
  `ip` varbinary(16) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


-- --------------------------------------------------------


--
-- Table structure for table `ajax_chat_invitations`
--


CREATE TABLE IF NOT EXISTS `ajax_chat_invitations` (
  `userID` int(11) NOT NULL,
  `channel` int(11) NOT NULL,
  `dateTime` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


-- --------------------------------------------------------


--
-- Table structure for table `ajax_chat_messages`
--


CREATE TABLE IF NOT EXISTS `ajax_chat_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userID` int(11) NOT NULL,
  `userName` varchar(64) COLLATE utf8_bin NOT NULL,
  `userRole` int(1) NOT NULL,
  `channel` int(11) NOT NULL,
  `dateTime` datetime NOT NULL,
  `ip` varbinary(16) NOT NULL,
  `text` text COLLATE utf8_bin,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=20 ;


-- --------------------------------------------------------


--
-- Table structure for table `ajax_chat_online`
--


CREATE TABLE IF NOT EXISTS `ajax_chat_online` (
  `userID` int(11) NOT NULL,
  `userName` varchar(64) COLLATE utf8_bin NOT NULL,
  `userRole` int(1) NOT NULL,
  `channel` int(11) NOT NULL,
  `dateTime` datetime NOT NULL,
  `ip` varbinary(16) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


-- --------------------------------------------------------


--
-- Table structure for table `attempts`
--


CREATE TABLE IF NOT EXISTS `attempts` (
  `id` int(225) NOT NULL,
  `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',
  `reallogin` varchar(64) DEFAULT NULL,
  `realdefender` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `reallogin` (`reallogin`),
  KEY `realdefender` (`realdefender`),
  KEY `result` (`result`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `berichten`
--


CREATE TABLE IF NOT EXISTS `berichten` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `naam` varchar(50) NOT NULL DEFAULT '',
  `bericht` varchar(125) NOT NULL,
  `visible` int(11) DEFAULT '1',
  `time` datetime DEFAULT NULL,
  `inapp` smallint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `inapp` (`inapp`),
  KEY `visible` (`visible`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=762 ;


-- --------------------------------------------------------


--
-- Table structure for table `blackjack`
--


CREATE TABLE IF NOT EXISTS `blackjack` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `player` varchar(16) NOT NULL DEFAULT '',
  `status` int(1) NOT NULL DEFAULT '0',
  `kaart1computer` varchar(64) NOT NULL DEFAULT '',
  `kaart2computer` varchar(64) NOT NULL DEFAULT '',
  `kaart3computer` varchar(64) NOT NULL DEFAULT '',
  `kaart4computer` varchar(64) NOT NULL DEFAULT '',
  `kaart5computer` varchar(64) NOT NULL DEFAULT '',
  `kaart6computer` varchar(64) NOT NULL DEFAULT '',
  `kaart1speler` varchar(64) NOT NULL DEFAULT '',
  `kaart2speler` varchar(64) NOT NULL DEFAULT '',
  `kaart3speler` varchar(64) NOT NULL DEFAULT '',
  `kaart4speler` varchar(64) NOT NULL DEFAULT '',
  `kaart5speler` varchar(64) NOT NULL DEFAULT '',
  `kaart6speler` varchar(64) NOT NULL DEFAULT '',
  `puntencomputer` int(2) NOT NULL DEFAULT '0',
  `puntenspeler` int(2) NOT NULL DEFAULT '0',
  `aas1` int(2) NOT NULL DEFAULT '0',
  `aas2` int(2) NOT NULL DEFAULT '0',
  `inzet` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


-- --------------------------------------------------------


--
-- Table structure for table `bug_shop`
--


CREATE TABLE IF NOT EXISTS `bug_shop` (
  `login` varchar(255) NOT NULL,
  `time` datetime NOT NULL,
  `var` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `clancrime`
--


CREATE TABLE IF NOT EXISTS `clancrime` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time` datetime NOT NULL,
  `land` varchar(255) NOT NULL,
  `clan` varchar(255) NOT NULL,
  `p1` varchar(255) NOT NULL,
  `p2` varchar(255) NOT NULL,
  `p3` varchar(255) NOT NULL,
  `p4` varchar(255) NOT NULL,
  `p5` varchar(255) NOT NULL,
  `result` int(11) NOT NULL,
  `money` bigint(20) NOT NULL,
  `p1_info` varchar(255) NOT NULL,
  `p2_info` varchar(255) NOT NULL,
  `p3_info` varchar(255) NOT NULL,
  `p4_info` varchar(255) NOT NULL,
  `p5_info` varchar(255) NOT NULL,
  `cashtoclan` int(11) NOT NULL,
  `battlelog` text NOT NULL,
  `timedone` datetime NOT NULL,
  `moneywon` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;


-- --------------------------------------------------------


--
-- Table structure for table `config_game`
--


CREATE TABLE IF NOT EXISTS `config_game` (
  `title` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `keywords` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `admin` varchar(255) NOT NULL,
  `author` varchar(255) NOT NULL,
  `versie` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `creditrad_log`
--


CREATE TABLE IF NOT EXISTS `creditrad_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(255) NOT NULL,
  `amount` int(11) NOT NULL DEFAULT '0',
  `result1` int(11) NOT NULL DEFAULT '0',
  `result2` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;


-- --------------------------------------------------------


--
-- Table structure for table `crimelog`
--


CREATE TABLE IF NOT EXISTS `crimelog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(255) NOT NULL,
  `log_cash` bigint(20) NOT NULL DEFAULT '0',
  `log_multiplier` int(11) NOT NULL DEFAULT '0',
  `log_respect` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


-- --------------------------------------------------------


--
-- Table structure for table `cronjob_log`
--


CREATE TABLE IF NOT EXISTS `cronjob_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time` datetime NOT NULL,
  `field` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6254 ;


-- --------------------------------------------------------


--
-- Table structure for table `dealen`
--


CREATE TABLE IF NOT EXISTS `dealen` (
  `wiet` smallint(6) NOT NULL,
  `hash` smallint(6) NOT NULL,
  `Coke` smallint(6) NOT NULL,
  `prijs` smallint(6) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `defence`
--


CREATE TABLE IF NOT EXISTS `defence` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(255) NOT NULL,
  `type` int(11) NOT NULL DEFAULT '1',
  `upgrade` int(11) NOT NULL DEFAULT '0',
  `crystal_1` int(11) NOT NULL,
  `crystal_2` int(11) NOT NULL,
  `crystal_3` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=240 ;


-- --------------------------------------------------------


--
-- Table structure for table `defence_crystals`
--


CREATE TABLE IF NOT EXISTS `defence_crystals` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(255) NOT NULL,
  `type` int(11) NOT NULL DEFAULT '1',
  `grade` int(11) NOT NULL DEFAULT '1',
  `percentage` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=312 ;


-- --------------------------------------------------------


--
-- Table structure for table `defence_stats`
--


CREATE TABLE IF NOT EXISTS `defence_stats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT 'Geen verdediging.',
  `HP` int(11) NOT NULL DEFAULT '0',
  `DEF` int(11) NOT NULL DEFAULT '0',
  `price` int(11) NOT NULL DEFAULT '0',
  `upgradeprice` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;


--
-- Dumping data for table `defence_stats`
--


INSERT INTO `defence_stats` (`id`, `name`, `HP`, `DEF`, `price`, `upgradeprice`) VALUES
(1, 'Helm', 250, 10, 1000000, 500000),
(2, 'Levensreddende Helm', 313, 10, 0, 1000000),
(3, 'Beschermende Helm', 250, 13, 0, 1000000),
(4, 'Super Helm', 313, 13, 0, 2000000),
(5, 'Superlevensreddende Helm', 375, 10, 0, 4000000),
(6, 'Superbeschermende Helm', 250, 15, 0, 4000000),
(7, '&Uuml;ber Helm', 375, 15, 0, 8000000);


-- --------------------------------------------------------


--
-- Table structure for table `emails`
--


CREATE TABLE IF NOT EXISTS `emails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1233 ;


--
-- Dumping data for table `emails`
--


INSERT INTO `emails` (`id`, `email`) VALUES
(1232, '[email protected]');


-- --------------------------------------------------------


--
-- Table structure for table `events`
--


CREATE TABLE IF NOT EXISTS `events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `day` int(11) NOT NULL,
  `month` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `button_text` varchar(255) NOT NULL,
  `succeed_chance` int(11) NOT NULL,
  `desc` text NOT NULL,
  `desc_succeed` text NOT NULL,
  `desc_fail` text NOT NULL,
  `prizes` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `day` (`day`),
  KEY `month` (`month`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;


-- --------------------------------------------------------


--
-- Table structure for table `event_prizes`
--


CREATE TABLE IF NOT EXISTS `event_prizes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `field` varchar(255) NOT NULL,
  `min` int(11) NOT NULL,
  `max` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;


-- --------------------------------------------------------


--
-- Table structure for table `gotw`
--


CREATE TABLE IF NOT EXISTS `gotw` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `login` varchar(255) NOT NULL DEFAULT '',
  `vraag1` text NOT NULL,
  `vraag2` text NOT NULL,
  `vraag3` text NOT NULL,
  `vraag4` text NOT NULL,
  `vraag5` text NOT NULL,
  `vraag6` text NOT NULL,
  `vraag7` text NOT NULL,
  `vraag8` text NOT NULL,
  `week` int(5) NOT NULL DEFAULT '1',
  `jaar` int(5) NOT NULL DEFAULT '2007',
  PRIMARY KEY (`id`),
  KEY `login` (`login`),
  KEY `week` (`week`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


-- --------------------------------------------------------


--
-- Table structure for table `guide`
--


CREATE TABLE IF NOT EXISTS `guide` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `temp_subject` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `search_subject` varchar(255) NOT NULL,
  `temp_content` text NOT NULL,
  `content` text NOT NULL,
  `temp_keywords` text NOT NULL,
  `keywords` text NOT NULL,
  `minlevel` int(11) NOT NULL,
  `visible` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  FULLTEXT KEY `content` (`content`),
  FULLTEXT KEY `keywords` (`keywords`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;


-- --------------------------------------------------------


--
-- Table structure for table `happyhour`
--


CREATE TABLE IF NOT EXISTS `happyhour` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timenow` datetime NOT NULL,
  `timestart` datetime NOT NULL,
  `timeend` datetime NOT NULL,
  `factor` int(11) NOT NULL,
  `timesused` int(11) NOT NULL,
  `creditsgiven` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `timenow` (`timenow`),
  KEY `timestart` (`timestart`),
  KEY `timeend` (`timeend`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


-- --------------------------------------------------------


--
-- Table structure for table `hogerlager`
--


CREATE TABLE IF NOT EXISTS `hogerlager` (
  `login` varchar(20) NOT NULL DEFAULT '',
  `number` int(5) NOT NULL DEFAULT '0',
  `round` int(5) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `ijzermarkt`
--


CREATE TABLE IF NOT EXISTS `ijzermarkt` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amount_ijzer` int(11) NOT NULL,
  `price` bigint(20) NOT NULL,
  `stuksprijs` int(11) NOT NULL,
  `aanbieder` varchar(255) NOT NULL,
  `koper` varchar(255) NOT NULL,
  `verkocht` int(11) NOT NULL,
  `info` varchar(255) NOT NULL,
  `ip` varchar(255) NOT NULL,
  `mode` varchar(255) NOT NULL DEFAULT 'cash',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;


-- --------------------------------------------------------


--
-- Table structure for table `important`
--


CREATE TABLE IF NOT EXISTS `important` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `message` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;


-- --------------------------------------------------------


--
-- Table structure for table `indexviews`
--


CREATE TABLE IF NOT EXISTS `indexviews` (
  `IP` varchar(32) NOT NULL,
  `time` datetime NOT NULL,
  `referer` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Dumping data for table `indexviews`
--


INSERT INTO `indexviews` (`IP`, `time`, `referer`) VALUES
('84.197.152.121', '2011-09-25 15:48:42', ''),
('84.197.152.121', '2011-09-25 15:49:15', ''),
('84.197.152.121', '2011-09-25 15:49:19', ''),
('84.197.152.121', '2011-09-25 15:50:45', ''),
('84.197.152.121', '2011-09-25 15:53:21', ''),
('84.197.152.121', '2011-09-25 15:56:06', ''),
('84.197.152.121', '2011-09-25 16:02:26', ''),
('84.197.152.121', '2011-09-25 16:06:20', ''),
('84.197.152.121', '2011-09-25 16:06:32', ''),
('84.197.152.121', '2011-09-25 16:08:26', ''),
('84.197.152.121', '2011-09-25 16:09:26', ''),
('84.197.152.121', '2011-09-25 16:14:37', ''),
('84.197.152.121', '2011-09-25 16:15:55', ''),
('84.197.152.121', '2011-09-25 16:16:14', ''),
('84.197.152.121', '2011-09-25 16:16:15', ''),
('84.197.152.121', '2011-09-25 16:16:17', ''),
('84.197.152.121', '2011-09-25 16:16:18', ''),
('84.197.152.121', '2011-09-25 16:16:19', ''),
('84.197.152.121', '2011-09-25 16:16:41', ''),
('84.197.152.121', '2011-09-25 16:16:52', ''),
('84.197.152.121', '2011-09-25 16:17:03', ''),
('84.197.152.121', '2011-09-25 16:19:40', ''),
('84.197.152.121', '2011-09-25 16:19:41', ''),
('84.197.152.121', '2011-09-25 16:19:58', ''),
('84.197.152.121', '2011-09-25 16:20:40', 'http://co102w.col102.mail.live.com/default.aspx'),
('84.197.152.121', '2011-09-25 16:20:46', ''),
('84.197.152.121', '2011-09-25 18:56:55', ''),
('84.197.152.121', '2011-09-25 18:57:02', ''),
('84.197.152.121', '2011-09-25 18:57:07', ''),
('84.197.152.121', '2011-09-25 18:57:13', ''),
('81.205.90.91', '2011-09-25 19:07:07', ''),
('84.197.152.121', '2011-09-25 19:25:30', ''),
('84.197.152.121', '2011-09-25 19:25:37', ''),
('84.197.152.121', '2011-09-25 19:27:08', ''),
('84.197.152.121', '2011-09-25 19:27:11', ''),
('84.197.152.121', '2011-09-25 19:28:05', ''),
('84.197.152.121', '2011-09-25 19:28:18', 'http://co102w.col102.mail.live.com/default.aspx?rru=getmsg?msg=8A11720C-E797-11E0-BE78-00215AD7DB9C'),
('84.197.152.121', '2011-09-25 19:29:03', '');


-- --------------------------------------------------------


--
-- Table structure for table `invite`
--


CREATE TABLE IF NOT EXISTS `invite` (
  `user_id` smallint(6) NOT NULL,
  `clan_id` smallint(6) NOT NULL,
  PRIMARY KEY (`user_id`,`clan_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `klikmissie`
--


CREATE TABLE IF NOT EXISTS `klikmissie` (
  `user_id` smallint(6) NOT NULL,
  `clicks` smallint(6) NOT NULL,
  `missie1` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `kogelmarkt`
--


CREATE TABLE IF NOT EXISTS `kogelmarkt` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `amount_kogels` int(10) NOT NULL DEFAULT '0',
  `price` int(10) NOT NULL DEFAULT '0',
  `stuksprijs` float NOT NULL DEFAULT '0',
  `aanbieder` varchar(20) NOT NULL DEFAULT '',
  `koper` varchar(20) NOT NULL DEFAULT '',
  `verkocht` enum('0','1') NOT NULL DEFAULT '0',
  `info` text NOT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `mode` varchar(255) NOT NULL DEFAULT 'cash',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;


-- --------------------------------------------------------


--
-- Table structure for table `kopers`
--


CREATE TABLE IF NOT EXISTS `kopers` (
  `ip` varchar(255) NOT NULL,
  `time` varchar(255) NOT NULL,
  `verkoperid` int(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `land`
--


CREATE TABLE IF NOT EXISTS `land` (
  `landid` int(5) NOT NULL AUTO_INCREMENT,
  `landnaam` varchar(25) NOT NULL DEFAULT '',
  `1` varchar(255) NOT NULL DEFAULT '#0#0',
  `2` varchar(255) NOT NULL DEFAULT '#0#0',
  `3` varchar(255) NOT NULL DEFAULT '#0#0',
  `4` varchar(255) NOT NULL DEFAULT '#0#0',
  `5` varchar(255) NOT NULL DEFAULT '#0#0',
  `6` varchar(255) NOT NULL DEFAULT '#0#0',
  `7` varchar(255) NOT NULL DEFAULT '#0#0',
  `8` varchar(255) NOT NULL DEFAULT '#0#0',
  `9` varchar(255) NOT NULL DEFAULT '#0#0',
  `10` varchar(255) NOT NULL DEFAULT '#0#0',
  `11` varchar(255) NOT NULL DEFAULT '#0#0',
  `12` varchar(255) NOT NULL DEFAULT '#0#0',
  `13` varchar(255) NOT NULL DEFAULT '#0#0',
  `14` varchar(255) NOT NULL DEFAULT '#0#0',
  `15` varchar(255) NOT NULL DEFAULT '#0#0',
  `16` varchar(255) NOT NULL DEFAULT '#0#0',
  `17` varchar(255) NOT NULL DEFAULT '#0#0',
  `18` varchar(255) NOT NULL DEFAULT '#0#0',
  `19` varchar(255) NOT NULL DEFAULT '#0#0',
  `20` varchar(255) NOT NULL DEFAULT '#0#0',
  `21` varchar(255) NOT NULL DEFAULT '#0#0',
  `22` varchar(255) NOT NULL DEFAULT '#0#0',
  `23` varchar(255) NOT NULL DEFAULT '#0#0',
  `24` varchar(255) NOT NULL DEFAULT '#0#0',
  `25` varchar(255) NOT NULL DEFAULT '#0#0',
  `26` varchar(255) NOT NULL DEFAULT '#0#0',
  `27` varchar(255) NOT NULL DEFAULT '#0#0',
  `28` varchar(255) NOT NULL DEFAULT '#0#0',
  `29` varchar(255) NOT NULL DEFAULT '#0#0',
  `30` varchar(255) NOT NULL DEFAULT '#0#0',
  `31` varchar(255) NOT NULL DEFAULT '#0#0',
  `32` varchar(255) NOT NULL DEFAULT '#0#0',
  `33` varchar(255) NOT NULL DEFAULT '#0#0',
  `34` varchar(255) NOT NULL DEFAULT '#0#0',
  `35` varchar(255) NOT NULL DEFAULT '#0#0',
  `36` varchar(255) NOT NULL DEFAULT '#0#0',
  `37` varchar(255) NOT NULL DEFAULT '#0#0',
  `38` varchar(255) NOT NULL DEFAULT '#0#0',
  `39` varchar(255) NOT NULL DEFAULT '#0#0',
  `40` varchar(255) NOT NULL DEFAULT '#0#0',
  `41` varchar(255) NOT NULL DEFAULT '#0#0',
  `42` varchar(255) NOT NULL DEFAULT '#0#0',
  `43` varchar(255) NOT NULL DEFAULT '#0#0',
  `44` varchar(255) NOT NULL DEFAULT '#0#0',
  `45` varchar(255) NOT NULL DEFAULT '#0#0',
  `46` varchar(255) NOT NULL DEFAULT '#0#0',
  `47` varchar(255) NOT NULL DEFAULT '#0#0',
  `48` varchar(255) NOT NULL DEFAULT '#0#0',
  `49` varchar(255) NOT NULL DEFAULT '#0#0',
  `50` varchar(255) NOT NULL DEFAULT '#0#0',
  `51` varchar(255) NOT NULL DEFAULT '#0#0',
  `52` varchar(255) NOT NULL DEFAULT '#0#0',
  `53` varchar(255) NOT NULL DEFAULT '#0#0',
  `54` varchar(255) NOT NULL DEFAULT '#0#0',
  `55` varchar(255) NOT NULL DEFAULT '#0#0',
  `56` varchar(255) NOT NULL DEFAULT '#0#0',
  `57` varchar(255) NOT NULL DEFAULT '#0#0',
  `58` varchar(255) NOT NULL DEFAULT '#0#0',
  `59` varchar(255) NOT NULL DEFAULT '#0#0',
  `60` varchar(255) NOT NULL DEFAULT '#0#0',
  `61` varchar(255) NOT NULL DEFAULT '#0#0',
  `62` varchar(255) NOT NULL DEFAULT '#0#0',
  `63` varchar(255) NOT NULL DEFAULT '#0#0',
  `64` varchar(255) NOT NULL DEFAULT '#0#0',
  `65` varchar(255) NOT NULL DEFAULT '#0#0',
  `66` varchar(255) NOT NULL DEFAULT '#0#0',
  `67` varchar(255) NOT NULL DEFAULT '#0#0',
  `68` varchar(255) NOT NULL DEFAULT '#0#0',
  `69` varchar(255) NOT NULL DEFAULT '#0#0',
  `70` varchar(255) NOT NULL DEFAULT '#0#0',
  `71` varchar(255) NOT NULL DEFAULT '#0#0',
  `72` varchar(255) NOT NULL DEFAULT '#0#0',
  `73` varchar(255) NOT NULL DEFAULT '#0#0',
  `74` varchar(255) NOT NULL DEFAULT '#0#0',
  `75` varchar(255) NOT NULL DEFAULT '#0#0',
  `76` varchar(255) NOT NULL DEFAULT '#0#0',
  `77` varchar(255) NOT NULL DEFAULT '#0#0',
  `78` varchar(255) NOT NULL DEFAULT '#0#0',
  `79` text NOT NULL,
  `80` text NOT NULL,
  `81` text NOT NULL,
  `82` text NOT NULL,
  `83` text NOT NULL,
  `84` text NOT NULL,
  `85` text NOT NULL,
  `86` text NOT NULL,
  `87` text NOT NULL,
  `88` text NOT NULL,
  `89` text NOT NULL,
  `90` text NOT NULL,
  `91` text NOT NULL,
  `92` text NOT NULL,
  `93` text NOT NULL,
  `94` text NOT NULL,
  `95` text NOT NULL,
  `96` text NOT NULL,
  `97` text NOT NULL,
  `98` text NOT NULL,
  `99` text NOT NULL,
  `100` text NOT NULL,
  `101` text NOT NULL,
  `102` text NOT NULL,
  `103` text NOT NULL,
  `104` text NOT NULL,
  `105` text NOT NULL,
  `106` text NOT NULL,
  `107` text NOT NULL,
  `108` text NOT NULL,
  `109` text NOT NULL,
  `110` text NOT NULL,
  `111` text NOT NULL,
  `112` text NOT NULL,
  `113` text NOT NULL,
  `114` text NOT NULL,
  `115` text NOT NULL,
  `116` text NOT NULL,
  `117` text NOT NULL,
  `118` text NOT NULL,
  `119` text NOT NULL,
  PRIMARY KEY (`landid`),
  KEY `landnaam` (`landnaam`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;


-- --------------------------------------------------------


--
-- Table structure for table `landen`
--


CREATE TABLE IF NOT EXISTS `landen` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `land` varchar(255) NOT NULL DEFAULT 'error',
  `vliegveld` varchar(255) NOT NULL DEFAULT 'error',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;


-- --------------------------------------------------------


--
-- Table structure for table `land_est`
--


CREATE TABLE IF NOT EXISTS `land_est` (
  `login` varchar(255) NOT NULL DEFAULT '',
  `land` varchar(255) NOT NULL DEFAULT '',
  `landid` int(5) NOT NULL DEFAULT '0',
  `type` int(5) NOT NULL DEFAULT '0',
  `value1` varchar(255) NOT NULL DEFAULT '',
  `value2` bigint(255) NOT NULL DEFAULT '0',
  `value3` varchar(255) NOT NULL DEFAULT '',
  `value4` bigint(255) NOT NULL DEFAULT '0',
  `value5` varchar(255) NOT NULL DEFAULT '',
  `value6` bigint(255) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `LEXFREE_11_LEX_CATEGORIES`
--


CREATE TABLE IF NOT EXISTS `LEXFREE_11_LEX_CATEGORIES` (
  `ID` tinyint(3) unsigned NOT NULL,
  `STITLE` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `LEXFREE_11_LEX_GROUPS`
--


CREATE TABLE IF NOT EXISTS `LEXFREE_11_LEX_GROUPS` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `STITLE` varchar(255) NOT NULL,
  `DTADDED` datetime NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


-- --------------------------------------------------------


--
-- Table structure for table `LEXFREE_11_LEX_GROUPSCATEGORIES`
--


CREATE TABLE IF NOT EXISTS `LEXFREE_11_LEX_GROUPSCATEGORIES` (
  `LEX_GROUPS_ID` int(10) unsigned NOT NULL,
  `LEX_CATEGORIES_ID` tinyint(3) unsigned NOT NULL,
  KEY `GROUPS_CATEGORY_LX_index` (`LEX_GROUPS_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `LEXFREE_11_LEX_LEXLINKS`
--


CREATE TABLE IF NOT EXISTS `LEXFREE_11_LEX_LEXLINKS` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `STITLE` varchar(60) DEFAULT NULL,
  `SURL` varchar(255) DEFAULT NULL,
  `SDESCRIPTION` text,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;


-- --------------------------------------------------------


--
-- Table structure for table `LEXFREE_11_LEX_SETTINGS`
--


CREATE TABLE IF NOT EXISTS `LEXFREE_11_LEX_SETTINGS` (
  `SID` varchar(20) NOT NULL,
  `SVALUE` varchar(255) DEFAULT NULL,
  `NTYPE` tinyint(3) unsigned NOT NULL,
  `NPAGEID` tinyint(3) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `LEXFREE_11_LEX_WEBSITES`
--


CREATE TABLE IF NOT EXISTS `LEXFREE_11_LEX_WEBSITES` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `STITLE` varchar(60) NOT NULL,
  `SURL` varchar(255) NOT NULL,
  `SDESCRIPTION` text,
  `DTADDED` datetime DEFAULT NULL,
  `SKEYWORDS` varchar(255) DEFAULT NULL,
  `SEMAIL` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;


-- --------------------------------------------------------


--
-- Table structure for table `LEXFREE_11_LEX_WEBSITESCATEGORIES`
--


CREATE TABLE IF NOT EXISTS `LEXFREE_11_LEX_WEBSITESCATEGORIES` (
  `LEX_WEBSITES_ID` int(10) unsigned NOT NULL,
  `LEX_CATEGORIES_ID` tinyint(3) unsigned NOT NULL,
  KEY `WEBSITE_CATEGORY_LX_index` (`LEX_WEBSITES_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `logs_clan`
--


CREATE TABLE IF NOT EXISTS `logs_clan` (
  `user_id` smallint(6) NOT NULL,
  `clan_id` smallint(6) NOT NULL,
  `money` bigint(20) NOT NULL,
  PRIMARY KEY (`user_id`,`clan_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `logs_clan_donatie`
--


CREATE TABLE IF NOT EXISTS `logs_clan_donatie` (
  `time` int(11) NOT NULL,
  `user_id` smallint(6) NOT NULL,
  `clan_id` smallint(6) NOT NULL,
  `person_id` smallint(6) NOT NULL,
  `money` bigint(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `lottery`
--


CREATE TABLE IF NOT EXISTS `lottery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(225) DEFAULT '',
  `active` tinyint(1) DEFAULT '1',
  `ticketprice` int(11) DEFAULT '1000',
  `ticketssold` mediumint(11) DEFAULT '0',
  `pot` bigint(11) DEFAULT '0',
  `winner` varchar(16) DEFAULT 'Niemand',
  `winner-login` varchar(16) DEFAULT '',
  `start` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;


-- --------------------------------------------------------


--
-- Table structure for table `lottery-tickets`
--


CREATE TABLE IF NOT EXISTS `lottery-tickets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(225) NOT NULL DEFAULT '',
  `lotterynr` mediumint(11) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `IP` varchar(225) NOT NULL DEFAULT '0.0.0.0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=101 ;


-- --------------------------------------------------------


--
-- Table structure for table `mcclog`
--


CREATE TABLE IF NOT EXISTS `mcclog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time` datetime NOT NULL,
  `result` tinyint(4) NOT NULL,
  `normal` int(11) NOT NULL,
  `extra` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;


-- --------------------------------------------------------


--
-- Table structure for table `megaclickcrime`
--


CREATE TABLE IF NOT EXISTS `megaclickcrime` (
  `p1` varchar(255) NOT NULL,
  `p2` varchar(255) NOT NULL,
  `p3` varchar(255) NOT NULL,
  `p4` varchar(255) NOT NULL,
  `p5` varchar(255) NOT NULL,
  `p6` varchar(255) NOT NULL,
  `p7` varchar(255) NOT NULL,
  `p8` varchar(255) NOT NULL,
  `p9` varchar(255) NOT NULL,
  `p10` varchar(255) NOT NULL,
  `p11` varchar(255) NOT NULL,
  `p12` varchar(255) NOT NULL,
  KEY `p1` (`p1`),
  KEY `p2` (`p2`),
  KEY `p3` (`p3`),
  KEY `p4` (`p4`),
  KEY `p5` (`p5`),
  KEY `p6` (`p6`),
  KEY `p7` (`p7`),
  KEY `p8` (`p8`),
  KEY `p9` (`p9`),
  KEY `p10` (`p10`),
  KEY `p11` (`p11`),
  KEY `p12` (`p12`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `mflog`
--


CREATE TABLE IF NOT EXISTS `mflog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `login` varchar(255) NOT NULL,
  `enemy` varchar(255) NOT NULL,
  `result` text NOT NULL,
  `won` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=680 ;


-- --------------------------------------------------------


--
-- Table structure for table `mf_armorfabriek`
--


CREATE TABLE IF NOT EXISTS `mf_armorfabriek` (
  `id` bigint(255) NOT NULL AUTO_INCREMENT,
  `eigenaar` varchar(255) NOT NULL,
  `uitbreiding` int(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ;


-- --------------------------------------------------------


--
-- Table structure for table `mf_armorfabriekmaak`
--


CREATE TABLE IF NOT EXISTS `mf_armorfabriekmaak` (
  `eigenaar` varchar(255) NOT NULL,
  `id` bigint(255) NOT NULL,
  `armorinmaak` varchar(255) NOT NULL,
  `tijdnu` datetime NOT NULL,
  `wachten` int(255) NOT NULL,
  `aantal` int(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `mf_autos`
--


CREATE TABLE IF NOT EXISTS `mf_autos` (
  `id` int(255) NOT NULL DEFAULT '0',
  `databasenaam` varchar(255) NOT NULL DEFAULT '',
  `naam` varchar(255) NOT NULL DEFAULT '',
  `prijs` int(255) NOT NULL DEFAULT '0',
  `delendoor` int(255) NOT NULL DEFAULT '0',
  `race` int(255) NOT NULL DEFAULT '0',
  `exp` int(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Dumping data for table `mf_autos`
--


INSERT INTO `mf_autos` (`id`, `databasenaam`, `naam`, `prijs`, `delendoor`, `race`, `exp`) VALUES
(1, 'citroenc1', 'Citro&euml;n C1', 10000, 1, 10, 5),
(2, 'fiatdoblo', 'Fiat Doblo', 20000, 5, 15, 10),
(3, 'renaultgrandscenic', 'Renault Grand Scenic', 25000, 8, 20, 15),
(4, 'audia3', 'Audi A3', 30000, 13, 25, 20),
(5, 'opelastra', 'Opel Astra', 35000, 14, 30, 25),
(6, 'fordmondeo', 'Ford Mondeo', 40000, 15, 35, 30),
(7, 'citroenc4picasso', 'Citro&euml;n C4 Picasso', 45000, 20, 40, 35),
(8, 'alfaromeospider', 'Alfa Romeo Spider', 50000, 25, 45, 40),
(9, 'audia4', 'Audi A4', 55000, 30, 50, 45),
(10, 'citroenc8', 'Citro&euml;n C8', 60000, 35, 55, 50),
(11, 'volkswagentouareg', 'Volkswagen Touareg', 65000, 40, 60, 55),
(12, 'jaguarxf', 'Jaguar XF', 70000, 50, 65, 60),
(13, 'toyotalandcruiser', 'Toyota Landcruiser', 75000, 70, 70, 65),
(14, 'landroverdiscovery', 'Land Rover Discovery', 80000, 90, 75, 70),
(15, 'volvoxc90', 'Volvo XC90', 85000, 110, 80, 75),
(16, 'ferrarif430', 'Ferrari F430', 250000, 200, 85, 90);


-- --------------------------------------------------------


--
-- Table structure for table `mf_bvot`
--


CREATE TABLE IF NOT EXISTS `mf_bvot` (
  `verzender` varchar(255) NOT NULL DEFAULT '',
  `ontvanger` varchar(255) NOT NULL DEFAULT '',
  `prijs` bigint(255) NOT NULL DEFAULT '0',
  `item` varchar(255) NOT NULL DEFAULT '',
  `itemnaam` varchar(255) NOT NULL DEFAULT '',
  `aantal` int(255) NOT NULL DEFAULT '0',
  `id` bigint(255) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=102 ;


-- --------------------------------------------------------


--
-- Table structure for table `mf_casino`
--


CREATE TABLE IF NOT EXISTS `mf_casino` (
  `kluis_1` int(255) NOT NULL,
  `kluis_2` int(255) NOT NULL,
  `kluis_3` int(255) NOT NULL,
  `kluis_4` bigint(255) NOT NULL,
  `id` int(25) NOT NULL,
  `kluis2_1` int(255) NOT NULL,
  `kluis2_2` int(255) NOT NULL,
  `kluis2_3` int(255) NOT NULL,
  `kluis2_4` bigint(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `mf_drugsfabriek`
--


CREATE TABLE IF NOT EXISTS `mf_drugsfabriek` (
  `eigenaar` varchar(255) NOT NULL,
  `id` bigint(255) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=64 ;


-- --------------------------------------------------------


--
-- Table structure for table `mf_drugsfabriekmaak`
--


CREATE TABLE IF NOT EXISTS `mf_drugsfabriekmaak` (
  `id` bigint(255) NOT NULL,
  `tijdnu` datetime NOT NULL,
  `wachten` bigint(255) NOT NULL,
  `aantal` bigint(255) NOT NULL,
  `eigenaar` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `mf_forum`
--


CREATE TABLE IF NOT EXISTS `mf_forum` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `datum` datetime NOT NULL,
  `titel` varchar(255) NOT NULL,
  `door` varchar(255) NOT NULL,
  `bericht` text NOT NULL,
  `gesloten` int(20) NOT NULL DEFAULT '0',
  `cat` varchar(255) NOT NULL,
  `datum2` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=63 ;


-- --------------------------------------------------------


--
-- Table structure for table `mf_forum_berichten`
--


CREATE TABLE IF NOT EXISTS `mf_forum_berichten` (
  `id` bigint(255) NOT NULL,
  `door` varchar(255) NOT NULL,
  `datum` datetime NOT NULL,
  `bericht` text NOT NULL,
  `berichtid` bigint(255) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`berichtid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=203 ;


-- --------------------------------------------------------


--
-- Table structure for table `mf_garage`
--


CREATE TABLE IF NOT EXISTS `mf_garage` (
  `naam` varchar(255) NOT NULL DEFAULT '',
  `databasenaam` varchar(255) NOT NULL DEFAULT '',
  `eigenaar` varchar(255) NOT NULL DEFAULT '',
  `prijs` bigint(255) NOT NULL DEFAULT '0',
  `schade` int(255) NOT NULL DEFAULT '0',
  `id` bigint(255) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4059 ;


-- --------------------------------------------------------


--
-- Table structure for table `mf_items`
--


CREATE TABLE IF NOT EXISTS `mf_items` (
  `databasenaam` varchar(255) NOT NULL DEFAULT '',
  `naam` varchar(255) NOT NULL DEFAULT '',
  `power` int(255) NOT NULL DEFAULT '0',
  `lvl` int(255) NOT NULL DEFAULT '0',
  `waarvoor` varchar(255) NOT NULL DEFAULT '',
  `kogels` int(20) NOT NULL DEFAULT '0',
  `classe` varchar(255) NOT NULL DEFAULT '',
  `job` int(255) NOT NULL DEFAULT '0',
  `uniek` int(255) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `mf_kogelfabriek`
--


CREATE TABLE IF NOT EXISTS `mf_kogelfabriek` (
  `id` bigint(255) NOT NULL AUTO_INCREMENT,
  `eigenaar` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;


-- --------------------------------------------------------


--
-- Table structure for table `mf_kogelfabriekmaak`
--


CREATE TABLE IF NOT EXISTS `mf_kogelfabriekmaak` (
  `id` bigint(255) NOT NULL,
  `tijdnu` datetime NOT NULL,
  `wachten` bigint(255) NOT NULL,
  `aantal` bigint(255) NOT NULL,
  `eigenaar` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `mf_leden`
--


CREATE TABLE IF NOT EXISTS `mf_leden` (
  `login` varchar(255) NOT NULL DEFAULT '',
  `email` varchar(255) NOT NULL DEFAULT '',
  `wachtwoord` varchar(255) NOT NULL DEFAULT '',
  `ip` varchar(255) NOT NULL DEFAULT '',
  `lvl` int(255) NOT NULL DEFAULT '1',
  `exp` int(255) NOT NULL DEFAULT '0',
  `genoegexp` int(255) NOT NULL DEFAULT '10',
  `hp` int(100) NOT NULL DEFAULT '100',
  `misdaadkans` int(100) NOT NULL DEFAULT '50',
  `credits` bigint(255) NOT NULL DEFAULT '20',
  `misdaadtijd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `hoofd` varchar(255) NOT NULL DEFAULT '',
  `arm1` varchar(255) NOT NULL DEFAULT 'm911',
  `lichaam` varchar(255) NOT NULL DEFAULT '',
  `voeten` varchar(255) NOT NULL DEFAULT '',
  `arm2` varchar(255) NOT NULL DEFAULT '',
  `power` int(255) NOT NULL DEFAULT '0',
  `kogels` bigint(255) NOT NULL DEFAULT '7',
  `geld` bigint(255) NOT NULL DEFAULT '200',
  `eagle` bigint(255) NOT NULL DEFAULT '0',
  `eaglegold` bigint(255) NOT NULL DEFAULT '0',
  `eagleelite` bigint(255) NOT NULL DEFAULT '0',
  `uzi` bigint(255) NOT NULL DEFAULT '0',
  `ak47gold` bigint(255) NOT NULL DEFAULT '0',
  `uzielite` bigint(255) NOT NULL DEFAULT '0',
  `m911` bigint(255) NOT NULL DEFAULT '1',
  `revolver` bigint(255) NOT NULL DEFAULT '0',
  `revolvergold` bigint(255) NOT NULL DEFAULT '0',
  `revolverelite` bigint(255) NOT NULL DEFAULT '0',
  `ak47` bigint(255) NOT NULL DEFAULT '0',
  `ak47elite` bigint(255) NOT NULL DEFAULT '0',
  `grenade` bigint(255) NOT NULL DEFAULT '0',
  `grenadegold` bigint(255) NOT NULL DEFAULT '0',
  `grenadeelite` bigint(255) NOT NULL DEFAULT '0',
  `gevangenistijd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `autokans` int(255) NOT NULL DEFAULT '50',
  `autotijd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `drugs` bigint(255) NOT NULL DEFAULT '1',
  `citroenc1` int(225) NOT NULL,
  `fiatdoblo` int(225) NOT NULL,
  `renaultgrandscenic` int(225) NOT NULL,
  `audia3` int(225) NOT NULL,
  `opelastra` int(225) NOT NULL,
  `fordmondeo` int(225) NOT NULL,
  `citroenc4picasso` int(225) NOT NULL,
  `alfaromeospider` int(225) NOT NULL,
  `audia4` int(225) NOT NULL,
  `citroenc8` int(225) NOT NULL,
  `volkswagentouareg` int(225) NOT NULL,
  `jaguarxf` int(225) NOT NULL,
  `toyotalandcruiser` int(225) NOT NULL,
  `landroverdiscovery` int(225) NOT NULL,
  `volvoxc90` int(225) NOT NULL,
  `ferrarif430` int(225) NOT NULL,
  `online` datetime NOT NULL,
  `rang` int(255) NOT NULL,
  `blauwshirt` bigint(255) NOT NULL,
  `geenwachttijd` datetime NOT NULL,
  `tip` smallint(255) NOT NULL DEFAULT '0',
  `aanvallen` int(255) NOT NULL DEFAULT '0',
  `aanvallenverloren` int(255) NOT NULL DEFAULT '0',
  `respect` int(255) NOT NULL DEFAULT '1',
  `respecttijd` datetime NOT NULL,
  `aanvaltijd` datetime NOT NULL,
  `pet` bigint(255) NOT NULL,
  `spijkerbroek` bigint(255) NOT NULL,
  `benen` varchar(255) NOT NULL,
  `spijkerbroekgold` bigint(255) NOT NULL,
  `spijkerbroekelite` bigint(255) NOT NULL,
  `sportschoenen` bigint(255) NOT NULL,
  `sportschoenenelite` bigint(255) NOT NULL,
  `sportschoenengold` bigint(255) NOT NULL,
  `mp5` bigint(255) NOT NULL,
  `mp5gold` bigint(255) NOT NULL,
  `mp5elite` bigint(255) NOT NULL,
  `rozeshirt` bigint(255) NOT NULL,
  `blauweschoenen` bigint(255) NOT NULL,
  `blauweschoenengold` bigint(255) NOT NULL,
  `blauweschoenenelite` bigint(255) NOT NULL,
  `job` int(255) NOT NULL DEFAULT '0',
  `grenadegreen` bigint(255) NOT NULL,
  `mp5green` bigint(255) NOT NULL,
  `shotgungreen` bigint(255) NOT NULL,
  `harpoongreen` bigint(255) NOT NULL,
  `radtijd` datetime NOT NULL,
  `bezitweergeven` int(100) NOT NULL DEFAULT '0',
  `infotekst` text NOT NULL,
  `uzigold` bigint(255) NOT NULL DEFAULT '0',
  `klikmissie1` datetime NOT NULL,
  `msn` datetime NOT NULL,
  `kluis` bigint(255) NOT NULL DEFAULT '500',
  `ban` int(255) NOT NULL DEFAULT '0',
  `mod` int(255) NOT NULL DEFAULT '0',
  `kortebroek` bigint(255) NOT NULL,
  `donkerebroek` bigint(255) NOT NULL,
  `donkerebroekgreen` bigint(255) NOT NULL,
  `zwartewerkschoenen` bigint(255) NOT NULL,
  `groenemust` bigint(255) NOT NULL,
  `groenemustgold` bigint(255) NOT NULL,
  `groenemustelite` bigint(255) NOT NULL,
  `groenshirt` bigint(255) NOT NULL,
  `groenshirtgold` bigint(255) NOT NULL,
  `groenshirtelite` bigint(255) NOT NULL,
  `groenshirtgreen` bigint(255) NOT NULL,
  `donkerrozeshirt` bigint(255) NOT NULL,
  `roodshirt` bigint(255) NOT NULL,
  `paarsshirt` bigint(255) NOT NULL,
  `klikmissiedubbel` int(255) NOT NULL,
  `eaglebruin` bigint(255) NOT NULL,
  `uzibruin` bigint(255) NOT NULL,
  `revolverbruin` bigint(255) NOT NULL,
  `ak47bruin` bigint(255) NOT NULL,
  `grenadebruin` bigint(255) NOT NULL,
  `mp5bruin` bigint(255) NOT NULL,
  `avatarpack` int(255) NOT NULL DEFAULT '0',
  `avatar` varchar(255) NOT NULL DEFAULT 'nopic.gif',
  `geenlimiet` int(255) NOT NULL DEFAULT '0',
  `racetijd` datetime NOT NULL,
  `extrapower` int(255) NOT NULL DEFAULT '0',
  `geenwachttijdrace` datetime NOT NULL,
  `stempunten` int(255) NOT NULL DEFAULT '1',
  `getaltijd` datetime NOT NULL,
  `familie_id` int(255) NOT NULL,
  `familie_rang` int(255) NOT NULL,
  `m16blauw` bigint(255) NOT NULL,
  `skorpionblauw` bigint(255) NOT NULL,
  `m203blauw` bigint(255) NOT NULL,
  `g36cblauw` bigint(255) NOT NULL,
  `m4m203blauw` bigint(255) NOT NULL,
  `uniek_kerstmuts` bigint(255) NOT NULL,
  `uniek_kerstschoenen` bigint(255) NOT NULL,
  `uniek_kerstshirt` bigint(255) NOT NULL,
  `uniek_kerstbroek` bigint(255) NOT NULL,
  `emailontvangen` int(255) NOT NULL DEFAULT '1',
  `status` int(255) NOT NULL DEFAULT '0',
  `starcount` int(255) NOT NULL DEFAULT '0',
  `header_scroll1` int(255) NOT NULL DEFAULT '1000',
  `header_scroll2` int(255) NOT NULL DEFAULT '1100',
  `body_color_table` varchar(255) NOT NULL DEFAULT 'dcdacd',
  `header_verbergen` int(255) NOT NULL DEFAULT '0',
  `body_tekst` int(255) NOT NULL DEFAULT '12',
  `eaglebruin_rood` bigint(255) NOT NULL,
  `eaglebruin_groen` bigint(255) NOT NULL,
  `eaglebruin_blauw` bigint(255) NOT NULL,
  `eaglebruin_zwart` bigint(255) NOT NULL,
  `eaglebruin_roze` bigint(255) NOT NULL,
  `diamant_rood` bigint(225) NOT NULL,
  `diamant_groen` bigint(225) NOT NULL,
  `diamant_blauw` bigint(225) NOT NULL,
  `diamant_zwart` bigint(225) NOT NULL,
  `diamant_roze` bigint(225) NOT NULL,
  `m16blauw_rood` bigint(255) NOT NULL,
  `m16blauw_groen` bigint(255) NOT NULL,
  `m16blauw_blauw` bigint(255) NOT NULL,
  `m16blauw_zwart` bigint(255) NOT NULL,
  `m16blauw_roze` bigint(255) NOT NULL,
  `sms` int(255) NOT NULL,
  `smsstatus` int(225) NOT NULL DEFAULT '0',
  `uniek_paarsepet` bigint(255) NOT NULL,
  `header_keuze` int(255) NOT NULL DEFAULT '2',
  `ak47_rood` bigint(255) NOT NULL,
  `ak47_groen` bigint(255) NOT NULL,
  `ak47_blauw` bigint(255) NOT NULL,
  `ak47_zwart` bigint(255) NOT NULL,
  `ak47_roze` bigint(255) NOT NULL,
  `grenade_rood` bigint(255) NOT NULL,
  `grenade_groen` bigint(255) NOT NULL,
  `grenade_blauw` bigint(255) NOT NULL,
  `grenade_zwart` bigint(255) NOT NULL,
  `grenade_roze` bigint(255) NOT NULL,
  `slottijd` datetime NOT NULL,
  `specpoints` int(255) NOT NULL DEFAULT '0',
  `tijdmachine` int(255) NOT NULL DEFAULT '0',
  `geldbespaarder` int(255) NOT NULL DEFAULT '0',
  `racemonster` int(255) NOT NULL DEFAULT '0',
  `gokfreak` int(255) NOT NULL DEFAULT '0',
  `politievriend` int(255) NOT NULL DEFAULT '0',
  `klikmissie2` datetime NOT NULL,
  `menustyle` int(255) NOT NULL DEFAULT '1',
  `missie_1` int(255) NOT NULL DEFAULT '0',
  `missie_2` int(255) NOT NULL DEFAULT '0',
  `missie_3` int(255) NOT NULL DEFAULT '0',
  `missie_4` int(255) NOT NULL DEFAULT '0',
  `missie_5` int(255) NOT NULL DEFAULT '0',
  `missie_6` int(255) NOT NULL DEFAULT '0',
  `missie_7` int(255) NOT NULL DEFAULT '0',
  `missie_8` int(255) NOT NULL DEFAULT '0',
  `missie_9` int(255) NOT NULL DEFAULT '0',
  `missie_10` int(255) NOT NULL DEFAULT '0',
  `uzibruin_rood` bigint(255) NOT NULL,
  `uzibruin_groen` bigint(255) NOT NULL,
  `uzibruin_blauw` bigint(255) NOT NULL,
  `uzibruin_zwart` bigint(255) NOT NULL,
  `uzibruin_roze` bigint(255) NOT NULL,
  `revolverbruin_zwart` bigint(255) NOT NULL,
  `revolverbruin_roze` bigint(255) NOT NULL,
  `ak47bruin_blauw` bigint(255) NOT NULL,
  `grenadebruin_blauw` bigint(255) NOT NULL,
  `mp5bruin_blauw` bigint(255) NOT NULL,
  `skorpionblauw_roze` bigint(255) NOT NULL,
  `m203blauw_roze` bigint(255) NOT NULL,
  `g36cblauw_roze` bigint(255) NOT NULL,
  `m4m203blauw_roze` bigint(255) NOT NULL,
  `uniek_groenejas` bigint(255) NOT NULL,
  `uniek_zilverenschoen` bigint(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `mf_misdaad`
--


CREATE TABLE IF NOT EXISTS `mf_misdaad` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `naam` varchar(255) NOT NULL,
  `delendoor` varchar(255) NOT NULL,
  `mingeld` int(255) NOT NULL,
  `exp` int(255) NOT NULL,
  `maxgeld` int(255) NOT NULL,
  `misdaadkansplus` int(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;


-- --------------------------------------------------------


--
-- Table structure for table `mf_prijzen`
--


CREATE TABLE IF NOT EXISTS `mf_prijzen` (
  `soort` varchar(255) NOT NULL,
  `prijs` int(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `mf_prijzentijd`
--


CREATE TABLE IF NOT EXISTS `mf_prijzentijd` (
  `tijd` datetime NOT NULL,
  `klasse` int(255) NOT NULL DEFAULT '1',
  `verw` int(255) NOT NULL,
  `nu` int(225) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `mf_wapenfabriek`
--


CREATE TABLE IF NOT EXISTS `mf_wapenfabriek` (
  `id` bigint(255) NOT NULL AUTO_INCREMENT,
  `eigenaar` varchar(255) NOT NULL DEFAULT '',
  `uitbreiding` int(255) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;


-- --------------------------------------------------------


--
-- Table structure for table `mf_wapenfabriekmaak`
--


CREATE TABLE IF NOT EXISTS `mf_wapenfabriekmaak` (
  `id` bigint(255) NOT NULL DEFAULT '0',
  `wapeninmaak` varchar(255) NOT NULL DEFAULT '',
  `tijdnu` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `wachten` int(255) NOT NULL DEFAULT '0',
  `aantal` int(255) NOT NULL DEFAULT '0',
  `eigenaar` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `missionfight_mobs`
--


CREATE TABLE IF NOT EXISTS `missionfight_mobs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `chance_min` int(11) NOT NULL DEFAULT '0',
  `chance_max` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT 'Geen',
  `dmg` int(11) NOT NULL DEFAULT '0',
  `hp` int(11) NOT NULL DEFAULT '0',
  `def` int(11) NOT NULL DEFAULT '0',
  `crit` int(11) NOT NULL DEFAULT '0',
  `diff` int(11) NOT NULL DEFAULT '0',
  `reward_money_min` int(11) NOT NULL DEFAULT '0',
  `reward_money_max` int(11) NOT NULL DEFAULT '0',
  `reward_reputation` int(11) NOT NULL DEFAULT '0',
  `reward_item_1` varchar(255) NOT NULL DEFAULT '1x0',
  `reward_item_2` varchar(255) NOT NULL DEFAULT '1x0',
  `reward_item_3` varchar(255) NOT NULL DEFAULT '1x0',
  `reward_item_4` varchar(255) NOT NULL DEFAULT '1x0',
  `reward_item_5` varchar(255) NOT NULL DEFAULT '1x0',
  `reward_item_6` varchar(255) NOT NULL DEFAULT '1x0',
  `reward_item_7` varchar(255) NOT NULL DEFAULT '1x0',
  `reward_item_8` varchar(255) NOT NULL DEFAULT '1x0',
  `reward_item_9` varchar(255) NOT NULL DEFAULT '1x0',
  `reward_item_10` varchar(255) NOT NULL DEFAULT '1x0',
  `reward_item_11` varchar(255) NOT NULL DEFAULT '1x0',
  `reward_item_12` varchar(255) NOT NULL DEFAULT '1x0',
  `reward_item_13` varchar(255) NOT NULL DEFAULT '1x0',
  `reward_item_14` varchar(255) NOT NULL DEFAULT '1x0',
  `reward_item_15` varchar(255) NOT NULL DEFAULT '1x0',
  `reward_item_16` varchar(255) NOT NULL DEFAULT '1x0',
  `reward_item_17` varchar(255) NOT NULL DEFAULT '1x0',
  `reward_item_18` varchar(255) NOT NULL DEFAULT '1x0',
  `reward_item_19` varchar(255) NOT NULL DEFAULT '1x0',
  `reward_item_20` varchar(255) NOT NULL DEFAULT '1x0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;


-- --------------------------------------------------------


--
-- Table structure for table `multiblackjack`
--


CREATE TABLE IF NOT EXISTS `multiblackjack` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player1` varchar(50) NOT NULL DEFAULT '',
  `player2` varchar(50) NOT NULL DEFAULT '',
  `player3` varchar(50) NOT NULL DEFAULT '',
  `player4` varchar(50) NOT NULL DEFAULT '',
  `score1` int(11) NOT NULL DEFAULT '0',
  `score2` int(11) NOT NULL DEFAULT '0',
  `score3` int(11) NOT NULL DEFAULT '0',
  `score4` int(11) NOT NULL DEFAULT '0',
  `gestart` int(11) NOT NULL DEFAULT '0',
  `tijd1` int(11) NOT NULL DEFAULT '0',
  `tijd2` int(11) NOT NULL DEFAULT '0',
  `tijd3` int(11) NOT NULL DEFAULT '0',
  `tijd4` int(11) NOT NULL DEFAULT '0',
  `startnew` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


-- --------------------------------------------------------


--
-- Table structure for table `multicrime`
--


CREATE TABLE IF NOT EXISTS `multicrime` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `person1` varchar(255) NOT NULL,
  `person2` varchar(255) NOT NULL,
  `starttime` varchar(255) NOT NULL,
  `status_1` int(11) NOT NULL DEFAULT '0',
  `status_2` int(11) NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '0',
  `log_cash` bigint(20) NOT NULL DEFAULT '0',
  `log_multiplier` int(11) NOT NULL DEFAULT '0',
  `log_respect` int(11) NOT NULL DEFAULT '0',
  `log_timing` decimal(20,6) NOT NULL DEFAULT '0.000000',
  `IP` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=69 ;


-- --------------------------------------------------------


--
-- Table structure for table `news_ingame`
--


CREATE TABLE IF NOT EXISTS `news_ingame` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` bigint(20) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;


-- --------------------------------------------------------


--
-- Table structure for table `nieuws`
--


CREATE TABLE IF NOT EXISTS `nieuws` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `TITLE` text NOT NULL,
  `NAME` text NOT NULL,
  `TIME` date NOT NULL DEFAULT '0000-00-00',
  `TXT` text NOT NULL,
  `view` char(3) NOT NULL DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=83 ;


-- --------------------------------------------------------


--
-- Table structure for table `onlinetime`
--


CREATE TABLE IF NOT EXISTS `onlinetime` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `ticks` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


-- --------------------------------------------------------


--
-- Table structure for table `partneradmin`
--


CREATE TABLE IF NOT EXISTS `partneradmin` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL DEFAULT '',
  `password` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;


-- --------------------------------------------------------


--
-- Table structure for table `partners`
--


CREATE TABLE IF NOT EXISTS `partners` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `naam` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(50) NOT NULL DEFAULT '',
  `sitenaam` varchar(50) NOT NULL DEFAULT '',
  `siteurl` varchar(100) NOT NULL DEFAULT '',
  `inhits` int(4) NOT NULL DEFAULT '0',
  `uithits` int(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;


-- --------------------------------------------------------


--
-- Table structure for table `pawnshop`
--


CREATE TABLE IF NOT EXISTS `pawnshop` (
  `stad` varchar(255) NOT NULL DEFAULT '',
  `tv` int(4) NOT NULL DEFAULT '500',
  `schilderij` int(5) NOT NULL DEFAULT '1000',
  `cinema` char(3) NOT NULL DEFAULT '50',
  `juwelenkist` char(3) NOT NULL DEFAULT '50',
  `laptop` varchar(5) NOT NULL DEFAULT '2500'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `reset`
--


CREATE TABLE IF NOT EXISTS `reset` (
  `allowed` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `schietlog`
--


CREATE TABLE IF NOT EXISTS `schietlog` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `tijd` datetime NOT NULL,
  `login` varchar(255) NOT NULL,
  `raak` int(10) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;


-- --------------------------------------------------------


--
-- Table structure for table `tickets`
--


CREATE TABLE IF NOT EXISTS `tickets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `naam` varchar(50) NOT NULL DEFAULT '',
  `afzender` varchar(50) NOT NULL DEFAULT '',
  `bericht` text NOT NULL,
  `antwoord` text NOT NULL,
  `datum` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ban` varchar(5) NOT NULL DEFAULT '0',
  `optie` varchar(50) NOT NULL DEFAULT 'geen',
  `onderwerp` varchar(50) NOT NULL DEFAULT 'nul',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;


-- --------------------------------------------------------


--
-- Table structure for table `uniekehits`
--


CREATE TABLE IF NOT EXISTS `uniekehits` (
  `ip` varchar(40) NOT NULL DEFAULT '',
  `dag` varchar(40) NOT NULL DEFAULT '',
  `id` char(3) NOT NULL DEFAULT '',
  `status` char(3) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `unsub`
--


CREATE TABLE IF NOT EXISTS `unsub` (
  `amount` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `usage`
--


CREATE TABLE IF NOT EXISTS `usage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `day` date NOT NULL,
  `weekday` int(11) NOT NULL,
  `crime1` int(11) NOT NULL DEFAULT '0',
  `last_crime1` int(11) NOT NULL DEFAULT '0',
  `estimated_crime1` int(11) NOT NULL,
  `leftover_crime1` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=192 ;


-- --------------------------------------------------------


--
-- Table structure for table `users_CW`
--


CREATE TABLE IF NOT EXISTS `users_CW` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `login` varchar(50) DEFAULT NULL,
  `email` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `login` (`login`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=1 ;


-- --------------------------------------------------------


--
-- Table structure for table `warnings`
--


CREATE TABLE IF NOT EXISTS `warnings` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `datum` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `gebruiker` varchar(255) NOT NULL DEFAULT '',
  `niveau` varchar(255) NOT NULL DEFAULT '',
  `admin` varchar(255) NOT NULL DEFAULT '',
  `reden` text NOT NULL,
  `setback` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


-- --------------------------------------------------------


--
-- Table structure for table `wars`
--


CREATE TABLE IF NOT EXISTS `wars` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `clan_attack` int(16) NOT NULL,
  `clan_defend` int(16) NOT NULL,
  `starter` varchar(16) NOT NULL DEFAULT '',
  `datum` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_attack` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `vrede` int(5) NOT NULL DEFAULT '0',
  `CAo` varchar(16) NOT NULL,
  `CDo` varchar(16) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


-- --------------------------------------------------------


--
-- Table structure for table `weapons`
--


CREATE TABLE IF NOT EXISTS `weapons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(255) NOT NULL,
  `type` int(11) NOT NULL,
  `upgrade` int(11) NOT NULL DEFAULT '0',
  `crystal_1` int(11) NOT NULL,
  `crystal_2` int(11) NOT NULL,
  `crystal_3` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=254 ;


-- --------------------------------------------------------


--
-- Table structure for table `weapon_crystals`
--


CREATE TABLE IF NOT EXISTS `weapon_crystals` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(255) NOT NULL,
  `type` int(11) NOT NULL,
  `grade` int(11) NOT NULL,
  `percentage` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `login` (`login`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=319 ;


-- --------------------------------------------------------


--
-- Table structure for table `weapon_stats`
--


CREATE TABLE IF NOT EXISTS `weapon_stats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT 'Geen wapen',
  `ATK` int(11) NOT NULL DEFAULT '0',
  `SPD` int(11) NOT NULL DEFAULT '0',
  `ACC` int(11) NOT NULL DEFAULT '0',
  `price` int(11) NOT NULL DEFAULT '0',
  `upgradeprice` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;


--
-- Dumping data for table `weapon_stats`
--


INSERT INTO `weapon_stats` (`id`, `name`, `ATK`, `SPD`, `ACC`, `price`, `upgradeprice`) VALUES
(1, 'Pistool', 2000, 1500, 1500, 1000000, 500000),
(2, 'Krachtig Pistool', 2500, 1500, 1500, 0, 1000000),
(3, 'Snelvurend Pistool', 2000, 1875, 1500, 0, 1000000),
(4, 'Accuraat Pistool', 2000, 1500, 1875, 0, 1000000),
(5, 'Super Pistool', 2500, 1875, 1875, 0, 2000000),
(6, 'Superkrachtig Pistool', 3000, 1500, 1500, 0, 4000000),
(7, 'Supersnelvurend Pistool', 2000, 2250, 1500, 0, 4000000),
(8, 'Superaccuraat Pistool', 2000, 1500, 2250, 0, 4000000),
(9, '&Uuml;ber Pistool', 3000, 2250, 2250, 0, 8000000);


-- --------------------------------------------------------


--
-- Table structure for table `[actionslog]`
--


CREATE TABLE IF NOT EXISTS `[actionslog]` (
  `time` datetime DEFAULT NULL,
  `login` varchar(64) DEFAULT NULL,
  `action` varchar(256) DEFAULT NULL,
  `post` text,
  `get` text,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subaction` varchar(255) DEFAULT NULL,
  `read` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=51 ;


-- --------------------------------------------------------


--
-- Table structure for table `[allies]`
--


CREATE TABLE IF NOT EXISTS `[allies]` (
  `login` varchar(64) DEFAULT NULL,
  `person` varchar(64) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  `log` varchar(64) DEFAULT NULL,
  `accepted` int(11) DEFAULT NULL,
  `prijs` bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `[bankoverval]`
--


CREATE TABLE IF NOT EXISTS `[bankoverval]` (
  `geld` bigint(255) NOT NULL DEFAULT '100000',
  `land` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `[banned]`
--


CREATE TABLE IF NOT EXISTS `[banned]` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(255) NOT NULL,
  `ip` varchar(255) NOT NULL,
  `reden` varchar(255) NOT NULL,
  `straf` varchar(255) NOT NULL,
  `user` varchar(255) NOT NULL,
  `time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `User` (`login`),
  KEY `login` (`login`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;


-- --------------------------------------------------------


--
-- Table structure for table `[bedrijven]`
--


CREATE TABLE IF NOT EXISTS `[bedrijven]` (
  `b_id` int(5) NOT NULL AUTO_INCREMENT,
  `bedrijf` varchar(255) NOT NULL DEFAULT '',
  `eigenaar` varchar(255) NOT NULL DEFAULT 'CrimeGame.BE',
  `winst` varchar(255) NOT NULL DEFAULT '0',
  `prijs` varchar(255) NOT NULL DEFAULT '0',
  PRIMARY KEY (`b_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ;


--
-- Dumping data for table `[bedrijven]`
--


INSERT INTO `[bedrijven]` (`b_id`, `bedrijf`, `eigenaar`, `winst`, `prijs`) VALUES
(24, 'mcdonald', 'NoMercy', '16983495809', '424587395219'),
(23, 'Staatsloterij', 'Senseo', '6386400', '159660000'),
(22, 'kogel', 'Old_Legend', '95912800000', '2397819999990'),
(21, 'microsoft', 'cab', '99969840359', '2499246008979'),
(20, 'nmbs', 'kipje', '434540656', '10863516408'),
(19, 'dexia', 'reaper', '16200000', '405000000'),
(18, 'ziekenhuis', 'Mafiaforce', '0', '0'),
(17, 'Febo', 'wesley160', '131364406', '3284110140'),
(16, 'delijn', 'Mafiaforce', '0', '0'),
(15, 'kpn', 'Mafiaforce', '0', '0'),
(14, 'sabena', 'Mafiaforce', '0', '0'),
(13, 'nachtclub', 'Darkness', '36000', '900000'),
(12, 'connexxion', 'Mafiaforce', '0', '0'),
(11, 'dhl', 'Mafiaforce', '0', '0'),
(10, 'belgacom', 'Mafiaforce', '0', '0'),
(9, 'essent', 'Mafiaforce', '0', '0'),
(8, 'ns', 'Mafiaforce', '0', '0'),
(7, 'advoc', 'Mafiaforce', '0', '0'),
(6, 'internet', 'bigg-boss', '3053753280', '76343831997'),
(5, 'auto', 'Mafiaforce', '0', '0'),
(4, 'vuurwerk', 'SG95', '0', '0'),
(3, 'vliegveld', 'tthemaffia', '0', '0'),
(2, 'haven', 'Mafiaforce', '0', '0'),
(1, 'taxi', 'Mafiaforce', '0', '0'),
(25, 'wapenshop', 'pipo', '34038509', '850962719');


-- --------------------------------------------------------


--
-- Table structure for table `[beljp]`
--


CREATE TABLE IF NOT EXISTS `[beljp]` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(255) NOT NULL,
  `checked` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


-- --------------------------------------------------------


--
-- Table structure for table `[bellen-nieuw]`
--


CREATE TABLE IF NOT EXISTS `[bellen-nieuw]` (
  `login` varchar(255) NOT NULL,
  `totaal_bel` int(10) NOT NULL,
  `totaal_sms` int(10) NOT NULL,
  `totaal_wallie` int(10) NOT NULL,
  `totaal_ideal` int(10) NOT NULL,
  `totaal_actie` int(10) NOT NULL,
  `points` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `[beveiliging]`
--


CREATE TABLE IF NOT EXISTS `[beveiliging]` (
  `id` int(50) NOT NULL DEFAULT '0',
  `naam` varchar(255) NOT NULL DEFAULT '',
  `tijd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `uren` int(10) NOT NULL DEFAULT '0',
  `soort` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `[casinoo]`
--


CREATE TABLE IF NOT EXISTS `[casinoo]` (
  `owner` varchar(250) DEFAULT '0',
  `spel` int(250) DEFAULT NULL,
  `land` varchar(255) NOT NULL DEFAULT '0',
  `tijd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `vw` int(255) NOT NULL DEFAULT '0',
  `maximum` int(255) NOT NULL DEFAULT '0',
  `casinobank` bigint(255) NOT NULL DEFAULT '0',
  `login` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `[clanban]`
--


CREATE TABLE IF NOT EXISTS `[clanban]` (
  `id` int(255) NOT NULL DEFAULT '0',
  `clan` varchar(255) NOT NULL DEFAULT '',
  `speler` varchar(255) NOT NULL DEFAULT '',
  `door` varchar(255) NOT NULL DEFAULT '',
  `datum` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `reden` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `[clanloon]`
--


CREATE TABLE IF NOT EXISTS `[clanloon]` (
  `speler` varchar(100) NOT NULL DEFAULT '',
  `door` varchar(100) NOT NULL DEFAULT '',
  `clan` varchar(100) NOT NULL DEFAULT '',
  `datum` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `reden` varchar(100) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `[clans]`
--


CREATE TABLE IF NOT EXISTS `[clans]` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(16) NOT NULL DEFAULT '',
  `owner` varchar(16) NOT NULL DEFAULT '',
  `started` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `warning` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `type` int(1) NOT NULL DEFAULT '0',
  `info` text NOT NULL,
  `recruit` bigint(255) NOT NULL DEFAULT '1',
  `instapcost` bigint(255) NOT NULL DEFAULT '0',
  `invites` int(5) NOT NULL DEFAULT '1',
  `clanurl` varchar(255) NOT NULL DEFAULT 'images/uitroepteken.gif',
  `clicks` int(5) NOT NULL DEFAULT '0',
  `clickstoday` int(3) NOT NULL DEFAULT '0',
  `cash` bigint(20) NOT NULL DEFAULT '0',
  `bank` bigint(20) NOT NULL DEFAULT '0',
  `bankleft` int(2) NOT NULL DEFAULT '10',
  `bankmax` bigint(14) NOT NULL DEFAULT '999999999999999',
  `attwins` int(6) NOT NULL DEFAULT '0',
  `attlosses` int(6) NOT NULL DEFAULT '0',
  `defwins` int(6) NOT NULL DEFAULT '0',
  `deflosses` int(6) NOT NULL DEFAULT '0',
  `land` bigint(6) NOT NULL DEFAULT '5000',
  `homes` int(3) NOT NULL DEFAULT '1',
  `money_lvl1` bigint(15) NOT NULL DEFAULT '0',
  `money_lvl2` bigint(15) NOT NULL DEFAULT '0',
  `money_lvl3` bigint(15) NOT NULL DEFAULT '0',
  `def_lvl1` bigint(15) NOT NULL DEFAULT '0',
  `def_lvl2` bigint(15) NOT NULL DEFAULT '0',
  `def_lvl3` int(3) NOT NULL DEFAULT '0',
  `war` varchar(16) NOT NULL DEFAULT '',
  `IPs` text NOT NULL,
  `money_lvl9` bigint(15) NOT NULL DEFAULT '0',
  `money_lvl10` bigint(15) NOT NULL DEFAULT '0',
  `minpower` bigint(20) NOT NULL DEFAULT '0',
  `clancrimes` int(11) NOT NULL DEFAULT '0',
  `cctime` datetime NOT NULL,
  `ccwait` int(11) NOT NULL DEFAULT '86400',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;


-- --------------------------------------------------------


--
-- Table structure for table `[clicklist]`
--


CREATE TABLE IF NOT EXISTS `[clicklist]` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `login` varchar(16) NOT NULL DEFAULT '',
  `set` varchar(255) NOT NULL DEFAULT '',
  `clicks` bigint(255) NOT NULL DEFAULT '0',
  `wat` varchar(255) NOT NULL DEFAULT '0',
  `aantal` bigint(255) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=67605 ;


-- --------------------------------------------------------


--
-- Table structure for table `[cocaine]`
--


CREATE TABLE IF NOT EXISTS `[cocaine]` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `aanvaller` varchar(26) NOT NULL DEFAULT '',
  `verdediger` varchar(26) NOT NULL DEFAULT '',
  `cocaine` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


-- --------------------------------------------------------


--
-- Table structure for table `[coffeshop]`
--


CREATE TABLE IF NOT EXISTS `[coffeshop]` (
  `id` int(11) NOT NULL DEFAULT '0',
  `owner` varchar(20) NOT NULL DEFAULT '',
  `aantal` mediumint(5) NOT NULL DEFAULT '500',
  `code` int(2) NOT NULL DEFAULT '0',
  `prijs` int(2) NOT NULL DEFAULT '0',
  `gram` int(255) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `[dealen]`
--


CREATE TABLE IF NOT EXISTS `[dealen]` (
  `wiet` int(5) DEFAULT NULL,
  `hash` int(5) DEFAULT NULL,
  `LSD` int(5) DEFAULT NULL,
  `speed` int(5) DEFAULT NULL,
  `vuurwerk` int(5) DEFAULT NULL,
  `heroine` int(5) DEFAULT NULL,
  `XTC` int(5) DEFAULT NULL,
  `prijs` int(2) DEFAULT NULL,
  KEY `wiet` (`wiet`),
  KEY `hash` (`hash`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `[desk]`
--


CREATE TABLE IF NOT EXISTS `[desk]` (
  `postID` int(11) NOT NULL AUTO_INCREMENT,
  `postTITLE` text NOT NULL,
  `posterNAME` text NOT NULL,
  `posterOW` text NOT NULL,
  `postTIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `postTXT` text NOT NULL,
  `ip` varchar(255) NOT NULL DEFAULT '',
  `reac` text NOT NULL,
  PRIMARY KEY (`postID`),
  FULLTEXT KEY `reac` (`reac`),
  FULLTEXT KEY `reac_2` (`reac`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;


-- --------------------------------------------------------


--
-- Table structure for table `[detectives]`
--


CREATE TABLE IF NOT EXISTS `[detectives]` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` int(11) DEFAULT NULL,
  `country` varchar(64) DEFAULT NULL,
  `cost` int(11) DEFAULT NULL,
  `bonus` int(11) DEFAULT NULL,
  `starttime` datetime DEFAULT NULL,
  `runtime` int(11) DEFAULT NULL,
  `foundtime` datetime DEFAULT NULL,
  `followtime` int(11) DEFAULT NULL,
  `attacker` varchar(64) DEFAULT NULL,
  `target` varchar(64) DEFAULT NULL,
  `foundcountry` varchar(64) DEFAULT NULL,
  `found` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ;


-- --------------------------------------------------------


--
-- Table structure for table `[detective]`
--


CREATE TABLE IF NOT EXISTS `[detective]` (
  `id` int(200) NOT NULL AUTO_INCREMENT,
  `naam` varchar(200) DEFAULT NULL,
  `zoeker` varchar(200) DEFAULT NULL,
  `uren` int(200) NOT NULL DEFAULT '0',
  `tijd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `vind` int(200) NOT NULL DEFAULT '0',
  `status` int(200) NOT NULL DEFAULT '0',
  `land` varchar(225) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `uren` (`uren`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


-- --------------------------------------------------------


--
-- Table structure for table `[drugs]`
--


CREATE TABLE IF NOT EXISTS `[drugs]` (
  `d_id` int(5) NOT NULL AUTO_INCREMENT,
  `drugs` varchar(255) NOT NULL DEFAULT '',
  `eigenaar` varchar(255) NOT NULL DEFAULT 'CrimeGame.BE',
  `winst` varchar(255) NOT NULL DEFAULT '',
  `prijs` varchar(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`d_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ;


--
-- Dumping data for table `[drugs]`
--


INSERT INTO `[drugs]` (`d_id`, `drugs`, `eigenaar`, `winst`, `prijs`) VALUES
(1, 'cannabis', 'Icaquestrix', '3222', '161100'),
(2, 'xtc', 'NoMercy', '5000', '1000000'),
(3, 'speed', 'wesley160', '0', '0'),
(4, 'cocaine', 'bigg-boss', '5000', '1000000'),
(5, 'paddos', 'SG95', '0', '0'),
(6, 'hasj', 'Mafiaforce', '0', '0'),
(7, 'marihuana', 'cab', '88758001800', '4437900090000'),
(8, 'poppers', 'Mafiaforce', '0', '0'),
(9, 'lsd', 'tthemaffia', '0', '0'),
(10, 'lijm', 'Mafiaforce', '0', '0'),
(11, 'ghb', 'gunny-bunny', '11142000', '557100000'),
(12, 'crack', 'iownumanyea', '546739', '27336947'),
(13, 'amfetamine', 'Mafiaforce', '0', '0'),
(14, 'opium', 'Mafiaforce', '0', '0'),
(15, 'methadon', 'Mafiaforce', '0', '0'),
(16, 'alcohol', 'Mafiaforce', '0', '0'),
(17, 'heroine', 'Icaquestrix', '18000', '900000'),
(18, 'wiet', 'zombie12345', '521637', '26081854'),
(19, 'spacecake', 'mafiaforce.nl', '0', '0'),
(20, 'joint', 'kipje', '0', '0'),
(21, 'morfine', 'Mafiaforce', '0', '0'),
(22, 'nicotine', 'bartjuhh', '119900', '5995000'),
(23, 'MDA', 'Mafiaforce', '0', '0'),
(24, 'cafeine', 'Mafiaforce', '0', '0'),
(25, 'atropine', 'reaper', '9000000', '450000000');


-- --------------------------------------------------------


--
-- Table structure for table `[enemies]`
--


CREATE TABLE IF NOT EXISTS `[enemies]` (
  `login` varchar(255) DEFAULT NULL,
  `enemy` varchar(255) DEFAULT NULL,
  KEY `login` (`login`),
  KEY `enemy` (`enemy`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `[escrow]`
--


CREATE TABLE IF NOT EXISTS `[escrow]` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `naam1` varchar(255) NOT NULL DEFAULT '',
  `naam2` varchar(255) NOT NULL DEFAULT '',
  `bedrag` int(255) NOT NULL DEFAULT '0',
  `land` varchar(32) NOT NULL DEFAULT '',
  `type` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


-- --------------------------------------------------------


--
-- Table structure for table `[friends]`
--


CREATE TABLE IF NOT EXISTS `[friends]` (
  `login` varchar(255) DEFAULT NULL,
  `friend` varchar(255) DEFAULT NULL,
  KEY `login` (`login`),
  KEY `friend` (`friend`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `[getuige]`
--


CREATE TABLE IF NOT EXISTS `[getuige]` (
  `id` int(11) NOT NULL DEFAULT '0',
  `naam` varchar(50) NOT NULL DEFAULT '',
  `vermoord` varchar(50) NOT NULL DEFAULT '',
  `moorder` varchar(50) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `[hitlist]`
--


CREATE TABLE IF NOT EXISTS `[hitlist]` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `naam` varchar(255) NOT NULL DEFAULT '',
  `reden` text NOT NULL,
  `geld` int(255) NOT NULL DEFAULT '0',
  `invoeger` varchar(255) NOT NULL DEFAULT 'Anoniem',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;


-- --------------------------------------------------------


--
-- Table structure for table `[hits]`
--


CREATE TABLE IF NOT EXISTS `[hits]` (
  `page` varchar(64) DEFAULT NULL,
  `hits` bigint(20) DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  KEY `page` (`page`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=220 ;


--
-- Dumping data for table `[hits]`
--


INSERT INTO `[hits]` (`page`, `hits`, `id`) VALUES
('hoofdkwartier', 6, 191),
('berichten', 4, 192),
('creditsgratis', 1, 193),
('betaald-pretparken2', 5, 194),
('creditskopen', 1, 195),
('vipmaker', 1, 196),
('admin_index', 3, 197),
('huurbescherming', 1, 198),
('crimes', 1, 199),
('autos', 2, 200),
('weapons', 2, 201),
('defence', 2, 202),
('detective', 1, 203),
('weapon_crystals', 1, 204),
('shop', 1, 205),
('admin_pretpark', 1, 206),
('betaald-drugsplantage2', 2, 207),
('betaald-bedrijven2', 1, 208),
('menu_casino', 1, 209),
('casino-krassen', 1, 210),
('click-shop', 1, 211),
('creditsshop', 1, 212),
('profile', 2, 213),
('clan-statistieken', 1, 214),
('redlightdistrict', 1, 215),
('wapenfabriek', 1, 216),
('poker', 1, 217),
('list', 2, 218),
('ticket_systeem', 1, 219);


-- --------------------------------------------------------


--
-- Table structure for table `[ironproduction]`
--


CREATE TABLE IF NOT EXISTS `[ironproduction]` (
  `lastcheck` datetime DEFAULT NULL,
  `login` varchar(64) DEFAULT NULL,
  `lastlandbuy` datetime DEFAULT NULL,
  `productionlevel` int(11) DEFAULT '1',
  `speedproduction` int(11) DEFAULT '1',
  `land` decimal(64,4) DEFAULT NULL,
  `landused` decimal(64,4) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `[job]`
--


CREATE TABLE IF NOT EXISTS `[job]` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `land` varchar(100) NOT NULL DEFAULT '',
  `firma` int(255) NOT NULL DEFAULT '10000',
  `active` int(255) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;


-- --------------------------------------------------------


--
-- Table structure for table `[killlimit]`
--


CREATE TABLE IF NOT EXISTS `[killlimit]` (
  `attacker` varchar(64) DEFAULT NULL,
  `defender` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `[kils]`
--


CREATE TABLE IF NOT EXISTS `[kils]` (
  `time` datetime DEFAULT NULL,
  `login` varchar(64) DEFAULT NULL,
  `killer` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `[kraakkluis]`
--


CREATE TABLE IF NOT EXISTS `[kraakkluis]` (
  `kluis` int(10) NOT NULL,
  `code` int(10) NOT NULL DEFAULT '3',
  `winnaar` varchar(15) NOT NULL,
  `area` int(4) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `[kraaknr]`
--


CREATE TABLE IF NOT EXISTS `[kraaknr]` (
  `id` int(4) NOT NULL DEFAULT '0',
  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `login` varchar(255) NOT NULL DEFAULT '',
  `getal` int(3) NOT NULL DEFAULT '0',
  `area` int(3) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `[land]`
--


CREATE TABLE IF NOT EXISTS `[land]` (
  `id` int(11) NOT NULL DEFAULT '0',
  `owner` varchar(255) NOT NULL DEFAULT '',
  `naam` varchar(255) NOT NULL DEFAULT '',
  `land` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `[loginlog]`
--


CREATE TABLE IF NOT EXISTS `[loginlog]` (
  `time` datetime DEFAULT NULL,
  `IP` varchar(32) DEFAULT NULL,
  `login` varchar(64) DEFAULT NULL,
  `browser` text,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=759 ;


--
-- Dumping data for table `[loginlog]`
--


INSERT INTO `[loginlog]` (`time`, `IP`, `login`, `browser`, `id`) VALUES
('2011-09-25 16:20:46', '84.197.152.121', 'Old_Legend', 'Mozilla/5.0 (Windows NT 6.0; WOW64) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/14.0.835.186 Safari/535.1', 754),
('2011-09-25 18:57:02', '84.197.152.121', 'Old_Legend', 'Mozilla/5.0 (Windows NT 6.0; WOW64) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/14.0.835.186 Safari/535.1', 755),
('2011-09-25 18:57:13', '84.197.152.121', 'Old_Legend', 'Mozilla/5.0 (Windows NT 6.0; WOW64) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/14.0.835.186 Safari/535.1', 756),
('2011-09-25 19:25:37', '84.197.152.121', 'Admin', 'Mozilla/5.0 (Windows NT 6.0; WOW64) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/14.0.835.186 Safari/535.1', 757),
('2011-09-25 19:29:03', '84.197.152.121', 'Admin', 'Mozilla/5.0 (Windows NT 6.0; WOW64) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/14.0.835.186 Safari/535.1', 758);


-- --------------------------------------------------------


--
-- Table structure for table `[logs]`
--


CREATE TABLE IF NOT EXISTS `[logs]` (
  `time` datetime DEFAULT NULL,
  `IP` varchar(32) DEFAULT NULL,
  `forwardedFor` varchar(32) DEFAULT NULL,
  `login` varchar(50) DEFAULT NULL,
  `person` varchar(30) DEFAULT NULL,
  `code` varchar(100) DEFAULT NULL,
  `price` varchar(255) DEFAULT NULL,
  `area` varchar(32) DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  KEY `login` (`login`),
  KEY `area` (`area`),
  KEY `time` (`time`),
  KEY `person` (`person`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1384 ;


-- --------------------------------------------------------


--
-- Table structure for table `[messages]`
--


CREATE TABLE IF NOT EXISTS `[messages]` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `IP` varchar(32) NOT NULL DEFAULT '',
  `forwardedFor` varchar(32) DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `from` varchar(19) DEFAULT NULL,
  `to` varchar(16) DEFAULT NULL,
  `subject` varchar(50) NOT NULL DEFAULT '',
  `message` text NOT NULL,
  `read` int(1) NOT NULL DEFAULT '0',
  `inbox` int(1) DEFAULT '1',
  `outbox` int(1) DEFAULT '1',
  `saved` int(1) NOT NULL DEFAULT '0',
  `ow` varchar(255) NOT NULL,
  `contactdesk` int(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `inbox` (`inbox`),
  KEY `read` (`read`),
  KEY `to` (`to`),
  KEY `from` (`from`),
  KEY `outbox` (`outbox`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1567 ;


--
-- Dumping data for table `[messages]`
--


INSERT INTO `[messages]` (`id`, `IP`, `forwardedFor`, `time`, `from`, `to`, `subject`, `message`, `read`, `inbox`, `outbox`, `saved`, `ow`, `contactdesk`) VALUES
(1563, '84.197.152.121', '', '2011-09-25 16:19:58', '** crimegame.org **', '', 'Recruiter', 'Old_Legend is een referal van jou geworden.\nKijk snel bij Referals voor de taken die hij moet voltooien voordat je iets krijgt!', 0, 1, 1, 0, '', 0),
(1564, '84.197.152.121', '', '2011-09-25 16:19:58', '** crimegame.org **', 'Old_Legend', 'Welkom!', 'Welkom op crimegame.org Old_Legend,\n\nAls er vragen zijn kan je die altijd stellen bij een onl;ine HDO [Help desk operator] het team zal je graag verder helpen en wat Tips geven om het spel goed te beheren.\nNodig zoveel mogelijk leden uit met je Aanmeld Link link uit je hoofdkwartier en verdien geld/credits/power/clicks.\nKlik je zelf om het uur in de klikmissie en ruil ze in tegen credits om eventueel betaald account te kopen of iets anders uit het lijstje.\n\nLees aub ook de regels door, zie het handboek.\n\nAlvast veel speelplezier!\n\nDe crimegame.org Crew!', 1, 1, 1, 0, '', 0),
(1565, '84.197.152.121', '', '2011-09-25 19:28:05', '** crimegame.org **', '', 'Recruiter', 'Admin is een referal van jou geworden.\nKijk snel bij Referals voor de taken die hij moet voltooien voordat je iets krijgt!', 0, 1, 1, 0, '', 0),
(1566, '84.197.152.121', '', '2011-09-25 19:28:05', '** crimegame.org **', 'Admin', 'Welkom!', 'Welkom op crimegame.org Admin,\n\nAls er vragen zijn kan je die altijd stellen bij een onl;ine HDO [Help desk operator] het team zal je graag verder helpen en wat Tips geven om het spel goed te beheren.\nNodig zoveel mogelijk leden uit met je Aanmeld Link link uit je hoofdkwartier en verdien geld/credits/power/clicks.\nKlik je zelf om het uur in de klikmissie en ruil ze in tegen credits om eventueel betaald account te kopen of iets anders uit het lijstje.\n\nLees aub ook de regels door, zie het handboek.\n\nAlvast veel speelplezier!\n\nDe crimegame.org Crew!', 0, 1, 1, 0, '', 0);


-- --------------------------------------------------------


--
-- Table structure for table `[misdaadkans]`
--


CREATE TABLE IF NOT EXISTS `[misdaadkans]` (
  `time` datetime DEFAULT NULL,
  `misdaad` smallint(6) DEFAULT NULL,
  `kans` smallint(6) DEFAULT NULL,
  `login` varchar(64) DEFAULT NULL,
  `misdaadks` smallint(6) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `[misdaadontslag]`
--


CREATE TABLE IF NOT EXISTS `[misdaadontslag]` (
  `volgnr` int(11) NOT NULL AUTO_INCREMENT,
  `id` int(11) DEFAULT NULL,
  `kans` int(11) DEFAULT NULL,
  `kanslaag` int(11) DEFAULT NULL,
  `kanshoog` int(11) DEFAULT NULL,
  PRIMARY KEY (`volgnr`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


-- --------------------------------------------------------


--
-- Table structure for table `[misdaadsalaris]`
--


CREATE TABLE IF NOT EXISTS `[misdaadsalaris]` (
  `volgnr` int(11) NOT NULL AUTO_INCREMENT,
  `id` int(11) DEFAULT NULL,
  `laag` int(11) DEFAULT NULL,
  `hoog` int(11) DEFAULT NULL,
  `kanslaag` int(11) DEFAULT NULL,
  `kanshoog` int(11) DEFAULT NULL,
  PRIMARY KEY (`volgnr`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


-- --------------------------------------------------------


--
-- Table structure for table `[misdaadscenarios]`
--


CREATE TABLE IF NOT EXISTS `[misdaadscenarios]` (
  `id` int(11) DEFAULT NULL,
  `naam` varchar(64) DEFAULT NULL,
  `vollekans` int(11) DEFAULT NULL,
  `naam2` varchar(64) DEFAULT NULL,
  `pluswaardering` int(11) DEFAULT NULL,
  `minwaardering` int(11) DEFAULT NULL,
  `min2waardering` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `[misdaadscenario]`
--


CREATE TABLE IF NOT EXISTS `[misdaadscenario]` (
  `volgnr` int(11) NOT NULL AUTO_INCREMENT,
  `id` int(11) DEFAULT NULL,
  `soort` int(11) DEFAULT NULL,
  `scenario` text,
  PRIMARY KEY (`volgnr`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;


-- --------------------------------------------------------


--
-- Table structure for table `[notes]`
--


CREATE TABLE IF NOT EXISTS `[notes]` (
  `id` tinyint(4) NOT NULL DEFAULT '0',
  `login` varchar(16) NOT NULL DEFAULT '',
  `subject` tinytext NOT NULL,
  `note` text NOT NULL,
  `date` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `[omnilog]`
--


CREATE TABLE IF NOT EXISTS `[omnilog]` (
  `time` datetime DEFAULT NULL,
  `login` varchar(16) DEFAULT NULL,
  `IP` varchar(32) DEFAULT NULL,
  `forwarderFor` varchar(32) DEFAULT NULL,
  `file` varchar(64) DEFAULT NULL,
  `$_POST` text,
  `$_GET` text,
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `[onlinetiming]`
--


CREATE TABLE IF NOT EXISTS `[onlinetiming]` (
  `time` datetime DEFAULT NULL,
  `users` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- --------------------------------------------------------


--
-- Table structure for table `[pageviews]`
--


CREATE TABLE IF NOT EXISTS `[pageviews]` (
  `time` bigint(255) DEFAULT NULL,
  `login` varchar(64) DEFAULT NULL,
  `page` varchar(255) DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  KEY `time` (`time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=77057 ;


--
-- Dumping data for table `[pageviews]`
--


INSERT INTO `[pageviews]` (`time`, `login`, `page`, `id`) VALUES
(1316960449, 'Old_Legend', 'hoofdkwartier', 77008),
(1316960456, 'Old_Legend', 'berichten', 77009),
(1316960459, 'Old_Legend', 'creditsgratis', 77010),
(1316960464, 'Old_Legend', 'berichten', 77011),
(1316960467, 'Old_Legend', 'berichten', 77012),
(1316960551, 'Old_Legend', 'betaald-pretparken2', 77013),
(1316960554, 'Old_Legend', 'creditskopen', 77014),
(1316960627, 'Old_Legend', 'vipmaker', 77015),
(1316969835, 'Old_Legend', 'hoofdkwartier', 77016),
(1316969840, 'Old_Legend', 'admin_index', 77017),
(1316970146, 'Old_Legend', 'huurbescherming', 77018),
(1316970461, 'Old_Legend', 'admin_index', 77019),
(1316970470, 'Old_Legend', 'crimes', 77020),
(1316970482, 'Old_Legend', 'autos', 77021),
(1316970651, 'Old_Legend', 'autos', 77022),
(1316970737, 'Old_Legend', 'weapons', 77023),
(1316970814, 'Old_Legend', 'weapons', 77024),
(1316970823, 'Old_Legend', 'defence', 77025),
(1316970909, 'Old_Legend', 'detective', 77026),
(1316970914, 'Old_Legend', 'defence', 77027),
(1316970917, 'Old_Legend', 'weapon_crystals', 77028),
(1316970993, 'Old_Legend', 'shop', 77029),
(1316971000, 'Old_Legend', 'betaald-pretparken2', 77030),
(1316971003, 'Old_Legend', 'admin_pretpark', 77031),
(1316971011, 'Old_Legend', 'betaald-drugsplantage2', 77032),
(1316971134, 'Old_Legend', 'betaald-drugsplantage2', 77033),
(1316971140, 'Old_Legend', 'betaald-bedrijven2', 77034),
(1316971256, 'Old_Legend', 'betaald-pretparken2', 77035),
(1316971307, 'Old_Legend', 'menu_casino', 77036),
(1316971311, 'Old_Legend', 'casino-krassen', 77037),
(1316971322, 'Old_Legend', 'click-shop', 77038),
(1316971346, 'Old_Legend', 'creditsshop', 77039),
(1316971349, 'Old_Legend', 'betaald-pretparken2', 77040),
(1316971353, 'Old_Legend', 'profile', 77041),
(1316971354, 'Old_Legend', 'profile', 77042),
(1316971359, 'Old_Legend', 'betaald-pretparken2', 77043),
(1316971386, 'Old_Legend', 'clan-statistieken', 77044),
(1316971393, 'Old_Legend', 'redlightdistrict', 77045),
(1316971398, 'Old_Legend', 'wapenfabriek', 77046),
(1316971402, 'Old_Legend', 'poker', 77047),
(1316971446, 'Old_Legend', 'list', 77048),
(1316971455, 'Old_Legend', 'ticket_systeem', 77049),
(1316971539, '', 'hoofdkwartier', 77050),
(1316971542, '', 'list', 77051),
(1316971549, '', 'hoofdkwartier', 77052),
(1316971745, 'Admin', 'hoofdkwartier', 77053),
(1316971750, 'Admin', 'berichten', 77054),
(1316971754, 'Admin', 'hoofdkwartier', 77055),
(1316971759, 'Admin', 'admin_index', 77056);


-- --------------------------------------------------------


--
-- Table structure for table `[polls]`
--


CREATE TABLE IF NOT EXISTS `[polls]` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question` varchar(255) DEFAULT NULL,
  `answer1` varchar(255) DEFAULT NULL,
  `answer2` varchar(255) DEFAULT NULL,
  `answer3` varchar(255) DEFAULT NULL,
  `answer4` varchar(255) DEFAULT NULL,
  `answer5` varchar(255) DEFAULT NULL,
  `answer6` varchar(255) DEFAULT NULL,
  `answer7` varchar(255) DEFAULT NULL,
  `answer8` varchar(255) DEFAULT NULL,
  `answer9` varchar(255) DEFAULT NULL,
  `answer10` varchar(255) DEFAULT NULL,
  `votes` varchar(255) DEFAULT NULL,
  `voa1` varchar(255) DEFAULT NULL,
  `voa2` varchar(255) DEFAULT NULL,
  `voa3` varchar(255) DEFAULT NULL,
  `voa4` varchar(255) DEFAULT NULL,
  `voa5` varchar(255) DEFAULT NULL,
  `voa6` varchar(255) DEFAULT NULL,
  `voa7` varchar(255) DEFAULT NULL,
  `voa8` varchar(255) DEFAULT NULL,
  `voa9` varchar(255) DEFAULT NULL,
  `voa10` varchar(255) DEFAULT NULL,
  `activated` int(11) DEFAULT NULL,
  `answers` int(11) DEFAULT NULL,
  `result` text,
  PRIMARY KEY (`id`),
  KEY `activated` (`activated`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;


-- --------------------------------------------------------


--
-- Table structure for table `[pretparken]`
--


CREATE TABLE IF NOT EXISTS `[pretparken]` (
  `p_id` int(5) NOT NULL AUTO_INCREMENT,
  `pretparken` varchar(255) NOT NULL DEFAULT '',
  `eigenaar` varchar(255) NOT NULL DEFAULT 'CrimeGame.BE',
  `winst` varchar(255) NOT NULL DEFAULT '',
  `prijs` varchar(255) NOT NULL DEFAULT '0',
  PRIMARY KEY (`p_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ;


--
-- Dumping data for table `[pretparken]`
--


INSERT INTO `[pretparken]` (`p_id`, `pretparken`, `eigenaar`, `winst`, `prijs`) VALUES
(1, 'Efteling', 'Icaquestrix', '359243816', '5987396940'),
(2, 'Slagharen', 'thomas_v', '44520955794', '742015929900'),
(3, 'Bracalandia', 'Old_Legend', '99976680000', '1666277999996'),
(4, 'Bobbejaanland', 'zombie12345', '3857596', '64293263'),
(5, 'Toverland', 'Old_Legend', '99630076897', '1660501281621'),
(6, 'Meli', 'AmonRa', '5261316', '87688606'),
(7, 'Ravensburger', 'Mafiaforce', '0', '0'),
(8, 'Plopsaland', 'NoMercy', '99999983472', '1666673591196'),
(9, 'Powerpark', 'Darkness', '0', '0'),
(10, 'Disneyland', 'SG95', '0', '0'),
(11, 'Walibi', 'cab', '99999999999', '1666666666658'),
(12, 'Bon', 'reaper', '22302000', '371700000'),
(13, 'Movie', 'master7maste', '6120000000', '102000000000'),
(14, 'Hellendoorn', 'Mafiaforce', '0', '0'),
(15, 'Bellewaerde', 'Mafiaforce', '0', '0'),
(16, 'Lego', 'Mafiaforce', '0', '0'),
(17, 'Duinrell', 'Mafiaforce', '0', '0'),
(18, 'Tykkimaki', 'Mafiaforce', '0', '0'),
(19, 'Flamingo', 'Mafiaforce', '0', '0'),
(20, 'Drievliet', 'Mafiaforce', '0', '0'),
(21, 'Gardaland', 'Mafiaforce', '0', '0'),
(22, 'Bouwdewijnpark', 'Mafiaforce', '0', '0'),
(23, 'Phantasia', 'Mafiaforce', '0', '0'),
(24, 'Taunuswunderland', 'Mafiaforce', '0', '0'),
(25, 'Adventure', 'Mafiaforce', '0', '0');


-- --------------------------------------------------------


--
-- Table structure for table `[redlight]`
--


CREATE TABLE IF NOT EXISTS `[redlight]` (
  `ramen` int(255) NOT NULL DEFAULT '1000000',
  `land` int(6) NOT NULL DEFAULT '1',
  `id` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------


--
-- Table structure for table `[reftasks]`
--


CREATE TABLE IF NOT EXISTS `[reftasks]` (
  `master` varchar(64) DEFAULT NULL,
  `ref` varchar(64) DEFAULT NULL,
  `task` int(11) DEFAULT NULL,
  `com` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Dumping data for table `[reftasks]`
--


INSERT INTO `[reftasks]` (`master`, `ref`, `task`, `com`) VALUES
('', 'Old_Legend', 1, 0),
('', 'Old_Legend', 2, 0),
('', 'Old_Legend', 3, 0),
('', 'Old_Legend', 4, 0),
('', 'Old_Legend', 5, 0),
('', 'Old_Legend', 6, 0),
('', 'Old_Legend', 7, 0),
('', 'Admin', 1, 0),
('', 'Admin', 2, 0),
('', 'Admin', 3, 0),
('', 'Admin', 4, 0),
('', 'Admin', 5, 0),
('', 'Admin', 6, 0),
('', 'Admin', 7, 0);


-- --------------------------------------------------------


--
-- Table structure for table `[ref]`
--


CREATE TABLE IF NOT EXISTS `[ref]` (
  `master` varchar(64) DEFAULT NULL,
  `ref` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Dumping data for table `[ref]`
--


INSERT INTO `[ref]` (`master`, `ref`) VALUES
('', 'Old_Legend'),
('', 'Admin');


-- --------------------------------------------------------


--
-- Table structure for table `[temp]`
--


CREATE TABLE IF NOT EXISTS `[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`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=754 ;


-- --------------------------------------------------------


--
-- Table structure for table `[transport-scenarios]`
--


CREATE TABLE IF NOT EXISTS `[transport-scenarios]` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `soort` varchar(255) NOT NULL,
  `bericht` text NOT NULL,
  `min-reward` int(255) NOT NULL,
  `max-reward` int(255) NOT NULL,
  `min-cardamage` int(255) NOT NULL,
  `max-cardamage` int(255) NOT NULL,
  `min-lifedamage` int(255) NOT NULL,
  `max-lifedamage` int(255) NOT NULL,
  `min-clicks` int(255) NOT NULL,
  `max-clicks` int(255) NOT NULL,
  `min-jailtime` int(255) NOT NULL,
  `max-jailtime` int(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;


-- --------------------------------------------------------


--
-- Table structure for table `[users]`
--


CREATE TABLE IF NOT EXISTS `[users]` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `uitbreek` int(255) NOT NULL DEFAULT '0',
  `lpv` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `chatrank` varchar(100) NOT NULL DEFAULT 'member',
  `chatten` int(1) NOT NULL DEFAULT '0',
  `page` varchar(100) NOT NULL,
  `points` int(255) NOT NULL DEFAULT '0',
  `pimprecht` int(2) NOT NULL DEFAULT '0',
  `pollvoted` text,
  `gezondheid` int(255) NOT NULL DEFAULT '100',
  `geldbespaarder` int(255) NOT NULL DEFAULT '0',
  `gestart` int(1) NOT NULL DEFAULT '0',
  `goudstaven` int(255) NOT NULL DEFAULT '0',
  `signup` datetime DEFAULT NULL,
  `login` varchar(16) DEFAULT NULL,
  `level` int(3) NOT NULL DEFAULT '1',
  `layout` varchar(1) NOT NULL DEFAULT '1',
  `leven` int(20) NOT NULL DEFAULT '100',
  `pass` varchar(255) DEFAULT NULL,
  `plantage` int(6) NOT NULL DEFAULT '0',
  `onderzoekers` int(1) NOT NULL DEFAULT '0',
  `ontslag` int(255) NOT NULL DEFAULT '0',
  `onderduiken` int(255) NOT NULL DEFAULT '0',
  `oc_won` int(11) NOT NULL DEFAULT '0',
  `oc_lost` int(11) NOT NULL DEFAULT '0',
  `ocs` int(11) NOT NULL DEFAULT '0',
  `aland` int(4) NOT NULL DEFAULT '100',
  `airplane` int(255) NOT NULL DEFAULT '0',
  `experience` int(10) NOT NULL DEFAULT '0',
  `exp` int(255) NOT NULL DEFAULT '0',
  `energie` int(3) NOT NULL DEFAULT '100',
  `est` int(2) NOT NULL DEFAULT '0',
  `openforum` int(5) NOT NULL DEFAULT '1',
  `opvakantie` int(10) NOT NULL DEFAULT '0',
  `landcolor` varchar(8) NOT NULL DEFAULT '800000',
  `avaurl` varchar(255) NOT NULL DEFAULT 'http://www.mafiaforce.nl/images/uitroepteken.gif',
  `avatarpack` int(255) NOT NULL DEFAULT '0',
  `aanvaltijd` datetime NOT NULL,
  `aanvallen` int(11) NOT NULL DEFAULT '0',
  `aanvallenverloren` int(11) NOT NULL DEFAULT '0',
  `avatar` varchar(255) NOT NULL DEFAULT 'uitroepteken.gif',
  `wapens` int(11) NOT NULL DEFAULT '0',
  `wapen11` int(11) NOT NULL DEFAULT '0',
  `woningtekst` text NOT NULL,
  `woning` int(5) NOT NULL DEFAULT '0',
  `warn_lvl` int(3) NOT NULL DEFAULT '0',
  `wskill` varchar(20) NOT NULL DEFAULT '0.00',
  `winkel` datetime NOT NULL,
  `winkeltijd` int(15) NOT NULL DEFAULT '0',
  `pers` varchar(5) NOT NULL DEFAULT '0',
  `bstand` varchar(255) NOT NULL,
  `backfire` int(11) NOT NULL DEFAULT '201',
  `baktijd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `baan` int(255) NOT NULL DEFAULT '0',
  `beheer` varchar(255) NOT NULL DEFAULT '19900629',
  `bloodtype` varchar(255) NOT NULL DEFAULT '0',
  `bankpogingen` varchar(1) NOT NULL DEFAULT '0',
  `bescherming` int(11) NOT NULL DEFAULT '0',
  `j13` int(10) NOT NULL DEFAULT '0',
  `joint` int(5) NOT NULL DEFAULT '50',
  `jointtijd` int(255) NOT NULL DEFAULT '0',
  `job` int(255) NOT NULL DEFAULT '0',
  `typew` char(2) NOT NULL DEFAULT '2',
  `tip` smallint(20) NOT NULL DEFAULT '0',
  `tickets` int(11) NOT NULL DEFAULT '0',
  `tijdmachine` int(255) NOT NULL DEFAULT '0',
  `type` int(1) NOT NULL DEFAULT '1',
  `train` varchar(255) NOT NULL DEFAULT '0',
  `trainuur` varchar(255) NOT NULL DEFAULT '2',
  `trlvl` int(10) NOT NULL DEFAULT '0',
  `autocrime` char(2) NOT NULL DEFAULT '10',
  `autoshop` int(255) NOT NULL DEFAULT '0',
  `legim` int(255) NOT NULL DEFAULT '0',
  `weedplant` int(255) NOT NULL DEFAULT '0',
  `auto` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `auto1` int(255) NOT NULL DEFAULT '0',
  `auto2` int(255) NOT NULL DEFAULT '0',
  `autoP` varchar(255) NOT NULL DEFAULT '0',
  `garage` int(1) NOT NULL DEFAULT '0',
  `G36C` int(11) NOT NULL DEFAULT '0',
  `crime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cbuy` int(255) NOT NULL DEFAULT '0',
  `crimes` int(255) NOT NULL DEFAULT '0',
  `codechecker` int(50) NOT NULL DEFAULT '0',
  `coffeshop` int(2) NOT NULL DEFAULT '0',
  `crime1` int(11) NOT NULL DEFAULT '0',
  `crime1s` int(11) NOT NULL DEFAULT '0',
  `crime1p` int(11) NOT NULL DEFAULT '100000',
  `crime2` int(11) NOT NULL DEFAULT '0',
  `crime2s` int(11) NOT NULL DEFAULT '0',
  `crime2p` int(11) NOT NULL DEFAULT '100000',
  `crime3` int(11) NOT NULL DEFAULT '0',
  `crime3s` int(11) NOT NULL DEFAULT '0',
  `crime3p` int(11) NOT NULL DEFAULT '100000',
  `crime4` int(11) NOT NULL DEFAULT '0',
  `crime4s` int(11) NOT NULL DEFAULT '0',
  `crime4p` int(11) NOT NULL DEFAULT '100000',
  `misdaad` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `msn` int(2) NOT NULL DEFAULT '0',
  `misdaadtijd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `misdaadkans` int(100) NOT NULL DEFAULT '50',
  `missie` int(255) NOT NULL DEFAULT '0',
  `missie_1` int(25) NOT NULL DEFAULT '0',
  `missie_2` int(25) NOT NULL DEFAULT '0',
  `missie_3` int(25) NOT NULL DEFAULT '0',
  `missie_4` int(25) NOT NULL DEFAULT '0',
  `missie_5` int(25) NOT NULL DEFAULT '0',
  `missie_6` int(25) NOT NULL DEFAULT '0',
  `missie_7` int(25) NOT NULL DEFAULT '0',
  `missie_8` int(25) NOT NULL DEFAULT '0',
  `missie_9` int(25) NOT NULL DEFAULT '0',
  `missie_10` int(25) NOT NULL DEFAULT '0',
  `missie_11` int(25) NOT NULL DEFAULT '0',
  `missie_12` int(25) NOT NULL DEFAULT '0',
  `missie_13` int(25) NOT NULL DEFAULT '0',
  `moord` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `moorden` varchar(255) NOT NULL DEFAULT '0',
  `moordexp` varchar(100) NOT NULL DEFAULT '0',
  `moordtijd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `moordtime` varchar(50) NOT NULL DEFAULT '0',
  `m16` int(255) NOT NULL DEFAULT '0',
  `m16b` int(255) NOT NULL DEFAULT '0',
  `m16v` int(255) NOT NULL DEFAULT '0',
  `m60` int(255) NOT NULL DEFAULT '0',
  `m60b` int(255) NOT NULL DEFAULT '0',
  `m60v` int(255) NOT NULL DEFAULT '0',
  `m66` int(255) NOT NULL DEFAULT '5',
  `m6` int(255) NOT NULL DEFAULT '0',
  `m11` int(255) NOT NULL DEFAULT '5',
  `m22` int(255) NOT NULL DEFAULT '4',
  `m33` int(255) NOT NULL DEFAULT '4',
  `m49` int(255) NOT NULL DEFAULT '3',
  `m55` int(255) NOT NULL DEFAULT '3',
  `M82a1` int(11) NOT NULL DEFAULT '0',
  `mailwitness` int(255) NOT NULL,
  `gram` int(255) NOT NULL DEFAULT '0',
  `ar` char(2) NOT NULL DEFAULT '0',
  `escr` char(3) NOT NULL DEFAULT '0',
  `stat` varchar(200) NOT NULL,
  `steel` datetime NOT NULL,
  `steeltijd` int(255) NOT NULL DEFAULT '0',
  `stempunten` int(255) NOT NULL DEFAULT '1',
  `sig552` int(255) NOT NULL DEFAULT '0',
  `sig552b` int(255) NOT NULL DEFAULT '0',
  `sig552v` int(255) NOT NULL DEFAULT '0',
  `status` varchar(255) NOT NULL DEFAULT 'cit',
  `aantbedrijf` varchar(255) NOT NULL DEFAULT '0',
  `aantdrugs` varchar(255) NOT NULL DEFAULT '0',
  `aantpretpark` varchar(255) NOT NULL DEFAULT '0',
  `attackdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `attacktime` int(255) NOT NULL DEFAULT '0',
  `ak47` int(255) NOT NULL DEFAULT '0',
  `ak47elite` bigint(20) NOT NULL DEFAULT '0',
  `ak47b` int(255) NOT NULL DEFAULT '0',
  `ak47v` int(255) NOT NULL DEFAULT '0',
  `mayor` int(255) NOT NULL DEFAULT '0',
  `vote` int(1) NOT NULL DEFAULT '0',
  `vermoord` datetime NOT NULL,
  `Vlammenwerper` int(11) NOT NULL DEFAULT '0',
  `city` int(2) NOT NULL DEFAULT '1',
  `respecttijd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `recruits` int(11) NOT NULL DEFAULT '0',
  `recruited_by` varchar(255) NOT NULL,
  `ramen` int(11) NOT NULL DEFAULT '0',
  `bitches` int(11) NOT NULL DEFAULT '0',
  `bitchesgezocht` int(11) NOT NULL DEFAULT '0',
  `respect` int(11) NOT NULL DEFAULT '0',
  `reputation` int(12) NOT NULL DEFAULT '10',
  `rank` int(255) NOT NULL DEFAULT '1',
  `rankvord` varchar(255) NOT NULL DEFAULT '0.00',
  `vordering` int(255) NOT NULL DEFAULT '0',
  `username` varchar(30) NOT NULL DEFAULT 'Nobody',
  `uurloon` int(1) NOT NULL DEFAULT '2',
  `lastid` int(10) NOT NULL DEFAULT '0',
  `lastreaction` int(12) NOT NULL DEFAULT '0',
  `active` int(1) NOT NULL DEFAULT '0',
  `lastcheck` int(12) NOT NULL DEFAULT '0',
  `betaald` char(2) NOT NULL DEFAULT '0',
  `ccd` varchar(255) NOT NULL DEFAULT '0',
  `c4` int(255) NOT NULL DEFAULT '0',
  `c4b` int(255) NOT NULL DEFAULT '0',
  `c4v` int(255) NOT NULL DEFAULT '0',
  `clan` varchar(26) NOT NULL,
  `clanlevel` int(3) NOT NULL DEFAULT '0',
  `clanconsig` int(3) NOT NULL DEFAULT '0',
  `claninstap` bigint(255) NOT NULL DEFAULT '0',
  `clanmeld` int(5) NOT NULL DEFAULT '0',
  `clanclick` char(3) NOT NULL DEFAULT '0',
  `opdruktijd1` int(255) NOT NULL DEFAULT '0',
  `opdruktijd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `vliegen` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `vliegtijd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `vliegtuig` int(255) NOT NULL DEFAULT '0',
  `vervote` int(1) NOT NULL DEFAULT '0',
  `ziekenhuis_in` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ziekenhuis_tijd` int(5) NOT NULL DEFAULT '0',
  `ziekenhuis_type` varchar(5) NOT NULL DEFAULT '0',
  `gevangenis` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `gevangenistijd` int(255) NOT NULL DEFAULT '0',
  `bustable` int(5) NOT NULL DEFAULT '0',
  `bustouts` int(255) NOT NULL DEFAULT '0',
  `gvu` int(255) NOT NULL DEFAULT '0',
  `gokken` int(3) NOT NULL DEFAULT '5',
  `hasj` int(255) NOT NULL DEFAULT '0',
  `HS` int(6) NOT NULL DEFAULT '0',
  `HSN` int(6) NOT NULL DEFAULT '0',
  `huisnaam` text NOT NULL,
  `HS_won` int(255) NOT NULL DEFAULT '0',
  `HS_lost` int(255) NOT NULL DEFAULT '0',
  `IP` varchar(32) DEFAULT NULL,
  `IP_online` varchar(32) NOT NULL DEFAULT ' ',
  `iron` decimal(64,4) DEFAULT NULL,
  `cs_ironfabric_production` int(11) NOT NULL DEFAULT '0',
  `cs_ironfabric_speed` int(11) NOT NULL DEFAULT '0',
  `email` varchar(64) DEFAULT NULL,
  `url` varchar(128) NOT NULL DEFAULT '',
  `info` text NOT NULL,
  `infoplaat` int(5) NOT NULL DEFAULT '0',
  `naam` varchar(30) NOT NULL DEFAULT 'Niet gegeven',
  `leeftijd` varchar(30) NOT NULL DEFAULT 'Niet gegeven',
  `woonplaats` varchar(30) NOT NULL DEFAULT 'Niet gegeven',
  `geslacht` varchar(15) NOT NULL DEFAULT 'Niet gegeven',
  `huur` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `huur1` int(255) NOT NULL DEFAULT '0',
  `werken1` int(255) NOT NULL DEFAULT '0',
  `weapon` int(255) NOT NULL DEFAULT '0',
  `cash` bigint(12) unsigned NOT NULL DEFAULT '5000000',
  `bank` bigint(15) unsigned NOT NULL DEFAULT '7500000',
  `bankleft` bigint(15) NOT NULL DEFAULT '10',
  `bankmax` bigint(20) NOT NULL DEFAULT '5000000',
  `clicks` int(4) unsigned NOT NULL DEFAULT '1',
  `clickstoday` int(3) NOT NULL DEFAULT '0',
  `attack` bigint(100) unsigned NOT NULL DEFAULT '100',
  `defence` bigint(100) unsigned NOT NULL DEFAULT '100',
  `deathdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `dealing` varchar(255) NOT NULL,
  `dealvordering` varchar(255) NOT NULL DEFAULT '0',
  `Dynamite` int(11) NOT NULL DEFAULT '0',
  `attwins` bigint(15) NOT NULL DEFAULT '0',
  `attlosses` bigint(15) NOT NULL DEFAULT '0',
  `defwins` bigint(15) NOT NULL DEFAULT '0',
  `deflosses` bigint(15) NOT NULL DEFAULT '0',
  `bonus` text NOT NULL,
  `turns` int(3) NOT NULL DEFAULT '100',
  `president` int(1) NOT NULL DEFAULT '0',
  `land` varchar(32) NOT NULL DEFAULT 'Belgie',
  `spel` char(2) NOT NULL DEFAULT '4',
  `showonline` int(1) NOT NULL DEFAULT '1',
  `Scherpschut geweer` int(11) NOT NULL DEFAULT '0',
  `online` bigint(20) NOT NULL DEFAULT '0',
  `activated` int(1) NOT NULL DEFAULT '0',
  `health` int(10) NOT NULL DEFAULT '100',
  `M4` int(5) NOT NULL DEFAULT '0',
  `Mobieltje` int(1) NOT NULL DEFAULT '1',
  `moordexp1` varchar(255) NOT NULL DEFAULT '0',
  `IPs` text NOT NULL,
  `blocklist` text NOT NULL,
  `clicktxt1` text NOT NULL,
  `clicktxt2` text NOT NULL,
  `Cel` int(5) NOT NULL DEFAULT '0',
  `pimpen` int(1) NOT NULL DEFAULT '1',
  `Lotto` int(5) NOT NULL DEFAULT '9',
  `citynumb` int(5) NOT NULL DEFAULT '0',
  `forumposts` int(250) NOT NULL DEFAULT '0',
  `forumstatus` varchar(255) NOT NULL DEFAULT '',
  `kogelfabriek` int(3) NOT NULL DEFAULT '0',
  `kogels` int(11) NOT NULL DEFAULT '10',
  `krieg550` int(255) NOT NULL DEFAULT '0',
  `krieg550b` int(255) NOT NULL DEFAULT '0',
  `krieg550v` int(255) NOT NULL DEFAULT '0',
  `kraak` int(1) NOT NULL DEFAULT '0',
  `death` int(255) NOT NULL DEFAULT '0',
  `killedby` varchar(255) NOT NULL DEFAULT '',
  `killedppl` int(255) NOT NULL DEFAULT '0',
  `killexp` int(255) NOT NULL DEFAULT '0',
  `killattemptsday` int(11) DEFAULT NULL,
  `fabriek2` int(1) NOT NULL DEFAULT '0',
  `familie_id` int(11) NOT NULL,
  `familie_rang` int(11) NOT NULL,
  `fabriekown` int(255) NOT NULL DEFAULT '0',
  `wapen` int(5) NOT NULL DEFAULT '0',
  `protection` int(5) NOT NULL DEFAULT '0',
  `wapenskill` varchar(5) NOT NULL DEFAULT '0.00',
  `wapentraining` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `wapentraining_tijd` int(5) NOT NULL DEFAULT '0',
  `drugs` int(255) NOT NULL DEFAULT '1',
  `drugsmeter` int(255) NOT NULL DEFAULT '100',
  `drugstime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `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',
  `rankpoint` int(6) NOT NULL DEFAULT '0',
  `euro` char(1) NOT NULL DEFAULT '&',
  `prijs` varchar(20) NOT NULL DEFAULT '',
  `autostelen` int(11) NOT NULL DEFAULT '0',
  `security` int(255) NOT NULL DEFAULT '0',
  `cars` int(11) NOT NULL DEFAULT '0',
  `gstart` int(2) NOT NULL DEFAULT '0',
  `orgtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cokevers` int(10) NOT NULL DEFAULT '0',
  `schiet` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `schiettijd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `klikmissiedubbel` int(255) NOT NULL,
  `klikmissie1` datetime NOT NULL,
  `honourpoints` int(12) NOT NULL DEFAULT '0',
  `maxpoints` int(12) NOT NULL DEFAULT '150',
  `escort` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `singlejob` int(255) NOT NULL DEFAULT '1',
  `clanmisdaad` int(10) NOT NULL DEFAULT '5',
  `allie` text NOT NULL,
  `alliep` bigint(20) DEFAULT NULL,
  `Booreiland` int(10) NOT NULL DEFAULT '0',
  `Energie Fabriek` int(10) NOT NULL DEFAULT '0',
  `Coffeeshop` int(10) NOT NULL DEFAULT '0',
  `transport` datetime NOT NULL,
  `rang` tinyint(4) DEFAULT '1',
  `rangnaam` varchar(64) DEFAULT NULL,
  `rangvordering` double(255,30) DEFAULT '0.000000000000000000000000000000',
  `misdadenervaring` int(11) DEFAULT '0',
  `ideasvoted` text,
  `warnings` int(11) DEFAULT '0',
  `mafia1attempt` datetime DEFAULT NULL,
  `mafia2attempt` datetime DEFAULT NULL,
  `mafia3attempt` datetime DEFAULT NULL,
  `bodygaurds` int(11) DEFAULT NULL,
  `bodyguards` int(11) DEFAULT NULL,
  `crimeks1` int(11) DEFAULT NULL,
  `crimeks1s` int(11) DEFAULT NULL,
  `crimeks2` int(11) DEFAULT NULL,
  `crimeks2s` int(11) DEFAULT NULL,
  `crimeks3` int(11) DEFAULT NULL,
  `crimeks3s` int(11) DEFAULT NULL,
  `misdadenervaringks` int(11) DEFAULT NULL,
  `killskill` float(30,2) DEFAULT '0.00',
  `onderduiktijd` datetime DEFAULT NULL,
  `onderduiksgraad` smallint(6) DEFAULT NULL,
  `onderduikduur` bigint(20) DEFAULT NULL,
  `wapenschade` float(5,2) DEFAULT '100.00',
  `pwlevel` tinyint(4) DEFAULT NULL,
  `pwbankmax` bigint(20) DEFAULT NULL,
  `weaponbase` int(11) DEFAULT '0',
  `silencerbase` int(11) DEFAULT '0',
  `scopebase` int(11) DEFAULT '0',
  `magbase` int(11) DEFAULT '0',
  `weaponbasedamage` float(5,3) DEFAULT '0.000',
  `silencerbasedamage` float(5,3) DEFAULT '0.000',
  `scopebasedamage` float(5,3) DEFAULT '0.000',
  `magbasedamage` float(5,3) DEFAULT '0.000',
  `defencebase` int(11) DEFAULT '0',
  `extraprotbase` int(11) DEFAULT '0',
  `defencebasedamage` float(6,2) DEFAULT '0.00',
  `extraprotbasedamage` float(6,2) DEFAULT '0.00',
  `killmessage` text,
  `lastkillattempt` datetime DEFAULT NULL,
  `lastkilledattempt` datetime DEFAULT NULL,
  `bantime` datetime DEFAULT NULL,
  `mailcode` int(11) DEFAULT NULL,
  `newmail` varchar(255) DEFAULT NULL,
  `estraid` int(11) NOT NULL DEFAULT '0',
  `multicrime1time` datetime NOT NULL,
  `multicrime1total` int(11) NOT NULL DEFAULT '0',
  `rankprogress` decimal(10,4) NOT NULL DEFAULT '0.0000',
  `mrank` int(11) NOT NULL DEFAULT '1',
  `crime1time` datetime NOT NULL,
  `crime1total` int(11) NOT NULL DEFAULT '0',
  `crime14h` int(11) NOT NULL DEFAULT '0',
  `mislukt` int(5) NOT NULL DEFAULT '0',
  `gelukt` int(5) NOT NULL DEFAULT '0',
  `fraudetijd` varchar(20) NOT NULL,
  `winst` int(20) NOT NULL DEFAULT '0',
  `xp` int(6) NOT NULL DEFAULT '0',
  `prestige` int(11) NOT NULL DEFAULT '0',
  `deletemem` tinyint(4) NOT NULL DEFAULT '0',
  `creditrad` int(11) NOT NULL DEFAULT '0',
  `clanmod` tinyint(4) NOT NULL DEFAULT '0',
  `IPcountry` varchar(255) NOT NULL DEFAULT 'Onbekend',
  `IPregion` varchar(255) NOT NULL DEFAULT 'Onbekend',
  `IPcity` varchar(255) NOT NULL DEFAULT 'Onbekend',
  `IPOcountry` varchar(255) NOT NULL,
  `IPOregion` varchar(255) NOT NULL,
  `IPOcity` varchar(255) NOT NULL,
  `IPcheck` varchar(255) NOT NULL,
  `IPOcheck` varchar(255) NOT NULL,
  `killeddipprotected` int(11) NOT NULL DEFAULT '0',
  `crime2time` datetime NOT NULL,
  `crime2total` int(11) NOT NULL DEFAULT '0',
  `clanmail` int(11) NOT NULL DEFAULT '0',
  `personeel` int(10) NOT NULL DEFAULT '0',
  `personeelgezocht` int(1) NOT NULL DEFAULT '0',
  `firma` int(255) NOT NULL DEFAULT '0',
  `eventused` int(11) NOT NULL DEFAULT '0',
  `cb_total_low` int(11) NOT NULL DEFAULT '0',
  `cb_total_high` int(11) NOT NULL DEFAULT '0',
  `bloedtype` varchar(2) NOT NULL DEFAULT '0',
  `clickmessage` int(11) NOT NULL DEFAULT '1',
  `cs_reputation` int(11) NOT NULL DEFAULT '0',
  `news_visit` bigint(20) NOT NULL DEFAULT '0',
  `eerpunten_uitbraak` int(11) NOT NULL DEFAULT '0',
  `bo_attempts` int(11) NOT NULL DEFAULT '10',
  `bbsize` varchar(5) NOT NULL DEFAULT '1.5',
  `crime4time` datetime NOT NULL,
  `crime4total` int(11) NOT NULL DEFAULT '0',
  `missionfighttime` datetime NOT NULL,
  `hprmessage` int(11) NOT NULL DEFAULT '1',
  `paid1_start` int(11) NOT NULL DEFAULT '0',
  `paid1_duration` int(11) NOT NULL DEFAULT '0',
  `paid2_start` int(11) NOT NULL DEFAULT '0',
  `paid2_duration` int(11) NOT NULL DEFAULT '0',
  `paid3_start` int(11) NOT NULL DEFAULT '0',
  `paid3_duration` int(11) NOT NULL DEFAULT '0',
  `time_online` int(11) NOT NULL DEFAULT '0',
  `time_offline` int(11) NOT NULL DEFAULT '0',
  `promopoints` int(11) NOT NULL DEFAULT '0',
  `promo_lives` int(11) NOT NULL DEFAULT '0',
  `promo_kill` int(11) NOT NULL DEFAULT '0',
  `promo_income` int(11) NOT NULL DEFAULT '0',
  `promo_waittime` int(11) NOT NULL DEFAULT '0',
  `promo_jail` int(11) NOT NULL DEFAULT '0',
  `promo_money` int(11) NOT NULL DEFAULT '0',
  `rp` int(18) NOT NULL DEFAULT '10',
  `killstoday` int(11) NOT NULL DEFAULT '0',
  `diamonds` int(11) NOT NULL DEFAULT '0',
  `diamant_rood` bigint(255) NOT NULL,
  `diamant_groen` bigint(255) NOT NULL,
  `diamant_blauw` bigint(255) NOT NULL,
  `diamant_zwart` bigint(255) NOT NULL,
  `diamant_roze` bigint(255) NOT NULL,
  `weapon1` int(11) NOT NULL DEFAULT '0',
  `weapon2` int(11) NOT NULL DEFAULT '0',
  `weapon3` int(11) NOT NULL DEFAULT '0',
  `weapon4` int(11) NOT NULL DEFAULT '0',
  `weapon5` int(11) NOT NULL DEFAULT '0',
  `weapon6` int(11) NOT NULL DEFAULT '0',
  `weapon7` int(11) NOT NULL DEFAULT '0',
  `weapon8` int(11) NOT NULL DEFAULT '0',
  `weapon9` int(11) NOT NULL DEFAULT '0',
  `weapon10` int(11) NOT NULL DEFAULT '0',
  `weapon11` int(11) NOT NULL DEFAULT '0',
  `weapon12` int(11) NOT NULL DEFAULT '0',
  `weapon13` int(11) NOT NULL DEFAULT '0',
  `weapon14` int(11) NOT NULL DEFAULT '0',
  `weapon15` int(11) NOT NULL DEFAULT '0',
  `weapon16` int(11) NOT NULL DEFAULT '0',
  `weapon17` int(11) NOT NULL DEFAULT '0',
  `weapon18` int(11) NOT NULL DEFAULT '0',
  `weapon19` int(11) NOT NULL DEFAULT '0',
  `weapon20` int(11) NOT NULL DEFAULT '0',
  `weapon21` int(11) NOT NULL DEFAULT '0',
  `weapon22` int(11) NOT NULL DEFAULT '0',
  `weapon23` int(11) NOT NULL DEFAULT '0',
  `weapon24` int(11) NOT NULL DEFAULT '0',
  `weapon25` int(11) NOT NULL DEFAULT '0',
  `weapon26` int(11) NOT NULL DEFAULT '0',
  `weapon27` int(11) NOT NULL DEFAULT '0',
  `weapon28` int(11) NOT NULL DEFAULT '0',
  `weapon29` int(11) NOT NULL DEFAULT '0',
  `weapon30` int(11) NOT NULL DEFAULT '0',
  `weapon31` int(11) NOT NULL DEFAULT '0',
  `weapon32` int(11) NOT NULL DEFAULT '0',
  `weapon33` int(11) NOT NULL DEFAULT '0',
  `weapon34` int(11) NOT NULL DEFAULT '0',
  `weapon35` int(11) NOT NULL DEFAULT '0',
  `weapon36` int(11) NOT NULL DEFAULT '0',
  `weapon37` int(11) NOT NULL DEFAULT '0',
  `weapon38` int(11) NOT NULL DEFAULT '0',
  `weapon39` int(11) NOT NULL DEFAULT '0',
  `weapon40` int(11) NOT NULL DEFAULT '0',
  `weapon41` int(11) NOT NULL DEFAULT '0',
  `weapon42` int(11) NOT NULL DEFAULT '0',
  `weapon43` int(11) NOT NULL DEFAULT '0',
  `weapon44` int(11) NOT NULL DEFAULT '0',
  `weapon45` int(11) NOT NULL DEFAULT '0',
  `weapon46` int(11) NOT NULL DEFAULT '0',
  `weapon47` int(11) NOT NULL DEFAULT '0',
  `weapon48` int(11) NOT NULL DEFAULT '0',
  `weapon49` int(11) NOT NULL DEFAULT '0',
  `weapon50` int(11) NOT NULL DEFAULT '0',
  `weapon51` int(11) NOT NULL DEFAULT '0',
  `weapon52` int(11) NOT NULL DEFAULT '0',
  `weapon53` int(11) NOT NULL DEFAULT '0',
  `weapon54` int(11) NOT NULL DEFAULT '0',
  `weapon55` int(11) NOT NULL DEFAULT '0',
  `weapon56` int(11) NOT NULL DEFAULT '0',
  `weapon57` int(11) NOT NULL DEFAULT '0',
  `weapon58` int(11) NOT NULL DEFAULT '0',
  `weapon59` int(11) NOT NULL DEFAULT '0',
  `weapon60` int(11) NOT NULL DEFAULT '0',
  `weapon61` int(11) NOT NULL DEFAULT '0',
  `weapon62` int(11) NOT NULL DEFAULT '0',
  `weapon63` int(11) NOT NULL DEFAULT '0',
  `hacken` tinyint(4) NOT NULL DEFAULT '10',
  `citroenc4picasso` int(255) NOT NULL,
  `alfaromeospider` int(255) NOT NULL,
  `audia4` int(255) NOT NULL,
  `citroenc8` int(255) NOT NULL,
  `volkswagentouareg` int(255) NOT NULL,
  `jaguarxf` int(255) NOT NULL,
  `toyotalandcruiser` int(255) NOT NULL,
  `landroverdiscovery` int(255) NOT NULL,
  `volvoxc90` int(255) NOT NULL,
  `ferrarif430` int(255) NOT NULL,
  `citroenc1` int(255) NOT NULL,
  `fiatdoblo` int(255) NOT NULL,
  `renaultgrandscenic` int(255) NOT NULL,
  `audia3` int(255) NOT NULL,
  `opelastra` int(255) NOT NULL,
  `fordmondeo` int(255) NOT NULL,
  `geenwachttijdrace` datetime NOT NULL,
  `geenwachttijd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `autotijd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `autokans` int(255) NOT NULL DEFAULT '0',
  `blauweschoenen` bigint(255) NOT NULL,
  `blauweshirt` bigint(255) NOT NULL,
  `eagle` bigint(255) NOT NULL DEFAULT '0',
  `eaglegold` bigint(20) NOT NULL DEFAULT '0',
  `eagleelite` bigint(20) NOT NULL DEFAULT '0',
  `ak47gold` bigint(20) NOT NULL DEFAULT '0',
  `uzielite` bigint(20) NOT NULL DEFAULT '0',
  `eaglebruin` bigint(255) NOT NULL,
  `eaglebruin_rood` bigint(255) NOT NULL,
  `spijkerbroekgold` bigint(255) NOT NULL,
  `pet` bigint(255) NOT NULL,
  `sportschoenen` bigint(255) NOT NULL,
  `spijkerbroek` bigint(255) NOT NULL,
  `uzi` bigint(255) NOT NULL DEFAULT '0',
  `m911` bigint(255) NOT NULL DEFAULT '1',
  `racetijd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `crimeairtime` datetime NOT NULL,
  `crimefly` datetime NOT NULL,
  `dagenbetaald` tinyint(4) NOT NULL DEFAULT '5',
  `revolverbruin_roze` bigint(20) NOT NULL,
  `revolver` bigint(20) NOT NULL DEFAULT '0',
  `revolvergold` bigint(20) NOT NULL DEFAULT '0',
  `revolverelite` bigint(20) NOT NULL DEFAULT '0',
  `ak47bruin_blauw` bigint(20) NOT NULL,
  `grenadebruin_blauw` bigint(20) NOT NULL,
  `mp5bruin_blauw` bigint(20) NOT NULL,
  `skorpionblauw_roze` bigint(20) NOT NULL,
  `m203blauw_roze` bigint(20) NOT NULL,
  `g36cblauw_roze` bigint(20) NOT NULL,
  `m4m203blauw_roze` bigint(20) NOT NULL,
  `uniek_groenejas` bigint(20) NOT NULL,
  `uniek_zilverenschoen` bigint(20) NOT NULL,
  `slottijd` datetime NOT NULL,
  `specpoints` int(255) NOT NULL DEFAULT '0',
  `racemonster` int(255) NOT NULL DEFAULT '0',
  `uzibruin_rood` bigint(20) NOT NULL,
  `uzibruin_groen` bigint(20) NOT NULL,
  `uzibruin_blauw` bigint(20) NOT NULL,
  `uzibruin_zwart` bigint(20) NOT NULL,
  `uzibruin_roze` bigint(20) NOT NULL,
  `revolverbruin_zwart` bigint(20) NOT NULL,
  `ak47_rood` bigint(20) NOT NULL,
  `ak47_groen` bigint(20) NOT NULL,
  `ak47_blauw` bigint(20) NOT NULL,
  `ak47_zwart` bigint(20) NOT NULL,
  `ak47_roze` bigint(20) NOT NULL,
  `grenade_rood` bigint(20) NOT NULL,
  `grenade_groen` bigint(20) NOT NULL,
  `grenade_blauw` bigint(20) NOT NULL,
  `grenade_zwart` bigint(20) NOT NULL,
  `grenade_roze` bigint(20) NOT NULL,
  `uniek_paarsepet` bigint(20) NOT NULL,
  `m16blauw_roze` bigint(20) NOT NULL,
  `m16blauw_zwart` bigint(20) NOT NULL,
  `m16blauw_blauw` bigint(20) NOT NULL,
  `m16blauw_groen` bigint(20) NOT NULL,
  `m16blauw_rood` bigint(20) NOT NULL,
  `skorpionblauw` bigint(20) NOT NULL,
  `m203blauw` bigint(20) NOT NULL,
  `g36cblauw` bigint(20) NOT NULL,
  `m4m203blauw` bigint(20) NOT NULL,
  `uniek_kerstmuts` bigint(20) NOT NULL,
  `uniek_kerstschoenen` bigint(20) NOT NULL,
  `uniek_kerstshirt` bigint(20) NOT NULL,
  `uniek_kerstbroek` bigint(20) NOT NULL,
  `m16blauw` bigint(20) NOT NULL,
  `eaglebruin_groen` bigint(20) NOT NULL,
  `eaglebruin_blauw` bigint(20) NOT NULL,
  `eaglebruin_roze` bigint(20) NOT NULL,
  `eaglebruin_zwart` bigint(20) NOT NULL,
  `uzibruin` bigint(20) NOT NULL,
  `revolverbruin` bigint(20) NOT NULL,
  `ak47bruin` bigint(20) NOT NULL,
  `grenadebruin` bigint(20) NOT NULL,
  `mp5bruin` bigint(20) NOT NULL,
  `geenlimiet` int(11) NOT NULL DEFAULT '0',
  `groenemust` bigint(20) NOT NULL,
  `groenemustgold` bigint(20) NOT NULL,
  `groenemustelite` bigint(20) NOT NULL,
  `groenshirt` bigint(20) NOT NULL,
  `groenshirtgold` bigint(20) NOT NULL,
  `groenshirtelite` bigint(20) NOT NULL,
  `groenshirtgreen` bigint(20) NOT NULL,
  `donkerrozeshirt` bigint(20) NOT NULL,
  `roodshirt` bigint(20) NOT NULL,
  `paarsshirt` bigint(20) NOT NULL,
  `zwartewerkschoenen` bigint(255) NOT NULL,
  `donkerebroekgreen` bigint(255) NOT NULL,
  `donkerebroek` bigint(255) NOT NULL,
  `kortebroek` bigint(255) NOT NULL,
  `uzigold` bigint(255) NOT NULL DEFAULT '0',
  `bezitweergeven` int(255) NOT NULL DEFAULT '0',
  `harpoongreen` bigint(255) NOT NULL,
  `shotgungreen` bigint(255) NOT NULL,
  `mp5green` bigint(255) NOT NULL,
  `grenadegreen` bigint(255) NOT NULL,
  `spijkerbroekelite` bigint(20) NOT NULL,
  `sportschoenenelite` bigint(20) NOT NULL,
  `sportschoenengold` bigint(20) NOT NULL,
  `mp5` bigint(20) NOT NULL,
  `mp5gold` bigint(20) NOT NULL,
  `mp5elite` bigint(20) NOT NULL,
  `rozeshirt` bigint(20) NOT NULL,
  `benen` varchar(255) NOT NULL,
  `hoofd` varchar(20) NOT NULL,
  `lichaam` varchar(20) NOT NULL,
  `arm1` varchar(20) NOT NULL,
  `arm2` varchar(20) NOT NULL,
  `voeten` varchar(20) NOT NULL,
  `blauweschoenengold` bigint(20) NOT NULL,
  `blauweschoenenelite` bigint(20) NOT NULL,
  `grenade` bigint(20) NOT NULL DEFAULT '0',
  `grenadegold` bigint(20) NOT NULL DEFAULT '0',
  `grenadeelite` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `login_2` (`login`),
  KEY `login` (`login`),
  KEY `gezondheid` (`gezondheid`),
  KEY `activated` (`activated`),
  KEY `online` (`online`),
  KEY `attack` (`attack`),
  KEY `defence` (`defence`),
  KEY `clicks` (`clicks`),
  KEY `level` (`level`),
  KEY `type` (`type`),
  KEY `cash` (`cash`),
  KEY `bank` (`bank`),
  KEY `prestige` (`prestige`),
  KEY `mrank` (`mrank`),
  KEY `rankprogress` (`rankprogress`),
  KEY `signup` (`signup`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12783 ;


--
-- Dumping data for table `[users]`
--


INSERT INTO `[users]` (`id`, `uitbreek`, `lpv`, `chatrank`, `chatten`, `page`, `points`, `pimprecht`, `pollvoted`, `gezondheid`, `geldbespaarder`, `gestart`, `goudstaven`, `signup`, `login`, `level`, `layout`, `leven`, `pass`, `plantage`, `onderzoekers`, `ontslag`, `onderduiken`, `oc_won`, `oc_lost`, `ocs`, `aland`, `airplane`, `experience`, `exp`, `energie`, `est`, `openforum`, `opvakantie`, `landcolor`, `avaurl`, `avatarpack`, `aanvaltijd`, `aanvallen`, `aanvallenverloren`, `avatar`, `wapens`, `wapen11`, `woningtekst`, `woning`, `warn_lvl`, `wskill`, `winkel`, `winkeltijd`, `pers`, `bstand`, `backfire`, `baktijd`, `baan`, `beheer`, `bloodtype`, `bankpogingen`, `bescherming`, `j13`, `joint`, `jointtijd`, `job`, `typew`, `tip`, `tickets`, `tijdmachine`, `type`, `train`, `trainuur`, `trlvl`, `autocrime`, `autoshop`, `legim`, `weedplant`, `auto`, `auto1`, `auto2`, `autoP`, `garage`, `G36C`, `crime`, `cbuy`, `crimes`, `codechecker`, `coffeshop`, `crime1`, `crime1s`, `crime1p`, `crime2`, `crime2s`, `crime2p`, `crime3`, `crime3s`, `crime3p`, `crime4`, `crime4s`, `crime4p`, `misdaad`, `msn`, `misdaadtijd`, `misdaadkans`, `missie`, `missie_1`, `missie_2`, `missie_3`, `missie_4`, `missie_5`, `missie_6`, `missie_7`, `missie_8`, `missie_9`, `missie_10`, `missie_11`, `missie_12`, `missie_13`, `moord`, `moorden`, `moordexp`, `moordtijd`, `moordtime`, `m16`, `m16b`, `m16v`, `m60`, `m60b`, `m60v`, `m66`, `m6`, `m11`, `m22`, `m33`, `m49`, `m55`, `M82a1`, `mailwitness`, `gram`, `ar`, `escr`, `stat`, `steel`, `steeltijd`, `stempunten`, `sig552`, `sig552b`, `sig552v`, `status`, `aantbedrijf`, `aantdrugs`, `aantpretpark`, `attackdate`, `attacktime`, `ak47`, `ak47elite`, `ak47b`, `ak47v`, `mayor`, `vote`, `vermoord`, `Vlammenwerper`, `city`, `respecttijd`, `recruits`, `recruited_by`, `ramen`, `bitches`, `bitchesgezocht`, `respect`, `reputation`, `rank`, `rankvord`, `vordering`, `username`, `uurloon`, `lastid`, `lastreaction`, `active`, `lastcheck`, `betaald`, `ccd`, `c4`, `c4b`, `c4v`, `clan`, `clanlevel`, `clanconsig`, `claninstap`, `clanmeld`, `clanclick`, `opdruktijd1`, `opdruktijd`, `vliegen`, `vliegtijd`, `vliegtuig`, `vervote`, `ziekenhuis_in`, `ziekenhuis_tijd`, `ziekenhuis_type`, `gevangenis`, `gevangenistijd`, `bustable`, `bustouts`, `gvu`, `gokken`, `hasj`, `HS`, `HSN`, `huisnaam`, `HS_won`, `HS_lost`, `IP`, `IP_online`, `iron`, `cs_ironfabric_production`, `cs_ironfabric_speed`, `email`, `url`, `info`, `infoplaat`, `naam`, `leeftijd`, `woonplaats`, `geslacht`, `huur`, `huur1`, `werken1`, `weapon`, `cash`, `bank`, `bankleft`, `bankmax`, `clicks`, `clickstoday`, `attack`, `defence`, `deathdate`, `dealing`, `dealvordering`, `Dynamite`, `attwins`, `attlosses`, `defwins`, `deflosses`, `bonus`, `turns`, `president`, `land`, `spel`, `showonline`, `Scherpschut geweer`, `online`, `activated`, `health`, `M4`, `Mobieltje`, `moordexp1`, `IPs`, `blocklist`, `clicktxt1`, `clicktxt2`, `Cel`, `pimpen`, `Lotto`, `citynumb`, `forumposts`, `forumstatus`, `kogelfabriek`, `kogels`, `krieg550`, `krieg550b`, `krieg550v`, `kraak`, `death`, `killedby`, `killedppl`, `killexp`, `killattemptsday`, `fabriek2`, `familie_id`, `familie_rang`, `fabriekown`, `wapen`, `protection`, `wapenskill`, `wapentraining`, `wapentraining_tijd`, `drugs`, `drugsmeter`, `drugstime`, `drug1`, `drug2`, `drug3`, `drug4`, `drug5`, `drug6`, `rankpoint`, `euro`, `prijs`, `autostelen`, `security`, `cars`, `gstart`, `orgtime`, `cokevers`, `schiet`, `schiettijd`, `klikmissiedubbel`, `klikmissie1`, `honourpoints`, `maxpoints`, `escort`, `singlejob`, `clanmisdaad`, `allie`, `alliep`, `Booreiland`, `Energie Fabriek`, `Coffeeshop`, `transport`, `rang`, `rangnaam`, `rangvordering`, `misdadenervaring`, `ideasvoted`, `warnings`, `mafia1attempt`, `mafia2attempt`, `mafia3attempt`, `bodygaurds`, `bodyguards`, `crimeks1`, `crimeks1s`, `crimeks2`, `crimeks2s`, `crimeks3`, `crimeks3s`, `misdadenervaringks`, `killskill`, `onderduiktijd`, `onderduiksgraad`, `onderduikduur`, `wapenschade`, `pwlevel`, `pwbankmax`, `weaponbase`, `silencerbase`, `scopebase`, `magbase`, `weaponbasedamage`, `silencerbasedamage`, `scopebasedamage`, `magbasedamage`, `defencebase`, `extraprotbase`, `defencebasedamage`, `extraprotbasedamage`, `killmessage`, `lastkillattempt`, `lastkilledattempt`, `bantime`, `mailcode`, `newmail`, `estraid`, `multicrime1time`, `multicrime1total`, `rankprogress`, `mrank`, `crime1time`, `crime1total`, `crime14h`, `mislukt`, `gelukt`, `fraudetijd`, `winst`, `xp`, `prestige`, `deletemem`, `creditrad`, `clanmod`, `IPcountry`, `IPregion`, `IPcity`, `IPOcountry`, `IPOregion`, `IPOcity`, `IPcheck`, `IPOcheck`, `killeddipprotected`, `crime2time`, `crime2total`, `clanmail`, `personeel`, `personeelgezocht`, `firma`, `eventused`, `cb_total_low`, `cb_total_high`, `bloedtype`, `clickmessage`, `cs_reputation`, `news_visit`, `eerpunten_uitbraak`, `bo_attempts`, `bbsize`, `crime4time`, `crime4total`, `missionfighttime`, `hprmessage`, `paid1_start`, `paid1_duration`, `paid2_start`, `paid2_duration`, `paid3_start`, `paid3_duration`, `time_online`, `time_offline`, `promopoints`, `promo_lives`, `promo_kill`, `promo_income`, `promo_waittime`, `promo_jail`, `promo_money`, `rp`, `killstoday`, `diamonds`, `diamant_rood`, `diamant_groen`, `diamant_blauw`, `diamant_zwart`, `diamant_roze`, `weapon1`, `weapon2`, `weapon3`, `weapon4`, `weapon5`, `weapon6`, `weapon7`, `weapon8`, `weapon9`, `weapon10`, `weapon11`, `weapon12`, `weapon13`, `weapon14`, `weapon15`, `weapon16`, `weapon17`, `weapon18`, `weapon19`, `weapon20`, `weapon21`, `weapon22`, `weapon23`, `weapon24`, `weapon25`, `weapon26`, `weapon27`, `weapon28`, `weapon29`, `weapon30`, `weapon31`, `weapon32`, `weapon33`, `weapon34`, `weapon35`, `weapon36`, `weapon37`, `weapon38`, `weapon39`, `weapon40`, `weapon41`, `weapon42`, `weapon43`, `weapon44`, `weapon45`, `weapon46`, `weapon47`, `weapon48`, `weapon49`, `weapon50`, `weapon51`, `weapon52`, `weapon53`, `weapon54`, `weapon55`, `weapon56`, `weapon57`, `weapon58`, `weapon59`, `weapon60`, `weapon61`, `weapon62`, `weapon63`, `hacken`, `citroenc4picasso`, `alfaromeospider`, `audia4`, `citroenc8`, `volkswagentouareg`, `jaguarxf`, `toyotalandcruiser`, `landroverdiscovery`, `volvoxc90`, `ferrarif430`, `citroenc1`, `fiatdoblo`, `renaultgrandscenic`, `audia3`, `opelastra`, `fordmondeo`, `geenwachttijdrace`, `geenwachttijd`, `autotijd`, `autokans`, `blauweschoenen`, `blauweshirt`, `eagle`, `eaglegold`, `eagleelite`, `ak47gold`, `uzielite`, `eaglebruin`, `eaglebruin_rood`, `spijkerbroekgold`, `pet`, `sportschoenen`, `spijkerbroek`, `uzi`, `m911`, `racetijd`, `crimeairtime`, `crimefly`, `dagenbetaald`, `revolverbruin_roze`, `revolver`, `revolvergold`, `revolverelite`, `ak47bruin_blauw`, `grenadebruin_blauw`, `mp5bruin_blauw`, `skorpionblauw_roze`, `m203blauw_roze`, `g36cblauw_roze`, `m4m203blauw_roze`, `uniek_groenejas`, `uniek_zilverenschoen`, `slottijd`, `specpoints`, `racemonster`, `uzibruin_rood`, `uzibruin_groen`, `uzibruin_blauw`, `uzibruin_zwart`, `uzibruin_roze`, `revolverbruin_zwart`, `ak47_rood`, `ak47_groen`, `ak47_blauw`, `ak47_zwart`, `ak47_roze`, `grenade_rood`, `grenade_groen`, `grenade_blauw`, `grenade_zwart`, `grenade_roze`, `uniek_paarsepet`, `m16blauw_roze`, `m16blauw_zwart`, `m16blauw_blauw`, `m16blauw_groen`, `m16blauw_rood`, `skorpionblauw`, `m203blauw`, `g36cblauw`, `m4m203blauw`, `uniek_kerstmuts`, `uniek_kerstschoenen`, `uniek_kerstshirt`, `uniek_kerstbroek`, `m16blauw`, `eaglebruin_groen`, `eaglebruin_blauw`, `eaglebruin_roze`, `eaglebruin_zwart`, `uzibruin`, `revolverbruin`, `ak47bruin`, `grenadebruin`, `mp5bruin`, `geenlimiet`, `groenemust`, `groenemustgold`, `groenemustelite`, `groenshirt`, `groenshirtgold`, `groenshirtelite`, `groenshirtgreen`, `donkerrozeshirt`, `roodshirt`, `paarsshirt`, `zwartewerkschoenen`, `donkerebroekgreen`, `donkerebroek`, `kortebroek`, `uzigold`, `bezitweergeven`, `harpoongreen`, `shotgungreen`, `mp5green`, `grenadegreen`, `spijkerbroekelite`, `sportschoenenelite`, `sportschoenengold`, `mp5`, `mp5gold`, `mp5elite`, `rozeshirt`, `benen`, `hoofd`, `lichaam`, `arm1`, `arm2`, `voeten`, `blauweschoenengold`, `blauweschoenenelite`, `grenade`, `grenadegold`, `grenadeelite`) VALUES
(12782, 0, '2011-09-25 19:29:19', 'member', 0, 'admin_index', 0, 0, NULL, 100, 0, 0, 0, '2011-09-25 19:28:18', 'Admin', 999, '1', 100, '3e6148d4707bb87e45c3f4717d85b229', 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 0, '800000', 'http://www.mafiaforce.nl/images/uitroepteken.gif', 0, '0000-00-00 00:00:00', 0, 0, 'uitroepteken.gif', 0, 0, '', 0, 0, '0.00', '0000-00-00 00:00:00', 0, '0', '', 201, '0000-00-00 00:00:00', 0, '19900629', '0', '0', 0, 0, 50, 0, 0, '2', 0, 0, 0, 1, '0', '2', 0, '10', 0, 0, 0, '0000-00-00 00:00:00', 0, 0, '0', 0, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 0, 0, 100000, 0, 0, 100000, 0, 0, 100000, 0, 0, 100000, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', '0', '0', '0000-00-00 00:00:00', '0', 0, 0, 0, 0, 0, 0, 5, 0, 5, 4, 4, 3, 3, 0, 0, 0, '0', '0', '', '0000-00-00 00:00:00', 0, 1, 0, 0, 0, 'cit', '0', '0', '0', '0000-00-00 00:00:00', 0, 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', 0, 1, '0000-00-00 00:00:00', 0, '', 0, 0, 0, 0, 10, 1, '0.00', 0, 'Nobody', 2, 0, 0, 0, 0, '0', '0', 0, 0, 0, '', 0, 0, 0, 0, '0', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, '0', '0000-00-00 00:00:00', 0, 0, 0, 0, 5, 0, 0, 0, '', 0, 0, '84.197.152.121', '84.197.152.121', '0.0000', 0, 0, '[email protected]', '', '', 0, 'Niet gegeven', 'Niet gegeven', 'Niet gegeven', 'Niet gegeven', '0000-00-00 00:00:00', 0, 0, 0, 5000000, 7500000, 10, 1000000, 0, 0, 100, 100, '0000-00-00 00:00:00', '', '0', 0, 0, 0, 0, 0, '', 100, 0, '', '4', 1, 0, 1316971759, 1, 100, 0, 1, '0', '', '', '', '', 0, 1, 9, 0, 0, '', 0, 10, 0, 0, 0, 0, 0, '', 0, 0, NULL, 0, 0, 0, 0, 0, 0, '0.00', '0000-00-00 00:00:00', 0, 1, 100, '0000-00-00 00:00:00', 0, 0, 0, 0, 0, 0, 0, '&', '', 0, 0, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, 150, '0000-00-00 00:00:00', 1, 5, '', NULL, 0, 0, 0, '0000-00-00 00:00:00', 1, NULL, 0.000000000000000000000000000000, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, 100.00, NULL, NULL, 0, 0, 0, 0, 0.000, 0.000, 0.000, 0.000, 0, 0, 0.00, 0.00, NULL, '2011-09-25 19:28:05', '2011-09-25 19:28:05', NULL, NULL, NULL, 0, '0000-00-00 00:00:00', 0, '0.0000', 1, '0000-00-00 00:00:00', 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 'Onbekend', 'Onbekend', 'Onbekend', '', '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, '0', 1, 0, 0, 0, 10, '1.5', '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 0, 0, 0, 0, 0, 1316971743, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', '', 0, 0, 0, 0, 0);


-- --------------------------------------------------------


--
-- Table structure for table `[veiling]`
--


CREATE TABLE IF NOT EXISTS `[veiling]` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `soort` int(255) NOT NULL DEFAULT '0',
  `plaatser` varchar(255) NOT NULL DEFAULT '',
  `bieder` varchar(255) NOT NULL DEFAULT '',
  `bod` bigint(255) NOT NULL DEFAULT '0',
  `tijd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `vid` int(255) NOT NULL DEFAULT '0',
  `info` text NOT NULL,
  `veiltijd` int(255) NOT NULL DEFAULT '3600',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;


-- --------------------------------------------------------


--
-- Table structure for table `[weapons]`
--


CREATE TABLE IF NOT EXISTS `[weapons]` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '',
  `area` int(2) DEFAULT NULL,
  `costs` bigint(15) DEFAULT NULL,
  `url` varchar(40) DEFAULT NULL,
  `attack` bigint(15) DEFAULT NULL,
  `defence` bigint(15) DEFAULT NULL,
  `max` text,
  `eval` text,
  `error` text,
  `extra` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=138 ;


-- --------------------------------------------------------


--
-- Table structure for table `[wietplantage]`
--


CREATE TABLE IF NOT EXISTS `[wietplantage]` (
  `id` tinyint(1) NOT NULL AUTO_INCREMENT,
  `eigenaar` varchar(40) NOT NULL DEFAULT '',
  `planten` int(6) NOT NULL DEFAULT '0',
  `begonnen` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `voedtijd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `procent` int(3) NOT NULL DEFAULT '0',
  `voedingkeer` tinyint(1) NOT NULL DEFAULT '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='2' AUTO_INCREMENT=1 ;


-- --------------------------------------------------------


--
-- Table structure for table `_LOG_[bank]`
--


CREATE TABLE IF NOT EXISTS `_LOG_[bank]` (
  `time` datetime DEFAULT NULL,
  `action` varchar(64) DEFAULT NULL,
  `banksaldo` bigint(20) unsigned DEFAULT NULL,
  `cashsaldo` bigint(20) unsigned DEFAULT NULL,
  `bankmax` bigint(20) DEFAULT NULL,
  `amount` bigint(20) DEFAULT NULL,
  `gelukt` varchar(8) DEFAULT NULL,
  `login` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Toon Meer

:cheer:

Bosske · 23 februari 2012

Johank had zaterdag gestort (zegt hij) maar tot op vandaag donderdag nog niets ontvangen, dat wil al genoeg zeggen dat hij waarschijnlijk niet gestort zal hebben, normaal duurt dit 3 werkdagen. Nu komt hij af op msn dat ik nog 4 dagen moet wachten met verkopen, indien hij zou gestort hebben dan zal ik het geld meteen terug sturen zonder probleem, ik zal het nu verkopen aan Dein.

Nieuwe reactie samengevoegd met originele reactie op 23.02.12 16:03:29:
Hier kan dus slotje op verkocht aan Dein wegens het niet storten van Johank.

Bosske · 23 februari 2012

Johank Na 4 dagen nog steeds niets gezien dus zal het er ook niet meer aankomen, indien dit toch wel zo zou zijn dan stort ik meteen je geld terug zonder pardon.

Bosske · 23 februari 2012

Na het niet nakomen van JohanK zijn aankoop stel ik alles terug in de verkoop.

Te koop wegens stopzetting.
-Maffia game met layout http://crimegamers.be/ Perfect werkende maffia game met tal van leuke opties URL zal overgeplaatst worden op uw naam.
inloggen kan met Demo/Demo Je krijgt alle rechten over lay-out zoals ook de source.

-3 maffia Lay-outs met alle rechten voor nieuwe eigenaar, psd is inbegrepen.
http://crimegamers.be/layout_sMaffia/maffia/index.php
http://crimegamers.be/layout_streetmobs/outgame/index.html http://crimegamers.be/layout_streetmobs/intgame/index.html
http://crimegamers.be/layout_crimegame/outgame.jpg http://crimegamers.be/layout_crimegame/ingame.jpg
- 2x Game source aangekocht bij rpgbunny 50 per stuk betaald, 1 x oude en 1x nieuwe versie.
http://www.rpgbunny.com/demo/perfect-mafia-deluxe/dit is het spel dat ik ooit aangekocht heb en nooit heb gebruikt. inloggen kan met demo/demo is enkel een voorbeeld, source van mij staat niet online maar is net het zelfde. Met dat ik ze zelf niet gebruik op 2 url kunt u deze overnemen van mij en 2x gebruiken zonder probleem of eventueel verder verkopen.
-Banner top site aangekocht bij webhouse.be voor 15 euro
http://www.server.webhouse.be/bannertoplijst/index.php
het voorbeeld kun je hier zien. Handleiding inbegrepen.
-Nog een pwyl source (maffia game) waar ik licentie voor heb (aangekocht bij Maurice) ,
-En als laatste nog een linkspel, voorbeeld kan ik even niet vinden.

Dit alles tegen spotprijs van 100euro.

Via overschrijving,

ps: Willen de Moderators/Beheerders niet mijn account verbannen tot alles is verkocht dan zie je mij hier toch niet meer.
Alvast bedankt voor jullie begrip en medewerking

Staat ook op sitedeals te koop.
http://www.sitedeals.nl/websit…itverkoop.html#post909407

DNS update Directadmin

PC probleem

Let op Vimexx klanten

wie kan mij helpen met Security aanscherpen voor nmijn website

Ik ben op zoek naar een goede hosting

App bouwer gezocht

4G met USB Dongle - windows 11 Chrome of Firefox - browser probleem

Hosting en websites op maat

Xenforo buckaroo plugin

300+ Nieuwe domeinnamen Maart 2024

Actieve crime

Posts by Bosske

Secondwar.nl & .be

Secondwar.nl & .be

Mafiaforce.nl Gratis vrijgegeven!

eigen maffia begin

Beste crimesource

Mafiaforce.nl Gratis vrijgegeven!

Mafiaforce.nl Gratis vrijgegeven!

Uitverkoop

Uitverkoop

Uitverkoop

ING Nederland streeft naar ondersteuning van Google Pay tegen eind februari

Het Belang van Standaardisatie

De Revolutionaire Rol van IT in Alzheimeronderzoek

Functioneel ontwerp

Access Control List implementatie in PHP/MySQL - deel 1/2

Access Control List implementatie in PHP/MySQL - deel 2/2