Crime Creation Error [v2]

[H0MICIDAL]

everytime i try to create a crime in the staff panel i get a syntax error, and its just for creating crimes everything else works fine, heres an example of the probelm

 

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 strole down to the park looking for some extra cash.', 'Success! Y' at line 1

Query was INSERT INTO crimes (crimeNAME, crimeBRAVE, crimePERCFORM, crimeSUCCESSMUNY, crimeSUCCESSCRYS, crimeSUCCESSITEM, crimeGROUP, crimeITEXT, crimeSTEXT, crimeFTEXT, crimeJTEXT, crimeJAILTIME, crimeJREASON, crimeXP) VALUES( 'Search The Park', '2', '((WILL*0.8)/2.5)+(LEVEL/4)', '12', , 0, '1', 'You strole down to the park looking for some extra cash.', 'Success! You found 12$ In the park!', 'Darn! You couldnt find anything.', 'Looks like youll be taking a visit to jail!', 1, 'Searching the park illegally', 3)

 

help is appreciated

[Magictallguy]

Re: Crime Creation Error [v2]

I'm getting bored of constantly replying to this particular error..

When creating a crime, fill in ALL the boxes.

If you don't want the crystals to payout, input 0

[H0MICIDAL]

Re: Crime Creation Error [v2]

eh i once again feel retarded thank you very much.

[Snake]

RE: Crime Creation Error [v2]

 

everytime i try to create a crime in the staff panel i get a syntax error, and its just for creating crimes everything else works fine, heres an example of the probelm

 

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 strole down to the park looking for some extra cash.', 'Success! Y' at line 1

Query was INSERT INTO crimes (crimeNAME, crimeBRAVE, crimePERCFORM, crimeSUCCESSMUNY, crimeSUCCESSCRYS, crimeSUCCESSITEM, crimeGROUP, crimeITEXT, crimeSTEXT, crimeFTEXT, crimeJTEXT, crimeJAILTIME, crimeJREASON, crimeXP) VALUES( 'Search The Park', '2', '((WILL*0.8)/2.5)+(LEVEL/4)', '12', , 0, '1', 'You strole down to the park looking for some extra cash.', 'Success! You found 12$ In the park!', 'Darn! You couldnt find anything.', 'Looks like youll be taking a visit to jail!', 1, 'Searching the park illegally', 3)

 

help is appreciated

To Make The Crimes Be Created Every Line Must Be Filled In.....Even If It's Not Gonna Be Used....Points Given....All Non-Used Boxes Should Have 0 In Them