use_hook('frontpage_start','getid'); function getid() { global $tpl,$cache,$db,$config; $mybb=$cache->read('mybbconfig'); $sql="SELECT * FROM `".$mybb['prefix']."forums` WHERE `type`='f' AND `active` != 0 AND `pid` != 13 ORDER BY `pid`,`disporder`"; $result=$db->query($sql) or die($db->error()); $i=0; while($row=$db->fetch_array($result)){ $forum[$i]['name']=$row['name']; $forum[$i]['link']='/forum/forum-'.$row['fid'].'.html'; $i++; } $tpl->assign('forum',$forum); } ?>