Smilie Info: Smilie Usage in Posts

[calorie]

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.

[Distance]

Sweet

[Terminatoronly]

nice thanks for the release ;)

[supersam1121]

Very nice.

Installed and working at http://www.sitefanatic.com/smilieinfo.php

- Sam

[Rich]

This may be a stupid question, but what purpose does this mod serve? (Other than showing how many smilies have been used on the site.)

I am not knocking this mod, I am just curious what usage this info would be good for. (I may be missing this mods usage completely.)

[paul41598]

This may be a stupid question, but what purpose does this mod serve? (Other than showing how many smilies have been used on the site.)

I am not knocking this mod, I am just curious what usage this info would be good for. (I may be missing this mods usage completely.)
It was requested here:
https://vborg.vbsupport.ru/showthread.php?t=137278

One would assume that if you like to replace your smilies alot, then i'd be nice to know how many times each one of them gets used so you can determine which ones to delete and in replacement add a new one ;)

[Cyricx]

Holy crap! That's awesome!!!

This will be VERY useful! We are up to like 400 smilies and I've been very curious to know which ones are used and are not so I can remove the ones that aren't :)

Well done!

[Trana]

I uploaded the file, gave the proper permissions, and I only get a white page when I load it.

Any ideas?

[KURTZ]

INSTALLED!

thx calorie :)

[Trana]

I uploaded the file, gave the proper permissions, and I only get a white page when I load it.

Any ideas?

Can anyone help with this? What do we need to do aside from upload the file?

[zompus]

Installing now, wish me luck. ;)

[Trana]

I have 230k posts and allI get is a white screen when the page finally loads.

Any ideas?

[WEBDosser]

uploaded and working.. ;)

[calorie]

@Trana: That's an awful lot of posts for this mod to handle. Untested, but try replacing:

$smilie_infos = $db->query_read("SELECT COUNT(t1.postid) AS smiliecount,
t2.smilietext, t2.smiliepath, t2.title AS smilietitle
FROM " . TABLE_PREFIX . "post AS t1, " . TABLE_PREFIX . "smilie AS t2
WHERE t1.allowsmilie = 1
AND BINARY t1.pagetext LIKE CONCAT('%',REPLACE(REPLACE(t2.smilietext,'%','\%') ,'_','\_'),'%')
GROUP BY BINARY t2.smilietext
ORDER BY smiliecount DESC
");

With the following to get a measure of the smilies used in about the last 1000 threads.

cache_ordered_forums(1);
$smilie_numthreads = 0;

if (is_array($vbulletin->forumcache))
{
foreach ($vbulletin->forumcache AS $smilie_foruminfo)
{
$smilie_numthreads += $smilie_foruminfo['threadcount'];
}
}

// change 1000 in this line to 500 if 1000 is too many
$smilie_cutpoint = max(0, $smilie_numthreads - 1000);

$smilie_infos = $db->query_read("SELECT COUNT(t1.postid) AS smiliecount,
t2.smilietext, t2.smiliepath, t2.title AS smilietitle
FROM " . TABLE_PREFIX . "post AS t1, " . TABLE_PREFIX . "smilie AS t2
WHERE t1.threadid > " . intval($smilie_cutpoint) . "
AND t1.allowsmilie = 1
AND BINARY t1.pagetext LIKE CONCAT('%',REPLACE(REPLACE(t2.smilietext,'%','\%') ,'_','\_'),'%')
GROUP BY BINARY t2.smilietext
ORDER BY smiliecount DESC
");

[Dream]

this is interesting. took 5 minutes to process 130k posts, but it worked.

some smilies show only their title and not the image though.

[Shelley_c]

This may be a stupid question, but what purpose does this mod serve? (Other than showing how many smilies have been used on the site.)

I am not knocking this mod, I am just curious what usage this info would be good for. (I may be missing this mods usage completely.)

It's purpose/usefullness isn't as great as many of the top mods but for me I was curious on which were the most populour smilies used on my board. Plus, being a graphics resource, it serves as an indicator in which emoticons people like due to the amount of times it's used.

[thepub]

some of the smileys do not show in the image box only a name for the smiley (i.e. "wink" instead of ;) ) How can I fix this?

[Allan]

It's possible to make a template version ?

[Anne Lise]

edited

[Anne Lise]

My smilies is just a red X.

[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.