{ function __construct() { $this->open('../../fitdayDB.db'); } } $db = new MyDB(); if (!$db) { echo $db->lastErrorMsg(); } $type = $_GET['type']; if ($type == "top3") { getTop3($db); } if ($type == "rank") { getRank($db); } if ($type == "timeline") { $pagenum = $_GET['page']; getPageN($pagenum, $db); } function getRank($db) { $userid = $_SESSION['users']; $nowdate = date('Y-m-d', time()); $datetime = strtotime(date("Y-m-d", time())); //获取当前日期并转换成时间戳 $tomorrow = date('Y-m-d', $datetime + 86400); //在时间戳的基础上加一天(即60*60*24) $searchsql = "Select userid,sum(calorie) as allcal from Exercise where ( userid='{$userid}' or userid in (select friendid from Friendship where userid = '{$userid}')) and endTime<'{$tomorrow}' and endTime>='{$nowdate}' group by userid order by allcal desc"; $result = $db->query($searchsql);
?> <div class="modal fade" id="<?php print $b["_t"]; ?> " tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title" id="myModalLabel"> <?php if ($currentBadge != null || $b["Secret"] != true) { ?> <img src="<?php print getRank($b["Level"]); ?> " /> <?php print $b["Name"]; } else { print 'Badge Oculto'; } ?> </h4> </div> <div class="modal-body"> <?php if ($currentBadge != null || $b["Secret"] != true) { print $b["Content"]; } else {
$throttled = true; error_log("<br>" . $e->getMessage()); } if (!$users) { $users = getFollowers($nick, $connfb); } // keys try { $keys = getKeys($nick, null, $client); } catch (Exception $e) { $throttled = true; error_log($e->getMessage()); $keys = getKeys($nick, $conn); } // turtle $rank = getRank($users); $ledger = getLedger($webid, $conn); $project = getProject($ledger); $main = 'http://gitpay.org/' . $user['login'] . '#this'; $githubaccount = 'http://github.com/' . $user['login']; if ($webid && $webid['bitcoin']) { $bitcoin = $webid['bitcoin']; } if ($webid && $webid['preferredURI']) { $preferredURI = $webid['preferredURI']; } $turtle = getTurtle($user, $webid, $users, $keys); insertKeys($keys, $nick, $conn); writeTurtle($turtle); if (!empty($_SESSION['login'])) { activateUser('https://gitpay.org/' . $_SESSION['login'] . '#this', $conn);
/// /// [History] /// Date Version Author Content /// ---------- ------- -------- ------------------------------------ /// 2009/11/16 1.1 龙首成 学生管理 // header('Content-Type: text/html; charset=utf-8'); require "include/sessionstud.php"; require "include/function.include.php"; require_once "stud_addapp.class.php"; $citem = new selitem(); $itype = $_SESSION['itype']; $iname = $_SESSION['icode']; $stuno = $_SESSION["studno"]; $studcode = $_SESSION["studcode"]; $irank = $_SESSION['irank']; $trank = getRank($irank); //$showitem=$citem->finditem($icode); if ($_POST['submit']) { // echo $showtime=date("Y-d-m H:i:s"); $itemcode = $citem->setitem($itype, $iname, $irank); $itenc = $itemcode[0]['item_code']; //echo $itenc; // print_r($itemcode); $insertok = $citem->insertapp($itype, $itenc, $studno, $studcode, $showtime); //写入表 } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
function getPlayerClass($playerName) { $pid = getPid($playerName); if ($pid == 0) { return 0; } $tournRank = 1; $strictRank = 1; $query = "SELECT u.username, u.user_onirc, u.user_email, u.user_game_type, u.user_blurb, u.user_viewblurb, u.user_viewemail, s.open_num_games, s.open_num_bases, s.open_num_pills, s.open_num_tanks, s.tourn_num_games, s.tourn_score, s.tourn_wins, s.tourn_loses, s.tourn_num_bases, s.tourn_num_pills, s.tourn_num_tanks, s.strict_num_games, s.strict_wins, s.strict_loses, s.strict_num_bases, s.strict_num_pills, s.strict_num_tanks, s.strict_score, u.user_regdate, u.user_icq, u.user_aim, u.user_website, u.user_occ, u.user_from, u.user_yim, u.user_msnm, u.user_sig, u.user_emailforward, u.user_showforward from stats_player s, users u where s.pid = u.user_id and u.user_id = " . $pid; $result = mysql_query($query); $pc = new PlayerInfoClass(); $pc->setStuff($pid, mysql_result($result, 0, "username"), mysql_result($result, 0, "user_email"), mysql_result($result, 0, "user_game_type"), mysql_result($result, 0, "user_blurb"), mysql_result($result, 0, "user_viewblurb"), mysql_result($result, 0, "user_viewemail"), mysql_result($result, 0, "open_num_games"), mysql_result($result, 0, "open_num_pills"), mysql_result($result, 0, "open_num_bases"), mysql_result($result, 0, "open_num_tanks"), mysql_result($result, 0, "tourn_num_games"), mysql_result($result, 0, "tourn_wins"), mysql_result($result, 0, "tourn_loses"), mysql_result($result, 0, "tourn_score"), mysql_result($result, 0, "tourn_num_pills"), mysql_result($result, 0, "tourn_num_bases"), mysql_result($result, 0, "tourn_num_tanks"), $tournRank, mysql_result($result, 0, "strict_num_games"), mysql_result($result, 0, "strict_score"), mysql_result($result, 0, "strict_wins"), mysql_result($result, 0, "strict_loses"), mysql_result($result, 0, "strict_num_pills"), mysql_result($result, 0, "strict_num_bases"), mysql_result($result, 0, "strict_num_tanks"), $strictRank, mysql_result($result, 0, "user_icq"), mysql_result($result, 0, "user_aim"), mysql_result($result, 0, "user_yim"), mysql_result($result, 0, "user_website"), mysql_result($result, 0, "user_occ"), mysql_result($result, 0, "user_msnm"), mysql_result($result, 0, "user_regdate"), mysql_result($result, 0, "user_sig"), mcHasTopLevelCollection($pid), mysql_result($result, 0, "user_emailforward"), mysql_result($result, 0, "user_showforward")); $pc->setOnIrc(mysql_result($result, 0, "user_onirc")); // Get number of posts $query = "SELECT count(*) AS total FROM posts where poster_id = " . $pid; $result = mysql_query($query); $pc->setNumPosts(mysql_result($result, 0, "total")); if ($pc->getNumPosts() > 0) { // Get Posting statistics $result = mysql_query("SELECT count(*) AS total FROM posts"); $pc->setPercentPosts($pc->getNumPosts() / mysql_result($result, 0, "total") * 100); if ((time() - strtotime($pc->getRegisteredDate())) / (24 * 60 * 60) < 1) { $pc->setPostsPerDay($pc->getNumPosts()); } else { $pc->setPostsPerDay($pc->getNumPosts() / ((time() - strtotime($pc->getRegisteredDate())) / (24 * 60 * 60))); } mysql_free_result($result); } $teams = array(); $query = "select t.name from stats_team t, team_members m where t.tid = m.tid and m.pid = '{$pid}' order by t.name"; $result = mysql_query($query); $count = 0; while ($count < mysql_numrows($result)) { $teams[$count] = mysql_result($result, $count, "name"); $count++; } $pc->setTeams($teams); // Get ranks $pc->setTournRank(getRank("stats_player", "tourn_score", $pc->getTournScore(), $pid, "pid", "tourn")); $pc->setStrictRank(getRank("stats_player", "strict_score", $pc->getStrictScore(), $pid, "pid", "strict")); $pc->setPageViews(getPageViews("view_player", $pid)); # Get Active Games $activeGames = array(); $activeSql = "SELECT g.gs_ip, g.gs_port, g.gs_key from game_server g, active_player p where p.ap_left = 0 and p.ap_pid = '{$pid}' and g.gs_key = p.ap_serverkey"; $activeResult = mysql_query($activeSql); $count = 0; while ($count < mysql_numrows($activeResult)) { $activeGames[$count] = mysql_result($activeResult, $count, "gs_ip"); $activeGames[$count + 1] = mysql_result($activeResult, $count, "gs_port"); $activeGames[$count + 2] = mysql_result($activeResult, $count, "gs_key"); $count += 3; } $pc->setActiveGames($activeGames); return $pc; }
if ($list->uid1 == Request::getParam('user')->id) { $id = $list->uid2; if ($list->countMsg1 > 0) { $count = ' <span class="mail_count">+' . $list->countMsg1 . '</span>'; } } else { $id = $list->uid1; if ($list->countMsg2 > 0) { $count = ' <span class="mail_count">+' . $list->countMsg2 . '</span>'; } } echo '<div class="tile">'; echo '<div class="tileImg">'; echo '<img src="' . getAvatar($id) . '">'; echo '<a href="' . url($id) . '"></a>'; echo '</div>'; echo '<div class="tileInfo">'; echo '<div><a class="tileName" href="' . url('mail' . $id) . '">' . $list->nickname . '</a>' . $count . '</div>'; echo '<div>' . getRank($list->elo) . '</div>'; echo '<a class="mailBtn" href="{URL:mail' . $id . '}" title="{L:INDEX_SEND_MAIL}"></a>'; echo '<a class="challengeBtn" href="">{L:INDEX_CHALLENGE}</a>'; echo '</div>'; echo '</div>'; //printTime($list->time) //$list->message } echo '</div>'; echo '<div class="pagin">' . Pagination::printPagination() . '</div>'; } else { echo '{L:INDEX_NO_DIALOGS}'; }
function profile() { // The usual suspects. global $MySelf; global $DB; // Set the ID. $ID = sanitize($_GET[id]); numericCheck($_GET[id], 0); // Load the profile. $profile = new profile($ID); $username = ucfirst(idToUsername($ID)); // Cache our permissions. $canSeeUsers = $MySelf->canSeeUsers(); // Need the api. $api = new api($ID); // Create table header. $table = new table(2, true); $table->addHeader(">> About " . $username); $table->addRow(); $table->addCol("Current rank:"); $table->addCol(getRank($ID)); $table->addRow(); $table->addCol("Last login:"******"SELECT lastlogin FROM users WHERE id='" . $ID . "' AND deleted='0' LIMIT 1"); $table->addCol(date("d.m.y. H:i:s", $lastLog[0])); $table->addRow(); $table->addCol("Total logins:"); $lastLog = $DB->getCol("SELECT COUNT(authkey) FROM auth WHERE user='******' LIMIT 1"); $table->addCol(number_format($lastLog[0], 0)); $table->addRow(); $table->addCol("Valid api-key on file:"); $table->addCol(yesno($api->valid(), true)); $table->addRow(); $table->addCol("Is available for mining:"); if ($profile->isOwn()) { if ($profile->MinerFlag()) { $temp = " [<a href=\"index.php?action=modprofile&id=" . $ID . "&mining=false\">set not available</a>]"; } else { $temp = " [<a href=\"index.php?action=modprofile&id=" . $ID . "&mining=true\">set available</a>]"; } } $table->addCol(yesno($profile->MinerFlag(), true) . $temp); $table->addRow(); $table->addCol("Is available for hauling:"); if ($profile->isOwn()) { if ($profile->HaulerFlag()) { $temp = " [<a href=\"index.php?action=modprofile&id=" . $ID . "&hauling=false\">set not available</a>]"; } else { $temp = " [<a href=\"index.php?action=modprofile&id=" . $ID . "&hauling=true\">set available</a>]"; } } $table->addCol(yesno($profile->HaulerFlag(), true) . $temp); $table->addRow(); $table->addCol("Is available for fighting:"); if ($profile->isOwn()) { if ($profile->FighterFlag()) { $temp = " [<a href=\"index.php?action=modprofile&id=" . $ID . "&fighting=false\">set not available</a>]"; } else { $temp = " [<a href=\"index.php?action=modprofile&id=" . $ID . "&fighting=true\">set available</a>]"; } } $table->addCol(yesno($profile->FighterFlag(), true) . $temp); if ($profile->emailVisible() || $profile->isOwn()) { if ($profile->isOwn()) { if ($profile->emailVisible()) { $temp = " (public) [<a href=\"index.php?action=modprofile&id=" . $ID . "&email=hide\">hide from public</a>]"; } else { $temp = " (hidden) [<a href=\"index.php?action=modprofile&id=" . $ID . "&email=show\">make public</a>]"; } } $table->addRow(); $table->addCol("Email address:"); $email = $DB->getCol("SELECT email FROM users WHERE id='" . $ID . "' LIMIT 1"); $table->addCol($email[0] . $temp); } // Statistics. $stats = new table(2, true); $stats->addHeader(">> Statistical breakdown"); $miningRunsJoined = $DB->getCol("SELECT COUNT(id) FROM joinups WHERE userid='" . $ID . "'"); $miningRunsJoined = $miningRunsJoined[0]; $OpjoinUps = $DB->getCol("SELECT COUNT(id) FROM joinups WHERE userid='" . $ID . "'"); $OpjoinUps = $OpjoinUps[0]; $joinUps = $DB->getCol("SELECT COUNT(id) FROM (SELECT * from joinups WHERE userid='" . $ID . "' GROUP BY run) as uJoinups"); $joinUps = $joinUps[0]; $haulingRuns = $DB->getCol("SELECT COUNT(id) FROM hauled WHERE hauler='" . $ID . "'"); $haulingRuns = $haulingRuns[0]; $timeMining = $DB->getCol("SELECT SUM(parted - joined) FROM joinups WHERE userid='" . $ID . "' AND parted >1"); $timeMining = $timeMining[0]; $timesKicked = $DB->getCol("SELECT COUNT(id) FROM joinups WHERE userid='" . $ID . "' AND status='1'"); $timesKicked = $timesKicked[0]; $timesRemoved = $DB->getCol("SELECT COUNT(id) FROM joinups WHERE userid='" . $ID . "' AND status='2'"); $timesRemoved = $timesRemoved[0]; $timesBanned = $DB->getCol("SELECT COUNT(id) FROM joinups WHERE userid='" . $ID . "' AND status='3'"); $timesBanned = $timesBanned[0]; $timesCharity = $DB->getCol("SELECT COUNT(id) FROM (SELECT * from joinups WHERE userid='" . $ID . "' GROUP BY run) as uJoinups WHERE userid='" . $ID . "' AND charity='1'"); $timesCharity = $timesCharity[0]; $tmec = $DB->getCol("SELECT AVG(tmec) FROM runs WHERE isOfficial = 1"); $tmecJoined = $DB->getCol("SELECT AVG(runs.tmec) FROM joinups, runs WHERE joinups.userid='" . $ID . "' AND joinups.run = runs.id AND runs.endtime > 0 AND runs.isOfficial = 1"); $tmecNotJoined = $DB->getCol("SELECT AVG(runs.tmec) FROM joinups, runs WHERE joinups.userid='" . $ID . "' AND joinups.run <> runs.id AND runs.endtime > 0 AND runs.isOfficial = 1"); $tmecDiff = $tmecJoined[0] - $tmecNotJoined[0]; $stats->addRow(); $stats->addCol("Mining operations joined:"); if ($miningRunsJoined > 0) { $stats->addCol(number_format($joinUps, 0)); } else { $stats->addCol("never joined."); } $stats->addRow(); $stats->addCol("Total operations joinups:"); if ($OpjoinUps > 0) { $stats->addCol(number_format($OpjoinUps, 0)); } else { $stats->addCol("never joined."); } $stats->addRow(); $stats->addCol("Hauling runs:"); if ($haulingRuns > 0) { $stats->addCol(number_format($haulingRuns, 0)); } else { $stats->addCol("never hauled."); } $stats->addRow(); $stats->addCol("Time spent mining:"); if ($timeMining > 0) { $stats->addCol(numberToString($timeMining)); } else { $stats->addCol("never mined."); } $stats->addRow(); $stats->addCol("Average TMEC:"); $stats->addCol(number_format($tmec[0], 3)); $stats->addRow(); $stats->addCol("Average TMEC on Ops <b>with</b> " . $username . ":"); $stats->addCol(number_format($tmecJoined[0], 3)); $stats->addRow(); $stats->addCol("Average TMEC on Ops <b>without</b> " . $username . ":"); $stats->addCol(number_format($tmecNotJoined[0], 3)); $stats->addRow(); $stats->addCol("TMEC difference:"); if ($tmecDiff >= 0) { $stats->addCol("<font color=\"#00ff00\">" . number_format($tmecDiff, 3), true . "</font>"); } else { $stats->addCol("<font color=\"#ff0000\">" . number_format($tmecDiff, 3), true . "</font>"); } $stats->addRow(); $stats->addCol("Times removed from OP:"); $stats->addCol(number_format($timesRemoved, 0)); $stats->addRow(); $stats->addCol("Times kicked from OP:"); $stats->addCol(number_format($timesKicked, 0)); $stats->addRow(); $stats->addCol("Times banned from OP:"); $stats->addCol(number_format($timesBanned, 0)); $stats->addRow(); $stats->addCol("Times declared charity:"); $stats->addCol(number_format($timesCharity, 0)); /* * Assemble the heavy-duty SQL query. * It is dynamic because this way we can easily add ores from * config-system.php to the system without code rewrite. */ /* global $DBORE; global $ORENAMES; foreach ($DBORE as $ORE) { $new = $ORE; if ($last) { $SQLADD .= "SUM(" . $last . ") AS total" . $last . ", "; } $last = $new; } $SQLADD .= "SUM(" . $last . ") AS total" . $last . " "; $SQL = "SELECT " . $SQLADD . " FROM hauled WHERE hauler='" . $ID . "'"; // Now query it. $totalOREDB = $DB->query("$SQL"); if (DB::isError($totalOREDB)) { * * This is not what you would really want to do in * your program. It merely demonstrates what kinds * of data you can get back from error objects. * echo 'Standard Message: ' . $totalOREDB->getMessage() . "\n"; echo '\n '; echo 'Standard Code: ' . $totalOREDB->getCode() . "\n"; echo '\n '; echo 'DBMS/User Message: ' . $totalOREDB->getUserInfo() . "\n"; echo '\n '; echo 'DBMS/Debug Message: ' . $totalOREDB->getDebugInfo() . "\n"; echo '\n '; exit; } // Create table. $totalOre_table = new table(2, true); $totalOre_table->addHeader(">> Total ore hauled"); // Loop through the result (single result!) if ($totalOREDB->numRows() > 0) { while ($totalORE = $totalOREDB->fetchRow()) { // Now check each ore type. foreach ($ORENAMES as $ORE) { // And ignore never-hauled ore if ($totalORE[total . $ORE] > 0) { // We got some ore! $totalOre_table->addRow(); $totalOre_table->addCol("<img width=\"20\" height=\"20\" src=\"./images/ores/" . $ORE . ".png\">Total " . $ORE . " hauled:"); $totalOre_table->addCol(number_format($totalORE[total . $ORE])); $gotOre = true; } } } if ($gotOre) { $oretable_r = "<br>" . $totalOre_table->flush(); } } */ // Image thingy. // We serve small images IGB. global $IGB; global $IGB_VISUAL; if ($IGB && $IGB_VISUAL) { $image = "<img src=\"portrait:" . $api->getCharacterID() . "\" SIZE=\"128\">"; } else { $image = $profile->getImage("large"); } $picTable = new table(true, 1); $picTable->addHeader(">> Picture of " . $username); $picTable->addRow(); $picTable->addCol($image); $imageTable = $picTable->flush(); // About if ($profile->GetAbout() && !$profile->isOwn()) { $aboutTable = new table(1, true); $aboutTable->addHeader(">> " . $username . " says..."); $aboutTable->addRow(); $aboutTable->addCol(nl2br($profile->GetAbout())); $aboutTable = "<br>" . $aboutTable->flush(); } if ($profile->isOwn()) { $aboutTable = new table(1, true); $aboutTable->addHeader(">> Enter a public viewable text here"); $aboutTable->addRow(); $form = "<form action=\"index.php\" method=\"POST\">"; $form .= "<input type=\"hidden\" name=\"check\" value=\"true\">"; $form .= "<input type=\"hidden\" name=\"action\" value=\"modprofile\">"; $form .= "<input type=\"hidden\" name=\"id\" value=\"" . $ID . "\">"; $aboutTable->addCol("<textarea rows=\"18\" cols=\"80\" name=\"about\">" . $profile->GetAbout() . "</textarea>"); $aboutTable->addHeaderCentered("<input type=\"submit\" name=\"submit\" value=\"Update about\">"); $aboutTable = "<br>" . $form . $aboutTable->flush() . "</form>"; } // quick "jump to" -thingy. $peeps = $DB->query("SELECT DISTINCT username,id FROM users WHERE deleted = 0 AND canLogin = 1 ORDER BY username ASC"); if ($peeps->numRows() > 0) { while ($p = $peeps->fetchRow()) { if ($ID == $p[id]) { $pdm .= "<option SELECTED value=\"" . $p[id] . "\">" . ucfirst($p[username]) . " (current)</option>"; } else { $pdm .= "<option value=\"" . $p[id] . "\">" . ucfirst($p[username]) . "</option>"; } } $pdm = "<select name=\"id\">" . $pdm . "</select></form>"; $quickChooser = new table(1, true); $quickChooser->addHeader(">> Quick jump to profile"); $quickChooser->addRow(); $quickChooser->addCol($pdm); $quickChooser->addHeaderCentered("<input type=\"submit\" name=\"submit\" value=\"Switch\">"); $quickChooser = "<form action=\"index.php\" method=\"GET\"><input type=\"hidden\" name=\"action\" value=\"profile\">" . $quickChooser->flush() . "</form>"; } $page = "<h2>View profile</h2>" . $quickChooser . $imageTable . "<br>" . $table->flush() . "<br>" . $stats->flush() . $oretable_r . $aboutTable; return $page; }
/** * 生成searchtitle,keyword,description等信息. * * @access private * @return array */ function getSearchTitle($info, $rankid, $priceid, $attrid) { global $searchkey, $dest_id; $arr = array(); $rankname = getRank($rankid); $searchtitle = "{$info['seotitle']}|"; if ($priceid != 0) { $pricearr = getMinMaxprice($priceid); if ($pricearr['min'] != "" && $pricearr['max'] == "") { $price .= "价格在{$pricearr['min']}以上"; } else { $price .= "价格范围在{$pricearr['min']}-{$pricearr['max']}之间"; } $searchtitle .= $price; } if ($rankname != "") { $searchtitle .= "{$rankname}|"; } if (!empty($attrid)) { $searchtitle .= getHotelAttrName($attrid); } //$arr['searchtitle']=$searchtitle; // if(!empty($searchkey)) //如果针对的是名称搜索 //{ //$arr['searchtitle']="{$searchkey}酒店列表"; // $arr['subtitle']="{$searchkey}酒店列表"; //} // return $arr; return $searchtitle; }
<th>#</th> <th>{L:LADDERS_USER}</th> <th>{L:LADDERS_WINS}</th> <th>{L:LADDERS_TIES}</th> <th>{L:LADDERS_LOSSES}</th> <th>{L:LADDERS_RANK}</th> </tr> <?php while ($list = mysqli_fetch_object($this->ladder_list)) { echo '<tr>'; echo '<td>' . ++Pagination::$start . '</td>'; echo '<td>' . ($list->country ? '<img src="' . _SITEDIR_ . 'public/images/country/' . mb_strtolower($list->country) . '.png">' : '') . ' <a href="' . url($list->id) . '">' . $list->nickname . '</a></td>'; echo '<td>' . $list->wins . '</td>'; echo '<td>' . $list->ties . '</td>'; echo '<td>' . $list->losses . '</td>'; echo '<td>' . getRank($list->elo) . '</td>'; echo '</tr>'; } ?> </table> </div> <div class="last-battles"> <style scoped> .lastMatches{ margin:0 0 25px 0; text-align: center; } .nicknames{ font-size: 16px; } </style>
<?php if (!defined('IN_PHPBB')) { exit; } $query = "SELECT * FROM " . $TableNames['roster'] . " ORDER BY name"; $result = $db->sql_query($query); while ($row = $db->sql_fetchrow($result)) { if ($row['active'] == 0) { $template->assign_block_vars('n_exMembers', array('NAME' => $row['name'], 'REALM' => $row['realm'], 'LEVEL' => $row['level'], 'ILEVEL' => $row['iLevel'], 'CLASS' => $row['class'], 'CLASSNAME' => getGermanClass(getClassById($row['class'])), 'RACE' => $row['race'], 'RACENAME' => getGermanRace(getRaceById($row['race'])), 'GENDER' => $row['gender'], 'LASTSEENTIMESTAMP' => strtotime($row['cache']), 'LASTSEEN' => $user->format_date(strtotime($row['cache']), false, true))); } else { $template->assign_block_vars('n_members', array('NAME' => $row['name'], 'RANK' => $row['rank'], 'RANKNAME' => getRank($row['rank'], $ranks), 'REALM' => $row['realm'], 'LEVEL' => $row['level'], 'ILEVEL' => $row['iLevel'], 'CLASS' => $row['class'], 'CLASSNAME' => getGermanClass(getClassById($row['class'])), 'RACE' => $row['race'], 'RACENAME' => getGermanRace(getRaceById($row['race'])), 'GENDER' => $row['gender'], 'ACHIEVEMENTPOINTS' => $row['achievementPoints'])); } } $db->sql_freeresult($result);
echo Request::getParam('countRequests') > 0 ? '(+' . Request::getParam('countRequests') . ')' : ''; ?> </a></li> <li><a href="{URL:friends/blacklist}">{L:BLACKLIST_TITLE}</a></li> </ul> <?php if (getCookie('error')) { echo getCookie('error'); } echo '<div class="inbox clearfix">'; if (count($this->friends) > 0) { foreach ($this->friends as $friend) { $id = $friend->uid == Request::getParam('user')->id ? $friend->pid : $friend->uid; echo '<div class="tile">'; echo '<div class="tileImg">'; echo '<img src="' . getAvatar($id) . '">'; echo '<a href="' . url($id) . '"></a>'; echo '</div>'; echo '<div class="tileInfo">'; echo '<div><a class="tileName" href="' . url($id) . '">' . $friend->name . '</a></div>'; echo '<div>' . getRank($friend->elo) . '</div>'; echo '<a class="mailBtn" href="{URL:mail' . $id . '}" title="{L:INDEX_SEND_MAIL}"></a>'; echo '<a class="challengeBtn" onclick="' . ajaxLoad(url('profile', 'challenge'), 'challenge', 'pid:' . $id) . '">{L:INDEX_CHALLENGE}</a>'; echo '</div>'; echo '<div id="challenge' . $id . '"></div>'; echo '</div>'; } } echo '</div>'; echo '<div class="pagin">' . Pagination::printPagination() . '</div>';
<?php header("Content-type: text/html; charset=utf-8"); include_once "db.php"; //单次处理直接查询请求 if (isset($_GET['num'])) { echo getRank($_GET['num']); } //处理带表单的查询请求 if (isset($_POST['hasData'])) { echo getData(); } //获取排名函数 function getRank($num) { $arr = array('data' => array()); $sql = "SELECT `username`,`score` FROM `rb_rank` ORDER BY score desc LIMIT 0,{$num}"; //按照积分大小顺序获取用户信息 $rst = mysql_query($sql); if ($rst) { //查询成功 $arr['error_code'] = 0; while ($res = mysql_fetch_row($rst)) { array_push($arr['data'], array('name' => $res[0], 'score' => $res[1])); } } else { //查询失败 $arr['error_code'] = -1; } return json_encode($arr); }
//echo 'test'; if ($this->profile->dateLast >= time() - 300) { $online = '<div class="on"></div>'; } else { $online = '<div class="off"></div>'; } echo '<div class="profile_left">'; echo '<div class="profile-details"><div class="avatar"><img src="' . getAvatar($this->profile->id) . '">' . $online . '</div>'; echo '<div class="profile_left_info">'; echo '<div class="nick-and-rate"><div class="nickname">'; echo $this->profile->nickname; if (Request::getParam('user')->id && Request::getParam('user')->id == $this->profile->id) { echo ' <a class="red-text" href="' . url('settings', 'general') . '">Edit</a>'; } echo '</div>'; echo '<div>' . getRank($this->profile->elo) . '</div></div>'; //{L:INDEX_RANK}: echo '<div>'; echo '{L:INDEX_RATING}: <span id="rating">' . $this->profile->rating . '</span>'; echo ' <span onclick="' . ajaxLoad(url('profile', 'voice_plus'), 'voice_plus', 'pid:' . $this->profile->id . '|rat:' . $this->profile->rating) . '">+</span> '; echo '</div>'; echo '<div>{L:INDEX_ELO}: ' . $this->profile->elo . '</div>'; echo '<div>{L:INDEX_WINS}: ' . $this->profile->wins . '</div>'; echo '<div>{L:INDEX_TIES}: ' . $this->profile->ties . '</div>'; echo '<div>{L:INDEX_LOSSES}: ' . $this->profile->losses . '</div>'; echo '</div></div>'; // Write message if (Request::getParam('user')->id && Request::getParam('user')->id != $this->profile->id) { echo '<div class="profile-menu">'; if ($this->challenge) { echo '<div id="challenge"><a onclick="' . ajaxLoad(url('profile', 'challenge'), 'challenge', 'pid:' . $this->profile->id) . '">' . Lang::translate('INDEX_CHALLENGE') . '</a></div>';
<?php error_reporting(0); include '../db_con.php'; $player = mysql_real_escape_string(addslashes($_GET['player'])); if (strlen($player) < 2) { return; } $sql = 'SELECT player,sum(kills) as tkills ,sum(death) as tdeath,sum(time) as ttime, sum(points) as total_points , sum(position) as tpos, sum(position = 1) as wins, count(*) as tgames FROM ' . $dbprefix . 'playerstats WHERE player LIKE \'%' . $player . '%\' GROUP BY player ORDER BY total_points desc LIMIT 500'; $result = mysql_query($sql); echo mysql_error(); $index = $p * $per_page + 1; echo '<center><table id="ldr_table"><tr class="lb_tb_hd" align="center"><td>Position</td><td>Player</td><td>Points</td><td>Wins</td><td>Avg Finish</td><td>Kills</td><td>Deaths</td><td>K/D</td><td>Games Played</td><td>Time Ingame</td></tr>'; while ($row = mysql_fetch_array($result)) { echo '<tr class="ldr_alt', $index % 2 + 1, '"><td>', getRank($row['player']), '</td>'; echo '<td><a href="index.php?page=player&player=', $row['player'], '">', $row['player'], '</a></td>'; echo '<td>', $row['total_points'], '</td>'; echo '<td>', $row['wins'], '</td>'; echo '<td>', round($row['tpos'] / $row['tgames'], 2), '</td>'; echo '<td>', $row['tkills'], '</td>'; echo '<td>', $row['tdeath'], '</td>'; echo '<td>', round($row['tkills'] / $row['tdeath'], 2), '</td>'; echo '<td>', $row['tgames'], '</td>'; $hours = round($row['ttime'] / (1000 * 60 * 60), 0); $min = round($row['ttime'] % (1000 * 60 * 60) / (1000 * 60), 0); $sec = round($row['ttime'] % (1000 * 60 * 60) % (1000 * 60) / 1000, 0); echo '<td>', $hours, ':', $min, ':', $sec < 10 ? '0' : '', $sec, '</td>'; echo '</tr>'; $index++; } echo '</table>';
?> </a> <?php echo $this->pid->country ? '<img src="' . _SITEDIR_ . 'public/images/country/' . mb_strtolower($this->pid->country) . '.png">' : ''; ?> </div> <!--<div class="rank"><?php echo getRank($this->pid->elo); ?> </div>--> </div> <div class="rDataInfo"> <div>{L:INDEX_RANK}: <?php echo getRank($this->pid->elo); ?> </div> <div>{L:INDEX_ELO}: <?php echo $this->pid->elo; ?> </div> <div>{L:LADDERS_WINS}: <?php echo $this->pid->wins; ?> </div> <div>{L:LADDERS_TIES}: <?php echo $this->pid->ties; ?> </div>
include 'getRank.php'; $user_id = $_GET['id_user']; date_default_timezone_set("Asia/Kolkata"); $time = date('Y-m-d H:i:s', time()); // echo $time; $arr = array("Tag" => "Start"); $output[] = $arr; $con = mysqli_connect($IP, $user, $pass, $db); // echo "select `idAuction`, `location`, `start_time`, `expctd_time`, `description` from `Auction` where `idUser`=\"$user_id\" and `end_time`>=\"$time\""; // echo "select Auction.*,Temp.Price,idBid,Temp.status from ( (( SELECT * FROM `Bid` Natural Join `Placed`) as Temp), `Auction`) where Temp.`idAuction` = Auction.`idAuction` and Temp.`idUser`=\"$user_id\" and `end_time`>=\"$time\""; $result = mysqli_query($con, "select Auction.*,Temp.Price,idBid,Temp.status from ( (( SELECT * FROM `Bid` Natural Join `Placed`) as Temp), `Auction`) where Temp.`idAuction` = Auction.`idAuction` and Temp.`idUser`=\"{$user_id}\" and `expctd_time`>=\"{$time}\"") or die("Error: " . mysqli_error($con)); $num = mysqli_num_rows($result); $tout = []; while ($row = mysqli_fetch_assoc($result)) { $rating = getRating($row['idUser']); $rank = getRank($row['idAuction'], $row['Price'], $row['idBid']); // print json_encode($rating); $row['rank'] = $rank; $row['rating'] = $rating[0]['rating']; $row['numRated'] = $rating[0]['numRated']; $tout[] = $row; } $arr = array("Participating" => $tout); $output[] = $arr; $tout = []; // echo "select * from Auction where `idAuction` not in (select Auction.`idAuction` from ( (( SELECT * FROM `Bid` Natural Join `Placed`) as Temp), `Auction`) where Temp.`idAuction` = Auction.`idAuction` and Temp.`idUser`=\"$user_id\" and `end_time`>=\"$time\") and `end_time`>=\"$time\""; $result = mysqli_query($con, "select * from Auction where `idAuction` not in (select Auction.`idAuction` from ( (( SELECT * FROM `Bid` Natural Join `Placed`) as Temp), `Auction`) where Temp.`idAuction` = Auction.`idAuction` and Temp.`idUser`=\"{$user_id}\" and `expctd_time`>=\"{$time}\") and `expctd_time`>=\"{$time}\"") or die("Error: " . mysqli_error($con)); $num = mysqli_num_rows($result); while ($row = mysqli_fetch_assoc($result)) { $rating = getRating($row['idUser']); // print json_encode($rating);