sql_query($sql); $row = $db->sql_fetchrow($query); $total = $row['c']; if($total>0) { //获取投诉列表 $sql = "SELECT `ID`,`Title`,`Content`,`AddTime` FROM `dede_tousu` ORDER BY `ID` DESC LIMIT {$start},{$pagesize}"; $rows = GetFromCacheOrFetchRowSet($sql); if(is_array($rows) && !empty($rows)) { foreach($rows as $k => $v) { $tousulist[$k]['Title'] = $v['Title']; $tousulist[$k]['Desc'] = mb_strlen($v['Content'])>140 ? mb_substr($v['Content'],0,140,'GBK').'...' : $v['Content']; $tousulist[$k]['AddTime'] = date('Y-m-d H:i:s',$v['AddTime']); $tousulist[$k]['url'] = "/315/tousu_{$v['ID']}.htm"; } } $pagelist = getPages($page,$total); } //靓车展 $sql = "SELECT maintable.`id`,maintable.`title`,maintable.`typeid`,maintable.`senddate`,maintable.`ismake`,maintable.`arcrank`,maintable.`litpic`,maintable.`money`,maintable.`filename`,arctype.`namerule`,arctype.`typedir`,arctype.`moresite`,arctype.`siteurl`,arctype.`sitepath` ". " FROM `dede_archives` maintable ". " LEFT JOIN `dede_arctype` arctype ON arctype.id=maintable.typeid ". " WHERE maintable.channel=1 AND maintable.arcrank!=-1 AND (arctype.`id` = 413 OR arctype.`topid` = 413) AND FIND_IN_SET('c',maintable.`flag`) AND FIND_IN_SET('p',maintable.`flag`) ". " ORDER BY maintable.pubdate DESC ". " LIMIT 0,4"; $rows = GetFromCacheOrFetchRowSet($sql); if(is_array($rows) && !empty($rows)) { foreach($rows as $k => $v) { $chezhanlist[$k]['title'] = $v['title']; $chezhanlist[$k]['litpic'] = $v['litpic']; $chezhanlist[$k]['arcurl'] = GetFileUrl($v["id"],$v["senddate"],$v["typedir"],$v['filename'],$v["siteurl"]); } } //香车养女 $sql = "SELECT maintable.`id`,maintable.`title`,maintable.`typeid`,maintable.`senddate`,maintable.`ismake`,maintable.`arcrank`,maintable.`litpic`,maintable.`money`,maintable.`filename`,arctype.`namerule`,arctype.`typedir`,arctype.`moresite`,arctype.`siteurl`,arctype.`sitepath` ". " FROM `dede_archives` maintable ". " LEFT JOIN `dede_arctype` arctype ON arctype.id=maintable.typeid ". " WHERE maintable.channel=1 AND maintable.arcrank!=-1 AND (arctype.`id` = 13 OR arctype.`topid` = 13) AND FIND_IN_SET('c',maintable.`flag`) AND FIND_IN_SET('p',maintable.`flag`) ". " ORDER BY maintable.pubdate DESC ". " LIMIT 0,4"; $rows = GetFromCacheOrFetchRowSet($sql); if(is_array($rows) && !empty($rows)) { foreach($rows as $k => $v) { $meinvlist[$k]['title'] = $v['title']; $meinvlist[$k]['litpic'] = $v['litpic']; $meinvlist[$k]['arcurl'] = 'http://car.qi-che.com/picture/girl_pic/s0/t15'; $p = $v['id'] % 8; $p>0 && $meinvlist[$k]['arcurl'] .= "_p{$p}.html"; } } $db->sql_close(); $smarty->assign("chezhanlist", $chezhanlist); $smarty->assign("meinvlist", $meinvlist); $smarty->assign("tousulist", $tousulist); $smarty->assign("pagelist", $pagelist); $smarty->display('tousulist.tpl'); //分页 function getPages($page, $total, $pagesize = 10, $offset = 5) { $total_page = (int)ceil($total / $pagesize); $total_page = min(100,$total_page); if ($total_page < 2) return null; $start = ($page > $offset) ? ($page - $offset) : 1; $end = $start + $offset * 2; if ($end > $total_page) { $end = $total_page; $start = $end - $offset * 2; $start = max(1,$start); } $url_format = '/315/tousu_list_%d.htm'; $pageer = ''; if($page>1) { $pager .= "首页"; $pager .= "上页"; } else { $pager .= "首页"; $pager .= "上页"; } for ($i = $start; $i <= $end; $i++) { if ($i == $page) { $pager .= "{$i}"; } else { $pager .= "{$i}"; } } if($page<$total_page) { $pager .= "下页"; $pager .= "末页"; } else { $pager .= "下页"; $pager .= "末页"; } return $pager; } //栏目目录规则 function MfTypedir($typedir) { $typedir = str_replace("{cmspath}",'',$typedir); $typedir = ereg_replace("/{1,}","/",$typedir); $typedir = rtrim($typedir,'/') . '/'; return $typedir; } //获得文章链接 function GetFileUrl($id,$senddate,$typedir,$filename,$siteurl) { $url = $siteurl ? $siteurl : 'http://www.qi-che.com'; $typedir = MfTypedir($typedir); $url .= $typedir; if($filename) { $url .= $filename; } else { $url .= date('Ymd',$senddate) . $id; } $url .= '.html'; return $url; } ?>