vb.org Archive - Miscellaneous Hacks - VSa - Advanced 'New Posts' (AJAX)

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Miscellaneous Hacks - VSa - Advanced 'New Posts' (AJAX) (https://vborg.vbsupport.ru/showthread.php?t=233310)

Can I use the addon with vbcms?
I have only in Forum Advanced 'New Posts' (AJAX) and i need this in cms too

Quote:

Originally Posted by Valter (Post 2333406)

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.

I've tried rebuilding the forums, threads, flushing the cache, even tried to figure out where it is picking up the list in the Database.

:erm:

How do you exclude certain forums?

Nice one. Works with 4.2.0. Does exactly what it says on the tin.

Cheers

Quote:

Originally Posted by jdeveaux (Post 2333471)

I've tried rebuilding the forums, threads, flushing the cache, even tried to figure out where it is picking up the list in the Database.

:erm:

By chance I've discovered that this issue is caused by installing a combination of VSA Hacks... now the new question is which one :confused:

I'm going through and testing one by one but thus far I haven't found the smoking gun. Installed by itself it works great.

I have a problem after install

Code:

Datenbankfehler in vBulletin 4.1.0:



Invalid SQL:



                                        SELECT COUNT(*) AS posts, post.threadid

                                        FROM post as post /*FORCE INDEX (dateline)*/

                                        INNER JOIN thread as thread USING (threadid)

                                        INNER JOIN forum AS forum USING (forumid)

                                        LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 67)

                                        LEFT JOIN forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 67)

                                        WHERE thread.visible IN (1)

                                        AND thread.forumid NOT IN(106,107,108,109,110,99,100,)

                                        AND post.dateline > IF(threadread.readtime IS NULL, 1352086208, threadread.readtime)

                                        AND thread.lastpost > IF(threadread.readtime IS NULL, 1352086208, threadread.readtime)

                                        AND post.dateline > IF(forumread.readtime IS NULL, 1352086208, forumread.readtime)

                                        AND thread.lastpost > IF(forumread.readtime IS NULL, 1352086208, forumread.readtime)

                                        AND post.dateline > 1352086208 AND thread.lastpost > 1352086208

                                        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, 1352086208, threadre' at line 8

Fehler-Nr.    : 1064

Fehler-Zeit   : Monday, November 5th 2012 @ 03:27:08 PM

Datum         : Monday, November 5th 2012 @ 03:27:09 PM

Skript        : http://new/vb4/misc.php?show=vsaanp_newposts

Referrer      : http://new/vb4/forum.php

Dear Valter,
Above the search results, the name of my private subforums will be shown to people who has no permission. This list is returned from {vb:raw criteriaDisplay}.

Please provide a fix for this issue.

HTML Code:

<div id="pagetitle">

                <h1>

                        <vb:if condition="$search_back_url">

                                <a href="{vb:raw search_back_url}"><strong>{vb:rawphrase search}:</strong></a>

                        <vb:else />

                                <strong>{vb:rawphrase search}:</strong>

                        </vb:if>

                </h1>

                <p class="description">

                        {vb:raw criteriaDisplay}                

                </p>

        </div>

I appreciate your work.

So, under New Posts in your screenshot, what does 3 | 2 mean?

Quote:

Originally Posted by Valter (Post 2331298)

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

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

well I tried update from 3.0.2 to 3.0.3 and the post counter is gone on 4.2.x forum
reverting to 3.0.2 fixes it

Quote:

Originally Posted by emperatour (Post 2391652)

HTML Code:

<div id="pagetitle">

                <h1>

                        <vb:if condition="$search_back_url">

                                <a href="{vb:raw search_back_url}"><strong>{vb:rawphrase search}:</strong></a>

                        <vb:else />

                                <strong>{vb:rawphrase search}:</strong>

                        </vb:if>

                </h1>

                <p class="description">

                        {vb:raw criteriaDisplay}                

                </p>

        </div>

I appreciate your work.

where this goes to please ?

Installed on 4.2.1 and working great!

But it still shows 4 | 6 altough i've already read the new posts/threads. And the SSM shows forums although the usergroup doesn't have permissions.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_html_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02061 seconds Memory Usage 1,757KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_html_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: