adsplace_view.inc.php

来自「采用模块化开发」· PHP 代码 · 共 18 行

<?php
defined('IN_PHPCMS') or exit('Access Denied');

$placeid = intval($placeid);

$query ="SELECT * FROM ".TABLE_ADS." AS a LEFT JOIN ".TABLE_ADS_PLACE." AS p ON (a.placeid=p.placeid) WHERE a.placeid=".$placeid." AND a.fromdate<=UNIX_TIMESTAMP() AND a.todate>=UNIX_TIMESTAMP() AND p.passed=1 AND a.passed=1 AND a.checked=1 ORDER BY a.addtime";
$ads = $db->get_one($query);
if(!$ads) exit('document.write("")');

$db->query("UPDATE ".TABLE_ADS." SET views=views+1 WHERE adsid=".$ads['adsid']);

$content = ads_content($ads);
$templateid = $ads['templateid'] ? $ads['templateid'] : 'ads';

echo "<SCRIPT LANGUAGE='JavaScript'>";
include template('ads',$templateid);
echo "</SCRIPT>";
?>