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!

fixed it

Apparently when I downloaded the file before modifying it was screwed. IT had boxes instead of letters in certain areas.
Very weird.
Thanks

[Admin]

Sorry for not answering, I was sleeping.

Glad you fixed it.

thanks bud

[Kengan]

cool hack ! I like it very much ! thanks man !

Help~

When I installed the hack, I got this error on the admin panal

Parse error: parse error in /home/hongkon/public_html/bbs/admin/functions.php on line 1956

Warning: Cannot add header information - headers already sent by (output started at /home/hongkon/public_html/bbs/admin/functions.php:1956) in /home/hongkon/public_html/bbs/admin/functions.php on line 1467

=========================

And I found that

Line 1956: smilies = $DB_site->query("SELECT title, smilietext, smiliepath FROM smilie ORDER BY showid");
Line 1467: setcookie($name,$value,$expire,$cookiepath);

What should I do?

[Admin]

Open your config.php file, and remove ANY whitespaces after the ?> and get back to me.

Thanks Buds. But there is no whitespaces behind <? in config.php.

Any other suggestion?

When I login to the admin panal, I got more errors.

Warning: Cannot add header information - headers already sent by (output started at /home/hongkon/public_html/bbs/admin/functions.php:1956) in /home/hongkon/public_html/bbs/admin/functions.php on line 1467

Warning: Cannot add header information - headers already sent by (output started at /home/hongkon/public_html/bbs/admin/functions.php:1956) in /home/hongkon/public_html/bbs/admin/functions.php on line 1467

Warning: Cannot add header information - headers already sent by (output started at /home/hongkon/public_html/bbs/admin/functions.php:1956) in /home/hongkon/public_html/bbs/admin/global.php on line 133

Warning: Cannot add header information - headers already sent by (output started at /home/hongkon/public_html/bbs/admin/functions.php:1956) in /home/hongkon/public_html/bbs/admin/global.php on line 159

====================================
Global.php
Line 133: setcookie("bbadminon",1,0,'/');
Line 159: setcookie("bbadminon",1,0,'/');

[Freddie Bingham]

ying_ho please enter your license information into your profile.

Great again, you have alot of nice hacks..

Install was very easy, and it is working perfect!