Miscellaneous Hacks - Digital Point Spy

About
This is a Digg-style spy for seeing what's going on in your forum in realtime.

This is something I originally made about 4 years ago. Now that I rewrote it for vBulletin 4 (it also now uses the bundled YUI for animation), I decided to also wrap it up as a product package and release it for the world to use.

Installation

• Put the spy.php file in your forum folder.
• Put the digitalpoint_spy.js file in your clientscript folder.
• Install the product-digitalpoint_spy.xml product under AdminCP -> Plugins & Products -> Manage Products -> Add/Import Product

You can see a live version in action here:
http://forums.digitalpoint.com/spy.php


1.1.0 Update

• Moved JavaScript to external file (works around template parsing bug with early versions of vBulletin 4.0.x).
• XML generation is done with vBulletin's XML Builder class (let it deal with weird characters).
• Switched JavaScript library to from YUI to jQuery (for an end user, it means better animations).
• Changed do=xml to do=feed (works around servers that are overly protective and think they are trying to be hacked and blocking the request).

[MikeTrin]

sorry if this has been asked before but how long can the spy run before it times out?

[Fready]

Originally Posted by MikeTrin

sorry if this has been asked before but how long can the spy run before it times out?

I found it would time out within an hour.
I use the 'other' ispy version as it never times out, it just keeps on going.

[digitalpoint]

It does not time out.

[MikeTrin]

I left it running last night but it stopped updating at some point. Could something else cause it to time out?

[digitalpoint]

Originally Posted by MikeTrin

I left it running last night but it stopped updating at some point. Could something else cause it to time out?

If you can get to your browser console, you should be able to see any errors (maybe HTTP timeout or something).

[MyPeSePe]

I have aproblem with this mod :

Database error in vBulletin 4.1.7:

Invalid SQL:

+ + + + + + + + + +SELECT languageid,
+ + + + + +phrasegroup_global AS phrasegroup_global,
+ + + + + +phrasegroup_spy AS phrasegroup_spy,
+ + + + + +phrasegroupinfo AS lang_phrasegroupinfo,
+ + + + + +options AS lang_options,
+ + + + + +languagecode AS lang_code,
+ + + + + +charset AS lang_charset,
+ + + + + +locale AS lang_locale,
+ + + + + +imagesoverride AS lang_imagesoverride,
+ + + + + +dateoverride AS lang_dateoverride,
+ + + + + +timeoverride AS lang_timeoverride,
+ + + + + +registereddateoverride AS lang_registereddateoverride,
+ + + + + +calformat1override AS lang_calformat1override,
+ + + + + +calformat2override AS lang_calformat2override,
+ + + + + +logdateoverride AS lang_logdateoverride,
+ + + + + +decimalsep AS lang_decimalsep,
+ + + + + +thousandsep AS lang_thousandsep
+ + + + + + + + + +FROM vb_language
+ + + + + + + + + +WHERE languageid = 2;

MySQL Error ++: Unknown column 'phrasegroup_spy' in 'field list'
Error Number +: 1054
Request Date +: Sunday, October 16th 2011 @ 12:52:51 PM
Error Date +++: Sunday, October 16th 2011 @ 12:52:51 PM
Script +++++++: http://www.phonesfera.com/spy.php?langid=1
Referrer +++++: 
IP Address +++: 72.167.232.130
Username +++++: 
Classname ++++: vB_Database
MySQL Version :

[digitalpoint]

Did you install the product? Is it listed under your installed products?

[MyPeSePe]

already solved. Delete all files in this hack and install another

[1320Nation]

I made back to back attempts to install this mod on a 4.1.7 board. with no luck. First install resulted in an all white page per the spy.php page. Uninstalled 1st attempt all files completely, and reinstalled. Same results. All white page.

[ofir24]

nice mod to monitoring new forums or little forums etc, can you update the mod to vb 4.1.7?