sprint.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
	+-------------------------------------------
	*/
	
	$cache_file	=	$wane_root.'globals/cache/cache_position.php';
	$cache_made	=	$wane_root.'globals/cache/cache_position_made.php';
	if (!file_exists($cache_file) || !file_exists($cache_made) )
	{
		unset($cache_file,$cache_made);
		require $wane_root.'globals/class_cache.php';
		$cache=new wanecache;
		$cache->update_cache(array('position','position_made'));
		echo 'Creating cache file.<BR>Please refresh the page.';
		exit;	
	}
	else
	{
		require $cache_file;
		require $cache_made;
		unset($cache_file);
	}

	eval($function->load_lang('view/spinfo'));

	if (!isset($info) || !is_numeric($info))
	{
		$function->clickback($VIEW_SP[UNDEFINED]);
	}
	else
	{
		/*
		+-----------------------------------------------
		+	which html should be loaded
		+-----------------------------------------------
		*/
		$tplfiles	=	array(
			'main'	=>	'spinfo_print.html',
		);	
		$function->load_tpl();			
		$tpl->set_var(
			array(
				'URL_TIME'	=>	'Date : '.$function->showtime('Y-m-d H:i',time()).' | IP : '.getenv("REMOTE_ADDR"),
				'URL_HOME'	=>	$default_url.'index.php',
				'URL_MEMCP'	=>	$default_url.'view.php?action=spinfo&info='.$info,
			)
		);		
		/*
		+-----------------------------------------------
		+	show sp info
		+-----------------------------------------------
		*/
		$query=$db->query("SELECT s.*,s.addtime as saddtime,s.losetime as slosetime,u.*,c.* FROM {$tablepre}spinfo s , {$tablepre}storeinfo u , {$tablepre}class c where s.sid!='0' and s.sid='$info' and (s.uid=u.uid or s.username=u.username) and c.cid=s.cid");
		if (!$db->num($query))
		{
			$function->clickback($VIEW_SP[UNEXISTS]);
		}
		else
		{
			require $wane_root.'globals/class_code.php';
			$tpl->set_var($VIEW_SP);
			$row=$db->row($query);
			$tpl->set_var(
				array(
					'WEBTITLE'	=>	$function->headtitle('[ '.$webtitle.' ] | '.$row[spname]),
					'NAVIGATA'	=>	'<a class=\'navigata\' href=\''.$default_url.'index.php?action=idx\'>'.$webtitle.'</a>'.$cache_position['cate_'.$row[cid]],
					'SPID'			=>	$info,
					'SQL_SPNAME'	=>	$row[spname],
					'SQL_SPNAME_QUESTION'	=>	urlencode($row[spname]),
					'SQL_CLICK'		=>	$row[click],
					
					'SQL_SPIMG'		=>	$row[spimg]==''	?	$default_url.'images/nophoto.gif'	:	(strpos($row[spimg],'http://')!==false	?	$row[spimg]	:	$default_url.$row[spimg])	,
					
					'PRICE_S_INFO'	=>	sprintf('%01.2f',$row[price_market]),
					'PRICE_M_INFO'	=>	sprintf('%01.2f',$row[price_member]),
					'PRICE_V_INFO'	=>	sprintf('%01.2f',$row[price_vip]),
					'SP_STATUS_INFO'=>	!$row[bid]	?	$VIEW_SP[SP_STATUS_COMMON]	:	$VIEW_SP[SP_STATUS_COMMEND]	,
					
					'SP_MADE_INFO'	=>	$cache_position_made['made_'.$row[mid]],
					'SP_COUNT_INFO'	=>	$row[spcount],
					'SP_SIZE_INFO'	=>	$row[spsize],
					
					'SQL_DISCUSS'	=>	$row['isdiscuss'] ? '<a href=\''.$default_url.'view.php?action=discuss&info='.$row['sid'].'\'>'.$row['replies'].'</a>' : '<font color=\'#ff0000\'>'.$VIEW_SP['SP_DISCUSS_CLOSE'].'</a>',
										
					'ADDTIME_INFO'	=>	$function->showtime('Y-m-d H:i',$row[saddtime]),
					'LOSETIME_INFO'	=>	!$row[slosetime]	?	$VIEW_SP[UNLOSETIME]	:	$function->showtime('Y-m-d H:i',$row[slosetime]),
					'SP_USER_INFO'	=>	$row[spuser],
					'SP_CONTEXT_INFO'	=>	wanecode($row[spcontext]),
										
					'ST_STORENAME'	=>	$row[storename],
					'ST_STOREID'	=>	$row[stid],
					'ST_UID'		=>	$row[uid]	?	'&uid='.$row[uid]	:	'&username='.urlencode($row[username])	,
					'ST_TRUENAME'	=>	$row[truename],
					'ST_PHONE'		=>	$row[phone],
					'ST_EMAIL'		=>	$row[email],
					'ST_QQ'			=>	$row[qq],
					'ST_MSN'		=>	$row[msn],
					'ST_URL'		=>	$row[url],
				)
			);
		}			
	}
	echo '<script>window.print();</script>'
?>