Miscellaneous Hacks - vBISpy - AJAX real-time feed of new posts/threads

This is a port of vBISpy by MPDev to vBulletin4. MPDev has given me permission to port this modification, if any staff need to see it, I can forward the PM.


If you use this modification, please >> Mark As Installed, Nominate for MOTM, or Support Developer <<, thank you


What is this!?
vBISpy is an AJAX real-time feed of new posts/threads for your vBulletin 4.0 forum.

Please note that this is currently in Beta. The style is not perfect, but the mod should be fully functionial.


Current Version
2.0.4 - You can find the 3.6.x version, here.


Features flagged for future version(s):

• looking for suggestions

Will this work on x.x.x ??
Unless otherwise stated, this will work on all 4.0.x versions. This will not work on 3.x.


Sounds cool. How do I install?

1. Extract the zip, you should have the following directories/files:
   
   

   /
   |_ vaispy.php
   
   /clientscript/
   |_ va_effects.js
   |_ va_prototype.js
   |_ va_spy.js
   
   /images/
   	/misc/
   	|_ pause_down.gif
   	|_ pause_up.gif
   	|_ play_down.gif
   	|_ play_up.gif

2. Upload: (in the below instructions 'yourforum' would be where you have vBulletin installed)
   
   • vaispy.php to /yourforum/vaispy.php
     
   • /clientscript/*.js to /yourforum/clientscript/*.js
     
   • /images/misc/*.gif to /yourforum/images/misc/*.gif

Upgrading
Unless noted otherwise, just upload and overwrite 'vaispy.php'.


Customization
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.

If you'd like to block certain usergroups from viewing vBISpy; or certain forums from being displayed - edit vaispy.php

PHP Code:

/**
* Do not list these forums even if they have 
* permissions (test categories, etc)
*
* Enter them by ID, separated by commans (eg: 1,2,3)
*/
$blockforums = '';

/**
* Do not allow these groups.
*
* Enter them by ID, separated by commans (eg: 1,2,3)
*/
$blockgroups = ''; 


In your browser, open the URL:

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

You can see examples of this at:

• Anyone wanting to list here as an example?

Note: Neither I nor MPDev claim ownership of this code except for the file vaispy.php - the rest of the files were using 'freely distributable' (although modified to suit vBISpy) sources. As such, you may use these files as you wish, but please do not remove the copyrights.


Changelog
2.0.4 - June 23, 2011
- Changed 'xml' to 'feed' when the script is requesting data via AJAX
- Updated code that checks for blocked groups and forums so that it works properly.
- Added version string (?v=) to script calls.
- Updated template html to include facebook data if enabled.
- Updated css link rendering to determine if templates are stored as files or not.

2.0.3 - March 25, 2010
- Updated alternate row colors to use stylevars.
- Added ability to block certain usergroups by editing vaispy.php.
- Fixed possible bug where in certain situations a database error would occur.

2.0.2 - January 23, 2010
- Hopefully the incorrect showthread link is now fixed.
- Added alternate row colors.
- Changed default xml delay in va_spy.js to 3000 from 7000.

2.0.1 - January 21, 2010
- Fixed issue with incorrect path to thread statusicon's
- Edits to clientscript/va_spy.js to hopefully fix issues with incorrect showthread link.
- Removed &nbsp;'s from the rows generated if displayed rows are less than 20

2.0.0 - January 21, 2010
- Ported to vBulletin4 with permission from MPDev



If you use this modification, please >> Mark As Installed, Nominate for MOTM, or Support Developer <<, thank you

[New Joe]

SecondV, hope you can sort out the go to last post thing, the one I spoke about before, as how it still is now when a poster is on ispy and clicks on the link it doesn't take tnem to the last post, it takes them to the first post on the Thread,

[SpottySocks]

Our members love this however there is one slight problem hope can help with. We have spoiler tags on our forum so info can be hid and they got to click a button to view the content... in iSpy the spoiler tags don't work so they can see what is in the spoiler tags, which kinda ruins things.

Can I stop this somehow?

[New Joe]

Originally Posted by New Joe

SecondV, hope you can sort out the go to last post thing, the one I spoke about before, as how it still is now when a poster is on ispy and clicks on the link it doesn't take tnem to the last post, it takes them to the first post on the Thread,

Really hope this one can get done.

[HRCHOSTING]

My members are really loving this one!!!! Thanks.

Is there any plans to make this a CMS widget?

They are always complaining on my site about the front page thread/post updates. We used to use vBportal which had a great recent forum activity update in it... now things aren't the same and they gripe lol.

[giorgino]

reserved

[RedHacker]

How can add in quick links last item...?

[Jabong82]

How is this different than when a user already has a "subscribed to" list?

[RedHacker]

Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT threadid
FROM vb_thread AS thread
WHERE thread.forumid NOT IN(0,273,162,158,41,42,91,92,93,254,252,253,94,95, 255,43,97,96,46,98,99,221,142,220,44,100,101,102,1 03,105,104,241,269,270,271,166,265,266,267,228,229 ,230,212,213,214,215,47,197,45,264,143,146,145,144 ,147,148,50,49,48,51,52,157,155,156,258,259,260,26 1,262,263,53,54,222,223,224,225,226,55,231,232,233 ,234,235,236,242,237,238,239,240,216,217,218,219,5 6,57,149,150,151,152,153,154,58,59,60,135,136,202, 203,204,205,206,207,208,209,210,133,134,211,138,)
AND thread.visible = 1
AND thread.open <> 10
AND thread.lastpostid > 0
AND thread.lastpost >= 1267346125;

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 thread.visible = 1
AND thread.open <> 10
AND thread.lastpostid > ' at line 3
Error Number : 1064
Request Date : Monday, March 1st 2010 @ 12:35:25 AM
Error Date : Monday, March 1st 2010 @ 12:35:25 AM
Script : http://www.xxx.xxx/vaispy.php
Referrer : http://www.xxx.xxx/forum.php
IP Address : xx.xxx.xxx.xx
Username : Administrator
Classname : vB_Database
MySQL Version : 5.0.81-community

[New Joe]

I hope the support for this mod will continue, as it's a great mod.

[pjdaley]

Is there a way to make it find the correct css to use. It seems to be using the wrong css. As it in no way goes with my current style (Darkness)