Is there any way for it to display the last post in the thread instead of the first post in the thread?

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:

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.

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?

Thank you very much!

Sure, Snake! Don't forget to click INSTALL! ;)

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

Can you grab the current download and update your vaispy.php and va_spy.js files?

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?

Is there a way to make this compatible with microstats? https://vborg.vbsupport.ru/showthrea...ght=microstats

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

Great stuff, thx. But it doesn't take me to last post either. Just to top of the thread.

It could have something to do with me using seo rewrite rules.

I'm not sure - can you give me a link to look at?

The latest update works for me, thanks

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:

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

Ι 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...

It would be good if there was a way to restrict guests from visiting that page. So that they can't cause high loads.

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.

Installed and looks great, thanks for the product :)

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

MPDev,
How to make it just a box to display on main Forum ???

For some reason, Ajax is not working...

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

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.

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.

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

Mine also pulls the 10 latest threads and then doesnt update (unless I refresh the browser).

I'll take a look.

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.

You can try the change from this post:

https://vborg.vbsupport.ru/showpost....8&postcount=42

And see if that makes a difference.

Really? Seems ok to me...

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

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.

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.

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

Download from the current file and upload the va_spy.js and vaispy.php files.

I want to make the change you posted here, but not sure my line 267 is the same as yours. Can you post the code from the line before as well?

It would be easier if you just downloaded the current files.

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?

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.....

Well, the only change I can think of is in va_spy.js at line 279:

Actually, this is better:
Is there a way to get that query/performance improvement ported over to the 3.5 version?

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