[phpBT-dev] CVS: phpbt query.php,1.90,1.91

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv16143

Modified Files:
	query.php 
Log Message:
Allow users to override saved queries by saving a new query with the same name as an old one.

Index: query.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/query.php,v
retrieving revision 1.90
retrieving revision 1.91
diff -u -r1.90 -r1.91
--- query.php	23 Sep 2002 20:48:21 -0000	1.90
+++ query.php	5 Nov 2002 20:43:46 -0000	1.91
@@ -257,13 +257,20 @@
 	if (!empty($savedqueryname)) {
 		$savedquerystring = ereg_replace('&savedqueryname=.*(&?)', '\1', $HTTP_SERVER_VARS['QUERY_STRING']);
 		$savedquerystring .= '&op=doquery';
-		$nextid = $db->getOne("select max(saved_query_id)+1 from ".TBL_SAVED_QUERY." where user_id = $u");
-		$nextid = $nextid ? $nextid : 1;
-		$db->query("insert into ".TBL_SAVED_QUERY.
-			" (saved_query_id, user_id, saved_query_name, saved_query_string)
-			values (".join(', ', array($nextid, $u,
-				$db->quote(stripslashes($savedqueryname)),
-				$db->quote(stripslashes($savedquerystring)))).")");
+		if ($savedqueryoverride) { // Updating an existing query
+			$db->query("update ".TBL_SAVED_QUERY." set saved_query_string = ".
+				$db->quote(stripslashes($savedquerystring)).
+				" where user_id = $u and saved_query_name = ".
+				$db->quote(stripslashes($savedqueryname)));
+		} else { // Adding a new saved query
+			$nextid = $db->getOne("select max(saved_query_id)+1 from ".TBL_SAVED_QUERY." where user_id = $u");
+			$nextid = $nextid ? $nextid : 1;
+			$db->query("insert into ".TBL_SAVED_QUERY.
+				" (saved_query_id, user_id, saved_query_name, saved_query_string)
+				values (".join(', ', array($nextid, $u,
+					$db->quote(stripslashes($savedqueryname)),
+					$db->quote(stripslashes($savedquerystring)))).")");
+		}
 	}
 	if (!isset($order)) {
 		if (isset($HTTP_SESSION_VARS['queryinfo']['order'])) {