Unread Post Count 1.2.0

[jayramfootball]

Hi Chris does this add run a lot of queries - it seems to slow my site down... speed issues have happened since loading the add on. It might not be the add on of course - could be many things, but just wanted to check how many queries this executes...

 

[Chris D]

It runs about three, in total, I think.

Try and run this query in PHP My Admin:

ALTER TABLE `xf_post`
ADD INDEX `unread_post_count_post_date` (`post_date` ASC)[/PHP]

If it executes successfully then that is what is missing to optimise the queries that are being run.

 

[jayramfootball]

ok ran the query and got the mesage:

#1061 - Duplicate key name 'unread_post_count_post_date'

I guess the index was already set up - it seems likely Chris that it is the addon slowing down the site, as the moment I disabled it the speed on the site came back...

I am using 1.2 RC2 by the way.

 

[Alexey.P]

Is there no better way to add the number styling wise? Running into issues with this on custom styles. See screenshot:

View attachment 52687

You can change the location @ templates, just edit it a bit, nothing biggie

 

[QenTox]

You can change the location @ templates, just edit it a bit, nothing biggie

I think it would be more helpful if you will tell what to do and where exactly.

 

[Brent W]

ok ran the query and got the mesage:


I guess the index was already set up - it seems likely Chris that it is the addon slowing down the site, as the moment I disabled it the speed on the site came back...

I am using 1.2 RC2 by the way.

How large is your site (posts per day and traffic) and what kind of server do you have?

Also, are you logging slow queries in MySQL?

 

[jayramfootball]

How large is your site (posts per day and traffic) and what kind of server do you have?

Also, are you logging slow queries in MySQL?

Not that large - about 33k posts so far, ~300 posts per day and 150 visits per day
Here is my server package
https://www.vidahost.com/web-hosting/package/advanced-package

 

[Brent W]

It is probably host related then. I have this installed on every site I own and it runs without a hitch (no slow queries) on a 1000+ post a day forum.

 

[jayramfootball]

It is probably host related then. I have this installed on every site I own and it runs without a hitch (no slow queries) on a 1000+ post a day forum.

Seemed fine before - but will try it again... it may have just been a temporary server issue...

 

[CyberAP]

@Chris Deeming how does your add-on work exactly? I have a separate template for tabLinks and my customers report that this add-on doesn't work with my custom templates.

 

[Chris D]

In version 1.1.x it uses a XenForo 1.2 template modification:



It searches for the find-new/posts link in the "navigation" template, and appends my template on the end of it (within the <a> tag so the count is also part of the link).

In XenForo 1.1.X (add-on version 1.0.X) it did some even crazier regular expression on the... header template I think. That was using template hooks.

If you've replaced the navigation template with something else... why would you? But that would explain it.

 

[CyberAP]

I moved tab links to another template because I wanted them to be in a different place, and that's not possible without separating them into another template. The style I am talking about is Velour, tab links there are in content, not in navigation.
Is there any way to do that PREG replace inside a hook, not inside a template?

 

[mauzao9]

Heya @Chris Deeming ...
Can't it be possible to make it count the updated threads and not all posts?

 

[Dakis]

Heya @Chris Deeming ...
Can't it be possible to make it count the updated threads and not all posts?

As already said, this addon was specifically built to count posts, there's another add-on for counting threads:

http://xenforo.com/community/resources/unread-threads-counter.1783/

 

[mauzao9]

As already said, this addon was specifically built to count posts, there's another add-on for counting threads:

http://xenforo.com/community/resources/unread-threads-counter.1783/

That's madness. So i can't have the same style only counting the threads with new posts... That addon does the base but not in the same way. It's ok anyway

 

[Chris D]

It's not madness at all.

It's two entirely different things.

You can contact me and I'll happily provide a quote to do the work for you.

But it may be cheaper to contact the author of the other add on to see if he can provide similar styling.

 

[mauzao9]

@Chris Deeming it's nothing but that important. I could use the other, but your do cares about performance, what is a big deal for me since we're a big enough site.

 

[netrix]

@Chris Deeming, I've got a suggestion for you to change the template of this addon like this:

<xen:if is="{$visitor.user_id}">
    <xen:require css="unread_posts_count.css" />
  
    <xen:set var="$unread">
        <xen:callback class="UnreadPostCount_Callback" method="getUnreadCount" />
    </xen:set>
  
        <span class="postItemCount{xen:if '{$unread} != 0', ' alert'}">
            {xen:number $unread}
        </span>
</xen:if>

And change the CSS like this:

.postItemCount
{   
    background: @primaryDark;
    padding-left: 3px;
    padding-right: 3px;
   
    text-align: center;
   
    font-weight: bold;
   
    border-radius: 2px;
    text-shadow: none;
}

    .postItemCount.alert
    {
        background: #e03030;
        color: white;
        box-shadow: 2px 2px 5px rgba(0,0,0, 0.25);
    }
   
.JsOnly .blockLinksList li .postItemCount {
    float:right;
}

It looks like the addon is more skin compatible, it might be necessary to adjust the fonts or some other CSS settings.
Jaxel did it the same way with XenMedio and it looks like it makes things easier.

 

[IcEWoLF]

Unfortunately this addon no longer shows with my skin, when browsing the forums 99% is not aligned and barely shows.

 

[Chris D]

Unfortunately I don't have enough information to assist you with fixing that. Maybe the style author can help?