Random

[SnowBot]

I was looking for a random smilie thing for VB3 and couldnt find anything but i did notice this post here

https://vborg.vbsupport.ru/showpost....51&postcount=2

I was wondering where and what i would change for it to work for VB3 RC2? Thanks for any help, i appreciate it.

[NTLDR]

Two variations, based on if you want random smilies in each group or random smilies from any group respectivly:

In includes/functions_editor.php find:

PHP Code:

                LEFT JOIN " . TABLE_PREFIX . "imagecategory AS imagecategory USING(imagecategoryid)
                ORDER BY imagecategory.displayorder, smilie.displayorder 


Replace with (for random smilies within each group):

PHP Code:

                LEFT JOIN " . TABLE_PREFIX . "imagecategory AS imagecategory USING(imagecategoryid)
                ORDER BY imagecategory.displayorder, RAND() 


Or replace with (for random smilies from any group):

PHP Code:

                LEFT JOIN " . TABLE_PREFIX . "imagecategory AS imagecategory USING(imagecategoryid)
                ORDER BY RAND() 


Untested but should work.

[Zachery]

well there is a trick that requires no hackign make all the smilies id 1 when your saving them they will rotate now

[SnowBot]

NTLDR thats great, i was looking in that file but didnt see that bit at all. Time to get an upgrade to RC2 on my glasses also

Appreciated

THANKS

Snowy

[SiXXGuNNZ]

I wanna hump u, thanks