} if ($current_challenge == 9) { $done = true; } if (isset($done) && $done) { $queryupdate = "UPDATE " . USER_TABLE . " SET " . "user_totalchallenges=" . $current_challenge . ", " . "user_totalpoints=" . $current_points . ", " . "user_cluestaken=" . $user_cluestaken . ", " . "user_endtime=" . time() . ", " . "user_alldone=1 WHERE " . "user_id=" . $user_id . " AND " . "user_name='" . $_SESSION['hs_uname'] . "' " . "LIMIT 1"; } else { $queryupdate = "UPDATE " . USER_TABLE . " SET " . "user_totalchallenges=" . $current_challenge . ", " . "user_totalpoints=" . $current_points . ", " . "user_cluestaken=" . $user_cluestaken . " WHERE " . "user_id=" . $user_id . " AND " . "user_name='" . $_SESSION['hs_uname'] . "' " . "LIMIT 1"; } $result = $conn->query($queryupdate) or msg_die($conn->error, 'D'); } } } } } $redtime = sec2min($user_endtime - time()); $timeleft = sec2arr($user_endtime - time()); // This function removes all newlines from the generated page.. nice way to obscure stuff? function stupid_hack_newlines($str) { return str_replace(array("\r\n", "\r", "\n"), '', $str); } ob_start('stupid_hack_newlines'); if (!isset($_SESSION['hs_challocatedpts'])) { $_SESSION['hs_challocatedpts'] = 5 * $current_challenge; } if (!isset($_SESSION['hs_ch_complete'])) { $_SESSION['hs_ch_complete'] = false; } if ($_SESSION['hs_ch_complete']) { render_page('Challenge ' . $current_challenge, phtml('challenge-success', ['session' => $_SESSION, 'ext' => $_ext, 'script_path' => $script_path], false), $script_path);
function GetEncodedTime($pkey) { if (!file_exists(dirname(__FILE__) . '/../log/' . $pkey . '.ffmpeg')) { $this->logError('ffmpeg-progressbar: can\'t open FFMPEG-Log \'./log/' . $pkey . '.ffmpeg\'', date("d-m-y") . '.error.log'); exit('ffmpeg-progressbar: can\'t open FFMPEG-Log \'./log/' . $pkey . '.ffmpeg\''); } else { $FFMPEGLog = @file_get_contents(dirname(__FILE__) . '/../log/' . $pkey . '.ffmpeg'); if (preg_match("/Lsize=/i", $FFMPEGLog)) { return sec2min($this->total_time); } else { $times = explode('time=', $FFMPEGLog); $ctime = count($times) - 1; $timed = explode(' bitrate=', $times[$ctime]); $tt = $timed[0]; $final = explode('.', $tt); return $final[0]; } } }
<?php require_once '../isnd/db_config.php'; require_once '../isnd/functions.php'; db_connect(); $query = "SELECT * FROM hs_users ORDER BY user_totalpoints DESC"; $result = $conn->query($query); echo "<table cellspacing=\"1\" cellpadding=\"1\">\n\t<tr><th>Name</th><th>Pseudo Name</th><th>Username</th><th>Challenges<br>Completed</th><th>Total Points</th><th>Time Taken</th><th>Clues Used</th><th>Full Complete</th></tr>\n"; while ($row = $result->fetch_assoc()) { if ($row['user_alldone'] == 1) { $timetaken = sec2min($row['user_endtime'] - $row['user_starttime']); } else { if ($row['user_hasstarted'] == 1) { $timetaken = sec2min(time() - $row['user_starttime']); if ($timetaken > 40) { $timetaken = "40:00"; } } else { $timetaken = "0:00"; } } echo "\t<tr>\n"; echo "\t\t<td>" . $row['user_fullname'] . "</td>\n"; echo "\t\t<td>" . $row['user_pseudoname'] . "</td>\n"; echo "\t\t<td>" . $row['user_name'] . "</td>\n"; echo "\t\t<td>" . $row['user_totalchallenges'] . "</td>\n"; echo "\t\t<td>" . $row['user_totalpoints'] . "</td>\n"; echo "\t\t<td>" . $timetaken . "</td>\n"; echo "\t\t<td>" . $row['user_cluestaken'] . "</td>\n"; echo "\t\t<td>" . ($row['user_alldone'] == 1 && $row['user_totalchallenges'] == 10 ? "Yes" : "No") . "</td>\n"; echo "\t</tr>\n";