X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Ffix_filters.php;h=299b052f945811f2a1b048a0a7772072b304b671;hb=5fed4d6d18f6458182276599d6cab6c9134ef4aa;hp=9f53a5a65b34f4964426d41cd416b936a241ce47;hpb=63f159414369b5ea19a8ca75d8cd8033c45d8341;p=mailer.git diff --git a/inc/fix_filters.php b/inc/fix_filters.php index 9f53a5a65b..299b052f94 100644 --- a/inc/fix_filters.php +++ b/inc/fix_filters.php @@ -50,14 +50,14 @@ ORDER BY `filter_name` ASC, `filter_function` ASC', __FILE__, __LINE__); -// Do we have entries? (we should have!) +// Are there entries? (there should be!) if (!SQL_HASZERONUMS($result)) { // Load row by row while ($filter = SQL_FETCHARRAY($result)) { // Now search again for this filter and get it's total count - $count = countSumTotalData($filter['filter_name'], 'filters', 'filter_id', 'filter_name', true, sprintf(" AND `filter_function`='%s'", SQL_ESCAPE($filter['filter_function']))); + $count = countSumTotalData($filter['filter_name'], 'filters', 'filter_id', 'filter_name', TRUE, sprintf(" AND `filter_function`='%s'", SQL_ESCAPE($filter['filter_function']))); - // Do we have more than one entry? + // Is there more than one entry? if ($count > 1) { // Then clean them up, except one addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_filters` WHERE `filter_name`='%s' AND `filter_function`='%s' LIMIT %s", @@ -74,7 +74,7 @@ SQL_FREERESULT($result); // Now insert our unqiue key addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_filters` DROP KEY `name_function`'); -addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_filters` ADD UNIQUE INDEX `name_function` (`filter_name`,`filter_function`)'); +addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_filters` ADD UNIQUE INDEX `name_function` (`filter_name`, `filter_function`)'); // [EOF] ?>