vb.org Archive - Smilie Info: Smilie Usage in Posts

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Smilie Info: Smilie Usage in Posts (https://vborg.vbsupport.ru/showthread.php?t=137287)

calorie

01-22-2007 10:00 PM

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.

Distance

01-23-2007 05:32 AM

Sweet

Terminatoronly

01-23-2007 05:40 AM

nice thanks for the release ;)

supersam1121

01-23-2007 08:04 AM

Very nice.

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

- Sam

Rich	01-23-2007 10:10 AM

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

01-23-2007 11:41 AM

Quote:

Originally Posted by Rich (Post 1165670)

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

01-23-2007 12:36 PM

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

01-26-2007 10:56 PM

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

Any ideas?

KURTZ

01-27-2007 07:47 AM

INSTALLED!

thx calorie :)

Trana

01-29-2007 05:00 AM

Quote:

Originally Posted by Trana (Post 1168080)

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

01-31-2007 11:47 PM

Installing now, wish me luck. ;)

Trana

02-02-2007 06:27 AM

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

Any ideas?

WEBDosser

02-02-2007 06:45 AM

uploaded and working.. ;)

calorie

02-02-2007 08:34 AM

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

Code:

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

Code:

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

04-08-2007 10:06 PM

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

04-08-2007 10:34 PM

Quote:

Originally Posted by Rich (Post 1165670)

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

04-09-2007 12:05 AM

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

04-11-2007 08:28 AM

It's possible to make a template version ?

Anne Lise

04-12-2007 08:27 PM

edited

Anne Lise

10-21-2007 05:02 PM

My smilies is just a red X.

leftie

12-16-2008 11:12 AM

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

Infopro

12-16-2008 11:52 AM

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

07-16-2009 05:16 PM

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.

All times are GMT. The time now is 07:46 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01848 seconds Memory Usage 1,759KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (23)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: