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.

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

Originally Posted by 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.)

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.