[Sam FT]

Today at 03:40 AM tkeil69575 said this in Post #22
the hack works fine together with firefly's hack. the order of smilies still works for the smilies shown directly in the post form, but is not adhered to in the pop-up window.

greets
tina

tina great hack, but there is one line that makes firefly's hack not work and it is in the smilie.php file (step 16 from your instructions)

original code:

$smilies=$DB_site->query("SELECT smilietext,smilieid,title,smiliepath FROM smilie LIMIT ORDER by title LIMIT ".($limitlower-1).",$perpage");

firefly version of the code:

$smilies=$DB_site->query("SELECT smilietext,smilieid,title,smiliepath,showid FROM smilie ORDER BY showid LIMIT ".($limitlower-1).",$perpage");

and your version of the code:

$smilies=$DB_site->query("SELECT smilietext,smilieid,smilie.title,smiliegroup.title AS catname,smiliepath,smiliecat FROM smilie LEFT JOIN smiliegroup ON smiliecat=smiliegroup.smiliegroupid ORDER by smilie.title LIMIT ".($limitlower-1).",$perpage");