smiley category hack

This hack will allow you to sort your smilies into categories. especially usefull if you have many smilies.

features are:
----------------

in admin cp:

add categories
sort categories
delete and edit categories
asign category on upload
show category in smilie overview
--> see admincp1-3.gif

in pop-up window of link [get more]:
shows a selectbox with categories
--> see screenshot popup.gif

tested with vb 2.2.9 and vb 2.3.0

hack requires database alterations
and editing of smilie.php and admin/index.php

have fun

[Arabs Emperor]

hey we wana help here any body know

[Sun Boy]

that what i was search for

thank you

[MaDCaT75]

Help! My category list is blank when it first pops up then i have to select the other category and go back to the first one to make it show up!

[MaDCaT75]

Someone help..... please?

[X-Fan]

With 200+ smilies on my forums, this is an excellent hack which works great on v2.3.0, thank you!

[X-Fan]

Whoops, spoke too soon! Everything works fine until I went to add multiple smilies, then I got this error:

Database error in vBulletin Control Panel 2.3.0:

Invalid query id specified
mysql error:

mysql error number: 0

Date: Friday 12th of September 2003 04:49:15 AM
Script: http://www.comixfan.com/xfan/forums/...min/smilie.php
Referer: http://www.comixfan.com/xfan/forums/...?action=add&s=

Looking through the thread, I see I'm not the only one with this problem. Any idea when it'll be fixed?

Also, is there a way to have smilies listed by category on the FAQ page?

[X-Fan]

No takers on fixing the bug with adding multiple smilies?

[EzX5U]

thanks man ... i was searching for a hack can do this job..

but i have a little Q..where did u got this cool collection of smiles?
i hope u or any one of the good members here to answer me


thanks
bye..

[X-Fan]

I was messing about with the code, and as luck would have it I've fixed the problem with the add multiple smilies bug!

In smilie.php, find:

 echo "<td align='center'><select name='smiliecat'>";
 while ($category = $DB_site->fetch_array($cats)) {

Replace that with:

         echo "<td align='center'><select name='smiliecat'>";
         $smiliecats=$DB_site->query("SELECT smiliegroupid AS catid, title AS catname, displayorder FROM smiliegroup GROUP by title ORDER by displayorder");
          while ($category = $DB_site->fetch_array($smiliecats)) {

That should at least get the add multiple option again, however it's not recording the category name for smilies added via the multiple option. It does add the smilies, you just need to go in and edit each one to set its category. I'm not sure how/where to fix that.

Any takers?

[Nebby]

Great hack - but i don't get a drop down box in the smilie window.