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!

[Hoffi]

I think you were too fast with cut'n paste.

in step three you say to change smilie.php and the variables and tables are also smilie.

[Admin]

Thanks man.

Nice feature, Now i just have to find one for what smilies show up on the front page..

Thanks!

[Alien]

Excellent job!

Nice hack Firefly!!

By any chance are you the same firefly from FFshrine BB?? If so then im Bal the FFT mod there. hehe

[Admin]

Glad you guys like this.

Balbanes:
Nope, sorry.

Its nice, but we need one to do this with smilies also...

Or atleast control the 15-20 that show up on the front page.

But this one works perfect, nice Job..

[Admin]

This hack was actually requested by someone that saw my first hack, this one:
http://www.vbulletin.com/forum/showt...threadid=25888

Great! Thanks

You seem to half alot of nice hacks, keep it up!