Sql error with bought script.

[killay]

Hi,

I recently bought a mmo php script from ravan.info. I tried contacting them, but haven't got any response yet in 2 days. I've been searching on the internet and found out that they might have copied the script from another website. The other way around is also possible offcourse, none have proof. The only problem I have now is that I get an sql error. I hope now, one of you guys can help me out

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, '0', '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('',6,'test','testdesc',,,0, '0', '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)

 

[user-7256]

Those multiple commas in a row look a bit suspicious to me...

 

[krishmk]

I guess the problem is this:
'test','testdesc',##HERE###,##AND HERE###,0,

It should be either NULL Or have some value.

 

[killay]

thanks, I'll check into that