merhabalar tablo yapısı budur umarım db dosyasında olan şeyleri yapıştırdım
CREATE TABLE `[land]` (
`owner` varchar(255) NOT NULL default '',
`id` int(255) NOT NULL default '0',
`type` int(255) NOT NULL default '0'
) TYPE=MyISAM;
INSERT INTO `[land]` VALUES ('none', 1, 0);
INSERT INTO `[land]` VALUES ('none', 2, 0);
INSERT INTO `[land]` VALUES ('none', 3, 0);
INSERT INTO `[land]` VALUES ('none', 4, 0);
INSERT INTO `[land]` VALUES ('none', 5, 0);
INSERT INTO `[land]` VALUES ('none', 6, 0);
INSERT INTO `[land]` VALUES ('none', 7, 0);
INSERT INTO `[land]` VALUES ('none', 8, 0);
INSERT INTO `[land]` VALUES ('none', 9, 0);
INSERT INTO `[land]` VALUES ('none', 10, 0);
INSERT INTO `[land]` VALUES ('none', 11, 0);
INSERT INTO `[land]` VALUES ('none', 12, 0);
INSERT INTO `[land]` VALUES ('none', 13, 0);
INSERT INTO `[land]` VALUES ('none', 14, 0);
INSERT INTO `[land]` VALUES ('none', 15, 0);
INSERT INTO `[land]` VALUES ('none', 16, 0);
INSERT INTO `[land]` VALUES ('none', 17, 0);
INSERT INTO `[land]` VALUES ('none', 18, 0);
INSERT INTO `[land]` VALUES ('none', 19, 0);
INSERT INTO `[land]` VALUES ('none', 20, 0);
INSERT INTO `[land]` VALUES ('none', 21, 0);
INSERT INTO `[land]` VALUES ('none', 22, 0);
INSERT INTO `[land]` VALUES ('none', 23, 0);
INSERT INTO `[land]` VALUES ('none', 24, 0);
INSERT INTO `[land]` VALUES ('none', 25, 0);
INSERT INTO `[land]` VALUES ('none', 26, 0);
INSERT INTO `[land]` VALUES ('none', 27, 0);
INSERT INTO `[land]` VALUES ('none', 28, 0);
INSERT INTO `[land]` VALUES ('none', 29, 0);
INSERT INTO `[land]` VALUES ('none', 30, 0);
INSERT INTO `[land]` VALUES ('none', 31, 0);
INSERT INTO `[land]` VALUES ('none', 32, 0);
INSERT INTO `[land]` VALUES ('none', 33, 0);
INSERT INTO `[land]` VALUES ('none', 34, 0);
INSERT INTO `[land]` VALUES ('none', 35, 0);
INSERT INTO `[land]` VALUES ('none', 36, 0);
INSERT INTO `[land]` VALUES ('none', 37, 0);
INSERT INTO `[land]` VALUES ('none', 38, 0);
INSERT INTO `[land]` VALUES ('none', 39, 0);
INSERT INTO `[land]` VALUES ('none', 40, 0);
INSERT INTO `[land]` VALUES ('none', 41, 0);
INSERT INTO `[land]` VALUES ('none', 42, 0);
INSERT INTO `[land]` VALUES ('none', 44, 0);
INSERT INTO `[land]` VALUES ('none', 43, 0);
INSERT INTO `[land]` VALUES ('none', 45, 0);
INSERT INTO `[land]` VALUES ('none', 46, 0);
INSERT INTO `[land]` VALUES ('none', 47, 0);
INSERT INTO `[land]` VALUES ('none', 48, 0);
INSERT INTO `[land]` VALUES ('none', 49, 0);
INSERT INTO `[land]` VALUES ('none', 50, 0);
INSERT INTO `[land]` VALUES ('none', 51, 0);
INSERT INTO `[land]` VALUES ('none', 52, 0);
INSERT INTO `[land]` VALUES ('none', 53, 0);
INSERT INTO `[land]` VALUES ('none', 54, 0);
INSERT INTO `[land]` VALUES ('none', 55, 0);
CREATE TABLE `auctions` (
`id` int(255) NOT NULL auto_increment,
`what` varchar(255) default NULL,
`by` varchar(255) default NULL,
`country` varchar(255) default NULL,
`hbid` int(255) NOT NULL default '0',
`reason` varchar(255) default NULL,
`datem` varchar(255) default NULL,
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=13 ;
CREATE TABLE `auctions_data` (
`id` int(255) NOT NULL auto_increment,
`itemid` int(255) default NULL,
`who` varchar(255) default NULL,
`money` int(255) default '0',
`datem` varchar(255) default NULL,
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=20 ;
CREATE TABLE `berichten` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(255) default NULL,
`bericht` varchar(255) default NULL,
`topic` varchar(255) default NULL,
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
CREATE TABLE `blackjack` (
`id` int(255) NOT NULL auto_increment,
`better` varchar(255) default NULL,
`bet` int(255) NOT NULL default '0',
`state` varchar(255) default NULL,
`card1` varchar(255) default NULL,
`card2` varchar(255) default NULL,
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;
CREATE TABLE `booze` (
`Beer` varchar(255) default '0',
`Rum` varchar(255) default '0',
`Whiskey` varchar(255) default '0',
`Vodka` varchar(255) default '0',
`state` varchar(255) default NULL
) TYPE=MyISAM;
INSERT INTO `booze` VALUES ('5724', '467', '7953', '157', 'Netherlands');
INSERT INTO `booze` VALUES ('5724', '467', '7953', '157', 'Italy');
INSERT INTO `booze` VALUES ('5724', '467', '7953', '157', 'United States');
INSERT INTO `booze` VALUES ('5724', '467', '7953', '157', 'Japan');
INSERT INTO `booze` VALUES ('5724', '467', '7953', '157', 'Poland');
INSERT INTO `booze` VALUES ('5724', '467', '7953', '157', 'Russia');
INSERT INTO `booze` VALUES ('5724', '467', '7953', '157', 'Columbia');
INSERT INTO `booze` VALUES ('5724', '467', '7953', '157', 'China');
INSERT INTO `booze` VALUES ('5724', '467', '7953', '157', 'France');
INSERT INTO `booze` VALUES ('5724', '467', '7953', '157', 'Australia');
CREATE TABLE `booze_units` (
`id` int(255) NOT NULL auto_increment,
`booze_` varchar(255) default NULL,
`ammount` int(255) NOT NULL default '0',
`user_booze_` varchar(255) default NULL,
`state` varchar(255) default NULL,
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
CREATE TABLE `casino` (
`id` varchar(255) default NULL,
`owner_casino` varchar(255) default NULL,
`max_bet` varchar(255) NOT NULL default '2000',
`state_cas` varchar(255) default NULL
) TYPE=MyISAM;
INSERT INTO `casino` VALUES ('2', 'GaLiL', '50000', 'Italy');
INSERT INTO `casino` VALUES ('3', 'GaLiL', '2000', 'United States');
INSERT INTO `casino` VALUES ('4', 'GaLiL', '2000', 'Japan');
INSERT INTO `casino` VALUES ('5', 'GaLiL', '2000', 'Poland');
INSERT INTO `casino` VALUES ('6', 'GaLiL', '2000', 'Russia');
INSERT INTO `casino` VALUES ('7', 'GaLiL', '2000', 'Columbia');
INSERT INTO `casino` VALUES ('8', 'GaLiL', '2000', 'China');
INSERT INTO `casino` VALUES ('9', 'GaLiL', '2000', 'Netherlands');
INSERT INTO `casino` VALUES ('10', 'GaLiL', '2000', 'France');
INSERT INTO `casino` VALUES ('11', 'GaLiL', '2000', 'Australia');
CREATE TABLE `crews` (
`id` int(255) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`boss` varchar(255) default NULL,
`bank` varchar(255) NOT NULL default '2000',
`recruiter` varchar(255) default NULL,
`cleaner` varchar(255) default NULL,
`rang` varchar(255) NOT NULL default '1',
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=14 ;
CREATE TABLE `death` (
`id` int(255) NOT NULL auto_increment,
`who` varchar(255) default NULL,
`bywho` varchar(255) default NULL,
`when` varchar(255) default NULL,
`rank` varchar(255) default NULL,
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
CREATE TABLE `factory` (
`id` int(255) NOT NULL auto_increment,
`owner` varchar(255) default NULL,
`bullets` int(255) NOT NULL default '2000',
`producing` varchar(255) NOT NULL default '10',
`offer` varchar(255) default NULL,
`state` varchar(255) default NULL,
`stamp` varchar(255) default NULL,
`price` int(255) NOT NULL default '500',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;
INSERT INTO `factory` VALUES (1, 'admin', 3500, '0', NULL, 'Italy', '1128097350', 500);
INSERT INTO `factory` VALUES (2, 'GaLiL', 3500, '0', NULL, 'United States', '1128097350', 500);
INSERT INTO `factory` VALUES (3, 'GaLiL', 3500, '0', NULL, 'Japan', '1128097350', 500);
INSERT INTO `factory` VALUES (4, 'GaLiL', 3500, '0', NULL, 'Poland', '1128097350', 500);
INSERT INTO `factory` VALUES (5, 'GaLiL', 3500, '0', NULL, 'Russia', '1128097350', 500);
INSERT INTO `factory` VALUES (6, 'GaLiL', 3500, '0', NULL, 'Columbia', '1128097350', 500);
INSERT INTO `factory` VALUES (7, 'GaLiL', 3500, '0', NULL, 'China', '1128097350', 500);
INSERT INTO `factory` VALUES (8, 'GaLiL', 3500, '0', NULL, 'Netherlands', '1128097350', 500);
INSERT INTO `factory` VALUES (9, 'GaLiL', 3500, '0', NULL, 'France', '1128097350', 500);
INSERT INTO `factory` VALUES (10, 'GaLiL', 3500, '0', NULL, 'Australia', '1128097350', 500);
CREATE TABLE `forum` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(255) default NULL,
`naam` varchar(255) default NULL,
`datum` varchar(255) default NULL,
`locked` int(1) NOT NULL default '0',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
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=2313 ;
INSERT INTO `forummess` VALUES ('0000-00-00 00:00:00', 'Welcome', 'Welcome to the bugs section.', 'GaLiL', 2, 2311);
CREATE TABLE `gta` (
`id` int(255) NOT NULL auto_increment,
`type` varchar(255) default NULL,
`damage` varchar(255) default NULL,
`location_car` varchar(255) default NULL,
`owner_car` varchar(255) default NULL,
`orginal` varchar(255) default NULL,
`ship_time` varchar(255) default NULL,
`when` varchar(255) default NULL,
`3` varchar(255) default NULL,
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=69 ;
CREATE TABLE `hitlist` (
`id` int(11) NOT NULL auto_increment,
`target` varchar(255) NOT NULL default '',
`payer` varchar(255) NOT NULL default '',
`ammount` int(255) NOT NULL default '0',
`reason` varchar(255) NOT NULL default '',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;
CREATE TABLE `inbox` (
`id` int(5) NOT NULL auto_increment,
`username` varchar(255) default NULL,
`reciever` varchar(255) default NULL,
`datem` varchar(255) default NULL,
`baricht` text,
`unread` int(1) NOT NULL default '0',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=97 ;
CREATE TABLE `ip_block` (
`ip` varchar(255) default NULL
) TYPE=MyISAM;
CREATE TABLE `jail` (
`id` int(11) NOT NULL auto_increment,
`whoinjail` varchar(255) default NULL,
`whenarrest` varchar(255) default NULL,
`tillwhen` varchar(255) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=80 ;
CREATE TABLE `jailbox` (
`id` int(5) NOT NULL auto_increment,
`sender` varchar(255) default NULL,
`reciever` varchar(255) default NULL,
`datem` varchar(255) default NULL,
`baricht` text,
`unread` int(1) NOT NULL default '0',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=32 ;
CREATE TABLE `loggedin` (
`username` varchar(255) default NULL,
`password` varchar(255) default NULL,
`datem` varchar(255) default NULL,
`ip` varchar(255) default NULL
) TYPE=MyISAM;
CREATE TABLE `oc` (
`id` int(255) NOT NULL auto_increment,
`leader` varchar(255) default NULL,
`weapon_expert` varchar(255) default NULL,
`explosive_expert` varchar(255) default NULL,
`driver` varchar(255) default NULL,
`location_oc` varchar(255) default NULL,
`datem` varchar(255) default NULL,
`we` varchar(255) default NULL,
`ee` varchar(255) default NULL,
`dr` varchar(255) default NULL,
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;
CREATE TABLE `oc_offers` (
`id` int(255) NOT NULL auto_increment,
`who` varchar(255) default NULL,
`towho` varchar(255) default NULL,
`state` varchar(255) default NULL,
`bewhat` varchar(255) default NULL,
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;
CREATE TABLE `offerscrew` (
`id` int(255) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`crew` varchar(255) default NULL,
`accepted` char(1) NOT NULL default '0',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;
CREATE TABLE `online` (
`ip` varchar(255) default NULL,
`login` varchar(255) default NULL
) TYPE=MyISAM;
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,
`last` datetime NOT NULL default '0000-00-00 00:00:00',
`type` int(1) NOT NULL default '0',
`locked` int(1) NOT NULL default '0',
`protected` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=520 ;
INSERT INTO `playermess` VALUES ('Read This First!', '2005-09-25 22:03:35', 2, 'Welcome to the bugs section.\r\nPlease read all another bugs first before posting your own found bug!', 'GaLiL', 517, '2005-09-25 22:03:35', 3, 1, 0);
CREATE TABLE `search` (
`id` int(255) NOT NULL auto_increment,
`killer` varchar(255) NOT NULL default '',
`target` varchar(255) NOT NULL default '',
`detective` varchar(255) NOT NULL default '',
`searchdate` varchar(255) NOT NULL default '',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;
CREATE TABLE `stats` (
`type` int(1) NOT NULL default '0',
`extra` varchar(100) NOT NULL default '',
`value1` int(11) NOT NULL default '0',
`value2` int(11) NOT NULL default '0',
`datum` int(20) NOT NULL default '0',
`maand` int(20) NOT NULL default '0',
`jaar` int(20) NOT NULL default '0',
`ip` varchar(100) NOT NULL default ''
) TYPE=MyISAM;
INSERT INTO `stats` VALUES (2, '', 1, 614, 1127944800, 9, 2005, '');
INSERT INTO `stats` VALUES (3, 'Grand Theft Auto', 127, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'Crime', 123, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (1, '', 1, 1216, 1050247515, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'Forum', 26, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'Travel', 31, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'Find Player', 8, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'View Profile', 8, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'Users Online', 5, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'Organised Crime', 60, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'Faq', 5, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'Mobile Zone', 3, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'Stats', 8, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'Crew', 21, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'Jail', 51, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'Inbox', 28, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'Jailbox', 8, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'At Home', 13, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'Bank', 7, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'Booze Cartel', 13, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'Buy Stuff', 5, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'Bullet Factory', 125, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'Search/Kill', 4, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'Hitlist', 336, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'BlackJack', 44, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'Disconnect', 47, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'Index', 112, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (3, 'Supported phones', 1, 0, 0, 0, 0, '');
INSERT INTO `stats` VALUES (4, '', 0, 0, 1128031200, 0, 0, '127.0.0.1');
INSERT INTO `stats` VALUES (2, '', 1, 606, 1128031200, 9, 2005, '');
INSERT INTO `stats` VALUES (3, 'Screenshots', 1, 0, 0, 0, 0, '');
CREATE TABLE `steden` (
`id` int(255) NOT NULL auto_increment,
`welke` varchar(255) default NULL,
`prijs` int(255) NOT NULL default '0',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;
INSERT INTO `steden` VALUES (1, 'Italy', 200);
INSERT INTO `steden` VALUES (2, 'United States', 0);
INSERT INTO `steden` VALUES (3, 'Japan', 0);
INSERT INTO `steden` VALUES (4, 'Poland', 200);
INSERT INTO `steden` VALUES (5, 'Russia', 200);
INSERT INTO `steden` VALUES (6, 'Columbia', 0);
INSERT INTO `steden` VALUES (7, 'China', 0);
INSERT INTO `steden` VALUES (8, 'Netherlands', 0);
INSERT INTO `steden` VALUES (9, 'France', 0);
INSERT INTO `steden` VALUES (10, 'Australia', 0);
CREATE TABLE `transfers` (
`id` int(255) NOT NULL auto_increment,
`whosend` varchar(255) default NULL,
`whoreceived` varchar(255) default NULL,
`moneywhat` varchar(255) default NULL,
`when` varchar(255) default NULL,
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
CREATE TABLE `users` (
`id` int(5) NOT NULL auto_increment,
`username` varchar(255) default NULL,
`password` varchar(255) default NULL,
`rang` varchar(255) NOT NULL default '0',
`geld` int(255) NOT NULL default '1500',
`crew` varchar(255) NOT NULL default '0',
`health` varchar(255) NOT NULL default '100',
`gun` varchar(255) NOT NULL default '0',
`protection` varchar(255) NOT NULL default '0',
`quote` varchar(255) NOT NULL default 'No quote',
`kills` varchar(255) NOT NULL default '0',
`crime` varchar(255) NOT NULL default '0',
`gta` varchar(255) NOT NULL default '0',
`oc` varchar(255) NOT NULL default '0',
`locatie` varchar(255) NOT NULL default 'Roggel',
`recover` varchar(255) NOT NULL default '0',
`travel` varchar(255) NOT NULL default '0',
`bank` varchar(255) NOT NULL default '0',
`timebank` varchar(255) NOT NULL default '0',
`online` varchar(255) NOT NULL default '0',
`moderator` varchar(255) NOT NULL default '0',
`signedup` varchar(255) default NULL,
`blank` varchar(255) NOT NULL default '0',
`latina` varchar(255) NOT NULL default '0',
`asian` varchar(255) NOT NULL default '0',
`black` varchar(255) NOT NULL default '0',
`specialised` varchar(255) NOT NULL default '0',
`email` varchar(255) default NULL,
KEY `userid` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;
CREATE TABLE `woman` (
`blank` varchar(255) NOT NULL default '0',
`latina` varchar(255) NOT NULL default '0',
`asian` varchar(255) NOT NULL default '0',
`black` varchar(255) NOT NULL default '0',
`state` varchar(255) default NULL
) TYPE=MyISAM;