X-Git-Url: http://Server1/repobrowser/?p=kiriwrite%2F.git;a=blobdiff_plain;f=cgi-files%2FModules%2FDatabase%2FMySQL5.pm;h=62a89679bf38a68d86b5205e8d96d263f99aa7c6;hp=6b4bcf3d7b7438b017d42beb3c073fabc914d435;hb=78f6c5e8ed54c22b470764e2b93c42ef1f6644e8;hpb=f50ef089751cbe0dffa1dcc19a359b1d94737a59

diff --git a/cgi-files/Modules/Database/MySQL5.pm b/cgi-files/Modules/Database/MySQL5.pm
index 6b4bcf3..62a8967 100644
--- a/cgi-files/Modules/Database/MySQL5.pm
+++ b/cgi-files/Modules/Database/MySQL5.pm
@@ -2389,12 +2389,12 @@ sub getfilterinfo{
 
 	if ($reduced && $reduced eq 1){
 
-		$statement_handle = $database_handle->prepare('SELECT id, priority, findsetting, replacesetting FROM ' . $class->convert($options{"TablePrefix"}) . '_filters where id = \'' . $class->convert($filter_id) . '\'') or ( $error = "FilterDatabaseError", $errorext = $database_handle->errstr, return );
+		$statement_handle = $database_handle->prepare('SELECT id, priority, findsetting, replacesetting, enabled FROM ' . $class->convert($options{"TablePrefix"}) . '_filters where id = \'' . $class->convert($filter_id) . '\'') or ( $error = "FilterDatabaseError", $errorext = $database_handle->errstr, return );
 		$statement_handle->execute();
 
 	} else {
 
-		$statement_handle = $database_handle->prepare('SELECT id, priority, findsetting, replacesetting, notes FROM ' . $class->convert($options{"TablePrefix"}) . '_filters where id = \'' . $class->convert($filter_id) . '\'') or ( $error = "FilterDatabaseError", $errorext = $database_handle->errstr, return );
+		$statement_handle = $database_handle->prepare('SELECT id, priority, findsetting, replacesetting, enabled, notes FROM ' . $class->convert($options{"TablePrefix"}) . '_filters where id = \'' . $class->convert($filter_id) . '\'') or ( $error = "FilterDatabaseError", $errorext = $database_handle->errstr, return );
 		$statement_handle->execute();
 
 	}
@@ -2407,7 +2407,8 @@ sub getfilterinfo{
 		$filter_info{"FilterPriority"}	= decode_utf8($filter_data[1]);
 		$filter_info{"FilterFind"}	= decode_utf8($filter_data[2]);
 		$filter_info{"FilterReplace"}	= decode_utf8($filter_data[3]);
-		$filter_info{"FilterNotes"}	= decode_utf8($filter_data[4]);
+		$filter_info{"FilterEnabled"}	= decode_utf8($filter_data[4]);
+		$filter_info{"FilterNotes"}	= decode_utf8($filter_data[5]);
 
 		$filter_exists = 1;
 
@@ -2444,6 +2445,7 @@ sub addfilter{
 # FindFilter	Specifies the find filter to add.				#
 # ReplaceFilter	Specifies the replace filter to add.				#
 # Priority	Specifies the filter priority to use.				#
+# Enabled	Specifies if the filter should be enabled.			#
 # Notes		Specifies the notes to use.					#
 #################################################################################
 
@@ -2473,6 +2475,7 @@ sub addfilter{
 	my $filter_find		= $passedoptions->{"FindFilter"};
 	my $filter_replace	= $passedoptions->{"ReplaceFilter"};
 	my $filter_priority	= $passedoptions->{"Priority"};
+	my $filter_enabled	= $passedoptions->{"Enabled"};
 	my $filter_notes	= $passedoptions->{"Notes"};
 
 	# Check if the template database exists.
@@ -2513,6 +2516,12 @@ sub addfilter{
 
 	}
 
+	if (!$filter_enabled){
+
+		$filter_enabled = "";
+
+	}
+
 	# Check if there is really no filter table.
 
 	if (!$filterdb_exists){
@@ -2623,6 +2632,7 @@ sub editfilter{
 # NewFindFilter		Specifies the new find filter setting.			#
 # NewReplaceFilter	Specifies the new replace filter setting.		#
 # NewFilterPriority	Specifies the new filter priority setting.		#
+# NewEnabled		Specifies if the filter is enabled.			#
 # NewFilterNotes	Specifies the new notes for the filter.			#
 #################################################################################
 
@@ -2644,6 +2654,7 @@ sub editfilter{
 	my $filter_newfind	= $passedoptions->{"NewFindFilter"};
 	my $filter_newreplace	= $passedoptions->{"NewReplaceFilter"};
 	my $filter_newpriority	= $passedoptions->{"NewFilterPriority"};
+	my $filter_enabled	= $passedoptions->{"NewEnabled"};
 	my $filter_newnotes	= $passedoptions->{"NewFilterNotes"};
 
 	# Check if the filter exists before editing it.
@@ -2677,6 +2688,7 @@ sub editfilter{
 		findsetting = \'' . $class->convert($filter_newfind) . '\',
 		replacesetting = \'' . $class->convert($filter_newreplace) . '\',
 		priority = \'' . $class->convert($filter_newpriority) . '\',
+		enabled = \'' . $class->convert($filter_enabled) . '\',
 		notes = \'' . $class->convert($filter_newnotes) . '\'
 	WHERE id = \'' . $class->convert($filter_id) . '\'') or ( $error = "FilterDatabaseError", $errorext = $database_handle->errstr, return );	
 	$statement_handle->execute();