Random Smilies in reply boxes for vb3

[SiXXGuNNZ]

<a href="https://vborg.vbsupport.ru/showthread.php?t=34161" target="_blank">for vb2</a>

I assume it is line 244 or 437 or both on misc.php in the root folder, I just do not know what to change :ermm:

[SiXXGuNNZ]

Line 244

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

Line 437

$smilies = $DB_site->query("
SELECT smilietext AS text, smiliepath AS path, smilie.title, smilieid,
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
");

I would think the right way to do this hack would be:

Line 244

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

and:

Line 437

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

[SiXXGuNNZ]

yeah, this don't work, does anybody know the fix?

[SiXXGuNNZ]

am I really the only one who likes to have random smilies appear? :(

[Zachery]

am I really the only one who likes to have random smilies appear? :(
set their id to 1 all of them they will appear randomly

[Gio Takahashi]

How would I do that?

[NTLDR]

I posted the code to change in another thread yesterday.

[Gio Takahashi]

I had to search through your post to find it, and it worked.

For those who are wondering what thread it is, its This one (https://vborg.vbsupport.ru/showthread.php?t=60201)

[*arie]

thanks, i got it working now. :D

[SiXXGuNNZ]

yer my hero :)

[gmarik]

where is the final version?

[SiXXGuNNZ]

where is the final version?
https://vborg.vbsupport.ru/showpost.php?p=462320&postcount=2