Random smilies in posts/reply

[GuaRRand]

I edited the original 3.0.7 (https://vborg.vbsupport.ru/showthread.php?t=79108) 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!!

[jugo]

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

* jugo goes to find a way to trick it into a hook....

* jugo found it!!!

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:

[GuaRRand]

OUCH!!

*sees toes get crushed*

:P

[Snake]

Installed!

[GuaRRand]

Dont forget to click INSTALL pls :D

[sellbuydomain]

find the code, where to change it, you did not say where to change or add
'

[Bounce]

find the code, where to change it, you did not say where to change or add
'

from the original thread ;)

Change To:-

$smilies = $DB_site->query("
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()
");

I take it its the same as thread from 3.0.7 :ninja:

[GuaRRand]

Hehe..sorry, will add it in the main post...

[hotwheels]

worked perfectly........thanks. hotwheels clicks *installs*

[sportsoutlaw]

I will give this one a try

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

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

* jugo goes to find a way to trick it into a hook....


* jugo found it!!!


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. :/
:eek:

[vbreal]

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. :/
:eek:


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 ;)

[Polo]

quick and easy.

installed on vb 3.5.3

[Roxie]

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

In includes/functions_editor.php

This is not in the admin control panel. You would have uploaded it to your server. It is a PHP file.

This also works with 3.6 Gold.

[hotwheels]

yes, it works perfectly on 3.6

[PoetJA-1975]

GREAT - very nice thanx

Jacquii.

[PoetJA-1975]

Great! Works in 3.6.4 as well!
Thanx,

Jacquii.

[vivamexico55]

Any way to do this with a plugin ?

[Roxie]

Works on 3.6.5.

Just replace the last line of the code.

[LisaD1]

Works with 3.6.8

Replaced this part of the code


LEFT JOIN " . TABLE_PREFIX . "imagecategory AS imagecategory USING(imagecategoryid)
ORDER BY imagecategory.displayorder, smilie.displayorder
");



With this


LEFT JOIN " . TABLE_PREFIX . "imagecategory AS imagecategory USING(imagecategoryid)
ORDER BY rand()
");



Works like a charm :)

[jilly]

Works with 3.6.8

Replaced this part of the code


LEFT JOIN " . TABLE_PREFIX . "imagecategory AS imagecategory USING(imagecategoryid)
ORDER BY imagecategory.displayorder, smilie.displayorder
");



With this


LEFT JOIN " . TABLE_PREFIX . "imagecategory AS imagecategory USING(imagecategoryid)
ORDER BY rand()
");



Works like a charm :)

this works in 3.7.0 too.. wish it could just be a plugin though :)

[Roxie]

Yea. Seems to work, you just have to reapply the change after upgrading, which sucks. lol

[LisaD1]

Yea. Seems to work, you just have to reapply the change after upgrading, which sucks. lol

Totally SUCKS!! Especially since the upgrades to vb happen often. But of well, At least it is a small change.

[Neilll]

Yea. Seems to work, you just have to reapply the change after upgrading, which sucks. lol

would be great if this was a plugin