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":