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."))
           {