<?php
//mini ranking
$host = '5.**.***.100';
$user = 'root';
$pass = '*******';
$dbid = 'player';
mysql_connect($host,$user,$pass) or die(error_connect_mysql());
mysql_select_db($dbid);


$gildie = @mysql_query("SELECT * FROM `guild`");
$row = mysql_fetch_assoc($gildie);
$index = 0;
$kolory[0] = "#f2f0f0";
$kolory[1] = "#ddfdfd";
$i = 1;
      if (mysql_num_rows($gildie)==0)
          {
              echo '<div align="center"><img src="img/empty-guild.png" width="400" height="130" alt="Ranking jest pusty" /></div>';
          }
          else {
              echo '<table width="100%" style="border: 1px solid #87ceeb;" border="0" cellspacing="0" cellpadding="0">
  <tr style="background-color:#4ca8ce; font-size: 18px;">
    <td width="62" height="50">#</td>
    <td width="145" height="50"><div align="left">Gildia</div></td>
    <td width="53" height="50">Poziom</td>
    <td width="255" height="50"><div align="center">Liczba PD</div></td>
  </tr>';
            while ($row = mysql_fetch_array($gildie))
            {
            $i++;
            $index++;
            echo '<tr style="background-color:'.$kolory[$i%2].'; height: 40px;">';
            echo '<td><div align="center">'.$index.'</div></td>';
            echo '<td><div align="left"><a href="gildie.php?details='.$row['name'].'">'.$row['name'].'</a></div></td>';
            echo '<td> '.$row['level'].' Lv</td>';
            echo '<td><strong><div align="left" style="margin-left: 100px;">'.number_format($row['exp']).' exp.</div></td>';
            echo '</tr>';
            echo "\n";
            }
          }
if(isset($_GET['details']))
    {
        $checker = $_GET['details'];
        $query = @mysql_query("SELECT * FROM `guild` where name = '$checker' limit 1");
        $row = mysql_fetch_assoc($query);
        $get_leader_id = $row['master'];
        $check_leader = @mysql_query("SELECT * FROM `player` where `id`='$get_leader_id'");
        $lider = mysql_fetch_assoc($check_leader);
        $lider_gildii = $lider['name'];
        if ($lider['id']==NULL)
        {
            $lider_gildii = 'Postać nieistnieje';
        }

        else
        {
            echo '<div style="border: 1px solid #1d1d1d;">';
            echo '<h3 align="center">Szczegóły Gildii '.$row['name'].'</h3>';
            echo "  \n";
            echo '<ul id="char_detail">';
            echo "  \n";
            echo '<li><div class="char_detail_name">Gildia: </div><div class="char_detail_value">'.$row['name'].'</div></li>';
            echo "  \n";
            echo '<li><div class="char_detail_name">Lider: </div><div class="char_detail_value">
            <a href="ranking.php?detail='.$lider_gildii.'">'.$lider_gildii.'</a></div></li>';
            echo "  \n";
            echo '<li><div class="char_detail_name">Zwyciestw: </div><div class="char_detail_value">'.$row['win'].'</div></li>';
            echo "  \n";
            echo '<li><div class="char_detail_name">Przegranych: </div><div class="char_detail_value">'.$row['loss'].'</div></li>';
            echo "  \n";
            echo '<li><div class="char_detail_name">Remisów: </div><div class="char_detail_value">'.$row['draw'].'</div></li>';
            echo "  \n";
            echo '<li><div class="char_detail_name">Energia: </div><div class="char_detail_value">'.$row['sp'].'</div></li>';
            echo "  \n";
            echo '<li><div class="char_detail_name">Punkty Rankingu: </div><div class="char_detail_value">'.$row['ladder_point'].'</div></li>';
            echo "  \n";
            echo '<li><div class="char_detail_name">Skarbiec: </div><div class="char_detail_value">'.$row['gold'].'</div></li>';
            echo "  \n";
            echo '<li><div class="char_detail_name">Oceń gildię: </div><div class="char_detail_value">'.rate('guild_'.$row['id']).'</div></li>';
            echo "  \n";
            echo '</ul>';
            echo '<div style="clear: both;"></div></div>';
            echo '<p></p>';
        }
    }
?>