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

[Shabow]

Is there a way to show unread posts? It shows all posts, even ones made by the user.

[RedHacker]

SecondV why i have Database Error.....?

[cddw.ltd]

Just a quick note that if anyone changed the .php filename to something else, remember to update the name in the va_spy.js file

[RedHacker]

No i haven't change anything....

[Jabong82]

Hello is there any way to put this on the "subscription.php" page? How would you move it to another page?

I already have it on my FORUMHOME and FORUMDISPLAY pages, but I'd like to move it to where the members view their subscribed threads as well. Thank you.

Oh nominated and installed! Thank you again.

[compuminus]

The only remaining issue with the conversion to vB4 is the fact that the navbar menu only shows the navtabs, not all of the links in the row below. This is the row that starts with new/today's posts, private messages, FAQ, etc links. I've gone through the vaispy.php code and cannot figure out how to mod this myself so that this menu bar shows up correctly...

[Javi_gray]

Originally Posted by Jabong82

Hello is there any way to put this on the "subscription.php" page? How would you move it to another page?

I already have it on my FORUMHOME and FORUMDISPLAY pages, but I'd like to move it to where the members view their subscribed threads as well. Thank you.

Oh nominated and installed! Thank you again.

How did you get it to show up on forumhome?

[Eric]

Originally Posted by 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

Will look into this.

Originally Posted by 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)

Link to your forum? I thought I had this problem resolved.

Originally Posted by compuminus

The only remaining issue with the conversion to vB4 is the fact that the navbar menu only shows the navtabs, not all of the links in the row below. This is the row that starts with new/today's posts, private messages, FAQ, etc links. I've gone through the vaispy.php code and cannot figure out how to mod this myself so that this menu bar shows up correctly...

Will look into this as well.



As far as folks looking to add this on other pages... I'll see if I can figure out something, when I get the time.

[RedHacker]

Originally Posted by SecondV

Will look into this.

Thanks i will wait SecondV

[Viper007Bond]

Working great here: http://forums.finalgear.com/vaispy.php

Thanks!