Random smilies in posts/reply

I edited the original 3.0.7 code, by BluPheonix, a bit to comply with 3.5.
Tetsed it with my 3.5 site and it works fine.

In includes/functions_editor.php find:

$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, smilie.displayorder
			");

Replace it with:

$smilies = $vbulletin->db->query_read("
				SELECT smilieid, smilietext, smiliepath, smilie.title,
				imagecategory.imagetype AS category
				FROM " . TABLE_PREFIX . "smilie AS smilie
				LEFT JOIN " . TABLE_PREFIX . "imagecategory AS imagecategory USING(imagecategoryid)
				ORDER BY rand()
			");

Should work fine!!

[jugo]

I want to do this so bad, but i'd hate to have to edit files...

[high]* jugo goes to find a way to trick it into a hook....
[/high]

[high]* jugo found it!!!
[/high]

I hope I'm not stepping on toes here, but i released the plugin version here: https://vborg.vbsupport.ru/showthread.php?t=99435 :ermm:

[GuaRRand]

OUCH!!

*sees toes get crushed*

:P

[Snake]

Installed!

[GuaRRand]

Dont forget to click INSTALL pls

[sellbuydomain]

find the code, where to change it, you did not say where to change or add
'

[Bounce]

Originally Posted by sellbuydomain

find the code, where to change it, you did not say where to change or add
'

from the original thread

Change To:-

PHP Code:

$smilies = $DB_site->query("
                SELECT smilieid, smilietext, smiliepath, smilie.title,
                imagecategory.imagetype AS category
                FROM " . TABLE_PREFIX . "smilie AS smilie
                LEFT JOIN " . TABLE_PREFIX . "imagecategory AS imagecategory USING(imagecategoryid)
                ORDER BY rand()
            "); 

I take it its the same as thread from 3.0.7 :ninja:

[GuaRRand]

Hehe..sorry, will add it in the main post...

[hotwheels]

worked perfectly........thanks. hotwheels clicks *installs*

[sportsoutlaw]

I will give this one a try