Problem with the Away Hack

I am getting these errors on my forum:

This when I try to use my Admin Options:

"The action you have attempted could not be performed as your session appears to be invalid. Click the below link to attempt this action again with a new session."

And this in the Admin CP:

When I try to find a user in the CP

"There seems to have been a slight problem with the [M]adness Forum database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

And then in a text box below:

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: SELECT *,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,FROM_UNIXTIME(awaydate) AS awaydate avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
FROM user
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
WHERE user.userid=12
mysql error: You have an error in your SQL syntax near 'avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
' at line 1

mysql error number: 1064

Date: Sunday 14th of July 2002 08:16:12 PM
Script: http://www.madnessforum.com/vb/vb/a...=edit&userid=12
Referer: http://madnessforum.com/vb/admin/?"



Why am I getting these errors? How can it be fixed?

[Scrub]

I fixed this somehow. Let me post my query for ya. .

Here is the unedited code:

PHP Code:

  $user=$DB_site->query_first("SELECT user.*,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,
                               avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
                               FROM user
                               LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                               LEFT JOIN customavatar ON customavatar.userid=user.userid
                               WHERE user.userid=$userid"); 


And replace that with:

PHP Code:

$user=$DB_site->query_first("SELECT user.*,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,FROM_UNIXTIME(awaydate) AS awaydate,
                               avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
                               FROM user
                               LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                               LEFT JOIN customavatar ON customavatar.userid=user.userid
                               WHERE user.userid=$userid"); 


[Chase]

Can you tell me again where the section is

[Scrub]

Doing a search for:

PHP Code:

$user=$DB_site->query_first("SELECT 


would be alot faster. .

But in my hacked user.php, this is where it is:

PHP Code:

// ###################### Start edit #######################
if ($action=="edit") {

$user=$DB_site->query_first("SELECT user.*,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,FROM_UNIXTIME(awaydate) AS awaydate,
                               avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
                               FROM user
                               LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                               LEFT JOIN customavatar ON customavatar.userid=user.userid
                               WHERE user.userid=$userid");

  if ($user[coppauser]==1) {
    echo "<P><b>THIS IS A COPPA USER. DO NOT CHANGE TO USERGROUP TO REGISTERED USER UNLESS YOU HAVE RECEIVED PARENTAL CONSENT</b></p>";
  }