Crimes dont work

[POG1]

when i try to make a crime on the admin pannel it says this

 

UERY 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', 'rdrtd', 'ytdrytrd', 'ytrdytr', 'htrdtrd', 1, 'www', 1)' at line 1

Query was INSERT INTO crimes (crimeNAME, crimeBRAVE, crimePERCFORM, crimeSUCCESSMUNY, crimeSUCCESSCRYS, crimeSUCCESSITEM, crimeGROUP, crimeITEXT, crimeSTEXT, crimeFTEXT, crimeJTEXT, crimeJAILTIME, crimeJREASON, crimeXP) VALUES( '8484', '1', '((WILL*0.8)/2.5)+(LEVEL/4)', '33', , 0, '1', 'rdrtd', 'ytdrytrd', 'ytrdytr', 'htrdtrd', 1, 'www', 1)

 

how can i fix it?

[UCC]

Re: Crimes dont work

If I am counting your fields correctly, your input for crimeSUCCESSCRYS does not exist. I would make sure you enter a Zero into that field if it exists. You might also want to add apostrophies around that field in the query. I dont know your code exactly but I'm guessing

'{$_POST['crimeSUCCESSCRYS']}'

[POG1]

Re: Crimes dont work

wouldn't it be easier to delete the crime row and get a new 1 of someone else?

[UCC]

Re: Crimes dont work

That logic does not compute with me. Why would you go through all that effort when the fix is oh so easy?

The whole idea of solving one's problem by getting new code from someone else boggles my mind.