Add-On Releases - vBISpy - AJAX real-time feed of new posts/threads

After seeing the http://www.digg.com/spy application; I wondered if this could be done for vBulletin as well. I came across this webpage which had a "how to" on how they built a similiar application to do the same thing. Taking a page from their book (i.e. the code), I modified it for use with vBulletin.

During development, I also came across this post here on vBulletin.Org where the very subject had already been discussed.

So I put this together; a simple ZIP file with a single PHP script, three javascript files and 4 images.

Installation

. UNZIP the file into your forums directory
. That's it!

Virtually all the code to customize the page is in the vaispy.php script; there are no plugins, no templates and no phrases. You do not need to do anything further; this should work right out of the box.

In your browser, open the URL:

http://www.yourforum.com/forum/vaispy.php

You can see examples of this at:

http://www.viperalley.com/forum/vaispy.php
http://www.extremefitness.com/forum/vaispy.php

Note: I claim no ownership of this code except for the file vaispy.php - the rest of the files were using 'freely distributable' sources. As such, you may use these files as you wish, but please do not remove the copyrights.

This modification is for vBulletin 3.6 only, if you are running vBulletin 3.5 you will need to see this thread.

JOIN THE vBIspy Network!
Once you have this mod installed, you can join the vBIspy network to have your threads appear on this site; the vBIspy Network is a great way for people to see what's going on in various vBulletin communities and for forum owners to promote their sites and generate new traffic.

Optional add-ons

Who's Online mod for this: https://vborg.vbsupport.ru/showthread.php?t=126209

vBAdvanced Module: https://vborg.vbsupport.ru/showthread.php?t=126421

UPDATES
1.0.4
Added buro9's code from here

1.0.5 - 9.9.06
Modified some JavaScript in va_spy.js to remove split strings

1.0.6 - 9.10.06
Added date cuffoff code from here and changed init() to spyinit() - changed vaispy.php and va_spy.js files.

1.0.7 - 9.12.06
va_spy.js: Added a forum url variable to allow for integration with portals or other products outside the forum directory
va_spy.js: Added xmldelay variable at top of script for easier configuration or repolling
Updated files: vaispy.php, vb_spy.js

1.0.8 - 9.13.06
vaispy.php - changed code for checking for forum permissions to include password protected forums, added javascript tag for script code

1.0.9 - 9.16.06
vaispy.php
va_spy.js
va_effects.js
- modified to allow for proper display in Opera browsers and moved more html into vaispy.php to allow for stylevars, trimmed va_effects.js to remove unused code (ForumDog's suggestions, except not using templates yet), changed way threads are parsed (removes html as well)

1.0.10 - 9.17.06
va_prototype.js - removed 20kb of unused code

1.1.11 - 9.25.2006
vaispy.php
va_spy.js
- added SirAdrian's mods for thread status icons and alternating row colors
- added code to prepopulate the first 10 rows with existing threads allowing for 5 new ones to be added in scrolling mode (versus scrolling starting from the first thread).
- added option to display subscribed threads only

1.1.12 - 9.26.2006
vaispy.php
- added code to add empty rows if initial pull has less than 20 rows.

[bashy]

Yeah it is now, thats really weird..
I have to do my blooming edits again lol

Cheers MP

[MPDev]

And you're up on the network, too.

Cheers!

[bashy]

Just got the email, thanks again....Great work, well done

[TECK]

Originally Posted by MPDev

Just curious about adding that to the query; does that speed up the query or is it to just make sure you only grab something from the past day?

Without the date cut, you scan the hole tables for threads/posts, then you simply select the first 10.
That's really bad, if you have a huge board, it could bring your server to it's knees... very easy.
The date cut will lower A LOT the table scans, because you select only a small segment of threads/posts.
So yes, it is a performance increase.

I made 2 comments there at the top, to explain how to set the date cut, depending on how busy is your board.

[G_Man]

So, what do have to do to get on this rotation??

To be honest, I am kind of lost with all this talk about a paid Mod, etc....

[bashy]

goto the vBIspy Network in MP's signature, there is a block on the left about adding your url/site its near the top

[NeutralizeR]

Originally Posted by MPDev

And you're up on the network, too.

Cheers!

Doesn't accept international forums?

[GoTTi]

so how far back does this thing search for in post?

[MPDev]

It only grabs the last 10 posts in the past (you can change the LIMIT if you want).

As for foreign sites on the vBIspy Network; I'm trying to figure out how to support them, seems like I'll need to develop some kind of language filter so users can elect which feeds they see - no sense sending posts that users can't read.

This is not a paid mod; there was reference to some ideas I am tossing around for vBIspy.com, but that isn't related to this mod or your ability to use it as-is.

[glenvw]

Nothing showing up for me at all. Could you please check my site?

http://www.warmislands.com/tropical_...ums/vaispy.php

In IE 6 I am also getting a script error that says

Line 308
Object Expected