PHP DataAccessLayer::InsertOrUpdateRanking Examples

Example #1

File: edit.php Project: ninomy/Scholarships

    exit;
}
$user_id = $_SESSION['user_id'];
if ($_GET['id']) {
    $id = $_GET['id'];
} else {
    if ($_POST['id']) {
        $id = $_POST['id'];
    } else {
        die("No ID supplied!");
    }
}
$dal = new DataAccessLayer();
$username = $dal->GetUsername($_SESSION['user_id']);
if (isset($_POST['up'])) {
    $dal->InsertOrUpdateRanking($user_id, $_POST['last_id'], 'valid', 1);
} else {
    if (isset($_POST['down'])) {
        $dal->InsertOrUpdateRanking($user_id, $_POST['last_id'], 'valid', -1);
    } else {
        if (isset($_POST['skip'])) {
            $dal->InsertOrUpdateRanking($user_id, $_POST['last_id'], 'valid', 0);
        } else {
            if (isset($_POST['save'])) {
                $dal->UpdateField('notes', $_POST['last_id'], $_POST['notes']);
                $dal->UpdateField('residence', $_POST['last_id'], $_POST['residence']);
                $dal->UpdateField('nationality', $_POST['last_id'], $_POST['nationality']);
                $dal->UpdateField('exclude', $_POST['last_id'], $_POST['exclude']);
                $dal->UpdateField('address', $_POST['last_id'], $_POST['address']);
            }
        }

Example #2

File: view.php Project: ninomy/Scholarships

    $id = $_GET['id'];
} else {
    if ($_POST['id']) {
        $id = $_POST['id'];
    } else {
        die("No ID supplied!");
    }
}
$dal = new DataAccessLayer();
$username = $dal->GetUsername($_SESSION['user_id']);
if (isset($_POST['rank'])) {
    $CRITERIA = array('valid', 'onwiki', 'offwiki', 'future');
    //, 'special');
    foreach ($CRITERIA as $c) {
        if (isset($_POST[$c])) {
            $dal->InsertOrUpdateRanking($user_id, $_POST['last_id'], $c, $_POST[$c]);
        }
    }
} else {
    if (isset($_POST['save']) && isset($_POST['notes']) && strlen($_POST['notes']) > 0) {
        $dal->UpdateNotes($_POST['last_id'], $_POST['notes']);
    }
}
if (isset($_POST['save'])) {
    $schol = $dal->GetScholarship($_POST['last_id']);
} else {
    if ($id == 'unranked') {
        $schol = $dal->GetNextPhase1($user_id);
    } else {
        $schol = $dal->GetScholarship($id);
    }