source: beta/pages/guilda.php@ 405

<?php
$id = (isset($_GET["id"])) ? $db->real_escape_string($_GET["id"]) : 0;
function count_days( $a, $b ) 
{
        $gd_a = getdate( $a );
        $gd_b = getdate( $b );
        $a_new = mktime( 12, 0, 0, $gd_a['mon'], $gd_a['mday'], $gd_a['year'] );
        $b_new = mktime( 12, 0, 0, $gd_b['mon'], $gd_b['mday'], $gd_b['year'] );
        return round( abs( $a_new - $b_new ) / 86400 );
}
if ($id != 0)
{
  $db -> select_db("realm1_characters");
  $guild_id = $id;
  $guild_data = $db -> query("SELECT `guildid`, `name`, `createdate` FROM `guild` WHERE `guildid` = ".$guild_id." LIMIT 1;") -> fetch_array();
  $members = $db -> query("SELECT guild_member.guid, guild_member.rank AS mrank, `characters`.name, SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', 35), ' ', -1) AS level, (SELECT rname FROM guild_rank WHERE guildid =".$guild_id." AND rid = mrank+1) AS rname, guild_member.pnote, guild_member.offnote FROM guild_member,`characters` LEFT JOIN guild_member k1 ON k1.`guid`=`characters`.`guid` WHERE guild_member.guildid = ".$guild_id." AND guild_member.guid=`characters`.guid ORDER BY mrank");
  $total_members = $members -> num_rows;
  $members_data = $members -> fetch_array();
  $online_mem = $db -> query("SELECT count(*) AS online_mem  FROM `guild_member`, `characters`, `guild` WHERE guild.guildid = ".$guild_id." AND guild_member.guildid = guild.guildid AND guild_member.guid = characters.guid AND characters.online = 1;") -> fetch_array();;
  // guild info
  $date_arr = explode(" ",$guild_data["createdate"]);
  $date = explode("-",$date_arr[0]);
  $time_stp = explode(":",$date_arr[1]);
  $time = mktime($time_stp[0],$time_stp[1],$time_stp[2],$date[1],$date[2],$date[0]);
  $human_date = date ("d.m.Y H:i:s",$time);
  echo "<a href=\"?page=guildy\">&lt;- Zpět na výpis</a><br />";
  echo "
  <table border=\"1\">
    <tr>
      <td colspan=\"2\"><font size=\"5\">Guilda : ".$guild_data["name"]."</font></td>
    </tr>
    <tr>
      <th>Datum založení: </th>
      <td>".$human_date."</td>
    </tr>
    <tr>
      <th>Celkem členů: </th>
      <td>".$total_members." (Online : ".$online_mem["online_mem"].")</td>
    </tr>
  </table>
  ";
  // members info
  echo "
  <table border=\"1\">
    <tr>
      <th align=\"center\">Jméno</th>
      <th align=\"center\">Rasa</th>
      <th align=\"center\">Class</th>
      <th align=\"center\">Úroveň</th>
      <th align=\"center\">Rank</th>
      <th align=\"center\">Poslední přihlášení (Dny)</th>
      <th align=\"center\">Online</th>     
    </tr>
  ";
  while ($member = $members -> fetch_row())
  {
    
    $query = $db -> query("SELECT `race`,`class`,`online`, `account`, `logout_time`, SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', 35), ' ', -1) AS level, mid(lpad( hex( CAST(substring_index(substring_index(data,' ',".(36+1)."),' ',-1) as unsigned) ),8,'0'),4,1) as gender FROM `characters` WHERE `guid` = '".$member[0]."' LIMIT 1;");
    $online = $query -> fetch_array();
          $accid = $online["account"];
          $llogin = count_days($online["logout_time"], time());
        if($llogin < 1)
        {
                $lastlogin = '<font color="#009900">'.$llogin.'</font>';
        }
        if($llogin >= 1)
        {
                $lastlogin = '<font color="#0000CC">'.$llogin.'</font>';
        }
        if($llogin > 5)
        {
                $lastlogin = '<font color="#FFFF00">'.$llogin.'</font>';
        }
        if($llogin > 15)
        {
                $lastlogin = '<font color="#FF8000">'.$llogin.'</font>';
        }
        if($llogin > 30)
        {
                $lastlogin = '<font color="#FF0000">'.$llogin.'</font>';
        }
        if($llogin > 60)
        {
                $lastlogin = '<font color="#FF00FF">'.$llogin.'</font>';
        }
        if($llogin > 90)
        {
                $lastlogin = '<font color="#8000FF">'.$llogin.'</font>';
        }
        $level = $online["level"];
        if($level > 0)
                {
                        $lev = '<font color="#FFFFFF">'.$level.'</font>';
                }
                if($level > 9)
                {
                        $lev = '<font color="#858585">'.$level.'</font>';
                }
                if($level > 19)
                {
                        $lev = '<font color="#339900">'.$level.'</font>';
                }
                if($level > 29)
                {
                        $lev = '<font color="#3300CC">'.$level.'</font>';
                }
                if($level > 39)
                {
                        $lev = '<font color="#5552FF">'.$level.'</font>';
                }
                if($level > 49)
                {
                        $lev = '<font color="#FF8000">'.$level.'</font>';
                }
                if($level > 59)
                {
                        $lev = '<font color="#FF0000">'.$level.'</font>';
                }
                if($level > 69)
                {
                        $lev = '<font color="#FF00CC">'.$level.'</font>';
                }
                if($level > 70)
                {
                        $lev = '<font color="#FFF000">'.$level.'</font>';
                }
                if ($online[6] == 0)
                {
                 $gender = "m";
    }
    else
    {
      $gender = "f";
    }
    echo "
    <tr>
      <td align=\"center\">".$member[2]."</td>
      <td align=\"center\"><img src=\"imgs/icons/".$player -> GetPlayerRace($online["race"])."-".$gender.".gif\"></td>
      <td align=\"center\"><img src=\"imgs/icons/".$player -> GetPlayerClass($online["class"]).".gif\"></td>
      <td align=\"center\">".$lev."</td>
      <td align=\"center\">".$member[4]." (".$member[1].")</td>
      <td align=\"center\">".$lastlogin."</td>
      <td align=\"center\">".(($online["online"]) ? "<img src=\"imgs/inc/on.gif\" alt=\"\" />" : "<img src=\"imgs/inc/off.gif\" alt=\"\" />")."</td>     
    </td>
    ";
  }
echo "</table>";






}
else
{echo "<meta http-equiv=\"refresh\" content=\"0;url=?page=guildy\">";}
 
 
 
  




?>