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; } ?>