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!

[Host Directory]

The reason i am concerned about this hack is because it is a prequisit to another hack called the smilie panel - https://vborg.vbsupport.ru/showthrea...236#post361236

I really like the smilie panel hack and it was hard to set up so i dont want to loose it when i install.

Can anyone confirm this hack working in 2.30?

[Stud_Muffin]

I installed it in vb 2.3.0 and I can update the order in 'Smilies' 'Modify' and the display does reflect this in the admin CP.
The the 'Smilies' window shows the correct order but the 'get more smiles' window do not reflect this order.

[Mikado247]

There is an error in the code.

It's the reason of Parse error. look this :

Change :

PHP Code:

 while (list($key,$val)=$order)) { 


For :

PHP Code:

 while (list($key,$val)=$order) { 


and it's work !

(tested on vbulletin v2.3.0)

[Mikado247]

Well, the code who work is :

PHP Code:

while (list($key, $val) = each($order))
{
  $DB_site->query("UPDATE smilie SET showid='$val' WHERE smilieid='$key'");
} 


It's work on vbulletin 2.3.0

[Mikado247]

There are a litle bug ...

while (list($key, $val) = each($order))

[AdultInsider]

What mikado is saying is that the following might need to be done to make it work in 2.3. This is what I did:

Change

PHP Code:

while (list($key,$val)= $order) 


to
while (list($key,$val)= each($order))

[jibious]

question. my smilies are listed in order, starting at 176 (through 357). just wondering if there is a query anyone knows that i could run to just change their order, starting at 1? so basically just re-order them 1-179 rather than 176-357 (keeping the same order they are in now though...

otto

[gmarik]

FireFly, could you make it just in one .txt file for easier download?
And I wanted to ask you - how does the table building array function in HiveMail 1.2 differs from vBulletin 2.30 - can they be integrated in one way or are they just too different?

[Anjie]

Installed on 2.3.0 and works wonderfully! Thank you Firefly!!

[gthell]

Im running 2.30 and this is what i get. I checked 4+ times too.

PHP Code:

Parse error: parse error, unexpected '{' in /home/valider/public_html/forum/admin/smilie.php on line 269 


the code in smilie.php:

PHP Code:

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";
} 


i tried everything that was posted b4 me and still get that error....please help