Most popular smilie !

[corsacrazy]

i would like to display the most used smilie on forumhome ! is this possible ? ? eg :

most popular smilie = : :cross-eyed: has been used 504 times in the forums !

thanks !

[Xenon]

well, yes it's possible, but it would be quite intensitve to get the value, as long as noone knows a good query i wouldn't do it

[corsacrazy]

so is there a possiblility that a coder wood b able 2 do it , or is this too intense ? ?

[Xenon]

i just know a tooooo intense way.
it's because you have to go through each posts pagetext and count how often every smilie is used in it.....

if you are on a hosted server your host would contact you very soon

[corsacrazy]

Originally posted by Xenon
if you are on a hosted server your host would contact you very soon

huh ? y ?

[Xenon]

they wouldn't be amused of the strongly increased serverload
especially on forumhome this could kill every server

[corsacrazy]

seriously ive gotta think more carfully of my requests lol so wood it b possis just to grab the most used smilie and not have it say "has been used XXX times " ?

[Xenon]

no, if you give out the number or not doesn'T help, the problem is to find out how often a smilie has been use so you can say it's the mostused one...

[corsacrazy]

right wood u know of any other hacks along these lines to add a bit of FUN stats to forumhome ?

[Logician]

I agree with Stefan. Easy way is too server intensive and your hosting company will kick you out at no time if you use such an algorithm.

However if any hackers take it, here is an algorithm which requires more hacking but is performance friendly: (Don't look at me, I don't have time, sorry!)

You can add a new field to smilie table named "usagecount" and populate this field with a script once. Then you can hack newreply.php, newthread.php, editpost.php and private.php and apply a hack which updates this field on the fly whenever a new post is sent by counting the smilies.

Then queries and smilies stats can easily be compiled without any server load.