Miscellaneous Hacks - Spider Display

Spider Display
Version 1.0.4
(By Boofo)

What does this product do?
This Hack displays the Number of Spiders on Forumhome and Who is Online.

If you are using a previous version of this mod, make sure to replace the default vBulletin template lines back into the templates and they are now automatically edited.

Version Information:
Version 1.0.1 --Initial release for vBulletin 3.7
Version 1.0.2 --Fixed MySQL error.
Version 1.0.3 --Fixed the leading comma issue when there were no members online.
Version 1.0.4 --Template edits now done automatically. No more manual template edits.

Credits:
A big thank you goes out to Andreas for coming up with the original code for this for 3.5.4. It now works in 3.7.

Installation overview:
Products to install: (1)
File Edits: (See the NOTE below)

Installation Instructions:
1. Upload spiders_vbulletin.xml to the includes/xml directory on your site.

2. Go to your Admin CP
Scroll down to 'Plugin System'
Click 'Manage Products'
Click 'Add/Import Product'
Click the 'Browse' button, and locate the product-spiderdisplay.xml file on your computer

Done!
Enjoy!

NOTE: There is one file edit that I have not found a way to get around yet. It is a special template cache that must be used with this. The easiest way to do it is add the file edit to the includes/config.php. Since this file does not change as often, you should be fine on most upgrades. This is the ONLY file edit.

NOTE: If you do not click install, you do not need support.

[ChurchMedia]

Cool! I just had to uninstall the 3.6 version. I'll install this tomorrow. Keep pumping them out, Boofo!

[Magnumutz]

Yup... you were right Icy... i had edited the config but forgot to upload it


But now i'm getting this error:

Database error in vBulletin 3.7.0 Beta 4:

Invalid SQL:

        SELECT useragent
        FROM session
        WHERE lastactivity > 
        AND userid = 0;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND userid = 0' at line 4
Error Number  : 1064
Date          : Monday, February 25th 2008 @ 08:58:56 AM
Script        : http://www.arcademania.ro/
Referrer      : *****
IP Address    : *****
Username      : Unregistered
Classname     : *****
MySQL Version : 
=====================================================

[JD45]

Originally Posted by Magnumutz

Yup... you were right Icy... i had edited the config but forgot to upload it


But now i'm getting this error:

Database error in vBulletin 3.7.0 Beta 4:

Invalid SQL:

        SELECT useragent
        FROM session
        WHERE lastactivity > 
        AND userid = 0;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND userid = 0' at line 4
Error Number  : 1064
Date          : Monday, February 25th 2008 @ 08:58:56 AM
Script        : http://www.arcademania.ro/
Referrer      : *****
IP Address    : *****
Username      : Unregistered
Classname     : *****
MySQL Version : 
=====================================================

I was getting the SAME exact error as well. I had to remove this and it went away. Something with the config.php mod perhaps?

[Magnumutz]

Donno for sure... Boofo's gotta help us out

[Boofo]

What exact code are you putting in the config.php and exactly where?

[JD45]

if(THIS_SCRIPT == 'index')
{
global $specialtemplates;
$specialtemplates = array_merge($specialtemplates, array('wol_spiders'));
}

Right before the closing php tag.

[Boofo]

What version of MySQL and PHP is your server using?

And move the code above the bottom box.

[Magnumutz]

I've got

if(THIS_SCRIPT == 'index')
{
global $specialtemplates;
$specialtemplates = array_merge($specialtemplates, array('wol_spiders'));
}

Before the bottom box.

PHP 4.4.6 & MySQL 4.1.22.

[Boofo]

Try uninstalling it and re-installing it again.

[Bounce]

I had same database error and had to remove the hack

code was before the end box in config

PHP 5.2.5 - MySQL Version 5.0.45