function get_advlist($position, $num=0)

{

$arr=array();

$limit_string = '';

if ($num > 0)

{

$limit_string = 'limit '.$num;

}

$sql = "select ap.ad_width,ap.ad_height,ad.ad_id,ad.ad_name,ad.ad_code,ad.ad_link,ad.ad_id,ad.link_man from ".$GLOBALS['ecs']->table('ad_position')." as ap left join ".$GLOBALS['ecs']->table('ad')." as ad on ad.position_id = ap.position_id where ap.position_name='".$position."' and UNIX_TIMESTAMP()>ad.start_time and UNIX_TIMESTAMP()<ad.end_time and ad.enabled=1 $limit_string";

$res = $GLOBALS['db']->getAll($sql);

foreach($res as $idx => $row)

{

$arr[$row['ad_id']]['name'] = $row['ad_name'];

$arr[$row['ad_id']]['title'] = $row['link_man'];

$arr[$row['ad_id']]['url'] = "affiche.php?ad_id=".$row['ad_id']."&uri=".$row['ad_link'];

$arr[$row['ad_id']]['image'] = 'data/afficheimg/'.$row['ad_code'];

$arr[$row['ad_id']]['ad_code'] = $row['ad_code'];

$arr[$row['ad_id']]['content'] = "<a href='".$arr[$row['ad_id']]['url']."' title='".$row['ad_name']."' target='_blank'><img src='data/afficheimg/".$row['ad_code']."' title='".$row['ad_name']."' alt='".$row['ad_name']."'/></a>";

}

return $arr;

}