advertisements.inc.php

极限网络智能办公系统 Office Automation V3.0官方100％源代码.

<?php

/*
	[Discuz!] (C)2001-2007 Comsenz Inc.
	This is NOT a freeware, use is subject to license terms

	$RCSfile: advertisements.inc.php,v $
	$Revision: 1.43.2.1 $
	$Date: 2007/03/21 15:52:02 $
*/

if(!defined('IN_DISCUZ') || !defined('IN_ADMINCP')) {
        exit('Access Denied');
}

require_once DISCUZ_ROOT.'./forumdata/cache/cache_forums.php';

cpheader();

if($action == 'adv') {

	if(!submitcheck('advsubmit')) {

		$advs = '';
		$page = max(1, intval($page));
		$start_limit = ($page - 1) * 15;

		$query = $db->query("SELECT COUNT(*) FROM {$tablepre}advertisements");
		$advnum = $db->result($query, 0);

		$query = $db->query("SELECT * FROM {$tablepre}advertisements ORDER BY type, displayorder, targets DESC LIMIT $start_limit, 15");
		while($adv = $db->fetch_array($query)) {
			$adv['type'] = $lang['advertisements_type_'.$adv['type']];

			if($adv['targets'] == '' || $adv['targets'] == 'forum') {
				$adv['targets'] = $lang['all'];
			} else {
				$targetsarray = array();
				foreach(explode("\t", $adv['targets']) as $target) {
					$targetsarray[] = $target == 'register' ? '<a href="register.php" target="_blank">'.$lang['advertisements_register'].'</a>' :
						($target == 'redirect' ? $lang['advertisements_jump'] :
						($target == 'archiver' ? '<a href="archiver/" target="_blank">Archiver</a>' :
						($target ? '<a href="forumdisplay.php?fid='.$target.'" target="_blank">'.$_DCACHE['forums'][$target]['name'].'</a>' : '<a href="'.$indexname.'" target="_blank">'.$lang['home'].'</a>')));
				}
				$adv['targets'] = implode(', ', $targetsarray);
			}

			$adv['parameters'] = unserialize($adv['parameters']);

			$advs .= "<tr align=\"center\" ".($adv['endtime'] && $adv['endtime'] <= $timestamp ? 'style="text-decoration: line-through"' : '')."><td class=\"altbg1\"><input class=\"checkbox\" type=\"checkbox\" name=\"delete[]\" value=\"$adv[advid]\"></td>".
				"<td class=\"altbg2\"><input class=\"checkbox\" type=\"checkbox\" name=\"availablenew[$adv[advid]]\" value=\"1\" ".($adv['available'] ? 'checked' : '')."></td>".
				"<td class=\"altbg1\"><input type=\"text\" size=\"2\" name=\"displayordernew[$adv[advid]]\" value=\"$adv[displayorder]\"></td>".
				"<td class=\"altbg2\"><input type=\"text\" size=\"15\" name=\"titlenew[$adv[advid]]\" value=\"".dhtmlspecialchars($adv['title'])."\"></td>".
				"<td class=\"altbg1\">$adv[type]</td>".
				"<td class=\"altbg2\">".$lang['advertisements_style_'.$adv['parameters']['style']]."</td>".
				"<td class=\"altbg1\">".($adv['starttime'] ? gmdate($dateformat, $adv['starttime'] + $_DCACHE['settings']['timeoffset'] * 3600) : $lang['unlimited'])."</td>".
				"<td class=\"altbg2\">".($adv['endtime'] ? gmdate($dateformat, $adv['endtime'] + $_DCACHE['settings']['timeoffset'] * 3600) : $lang['unlimited'])."</td>".
				"<td class=\"altbg1\">$adv[targets]</td>".
				"<td class=\"altbg2\"><a href=\"admincp.php?action=advedit&advid=$adv[advid]\">[$lang[detail]]</a></td></tr>";
		}

		$multipage = multi($advnum, 15, $page, "admincp.php?action=adv");
		shownav('menu_misc_advertisements');

?>
<form method="post" action="admincp.php?action=advadd">
<input type="hidden" name="formhash" value="<?=FORMHASH?>">
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="tableborder">
<tr class="header"><td><?=$lang['advertisements_add']?></td></tr>
<tr><td class="category">
<?=$lang['advertisements_edit_title']?> <input style="vertical-align: middle" type="text" name="title" value="" size="25" maxlength="50"> &nbsp;&nbsp;
<?=$lang['advertisements_edit_style']?> <select style="vertical-align: middle" name="style"><option value="code" <?=$styleselect['code']?>> <?=$lang['advertisements_style_code']?></option><option value="text" <?=$styleselect['text']?>> <?=$lang['advertisements_style_text']?></option><option value="image" <?=$styleselect['image']?>> <?=$lang['advertisements_style_image']?></option><option value="flash" <?=$styleselect['flash']?>> <?=$lang['advertisements_style_flash']?></option></select> &nbsp;&nbsp;
<select onchange="if(this.options[this.selectedIndex].value) {this.form.submit()}" style="vertical-align: middle" name="type"><option value=""> <?=$lang['advertisements_type']?></option><option value="headerbanner"> <?=$lang['advertisements_type_headerbanner']?></option><option value="footerbanner"> <?=$lang['advertisements_type_footerbanner']?></option><option value="text"> <?=$lang['advertisements_type_text']?></option><option value="thread"> <?=$lang['advertisements_type_thread']?></option><option value="interthread"> <?=$lang['advertisements_type_interthread']?></option><option value="float"> <?=$lang['advertisements_type_float']?></option><option value="couplebanner"> <?=$lang['advertisements_type_couplebanner']?></option><option value="intercat"> <?=$lang['advertisements_type_intercat']?></option></select>
</td></tr></table><br>
</form>

<form method="post" action="admincp.php?action=adv">
<input type="hidden" name="formhash" value="<?=FORMHASH?>">
<?=$multipage?>
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="tableborder">
<tr class="header"><td width="3%" nowrap><input class="checkbox" type="checkbox" name="chkall" onclick="checkall(this.form,'delete')"><?=$lang['del']?></td>
<td width="5%" nowrap><?=$lang['available']?></td>
<td width="8%" nowrap><?=$lang['display_order']?></td>
<td width="15%" nowrap><?=$lang['subject']?></td>
<td width="12%" nowrap><?=$lang['type']?></td>
<td width="5%" nowrap><?=$lang['advertisements_style']?></td>
<td width="10%" nowrap><?=$lang['start_time']?></td>
<td width="10%" nowrap><?=$lang['end_time']?></td>
<td width="20%" nowrap><?=$lang['advertisements_targets']?></td>
<td width="6%" nowrap><?=$lang['edit']?></td></tr>
<?=$advs?>
</table>
<?=$multipage?>
<br><center><input class="button" type="submit" name="advsubmit" value="<?=$lang['submit']?>"></center>
</form>
<?

	} else {

		if($advids = implodeids($delete)) {
			$db->query("DELETE FROM {$tablepre}advertisements WHERE advid IN ($advids)");
		}

		if(is_array($titlenew)) {
			foreach($titlenew as $advid => $title) {
				$db->query("UPDATE {$tablepre}advertisements SET available='$availablenew[$advid]', displayorder='$displayordernew[$advid]', title='".cutstr($titlenew[$advid], 50)."' WHERE advid='$advid'", 'UNBUFFERED');
			}
		}

		updatecache('settings');
		updatecache('advs');

		cpmsg('advertisements_update_succeed', 'admincp.php?action=adv');

	}

} elseif($action == 'advadd' && in_array($type, array('headerbanner', 'footerbanner', 'text', 'thread', 'interthread', 'float', 'couplebanner', 'intercat')) || ($action == 'advedit' && $advid)) {

	if(!submitcheck('advsubmit')) {

		require_once DISCUZ_ROOT.'./include/forum.func.php';

		shownav('menu_misc_advertisements');

		if($action == 'advedit') {
			$query = $db->query("SELECT * FROM {$tablepre}advertisements WHERE advid='$advid'");
			if(!$adv = $db->fetch_array($query)) {
				cpmsg('undefined_action');
			}
			$adv['parameters'] = unserialize($adv['parameters']);
			if(in_array($adv['type'], array('footerbanner', 'thread'))) {
				$adv['parameters']['position'] = isset($adv['parameters']['position']) && in_array($adv['parameters']['position'], array(2, 3)) ? $adv['parameters']['position'] : 1;
				$positionchecked = array($adv['parameters']['position'] => 'checked');
				if($adv['type'] == 'thread') {
					$dispchecked = array();
					foreach((isset($adv['parameters']['displayorder']) ? explode("\t", $adv['parameters']['displayorder']) : array('0')) AS $postcount) {
						$dispchecked[$postcount] = ' selected="selected"';
					}
				}
			}
			$type = $adv['type'];
		} else {
		        $title = cutstr($title, 50);
		        $style = in_array($style, array('text', 'image', 'flash')) ? $style : 'code';
			$adv = array('type' => $type, 'title' => $title, 'parameters' => array('style' => $style), 'starttime' => $timestamp);
			$positionchecked = array(1 => 'checked');
			$dispchecked = array(0 => ' selected="selected"');
		}

		$adv['targets'] = $adv['targets'] != '' && $adv['targets'] != 'forum' ? explode("\t", $adv['targets']) : array('all');

		if($type == 'intercat') {
			$targetsselect = '<select name="advnew[targets][]" selected="selected"><option value="0">&nbsp;&nbsp;> '.$lang['home'].'</option></select>';
		} else {
			$targetsselect = '<select name="advnew[targets][]" size="10" multiple="multiple"><option value="all">&nbsp;&nbsp;> '.$lang['all'].'</option>'.
				'<option value="">&nbsp;</option>'.
				(in_array($type, array('thread', 'interthread')) ? '' : '<option value="0">&nbsp;&nbsp;> '.$lang['home'].'</option>').
				(in_array($type, array('headerbanner', 'footerbanner')) ? '</option><option value="register">&nbsp;&nbsp;> '.$lang['advertisements_register'].'</option>'.
				'</option><option value="redirect">&nbsp;&nbsp;> '.$lang['advertisements_jump'].'</option>'.
				'</option><option value="archiver">&nbsp;&nbsp;> Archiver</option>' : '').
				'</option>'.forumselect().'</select>';