File size: 1.32Kb
<?php
/**
* Created by PhpStorm.
* User: Venom
* Date: 07.11.13
* Time: 3:17
*/
?>
<?
echo '<div class="blockheader"><h3 class="t">Реклама</h3></div>';
echo '<div class="blockcontent"><ul>';
$sett = $mysqli->query("SELECT * FROM `ads_settings`")->fetch_assoc();
$sql = $mysqli->query("SELECT * FROM `ads` WHERE `pay` = '1' AND `date` >= NOW() OR `pay` = '1' AND `total` > 0 ORDER BY `id` LIMIT ".$sett['links']."");
while($row = $sql->fetch_assoc()) {
if(substr_count($row['name'], '|') > 0) {
$arr_name = explode("|", $row['name']);
$rand = array_rand($arr_name);
$name = htmlspecialchars($arr_name[$rand]);
} else $name = htmlspecialchars($row['name']);
echo '<li>'.($row['bold']==1?'<b>':NULL).'<a href="/link.php?id='.$row['id'].'"><font color="'.$row['color'].'">'.$name.'</font></a>'.($row['bold']==1?'</b>':NULL).'</li>';
}
$rek = $mysqli->query("SELECT `id`,`name`,`position`,`link`,`color` FROM `".$prefix."rekl` WHERE `stat` = '1' ORDER BY RAND() LIMIT 3");
if($rek->num_rows > 0)
{
while($row = $rek->fetch_assoc())
{
echo '<li><a href="http://'.$row['link'].'"><font color=#'.$row['color'].'>'.$row['name'].'</font></a></li>';
}
}
echo '</ul></div><!-- /.adv -->';
?>
<div class="blockheader">
<h3 class="t">Партнеры</h3>
</div>
<div class="blockcontent">
</div>