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

PHP Code:

 $smilies = $DB_site->query("
  SELECT 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
 "); 


Line 437

PHP Code:

 $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

PHP Code:

 $smilies = $DB_site->query("
  SELECT 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.RAND, smilie.RAND "); 


and:

Line 437

PHP Code:

 $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]

Originally Posted by SiXXGuNNZ

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

[*arie]

thanks, i got it working now.

[SiXXGuNNZ]

yer my hero