Smilie Info: Smilie Usage in Posts

This mod displays a count for the number of times a smilie has been used in posts, where the allowsmilie field of the post table indicates that smilies can be used. If you have a lot of posts, the one query contained in this mod could be heavy. If you are unsure, try the mod and see how it performs. If it's too heavy, just uninstall the mod. No harm, no foul. See the screenshot for the output.

[leftie]

Excellent. This works for 3.7.2. It's a shame it can't be intergrated into admincp to help with management.

[Infopro]

Thanks for this. Only took a few seconds to go thru (I'll assume) all 106,000+ posts. Over 400 smilies stored, only 96 in use. All smilies came up red X's but I was still able to go thru them all and remove the "dead soldiers".

Major benefit to this, when adding new smilies, I won't have to go thru pages of crap smilies no one ever used. Plus, knowing the ones that are used, it'll be easier to find replacements for 96 smiles than thinking I'd need to replace many more.

BTW, ran this on vb 3.8 RC1. Didn't bother worrying about why the red x's instead of the image itself, didn't matter. I won't be needing this too often.

Thanks.

[SamirDarji]

Has anyone tested this on 3.8.3?

I'd like to see a version of this that stores this information and uses it to populate the smilie table in the post reply screen. This way, the top 10+ smilies are always in view, but the user has the option of choosing something else if they desire.