Crime Problems

[spiky]

kk well im setting up a game temperarilly on a free host tell i like it thn move to real host and domain but i got some problems

Using V2

2 problems:

Problem 1.

If i add a crime group above th crime centre where it lists all the crimes i get.

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

if i go to that line in the code it says this (hope this helps)

foreach($crimes as $v)

 

Problem 2:

When i then try to add a crime to the crime group i get the following 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 ' '', 10)' at line 1

need any other info ask im new to this

Maybe someone can paste there criminal.php code here and i can see what the difference is with mine cause when i copyed someone else item market code it sorted that problem maybe itle work the same with this

[Psycho_Coder]

Re: Crime Problems

staff_crimes.php has errors in the INSERT INTO. Look over it and you should be able to correct.

[UCC]

Re: Crime Problems

Posting Mc Code 2.0 code on here in detail is prohibited.

I think you get that error because although you have a crime group, you have no crimes to go under it. Make a crime for that group and try again

What does it say after.....

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 ' '', 10)' at line 1

It usually displays the query.

[whitescout]

Re: Crime Problems

I would go and delete all crime groups and crimes from the satabase, and then start making crime groups and crimes from the staff panel. My.02

[Psycho_Coder]

Re: Crime Problems

I was having the same problems and figured out there are missing ' points in the sql code. Find them, add them, and it will work fine