jopitan een bugloos source, geef je niet zomaar vrij... Enigste wat goed is aan de source is dat de aantal opties groot zijn. Dat was ook mijn reden om te kopen. Ik dacht dat ik het zou kunnen herscripten, maar werd me teveel...
SQL mist, iemand was zog grappig om een SQL injectie uit te voeren. Ik heb slechts een backup van `[users]` die ik wel kan leveren indien gewenst.
==
Dan wil ik nog is herhalen:
Ik lever geen support, die zal je zelf moeten regelen.
Er moet een database ontwikkeld worden. Ik ga zo direct naar huis en ontwikkel deze vanmiddag, en kan hem eventueel morgenavond af maken als ik dan tijd heb?
Okay?:cheer:
Citaat van SvenBEr moet een database ontwikkeld worden. Ik ga zo direct naar huis en ontwikkel deze vanmiddag, en kan hem eventueel morgenavond af maken als ik dan tijd heb?
Okay?:cheer:
Ik heb mijn eerste update hier staan:
http://iunlocker.nl/CP/updates/
Citaat van jopitanIk heb mijn eerste update hier staan:
http://iunlocker.nl/CP/updates/
Wat heb jij er aan veranderd?
Citaat van jgdonleach
Wat heb jij er aan veranderd?
Index.php -> Bugs verwijderd
Aanmelden2.php -> Bugs verwijderd (deels)
_include-config.php -> Bugs verwijderd
database.sql -> Eerste deel van de database
Beste malik, Heel leuk en lief vanje datje deze source deelt met ons allemaal, Maar is hier ook toevallig een database van die je erbij mee kunt sturen?, Gewoon een schoone database(geleegde).
Toni Sanchez :cheer:
@ nulldubbeldrie : Er is helaas geen geleegde database bij malik wou volgens mij ook geen support bieden, Er zijn hier wel genoeg mensen die een database vanuit de scripts kunnen opbouwen.
Ik wil het best wel even voor je probeeren uiteraard zodat je een goeie en foutlose database krijgt.
scarface, Bedankt voor het aanbod, maar toch nee bedankt, Ik kan zelf ook de database maken vanuit de script's, Maar omdat ik zelf erg druk ben met mijn eigen project http://fivestarz.nl heb ik eigenlijk geen tijd daarvoor, En ik wou eigenlijk alleen even rond snuffelen op de source aangezien ik veel reactie's lees dat dit toch wel een mooie spel is. Was dus erg nieuwsgierig.
Maar ik heb net even de coding bekeken en het blijkt gewoon criminals troep te wezen haha, Dusjaa deze source word ook weer perdirect verwijdert ;).
Toni Sanchez:cheer:
Spel is leuk bedacht, maar het systeem erachter zuigt echt.
Mafiaforce sql bestand aub.
-- --------------------------------------------------------
--
-- 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, 'Ü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ë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ë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ë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, 'Ü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 */;:cheer:
Kun je het misschien ook ff in code tags zetten ?
Bedankt voor het delen!! (xD)
Bedankt Buds, ik dacht dat jij het was maar het was legend die niet netjes was....
Is jammer dat het zo is moeten lopen met deze leuke source toch wel.
niet negatief bedoelt je hebt zijn reachtie gezien toch als hij dat zegt wat kan ik er aan doen anyways bedankt voor de code.
ntnt Als het negatief tegenover mij is bedoeld, dan wil ik je vragen om eerst te kijken hoe het kan dat iemand die Mafiaforce.nl 4 maanden in bezit heeft geen rechten over de source ervan heeft?
Daarnaast heb ik eerder een gesprek met hem gevoerd en dit was 1 van zijn reacties:
==
Ik versta uw woede hierover.
En ik zou in uw geval ook razend zijn als ik iets anders was verteld.
Ik denk dat ze bij u hier niet bij hebben gezegd dat er nog licenties waren verkocht voor u de eigenaarsrechten kocht.
==
Hij probeert alleen zijn source te verkopen omdat hij is opgelicht door iemand die de source zonder rechten heeft verkocht.
Bedankt. Zal deze zeker eens bekijken, en misschien zelfs gebruiken.
mvg
Mededeling: het kost zeer veel tijd om de source volledig aan uw wensen aan te passen.
Heeft er iemand al een volledig werkende versie?
Mijn voorstel is dat deze persoon alles in een rar of zip gooit en deze hier nogmaals plaatst! (h)
is er al een deels unbugged ingame versie? want die werkt volledig niet 
werkt op zich redelijk en ja zitten fouten in
maar geloof niet dat er iemand hier is die een bugloos script heeft
dat zul je zelf moeten aanpassen
met een paar kleine aanpassingen is het mafiaforce script goed online te krijgen
zie
http://www.ganglandmaffia.nl/test/
Heb je nog geen account? Registreer je nu en word deel van onze community!