Forum Home Enhancements - Show Spiders on ForumHome

Show the spiders browsing your board in the What's Going On box of your Forum Home Page.

This is, unfortunately, still a code mod. The code to find is different in 3.6 and I have updated accordingly.

I have not included directions to use this with any portals.

[Icy]

Works fine for me in vB 3.7 Beta 5. You will have to change two things though.

In index.php (if you already edit it) search for:

PHP Code:

    $forumusers = $db->query_read_slave("
        SELECT
            user.username, (user.options & " . $vbulletin->bf_misc_useroptions['invisible'] . ") AS invisible, user.usergroupid,
            session.userid, session.inforum, session.lastactivity, session.useragent,
            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 OR $vbulletin->options['displayloggedin'] == 3, "ORDER BY username ASC") . "
    "); 


Replace it with:

PHP Code:

    $forumusers = $db->query_read_slave("
        SELECT
            user.username, (user.options & " . $vbulletin->bf_misc_useroptions['invisible'] . ") AS invisible, user.usergroupid,
            session.userid, session.inforum, session.lastactivity, session.useragent,
            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 OR $vbulletin->options['displayloggedin'] == 3, "ORDER BY username ASC") . "
    "); 


Replace the contents of the template forumhome_loggedinuser with:

<if condition="$loggedin[userid]"><if condition="$show['comma_leader']">, </if>$stylevar[dirmark]<a href="member.php?$session[sessionurl]u=$loggedin[userid]">$loggedin[musername]</a>$loggedin[invisiblemark]$loggedin[buddymark]<else />$loggedin[musername]</if>

[Boofo]

This can be done without editing any files now. I have been doing it without files edits since 3.5.4.

[Icy]

Originally Posted by Boofo

This can be done without editing any files now. I have been doing it without files edits since 3.5.4.

How? Can you release it here?

[Taragon]

Originally Posted by Icy

Works fine for me in vB 3.7 Beta 5. You will have to change two things though.

In index.php (if you already edit it) search for:

PHP Code:

    $forumusers = $db->query_read_slave("
        SELECT
            user.username, (user.options & " . $vbulletin->bf_misc_useroptions['invisible'] . ") AS invisible, user.usergroupid,
            session.userid, session.inforum, session.lastactivity, session.useragent,
            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 OR $vbulletin->options['displayloggedin'] == 3, "ORDER BY username ASC") . "
    "); 


Replace it with:

PHP Code:

    $forumusers = $db->query_read_slave("
        SELECT
            user.username, (user.options & " . $vbulletin->bf_misc_useroptions['invisible'] . ") AS invisible, user.usergroupid,
            session.userid, session.inforum, session.lastactivity, session.useragent,
            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 OR $vbulletin->options['displayloggedin'] == 3, "ORDER BY username ASC") . "
    "); 


Replace the contents of the template forumhome_loggedinuser with:

<if condition="$loggedin[userid]"><if condition="$show['comma_leader']">, </if>$stylevar[dirmark]<a href="member.php?$session[sessionurl]u=$loggedin[userid]">$loggedin[musername]</a>$loggedin[invisiblemark]$loggedin[buddymark]<else />$loggedin[musername]</if>

Thanks! Works like a charm!

[mariocaz]

Is there a version for 3.6.8 pl 2 ???

Thank you

[Icy]

This one works even with 3.7 Beta 5

[mariocaz]

Ok I will give it a shoot, hope works.

[Big Boss]

Originally Posted by Boofo

This can be done without editing any files now. I have been doing it without files edits since 3.5.4.

Then by all means, could you release it to the public since many of us have been waiting for it, pretty please?

[mariocaz]

Yes also I join the petition.

[Boofo]

Ok, give me a day to verify it with the co-author and I will release it.