Smilie Category Dropdown

**amykhar** · #1 07-31-2005, 02:34 PM

This one is a beta mod that will help divide up the more smilies page.

Unfortuately, it's a code mod because the query has to change.

It's a pretty easy one to install though. Hope you like it.

This is mod may NOT be released on any other vbulletin-related site. If you would like to download it, register here and then send a PM to me asking to join my hideaway group.

Amy

Uno · #2 08-27-2005, 06:34 AM

I thought to modify it little , I would want to directly put the selection before opening the additional window.
I hope that it does not give you annoyance.

**amykhar** · #3 08-27-2005, 10:25 AM

No, it doesn't

Cyricx · #4 09-15-2005, 12:49 PM

Bug with table prefixes

Got an sql error, fixed it by changing this

Code:

 // First, I need a list of smilie categories to fill the dropdown box.
 $smiliecats = $db->query_read("SELECT imagecategory.title as category, imagecategory.imagecategoryid FROM ".TABLE_PREFIX."imagecategory where imagetype=3 ORDER BY title");

to this

Code:

 // First, I need a list of smilie categories to fill the dropdown box.
 $smiliecats = $db->query_read("SELECT imagecategory.title as category, imagecategory.imagecategoryid FROM ".TABLE_PREFIX."imagecategory AS imagecategory where imagetype=3 ORDER BY title");

Had to add the "AS imagecategory"

**amykhar** · #5 09-15-2005, 12:55 PM

Hmm. I wonder if that's a difference in mysql versions? It's running fine with no errors here. But, it should probably be there for form anyway.

Amy

Uno · #6 09-15-2005, 04:56 PM

For me work (in forum test )

I have only write 1 ".TABLE_PREFIX." after SELECT

Tank Amy is nice.... the next week i install it on the main frum

Cyricx · #7 09-15-2005, 05:58 PM

It tries to look for "imagecategory.title" rather then "vb3_imagecategory.title" without the AS statement

**amykhar** · #8 09-15-2005, 09:24 PM

Ah. I keep forgetting about table prefixes.

AngelArs · #9 10-03-2005, 09:53 PM

A lot of people who will be using this will have a lot of smilies. Just wondering, wouldn't it make more sense to first open up to a page of category links, and then the user can just open the one that they need? That way you wouldn't have to load every single smilie each time that its used.

foreverdarkness · #10 10-16-2005, 04:51 PM

I tried to install this and everytime the smile popup window opens it keeps loading the full list of smilies. When you select a category it just basically refreshes the whole smilie list and stays at the top. Any idea's to help fix this?

**amykhar** · #11 10-16-2005, 05:53 PM

Did you change the query? It doesn't sound like you did.

**amykhar** · #12 10-16-2005, 05:54 PM

Quote:

AngelArs said

A lot of people who will be using this will have a lot of smilies. Just wondering, wouldn't it make more sense to first open up to a page of category links, and then the user can just open the one that they need? That way you wouldn't have to load every single smilie each time that its used.

Not necessarily. Most people use the same few smilies over and over again. The way this is set up, it will pull up the default category first. Then, users can change categories as needed. If the smilies are orgainized right, it will save most users a click.

Amy

eure-mudder · #13 10-18-2005, 09:57 AM

Quote:

amykhar said

Not necessarily. Most people use the same few smilies over and over again. The way this is set up, it will pull up the default category first. Then, users can change categories as needed. If the smilies are orgainized right, it will save most users a click.

Amy

Here on this Site, default smilie categories shows up by default.
On my test board where I installes the Hack, no categories ist picked by default.I always have to chose one category first.
Is there any chance to change this?

**amykhar** · #14 10-18-2005, 09:59 AM

Yes. Change the number for the default id that I have. Here, the default category is 19. Check to see what yours is and change the 19 to the new number.

eure-mudder · #15 10-19-2005, 02:12 AM

Thanks amy, could have seen that myself.

TosaInu · #16 10-21-2005, 05:52 PM

Nice hack amykhar,

Can it be made to work for the smiliepage in postingrules too?
misc.php?do=showsmilies

**amykhar** · #17 10-21-2005, 06:29 PM

I'm sure you could. It's just a matter of looking at the code and patching it in.

Amy

TosaInu · #18 10-22-2005, 10:45 AM

Yes, thanks amykhar. I also extended this for the avatar page: the 1000's didn't load at first.

Lyricsmama · #19 11-02-2005, 07:20 PM

Thanks so much

Works like a charm, my members are HAPPY again lol

**amykhar** · #20 11-02-2005, 09:16 PM

Happy to be of service.

Freebird · #21 11-12-2005, 11:05 PM

Amy,
Thank you for allowing me to download this. It is installed and working perfectly at my site.

Don Nelson
VentureRider.org

SpanishHarlem · #22 11-17-2005, 12:26 PM

Thank you. Installed and working perfectly on my forum.

TosaInu · #23 01-15-2006, 01:40 PM

Can you make an extension to this amykhar? User favourite smileys in newreply?

All-the-vb made some hack for that for the 3.0.x boards. This works to some extent in 3.5, but creating the fav list is pretty different now.

**amykhar** · #24 01-15-2006, 02:40 PM

No, sorry. I am not currently doing mods because of time constraints.

TosaInu · #25 01-16-2006, 05:37 AM

Good luck with the other projects amykhar.