學校公告系統 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 將小弟編修設計的字眼給去掉