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