Esempio n. 1
0
        mysql_query("UPDATE newcms2_gallerypicture SET sort = '" . $upperitem["sort"] . "' WHERE ID = '" . $item["ID"] . "'") or die(mysql_error());
        mysql_query("UPDATE newcms2_gallerypicture SET sort = '" . $item["sort"] . "' WHERE ID = '" . $upperitem["ID"] . "'") or die(mysql_error());
    }
}
function moveDown($item)
{
    $loweritem = getLowerItem($item);
    print "got loweritem: " . $loweritem . "<br>";
    if (is_array($loweritem)) {
        mysql_query("UPDATE newcms2_gallerypicture SET sort = '" . $loweritem["sort"] . "' WHERE ID = '" . $item["ID"] . "'");
        mysql_query("UPDATE newcms2_gallerypicture SET sort = '" . $item["sort"] . "' WHERE ID = '" . $loweritem["ID"] . "'") or die(mysql_error());
    }
}
if (isset($_REQUEST["action"]) && isset($_REQUEST["itemID"])) {
    $item = getItem($_REQUEST["itemID"]);
    $action = $_REQUEST["action"];
    print "item: " . $item . "<br>";
    if ("up" == $action) {
        print "moveing up<br>";
        moveUp($item);
    } else {
        if ("down" == $action) {
            print "moveing down<br>";
            moveDown($item);
        }
    }
}
print "done";
?>
</body>
</html>
Esempio n. 2
0
$content_id = $_REQUEST['content_id'];
$operation = $_REQUEST['operation'];
if (isset($_REQUEST['connection'])) {
    $id_item = $_REQUEST['connection'];
}
if ($operation == 'add1') {
    addToPlaylist($playlist_id, $content_id);
} else {
    if ($operation == 'delete') {
        deleteRow($playlist_id, $content_id);
    } else {
        if ($operation == 'moveUp') {
            moveUp($playlist_id, $content_id, $id_item);
        } else {
            if ($operation == 'moveDown') {
                moveDown($playlist_id, $content_id, $id_item);
            }
        }
    }
}
function moveDown($playlist_id, $content_id, $id_item)
{
    $isUp = false;
    $servername = "localhost";
    $username = "******";
    $password = "******";
    $dbname = "Doopy";
    $connect = mysqli_connect($servername, $username, $password, $dbname);
    if (!$connect) {
        die("Connection failed: " . mysqli_connect_error());
    }