another sql error

PHP Code:

Database error in vBulletin 2.2.7:

Invalid SQL: SELECT userid,username
                                        FROM user
                                       WHERE userid<>
                                         AND (usergroupid=5
                                          OR usergroupid=6
                                          OR usergroupid=7
                                          OR usergroupid=2)
                                       ORDER BY RAND()
                                       LIMIT 1
mysql error: You have an error in your SQL syntax near 'AND (usergroupid=5
                                          OR usergroupid=6
  ' at line 4

mysql error number: 1064

Date: Sunday 08th of September 2002 09:50:44 AM
Script: [url]http://www.darknemesis.com/forums/forums/[/url]
Referer: 


i left the forums workong fine, the when i got on this morning this happened

[DarkDraco07]

and at the obttom where it says script why does it say /forums/forums/ twice?

[DarkDraco07]

can someone help me, this is kinda important. it wont display none of the forum

[g-force2k2]

which file is this occuring in? try and replace the file with an unhacked one... regards...

g-force2k2

[DarkDraco07]

its the index.php

[g-force2k2]

DD07 did you try replacing it with a fresh index.php yet? see if that fixes the problem... if not it could be because of the php that your host is running (or mysql)

regards...

g-force2k2

[DarkDraco07]

its was the member of the day hack. i installed it right but when i run the sql error, it wont save. like, i can run it over and over, it says its inserted but its not.

[Velocd]

PHP Code:

WHERE userid<> AND (usergroupid=5 OR usergroupid=6 OR usergroupid=7 OR usergroupid=2 


Shouldn't WHERE userid<> have some kind of value after it?

Try replacing that segment with:

PHP Code:

WHERE userid<>0