<{php}> global $xoopsDB,$xoopsTpl,$xoopsConfig; $slider_var=get_theme_slide_items(); $xoopsTpl->assign('slider_var',$slider_var); function get_theme_slide_items(){ global $xoopsDB,$xoopsConfig; $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 where a.`col_name`='slide' and b.`theme_name`='{$xoopsConfig['theme_set']}'"; $result = $xoopsDB->query($sql); if($result){ $i=0; while($data=$xoopsDB->fetchArray($result)){ foreach($data as $k=>$v){ $$k=$v; } //`files_sn`, `col_name`, `col_sn`, `sort`, `kind`, `file_name`, `file_type`, `file_size`, `description`, `counter`, `original_filename`, `hash_filename`, `sub_dir` preg_match_all("/\](.*)\[/", $description, $matches); $url=$matches[1][0]; if(empty($url))$url=XOOPS_URL; $description=str_replace("[url]{$url}[/url]", "", $description); $slider_var[$i]['files_sn']=$files_sn; $slider_var[$i]['sort']=$sort; $slider_var[$i]['file_name']=$file_name; $slider_var[$i]['description']=$description; $slider_var[$i]['text_description']=strip_tags($description); $slider_var[$i]['original_filename']=$original_filename; $slider_var[$i]['sub_dir']=$sub_dir; $slider_var[$i]['file_url']= XOOPS_URL."/uploads/tad_themes{$sub_dir}/{$file_name}"; $slider_var[$i]['file_thumb_url']= XOOPS_URL."/uploads/tad_themes{$sub_dir}/thumbs/{$file_name}"; $slider_var[$i]['slide_url']=$url; $i++; } } return $slider_var; } <{/php}>