<?
/*
 *Ryan Kelley
 *ryan(at)staticsoldiers.net
 */

include("config.php");

if(empty($dbport))
        $dbport = 3306;

if($dbtype=="mysql")
{
        $plrData = array();
        $conn = mysql_connect($dbhost.":".$dbport,$dbuser,$dbpass) or die(mysql_error());
        mysql_select_db($dbname,$conn) or die(mysql_error());

        $query = "select plrid,uniqueid,rank,skill from ".$dbtblprefix."plr where allowrank=1 order by skill desc limit 10";
        $result = mysql_query($query);

        for($i=0;$row = mysql_fetch_array($result);$i++)
        {
                for($j=0;$j<4;$j++)
                {
                        $plrData[$i][$j] = $row[$j];
                }
        }

        print("<table width=\"100%\" border=\"1\" align=\"center\" cellpadding=\"5\"><tr>
        <td><b>Name</b></td><td>Kills</td><td>Skill</td></tr>");
        for($i=0;$plrData[$i][0]!=null;$i++)
        {
                $query = "select name from ".$dbtblprefix."plr_profile where uniqueid='".$plrData[$i][1]."' limit 1";
                $ans = mysql_fetch_array(mysql_query($query));
                $plrData[$i][4] = $ans[0];

                $query = "select kills,deaths,onlinetime,killsperdeath,killsperminute from ".$dbtblprefix."c_plr_data where plrid=".$plrData[$i][0];
                $ans = mysql_fetch_array(mysql_query($query));
                $plrData[$i][5] = $ans[0];
                $plrData[$i][6] = $ans[1];
                $plrData[$i][7] = $ans[2];
                $plrData[$i][8] = $ans[3];
                $plrData[$i][9] = $ans[4];


                print("
                <tr>
                        <td>".$plrData[$i][4]."</td>
                        <td>".$plrData[$i][5]."</td>
                        <td>".$plrData[$i][3]."</td>
                </tr>");
        }
}
mysql_close($conn);
function myTime($time)
{
        if($time >= 3600)
        {
                for($hour=0;$time>=3600;$hour++)
                {
                        $time -= 3600;
                }
        }
        else
        {
                $hour = "0";
        }
        if($time >=60 )
        {
                for($min=0;$time>=60;$min++)
                {
                        $time -= 60;
                }
        }
        else
        {
                $min = "00";
        }
        $sec = $time;


        return "$hour:$min:$sec";

}
?>

<?php
if (!defined('BLOCK_FILE')) {
Header("Location: ../../");
exit;
}
ob_start();
include("путь до скрипта");
$script = ob_get_contents();
ob_end_clean();
$content .= $script;
?>

print("<table width=\"100%\" border=\"1\" align=\"center\" cellpadding=\"5\"><tr>
				<td><b>Name</b></td><td>Kills</td><td>Skill</td></tr>");
				for($i=0;$plrData[$i][0]!=null;$i++)
					{
						$query = "select name from ".$dbtblprefix."plr_profile where uniqueid='".$plrData[$i][1]."' limit 1";
						$ans = mysql_fetch_array(mysql_query($query));
						$plrData[$i][4] = $ans[0];

						$query = "select kills,deaths,onlinetime,killsperdeath,killsperminute from ".$dbtblprefix."c_plr_data where plrid=".$plrData[$i][0];
						$ans = mysql_fetch_array(mysql_query($query));
						$plrData[$i][5] = $ans[0];
						$plrData[$i][6] = $ans[1];
						$plrData[$i][7] = $ans[2];
						$plrData[$i][8] = $ans[3];
						$plrData[$i][9] = $ans[4];


							print("
							<tr>
								<td>".$plrData[$i][4]."</td>
								<td>".$plrData[$i][5]."</td>
								<td>".$plrData[$i][3]."</td>
							</tr>");
					}
			print("</table>");