what - this hack adds 32 queries when viewing posts - if so then it aint worth installing then.

look good ill wait abit and then install lol

Heh , I got a little problem (again) :
I want to use the $acthack_postsd[] thing , but I can't find much instructions about that one , any help on how to use it?

Thanks

As I said in the post immediately above yours, it's on install. At view, it's two queries plus 2 per user who hasn't had activity updated that day. The dynamic of this is a max of 32 queries per page, which will happen a bit after midnight when the old data is discarded, and 2 queries per page the rest of the day.

I am open to suggestions as to how to further reduce the number of queries. Currently, to find the activity for a user, I need to query the visitlog for visitation data, query the post table to find out when they posted, and query the user table to store the activity information so that it won't be calculated again. The only possibility I can think of is if I can do all the activity for the whole page in two queries and hope that the cost of these two queries is little enough to make them every load instead of storing the results to avoid performing the process over and over; however, I am no SQL wizzard and figuring out how to reduce the process to a flat 2 queries was a stretch of my ability.

All you need to do is enable it in the settings, then use the array in the names of the images, for example, if you made the images
postcleftcap.gif
postcrightcap.gif
postcs.gif
postc0.gif
postc1.gif
postc2.gif
postc3.gif
postc4.gif
postc5.gif
postc6.gif
postc7.gif
postc8.gif
postc9.gif

then, you could use code like this:
<img src="postcleftcap.gif" /><img src="postc$acthack_postsd[1].gif" /><img src="postc$acthack_postsd[2].gif" /><img src="postc$acthack_postsd[3].gif" /><img src="postc$acthack_postsd[4].gif" /><img src="postc$acthack_postsd[5].gif" /><img src="postc$acthack_postsd[6].gif" /><img src="postc$acthack_postsd[7].gif" /><img src="postc$acthack_postsd[8].gif" /><img src="postc$acthack_postsd[9].gif" /><img src="postcrightcap.gif" />
of course, you would want to include the path to the images and width and height attributes so your page loads cleanly. The hack generates 9 digits and represents left padded digits with an 's' .

Thanks a lot , now its perfect!

i cant even open these when I dlthem why not put them into one zip file?

Handy hack. *installs*. A word of warning for noobs: There is quite a few .TABLE_PREFIX.es missing from the code. These cause sql errors in case of a sqlprfix used and solving the mess might be quite a frustrating task without at least basic knowledge of php and sql. Aside of that - cool, as said.

=M=

Thank you WW for releases this to the public, after a year of nagging you. :p

[high]* Logikos clicks install[/high]

Is this just in the installer or in the code for the hack itself? As of 2.1, I was fairly certain that I had updated all the queries in activity.php to use TABLE_PREFIX