我把中文的假期彙總到一支小程式內，可以更改smf的資料庫。各位如有需要可以據以增刪所需的中文假期。
<?
$username = "your username";
$password = "your password";
$host = "localhost";
$database = "your smf database";
$table = "smf_calendar_holidays";
//holidays with the same date each year;
$holidays[] = array("元旦"=>"0000-01-01");
$holidays[] = array("自由日"=>"0000-01-23");
$holidays[] = array("情人節"=>"0000-02-14");
$holidays[] = array("和平紀念日"=>"0000-02-28");
$holidays[] = array("植樹節" => "0000-03-12");
$holidays[] = array("青年節" => "0000-03-29");
$holidays[] = array("愚人節" => "0000-04-01");
$holidays[] = array("婦幼節" => "0000-04-04");
$holidays[] = array("世界地球日" => "0000-04-22");
$holidays[] = array("勞動節" => "0000-05-01");
$holidays[] = array("父親節" => "0000-08-08");
$holidays[] = array("教師節" => "0000-09-28");
$holidays[] = array("國慶紀念日" => "0000-10-10");
$holidays[] = array("台灣光復節" => "0000-10-25");
$holidays[] = array("聖誕節" => "0000-12-25");
//holidays with different date each year
//2005
$holidays[] = array("除夕"=>"2005-02-07");
$holidays[] = array("春節"=>"2005-02-08");
$holidays[] = array("元宵節"=>"2005-02-23");
$holidays[] = array("母親節"=>"2005-05-08");
$holidays[] = array("端午節"=>"2005-06-11");
$holidays[] = array("七夕情人節" => "2005-08-11");
$holidays[] = array("中元節" => "2005-08-19");
$holidays[] = array("中秋節" => "2005-09-18");
//2006
$holidays[] = array("除夕"=>"2006-01-28");
$holidays[] = array("春節" => "2006-01-29");
$holidays[] = array("元宵節" => "2006-02-12");
$holidays[] = array("母親節" => "2006-05-14");
$holidays[] = array("端午節" => "2006-05-31");
$holidays[] = array("七夕情人節" => "2006-07-31");
$holidays[] = array("中元節" => "2006-08-08");
$holidays[] = array("中秋節" => "2006-10-06");
//2007
$holidays[] = array("除夕" => "2007-02-17");
$holidays[] = array("春節" => "2007-02-18");
$holidays[] = array("元宵節" => "2007-03-04");
$holidays[] = array("母親節" => "2007-05-13");
$holidays[] = array("端午節" => "2007-06-19");
$holidays[] = array("七夕情人節" => "2007-08-19");
$holidays[] = array("中元節" => "2007-08-27");
$holidays[] = array("中秋節" =>"2007-09-25");
//2008
$holidays[] = array("除夕" => "2008-02-06");
$holidays[] = array("春節" => "2008-02-07");
$holidays[] = array("元宵節" => "2008-02-21");
$holidays[] = array("母親節" => "2008-5-11");
$holidays[] = array("端午節" => "2008-06-08");
$holidays[] = array("七夕情人節" => "2008-08-07");
$holidays[] = array("中元節" => "2008-08-15");
$holidays[] = array("中秋節" => "2008-09-14");
//2009
$holidays[] = array("除夕" => "2009-01-25");
$holidays[] = array("春節" => "2009-01-26");
$holidays[] = array("元宵節" => "2009-02-09");
$holidays[] = array("母親節" => "2009-05-10");
$holidays[] = array("端午節" => "2009-05-28");
$holidays[] = array("七夕情人節" => "2009-08-26");
$holidays[] = array("中元節" => "2009-09-03");
$holidays[] = array("中秋節" => "2009-10-03");
//2010
$holidays[] = array("除夕" => "2010-02-13");
$holidays[] = array("春節" => "2010-02-14");
$holidays[] = array("元宵節" => "2010-02-28");
$holidays[] = array("母親節" => "2010-05-09");
$holidays[] = array("端午節" => "2010-06-16");
$holidays[] = array("七夕情人節" => "2010-08-16");
$holidays[] = array("中元節" => "2010-08-24");
$holidays[] = array("中秋節" => "2010-09-22");
//2011
$holidays[] = array("除夕" => "2011-02-02");
$holidays[] = array("春節" => "2011-02-03");
$holidays[] = array("元宵節" => "2011-02-17");
$holidays[] = array("母親節" => "2011-05-08");
$holidays[] = array("端午節" => "2011-06-06");
$holidays[] = array("七夕情人節" => "2011-08-06");
$holidays[] = array("中元節" =>" 2011-08-14");
$holidays[] = array("中秋節" => "2011-09-12");
//2012
$holidays[] = array("除夕" => "2012-01-22");
$holidays[] = array("春節" => "2012-01-23");
$holidays[] = array("元宵節" => "2012-02-06");
$holidays[] = array("母親節" => "2012-05-13");
$holidays[] = array("端午節" => "2012-06-23");
$holidays[] = array("七夕情人節" => "2012-08-23");
$holidays[] = array("中元節" => "2011-08-31");
$holidays[] = array("中秋節" => "2011-09-30");
$link = mysql_connect($host, $username, $password) or die('Could not connect:' . mysql_error());
mysql_select_db($database) or die('Could not select database');
//empting orgin information of holidays in smf
$result = mysql_query("TRUNCATE TABLE $table") or die('Query failed: '. mysql_error());
$id = 1;
//inserting chinese information of holidays via looping
foreach ($holidays as $sub_key) {
foreach ($sub_key as $key => $value) {
$string = "INSERT INTO $table (ID_HOLIDAY, eventDate, title ) VALUES ('$id', '$value', '$key')";
$result = mysql_query($string) or die('Query failed: ' . mysql_error());
echo "$value of $key was inserted..
";
$id++;
}
}
echo "Chinese Holidays inserted completely...";
mysql_close($link);
?>
