X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Ffix_filters.php;h=b2762810fe45cc23589bcf2e72bb8a260d320cc3;hp=756532e988bc960338fd582b33c4b86fc320ca2f;hb=25b4a580b4c7e0d429eb8e436785d3c2ef304f8e;hpb=64c8349613addc3da2242c5cd6b99d64e3fb5f8e diff --git a/inc/fix_filters.php b/inc/fix_filters.php index 756532e988..b2762810fe 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 // Rebuild the cache - rebuildCacheFile('filter', 'filter'); + rebuildCache('filter', 'filter'); } // END - if // Free result 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] ?>