Untitled

<html>
<style>
/* Consolidation of fonts (*shielf your eyes, there are many of them!). Families, then sizes and weights */

/* Families */
html {
	font-size: 100%;
}

body {
	font-family: "Roboto", Arial, Helvetica, sans-serif;
	font-size: 13px;
}

/*
h1 {font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;}
h2 {font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;}
h3 {font-family: Arial, Helvetica, sans-serif;}
h4 {font-family: "Trebuchet MS", Verdana, Helvetica, Arial, Sans-serif;}
.pagination li.active span {font-family: "Open Sans", "Droid Sans", Verdana, Arial, Helvetica;}
.dropdown-extended .header {font-family: Arial, "Helvetica Neue", Helvetica, Arial, sans-serif;}
.notification_list p.notifications_title {font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;}
.button {font-family: "Open Sans", "Droid Sans", Verdana, Arial, Helvetica;}
li.header dt, li.header dd {font-family: Arial, Helvetica, sans-serif;}
.postbody h3 {font-family: "Trebuchet MS", Verdana, Helvetica, Arial, sans-serif;}
.content {font-family: "Lucida Grande", "Trebuchet MS", Verdana, Helvetica, Arial, sans-serif;}
.content p {font-family: "Lucida Grande", "Trebuchet MS", Verdana, Helvetica, Arial, sans-serif;}
dl.faq {font-family: "Lucida Grande", Verdana, Helvetica, Arial, sans-serif;}
p.author {font-family: Verdana, Helvetica, Arial, sans-serif;}
.notice {font-family: "Lucida Grande", Verdana, Helvetica, Arial, sans-serif;}
.attachbox dt {font-family: Arial, Helvetica, sans-serif;}
dl.file {font-family: Verdana, Arial, Helvetica, sans-serif;}
dl.file dt {font-family: Verdana, Arial, Helvetica, sans-serif;}
dl.thumbnail dd {font-family: Verdana, Arial, Helvetica, sans-serif;}
fieldset.polls {font-family: "Trebuchet MS", Verdana, Helvetica, Arial, sans-serif;}
fieldset.polls dd div {font-family: Arial, Helvetica, sans-serif;}
fieldset {font-family: Verdana, Helvetica, Arial, sans-serif;}
input {font-family: Verdana, Helvetica, Arial, sans-serif;}
select {font-family: Verdana, Helvetica, Arial, sans-serif;}
select optgroup option {font-family: Verdana, Helvetica, Arial, sans-serif;}
textarea {font-family: "Lucida Grande", Verdana, Helvetica, Arial, sans-serif;}
.message-box textarea {font-family: "Trebuchet MS", Verdana, Helvetica, Arial, sans-serif;}
a.button1, input.button1, input.button3, a.button2, input.button2 {font-family: "Lucida Grande", Verdana, Helvetica, Arial, sans-serif;}
a.forumtitle {font-family: "Trebuchet MS", Helvetica, Arial, Sans-serif;}
a.topictitle {font-family: "Trebuchet MS", Helvetica, Arial, Sans-serif;}
*/


/* Everything Else */

h1 {
	/* Forum name */
	font-weight: 600;
	font-size: 18px;
color: white;
background-color: #FFA62F;
}

h2 {
	/* Forum header titles */
	font-weight: 300;
	font-size: 2em;
}

h3 {
	/* Sub-headers (also used as post headers, but defined later) */
	font-weight: 500;
	font-size: 1.2em;
}

h4 {
	/* Forum and topic list titles */
	font-size: 1.3em;
}

p {
	font-size: 1.1em;
}

b, strong {
	font-weight: 1000;
}

i, em {
	font-style: italic;
}


.box-blue {
margin:0 0 25px;
overflow:hidden;
padding:10px;
background-color:#FFA62F;
border:1px solid #FFA62F;
-webkit-border-radius: 5px;
border-radius: 5px;
color: white;
}

.box-gray {
margin:0 0 25px;
overflow:hidden;
padding:2px;
background-color:#e8e8e8;
border:1px solid #e8e8e8;
-webkit-border-radius: 5px;
border-radius: 5px;
}

.box-red {
margin:0 0 25px;
overflow:hidden;
padding:2px;
background-color:#ffcccc;
border:1px solid #ffcccc;
-webkit-border-radius: 5px;
border-radius: 5px;
}


.box-green {
margin:0 0 25px;
overflow:hidden;
padding:20px;
width:35%;
background-color:#ffe4b2;
border:1px solid #ffe4b2;
-webkit-border-radius: 5px;
border-radius: 5px;
}


</style>
 <title>HTML with PHP</title>
 <body>


<div class="box-gray"><img src="http://dynbans.com/images/bansymbal.png"><font color="red">  <b>10 Recent Bans</b></font>


</div>

<?php
require_once("include/geoip.inc");

$servername = "localhost";

$username = "dsadsa";

$password = "dasdsa";

$dbname = "dadsa";


// Create connection

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection

if ($conn->connect_error) {

    die("Connection failed: " . $conn->connect_error);

}


$sql = "SELECT player_ip,player_nick,ban_reason,admin_nick FROM dynbans_freshbans.amx_bans WHERE expired=0 ORDER BY bid desc LIMIT 10";

$result = $conn->query($sql);


 if ($result->num_rows > 0) {
    $gi = geoip_open($config->path_root."/include/GeoIP.dat",GEOIP_STANDARD);
    // output data of each row
    echo '<table cellpadding="2" frame="box" rules="all" summary="">';
    echo '<thead><tr><th><h1>Player</h1></th><th><h1>Reason</h1></th><th><h1>Admin</h1></th></tr></thead><tbody>';
    while($row = $result->fetch_assoc()) {
	$cc = "";
	if(!empty($row["player_ip"])) {
	    $cc = geoip_country_code_by_addr($gi, $row["player_ip"]);
        }
        echo "<tr><td>" . '<img alt="" src="images/country/' . ( !empty($cc) ? echo strtolower($cc) : echo 'clear' ) . '.png" /> ' . htmlspecialchars(substr($row["player_nick"],0,11)) . "</td><td>" . htmlspecialchars(substr($row["ban_reason"],0,11)) . "</td><td>" . htmlspecialchars(substr($row["admin_nick"],0,11)) . "</td></td>";
    }
    echo '</tbody></table>';
} else {
    echo "0 results";
}

geoip_close($gi);
$conn->close();

?>

</div>

 </body>
 </html>