magics.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: magics.inc.php,v $
	$Revision: 1.15.2.2 $
	$Date: 2007/03/21 15:52:02 $
*/

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

cpheader();
if(!isfounder()) cpmsg('noaccess');

if($action == 'magic_config') {

	if(!submitcheck('magicsubmit')) {

		$settings = array();
		$query = $db->query("SELECT variable, value FROM {$tablepre}settings WHERE variable IN ('magicstatus', 'magicmarket', 'maxmagicprice')");
		while($setting = $db->fetch_array($query)) {
			$settings[$setting['variable']] = $setting['value'];
		}

		shownav('magics');

?>
<form method="post" name="settings" action="admincp.php?action=magic_config">
<input type="hidden" name="formhash" value="<?=FORMHASH?>">
<?

		showtype('magics_config', 'top');
		showsetting('magics_open', 'settingsnew[magicstatus]', $settings['magicstatus'], 'radio');
		showsetting('magics_market_open', 'settingsnew[magicmarket]', $settings['magicmarket'], 'radio');
		showsetting('magics_market_percent', 'settingsnew[maxmagicprice]', $settings['maxmagicprice'], 'text');
		showtype('', 'bottom');

?>
<br><center><input type="submit" class="button" name="magicsubmit" value="<?=$lang['submit']?>"></form>
<?

	} else {

		if(is_array($settingsnew)) {
			foreach($settingsnew as $variable => $value) {
				$db->query("UPDATE {$tablepre}settings SET value='$value' WHERE variable='$variable'");
			}
		}

		updatecache('settings');

		cpmsg('magics_config_succeed', 'admincp.php?action=magic_config');
	}


} elseif($action == 'magic') {

	if(!submitcheck('magicsubmit')) {

		$magiclist = '';
		$addtype = $typeid ? "WHERE type='".intval($typeid)."'" : '';

		$query = $db->query("SELECT * FROM {$tablepre}magics $addtype ORDER BY displayorder");
		while($magic = $db->fetch_array($query)) {
			$magictype = $lang['magics_type_'.$magic['type']];

			$magiclist .= "<tr align=\"center\">\n".
				"<td class=\"altbg1\"><input type=\"checkbox\" class=\"checkbox\" name=\"delete[]\" value=\"$magic[magicid]\"></td>\n".
				"<td class=\"altbg2\"><input type=\"text\" size=\"3\" name=\"displayorder[$magic[magicid]]\" value=\"$magic[displayorder]\"></td>\n".
				"<td class=\"altbg1\"><input type=\"text\" size=\"10\" name=\"name[$magic[magicid]]\" value=\"$magic[name]\"></td>\n".
				"<td class=\"altbg2\"><a href=\"admincp.php?action=magic&typeid=$magic[type]\">$magictype</a></td>\n".
				"<td class=\"altbg1\"><input type=\"text\" size=\"5\" name=\"price[$magic[magicid]]\" value=\"$magic[price]\"></td>\n".
				"<td class=\"altbg2\"><input type=\"text\" size=\"5\" name=\"num[$magic[magicid]]\" value=\"$magic[num]\"></td>\n".
				"<td class=\"altbg1\"><input type=\"text\" size=\"25\" name=\"description[$magic[magicid]]\" value=\"$magic[description]\"></td>\n".
				"<td class=\"altbg2\"><input type=\"hidden\" name=\"identifier[$magic[magicid]]\" value=\"$magic[identifier]\">$magic[identifier]</td>\n".
				"<td class=\"altbg1\"><input type=\"checkbox\" class=\"checkbox\" name=\"available[$magic[magicid]]\" value=\"1\" ".(!$magic['name'] || !$magic['identifier'] || !$magic['filename'] ? 'disabled' : ($magic['available'] ? 'checked' : ''))."></td>\n".
				"<td class=\"altbg2\"><a href=\"admincp.php?action=magicedit&magicid=$magic[magicid]\">[$lang[detail]]</a></td>\n";
		}
		shownav('magics');
		showtips('magics_tips');

?>
<form method="post" action="admincp.php?action=magic">
<input type="hidden" name="formhash" value="<?=FORMHASH?>">
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="tableborder">
<tr class="header">
<td colspan="10"><?=$lang['magics_edit']?></td></tr>
<tr align="center" class="category">
<td><input type="checkbox" name="chkall" class="checkbox" onclick="checkall(this.form)"><?=$lang['del']?></td>
<td><?=$lang['display_order']?></td><td><?=$lang['name']?></td><td><?=$lang['type']?></td>
<td><?=$lang['price']?></td><td><?=$lang['num']?></td><td><?=$lang['description']?></td><td><?=$lang['magics_identifier']?></td><td><?=$lang['available']?></td><td><?=$lang['detail']?></td>
</tr>
<?=$magiclist?>
<tr class="altbg1" align="center">
<td><?=$lang['add_new']?></td>
<td><input type="text" size="3"	name="newdisplayorder"></td>
<td><input type="text" size="10" name="newname"></td>
<td><select name="newtype"><option value="1" selected><?=$lang['magics_type_1']?></option><option value="2"><?=$lang['magics_type_2']?></option><option value="3"><?=$lang['magics_type_3']?></option></select></td>
<td><input type="text" size="5" name="newprice"></td>
<td><input type="text" size="5" name="newnum"></td>
<td><input type="text" size="25" name="newdescription"></td>
<td><input type="text" size="5" name="newidentifier"></td>
<td></td><td></td>
</tr></table><br>
<center><input type="submit" class="button" name="magicsubmit" value="<?=$lang['submit']?>"></center></form></td></tr>
<?

	} else {

		$newname = dhtmlspecialchars(trim($newname));
		$newidentifier = dhtmlspecialchars(trim(strtoupper($newidentifier)));

		if($ids = implodeids($delete)) {
			$db->query("DELETE FROM {$tablepre}magics WHERE magicid IN ($ids)");
			$db->query("DELETE FROM {$tablepre}membermagics WHERE magicid IN ($ids)");
			$db->query("DELETE FROM {$tablepre}magicmarket WHERE magicid IN ($ids)");
			$db->query("DELETE FROM {$tablepre}magiclog WHERE magicid IN ($ids)");
		}

		if(is_array($name)) {
			foreach($name as $id =>	$val) {
				$db->query("UPDATE {$tablepre}magics SET available='$available[$id]', name='$name[$id]', identifier='$identifier[$id]', description='$description[$id]', displayorder='$displayorder[$id]', price='$price[$id]', num='$num[$id]' WHERE magicid='$id'");
			}
		}

		if($newname != '') {
			$query = $db->query("SELECT magicid FROM {$tablepre}magics WHERE identifier='$newidentifier'");
			if($db->num_rows($query)) {
				cpmsg('magics_identifier_invalid');
			}
			$db->query("INSERT INTO {$tablepre}magics (type, name, identifier, description, displayorder, price, num) VALUES ('$newtype', '$newname', '$newidentifier', '$newdescription', '$newdisplayorder', '$newprice', '$newnum')");
		}

		updatecache('magics');
		cpmsg('magics_data_succeed', 'admincp.php?action=magic');

	}

} elseif($action == 'magicedit') {

	if(!submitcheck('magiceditsubmit')) {

		$magicid = intval($magicid);

		$query = $db->query("SELECT * FROM {$tablepre}magics WHERE magicid='$magicid'");
		$magic = $db->fetch_array($query);

		$magicperm = unserialize($magic['magicperm']);

		$groups = $fourms = array();
		$query = $db->query("SELECT groupid, grouptitle FROM {$tablepre}usergroups");
		while($group = $db->fetch_array($query)) {
			$groups[] = $group;
		}

		$query = $db->query("SELECT fid, name FROM {$tablepre}forums WHERE type NOT IN ('group') AND status>0");
		while($forum = $db->fetch_array($query)) {
			$forums[] = $forum;
		}

		$usergroupsperm = $targetgroupsperm = $forumperm = '';

		$num = -1;
		$usergroupsperm = "<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"100%\" align=\"center\"><tr>";

		foreach($groups as $group) {
			$num++;
			if($num && $num % 4 == 0) {
				$usergroupsperm .= "</tr><tr>";
			}
			$checked = strstr($magicperm['usergroups'], "\t$group[groupid]\t") ? 'checked' : NULL;
			$usergroupsperm .= "<td style=\"border:0px\"><input type=\"checkbox\" class=\"checkbox\" name=\"usergroupsperm[]\" value=\"$group[groupid]\" $checked> $group[grouptitle]</td>\n";
		}
		$usergroupsperm .= '</tr></table>';

		$num = -1;
		$targetgroupsperm = "<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"100%\" align=\"center\"><tr>";

		foreach($groups as $group) {
			$num++;
			if($num && $num % 4 == 0) {
				$targetgroupsperm .= "</tr><tr>";
			}
			$checked = strstr($magicperm['targetgroups'], "\t$group[groupid]\t") ? 'checked' : NULL;
			$targetgroupsperm .= "<td style=\"border:0px\"><input type=\"checkbox\" class=\"checkbox\" name=\"targetgroupsperm[]\" value=\"$group[groupid]\" $checked> $group[grouptitle]</td>\n";
		}
		$targetgroupsperm .= '</tr></table>';

		$num = -1;
		$forumperm = "<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"100%\" align=\"center\"><tr>";
		foreach($forums as $forum) {
			$num++;
			if($num && $num % 4 == 0) {
				$forumperm .= "</tr><tr>";
			}
			$checked = strstr($magicperm['forum'], "\t$forum[fid]\t") ? 'checked' : NULL;
			$forumperm .= "<td style=\"border:0px\"><input type=\"checkbox\" class=\"checkbox\" name=\"forumperm[]\" value=\"$forum[fid]\" $checked>  $forum[name]</td>\n";
		}
		$forumperm .= '</tr></table>';

		$checksupplytype = array($magic['supplytype'] => 'checked');

		shownav('magics');
		showtips('magics_edit_tips');

?>
<form method="post" action="admincp.php?action=magicedit&magicid=<?=$magicid?>">
<input type="hidden" name="formhash" value="<?=FORMHASH?>">
<?

		$typeselect = array($magic['type'] => 'selected');
		showtype($lang['magics_edit'].' - '.$magic['name'], 'top');
		showsetting('magics_edit_name', 'namenew', $magic['name'], 'text');
		showsetting('magics_edit_identifier', 'identifiernew', $magic['identifier'], 'text');