discuss.php

用PHP和MSSQL开发的sspace商城系统

<?php
	/*
	+-------------------------------------------
	|
	|   Technology of Wane netware
	|   ========================================
	|   Powered by wan-e.net inc 
	|   (c) 2004 wane.net Power Services
	|   http://www.wan-e.net
	|   ========================================
	|   Web: http://www.wan-e.net
	|
	+-------------------------------------------
	|   Autohr	:	wsfuyibing
	+-------------------------------------------
	*/
	if (!$allow_guestdiscuss && !$USER_CFG['LOGINED'] && $quotes)
	{
		require $wane_root.'globals/source/login.php';
	}
	elseif (!$allow_guestdiscuss && !$USER_CFG['LOGINED'] && $edit)
	{
		require $wane_root.'globals/source/login.php';
	}
	elseif ($submit && $discusssubmit)
	{	
		eval($function->load_lang('view/discuss'));
		if (!is_numeric($_POST['sid']) || $_POST['sid']<1)
		{
			$function->clickback($VIEW_DISCUSS['DISCUSS_CLOSE']);
		}
		elseif (empty($context))
		{
			$function->clickback($VIEW_DISCUSS['ACCESS_DISCUSS_CONTENT']);
		}
		elseif ($editid && is_numeric($editid) && $editid>0)
		{
			$db->query("UPDATE {$tablepre}spinfo_discuss SET title='$title',context='$context' WHERE id='$editid'");
			if ($html_onoff && $html_spinfo)
			{
				echo "<script src='{$default_url}view.php?action=spinfo&info={$sid}'></script>";
			}
			$function->showmsg($default_url.'view.php?action=discuss&info='.$sid,$VIEW_DISCUSS['DISCUSS_SUBMITEDIT_SUCCESS']);
		}
		else
		{
			$nowtime=time();
			$ipaddr=$function->onlineip();
			$db->query("INSERT INTO {$tablepre}spinfo_discuss (sid,uid,username,title,context,addtime,ipaddr) VALUES ('$sid','$wane_uid','$wane_user','$title','$context','$nowtime','$ipaddr')");
			$db->query("UPDATE {$tablepre}spinfo SET replies=replies+'1' WHERE sid='$sid'");			
			if ($html_onoff && $html_spinfo)
			{
				echo "<script src='{$default_url}view.php?action=spinfo&info={$sid}'></script>";
			}			
			$function->showmsg($default_url.'view.php?action=discuss&info='.$sid,$VIEW_DISCUSS['DISCUSS_SUBMIT_SUCCESS']);
		}
	}
	else
	{
		eval($function->load_lang('view/discuss'));
		$query_sp=$db->query("select sid,spname,htmlroot from {$tablepre}spinfo where sid='$info' and isdiscuss='1'");
		if (!$db->num($query_sp))
		{
			$function->clickback($VIEW_DISCUSS['DISCUSS_CLOSE']);
		}
		else
		{
			$row_sp=$db->row($query_sp);
			$navaextent = "<a href='".$tpl->linkurl($row_sp['sid'],$row_sp['htmlroot'],'spinfo')."'>$row_sp[spname]</a>";
			$db->free($query_sp);
			require $wane_root.'globals/class_code.php';
			$page_count	=	array("10","{$tablepre}spinfo_discuss","view.php?action=discuss&info=$info","where sid='$info'");
			require $wane_root.'globals/page_count.php';
			$query=$db->query("select * from $page_count[1] $page_count[3] order by addtime limit $offset,$show_count");
			
			if ($quotes && is_numeric($quotes))
			{
				$query_extent=$db->query("select * from {$tablepre}spinfo_discuss where id='$quotes' and sid='$info'");
				if ($db->num($query_extent))
				{
					$row_extent=$db->row($query_extent);
					$submit_title = 'RE:'.$row_extent['title'];
					$submit_text = "[quote]".$function->wane_str(preg_replace("/\[quote\](.+?)\[\/quote\]/is","",$row_extent['context']),300)."[/quote]\r\n";
					$submit_edit = '0';
					$db->free($query_extent);
				}
				else
				{
					$function->clickback($VIEW_DISCUSS['DISCUSS_CLOSE']);
				}
			}
			elseif ($edit && is_numeric($edit))
			{
				$query_extent=$db->query("select * from {$tablepre}spinfo_discuss where id='$edit' and sid='$info' and uid='$wane_uid'");
				if ($db->num($query_extent))
				{
					$row_extent=$db->row($query_extent);
					$submit_title = $row_extent['title'];
					$submit_text = $row_extent['context'];
					$submit_edit = $edit;
					$db->free($query_extent);
				}
				else
				{
					$function->clickback($VIEW_DISCUSS['DISCUSS_CLOSE']);
				}
			}
			else
			{
				$submit_title = '';
				$submit_text = '';
				$submit_edit = '0';
			}
			eval($tpl->set_var(array(
				'WEBTITLE'		=>	'['.$webtitle.'] '.$VIEW_DISCUSS['DISCUSS_TITLE'],
				'NAVIGATA'		=>	"<a href='{$default_url}index.php?action=idx' class='navigata'>$webtitle</a>&nbsp;$category_separate&nbsp;$navaextent&nbsp;$category_separate&nbsp;".$VIEW_DISCUSS['DISCUSS_TITLE'],
				'SQL_QUOTE_TITLE'	=>	$submit_title,
				'SQL_QUOTE_CONTEXT'	=>	$submit_text,
				'SQL_EDITID'		=>	$submit_edit
			)));
			if (!$allow_guestdiscuss && !$USER_CFG['LOGINED'])
			{
				eval($function->load_lang('login'));
			}
			$tplfiles	=	array('header','discuss_show','footer');	
		}
	}
?>