www.gusucode.com > weenCompany闻名企业网站系统 4.0.0 繁体中英文 UTF8源码程序 > modules/m4_guestbook/m4_settings.php

    <?php
// +---------------------------------------------+
// |     Copyright 2007 - 2008 weenCompany       |
// |     http://www.weentech.com                 |
// |     This file may not be redistributed.     |
// +---------------------------------------------+

if(!defined('IN_WEENCOMPANY'))
  die('File not found!');


// ############################## UPDATE MESSAGES ##############################

function UpdateMessages($start)
{
  global $DB, $refreshpage;

  $messageid       = $_POST['messageid'];
  $noactivated       = $_POST['noactivated'];
  $username        = $_POST['username'];
  $websitename     = $_POST['websitename'];
  $website         = $_POST['website'];
  $message         = $_POST['message'];
  $deletemessageid = $_POST['deletemessageid'];

  for($i = 0; $i < count($message); $i++)
  {
    $DB->query("UPDATE " . TABLE_PREFIX . "m4_guestbook SET username    = '$username[$i]',
                                                            noactivated = '$noactivated[$i]',
                                                            websitename = '$websitename[$i]',
                                                            website     = '$website[$i]',
                                                            message     = '$message[$i]'
                                                        WHERE messageid = '$messageid[$i]'");
  }

  for($i = 0; $i < count($deletemessageid); $i++)
  {
    $DB->query("DELETE FROM " . TABLE_PREFIX . "m4_guestbook WHERE messageid = '" . $deletemessageid[$i] . "'");
  }

  PrintRedirect($refreshpage.'&start='.$start, 1);
}



// ############################## DISPLAY DEFAULT ##############################

function DisplayDefault($start)
{
  global $DB, $moduleid, $refreshpage;

  PrintModuleSettings($moduleid, '模塊設置', $refreshpage);

  $getmessages  = $DB->query("SELECT * FROM " . TABLE_PREFIX . "m4_guestbook ORDER BY messageid DESC LIMIT $start, 5");
  $messagesrows = $DB->get_num_rows($getmessages);

  PrintSection('內容條目');

  echo '<form method="post" action="'.$refreshpage.'&start='.$start.'" name="deletemessages">
        <input type="hidden" name="action" value="updatemessages" />

        <table width="100%" border="0" cellpadding="5" cellspacing="0">
        <tr>
		  <td class="tdrow1">日期</td>
		  <td class="tdrow1">狀態</td>
          <td class="tdrow1">用戶名</td>
          <td class="tdrow1">網站名稱</td>
          <td class="tdrow1">網站URL</td>
          <td class="tdrow1">內容</td>
          <td class="tdrow1"><input type="checkbox" checkall="group" onclick="javascript: return select_deselectAll (\'deletemessages\', this, \'group\');">刪除</td>
        </tr>';

  while($message = $DB->fetch_array($getmessages))
  {
    echo '<tr>
            <td class="tdrow2">'.DisplayDate($message['datecreated']).'			
            </td>
              <td class="tdrow3">
                <select name="noactivated[]">
                  <option value="0">發佈</option>
                  <option value="1" ' . iif($message['noactivated'], 'SELECTED') . '>隱藏</option>
                </select>
              </td>
            <td class="tdrow2">
              <input type="hidden" name="messageid[]" value="'.$message['messageid'].'" />
              <input type="text" name="username[]" value="'.CleanFormValue($message['username']).'" size="8" />
            </td>
            <td class="tdrow3">
              <input type="text" name="websitename[]" value="'.CleanFormValue($message['websitename']).'" size="12" />
            </td>
            <td class="tdrow2">
              <input type="text" name="website[]" value="'.CleanFormValue($message['website']).'" />
            </td>
            <td class="tdrow3">
              <textarea name="message[]" cols="25" rows="4">'.$message['message'].'</textarea>
            </td>
            <td class="tdrow2">
              <input type="checkbox" name="deletemessageid[]" value="' . $message['messageid'] . '" checkme="group" />
            </td>
          </tr>';
  }

  echo '  </td>
        </tr>
        <tr>
          <td class="tdrow1" bgcolor="#FCFCFC" colspan="7" align="center">
           <input type="submit" value=" 保存更新 " />
          </td>
        </tr>
        </table>
        </form>';
  EndSection();

  // previous and next section

  // get max rows for guestbook
  $maxrows = $DB->query_first("SELECT COUNT(*) AS value FROM " . TABLE_PREFIX . "m4_guestbook");

  echo '<table width="100%" border="0" cellspacing="5" cellpadding="0">
        <tr>
          <td width="50%" align="left">';

  if($start != 0)
  {
    echo '<a href="'.$refreshpage.'&start='.($start-5).'"><b><< 上一頁</b></a>';
  }

  echo '</td>
        <td width="50%" align="right">';

  if(($maxrows['value'] - $start) > 5)
  {
    echo '<a href="'.$refreshpage.'&start='.($start+5).'"><b>下一頁 >></b></a>';
  }

  echo '  </td>
        </tr>
        </table>';

}



// ############################# FUNCTION CALLING ##############################

if(isset($_GET['start']))
  $start = $_GET['start'];
else
  $start = 0;


switch($action)
{
  case 'updatemessages':
    UpdateMessages($start);
  break;

  default:
    DisplayDefault($start);
}


?>