線上書籍

Home

1041 XOOPS模組開發

<?php /*-----------引入檔案區--------------*/ include_once "header.php"; $xoopsOption['template_main'] = set_bootstrap("tad_ebook_index.html"); include_once XOOPS_ROOT_PATH."/header.php"; /*-----------function區--------------*/ //顯示預設頁面內容 function show_page($page_sn=""){ global $xoopsTpl ,$xoopsDB; $tbl=$xoopsDB->prefix('tad_ebook_page'); //新增計數器 $sql="update {$tbl} set `page_counter`= `page_counter` + 1 where `page_sn`='{$page_sn}'"; $xoopsDB->queryF($sql) or redirect_header("index.php",3, mysql_error()); $sql="select * from `{$tbl}` where `page_sn` = '{$page_sn}'"; $result=$xoopsDB->query($sql) or redirect_header("index.php",3, mysql_error()); $page=$xoopsDB->fetchArray($result); $xoopsTpl->assign('page',$page); $xoopsTpl->assign('op', 'show_page'); } //顯示所有期數列表 function show_all(){ global $xoopsTpl ,$xoopsDB; //單一檔案真實路徑: include_once XOOPS_ROOT_PATH."/modules/tadtools/TadUpFiles.php" ; $TadUpFiles=new TadUpFiles("tad_ebook"); $today=date("Y-m-d"); $tbl=$xoopsDB->prefix('tad_ebook'); $sql="select * from `{$tbl}` where `ebook_publish_date` <= '{$today}' order by `ebook_publish_date` desc"; $result=$xoopsDB->query($sql) or redirect_header("index.php",3, mysql_error()); $i=0; while($ebook=$xoopsDB->fetchArray($result)){ $all_ebook[$i]=$ebook; $TadUpFiles->set_col('ebook_sn',$ebook['ebook_sn']); $all_ebook[$i]['ebook_pic']=$TadUpFiles->get_pic_file('thumb'); $i++; } //die(var_export($all_ebook)); $xoopsTpl->assign('all_ebook',$all_ebook); $xoopsTpl->assign('op', 'show_all'); } //顯示某期文章列表 function show_ebook($ebook_sn=""){ global $xoopsTpl ,$xoopsDB; $tbl=$xoopsDB->prefix('tad_ebook_page'); $sql="select * from `{$tbl}` where `ebook_sn` = '{$ebook_sn}'"; $result=$xoopsDB->query($sql) or redirect_header("index.php",3, mysql_error()); while($page=$xoopsDB->fetchArray($result)){ $all_page[]=$page; } $xoopsTpl->assign('all_page',$all_page); $xoopsTpl->assign('op', 'show_ebook'); } /*-----------執行動作判斷區----------*/ $op=empty($_REQUEST['op'])?"":$_REQUEST['op']; $page_sn=empty($_REQUEST['page_sn'])?"":intval($_REQUEST['page_sn']); $ebook_sn=empty($_REQUEST['ebook_sn'])?"":intval($_REQUEST['ebook_sn']); switch($op){ // case "xxx": // xxx(); // header("location:{$_SERVER['PHP_SELF']}"); default: if($page_sn){ show_page($page_sn); include_once XOOPS_ROOT_PATH.'/include/comment_view.php'; }elseif($ebook_sn){ show_ebook($ebook_sn); }else{ show_all(); } break; } /*-----------秀出結果區--------------*/ $xoopsTpl->assign( "toolbar" , toolbar_bootstrap($interface_menu)) ; include_once XOOPS_ROOT_PATH.'/footer.php'; ?>