About this Page
This is a discussion on Sorting online users within the Nuke 7.x - Blocks forums, part of the PHP-Nuke 7.x category; Hi. I have the user_info block and modified it so that it displays a small U.S. Army rank graphic ...

aramis · #1 (**permalink**) 10-04-2004, 04:19 PM

Hi.

I have the user_info block and modified it so that it displays a small U.S. Army rank graphic next to the user that is currently online . The problem I now have is that I want to sort the users according to rank i.e. when a Sergeant comes on he should be displyed above the Privates. Another problem is if two Sergeants are online or two or three Privates I need to sort not only by the rank but also by the lastname. Any suggestions on how I might be able to do this? Both the username and rankimage are in the same table. I have tried ORDER BY but no change.

Here is the part of the script that I have now, you can view the block at www.32bat.com

Code:

$who_online_now = "";
$i = "1";

while ( $session = sql_fetch_array( $result2, $dbi ) )
{
   if ( isset($session["guest"]) and $session["guest"] == 0 )
   {
            $FlagResult = sql_query( "select user_ranksmall from ".$prefix."_users where username = '$session[uname]'", $dbi );
      $FlagInfo =   sql_fetch_array( $FlagResult, $dbi );
      
   
      $FlagPath = "/nuke/images/rankssmall/";
     if ( $FlagInfo[user_ranksmall] == "0" )
   {
          $FlagPathFile = "/nuke/images/flags/guest";}
else
      {

$FlagPathFile = $FlagPath.$FlagInfo[user_ranksmall];
      }

           $resultuser_id = sql_query( "SELECT user_id FROM ".$prefix."_users where username='$session[uname]'", $dbi );
      list( $user_id ) = sql_fetch_row( $resultuser_id, $dbi );
     
      $who_online_now .= "<img src=\"$FlagPathFile.gif\" ><A HREF=\"modules.php?name=Private_Messages&file=index&mode=post&&u=$user_id\">$session[uname]</a>
\n";
      $who_online_now .= ( $i != $member_online_num ? "  " : "" );
      $i++;
   }
}

[/code]

telli · #2 (**permalink**) 10-05-2004, 01:47 PM

First off your adding alot of queries. Every user needs to run those queries to view the block so lets get rid of the two above. In the bloc above this section you posted look for the main query call to the session table and change that with this one:

Code:

$result = $db->sql_query("SELECT s.uname, s.guest, u.user_id, u.username, u.user_ranksmall FROM $prefix"._session." AS s LEFT JOIN ".$prefix."_users AS u ON u.username = s.uname WHERE guest='0'");

Now we have them all in one query. Now for the ranking you will need to make either another table or another field to associate what rank is what and what order they should list in. Hope that helps.

Telli

About this PageThis is a discussion on Sorting online users within the Nuke 7.x - Blocks forums, part of the PHP-Nuke 7.x category; Hi. I have the user_info block and modified it so that it displays a small U.S. Army rank graphic ...

Sorting online users

About this Page
This is a discussion on Sorting online users within the Nuke 7.x - Blocks forums, part of the PHP-Nuke 7.x category; Hi. I have the user_info block and modified it so that it displays a small U.S. Army rank graphic ...