Mercurial > hg > fapweb
diff admajax.php @ 459:36835ef53346
Moar!
author | Matti Hamalainen <ccr@tnsp.org> |
---|---|
date | Fri, 06 Dec 2013 18:38:57 +0200 |
parents | 3b5184c6b36f |
children | ac7357d52ff6 |
line wrap: on
line diff
--- a/admajax.php Fri Dec 06 18:24:02 2013 +0200 +++ b/admajax.php Fri Dec 06 18:38:57 2013 +0200 @@ -262,7 +262,6 @@ "SELECT rotationListData.*, ". "(SELECT COUNT(*) FROM rotationListSlides WHERE list_id=rotationListData.id) AS nslides ". "FROM rotationListData ". - "LEFT JOIN rotationListSlides ON rotationListData.id=rotationListSlides.list_id ". "ORDER BY id DESC"; $str = stGetOptionListStart("ctrlRotationLists", $indent, $outer); @@ -785,12 +784,15 @@ stChkRequestItem("slide_id", $slide_id, array(CHK_TYPE, VT_INT, "Invalid data."))) { $nslides = stFetchSQLColumn(stPrepareSQL("SELECT COUNT(*) FROM rotationListSlides WHERE list_id=%d", $list_id)); - $sql = stPrepareSQL("INSERT INTO rotationListSlides () VALUES ()", + $sql = stPrepareSQL( + "INSERT INTO rotationListSlides (list_id,slide_id,order_num) VALUES (%d,%d,%d)", $list_id, $slide_id, $nslides+1); - stExecSQLCond($sql, "Slide added to list."); - stNormalizeListSlideOrder($list_id); - stDisplayUpdated(); + if (stExecSQLCond($sql, "Slide added to list.")) + { + stNormalizeListSlideOrder($list_id); + stDisplayUpdated(); + } } break; @@ -800,9 +802,12 @@ { $sql = stPrepareSQL("DELETE FROM rotationListSlides WHERE list_id=%d AND slide_id=%d", $list_id, $slide_id); - stExecSQLCond($sql, "List slide refs deleted."); - stNormalizeListSlideOrder($list_id); - stDisplayUpdated(); + + if (stExecSQLCond($sql, "List slide refs deleted.")) + { + stNormalizeListSlideOrder($list_id); + stDisplayUpdated(); + } } break; } @@ -832,7 +837,7 @@ case "infoRotationListEdit": if (stChkRequestItem("id", $list_id, array(CHK_TYPE, VT_INT, "Invalid data."))) - echo stGetInfoRotationListEditFull("", TRUE, $list_id); + echo stGetInfoRotationListEditFull("", stGetRequestItem("full", TRUE), $list_id); break; case "infoRotationListEditData": @@ -842,7 +847,7 @@ case "infoDisplaySlideEdit": if (stChkRequestItem("id", $slide_id, array(CHK_TYPE, VT_INT, "Invalid data."))) - echo stGetInfoDisplaySlideEdit("", TRUE, $slide_id); + echo stGetInfoDisplaySlideEdit("", FALSE, $slide_id); break; case "infoActiveRotationList":