<?php include "../util/DbUtil.php"; session_start(); $userid = $_POST['userid']; $response = ""; $db_conn = getConnectedDb(); if (is_null($db_conn)) { $response = "Error connecting to database. Try again later."; } elseif (isUserBanned($db_conn, $userid)) { $response = "User already banned."; } elseif (!banUser($db_conn, $userid)) { $response = "Error banning user"; } else { $response = "Success"; } echo $response;
$replayLocation = '/home/osuserve/public_html/web/replay/'; $IV = $_POST['iv']; $key = 'h89f2-890h2h89b34g-h80g134n90133'; $scoreEncrypted = $_POST["score"]; $scoreDecrypted = decryptText($scoreEncrypted); $score = explode(':', $scoreDecrypted); //BOOM //get playerID $playerID = getPlayerIDFromOsu($score[1]); if ($playerID == '') { displayError('nouser'); } if (!checkOsuLogin($score[1], $_POST["pass"])) { displayError('pass'); } if (isUserBanned($playerID)) { displayError('ban'); } //set failed or not //pass: 2 //quit: 1 //fail: 0 $completed = 2; if (isset($_POST['x'])) { //user didnt finish map $completed = $_POST['x']; } addToDatabase($score, $playerID, $completed); //store replay file storeReplay(); echo 'ok';
function getScores($beatmapHash, $mode, $playerID) { $db = sqlconn(); $personalScore = $playerID == NULL; if ($personalScore) { //global scores $query = 'SELECT * FROM scores WHERE beatmapHash = :beatmap AND mode = :mode ORDER BY score DESC'; $prepared = $db->prepare($query); $prepared->bindParam(':beatmap', $beatmapHash, PDO::PARAM_STR); $prepared->bindParam(':mode', $mode, PDO::PARAM_INT); } else { //personal scores $query = 'SELECT * FROM scores WHERE beatmapHash = :beatmap AND playerID = :user AND mode = :mode ORDER BY score DESC LIMIT 1'; $prepared = $db->prepare($query); $prepared->bindParam(':beatmap', $beatmapHash, PDO::PARAM_STR); $prepared->bindParam(':mode', $mode, PDO::PARAM_INT); $prepared->bindParam(':user', $playerID, PDO::PARAM_INT); } $prepared->execute(); $i = 0; while ($row = $prepared->fetch()) { $i++; $playerID = $row['playerID']; $score = $row['score']; $combo = $row['combo']; $fc = $row['fc']; $mods = $row['mods']; $ID = $row['ID']; $count50 = $row['count50']; $count100 = $row['count100']; $count300 = $row['count300']; $countKatu = $row['countKatu']; $countGeki = $row['countGeki']; $countMiss = $row['countMiss']; $time = $row['time']; $completed = $row['completed']; $showScore = !isUserBanned($playerID); //customisation $avatarID = getAvatarID($playerID); $newUser = getUserName($playerID); //display play ID if (false) { $newUser = "******"; } //display tries if (true) { $tries = getTries($playerID, $beatmapHash, $mode); $newUser = "******" . ($tries == 1 ? 'try' : 'tries') . ')'; } if ($completed == 1) { //display quitted if (true) { $newUser = '******' . $newUser; } else { if ($personalScore) { echo "\r\n"; } continue; } } if ($completed == 0) { //display failed if (true) { $newUser = '******' . $newUser; } else { if ($personalScore) { echo "\r\n"; } continue; } } if ($showScore) { echo scoreString($ID, $newUser, $score, $combo, $count50, $count100, $count300, $countMiss, $countKatu, $countGeki, $fc, $mods, $avatarID, $i, $time); } } if ($i == 0) { //no scores recieved echo "\r\n"; } }