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!

[AzzKickr]

hi guys. is it possible to make this:
first 6 smilies will always be here and i will setup it using this hack, and other 6 will check random using random smilies hack :chinese:
sorry my bad english

[Dan_UPC]

Thanks for a great hack Firefly.

*Installs*

[Oblivion Knight]

Top stuff FireFly.
Nice and simple, yet really handy

[high]* Oblivion Knight clicks install.[/high]

[Host Directory]

I have been looking for a hack which does not seem to exist, this is kind of on the same lines so i am hoping you might be interested in this hack.

New area in admin panel.

Allows you to set the smilies in Posts to be displayed ramdomly or pick the ones you wish from your smilies list to display in the New Post area.

Also allows option to display smilies in Get More as ramdom but also allows you to select how many smilies should appear in Get More before splitting the page.

For example if you have 400 smilies and you set the number to split at 50. The result would be 8 seperate pages with the smilies on.

This is much better - i have lots of smilies and they all display on one page. Many of the smilies i have are animated and the server cannot cope with so many on one page. I think a lot of people have this problem. The result is many of the smilies do not show as a graphic.

This would be a good hack to make.

[Host Directory]

Can someone do me a massive favour and talk me through phpmyadmin - i am confused how to change the code.

I need to

ALTER TABLE smilie ADD showid SMALLINT not null
ALTER TABLE smilie ADD INDEX (showid)
UPDATE smilie SET showid=smilieid

I have never used phpmyadmin before. Can someone talk me through?

[Host Directory]

I have installed this now and its working fine on 2.2.9

Someone has told me that this hack wont work on the new version of vb 2.3.0.

Can anyone confirm this before i upgrade?

[Paraone]

EDIT: I JUST NOTICED THE POST ABOVE MINE!!!! I have version 2.3.0 and I can't get it to work, can "DA MAN" make one that works for the newest version ppppplease please please...!!! If not I understand..... now read my post, it may help you fix whatever problem it is having...

Ok i got this error:

Parse error: parse error in /home/clan-tuc/public_html/forums/admin/functions.php on line 865

Fatal error: Call to undefined function: vbdate() in /home/clan-tuc/public_html/forums/admin/sessions.php on line 400

after the 1st post install....so i put the old backup of functions back in...and the site came back up, tried it all again and same error...

Ok so then i downloaded the orsmin file...and the first link worked, but the second gave an error...so i ran the first again...then installed everything and same error...so i replaced the functions.php with the original copy and the sites backup(still the modified smilie.php)

so just for the hell of it, i went into admin...and now i have numbers below the smilies...so i tried changing the order, and it didn't work, obviously cuz i don't have the proper stuff in the functions.php....

Now when i ran the mysql queries...the last query didn't reply with ran succesful it just said :

Affected rows: 0

SQL-query : [Edit] [Create PHP Code]
UPDATE smilie SETshowid = smilieid

but i get that error....ne ideas whats going on

[Cyricx]

not getting the error codes but it definately isn't working for me, I'm on 2.3.0

it won't display their current order number or accept changes well, they get all fubared and contorted for the order lol.

No discernable pattern that I can find.

[Paraone]

well i wonder if we can get this working on 2.3.0 ...who is a super hacker that can figure it out?

[AllMadden.net]

It seems to work on 2.3 for me...but when I try to edit the smilies or add or upload in the admin menu I get this error:

Parse error: parse error, unexpected ':' in /home/virtual/site4/fst/var/www/html/madden/forums/admin/smilie.php on line 268

Any idea how to fix that?