Was going to start a thread on this but found this one.
I wanted to randomize the smilies and found the same info that Michael has supplied but I couldn't get it to work that way. All my smilies are display no.1 and the same smilies always came up when replying to or starting a thread.
The way I got round it is...
Edit the
functions_editor.php file in /includes.
Find this code:
Code:
// query smilies
= ->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
"); Change it to:
Code:
// query smilies
= ->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()
"); This works for me. Hope it helps others.
