Most Popular Avatar on Forum Home 1.0
 

// Most Popular Avatar on Forum Home
-- // A hack by N9ne, Copyright N9ne 2003+
-- // Created on 11th April 2003

// Description
-- // This hack will display the most popular avatar, ie.
the most used avatar, on forumhome.

// What needs to be done to install the hack
-- // Add some code to index.php

nice idea ! how many queries does it add (sorry if a dumb question)

wood it b poss 4 u to make "most popular smilie on forum home" ! cheers

It adds one query to forumhome.

I don't know how to make the most popular smilie appear, as I'm not even sure if it's possible to search through posts counting how many times each smilie is used, etc. etc.

It would be far too intensive to do the same for smilies though, even if it is possible.

how can u determine which is the most popular????

It does it automatically, based on how many users are using the avatar.

Would be good to cache this ;)?

Probably would be good, but how? :p

you could make a table that stores the info and have it update it on a preset time, like once an hour.

Indeed if someone could help n9ne do this then i can pinch the code and again learn from it ;)

The problem with storing the information in a separate table, is:

1. Another table is added
2. There will still be one query required, to retrieve the data from the table
3. Somewhere, an update must be run, albeit even if it is automatic, some form of query will be run then...

Is it possible to make the avatar come with the number of people using it in text?