Help V2 Crime error

[norwayzone]

Hello I am new and I am reciving crime error mails when trying to make new crimes.

Here:

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 ...ect bla bla...

And how do I change the sucess % for crimes ?

Please help quick :)

[norwayzone]

Re: Help V2 Crime error

I can also not add cities, I click in the details and press add and the page flashes as if its added and back to add cities.

Crimes fixed but I still can not add cities!!!

[Danny696]

Re: Help V2 Crime error

Whats the error

[norwayzone]

Re: Help V2 Crime error

TY for replay!! I can simply not get the system to add any cities..

I got every thing working but the game does not want to add new cities.. i type in detailes then press enter and it just goes back to same page with blank box ... so its as if the page just refreshes when i press enter or make city!! :S

[Feky]

Re: Help V2 Crime error

it could be that you are missing a query

[Feky]

Re: Help V2 Crime error

do you have this is your staff cities

$db->query("INSERT INTO cities VALUES(NULL, '$name', '$desc', '$minlevel', '$travtime')");

print "City {$name} added to the game.";

[Feky]

Re: Help V2 Crime error

 

do you have this is your staff cities

$db->query("INSERT INTO cities VALUES(NULL, '$name', '$desc', '$minlevel')");

print "City {$name} added to the game.";

[Danny696]

Re: Help V2 Crime error

check for this query

$db->query("INSERT INTO cities VALUES(NULL, '$name', '$desc', '$minlevel')");
print "City {$name} added to the game.";

[norwayzone]

Re: Help V2 Crime error

Where shall i check for that querry? phpmyAdmin?

[norwayzone]

Re: Help V2 Crime error

Yes I got that, every thing works beside add cities I do not understand it.. coding looks fine!

[Magictallguy]

Re: Help V2 Crime error

Check the form, look for name='minlevel

It's missing a ', simply add it in