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!!

[Polo]

quick and easy.

installed on vb 3.5.3

[Roxie]

Originally Posted by yumyumcat

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]

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

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