Help wanted adding item

[BARR3TT]

Right here is the error

QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',0, '1', 'a:4:{s:4:\"stat\";s:4:\"will\";s:3:\"dir\";s:3:\"pos\";s:8:\"inc_type\' at line 1

Query was INSERT INTO items VALUES('',3,'Full Will Potion','Refills 100% Will',,,0, '1', 'a:4:{s:4:\"stat\";s:4:\"will\";s:3:\"dir\";s:3:\"pos\";s:8:\"inc_type\";s:7:\"percent\";s:10:\"inc_amount\";i:100;}', '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, 0)

Edit : Mccodes v2 (if this helps)

Im trying to add a will potion to my game, but im getting this error

If you can post the solution be greatful thanks

Barrett

[AlabamaHit]

Re: Help wanted adding item

I assume You UNCHECKED the buyable box correct?

Ok, now.....If you did, you have to put in a price...0 and 0 <--Thats buy and sale.

[BARR3TT]

Re: Help wanted adding item

Simple as that

cheers will try now

 

thanks

edit: Yeah your spot on thanks loads.

[AlabamaHit]

Re: Help wanted adding item

no problem :-D