PsychoStats GunGame Mod

<?php


define("PSYCHOSTATS_PAGE", true);
include(dirname(__FILE__) . "/includes/common.php");
include(PS_ROOTDIR . "/includes/class_Color.php");
$cms->init_theme($ps->conf['main']['theme'], $ps->conf['theme']);
$ps->theme_setup($cms->theme);
$cms->theme->page_title('PsychoStats - Gungame Stats');
include("config.php");
include("includes/class_pagination.php");

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error());

mysql_select_db($dbname);


if (!$conn) {
   echo "Failed";
}


// MYSQL QUERIES
$total_gg = mysql_query("SELECT * FROM gg_stats");
$total_plrs = mysql_query("SELECT * FROM ps_c_plr_data");
$total_svr_plrs = mysql_num_rows($total_plrs);
$total_gg_records = mysql_num_rows($total_gg);

//my pageination
$page = 1;
$size = 100;

//start empty string
$output = '';

// we get the current page from $_GET
if (isset($_GET['page'])){
    $page = (int) $_GET['page'];
}

// create the pagination class
$pagination = new Pagination();
$pagination->setLink("gungame.php?page=%s");
$pagination->setPage($page);
$pagination->setSize($size);
$pagination->setTotalRecords($total_gg_records);

// now use this SQL statement to get records from your table
$SQL = mysql_query("SELECT * FROM gg_stats ORDER BY `streak` DESC " . $pagination->getLimitSql()."");

//output links
$navigation = $pagination->create_links();

//ranks
$p = $_GET['page'];
if(empty($p) || $p == 1)
   {
    $p = 0;
    $rank = 0;
    }
    else
    {
    $rank = ($p - 1) * 50;
    }    

$output .= "<table class='ps-table ps-player-table'>
     <tr>
     <th>Rank</th>
    <th>Nickname</th>
    <th>Streak</th>
    <th>Wins</th>
    <th>Points</th>
<!-- <th>TeamPlay Wins</th>
    <th>Teamplay Points</th>
    <th>TeamPlay Streak</th>
-->
    </tr>";

while ($Plr = mysql_fetch_array($SQL))
{
    
    if($rank % 2)
        {
          $output .="<tr>";
        }
        else
        {
         $output .="<tr class='even'>";
         }

    $rank++;
    $output .="
    <td>$rank</td>
    <td>".$Plr['name']."</td>
    <td>".$Plr['streak']."</td>
    <td>".$Plr['wins']."</td>
    <td>".$Plr['points']."</td>
<!--    <td>".$Plr['wins_tp']."</td>
    <td>".$Plr['points_tp']."</td>
    <td>".$Plr['streak_tp']."</td>
-->
    </tr>";
}
//print "$output";
$output .="</table>";

$cms->theme->assign('gg_stats_output', $output);
$cms->theme->assign('total_svr_plrs', $total_svr_plrs);
$cms->theme->assign('total_gg_plrs', $total_gg_records);
$cms->theme->assign('pager', $navigation);

$basename = basename(__FILE__, '.php');
$cms->full_page($basename, $basename, $basename.'_header', $basename.'_footer');
//authid    wins    name    timestamp    points    streak    wins_tp    points_tp    streak_tp    serverip

mysql_close($conn);
?>