www.gusucode.com > weenCompany闻名企业网站系统 4.0.0 繁体中英文 UTF8源码程序 > modules/m16_linkdirectory/m16_settings.php
<?php // +---------------------------------------------+ // | Copyright 2006-2008 weenCompany | // | http://www.weentech.com | // | This file may not be redistributed. | // +---------------------------------------------+ if(!defined('IN_WEENCOMPANY')) { die('File not found!'); } // ############################# Begin Functions ############################ // insert a new link into the database function InsertLink($sectionid, $activated, $allowsmilies, $showauthor, $author, $title, $url, $description) { global $DB; global $refreshpage; $activated = empty($activated) ? 0 : $activated; $allowsmilies = empty($allowsmilies) ? 0 : $allowsmilies; $showauthor = empty($showauthor) ? 0 : $showauthor; if(strlen($title) == 0) { $errors[] = '必須輸入鏈接的標題!'; } if(strlen($url) == 0) { $errors[] = '必須輸入鏈接的URL!'; } if(!isset($errors)) { $DB->query("INSERT INTO " . TABLE_PREFIX . "m16_links VALUES ('0', '$sectionid', '$activated', '$allowsmilies', '$showauthor', '$author', '$title', '$url', '$description') "); PrintRedirect($refreshpage, 1); } else { PrintErrors($errors); DisplayLinkForm(null); // 1 = errors exist } } // update a link function UpdateLink($deletelink, $linkid, $sectionid, $activated, $allowsmilies, $showauthor, $author, $title, $url, $description) { global $DB, $refreshpage; $activated = empty($activated) ? 0 : $activated; $allowsmilies = empty($allowsmilies) ? 0 : $allowsmilies; $showauthor = empty($showauthor) ? 0 : $showauthor; // delete link? if($deletelink == 1) { return DeleteLink($linkid); } if(strlen($title) == 0) { $errors[] = '必須輸入鏈接的標題!'; } if(strlen($url) == 0) { $errors[] = '必須輸入鏈接的URL!'; } if(!isset($errors)) { $DB->query("UPDATE " . TABLE_PREFIX . "m16_links SET sectionid = '$sectionid', activated = '$activated', allowsmilies = '$allowsmilies', showauthor = '$showauthor', author = '$author', title = '$title', url = '$url', description = '$description' WHERE linkid = '$linkid'"); PrintRedirect($refreshpage, 1); } else { PrintErrors($errors); DisplayLinkForm($linkid); } } // delete a link from the database function DeleteLink($linkid) { global $DB; global $refreshpage; $DB->query("DELETE FROM " . TABLE_PREFIX . "m16_links WHERE linkid = '$linkid'"); PrintRedirect($refreshpage, 1); } function DeleteLinks() { global $DB; global $refreshpage; // get post vars $linkids = $_POST['linkids']; for($i = 0; $i < count($linkids); $i++) { $DB->query("DELETE FROM " . TABLE_PREFIX . "m16_links WHERE linkid = '".$linkids[$i]."'"); } PrintRedirect($refreshpage, 1); } // insert a new section function InsertSection($parentid, $activated, $name, $description, $sorting) { global $DB; global $refreshpage; $activated = empty($activated) ? 0 : $activated; if(strlen($name) == 0) { $errors[] = '必須輸入類別名稱!'; } if(!isset($errors)) { $DB->query("INSERT INTO " . TABLE_PREFIX . "m16_sections VALUES ('0', '$parentid', '$activated', '$name', '$description', '$sorting') "); PrintRedirect($refreshpage, 1); } else { PrintErrors($errors); DisplaySectionForm(null); } } function UpdateSection($sectionid, $parentid, $activated, $name, $description, $sorting) { global $DB, $refreshpage; $parentid = empty($parentid) ? 0 : $parentid; $activated = empty($activated) ? 0 : $activated; // delete section if($_POST['deletesection'] == 1) { $subsection = $DB->query_first("SELECT parentid FROM " . TABLE_PREFIX . "m16_sections WHERE parentid = '$sectionid'"); if (isset($subsection)) { $errors[] = '無法刪除此鏈接類別! 您必須先刪除此類別的子類別.'; PrintErrors($errors); DisplaySectionForm($sectionid); exit(); } } // delete section links if($_POST['deletesectionlinks'] == 1 && $_POST['deletesection'] == 1) { $DB->query("DELETE FROM " . TABLE_PREFIX . "m16_links WHERE sectionid = '$sectionid'"); $DB->query("DELETE FROM " . TABLE_PREFIX . "m16_sections WHERE sectionid = '$sectionid'"); PrintRedirect($refreshpage, 1); } if($_POST['deletesectionlinks'] == 1 && $_POST['deletesection'] == 0) { $DB->query("DELETE FROM " . TABLE_PREFIX . "m16_links WHERE sectionid = '$sectionid'"); } if($_POST['deletesectionlinks'] == 0 && $_POST['deletesection'] == 1) { $DB->query("DELETE FROM " . TABLE_PREFIX . "m16_sections WHERE sectionid = '$sectionid'"); $DB->query("UPDATE " . TABLE_PREFIX . "m16_links SET sectionid = '$parentid', activated = '0' WHERE sectionid = '$sectionid'"); PrintRedirect($refreshpage, 1); } if(strlen($name) == 0) { $errors[] = '必須輸入類別名稱!'; } if(!isset($errors)) { if($sectionid=='1'){$activated=1;} $DB->query("UPDATE " . TABLE_PREFIX . "m16_sections SET parentid = '$parentid', activated = '$activated', name = '$name', description = '$description', sorting = '$sorting' WHERE sectionid = '$sectionid'"); PrintRedirect($refreshpage, 1); } else { PrintErrors($errors); DisplaySectionForm($sectionid); } } // display options function DisplaySettings() { global $DB; global $moduleid; global $refreshpage; PrintModuleSettings($moduleid, '模塊設置', $refreshpage); } // view the section form to insert/edit a section function DisplaySectionForm($sectionid) { global $DB, $rootpath, $refreshpage; if(isset($sectionid)) { // gather section information $section = $DB->query_first("SELECT * FROM " . TABLE_PREFIX . "m16_sections WHERE sectionid = $sectionid"); PrintSection('編輯分類: '.$section['name']); } else { // create empty array $section = array('sectionid' => 0, 'parentid' => 1, 'activated' => 1, 'name' => '', 'description' => '', 'sorting' => '時間(降序)' ); PrintSection('添加分類'); } echo '<form method="post" action="'.$refreshpage.'"> <input type="hidden" name="sectionid" value="'.$sectionid.'" /> <table width="100%" border="0" cellpadding="5" cellspacing="0">'; if(isset($sectionid)) { echo '<tr> <td class="tdrow2" width="15%"><b>刪除類別:</b></td> <td class="tdrow3" width="75%" valign="top">'; if($sectionid == 1) { echo '默認根類別不能刪除.'; } else { echo '<input type="checkbox" name="deletesection" value="1"> 刪除此類別? 注: 如僅刪除鏈接類別, 而不刪除所有此類鏈接, 則所有此類鏈接自動轉入其父類且狀態為"不發佈". '; } echo ' </td> </tr>'; echo '<tr> <td class="tdrow2" width="15%" valign="top"><b>刪除鏈接:</b></td> <td class="tdrow3" width="75%" valign="top"> <input type="checkbox" name="deletesectionlinks" value="1"> 刪除此類別的所有鏈接? </td> </tr>'; } echo '<tr> <td class="tdrow2" width="15%"><b>所屬類別:</b></td> <td class="tdrow3" width="75%" valign="top">'; if(isset($sectionid)) { if($sectionid == 1) { echo '根類別是所有類別的父類, 不能設置為子類.'; } else { PrintSectionSelectionEXX('parentid', $section['parentid'], $section['sectionid']); } } else { PrintSectionSelection('parentid', $section['parentid'], $section['sectionid']); } echo ' </td> </tr> <tr> <td class="tdrow2" width="15%" valign="top"><b>鏈接排序:</b></td> <td class="tdrow3" width="75%" valign="top"> <select name="sorting"> <option '.iif($section[sorting] == "時間(降序)","selected") .'>時間(降序)</option> <option '.iif($section[sorting] == "時間(升序)","selected") .'>時間(升序)</option> <option '.iif($section[sorting] == "標題(A-Z)","selected") .'>標題(A-Z)</option> <option '.iif($section[sorting] == "標題(Z-A)","selected") .'>標題(Z-A)</option> <option '.iif($section[sorting] == "作者(A-Z)","selected") .'>作者(A-Z)</option> <option '.iif($section[sorting] == "作者(Z-A)","selected") .'>作者(Z-A)</option> </select> </td> </tr> <tr> <td class="tdrow2" width="15%"><b>類別名稱:</b></td> <td class="tdrow3" width="75%" valign="top"> <input type="text" name="name" value="'.CleanFormValue($section['name']).'" /> </td> </tr>'; if($sectionid != 1) { echo '<tr> <td class="tdrow2" width="15%" valign="top"><b>類別描述:</b></td> <td class="tdrow3" width="75%" valign="top"> <textarea name="description" cols="54" rows="5">'.$section['description'].'</textarea> </td> </tr> <tr> <td class="tdrow2" width="15%" valign="top"><b>發佈選項:</b></td> <td class="tdrow3" width="75%" valign="top"> <input type="checkbox" name="activated" value="1" '.iif($section['activated']== 1, "CHECKED").'> <b>發佈:</b> 網站顯示此類別及其下屬鏈接? </td> </tr>'; } echo '<tr> <td colspan="2" class="tdrow1" align="center">'; if($sectionid) { echo '<input type="hidden" name="action" value="updatesection" /> <input type="submit" value=" 保存更新 " />'; } else { echo '<input type="hidden" name="action" value="insertsection" /> <input type="submit" value=" 提交保存 " />'; } echo ' </td> </tr> </table> </form>'; EndSection(); } // view the link form to insert/edit a link function DisplayLinkForm($linkid) { global $DB, $rootpath, $refreshpage, $userinfo, $loadwysiwyg, $enablewysiwyg; if(isset($linkid)) { // gather link information $link = $DB->query_first("SELECT * FROM " . TABLE_PREFIX . "m16_links WHERE linkid = '$linkid'"); PrintSection('編輯鏈接'); } else { // get current loggedin username $username = $userinfo['username']; // create empty array $link = array("sectionid" => '1', "author" => $username, "title" => "", "url" => "http://", "description" => "", "activated" => 1, "showauthor" => 1, "allowsmilies" => 1 ); PrintSection('添加鏈接'); } echo '<form method="post" action="'.$refreshpage.'"> <input type="hidden" name="linkid" value="'.$linkid.'" /> <table width="100%" border="0" cellpadding="5" cellspacing="0">'; if(isset($linkid)) { // delete link option echo '<tr> <td class="tdrow2" width="15%"><b>刪除鏈接:</b></td> <td class="tdrow3" width="75%" valign="top"> <input type="checkbox" name="deletelink" value="1"> 刪除此鏈接? </td> </tr>'; } echo '<tr> <td class="tdrow2" width="15%"><b>發佈人:</b></td> <td class="tdrow3" width="75%" valign="top"> <input type="text" name="author" value="'.CleanFormValue($link['author']).'" /> </td> </tr> <tr> <td class="tdrow2" width="15%"><b>所屬類別:</b></td> <td class="tdrow3" width="75%" valign="top">'; PrintSectionSelection('sectionid', $link['sectionid']); echo ' </td> </tr> <tr> <td class="tdrow2" width="15%"><b>鏈接標題:</b></td> <td class="tdrow3" width="75%" valign="top"> <input type="text" name="title" size="64" maxlength="128" value="'.CleanFormValue($link['title']).'"> </td> </tr> <tr> <td class="tdrow2" width="15%" valign="top"><b>鏈接路徑:</b></td> <td class="tdrow3" width="75%" valign="top"> <input type="text" name="url" size="64" value="'.CleanFormValue($link['url']).'"> 需填寫完整路徑, 如: <i>http://www.weentech.com</i> </td> </tr> <tr> <td class="tdrow2" width="15%" valign="top"><b>鏈接描述:</b>'; if($loadwysiwyg AND $enablewysiwyg){ echo '  <a href="javascript:;" onclick="javascript: ween_toggleEditor(\'linkdescription\', \'tinytogglelink\', \'tinytoggleimglink\');return false;" id="tinytogglelink" title="Hide TinyMCE"><img src="styles/advanced/images/disabletiny.gif" border="0" align="absmiddle" id="tinytoggleimglink"></a>'; } echo '</td> <td class="tdrow3" width="75%" valign="top"> <textarea name="description" rows="16" style="width: 100%;" class="mceEditor" id="linkdescription">'.$link['description'].'</textarea> </td> </tr> <tr> <td class="tdrow2" width="15%" valign="top"><b>發佈選項:</b></td> <td class="tdrow3" width="75%" valign="top"> <input type="checkbox" name="activated" value="1" '.iif($link['activated']== 1, "CHECKED").'> <b>發佈:</b> 選擇是否發佈鏈接?<br /> <input type="checkbox" name="showauthor" value="1" '.iif($link['showauthor']== 1, "CHECKED").'> <b>發佈人:</b> 選擇是否顯示發佈人?<br /> <input type="checkbox" name="allowsmilies" value="1" '.iif($link['allowsmilies']== 1, "CHECKED").'> <b>表情符號:</b> 是否允許在鏈接描述中輸入的表情代碼字符組合轉換成表情符號?<br /> </td> </tr> <tr> <td colspan="2" align="center" class="tdrow1">'; if($linkid) { echo '<input type="hidden" name="action" value="updatelink" /> <input type="submit" value=" 保存更新 " />'; } else { echo '<input type="hidden" name="action" value="insertlink" /> <input type="submit" value=" 提交保存 " />'; } echo ' </td> </tr> </table> </form>'; EndSection(); } function PrintSectionChildren($parentid, $selected, $exclude, $indent, $displaycounts = 0) { global $DB; $getsections = $DB->query("SELECT sectionid, name FROM " . TABLE_PREFIX . "m16_sections WHERE parentid = $parentid ORDER BY name"); while($sections = $DB->fetch_array($getsections)) { if($exclude != $sections['sectionid']) { $name = $indent . ' ' . $sections['name'] .iif($sections['sectionid'] == 1,"(默認)",""); if($displaycounts) { $getimagecount = $DB->query_first("SELECT COUNT(*) FROM " . TABLE_PREFIX . "m16_links WHERE activated = '1' AND sectionid = " . $sections['sectionid']); $name .= '('.$getimagecount[0].')'; } echo "<option value=\"$sections[sectionid]\" ".iif($selected == $sections['sectionid'],"selected","").">$name</option>"; } PrintSectionChildren($sections['sectionid'], $selected, $exclude, $indent . '-', $displaycounts); } } function PrintSectionChildrenEXX($parentid, $selected, $exclude, $indent, $displaycounts = 0) { global $DB; $getsections = $DB->query("SELECT sectionid, parentid, name FROM " . TABLE_PREFIX . "m16_sections WHERE parentid = $parentid ORDER BY name"); while($sections = $DB->fetch_array($getsections)) { if($exclude != $sections['sectionid'] && $exclude != $parentid) { $name = $indent . ' ' . $sections['name'] .iif($sections['sectionid'] == 1,"(默認)",""); if($displaycounts) { $getimagecount = $DB->query_first("SELECT COUNT(*) FROM " . TABLE_PREFIX . "m16_links WHERE activated = '1' AND sectionid = " . $sections['sectionid']); $name .= '('.$getimagecount[0].')'; } echo "<option value=\"$sections[sectionid]\" ".iif($selected == $sections['sectionid'],"selected","").">$name</option>"; PrintSectionChildrenEXX($sections['sectionid'], $selected, $exclude, $indent . '-', $displaycounts); } } } // ############################ PRINT SELECTION BOX ############################ // display sections in a selection box function PrintSectionSelection($name, $selected = null, $exclude = null) { echo '<select name="' . $name . '">'; PrintSectionChildren(0, $selected, $exclude, ''); echo '</select>'; } function PrintSectionSelectionEXX($name, $selected = null, $exclude = null) { echo '<select name="' . $name . '">'; PrintSectionChildrenEXX(0, $selected, $exclude, ''); echo '</select>'; } // ######################## PRINT SECTION SELECTION EX ######################### function PrintSectionSelectionEx() { global $DB; echo '<select name="sectionid">'; PrintSectionChildren(0, null, null, '', 1); $getofflineimages = $DB->query_first("SELECT count(*) FROM " . TABLE_PREFIX . "m16_links WHERE activated = '0'"); echo '<option value="未發佈的鏈接">未發佈(' . $getofflineimages[0] . ')</option> </select>'; } // display links function DisplayLinks($viewtype) { global $DB; global $refreshpage; switch($viewtype) { case '最新鏈接': // 10 most recent submissions $getlinks = $DB->query("SELECT * FROM " . TABLE_PREFIX . "m16_links ORDER BY linkid DESC LIMIT 0,10"); break; case '未發佈的鏈接': // offline = (not activated, needs review) $getlinks = $DB->query("SELECT * FROM " . TABLE_PREFIX . "m16_links WHERE activated = '0' ORDER BY linkid DESC"); break; default: $sectionid = $viewtype; $getlinks = $DB->query("SELECT * FROM " . TABLE_PREFIX . "m16_links WHERE sectionid = '$sectionid' ORDER BY linkid DESC"); $viewtype = '鏈接'; } PrintSection($viewtype); echo '<form action="'.$refreshpage.'" method="POST" name="deletelinksform"> <input type="hidden" name="action" value="deletelinks" /> <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" width="75"><input type="checkbox" checkall="group" onclick="javascript: return select_deselectAll (\'deletelinksform\', this, \'group\');">刪除</td> </tr>'; while($link = $DB->fetch_array($getlinks)) { $section = $DB->query_first("SELECT name FROM " . TABLE_PREFIX . "m16_sections WHERE sectionid = '".$link['sectionid']."'"); echo '<tr> <td class="tdrow2"> <a href="'.$refreshpage.'&action=displaylinkform&linkid='.$link['linkid'].'&loadwysiwyg=1"><u>'.$link['title'].'</u></a></td> <td class="tdrow3"> '.$section['name'].'</td> <td class="tdrow2"> '.$link['author'].'</td> <td class="tdrow3">'.iif($link['activated']=="1","<div style=\"color:green\">發佈</div>","<div style=\"color:red\"><b>未發佈</b></div>").'</td> <td class="tdrow2"> <input type="checkbox" name="linkids[]" value="'.$link['linkid'].'" checkme="group" /></td> </tr>'; } echo '<tr> <td class="tdrow1" bgcolor="#FCFCFC" colspan="5" align="right" style="padding-right: 20px;"> <input type="submit" onclick="return confirm(\'確定要刪除所選鏈接嗎?\');" value=" 刪除鏈接 " /> </td> </tr> </table> </form>'; EndSection(); } // display the default page function DisplayDefault() { global $DB; global $refreshpage; global $moduleid; // module settings PrintSection('模塊設置'); echo '<table width="100%" border="0" cellpadding="5" cellspacing="0"> <tr><td class="tdrow1" colspan="2">詳細選項</td></tr> <tr><td class="tdrow2" width="70%">顯示設置模塊詳細屬性:</td> <td class="tdrow3" style="padding-left: 40px;"> <form method="post" action="'.$refreshpage.'"> <input type="hidden" name="action" value="displaysettings" /> <input type="submit" value=" 設置模塊 " /> </form> </td></tr> </table>'; EndSection(); // links - add/manage PrintSection('鏈接管理'); echo '<table width="100%" border="0" cellpadding="5" cellspacing="0"> <tr><td class="tdrow1" colspan="2">添加鏈接</td></tr> <tr><td class="tdrow2" width="70%">添加新鏈接到網站:</td> <td class="tdrow3" style="padding-left: 40px;"> <form method="post" action="'.$refreshpage.'&action=displaylinkform&loadwysiwyg=1"> <input type="submit" value=" 添加鏈接 " /> </form> </td></tr> <tr><td class="tdrow1" colspan="2">編輯鏈接</td></tr> <tr><td class="tdrow2" width="70%">查看編輯鏈接信息:</td> <td class="tdrow3" style="padding-left: 40px;"> <form method="post" action="'.$refreshpage.'">'; PrintSectionSelectionEx(); echo ' <input type="hidden" name="action" value="displaylinks" /> <input type="submit" value=" 編輯鏈接 " /> </form> </td></tr> </table>'; EndSection(); // sections - add/manage PrintSection('類別管理'); echo '<table width="100%" border="0" cellpadding="5" cellspacing="0"> <tr><td class="tdrow1" colspan="2">添加分類</td></tr> <tr> <td class="tdrow2" width="70%">添加產品分類, 以便對產品進行分類管理和發佈:<br /> 默認產品類別為"產品", 且不能刪除. </td> <td class="tdrow3" style="padding-left: 40px;"> <form method="post" action="'.$refreshpage.'"> <input type="hidden" name="action" value="displaysectionform" /> <input type="submit" value=" 添加分類 " /> </form> </td></tr> <tr><td class="tdrow1" colspan="2">編輯分類</td></tr> <tr><td class="tdrow2" width="70%">選擇一個產品分類, 然後進行編輯:</td> <td class="tdrow3" style="padding-left: 40px;"> <form method="post" action="'.$refreshpage.'">'; PrintSectionSelection('sectionid', ''); echo ' <input type="hidden" name="action" value="displaysectionform" /> <input type="submit" value=" 編輯分類 " /> </form> </td></tr> </table>'; EndSection(); DisplayLinks('最新鏈接'); } // ############################# Select Function ############################ switch($action) { case 'insertlink': InsertLink($sectionid, $activated, $allowsmilies, $showauthor, $author, $title, $url, $description); break; case 'updatelink': UpdateLink($deletelink, $linkid, $sectionid, $activated, $allowsmilies, $showauthor, $author, $title, $url, $description); break; case 'deletelinks': DeleteLinks(); break; case 'deletelink': DeleteLink($linkid); break; case 'insertsection': InsertSection($parentid, $activated, $name, $description, $sorting); break; case 'updatesection': UpdateSection($sectionid, $parentid, $activated, $name, $description, $sorting); break; case 'displaylinkform': DisplayLinkForm($linkid); break; case 'displaysectionform': DisplaySectionForm($sectionid); break; case 'displaylinks': DisplayLinks($sectionid); break; case 'displaysettings': DisplaySettings(); break; default: DisplayDefault(); }