コード例 #1
0
<?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;
コード例 #2
0
$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';
コード例 #3
0
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";
    }
}