smiley category hack

[tkeil69575]

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

[tkeil69575]

screenshot of smiley pop-up window

[tkeil69575]

admin cp screenshot 1

[tkeil69575]

admincp screenshot 2

[S.Shady]

Nice idea. I will use this when i get more smilies :)

[tkeil69575]

admincp screenshot 3

finito

[Kars10]

This is so great!!!! :)
Thanks for sharing Tina.

* Kars10 klicks install!

[Intex]

Cool hack Tina. Will add to my install list :).

[mx3]

I've been wanting something like this for a long time! *Installs*

[Chris M]

@mx3 - Then you can look forward to this in vB3;):)

Nice idea Tina:)

Satan

[Dean C]

Great idea and great hack. Good to see another female hacker posting here :)!

- miSt

[Dan]

interesting.... I'd install it if I was running vb2 still but great hack anyways

[Kars10]

@ Chris, this is way better than the VB3 Smilie Categorys...believe me. :)

[AntiOnline]

Greetings:

How about adding a way to limit certain categories to certain forums? That way, each forum could have it's own smilie category, with smilies relevant to the content posted in that forum (sports smilies under the sports forum, video game smilies in the video game forum, etc. etc.)?

[-Sidekick-]

great hack.

[MetroSports82]

nice idea tina. :)

[SpeedStreet]

I'd still donate a kidney and/or first borne child to using a drop down vs. the smiley showcase on the replybit.

[-Sidekick-]

How does this hack effect the order of smilies that are shown in the display block of a new thread or reply screen?

[tkeil69575]

hi sidekick,
it does not effect that order at all.

greetings
tina

[-Sidekick-]

Last question. Does your hack "play along well" with FireFly's smilie hack?

https://vborg.vbsupport.ru/showthread.php?s=&threadid=25888

[Smoothie]

Today at 04:51 PM -Sidekick- said this in Post #20 (https://vborg.vbsupport.ru/showthread.php?postid=410476#post410476)
Last question. Does your hack "play along well" with FireFly's smilie hack?

https://vborg.vbsupport.ru/showthread.php?s=&threadid=25888 same question here too.

[tkeil69575]

the hack works fine together with firefly's hack. the order of smilies still works for the smilies shown directly in the post form, but is not adhered to in the pop-up window.

greets
tina

[gmarik]

Nice, damn, nice!

Is there ady idea, how to make relative the smilie paths store in the db? I mean, not "images/smilies/red" but just adding variable $redsmile, if the path maches predefined values? So if I have to later the site structure, I can only change the variable values?

[Sam FT]

Today at 03:40 AM tkeil69575 said this in Post #22 (https://vborg.vbsupport.ru/showthread.php?postid=410651#post410651)
the hack works fine together with firefly's hack. the order of smilies still works for the smilies shown directly in the post form, but is not adhered to in the pop-up window.

greets
tina

tina great hack, but there is one line that makes firefly's hack not work and it is in the smilie.php file (step 16 from your instructions)

original code:
$smilies=$DB_site->query("SELECT smilietext,smilieid,title,smiliepath FROM smilie LIMIT ORDER by title LIMIT ".($limitlower-1).",$perpage");

firefly version of the code:
$smilies=$DB_site->query("SELECT smilietext,smilieid,title,smiliepath,showid FROM smilie ORDER BY showid LIMIT ".($limitlower-1).",$perpage");

and your version of the code:
$smilies=$DB_site->query("SELECT smilietext,smilieid,smilie.title,smiliegroup.title AS catname,smiliepath,smiliecat FROM smilie LEFT JOIN smiliegroup ON smiliecat=smiliegroup.smiliegroupid ORDER by smilie.title LIMIT ".($limitlower-1).",$perpage");

[tkeil69575]

like i said pirate
the order of smilies according to fireflys hack works only in the smilies shown in the reply form and not in the pop up windows of the smiley category hack. smilies there are sorted acording to the smiley title. you could change that if you wanted by editing "ORDER BY smilie.title" to "ORDER BY smilie.showid" if you wanted. when I say it works with fireflys hack, I mean it doesnt conflict with it.

tina

[Floris]

We need moreeeeeeeeee female hackers on this community !!

[gmarik]

Tina,

Great to see, what you have done. If there could only be one person (or the vb.com team) that could unite the good features of your and the other (Avatars Category and Permission) hack. Because I would love to categorize not only smilies, but the images I upload as well.

An idea I had about this matter looks like this: we need to have just one "category" and one "metacategory" (last added, time and all other meta info about the other table) where, for example, all smilie groups have one cid incommon, all the avatar categorys have another and another feature would be good - to create subcategorys as we have subforums here. I understand that it's very hard, but you're not the only one arround, we could help. You're just on the right way :o)

[-Sidekick-]

It would be cool if users had their own category that they could modify for themselves, like a favorites category. =]

[-Sidekick-]

When I installed this, the order boxes from the FireFly hack became blank. Though when I uninstalled the hack, the boxes were no longer blank.

[tkeil69575]

hi sidekick,
i have fireflys hack installed on my board too. there should be no problem and it should not interfeer with his hack. recheck the instructions.

yes i was thinking about an integration with the favourite smilies hack, but am too busy right now for that. maybe someone else will come up with that.

greetings
tina

[MentaL]

looks good

[M.C.]

i`ve got an error when i tryed to add new smilies:

Database error in vBulletin Control Panel 2.3.0:

Invalid query id specified
mysql error:

mysql error number: 0

Date: Friday 04th of July 2003 08:32:38 PM
Script: http://localhost/forum/forum/admin/smilie.php
Referer: http://localhost/forum/admin/smilie.php?action=add&s=


after i installed that hack

[tkeil69575]

hi m.c.,
did you carry out the queries as described in the instructions?

tina

[M.C.]

2 tina

Thanx for reply! I did everything what is in instruction.

Everything work perfect exept add multiply smilies!

Good Luck!

[-Sidekick-]

I have the same problem.

[-Sidekick-]

The error is there after you specify the number of smilies to show per page when adding multiple smilies.

Also, the error doesn't show if there's no smilies to add.

Don't know if that helps you any.

[-Sidekick-]

has this hack been ditched?

[The_Huntress]

Question: Would this hack allow me to restric the use of smilies in an especific cat to certain usergroups? And if not, would it be possible to add such feature?

[Arabs Emperor]

i have same M.C. error

:confused: Pleas help us i need to add smilies
:(
++++++++++++++++++++++++++++++
There seems to have been a slight problem with the ?????????? ????? database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin Control Panel 2.3.0:

Invalid query id specified
mysql error:

mysql error number: 0

Date: Tuesday 22nd of July 2003 02:49:55 PM
Script: http://www.arabse.net/forums/forums/admin/smilie.php
Referer: http://www.arabse.net/forums/admin/smilie.php?action=add&
++++++++++++++++++++++++++++++++++++++++++

[-Sidekick-]

I think this hack has been ditched by the hacker. =] We're on our own. If I figure it out I'll let you know. =]

[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! :D

[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/xfan/forums/admin/smilie.php
Referer: http://www.comixfan.com/xfan/forums/admin/smilie.php?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.