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

    <?php
!defined('M_COM') && exit('No Permission');
function v_sqlstr(&$tag,$type='c',$iscount=0){
	global $vcatalogs,$tblprefix,$timestamp;
	$sql = $sqlorder = '';
	$sqlwhere = " WHERE checked=1 AND (enddate=0 OR enddate>$timestamp)";
	$sqlselect = $iscount ? "SELECT COUNT(*)" : "SELECT *";
	$sqlfrom = " FROM {$tblprefix}votes";
	if(!empty($tag['vsource'])){
		if(empty($vcatalogs[$tag['vsource']])) return false;
		$sqlwhere .= " AND caid='".$tag['vsource']."'";
	}
	if(!empty($tag['vids'])){
		$vids = explode(',',$tag['vids']);
		foreach($vids as $k => $v) $vids[$k] = max(0,intval($v));
		$sqlwhere .= " AND vid IN (".mimplode($vids).")";
		unset($vids);
	}
	if(!$iscount){
		$sqlorder = " ORDER BY vieworder,vid DESC";
	}
	$sql = $sqlselect.$sqlfrom.$sqlwhere.$sqlorder;
	return $sql;
}

?>