Need Items sql

[? Sparks ?]

I need a new code to run, I can't edit, create , use, or send my Items, and You cant sell them :S

[Uridium]

Re: Need Items sql

do you just want the standard V2 sqls for 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` 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  ;

 

CREATE TABLE `itemtypes` (
 `itmtypeid` int(11) NOT NULL auto_increment,
 `itmtypename` varchar(255) NOT NULL default '',
 PRIMARY KEY  (`itmtypeid`)
) ENGINE=MyISAM  ;

[? Sparks ?]

Re: Need Items sql

I went and tried to run this

 

 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 ,
`helmet` int( 11 ) NOT NULL default '0',
`weapon` int( 11 ) NOT NULL default '0',
`armor` int( 11 ) NOT NULL default '0',
`boots` int( 11 ) NOT NULL default '0',
`amulet` int( 11 ) NOT NULL default '0',
`bracelet` int( 11 ) NOT NULL default '0',
`ring` int( 11 ) NOT NULL default '0',
`special` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `itmid` )
) ENGINE = MYISAM 

 

But It says

MySQL said: Documentation

#1050 - Table 'items' already exists

But when I go to create an Item It says

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

Query was INSERT INTO items VALUES('',7,'Stick (+50)','Deadly weapon that you can rip off a tree',25000,12500,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;}', 50, 0, 0, 0, 0, 0, 0, 0)

[Uridium]

Re: Need Items sql

 

I need a new code to run, I can't edit, create , use, or send my Items, and You cant sell them :S

Ok im confused now :) are you wanting the staff_items.php file and not the SQLS file...

[CrazyT]

Re: Need Items sql

 

Table 'items' already exists

That means "Items" mysql table already exists in the database.

[Guest Sniko`]

Re: Need Items sql

 

Table 'items' already exists

That means "Items" mysql table already exists in the database.

Yup, eaither u have added a column into items or you have modified staff_items.php query to insert into database