Fixes for broken SQL/language string id

[mailer.git] / inc / modules / admin / what-list_sponsor_pay.php

diff --git a/inc/modules/admin/what-list_sponsor_pay.php b/inc/modules/admin/what-list_sponsor_pay.php
index 7375e79285c7b3ebcd28b3e5fd5ec9ffab57adda..75dea69fb2d7431f5321fd923c246d5dcdcbb86b 100644 (file)
--- a/inc/modules/admin/what-list_sponsor_pay.php
+++ b/inc/modules/admin/what-list_sponsor_pay.php
@@ -80,7 +80,7 @@ SET
        `pay_min_count`='%s',
        `pay_currency`='%s'
 WHERE
-       `id`='%s'
+       `id`=%s
 LIMIT 1",
                        array(
                                postRequestParameter('name', $id),
@@ -97,7 +97,7 @@ LIMIT 1",
                // Remove entries here...
                foreach (postRequestParameter('id') as $id => $sel) {
                        // Remove entry
-                       SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_sponsor_paytypes` WHERE `id`='%s' LIMIT 1",
+                       SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_sponsor_paytypes` WHERE `id`=%s LIMIT 1",
                                array(bigintval($id)), __FILE__, __LINE__);
                }
 
@@ -183,7 +183,7 @@ ORDER BY
                __FILE__, __LINE__);
 
        // Do we have some paytypes setup?
-       if (SQL_NUMROWS($result) > 0) {
+       if (!SQL_HASZERONUMS($result)) {
                // Prepare variables for listing
                $OUT = '';