Random Smilies - Editor Pages

Discussion in 'vB 3.8.X Releases' started by rob001, Jun 26, 2009.

  1. rob001

    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
     
  2. XT-1

    XT-1 New Member

    i think you posted in the wrong area
    doh..
     
  3. XT-1

    XT-1 New Member

    i think you posted in the wrong area
    doh..
     
  4. afrozenminute

    afrozenminute New Member

    Great share even its in wrong forum :)
     

Share This Page