phpBB România

Cod: Selectaţi tot

CREATE TABLE /*!32300 IF NOT EXISTS*/ server (
id int(11) NOT NULL auto_increment,
ip varchar(250) NOT NULL DEFAULT '' ,
port varchar(250) NOT NULL DEFAULT '' ,
player varchar(250) NOT NULL DEFAULT '' ,
cod varchar(250) NOT NULL DEFAULT '' ,
net varchar(250) NOT NULL DEFAULT '' ,
modul varchar(250) NOT NULL DEFAULT '' ,
tara varchar(250) NOT NULL DEFAULT '' ,
lastip varchar(16) ,
points int(11) NOT NULL DEFAULT '0' ,
PRIMARY KEY (ip),
UNIQUE id (id)

);

Cod: Selectaţi tot

<?php
include("config.php"); //db connect
$sql = "SELECT * FROM server"; 
$resursa = mysql_query($sql); 
print "<table border ='1'>";
print "<tr><td height=23 style=background-image:url(bar.png) align=center><b>No</b></td>
<td height=23 style=background-image:url(bar.png) align=center><b>Check</b></td>
<td height=23 style=background-image:url(bar.png) align=center><b>Adress</b></td>
<td height=23 style=background-image:url(bar.png) align=center><b>Port</b></td>
<td height=23 style=background-image:url(bar.png) align=center><b>Players</b></td>
<td height=23 style=background-image:url(bar.png) align=center><b>Anticheat</b></td>
<td height=23 style=background-image:url(bar.png) align=center><b>ISP</b></td>
<td height=23 style=background-image:url(bar.png) align=center><b>Mod</b></td>
<td height=23 style=background-image:url(bar.png) align=center><b>Country</b></td></tr>"; 
while ($row=mysql_fetch_array($resursa)) 
{ 
print "<tr><td>".$row['id']."</td><td><a href='/stats/stats.php?ip=".$row['ip']."&port=".$row['port']."' target='_blank'> <img src='check_server.gif' border='0'></a></td><td>".$row['ip']."</td><td>".$row['port']."</td><td>".$row['player']."</td><td>".$row['cod']."</td><td>".$row['net']."</td><td>".$row['modul']."</td><td>".$row['tara']."</td></tr>"; 
}
print "</table>"; 
?>

Cod: Selectaţi tot

SELECT * FROM servere ORDER BY id DESC LIMIT 10