0

OK, I'm making items in webbased game and dunno how to design the db well to be able to use well

this is the one i made but dunno its nice or no, gonna be hard to use anyway,
what i need it item type which is Potion,Gem,or equipment ... and if potion what effect it do and if gem what effect and what level its and if equipment what name and what desc and what the type (weapon,shield,..) and what class (knight,archer,...) and what grade (normal,elite,super,....) and plus (+1,+2,+3,...) and first socket on or off and if on its empty or no and if there gem what kind and what level and the stats and this stuff

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` int(11) NOT NULL default '0',
  `itmsellprice` int(11) NOT NULL default '0',
  `itmbuyable` int(11) NOT NULL default '0',
  `itmclass` int(11) NOT NULL default '0',
  `itmgrade` int(11) NOT NULL default '0',
  `itmplus` int(11) NOT NULL default '0',
  `itmsocket1_on` tinyint(4) NOT NULL default '0',
  `itmsocket1type` int(11) NOT NULL default '0',
  `itmsocket1lvl` int(11) NOT NULL default '0',
  `itmsocket2_on` tinyint(4) NOT NULL default '0',
  `itmsocket2type` int(11) NOT NULL default '0',
  `itmsocket2lvl` int(11) NOT NULL default '0',
  `effect1_on` tinyint(4) NOT NULL default '0',
  `effect1` text NOT NULL,
  `effect2_on` tinyint(4) NOT NULL default '0',
  `effect2` text NOT NULL,
  `effect3_on` tinyint(4) NOT NULL default '0',
  `effect3` text NOT NULL,
  `weapon` int(11) NOT NULL default '0',
  `armor` int(11) NOT NULL default '0',
  `shield` int(11) NOT NULL default '0',
  PRIMARY KEY  (`itmid`)
) ENGINE=MyISAM  ;

i guess gonna be better if i make each type alone (potion,gem,equipment,..)
Please help i really need it :S

2
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by DarkBerzerk
0

Please help i really need it.

Punctuate your request. I was out of breath by the time I came to the end. I almost passed out! and what... Confused.

Edited by diafol: n/a

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.