Mercurial > hg > fapweb
diff admajax.php @ 461:ac7357d52ff6
Moar work.
author | Matti Hamalainen <ccr@tnsp.org> |
---|---|
date | Fri, 06 Dec 2013 18:55:04 +0200 |
parents | 36835ef53346 |
children | a678e904633f |
line wrap: on
line diff
--- a/admajax.php Fri Dec 06 18:45:05 2013 +0200 +++ b/admajax.php Fri Dec 06 18:55:04 2013 +0200 @@ -340,7 +340,7 @@ function stGetInfoRotationListEditData($indent, $outer, $list_id) { $sql = stPrepareSQL( - "SELECT displaySlides.* FROM displaySlides ". + "SELECT displaySlides.*,rotationListSlides.order_num FROM displaySlides ". "LEFT JOIN rotationListSlides ON displaySlides.id=rotationListSlides.slide_id ". "WHERE rotationListSlides.list_id=%d ". "ORDER BY rotationListSlides.order_num DESC", @@ -352,7 +352,8 @@ { foreach ($res as $item) { - $str .= $indent." ".stGetOptionListItem($item["id"], FALSE, $item["title"]); + $str .= $indent." ". + stGetOptionListItem($item["id"]."_".$item["order_num"], FALSE, $item["title"]); } } @@ -774,6 +775,7 @@ case "moveRotationListSlide": if (stChkRequestItem("list_id", $list_id, array(CHK_TYPE, VT_INT, "Invalid data.")) && stChkRequestItem("slide_id", $slide_id, array(CHK_TYPE, VT_INT, "Invalid data.")) && + stChkRequestItem("order_num", $order_num, array(CHK_TYPE, VT_INT, "Invalid data.")) && stChkRequestItem("dir", $dir, array(CHK_TYPE, VT_INT, "Invalid data."))) { } @@ -798,10 +800,11 @@ case "removeRotationListSlide": if (stChkRequestItem("list_id", $list_id, array(CHK_TYPE, VT_INT, "Invalid data.")) && - stChkRequestItem("slide_id", $slide_id, array(CHK_TYPE, VT_INT, "Invalid data."))) + stChkRequestItem("slide_id", $slide_id, array(CHK_TYPE, VT_INT, "Invalid data.")) && + stChkRequestItem("order_num", $order_num, array(CHK_TYPE, VT_INT, "Invalid data."))) { - $sql = stPrepareSQL("DELETE FROM rotationListSlides WHERE list_id=%d AND slide_id=%d", - $list_id, $slide_id); + $sql = stPrepareSQL("DELETE FROM rotationListSlides WHERE list_id=%d AND slide_id=%d AND order_num=%d", + $list_id, $slide_id, $order_num); if (stExecSQLCond($sql, "List slide refs deleted.")) {