is that normal that this mod adds 10 queries?

edit : never mind the inferno warning was adding 20 queries go figure!

It is normal for this mod to add a lot of queries at the start of the day, and for it to quickly taper off.
There are several options that start off which add queries when turned on. They should all explain the query impact in the description.

In the default configuration, it is possible for this mod to add no queries when viewing a thread. This happens when posts for all of the posters on the displayed page have been previously viewed during the day, and none of those posters are the active user. On the other hand, if you view a thread page (of 25 posts), where each post is by a different user and noone has been viewing the board today, you could get 25x3=75 queries the first time you view the thread (but if you refresh it would drop to zero, because the activity is stored for each user from the first page load).

Activity is per user, not per post, so the typical senario is that after the configured "midnight" for the mod, people are viewing threads and the people that post a lot get their activity calculated and stored, using a lot of queries. After that, pages probably get 6 or 9 queries added as people view posts by less-frequent posters. Eventally, virtually all of the active users will have their activity already calculated and stored, and the mod will be adding only the single query to calculate the logged-in user's activity today in threads they posted in. Note that this is one of the reasons for the configurable day cycle: if you place the mod's midnight at the time where you have the lowest usage, not only will the day cycles seem more natural to the users, but the load spike after midnight will be placed where it won't matter as much.

I have made every effort to minimize SQL server load caused by this mod. Not only is activity stored for future page loads, but it is also stored for future posts on the same page, for example. It would be possible for me to do only 3 big queries every page load, but those 3 queries would create a larger and ongoing load than the way that I do it.

I guess I figured out, how you can show the activitytstat.php addon as a correct location in Who is online. By adding two mini-plugins and a phrase, the WOL-List will show the right location. Maybe this could be added to the package, if it is good enough. I do not claim any credits, since this bases on a tutorial I found on vbhacks-germany.com (thank you Andreas ;) ). Okay, here we go:

1. Add a new phrase, name it activity_toplist and give it the value of "Toplist" or "Statistic" or whatever you desire.

2. We now need the first plugin to introduce the addon to our vbulletin system. Select "add plugin", in the dialog select the product "Activity modification" and the hook "online_location_process". Add the following code to it:
3. It's time to tell the WOL what to do, so we add the next plugin. Select "add plugin", in the dialog select the product "Activity modification" and the hook "online_location_unknown". Now add the code:
4. All done. The next time somene visits the activitystats.php, it will be shown correctly in the who is online list.

By the way, this system is working of course for every other installed hack that is not shown correctly. Hope that helps someone out.

thx wetwired

I very like this Hack and it works fine for me with 3.60 Gold.
Thank you for your Efforts to code such Things, I know that's
not easy Work. :cool:

i second that

thank you for this script. i am wondering if one has tested this script on VB 3.6.0 thanks

yup, works fine for me :)

thanks rogersnm i will test it now..