Beispiel #1
0
if ($LoggedUser['BytesUploaded'] >= $Amount && $Filled === '0') {
    // Create vote!
    $DB->query("\n\t\tINSERT IGNORE INTO requests_votes\n\t\t\t(RequestID, UserID, Bounty)\n\t\tVALUES\n\t\t\t({$RequestID}, " . $LoggedUser['ID'] . ", {$Bounty})");
    if ($DB->affected_rows() < 1) {
        //Insert failed, probably a dupe vote, just increase their bounty.
        $DB->query("\n\t\t\t\tUPDATE requests_votes\n\t\t\t\tSET Bounty = (Bounty + {$Bounty})\n\t\t\t\tWHERE UserID = " . $LoggedUser['ID'] . "\n\t\t\t\t\tAND RequestID = {$RequestID}");
        echo 'dupe';
    }
    $DB->query("\n\t\tUPDATE requests\n\t\tSET LastVote = NOW()\n\t\tWHERE ID = {$RequestID}");
    $Cache->delete_value("request_{$RequestID}");
    $Cache->delete_value("request_votes_{$RequestID}");
    $ArtistForm = Requests::get_artists($RequestID);
    foreach ($ArtistForm as $Importance) {
        foreach ($Importance as $Artist) {
            $Cache->delete_value('artists_requests_' . $Artist['id']);
        }
    }
    // Subtract amount from user
    $DB->query("\n\t\tUPDATE users_main\n\t\tSET Uploaded = (Uploaded - {$Amount})\n\t\tWHERE ID = " . $LoggedUser['ID']);
    $Cache->delete_value('user_stats_' . $LoggedUser['ID']);
    Requests::update_sphinx_requests($RequestID);
    echo 'success';
    $DB->query("\n\t\tSELECT UserID\n\t\tFROM requests_votes\n\t\tWHERE RequestID = '{$RequestID}'\n\t\t\tAND UserID != '{$LoggedUser['ID']}'");
    $UserIDs = array();
    while (list($UserID) = $DB->next_record()) {
        $UserIDs[] = $UserID;
    }
    NotificationsManager::notify_users($UserIDs, NotificationsManager::REQUESTALERTS, Format::get_size($Amount) . " of bounty has been added to a request you've voted on!", "requests.php?action=view&id=" . $RequestID);
} elseif ($LoggedUser['BytesUploaded'] < $Amount) {
    echo 'bankrupt';
}