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); } ?>