學校公告系統 schoolboard 1.1 版 本系統由台北縣福營國中教師張文杰編修設計 在非營利及商業用途下,任何人都可免費使用、散佈及修改本程式 版本說明: schoolboard 1.0 2000/06/20 第一次開放下載 schoolboard 1.1 2000/06/23 修正schoolboard.php3張貼公告後按重新整理會再張貼同一份公告的bug 修改profile.php3讓列印畫面變單純 特色: 1.行政人員可自行註冊帳號 2.公告時可上傳附件,附件是存放在公告人的帳號目錄下 3.公告人可修改或刪除自己的公告 4.一些公告系統常見的功能 安裝: 一系統需求:UNIX下,apache+mysql+php 二下載schoolboard.tar.gz 三解壓縮 #cd /usr/local/apache/htdocs #tar zxvf schoolboard.tar.gz #cd schoolboard 建立附件上傳目錄 #mkdir attachment 更改附件上傳目錄 attachment 為 777 #chmod 777 attachment 四建立資料庫 #cd /usr/local/apache/htdocs/schoolboard 執行下列步驟前請先修改schoolboard.sql檔, 將第七行password( 'school' )改成password( '您欲使用的密碼' ) #mysql -u root -p密碼 < schoolboard.sql 五修改 schoolboard.ini 來適合您的環境 $dbhost = "localhost"; $default_dbname = "schoolboard"; $dbusername = "schoolboard"; $dbuserpassword = "school"; #改成步驟四'您欲使用的密碼' $user_tablename = "user_table"; $attachmentdir = "/usr/local/apache/htdocs/schoolboard/attachment/"; #存放上傳附件目錄 $board = "school_board"; $board_title = "學校公告"; #可改成"某某國中公告" # Look and feel $default_font = "Times New Roman"; $default_font_size = "2"; $master_table_bgcolor ="#EBEBEB"; $master_table_bordercolor ="#FFFFFF"; $header_cell_bgcolor = "#303072"; $header_cell_font_color = "#FFFFFF"; $msg_cell_bgcolor="#D8E9FE"; $msg_display_cell_bgcolor = "#F0F5FF"; $post_table_bgcolor = "#FFFFFF"; $post_cell_bgcolor = "#DDDDDD"; $post_cell_font_color = "black"; $feature_cell_bgcolor="#EBEBEB"; $menu_cell_bgcolor = "#EBEBEB"; $feature_colspan = $menu_colspan = "6"; $info_colspan = "6"; $separator = "<hr width=\"90%\" size=\"1\">"; $master_table_width = '90%'; $master_table_border = '0'; $post_table_border = '0'; $master_cellpadding = '1'; $master_cellspacing = '1'; $post_cellpadding = '1'; $post_cellspacing = '1'; $board_info_table_width = '90%'; $number_cell_width ="5%"; $subject_cell_width = "51%"; $id_cell_width = "8%"; $name_cell_width ="20%"; $hit_cell_width = "8%"; $date_cell_width = "8%"; $msg_rows = "15"; $msg_cols = "50"; $subject_length = "40"; # The maximum number of messages listed per page $max_msg_per_page = 15; #每頁最多顯示幾則公告 # hspace between threaded messages $default_hspace = 5; # set $allowhtml to 1 (true) if you want to allow html tags $allowhtml = 0; #是否允許使用 html,目前設定為不可以 $icon_dir = "icons"; $space_icon = "$icon_dir/space.gif"; $main_icon = "$icon_dir/main.gif"; $new_main_icon = "$icon_dir/main_new.gif"; $reading_icon = "$icon_dir/reading.gif"; $print_icon = "$icon_dir/print.gif"; # Who are you? $webmaster_email = "you@yourdomain.com"; #管理者的email,當有新公告會寄到此信箱 $webmaster_signature = "Your signature goes here."; $webmaster_signature .= "You got more to say in your signature? It might go on and on..."; # Wanna get notified on new postings? $maileron = 0; #有新公告是否要email給管理者,目前設定為不要 六將 schoolboard.ini 搬移至別的目錄(為了安全起見) #mv schoolboard.ini /usr/local/apache/include 修改 schoolboard.php3 檔,將第1084行 include "./schoolboard.ini"; 改成 include "/usr/local/apache/include/schoolboard.ini"; 修改 profile.php3 檔,將第1行 include "schoolboard.ini"; 改成 include "/usr/local/apache/include/schoolboard.ini"; 七修改 boardregister.ini 來適合您的環境 $dbhost = "localhost"; $default_dbname = "schoolboard"; $dbusername = "schoolboard"; $dbuserpassword = "school"; #改成步驟四'您欲使用的密碼' $user_tablename = "user_table"; $attachmentdir = "/usr/local/apache/htdocs/schoolboard/attachment/"; #存放上傳附件目錄 #下列是行政人員註冊時可選擇的公告單位,請自行增修 $departments = array('校長室','教務處','訓導處','輔導室','總務處','人事室','會計室','補校','教師會','合作社','家長會'); #下列兩行是執行註冊程式boardregister.php3時的認證帳號及密碼,請自行修改 $register_id = "register"; $register_pwd = "11111"; # Who are you? $webmaster_email = "you@yourdomain.com"; #管理者的email,當有新註冊者會寄到此信箱 $webmaster_signature = "Your signature goes here."; $webmaster_signature .= "You got more to say in your signature? It might go on and on..."; # Wanna get notified on new postings? $maileron = 0; #有新註冊者是否要email給管理者,目前設定為不要 八將 boardregister.ini 搬移至別的目錄(為了安全起見) #mv boardregister.ini /usr/local/apache/include 修改 boardregister.php3 檔,將第2行 include "boardregister.ini"; 改成 include "/usr/local/apache/include/boardregister.ini"; 恭喜您大功告成 執行公告人註冊程式:http://yourhostdomain/schoolboard/boardregister.php3 執行公告系統:http://yourhostdomain/schoolboard/schoolboard.php3 備註:修改 boardfooter.inc 將小弟編修設計的字眼給去掉