Change the display order of smilies

Description:
This hack will allow you to set the display order of clickable smilies (if you use them).
It's good if you have a lot of smilies, and want the more commonly used to be shown in the box.

Demo:


Installation:
1. Run the following queries either in phpMyAdmin or thru Telnet: (one query at a time)

ALTER TABLE smilie ADD showid SMALLINT not null
ALTER TABLE smilie ADD INDEX (showid)
UPDATE smilie SET showid=smilieid

2. In functions.php (in your admin folder) replace

PHP Code:

$smilies = $DB_site->query("SELECT title, smilietext, smiliepath FROM smilie"); 


with

PHP Code:

$smilies = $DB_site->query("SELECT title, smilietext, smiliepath FROM smilie ORDER BY showid"); 


And also replace

PHP Code:

$smilies=$DB_site->query("SELECT smilietext,smiliepath FROM smilie"); 


with

PHP Code:

$smilies=$DB_site->query("SELECT smilietext,smiliepath FROM smilie ORDER BY showid"); 


3. In smilie.php (in your admin folder) replace

PHP Code:

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


with

PHP Code:

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


Below

PHP Code:

echo makelinkcode("remove","smilie.php?s=$session[sessionhash]&action=remove&smilieid=$smilie[smilieid]&perpage=$perpage&statrpage=$startpage"); 


add

PHP Code:

echo "<br>Order: <input type=text name=\"order[$smilie[smilieid]]\" size=5 value=\"$smilie[showid]\">"; 


Replace

PHP Code:

echo "</table></td></tr></table></form>"; 


with

PHP Code:

doformfooter("Update order"); 


Replace

PHP Code:

doformheader("smilie","modify"); 


with

PHP Code:

doformheader("smilie","doorder"); 


Above

PHP Code:

// ###################### Start Modify ####################### 


add

PHP Code:

// ###################### Start do order #####################
if ($HTTP_POST_VARS['action']=="doorder") {

  while (list($key,$val)=each($order)) {

    $DB_site->query("UPDATE smilie SET showid='$val' WHERE smilieid='$key'");

  }

  echo "<p>Order updated!</p>";
  $action="modify";

} 


Requested by:
JJR512

That's it! Feedback, requests and anything else is more than welcome.
Good luck!

[Xer]

WORKING ON 2.2.9

[LilTara]

I'm having the same trouble as that Ying ho person.... can someone please help. It says:

Parse error: parse error, unexpected T_VARIABLE in /home/prue/public_html/admin/functions.php on line 2091

Warning: Cannot add header information - headers already sent by (output started at /home/prue/public_html/admin/functions.php:2091) in /home/prue/ public_html/admin/functions.php on line 1593

Fatal error: Call to undefined function: getclickysmilies() in /home/prue/public_html/showthread.php on line 252

[N9ne]

I've got this working for me no problems on 2.2.8, should work on 2.2.x.

[LilTara]

I have 2.2.7.... I'm not sure if it's conflicting with another hack or if I've just done something wrong. It seems to be related to my functions.php file because when I restore the back up of that file everything works again.

Any ideas?

[N9ne]

It should work, there's no reason why it shouldn't...try re-applying the changes in functions.php, there's only two and they're just modifications to queries.

[LilTara]

I've redone it several times... so I'm pretty baffled.

Thanks though N9ne... I'll try again.

[N9ne]

Have you got any other hacks installed which have anything to do with smilies in any way?

[LilTara]

I've got the quick reply box that has smilies... I didn't install it myself though since I took the board over from a friend... so I'm not sure what version it is.

[N9ne]

When you added smilies to quick reply, did you modify functions.php ?

[LilTara]

Honestly I don't know... as I posted above, I'm not the one who installed that hack... I can probably find out though.