<?php

$cache_expires_time = 120;

if(!defined('TEXTLINKS_FILE'))
	define('TEXTLINKS_FILE', 'my_cache/textlinks.inc');

if(!isset($textlinks_array) && is_file(TEXTLINKS_FILE)
	&& filemtime(TEXTLINKS_FILE) > (time()-$cache_expires_time)){
	$textlinks_array = @unserialize(file_get_contents(TEXTLINKS_FILE));
}else{
	$mysql_queries="0";
	require('config.php');
	$res = mysql_query("SELECT `date`,`date_end`,`url`,`description` FROM `tb_ads_txt` WHERE `status`='pay'");
	if(mysql_num_rows($res)>0) {
		while($row = mysql_fetch_assoc($res)) 
			$textlinks_array[] = array('dataN' => $row['date'], 'dataO' => $row['date_end'], 'link' => $row['url'], 'text' => $row['description']);
	}
	if(!isset($textlinks_array)) $textlinks_array = array();
	if(is_file(TEXTLINKS_FILE)){
		file_put_contents(TEXTLINKS_FILE, serialize($textlinks_array));
	}
}

if(isset($textlinks_array[0])) {
	$textlink = $textlinks_array[rand(0, count($textlinks_array)-1)];
	echo '<a rel="nofollow" href="'.$textlink['link'].'" target="_blank" class="block"><b>'.$textlink['text'].'</b></a>';
}else{
	echo '';
}

unset($cache_expires_time, $res, $textlinks_array);
?>