Renamed ifSqlHasZeroNums() to ifSqlHasZeroNumRows() and improved some queries.

[mailer.git] / inc / filter / rallye_filter.php

diff --git a/inc/filter/rallye_filter.php b/inc/filter/rallye_filter.php
index 2965cc5acc432f2ba5d7558b187302618ec14df1..180574263637bc6a248921ea8f167f6b10b81f57 100644 (file)
--- a/inc/filter/rallye_filter.php
+++ b/inc/filter/rallye_filter.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
+ * Copyright (c) 2009 - 2015 by Mailer Developer Team                   *
  * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -63,53 +63,53 @@ function FILTER_RALLYE_NOTIFY_USERS ($filterData) {
                ));
 
                // Check for new started but not notified rallyes
-               $result = SQL_QUERY("SELECT SQL_SMALL_RESULT
-       d.`id`,
-       d.`title`,
-       d.`start_time`,
-       d.`end_time`,
-       d.`send_notify`
+               $result = sqlQuery("SELECT SQL_SMALL_RESULT
+       `d`.`id`,
+       `d`.`title`,
+       `d`.`start_time`,
+       `d`.`end_time`,
+       `d`.`send_notify`
        " . $sqlAddons['add'] . "
 FROM
-       `{?_MYSQL_PREFIX?}_rallye_data` AS d
+       `{?_MYSQL_PREFIX?}_rallye_data` AS `d`
 WHERE
-       d.`is_active`='Y' AND
-       d.`notified`='N' AND
-       d.`expired`='N' AND
-       d.`start_time` <= UNIX_TIMESTAMP() AND
-       d.`end_time` > UNIX_TIMESTAMP()
+       `d`.`is_active`='Y' AND
+       `d`.`notified`='N' AND
+       `d`.`expired`='N' AND
+       `d`.`start_time` <= UNIX_TIMESTAMP() AND
+       `d`.`end_time` > UNIX_TIMESTAMP()
 LIMIT 1", __FILE__, __LINE__);
-               if (SQL_NUMROWS($result) == 1) {
+               if (sqlNumRows($result) == 1) {
                        // Start rallye
                        autostartReferralRallyes($result);
                } // END - if
 
                // Free memory
-               SQL_FREERESULT($result);
+               sqlFreeResult($result);
 
                // Check for expired rallyes
-               $result = SQL_QUERY("SELECT SQL_SMALL_RESULT
-       d.`id`,
-       d.`title`,
-       d.`start_time`,
-       d.`end_time`,
-       d.`send_notify`
+               $result = sqlQuery("SELECT SQL_SMALL_RESULT
+       `d`.`id`,
+       `d`.`title`,
+       `d`.`start_time`,
+       `d`.`end_time`,
+       `d`.`send_notify`
        " . $sqlAddons['add'] . "
 FROM
-       `{?_MYSQL_PREFIX?}_rallye_data` AS d
+       `{?_MYSQL_PREFIX?}_rallye_data` AS `d`
 WHERE
-       d.`is_active`='Y' AND
-       d.`notified`='Y' AND
-       d.`expired`='N' AND
-       (d.`end_time` <= UNIX_TIMESTAMP()" . $sqlAddons['or'] . ")
+       `d`.`is_active`='Y' AND
+       `d`.`notified`='Y' AND
+       `d`.`expired`='N' AND
+       (`d`.`end_time` <= UNIX_TIMESTAMP()" . $sqlAddons['or'] . ")
 LIMIT 1", __FILE__, __LINE__);
-               if ((SQL_NUMROWS($result) == 1) && (isExtensionActive('autopurge'))) {
+               if ((sqlNumRows($result) == 1) && (isExtensionActive('autopurge'))) {
                        // End rallye here...
                        stopRallyeByResult($result);
                } // END - if
 
                // Free memory
-               SQL_FREERESULT($result);
+               sqlFreeResult($result);
        } // END - if
 
        // Return data
@@ -124,7 +124,7 @@ function FILTER_ADD_RALLYE_SQL_COLUMNS ($filterData) {
        if (isExtensionInstalledAndNewer('rallye', '0.2.0')) {
                // Add more data on higher versions
                $filterData['add'] .= ',`min_users`, `min_prices`';
-               $filterData['or']  .= ' OR (d.`min_users` <= ' . getTotalConfirmedUser() . ' AND d.`min_users` > 0)';
+               $filterData['or']  .= ' OR (`d`.`min_users` <= ' . getTotalConfirmedUser() . ' AND `d`.`min_users` > 0)';
        } // END  - if
 
        // Return data