From 027b405b1bdeb5bb7f3362ff1d570aa076846bc3 Mon Sep 17 00:00:00 2001
From: jhunkeler <jhunkeler@c5b2fb0a-d05d-0410-98c8-828840a80ff6>
Date: Mon, 21 Dec 2009 21:32:16 +0000
Subject: (OC) added some jQuery stuff. Working dragable ui for newsreel

git-svn-id: http://svn.3rd-infantry-division.org/testing/branches/Bayonet CMS v2@389 c5b2fb0a-d05d-0410-98c8-828840a80ff6
---
 admin/newsreel/updateDB.php | 39 +++++++++++++++++++++++++++++++++++++++
 1 file changed, 39 insertions(+)
 create mode 100644 admin/newsreel/updateDB.php

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

diff --git a/admin/newsreel/updateDB.php b/admin/newsreel/updateDB.php
new file mode 100644
index 0000000..a7d25a9
--- /dev/null
+++ b/admin/newsreel/updateDB.php
@@ -0,0 +1,39 @@
+<?php
+
+include '../../includes/debug.php';
+include '../../includes/config.php'; 
+include '../../includes/sql.class.php';
+include '../functions.php';
+
+$action = $_POST['action'];
+$updateRecordsArray = $_POST['recordsArray'];
+
+$db = new Bayonet_SQL();
+$db->Connect(
+  $config['sql']['hostname'],
+  $config['sql']['username'],
+  $config['sql']['password']
+  );
+$db->Select_db($config['sql']['database']);
+
+if ($action == "updateReelOrder"){
+
+	$listingCounter = 1;
+	foreach ($updateRecordsArray as $recordIDValue) {
+	
+		$db->Query("UPDATE `bayonet_newsreel` SET `weight` = '$listingCounter' WHERE `slide_id` = '$recordIDValue'");
+		//mysql_query($query) or die('Error, insert query failed');
+		$listingCounter = $listingCounter + 1;
+	}
+	echo "<img src=\"images/accepted.png\" />";
+/*
+	echo '<pre>';
+	print_r($updateRecordsArray);
+	echo '</pre>';
+	echo 'If you refresh the page, you will see that records will stay just as you modified.';
+*/
+}
+else{
+	echo "<img src=\"images/rejected.png\" />";
+}
+?>
\ No newline at end of file
-- 
cgit