hallo ik heb de criminalsx source gedownload maar er zit geen sql bij heeft iemand die hier liggen of heeft niemand hem.
mvg,ssjharry
criminalsx sql
-
ssjharry -
17 oktober 2009 om 10:16 -
Closed
-
-
Guest, wil je besparen op je domeinnamen? (ad)
-
Ik heb die wel ergens liggen. Ik zal eens zoeken
PHP
Toon Meer-- phpMyAdmin SQL Dump -- version 2.6.2-pl1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generatie Tijd: 16 Dec 2005 om 15:35 -- Server versie: 4.0.23 -- PHP Versie: 4.3.11 -- -- Database: `bonannx_maffia` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[5050]` -- CREATE TABLE `[5050]` ( `id` int(2) NOT NULL default '0', `owner` varchar(16) NOT NULL default 'Gangster', `prijs` int(7) NOT NULL default '1000', UNIQUE KEY `id` (`id`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[aanbiedingen]` -- CREATE TABLE `[aanbiedingen]` ( `id` int(255) NOT NULL auto_increment, `naam` varchar(255) NOT NULL default '', `aanbieding` int(255) NOT NULL default '0', `extra1` int(255) NOT NULL default '0', `extra1item` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=7 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[administrator]` -- CREATE TABLE `[administrator]` ( `id` int(255) NOT NULL auto_increment, `login` varchar(255) NOT NULL default '', `bgpimp` varchar(255) NOT NULL default 'admini', `bgima` varchar(255) NOT NULL default '', `nick` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[assajobs]` -- CREATE TABLE `[assajobs]` ( `id` int(255) NOT NULL auto_increment, `login` varchar(255) NOT NULL default '', `killname` varchar(255) NOT NULL default '', `jobgive` varchar(255) NOT NULL default '', `geld` int(255) NOT NULL default '0', `datum` datetime NOT NULL default '0000-00-00 00:00:00', `gedaan` int(1) NOT NULL default '1', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=14 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[auto]` -- CREATE TABLE `[auto]` ( `id` int(255) NOT NULL auto_increment, `soort` int(3) NOT NULL default '0', `schade` int(3) NOT NULL default '0', `owner` varchar(255) NOT NULL default '', `land` int(10) NOT NULL default '1', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=15 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[autorace]` -- CREATE TABLE `[autorace]` ( `id` int(255) NOT NULL auto_increment, `naam1` varchar(255) NOT NULL default '', `naam2` varchar(255) NOT NULL default '', `auto1` int(20) NOT NULL default '0', `schade1` int(100) NOT NULL default '0', `inzet` int(2) NOT NULL default '0', `geld` int(255) NOT NULL default '0', `aid` int(255) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=23 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[bedreq]` -- CREATE TABLE `[bedreq]` ( `id` int(255) NOT NULL auto_increment, `naam` varchar(255) NOT NULL default '', `eigenaar` varchar(255) NOT NULL default '', `land` int(255) NOT NULL default '0', `stad` int(255) NOT NULL default '0', `kav1` int(255) NOT NULL default '0', `kav2` int(255) NOT NULL default '0', `type` int(3) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=25 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[bedrijven]` -- CREATE TABLE `[bedrijven]` ( `id` int(255) NOT NULL default '0', `stad` int(255) NOT NULL default '0', `land` int(255) NOT NULL default '0', `eigenaar` varchar(255) NOT NULL default '', `type` int(3) NOT NULL default '0', `prijs` int(255) NOT NULL default '0', `naam` varchar(255) NOT NULL default '', `kav1` int(255) NOT NULL default '0', `kav2` int(255) NOT NULL default '0', `dingen` int(255) NOT NULL default '1', `winst` int(255) NOT NULL default '0', `reizen` int(255) NOT NULL default '0', `elekcost` int(255) NOT NULL default '0', `verlies` int(255) NOT NULL default '0', `verliesvd` int(255) NOT NULL default '0', `winstvd` int(255) NOT NULL default '0', `reizenvd` int(255) NOT NULL default '0' ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[bellot]` -- CREATE TABLE `[bellot]` ( `date` datetime NOT NULL default '0000-00-00 00:00:00', `lotnum` int(255) NOT NULL default '0', `lotjack` bigint(255) NOT NULL default '1000', `lotsold` bigint(255) NOT NULL default '0', `lotmax` int(255) NOT NULL default '1000', `lotleft` int(255) NOT NULL default '1000', `timelot` int(255) NOT NULL default '1', `id` int(255) NOT NULL auto_increment, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[bellotsold]` -- CREATE TABLE `[bellotsold]` ( `id` int(255) NOT NULL auto_increment, `owner` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[buddylist]` -- CREATE TABLE `[buddylist]` ( `id` int(255) NOT NULL auto_increment, `login` varchar(255) NOT NULL default '', `name` varchar(255) NOT NULL default '', `date` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=56 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[casino]` -- CREATE TABLE `[casino]` ( `owner` varchar(250) default 'admin', `spel` int(250) default '4', `land` int(255) NOT NULL default '29', `tijd` datetime NOT NULL default '0000-00-00 00:00:00', `vw` varchar(255) NOT NULL default '', `maximum` int(255) NOT NULL default '500' ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[clans]` -- CREATE TABLE `[clans]` ( `name` varchar(16) NOT NULL default '', `owner` varchar(16) NOT NULL default '', `started` datetime NOT NULL default '0000-00-00 00:00:00', `type` int(1) NOT NULL default '0', `info` text NOT NULL, `clicks` int(5) NOT NULL default '0', `clickstoday` int(3) NOT NULL default '0', `cash` int(9) NOT NULL default '0', `bank` int(9) NOT NULL default '10000', `bankleft` int(2) NOT NULL default '10', `bankmax` int(5) NOT NULL default '10000', `attwins` int(6) NOT NULL default '0', `attlosses` int(6) NOT NULL default '0', `defwins` int(6) NOT NULL default '0', `deflosses` int(6) NOT NULL default '0', `land` int(6) NOT NULL default '300', `homes` int(3) NOT NULL default '2', `money_lvl1` int(3) NOT NULL default '0', `money_lvl2` int(3) NOT NULL default '0', `money_lvl3` int(3) NOT NULL default '0', `def_lvl1` int(3) NOT NULL default '0', `def_lvl2` int(3) NOT NULL default '0', `def_lvl3` int(3) NOT NULL default '0', `IPs` text NOT NULL, `clan` varchar(255) NOT NULL default '', `lim` int(2) NOT NULL default '0', `money_lvl9` int(3) NOT NULL default '0', PRIMARY KEY (`name`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[coffeshop]` -- CREATE TABLE `[coffeshop]` ( `id` int(2) NOT NULL default '29', `owner` varchar(16) NOT NULL default 'admin', `code` int(2) NOT NULL default '0', `prijs` int(3) NOT NULL default '250', `aantal` int(5) NOT NULL default '30000', `plantages` int(255) NOT NULL default '9', UNIQUE KEY `id` (`id`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[cron]` -- CREATE TABLE `[cron]` ( `time` datetime default NULL, `name` varchar(16) NOT NULL default '', PRIMARY KEY (`name`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[dnaclones]` -- CREATE TABLE `[dnaclones]` ( `id` int(4) NOT NULL auto_increment, `achternaam` varchar(255) NOT NULL default '', `signup` datetime default NULL, `type` int(1) default NULL, `age` int(3) NOT NULL default '0', `change` int(1) NOT NULL default '1', `sex` varchar(5) NOT NULL default 'man', `bankleft` int(1) NOT NULL default '10', `clicks` int(4) NOT NULL default '10', `clickstoday` int(3) NOT NULL default '0', `attack` int(6) NOT NULL default '0', `defence` int(6) NOT NULL default '0', `turns` int(3) NOT NULL default '100', `showonline` int(1) NOT NULL default '1', `online` datetime NOT NULL default '0000-00-00 00:00:00', `activated` int(1) NOT NULL default '1', `Mes` int(5) NOT NULL default '0', `Walter P99` int(5) NOT NULL default '0', `Uzi` int(5) NOT NULL default '0', `MP5k` int(5) NOT NULL default '0', `Flashbang` int(5) NOT NULL default '0', `Granaat` int(5) NOT NULL default '0', `Shotgun` int(5) NOT NULL default '0', `G36C` int(5) NOT NULL default '0', `SIG 552` int(5) NOT NULL default '0', `Ak47` int(5) NOT NULL default '0', `Ak Beta` int(5) NOT NULL default '0', `Scherpschut geweer` int(5) NOT NULL default '0', `M4` int(5) NOT NULL default '0', `Granaat Lanceerder` int(5) NOT NULL default '0', `Bazooka` int(5) NOT NULL default '0', `Kogelvrij vest` int(5) NOT NULL default '0', `Bulldog` int(5) NOT NULL default '0', `Camera` int(5) NOT NULL default '0', `Hek` int(5) NOT NULL default '0', `Muur` int(5) NOT NULL default '0', `Bunker` int(5) NOT NULL default '0', `FN P90` int(5) NOT NULL default '0', `Chip` int(5) NOT NULL default '0', `Helm` int(5) NOT NULL default '0', `Politie wagen` int(5) NOT NULL default '0', `IPs` text NOT NULL, `blocklist` text NOT NULL, `allie` text NOT NULL, `enemy` text NOT NULL, `Xtc` int(5) NOT NULL default '0', `B2` int(5) NOT NULL default '0', `typew` int(5) NOT NULL default '4', `kogels` int(5) NOT NULL default '0', `money` int(9) NOT NULL default '0', `autocrime` int(2) NOT NULL default '2', `dealers` int(255) NOT NULL default '100', `police` int(255) NOT NULL default '100', `dieven` int(255) NOT NULL default '100', `smstegoed` int(5) NOT NULL default '50', `plevel` int(3) NOT NULL default '1', `informa` int(1) NOT NULL default '10', `experience` int(10) NOT NULL default '100', `cocaine` int(10) NOT NULL default '10000', `cokevers` int(10) NOT NULL default '100', `hitmen` int(10) NOT NULL default '100', `prostituees` int(10) NOT NULL default '500', `energie` int(5) NOT NULL default '20000', `profielv` int(5) NOT NULL default '0', `opdruktijd` datetime NOT NULL default '0000-00-00 00:00:00', `opdruktijd1` int(255) NOT NULL default '0', `HS` tinyint(255) NOT NULL default '0', `auto` datetime NOT NULL default '0000-00-00 00:00:00', `auto1` int(255) NOT NULL default '0', `gevangenis` datetime NOT NULL default '0000-00-00 00:00:00', `gevangenistijd` int(255) NOT NULL default '0', `misdaadl` int(100) NOT NULL default '0', `misdaad` 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 '14400', `bustouts` int(255) NOT NULL default '0', `carstealattempt` int(255) NOT NULL default '0', `crimes` int(255) NOT NULL default '0', `Agent` int(5) NOT NULL default '0', `rtijd` datetime NOT NULL default '0000-00-00 00:00:00', `rtijden` int(1) NOT NULL default '0', `junkies` int(255) NOT NULL default '200', `land` int(32) NOT NULL default '19', `inlijst` char(2) NOT NULL default '1', `level` int(3) NOT NULL default '1', `Mobieltje` int(1) NOT NULL default '1', `recruiters` int(9) NOT NULL default '0', `lood` bigint(255) NOT NULL default '50', `lood1` datetime NOT NULL default '0000-00-00 00:00:00', `loodt` int(255) NOT NULL default '180', `gvu` int(255) NOT NULL default '0', `cash` bigint(9) NOT NULL default '1000', `orgtime` datetime NOT NULL default '0000-00-00 00:00:00', `gstart` int(2) NOT NULL default '0', `bank` bigint(9) NOT NULL default '10000000', `ar` int(4) NOT NULL default '0', `Boksbeugel` int(5) NOT NULL default '0', `Ninjastar` int(5) NOT NULL default '0', `Landmijn` int(5) NOT NULL default '0', `Shocker` int(5) NOT NULL default '0', `Traangas` int(5) NOT NULL default '0', `T80UK` int(5) NOT NULL default '0', `Acacia` int(5) NOT NULL default '0', `Smerch` int(5) NOT NULL default '0', `Leger` int(5) NOT NULL default '0', `Beretta` int(5) NOT NULL default '0', `Remington` int(5) NOT NULL default '0', `SR99` int(5) NOT NULL default '0', `bug` int(255) NOT NULL default '0', `huur` datetime NOT NULL default '0000-00-00 00:00:00', `huur1` int(255) NOT NULL default '0', `werken1` int(5) NOT NULL default '0', `werken` datetime NOT NULL default '0000-00-00 00:00:00', `allies` text NOT NULL, `person` int(255) NOT NULL default '0', `enemies` text NOT NULL, `leven` int(8) NOT NULL default '100', `gijzel` int(2) NOT NULL default '10', `coffeshop` int(1) NOT NULL default '0', `drugsmeter` int(255) NOT NULL default '100', `health` int(3) NOT NULL default '100', `testmode` int(5) NOT NULL default '0', `aanrijden` int(3) NOT NULL default '0', `bankmax` bigint(4) NOT NULL default '10000', `pimprecht` int(5) NOT NULL default '0', `belcredits` int(255) NOT NULL default '10', `maxbet` varchar(255) NOT NULL default '0', `fowner` varchar(255) NOT NULL default '0', `flost` varchar(255) NOT NULL default '0', `fwinst` varchar(255) NOT NULL default '0', `ftotal` varchar(255) NOT NULL default '0', `ftotalklik` varchar(255) NOT NULL default '0', `hvi` int(100) NOT NULL default '0', `ritrug` varchar(255) NOT NULL default '0', `rtotalklik` varchar(255) NOT NULL default '0', `rtotal` varchar(255) NOT NULL default '0', `rlost` varchar(255) NOT NULL default '0', `rwinst` varchar(255) NOT NULL default '0', `rmaxbet` varchar(255) NOT NULL default '0', `rowner` varchar(255) NOT NULL default '0', `mfailed` int(255) NOT NULL default '0', `mwins` int(255) NOT NULL default '0', `mcarw` int(255) NOT NULL default '0', `mcarl` int(255) NOT NULL default '0', `bustouts1` int(255) NOT NULL default '0', `glos` int(255) NOT NULL default '0', `gwin` int(255) NOT NULL default '0', `awins` int(255) NOT NULL default '0', `alost` int(255) NOT NULL default '0', `hwins` int(255) NOT NULL default '0', `hlost` int(255) NOT NULL default '0', `honourpoints` int(255) NOT NULL default '10', `deal1` datetime NOT NULL default '0000-00-00 00:00:00', `dealt` int(255) NOT NULL default '100', `gespeelt` int(255) NOT NULL default '0', `cbuy` int(255) NOT NULL default '0', `faminvite` int(255) NOT NULL default '0', `partner_trouw` varchar(255) NOT NULL default '', `gaandealen` int(255) NOT NULL default '0', `Stad` int(255) NOT NULL default '1', `Fabriek` int(5) NOT NULL default '0', `Creditcard` int(5) NOT NULL default '0', `detwork` int(1) NOT NULL default '0', `detwdate` datetime NOT NULL default '0000-00-00 00:00:00', `detuser` varchar(255) NOT NULL default '', `detland` int(255) NOT NULL default '0', `detuser2` varchar(255) NOT NULL default '', `detprice` int(255) NOT NULL default '0', `detective` int(1) NOT NULL default '4', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[families]` -- CREATE TABLE `[families]` ( `id` int(255) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `leader` varchar(255) NOT NULL default '', `consig` varchar(255) NOT NULL default '', `sotto` varchar(255) NOT NULL default '', `charge` varchar(255) NOT NULL default '', `leavecost` bigint(255) NOT NULL default '0', `bank` bigint(255) NOT NULL default '0', `recruit` int(255) NOT NULL default '0', `startdate` datetime NOT NULL default '0000-00-00 00:00:00', `info` text NOT NULL, `caponame1` varchar(255) NOT NULL default '', `famimg` varchar(255) NOT NULL default '', `activated` int(255) NOT NULL default '1', `crush` int(255) NOT NULL default '0', `crushsys` int(255) NOT NULL default '0', `convsys` int(255) NOT NULL default '0', `maxautos` varchar(255) NOT NULL default '0', `autosnu` varchar(255) NOT NULL default '0', `maxkogels` varchar(255) NOT NULL default '0', `drukpers` int(255) NOT NULL default '0', `detwork` int(1) NOT NULL default '0', `detwdate` datetime NOT NULL default '0000-00-00 00:00:00', `detuser` varchar(255) NOT NULL default '', `detland` int(255) NOT NULL default '0', `detuser2` varchar(255) NOT NULL default '', `detective` int(255) NOT NULL default '4', `detprice` int(255) NOT NULL default '1000000', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=4 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[famlogs]` -- CREATE TABLE `[famlogs]` ( `id` int(255) NOT NULL auto_increment, `wat` varchar(255) NOT NULL default '', `hoeveel` bigint(255) NOT NULL default '0', `tijd` datetime NOT NULL default '0000-00-00 00:00:00', `login` varchar(255) NOT NULL default '', `familie` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=128 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[getallen]` -- CREATE TABLE `[getallen]` ( `id` int(2) NOT NULL default '0', `owner` varchar(16) NOT NULL default 'Gangster', `winst` bigint(9) NOT NULL default '0', `aantalx` int(5) NOT NULL default '0' ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[getuige]` -- CREATE TABLE `[getuige]` ( `id` int(255) default NULL, `naam` varchar(255) NOT NULL default '0', `vermoord` varchar(255) NOT NULL default '', `moorder` varchar(255) NOT NULL default '', `owner` varchar(255) NOT NULL default 'mrtrance', `bank` bigint(255) NOT NULL default '5000000' ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[handdruk]` -- CREATE TABLE `[handdruk]` ( `id` int(255) NOT NULL auto_increment, `naam` varchar(255) NOT NULL default '', `inzet` int(255) NOT NULL default '0', `wanneer` datetime NOT NULL default '0000-00-00 00:00:00', `land` int(10) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=316 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[hitlist]` -- CREATE TABLE `[hitlist]` ( `id` int(255) NOT NULL auto_increment, `naam` varchar(255) NOT NULL default '', `clan` varchar(255) NOT NULL default 'clan', `geld` int(255) NOT NULL default '0', `invoeger` varchar(255) NOT NULL default 'Anoniem', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=40 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[kogelfabriek]` -- CREATE TABLE `[kogelfabriek]` ( `land` int(255) NOT NULL default '1', `geld` int(255) NOT NULL default '2000', `tijd` datetime NOT NULL default '0000-00-00 00:00:00', `ltijd` datetime NOT NULL default '0000-00-00 00:00:00', `cash` bigint(255) NOT NULL default '5000', `lood` bigint(255) NOT NULL default '1000', `klanten` bigint(255) NOT NULL default '0', `leveranciers` bigint(255) NOT NULL default '0', `totalsold` bigint(255) NOT NULL default '0', `totalbuy` bigint(255) NOT NULL default '0', `lprijs` bigint(255) NOT NULL default '0', `minsell` bigint(255) NOT NULL default '100', `status` int(1) NOT NULL default '1', `kogels` bigint(255) NOT NULL default '1000000', `owner` varchar(255) NOT NULL default 'mrtrance' ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[land]` -- CREATE TABLE `[land]` ( `id` int(255) NOT NULL auto_increment, `stadnaam` varchar(255) NOT NULL default '', `stadnr` int(255) NOT NULL default '0', `landnr` int(255) NOT NULL default '0', `eigenaar` varchar(255) NOT NULL default 'Niemand', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=99 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[logs]` -- CREATE TABLE `[logs]` ( `time` datetime default NULL, `IP` varchar(32) default NULL, `forwardedFor` varchar(32) default NULL, `login` varchar(16) default NULL, `person` varchar(16) default NULL, `code` int(10) default NULL, `area` varchar(32) default NULL, `allies` text NOT NULL ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[messages]` -- CREATE TABLE `[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(16) 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', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=3589 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[omnilog]` -- CREATE TABLE `[omnilog]` ( `time` datetime default NULL, `login` varchar(16) default NULL, `IP` varchar(32) default NULL, `forwardedFor` varchar(32) default NULL, `file` varchar(64) default NULL, `$_POST` text, `$_GET` text ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[online]` -- CREATE TABLE `[online]` ( `time` datetime default NULL, `IP` varchar(32) default NULL, `login` varchar(16) NOT NULL default '', `validate` varchar(32) default NULL, PRIMARY KEY (`login`), KEY `IP` (`IP`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[orgcrime]` -- CREATE TABLE `[orgcrime]` ( `id` int(100) NOT NULL auto_increment, `name1` varchar(100) default NULL, `name2` varchar(100) default NULL, `name3` varchar(100) default NULL, `name4` varchar(100) default NULL, `WEA` int(1) NOT NULL default '0', `BEA` int(1) NOT NULL default '0', `DRA` int(1) NOT NULL default '0', `wapens` varchar(100) NOT NULL default '', `kogels` int(100) NOT NULL default '0', `bommen` varchar(100) NOT NULL default '', `aantal` int(100) NOT NULL default '0', `auto` varchar(100) NOT NULL default '', `klaar` int(1) NOT NULL default '0', `autoid` int(255) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[paardenrace]` -- CREATE TABLE `[paardenrace]` ( `id` int(2) NOT NULL default '0', `owner` varchar(16) NOT NULL default 'Gangster', `winst` int(9) NOT NULL default '0' ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[reizen]` -- CREATE TABLE `[reizen]` ( `land` int(255) NOT NULL auto_increment, `tijd` datetime NOT NULL default '0000-00-00 00:00:00', `ltijd` datetime NOT NULL default '0000-00-00 00:00:00', `owner` varchar(255) NOT NULL default 'Gangster', `winst` int(255) NOT NULL default '0', `aantalx` int(20) NOT NULL default '0', `geld` int(20) NOT NULL default '1100', PRIMARY KEY (`land`) ) TYPE=MyISAM AUTO_INCREMENT=30 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[roulet]` -- CREATE TABLE `[roulet]` ( `id` int(2) NOT NULL default '0', `owner` varchar(16) NOT NULL default 'Gangster', `winst` bigint(9) NOT NULL default '0' ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[smilies]` -- CREATE TABLE `[smilies]` ( `smilies_id` smallint(5) unsigned NOT NULL auto_increment, `code` varchar(50) default NULL, `smile_url` varchar(100) default NULL, `emoticon` varchar(75) default NULL, PRIMARY KEY (`smilies_id`) ) TYPE=MyISAM AUTO_INCREMENT=23 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[stats]` -- CREATE TABLE `[stats]` ( `id` int(4) NOT NULL auto_increment, `user` varchar(16) NOT NULL default '', `datum` date NOT NULL default '0000-00-00', `inzet` varchar(6) NOT NULL default '', `file` varchar(15) NOT NULL default '', `uitsl` enum('0','1') NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=57 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[temp]` -- CREATE TABLE `[temp]` ( `id` int(16) NOT NULL auto_increment, `time` datetime default NULL, `login` varchar(16) default NULL, `IP` varchar(32) default NULL, `forwardedFor` varchar(32) default NULL, `code` int(10) unsigned NOT NULL default '0', `area` varchar(32) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=55 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[users]` -- CREATE TABLE `[users]` ( `id` int(4) NOT NULL auto_increment, `achternaam` varchar(255) NOT NULL default '', `signup` datetime default NULL, `login` varchar(16) default NULL, `pass` varchar(32) default NULL, `IP` varchar(32) default NULL, `email` varchar(64) default NULL, `type` int(1) default NULL, `age` int(3) NOT NULL default '0', `change` int(1) NOT NULL default '1', `sex` varchar(5) NOT NULL default 'man', `url` varchar(128) NOT NULL default 'http://www.warzone.dutchcriminals.nl/', `info` text NOT NULL, `bankleft` int(1) NOT NULL default '10', `clicks` int(4) NOT NULL default '10', `clickstoday` int(3) NOT NULL default '0', `attack` int(6) NOT NULL default '0', `defence` int(6) NOT NULL default '0', `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', `clanlevel` int(3) NOT NULL default '0', `bonus` text NOT NULL, `turns` int(3) NOT NULL default '100', `showonline` int(1) NOT NULL default '1', `online` datetime NOT NULL default '0000-00-00 00:00:00', `activated` int(1) NOT NULL default '1', `Mes` int(5) NOT NULL default '0', `Walter P99` int(5) NOT NULL default '0', `Uzi` int(5) NOT NULL default '0', `MP5k` int(5) NOT NULL default '0', `Flashbang` int(5) NOT NULL default '0', `Granaat` int(5) NOT NULL default '0', `Shotgun` int(5) NOT NULL default '0', `G36C` int(5) NOT NULL default '0', `SIG 552` int(5) NOT NULL default '0', `Ak47` int(5) NOT NULL default '0', `Ak Beta` int(5) NOT NULL default '0', `Scherpschut geweer` int(5) NOT NULL default '0', `M4` int(5) NOT NULL default '0', `Granaat Lanceerder` int(5) NOT NULL default '0', `Bazooka` int(5) NOT NULL default '0', `Kogelvrij vest` int(5) NOT NULL default '0', `Bulldog` int(5) NOT NULL default '0', `Camera` int(5) NOT NULL default '0', `Hek` int(5) NOT NULL default '0', `Muur` int(5) NOT NULL default '0', `Bunker` int(5) NOT NULL default '0', `FN P90` int(5) NOT NULL default '0', `Chip` int(5) NOT NULL default '0', `Helm` int(5) NOT NULL default '0', `Politie wagen` int(5) NOT NULL default '0', `IPs` text NOT NULL, `blocklist` text NOT NULL, `allie` text NOT NULL, `enemy` text NOT NULL, `Xtc` int(5) NOT NULL default '0', `B2` int(5) NOT NULL default '0', `typew` int(5) NOT NULL default '4', `kogels` int(5) NOT NULL default '0', `money` int(9) NOT NULL default '0', `autocrime` int(2) NOT NULL default '2', `dealers` int(255) NOT NULL default '100', `police` int(255) NOT NULL default '100', `dieven` int(255) NOT NULL default '100', `smstegoed` int(5) NOT NULL default '50', `plevel` int(3) NOT NULL default '1', `informa` int(1) NOT NULL default '10', `experience` int(10) NOT NULL default '100', `cocaine` int(10) NOT NULL default '10000', `cokevers` int(10) NOT NULL default '100', `hitmen` int(10) NOT NULL default '100', `prostituees` int(10) NOT NULL default '500', `energie` int(5) NOT NULL default '20000', `profielv` int(5) NOT NULL default '0', `opdruktijd` datetime NOT NULL default '0000-00-00 00:00:00', `opdruktijd1` int(255) NOT NULL default '0', `HS` tinyint(255) NOT NULL default '0', `auto` datetime NOT NULL default '0000-00-00 00:00:00', `auto1` int(255) NOT NULL default '0', `gevangenis` datetime NOT NULL default '0000-00-00 00:00:00', `gevangenistijd` int(255) NOT NULL default '0', `misdaadl` int(100) NOT NULL default '0', `misdaad` 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 '14400', `bustouts` int(255) NOT NULL default '0', `carstealattempt` int(255) NOT NULL default '0', `crimes` int(255) NOT NULL default '0', `Agent` int(5) NOT NULL default '0', `rtijd` datetime NOT NULL default '0000-00-00 00:00:00', `rtijden` int(1) NOT NULL default '0', `junkies` int(255) NOT NULL default '200', `land` int(32) NOT NULL default '19', `inlijst` char(2) NOT NULL default '1', `level` int(3) NOT NULL default '1', `Mobieltje` int(1) NOT NULL default '1', `recruiters` int(9) NOT NULL default '0', `lood` bigint(255) NOT NULL default '50', `lood1` datetime NOT NULL default '0000-00-00 00:00:00', `loodt` int(255) NOT NULL default '180', `gvu` int(255) NOT NULL default '0', `cash` bigint(9) NOT NULL default '1000', `orgtime` datetime NOT NULL default '0000-00-00 00:00:00', `gstart` int(2) NOT NULL default '0', `achtergrond` varchar(128) NOT NULL default 'http://koti.mbnet.fi/eiskis/taide-taustat/hitman.jpg', `bank` bigint(9) NOT NULL default '10000000', `clan` varchar(26) NOT NULL default '', `ar` int(4) NOT NULL default '0', `Boksbeugel` int(5) NOT NULL default '0', `Ninjastar` int(5) NOT NULL default '0', `Landmijn` int(5) NOT NULL default '0', `Shocker` int(5) NOT NULL default '0', `Traangas` int(5) NOT NULL default '0', `T80UK` int(5) NOT NULL default '0', `Acacia` int(5) NOT NULL default '0', `Smerch` int(5) NOT NULL default '0', `Leger` int(5) NOT NULL default '0', `Beretta` int(5) NOT NULL default '0', `Remington` int(5) NOT NULL default '0', `SR99` int(5) NOT NULL default '0', `bug` int(255) NOT NULL default '0', `huur` datetime NOT NULL default '0000-00-00 00:00:00', `huur1` int(255) NOT NULL default '0', `werken1` int(5) NOT NULL default '0', `werken` datetime NOT NULL default '0000-00-00 00:00:00', `allies` text NOT NULL, `person` int(255) NOT NULL default '0', `enemies` text NOT NULL, `leven` int(8) NOT NULL default '100', `gijzel` int(2) NOT NULL default '10', `coffeshop` int(1) NOT NULL default '0', `drugsmeter` int(255) NOT NULL default '100', `health` int(3) NOT NULL default '100', `testmode` int(5) NOT NULL default '0', `aanrijden` int(3) NOT NULL default '0', `bankmax` bigint(4) NOT NULL default '10000', `pimprecht` int(5) NOT NULL default '0', `belcredits` int(255) NOT NULL default '10', `maxbet` varchar(255) NOT NULL default '0', `fowner` varchar(255) NOT NULL default '0', `flost` varchar(255) NOT NULL default '0', `fwinst` varchar(255) NOT NULL default '0', `ftotal` varchar(255) NOT NULL default '0', `ftotalklik` varchar(255) NOT NULL default '0', `hvi` int(100) NOT NULL default '0', `ritrug` varchar(255) NOT NULL default '0', `rtotalklik` varchar(255) NOT NULL default '0', `rtotal` varchar(255) NOT NULL default '0', `rlost` varchar(255) NOT NULL default '0', `rwinst` varchar(255) NOT NULL default '0', `rmaxbet` varchar(255) NOT NULL default '0', `rowner` varchar(255) NOT NULL default '0', `mfailed` int(255) NOT NULL default '0', `mwins` int(255) NOT NULL default '0', `mcarw` int(255) NOT NULL default '0', `mcarl` int(255) NOT NULL default '0', `bustouts1` int(255) NOT NULL default '0', `glos` int(255) NOT NULL default '0', `gwin` int(255) NOT NULL default '0', `vandaaggebeld2` int(255) NOT NULL default '0', `awins` int(255) NOT NULL default '0', `alost` int(255) NOT NULL default '0', `hwins` int(255) NOT NULL default '0', `hlost` int(255) NOT NULL default '0', `honourpoints` int(255) NOT NULL default '10', `deal1` datetime NOT NULL default '0000-00-00 00:00:00', `dealt` int(255) NOT NULL default '100', `rente` bigint(255) NOT NULL default '0', `gespeelt` int(255) NOT NULL default '0', `cbuy` int(255) NOT NULL default '0', `faminvite` int(255) NOT NULL default '0', `capo` varchar(255) NOT NULL default '', `family` varchar(255) NOT NULL default '', `famleader` int(255) NOT NULL default '0', `famsotto` int(255) NOT NULL default '0', `famconsig` int(255) NOT NULL default '0', `partner_trouw` varchar(255) NOT NULL default '', `bverdediging` int(255) NOT NULL default '0', `bkracht` int(255) NOT NULL default '0', `bgeneessnelheid` int(255) NOT NULL default '0', `bmoordervaring` int(255) NOT NULL default '0', `bgezondheid` int(255) NOT NULL default '0', `bvindsnelheid` int(255) NOT NULL default '0', `gezondheid` int(255) NOT NULL default '100', `moordervaring` int(255) NOT NULL default '15', `verdediging` int(255) NOT NULL default '50', `kracht` int(255) NOT NULL default '5', `geneessnelheid` int(255) NOT NULL default '20', `vindsnelheid` int(255) NOT NULL default '25', `upgradedp` int(255) NOT NULL default '1', `avaurl` varchar(255) NOT NULL default 'http://www.aoqz76.dsl.pipex.com/Web%20Page%20Components/Wallpaper/Games/Hitman%202.jpg', `gaandealen` int(255) NOT NULL default '0', `Stad` int(255) NOT NULL default '1', `Fabriek` int(5) NOT NULL default '0', `Creditcard` int(5) NOT NULL default '0', `detwork` int(1) NOT NULL default '0', `detwdate` datetime NOT NULL default '0000-00-00 00:00:00', `detuser` varchar(255) NOT NULL default '', `detland` int(255) NOT NULL default '0', `detuser2` varchar(255) NOT NULL default '', `detprice` int(255) NOT NULL default '0', `detective` int(1) NOT NULL default '4', `rank` int(255) NOT NULL default '1', `rankv` int(255) NOT NULL default '0', `testament` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `login` (`login`) ) TYPE=MyISAM AUTO_INCREMENT=9266 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[veiling]` -- CREATE TABLE `[veiling]` ( `id` int(11) NOT NULL auto_increment, `soort` int(255) NOT NULL default '0', `plaatser` varchar(255) NOT NULL default '', `hoeveel` bigint(255) NOT NULL default '0', `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`) ) TYPE=MyISAM AUTO_INCREMENT=29 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[veilingboden]` -- CREATE TABLE `[veilingboden]` ( `id` int(255) NOT NULL auto_increment, `veilid` int(255) NOT NULL default '0', `login` varchar(255) NOT NULL default '', `bod` int(255) NOT NULL default '0', `tijd` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=28 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[weapons]` -- CREATE TABLE `[weapons]` ( `id` int(4) NOT NULL auto_increment, `name` varchar(30) NOT NULL default '', `area` int(2) default NULL, `costs` int(7) default NULL, `url` varchar(40) default NULL, `attack` int(5) default NULL, `defence` int(5) default NULL, `max` text, `eval` text, `error` text, `extra` text, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=92 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `bl` -- CREATE TABLE `bl` ( `id` int(11) NOT NULL auto_increment, `login` varchar(20) NOT NULL default '', `time` datetime NOT NULL default '0000-00-00 00:00:00', `ip` varchar(255) NOT NULL default '', `wat` varchar(100) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=87 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `forummess` -- CREATE TABLE `forummess` ( `datum` datetime NOT NULL default '0000-00-00 00:00:00', `titel` varchar(255) NOT NULL default '', `text` text NOT NULL, `schrijver` varchar(255) NOT NULL default '', `forum` int(255) NOT NULL default '1', `id` int(255) NOT NULL auto_increment, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=10 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `ip_blocks` -- CREATE TABLE `ip_blocks` ( `id` int(11) NOT NULL auto_increment, `ip_adres` varchar(20) NOT NULL default '', `block_datum` varchar(20) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=24 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jail` -- CREATE TABLE `jail` ( `id` int(4) NOT NULL auto_increment, `login` varchar(17) default NULL, `reden` varchar(30) default NULL, `straf` varchar(17) default NULL, `date` varchar(25) NOT NULL default '', `rechter` varchar(40) NOT NULL default '', `uitslag` varchar(40) default 'Schuldig', UNIQUE KEY `id` (`id`) ) TYPE=MyISAM AUTO_INCREMENT=9 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `news` -- CREATE TABLE `news` ( `id` int(11) NOT NULL auto_increment, `titel` varchar(255) NOT NULL default '(Geen)', `datum` varchar(255) NOT NULL default '00-00-0000', `text` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `playermess` -- CREATE TABLE `playermess` ( `titel` varchar(255) NOT NULL default '', `datum` datetime NOT NULL default '0000-00-00 00:00:00', `forum` int(255) NOT NULL default '1', `text` text NOT NULL, `poster` varchar(255) NOT NULL default '', `id` int(255) NOT NULL auto_increment, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `poll` -- CREATE TABLE `poll` ( `poll_id` int(11) NOT NULL auto_increment, `poll_stelling` varchar(255) NOT NULL default '', `poll_keuzes` longtext NOT NULL, `poll_scores` longtext NOT NULL, `poll_datum` int(20) NOT NULL default '0', PRIMARY KEY (`poll_id`) ) TYPE=MyISAM AUTO_INCREMENT=5 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `updates` -- CREATE TABLE `updates` ( `id` int(255) NOT NULL auto_increment, `upd` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `votes` -- CREATE TABLE `votes` ( `vote_id` int(11) NOT NULL auto_increment, `vote_ip` varchar(16) NOT NULL default '', `vote_datum` int(20) NOT NULL default '0', PRIMARY KEY (`vote_id`) ) TYPE=MyISAM AUTO_INCREMENT=65 ;Alstu,
Met vriendelijke groet,
Luc
-
hartelijk dank voor de sql:slotje:
-
:slotje:
Participate now!
Heb je nog geen account? Registreer je nu en word deel van onze community!