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!

[smx]

gthell I installed it on VB3.0 .. got the same error ...


Replace:

PHP Code:

// ###################### Start do order #####################
if ($HTTP_POST_VARS['action']=="doorder") {
while (list($key,$val)=each <http://www.php.net/each>($order)) {
$DB_site->query("UPDATE smilie SET showid='$val' WHERE smilieid='$key'");
}

echo "<p>Order updated!</p>";
$action="modify";

} 


With:

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

} 


I also got an error on line 262, but this was due to spaces ...
Try removing all spaces between lines !

[Linus]

The order seems to be changed only in the Admin CP and when Users post replies/new threads. However when clicking on more smilies the order is not updated.

[electrolov]

05-26-03 at 11:11 AM gthell said this in Post #150
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

had same error line, i deleted space from start of line to code on lines 269, 270,273.

might help if u delete the "?"'s in yr code.

[DeeperImage]

I installed it on 2.3.0 and i got no errors, but it will not accept the order commands. I keep hitting update and everything and no changes. When i first installed it some of them worked but thats it.. What can i do?

[JonUrban]

I just installed this on 2.3.0. I got the sucess message, but I cannot see anywhere to assign the smile order? Does that mean I screwed it up, or is it operator malfunction?

Thanks

[Oblivion Knight]

06-10-03 at 04:17 AM Linus said this in Post #152
The order seems to be changed only in the Admin CP and when Users post replies/new threads. However when clicking on more smilies the order is not updated.

This was answered in Post #96..

https://vborg.vbsupport.ru/showthrea...173#post251173

[Host Directory]

I am not sure what you mean Jon, i updated my forum from 2.2.9 to 2.3.0 and this hack works fine for me.

Was you upgrading your forum when you got the problem?

You can see this hack working at www.hostcompanies.com/forums (vb version 2.3.0)

[JonUrban]

Today at 12:22 AM Host Directory said this in Post #157
I am not sure what you mean Jon, i updated my forum from 2.2.9 to 2.3.0 and this hack works fine for me.

Was you upgrading your forum when you got the problem?

You can see this hack working at www.hostcompanies.com/forums (vb version 2.3.0)

It worked. I just did not realize that I had to go into MySQL and modify the tables. I thought there might be a way to do it in the vBulliten Control Panel.

Anyway, I did it through MySQL, moved the ID numbers around, and all is well. Thanks to all for the help and the hack!

:-jon

[DeeperImage]

Today at 09:43 PM JonUrban said this in Post #158
It worked. I just did not realize that I had to go into MySQL and modify the tables. I thought there might be a way to do it in the vBulliten Control Panel.

Anyway, I did it through MySQL, moved the ID numbers around, and all is well. Thanks to all for the help and the hack!

:-jon

Jon,
Would you be kind enough to tell us exactly what you did in there? thanks.

[JonUrban]

Today at 04:59 AM DeeperImage said this in Post #159
Jon,
Would you be kind enough to tell us exactly what you did in there? thanks.

Sure! Bear in mind that I am a TOTAL ROOKIE at this, I have a slight amount of experience with Microsoft SQL, but I have never used any web based stuff at all.

I applied the hack using the second option and got the success message.

Then, I used phpMyAdmin (which is software provided by my web hosting company), selected 'database', then the 'forum' database. I was then presented with a list of tables in the database. I selected the "smilie" table, browsed it, and edited the following 2 fields until they were in the order I needed. "Smilieid" and "showid".

I renumbered the ones that I wanted to move (i.e. 12,13,14,15) to numbers out of my range, them renumbered the ones I wanted to make 12,13,14,15, and finally renumbered the temporary numbered ones back to the former numbers of the ones I moved.

This may be a round about, convaluted way to do this, but it worked!!

:-jon