Item Table

[Chuckster]

Ok. So i accidently was messing around with my items table, and kinda fucked it up :(

Has anyone still got the default item table for mc codes V2? I really need it :s

[bladewolf2010]

your mccodes should come standard with that. unless you got another way XD

[rulerofzu]

You are be able to download the entire rar file inc sql file from your mccodes account ;)

[Danny696]

You two must be like me. (Yes! thats not all bad. xD)

Wont give out any file/table of the original mcc, but would if it was anyother mod :P

[bladewolf2010]

XD i doin what you did to me danny.

[rulerofzu]

You and I maybe Dan not sure about that blade though :D

[Danny696]

I just feel as thought if they got a proper copy, use it. If not, they can always get it again ;p

[bladewolf2010]

I'm not giving any tables out files i will but there modified for my site so they'd have to edit them

[Djkanna]

Just to be different, have you checked the V2 folder there is an SQL file in there.

[Jordan Palmer]

Delete you're item table.

 

[mysql]

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 ;[/mysql]

Add that and bam, You'll be fine :)

[Danny696]

Always one isn't there xD

[Dave]

Always one isn't there xD

He could off got it anyway by just simply typing in "Mccodes V2 Download" to the best warez site ever created.. Google :')