PHP change_rank Examples

Example #1

File: aliases.php Project: taqfu/peeps2

<?php

$connection = new PDO("mysql:host=localhost;dbname=peeps", "root", "");
switch ($_POST['function_called']) {
    case "new_alias":
        create_new_alias($_POST['profile_id'], $_POST['new_alias']);
        break;
    case "delete_alias":
        delete_alias($_POST['id']);
        break;
    case "change_rank":
        change_rank($_POST['id'], $_POST['is_direction_up']);
        break;
}
function change_rank($id, $is_direction_up)
{
    global $connection;
    $statement = $connection->prepare("select * from aliases where id=?");
    $statement->bindValue(1, $id, PDO::PARAM_INT);
    $statement->execute();
    $main_record = $statement->fetchObject();
    if ($is_direction_up) {
        $new_rank = $main_record->rank - 1;
    } else {
        $new_rank = $main_record->rank + 1;
    }
    $other_record = $connection->query("select * from aliases where active=1 and owner=" . $main_record->owner . " and rank=" . $new_rank)->fetchObject();
    $connection->exec("update aliases set rank=" . $main_record->rank . " where id=" . $other_record->id);
    $connection->exec("update aliases set rank=" . $new_rank . " where id=" . $main_record->id);
}
function create_new_alias($profile_id, $alias)

Example #2

File: ajax.php Project: taqfu/rla-old

     break;
 case "change_due_date":
     echo "EX";
     change_due_date(filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT), filter_input(INPUT_POST, 'due', FILTER_SANITIZE_STRING));
     break;
 case "change_name":
     change_name(filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT), filter_input(INPUT_POST, 'new_name', FILTER_SANITIZE_STRING));
     break;
 case "change_power":
     change_power(filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT), filter_input(INPUT_POST, 'new_power', FILTER_SANITIZE_NUMBER_INT));
     break;
 case "change_quality":
     change_quality(filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT), filter_input(INPUT_POST, 'new_quality', FILTER_VALIDATE_BOOLEAN));
     break;
 case "change_rank":
     change_rank(filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT), filter_input(INPUT_POST, 'new_rank', FILTER_SANITIZE_NUMBER_INT));
     break;
 case "change_todo_name":
     change_todo_name(filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT), filter_input(INPUT_POST, 'name', FILTER_SANITIZE_STRING));
     break;
 case "change_work_status_of_achievement":
     change_work_status_of_achievement(filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT), filter_input(INPUT_POST, 'status', FILTER_SANITIZE_NUMBER_INT));
     break;
 case "change_work_status_of_action":
     change_work_status_of_action(filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT), filter_input(INPUT_POST, 'work', FILTER_SANITIZE_NUMBER_INT));
     break;
 case "clear_due_date":
     clear_due_date(filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT));
     break;
 case "complete_achievement":
     complete_achievement(filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT));