Quote:
Originally Posted by sellbuydomain
find the code, where to change it, you did not say where to change or add
'
|
from the original thread
Change To:-
PHP Code:
$smilies = $DB_site->query("
SELECT smilieid, smilietext, smiliepath, smilie.title,
imagecategory.imagetype AS category
FROM " . TABLE_PREFIX . "smilie AS smilie
LEFT JOIN " . TABLE_PREFIX . "imagecategory AS imagecategory USING(imagecategoryid)
ORDER BY rand()
");
I take it its the same as thread from 3.0.7 :ninja: