} ?> </div> <div class="spaceline"></div> <ul class="left_4"> <?php $sqlSegment = "and sortid IN ({$sort_ids_str}) order by sortop DESC,date DESC"; $logs = $Log_Model->getLogsForHome($sqlSegment, 1, 6); $cover_img = ''; foreach ($logs as $value) { ?> <li> <?php blog_cover($value['logid'], $cover_img, 230, 137); ?> <p><a href="<?php echo utl_tool_convertToMobile($value['log_url']); ?> "><?php echo $value['log_title']; ?> </a></p> </li> <?php } ?> </ul> </div> <?php include View::getView('footer');
function blog_cover($blogid, &$cover_img, $w, $h) { $db = MySql::getInstance(); $sql = "SELECT b.filepath,a.title,a.gid FROM " . DB_PREFIX . "blog as a, " . DB_PREFIX . "attachment as b where a.gid={$blogid} and b.blogid=a.gid ORDER BY b.addtime asc, thumfor DESC "; $ret = $db->query($sql); $row = $db->fetch_array($ret); if (!empty($row)) { $row['filepath'] = $row['filepath'] ? BLOG_URL . substr($row['filepath'], 3) : TEMPLATE_URL . 'image/logo.png'; $row['title'] = htmlspecialchars($row['title']); $row['logurl'] = utl_tool_convertToMobile(Url::log(intval($row['gid']))); $cover_img = $row['filepath']; ?> <a href="<?php echo utl_tool_convertToMobile($row['logurl']); ?> " target="_blank"><img width="<?php echo $w; ?> " height="<?php echo $h; ?> " src="<?php echo $row['filepath']; ?> " alt="<?php echo $row['title']; ?> " /></a> <?php } }