ไฟล์ new-ad.php
<?
include ('SSI.php');
function findIMG($text){
preg_match_all('/\[img\].*?\[\/img\]/i',$text,$page);
foreach($page as $value)
$src = substr($value[0],5);
$src = substr($src,0,-6);
return($src);
}
function ssi_pic($num_top = 12,$order,$board = array()){
global $db_prefix, $scripturl, $smcFunc;
$request = $smcFunc['db_query']('', '
SELECT t.id_topic,m.body,m.subject
FROM {db_prefix}messages m,{db_prefix}topics t
WHERE t.id_first_msg=m.id_msg AND t.id_board IN('. implode(',',$board) .')
ORDER BY t.'.$order.' DESC
LIMIT '.$num_top,
array(
)
);
$posts = array();
while ($row = $smcFunc['db_fetch_assoc']($request))
{
// Build the array.
$topics[] = array(
'id' => $row['id_topic'],
'body' => $row['body'],
'subject' => $row['subject']
);
}
$smcFunc['db_free_result']($request);
foreach ($topics as $data){
$topic = "index.php?topic=".$data['id'];
$srcPic = findIMG($data['body']);
$subject = $data['subject'];
echo '<div class="boxpGal">
<div class="picpGal"><a href="'.$srcPic.'" title="คลิ๊กเพื่อดูภาพเต็ม."><img src="'.$srcPic.'" width="150" alt="" />[/url]</div><center>'.mb_substr($subject,0,20,'UTF-8').'</center>
<div class="viewAllpic"><a href="'.$topic.'" target="_blank"><font color="#0000FF">อ่านเพิ่มเติม...</font>[/url]</div>
</div>';
}
}
echo'<div class="cat_bar">
<h3 class="catbg">คู่มือการซ่อม และวายริ่งรถยนต์ ล่าสุด...</h3></div>';
echo''.ssi_pic(6,'ID_TOPIC', array(25,436,656,739)).'';
?>
