um BIG ISSUE

[DarkDraco07]

i edited this post so erwins post doesnt make sence...


for some reason wehn someone is not logged in the forums, they cant log in and they get this error :

Invalid SQL: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Monday 02nd of September 2002 08:05:34 PM
Script: (Link: http://www.darknemesis.com/forums/forums/index.php?)http://www.darknemesis.com/forums/forums/index.php?
Referer:

[Erwin]

Reinstall the "Element" hack or whatever it is that uses the column element in your database.

[DarkDraco07]

ignore the post above by erwin,

also when u click on the members button or look for users in admin page, it only shows 2 people

[Erwin]

Mmm... something is wrong with the query that checks for total number PMs in your index.php. Go and compare the code between your index.php and an original unhacked index.php.

[DarkDraco07]

uh...if i do compare... i wont know what to look for

[Erwin]

The line is in your error email -

SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=

Just look for that line, and then compare that whole piece of code with the original. Chances are there is something missing or added that is causing a query error.

[DarkDraco07]

ok, looked at clean and hacked. there were 3 lines with that in it. i compared and they were all the same

[g-force2k2]

it seems that the userid variable that you're using isn't correct... can you show us the line of coding thats on the line erroring out? regards...

g-force2k2

[DarkDraco07]

what line is that? in index.php?

this is the line erwin was talking about

PHP Code:

  $allpm=$DB_site->query_first("SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=$bbuserinfo[userid] $ignoreusers");
  $newpm=$DB_site->query_first("SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=$bbuserinfo[userid] AND dateline>$bbuserinfo[lastvisit] AND folderid=0 $ignoreusers");
  $unreadpm=$DB_site->query_first("SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=$bbuserinfo[userid] AND messageread=0 AND folderid=0 $ignoreusers"); 


[DarkDraco07]

did i give the right info?