X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_unconfirmed.php;h=822d58d766f4c89e08f857a682c544f80a85e8c9;hp=cd6da112e6d7816dc91e04c0e1957b4222a5a157;hb=754861aaacc51a871b8b91f382c3e0b57726f692;hpb=e5527fd38a6585c8466dc28d013f12d21eb7c07a diff --git a/inc/modules/admin/what-list_unconfirmed.php b/inc/modules/admin/what-list_unconfirmed.php index cd6da112e6..822d58d766 100644 --- a/inc/modules/admin/what-list_unconfirmed.php +++ b/inc/modules/admin/what-list_unconfirmed.php @@ -57,7 +57,7 @@ $sql = ''; // List confirmation links from normal or bonus mails if ((isPostRequestElementSet('id')) && (isGetRequestElementSet('type')) && (postRequestElement('type') == 'normal')) { // SQL query for mail data - $sql = sprintf("SELECT + $sql = sprintf('SELECT `s`.`id`, `p`.`sender`, `p`.`subject`, @@ -73,7 +73,7 @@ ON `p`.`id`=`s`.`pool_id` WHERE `s`.`pool_id`=%s -LIMIT 1", +LIMIT 1', bigintval(getRequestElement('id')) ); @@ -87,7 +87,7 @@ LIMIT 1", $DATA = getRequestElement('id'); } elseif (((isPostRequestElementSet('id')) && (isGetRequestElementSet('type')) && (postRequestElement('type') == 'bonus')) && (isExtensionActive('bonus'))) { // SQL query for mail data (both ids are required for compatiblity to above normal mail - $sql = sprintf("SELECT + $sql = sprintf('SELECT `id`, NULL AS `sender`, `subject`, @@ -99,7 +99,7 @@ FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s -LIMIT 1", +LIMIT 1', bigintval(getRequestElement('id')) );