:::

\[1011\]XOOPS 2.5 模組開發
======================

```
<pre class="brush: php;" title="code">
<?php
/*** 引入檔案 ***/
include_once '../../mainfile.php';
include_once XOOPS_ROOT_PATH."/header.php";

/*** 函數檔 ***/

//新增記事表單
function add_form($note_sn=null){
  global $xoopsDB,$xoopsUser;

if(empty($xoopsUser))redirect_header('index.php', 3, "請先登入。");

if($note_sn){
    $sql="select * from ".$xoopsDB->prefix("tad_notes")." where `note_sn`='$note_sn'";
    $result=$xoopsDB->query($sql) or redirect_header('index.php', 3, mysql_error());
    $doc=$xoopsDB->fetchArray($result);
  }

include_once(XOOPS_ROOT_PATH."/class/xoopsformloader.php");
  $XoopsFormHiddenToken=new XoopsFormHiddenToken();
  $token=$XoopsFormHiddenToken->render();

$option="";
  //抓取資料庫中的分類選項
  $sql="select * from ".$xoopsDB->prefix("tad_note_cate")." where cate_enable='1' order by `cate_sort`";
  $result = $xoopsDB->query($sql) or redirect_header('index.php', 3, mysql_error());
  while($cate=$xoopsDB->fetchArray($result)){
    $selected=($cate['cate_sn']==$doc['cate_sn'])?"selected":"";
    $option.="<option value='{$cate['cate_sn']}' $selected>{$cate['cate_title']}</option>";
  }
  
  //取得最大排序
  $note_sort=empty($note_sn)?get_max_sort():$doc['note_sort'];

//取得現在時間
  $note_date=empty($note_sn)?date("Y-m-d H:i:s"):$doc['note_date'];

$note_public1=($doc['note_public']=='1')?"checked":"";
  $note_public0=($doc['note_public']=='0')?"checked":"";

$main="
  <script type='text/javascript' src='class/ckeditor/ckeditor.js'></script>
  <script language='javascript' type='text/javascript' src='class/DatePicker/WdatePicker.js'></script>
  <h3>記事編輯</h3>
  <form action='{$_SERVER['PHP_SELF']}' method='post'>
    <table>
      <tr><th nowrap>所屬分類</th><td>
        <select name='cate_sn'>
        <option value='0'>不分類</option>
        $option
        </select>
        </td></tr>
      <tr><th>文章標題</th><td><input type='text' name='note_title' size=40 value='{$doc['note_title']}'></td></tr>
      <tr><td colspan=2>
        <textarea name='note_content' cols=40 rows=6 class='ckeditor' id='ckeditor'>{$doc['note_content']}

發布日期是否公開是否排序 $token "; /* 所屬分類 cate_sn 文章標題 note_title 文章內容 note_content 發布日期 note_date 是否公開 note_public 排序 note_sort */ return $main; } //儲存文章 function save(){ global $xoopsDB , $xoopsUser; if(!$GLOBALS['xoopsSecurity']->check()){ $error=implode("
" , $GLOBALS['xoopsSecurity']->getErrors()); redirect_header($_SERVER['PHP_SELF'],3, $error); } $myts =& MyTextSanitizer::getInstance(); $_POST['note_title'] = $myts->addSlashes($_POST['note_title']); $_POST['note_content'] = $myts->addSlashes($_POST['note_content']); $_POST['note_date'] = $myts->addSlashes($_POST['note_date']); $_POST['note_sort'] = $myts->addSlashes($_POST['note_sort']); $uid = empty($xoopsUser)? 0 : $xoopsUser->uid(); $sql="insert into ".$xoopsDB->prefix("tad_notes")." (`cate_sn`, `note_title`, `note_content`, `note_date`, `note_public`, `note_count`, `uid`, `note_sort`) values('{$_POST['cate_sn']}' , '{$_POST['note_title']}' , '{$_POST['note_content']}' , '{$_POST['note_date']}' , '{$_POST['note_public']}' , '0' , '{$uid}' , '{$_POST['note_sort']}')"; $xoopsDB->query($sql) or redirect_header('index.php', 3, mysql_error()); } //工具列 function toolbar(){ $main="新增記事"; return $main; } //取得最大排序 function get_max_sort(){ global $xoopsDB; $sql="select max(`note_sort`) from ".$xoopsDB->prefix("tad_notes")." where `note_public`='1'"; $result=$xoopsDB->query($sql) or redirect_header('index.php', 3, mysql_error()); list($max_sort)=$xoopsDB->fetchRow($result); return ++$max_sort; } //顯示文章列表或單一文章 function show_doc($note_sn=''){ global $xoopsDB,$xoopsUser; $now_uid=($xoopsUser)?$xoopsUser->uid():""; $myts =& MyTextSanitizer::getInstance(); if(empty($note_sn)){ $sql="select * from ".$xoopsDB->prefix("tad_notes")." where `note_public`='1' order by note_sort"; $result=$xoopsDB->query($sql) or redirect_header('index.php', 3, mysql_error()); $main=""; while($doc=$xoopsDB->fetchArray($result)){ $doc['note_title'] = $myts->htmlSpecialChars($doc['note_title']); $doc['note_date'] = $myts->htmlSpecialChars($doc['note_date']); $tool=($doc['uid']==$now_uid)?"刪除 | 修改":""; $main.=""; } $main.="

{$doc['note_title']}

{$doc['note_date']}

{$tool}

"; }else{ $sql="select * from ".$xoopsDB->prefix("tad_notes")." where `note_sn`='$note_sn' and `note_public`='1'"; $result=$xoopsDB->query($sql) or redirect_header('index.php', 3, mysql_error()); $doc=$xoopsDB->fetchArray($result); $doc['note_title'] = $myts->htmlSpecialChars($doc['note_title']); $doc['note_date'] = $myts->htmlSpecialChars($doc['note_date']); $doc['note_content'] = $myts->displayTarea($doc['note_content'], 1, 1, 0, 1, 0); $main="

{$doc['note_title']}

{$doc['note_date']}

{$doc['note_content']}

"; } return $main; } //刪除函數 function del_note($note_sn=null){ global $xoopsDB; $sql="delete from ".$xoopsDB->prefix("tad_notes")." where note_sn='$note_sn'"; $xoopsDB->queryF($sql) or redirect_header('index.php', 3, mysql_error()); } /*** 流程判斷 ***/ $op = empty($_REQUEST['op'])? "" : $_REQUEST['op']; $note_sn = empty($_REQUEST['note_sn'])? "" : intval($_REQUEST['note_sn']); switch($op){ case "del": del_note($note_sn); header("location:index.php"); break; case "modify": $main=add_form($note_sn); break; case "save": save(); header("location:index.php"); break; case "add_form": $main=add_form(); break; default: $main=show_doc($note_sn); break; } /*** 輸出 ***/ $current1=($_SERVER['REQUEST_URI']=="/~tad0616/modules/tad_note/index.php")?"class='current'":""; $current2=($_SERVER['REQUEST_URI']=="/~tad0616/modules/tad_note/index.php?op=add_form")?"class='current'":""; echo " "; echo $main; include_once XOOPS_ROOT_PATH.'/footer.php'; ?> ```

:::