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

[Eric]

This is a port of vBISpy (https://vborg.vbsupport.ru/showthread.php?t=125947) by MPDev (https://vborg.vbsupport.ru/member.php?u=43030) 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 (https://vborg.vbsupport.ru/showthread.php?t=125947).


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?

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


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

/**
* 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 :)

[cbehan]

Looks very interesting...I'll test it out.

[akee]

Nice!
Thanks!
I try it now

-----edit--------

Installed, thanks

[Alien]

My members have been CRAVING to have this back.

I'll test it out and report back!

[Alien]

Apparently this is incompatible with Lynne's additional_css and additional_css2 templates made by her modification. I'd like to move to the built-in solution that vB has made but they broke it and don't call it from the usercp and other places which sucks.

I tried this with the default style though and it's killer, just needs a little style tweaking!

Thanks!

[SpongeBob71]

Works fine EXCEPT my "thread_dot.gif" is located in the correct path./

It assumes it is in the root of my website instead of the forum -->images path.

Just an FYI...

Great Job!

-Sponge

[TimberFloorAu]

We have installed. Very good.

Styling does need looking at tho :) Perhaps alternate backgrounds for each new post/thread and better definition for URL's

Excellent, thanks.

Ste

www.yobromofo.com/forum/vaispy.php

[TimberFloorAu]

Apparently this is incompatible with Lynne's additional_css and additional_css2 templates made by her modification. I'd like to move to the built-in solution that vB has made but they broke it and don't call it from the usercp and other places which sucks.

I tried this with the default style though and it's killer, just needs a little style tweaking!

Thanks!

We use Lynnes CSS , no issues. What problem do you have ??

[Eric]

Yeah, the styling needs a lot of work - it's the one thing about vB4 that will take me some getting used to :p

The main issue with styling, at least for the tables, I think is how vB has implemented the YUI reset CSS.

I'll try to get it worked out though :)

[Alien]

We use Lynnes CSS , no issues. What problem do you have ??

Do you save CSS as files, or save CSS in the database?

If you save the CSS as files, external scripts like this and Photopost are unable to locate your custom css. They only know how to look in the default vBulletin locations as far as I can tell?

[clmazin]

Works well for me, except for this:

When it pulls up the new threads, those threads are properly linked. Older threads listed on the page, however, get a strange "t=3459" type of syntax, which does not link properly.

Any thoughts?

Otherwise, very cool!

C.

[Eric]

Works fine EXCEPT my "thread_dot.gif" is located in the correct path./


It assumes it is in the root of my website instead of the forum -->images path.



Just an FYI...



Great Job!




-Sponge
I think I have a fix for that - looking into it now.

Works well for me, except for this:

When it pulls up the new threads, those threads are properly linked. Older threads listed on the page, however, get a strange "t=3459" type of syntax, which does not link properly.

Any thoughts?

Otherwise, very cool!

C.
Hmm, might be the javascript in clientscript/va_spy.js - will look into this as well.

[clmazin]

Thanks for the quick support, SecondV!

C.

[Eric]

I'll have to look into this as well.

Do you save CSS as files, or save CSS in the database?

If you save the CSS as files, external scripts like this and Photopost are unable to locate your custom css. They only know how to look in the default vBulletin locations as far as I can tell?

[Eric]

Updated to 2.0.1 to attempt to fix a couple issues:

2.0.1 - January 21, 2010
- Fixed issue with incorrect path to thread statusicon's -- this appears to show the vB3 type icons... may try doing the vB4 ones, but they are larger
- 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

[clmazin]

Downloaded the update. Still getting the "t=xxx" syntax on older threads instead of the proper "showthread" syntax.

Status icons working though...looks good...

C.

[SpongeBob71]

MUCH better.....thank you so much! :D



-Sponge

[Eric]

Very weird.

Did you use the vB3 version at one time, was it doing the same thing? I don't beleive I really made any changes (initially) to the code that generates the link.

By chance, do you have vBSEO installed? I'm wondering if that may be affecting it at all.

Downloaded the update. Still getting the "t=xxx" syntax on older threads instead of the proper "showthread" syntax.

Status icons working though...looks good...

C.

[clmazin]

This is my first install; never used it on 3.x.

vBSEO is not installed.

It appears the most recent five threads get the proper link, and the others get the t=xxxx version.

Attaching a snapshot of my installed products...

[DjEddie]

very nice mod .. will be installin soon .. just quick suggestion ...

could there be like a mini version of this made to go onto the CMS as a widget in some way?

Thanks :)

[sqzdog]

I second that! If this were a widget, I could definitely use it. Thank you!

[MPDev]

For the record, yes, I gave permission for this to be ported.

[SpongeBob71]

Oh wow....I def. second the widget idea if this is possible.

-Sponge

[Eric]

I do not have access to vB4 Suite (simply because I can't afford it), so it may prove difficult to build a widget for it, myself.

[Eric]

This is my first install; never used it on 3.x.

vBSEO is not installed.

It appears the most recent five threads get the proper link, and the others get the t=xxxx version.

Attaching a snapshot of my installed products...

I've not been able to reproduce this with my testing - however I will try to look into the code more to see if I can find any problems.

Just out of curiosity, what browser are you using - and have you had any users noticing the same problem? Also, would you mind linking me to your forum? (you can PM if you don't want to post it publicly)

[Eric]

For the record, yes, I gave permission for this to be ported.

:) Thanks for posting this!

[Alfa1]

Please include new group discussions into the feed. New blogs would also be awesome.

[New Joe]

I get this after installing and going to the vBISPY page:

vBulletin Message

You have been banned for the following reason:
No reason was specified.

Date the ban will be lifted: Never


Although I'm not banned when I go back to the Forum.

[patt1293]

Works well for me, except for this:

When it pulls up the new threads, those threads are properly linked. Older threads listed on the page, however, get a strange "t=3459" type of syntax, which does not link properly.

Any thoughts?

Otherwise, very cool!

C.

This is a quick a Dirty fix for your problem
Go into the vbispy.php and find

$post_url = 'showthread.php?' . ($etype == 'New Thread') ? "t=$thread[threadid]" : "p=$thread[lastpostid]#post$thread[lastpostid]";
Replace with this
$post_url = 'showthread.php?' . ($etype == 'New Thread') ? "showthread.php?t=$thread[threadid]" : "p=$thread[lastpostid]#post$thread[lastpostid]";

[clmazin]

Patt1293:

That did the trick! Thanks!

SecondV:

Firefox 3.5.7 on Snow Leopard.

C.

[New Joe]

Did anyone have the same problem as me?

[sematopdemir]

Thanks

[New Joe]

I get this after installing and going to the vBISPY page:



Although I'm not banned when I go back to the Forum.
This was a user group option permission problem, this is now ok.

The new problem I have is when the forum has been left standing for 5 mins or so and a new thread is started it doesn't up date on the ispy page.

[New Joe]

I remeber having the same problem with MPDev's version, but after doing this:Keep in mind, this kind of script can add to your server load if alot of users are using it; it polls the lookup script every 7 seconds to give it a real-time effect; you may need to adjust this to suit your own needs.

The last line of the file:
setTimeout("getXML()", 7000);
can be changed to allow for greater periods of delay between polling.
It worked fine, I changed 7000 to 1000

But i have looked in the va_spy_js file in this new version and the above is different:
setTimeout("getXML()", xmldelay);

Any help would be great.
Thanks.

[New Joe]

Another small bug is that when you click on the newly posted post, it will take you to the first post and first page of that Thread, instead of taking you right to the last post, the on you've just clicked on in iSpy.

[DjEddie]

I do not have access to vB4 Suite (simply because I can't afford it), so it may prove difficult to build a widget for it, myself.

If u would like access to mine, as the widget ideas seems like a good one .. then pm me for details and ill sort u an account out ... :)

[skariko]

Downloaded the update. Still getting the "t=xxx" syntax on older threads instead of the proper "showthread" syntax.

C.

Same here! :)

[clmazin]

Another small bug is that when you click on the newly posted post, it will take you to the first post and first page of that Thread, instead of taking you right to the last post, the on you've just clicked on in iSpy.

Yes. If you fix that one, this mod will be really useful!

C.

[Eric]

I'll try to have a new version out within the next day or two - possibly Monday, since it's the weekend. :)

[Highwayfrunkis]

:( I can't get this to show up

edit - I got the page to show up, but when I click on a link I'm getting:

"Oops! Something is wrong. Please try again. "

[mpadc]

Thanks can soemone tell me how to include it as a link in the navbar next to calendar

[patt1293]

Same here! :)
Fixed your problem here (https://vborg.vbsupport.ru/showpost.php?p=1963026&postcount=29)

Thanks can soemone tell me how to include it as a link in the navbar next to calendar
Find

<li><a href="calendar.php{vb:raw session.sessionurl_q}">{vb:rawphrase calendar}</a></li>

Add:
<li><a href="vaispy.php">iSpy</a></li>

[Eric]

If u would like access to mine, as the widget ideas seems like a good one .. then pm me for details and ill sort u an account out ... :)
We'll see - may do that when I know I'll have time to mess around with it :)

Another small bug is that when you click on the newly posted post, it will take you to the first post and first page of that Thread, instead of taking you right to the last post, the on you've just clicked on in iSpy.
This seems to be because of vB4's new "Friendly URL's" - I've not found a way to be able to generate them in Javascript.

I remeber having the same problem with MPDev's version, but after doing this:
It worked fine, I changed 7000 to 1000

But i have looked in the va_spy_js file in this new version and the above is different:


Any help would be great.
Thanks.
You can change that by modifying:

/* Delay between polls to the XML feed for new updates to page */
var xmldelay = 7000;

In /clientscript/va_spy.js - if using 2.0.2 - that line is now:

/* Delay between polls to the XML feed for new updates to page */
var xmldelay = 3000;

[Eric]

Updated to 2.0.2

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.

[clmazin]

Great work, SecondV. The showthread links do work correctly now, and clicking on the thread in the feed takes you to the last post.

Thanks!

C.

[TimberFloorAu]

That Looks Great now Eric.

Thanks ( upgraded )

[Eric]

Great work, SecondV. The showthread links do work correctly now, and clicking on the thread in the feed takes you to the last post.

Thanks!

C.

That Looks Great now Eric.

Thanks ( upgraded )

Awesomesauce! Glad it works now :)

[Sushubh]

thank you thank you thank you so much. :) i have been waiting for this since the day i moved to vb4...

[SpankMe]

Updated to 2.0.2

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.

New colors don't work well on dark colored styles. :( It needs to use css from styles so we can adjust for style color.

[ahmedbehiry]

it's working, but I don't know what it doesn't update.. I mean the links in the page stay the same and they don't show new posts and threads in the forum!

[ahmedbehiry]

it's working, but I don't know what it doesn't update.. I mean the links in the page stay the same and they don't show new posts and threads in the forum!

[cagbaazee]

Thanks , I hv install it without any problem. Keep it up.

[ManagerJosh]

Up and running in http://uoem.com/forums/vaispy.php

[jonty]

Please include new group discussions into the feed. New blogs would also be awesome.

:up:

Social Group discussion are our most commonly asked-for feature. (permissions dependant)
PMs (obviously just your own!)
Blogs and CMS entries would also be handy.

[madotds]

New colors don't work well on dark colored styles. :( It needs to use css from styles so we can adjust for style color.

I also have this problem as you can see HERE (http://www.called2duty.com/vaispy.php?styleid=2) is there any way to change the colours?

Mark

[Eric]

I also have this problem as you can see HERE (http://www.called2duty.com/vaispy.php?styleid=2) is there any way to change the colours?

Mark

New colors don't work well on dark colored styles. :( It needs to use css from styles so we can adjust for style color.

Ahh, that totally slipped my mind. You can edit this in vaispy.php, find:

#spy_table td .alt1 & #spy_table td .alt2

And you can change it there.

[ahmedbehiry]

and what should I do with the page not being updates as it should?

[madotds]

Ahh, that totally slipped my mind. You can edit this in vaispy.php, find:

#spy_table td .alt1 & #spy_table td .alt2

And you can change it there.

Ok thanks for that I have used rgb 000.102.153 and rgb 000.153.153 and this shows up well on both my light and dark skin. :)

[Eric]

and what should I do with the page not being updates as it should?

What is the URL to your installation?

[ahmedbehiry]

<a href="http://haridy.com/ib/vaispy.php" target="_blank">http://haridy.com/ib/vaispy.php</a>
sorry, it's in Arabic.. but you can see that the posts are not changing..

[Eric]

http://haridy.com/ib/vaispy.php
sorry, it's in Arabic.. but you can see that the posts are not changing..

You're using jQuery - jQuery and Prototype(what this mod uses) do not play nice with each other.

[ahmedbehiry]

:S is there a way to disable jquery inthis page with vb conditionals?

[New Joe]

This seems to be because of vB4's new "Friendly URL's" - I've not found a way to be able to generate them in Javascript.

So do you think it can be done?

[compuminus]

Updated to 2.0.2

2.0.2 - January 23, 2010
- Added alternate row colors.

Ideally the alternate row colors would be drawn from the stylevars, as opposed to being hard-coded into the php. I have a light and dark style for my forums, so as it stands now, vBISpy won't look right with one of them. Perhaps alt1 could correspond to threadbit_background and alt2 could be threadbit_alt_background ? Thanks for porting this to vB4!

[compuminus]

Also, perhaps you would want to use the new thread status icons for vB4...? You'd mentioned that these were too large to fit in the line of vBISpy test, so they weren't used -- but how about using the 16x16px versions? This would just change the vaispy.php code from:

$thread['statusicon'] = vB_Template_Runtime::fetchStylevar('imgdir_statusi con') . '/thread' . $thread['statusicon'] . '.gif';

to:

$thread['statusicon'] = vB_Template_Runtime::fetchStylevar('imgdir_statusi con') . '/thread' . $thread['statusicon'] . '-16.png';

[ahmedbehiry]

I've disabled jquery in the page using vb conditional <vb:if condition="THIS_SCRIPT != 'vaispy'">
and I'm checking it right now

[ahmedbehiry]

still not working even though jquery is disabled.

[phil801]

I'm so glad you fixed this mod for 4.0! I was in the process of paying to have it customized.

Installed fast and easy and WORKS!

Viewable here: http://www.ldspreppers.com/recentposts.php

[Eric]

Ideally the alternate row colors would be drawn from the stylevars, as opposed to being hard-coded into the php. I have a light and dark style for my forums, so as it stands now, vBISpy won't look right with one of them. Perhaps alt1 could correspond to threadbit_background and alt could be threadbit_alt_background ? Thanks for porting this to vB4!
Yeah, it just slipped my mind when I added that in. The threadbit backgrounds probably would be best for it.

Also, perhaps you would want to use the new thread status icons for vB4...? You'd mentioned that these were too large to fit in the line of vBISpy test, so they weren't used -- but how about using the 16x16px versions? This would just change the vaispy.php code from:

$thread['statusicon'] = vB_Template_Runtime::fetchStylevar('imgdir_statusi con') . '/thread' . $thread['statusicon'] . '.gif';

to:

$thread['statusicon'] = vB_Template_Runtime::fetchStylevar('imgdir_statusi con') . '/thread' . $thread['statusicon'] . '-16.png';
Ahh, thanks for that - will implement that in the next release :)

I've disabled jquery in the page using vb conditional <vb:if condition="THIS_SCRIPT != 'vaispy'">
and I'm checking it right now
Sorry, not sure what else to tell you. It could be an RTL issue, I'm not sure.
So do you think it can be done?
Still looking into the friendly URL situation...

[compuminus]

Ahh, thanks for that - will implement that in the next release :)


Great. It's not a perfect icons coding though, since it does not always correctly use the thread_dot_16-right.png or thread-16-right.png as opposed to thread_dot_16.png or thread-16.png, respectively (when appropriate), but it's pretty close.

Look forward to the new release! Thanks!

[Alien]

Ideally the alternate row colors would be drawn from the stylevars, as opposed to being hard-coded into the php. I have a light and dark style for my forums, so as it stands now, vBISpy won't look right with one of them. Perhaps alt1 could correspond to threadbit_background and alt2 could be threadbit_alt_background ? Thanks for porting this to vB4!

I have this same issue, please consider this it's very important for those with light and dark styles both!

[compuminus]

I just noticed another issue that I'm surprised I hadn't spotted before:

All of the lower menu items disappear on the vaispy.php page (New Posts, Private Messages, FAQ, Community, etc.). Only the very top level items appear (Forum, What's New, etc.)

Should be a reasonably simple fix...

[SpankMe]

Great. It's not a perfect icons coding though, since it does not always correctly use the thread_dot_16-right.png or thread-16-right.png as opposed to thread_dot_16.png or thread-16.png, respectively (when appropriate), but it's pretty close.

Look forward to the new release! Thanks!

For now just..

cp statusicon/thread_dot-16.png BP-Brown/statusicon/thread_dot_hot-16.png
cp statusicon/thread_dot-16.png BP-Brown/statusicon/thread_dot-16.png
cp BP-Brown/statusicon/forum_old-16.png BP-Brown/statusicon/thread-16.png

it fits well. And it's green. :)

[New Joe]

Any chance of getting this made: https://vborg.vbsupport.ru/showthread.php?t=126421
vBISpy module - live AJAX feed of new threads - for vBAdvanced CMPS

[dosadno]

Sorry if this has been asked, but how can i set it to be viewable by only certain usergroups?
I would like that only admins and moderators can use this mod...

BTW great mod

[Sushubh]

i guess do not reveal the URL of the vaispy page!

that's what i do. only a limited number of people know about the vaispy page on my forum.

[dosadno]

There must be a beter way, besides, tab with the url is alredy publised

[shofolofo]

yes I need this aswell .. anyway to define the user group ids ?

[chris1979]

Are there some customisation instructions somewhere? I cannot remember from the 3.8 version... how do we select which forums to include, and how can we set how often to check for updates?

[Eric]

yes I need this aswell .. anyway to define the user group ids ?
This will be in the next update. In the meantime, if you want to block certain usergroups from viewing vaispy...

Edit vaispy.php and find:

// ################################################## #####################
// ######################## START MAIN SCRIPT ############################
// ################################################## #####################


and after that, add (only an example)

if (is_member_of($vbulletin->userinfo, 8))
{
print_no_permission();
}

Where '8' would be the usergroup id. You can also do multiple usergroups. Let's say you had 8, 9, 10 that you wanted to block:

if (is_member_of($vbulletin->userinfo, 8, 9, 10))
{
print_no_permission();
}

Are there some customisation instructions somewhere? I cannot remember from the 3.8 version... how do we select which forums to include, and how can we set how often to check for updates?
Since this is based on the original vBISpy, I've not really changed the mod much. It doesn't make use of the product system/templates/phrases/etc, so it has to be done manually. You can not currently choose which forums to include, you can only choose to exclude forums:

Around line 44 in vaispy.php

/**
* Do not list these forums even if they have
* permissions (test categories, etc)
*/
$blockforums = '';


As far as the time between updates, that's controlled by the javascript, in the clientscript/va_spy.js file. In that file, around line 38 you'll see:

/* Delay between polls to the XML feed for new updates to page */
var xmldelay = 3000;


This value is seconds x 1000

So, let's say you wanted it to be 6 seconds, you'd change it to:

/* Delay between polls to the XML feed for new updates to page */
var xmldelay = 6000;

[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. :p

Can I stop this somehow?

[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)

[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]

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]

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.

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.

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]

Will look into this.

Thanks i will wait SecondV

[Viper007Bond]

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

Thanks! :)

[Juggernaut]

I like it :D

[New Joe]

I don't think my question is going to be answered.

[New Joe]

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

Thanks! :)
Regarding my last post to the question I need answering, I found the above post and link.
This site works fine, when I clicked on the last post of a Thread with over 6,717 replies it took me to the last reply.
Viper, did you do anything more or just up loaded the files and it worked that way?

[Viper007Bond]

Regarding my last post to the question I need answering, I found the above post and link.
This site works fine, when I clicked on the last post of a Thread with over 6,717 replies it took me to the last reply.
Viper, did you do anything more or just up loaded the files and it worked that way?

I just uploaded all the files -- it worked out of the box.

[Eric]

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...
Actually, this isn't even an issue. It's meant to be that way... the way the navbar in vB4 works now, is that each tab can have sublinks - vBISpy doesn't really need any sublinks..

[Eric]

Updated to 2.0.3

[RedHacker]

Thanks for update but i create new thread/post nothing show in vaispy.php

[daveaite]

Hey mate. I have a suggestion :)

Turn this into a widget formed mod. That way we can install it on the CMS as well. This would probably involve configuring directory paths and copying the vbispy into the PHP Widget.

If you need help I could try testing and playing around with it. Let me know via pm.

P.S: Nice network of sites.


Edit:
On xml install I get this error:
XML Error: not well-formed (invalid token) at Line 340

[Eric]

Hey mate. I have a suggestion :)

Turn this into a widget formed mod. That way we can install it on the CMS as well. This would probably involve configuring directory paths and copying the vbispy into the PHP Widget.

If you need help I could try testing and playing around with it. Let me know via pm.

P.S: Nice network of sites.


Edit:
On xml install I get this error:
This mod has no product xml, you just upload files and make template edits to include a link to vaispy.php

Thanks for update but i create new thread/post nothing show in vaispy.php
What's the URL to your forum?

[RedHacker]

This mod has no product xml, you just upload files and make template edits to include a link to vaispy.php


What's the URL to your forum?

It is fixed now... Must be renamed one file....

[xsamet]

thank you installl...

[TurkYasam]

Is there any chance that we can have small avatar on "by" column?..
After we have avatar,I guess I can make it look like yahoo answers homepage with some basic html coding (recent-populer section)

regards

[vivamexico55]

Installed, tagged, nominated.

Any possibility of making this a WIDGET for the front page? (CMS)

It would be excellent.

In any case, thanks for this!

[carubmun]

I have hundreds of forums... and i would like this to only pull info from 15 or so forums.
Would i then need to put in the forum number of all of the hundreds of forums i dont want it to pull posts from?
Cuz that would not be fun.
Specially since i plan on using this on a number of different pages, broken down by forum section.

[hotslot]

Keeping this thread alive.. Is everything up to par on it now?

[carubmun]

How can i run this code inside a template and not in its own page.
Like i want to be able to run it inside a forum or section... even if that means using the notices system.
When i put the code in there it doesnt work though.

[New Joe]

How can i run this code inside a template and not in its own page.
Like i want to be able to run it inside a forum or section... even if that means using the notices system.
When i put the code in there it doesnt work though.
Best thing to do is set up a Forum in the Admin CP and when creating the Forum, just add a URL re-direct so when a user clicks on the Forum it will go to the URL of iSpy.
Easy mate.:D

[Katoona]

I am just curious - does this script/iSpy require much server-load?

[Fuhrmann]

Doest not work here too. All looks fine, but no thread, post appears. Anyone know what could be?

[sticky]

I can't believe it took me so long to find this! Wow, what an awesome mod.

My only question is, how do I get it to look like a grid setup which divides the updates cleanly like here: http://www.bikeforums.net/vaispy.php

[Daniel_HBK]

Great hack !! NOTM & 5 Stars & Installed , but how i can exclude forums ,please ?

Edit

found this post
https://vborg.vbsupport.ru/showpost.php?p=1981286&postcount=80
God bless you :)

[SoltanWorld]

i have set the usergroup which should not see the vaispy but doesn work!

[cbehan]

I love this mod. Really a great product.

I was wondering if we can have any control over the layout or styling of the feed. That would be great.

Oh, and you're welcome to use my forum as an example (although I'll probably be blocking it to all but paid subscribers in the near future):

http://tippingpitchers.com/vaispy.php

[Boofo]

How does this compare to Digital Point Spy?

https://vborg.vbsupport.ru/showthread.php?t=243429

[sticky]

This stopped working correctly and is now slow with the updates, any reason why?

[fdurmaz]

This hacks run 3.8 version for vb ?

[Eric]

I don't think I'm going to develop this any further. I'd recommend taking a look at digitalpoint's:

https://vborg.vbsupport.ru/showthread.php?t=243429

[ah-webhosting]

doesn't look right with opera 10.6 and vb 4.0.5

[lubbie]

Works great but uninstalled.

[tafreeh]

Great Mod

Question: How do you make a link to open in new tab or window ?

[intruder]

Great, Keep up the dev!

[wEbAddEr]

I don't think I'm going to develop this any further. I'd recommend taking a look at digitalpoint's:

https://vborg.vbsupport.ru/showthread.php?t=243429

lol, i switched from his to yours :)
Thanks for this great mod

[Sushubh]

i have been playing around with both. for some reason i like the vbispy's formatting.

[tafreeh]

Is there anyway, I can show this on Forumhome ???
like showing Latest 3 or 5 post on forumhome

[New Joe]

i have set the usergroup which should not see the vaispy but doesn work!

Same problem here, anyone has a fix for this?

[pmcnamara]

Is there a way to insert ads into the Ajax - Forum Spy.. I have a high number of users who sit on Forum Spy and I'd like to insert ads into the scroll.

[mavherzog]

I've used the former version of this for quite a while. Had to make several modifications to it...but now it appears that the Digital Point Spy has pretty much everything I need.

If the author/porter has truly abandoned this, it makes sense for everyone to throw their support behind the Digital point version.

[jefferis]

I like this. We just added it to our site. http://www.igotasti.com/vBforum/vaispy.php
We found 1 minor problem. I changed the status icon to png instead of gif, since png is now the standard and had to change thread_hot-16.gif to thread_hot.png.

The FEATURE we would like is to be able to restrict some forum feeds to be visible only to moderators, e.g. but all other forums visible to everyone. The restrictions here are global, so maybe that isn't possible. But you can put our FEED in your examples above if you like.

Also, you have to block subforums separately from forums by ID number. I also notice some raw code appearing in the links.<u>Member's Garage</u>

[jefferis]

THe first 5 live feed posts (newest) are underlined, but the scroll produces the raw code: showing <u>forum Name</u> instead.

[tomerl1]

Hello,

Since 4.1.2. Hack does not work. No Page refresh.
Is this a known error?

Sorry my english (I`m Austrian)

[d19rnyxx]

Hello,

Since 4.1.2. Hack does not work. No Page refresh.
Is this a known error?

Sorry my english (I`m Austrian)

Im having the same issue.
Is there anyway of uninstalling this hack

[Mikevet1984]

Just remove the uploaded in your server files and you are done!

[ZeroHour]

Same problem here, anyone has a fix for this?

Put this under "blockforums = '';"

if ($vbulletin->userinfo[usergroupid] == 1)
{
print_no_permission();
}
This blocks unregistered.

[sportsfroma2]

I see two reports of it not working in 4.1.2..

Anyone have it working in 4.1.2 or 4.1.3? others having issues?

just wondering about the status of the before I decide to upgrade from 4.0.7 to 4.1.3

thanks

[ZeroHour]

I see two reports of it not working in 4.1.2..

Anyone have it working in 4.1.2 or 4.1.3? others having issues?

just wondering about the status of the before I decide to upgrade from 4.0.7 to 4.1.3

thanks

Running 4.1.3 and all is good :)
Its code actually doesnt affect vbulletin and unless vb change the structure of the DB it will probably work fine in 4.1.4 etc (4.2 tree *could* be diff but probably not)

[sportsfroma2]

Running 4.1.3 and all is good :)
Its code actually doesnt affect vbulletin and unless vb change the structure of the DB it will probably work fine in 4.1.4 etc (4.2 tree *could* be diff but probably not)

that's good to hear.. I've been using this for years and haven't had any incompatibilities so was surprised to read that this stopped working for some at 4.1.2, so it's good to hear you have it working on 4.1.3.

Occasionally on my site I do have an issue where the spy gets "stuck" and certain posts don't show, but I haven't really found a pattern so figured there's now use reporting it..

For future reference, is there a cache or something that needs to be cleared/reset to get it spying again? seems to happen randomly though

no biggie, just curious

[ZeroHour]

that's good to hear.. I've been using this for years and haven't had any incompatibilities so was surprised to read that this stopped working for some at 4.1.2, so it's good to hear you have it working on 4.1.3.

Occasionally on my site I do have an issue where the spy gets "stuck" and certain posts don't show, but I haven't really found a pattern so figured there's now use reporting it..

For future reference, is there a cache or something that needs to be cleared/reset to get it spying again? seems to happen randomly though

no biggie, just curious

Hmm there is no cache as far as I can see but I suspect that when the xml feed that contains the actual stream of posts fails, the script does not resume. I presume a refresh of the page fixes the issue.
Its also possible some content in the post preview etc has error'ed the script which would stop it updating and there is always the other possibility if your a larger board of the mysql taking a bit too long to respond with the data but you need to have either a weak vps or large amounts of load.
I personally added a html meta refresh tag to our page to prevent these types of issues for those with our iSpy on a different monitor which may be a plan. The refresh we use is either 20 or 40 mins (I need to check)

[skariko]

Hi there,
anyone know this bug?

It solves itself when someone create a new thread. It shows this gray line and don't make auto-refresh. (and don't shows all the latest messages).

Thanks,
Andrea

[tomerl1]

Not working by 4.1.3

[Alan_SP]

works for me on 4.1.2 (just installed, some testing is needed). Is there a way to use new png grafics for threads instead old gifs from vB3.8?

[Michael Sievers]

Is there anyway to edit vaispy to not show threads where a specific usergroup was the last to respond?

I run a support forum and want an easy way to monitor the "queue" of posts that need to be responded to, and the easiest way I can think of would be to have vaispy not show threads where my staff was the last to respond.

[phinphan]

I am having the same problem. Sometimes certain posts just do not show up but I cannot discern a pattern to when or why they don't show up.

[tomerl1]

Now it works beautifully. By 4.1.4

[bikoy888]

it seems it doesn't worked for me
using v4.1.3

[Eric]

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.

Should work with all 4.x versions (tested all the way back to 4.0.8 and tested on the most recent 4.1.5 alpha as well).

[Alan_SP]

For upgrading, we also need to upload va_spy.js as it's changed (didn't test what is change, but I see different time stamp and size).

[Mr.Script]

how i unistall this mod?

[New Joe]

how i unistall this mod?
Delete what you up loaded into your forum folder in your c panel

[Mr.Script]

Delete what you up loaded into your forum folder in your c panel
I tried, it does not work, I have code in templates..
And it's not I installed this mod..

[Alan_SP]

Look at installation instructions (download again if need be), then reverse it.

For template modifications, find code that's from this mode, or just revert it (if you don't have other modifications in it).

[MikeF]

How does this differ from the mod by DigitalPoint? (vBSpy). Can this work for a side module in vbAdvanced?

[8thos]

Gonna try this out tonight.

[MySaltyreef]

i like this hack, is there any way one could make it work in a widget ?

[8thos]

i like this hack, is there any way one could make it work in a widget ?DBShout is like this but works in a widget.

[jooohn1]

Installed and its working fine with 4.1.4. Can anyone tell me how do i change the below marked title to some other text ?

https://vborg.vbsupport.ru/external/2011/07/40.jpg

[hacksden]

I have problems with this mod. Sometimes it freezes when loading threads and other times it works perfectly fine. This isn't just a problem on my end as all the moderators (10 of us) experience the same exact issue time and time again. Is there a fix for this?

[FiRe_MaStER]

perfect mod installed and little edited thank you

I wanna ask something how can I change the forum name to category name

right place there are forum names but I wanna change them to category names is it possible?

[mjfan227]

I've moved all the files where there supposed to be, but where is it? It doesn't show up on my site. I'm using 4.1.5

[jefferis]

<a href="http://igotaevo.com/vBforum/images/Future/statusicon/thread.gif" target="_blank">http://igotaevo.com/vBforum/images/F...con/thread.gif</a>

All the images in status icon are png files and not gif files...

[Fready]

http://igotaevo.com/vBforum/images/Future/statusicon/thread.gif

All the images in status icon are png files and not gif files...

This is true, I had to change all the file names, but it didn't take that long to do
Well worth it as this mod works right out of the box and never stops working unlike another mod which is similar

[rab3rd]

Hello, new to the board and new to vBulletin.

I have the most recent version of vBulletin and when I install this mod it works except I get the red X where the statusicons should be. I have comment out the event and the code that calls the img. It only gets rid of the red x's on the last 15 post (it appears). I wold like to do away with all the statusicons

Ideas?

Rob

[rab3rd]

or even making them work would be better than red x's. I tried renaming all the "thread_dot_* files too .gif's from .png's but still no images...

[cgway.net]

Any chance of getting this made: https://vborg.vbsupport.ru/showthread.php?t=126421
vBISpy module - live AJAX feed of new threads - for vBAdvanced CMPS

i wait the same replay for this request

[cgway.net]

please replay me

Any chance of getting this made: https://vborg.vbsupport.ru/showthread.php?t=126421
vBISpy module - live AJAX feed of new threads - for vBAdvanced CMPS

[vAsia]

Is there a way to place vBiSpy in FORUMHOME?

[Alan_SP]

What you mean with this question?

You can add link to it to any template, forumhome included. Or if you want it inside template, use iframe html code. I think that this should work.

But, you have others mods that could do similar things. Depends what you really want.

[cgway.net]

please replay me

Any chance of getting this made: https://vborg.vbsupport.ru/showthread.php?t=126421
vBISpy module - live AJAX feed of new threads - for vBAdvanced CMPS

why no any replay

[leejohn02]

is there a way to put this under an advert or someone where under the navbar instead of as a seperate page??

[davech]

This is a brilliant mod that's been working really well on our forum. Recently, however, there have been periods where iSpy doesn't work so well - sometimes it freezes or only shows old posts. Does anyone have any idea why this happens?

[stl7997]

When I try to upload the product I get:

XML Error: Not well-formed (invalid token) at Line 332

Any ideas?

[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

[kalilo81]

can we display this in a block?

[Cusski]

Hi. I am trying to get MGC chatbox evo pro version to load on this page, can somebody help please

http://www.sattvhelp.com/forum/liveposts.php

[RedHacker]

Solve the solution for install vBISpy