I'm horrible at arrays. And I'm now using a scrip that has a lot of neat predefined functions and things that I adore and would never have time to come up with myself.
I'm facing a problem with sorting an array in it though. Can't figure out where to really go in and... determine how to get the info displayed in correct order.
the $tpl->assign_block_vars basically creates a loop out of variables to output using a html template. Now... I want all this sorted by the variable called 'CURRENT'. Can't do ORDER BY in the sql statements since it's nested within a other sql statement call etc. Any help would be apprecciated. Here's the code:
$getitem = mysql_fetch_assoc(mysql_query("SELECT * FROM witem WHERE itemname='".addslashes($item_name)."'"));
$itemdesca= $getitem['itemdesc'];
$itemdescb= str_replace("\n", "<br>", $itemdesca);
$mob= $getitem['mob'];
$itemloc=$getitem['itemloc'];
$iid=$getitem['iid'];
$itemlocup= mysql_fetch_assoc(mysql_query("SELECT * FROM wlocation WHERE lid='$itemloc'"));
$itemmobup= mysql_fetch_assoc(mysql_query("SELECT * FROM wmob WHERE mid='$mob'"));
$curmli= $user->data['user_id'];
$curmemberloggedin= mysql_fetch_assoc(mysql_query("SELECT * FROM " . MEMBER_USER_TABLE . " WHERE user_id='$curmli'"));
$curnamememli= $curmemberloggedin['member_id'];
$findcurmemlogin= mysql_fetch_assoc(mysql_query("SELECT * FROM " . MEMBERS_TABLE . " WHERE member_id='$curnamememli'"));
$curnamememli2= $findcurmemlogin['member_name'];
$findcurmemlogin2= mysql_fetch_assoc(mysql_query("SELECT * FROM " . W_PLAYER_TABLE . " WHERE pname='$curnamememli2'"));
$pid2= $findcurmemlogin2['pid'];
$reqres= mysql_query("SELECT * FROM " . W_REQUEST_TABLE . " WHERE iid='$iid'");
$bnum = mysql_num_rows($reqres);
$a =0;
while ($a < $bnum){
$rid=mysql_result($reqres,$a,"rid");
$iid=mysql_result($reqres,$a,"iid");
$pid=mysql_result($reqres,$a,"pid");
$findplayer= mysql_fetch_assoc(mysql_query("SELECT * FROM " . W_PLAYER_TABLE . " WHERE pid='$pid'"));
$pname= $findplayer['pname'];
$findmember= mysql_fetch_assoc(mysql_query("SELECT * FROM " . MEMBERS_TABLE . " WHERE member_name='$pname'"));
$member_earned= $findmember['member_earned'];
$member_spent= $findmember['member_spent'];
$member_adjustment= $findmember['member_adjustment'];
$member_current= $member_earned-$member_spent+$member_adjustment;
$tpl->assign_block_vars('wish_row', array(
'ROW_CLASS' => $eqdkp->switch_row_class(),
'MEMBER_WISH' => $pname,
'U_VIEW_MEMBER' => 'viewmember.php'.$SID.'&' . URI_NAME . '='.$findmember['member_name'],
'EARNED' => $member_earned,
'SPENT' => $member_spent,
'ADJUSTMENT' => $member_adjustment,
'CURRENT' => $member_current,
'LASTRAID' => ( !empty($findmember['member_lastraid']) ) ? date($user->style['date_notime_short'], $findmember['member_lastraid']) : ' ',
'C_ADJUSTMENT' => color_item($findmember['member_adjustment']),
'C_CURRENT' => color_item($findmember['member_current']),
'C_LASTRAID' => 'neutral')
);
++$a;
}