Miscellaneous Hacks - VSa - Advanced 'New Posts' (AJAX)

Info:
This hack will show how many new posts/threads have been posted in forums since your 'last visit'. New posts are checked via AJAX, manually or in defined time interval. Optionally you can enable and configure Smart Search Menu to give users ability to search individual forum sections. View screenshots...

Installation:
Import product XML: AdminCP > Plugin System > Manage Products > [Add/Import Product]

To set options:
Go to: AdminCP > vBulletin Options > VSa - Advanced 'New Posts'

Versions:
v1.0 - Apr 29. 2006.
-First version
v2.4 - Jan 18. 2009.
-Latest 3.x version
v3.0 - Jan 17. 2010.
-Updated for vBulletin 4.x
-Mod prefix (Cyb) changed to 'VSa'
v3.0.1 - Jan 17. 2010.
-Fixed bug where individual forum search does not work properly
-Fixed bug where product is not stopped when forums are turned off
v3.0.2 - Apr 11. 2010.
-Fixed: WOL confusion
-New: Compatible with DB thread/forum read marking types
-New: Navbar items merged
-Fixed: Permissions bug
-Fixed: Minor bugs
v3.0.3 - May 21. 2012.
-Compatible with vBulletin 4.2.x

[Swordman844555]

Old Articles from the CMS will reappear as new?

[Crossbow]

Installed and works great.

Thank you.

[Xowi]

Another great mod, thanks!

[x YNWA x]

Getting database emails for errors. On the error it has vsaanp_newposts, I am guessing it stands for vsa advanced new posts. Correct me if I am wrong.

Database error in vBulletin 4.1.2:

Invalid SQL:

SELECT COUNT(*) AS posts, post.threadid, post.dateline, thread.forumid
FROM post as post
LEFT JOIN thread AS thread ON (thread.threadid = post.threadid)
WHERE post.visible = '1' AND thread.forumid NOT IN(23,24,31,25,26,27,28,) AND
post.dateline >= 1300992412
GROUP BY post.threadid;

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
post.dateline >= 1300992412
GROUP BY post.threadid' at line 4
Error Number : 1064
Request Date : Thursday, March 24th 2011 @ 12:57:28 PM
Error Date : Thursday, March 24th 2011 @ 12:57:28 PM
Script : http://www.anfieldindex.com/forum/mi...saanp_newposts
Referrer : http://www.anfieldindex.com/forum/index.php
IP Address : 122.177.193.206
Username : thereddyone
Classname : vB_Database
MySQL Version :


Anyone have an idea what this error means and how to fix? I do not think users actually get an onscreen error...

[Valter]

Try rebuilding forum cache by going to your forum manager and saving the display.

Try also with:
Maintenance > Update Counters > Rebuild Thread Information
Maintenance > Update Counters > Rebuild Forum Information

[x YNWA x]

Originally Posted by Valter

Try rebuilding forum cache by going to your forum manager and saving the display.

Try also with:
Maintenance > Update Counters > Rebuild Thread Information
Maintenance > Update Counters > Rebuild Forum Information

Sorry What does saving the display mean? Cheers

[Valter]

[Save Display Order] button at the bottom of the page.

[fatdr]

nice mod
thanks

[fatdr]

Works great in 4.1.2 Thank you.

[pselten]

Also works great in V4.1.0

Now it says X (posts) in Y (threats)
Is it possible for me to hide the Y and only show the X ?

Thanx in advance,

Paul Selten.