[legionofangels]

Originally Posted by Darwinist

In the very first part of step 1 of the installation instructions, look at the 'replace with' code. In this part:

PHP Code:

            else {
                $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
                ");
                $totalsmilies = $vbulletin->db->num_rows($smilies);
            } 


You would replace the...

PHP Code:

ORDER BY imagecategory.displayorder, imagecategory.title, smilie.displayorder 


line with...

PHP Code:

ORDER BY rand() 


The result would be random smilies in the smilie box when the user has not selected a favorite smilies list.

Darwinist,

Does your above changes make my Smilies Cloud remain random and not show the fave smilies?

Our goal: we have the fave smilies show in the drop down menu of the Smilies button on the editor, and we want the Smilies cloud to remain random and not show the faved smilies there.

If the above change does not work, please advise on how to make the Smilies Cloud remain random.