Attack.php help

[Shole]

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 'ORDER BY rand()' at line 1

Query was SELECT i.armor FROM items i WHERE itmid= ORDER BY rand()

That i got i replaced the attack.php with ravens script attack.php since i cant find the attack.php of mccodes because my assistant/helper deleted the mcodes and added a new attack.php which doesent work and now he is off line for a week because of school.

How can i fix this problem?

[DigitalGerm]

Query was SELECT i.armor FROM items i WHERE itmid= ORDER BY rand()

 

don't know how attack.php script looks like, so it's hard to guess.

[ddgamedesign]

We'd need to see more of the code to know what was up.

[Diesl]

I don't know why you have SELECT i.armor FROM items i.. when you can just do SELECT armor FROM items

But if you want to keep it that way, make this change: WHERE i.itmid=.........