Display Unread Posts and New Reputation Comments

[Paul M]

This modification is no longer available or supported.

Note: The unread posts portion of this hack only works if you use the database thread marking system, also, this attaches itself to certain phrases in the "welcome" box and will not work if they are not present (or are modified by other code).

FYI, the Forum Marking Choices are located in vBulletin Options ;
vBulletin Options > General Settings > Thread/Forum Read Marking Type

This displays the actual number of posts that are still considered unread by you (and will show up in a 'getnew' search). It also displays the number of new reputation comments since you last checked your usercp.

There is the option to count the unread posts since your last visit, or all posts considered unread. This setting reflects the divider in the 'getnew' search display. There is also the option to disable the unread posts display or the new reputation comments display.

There is also the option to display the New Reputation Comments counter as a Welcome Box Notification.

All settings are located in vBulletin Options > Display Unread Posts and Reputation.

Version 3.7.004 adds the following ;

A forum exclusion list - requested a number of times, an option is provided to exclude forums from the unread count & display.

A time limit on unread posts count - if a member has not visited for more than x days then a simple unread posts link will be displayed, not an actual count, this stops potential large sql queries if you have a busy forum. The option can be disabled.



To install this hack unzip the xml file and import it using the ACP Product Manager.


History:

v3.7.001 : First Release for vb 3.7.
v3.7.002 : Added Notification Display Option for Reputation Comments.
v3.7.003 : Internal version, not released.
v3.7.004 : Added time limit and forum exclusion list.
v3.7.005 : Fixed path bug in welcome box notification.
v3.7.006 : Slight change to accomodate customised navbars still using vb 3.6 code.
v3.7.007 : Fix potential database error if lastrepcheck is blank, rare, but it can happen it seems.

[jerrygad]

Good job. Thanks for sharing.

[gator777]

I just want to say "thanks" Paul M for making this great mod. Although I like all my mods, this is one of the absolute best. :D

Thanks again

[Zagis]

Thanks for sharing.

Installed on vB 3.7 ;)

[aj8690]

Thank you so much! I love this. :D

[Magnumutz]

Awesome hack dude... 15 installs already :)

[The Ottoman]

Thank God!!!!


I (and my user base) have been waiting for this quite intently.

One question/request would be to have the Rep comment message show up in your "Your Notifications" section.

[lucky51]

thank you so much,
installed

and agreed with The Ottoman (https://vborg.vbsupport.ru/member.php?u=117332)

[Paul M]

Hmmm, I'm not convinced by the that idea atm.

[Alfa1]

Where does this display?

[Paul M]

In the Navbar Welcome box.

[The Ottoman]

Hmmm, I'm not convinced by the that idea atm.


Could something as simple as the fact that it would make the section just one line smaller, and that that type of notification is roughly on the same level as a Private Message, or a Social Group notification be the clincher?



Then there is also the simple bribe of Dr. Pepper if the above fails.:p

[Greenwoodi]

Hm, for me even on a local server does not work, the plug-in is established and in navbar anything is not present.

[Rat1972]

Finaly! :D

Thanks Paul

*clicks install*

[Roxie]

Been waiting for this. Thanks Paul!

[Roxie]

Oh shoot. I just noticed this only works with database thread marking. :( I've been using 3.5 that didn't require that.

[soletrader]

There's a small error with the new unread posts feature, which is very cool btw.

It depends on the location my browser is viewing if the search function works or not.

E.g. from the TL home( www.traderslaboratory.com ) it gives me an error, if I am in the
forums section it doesn't ( www.traderslaboratory.com/forums ).

This is because the link is relative, just need to convert it to absolute then everything should be fine. How can I change the path to forums?

[Paul M]

You need to set the "Links Prefix Path" setting.

[soletrader]

You need to set the "Links Prefix Path" setting.

Thank you Paul.

[Caddyman]

I had the 3.6 version of this installed. I upgraded the site to 3.7B4 and it still worked. I thought i may get more functionality out of the one you made here for 3.7 so i loaded it and it took away the unread posts counter on top the welcome box

http://www.talkdelaware.com/forums.php

Any idea Paul?
TIA

edit: must be the custom style. it works on default style. what needs to be changed on custom style to fix that, anyone?

edit edit: fixed it, in navbar template the custom style showed a old phrase. i updated with this one

<phrase 1="$bbuserinfo[username]" 2="member.php?$session[sessionurl]u=$bbuserinfo[userid]">$vbphrase[welcome_x_link_y]</phrase>

[rinkrat]

Thanks for the update!

[KURTZ]

OK nice hack Paul, just installed ... :)

[Evolution06]

cool *Installed* quick question whats the difference or benefit of switching Inactivity/Cookie Based to Database (automatic forum marking) other then this mod working?

[vnairp11]

very nice thanks you!

[Paul M]

cool *Installed* quick question whats the difference or benefit of switching Inactivity/Cookie Based to Database (automatic forum marking) other then this mod working?
Database marking works better, and also across computers (think work/home).

[Paul M]

One question/request would be to have the Rep comment message show up in your "Your Notifications" section.

As of v3.7.002 I have added this as an option, so you can use either method.

[asj]

Excellent work :)

[KURTZ]

upgraded!

[BatMNet]

Installed... Excuse my nubness.... What exactly is the "database thread marking system" and how do I get it going? (I searched these forums)

[Paul M]

See the last part of this page.

http://www.vbulletin.com/docs/html/main/vboptions_group_general

[MR.BOSS]

thanks Paul!

it didnt work on the default vbulletin skin, it worked on all other skins, why is that?

[Paul M]

No idea, works for me.

[maniguang]

hi paul, it's a nice add-on. Same as MR.BOSS, I did not get this work on the default skin. Is it possible because that I have made some changes on the default navibar before?

[CrashPush]

Love this mod. Thanks!

[basilrath]

strange ive added this previously and upgraded to the latest beta 5 and not showing now.......

[Paul M]

There is nothing in beta 5 that stops this running - its fine on my test forum.

[Greek76]

This does not work for me either on the 3.7.5 beta default skin..

[MR.BOSS]

yes thats right, there is a problem in this mod that does not work in the default vb style.. it works on other style though

[Paul M]

Please do not make unsupported statements. As I have already pointed out, this is working fine on my Test Forum (in the default and all other styles). If you have a specific issue then point it out - just saying "does not work in the default vb style" is both meaningless and wrong.

[MR.BOSS]

How do you want me to support my statement? My statement is very clear... What you want me to say if, the mod is not appearing?

[Greek76]

It does not display new post or new reputation is that better? Im using the default style of vb and the newest version of 3.7...

[Paul M]

Like I said, its running fine for me, on beta 5, default vb style - so unless one of you can give me admin access on your forum I cannot explain why you have a problem.

[Greek76]

Where do I send the details? I think its real weird that it works on yours with 3.7.5 deafault template and that it doesnt work ours.

[Paul M]

Just drop me a PM.

[MR.BOSS]

Where do I send the details? I think its real weird that it works on yours with 3.7.5 deafault template and that it doesnt work ours.

Goto, your admincp.. the vbulletin option..

find Thread/Forum Read Marking Type

then choose the second choice..

[Brandon Sheley]

added this last week and it works great :)
Thanks Paul

* Brandon Sheley clicks install

[Paul M]

Anyone saying that it is not working needs to take careful note of this quite clear statement ;

Note: The unread posts portion of this hack only works if you use the database thread marking system.

This is the issue with both I have investigated recently.

[Greek76]

Thanks Paul that definately did the trick. Working great now...

[ZGeek]

One question/request would be to have the Rep comment message show up in your "Your Notifications" section.This is an awesome mod. But I agree with Ottoman. Can it be added to the Your Notifications?

[Paul M]

Maybe you need to re-read the first post, esp the blue text. ;)

[Caddyman]

i have this installed on my board talkdelaware.com and it works GREAT!

my users love it, now i just added news feeds. they want these dis-included from the new post search and the count it shows "X unread posts" in the welcome box.

i have successfully filtered out the right forums on a search by using the "&exclude=48,4,54,55,56,57,58,59,60,61,62,63,64,65,6 6\" on the end of get new.

is there a way to get the "X unread post" to be filtered as well?

now it will show like "20 unread posts" and when you click the search it will return nothing as the actual search is filtered.

does that make sense?
-Caddy

[mamashid]

HI there paul, i have used your hack for this in the past, I just upgraded it from the 3.6 to this I have 3.7.0 RC running on board, when I added it, it is now not showing in my welcome box, help?

[Caddyman]

ok i found this in the 3.6 thread for this mod. i want to exclude a userid from the new post counts. how do i do it with this mod?

Everyone keeps asking if they can exclude forums, well, that's a different table in vBulletin. What I did is remove a user. I my case this is an RSS bot. So here's what I did.
Original New Posts and Reputation (1) Plugin:
$repcount = array();
$postcount = array();
$show['pcount'] = $vbulletin->options['npr1'];
$show['rcount'] = $vbulletin->options['npr2'];

if ($vbulletin->userinfo['userid'])
{
if ($show['pcount'])
{
$postcount = $vbulletin->db->query_first_slave("
SELECT COUNT(dateline) AS pcount
FROM ".TABLE_PREFIX."post
WHERE dateline > {$vbulletin->userinfo[lastvisit]}
");
}
if ($show['rcount'])
{
if ($vbulletin->userinfo['showreputation'])
{
$repcount = $vbulletin->db->query_first_slave("
SELECT COUNT(dateline) AS rcount
FROM ".TABLE_PREFIX."reputation
WHERE userid = {$vbulletin->userinfo[userid]}
AND dateline > {$vbulletin->userinfo[lastrepcheck]}
");
}
}

if ($postcount['pcount'] == 0)
{
$vbulletin->userinfo['pcount'] = $vbphrase['npr_no_posts'];
}
else
{
if ($postcount['pcount'] == 1)
{
$vbulletin->userinfo['pcount'] = construct_phrase($vbphrase['npr_posts'],$postcount['pcount'],$vbphrase['npr_single_post']);
}
else
{
$vbulletin->userinfo['pcount'] = construct_phrase($vbphrase['npr_posts'],$postcount['pcount'],$vbphrase['npr_plural_post']);
}
}

if ($repcount['rcount'] == 0)
{
$vbulletin->userinfo['rcount'] = $vbphrase['npr_no_reputation'];
}
else
{
if ($repcount['rcount'] == 1)
{
$vbulletin->userinfo['rcount'] = construct_phrase($vbphrase['npr_reputation'],$repcount['rcount'],$vbphrase['npr_single_comment']);
}
else
{
$vbulletin->userinfo['rcount'] = construct_phrase($vbphrase['npr_reputation'],$repcount['rcount'],$vbphrase['npr_plural_comment']);
}
}
}

Have a look at this bit:
if ($show['pcount'])
{
$postcount = $vbulletin->db->query_first_slave("
SELECT COUNT(dateline) AS pcount
FROM ".TABLE_PREFIX."post
WHERE dateline > {$vbulletin->userinfo[lastvisit]}
");
}

This is where you can manually tweak the query.
if ($show['pcount'])
{
$postcount = $vbulletin->db->query_first_slave("
SELECT COUNT(dateline) AS pcount
FROM ".TABLE_PREFIX."post
WHERE dateline > {$vbulletin->userinfo[lastvisit]}
AND userid != 13476
");
}
I added the bold text. The userid is my RSS poster bot userid. You can exclude any of the following by changing my "userid" to one on the list below and my "13476" to whatever floats your boat.

I don't recommend anyone do this unless you know what your doing!

I'm only showing you the query used and possibilities to tweak it and the only reason I'm doing that is because Paul M has stated he's not adding any features to this kick ass mod.

Here are the fields than can be played with:
postid
threadid
parentid
username
userid
title
dateline
pagetext
allowsmilie
showsignature
ipaddress
iconid
visible
attach
infraction
reportthreadid


Paul M ~ if you don't like what I've posted here, I totally understand and will delete the post. Just let me know.



please and thank you :)

[DJ Matt4684]

Edit: Nevermind, got it working again.

[user02934123123]

Is there any way to display the New Posts reading separately from the Welcome block? I very much like it there; but I'd also like to add it to various locations on custom forum pages -- e.g. we have a 'welcome page' that displays a quotation, and where I used the old Show New Posts hack to paste in the HTML code so that the reading would show.

How can I display this hack's readout elsewhere via HTML in templates?

[DJ Matt4684]

This works for me flawlessly, but on the vbadvanced page (homepage) it does not work. Is there anyway to fix this issue with vbadvanced?

[Paul M]

I think this has the path option, I cant check while on holiday.

[mamashid]

what about me paul??? ;)

[mamashid]

took me forever but i figured it out on my own, thanks though!

[Forum Lover]

Marked as Installed. :up:

[DJ Matt4684]

I think this has the path option, I cant check while on holiday.
Alright, check it out whenever you get back if you can. Thanks!

[popowich]

I have used a lot of your products on several sites over the last couple of years, you are owned one big thank you if you didn't get it already! Thank you. :D

I have a question about the unread posts. I have 3 sites I'm administering at the moment, one upgraded from 3.6.8 and unread posts works OK, the other two it was installed into new 3.7 sites, and one site doesn't shot it only for me, and the other site has the line in the welcome box but it is missing the number of posts in front of the unread posts link.

Any ideas what I should be checking to fix this issue? Thanks!

-Raymond

[AWMJen]

Paul, the mod itself works wonderfully, but with it installed, if I click on any user's name, rather than the user's profile, I see:

Fatal error: [] operator not supported for strings in /home/content/w/e/s/westa/html/AWM/vbtestnew/member.php(490) : eval()'d code on line 63

How can I fix this? Thanks.

[Paul M]

Sorry, but thats an error on the member_complete hook which is not used by this mod. Your problem is elsewhere.

[Paul M]

FYI, after 3.7 gold is released this mod will be updated with two new options.

1. Time limit on unread posts count - if a member has not visited for more than x days then a simple unread posts link will be displayed, not an actual count, this stops potential large sql queries if you have a busy forum. The option can be disabled.

2. Forum exclusion list - requested a number of times, an option will be provided to exclude forums from the unread count & display.

[Bounce]

Where does this show paul ?

Beside the user's username or elsewhere, apoologises but I can't notice any changes

Using DB marking system :up:

[Paul M]

There is a screenshot in the 3.6 version.

https://vborg.vbsupport.ru/showthread.php?t=123886

[Bounce]

Thanks I thought that as had it installed a while back, I must have a conflict somewhere as I don't see it there,navbar was reverted when 3.7 went gold,i'll try and find cause later as way past ZZzzzz time LOL

[Charlie98902]

Can't download this?

[Paul M]

Is that a statement or a question ?

[Boosted Panda]

Can't wait Paul people LOVE this mod!

[Deimos]

2. Forum exclusion list - requested a number of times, an option will be provided to exclude forums from the unread count & display.

I see it's been released with this new option, but, I can't for the life of me find it in the UserCP anywhere?

[gwerzal]

Dont suppose there is a demo available

[Deimos]

Oh....I see it

Forum Exlude List
Comma separated list of forumids to be exclused from the unread count.

But this isn't like the old addon where users could choose which forums to block and not to block.
Any chance that can be added?

[Paul M]

I see it's been released with this new option, but, I can't for the life of me find it in the UserCP anywhere?
Its not a user option, its a forum wide option in the mods vb options.

[unitedpunjab]

Thank you for the update,Possible to disable this hack it for certain usergroups ?

[Zagis]

users could choose which forums to block and not to block.
Any chance that can be added?
That would be a great idea! :up:

[Paul M]

Possible to disable this hack it for certain usergroups ?
Nope, there is no such option.

That would be a great idea! :up:
Sorry, but that will never be added - the forum wide option is the best you will get.

[GoNz00]

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 ?

[Aclikyano]

Your a professional PAUL... maybe you can tell me what this means...
(im running vb 3.7 gold now)


I overwrite with the 3.6 version of new rep + comm and it didnt go thru, gave an error.
(yea it was my mistake, shouldve installed the 3.7 duhhh :confused:)
SO I removed off the ftp, uninstalled it and thats when I got the database error.
I installed the NEW version of your hack, installed fine and BANG got an error again.
so I went back and DISABLED this product and the MYSQL error went away immediatly.


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

[Paul M]

You must post all the error text.

[Aclikyano]

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

[Paul M]

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

[Aclikyano]

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

and thats a :up:

[GoNz00]

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 !

[lunarmodule]

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:
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. :)

[lunarmodule]

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

[lunarmodule]

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.

[Paul M]

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.

[johnban]

:confused:

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

why???

[GoNz00]

if you have ultimate navbar u need to go read that thread again.

[johnban]

if you have ultimate navbar u need to go read that thread again.

I read again all the thread but I didn't figure out what I should do . :erm:

And since I am new with VB what do you mean ultimate navbar?? Can you explain in more details??

Thanks,

John.

[Goomzee]

thankx nice mod

[johnban]

I read again all the thread but I didn't figure out what I should do . :erm:

And since I am new with VB what do you mean ultimate navbar?? Can you explain in more details??

Thanks,

John.

Well... I found out something but it doesn't work correctly.

When I am selecting "Use Last Visit Date" displays "No Unread Posts since your last visit." so far so good...

When I am selecting "Count All Posts Marked as Unread" displays "Display Unread Posts" even if I have or not unread Posts.
Shouldn't display ... You Have <strong>No <a href="{1}search.php?do=getnew{2}">Unread Posts</a></strong> If I have no unread posts and
You Have <strong>{1} <a href="{3}search.php?do=getnew{4}">Unread {2}</a></strong> If I had undread posts??

:confused:

[Paul M]

Actually I wasnt sure what you meant to start with, but now I've read it again I see.

This will happen if you use the "Count All Posts Marked as Unread" option, and you have set your "Database Read Marking Limit" higher than the "Maximum Cutoff Limit" in this mod. The cutoff needs to be equal to or greater than the marking limit.

[subnet_rx]

Is there an addon like this that displays unread posts without using database marking? I know there used to be for 3.6

[Racecar]

You need to set the "Links Prefix Path" setting.

I like the add great job.
I'm new to this and have no clue what to make it, any help please?

[Paul M]

Assuming its the site in your signature, you shouldnt need to set it to anything.

[Racecar]

Assuming its the site in your signature, you shouldnt need to set it to anything.

that is the site name. When I turn the unread post count on it leaves the new post blank.
The rep part works and I can get the unread post to work but then the new post is off. Not sure what is wrong there so I have the unread post turned off at the moment.

[markblair]

I just installed this mod for vB 3.7 (have been using the previous version for awhile) and it works great! Thanks again for an excellent mod. :)

[Paul M]

that is the site name. When I turn the unread post count on it leaves the new post blank.
The rep part works and I can get the unread post to work but then the new post is off. Not sure what is wrong there so I have the unread post turned off at the moment.

New Post ?

I dont understand what you mean by that.

[droid101]

Okay, so if I set the new reputation comment to be normal, legacy mode, it works fine.

However, if I set it to be like a notification, when clicking it, it doesn't work. It doesn't add the /forums/ inbetween my URL and usercp.php, like it does when it's not a notification.

Any thoughts?

[Paul M]

Hmm, could be a bug, I'll take a look tonight.

[Racecar]

New Post ?

I dont understand what you mean by that.

When I turn the unread post on then under the New Post link on the navabar will remove the post after you read it. When I have the unread post turned off the new post link acts more like todays post. I'm hoping that it making some since. This was not a problem with 3.6 version and is now with the 3.7 version for me. When it was cookie based it was what everyone liked. It has to be something that I'm missing and I don't know what it is.

[johnban]

Actually I wasnt sure what you meant to start with, but now I've read it again I see.

This will happen if you use the "Count All Posts Marked as Unread" option, and you have set your "Database Read Marking Limit" higher than the "Maximum Cutoff Limit" in this mod. The cutoff needs to be equal to or greater than the marking limit.

Thanks Paul,

That was the problem !!!

:up:

[droid101]

Hmm, could be a bug, I'll take a look tonight.

Thanks. I just narrowed down the issue.

When there actually is new reputation, the link doesn't work. However, if there is no new reputation (but some other new notification), the link works from the dropdown.

Just trying to help!

[Paul M]

It was a small bug in the notification code, it wasnt applying the links path. Fixed in 3.7.005.

[ABeautifulBrown]

I've installed it but I don't see it :(

[LisaJH]

It works for me :D

[docvader]

Any reputation comments in postbit hack Paul?

[Paul M]

Not from me, I dont know if one exists at all.

[ABeautifulBrown]

I uploaded the file in the admin, checked the settings, and I still don't see it. :(

[Paul M]

Are you actually using the database thread marking system ?

[dancue]

I'm using the database thread marking system and I don't see the unread posts. I can see the new rep comments. (I set it under notifications)

[Paul M]

Sorry but I cannot help you without admin access to your forum.

[prawn]

Thanks for that great and another "that should be vbulletin default" modification.

Best

[mgurain]

It didn't work for my 3.7.0 Gold ! nothing appears, it was working on 3.6 with last version.

[Paul M]

See post #115 :)

[IvyKeepMommy]

I have this installed and it works great, but I'm having an issue on my site with "database errors" that the host is saying is caused by too many queries at once... so I'm trying to track that down.

Does this modification add to the queries significantly?

[Paul M]

Ask your host what they mean exactly by "too many queries" - and what exactly are the database errors you get.

This adds one select query for each function (unread posts, rep comments).

[docvader]

Paul, I used this one for years, into 3.68...

https://vborg.vbsupport.ru/showthread.php?t=103046

Reputation comments in Postbit.

I know you can make one better....

[OcR Envy]

Is there no way manually edit the navbar template to include this? I have a custom style which this mod does not seem to like and does not display.

I got it to work with the $unread variable however the $rcount isn't displaying anything? Will it display if I have no new rep comments?

[Kinneas]

Don't believe it displays unless you have a rep comment.

[Paul M]

Will it display if I have no new rep comments?No.

[arena]

Hello unread only not working help me? and instaked hack for thanks

[Paul M]

Did you read the big note in the main post ?

[arena]

Did you read the big note in the main post ?
Thanks

[arena]

Paul M Your hack 3.18 New posts and reputation comments unustalled mysql error and
Display Unread Posts and Reputation Comments 3.7.005 loding

Help me please.

And

Fatal error: Allowed memory size of 10485760 bytes exhausted (tried to allocate 401239 bytes) in /home2/xxxx/public_html/includes/functions.php(5501) : eval()'d code on line 54

[Paul M]

Paul M Your hack 3.18 New posts and reputation comments unustalled mysql error and
Display Unread Posts and Reputation Comments 3.7.005 loding
No idea what you mean by this - what mysql error, and what exactly were you doing ?


Fatal error: Allowed memory size of 10485760 bytes exhausted (tried to allocate 401239 bytes) in /home2/xxxx/public_html/includes/functions.php(5501) : eval()'d code on line 54
This is a php error, your allowed (php) memory size seems very small, you need to increase it.

[IvyKeepMommy]

The host says that the database error happens when there are more than 50 queries. Anyone trying to access the site instead gets a slash screen that says database error:

This is literally the entire text of the error:

The database has encountered a problem.
Please try the following:

* Load the page again by clicking the Refresh button in your web browser.
* Open the www.***mysite.com home page, then try to open another page.
* Click the Back button to try another link.

The www.***mysite.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

[arena]

I to use 3.18 New posts and reputation comments not to rome mysql error to find with.

board of this Display Unread Posts and Reputation Comments 3.7.005 some time page this Fatal error: Allowed memory size of 10485760 bytes exhausted (tried to allocate 401239 bytes) in /home2/xxxx/public_html/includes/functions.php(5501) : eval()'d code on line 54 and versiyon 3.18 or 3.7.005 How do romove ?

very sorry for bad english

[Paul M]

The host says that the database error happens when there are more than 50 queries. Anyone trying to access the site instead gets a slash screen that says database error:

This is literally the entire text of the error:

The database has encountered a problem.
Please try the following:

* Load the page again by clicking the Refresh button in your web browser.
* Open the www.***mysite.com home page, then try to open another page.
* Click the Back button to try another link.

The www.***mysite.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.


You need to right click on the page and view the source, that will show you the real error. TBH, it sounds like you need a new host.

[arena]

Paul M help me please how are this romove?
versiyon 3.18 or 3.7.005

Database error in vBulletin 3.7.0:
Invalid SQL:
SELECT COUNT(dateline) AS rcount
FROM reputation
WHERE userid = s
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 : Wednesday, May 14th 2008 @ 05:41:32 PM
Error Date : Wednesday, May 14th 2008 @ 05:41:32 PM
Script : http://www.mysite.com/
Referrer : http://www.maysite.com/showthread.php/arenatr-ailesine-hos-geldiniz-41.html
IP Address : xxxxxx
Username : xxxxxxx
Classname : vb_database
MySQL Version : 4.1.22-standard-log

[Paul M]

Uninstall it, and then reinstall it.

[arena]

Not Uninstall mysql error

[scdurwood]

the unread portion works great for me...

...the notification part not so much....

...what I get is a generic "Your notifications: ##" with a drop down arrow next to it...

...the drop down doesn't do anything on click and the link doesn't click over even though the status bar shows it pointing to the UserCP...

...is it supposed to differentiate between new PMs and rep points?

[Fraxter]

Edit://

Please delete this post.

best regards Pander23

[arena]

Paul M help me please how are this manuel romove?
versiyon 3.18 or 3.7.005

bicause I versiyun 3.7.005 inistall

[Paul M]

You uninstall it using the product manager.

[Rottimom]

Hello,

I have vers. 3.7.005 into my vB 3.7.0 installs, it is shown to nothing in the navbar, though.
Of vB 3.6.7 ( here the old add On still worked after the update) on vB 3.7.0, the Template navbar still is not revised completely. Perhaps it is due to it?
Would be possible for me there to be the code for the unread Posts which displays these, you revise to the Template completely so that I can manually install it in the right place?

Sorry, unfortunately, English is not my language, therefore I translate this text by a tool.

Greetings Rottimom

[Paul M]

There are no template modifications for this - as the big note says, it attaches itself to certain phrases (which have changed between 3.6 and 3.7, so if you have a customised navbar, you may need to revert/re-edit it).

[shinydarkstone]

really an excelent mod
my users loveit

[Hannan]

Thanks Paul but it has not work for me! Could you tell me what is the manual code so I can add to my Template by my self
thanks

[SNATCH3R]

Thanks Paul for this wonderful mod....i had used this on 3.6.8..will uninstall that and use this now....thanks buddy....

[Paul M]

Thanks Paul but it has not work for me! Could you tell me what is the manual code so I can add to my Template by my self
thanks
Please read previous posts, specifically just two above yours.

[Greek76]

Works great but doesnt work on my vbadvanced page. the link is missing the form inbetween the url. Is their a fix for it? Thanks Paul..

[Paul M]

Is their a fix for it? Thanks Paul..
Yes, use the provided "Links Prefix Path" option.

[scdurwood]

even on the default vb 3.7 style it does not detail which type of notification is displayed. Would you be willing to look at my code to see if there is a phrase in my navbar that is missing? Works fine for me except for this one bug.

[Paul M]

If you PM me admin access and the exact issue then yes, i'll take a look.

[Jason Buchanan]

Anyway to turn so others can see reputation? Such as a buddy of mine looks at my profile and can see what my rep is and who left what comments?

[mariocaz]

Very nice, thank you!!

[Paul M]

Anyway to turn so others can see reputation? Such as a buddy of mine looks at my profile and can see what my rep is and who left what comments?

https://vborg.vbsupport.ru/showthread.php?t=169555

[DDIG]

Would it be possible to add the "x unread posts since your last visit" to the "Your notifications" dropdown? I don't want my breadcrumbs header to grow vertically (which this mod does).

How can I do that?

[Paul M]

Sorry but I have no intention of doing that, on anything except the most quiet of forums you would always have a notification. I also like it to be visible without having to click on anything.

[DDIG]

That makes sense. I thought since reputation comments is optional from within the admin cp 'latest unread posts' may also be there. Most users click on 'latest posts' in the navbar anyway. Thanks for the mod.

[petersweb]

Thanks Paul - great Mod!

I use vbPortal and have copied the code to my /global.php file which allows it to be seen in the notifications area on the Portal pages. Only problem is that the URL on the "Unread Posts" link is incorrect. Where can I alter the URL so it points to /forum/seach.php?

[Paul M]

Use the Links Prefix setting.

[petersweb]

Use the Links Prefix setting.
Thanks Paul!

[balance12]

i have installed the Mod, it check my DB and say it was Ok. But It dont shows nothing in the navbar. I prove with the three opions in admincp/option/displau unread.... what could it be?

[basilrath]

i have installed the Mod, it check my DB and say it was Ok. But It dont shows nothing in the navbar. I prove with the three opions in admincp/option/displau unread.... what could it be?

you have sorted the "database thread marking system" i assume?

[balance12]

Dont understand what is that. its a mod? a DB modification?

[Kinneas]

Dont understand what is that. its a mod? a DB modification?

vBulletin Options -> General Settings

[Paul M]

Having investigated another forum having problems I came across the same common problem as a number of others Ive looked at.

The unread posts portion of this modification attaches itself to a phrase in the Navbar template that is only found in vb 3.7 - if you have a customised navbar that is based on pre 3.7 code then this will not display the unread posts.

Since this is the cause of a number of reports in this thread Im going to look at modifying it slightly to try and detect if you using pre 3.7 code and adjust itself acordingly.

[DominicG]

I just wanted to say Thank you for all your help :) The mod is awesome and the support I received from you is greatly appreciated :)

[lolitka]

Hi Paul!

I'm using a "Blue Evolution" theme and trying to use your mod, but even installation seems to be ok in whole 100% I don't have any effects. I knew, you wrote:

Note: The unread posts portion of this hack only works if you use the database thread marking system, also, this attaches itself to certain phrases in the "welcome" box and will not work if they are not present (or are modified by other code).

But what can I do to make it working and change this:
http://www.iv.pl/image/181585.jpeg

into something you wrote?

Appreciate your future help!
Tom

[Paul M]

Since I dont have a copy of the Blue Evolution style I cannot tell you much. The mod attaches itself to the welcome_x or welcome_x_link_y phrases.

[lolitka]

strange, because I have in my navbar template:
<if condition="$show['member']">
<td class="alt2" nowrap="nowrap">
<div class="smallfont">
<strong><phrase 1="$bbuserinfo[username]" 2="member.php?$session[sessionurl]u=$bbuserinfo[userid]">$vbphrase[welcome_x_link_y]</phrase></strong><br />
<phrase 1="$pmbox[lastvisitdate]" 2="$pmbox[lastvisittime]">$vbphrase[last_visited_x_at_y]</phrase>

so what to do next?

[Paul M]

Check that you are using database marking, and all the mod settings are correct - after that you would need to start looking at things like another mod breaking it.

As with any of my mods, if you PM me admin access I will look for you when I have the time.

[lolitka]

Thx :)

Would you mind to write sth more about "database thread marking system"? Is is a vB admin option and where can I find it to turn it on?

It's probably noobish question but I really don't know.

[Paul M]

vBulletin Options > General Settings > Thread/Forum Read Marking Type

[balance12]

Thanks, I change that and worked 100%.... you are grate.. mark as install
ed

[lolitka]

Thanks, I change that and worked 100%.... you are grate.. mark as install
ed

same as me!
Thx Paul!

[tei727]

Paul,

This will not work when using the Time Greeting (Good Morning,etc..) mod (https://vborg.vbsupport.ru/showthread.php?t=178745).

[Paul M]

Correct, that mod overwrites the welcome_x_link_y phrase.

Note: The unread posts portion of this hack only works if you use the database thread marking system, also, this attaches itself to certain phrases in the "welcome" box and will not work if they are not present (or are modified by other code).

JFYI, If you altered the plugin execution order on the two mods you might still be able to get it to work.

[tei727]

Correct, that mod overwrites the welcome_x_link_y phrase.



JFYI, If you altered the plugin execution order on the two mods you might still be able to get it to work.you might as well have spoken that in greek...lol

[Charlie98902]

It is truly sad to see no more development on this mod it was and still is a great mod.

[Paul M]

Huh ?

[BigDog56]

Correct, that mod overwrites the welcome_x_link_y phrase.



JFYI, If you altered the plugin execution order on the two mods you might still be able to get it to work.

How do you do that?

[Scooterpig]

Thanks for the update Paul but since installing this new version I find that it doesn't work when using this (https://vborg.vbsupport.ru/showthread.php?t=172507) hack, yet did so fine before this new release version, sorry..:(

[Paul M]

I take it that by new version you mean the 3.7 version because this could never have worked with that mod installed - the reason being that Boofo appears to completely remove the welcome_x_link_y phrase from the navbar.

Edit: Actually, there is a post on how to modify one of my plugins here ;

https://vborg.vbsupport.ru/showthread.php?p=1461180#post1461180

[Paul M]

How do you do that?
Edit them in the Plugin Manager.

[Scooterpig]

Thanks Paul that link to fix got it going again along with Boofo's hack, thank you..:)

[N-0p3rz]

Just updated. Working flawlessly.

Love your work. Thanks..

[Aimee1969]

Thank you so much ;)

[Paul M]

This cannot invent reputation.

[BigDog56]

This cannot invent reputation.
My bad, I figured it out. :o

[hostlayer]

I installed this on 3.7 but it is not showing up at all, any ideas?

[Miktar]

EDIT: NM, just takes a while.

[Paul M]

I installed this on 3.7 but it is not showing up at all, any ideas?
Have you read all the notes in the main post.

[slyreptile]

Odd. After removing the old 3.6 version and installing this new version, I'm getting database errors sent to my email account. Apparently some users have having problems viewing the forum and others (like myself) have no issues. Here's the email message:

Database error in vBulletin 3.7.0:
Invalid SQL:
SELECT COUNT(dateline) AS rcount
FROM vb_reputation
WHERE userid = 210
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 : Thursday, June 12th 2008 @ 09:37:15 AM
Error Date : Thursday, June 12th 2008 @ 09:37:15 AM
Script : http://www.mydomain.com/forum/
Referrer :
IP Address : x.x.x.x
Username : Thiok
Classname : vB_Database
MySQL Version :

I've disabled showing new Reputation comments for now. Don't know if that will work or not. I'm still troubleshooting.

[slyreptile]

After turning on the rep system and having the Display New Reputation Comments set to Yes, I still have members having this issue.

[Artes_Marciales]

Thanks Paul!

it commendable to install this at big forums?
My data base is very heavy this does that she be heavier or it goes away cleaning the table periodically?

Sorry my English...

[ArnyVee]

This is one of the most valuable mods to have installed, IMO.

It really keeps the folks up to speed on what is going on in multiple threads. Thanks Paul! :D

[Paul M]

After turning on the rep system and having the Display New Reputation Comments set to Yes, I still have members having this issue.
Uninstall it, and then re-install it. You are missing some values in a column.

JFYI, that column should never be missing data, but this isnt the first case, so I'm going to edit the code slightly to stop the error when that data is missing.

[Paul M]

it commendable to install this at big forums?
My data base is very heavy this does that she be heavier or it goes away cleaning the table periodically?
How big do you mean ? This adds a column to the user table, and in index to the post table - thats the only difference it will make to your database.

[Artes_Marciales]

Thanks Paul,
I have around 40.000 members.
This adds a column to the user table, and in index to the post table
This column is autoprune or I have to empty it manually like the column of cookies?

Regards!! : )

[Paul M]

I dont really understand your question, but you dont have to do anything.

[Artes_Marciales]

OK, thanks Paul!!

[Hugo Holbling]

Edit: Nevermind - I figured it out.

[Ohiosweetheart]

Paul I really like this, and have it installed on my business site. However, on my other site, TalkOhio, I can't get it to work. I'm thinking that it's because I have Boofo's modification (https://vborg.vbsupport.ru/showthread.php?t=172507) installed, and perhaps it's conflicting?

[Paul M]

Yes, it conflicts - if you look right at the bottom of the main post in Boofos mod, there is a link to a post that tells you how to fix the problem.

[Ohiosweetheart]

great, thanks Paul, worked beautifully! I really like this modification.

[kansei]

Anyone else having an issue with this plugin where on the homepage of the forum (which is running vbadvance) such as www.heyitstheforum.com it tries to link to www.heyitstheforum.com/search.php, but the forums are in /forums/ so search.php isn't there?

It works fine once you are in the /forums/ hierarchy of pages, just any page outside of that it won't work.

It's a vbulletin 3.7.1 patch level 2 forum btw

[petersweb]

Anyone else having an issue with this plugin where on the homepage of the forum (which is running vbadvance) such as www.heyitstheforum.com (http://www.heyitstheforum.com) it tries to link to www.heyitstheforum.com/search.php (http://www.heyitstheforum.com/search.php), but the forums are in /forums/ so search.php isn't there?

It works fine once you are in the /forums/ hierarchy of pages, just any page outside of that it won't work.

It's a vbulletin 3.7.1 patch level 2 forum btw
I had a similar problem - Paul gave me the answer here : https://vborg.vbsupport.ru/showpost.php?p=1528137&postcount=157

[InoffLine]

And is it possible to disable atm, and make templates changes by myself

[theparentpack]

After upgrading to this version my unread posts link on the vbadvanced CMPS page not working. Any ideas on how to fix this?

[Paul M]

<a href="https://vborg.vbsupport.ru/showthread.php?p=1426822&highlight=links+prefix#post1426822" target="_blank">https://vborg.vbsupport.ru/showt...ix#post1426822</a>

[Hund]

When I click on unread posts it displays a list of threads that have unread posts. Is there a way to have it then take me to the first unread post in that thread when I click on the thread title?

[Paul M]

You click on the little icon at the start of the thread title - thats standard vb functionality.

[theparentpack]

Thanks!:D

[madmax1228]

....marks installed! Very nice!

[balance12]

Installed, but it dont show me nothing in navbar!

[Paul M]

and you have read the big note ?

[Boosted Panda]

I have some notifications that will not go away any solution to this? Love this mod!

[Paul M]

Can you be a little more specific please.

[Boosted Panda]

Ignore the PM but the notifications have been read and they won't go away.

[Paul M]

Sorry, that is unrelated to this mod, I cant help you.

[Kamakazy]

Hi Paul,

I installed the mod and it seems to be working fine...

In your old hack, i was able to see 'New Post' rather than 'Unread Posts'

New Posts will show all new posts (read and unread) <--- this is what i want to see...

Unread Posts only shows the unread post (duhh!)

How can i set your mod to show me 'New Posts'?

Thanks

[Paul M]

You cant.

[Brandon Sheley]

Thanks for the update Paul :)

[Piccante]

I'm having an issue that the new rep notification is not showing on my admin account on my board. Unread posts is working though, and for my registered members it is all working.

Any idea?

[liwo]

I have done a small patch to get this mod work together with Opt-Out Forums from Get New/Get Daily (https://vborg.vbsupport.ru/showthread.php?t=91025).

I post it here, it might be usefull for some people (or you might even include it in the hack)...

--- Unread-posts.xml (Revision 10)
+++ Unread-posts.xml (Arbeitskopie)
@@ -174,7 +174,23 @@
}
unset($fids[$eforum]);
}
+
+ // Modification by liwo
+ // Exclude forums selected in addon optoutgnp (https://vborg.vbsupport.ru/showthread.php?t=91025)
+ if ($vbulletin->products['optoutgnp'])
+ {
+ if ($vbulletin->userinfo['excludeforumsgnp'])
+ {
+ $optout_forums = explode(',', $vbulletin->userinfo['excludeforumsgnp']);
+ foreach($optout_forums AS $id)
+ {
+ unset($fids[$id]);
+ }
+ }
+ }
+ // End modfication by liwo

+
$flist = implode(',', $fids);
$elist = implode(',', $elista);

[Paul M]

Thank you.

I'll take a closer look at this when I next update the mod.

[Piccante]

I'm having an issue that the new rep notification is not showing on my admin account on my board. Unread posts is working though, and for my registered members it is all working.

Any idea?

PS I've upgraded to lastest release and didn't make any difference.
And I realised I hadn't marked as installed - which I've rectified :D

[Paul M]

Are you sure your admin account is set to display reputation (its a user option).

[Piccante]

Are you sure your admin account is set to display reputation (its a user option).

It was set to "no", but I hadn't realised as I could still always see my reputation on my posts :confused:

I've managed to change it now... after the trauma of finding I was an unalterable user.

Will see if it's sorted now. Thank you Paul.

[lazytown]

Great mod.. I am having a couple members say that for ex it shows "5 new posts since your last visit" and when they click the link it doesn't show any or shows 1 or 2. I figured it might be due to the mod section posts? However if I exclude them, then it will affect the count the mods see. If it's not due to the mod sections, can someone point me as to what the cause might be?

Thanks
-vissa

[Paul M]

Could be moderated threads perhaps ?

How many do you see when they tell you this.

[lazytown]

Ah, perhaps it is moderated threads (spambot). I wasn't online when they quoted the number, though I can try it through a test account.

-vissa

[ePrOmD]

Hi Paul
it is possible that through this hack can also see where there are post in social groups to which the user belongs? as well too, if someone responds to a blog ?

thank you very much again for your work
regards from argentina

[Spank]

I agree with the comments that it would be better to have this incorporated into notifications.

[MDK-Indy]

Salü,

the "new reputation comments" ar below of Welcom message.
The "AJAX Invisible Mode Switch" Icon to displace downward.

See at the Picture...

How i can the "new reputation comments" display below of the last visit line?

greeting Indy

[JJ the Fox]

Great mod but I'm having a problem, when a user receives reputation, it posts the notice twice like shown below:

https://vborg.vbsupport.ru/external/2008/08/35.gif

[Paul M]

Do you have more than one version installed ?

[towermatt]

Hello--I went through all my hacks and disabled them because the calendar.php on my site was drawing a blank page.

Disabled this one and it came back. I did not have a problem with it before I ugraded, any chance there is a solve?

I have version 3.7.007 loaded.

[SSJB_7]

Can We Have Some Screenshots I Don't See It Anywhere

[SSJB_7]

ok i found it and add it in my navbar2 thanks a lot

[Paul M]

Hello--I went through all my hacks and disabled them because the calendar.php on my site was drawing a blank page.

Disabled this one and it came back. I did not have a problem with it before I ugraded, any chance there is a solve?
There is no chance unless you can give me repeatable steps to create the issue as my calendar works fine.

[towermatt]

I'm sure it does Paul, I certainly didn't mean to offend.

Basically, I upgraded to 3.7 and then made an effort to upgrade all my hacks. All seemed perfectly fine until someone mentioned to me that the default calendar for the board was drawing a blank page.

So I began turning them off one by one and testing it. The default board calendar would not come up until I got to the unread posts hack. I realize there is probably nothing wrong with your hack, just that they may conflict somehow...not sure. I could be crazy. LOL

Here is a link to my board: http://www.thedarktower.com/palaver

My members are going crazy without the "unread posts" modification so I'm putting it back on no matter what, calendar or no.

[Paul M]

I cant do anything as a guest :) I would need an admin login at the very least to see whats happening.

[towermatt]

Thank you Paul, if you have time to look that would be great.

I'll PM you the info.

[towermatt]

Just so everyone knows, my problem with the calendar was not Paul's hack. The fact that it worked after the disable was a total coincidence.

Amazing support on this hack, thank you for your help Paul.

[glennybee]

Is there any way I can change the font for this text...???

No Unread Posts since your last visit.

Thanks :)

EDIT:

I found it lol...I edited the phrase and that fix it. :)

[forumguy]

Installed this hack and upgraded the previous one. Works well except there seems to be a small change. In the previous edition when you viewed an unread post it left in the unread post section, just not bolded.

Is there anyway to go to having the unread post stay in the unread section instead of disappearing after it is clicked?

[Brad Jones]

Paul, thank you for this plugin. It works very well.

Could you make an option whereas the admin could choose to display the number of posts and threads? The display could be something like, "x new posts in y threads".

Seeing both numbers gives a better sense of what kind of unread monstrosity you have awaiting you when there's been a particularly active time since your last visit.

[theparentpack]

I have this installed on 3 of my forums, and one of them is a new forum. I am having issues with the Unread Posts link working on my vBa CMPS hompage. The Unread Posts link works fine on the forums page, but not the CMPS page. How do I correct this issue?

[Brad Jones]

The Unread Posts link works fine on the forums page, but not the CMPS page. How do I correct this issue?
As per earlier messages in this thread...

vBulletin Options -> Display Unread Posts and Reputation -> Links Prefix Path

You need to enter the path from your homepage to your forum, with a trailing slash.

For instance, I use, "/forum/".

[theparentpack]

thanks! I solved the other issue, but now I am having another issue.

Every time any of the members or I visit the forums our unread posts says No Unread Posts. When I click on unread posts there are some listed, but they are listed as if I have already visited the site. In other words above the unread posts list of posts it says:

The threads below have not been updated since your last visit but still contain unread posts.

How do I fix this? It is only happening on one of 3 forums that I have. I am afraid it is affecting the activity on my site.

[Brad Jones]

Every time any of the members or I visit the forums our unread posts says No Unread Posts. When I click on unread posts there are some listed, but they are listed as if I have already visited the site. In other words above the unread posts list of posts it says:

The threads below have not been updated since your last visit but still contain unread posts.
What do you have for the following?:

vBulletin Options -> Display Unread Posts and Reputation -> Display Unread Posts Option

It should be set to "Count All Posts Marked as Unread".

[forumguy]

Anyone know how to resolve this issue:

Installed this hack and upgraded the previous one. Works well except there seems to be a small change. In the previous edition when you viewed an unread post it left in the unread post section, just not bolded.

Is there anyway to go to having the unread post stay in the unread section instead of disappearing after it is clicked?

It should be displaying read and unread posts.