再次感谢开源， 发个首页分类调用mymps_get_info_list()的改进

239300

1. function mymps_get_info_list($num=10,$len=70,$info_level='',$upgrade_type='',$userid='',$catid=''){//增加标题长度控制默认70
   
2. //function mymps_get_info_list($num=10,$info_level='',$upgrade_type='',$userid='',$catid=''){
     Z) ~7 X! ]1 d  q7 E$ N
3. global $db,$db_mymps,$mymps_global;
   3 t' i, B" E& J% X/ v: _1 U
4. 
   # F, g) |$ O1 F- g! W
5. foreach(explode(',',$catid) as $k=>$v) $cid .=get_cat_children($v).',';//此行增加：多分类同时调用
   
6. $cid=substring($cid,0,strlen($cid)-1);//此行增加：多分类同时调用
   + d- h2 \  Q+ i- N5 l3 u1 ^9 K
7. 
   / X2 G3 P; l4 M
8. $where .= empty($info_level)? 'WHERE a.info_level > 0 ':'WHERE a.info_level = '.$info_level;
   % b. P# m" u, V1 `! p. s4 I
9. $where .= $userid ? ' AND a.userid = "'.$userid.'"' : '';
   , o& Q4 X( V9 C- A
10. // $where .= $catid ? ' AND a.catid IN ('.get_cat_children($catid).')':'';
    ' u  _/ C8 _& o5 E
11. $where .= $catid ? ' AND a.catid IN ('.$cid.')':'';//此行增加：多分类同时调用
    $ h6 m+ B% T8 T! ?! s' v2 K
12. $where .= ($upgrade_type == '')? '' : ' AND a.upgrade_type = '.$upgrade_type.' AND a.upgrade_time >= '.time();
    
13. $sql = "SELECT a.id,a.title,a.begintime,a.info_level,a.hit,b.areaname,c.catname FROM `{$db_mymps}information` AS a LEFT JOIN `{$db_mymps}area` AS b ON a.areaid = b.areaid LEFT JOIN `{$db_mymps}category` AS c ON a.catid = c.catid $where ORDER BY a.begintime DESC LIMIT 0,".$num."";
    0 S& K' c# i- h- G+ \8 v
14. $do_mymps = $db -> query($sql);
    
15. if($do_mymps){
    
16. while($row = $db -> fetchRow($do_mymps)){
      Q! K9 m% I- E8 K$ w
17. $arr['id'] = $row['id'];
    & _6 K6 _9 E0 T: O. i
18. $arr['title'] =($len>0)?substring($row['title'],0,$len):$row['title'];
    $ g/ _6 M2 V. ^: ?! B& n* N# S
19. $arr['hit'] = $row['hit'];
    * l  R! h( i1 L0 {
20. $arr['begintime'] = GetTime($row['begintime']);
    
21. $arr['areaname'] = $row['areaname'];
    
22. $arr['catname'] = $row['catname'];
    # a0 Y. E5 \+ Z* ^$ \
23. $arr['info_level']= $row['info_level'];
    9 K3 K) N8 _. }1 L6 |, s
24. $arr['uri'] = Rewrite('info',array('id'=>$row['id']));
    
25. $info_list[] = $arr;
    8 h5 V8 [) f& K0 {% f7 h
26. }
    : T/ Q% F% l$ @, V& k5 q5 E8 q
27. }
    
28. return $info_list;
    . C2 d2 k5 ]" n% ~  O
29. }
    # i" d- q8 x3 n6 ^
30. 
    ) v; _2 w; p# m: P1 U3 c; v

复制代码

8 c. G, n3 r3 Y5 i" ~/index.php中如下调用：$smarty -> assign('info_list_1' , mymps_get_info_list(5,70,'','','','1,2'));//分类1和分类2
# X* g  o6 q" K3 b1 e( X- Z
' @3 D. p+ n) T* C本人QQ：82305485，有问题可以联系，此函数不懂者不要用，否则后果自负

[ 本帖最后由 239300 于 2010-5-1 11:28 编辑 ]

好运1线

要是有个图或是演示就好了！

好运1线

要是有个图或是演示就好了！
www.q481.com