Help

[DISTORTED]

Does anyone have the code to create items table on my db.My son hit the drop key now we got to add every item over.

[AlabamaHit]

Re: Help

 

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',
 `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',
 PRIMARY KEY  (`itmid`)
) ENGINE=MyISAM  ;

[DISTORTED]

Re: Help

thanks that did it

[DISTORTED]

Re: Help

need help, anyone know how to fix this

QUERY ERROR: Column count doesn't match value count at row 1

Query was INSERT INTO items VALUES('',23,'test','+5',10000,5000,1, '0', 'a:4:{s:4:\"stat\";s:6:\"energy\";s:3:\"dir\";s:3:\"pos\";s:8:\"inc_type\";s:6:\"figure\";s:10:\"inc_amount\";i:0;}', '0', 'a:4:{s:4:\"stat\";s:6:\"energy\";s:3:\"dir\";s:3:\"pos\";s:8:\"inc_type\";s:6:\"figure\";s:10:\"inc_amount\";i:0;}', '0', 'a:4:{s:4:\"stat\";s:6:\"energy\";s:3:\"dir\";s:3:\"pos\";s:8:\"inc_type\";s:6:\"figure\";s:10:\"inc_amount\";i:0;}', 0, 5, 0, 0, 0, 0, 0, 0)

[Strats]

Re: Help

Wow Never seen an error like that lol

[castle]

Re: Help

the item table given was from a mod, not the original mccodes item table

[Strats]

Re: Help

 

Does anyone have the code to create items table on my db.My son hit the drop key now we got to add every item over.

Is it for V1 or V2?

[Uridium]

Re: Help

the reason your probably getting that error is cos your staff_items.php has more Queries than your actual SQL so if youve adde extra in the past to the staff_items.php you will have to replace those SQLS back to phpmyadmin..

That will resolve your problem :)

[castle]

Re: Help

 

Does anyone have the code to create items table on my db.My son hit the drop key now we got to add every item over.

Is it for V1 or V2?

It's from here, great mod by the way:

http://criminalexistence.com/ceforums/index.php?topic=26757.0