rendered paste body<table BORDER=10 BORDERCOLOR=#336699 CELLPadding=10 CELLSPACING=0>
<CAPTION ALIGN=top><BIG>Strike and Defensive Action</BIG></CAPTION>
<tr>
<TH BGCOLOR=#A2A2A2>Rank</TH>
<TH BGCOLOR=#AAAAAA>Name</TH>
<TH BGCOLOR=#A2A2A2>SA</TH>
<TH BGCOLOR=#AAAAAA>When</TH>
<TH BGCOLOR=#A2A2A2>Name</TH>
<TH BGCOLOR=#AAAAAA>DA</TH>
<TH BGCOLOR=#A2A2A2>when</TH>
</tr>
<?php
$ip=$_SERVER['REMOTE_ADDR'];
if ($ip=="208.101.40.202")
{
$con = mysql_connect ('localhost', ', '') or die (mysql_error());
mysql_select_db ('', $con) or die (mysql_error());
$sql=mysql_query('SELECT kocname,strike,(unix_timestamp() - time) as tt from user,playerstats,reportid where user.userid=playerstats.userid and sareport=reportid.reportid order by strike DESC limit 50;') or die (mysql_error());
$sql2=mysql_query('SELECT kocname,defence,(unix_timestamp() - time) as tt from user,playerstats,reportid where user.userid=playerstats.userid and dareport=reportid.reportid order by defence DESC limit 50;');
for ($i = 1; $i <= 50; $i++)
{
switch(fmod($i,2))
{
case 0:
ECHO "<tr><td BGCOLOR=#D2D2D2>";
break;
case 1:
ECHO "<tr><td BGCOLOR=#C2C2C2>";
break;
}
$sa= mysql_fetch_array($sql) or die(mysql_error());
$da= mysql_fetch_array($sql2) or die(mysql_error());
$v=array();
$v[]=$i;
$v[]=$sa['kocname'];
$v[]=number_format($sa['strike']);
$d=floor($sa['tt']/86400);
$h=floor(($sa['tt']-$d*86400)/3600);
$v[]= $d . " days " . $h . " hours ago.";
$v[]=$da['kocname'];
$v[]=number_format($da['defence']);
$d=floor($da['tt']/86400);
$h=floor(($da['tt']-$d*86400)/3600);
$v[]= $d . " days " . $h . " hours ago.";
for ($j = 0; $j <= 5; $j++)
{
switch(fmod($i,2))
{
case 0:
switch(fmod($j,2))
{
case 0:
echo $v[$j] . "</td><td BGCOLOR=#DDDDDD>";
break;
case 1:
echo $v[$j] . "</td><td BGCOLOR=#D2D2D2>";
break;
}
break;
case 1:
switch(fmod($j,2))
{
case 0:
echo $v[$j] . "</td><td BGCOLOR=#CCCCCC>";
break;
case 1:
echo $v[$j] . "</td><td BGCOLOR=#C2C2C2>";
break;
}
break;
}
}
echo $v[6] . "</td></tr>";
}
}
?>
</table>
<table BORDER=10 BORDERCOLOR=#336699 CELLPadding=10 CELLSPACING=0>
<CAPTION ALIGN=top><BIG>Spy and Sentry Action</BIG></CAPTION>
<tr>
<TH BGCOLOR=#A2A2A2>Rank</TH>
<TH BGCOLOR=#AAAAAA>Name</TH>
<TH BGCOLOR=#A2A2A2>Spy</TH>
<TH BGCOLOR=#AAAAAA>When</TH>
<TH BGCOLOR=#A2A2A2>Name</TH>
<TH BGCOLOR=#AAAAAA>Sentry</TH>
<TH BGCOLOR=#A2A2A2>when</TH>
</tr>
<?php
if ($ip=="208.101.40.202")
{
$sql3=mysql_query('SELECT kocname,spy,(unix_timestamp() - time) as tt from user,playerstats,reportid where user.userid=playerstats.userid and spyreport=reportid.reportid order by spy DESC limit 50;');
$sql4=mysql_query('SELECT kocname,sentry,(unix_timestamp() - time) as tt from user,playerstats,reportid where user.userid=playerstats.userid and senreport=reportid.reportid order by sentry DESC limit 50;');
for ($i = 1; $i <= 50; $i++)
{
switch(fmod($i,2))
{
case 0:
ECHO "<tr><td BGCOLOR=#D2D2D2>";
break;
case 1:
ECHO "<tr><td BGCOLOR=#C2C2C2>";
break;
}
$spy= mysql_fetch_array($sql3) or die(mysql_error());
$sentry= mysql_fetch_array($sql4) or die(mysql_error());
$v=array();
$v[]=$i;
$v[]=$spy['kocname'];
$v[]=number_format($spy['spy']);
$d=floor($spy['tt']/86400);
$h=floor(($spy['tt']-$d*86400)/3600);
$v[]= $d . " days " . $h . " hours ago.";
$v[]=$sentry['kocname'];
$v[]=number_format($sentry['sentry']);
$d=floor($sentry['tt']/86400);
$h=floor(($sentry['tt']-$d*86400)/3600);
$v[]= $d . " days " . $h . " hours ago.";
for ($j = 0; $j <= 5; $j++)
{
switch(fmod($i,2))
{
case 0:
switch(fmod($j,2))
{
case 0:
echo $v[$j] . "</td><td BGCOLOR=#DDDDDD>";
break;
case 1:
echo $v[$j] . "</td><td BGCOLOR=#D2D2D2>";
break;
}
break;
case 1:
switch(fmod($j,2))
{
case 0:
echo $v[$j] . "</td><td BGCOLOR=#CCCCCC>";
break;
case 1:
echo $v[$j] . "</td><td BGCOLOR=#C2C2C2>";
break;
}
break;
}
}
echo $v[6] . "</td></tr>";;
}
}
?>
</table>