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); }