MCCode v2 Criminal.php question.

[Nubbadon]

Man i've been banging my head almost all day trying to find out what the hell is wrong with this thing. Im desperate xD!

When i try to make a crime it gives me this 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', 'You walk down to the town in desperate hope for money', 'Congratulatio' at line 1

Query was INSERT INTO crimes (crimeNAME, crimeBRAVE, crimePERCFORM, crimeSUCCESSMUNY, crimeSUCCESSCRYS, crimeSUCCESSITEM, crimeGROUP, crimeITEXT, crimeSTEXT, crimeFTEXT, crimeJTEXT, crimeJAILTIME, crimeJREASON, crimeXP) VALUES( 'Look for money.', '1', '((WILL*0.8)/2.5)+(LEVEL/4)', '100', , 0, '1', 'You walk down to the town in desperate hope for money', 'Congratulation you found', 'You couldnt find any money.', 'Oh you were sent to jail!', 5, 'Cought doing a crime', 5)

And when i go on the Crimes page i look over the "crimes which isnt there lol" i see:

Warning: Invalid argument supplied for foreach() in /home/nubbadon/public_html/criminal.php on line 16

I've taken a look at line 16 in criminal.php but i cant seem to find anything strange there. I will post whats in line 16 aswell:

foreach($crimes as $v)

 

I'm no coder so hopefully there are som1 here who can help me :/

Thanks.

[wolfe]

Re: MCCode v2 Criminal.php question.

'100', , 0, '1',

No value between the two commas.

Looks like you are missing the success crystals.

[Nubbadon]

Re: MCCode v2 Criminal.php question.

Ahhh! Thanks a bunch! I woulda kissed ya if i could. lol.

[wolfe]

Re: MCCode v2 Criminal.php question.

lol. yw.