9-2 /index.php

<?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';
?>