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!

[Admin]

I just paid a little visit to your database (with your permission of course), and something is wrong with it, so I did a little search, and it looks like you're out of space in your MySQL partition.
(if you want, search for "mysql error: can't create/write file")
I suggest you have a little talk with your host.
Oh, and while you're at it, upgrade your phpMyAdmin

Sorry.

[NYI Fan]

Firefly;
Thanks for the hack, and the incredibly easy instructions (even a newbie like me could follow them!) Having a lot of smilies is now an easily managable thing!

[maverick1236]

the random smilies are great-but if your in the middle of a post and u refresh to see another random set-you lose the post and need to start over-also could be a problem for those with the auto-refresh installed...

just a heads up!!

[Hoffi]

Just view all smilies on one Page. It's much, but it's OK and you can Edit the order completely.
I have 85 smilies on one Page, and it works excellent.

[maverick1236]

i have over 200 lol

[Hoffi]

u need a hugh Screen.

Parse error: parse error in ./admin/functions.php on line 135

Fatal error: Call to undefined function: iif() in ./admin/functions.php on line 77

WTF?
I did everything right but it screwed my database

The dreaded white screen

Can anyone help?

[Admin]

What is line 135?
And did you run the queries successfully?

yes I did run them sucessfully

I reverted back to my old functions and smilie php files but it didn't change the error

Line 135 is this

$l
if ($highlightlast) {

i am on aol im
DLRArmyWebsite if you got a sec

Thanks in advance