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!

[dxb]

nice simple and effective .... I'll try it now

[JJR512]

Alright, it's done, and it's great!

You know in the other thread I was about to say that the one line replacement you had originally (which added the ORDER BY bit) didn't work. I guess there was a lot more to it, though! Hope it wasn't too much trouble...but I love it! Thank you!

[Admin]

Yeah I know JJR, I forgot to replace another line.

[Hoffi]

Cool Hack and it works directly.
Good work.

kool hack m8 ur on fire with these hacks @ the mo

I was actually doing something similiar at the same time, but wanted random


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 smilieid*0+RAND() AS randcol, title, smilietext, smiliepath FROM smilie ORDER BY randcol"); 

And also replace

PHP Code:

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

with

PHP Code:

$smilies=$DB_site->query("SELECT smilieid*0+RAND() AS randcol, smilietext,smiliepath FROM smilie ORDER BY randcol"); 

[dost]

Thanks FireFly, it works great!

[snyx]

omg, do I ever want this!
but I never thought of it as a hack?
THANKS MAN!

*snyx runs off to install*

[snyx]

I tired to copy paste the queries into phpmyadmin and I get errors?