<{php}> global $xoopsDB,$xoopsConfig; if(file_exists(XOOPS_ROOT_PATH."/modules/tad_themes/xoops_version.php")){ $sql="select a.*,b.slide_width,b.slide_height from ".$xoopsDB->prefix("tad_themes_files_center")." as a left join ".$xoopsDB->prefix("tad_themes")." as b on a.col_sn=b.theme_id and b.`theme_name`='{$xoopsConfig['theme_set']}' where a.`col_name`='slide' "; $result = $xoopsDB->query($sql); $slide_images=""; while($data=$xoopsDB->fetchArray($result)){ foreach($data as $k=>$v){ $$k=$v; //$this->assign($k,$$k); } $slide_images.="
"; } } if(empty($slide_images)){ $slide_images=" \n
\n
\n
"; } echo $slide_images; <{/php}>