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.

[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

[CoreIssue]

Thanks. I was hoping it was something that simple.

On phpBB I was use to find, inline find and after add. That made it easier to figure out what the need changes were as work arounds.

I have to get use to the way Vb does it.:ermm:

[CoreIssue]

Well I cannot find the following two but the spiders are showing on the forumhome.

4. In your forumhome template, 
Find:
----------------------
<a href="online.php?$session[sessionurl]" rel="nofollow">$vbphrase[currently_active_users]</a>: $totalonline (<phrase 1="$numberregistered" 2="$numberguest">$vbphrase[x_members_and_y_guests]</phrase>)
----------------------

Replace with:
----------------------
<a href="online.php?$session[sessionurl]" rel="nofollow">$vbphrase[currently_active_users]</a>: $totalonline (<phrase 1="$numberregistered" 2="$numberguest" 3="$numberspiders">$vbphrase[x_members_and_y_guests]</phrase>)
----------------------

I template searched for forumhome template, forumhome_template, forumhome then template and template.

Just got a debug error.
DEBUG MESSAGES (1) Querying master template idstemplate.php, CVS v1.240

SQL Queries (10)



And

5. In your phrase manager, edit the phrase x_members_and_y_guests to use the third parameter, which is spiders.  Example:
{1} members and {2} guests and {3} spiders

In phrase search for x_members_and_y_guests

vBulletin Message

No Phrases Matched Your Query

Since they are showing just not worry about it?

[TomasDR]

Originally Posted by amykhar

You can do it at the point right before I do the template eval for the spiders. As they pop off the array, check for google, msn, or whatever and format it to your liking. I'm not doing it for release because everybody and their brother would be asking me how to change the colors or would want some sort of a admincp way to set them.

Amy

I have a related question but I am not looking to change them but ask why.

I have this hack and the Coloured User Groups Legend/Key hack installed.
https://vborg.vbsupport.ru/showthread.php?t=104785

Occassionally the spiders appear in different colors, red & orange concern me the most since those are the colors for Admins & SupMods. I also made some colors for Custom groups and occasionally the spiders show up in those colors too.

Any ideas?

[Zia]

Cant it show all the spider/bot listed in vbulletin_spider.xml in forum home?
any way show them in Members That Have Visited Today: block?

we are on vb 3.5.4.

Thnx.

[Zia]

Originally Posted by TomasDR

I have a related question but I am not looking to change them but ask why.Any ideas?

HELLO man..

mybe need time to get the anser