* -------------------------------------------------------------------- *
* Kurzbeschreibung : Resolver-Klasse *
* -------------------------------------------------------------------- *
- * $Revision:: $ *
- * $Date:: $ *
- * $Tag:: 0.2.1-FINAL $ *
- * $Author:: $ *
- * -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * Copyright (c) 2009 - 2012 by Mailer Developer Team *
+ * Copyright (c) 2009 - 2016 by Mailer Developer Team *
* For more information visit: http://mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
class HostnameResolver {
// Resolve hostname -> IP address
function resolveHostname ($hostname) {
- // If sql_patches is not at least 0.7.0, abort here and return the hostname (gethostbyname() may return something unwanted)
+ // If ext-sql_patches is not at least 0.7.0, abort here and return the hostname (gethostbyname() may return something unwanted)
if (!isExtensionInstalledAndNewer('sql_patches', '0.7.0')) {
// Abort here
return $hostname;
$ret = '0.0.0.0';
// Search for hostname in cache
- $result = SQL_QUERY_ESC("SELECT `ip` FROM `{?_MYSQL_PREFIX?}_dns_cache` WHERE `hostname`='%s' LIMIT 1",
- array($hostname), __METHOD__, __LINE__);
+ $result = sqlQueryEscaped("SELECT `ip` FROM `{?_MYSQL_PREFIX?}_dns_cache` WHERE `hostname`='%s' LIMIT 1",
+ array(
+ $hostname
+ ), __METHOD__, __LINE__
+ );
// Does an entry exist?
- if (SQL_NUMROWS($result) == 1) {
+ if (sqlNumRows($result) == 1) {
// Then load the hostname
- list($ip) = SQL_FETCHROW($result);
+ list($ip) = sqlFetchRow($result);
// Count cache hit
incrementStatsEntry('dns_cache_hits');
// Seems to be an IP! Now check deeper...
if (($matches[0] == $ip) && ($matches[1] >= 0) && ($matches[1] <= 255) && ($matches[2] >= 0) && ($matches[2] <= 255) && ($matches[3] >= 0) && ($matches[3] <= 255) && ($matches[4] > 0) && ($matches[4] < 255)) {
// We also cache IP addresses
- SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_dns_cache` (`ip`,`hostname`,`added`) VALUES ('%s', '%s', NOW())",
- array($ip, $hostname), __METHOD__, __LINE__);
+ sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_dns_cache` (`ip`, `hostname`, `added`) VALUES ('%s', '%s', NOW())",
+ array(
+ $ip,
+ $hostname
+ ), __METHOD__, __LINE__
+ );
// Set return value to $ip
//* DEBUG: */ logDebugMessage(__METHOD__, __LINE__, sprintf("IP detected, cache entry written: %s->%s", $hostname, $ip));
//* DEBUG: */ logDebugMessage(__METHOD__, __LINE__, sprintf("Cannot lookup: %s", $hostname));
} else {
// Put entry in DB
- SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_dns_cache` (`ip`,`hostname`,`added`) VALUES ('%s', '%s', NOW())",
- array($ip, $hostname), __METHOD__, __LINE__);
+ sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_dns_cache` (`ip`, `hostname`, `added`) VALUES ('%s', '%s', NOW())",
+ array(
+ $ip,
+ $hostname
+ ), __METHOD__, __LINE__
+ );
// Set return value to $ip
$ret = $ip;
}
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
// Return IP number (let's hope it)
return $ret;
// Purge old entries
function purgeEntries() {
// SQL for cleaning up
- SQL_QUERY('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_dns_cache` WHERE (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(`added`) >= {?dns_cache_timeout?})',
+ sqlQuery('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_dns_cache` WHERE (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(`added`) >= {?dns_cache_timeout?})',
__METHOD__, __LINE__);
}
}