X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Ffix_filters.php;h=9209cbfaebc9ed90e1e2580b9df57f8639f31ad9;hp=7ff1292b6ce9b9309b8141231fe01a669388755d;hb=0f3a135204757cc8750262871c8e62c42300acb4;hpb=de5910b8e5deb9285a7ac57c26ebd894f4e1afbf diff --git a/inc/fix_filters.php b/inc/fix_filters.php index 7ff1292b6c..9209cbfaeb 100644 --- a/inc/fix_filters.php +++ b/inc/fix_filters.php @@ -14,10 +14,9 @@ * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * * $Author:: $ * - * Needs to be in all Files and every File needs "svn propset * - * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * + * Copyright (c) 2009 - 2011 by Mailer Developer Team * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -43,18 +42,18 @@ if (!defined('__SECURITY')) { // Get all filters $result = SQL_QUERY('SELECT - `filter_name`, `filter_function` + `filter_name`,`filter_function` FROM `{?_MYSQL_PREFIX?}_filters` ORDER BY `filter_name` ASC, `filter_function` ASC', __FILE__, __LINE__); // Do we have entries? (we should have!) -if (SQL_NUMROWS($result) > 0) { +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'", $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? if ($count > 1) {