function saveOrderedImages($uid, $type, $category, $name) { $query = "select * from orders where deleted = 0 and fk_user_id = :uid and type=:type and category = :category and name = :name"; $res = DB::findOneFromQuery($query, array(":uid" => $uid, ":type" => $type, ":category" => $category, ":name" => $name)); if (!($res && count($res) > 0)) { return DB::insert("orders", array("fk_user_id" => $uid, "type" => $type, "category" => $category, "name" => $name)); } return -1; }
function liveContestRanking($contestCode, $limit) { $query = "SELECT ranktable FROM contest WHERE code = '{$contestCode}'"; $table = '<table class="table table-striped table-bordered table-condensed">'; $result = DB::findOneFromQuery($query); $rankTable = json_decode($result['ranktable'], true); $rank = 1; foreach ($rankTable as $row) { $table .= '<tr>'; $table .= '<td align = "center">' . $rank . '</td><td align="center"><a href="' . SITE_URL . '/teams/' . $row['teamname'] . '">' . $row['teamname'] . '</a></td><td align="center">' . $row['score'] . '</td>'; $table .= '</tr>'; if ($rank >= $limit) { break; } $rank++; } $table .= '</table>'; return $table; }
$a -= $min; $hr = $a / 60; $str = ""; if ($hr > 0) { $str .= $hr . ":"; } if ($min > 0) { $str .= $min . ":"; } $str .= $sec; return $str; } if (isset($_GET['code'])) { $_GET['code'] = addslashes($_GET['code']); $query = "select * from contest where code = '{$_GET['code']}'"; $contest = DB::findOneFromQuery($query); ?> <center><h1>Rankings - <?php echo $contest['name']; ?> </h1></center> <?php $query = "select teams.tid, teamname, group_concat(distinct(problems.pid) SEPARATOR ',') as pids\nfrom problems, teams, runs \nwhere \nruns.result = 'AC' and\nproblems.pid = runs.pid and \nproblems.contest = 'contest' and\nruns.access != 'deleted' and\nteams.tid = runs.tid and \nproblems.pgroup = '{$_GET['code']}' and \n(problems.status = 'Active' or problems.status = 'Inactive' or problems.status ='deleted') and\nteams.status != 'Admin'\ngroup by teams.tid"; $res = DB::findAllFromQuery($query); foreach ($res as $row) { $rank[$row['tid']]['teamname'] = $row['teamname']; $rank[$row['tid']]['time'] = 0; $rank[$row['tid']]['score'] = 0; $rank[$row['tid']]['penalty'] = 0; $rank[$row['tid']]['solved'] = count(explode(',', $row['pids'])); $query = "select \n r.pid as pid, \n min(submittime) as time, \n score, \n (select count(pid) from runs where tid = {$row['tid']} and pid = problems.pid and submittime < r.submittime and runs.access != 'deleted' and result != 'AC') as penalty \n from runs r, problems where \n r.access != 'deleted' and \n tid = {$row['tid']} and \n problems.pid in ({$row['pids']}) and \n result = 'AC' and \n r.pid = problems.pid \n group by pid";
function getCurrentContest() { $result = DB::findOneFromQuery("SELECT value from admin where variable = 'currentContest'"); $contestCode = $result['value']; return $contestCode; }
echo "<input type='submit' name='rejudge' class='btn btn-danger' value='Rejudge All Selected Submisssions'/>\n </form></center>"; } $resopt = array('AC', 'RTE', 'WA', 'TLE', 'CE', 'DQ', 'PE'); echo "<div class='breadcrumb' align='center'>"; echo "Filter : <a class='label label-primary' href='" . SITE_URL . "/submissions/{$_GET['code']}'>ALL</a> "; foreach ($resopt as $val) { echo "<a class='label label-primary' href='" . SITE_URL . "/submissions/{$_GET['code']}&filter={$val}'>{$val}</a> "; } echo "</div>"; $select = "Select *"; $query = "from runs where access!='deleted' and tid in (SELECT tid FROM teams WHERE teamname='{$_GET['code']}') AND pid in (SELECT pid FROM problems WHERE status='Active' or status='Inactive')" . (isset($_GET['filter']) ? " and result='{$_GET['filter']}' " : "") . " order by rid desc"; $result = DB::findAllWithCount($select, $query, $page, 25); $data = $result['data']; echo "<table class='table table-hover'><tr><th>Run ID</ht><th>Team</th><th>Problem</th><th>Language</th><th>Time</th><th>Result</th><th>Options</th></tr>"; foreach ($data as $row) { $prob = DB::findOneFromQuery("Select name, code from problems where pid = {$row['pid']}"); echo "<tr" . ($row['result'] == "AC" ? " class='success'>" : ">") . "<td>" . ($row['access'] == 'public' || isset($_SESSION['loggedin']) && ($_SESSION['team']['status'] == "Admin" || $_SESSION['team']['id'] == $row['tid']) ? "<a href='" . SITE_URL . "/viewsolution/{$row['rid']}'>{$row['rid']}</a>" : "{$row['rid']}") . "</td><td><a href='" . SITE_URL . "/teams/{$_GET['code']}'>{$_GET['code']}</a></td><td><a href='" . SITE_URL . "/problems/{$prob['code']}'>{$prob['name']}</a></td><td>{$row['language']}</td><td>{$row['time']}</td><td>{$row['result']}</td><td>" . ($row['access'] == 'public' || isset($_SESSION['loggedin']) && ($_SESSION['team']['status'] == "Admin" || $_SESSION['team']['id'] == $row['tid']) ? "<a class='btn btn-primary' href='" . SITE_URL . "/viewsolution/{$row['rid']}'>Code</a>" : "") . "</td></tr>"; } echo "</table>"; pagination($result['noofpages'], SITE_URL . "/submissions/{$_GET['code']}" . (isset($_GET['filter']) ? "&filter={$_GET['filter']}" : ""), $page, 10); } else { ?> <center><h1>Submissions</h1></center> <?php if (isset($_GET['page'])) { $page = $_GET['page']; } else { $page = 1; } $select = "Select *"; if (isset($_SESSION['loggedin']) && $_SESSION['team']['status'] == 'Admin') {
<?php if (isset($_SESSION['loggedin']) && $_SESSION['team']['status'] == 'Admin') { if (isset($_GET['code'])) { $_GET['code'] = addslashes($_GET['code']); $query = "select * from teams where teamname='{$_GET['code']}'"; $res = DB::findOneFromQuery($query); ?> <script type='text/javascript'> $(document).ready(function() { $('#teamname').focus(function() { $('#teamname').tooltip('show'); }); $('#teamname').blur(function() { $('#teamname').tooltip('hide'); }); }); </script> <h1>Team Settings - <?php echo $_GET['code']; ?> </h1> <form method='post' class='form-horizontal' action='<?php echo SITE_URL; ?> /process.php'> <input type="hidden" value="<?php echo $res['tid']; ?> " name="tid" /> <div class='form-group'>
<?php include_once '../functions.php'; include_once '../components.php'; function timeformating($a) { return gmdate("H:i:s", $a); } if (isset($_GET['code'])) { $_GET['code'] = addslashes($_GET['code']); $query = "select * from contest where code = '{$_GET['code']}'"; $contest = DB::findOneFromQuery($query); $query = "select value from admin where variable = 'penalty'"; $admin = DB::findOneFromQuery($query); $query = "select * from problems where pgroup = '{$_GET['code']}' and status != 'Deleted'"; $problems = DB::findAllFromQuery($query); $pidToProbCode = array(); foreach ($problems as $prob) { $pidToProbCode[$prob['pid']] = $prob['code']; } ?> <center><?php if (isset($_SESSION['loggedin']) && $_SESSION['team']['status'] == "Admin") { } ?> <h1>Rankings - <?php echo $contest['name']; ?> </h1></center> <?php if ($contest['ranktable'] != "") {
<?php require_once 'config.php'; require_once 'components.php'; $_SESSION['url'] = $_SERVER['REQUEST_URI']; // used by process.php to send to last visited page $query = "select value from admin where variable='mode'"; $judge = DB::findOneFromQuery($query); if ($judge['value'] == 'Lockdown' && isset($_SESSION['loggedin']) && !isAdmin()) { session_destroy(); session_regenerate_id(true); session_start(); $_SESSION['msg'] = "Judge is in Lockdown mode and so you have been logged out."; redirectTo(SITE_URL); } ?> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <link type="text/css" rel="stylesheet" href="<?php echo CSS_URL; ?> /bootstrap.css" media="screen" /> <link type="text/css" rel="stylesheet" href="<?php echo CSS_URL; ?> /style.css" media="screen" /> <script type="text/javascript" src="<?php
$result = DB::findOneFromQuery($query); echo $result['rank']; ?> </td> </tr> <tr> <th>Score</th><td><?php echo $res['score']; ?> </td> </tr> <tr> <th>Practice Score</th><td> <?php $query = "select sum(score) as tot from (select distinct(pid), (select score from problems where pid = runs.pid and contest = 'practice') as score from runs where pid in (select pid from problems where contest = 'practice' and status = 'Active') and result = 'AC' and tid = {$res['tid']})t"; $sco = DB::findOneFromQuery($query); echo $sco['tot']; ?> </td> </tr> </table> <center><a href="<?php echo SITE_URL . "/submissions/{$_GET['code']}"; ?> "><?php echo $_GET['code'] . "'s "; ?> Submissions</a></center> <h3>Practice Problems Solved</h3> <div class='row'> <?php
<center><h1>Contact Us</h1></center> <?php if (isset($_GET['page'])) { $page = $_GET['page']; } else { $page = 1; } $select = "Select *"; $query = "from clar where access = 'Public' and pid='0' order by time desc"; $result = DB::findAllWithCount($select, $query, $page, 10); $data = $result['data']; foreach ($data as $row) { $row['query'] = htmlentities(preg_replace("/\n/", "<br>", $row['query'])); $row['reply'] = htmlentities(preg_replace("/\n/", "<br>", $row['reply'])); $query = "Select teamname from teams where tid = {$row['tid']}"; $team = DB::findOneFromQuery($query); echo "<div class='post'><b><a href='" . SITE_URL . "/teams/{$team['teamname']}'>{$team['teamname']}</a> : {$row['query']}</b>" . ($row['reply'] != "" ? "<hr/>A. {$row['reply']}<br/>" : '') . "</div>"; } if (isset($_SESSION['loggedin'])) { ?> <hr/> <h4>Please feel free to post your queries/doubts/praise/criticism/feedback.<br/>We will reply as soon as we can!</h4> <form action="<?php echo SITE_URL; ?> /process.php" method="post"> <input type="hidden" value="0" name="pid" /> <textarea class='form-control' style="width: 500px; height: 200px;" name="query"></textarea><br/> <input name="clar" type="submit" class="btn btn-primary" /> </form> <?php
<?php if (isset($_SESSION['loggedin'])) { $level = DB::findOneFromQuery("select * from level where levelcode = (select level from users where id = " . $_SESSION['team']['id'] . ")"); // if($level['level']==16) { // // <div class='wrap-box'> // <div style='padding: 10px;'> // Congratulations. You are now a pR0_H@ck3R! // </div> // </div> //<?php // } // else if (isset($_GET['tab']) && $level['url'] == $_GET['tab']) { if ($level['content'] == "") { require 'files/' . $level['url'] . '.php'; } else { foreach ($_COOKIE as $k => $value) { if ($k == "PHPSESSID") { continue; } setcookie($k, null, -1); } if ($level['cookie'] != "") { foreach (explode(";", $level['cookie']) as $value) { $r = explode("=", $value); setcookie($r[0], $r[1], time() + 1000); } } ?>
$result = DB::findOneFromQuery("select * from editorials where pid = '{$pid}'"); if ($result == NULL) { $data['pid'] = $pid; $data['content'] = $_POST['statement']; DB::query("INSERT into editorials VALUES ( {$pid}, '{$_POST['statement']}' )"); } else { DB::query("update editorials set content = '{$_POST['statement']}' where pid = '{$pid}'"); } // $_SESSION['msg'] = 'Editorial Updated'; } if (isset($_GET['code'])) { $_GET['code'] = addslashes($_GET['code']); $query = "select pid, code from problems where code = '{$_GET['code']}'"; $res = DB::findOneFromQuery($query); if ($res != NULL) { $result = DB::findOneFromQuery("select content from editorials where pid = '{$res['pid']}'"); } ?> <center><h1>Editorial Settings - <?php echo "<a class='btn btn-primary' href='" . SITE_URL . "/editorial/{$_GET['code']}'>{$_GET['code']} Editorial</a>"; ?> </h1></center> <form class='form-horizontal' role='form' method='post' action='<?php echo SITE_URL . "/admineditorial/{$_GET['code']}'"; ?> enctype='multipart/form-data'> <div class='form-group'> <label class='control-label col-sm-2' for='code'>Code</label> <div class='col-sm-4'> <input class='form-control' type='text' name='code' id='code' value='<?php
if ($judge['value'] != "Lockdown" || isset($_SESSION['loggedin']) && $_SESSION['team']['status'] == 'Admin') { if (isset($_GET['code'])) { $_GET['code'] = addslashes($_GET['code']); if (isset($_SESSION['loggedin']) && $_SESSION['team']['status'] == "Admin") { $query = "select * from problems where code = '{$_GET['code']}'"; $result = DB::findOneFromQuery($query); if ($result != NULL) { echo "<a class='btn btn-primary pull-right' style='margin-top: 10px;' href='" . SITE_URL . "/admineditorial/{$_GET['code']}'><i class='glyphicon glyphicon-edit'></i> Edit</a>"; } } else { $query = "select * from problems where code = '{$_GET['code']}' and status != 'Deleted'"; $result = DB::findOneFromQuery($query); } if ($result == NULL) { echo "<br/><br/><br/><div style='padding: 10px;'><h1>Problem not Found :(</h1>The problem you are looking for doesn't exsits.</div><br/><br/><br/>"; } else { $contentRes = DB::findOneFromQuery("select content from editorials where pid = " . $result['pid']); if ($contentRes == NULL) { echo "<br/><br/><br/><div style='padding: 10px;'><h1>Editorial not Found :(</h1>The editorial you are looking for doesn't exsits.</div><br/><br/><br/>"; } else { $content = stripslashes($contentRes["content"]); echo "<center><h1>{$result['name']} - Editorial</h1></center><div class='btn-group'><a class='btn btn-primary' href='" . SITE_URL . "/problems/{$result['code']}'>Problem</a></div>\n <br/><br/>" . $content . "<br/>"; } } } else { echo "<br/><br/><br/><div style='padding: 10px;'><h1>Problem not Found :(</h1>The problem you are looking for doesn't exsits.</div><br/><br/><br/>"; } } else { echo "<br/><br/><br/><div style='padding: 10px;'><h1>Lockdown Mode :(</h1>This feature is now offline as Judge is in Lockdown mode.</div><br/><br/><br/>"; }
<?php require "config.php"; if (isset($_POST['username'])) { $res = DB::findOneFromQuery("select * from users where urname=" . DB::escape($_POST['username']) . " and (password='******'password'] . "')"); if ($res) { $_SESSION['id'] = $res['id']; redirectTo("user.php"); } else { redirectTo("index.php"); } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta name="description" content=""> <meta name="author" content=""> <title>Signin</title> <link href="bootstrap.min.css" rel="stylesheet"> <link href="signin.css" rel="stylesheet"> </head> <body> <div class="container">
public static function getStaticRankTableInJSON($contestCode) { $query = "SELECT ranktable FROM contest WHERE code = '{$contestCode}'"; return DB::findOneFromQuery($query); }
<!-- Custom styles for this template --> <link href="signin.css" rel="stylesheet"> <!-- HTML5 shim and Respond.js IE8 support of HTML5 elements and media queries --> <!--[if lt IE 9]> <script src="../../assets/js/html5shiv.js"></script> <script src="../../assets/js/respond.min.js"></script> <![endif]--> </head> <body> <div class="container"> <?php include 'config.php'; $re = DB::findOneFromQuery("select * from login where id=2"); if (isset($_GET['id']) && $_GET['id'] == $re['sessionid']) { $_SESSION['allowed'] = true; redirectTo('answer.php'); } else { echo "You have reached here. You'll go no far."; } ?> </div> <!-- /container --> <!-- Bootstrap core JavaScript ================================================== --> <!-- Placed at the end of the document so the pages load faster --> </body>
$query .= " where access = 'deleted'"; } } $query .= " order by time desc"; echo "<h1>Clarifications</h1>\n <ul class='nav nav-tabs'>\n <li " . ($tab == 'pending' ? "class='active'" : "") . "><a href='" . SITE_URL . "/adminclar&group=pending'>Pending</a></li>\n <li " . ($tab == 'replied' ? "class='active'" : "") . "><a href='" . SITE_URL . "/adminclar&group=replied'>Replied</a></li>\n <li " . ($tab == 'deleted' ? "class='active'" : "") . "><a href='" . SITE_URL . "/adminclar&group=deleted'>Deleted</a></li>\n </ul>"; $data = DB::findAllWithCount("select * ", $query, $page, 10); $result = $data['data']; foreach ($result as $row) { $save = $row['reply']; $row['query'] = preg_replace("/\n/", "<br>", $row['query']); $row['reply'] = preg_replace("/\n/", "<br>", $row['reply']); $query = "select teamname from teams where tid='{$row['tid']}'"; $team = DB::findOneFromQuery($query); if ($row['pid'] != '0') { $query = "select name, code from problems where pid='{$row['pid']}'"; $prob = DB::findOneFromQuery($query); $prob['code'] = "problems/" . $prob['code']; } else { $prob['name'] = 'Feedback'; $prob['code'] = 'contact'; } echo "<a href='" . SITE_URL . "/teams/{$team['teamname']}'>{$team['teamname']}</a> (<a href='" . SITE_URL . "/{$prob['code']}'>{$prob['name']}</a>):<br/>\n <b>Q. " . htmlspecialchars($row[query]) . "</b><br/>"; if ($row['reply'] != "") { echo "A. " . htmlspecialchars($row[reply]) . "<br/><br/>"; } echo "<form class='form-inline' role='form' method='post' action='" . SITE_URL . "/process.php'>"; echo "<div class='form-group'>Access:</div><div class='form-group'><select class='form-control' name='access'><option value='public' " . ($row['access'] == "public" ? "selected='selected' " : "") . ">Public</option><option value='deleted' " . ($row['access'] == "deleted" ? "selected='selected' " : "") . ">Deleted</option></select></div><br/><br/>"; echo "<input type='hidden' name='tid' value='{$row['tid']}' /><input type='hidden' name='pid' value='{$row['pid']}' /><input type='hidden' name='time' value='{$row['time']}' />\n<textarea class='form-control' name='reply' style='width: 450px; height: 100px;'>{$save}</textarea><br/><br/>\n<input type='submit' class='btn btn-primary' name='clarreply' value='Reply / Change Reply'/>\n</form><hr/>"; } pagination($data['noofpages'], SITE_URL . "/adminclar" . "&group={$tab}", $page, 10); } else {
} DB::update('users', array('mcq_answer' => $mcqans), "id = " . $_SESSION['team']['id']); } else { if (isset($_POST['mcqans'])) { $ans = $_POST; $question = DB::findOneFromQuery("select count(id) as total from mcq"); unset($ans['save']); $mcqans = ""; for ($i = 1; $i <= $question['total']; $i++) { if (isset($ans[$i])) { $mcqans .= $ans[$i]; } $mcqans .= ","; } $correct = DB::findAllFromQuery("select correct from mcq"); $user = DB::findOneFromQuery("select cheat from users where id = " . $_SESSION['team']['id']); $i = 1; $score = 0; foreach ($correct as $val) { if (isset($ans[$i]) && $ans[$i] == $val['correct']) { $score += 4 * $user['cheat']; } else { if (isset($ans[$i]) && $ans[$i] != $val['correct']) { $score -= 1; } } $i++; } $_SESSION['team']['score'] = $score; DB::update('users', array('mcq_answer' => $mcqans, 'score' => $score, 'level' => 1), "id = " . $_SESSION['team']['id']); } else {