From ed943b32335933f369d9aa459689e986c10421ae Mon Sep 17 00:00:00 2001
From: jhunkeler <jhunkeler@c5b2fb0a-d05d-0410-98c8-828840a80ff6>
Date: Mon, 28 Dec 2009 00:21:11 +0000
Subject: (OC) fixed some bugs in the admin panel caused by the new sql
 wrapper. *need to figure out the avatar for smflogin block.

git-svn-id: http://svn.3rd-infantry-division.org/testing/branches/Bayonet CMS v2@403 c5b2fb0a-d05d-0410-98c8-828840a80ff6
---
 admin/newsreel/functions.php | 37 ++++++++++++++++++++++++++-----------
 1 file changed, 26 insertions(+), 11 deletions(-)

(limited to 'admin/newsreel/functions.php')

diff --git a/admin/newsreel/functions.php b/admin/newsreel/functions.php
index 9dece93..6bde17c 100644
--- a/admin/newsreel/functions.php
+++ b/admin/newsreel/functions.php
@@ -55,6 +55,9 @@ $(document).ready(function(){
  * You should have received a copy of the GNU General Public License
  * along with this program.  If not, see <http://www.gnu.org/licenses/>.
  */
+ 
+ define(MAX_SLIDES, 6);
+ 
   function EditOrder(){
  	
 	 global $db;
@@ -87,7 +90,7 @@ $(document).ready(function(){
  	
 	 global $db;
 	 $lastspot = GetLastPosition();
-	 if($lastspot >= 6){
+	 if($lastspot >= MAX_SLIDES){
 	 	ReportError("There are already 6 active slides. You must disable one in order to enable another.");
 	 	PageRedirect(3,"?op=newsreel");
 		return;	 
@@ -100,12 +103,20 @@ $(document).ready(function(){
  function DisableSlide($slide_id){
  	
 	 global $db;
-	 echo "Disable: ".$slide_id;
 	 $result = $db->Query("SELECT `weight` FROM `bayonet_newsreel` WHERE `slide_id` = '$slide_id' LIMIT 1");
-	 $row = $db->Fetch($result);
-	 foreach($row as $slide){
-	 	$oldWeight = $slide['weight'];	 
-	 }
+	 $slide = $db->FetchRow($result);
+
+	 $oldWeight = $slide['weight'];
+	 
+	 if($oldWeight < MAX_SLIDES){
+		$total = getNumOfActive(); 
+		for($i=$oldWeight+1; $i<=$total; $i++){
+			//echo "Change Weight:".$i." to ".($i-1)."<br />";
+			$new = $i-1;
+			$db->Query("UPDATE `bayonet_newsreel` SET `weight` = '$new' WHERE `weight` = '$i' LIMIT 1");	
+		} 		  		  		  		 
+	 }	 	 	 	 
+
 	 $db->Query("UPDATE `bayonet_newsreel` SET `visible` = 0, `weight` = 0 WHERE `slide_id` = '$slide_id' LIMIT 1");
 	 PageRedirect(0,"?op=newsreel");
  }
@@ -134,11 +145,15 @@ $(document).ready(function(){
  	
 	global $db;
 	$result = $db->Query("SELECT `weight` FROM `bayonet_newsreel` WHERE `visible` = 1 ORDER BY `weight` DESC LIMIT 1");
-	$row = $db->Fetch($result);
-	foreach($row as $slide){
-		$weight = $slide['weight'];	
-	}
- 	return $weight;
+	$row = $db->FetchRow($result);
+	
+ 	return $row['weight'];
+ }
+ 
+ function getNumOfActive(){
+ 	global $db;
+	$result = $db->Query("SELECT `slide_id` FROM `bayonet_newsreel` WHERE `visible` = 1");
+	return $db->Rows($result); 
  }
 		
 
-- 
cgit