function api_autograder_menu_get_problems($user_id, $is_admin, $type, $competition_id, $show_golf_scores)
{
$user_id = intval($user_id);
$language_id = intval($language_id);
if ($type != 'golf' && $type != 'practice' && $type != 'competition') {
return api_error("INVALID_TYPE");
}
if ($type == 'competition') {
$competition_id = intval($competition_id);
$where = "`competition_id` = {$competition_id}";
} else {
$where = "`type` = '{$type}'";
}
if ($type == 'golf') {
$order_by = "`golf_end_time` DESC";
} else {
$order_by = "`problem_id` DESC";
}
$query = "\n\t\t\tSELECT\n\t\t\t\t`problem_id`,\n\t\t\t\t`title`,\n\t\t\t\t`metadata`,\n\t\t\t\t`golf_start_time`,\n\t\t\t\t`golf_end_time`\n\t\t\tFROM `code_problems`\n\t\t\tWHERE {$where}\n\t\t\tORDER BY\n\t\t\t\t{$order_by} ";
$problems = sql_query($query);
$output = array();
$ordered_problem_ids = array();
$user_ids = array();
for ($i = 0; $i < $problems->num_rows; ++$i) {
$problem = api_autograder_canonicalize_problem($problems->fetch_assoc());
$id = $problem['problem_id'];
array_push($ordered_problem_ids, $id);
$output['problem_' . $id] = $problem;
}
$output['ordered_problem_ids'] = $ordered_problem_ids;
if (count($user_ids) > 0) {
$user_infos = api_account_fetch_mini_profiles($user_ids);
$output = array_merge($output, $user_infos);
}
if ($show_golf_scores && count($ordered_problem_ids) > 0 && $user_id > 0) {
$scores = sql_query("SELECT `problem_id`,`language_id`,`code_size`,`integer_rank` FROM `code_solutions` WHERE `user_id` = " . $user_id . " AND `problem_id` IN (" . implode(', ', $ordered_problem_ids) . ")");
for ($i = 0; $i < $scores->num_rows; ++$i) {
$score = $scores->fetch_assoc();
$output['score_' . $score['problem_id'] . '_' . $score['language_id']] = $score;
}
}
return api_success($output);
}
function api_forum_get_recent_threads()
{
$threads = sql_query("\n\t\t\tSELECT\n\t\t\t\tth.*,\n\t\t\t\tp.`user_id`,\n\t\t\t\tc.`key` AS 'category_key',\n\t\t\t\tc.`name` AS 'category_name'\n\t\t\tFROM `forum_threads` th\n\t\t\tINNER JOIN `forum_posts` p ON (p.`post_id` = th.`last_post_id`)\n\t\t\tINNER JOIN `forum_categories` c ON (c.`category_id` = th.`category_id`)\n\t\t\tWHERE c.`show_in_recent` = 1\n\t\t\tORDER BY th.`last_post_id` DESC\n\t\t\tLIMIT 25");
$thread_infos = array();
$user_ids = array();
for ($i = 0; $i < $threads->num_rows; ++$i) {
$thread_info = api_forum_canonicalize_thread_db_entry($threads->fetch_assoc());
if ($thread_info['is_admin_viewable']) {
continue;
}
array_push($thread_infos, $thread_info);
array_push($user_ids, $thread_info['user_id']);
}
$user_info = api_account_fetch_mini_profiles($user_ids);
return array('threads' => $thread_infos, 'user_info' => $user_info);
}
function execute($request)
{
$output = array('<h1>Code Golf</h1>', "<p><a href=\"https://en.wikipedia.org/wiki/Code_golf\">Code Golf</a> is a competition to see who can solve a programming problem using the fewest [key] \"strokes\".</p>", '</div>');
$now = time();
// TODO: migrate to api layer
$current_challenge = api_autograder_canonicalize_problem(sql_query_item("SELECT * FROM `code_problems` WHERE `type` = 'golf' AND `golf_start_time` <= {$now} AND `golf_end_time` > {$now} LIMIT 1"));
array_push($output, '<div style="padding-top:20px; margin-bottom:20px;">', '<div class="block" style="float:left; width:460px;">', '<p>' . "A new problem is posted every <s>2 weeks</s> once in a while. " . "During that time you can submit solutions. " . "Once time is up, the highest ranking (shortest) solutions will be awarded points. " . "You may still submit solutions after time is up for practice, but they won't be recorded for scores." . '</p>', '<p>Points are granted as follows on a per-language basis:</p>', '<ul>', '<li>First place: 3 points</li>', '<li>Second place: 2 points</li>', '<li>Third through fifth: 1 point</li>', '</ul>', '<p>Preference is given to earlier solutions in the event of ties. The maximum points you can receive is 3 × {number of languages}.</p>', '<p>More about <a href="/about#points">NP points</a>.</p>', '<p>Want a reminder every 2 weeks? New Golf questions will be announced via <a href="https://twitter.com/nerdparadise">twitter</a>.</p>', '</div>', '<div class="block" style="float:left; margin-left:20px; width:400px;">');
if ($current_challenge == null) {
array_push($output, '<h2>Current Challenge: None</h2>', '<div>Check back soon or poke <a href="/profiles/blake">Blake</a></div>');
} else {
array_push($output, '<h2>Current Challenge: <a href="/golf/' . $current_challenge['problem_id'] . '">' . htmlspecialchars($current_challenge['title']) . '</a></h2>', '<div><span style="color:#048; font-weight:bold;">' . seconds_to_duration($current_challenge['golf_end_time'] - time()) . '</span> Remain.</div>', '');
// TODO: migrate to api
$ranked_entries = sql_query("\r\n\t\t\t\tSELECT\r\n\t\t\t\t\tr.`user_id`,\r\n\t\t\t\t\tr.`integer_rank`,\r\n\t\t\t\t\tr.`code_size`,\r\n\t\t\t\t\tr.`language_id`,\r\n\t\t\t\t\tlang.`name` AS 'lang_name',\r\n\t\t\t\t\tlang.`key` AS 'lang_key'\r\n\t\t\t\tFROM `code_solutions` r\r\n\t\t\t\tINNER JOIN `languages` lang ON (lang.`language_id` = r.`language_id`)\r\n\t\t\t\tWHERE\r\n\t\t\t\t\tr.`problem_id` = " . $current_challenge['problem_id'] . " AND\r\n\t\t\t\t\tr.`integer_rank` <= 3\r\n\t\t\t\tORDER BY r.`integer_rank`");
if ($ranked_entries->num_rows == 0) {
array_push($output, '<p>Currently there are no submissions.</p>', '<p><a href="/golf/' . $current_challenge['problem_id'] . '">Be the first!</a></p>');
} else {
array_push($output, '<h2 style="padding-top:20px; padding-bottom:10px;">Rankings</h2>');
$user_ids = array();
$languages = array();
$language_keys = array();
$language_names = array();
for ($i = 0; $i < $ranked_entries->num_rows; ++$i) {
$entry = $ranked_entries->fetch_assoc();
array_push($user_ids, $entry['user_id']);
$language_key = $entry['lang_key'];
if (!isset($languages[$language_key])) {
$languages[$language_key] = array();
array_push($language_keys, $language_key);
$language_names[$language_key] = $entry['lang_name'];
}
array_push($languages[$language_key], $entry);
}
sort($language_keys);
$user_infos = api_account_fetch_mini_profiles($user_ids);
foreach ($language_keys as $language_key) {
array_push($output, '<h3>', '<img src="/images/languages/' . $language_key . '_small.png" valign="middle" />', htmlspecialchars($language_names[$language_key]), '</h3>', '<table style="width:100%">');
$rank = 1;
foreach ($languages[$language_key] as $entry) {
$user_info = $user_infos['user_' . $entry['user_id']];
array_push($output, '<tr>', '<td>#' . $rank . '</td>', '<td><a href="/profiles/' . $user_info['login_id'] . '">' . htmlspecialchars($user_info['name']) . '</a></td>', '<td>' . $entry['code_size'] . ' byte' . ($entry['code_size'] == 1 ? '' : 's') . '</td>', '</tr>');
++$rank;
}
array_push($output, '</table>');
}
}
}
array_push($output, '</div>', '</div>');
array_push($output, '<div style="clear:left; padding-top:20px;">', '<div class="fullblock">', '<h2>All Challenges</h2>');
$languages = api_autograder_get_language_infos(true);
$problems_and_scores = api_autograder_menu_get_problems($request['user_id'], $request['is_admin'], 'golf', 0, true);
$ordered_problem_ids = $problems_and_scores['ordered_problem_ids'];
array_push($output, '<table cellspacing="0" cellpadding="4"><tr style="font-size:14px; font-weight:bold;"><td></td><td></td>');
foreach ($languages as $language) {
array_push($output, '<td style="padding-right:30px;">');
array_push($output, '<img src="/images/languages/' . htmlspecialchars($language['key']) . '_small.png" valign="middle" />');
array_push($output, htmlspecialchars($language['name']));
array_push($output, '</td>');
}
array_push($output, '</tr>');
$now = time();
$alt = true;
foreach ($ordered_problem_ids as $problem_id) {
$problem_info = $problems_and_scores['problem_' . $problem_id];
$is_active = $now < $problem_info['golf_end_time'];
$alt = !$alt;
$bg_color = $is_active ? 'cde' : ($alt ? 'fff' : 'eee');
array_push($output, '<tr style="' . ($is_active ? 'font-weight:bold;' : '') . 'text-align:center;background-color:#' . $bg_color . ';">', '<td style="text-align:left;"><a href="/golf/' . $problem_id . '">', htmlspecialchars($problem_info['title']), '</a></td>', '<td>');
if ($is_active) {
array_push($output, "Ends: " . unix_to_scaling_time($problem_info['golf_end_time']));
} else {
array_push($output, "Ended: " . unix_to_scaling_time($problem_info['golf_start_time']));
}
array_push($output, '</td>');
foreach ($languages as $language) {
$score = $problems_and_scores['score_' . $problem_id . '_' . $language['language_id']];
if (intval($score['code_size']) > 0) {
array_push($output, '<td>');
array_push($output, $score['code_size']);
array_push($output, ' (#' . $score['integer_rank'] . ')');
// TODO: little trophy images.
} else {
array_push($output, '<td style="color:#888;">');
array_push($output, 'N/A');
}
array_push($output, '</td>');
}
array_push($output, '</tr>');
}
array_push($output, '</table>');
array_push($output, '</div>');
return build_response_ok("Code Golf", implode("\n", $output));
}