Re: fields misssing
CREATE TABLE `adminlogs` (
`adID` int(11) NOT NULL auto_increment,
`adUSER` int(11) NOT NULL default '0',
`adPOST` longtext NOT NULL,
`adGET` longtext NOT NULL,
`adTIME` int(11) NOT NULL default '0',
PRIMARY KEY (`adID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `adminlogs`
--
-- --------------------------------------------------------
--
-- Table structure for table `armour`
--
CREATE TABLE `armour` (
`item_ID` int(11) NOT NULL default '0',
`Defence` int(11) NOT NULL default '0'
) ENGINE=MyISAM ;
--
-- Dumping data for table `armour`
--
-- --------------------------------------------------------
--
-- Table structure for table `attacklogs`
--
CREATE TABLE `attacklogs` (
`log_id` int(11) NOT NULL auto_increment,
`attacker` int(11) NOT NULL default '0',
`attacked` int(11) NOT NULL default '0',
`result` enum('won','lost') NOT NULL default 'won',
`time` int(11) NOT NULL default '0',
`stole` bigint(20) NOT NULL default '0',
`attacklog` longtext NOT NULL,
PRIMARY KEY (`log_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `attacklogs`
--
-- --------------------------------------------------------
--
-- Table structure for table `cashxferlogs`
--
CREATE TABLE `cashxferlogs` (
`cxID` int(11) NOT NULL auto_increment,
`cxFROM` int(11) NOT NULL default '0',
`cxTO` int(11) NOT NULL default '0',
`cxAMOUNT` bigint(20) NOT NULL default '0',
`cxTIME` int(11) NOT NULL default '0',
`cxFROMIP` varchar(15) NOT NULL default '127.0.0.1',
`cxTOIP` varchar(15) NOT NULL default '127.0.0.1',
`cxCONTENT` longtext NOT NULL,
PRIMARY KEY (`cxID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `cashxferlogs`
--
-- --------------------------------------------------------
--
-- Table structure for table `cities`
--
CREATE TABLE `cities` (
`cityid` int(11) NOT NULL auto_increment,
`cityname` varchar(255) NOT NULL default '',
`citydesc` longtext NOT NULL,
`cityminlevel` int(11) NOT NULL default '0',
PRIMARY KEY (`cityid`)
) ENGINE=MyISAM AUTO_INCREMENT=6 ;
--
-- Dumping data for table `cities`
--
INSERT INTO `cities` VALUES (1, 'Mono Central', 'This city has been the home of newcomers to Mono Country for many years... it is resourceful and provides many job opportunities.', 1);
INSERT INTO `cities` VALUES (2, 'Country Farms', 'A cheap place to buy food, this is a peaceful place for pacifists but property is very expensive.', 5);
INSERT INTO `cities` VALUES (3, 'El Ablo', 'The place of the truly strong.', 20);
INSERT INTO `cities` VALUES (4, 'Industrial Sector', 'The industrial sector of Mono Central.', 1);
INSERT INTO `cities` VALUES (5, 'Cyber State', 'One for those who are masters at the game', 50);
-- --------------------------------------------------------
--
-- Table structure for table `crimegroups`
--
CREATE TABLE `crimegroups` (
`cgID` int(11) NOT NULL auto_increment,
`cgNAME` varchar(255) NOT NULL default '',
`cgORDER` int(11) NOT NULL default '0',
PRIMARY KEY (`cgID`)
) ENGINE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `crimegroups`
--
INSERT INTO `crimegroups` VALUES (1, 'Search for money', 1);
INSERT INTO `crimegroups` VALUES (2, 'Sell illegal CDs', 2);
-- --------------------------------------------------------
--
-- Table structure for table `crimes`
--
CREATE TABLE `crimes` (
`crimeID` int(11) NOT NULL auto_increment,
`crimeNAME` varchar(255) NOT NULL default '',
`crimeBRAVE` int(11) NOT NULL default '0',
`crimePERCFORM` text NOT NULL,
`crimeSUCCESSMUNY` bigint(20) NOT NULL default '0',
`crimeGROUP` int(11) NOT NULL default '0',
`crimeITEXT` text NOT NULL,
`crimeSTEXT` text NOT NULL,
`crimeFTEXT` text NOT NULL,
`crimeEXP` DOUBLE NOT NULL,
PRIMARY KEY (`crimeID`)
) ENGINE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `crimes`
--
INSERT INTO `crimes` VALUES (1, 'Near The Council', 1, '((WILL*0.8)/1)+(LEVEL/4)', 10, 1, '1. You head over to the council.
\r\n2. You start scavenging for coins.
', 'Result: You collect ${money} from the gutters!', 'Result: There''s no change to be seen!', 1.25);
INSERT INTO `crimes` VALUES (2, 'Under a Hobo''s Shack', 1, '((WILL*0.8)/1.5)+(LEVEL/4)', 20, 1, '1. You head over to the shack of well-known hobo, Kent.
\r\n2. You creep underneath and start scavenging for money.
', 'Result: You dig up ${money}!', 'Result: Kent finds you and says "What yo doin here?". You walk off briskly.', 2.5);
INSERT INTO `crimes` VALUES (3, 'Music CDS', 3, '((WILL*0.8)/3)+(LEVEL/4)', 30, 2, '1. You go down to the local market and buy some blank CDs.
\r\n2. You head home and burn some music onto these CDs.
\r\n3. You go back to the market, set up your stall, and wait for customers.
', 'Result: You sell your stock making you ${money}!', 'Result: No-one wants to buy your worthless garbage!', 3.75);
INSERT INTO `crimes` VALUES (4, 'Video CDs', 3, '((WILL*0.8)/3.5)+(LEVEL/4)', 34, 2, '1. You go down to the local market and buy some blank CDs.
\r\n2. You head home and burn some videos onto these CDs.
\r\n3. You go back to the market, set up your stall, and wait for customers.
', 'Result: You sell your stock making you ${money}!', 'Result: No-one wants to buy your worthless garbage!', 4.25);
-- --------------------------------------------------------
--
-- Table structure for table `events`
--
CREATE TABLE `events` (
`evID` int(11) NOT NULL auto_increment,
`evUSER` int(11) NOT NULL default '0',
`evTIME` int(11) NOT NULL default '0',
`evREAD` int(11) NOT NULL default '0',
`evTEXT` text NOT NULL,
PRIMARY KEY (`evID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `events`
--
-- --------------------------------------------------------
--
-- Table structure for table `fedjail`
--
CREATE TABLE `fedjail` (
`fed_id` int(11) NOT NULL auto_increment,
`fed_userid` int(11) NOT NULL default '0',
`fed_days` int(11) NOT NULL default '0',
`fed_jailedby` int(11) NOT NULL default '0',
`fed_reason` text NOT NULL,
PRIMARY KEY (`fed_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `fedjail`
--
-- --------------------------------------------------------
--
-- Table structure for table `food`
--
CREATE TABLE `food` (
`item_id` int(11) NOT NULL default '0',
`energy` int(11) NOT NULL default '0'
) ENGINE=MyISAM ;
--
-- Dumping data for table `food`
--
-- --------------------------------------------------------
--
-- Table structure for table `houses`
--
CREATE TABLE `houses` (
`hID` int(11) NOT NULL auto_increment,
`hNAME` varchar(255) NOT NULL default '',
`hPRICE` bigint(20) NOT NULL default '0',
`hWILL` int(11) NOT NULL default '0',
PRIMARY KEY (`hID`)
) ENGINE=MyISAM AUTO_INCREMENT=14 ;
--
-- Dumping data for table `houses`
--
INSERT INTO `houses` VALUES (1, 'Garden Shed', 0, 100);
INSERT INTO `houses` VALUES (2, 'Apartment', 12500, 150);
INSERT INTO `houses` VALUES (3, 'Motel Room', 32000, 200);
INSERT INTO `houses` VALUES (4, 'Semi-Detached House', 80000, 250);
INSERT INTO `houses` VALUES (5, 'Detached House', 400000, 450);
INSERT INTO `houses` VALUES (6, 'Chalet', 1000000, 750);
INSERT INTO `houses` VALUES (7, 'Mansion', 15000000, 1200);
INSERT INTO `houses` VALUES (8, 'Penthouse', 45000000, 2000);
INSERT INTO `houses` VALUES (9, 'Castle', 125000000, 3500);
INSERT INTO `houses` VALUES (11, 'Luxurious Space Shuttle', 375000000, 7500);
INSERT INTO `houses` VALUES (10, 'Small Space Shuttle', 250000000, 5000);
INSERT INTO `houses` VALUES (12, 'Artificial Orbiting Moon', 1000000000, 12500);
INSERT INTO `houses` VALUES (13, 'Brothel', 2000000000, 20000);
-- --------------------------------------------------------
--
-- Table structure for table `inventory`
--
CREATE TABLE `inventory` (
`inv_id` int(11) NOT NULL auto_increment,
`inv_itemid` int(11) NOT NULL default '0',
`inv_userid` int(11) NOT NULL default '0',
`inv_qty` bigint(20) NOT NULL default '0',
PRIMARY KEY (`inv_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `inventory`
--
-- --------------------------------------------------------
--
-- Table structure for table `itembuylogs`
--
CREATE TABLE `itembuylogs` (
`ibID` int(11) NOT NULL auto_increment,
`ibUSER` int(11) NOT NULL default '0',
`ibITEM` int(11) NOT NULL default '0',
`ibTOTALPRICE` bigint(20) NOT NULL default '0',
`ibQTY` bigint(20) NOT NULL default '0',
`ibTIME` int(11) NOT NULL default '0',
`ibCONTENT` text NOT NULL,
PRIMARY KEY (`ibID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `itembuylogs`
--
-- --------------------------------------------------------
--
-- Table structure for table `items`
--
CREATE TABLE `items` (
`itmid` int(11) NOT NULL auto_increment,
`itmtype` int(11) NOT NULL default '0',
`itmname` varchar(255) NOT NULL default '',
`itmdesc` text NOT NULL,
`itmbuyprice` bigint(20) NOT NULL default '0',
`itmsellprice` bigint(20) NOT NULL default '0',
`itmbuyable` int(11) NOT NULL default '0',
PRIMARY KEY (`itmid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `items`
--
-- --------------------------------------------------------
--
-- Table structure for table `itemselllogs`
--
CREATE TABLE `itemselllogs` (
`isID` int(11) NOT NULL auto_increment,
`isUSER` int(11) NOT NULL default '0',
`isITEM` int(11) NOT NULL default '0',
`isTOTALPRICE` bigint(20) NOT NULL default '0',
`isQTY` bigint(20) NOT NULL default '0',
`isTIME` int(11) NOT NULL default '0',
`isCONTENT` text NOT NULL,
PRIMARY KEY (`isID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `itemselllogs`
--
-- --------------------------------------------------------
--
-- Table structure for table `itemtypes`
--
CREATE TABLE `itemtypes` (
`itmtypeid` int(11) NOT NULL auto_increment,
`itmtypename` varchar(255) NOT NULL default '',
PRIMARY KEY (`itmtypeid`)
) ENGINE=MyISAM AUTO_INCREMENT=8 ;
--
-- Dumping data for table `itemtypes`
--
INSERT INTO `itemtypes` VALUES (1, 'Food');
INSERT INTO `itemtypes` VALUES (2, 'Electronics');
INSERT INTO `itemtypes` VALUES (3, 'Melee Weapon');
INSERT INTO `itemtypes` VALUES (4, 'Gun');
INSERT INTO `itemtypes` VALUES (5, 'Medical');
INSERT INTO `itemtypes` VALUES (6, 'Collectible');
INSERT INTO `itemtypes` VALUES (7, 'Armour');
-- --------------------------------------------------------
--
-- Table structure for table `itemxferlogs`
--
CREATE TABLE `itemxferlogs` (
`ixID` int(11) NOT NULL auto_increment,
`ixFROM` int(11) NOT NULL default '0',
`ixTO` int(11) NOT NULL default '0',
`ixITEM` int(11) NOT NULL default '0',
`ixQTY` bigint(20) NOT NULL default '0',
`ixTIME` int(11) NOT NULL default '0',
PRIMARY KEY (`ixID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `itemxferlogs`
--
-- --------------------------------------------------------
--
-- Table structure for table `jaillogs`
--
CREATE TABLE `jaillogs` (
`jaID` int(11) NOT NULL auto_increment,
`jaJAILER` int(11) NOT NULL default '0',
`jaJAILED` int(11) NOT NULL default '0',
`jaDAYS` int(11) NOT NULL default '0',
`jaREASON` longtext NOT NULL,
`jaTIME` int(11) NOT NULL default '0',
PRIMARY KEY (`jaID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `jaillogs`
--
-- --------------------------------------------------------
--
-- Table structure for table `mail`
--
CREATE TABLE `mail` (
`mail_id` int(11) NOT NULL auto_increment,
`mail_read` int(11) NOT NULL default '0',
`mail_from` int(11) NOT NULL default '0',
`mail_to` int(11) NOT NULL default '0',
`mail_time` int(11) NOT NULL default '0',
`mail_subject` varchar(255) NOT NULL default '',
`mail_text` text NOT NULL,
PRIMARY KEY (`mail_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `mail`
--
-- --------------------------------------------------------
--
-- Table structure for table `papercontent`
--
CREATE TABLE `papercontent` (
`content` longtext NOT NULL
) ENGINE=MyISAM ;
--
-- Dumping data for table `papercontent`
--
INSERT INTO `papercontent` VALUES ('[[b]11/07/05[/b]] Codes Purchased From Dabomstew');
-- --------------------------------------------------------
--
-- Table structure for table `referals`
--
CREATE TABLE `referals` (
`refID` int(11) NOT NULL auto_increment,
`refREFER` int(11) NOT NULL default '0',
`refREFED` int(11) NOT NULL default '0',
`refTIME` int(11) NOT NULL default '0',
`refREFERIP` varchar(15) NOT NULL default '127.0.0.1',
`refREFEDIP` varchar(15) NOT NULL default '127.0.0.1',
PRIMARY KEY (`refID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `referals`
--
CREATE TABLE `settings` (
`conf_id` int(11) NOT NULL auto_increment,
`conf_name` varchar(255) NOT NULL default '',
`conf_value` text NOT NULL,
PRIMARY KEY (`conf_id`)
) TYPE=MyISAM ;
INSERT INTO `settings` ( `conf_id` , `conf_name` , `conf_value` )
VALUES (
'', 'game_version', '101'
);
-- --------------------------------------------------------
--
-- Table structure for table `shopitems`
--
CREATE TABLE `shopitems` (
`sitemID` int(11) NOT NULL auto_increment,
`sitemSHOP` int(11) NOT NULL default '0',
`sitemITEMID` int(11) NOT NULL default '0',
PRIMARY KEY (`sitemID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `shopitems`
--
-- --------------------------------------------------------
--
-- Table structure for table `shops`
--
CREATE TABLE `shops` (
`shopID` int(11) NOT NULL auto_increment,
`shopLOCATION` int(11) NOT NULL default '0',
`shopNAME` varchar(255) NOT NULL default '',
`shopDESCRIPTION` text NOT NULL,
PRIMARY KEY (`shopID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `shops`
--
-- --------------------------------------------------------
--
-- Table structure for table `staffnews`
--
CREATE TABLE `staffnews` (
`snID` int(11) NOT NULL auto_increment,
`snPOSTER` int(11) NOT NULL default '0',
`snIMPORTANCE` enum('low','medium','high') NOT NULL default 'low',
`snSUBJECT` varchar(255) NOT NULL default '',
`snTEXT` longtext NOT NULL,
`snTIME` int(11) NOT NULL default '0',
PRIMARY KEY (`snID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `staffnews`
--
-- --------------------------------------------------------
--
-- Table structure for table `staffnotelogs`
--
CREATE TABLE `staffnotelogs` (
`snID` int(11) NOT NULL auto_increment,
`snCHANGER` int(11) NOT NULL default '0',
`snCHANGED` int(11) NOT NULL default '0',
`snTIME` int(11) NOT NULL default '0',
`snOLD` longtext NOT NULL,
`snNEW` longtext NOT NULL,
PRIMARY KEY (`snID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `staffnotelogs`
--
-- --------------------------------------------------------
--
-- Table structure for table `unjaillogs`
--
CREATE TABLE `unjaillogs` (
`ujaID` int(11) NOT NULL auto_increment,
`ujaJAILER` int(11) NOT NULL default '0',
`ujaJAILED` int(11) NOT NULL default '0',
`ujaTIME` int(11) NOT NULL default '0',
PRIMARY KEY (`ujaID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `unjaillogs`
--
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`userid` int(11) NOT NULL auto_increment,
`username` varchar(255) NOT NULL default '',
`userpass` varchar(255) NOT NULL default '',
`level` int(11) NOT NULL default '0',
`exp` decimal(11,4) NOT NULL default '0.0000',
`money` bigint(20) NOT NULL default '0',
`laston` int(11) NOT NULL default '0',
`lastip` varchar(255) NOT NULL default '',
`energy` int(11) NOT NULL default '0',
`will` int(11) NOT NULL default '0',
`maxwill` int(11) NOT NULL default '0',
`brave` int(11) NOT NULL default '0',
`maxbrave` int(11) NOT NULL default '0',
`maxenergy` int(11) NOT NULL default '0',
`hp` int(11) NOT NULL default '0',
`maxhp` int(11) NOT NULL default '0',
`location` int(11) NOT NULL default '0',
`fedjail` int(11) NOT NULL default '0',
`user_level` int(11) NOT NULL default '1',
`gender` enum('Male','Female') NOT NULL default 'Male',
`daysold` int(11) NOT NULL default '0',
`signedup` int(11) NOT NULL default '0',
`email` varchar(255) NOT NULL default '',
`login_name` varchar(255) NOT NULL default '',
`display_pic` text NOT NULL,
`duties` varchar(255) NOT NULL default 'N/A',
`staffnotes` longtext NOT NULL,
`mailban` int(11) NOT NULL default '0',
`mb_reason` varchar(255) NOT NULL default '',
`crystals` bigint(20) NOT NULL default '0',
`signature` text NOT NULL,
PRIMARY KEY (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` VALUES (1, 'adUsername', md5('adPassword'), 1, 0, 100, 1155283843, '127.0.0.1', 12, 100, 100, 5, 5, 12, 100, 100, 1, 0, 2, 'Male', 0, 1145750935, 'adEmail', 'adUsername', '', 'N/A', '', 0, '', 0, '');
-- --------------------------------------------------------
--
-- Table structure for table `userstats`
--
CREATE TABLE `userstats` (
`userid` int(11) NOT NULL default '0',
`strength` decimal(11,4) NOT NULL default '0.0000',
`agility` decimal(11,4) NOT NULL default '0.0000',
`guard` decimal(11,4) NOT NULL default '0.0000',
`labour` decimal(11,4) NOT NULL default '0.0000',
`IQ` decimal(11,6) NOT NULL default '0.000000'
) ENGINE=MyISAM ;
--
-- Dumping data for table `userstats`
--
INSERT INTO `userstats` VALUES (1, 10.0000, 10.0000, 10.0000, 10.0000, 10.000000);
-- --------------------------------------------------------
--
-- Table structure for table `weapons`
--
CREATE TABLE `weapons` (
`item_id` int(11) NOT NULL default '0',
`damage` decimal(11,4) NOT NULL default '0.0000'
) ENGINE=MyISAM ;
--
-- Dumping data for table `weapons`
--
Edit: added code tags
