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>
session_start(); $playlist_id = $_REQUEST['playlist_id']; $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);