Sticky Weight

Is there any way to give stickies different weights depending on who made them sticky. (admin vs. moderator vs. anyone else w/ the capability) so that the ones made sticky by admin are higher than the ones made sticky by mod. (all stickies are still above the other discussions)
0
This discussion has been closed.
Comments
If you add any other roles or re-order them, this won't work.
function Sticky_HideFromDiscussions(&$DiscussionManager) { global $CategoryToShow; // this function adjusts the Discussion count $SB = &$DiscussionManager->DelegateParameters['SqlBuilder']; $SB->AddJoin('User', 'us', 'UserID', 't', 'AuthUserID', 'left join'); $SB->AddOrderBy('RoleID', 'us', 'desc'); foreach ( array('0') as $CurrentBlock ) { //$SB->AddWhere('t', 'Sticky', '', 0, '=', 'and'); //$SB->AddWhere('t', 'CategoryID', '', $CategoryToShow, '=', 'or'); } }
If you want to sort by Role Priority, then you would have to Join the Role table.