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!

[JulianD]

Thanks! Finally I found something useful for this hack Already installed!

[Rheinblitz]

hi there,

nice hack, but i got one error during clicking "smilies-modify" in the admin cp!

Parse error: parse error in */admin/smilie.php on line 266

the hack works great, but i cant change the settings..

plz help

[Neo]

This work of 2.2.5

[FWC]

Originally posted by neo
This work of 2.2.5

Yes, it does.

[Fatty_Bolger]

Thanks for the great hack!!

I have to agree that it woud be great if the order was carried over into the "Get More Smilie" pop-up, or is there another way to affect the popup directly?

Kinda junior at this stuff.....

Help please!!

[Admin]

Edit misc.php and replace this:

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

With this:

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

[Fatty_Bolger]

Thanks Firefly, worked a treat. Mucho Happiness :-)

[mariochiosso]

hi,
does it work with 2.2.5 release?

[Fatty_Bolger]

Mario, seems to fine on our board and it is 2.2.5. Very easy to install. :-)

[Keyser S?ze]

works great for me in 2.2.5

anyways, heresa important addition, after i have, lets say about 40 smilies or so, and i have them arranged smallest to biggest, to make it look better, well lets say i want to add another small one, i cant just give it a number and have the ones above it bumped up, it messes it up and doesnt change the others

like, if i make it num 14, it should make the one that was 14 now 15, and al the others above it should go up 1 number (after u hit the update order button)

think that could be done?