PDA

View Full Version : vBISpy - AJAX real-time feed of new posts/threads (for vB3.5)


MPDev
09-06-2006, 10:00 PM
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 (http://blablist.crowdiq.com/iqueue/votespy_howto.jsp) 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 (https://vborg.vbsupport.ru/showthread.php?t=113435&highlight=spy) 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 version is for vBulletin 3.5 users only, for vBulletin 3.6 you will need to download the 3.6 version located here (https://vborg.vbsupport.ru/showthread.php?t=125947).

JOIN THE vBIspy Network!
Once you have this mod installed, you can join the vBIspy network (http://www.vbispy.com) 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.2
Added buro9's code from here (https://vborg.vbsupport.ru/showpost.php?p=1070584&postcount=130)

1.0.3 - 9.9.06
Modified some JavaScript in va_spy.js to remove split strings

1.0.4 - 9.10.06
Added date cuffoff code from here (https://vborg.vbsupport.ru/showpost.php?p=1071270&postcount=153) and changed init() to spyinit() - changed vaispy.php and va_spy.js files.

1.0.5 - 9.11.06
I've changed the query to grab the preview text from the last message; the downside to this change is that people with very large "post" tables will want to add an index to their table to significantly improve the performance on this script.

ALTER TABLE `vb_post` ADD INDEX ( `dateline` )

1.0.6 - 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.7 - 9.13.06
vaispy.php - changed code for checking for forum permissions to include password protected forums, added javascript tag for script code
va_spy.js - changed link to use goto=lastpost to fix links

1.0.8 - 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 (https://vborg.vbsupport.ru/showpost.php?p=1076094&postcount=226), except not using templates yet), changed way threads are parsed (removes html as well)

1.0.9 - 9.17.06
va_prototype.js - removed 20kb of unused code

MPDev
09-07-2006, 12:43 PM
Reserved.

kompakt
09-07-2006, 01:55 PM
thanks for the 3.5 version of the mod; works great...

edit.. both 3.6 and 3.5 versions do not work on opera browsers (everything is displayed inline under the event column) any idea how to fix it?

The Chief
09-07-2006, 02:21 PM
Amazing, will install on myetalk.com probably sometime this weekend, good job!! :)

Strike3ForumsMH
09-07-2006, 03:15 PM
Huzzah. I was very upset to see that this wasn't functional with 3.5x, so much thanks for getting a version ready for everyong else so fast MP.

Great mod.

MPDev
09-07-2006, 04:07 PM
Made a small update to vbispy.php and vb_spy.js to provide same XML data as the 3.6 version; you should update those two files if you downloaded before now.

Gizmo5h1t3
09-07-2006, 04:54 PM
just curious....could it be done so you have the little right facing arrow that takes you to the last post in that thread on the page somewhere??

saves clicking the post shown in the vaispy.php page, and having to trawl thru all the posts to get to the end of the thread??

Holidazed
09-07-2006, 05:00 PM
just curious....could it be done so you have the little right facing arrow that takes you to the last post in that thread on the page somewhere??

saves clicking the post shown in the vaispy.php page, and having to trawl thru all the posts to get to the end of the thread??
That would be slick. Then I could replace my "New Posts" menu option with this.

MPDev
09-07-2006, 05:25 PM
When I click on the link, it takes me right to the thread being shown.

Titania
09-07-2006, 06:08 PM
When I click on the link, it takes me right to the thread being shown.
That is what it does for me too but -
just curious....could it be done so you have the little right facing arrow that takes you to the last post in that thread on the page somewhere??

saves clicking the post shown in the vaispy.php page, and having to trawl thru all the posts to get to the end of the thread??
I agree with this post. Rather than just go to the thread, it would be much better if it went to the last post in that thread.

Great mod though :D

MPDev
09-07-2006, 06:26 PM
What I meant to say was it took me to the post being shown; not the top of the thread. If I click on a post, I go right to the post.

Titania
09-07-2006, 06:44 PM
What I meant to say was it took me to the post being shown; not the top of the thread. If I click on a post, I go right to the post.
Hmm... doesn't do that on mine. I get sent to the FIRST post on each topic. I am using Firefox on WinXP Pro. You can try it HERE (http://musclefemme.com/forum/vaispy.php)

Titania
09-07-2006, 06:47 PM
Just tried it with IE and it still goes to the first post.

MPDev
09-07-2006, 07:07 PM
I just tried it on your site using FF and it took me to the second post. Check the link - it has a #X in it which is used by vB3.5 to take a person to a specific post; we could possibly change the link to use "goto=lastpost" instead of the #X in vb_spy.js

camoman
09-07-2006, 07:24 PM
Looks really good.. What I would lie to see is it pull the latest X threadsand display them imediatly instead of one at a time .. then start polling for new threads so your not waiting for them to load if you click the back button after going to a post or revisiting the page.
So basically a module like I have in the middle on my front page HERE (http://www.trackshare.com) but it auto updates with AJAX.

RFViet
09-07-2006, 10:09 PM
Is there anyway to display it on the main forum ?? just want to replace the TopXStat !!!
And it doesn't work with bbcode !!!

MPDev
09-07-2006, 11:09 PM
Right, it does not display bbcode and I haven't tried to integrate it anywhere else; but I am sure it could be done.

RFViet
09-08-2006, 12:47 AM
Right, it does not display bbcode and I haven't tried to integrate it anywhere else; but I am sure it could be done.

Can you make it display within a box, anh about first 5 or 10 new posts , just display the thread name (so you won't worry about bbcode) . So, member can see live new posts without refresh the page . !!

scottct1
09-08-2006, 01:13 AM
My users are reporting the following error...

Works fine in Firefox, but folks having trouble with IE.

Lonny
09-08-2006, 11:44 AM
what about server load?

MPDev
09-08-2006, 12:36 PM
As with any "new thing" you add, there can be an impact. I haven't had any problems on my site; but I would expect with a large number of users you'd see a higher load because it would be like all of those users hitting the refresh button every 5 seconds or so. That's why I would suggest moderating the delay to suit your needs on your site (see the 3.6 thread for that info).

MPDev
09-08-2006, 12:55 PM
Can you make it display within a box, anh about first 5 or 10 new posts , just display the thread name (so you won't worry about bbcode) . So, member can see live new posts without refresh the page . !!

At this time I have no plans to work on derivatives; sorry.

lexx27
09-08-2006, 03:31 PM
Great Hack!!!! Thank you

Do you have in mind to make something similar with feeds?

lexx27
09-08-2006, 04:11 PM
I have 2 problems.

1. Doesnt work in ie
2. Doesnt refresh in firefox,flock and opera

I didnt change a thing from the code(only the title) and all the files are in the right place.

here is the link http://www.webz.gr/forum/vaispy.php

MPDev
09-08-2006, 04:16 PM
lexx27 - your link is working just fine for me.

Gizmo5h1t3
09-08-2006, 04:17 PM
I just tried it on your site using FF and it took me to the second post. Check the link - it has a #X in it which is used by vB3.5 to take a person to a specific post; we could possibly change the link to use "goto=lastpost" instead of the #X in vb_spy.js


tried that mate, and it stil goes to the first post....

weird...and a shame, cracking hack this, but would be complete with the ability to get to the final post in a thread with just one click.

MPDev
09-08-2006, 05:59 PM
Try grabbing the current files; I think I have it resolved (hard to keep track of these two versions and the changes, lol).

Intex
09-08-2006, 06:56 PM
Great addition. Would be nice to have the same ajax functionality with who's online.

RFViet
09-08-2006, 09:19 PM
Is there anyway to limit the characters to display ??

username12
09-08-2006, 09:21 PM
what about server load?

Way too much for me, but I may try editing the delay as suggested.

MPDev
09-08-2006, 09:48 PM
Is there anyway to limit the characters to display ??

You can change line 69 in vaispy.php:

$thread['preview'] = htmlspecialchars_uni(fetch_trimmed_title(strip_bbc ode($thread['preview'], true, true), 200));

Change the 200 to whatever.

(Dont' forget to click INSTALL!)

RFViet
09-08-2006, 09:52 PM
thanks, then how to change the time to refresh the page ??

MPDev
09-08-2006, 10:13 PM
In va_spy.js, find 3 times:

setTimeout("getXML()", 5000);

Change the number to whatever (1000 = 1 second).

Murty
09-08-2006, 11:43 PM
Can i ask, what exactly does this modification do? I have never heard of 'spy'. perhaps add something to your mod description.
thanks

MPDev
09-08-2006, 11:45 PM
Click the example links in the mod description and you'll see exactly what it does - provides a continously updating live feed of posts made to your forum without having to use REFRESH.

Murty
09-08-2006, 11:49 PM
ohh ok cool

scottct1
09-08-2006, 11:58 PM
Still not working in IE. It loads the first 10 messages but does not continue to montor and gives the error shown above in the picture I uploaded earlier.

MPDev
09-09-2006, 12:07 AM
Scott, your issue isn't related to the feed itself (it works on your site); it appears to be something about your advertising sidebar items which are causing the problem.

I'm guessing its something about your header or footer that is causing the problem.

scottct1
09-09-2006, 12:14 AM
Thanks I found out the issue was the footer, it had another Javascript in there and I just removed it.

No more error, although on IE7 I get the feed for a few minutes and then it just stops. Strange, runs fine in Firefox

RFViet
09-09-2006, 12:55 AM
Still not working in IE. It loads the first 10 messages but does not continue to montor and gives the error shown above in the picture I uploaded earlier.

Hmm I have the same problem . Yes I have java script at footer but I don't want to remove it.

scottct1
09-09-2006, 01:59 AM
Is there any way for it to display the last post in the thread instead of the first post in the thread?

MPDev
09-09-2006, 02:38 AM
I didn't notice that until now; but the problem is I'm not sure how to get that. vB3.5 doesn't store the lastpostid made (where 3.6 does). So I'm not sure how to JOIN the post and thread table to grab the last preview text.

Try changing line 57 in vaispy.php to:

LEFT JOIN ".TABLE_PREFIX."post ON (post.dateline = thread.lastpost)

The potential problem with this is on one large site with 1 million posts the query takes 10 seconds versus the .003 seconds for the original one! So, I'm not sure this is the best way.

Edit: However, if I manually add an index on the dateline field in the post table the query drops to .008 seconds on the same site. So this can work, if you add the index manually; unless someone has a better idea.

Gizmo5h1t3
09-09-2006, 08:13 AM
I didn't notice that until now; but the problem is I'm not sure how to get that. vB3.5 doesn't store the lastpostid made (where 3.6 does). So I'm not sure how to JOIN the post and thread table to grab the last preview text.

Try changing line 57 in vaispy.php to:

LEFT JOIN ".TABLE_PREFIX."post ON (post.dateline = thread.lastpost)

The potential problem with this is on one large site with 1 million posts the query takes 10 seconds versus the .003 seconds for the original one! So, I'm not sure this is the best way.

Edit: However, if I manually add an index on the dateline field in the post table the query drops to .008 seconds on the same site. So this can work, if you add the index manually; unless someone has a better idea.

nope, edited line 57. and im still getting placed on the first post on a page m8...but only on some threads, others seem to work..weird.

MPDev
09-09-2006, 11:55 AM
nope, edited line 57. and im still getting placed on the first post on a page m8...but only on some threads, others seem to work..weird.

I'm not following you - this change would make the preview text display as that of the last last - does this not work for you or are you saying that when you click on a link it doesn't take you to the last post?

Snake
09-09-2006, 05:38 PM
Thank you very much!

MPDev
09-09-2006, 09:26 PM
Sure, Snake! Don't forget to click INSTALL! ;)

Gizmo5h1t3
09-10-2006, 12:33 AM
I'm not following you - this change would make the preview text display as that of the last last - does this not work for you or are you saying that when you click on a link it doesn't take you to the last post?


sorry for being unclear m8...im saying its not taking me to the final post in a thread....

MPDev
09-10-2006, 12:48 PM
Can you grab the current download and update your vaispy.php and va_spy.js files?

djwins
09-10-2006, 06:31 PM
Would there be a way to modify this so that the latest activity is called only one time every few seconds and not each time as a user hits the vbispy.php page?

If you can get the information to be pulled via a cron job (once every 10 seconds or so) and then have everything displayed on a static page, wouldn't this be much easier on the server load?

Hmm I have the same problem . Yes I have java script at footer but I don't want to remove it.

Is there a way to make this compatible with microstats? https://vborg.vbsupport.ru/showthread.php?t=82900&highlight=microstats

Maybe just a conditional in the footer that wouldt not display microstats on the vbispy page...anyone know how to do that?

Karabaja
09-10-2006, 08:26 PM
Great stuff, thx. But it doesn't take me to last post either. Just to top of the thread.

Karabaja
09-10-2006, 08:34 PM
It could have something to do with me using seo rewrite rules.

MPDev
09-10-2006, 09:32 PM
I'm not sure - can you give me a link to look at?

RFViet
09-10-2006, 10:24 PM
The latest update works for me, thanks

MPDev
09-10-2006, 10:25 PM
Some people are suing rewrites of URLs and the links wont always work to take you to the last post. In these cases, you might try rewriting line 262 in va_spy.js to:

post_url = 'showthread.php?t=' + threadid + '&goto=lastpost';

Which tells the link to take you to the last post in the thread and seems to get rewritten correctly on the system I tested it on.

Karabaja
09-10-2006, 10:32 PM
Some people are suing rewrites of URLs and the links wont always work to take you to the last post. In these cases, you might try rewriting line 262 in va_spy.js to:

post_url = 'showthread.php?t=' + threadid + '&goto=lastpost';

Which tells the link to take you to the last post in the thread and seems to get rewritten correctly on the system I tested it on.


Yes, that worked great for me. Now it is got everything :)
Thx MPDev

lexx27
09-10-2006, 11:14 PM
Ι tested this in 3 browsers. It only shows the first 7 posts and then it does not update...
Does anybody else have this problem? It might have to do with Thread/Forum Read Marking Type...

Karabaja
09-10-2006, 11:35 PM
It would be good if there was a way to restrict guests from visiting that page. So that they can't cause high loads.

MPDev
09-10-2006, 11:47 PM
In the 3.6 area is the code for blocking access to un-registered users; just be sure to put it below the XML code if you are using the vBIspy Network.

This mod doesn't use read flags; its just waiting for new posts to be made.

The Chief
09-10-2006, 11:48 PM
Installed and looks great, thanks for the product :)

Last post feature also doesn't work... :D

RFViet
09-11-2006, 12:27 AM
MPDev,
How to make it just a box to display on main Forum ???

The Chief
09-11-2006, 12:52 AM
For some reason, Ajax is not working...

When there is a new post it doesn't automatically updating...did I miss something?

djwins
09-11-2006, 02:25 AM
I'm not sure - can you give me a link to look at?

In case you were talking to me:
http://www.cheapassgamer.com/forums/vaispy.php


Also, I really like the idea of vbispy.com network and website. I think the key here will be to make this mod as server load friendly as possible, so you can have lots of good forums feeding your vbispy page.

MPDev
09-11-2006, 12:22 PM
djwins,

Update your clientscript/va_spy.js file from the download - you still have the "old" one that has init() defined and the new code uses spyinit() to prevent any conflicts with other JavaScript.

Gizmo5h1t3
09-11-2006, 02:38 PM
Some people are suing rewrites of URLs and the links wont always work to take you to the last post. In these cases, you might try rewriting line 262 in va_spy.js to:

post_url = 'showthread.php?t=' + threadid + '&goto=lastpost';

Which tells the link to take you to the last post in the thread and seems to get rewritten correctly on the system I tested it on.


thats working fine now m8...nice work!!

djwins
09-11-2006, 05:41 PM
For some reason, Ajax is not working...

When there is a new post it doesn't automatically updating...did I miss something?
Mine also pulls the 10 latest threads and then doesnt update (unless I refresh the browser).

MPDev
09-11-2006, 06:05 PM
I'll take a look.

MPDev
09-11-2006, 06:28 PM
The problem is in your postid's - for some reason your post ids are all over the place - <id>393555</id> in the last post made, but <id>2182585</id> the post just before that.

So what I do not understand is, why are the postids so out of whack? They should be incremental given they are new posts added to the post table.

MPDev
09-11-2006, 06:34 PM
You can try the change from this post:

https://vborg.vbsupport.ru/showpost.php?p=1071138&postcount=42

And see if that makes a difference.

djwins
09-11-2006, 06:34 PM
Really? Seems ok to me...

Could it have somethingt o do with people editing old posts?

MPDev
09-11-2006, 06:37 PM
No, must be the query I am using; I only have one 3.5 site to test on and the query works using the moficiation in the link above.

I use the postid as a marker for the last post I grabbed; but when those number are so out of whack, then it never sees anything else because that first record id was so high. We might need to switch to using a datestamp variable.

MPDev
09-11-2006, 06:59 PM
Okay, I did some checking - the postid is coming from the first post in the thread; not the last. This is a problem for vB3.5 and requires making the change I outlined above.

I can update the module here, but people running larger sites will want to add an index on dateline in the post table.

djwins
09-12-2006, 06:53 AM
You can try the change from this post:

https://vborg.vbsupport.ru/showpost.php?p=1071138&postcount=42

And see if that makes a difference.

I cant find where to make the change.
My line 57 is blank.

MPDev
09-12-2006, 11:26 AM
Download from the current file and upload the va_spy.js and vaispy.php files.

djwins
09-12-2006, 01:35 PM
I want to make the change you posted here (https://vborg.vbsupport.ru/showpost.php?p=1072269&postcount=54), but not sure my line 267 is the same as yours. Can you post the code from the line before as well?

MPDev
09-12-2006, 01:46 PM
It would be easier if you just downloaded the current files.

ChurchMedia
09-12-2006, 03:04 PM
Thanks for the cool hack!

On mine, it isn't following permissions correctly. It's showing *all* the threads no matter who you are. Could this be because I'm running 5.2?

Gizmo5h1t3
09-12-2006, 03:19 PM
ok, ive uploaded the most recent files, which obviously overwrite the old ones...thing is, the fix u supplied in the last one to get the thing to go to the last post in a thread, the code u supplied i cant find now in the file to adapt...can u help, as now the newestfiles dont go to the last post, they go to the FIRST.....

MPDev
09-12-2006, 05:17 PM
Well, the only change I can think of is in va_spy.js at line 279:

post_url = vburl + 'showthread.php?t=' + threadid + 'goto=laspost';

djwins
09-13-2006, 11:34 AM
Actually, this is better:
post_url = vburl + 'showthread.php?goto=lastpost&t=' + threadid;

Is there a way to get that query/performance improvement ported over to the 3.5 version?

stud
09-13-2006, 03:56 PM
i noticed this also. The link it is generating is incorrect:

http://www.domain.com/forum/showthread.php?t=1484#60

#60 will not work as a modifier

MPDev
09-13-2006, 04:40 PM
I've updated the build to include some new code checking for password protected forums and also change the link to use goto=lastpost; try updating your vbispy.php and va_spy.js files.

Gizmo5h1t3
09-13-2006, 04:59 PM
the updated files, plus the code edit in post #79 works a dream.....nice!!

stud
09-13-2006, 05:13 PM
MPDev - please double check your code... it still is not generating the link correctly:

...showthread.php?t=1484goto=lastpost

should be:

...showthread.php?goto=lastpost&t=1484

MPDev
09-13-2006, 05:17 PM
Okay, updated download, line 279 in va_spy.js was missing the &:

post_url = vburl + 'showthread.php?t=' + threadid + '&goto=lastpost';

stud
09-13-2006, 05:26 PM
great. works fine!

Not sure if there's much of a difference how you use the lastpost variable, but either way works great.
(t=1324&goto=lastpost vs. goto=lastpost&t=1484)

Now how easy is it to remove things - such as the views/replies. Should be just as simple as removing the try{} command for each event?

MPDev
09-13-2006, 05:29 PM
There is no difference in the order; both variables get processed.

scottct1
09-14-2006, 01:01 PM
This is nice, but I would love to have it in my right column like I have it now. I reserve my center column for my news for my site.

If you can get this shrunk down so it fits in the right column it would be amazing.

MPDev
09-14-2006, 03:31 PM
This is nice, but I would love to have it in my right column like I have it now. I reserve my center column for my news for my site.

If you can get this shrunk down so it fits in the right column it would be amazing.

I don't have any plans to do different designs at this time.

america2
09-14-2006, 03:59 PM
Hey MPDev!

Pretty awesome stuff! I added it to our forum which is

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

It works fine, but I did notice that it takes almost a minute for the posts to show. Any thoughts? Thanks!

mxtabs9
09-14-2006, 05:09 PM
Nothing showing:

http://sputnikmusic.com/forums/vaispy.php

??

america2
09-14-2006, 05:17 PM
Hey mxtabs9.

Im not sure if we have the same problem but on my site it takes upto almost a minute for a post to show up. I dunno why...

glorify
09-14-2006, 05:20 PM
I love this, but the initial refresh is quite awhile in 3.5.0

Any ideas--I'd love to use the vba block, but not if it takes a long time to load.

http://www.glorifythepast.com/forums/vaispy.php

glorify
09-14-2006, 05:27 PM
Looks like the same problem everywhere. Maybe after the last update?

america2
09-14-2006, 05:30 PM
could be. I really like this. hope theres a fix to it :)

MPDev
09-14-2006, 06:17 PM
mxtabs, your site doesn't load for me at all - connection timed out.

america2, did you add the index mentioned in the first post?

america2
09-14-2006, 07:08 PM
Hey, Im not sure which index is that and what to do with it. My apologies.

djwins
09-14-2006, 09:02 PM
ALTER TABLE `vb_post` ADD INDEX ( `dateline` )
Is this code something we can just run in PHPmyadmin?

From a server load standpoint, how has this script been running on viperalley?
I have about 500-600 users online at peak times, can I use this mod without a server meltdown?

MPDev
09-14-2006, 09:57 PM
Yep, phpmyadmin is fine.

It's works great on viperalley.com - a slight increase in overall server load, but I'm running this on a couple sites and also have vbispy.com running on the same server.

In antication of the growth of vbispy.com I have a new dual core Dell 2950 being installed tomorrow. :)

Unless you have 500-600 people using vbispy.com at the same time, I don't see it as taking your server to a crawl (assuming you have a decent server in place with that many users already).

djwins
09-14-2006, 10:06 PM
I just checked phpmyadmin and it seems as if I already have a dateline index in the post table.

mxtabs9
09-14-2006, 10:13 PM
Sorry about the downtime, the site is up now, still nothing

http://www.sputnikmusic.com/forums/vaispy.php

mxtabs9
09-14-2006, 10:49 PM
Never mind, found out the site was down due to the queries caused by this thing. Not sure why

MPDev
09-14-2006, 10:52 PM
See previous posts about add an index to the post table.

evesve
09-16-2006, 03:59 PM
I really like this!

One suggest:
Is it possible to get post I already read to be normal font an unread bold?
(Or some other sign..)
To next version?

MPDev
09-17-2006, 01:14 AM
Updated to include support for Opera browsers, etc. (see version 1.08 notes at top).

djwins
09-17-2006, 02:04 AM
Upgraded to the latest version. Congrats again on the great mod!

It looks like the font got smaller.
Very much looking forward to the templated version and future improvements.

How about the option for mods/admins to change thread titles using Ajax? That would be hot.

p.s. finally clicked install and nominated for m.o.t.m

oh, and in phpmyadmin, under INDEXES, it is showing a dateline index already, despite me not adding it manually. Do I have to do anything additional?

MPDev
09-17-2006, 12:54 PM
It's using the smallfont tag (which is was using before); there is a reason that the "template" version is not a big push - it's misleading. The formatted html is in the javascript and cannot be templated; the index page can be templated, but changing the columns and such on it does not change how the data itself is displayed.

If you have a dateline index, you are good to go.

djwins
09-18-2006, 02:11 AM
I'm having an issue where iSpy will occasionally get the thread title wrong.
It will assign a thread title that is not the actual thread title of the post.

Picture attached:

MPDev
09-18-2006, 11:11 AM
I'm not sure why it would only do it occasionally and not consistantly; unless we can identify a common reason, I'm not sure where to look.

djwins
09-18-2006, 12:23 PM
Could it have something to do with the same user posting within 60 seconds?
That seems to have been the case in the photo above.

MPDev
09-18-2006, 05:57 PM
I don't think so; maybe just a fluke... Is it consistant in any way?

Guest210212002
09-21-2006, 09:14 PM
Is there a way to prevent guests/spiders from using this?

Joe
09-22-2006, 03:18 PM
Such a cool hack! Thank you much! :D

What would it take to have the option to only view new threads / posts in subscribed forums?

kompakt
09-23-2006, 11:22 AM
Thanks for fixing the last post issue on 3.5.

How would I go about parsing the posticons of the thread in a new column?

MPDev
09-23-2006, 04:10 PM
Is there a way to prevent guests/spiders from using this?

If you check the thread in the 3.6 area, you'll see code for this in the first couple pages.

MPDev
09-23-2006, 04:10 PM
Such a cool hack! Thank you much! :D

What would it take to have the option to only view new threads / posts in subscribed forums?

A change to the query to look only at subscribed forums.

MPDev
09-23-2006, 04:11 PM
Thanks for fixing the last post issue on 3.5.

How would I go about parsing the posticons of the thread in a new column?

It would require changing the vaispy.php and va_spy.js scripts to add the new icon field, determining the url to it and passing it as part of the XML feed and then using it as part of a newly formatted table. Not trivial; but do'able.

kompakt
09-23-2006, 07:38 PM
Thanks, I will take a look at them and see what I could do :)

MPDev
09-29-2006, 04:37 PM
Such a cool hack! Thank you much! :D

What would it take to have the option to only view new threads / posts in subscribed forums?

I've done this in the 3.6 version; but haven't done it for 3.5 as yet. Waiting to make sure the 3.6 version works as expected all around with new changes before porting them back to 3.5.

glorify
10-08-2006, 05:11 PM
This would be HOTM material if there was an easy way to template the output.

djwins
10-09-2006, 02:13 AM
It's definitely HOTM material anyway, but yes, a template would make this great hack even better.

MPDev
10-09-2006, 12:35 PM
Because the html is generated in javascript itself, there is no ability to interact with the template system.

djwins
10-11-2006, 04:49 AM
I don't think so; maybe just a fluke... Is it consistant in any way?Getting back to this issue...it still is mixing up the occasional post/thread. It seems to be pulling the same post ID at times...
http://www.cheapassgamer.com/forums/vaispy.php

djwins
10-20-2006, 02:52 AM
a friendly bump for my above questions and for a great mod!
I haven't actually announced this feature yet to my users, but I would like to!

MPDev
10-27-2006, 12:34 PM
I don't have any feedback for the "occasional" issue as I don't run vB3.5 anymore and cannot duplicate the problem on any of my 3.6 sites.

Stangsta
02-05-2007, 03:05 AM
Is there any way to code it like the 3.6 version, where when the vbispy.php page is loaded, that it displays the first say, 20 threads automatically, and THEN starts feeding in additional threads?

moosem32
02-21-2007, 06:32 AM
seems to be working good.. except it doesn't differentiate between new post and new thread, everything is classified as new post.

edit: nevermind, fixed it by changing line 88 of vaispy.php to:

if ( $thread['parentid'] == 0 )

Greg-J
05-27-2007, 05:26 AM
Is there any way to exclude a particular forum id from showing up? I have a hidden adult discussion section for those of my members who want to chat it in, and it is hidden from view - but can be seen with this mod.

Any ideas?

michellelammers
04-08-2008, 06:16 PM
I am taking over a forum and tried to install your mod but it didn't work. The forum was set-up without a folder called forum and just shows the site with the PHP. Will this prevent me from using this mod?

The site is pwctoday.com