guild

<style>
body {
    margin: 0;
    background:#ddd;
}
h2 {
    margin:5px;
}
table {
    border-collapse:collapse;
    background:#333;
    color:#BBB;
}
th {
    border-left:1px solid #000;
    border-right:1px solid #000;
    border-bottom:1px solid #000;
    color:#fe5;
}
#border {
    border-left:1px solid #000;
    border-right:1px solid #000;
    border-bottom:1px solid #000;
}
#border td {
    border-left:1px solid #000;
    border-right:1px solid #000;
}
a:link {
    color:#BBB;
}
a:hover {
    color:#BBB;
    text-decoration:none;
}
a:active {
    color:#BBB;
}
a:visited {
    color:#BBB;
}
</style>
<?php
$host = 'localhost';
$user = 'root';
$pass = '';
$cdb = 'characters';

$connect = mysql_connect($host,$user,$pass) or die('Нет подключения к базе данных');
mysql_select_db ($cdb, $connect) or die(mysql_error());
if (!addslashes($_GET['guid'])){
    $guild = mysql_query("SET NAMES cp1251");
    $guild = mysql_query("SELECT * FROM `guild` ORDER BY `createdate` LIMIT 100", $connect) or die(mysql_error());
    print "<h2 align=\"center\">Список гильдий</h2>
    <table cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"600\"><tr>
    <th width=\"30\">№</th>
    <th>Название</th>
    <th width=\"120\">Создатель</th>
    <th width=\"120\">Дата создания</th>
    </tr></table>";
    $id = 1;
    while ($result = mysql_fetch_array($guild)){
        $id = $result['guildid'];
        $name = $result['name'];
        $leader_guid = $result['leaderguid'];
        $date = date("H:i:s d.m.Y", $result['createdate']);

        $leader_name = mysql_query("SELECT * FROM `characters` WHERE `guid` = $leader_guid", $connect) or die(mysql_error());
        $result_leader = mysql_fetch_array($leader_name);
        $leader = $result_leader['name'];

        print "<table cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"600\" id=\"border\"><tr>
        <td align=\"center\" width=\"30\">$id</td>
        <td align=\"center\"><a href=\"?guid=$id\" title=\"Состав гильдии\">$name</a></td>
        <td align=\"center\" width=\"120\">$leader</td>
        <td align=\"center\" width=\"120\">$date</td>
        </tr></table>";
    $id++;
    }
}else{
    $guild_name = mysql_query("SET NAMES cp1251");
    $guild_name = mysql_query("SELECT * FROM `guild` WHERE `guildid` = ".$_GET['guid']."", $connect) or die(mysql_error());
    $result_guild_name = mysql_fetch_array($guild_name);
    $guild_member = mysql_query("SET NAMES cp1251");
    $guild_member = mysql_query("SELECT * FROM `guild_member`, `characters` WHERE `characters`.`guid`=`guild_member`.`guid` AND `guild_member`.`guildid` = ".$_GET['guid']." ORDER BY `rank`", $connect) or die(mysql_error());
    print "<h2 align=\"center\">Состав гильдии <font color=\"red\">".$result_guild_name['name']."</font></h2>
    <table cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"800\"><tr>
    <th width=\"30\">№</th>
    <th>Имя</th>
    <th width=\"30\">Лвл</th>
    <th width=\"120\">Раса</th>
    <th width=\"120\">Класс</th>
    <th width=\"100\">Сторона</th>
    <th width=\"100\">Ранк</th>
    </tr></table>";

    $id = 1;
    while ($result_member = mysql_fetch_assoc($guild_member)){

        $member_rank = mysql_query("SELECT * FROM `guild_rank` WHERE `guildid` = ".$_GET['guid']."", $connect) or die(mysql_error());
        $guildranks = array();
        while($result_rank = mysql_fetch_array($member_rank))
        {
            $guildranks[$result_rank["rid"]] = $result_rank["rname"];
        }
        $name = $result_member['name'];
        $level = $result_member['level'];
        $rank = $guildranks[$result_member['rank']];

        if ($result_member['race'] == 1 || $result_member['race'] == 3 || $result_member['race'] == 4 || $result_member['race'] == 7 || $result_member['race'] == 11){
            $side = 'Альянс';
            $style_side = 'blue';
        }
        else{
            $side = 'Орда';
            $style_side = 'red';
        }

        switch ($result_member['race']){
            case 1: $race = 'Человек';break;
            case 2: $result_member['gender'] == 0 ? $race = 'Орк' : $race = 'Орчиха';break;
            case 3: $race = 'Дворф';break;
            case 4: $result_member['gender'] == 0 ? $race = 'Ночной эльф' : $race = 'Ночная эльфийка';break;
            case 5: $result_member['gender'] == 0 ? $race = 'Отрекшийся' : $race = 'Отрекшаяся';break;
            case 6: $race = 'Таурен';break;
            case 7: $race = 'Гном';break;
            case 8: $result_member['gender'] == 0 ? $race = 'Тролль' : $race = 'Троллиха';break;
            case 10: $result_member['gender'] == 0 ? $race = 'Эльф крови' : $race = 'Эльфийка крови';break;
            case 11: $result_member['gender'] == 0 ? $race = 'Дреней' : $race = 'Дренейка';break;
        }

        if ($result_member['class'] == 1){
            $class = 'Воин';
            $style_class = '#C79C6E';
        }
        if ($result_member['class'] == 2){
            $class = 'Паладин';
            $style_class = '#F58CBA';
        }
        if ($result_member['class'] == 3){
            $class = 'Охотник';
            $style_class = '#ABD473';
        }
        if ($result_member['class'] == 4){
            $class = 'Разбойник';
            $style_class = '#FFF569';
        }
        if ($result_member['class'] == 5){
            $class = 'Жрец';
            $style_class = '#FFFFFF';
        }
        if ($result_member['class'] == 6){
            $class = 'Рыцарь смерти';
            $style_class = '#C41F3B';
        }
        if ($result_member['class'] == 7){
            $class = 'Шаман';
            $style_class = '#0070DE';
        }
        if ($result_member['class'] == 8){
            $class = 'Маг';
            $style_class = '#69CCF0';
        }
        if ($result_member['class'] == 9){
            $class = 'Чернокнижник';
            $style_class = '#9482C9';
        }
        if ($result_member['class'] == 11){
            $class = 'Друид';
            $style_class = '#FF7D0A';
        }

        print "<table cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"800\" id=\"border\"><tr>
        <td align=\"center\" width=\"30\">$id</td>
        <td align=\"center\">$name</td>
        <td align=\"center\" width=\"30\">$level</td>
        <td align=\"center\" width=\"120\">$race</td>
        <td align=\"center\" width=\"120\"><font color=\"$style_class\">$class</font></td>
        <td align=\"center\" width=\"100\"><font color=\"$style_side\">$side</font></td>
        <td align=\"center\" width=\"100\">$rank</td>
        </tr></table>";
    $id++;
    }
    print "<p align=\"center\"><a href=\"".$_SERVER['PHP_SELF']."\" title=\"Вернуться\"><font color=\"black\">Вернуться</font></a></p>";
}
mysql_close($connect);
?>