$sql = "SELECT $prefix"._session.".uname, $prefix"._session.".guest, $user_prefix"._users.".user_id, $user_prefix"._users.".user_from, $user_prefix"._users.".user_chatting FROM $prefix"._session.", $user_prefix"._users." WHERE $prefix"._session.".guest=0 AND $prefix"._session.".uname = $user_prefix"._users.".username";


$result = $db->sql_query($sql);


$member_online_num = $db->sql_numrows($result);


$who_online_now = "";


$i = 1;


                                                                                                                            


while ($session = $db->sql_fetchrow($result)) {


    if (isset($session["guest"]) and $session["guest"] == 0) {


        if ($i < 10) {


        if ($session["user_chatting"]!=0 && $session["user_chatting"]!=NULL && (time()-$session["user_chatting"]) < 90 ) {


                $who_online_now .= "0$i:&nbsp;<A HREF=\"forums.html?amp;file=profile&amp;mode=viewprofile&amp;u=$session[user_id]\">".$session[uname]."</a>&nbsp;&nbsp;<a href=\"#\" onClick=\"window.open('php121sendim.php?to=$session[user_id]','$session[user_id]','left=20,top=20,width=600,height=500,toolbar=0,resizeable=0');\"><img src=\"images/blocks/ur-registered.gif\" height=\"14\" width=\"17\" border=0></a><br>\n";


        } else {


            $who_online_now .= "0$i:&nbsp;<A HREF=\"forums.html?amp;file=profile&amp;mode=viewprofile&amp;u=$session[user_id]\">".$session[uname]."</a>&nbsp;&nbsp;<a href=\"messages-post-.html$session[user_id]\"><img src=\"images/blocks/ur-admin.gif\" height=\"14\" width=\"17\" border=0></a><br>";


        }


        } else {


        if ($session["user_chatting"]!=0 && $session["user_chatting"]!=NULL && (date("U")-date("U",strtotime($session["user_chatting"])) < 90 )) {


                $who_online_now .= "$i:&nbsp;<A HREF=\"forums.html?amp;file=profile&amp;mode=viewprofile&amp;u=$session[user_id]\">".$session[uname]."</a>&nbsp;&nbsp;<a href=\"#\" onClick=\"window.open('php121sendim.php?to=$session[user_id]','$session[user_id]','left=20,top=20,width=600,height=500,toolbar=0,resizeable=0');\"><img src=\"images/blocks/ur-registered.gif\" height=\"14\" width=\"17\" border=0></a><br>\n";


        } else {


         $who_online_now .= "$i:&nbsp;<A HREF=\"forums.html?amp;file=profile&amp;mode=viewprofile&amp;u=$session[user_id]\">".$session[uname]."</a>&nbsp;&nbsp;<a href=\"messages-post-.html$session[user_id]\"><img src=\"images/blocks/ur-admin.gif\" height=\"14\" width=\"17\" border=0></a><br>";


        }


        }


        $who_online_now .= ($i != $member_online_num ? "  " : "");


        $i++;


    }


}

$sql = "SELECT SQL_NO_CACHE s.host_addr, u.user_id, u.username, u.user_allow_viewonline FROM $user_prefix"._session." s,".$user_prefix."_users u WHERE s.guest=0 AND u.username=s.uname ORDER BY u.username";


$result = $db->sql_query($sql);


$member_online_num = $db->sql_numrows($result);


$who_online_now = "";


$i = 1;


$hiddenTotal = 0;


while ($member_result = $db->sql_fetchrow($result)) {


    if ($i < 10) $zi = "0$i";


    else $zi = $i;


    if (is_admin($admin)) {


      $zi = "<a href=\"http://$whoisServerString".$member_result['host_addr']."\" title=\"".$member_result['host_addr']."\" target=\"_blank\">".$zi."</a>";


   }


   $sessionNameModified = strlen($member_result['username'])<$nameMaxLength?$member_result['username']:substr($member_result['username'],0,10)."...";


    if (!$member_result['user_allow_viewonline']&&!is_admin($admin)) {


      $hiddenTotal++;


   }


    elseif (!$member_result['user_allow_viewonline']&&is_admin($admin)) {


      $hiddenTotal++;


      $who_online_now .= "$zi:&nbsp;<a href=\"modules.php?name=Your_Account&amp;op=userinfo&amp;username=".$member_result['username']."\"><img src=\"images/blocks/icon_mini_profile.gif\" border=\"0\" alt=\""._ALT_CHKPROFILE.$member_result['username']."\" title=\""._ALT_CHKPROFILE.$member_result['username']."\"></a>&nbsp;<a href=\"modules.php?name=Private_Messages&amp;mode=post&amp;u=".$member_result['user_id']."\"><img src=\"images/blocks/nopm.gif\" border=\"0\" alt=\""._ALT_SEND.$member_result['username']."\" title=\""._ALT_SEND.$member_result['username']."\"></a>&nbsp;<a title=\""._ALT_CHKPROFILE.$member_result['username']."\" href=\"modules.php?name=Forums&amp;file=profile&amp;mode=viewprofile&amp;u=".$member_result['user_id']."\">".$sessionNameModified."</a>"._HIDDEN_ABBREV."<br />\n";


          $who_online_now .= ($i != $member_online_num ? "  " : "");


       $i++;


   }


    else {


                $who_online_now .= "$zi:&nbsp;<a href=\"modules.php?name=Your_Account&amp;op=userinfo&amp;username=".$member_result['username']."\"><img src=\"images/blocks/icon_mini_profile.gif\" border=\"0\" alt=\""._ALT_CHKPROFILE.$member_result['username']."\" title=\""._ALT_CHKPROFILE.$member_result['username']."\"></a>&nbsp;<a href=\"modules.php?name=Private_Messages&amp;mode=post&amp;u=".$member_result['user_id']."\"><img src=\"images/blocks/nopm.gif\" border=\"0\" alt=\""._ALT_SEND.$member_result['username']."\" title=\""._ALT_SEND.$member_result['username']."\"></a>&nbsp;<a title=\""._ALT_CHKPROFILE.$member_result['username']."\" href=\"modules.php?name=Forums&amp;file=profile&amp;mode=viewprofile&amp;u=".$member_result['user_id']."\">".$sessionNameModified."</a><br />\n";


       $who_online_now .= ($i != $member_online_num ? "  " : "");


       $i++;


   }


}