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

[LisaD1]

Originally Posted by Roxie

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]

Originally Posted by Roxie

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

would be great if this was a plugin