BARR3TT Posted November 30, 2008 Posted November 30, 2008 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 Quote
AlabamaHit Posted December 1, 2008 Posted December 1, 2008 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. Quote
BARR3TT Posted December 1, 2008 Author Posted December 1, 2008 Re: Help wanted adding item Simple as that cheers will try now thanks edit: Yeah your spot on thanks loads. Quote
AlabamaHit Posted December 1, 2008 Posted December 1, 2008 Re: Help wanted adding item no problem :-D Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.