www.gusucode.com > 08CMS空白站群系统 3.3 繁体 UTF-8 > upload/include/parse/commus.php

    <?php
!defined('M_COM') && exit('No Permission');
function cu_sqlstr(&$tag,$temparr,$type='c',$iscount=0){
	global $tblprefix;
	if(!($commu = read_cache('commu',$tag['cuid']))) return false;
	$sql = $sqlwhere = $sqlorder = '';
	$sqlselect = $iscount ? "SELECT COUNT(*)" : "SELECT *";
	$sqlfrom = " FROM {$tblprefix}".$commu['customtable'];
	if($tag['idsource'] == 'aid'){
		if(empty($temparr['aid'])) return false;
		$sqlwhere = " WHERE aid=".$temparr['aid'];
	}elseif($tag['idsource'] == 'mid'){
		if(empty($temparr['mid'])) return false;
		$sqlwhere = " WHERE mid=".$temparr['mid'];
	}
	if($tag['checked'] >= 0){
		if($commu['cclass'] == 'purchase'){
			$sqlwhere .= " AND oid".(empty($tag['checked']) ? '=' : '>')."0";
		}else $sqlwhere .= " AND checked = '".$tag['checked']."'";
	}
	$sqlorder = " ORDER BY createdate ".(empty($tag['orderby']) ? "DESC" : "ASC");
	$sql = $sqlselect.$sqlfrom.$sqlwhere.$sqlorder;
	return $sql;
}
?>