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!

[Brian Cruz]

I installed this, but it doesn't affect the order in the "get more" smilies box. Did I do something wrong, or is it not designed to do that?

[Dalius]

this works on 2.2.1 right???

[Dalius]

YEAH!
Installed on 2.2.1, works PERFECTLY!
Thanks FireCat

[Admin]

Oi!

[Rose]

*sigh* I thought I had this working, but apparently it's not.


I have installed the hack, and even got so far as testing the smilie orders and whatnot. Everything seemed to work with a few minor errors at the top of the pages, but they looked like they were unrelated.

Now, I'm afraid they are related. This is the last hack I have installed. I tried reverting to my original 'functions.php' and 'smilie.php' file, but to no avail.

Here's the errors on the homepage:

Warning: Cannot add header information - headers already sent by (output started at /home/simpson/public_html/admin/functions.php:2228) in /home/simpson/public_html/admin/functions.php on line 1498

Warning: Cannot add header information - headers already sent by (output started at /home/simpson/public_html/admin/functions.php:2228) in /home/simpson/public_html/admin/functions.php on line 1498

Warning: Cannot add header information - headers already sent by (output started at /home/simpson/public_html/admin/functions.php:2228) in /home/simpson/public_html/admin/functions.php on line 1498

This is above the header banner on the forum home page. I had turned the bulletin board to 'off' in case any errors occured. Unfortunately, now, I can't get into the admin cp!! The errors quoted above are also listed on the admin cp. When I enter my name and password, it shows the "hang on a sec" then it goes back to the normal (without errors) admin log in screen. But it just cycles again if I try to log in again.

Line 1498 is:

  if ($cookiedomain) {
    setcookie($name, $value, $expire, $cookiepath, $cookiedomain, $secure);
  } else {
    setcookie($name, $value, $expire, $cookiepath, '', $secure);
  }

The line after the 'else' is the line #1498 - I thought I'd post the surrounding code for clarification.


Any help?

[Rose]

The problem I had is now fixed. Thankfully it has nothing to do with this hack. This hack is the GREATEST!! Probably my all time fave.


One error in the script of Firefly's original post - startpage is mispelled in about the third line to find in the Smilie.php.



Excellant work

[DelusionalMind]

nice

many thanks man

I see that vb.org is using this. heh

[Shenlong]

spectacular hack firefly!

[Lucky]

Great job again.

Thank you kindly!

[blazin]

i just uploaded that file, chose the 2nd install option, got an OK message, but there is no order # field in my smilie menu. What did I do wrong?