Random smilies in posts/reply

I edited the original 3.0.7 code, by BluPheonix, a bit to comply with 3.5.
Tetsed it with my 3.5 site and it works fine.

In includes/functions_editor.php find:

$smilies = $vbulletin->db->query_read("
				SELECT smilieid, smilietext, smiliepath, smilie.title,
				imagecategory.title AS category
				FROM " . TABLE_PREFIX . "smilie AS smilie
				LEFT JOIN " . TABLE_PREFIX . "imagecategory AS imagecategory USING(imagecategoryid)
				ORDER BY imagecategory.displayorder, smilie.displayorder
			");

Replace it with:

$smilies = $vbulletin->db->query_read("
				SELECT smilieid, smilietext, smiliepath, smilie.title,
				imagecategory.imagetype AS category
				FROM " . TABLE_PREFIX . "smilie AS smilie
				LEFT JOIN " . TABLE_PREFIX . "imagecategory AS imagecategory USING(imagecategoryid)
				ORDER BY rand()
			");

Should work fine!!

[jilly]

that worked for me too , where nothing else did

[jilly]

Could there be a way to exclude certain categories of smilies by user preference? For example we have dancing bananas, and it's either a love/hate thing - I'd love to be able to let the members screen what smilies go in the random rotation by category...

[LBSources]

Welp.. working on 3.5.3 as for some reason all '1' do not rotate mine.. but this did the trick.. just hate that its a file edit..

good job and thanks..

[QueenBee]

works like a charm

:clicks install::

[yinyang]

Originally Posted by jugo

I want to do this so bad, but i'd hate to have to edit files...

[high]* jugo goes to find a way to trick it into a hook....
[/high]

[high]* jugo found it!!!
[/high]

I hope I'm not stepping on toes here, but i released the plugin version here: https://vborg.vbsupport.ru/showthread.php?t=99435 :ermm:

no he doesn't. doesn't work.

[GrendelKhan{TSU]

anyway to exclude some smilie categories?

I have some that are HUGE (and in a HUGE smilie category). Don't want them showing up suddenly and stretching the page. :/

[vbreal]

Originally Posted by GrendelKhan{TSU

anyway to exclude some smilie categories?

I have some that are HUGE (and in a HUGE smilie category). Don't want them showing up suddenly and stretching the page. :/

thats the same problem i am having. i need to exclude the big smilies

[bairy]

Yip. Create a second smilie category named "Big smilies" or something, and move the large smilies to it, then put:

WHERE smilie.imagecategoryid =1

above the ORDER BY line in the query, that will select smilies only from the default smilie category.

Of course that means the big smilies will only be accessible via viewing all of them.

Also I'm not one to critisise others, especially on matters such as php file hacking, but:
This is a tiny tiny file edit. I know everyone has become ultra sensitive about file hacks since the plugin system came out, but this is a 10 second job. Upgrade, Re-replace it. If you clicked install it'll show up in your profile so you can quickly find it again.

[yumyumcat]

Where do I find this in the Admin CP? I can't seem to locate it.

In includes/functions_editor.php

[Bojangles]

Easy to overwrite, nice job