[WildSoftCat]

To use Favorite Smilies : https://vborg.vbsupport.ru/showthread.php?t=123116

Replace this

PHP Code:

                    $cybcb_get_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
                        LIMIT 0, ".$vbulletin->options['cybchatbox_smiliesinit']."
                    ");        


$cybcb_smilies_total = $vbulletin->db->num_rows($cybcb_get_smilies); 


with this

PHP Code:

############### FAVORITE SMILIES #################
                  global $permissions;
                  if (($vbulletin->userinfo['favsmilies']) AND ($vbulletin->options['favsmiliesactive']) AND ($permissions['favsmiliepermissions'] & $vbulletin->bf_ugp_favsmiliepermissions['canusefavsmilies'])) {
                $show['favsmilies'] = true;
                $favsmilies = str_replace(" ", ", ", $vbulletin->userinfo['favsmilies']);
                $cybcb_get_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)
                    WHERE smilieid IN ($favsmilies)
                    ORDER BY imagecategory.displayorder, imagecategory.title, smilie.displayorder
                ");
                $favsmtotal = $vbulletin->db->num_rows($cybcb_get_smilies);
                $smilietotal = $vbulletin->db->query_first("SELECT COUNT(*) as total FROM " . TABLE_PREFIX . "smilie");
                $cybcb_smilies_total = $smilietotal['total'];
            }
            else {
                $cybcb_get_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
                ");
                $cybcb_smilies_total = $vbulletin->db->num_rows($cybcb_get_smilies);
            }
############### /FAVORITE SMILIES ################