[uae]

Originally Posted by docvader

Uae, getting a mysql error when trying to access the Who's Online section of my site:


My online.php relevant section looks like this:


Any ideas? It was working before the hack.

rich

You have missed something there, let's do it again.

In ONLINE.PHP FIND

SELECT user.username, session.useragent,

Replace it WITH

 
SELECT user.username, session.useragent, session.sessionhash,

AGAIN in ONLINE.PHP FIND

$guests["$count"]['username'] = $vbphrase['guest'];

Add Below

 
// [START HACK='vB Pager' AUTHOR='WwW.UAEWEB.COM' VERSION='2.0.4' CHANGEID= 3 ]
  $guests["$count"]['sessionid']= $users[sessionhash];
// [END HACK='vB Pager' AUTHOR='WwW.UAEWEB.COM' VERSION='2.0.4' CHANGEID= 3 ]