Account Banned :
Code:
<?php
require_once ( 'config.php');
echo "<center><table border=1><tr><th>acc ID:</th><th>User:</th><th>Reason:</th><th>Ban Data</th><th>Unban Data</th></tr>";
$conn = mysql_connect($host, $user, $pass) or die ("Can't connect with $host");
mysql_select_db($mangosrealm, $conn);
$sqle = "SELECT `id`,`banreason`, `bandate`, `unbandate` FROM `account_banned`";
$sql = "SELECT `ab`.*, `a`.`username` FROM `account_banned` as `ab` "
."LEFT JOIN `account` as `a` ON `a`.`id` = `ab`.`id`;";
$result = mysql_query($sql, $conn);
while ($result_data = mysql_fetch_array($result))
{
echo "<tr><td align=\"center\">".$result_data["id"]."</td>";
echo "<td align=\"center\">".$result_data["username"]."</td>";
echo "<td align=\"center\">".$result_data["banreason"]."</td>";
echo "<td align=\"center\">".date("d.m.Y H:m",$result_data["bandate"])."</td>";
echo "<td align=\"center\">".date("d.m.Y H:m",$result_data["unbandate"])."</td>";
echo "</tr>";
}
mysql_close($conn);
echo "</table></center>";
?>
Arena TOP 5-10:
Code:
echo "<center><table border=1 width=70%>
<tr>
<td>Team Name</td>
<td align=center>Command Type</td>
<td align=center><center>Team Leader</center></td>
<td>Faction</td>
<td align=center>Rating</td>
</tr>";
while ($row = mysql_fetch_array($sql)){
$query_num = mysql_query("SELECT COUNT(*) FROM `arena_team_member` WHERE `arenateamid`='$row[arenateamid]'");
$gleader = "SELECT name,race FROM `characters` WHERE `guid`='$row[captainguid]'";
$myrow = mysql_fetch_array(mysql_query($gleader));
$top = mysql_query("SELECT * FROM `arena_team_stats` WHERE `arenateamid`='$row[arenateamid]'");
$toprow = mysql_fetch_array($top);
if($myrow['race']=="1" or $myrow['race']=="3" or $myrow['race']=="4" or $myrow['race']=="7" or $myrow['race']=="11"){
$faction = "alliance";
}else{
$faction = "horde";}
echo "
<tr>
<td >
<p style='padding-left: 5px'><a href='?guid=".$row[arenateamid]."' >".$row['name']."</a></p>
</td>
<td align=center><center>".$teamType[$row['type']]."</center></td>
<td><a href=".$wowd."/index.php?player=".$row[captainguid].">".$myrow['name']."</a></td>
<td align=center><center><img src=images/".$faction.".gif title=".$faction."></center></td>
<td align=right><p style='padding-right: 8px'>".$toprow['rating']."</p></td></tr>";
}
echo "</table></center><br><br>";
}
if (@$_GET['guid'] ) {
$name = "SELECT * FROM `arena_team` WHERE `arenateamid`='$_GET[guid]'";
$nrow = mysql_fetch_array(mysql_query($name));
$top = "SELECT * FROM `arena_team_stats` WHERE `arenateamid`='$_GET[guid]'";
$trow = mysql_fetch_array(mysql_query($top));
$member = "SELECT * FROM `arena_team_member` WHERE `arenateamid`='$_GET[guid]'";
$mrow = mysql_fetch_array(mysql_query($member));
$sql = mysql_query("SELECT * FROM `characters`, `arena_team_member` WHERE `characters`.`guid`=`arena_team_member`.`guid` and `arenateamid` = '".$_GET["guid"]."' ");
$row = mysql_fetch_array($sql);
$data = explode(' ',$row['data']);
$lvl = $data[$ver];
$gender = dechex($data[36]);
$gender = str_pad($gender,8, 0, STR_PAD_LEFT);
$gender = $gender{3};
$guid = $row['guid'];
$race = $row['race'];
$class = $row['class'];
$online = $row['online'];
$j=1;
echo "<center>
<table border=0 width=60%>
<tr>
<td>
<table border=1 width=100%>
<tr><td>Team Name</td><td >".$nrow['name']."</td></tr>
<tr><td>Rating</td><td >".$trow['rating']."</td></tr>
<tr><td>Command Type</td><td >".$teamType[$nrow['type']]."</td></tr>
<tr><td colspan=2 >Statistics of the Week</td></tr>
<tr><td>Played: ".$trow['games']."</td><td >Won: ".$trow['wins']."</td></tr>
<tr><td colspan=2 >Stats</td></tr>
<tr><td>Played: ".$trow['played']."</td><td >Won: ".$trow['wins2']."</td></tr>
</table>
";
echo "<table border=1 width=100%>
<tr>
<td align=center>#</td>
<td align=center>Player Name</td>
<td align=center>lvl</td>
<td align=center>Race</td>
<td align=center>Class</td>
<td align=center>Game of the Week</td>
<td align=center>Won week</td>
<td align=center>Games for the season</td>
<td align=center>Won season</td>
<td align=center>Personal rating</td>
<td align=center>Online</td>
</tr>
";
echo "<tr>
<td valign=center width=3%>$j</td>
<td align=center valign=center width=20%><a href='/wow/wowd/?player=".$guid."' style='color: #ff9900; font-family : Geneva; text-decoration : none;'>".$row[name]."</a></td>
<td width=20 align=center valign=center>$lvl</td>
<td align=center valign=center width=7%><img src=images/race/".$race."-".$gender.".gif></td>
<td align=center valign=center width=7%><img src=images/class/$class.gif></td>
<td align=center width=20%>".$mrow['played_week']."</td>
<td valign=center width=20%>".$mrow['wons_week']."</td>
<td valign=center width=10%>".$mrow['played_season']."</td>
<td valign=center width=10%>".$mrow['wons_season']."</td>
<td valign=center width=10%>".$mrow['personal_rating']."</td>
<td valign=center width=10%><center><img src='images/status/".$online.".gif' height='18' width='18'></center></td>
</tr>
";
echo "</table></td></tr></table></center><br><br><br>";
echo "<table border=1><tr><td><a href='index.php'>Index</a></td></tr></table>";
}
?>
</body>
</html>
Config:
code:
<?php
$ip = "localhost";
$port = "3306";
$host = "localhost";
$user = "root";
$pass = "root";
$mangoscharacters = "characters";
$mangosrealm = "realmd";
$cod = 'utf8';
?>
Tak to je vše co jsem v PHP dokazal napsat.Až napíšu neco dalšího tak se vam se svýma výtvorama znovu pochlubim
edit: Upraven text hozeno do kode