Change the display order of message icons

Description:
This hack will allow you to set the display order of message icons.
Similar to my other hack, ordering of smilies.

Demo:


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

ALTER TABLE icon ADD showid SMALLINT not null
ALTER TABLE icon ADD INDEX (showid)
UPDATE icon SET showid=iconid

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

PHP Code:

$icons=$DB_site->query("SELECT iconid,iconpath,title FROM icon ORDER BY iconid"); 


with

PHP Code:

$icons=$DB_site->query("SELECT iconid,iconpath,title FROM icon ORDER BY showid"); 


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

PHP Code:

$icons=$DB_site->query("SELECT iconid,title,iconpath FROM icon ORDER BY title LIMIT ".($limitlower-1).",$perpage"); 


with

PHP Code:

$icons=$DB_site->query("SELECT iconid,title,iconpath FROM icon ORDER BY showid LIMIT ".($limitlower-1).",$perpage"); 


Below

PHP Code:

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


add

PHP Code:

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


Replace

PHP Code:

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


with

PHP Code:

doformfooter("Update order"); 


Replace

PHP Code:

doformheader("icon","modify"); 


with

PHP Code:

doformheader("icon","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 icon SET showid='$val' WHERE iconid='$key'");

  }

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

} 


Requested by:
theflow

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

[Lucky]

Will this work in 2.2.1 just like your smilie hack?

[Icheb]

PHP Code:

$icons=$DB_site->query("SELECT iconid,title,iconpath FROM icon ORDER BY showid LIMIT ".($limitlower-1).",$perpage"); 


Only one minor addition to the code above: You also have to query the showid from the icon table, otherwise the ids will not be displayed in the Admin CP and you have to enter all of them every time you want to change the order.

[Xer]

sorry.. it is not working on 2.2.9.
when i click "update order" no any change ..and remove all my order.

*.i am running the smile one.. it is fully Working.

[Icheb]

As I said, change the following code in your icon.php

PHP Code:

$icons=$DB_site->query("SELECT iconid,title,iconpath FROM icon ORDER BY showid LIMIT ".($limitlower-1).",$perpage"); 


to this:

PHP Code:

$icons=$DB_site->query("SELECT iconid,title,iconpath,showid FROM icon ORDER BY showid LIMIT ".($limitlower-1).",$perpage"); 


It has to query the showid from the table, otherwise it can't use it.

Icheb

[Xer]

thx Icheb!!! it is working now!!!