The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
|||||||
vBISpy - AJAX real-time feed of new posts/threads Details »»
|
|||||||||||||||||||||||||||
|
vBISpy - AJAX real-time feed of new posts/threads
Developer Last Online: Dec 2016 
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. Supporters / CoAuthors Show Your Support
|
|||||||||||||||||||||||||||
About Developer
Visit Web Site
Additional Files 
No support by the author.| Comments |
|
#152
09-08-2006, 11:50 PM
|
|||
|
|||
This is a really awesome hack and I'd love to see it developed further. (like a module for vbadvanced hehehehe)
Is there anything that can be done for the whos online page? When its viewed and people are on that page they are reported like this: Unknown Location /forum/vaispy.php?do=xml&last=993718&r=0.4711818012095664 3&_= 
|
|
#153
09-09-2006, 12:04 AM
|
|||
|
|||
|
EDIT:
To change the amount of posts to show: Find and change the 50 to the amount you require [phpORDER BY lastpost DESC LIMIT 50");[/php] Find and change the 50 to the amount you require PHP Code:
[php] PHP Code:
PHP Code:
|
|
#154
09-09-2006, 09:21 AM
|
|||
|
|||
|
All the credit goes to TECK ( Floren )
In order to optimize the code Replace Code:
$getthreads = $db->query_read("
SELECT thread.*, post.pagetext AS preview, post.userid AS lastpuserid
FROM ".TABLE_PREFIX."thread AS thread
LEFT JOIN ".TABLE_PREFIX."deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN ".TABLE_PREFIX."post AS post ON(post.postid = thread.lastpostid)
WHERE open <> 10 AND thread.lastpostid > $lastpostid
AND forumid NOT IN (0$blockforums)
AND thread.visible = '1'
AND deletionlog.primaryid IS NULL
ORDER BY lastpost DESC LIMIT 10");
Code:
// The number of days to scan the table for ...
// 86400 represents the number of seconds in 24hrs
$daysprune = 1;
$datecut = "AND thread.lastpost >= " . (TIMENOW - ($daysprune * 86400));
$getthreads = $db->query_read("
SELECT thread.*, post.pagetext AS preview, post.userid AS lastpuserid
FROM " . TABLE_PREFIX . "thread AS thread
LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN " . TABLE_PREFIX . "post AS post ON (post.postid = thread.lastpostid)
WHERE open <> 10 AND thread.lastpostid > $lastpostid
AND forumid NOT IN (0$blockforums)
AND thread.visible = '1'
AND deletionlog.primaryid IS NULL
$datecut
ORDER BY thread.lastpost DESC LIMIT 10
");
|
|
#156
09-09-2006, 09:32 PM
|
|||
|
|||
|
Problem here.
The query is going correctly, it has valid information in it: http://yourconvo.com/forums/vaispy.php?do=xml However, The actual page is not filling up with data. http://www.yourconvo.com/forums/vaispy.php
|
|
#157
09-09-2006, 09:34 PM
|
|||
|
|||
|
Quote:
It seems to be working for me...
|
|
#158
09-09-2006, 09:35 PM
|
|||
|
|||
|
yeah me too
|
|
#160
09-10-2006, 02:57 AM
|
||||
|
||||
|
I made an update with some minor changes to the JavaScript to remove the split strings.
I'm not sure what to do about Opera; I just dont use it to know enough what might need to be done. I wonder if it works like IE and we need: Code:
if (is_ie || is_opera)
|
|
#161
09-10-2006, 03:39 AM
|
||||
|
||||
|
Quote:
|
 |
«
Previous Thread
|
Next Thread
»
|
|
All times are GMT. The time now is 05:33 AM.