Jump to content
MakeWebGames

fields misssing

RazorBladerz

By RazorBladerz
in General Discussion

 Share

Recommended Posts

RazorBladerz Newbie

RazorBladerz

Posted
  • Author
Posted

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...