Show Spiders Online on ForumHome

This is a port of my 3.0.x modification. It shows, on your forumhome page, any spiders that are present (ones that show as a spider on your who's online page)

NOTE: If you are using a portal that shows who's online, this mod will mess up your portal. As of this date, I do not know of any working portals for 3.5 and I do not have the code to fix portals.

Please understand what this mod does before you start crying that it doesn't work. This mod will show any spiders who show up as a spider on who's online as a spider on the forumhome page. It will NOT show a spider who shows up as a guest on who's online as a spider. It does not add additional spiders to the list either.

PLEASE DO NOT INSTALL THIS IF YOU ARE UNABLE TO ADJUST YOUR OWN PORTAL TEMPLATES SO THAT THE PHRASE DOES NOT CONTAIN AN ERROR.

[Mudvayne]

amykhar.. I just downloaded the zip file.. No upgrading instruction thr.. :S.. Or i hav to redo the all modification from begginin?

[MioTraGusa]

thanks for update the nice hack ... but there are many errors in the number of guest ... see pictures...

[amykhar]

Did the codeblock that displays the spiders get pasted in twice? It looks fine in the count, but is displaying the spiders more than once.

Check this chunk:

 while ($spidername = current($spiderlist))
  {
  if ($spidername > 1) {
  $loggedin['musername'] = trim(key($spiderlist)) . "(" . $spidername.")";
  }
  else
  {
  $loggedin['musername'] = trim(key($spiderlist));
  }
  $loggedin['userid'] = 0;
  eval('$activeusers .= ", ' . fetch_template('forumhome_loggedinuser') . '";');
  next($spiderlist);
  }

[MioTraGusa]

Not, the codeblock alone this hit a single time, I have tried the modificacion several times and always is obtained the same result, so much in forumhome as in online :disappointed:, so that I have opted for returning to the previous version of your hack which functions correctly. Thanks again

[rrokdoka]

Where do i find index.php in the ACP? It sounds like a newbie question because im somewhat of a newbie to this! lol

[bashy]

You dont...login to your ftp and its in forum root

[rrokdoka]

hmmmmm.... i logged in to my ftp a while ago and i opened it up and i cant find eventcache. So i was wondering if there was a place in ACP?

[amykhar]

rrokdoka,
I think you should skip this mod for a while until you've had a bit more experience. It's a more advanced install and not for the faint of heart.

Also, given that your site is already throwing errors and I have no way of even seeing if you are running vbulletin or what version it is, I'm not even sure you have 3.5 running.

[bashy]

As a clue though m8...

Where it says in the instructions..

1. In index.php

Find:
----------------------
'eventcache',
----------------------

Add After:
----------------------
'wol_spiders',
----------------------

Find:
----------------------
$numberguest = 0;
----------------------

Add after:
----------------------
$numberspiders = 0;
$spiderlist = array();
----------------------

An so on....... Index.php is your index file that should be in your forums/forums folder on your ftp....

The edits are made in this file....

There are also other files to edit as well such as online.php..
Please have another good read of the instructions

If this does not makes sense then as amy says, leave this for a while untill you have installed a few easier 1's

Good luck....

Originally Posted by rrokdoka

hmmmmm.... i logged in to my ftp a while ago and i opened it up and i cant find eventcache. So i was wondering if there was a place in ACP?

[rrokdoka]

hehehe well that wasnt my website amy. I dont know how that got in there you can visit my website here.... www.rrokdoka.org

and i really would like to add this mod but like i said i open up the index.php and there isnt a 'eventcache' to be found!

[rrokdoka]

Can someone please help me with this...

[quanvo81]

Edited !

I was asking for a solution, but I figured it out, thanks anyway !

[catocom2]

reinstalled for 3.5.4

[CoreIssue]

I began installing on 3.5.4 and hit a snag.

 Find:
----------------------
 $forumusers = $db->query_read("
  SELECT
   userfield.*,user.username, (user.options & " . $vbulletin->bf_misc_useroptions['invisible'] . ") AS invisible, user.usergroupid,
   session.userid, session.inforum, session.lastactivity,
   IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
  FROM " . TABLE_PREFIX . "session AS session
  LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = session.userid)
  LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(user.userid = userfield.userid)
  WHERE session.lastactivity > $datecut
  " . iif($vbulletin->options['displayloggedin'] == 1, "ORDER BY username ASC") . "
 ");

At a minimum userfiled.* is no longer there.

  $forumusers = $db->query_read("
  SELECT
   user.username, (user.options & " . $vbulletin->bf_misc_useroptions['invisible'] . ") AS invisible, user.usergroupid,
   session.userid, session.browser, session.inforum, session.lastactivity,
   IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
  FROM " . TABLE_PREFIX . "session AS session
  LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = session.userid)
  WHERE session.lastactivity > $datecut
  " . iif($vbulletin->options['displayloggedin'] == 1, "ORDER BY username ASC") . "
 ");

[amykhar]

The key to changing the query is to get session.useragent into the query. That's the field that tells us if it's a spider or not.

Amy