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

[Sarteck]

I just changed my forum's domain name, and also put forums, blogs, and cms all on separate subforums.

The whole shebang used to be at www.xxx.org/forums.

Forums are now at forums.yyy.com,
Blogs are now at blogs.yyy.com,
CMS is now at www.yyy.com


My iSpy stopped updating itself, for some reason I don't really understand.

When I go to the feed at vaispy.php?do=feed, I do see the new content. However, it just does not seem to be updating.

I am not getting any JavaScript errors.



Anyone got a clue if it has something to do with now having the forums on a subdomain? I wouldn't think that it would be an issue, but I just can't find what the error would be.

[Sarteck]

Well, I'm not exactly sure what fixed it, but apparently I was going about it the wrong way when doing my sub-domain stuff.

I actually had all my subdomains (www, blogs, and forums) all pointing at the same directory. I figured this would be fine, and it actually was for most things. I did NOT have the I-guess-they're-called "stub" directories from the do_not_upload folder uploaded.

I changed this and uplaoded the stub directories for forums and blogs, but this did not seem to fix it.

I then re-uploaded the mod from here, in case I had an older version. Still no dice.

I then added the subdomains to my "Domain Whitelist." Still nothing.

Afterwards, I realized that some of my modifications to the iSpy stuff were missing (I've altered this mod a bit so that it also displays new Blogs and Blog comments), and after fixing that, it worked.



So I'm guessing that I had to add the subdomains to my "Domain Whitelist," though I'm not entirely sure. If anyone encounters the same problem, try that, see if it works for you.

[xBhp]

Hi, I just installed the latest version of vbispy on vbulletin 4.2 and it is giving me the AJAX error "Refused to get unsafe header "X-JSON". Any idea what is the cause?

Attached is the screenshot

[jluerken]

Is there a way to display the thread prefixes before the thread titles too?

[Lexserv]

Does this mod work on version 4.2 without issues? Can anyone confirm?

[kalilo81]

any chance to show this in forum home under navbar?

[Baghira]

When calling mydomain.de/vaispy.php, I get:

Invalid SQL:

SELECT threadid
FROM thread AS thread
WHERE thread.forumid NOT IN(0,)
AND thread.visible = 1
AND thread.open <> 10
AND thread.lastpostid > 0
AND thread.lastpost >= 1361797081;

MySQL-Fehler : 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
Fehler-Nr. : 1064
Fehler-Zeit : Tuesday, 26.02.2013 @ 13:58:01
Datum : Tuesday, 26.02.2013 @ 13:58:01
Skript : http://mydomain.de/vaispy.php
Referrer :
IP-Adresse : An IP Address
Benutzername : MyUsername
Klassenname : vB_Database
MySQL-Version : 5.1.63-0+squeeze1

[addamroy]

First it was working fine. As I refresh the page a few more times, less threads show up than before. First time it showed all the newest posts, next time it only showed a few of the newest posts, next time fewer, etc. Like every few times you refresh a couple of the newest posts don't show up anymore.

I see many others have the exact same issue in this thread.

I installed and uninstalled, it needs work.

I'm using 4.1.12 if that helps. I'll tag this in case the OP makes a fix for this.

[gazza2008]

Hello

I jeep getting a DB error with this MOD

I have coplied the DB error below

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT threadid
FROM thread AS thread
WHERE thread.forumid NOT IN(0,)
AND thread.visible = 1
AND thread.open <> 10
AND thread.lastpostid > 0
AND thread.lastpost >= 1369128307;

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 > 0
' at line 3
Error Number : 1064
Request Date : Wednesday, May 22nd 2013 @ 09:25:07 AM
Error Date : Wednesday, May 22nd 2013 @ 09:25:08 AM
Script : http://www.uk-bettinginfo.co.uk/vaispy.php
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.1.69-cll

[gazza2008]

any updates on this please.......it seems it works if you are a guest but when you log in it gives me a database error