Xenplaza - Number Viewing a Forum [Deleted]

[X_Plaza]

X_Plaza submitted a new resource:

Xenplaza - Number Viewing a Forum (version 1.0.0) - How many visittors are viewing a forum ?

Please consider a donation to encourage continued support of this free addon.

View attachment 33762​

Description
This addon will show on the forum list (included subforum), where it says how many visittors are viewing a forum.

Installation:
- Upload all contents of upload folder to your forum root
- Import XML file in your forum ACP
- Find this line in...

Read more about this resource...

 

[faeronsayn]

How many queries does this add ?

 

[bainisteoir]

How many queries does this add ?

would like to know this too?

 

[TheBigK]

How many queries does this add ?

Me too. I'm really minding the performance of the site these days.

 

[Dao Hoang Son]

Me too. I'm really minding the performance of the site these days.

It will add one very fast query to get data from session activity table. Depending on the user activities, this add-on will add

• One extra query for each member viewing a thread to determine the thread's forum id. This query is fairly fast because it uses thread_id (the primary index) to query data.
• One extra query for each nodes to get its child nodes. This query is not very fast. It may be quite slow if you have many nodes.

So with 100 logged in users browsing the site: 5 of them are viewing threads, your site has 10 nodes (forums, pages, categories). For each forum index request, this add-on will add 1 + 5 + 10 = 16 queries. This post is written after reading the code, I'm not confident enough to install this on my live server yet. Will update this post after getting home and install it on my local machine.

Edit: So I installed this on my local machine and forum_list query count jumped from 9 to 13 with 3 forums + no other logged in user. If I go to view a thread and refresh forum_list, the counter jumped to 14 as expected.

 

[TheBigK]

Looks like I'll skip it.

 

[guicoelho]

Hello, loved this add-on! Could you please make a version of it that shows the members who are reading the Forum?
Thanks!

 

[Brandon Sheley]

I've added this for now, I'd like to get the query count down though, is there a way to cache the system or have it fetch every 15 mins or so?

 

[Syndol]

This person was banned for pirating XenForo add-ons.
I don't think you are likely to receive an answer

 

[cclaerhout]

Hello, loved this add-on! Could you please make a version of it that shows the members who are reading the Forum?
Thanks!

I've added this for now, I'd like to get the query count down though, is there a way to cache the system or have it fetch every 15 mins or so?

The developer of this addon will not connect there anymore, so if I were you I won't wait after an answer to your question.
Edit: Syndol was faster than me.

 

[Brandon Sheley]

Oh that's a shame

 

[Syndol]

A shame he was banned or that you will get no answer?

 

[Brandon Sheley]

A shame he was banned or that you will get no answer?

Well that he was banned and what he allegedly did.

 

[Syndol]

No 'Alleged' here.

 

[Brandon Sheley]

Either way, I've been looking for this addon for a while, it's sucks that it won't be supported.

 

[Forsaken]

Either way, I've been looking for this addon for a while, it's sucks that it won't be supported.

This had a lot of performance issues on other boards I was helping out with.

 

[Brandon Sheley]

It took my home page from 18 queries to 57

 

[Forsaken]

It took my home page from 18 queries to 57

The site I helped out was getting close to 6k queries with this add-on.

 

[CritiKiL]

So basically if no one is viewing any threads then this addon will not show anything, correct?

 

[speedway]

So basically if no one is viewing any threads then this addon will not show anything, correct?

Correct....