X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Ffix_filters.php;h=69cd4e001cfc68046c295fe673a607400343fb31;hb=2eb01731e9a7a21c1b44ca5881a1444a801f5e5a;hp=756532e988bc960338fd582b33c4b86fc320ca2f;hpb=64c8349613addc3da2242c5cd6b99d64e3fb5f8e;p=mailer.git diff --git a/inc/fix_filters.php b/inc/fix_filters.php index 756532e988..69cd4e001c 100644 --- a/inc/fix_filters.php +++ b/inc/fix_filters.php @@ -1,7 +1,7 @@ 0) { // Do we have more than one entry? if ($count > 1) { // Then clean them up, except one - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_filters` WHERE `filter_name`='%s' AND `filter_function`='%s' LIMIT %s", - array($filter['filter_name'], $filter['filter_function'], ($count - 1)), __FILE__, __LINE__); + addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_filters` WHERE `filter_name`='%s' AND `filter_function`='%s' LIMIT %s", + array($filter['filter_name'], $filter['filter_function'], ($count - 1))); } // END - while } // END - while @@ -72,8 +72,8 @@ if (SQL_NUMROWS($result) > 0) { SQL_FREERESULT($result); // Now insert our unqiue key -SQL_QUERY('ALTER TABLE `{?_MYSQL_PREFIX?}_filters` DROP KEY `name_function`', __FILE__, __LINE__); -SQL_QUERY('ALTER TABLE `{?_MYSQL_PREFIX?}_filters` ADD UNIQUE `name_function` (`filter_name` , `filter_function`)', __FILE__, __LINE__); +addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_filters` DROP KEY `name_function`'); +addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_filters` ADD UNIQUE `name_function` (`filter_name` , `filter_function`)'); // [EOF] ?>