[mfyvie]

If you've used the original version of this mod, or you've used my modified version prior to this date you should be aware that there is a performance issue. If the query is used on a busy or large system it can tie up the mysql process on the server, affecting all other queries. Therefore you need to ensure that you execute this sql query on your database:

ALTER TABLE `user` ADD INDEX(`avatarid`)

By adding this index it cut the query time on my server from over 15 seconds to 0.0065 seconds.

I've updated the attached file in the previous post to incorporate this change.

If you are using this mod and you do not add the index as described above you could affect not only the performance of your own forum, but also other applications / sites which run on the same server.