Added site and date key for improved security

[mailer.git] / mailid.php

diff --git a/mailid.php b/mailid.php
index a90ea06eff7f577c4ebde4f469f455d6d32f63f1..289ac310cd4a701d728f6993b57a358078e3b5fa 100644 (file)
--- a/mailid.php
+++ b/mailid.php
@@ -112,7 +112,7 @@ if ((isValidUserId($userId)) && (($mailId > 0) || ($bonusId > 0)) && (!ifFatalEr
                                redirectOnUninstalledExtension('bonus');
 
                                // Bonus-Mails
-                               $result = SQL_QUERY_ESC("SELECT `id`, `url`, `subject` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1",
+                               $result = SQL_QUERY_ESC("SELECT `id` AS `pool_id`, `url`, `subject` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1",
                                        array($bonusId), __FILE__, __LINE__);
                                break;
 
@@ -174,7 +174,7 @@ if ((isValidUserId($userId)) && (($mailId > 0) || ($bonusId > 0)) && (!ifFatalEr
                                                default: // Invalid mail type
                                                        reportBug(__FILE__, __LINE__, 'Invalid mail type ' . $ltype . ' detected.');
                                                        break;
-                                       }
+                                       } // END - switch
 
                                        // Add header
                                        loadIncludeOnce('inc/header.php');