[VBDev]

Originally Posted by Angel-Wings

Hmm - related to the smiley retrival problem - dunno but it works fine until I set up more than 1 category - then both categories get mixed.

Modifying the mgc_cb_evo.php file and the SQL statement:

Would display the smilies, sorted by category. Still sorting the categories like set, dunno - seems there's an additional query needed to read from the "imagecategory" table the imagetype and the ID's

Here is a fix that should work :

PHP Code:

            $smilies = $vbulletin->db->query_read("
              SELECT s.smilieid, s.smilietext, s.smiliepath, s.title
              FROM " . TABLE_PREFIX . "smilie AS s
              LEFT JOIN " . TABLE_PREFIX . "imagecategory AS cat ON (s.imagecategoryid=cat.imagecategoryid)
              ORDER BY cat.displayorder ASC,s.displayorder ASC
              LIMIT " . $vbulletin->options['mgc_cb_evo_editor_nbsmileys']
                                                  ); 


Please can you try ?