[boatswife]

Originally Posted by Pamela

Can anyone please help me? I'm almost there!

No matter what I do, I can't get the selected smilies to show up in my smilies box. I see the yellow star...I get the list of smilies to chose from (and can make and save my selections)...BUT nothing changes in my smilies box. When I click on the yellow star again, the selctions are still marked as saved...but nothing changes in my smilies box (just the same old ones showing as before) .

I have redone the steps over and over again and can't get it to work. I have even tried disabling all other modifications to see if one of other mods were interfering with it...and nothing! Please help!

I had to figure it out once again, this time I can pass it on to you all! LOL I know I sounded like a nut telling you (Pamela) that the file sizes were different. They were because it was an older version of the edits that I was using and that's what made it work.

I used the older version edits of function_editor.php that can be found here. Make only the following edits to your current function_editor.php file and it will work. At least it corrected the problem for me and it's now working on 3.8.2. You may still need to go to the membergroups and click on go.

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
");

// get total number of smilies
$totalsmilies = $vbulletin->db->num_rows($smilies);

REPLACE WITH:
// query smilies
############### FAVORITE SMILIES #################
if (($vbulletin->userinfo['favsmilies']) AND ($vbulletin->options['favsmiliesactive'])) {
$favsmilies = str_replace(" ", ", ", $vbulletin->userinfo['favsmilies']);
$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)
WHERE smilieid IN ($favsmilies)
ORDER BY imagecategory.displayorder, imagecategory.title, smilie.displayorder
");
$favsmtotal = $vbulletin->db->num_rows($smilies);
$smilietotal = $vbulletin->db->query_first("SELECT COUNT(*) as total FROM " . TABLE_PREFIX . "smilie");
$totalsmilies = $smilietotal['total'];
}
else {
$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, imagecategory.title, smilie.displayorder
");
$totalsmilies = $vbulletin->db->num_rows($smilies);
}
############### /FAVORITE SMILIES ################

FIND:
$show['moresmilieslink'] = iif ($totalsmilies > $vbulletin->options['smtotal'], true, false);

REPLACE WITH:
$show['moresmilieslink'] = iif ($totalsmilies > $vbulletin->options['smtotal'], true, iif ($vbulletin->userinfo['favsmilies'], true, false));

Save and upload.