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

[massizero]

some users are writing that they don't read any numbers but "database error" what could it be the reason ? thanks

[RustyDogma]

I love this mod! It would be nice if it could show new posts in groups as well.

[Xencored]

Is there a way to Disable CMS comments from showing? because it links them to the "none viewing thread" not the main article

Thanks

[CVOsporty]

Hi new to BBcode and stuff as only ever really used the frebies
is there a way that somebody could advise on how to get this to post on everypage of the forum, many regards

[DDIG]

Gread mod! Thank you very much!

[Webby24]

Hello,
dont know if this error is known.

But i have the follow error, and this after installation thousand times

Invalid SQL:

                                        SELECT COUNT(*) AS posts, post.threadid
                                        FROM vb3_post as post /*FORCE INDEX (dateline)*/
                                        INNER JOIN vb3_thread as thread USING (threadid)
                                        INNER JOIN vb3_forum AS forum USING (forumid)
                                        LEFT JOIN vb3_threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1530)
                                        LEFT JOIN vb3_forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1530)
                                        WHERE thread.visible IN (1)
                                        AND thread.forumid NOT IN(64,16,52,22,24,)
                                        AND post.dateline > IF(threadread.readtime IS NULL, 1285316613, threadread.readtime)
                                        AND thread.lastpost > IF(threadread.readtime IS NULL, 1285316613, threadread.readtime)
                                        AND post.dateline > IF(forumread.readtime IS NULL, 1285316613, forumread.readtime)
                                        AND thread.lastpost > IF(forumread.readtime IS NULL, 1285316613, forumread.readtime)
                                        AND post.dateline > 1285316613 AND thread.lastpost > 1285316613
                                        GROUP BY post.threadid;

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 post.dateline > IF(threadread.readtime IS NULL, 1285316613, threadre' at line 8

Thanks a lot

Andr?

[Head Roller]

Very nice Mod.. .thanks

[LuisManson]

i was wondering how server intensive this is, since i see lots of

POST /misc.php?show=vsaanp_newposts HTTP/1.0

in the apache status...

[MonsterDK]

Need some advice... been advised to remove this if on shared or vps hosting based on that when my forum fills up with members and posts, this mod will be a major down fall.

I am using shared hosting.. can anyone advise on this?

thanks

[shanef]

how can i exclude forums that i don't want showing new posts?