Smilies

[eglyntine]

I know this post is pretty old but I just upgraded to 3.8.2 and noticed that my smilies weren't rotating like they should so I went searching and found this article. Of course it didn't have the answer but I figured it out so I thought I would pass it on for those of you that are still having the problem.

In includes/functions_editor.php find:

// query smilies
            $smilies = $vbulletin->db->query_read_slave("
                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, imagecategory.title, smilie.displayorder
            ");

Replace with:

// query smilies
            $smilies = $vbulletin->db->query_read_slave("
                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 rand()
            ");

It works like it should now.