Random Smilies - Editor Pages

rob001

New Member
Code:
===============
Author: Leo "MadK" J
Website: http://www.mafia-mp.com
Name of Modification: Random Smilies - Editor Pages

Looking for premium hosting for your vBulletin boards? 
Visit www.interserved.com for amazing plans, TODAY!

Please note: For vBulletin legal license holders and I am in no way to be held responsible for the damages caused by this modification, use it at your own risk.
===============



=============================
Random Smilies - Editor Pages
=============================

I have been using vBulletin for over four years, and realized only a few days ago, that every time you'd load the newthread/newreply page, you would get some smileys in a random position, but it was always the same smileys, over and over. This is not the greatest feature for people who have uploaded hundreds of smilies (like I did) and knowing that there's only a small portion of people that would click the 'more...' link, yet see it. This is why I decided to came up with this mod which will allow board owners who have tons of smileys on their server, to always randomize the smileys displayed on their editor pages (newthread, newreply) and never get to see the same smiley again.



============
Installation
============

Step 1

Open file: functions_editor.php in includes folder.

Step 2

FIND


			// query smilies
			$smilies = $vbulletin->db->query_read_slave("
				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 WITH

			// query smilies
			$smilies = $vbulletin->db->query_read_slave("
				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() 
			");



Step 3

ENJOY!


==============PLEASE CLICK INSTALL TO SHOW YOUR SUPPORT/APPRECIATION. I WILL NOT GIVE SUPPORT TO ANYONE THAT DOES NOT CLICK INSTALL==============

For vb 3.8, i try searching before posting, but i only so the vb 3.7 version

uploaded as file also.

:D
 
Top