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

[Emeralda]

It works on 4.1.10, at least with it's basic functionality, I haven't gotten deeper yet. But it doesn't show properly here:



Any ideas on how I could get it to work with What's New tab?

[depalaza]

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

i have same problem and i have do
-forum manager and saving the display.
Maintenance > Update Counters > Rebuild Thread Information
Maintenance > Update Counters > Rebuild Forum Information


but still error

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(3,10,57,64,79,80,81,73,48,74,87,62,75,71,) AND post.dateline >= 1330064830 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 >= 1330064830 GROUP BY post.threadid' at line 4
Error Number : 1064
Request Date : Thursday, February 23rd 2012 @ 10:52:17 PM
Error Date : Thursday, February 23rd 2012 @ 10:52:18 PM
Script : http://www.blackgamerz.net/misc.php?...saanp_newposts
Referrer : http://www.blackgamerz.net/forum.php
Classname : vB_Database
MySQL Version :

[Valter]

You have unexpected comma at the end of list of excluded forums.
3,10,57,64,79,80,81,73,48,74,87,62,75,71,

[Nirjonadda]

Working on my forum 4.1.10

[depalaza]

Originally Posted by Valter

You have unexpected comma at the end of list of excluded forums.
3,10,57,64,79,80,81,73,48,74,87,62,75,71,

hmm excluded forum ? where i can find it ? and that message not shown at admin usergroup so it only shown to other usergroup

[Valter]

v3.0.3 - May 21. 2012.
-Compatible with vBulletin 4.2.x

To upgrade:
-Import XML, allow overwrite
-Revert product templates if modified

[Gemma]

Thanks for the update

[FTG LIQUID CL]

Works like it says,updates fine.Great work as always Valter. Thank you

[jdeveaux]

I'm testing with 4.2 and getting the same MySQLi error, below:

Note - I've noticed that it only happens if a user logs out or comes to the site and does not have cached login credentials. Once they log-in everything appears to be ok.


Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT COUNT(*) AS posts, post.threadid
FROM vb_post as post /*FORCE INDEX (dateline)*/
INNER JOIN vb_thread as thread USING (threadid)
INNER JOIN vb_forum AS forum USING (forumid)
LEFT JOIN vb_threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 0)
LEFT JOIN vb_forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 0)
WHERE thread.visible IN (1)
AND thread.forumid NOT IN(7,16,24,8,33,21,136,127,115,138,5,110,25,28,29, 42,80,3,12,134,139,36,131,130,30,99,91,32,82,69,31 ,20,27,26,117,)
AND post.dateline > IF(threadread.readtime IS NULL, 1338082997, threadread.readtime)
AND thread.lastpost > IF(threadread.readtime IS NULL, 1338082997, threadread.readtime)
AND post.dateline > IF(forumread.readtime IS NULL, 1338082997, forumread.readtime)
AND thread.lastpost > IF(forumread.readtime IS NULL, 1338082997, forumread.readtime)
AND post.dateline > 1338082997 AND thread.lastpost > 1338082997
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 > IF(threadread.readtime IS NULL, 1338082997, threadre' at line 8 Error Number : 1064 Request Date : Saturday, May 26th 2012 @ 08:44:21 PM
Error Date : Saturday, May 26th 2012 @ 08:44:22 PM
Script : http://site/misc.php?show=vsaanp_newposts
Referrer : http://site/login.php?do=logout&logo...6f538d64af7e12
IP Address :
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :

Regards,

John

[Valter]

At the end of list of excluded forums you have extra comma which produces error:
...27,26,117,).

It should not be there. Try rebuilding Forum Information.