function ranking()
{
$ranking_board = '';
$conn = get_connection();
$sql = "SELECT * FROM Users ORDER BY marks DESC LIMIT 0,10";
$result = mysqli_query($conn, $sql);
if ($result->num_rows > 0) {
$ranking_board .= '<table id="ranking-board">';
$ranking_board .= '<tr>';
$ranking_board .= ' <th>STT</th><th>Tài khoản</th><th>Điểm</th><th>Bậc kỹ năng</th>';
$ranking_board .= '</tr>';
$num = 1;
while ($row = $result->fetch_assoc()) {
$ranking_board .= '<tr>';
$ranking_board .= ' <td align="center">' . $num . '</td><td>' . $row['username'] . '</td><td align="right">' . $row['marks'] . '</td>';
$ranking_board .= ' <td align="center">' . get_skill($row['username']) . '</td>';
$ranking_board .= '</tr>';
$num++;
}
$ranking_board .= '</table>';
}
$conn->close();
return $ranking_board;
}
// Set for every page
require 'engine/common.php';
$selectedGameId = 0;
$skillLevel = 0;
$day = 0;
$position = '';
$dayColumn = '';
if (isset($_POST['action']) && $_POST['action'] == "Search Subs") {
if ($_POST && $_POST['game'] && $_POST['game'] > 0) {
$selectedGameId = $_POST['game'];
$smarty->assign('selectGameID', $selectedGameId);
$smarty->assign('selectGameInfo', getSelectedGameInfo($selectedGameId));
}
if ($_POST && $_POST['skill'] && $_POST['skill'] > 0 && $_POST['skill'] < 6) {
$skillLevel = $_POST['skill'];
$skillLevelName = get_skill($skillLevel);
$smarty->assign('skillLevel', $skillLevel);
$smarty->assign('skillLevelName', $skillLevelName);
}
if ($_POST && $_POST['day'] && $_POST['day'] > 0 && $_POST['day'] < 8) {
$day = $_POST['day'];
$dayOfWeek = get_day_of_week($day);
$dayColumn = get_day_column($day);
$smarty->assign('day', $day);
$smarty->assign('dayOfWeek', $dayOfWeek);
}
/*
if($_POST && $_POST['pos'] && $_POST['pos'] == 'G' || $_POST['pos'] == 'D' || $_POST['pos'] == 'C' || $_POST['pos'] == 'W' || $_POST['pos'] == 'AF') {
$position = $_POST['pos'];
if($position == 'AF') {
$smarty->assign('positions', 'All Forwards');
function run_report()
{
global $smarty;
global $Link;
global $SEASON;
global $ADDRESS;
global $EMAIL;
global $HOMEPHONE;
global $WORKPHONE;
global $CELLPHONE;
global $SKILLLEVEL;
global $POSITION;
global $JERSEYSIZE;
global $JERSEYNUMBER1;
global $JERSEYNUMBER2;
global $JERSEYNUMBER3;
global $PAYMENTPLAN;
global $DRILLEAGUE;
global $USAHOCKEYMEMBERSHIP;
global $DB_COLUMNS;
global $REPORT;
$select = 'SELECT ' . $DB_COLUMNS . ' FROM ' . REGISTRATION . ' WHERE seasonId=' . $SEASON;
$select .= ' AND fName != "Open"';
if ($REPORT == 1) {
$select .= ' ORDER BY lName';
} else {
if ($REPORT == 2) {
$select .= ' AND wantToBeATeamRep = 1 ORDER BY lName';
} else {
if ($REPORT == 3) {
$select .= ' AND wantToBeARef = 1 ORDER BY lName';
} else {
if ($REPORT == 4) {
$select .= ' ORDER BY skillLevel DESC, lName';
} else {
if ($REPORT == 5) {
$select .= ' ORDER BY paymentPlan, lName';
} else {
if ($REPORT == 6) {
$select .= ' ORDER BY lName';
} else {
if ($REPORT == 7) {
$select .= ' AND drilLeague > 1 ORDER BY drilLeague, lName';
} else {
if ($REPORT == 8) {
$select .= ' ORDER BY usaHockeyMembership ASC, lName';
}
}
}
}
}
}
}
}
$result = mysql_query($select, $Link) or die("sp_clubs (Line " . __LINE__ . "): " . mysql_errno() . ": " . mysql_error());
if ($result && mysql_num_rows($result) > 0) {
$count = 0;
$smarty->assign('count', array());
$smarty->assign('id', array());
$smarty->assign('fname', array());
$smarty->assign('lname', array());
if ($ADDRESS == true) {
$smarty->assign('address', array());
}
if ($EMAIL == true) {
$smarty->assign('email', array());
}
if ($HOMEPHONE == true) {
$smarty->assign('homephone', array());
}
if ($WORKPHONE == true) {
$smarty->assign('workphone', array());
}
if ($CELLPHONE == true) {
$smarty->assign('cellphone', array());
}
if ($SKILLLEVEL == true) {
$smarty->assign('skilllevel', array());
}
if ($POSITION == true) {
$smarty->assign('position', array());
}
if ($JERSEYSIZE == true) {
$smarty->assign('jerseysize', array());
}
if ($JERSEYNUMBER1 == true) {
$smarty->assign('jerseynumber1', array());
}
if ($JERSEYNUMBER2 == true) {
$smarty->assign('jerseynumber2', array());
}
if ($JERSEYNUMBER3 == true) {
$smarty->assign('jerseynumber3', array());
}
if ($PAYMENTPLAN == true) {
$smarty->assign('paymentplan', array());
}
if ($DRILLEAGUE == true) {
$smarty->assign('drilleague', array());
}
if ($USAHOCKEYMEMBERSHIP == true) {
$smarty->assign('usaHockeyMembership', array());
}
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$count++;
$id = $row['registrationId'];
$fname = $row['fName'];
$lname = $row['lName'];
$smarty->append('count', $count);
$smarty->append('id', $id);
$smarty->append('fname', $fname);
$smarty->append('lname', $lname);
if ($ADDRESS == true) {
$smarty->append('address', $row['addressOne'] . ' ' . $row['addressTwo'] . '<br />' . $row['city'] . ', ' . $row['state'] . '<br />' . $row['postalCode']);
}
if ($EMAIL == true) {
if (isset($row['eMail']) && strlen($row['eMail']) > 0) {
$email = $row['eMail'];
} else {
$email = ' ';
}
$smarty->append('email', $email);
}
if ($HOMEPHONE == true) {
if (isset($row['homePhone']) && strlen($row['homePhone']) > 0) {
$homePhone = $row['homePhone'];
} else {
$homePhone = ' ';
}
$smarty->append('homephone', $homePhone);
}
if ($WORKPHONE == true) {
if (isset($row['workPhone']) && strlen($row['workPhone']) > 0) {
$workPhone = $row['workPhone'];
} else {
$workPhone = ' ';
}
$smarty->append('workphone', $workPhone);
}
if ($CELLPHONE == true) {
if (isset($row['cellPhone']) && strlen($row['cellPhone']) > 0) {
$cellPhone = $row['cellPhone'];
} else {
$cellPhone = ' ';
}
$smarty->append('cellphone', $cellPhone);
}
if ($SKILLLEVEL == true) {
$smarty->append('skilllevel', get_skill($row['skillLevel']));
}
if ($POSITION == true) {
$smarty->append('position', $row['position']);
}
if ($JERSEYSIZE == true) {
$smarty->append('jerseysize', $row['jerseySize']);
}
if ($JERSEYNUMBER1 == true) {
$smarty->append('jerseynumber1', $row['jerseyNumberOne']);
}
if ($JERSEYNUMBER2 == true) {
$smarty->append('jerseynumber2', $row['jerseyNumberTwo']);
}
if ($JERSEYNUMBER3 == true) {
$smarty->append('jerseynumber3', $row['jerseyNumberThree']);
}
if ($PAYMENTPLAN == true) {
$smarty->append('paymentplan', $row['paymentPlan']);
}
if ($DRILLEAGUE == true) {
$smarty->append('drilleague', $row['drilLeague']);
}
if ($USAHOCKEYMEMBERSHIP == true) {
if (isset($row['usaHockeyMembership']) && strlen($row['usaHockeyMembership']) > 0) {
$usaHockeyMembership = $row['usaHockeyMembership'];
} else {
$usaHockeyMembership = 'NONE';
}
$smarty->append('usaHockeyMembership', $usaHockeyMembership);
}
}
$smarty->assign('count', $count);
}
}
<?php require 'libs/checklogin.php'; require 'libs/functions.php'; $username = isset($_SESSION["username"]) ? $_SESSION["username"] : ''; echo get_skill($username);
function strike_prepare(&$pa, &$pd, $active)
{
if (eval(__MAGIC__)) {
return $___RET_VALUE;
}
eval(import_module('weapon', 'logger'));
if ($active) {
$log .= "使用{$pa['wep']}<span class=\"yellow\">" . $attinfo[$pa['wep_kind']] . "</span>{$pd['name']}！<br>";
} else {
$log .= "{$pa['name']}使用{$pa['wep']}<span class=\"yellow\">" . $attinfo[$pa['wep_kind']] . "</span>你！<br>";
}
$pd['deathmark'] = $wepdeathstate[$pa['wep_kind']];
$pa['attackwith'] = $pa['wep'];
$pa['fin_skill'] = get_skill($pa, $pd, $active);
$pa['fin_hitrate'] = get_hitrate($pa, $pd, $active);
$chprocess($pa, $pd, $active);
}
