From 3f4d766f298bd71ae05ab1ccb6aa4c46142257ca Mon Sep 17 00:00:00 2001
From: nedko <nedko>
Date: Mon, 3 May 2004 23:22:08 +0000
Subject: [PATCH] Allow readonly mode (demo)

---
 php/inc.config.php |  2 ++
 php/index.php      | 34 +++++++++++++++++++---------------
 php/locations.php  | 25 ++++++++++++++++---------
 3 files changed, 37 insertions(+), 24 deletions(-)

diff --git a/php/inc.config.php b/php/inc.config.php
index 06ea9ab..c7f776c 100644
--- a/php/inc.config.php
+++ b/php/inc.config.php
@@ -35,5 +35,7 @@ $config = array(
 
   'media_title_ellipsis_limit' => 50,
 
+  'readonly_mode'         =>      false,
+
   '');
 ?>
diff --git a/php/index.php b/php/index.php
index ea5bdff..5f56db2 100644
--- a/php/index.php
+++ b/php/index.php
@@ -42,25 +42,29 @@ function ShowChangeLocationForm($media_id)
 
 function ChangeMediaLocation($media_id, $new_location_id)
 {
-	echo "<p>\n";
-	$query = "UPDATE ".$GLOBALS['config']['tbl_media'].
-    " SET location = '".$new_location_id."'".
-    " WHERE mediaid = '".$media_id."'";
-//  echo $query;
-
-	if (!$res = mysql_query($query))
+  if ($GLOBALS['config']['readonly_mode'])
   {
-		echo "<b>Error:</b> ".mysql_error()." <i>(".basename(__FILE__).", line ".__LINE__.")</i>\n<p>\n";
-	}
-  else if (mysql_affected_rows() != 0)
-  {
-    echo "Location changed.\n\n";
-    return;
+    echo "<p>Cannot modify database in read-only mode.</p>\n";
   }
+  else
+  {
+    $query = "UPDATE ".$GLOBALS['config']['tbl_media'].
+      " SET location = '".$new_location_id."'".
+      " WHERE mediaid = '".$media_id."'";
+//  echo $query;
 
-  echo "Could not change location.\n\n";
+    if (!$res = mysql_query($query))
+    {
+      echo "<p><b>Error:</b> ".mysql_error()." <i>(".basename(__FILE__).", line ".__LINE__.")</i>\n</p>\n";
+    }
+    else if (mysql_affected_rows() != 0)
+    {
+      echo "<p>Location changed.</p>\n";
+      return;
+    }
+  }
 
-	echo "</p>\n";
+  echo "<p>Could not change location.</p>\n";
 }
 
 if (isset($_GET['media']))
diff --git a/php/locations.php b/php/locations.php
index 955ed81..5a28e46 100644
--- a/php/locations.php
+++ b/php/locations.php
@@ -67,17 +67,24 @@ function ShowAddLocationForm()
 
 function AddLocation()
 {
-  $query = "INSERT INTO ".$GLOBALS['config']['tbl_locations'].
-    "(description,type)".
-    " VALUES ('".addslashes($_POST['location_add'])."', ".$_POST['location_type'].")";
-	if (!$res = mysql_query($query))
+  if ($GLOBALS['config']['readonly_mode'])
   {
-		echo "<b>Error:</b> ".mysql_error()." <i>(".basename(__FILE__).", line ".__LINE__.")</i>\n<p>\n";
-	}
-  else if (mysql_affected_rows() != 0)
+    echo "<p>Cannot modify database in read-only mode.</p>\n";
+  }
+  else
   {
-    echo "Location added.\n\n";
-    return;
+    $query = "INSERT INTO ".$GLOBALS['config']['tbl_locations'].
+      "(description,type)".
+      " VALUES ('".addslashes($_POST['location_add'])."', ".$_POST['location_type'].")";
+    if (!$res = mysql_query($query))
+    {
+      echo "<b>Error:</b> ".mysql_error()." <i>(".basename(__FILE__).", line ".__LINE__.")</i>\n<p>\n";
+    }
+    else if (mysql_affected_rows() != 0)
+    {
+      echo "Location added.\n\n";
+      return;
+    }
   }
 
   echo "Could not add location.\n\n";
-- 
2.11.4.GIT