';
var $sitemapFileHeader;
var $sitemapFileBuffer = '';
var $sitemapxml_max_entrys;
var $sitemapxml_max_size;
var $timezone;
var $fb_maxsize = 4096;
var $fb = '';
var $fp = null;
var $fn = '';
var $time_ping;
var $statisticTotalTime = 0;
var $statisticTotalQueries = 0;
var $statisticTotalQueriesTime = 0;
var $statisticModuleTime = 0;
var $statisticModuleQueries = 0;
var $statisticModuleQueriesTime = 0;
function zen_SiteMapXML($inline=false, $ping=false, $rebuild=false, $genxml=true) {
global $db;
$this->statisticTotalTime = microtime(true);
$this->statisticTotalQueries = $db->count_queries;
$this->statisticTotalQueriesTime = $db->total_query_time;
$this->statisticModuleTime = microtime(true);
$this->statisticModuleQueries = $db->count_queries;
$this->statisticModuleQueriesTime = $db->total_query_time;
$this->sitemap = 'sitemap';
$this->videomap = 'videomap';
$this->sitemapindex = SITEMAPXML_SITEMAPINDEX . '.xml';
$this->compress = (SITEMAPXML_COMPRESS == 'true' ? true : false);
$this->duplicatedLinks = array();
$this->sitemapItems = array();
$this->dir_ws = trim(SITEMAPXML_DIR_WS);
$this->dir_ws = rtrim($this->dir_ws, '/');
if ($this->dir_ws != '') {
$this->dir_ws .= '/';
}
$this->savepath = DIR_FS_CATALOG . $this->dir_ws;
$this->savepathIndex = DIR_FS_CATALOG;
$this->base_url = HTTP_SERVER . DIR_WS_CATALOG . $this->dir_ws;
$this->base_url_index = HTTP_SERVER . DIR_WS_CATALOG;
$this->submit_url = utf8_encode(urlencode($this->base_url . $this->sitemapindex));
$this->submitFlag = true;
$this->inline = $inline;
$this->ping = $ping;
$this->rebuild = $rebuild;
$this->checkDublicates = SITEMAPXML_CHECK_DUBLICATES;
$db->Execute("DROP TABLE IF EXISTS " . TABLE_SITEMAPXML_TEMP);
if ($this->checkDublicates == 'mysql') {
$sql = "CREATE TABLE IF NOT EXISTS " . TABLE_SITEMAPXML_TEMP . " (
`url_hash` CHAR(32) NOT NULL ,
PRIMARY KEY (`url_hash`)
) ENGINE = MEMORY;";
$db->Execute($sql);
}
$this->checkurl = (SITEMAPXML_CHECK_URL == 'true' ? true : false);
$this->genxml = $genxml;
$this->sitemapFileFooter = '';
$this->sitemapFileBuffer = '';
$this->sitemapxml_max_entrys = SITEMAPXML_MAX_ENTRYS;
$this->sitemapxml_max_size = SITEMAPXML_MAX_SIZE-strlen($this->sitemapFileFooter);
global $lng;
if (!is_object($lng)) {
$lng = new language();
}
$this->languageSession = array(
'language' => $_SESSION['language'],
'languages_id' => $_SESSION['languages_id'],
'languages_code' => $_SESSION['languages_code'],
);
$languagesIDsArray = array();
foreach ($lng->catalog_languages as $language) {
$this->languages[$language['id']] = array(
'directory' => $language['directory'],
'id' => $language['id'],
'code' => $language['code'],
);
$languagesIDsArray [] = $language['id'];
if ($language['code'] == DEFAULT_LANGUAGE) {
$this->default_language_id = $language['id'];
}
}
if (SITEMAPXML_USE_ONLY_DEFAULT_LANGUAGE == 'true') {
$languagesIDsArray = array($this->default_language_id);
}
$this->languagesIDs = implode(',', $languagesIDsArray );
$this->languagesCount = sizeof($languagesIDsArray );
$this->sitemapItems = array();
$timezone = date('O');
$this->timezone = substr($timezone, 0, 3) . ':' . substr($timezone, 3, 2);
$this->magicSeo = false;
if (function_exists('unMagicSeoDoSeo')) {
$this->magicSeo = true;
}
if ($this->inline) {
ob_start();
}
$this->time_ping = time();
}
function SitemapOpen($file, $last_date=0, $type='sitemap') {
if (strlen($this->sitemapFileBuffer) > 0) $this->SitemapClose();
if (!$this->genxml) return false;
$this->sitemapFile = $file;
$this->sitemapType = $type;
$this->sitemapFileName = $this->_getNameFileXML($file);
if ($this->_checkFTimeSitemap($this->sitemapFileName, $last_date) == false) return false;
if ($file == 'index') {
$rc = $this->_fileOpen($this->sitemapFileName, $this->savepathIndex);
} else {
$rc = $this->_fileOpen($this->sitemapFileName);
}
if (!$rc) return false;
$this->_SitemapReSet();
$this->sitemapFileBuffer .= $this->_SitemapXMLHeader();
if ($file != 'index') {
$i = strpos($this->sitemapFileName, '.');
$name = substr($this->sitemapFileName, 0, $i);
$ext = substr($this->sitemapFileName, $i);
if ($sitemapFiles = glob($this->savepath . $name . '*' . $ext)) {
foreach ($sitemapFiles as $fn) {
if ($fn == $this->savepath . $this->sitemapFileName) continue;
if (preg_match('@^' . preg_quote($this->savepath . $name) . '([\d]{3})' . preg_quote($ext) . '$@', $fn, $m) && filesize($fn) > 0) {
if ($this->dir_ws != '') {
unlink($fn);
} else {
$fp = fopen($fn, 'w');
fclose($fp);
}
}
}
}
}
return true;
}
function SitemapSetMaxItems($maxItems) {
$this->sitemapFileItemsMax = $maxItems;
return true;
}
function writeItem($link, $parms='', $language_id=0, $lastmod='', $changefreq='', $xtra='') {
if ($lastmod != '') {
$lastmod = strtotime($lastmod);
}
$langParm = $this->getLanguageParameter($language_id);
if ($langParm !== false) {
$_SESSION['language'] = $this->languages[$language_id]['directory'];
$_SESSION['languages_id'] = $this->languages[$language_id]['id'];
$_SESSION['languages_code'] = $this->languages[$language_id]['code'];
if (substr($link, 0, 7) != 'http://' && substr($link, 0, 8) != 'https://') {
if ($parms != '' && $langParm != '') {
$langParm = '&' . $langParm;
}
$link = zen_href_link($link, $parms . $langParm, 'NONSSL', false);
} else {
if ($langParm != '') {
$langParm = (strpos($link, '?') === false ? '?' . $langParm : '&' . $langParm);
}
}
$_SESSION['language'] = $this->languageSession['language'];
$_SESSION['languages_id'] = $this->languageSession['languages_id'];
$_SESSION['languages_code'] = $this->languageSession['languages_code'];
$this->SitemapWriteItem($link, $lastmod, $changefreq, $xtra);
}
}
function SitemapWriteItem($loc, $lastmod='', $changefreq='', $xtra='') {
$time_now = time();
if ($this->time_ping >= $time_now + 30) {
$this->time_ping = $time_now;
header('X-pmaPing: Pong');
}
if (!$this->genxml) return false;
if ($this->magicSeo) {
$href = 'loc';
$out = unMagicSeoDoSeo($href);
$loc = substr($out, 21, -23);
}
if (!$this->_checkDublicateLoc($loc)) return false;
if ($this->checkurl) {
if (!($info = $this->_curlExecute($loc, 'header')) || $info['http_code'] != 200) return false;
}
$itemRecord = '';
$itemRecord .= ' ' . "\n";
$itemRecord .= ' ' . utf8_encode($loc) . '' . "\n";
if (isset($lastmod) && zen_not_null($lastmod) && (int)$lastmod > 0) {
$itemRecord .= ' ' . $this->_LastModFormat($lastmod) . '' . "\n";
}
if (zen_not_null($changefreq) && $changefreq != 'no') {
$itemRecord .= ' ' . $changefreq . '' . "\n";
}
if ($this->sitemapFileItemsMax > 0) {
$itemRecord .= ' ' . number_format(max((($this->sitemapFileItemsMax-$this->sitemapFileItemsTotal)/$this->sitemapFileItemsMax), 0.10), 2, '.', '') . '' . "\n";
}
if (isset($xtra) && zen_not_null($xtra)) {
$itemRecord .= $xtra;
}
$itemRecord .= ' ' . "\n";
if ($this->sitemapFileItems >= $this->sitemapxml_max_entrys || $this->sitemapFileSize+strlen($itemRecord) >= $this->sitemapxml_max_size) {
$this->_SitemapCloseFile();
$this->sitemapFileName = $this->_getNameFileXML($this->sitemapFile . str_pad($this->sitemapFileNameNumber, 3, '0', STR_PAD_LEFT));
if (!$this->_fileOpen($this->sitemapFileName)) return false;
$this->_SitemapReSetFile();
$this->sitemapFileBuffer .= $this->_SitemapXMLHeader();
}
$this->sitemapFileBuffer .= $itemRecord;
$this->_fileWrite($this->sitemapFileBuffer);
$this->sitemapFileSize += strlen($this->sitemapFileBuffer);
$this->sitemapFileSizeTotal += strlen($this->sitemapFileBuffer);
$this->sitemapFileItems++;
$this->sitemapFileItemsTotal++;
$this->sitemapFileBuffer = '';
return true;
}
function SitemapClose() {
global $db;
$this->_SitemapCloseFile();
if ($this->sitemapFileItemsTotal > 0) {
$total_time = microtime(true) - $this->statisticModuleTime;
$total_queries = $db->count_queries - $this->statisticModuleQueries;
$total_queries_time = $db->total_query_time - $this->statisticModuleQueriesTime;
echo sprintf(TEXT_TOTAL_SITEMAP, ($this->sitemapFileNameNumber+1), $this->sitemapFileItemsTotal, $this->sitemapFileSizeTotal, $this->timefmt($total_time), $total_queries, $this->timefmt($total_queries_time)) . '
';
}
$this->_SitemapReSet();
}
// generate sitemap index file
function GenerateSitemapIndex() {
global $db;
if ($this->genxml) {
echo '' . TEXT_HEAD_SITEMAP_INDEX . '
';
$this->SitemapOpen('index', 0, 'index');
$records_count = 0;
$sitemapFiles = array();
if ($files = glob($this->savepath . $this->sitemap . '*' . '.xml')) {
$sitemapFiles = array_merge($sitemapFiles, $files);
}
if ($files = glob($this->savepath . $this->sitemap . '*' . '.xml.gz')) {
$sitemapFiles = array_merge($sitemapFiles, $files);
}
clearstatcache();
foreach ($sitemapFiles as $filename) {
$filenameBase = basename($filename);
if ($filenameBase != $this->sitemapindex && filesize($filename) > 0) {
$fileURL = $this->base_url . $filenameBase;
echo TEXT_INCLUDE_FILE . $filename . ' (' . $fileURL . ')' . '
';
$itemRecord = '';
$itemRecord .= ' ' . "\n";
$itemRecord .= ' ' . $fileURL . '' . "\n";
$itemRecord .= ' ' . $this->_LastModFormat(filemtime($filename)) . '' . "\n";
$itemRecord .= ' ' . "\n";
$this->sitemapFileBuffer .= $itemRecord;
$this->_fileWrite($this->sitemapFileBuffer);
$this->sitemapFileSize += strlen($this->sitemapFileBuffer);
$this->sitemapFileSizeTotal += strlen($this->sitemapFileBuffer);
$this->sitemapFileItems++;
$this->sitemapFileItemsTotal++;
$this->sitemapFileBuffer = '';
}
}
$data = '';
$this->sitemapFileSizeTotal += strlen($data);
$this->_fileWrite($data);
$this->_fileClose();
echo TEXT_URL_FILE . '' . $this->base_url_index . $this->sitemapFileName . '' . '
';
echo sprintf(TEXT_WRITTEN, $this->sitemapFileItems++, $this->sitemapFileSizeTotal, filesize($this->savepathIndex . $this->sitemapFileName)) . '
';
}
$db->Execute("DROP TABLE IF EXISTS " . TABLE_SITEMAPXML_TEMP);
if ($this->checkDublicates == 'mysql') {
}
if ($this->inline) {
if ($this->submitFlag) {
ob_end_clean();
$this->_outputSitemapIndex();
} else {
ob_end_flush();
}
}
if ($this->ping) {
if ($this->inline) {
ob_start();
}
$this->_SitemapPing();
if ($this->inline) {
ob_end_clean();
}
}
if ($this->inline) {
die();
}
}
// retrieve full cPath from category ID
function GetFullcPath($cID) {
global $db;
static $parent_cache = array();
$cats = array();
$cats[] = $cID;
$sql = "SELECT parent_id, categories_id
FROM " . TABLE_CATEGORIES . "
WHERE categories_id=:categoriesID";
$sql = $db->bindVars($sql, ':categoriesID', $cID, 'integer');
$parent = $db->Execute($sql);
while (!$parent->EOF && $parent->fields['parent_id'] != 0) {
$parent_cache[(int)$parent->fields['categories_id']] = (int)$parent->fields['parent_id'];
$cats[] = $parent->fields['parent_id'];
if (isset($parent_cache[(int)$parent->fields['parent_id']])) {
$parent->fields['parent_id'] = $parent_cache[(int)$parent->fields['parent_id']];
} else {
$sql = "SELECT parent_id, categories_id
FROM " . TABLE_CATEGORIES . "
WHERE categories_id=:categoriesID";
$sql = $db->bindVars($sql, ':categoriesID', $parent->fields['parent_id'], 'integer');
$parent = $db->Execute($sql);
}
}
$cats = array_reverse($cats);
$cPath = implode('_', $cats);
return $cPath;
}
function setCheckURL($checkurl) {
$this->checkurl = $checkurl;
}
function setStylesheet($stylesheet) {
$this->stylesheet = $stylesheet;
}
function getLanguageParameter($language_id=0, $lang_parm='language') {
$code = '';
if (!isset($language_id) || $language_id == 0) {
$language_id = $this->default_language_id;
}
if (!isset($this->languages[$language_id]['code'])) {
return false;
}
if (SITEMAPXML_USE_LANGUAGE_PARM != 'false' && (($this->languages[$language_id]['code'] != DEFAULT_LANGUAGE && $this->languagesCount > 1) || SITEMAPXML_USE_LANGUAGE_PARM == 'all')) {
$code = $lang_parm . '=' . $this->languages[$language_id]['code'];
}
return $code;
}
function getLanguageDirectory($language_id) {
if (isset($this->languages[$language_id])) {
$directory = $this->languages[$language_id]['directory'];
} else {
$directory = false;
}
return $directory;
}
function getLanguagesIDs() {
return $this->languagesIDs;
}
function dbTableExist($table) {
global $db;
$exist = false;
if (defined($table)) {
$sql = "SHOW TABLES LIKE :tableName";
$sql = $db->bindVars($sql, ':tableName', constant($table), 'string');
$check_query = $db->Execute($sql);
if (!$check_query->EOF) {
$exist = true;
}
}
return $exist;
}
function dbColumnExist($table, $column) {
global $db;
$exist = false;
$sql = "SHOW COLUMNS FROM :tableName LIKE :columnName";
$sql = $db->bindVars($sql, ':tableName', $table, 'noquotestring');
$sql = $db->bindVars($sql, ':columnName', $column, 'string');
$check_query = $db->Execute($sql);
if (!$check_query->EOF) {
$exist = true;
}
return $exist;
}
function imagesTags($images, $caption='true', $license_url='') {
$tags = '';
foreach ($images as $image) {
$image['title'] = htmlspecialchars($image['title']);
$loc = HTTP_SERVER . DIR_WS_CATALOG . $image['file'];
$tags .= ' ' . "\n";
$tags .= ' ' . $this->_clear_url($loc) . '' . "\n";
if ($caption == 'true') {
$tags .= ' ' . $image['title'] . '' . "\n";
$tags .= ' ' . $image['title'] . '' . "\n";
}
if ($license_url != '') {
if (substr($license_url, 0, 7) != 'http://' && substr($license_url, 0, 8) != 'https://') {
$license_url = HTTP_SERVER . DIR_WS_CATALOG . $license_url;
}
$tags .= ' ' . $this->_clear_url($license_url) . '' . "\n";
}
$tags .= ' ' . "\n";
}
return $tags;
}
/////////////////////////
function _checkFTimeSitemap($filename, $last_date=0) {
// TODO: Multifiles
if ($this->rebuild == true) return true;
if ($last_date == 0) return true;
clearstatcache();
if ( SITEMAPXML_USE_EXISTING_FILES == 'true'
&& file_exists($this->savepath . $filename)
&& (filemtime($this->savepath . $filename) >= strtotime($last_date))
&& filesize($this->savepath . $filename) > 0) {
echo '"' . $filename . '" ' . TEXT_FILE_NOT_CHANGED . '
';
return false;
}
return true;
}
function _getNameFileXML($filename) {
switch ($this->sitemapType) {
case 'index':
$filename = $this->sitemapindex;
break;
case 'video':
$filename = $this->videomap . $filename . '.xml' . ($this->compress ? '.gz' : '');
break;
case 'sitemap':
default:
$filename = $this->sitemap . $filename . '.xml' . ($this->compress ? '.gz' : '');
break;
}
return $filename;
}
// format the LastMod field
function _LastModFormat($date) {
if (SITEMAPXML_LASTMOD_FORMAT == 'full') {
return gmdate('Y-m-d\TH:i:s', $date) . $this->timezone;
} else {
return gmdate('Y-m-d', $date);
}
}
function _SitemapXMLHeader() {
$header = '';
$header .= '' . "\n";
$header .= ($this->stylesheet != '' ? 'stylesheet . '"?'.'>' . "\n" : "");
switch ($this->sitemapType) {
case 'index':
$header .= '' . "\n";
$header .= '' . "\n";
return $header;
}
function _SitemapPing() {
if ($this->submitFlag && SITEMAPXML_PING_URLS !== '') {
echo '' . TEXT_HEAD_PING . '
';
$pingURLs = explode(";", SITEMAPXML_PING_URLS);
foreach ($pingURLs as $pingURL) {
$pingURLarray = explode("=>", $pingURL);
if (!isset($pingURLarray[1])) $pingURLarray[1] = $pingURLarray[0];
$pingURLarray[0] = trim($pingURLarray[0]);
$pingURLarray[1] = trim($pingURLarray[1]);
$pingFullURL = sprintf($pingURLarray[1], $this->submit_url);
echo '' . TEXT_HEAD_PING . ' ' . $pingURLarray[0] . '
';
echo $pingFullURL . '
';
echo '';
if ($info = $this->_curlExecute($pingFullURL, 'page')) {
echo $this->_clearHTML($info['html_page']);
}
echo '
';
}
}
}
function _clearHTML($html) {
$html = str_replace(" ", " ", $html);
$html = preg_replace("@\s\s+@", " ", $html);
$html = preg_replace('@(.*)@si', '', $html);
$html = preg_replace('@@si', '', $html);
$html = preg_replace('@(.*)</'.'title>@si', '', $html);
$html = preg_replace('@(<br\s*[/]*>|<p.*>|</p>|</div>|</h\d+>)@si', "$1\n", $html);
$html = preg_replace("@\n\s+@", "\n", $html);
$html = strip_tags($html);
$html = trim($html);
$html = nl2br($html);
return $html;
}
function _outputSitemapIndex() {
header('Last-Modified: ' . gmdate('r') . ' GMT');
header('Content-Type: text/xml; charset=UTF-8');
header('Content-Length: ' . filesize($this->savepath . $this->sitemapindex));
// header('Content-disposition: inline; filename=' . $this->sitemapindex);
echo file_get_contents($this->savepath . $this->sitemapindex);
}
function _curlExecute($url, $read='page') {
if (!function_exists('curl_init')) {
echo TEXT_ERROR_CURL_NOT_FOUND . '<br />';
return false;
}
if (!$ch = curl_init()) {
echo TEXT_ERROR_CURL_INIT . '<br />';
return false;
}
$url = str_replace('&', '&', $url);
curl_setopt($ch, CURLOPT_URL, $url);
if ($read == 'page') {
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_NOBODY, 0);
@curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
} else {
curl_setopt($ch, CURLOPT_HEADER, 1);
curl_setopt($ch, CURLOPT_NOBODY, 1);
@curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 0);
}
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_FRESH_CONNECT, 1);
if (CURL_PROXY_REQUIRED == 'True') {
$proxy_tunnel_flag = (defined('CURL_PROXY_TUNNEL_FLAG') && strtoupper(CURL_PROXY_TUNNEL_FLAG) == 'FALSE') ? false : true;
curl_setopt($ch, CURLOPT_HTTPPROXYTUNNEL, $proxy_tunnel_flag);
curl_setopt($ch, CURLOPT_PROXYTYPE, CURLPROXY_HTTP);
curl_setopt($ch, CURLOPT_PROXY, CURL_PROXY_SERVER_DETAILS);
}
if (!$result = curl_exec($ch)) {
echo sprintf(TEXT_ERROR_CURL_EXEC, curl_error($ch), $url) . '<br />';
return false;
} else {
$info = curl_getinfo($ch);
curl_close($ch);
if (empty($info['http_code'])) {
echo sprintf(TEXT_ERROR_CURL_NO_HTTPCODE, $url) . '<br />';
// return false;
} elseif ($info['http_code'] != 200) {
// $http_codes = @parse_ini_file('includes/http_responce_code.ini');
// echo "cURL Error: Error http_code '<b>" . $info['http_code'] . " " . $http_codes[$info['http_code']] . "</b>' reading '" . $url . "'. " . '<br />';
echo sprintf(TEXT_ERROR_CURL_ERR_HTTPCODE, $info['http_code'], $url) . '<br />';
// return false;
}
if ($read == 'page') {
if ($info['size_download'] == 0) {
echo sprintf(TEXT_ERROR_CURL_0_DOWNLOAD, $url) . '<br />';
// return false;
}
if (isset($info['download_content_length']) && $info['download_content_length'] > 0 && $info['download_content_length'] != $info['size_download']) {
echo sprintf(TEXT_ERROR_CURL_ERR_DOWNLOAD, $url, $info['size_download'], $info['download_content_length']) . '<br />';
// return false;
}
$info['html_page'] = $result;
}
}
return $info;
}
///////////////////////
function _SitemapReSet() {
$this->_SitemapReSetFile();
$this->statisticModuleReset();
$this->sitemapFileItemsTotal = 0;
$this->sitemapFileSizeTotal = 0;
$this->sitemapFileNameNumber = 0;
$this->sitemapFileItemsMax = 0;
$this->duplicatedLinks = array();
return true;
}
function _SitemapReSetFile() {
// $this->sitemapFile = null;
// $this->sitemapType = null;
// $this->sitemapFileName = null;
$this->sitemapFileBuffer = '';
$this->sitemapFileItems = 0;
$this->sitemapFileSize = 0;
$this->sitemapFileNameNumber++;
return true;
}
function _SitemapCloseFile() {
if (!$this->_fileIsOpen()) return;
if ($this->sitemapFileItems > 0) {
$this->sitemapFileBuffer .= $this->sitemapFileFooter;
$this->sitemapFileSizeTotal += strlen($this->sitemapFileBuffer);
$this->_fileWrite($this->sitemapFileBuffer);
}
$this->_fileClose();
echo sprintf(TEXT_FILE_SITEMAP_INFO, $this->base_url . $this->sitemapFileName, $this->base_url . $this->sitemapFileName, $this->sitemapFileItems, $this->sitemapFileSize, filesize($this->savepath . $this->sitemapFileName)) . '<br />';
}
function statisticModuleReset() {
global $db;
$this->statisticModuleTime = microtime(true);
$this->statisticModuleQueries = $db->count_queries;
$this->statisticModuleQueriesTime = $db->total_query_time;
}
function _checkDublicateLoc($loc) {
global $db;
if ($this->checkDublicates == 'true') {
if (isset($this->duplicatedLinks[$loc])) return false;
$this->duplicatedLinks[$loc] = true;
} elseif ($this->checkDublicates == 'mysql') {
$url_hash = md5($loc);
$sql = "SELECT COUNT(*) AS total FROM " . TABLE_SITEMAPXML_TEMP . " WHERE url_hash=:urlHash";
$sql = $db->bindVars($sql, ':urlHash', $url_hash, 'string');
$check = $db->Execute($sql);
if ($check->fields['total'] > 0) return false;
$sql = "INSERT INTO " . TABLE_SITEMAPXML_TEMP . " SET url_hash=:urlHash";
$sql = $db->bindVars($sql, ':urlHash', $url_hash, 'string');
$db->Execute($sql);
}
return true;
}
///////////////////////
function _fileOpen($filename, $path='') {
if ($path == '') {
$path = $this->savepath;
}
$this->fn = $filename;
$this->fb = '';
if (is_file($path . $filename) && !is_writable($path . $filename)) {
@chmod($path . $filename, 0666);
}
if (substr($this->fn, -3) == '.gz') {
$this->fp = gzopen($path . $filename, 'wb9');
} else {
$this->fp = fopen($path . $filename, 'w+');
}
if (!$this->fp) {
// echo '<span style="font-weight:bold;color:red;">' . sprintf(TEXT_FAILED_TO_OPEN, $filename) . '</span>' . '<br />';
if (!is_file($path . $filename)) {
echo '<span style="font-weight:bold;color:red;">' . sprintf(TEXT_FAILED_TO_CREATE, $path . $filename) . '</span>' . '<br />';
} else {
echo '<span style="font-weight:bold;color:red;">' . sprintf(TEXT_FAILED_TO_CHMOD, $path . $filename) . '</span>' . '<br />';
}
$this->submitFlag = false;
}
return $this->fp;
}
function _fileIsOpen() {
if (!isset($this->fp) || $this->fp == false) return false;
return true;
}
function _fileWrite($data='') {
$ret = true;
if (strlen($this->fb) > $this->fb_maxsize || ($data == '' && strlen($this->fb) > 0)) {
if (substr($this->fn, -3) == '.gz') {
$ret = gzwrite($this->fp, $this->fb, strlen($this->fb));
} else {
$ret = fwrite($this->fp, $this->fb, strlen($this->fb));
}
$this->fb = '';
}
$this->fb .= $data;
return $ret;
}
function _fileClose() {
if (!isset($this->fp) || $this->fp == false) return;
if (strlen($this->fb) > 0) {
$this->_fileWrite();
}
if (substr($this->fn, -3) == '.gz') {
gzclose($this->fp);
} else {
fclose($this->fp);
}
unset($this->fp);
}
function timefmt($s) {
$m = floor($s/60);
$s = $s - $m*60;
return $m . ":" . number_format($s, 4);
}
function _clear_url($str) {
$url_parts = parse_url($str);
$out = '';
if (isset($url_parts["scheme"])) $out .= $url_parts["scheme"] . '://';
if (isset($url_parts["host"])) $out .= $url_parts["host"];
if (isset($url_parts["port"])) $out .= ':' . $url_parts["port"];
if (isset($url_parts["path"])) {
$pathinfo = pathinfo($url_parts["path"]);
if (!isset($pathinfo["dirname"]) || $pathinfo["dirname"] == '\\' || $pathinfo["dirname"] == '.') $pathinfo["dirname"] = '';
$out .= rtrim($pathinfo["dirname"], '/') . '/';
if ($pathinfo["basename"] != '') {
$out .= str_replace('&', '%26', rawurlencode($pathinfo["basename"]));
}
}
if (isset($url_parts["query"])) {
$url_parts["query"] = str_replace('&', '&', $url_parts["query"]);
$url_parts["query"] = str_replace('&&', '&', $url_parts["query"]);
$url_parts["query"] = str_replace('&', '&', $url_parts["query"]);
$out .= '?' . $url_parts["query"];
}
if (isset($url_parts["fragment"])) $out .= '#' . $url_parts["fragment"];
$out = $this->_utf8_encode($out);
return $out;
}
function _utf8_encode($str) {
if (!isset($this->convert_to_utf8)) {
$this->convert_to_utf8 = (strtolower(CHARSET) != 'utf-8');
}
if ($this->convert_to_utf8 === true) {
if (preg_match('@[\x7f-\xff]@', $str)) {
$str = iconv(CHARSET, 'utf-8', $str);
}
}
return $str;
}
function _clear_string($str) {
$str = $this->_clear_problem_characters($str);
$str = html_entity_decode($str, ENT_QUOTES);
$str = $this->_utf8_encode($str);
$str = htmlspecialchars($str);
$str = strip_tags($str);
return $str;
}
function _clear_problem_characters($str) {
$formattags = array("&");
$replacevals = array("&");
// $str = str_replace($formattags, $replacevals, $str);
$in = $out = array();
$in[] = '@&(amp|#038);@i'; $out[] = '&';
$in[] = '@&(#036);@i'; $out[] = '$';
$in[] = '@&(quot);@i'; $out[] = '"';
$in[] = '@&(#039);@i'; $out[] = '\'';
$in[] = '@&(nbsp|#160);@i'; $out[] = ' ';
$in[] = '@&(hellip|#8230);@i'; $out[] = '...';
$in[] = '@&(copy|#169);@i'; $out[] = '(c)';
$in[] = '@&(trade|#129);@i'; $out[] = '(tm)';
$in[] = '@&(lt|#60);@i'; $out[] = '<';
$in[] = '@&(gt|#62);@i'; $out[] = '>';
$in[] = '@&(laquo);@i'; $out[] = '';
$in[] = '@&(raquo);@i'; $out[] = '';
$in[] = '@&(deg);@i'; $out[] = '';
$in[] = '@&(mdash);@i'; $out[] = '';
$in[] = '@&(reg);@i'; $out[] = '';
$in[] = '@&();@i'; $out[] = '-';
$str = preg_replace($in, $out, $str);
return $str;
}
}