X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=beg.php;h=89775b185cc483f01211e489a3091de93359ac1a;hb=7faab9c40d199c032562279be6db98b632dc7ef6;hp=e9e559138e952b77c901dd99c1283b930f6da3b9;hpb=544aa3fb48613160f812515673e64c46d18d2e1d;p=mailer.git diff --git a/beg.php b/beg.php index e9e559138e..89775b185c 100644 --- a/beg.php +++ b/beg.php @@ -103,8 +103,8 @@ if (isGetRequestParameterSet('userid')) { SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `beg_clicks`=`beg_clicks`+1 WHERE `userid`=%s LIMIT 1", array(getUserData('userid')), __FILE__, __LINE__); - // Check for last entry for userid w/o IP number - $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_beg_ips` WHERE (`timeout` > (UNIX_TIMESTAMP() - {?beg_timeout?}) OR (timeout > (UNIX_TIMESTAMP() - {?beg_userid_timeout?}) AND `userid`=%s)) AND (`remote_ip`='%s' OR `sid`='%s') LIMIT 1", + // Check for last entry for userid w/o IP number 12 33 2 23 44 3 21 1 1 + $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_beg_ips` WHERE ((UNIX_TIMESTAMP() - `timeout`) >= {?beg_timeout?} OR ((UNIX_TIMESTAMP() - `timeout`) >= {?beg_userid_timeout?} AND `userid`=%s)) AND (`remote_ip`='%s' OR `sid`='%s') LIMIT 1", array(getUserData('userid'), detectRemoteAddr(), session_id()), __FILE__, __LINE__); // Entry not found, points set and not logged in? @@ -116,7 +116,7 @@ if (isGetRequestParameterSet('userid')) { * but only when there is no admin begging. * Admins shall be able to test it! */ - SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_beg_ips` (`userid`, `remote_ip`,`sid`, `timeout`) VALUES ('%s','%s','%s', UNIX_TIMESTAMP())", + SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_beg_ips` (`userid`, `remote_ip`, `sid`, `timeout`) VALUES ('%s','%s','%s', UNIX_TIMESTAMP())", array( getUserData('userid'), detectRemoteAddr(), @@ -149,7 +149,7 @@ if (isGetRequestParameterSet('userid')) { $content['message'] = loadTemplate('beg_login', true, $content); } elseif (getBegPayMode() != 'NONE') { // Other pay-mode active! // Load message template depending on pay-mode - $content['message'] = loadTemplate('beg_pay_mode_'.strtolower(getBegPayMode()), true, $content); + $content['message'] = loadTemplate('beg_pay_mode_' . strtolower(getBegPayMode()), true, $content); $pay = true; } else { // Clicked received while reload lock is active @@ -173,7 +173,7 @@ if (isGetRequestParameterSet('userid')) { ); // Include config-depending template - loadTemplate('beg_pay_code_'.strtolower(getBegPayMode()), false, $content); + loadTemplate('beg_pay_code_' . strtolower(getBegPayMode()), false, $content); } elseif (($pay === false) && (!isset($content['message']))) { // Cannot pay! :-( $content['message'] = loadTemplate('beg_failed', true);