vb.org Archive - Miscellaneous Hacks - Display Unread Posts and New Reputation Comments

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

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Miscellaneous Hacks - Display Unread Posts and New Reputation Comments (https://vborg.vbsupport.ru/showthread.php?t=168303)

You must post all the error text.

Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT COUNT(dateline) AS rcount
FROM reputation
WHERE userid = 2
AND dateline >;

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 '' at line 4
Error Number : 1064
Request Date : Saturday, May 3rd 2008 @ 03:08:24 PM
Error Date : Saturday, May 3rd 2008 @ 03:08:27 PM
Script : http://www.mysite.com/forums/
Referrer :
IP Address : edited
Username : AtotheC
Classname : vB_Database
MySQL Version : 4.1.22-standard

You are missing a value for lastrepcheck - I suggest you uninstall this and then re-install it.

Quote:

Originally Posted by Paul M (Post 1507152)

You are missing a value for lastrepcheck - I suggest you uninstall this and then re-install it.

and thats a :up:

Quote:

Originally Posted by GoNz00 (Post 1506636)

this was working fine until i installed this version, now its gone and im not sure what to try in forum path.

/forums/
and the full www.clan...co.uk/foeums/ also didnt work ?

db is set right as well as it wused to work ok ?

i forgot all about the issue with ultimate navbar, working again thanks !

Hmm. Well, I upgraded my forum to 7.0 last night and I'm having trouble getting this new version to work for me. It shows the "unread posts" portion, but not the reputation part.

I previously had your 6x version installed (loved it btw), upgraded forum to 3.7.0, uninstalled 6x version in the product manager, installed the new one successfully, but I can only get the "unread posts" part to show up. Everything seemed to go perfectly, no errors.

During the forum upgrade, and before the mod install, I reverted back all templates and I just verified they are unaltered and up to date.

It almost seems to me like it just needs to be turned on, but I verified in vB Options that the bullet for "display new reputation comments" is set to yes.

I saw your warning:

Quote:

Note that this attaches itself to certain phrases in the "welcome" box and therefore will not work if they are not present (or are modified by other code).

and that seems like it might apply to me but, as far as I can tell, the templates are fresh and untouched.

Any idea what could be wrong?

Thanks a bunch and I love this hack, when I can get it to work. :)

no additional template modifications are necessary, right? all i did was install the xml in the product manager.

OH, ugh, nm, got it. It doesn't show up unless there is a new rep comment, otherwise the line doesn't appear at all, which is different than the 6x version. But it's fine! :)

Thanks again, great hack.

Quote:

Originally Posted by lunarmodule (Post 1507541)

OH, ugh, nm, got it. It doesn't show up unless there is a new rep comment, otherwise the line doesn't appear at all, which is different than the 6x version. But it's fine! :)

Yes, the "no new comments" line was removed.

:confused:

I installed it but it does not appear in the navbar.

why???

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 (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)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.01355 seconds Memory Usage 1,739KB 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 (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)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: