The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
$sortorder for multiple fields
Is there an easy way to set the $sortorder for multiple fields. Right now I have my $sortorder set to default on usergroup.title. The page comes up correctly with the titles put in the correct order, but then it puts the members in userid order. I'd like it to instead put them in username order (alphabetically). And, if I sort by another field, I always want the username order (alphabetically) to be my secondary order.
Here is what I have right now: Code:
$sorturl = 'shroster.php?' . $vbulletin->session->vars['sessionurl']; $sortfield = $_REQUEST['sort']; $sortorder = $_REQUEST['order']; if ($sortfield == '') { $sortfield = 'title'; } if ($sortorder == '') { $sortorder = 'asc'; } Code:
$users = $db->query_read_slave(" SELECT user.*, shroster_roster.*, usergroup.usergroupid, usergroup.title, user.options, usertextfield.*, userfield.*, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid FROM " . TABLE_PREFIX . "usergroup AS usergroup LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.usergroupid = usergroup.usergroupid OR FIND_IN_SET(usergroup.usergroupid, user.membergroupids)) LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid = user.userid) LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=user.userid) LEFT JOIN " . TABLE_PREFIX . "shroster_roster AS shroster_roster ON(shroster_roster.shCharID=userfield.field7) WHERE (usergroup.shrosterviewpermissions = 1) ORDER BY " .$sortfield. " " .$sortorder ); I appreciate any assistance. Thank you! Code:
if ($sortfield == '') { $sortfield = 'title, shname'; } if ($sortorder == '') { $sortorder = 'asc'; } I still have a problem when trying to sort different columns though. Here's a bit from my template. Code:
<a href="$sorturl&order=asc&sort=shname"><img class="inlineimg" src="$stylevar[imgdir_button]/sortasc.gif" border="0" /></a> $vboptions[shCharName] <a href="$sorturl&order=desc&sort=shname"><img class="inlineimg" src="$stylevar[imgdir_button]/sortdesc.gif" border="0" /></a></td></if> <if condition="$show['title']"><td class="thead" nowrap>$vboptions[shTitle]</td></if> <if condition="$show['rank']"><td class="thead" nowrap> <a href="$sorturl&order=asc&sort=title"><img class="inlineimg" src="$stylevar[imgdir_button]/sortasc.gif" border="0" /></a> $vboptions[shRank] <a href="$sorturl&order=desc&sort=title"><img class="inlineimg" src="$stylevar[imgdir_button]/sortdesc.gif" border="0" /></a></td></if> Code:
<if condition="$show['rank']"><td class="thead" nowrap> <a href="$sorturl&order=asc&sort=title&order=asc&sort=shname"><img class="inlineimg" src="$stylevar[imgdir_button]/sortasc.gif" border="0" /></a> $vboptions[shRank] <a href="$sorturl&order=desc&sort=title&order=asc&sort=shname"><img class="inlineimg" src="$stylevar[imgdir_button]/sortdesc.gif" border="0" /></a></td></if> |
#2
|
|||
|
|||
<font color="Red">*****************************</font>
Update: I've tried everything I could come up with but still can't get this code to sort a secondary field the way I want it. The title,shname works great for the default, but when trying to put that in place for desc, the title stays in ASC order and only the shname changes to desc. I've tried many other combinations, still no result. I also tried adding a secsort and secorder to the .php, but that didn't work either. I'm missing something. I hope someone feels generous and can offer some help. I'd gladly return the favor if I can. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|