Problem

[WestBrookRPG]

I am having this problem...with v2

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 start lurking around the streets....and look for cash around every' 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 Trash Cans for Money', '1', '((WILL*0.8)/2.5)+(LEVEL/4)', '2', , 0, '1', 'You start lurking around the streets....and look for cash around every corner...', 'You manage to fine $2! ', 'Nothing is found...poor you!', 'A copper comes up to you... \"What do you think you are doing? I think we better go down town, and talk about this\"', 16, 'Loitering', 4)

If you can help me please do

[Isomerizer]

Re: Problem

 

INSERT INTO `crimes` (
`crimeNAME`, 
`crimeBRAVE`, 
`crimePERCFORM`, 
`crimeSUCCESSMUNY`, 
`crimeSUCCESSCRYS`, 
`crimeSUCCESSITEM`, 
`crimeGROUP`, 
`crimeITEXT`, 
`crimeSTEXT`, 
`crimeFTEXT`, 
`crimeJTEXT`, 
`crimeJAILTIME`, 
`crimeJREASON`, 
`crimeXP`)
VALUES (
'Search the Trash Cans for Money', 
1, 
'((WILL*0.8 ).Cool/2.5)+(LEVEL/4)',
2, 
NULL, 
0, 
1, 
'You start lurking around the streets....and look for cash around every corner...', 
'You manage to fine $2! ', 
'Nothing is found...poor you!', 
'A copper comes up to you... \"What do you think you are doing? I think we better go down town, and talk about this\"', 
16, 
'Loitering', 
4)

[Poldar]

Re: Problem

How would you fix it...with out having to insert...?

[Isomerizer]

Re: Problem

 

How would you fix it...with out having to insert...?

Huh? :?

The query you posted, was an insert query.

[WestBrookRPG]

Re: Problem

I fixed the problem..thanks so much for the help anyways :D