本帖最后由 members 于 2009-8-17 19:17 编辑
帮我把这个修改成资讯频道使用的可以吗?这个是模型m.php文件里取的
资讯频道那个使用的是block
catid- $listcount = $_SGLOBAL['db']->result($query,0);
- $multipage = '';
- $theurl = S_URL.'/m.php?'.str_replace('&page='.$page, '', $_SERVER["QUERY_STRING"]);
- if($listcount) {
- if(empty($isfixedsearch)) {
- $query = $_SGLOBAL['db']->query('SELECT * FROM '.tname($modelsinfoarr['modelname'].'items').' i, '
- .tname($modelsinfoarr['modelname'].'message').' m '
- .' WHERE i.itemid=m.itemid AND '.$wherecatid.$where
- .' ORDER BY '.(empty($orderbyarr[$_GET['mo_order']]) ? $orderbyarr[0] : $orderbyarr[$_GET['mo_order']]).' LIMIT '.$start.','.$perpage);
- } else {
- $query = $_SGLOBAL['db']->query('SELECT * FROM '.tname($modelsinfoarr['modelname'].'items').' i '
- .' WHERE '.$wherecatid.$where
- .' ORDER BY '.(empty($orderbyarr[$_GET['mo_order']]) ? $orderbyarr[0] : $orderbyarr[$_GET['mo_order']]).' LIMIT '.$start.','.$perpage);
- }
-
- while($value = $_SGLOBAL['db']->fetch_array($query)) {
- $value['ss_url'] = geturl('action/model/name/'.$modelsinfoarr['modelname'].'/itemid/'.$value['itemid']);
- if(!empty($value['subjectimage'])) {
- $fileext = fileext($value['subjectimage']);
- if($fileext == 'gif') {
- $value['ss_imgurl'] = A_URL.'/'.$value['subjectimage'];
- } else {
- $value['ss_imgurl'] = A_URL.'/'.substr($value['subjectimage'], 0, strrpos($value['subjectimage'], '.')).'.thumb.jpg';
- }
- } else {
- $value['ss_imgurl'] = S_URL.'/images/base/nopic.gif';
- }
-
- if(!empty($columnsinfoarr)) {
- foreach($columnsinfoarr as $temp) {
- if(empty($temp['allowshow']) || empty($temp['allowlist'])) {
- unset($columnsinfoarr[$temp['fieldname']]);
- } else {
- $tmpvalue = trim($value[$temp['fieldname']]);
- if($temp['formtype'] == 'checkbox' || $temp['formtype'] == 'textarea') {
- $value[$temp['fieldname']] = explode("\n", $tmpvalue);
- }
- }
- }
- }
- $value = strim(sstrip_tags($value));
- $listarr[] = $value;
- }
- $multipage = multi($listcount, $perpage, $page, $theurl);
- }
复制代码 |