vb.org Archive - Random Smilies v1

Page 2 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - Random Smilies v1 (https://vborg.vbsupport.ru/showthread.php?t=79108)

Pain86

05-27-2005 03:47 PM

Quote:

Originally Posted by mholtum

just set them all to number 1 in the smiley manager, does the same thing.

no it doesnt :ermm:

o0Hubba0o

09-15-2005 11:33 PM

Quote:

Originally Posted by Pain86

no it doesnt :ermm:

Yep agreed, at one time we thought that maybe they were, but we've been watching them for awhile now and they are staying the same. This is just the hack we've looking for.

hotwheels

10-14-2005 12:27 AM

That is awesome.......i have been wanting something like this....thanks for the great work.

hotwheels

o0Hubba0o

10-23-2005 01:50 AM

Quote:

Originally Posted by hotwheels

That is awesome.......i have been wanting something like this....thanks for the great work.

hotwheels

Will this work with 3.5?

GuaRRand

10-27-2005 12:24 PM

Does this work with 3.5. also??

Zachariah

10-27-2005 01:48 PM

Does this work with 3.5. also??

No / Yes :D

Change the RED

Find:

Code:

                        // query smilies

                        $smilies = $vbulletin->db->query_read("

                                SELECT smilieid, smilietext, smiliepath, smilie.title,

                                        imagecategory.title AS category

                                FROM " . TABLE_PREFIX . "smilie AS smilie

                                LEFT JOIN " . TABLE_PREFIX . "imagecategory AS imagecategory USING(imagecategoryid)

                                ORDER BY imagecategory.displayorder, imagecategory.title, smilie.displayorder

                        ");

Replace:

Code:

// query smilies

                        $smilies = $vbulletin->db->query_read("

                                SELECT smilieid, smilietext, smiliepath, smilie.title,

                                        imagecategory.title AS category

                                FROM " . TABLE_PREFIX . "smilie AS smilie

                                LEFT JOIN " . TABLE_PREFIX . "imagecategory AS imagecategory USING(imagecategoryid)

                                ORDER BY rand()

                        ");

jugo	10-27-2005 02:33 PM

Quote:

Originally Posted by Zachariah

Does this work with 3.5. also??

No / Yes :D

I put it in a plugin....seems to work fine for me.

https://vborg.vbsupport.ru/showthrea...083#post806083

Zachariah

10-27-2005 05:15 PM

Quote:

Originally Posted by jugo

I put it in a plugin....seems to work fine for me.

https://vborg.vbsupport.ru/showthrea...083#post806083

HA! you so groovy - no file edits :D

Nice, but I prefer the file edit - One less query ran on loading the editor

ThugTheLeet

01-15-2006 12:11 AM

Thanks installed.

All times are GMT. The time now is 08:18 PM.

Page 2 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01202 seconds Memory Usage 1,737KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (9)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: