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

$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?

[Erwin]

Safest thing is to compare the original unhacked index.php and the hacked one using Beyond Compare or Araxis Merge - one of the variables in those 3 lines of code you posted is not being used properly.

[DarkDraco07]

uh....

index.php on old forum
$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");


new forum
$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");


unhacked
$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");

[Erwin]

No, the problem is obviously not in the PM queries, but in another part of your index. I am saying to compare the WHOLE index.php because one of the user variables are not being checked properly.

[DarkDraco07]

hmmm, is there a way i can contact u on some instant messenger? this is all confusing

[Boofo]

Try replacing what you have there with this:

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

$newpm['messages']=$allpm['newpm'];
$unreadpm['messages']=$allpm['unreadpm'];

This code will also cut 2 queries from your forumhome.

[Erwin]

I'm at work. :) So no. Compare the index.php with an unhacked one, and you will find the missing or erroneous code.

[DarkDraco07]

damn, i dont know where to start. index.php is a kinda big file to look word for word, plus with the hacksinstalled it will be harder

[Boofo]

DarkDraco07, replace the code I gave you and see if that does anything.

[DarkDraco07]

1sec

[DarkDraco07]

replace the

$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");
right?

[Boofo]

Yes.

[DarkDraco07]

nope, people cant log in and i still cant log out

check it out www.darknemesis.com/forums

look at the members page and look at total members on forum home

[DarkDraco07]

just to make sure, for the members i need to backup which querys?

[Boofo]

How many members do you actually have? The code I gave you is for private messages. It shouldn't have anything to do with what seems to be happening. Somewhere in your index.php you have another problem. Either with a hack you installed or something. Like Erwin said, the only way to find out what it is is to compare it or start over with a fresh index.php and see if that fixes it.

[Erwin]

Yup. It has nothing to do with PM - the PM query is trying to find your bbuserinfo[userid] and other user information which is not being checked by index.php properly, hence your login problems.

[DarkDraco07]

NOOOO :( i hate vb!!! ahhhhh

is anyone willing to check my index.php file for me cuz...i cant seem to find a wrong variable. i searched line by line by copy/pasting in find and i cant seem to see whats wrong!!

and how come in the members page it has me and a random person on there

[DarkDraco07]

i guess thats a no...

[DarkDraco07]

i took a fresh index.php file and reinstalled EVERY hack that needed index.php. still have same problem.

for more info aobut my problem its like this...

if someone is logged out and logs in, it will show them as logged in and a guest at same time but they are not logged in.

if you are logged in (only me) and try to log out it shows u as a guest and as logged in at same time but you are logged in