X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fhttp-functions.php;h=8ae5daa78323c9e8a7512fa57d550a51b938b1d5;hb=b5e396d81912f97a5752b4a4e61ae08f7c1efbd5;hp=16d8b80dce61e4f4e0f9016b69ec8733cf310c4b;hpb=cd7d344ea7007cfa20413acd3e03e50f0ab86d86;p=mailer.git diff --git a/inc/http-functions.php b/inc/http-functions.php index 16d8b80dce..8ae5daa783 100644 --- a/inc/http-functions.php +++ b/inc/http-functions.php @@ -896,9 +896,9 @@ function logWrongServerNameRedirect () { // Is ext-sql_patches at least version 0.9.2? if (isExtensionInstalledAndNewer('sql_patches', '0.9.2')) { // Is there an entry? - if (countSumTotalData(detectServerName(), 'server_name_log', 'server_name_id', 'server_name', TRUE, str_replace('%', '{PER}', sprintf(" AND `server_name_remote_addr`='%s' AND `server_name_ua`='%s' AND `server_name_referrer`='%s'", SQL_ESCAPE(detectRemoteAddr(TRUE)), SQL_ESCAPE(detectUserAgent(TRUE)), SQL_ESCAPE(detectReferer(TRUE))))) == 1) { + if (countSumTotalData(detectServerName(), 'server_name_log', 'server_name_id', 'server_name', TRUE, str_replace('%', '{PER}', sprintf(" AND `server_name_remote_addr`='%s' AND `server_name_ua`='%s' AND `server_name_referrer`='%s'", sqlEscapeString(detectRemoteAddr(TRUE)), sqlEscapeString(detectUserAgent(TRUE)), sqlEscapeString(detectReferer(TRUE))))) == 1) { // Update counter, as all are the same - SQL_QUERY_ESC("UPDATE + sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_server_name_log` SET `server_name_counter`=`server_name_counter`+1 @@ -916,7 +916,7 @@ LIMIT 1", ), __FUNCTION__, __LINE__); } else { // Then log it away - SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_server_name_log` (`server_name`, `server_name_remote_addr`, `server_name_ua`, `server_name_referrer`) VALUES('%s','%s', '%s', '%s')", + sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_server_name_log` (`server_name`, `server_name_remote_addr`, `server_name_ua`, `server_name_referrer`) VALUES('%s','%s', '%s', '%s')", array( detectServerName(), detectRemoteAddr(TRUE),