<?php

require_once "maincore.php";
require_once "subheader.php";
require_once "side_left.php";
include LOCALE.LOCALESET."members-profile.php";

opentable("Administracja");

echo "<center><br><b>Super Administratorius</b></center><br>";
if (!isset($sortby) || !preg_match("/^[A-Z]$/", $sortby)) $sortby = "all";
$orderby = ($sortby == "all" ? "" : " WHERE user_name LIKE '".stripinput($sortby)."%'");
$result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby."");
$rows = dbrows($result);
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
   $i = 0;
   $result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby." WHERE user_level = 103  ORDER BY user_level DESC, user_name LIMIT $rowstart,20");
   while ($data = dbarray($result)) {
      $cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
      echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n";      
      echo "<tr>\n<td width='50%' align='center' class='tbl2'>\n<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a></td>";
      echo "<td align='center'  rowspan='5' class='tbl2'>\n";
      echo ($data['user_avatar'] ? "<img src='".IMAGES."avatars/".$data['user_avatar']."' alt='".$locale['u017']."'>" : $locale['u046'])."</td>\n";
      echo "<td align='center' width='50%' class='tbl2' style='white-space:nowrap'>&#193;stojimo data: ".showdate("longdate", $data['user_joined'])."</td>\n</tr>
         <tr>
<td align='center' class='tbl1'>Vieta: ".($data['user_location'] ? $data['user_location'] : $locale['u048'])."</td>
<td align='center' class='tbl1'>Prane&#240;imai &#240;aukykloje: <b>".number_format(dbcount("(shout_id)", "shoutbox", "shout_name='".$data['user_id']."'"))."</b></td>
</tr>
<tr>
<td align='center' class='tbl2'>Gimimo data: ";
      if ($data['user_birthdate'] != "0000-00-00") {
         $months = explode("|", $locale['months']);
         $user_birthdate = explode("-", $data['user_birthdate']);
         echo $months[number_format($user_birthdate['1'])]." ".number_format($user_birthdate['2'])." ".$user_birthdate['0'];
      } else {
         echo $locale['u048'];
      }
      echo "</td>
<td align='center' class='tbl2'>Komentar¸: <b>".number_format(dbcount("(comment_id)", "comments", "comment_name='".$data['user_id']."'"))."</b></td>
</tr>
<tr>
<td align='center' class='tbl1'>Paskutinis apsilankymas: ".($data['user_lastvisit'] != 0 ? showdate("longdate", $data['user_lastvisit']) : $locale['u049'])."</td>
<td align='center' class='tbl1'>Prane&#240;im¸ forume: <b>".number_format(dbcount("(post_id)", "posts", "post_author='".$data['user_id']."'"))."</b></td>
</tr></table>";
      echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>";
      if (iMEMBER) {
         echo "<tr><td align='center' class='tbl2'>\n";
         if ($data['user_hide_email'] != "1" || iADMIN) {
            echo "| <a href='mailto:".str_replace("@","&#64;",$data['user_email'])."' title='".str_replace("@","&#64;",$data['user_email'])."'>".$data['user_email']."</a> | \n";
         }
         if ($data['user_web']) {
            $urlprefix = !strstr($data['user_web'], "http://") ? "http://" : "";
            echo "<a href='".$urlprefix.$data['user_web']."' title='".$urlprefix.$data['user_web']."' target='_blank'>".$data['user_web']."</a> | ";
         }
         if (!isset($userdata['user_id']) || $data['user_id'] != $userdata['user_id']) {
            echo "| <a href='messages.php?msg_send=".$data['user_id']."' title='".$locale['u060']."'>Si¸sti asmenin¿ &#254;inut¿</a> |";
         }
            echo"<tr><td align='center' class='tbl1'><br></td></tr>";
         echo "</td>\n</tr>";
      }else{ // End IF
         echo "<tr><td align='center' class='tbl2'>\n";
         echo "<center>Kontaktas: Tik registruotiems nariams</center></td></tr>\n";
            echo"<tr><td align='center' class='tbl1'><br></td></tr>";
      }
      echo "</table>\n";
   } // End while
} else {
   echo "<center><br>\n".$locale['403']."$sortby<br><br>\n</center>\n";
} // End If
   
echo "<center><br><b>Administratoriai</b></center><br>";
if (!isset($sortby) || !preg_match("/^[A-Z]$/", $sortby)) $sortby = "all";
$orderby = ($sortby == "all" ? "" : " WHERE user_name LIKE '".stripinput($sortby)."%'");
$result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby."");
$rows = dbrows($result);
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
   $i = 0;
   $result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby." WHERE user_level = 102  ORDER BY user_level DESC, user_name LIMIT $rowstart,20");
   while ($data = dbarray($result)) {
      $cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
      echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n";      
      echo "<tr>\n<td width='50%' align='center' class='tbl2'>\n<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a></td>";
      echo "<td align='center'  rowspan='5' class='tbl2'>\n";
      echo ($data['user_avatar'] ? "<img src='".IMAGES."avatars/".$data['user_avatar']."' alt='".$locale['u017']."'>" : $locale['u046'])."</td>\n";
      echo "<td align='center' width='50%' class='tbl2' style='white-space:nowrap'>&#193;stojimo data: ".showdate("longdate", $data['user_joined'])."</td>\n</tr>
         <tr>
<td align='center' class='tbl1'>Vieta: ".($data['user_location'] ? $data['user_location'] : $locale['u048'])."</td>
<td align='center' class='tbl1'>Prane&#240;imai &#240;aukykloje: <b>".number_format(dbcount("(shout_id)", "shoutbox", "shout_name='".$data['user_id']."'"))."</b></td>
</tr>
<tr>
<td align='center' class='tbl2'>Gimimo data: ";
      if ($data['user_birthdate'] != "0000-00-00") {
         $months = explode("|", $locale['months']);
         $user_birthdate = explode("-", $data['user_birthdate']);
         echo $months[number_format($user_birthdate['1'])]." ".number_format($user_birthdate['2'])." ".$user_birthdate['0'];
      } else {
         echo $locale['u048'];
      }
      echo "</td>
<td align='center' class='tbl2'>Komentar¸: <b>".number_format(dbcount("(comment_id)", "comments", "comment_name='".$data['user_id']."'"))."</b></td>
</tr>
<tr>
<td align='center' class='tbl1'>Paskutinis apsilankymas: ".($data['user_lastvisit'] != 0 ? showdate("longdate", $data['user_lastvisit']) : $locale['u049'])."</td>
<td align='center' class='tbl1'>Prane&#240;im¸ forume: <b>".number_format(dbcount("(post_id)", "posts", "post_author='".$data['user_id']."'"))."</b></td>
</tr></table>";
      echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>";
        if (iMEMBER) {
         echo "<tr><td align='center' class='tbl2'>\n";
         if ($data['user_hide_email'] != "1" || iADMIN) {
            echo "| <a href='mailto:".str_replace("@","&#64;",$data['user_email'])."' title='".str_replace("@","&#64;",$data['user_email'])."'>".$data['user_email']."</a> | \n";
         }
         if ($data['user_web']) {
            $urlprefix = !strstr($data['user_web'], "http://") ? "http://" : "";
            echo "<a href='".$urlprefix.$data['user_web']."' title='".$urlprefix.$data['user_web']."' target='_blank'>".$data['user_web']."</a> | ";
         }
         if (!isset($userdata['user_id']) || $data['user_id'] != $userdata['user_id']) {
            echo "| <a href='messages.php?msg_send=".$data['user_id']."' title='".$locale['u060']."'>Si¸sti asmenin¿ &#254;inut¿</a> |";
         }
            echo"<tr><td align='center' class='tbl1'><br></td></tr>";
         echo "</td>\n</tr>";
      }else{ // End IF
         echo "<tr><td align='center' class='tbl2'>\n";
         echo "<center>Kontaktas: Tik registruotiems nariams</center></td></tr>\n";
            echo"<tr><td align='center' class='tbl1'><br></td></tr>";
      }
      echo "</table>\n";
   } // End while
} else {
   echo "<center><br>\n".$locale['403']."$sortby<br><br>\n</center>\n";
} // End If

echo "<center><br><b>Moderatoriai</b></center><br>";
if (!isset($sortby) || !preg_match("/^[A-Z]$/", $sortby)) $sortby = "all";
$orderby = ($sortby == "all" ? "" : " WHERE user_name LIKE '".stripinput($sortby)."%'");
$result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby."");
$rows = dbrows($result);
$result2 = dbquery("SELECT * FROM ".$db_prefix."forums");
$f_mods = array();
while ($data2 = dbarray($result2)) {
   $f_mods = ($data2['forum_moderators'] ? explode(".", $data2['forum_moderators']) : "");
   for ($i=0;$i<sizeof($f_mods);$i++) {
      $forum_mods[] = $f_mods[$i];
   }
}
$forum_mods = array_unique($forum_mods);
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
   $i = 0;
   for ($x=0;$x<sizeof($forum_mods);$x++) {
      $result3 = dbquery("SELECT user_id,user_name,user_avatar,user_joined,user_birthdate,user_lastvisit,user_location,user_email,user_web FROM ".$db_prefix."users WHERE user_id='".$forum_mods[$x]."'");   
      $rows3 = dbrows($result3);
      if ($rows3!=0) {
         $data3 = dbarray($result3);
         $cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
         echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n";     
         echo "<tr>\n<td width='50%' align='center' class='tbl2'>\n<a href='profile.php?lookup=".$data3['user_id']."'>".$data3['user_name']."</a></td>";
         echo "<td align='center'  rowspan='5' class='tbl2'>\n";
         echo ($data3['user_avatar'] ? "<img src='".IMAGES."avatars/".$data3['user_avatar']."' alt='".$locale['u017']."'>" : $locale['u046'])."</td>\n";
         echo "<td align='center' width='50%' class='tbl2' style='white-space:nowrap'>&#193;stojimo data: ".showdate("longdate", $data3['user_joined'])."</td>\n</tr>
         <tr>
         <td align='center' class='tbl1'>Vieta: ".($data3['user_location'] ? $data3['user_location'] : $locale['u048'])."</td>
         <td align='center' class='tbl1'>Prane&#240;imai &#240;aukykloje: <b>".number_format(dbcount("(shout_id)", "shoutbox", "shout_name='".$data3['user_id']."'"))."</b></td>
         </tr>
         <tr>
         <td align='center' class='tbl2'>Gimimo data: ";
         if ($data3['user_birthdate'] != "0000-00-00") {
            $months = explode("|", $locale['months']);
            $user_birthdate = explode("-", $data3['user_birthdate']);
            echo $months[number_format($user_birthdate['1'])]." ".number_format($user_birthdate['2'])." ".$user_birthdate['0'];
         } else {
            echo $locale['u048'];
         }
         echo "</td>
         <td align='center' class='tbl2'>Komentar¸: <b>".number_format(dbcount("(comment_id)", "comments", "comment_name='".$data3['user_id']."'"))."</b></td>
         </tr>
         <tr>
         <td align='center' class='tbl1'>Paskutinis apsilankymas: ".($data3['user_lastvisit'] != 0 ? showdate("longdate", $data3['user_lastvisit']) : $locale['u049'])."</td>
         <td align='center' class='tbl1'>Prane&#240;im¸ forume: <b>".number_format(dbcount("(post_id)", "posts", "post_author='".$data3['user_id']."'"))."</b></td>
         </tr></table>";
         echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>";
         if (iMEMBER) {
            echo "<tr><td align='center' class='tbl2'>\n";
            if ($data3['user_hide_email'] != "1" || iADMIN) {
               echo "| <a href='mailto:".str_replace("@","&#64;",$data3['user_email'])."' title='".str_replace("@","&#64;",$data3['user_email'])."'>".$data3['user_email']."</a> | \n";
            }
            if ($data3['user_web']) {
               $urlprefix = !strstr($data3['user_web'], "http://") ? "http://" : "";
               echo "<a href='".$urlprefix.$data3['user_web']."' title='".$urlprefix.$data3['user_web']."' target='_blank'>".$data3['user_web']."</a> | ";
            }
            if (!isset($userdata['user_id']) || $data3['user_id'] != $userdata['user_id']) {
               echo "| <a href='messages.php?msg_send=".$data3['user_id']."' title='".$locale['u060']."'>Si¸sti asmenin¿ &#254;inut¿</a> |";
            }
            echo"<tr><td align='center' class='tbl1'><br></td></tr>";
            echo "</td>\n</tr>";
         } else { // End IF
            echo "<tr><td align='center' class='tbl2'>\n";
            echo "<center>Kontakt: Tik registruotiems nariams</center></td></tr>\n";
            echo"<tr><td align='center' class='tbl1'><br></td></tr>";
         }
         echo "</table>\n";
      }
   } // End while
} else {
   echo "<center><br>\n".$locale['403']."$sortby<br><br>\n</center>\n";
} // End If
   
closetable();

require_once "side_right.php";
require_once "footer.php";
?>
