Файл: InstantSocial/uploud/modules/mod_reklama/module.php
Строк: 73
<?php
/*********************************************************************************************/
// //
// www.instantcmsdev.ru //
// //
// //
// //
// //
/*********************************************************************************************/
function mod_reklama($module_id){
$inCore = cmsCore::getInstance();
$inDB = cmsDatabase::getInstance();
$cfg = $inCore->loadModuleConfig($module_id);
$inCore->loadModel('reklama');
$model = new cms_model_reklama();
echo '<p style="margin-bottom:10px;"><a href="/reklama">Как разместить рекламу?</a></p>';
if(!$cfg['countitem']){$cfg['countitem'] = 5;}
if(!$cfg['width']){$cfg['width'] = 100;}
$inDB = cmsDatabase::getInstance();
$sql = "SELECT * FROM cms_reklama_config";
$result = $inDB->query($sql);
$conf = $inDB->fetch_assoc($result);
$sql = "SELECT * FROM cms_reklama WHERE published = 1 AND maxlimit = 0 AND daylimit = 0 AND bal = 1 AND blocking = 0 ORDER BY RAND() LIMIT {$cfg['countitem']}";
$result = $inDB->query($sql);
if ($inDB->num_rows($result) !==0){
while($item = $inDB->fetch_assoc($result)){
$items[] = $item;
}
}
echo '<div style="margin: 0 auto;">';
foreach($items as $item){
$datehit = date('Y-m-d');
$sql = "SELECT hity FROM cms_reklama_hits WHERE reklama_id = {$item['id']} AND hitdate = '{$datehit}'";
$result = $inDB->query($sql);
$hit = $inDB->fetch_assoc($result);
if($item['day'] == 0){
$inDB->query("UPDATE cms_reklama SET daylimit = 0 WHERE id = {$item['id']}");
}else{
if ($hit['hity'] >= $item['day']){
$inDB->query("UPDATE cms_reklama SET daylimit = 1 WHERE id = {$item['id']}");
}else{
$inDB->query("UPDATE cms_reklama SET daylimit = 0 WHERE id = {$item['id']}");
}
}
if ($item['hity'] >= $item['max']){
$inDB->query("UPDATE cms_reklama SET maxlimit = 1 WHERE id = {$item['id']}");
}else{
$inDB->query("UPDATE cms_reklama SET maxlimit = 0 WHERE id = {$item['id']}");
}
$sql = "SELECT * FROM cms_reklama_balans WHERE user_id = {$item['user_id']}";
$result = $inDB->query($sql);
$usbal = $inDB->fetch_assoc($result);
if($usbal['balans'] <= 0){
$inDB->query("UPDATE cms_reklama SET bal = 0 WHERE id = {$item['id']}");
}
$size_xy = $cfg['width']+6;
$size_xw = $conf['img_w']+6;
$witdh_class = $model->widthClass($cfg['width']);
$width_style = $conf['img_w']+8;
$widthcount = 100/$cfg['countitem'];
$widthcount = str_replace(',','.',$widthcount);
if($cfg['width'] == 'cfg'){
echo '<div class="reklama" style="width:'.$widthcount.'%;">'.$item['balans'].'
<a href="/reklama/click-'.$item['id'].'" target="_blank" style="width:'.$width_style.'px;">
<span title="'.str_replace("<br>"," ",$item['text']).'" style="width:'.$size_xw.'px; height:'.$size_xw.'px; background-image:url('/images/tizers/small'.$cfg['width'].'/'.$item['img'].'');"></span>
'.$item['text'].'
</a>
</div>';
}else{
echo '<div class="reklama" style="width:'.$widthcount.'%;">'.$item['balans'].'
<a href="/reklama/click-'.$item['id'].'" target="_blank" class="'.$witdh_class.'">
<span title="'.str_replace("<br>"," ",$item['text']).'" style="width:'.$size_xy.'px; height:'.$size_xy.'px; background-image:url('/images/tizers/small'.$cfg['width'].'/'.$item['img'].'');"></span>
'.$item['text'].'
</a>
</div>';
}
$inDB->query("UPDATE cms_reklama SET hity = hity + 1 WHERE id = {$item['id']}");
$inDB->query("UPDATE cms_reklama_balans SET balans = balans - 1 WHERE user_id = {$item['user_id']}");
$date = date('Y-m-d');
$sql = "SELECT * FROM cms_reklama_hits WHERE reklama_id = {$item['id']} AND hitdate = '$date'";
$result = $inDB->query($sql);
if (!$inDB->num_rows($result)){
$inDB->query("INSERT INTO cms_reklama_hits (reklama_id, hitdate, hity) VALUES ({$item['id']}, '$date', 1)");
}else{
$inDB->query("UPDATE cms_reklama_hits SET hity = hity + 1, hitdate = '$date' WHERE reklama_id = {$item['id']} AND hitdate = '$date'");
}
}
echo '</div>';
echo '<div style="clear:both;"></div>';
return true;
}
?>