參考網址：http://phpbb-tw.net/phpbb/viewtopic.php ... %A4%BD%A7i
使用外掛：phpbbs2.0.8
狀況描述：
我突然想到一個想法，我曾經看過由竹貓寫的書，在第A-3頁(公告條部份)的Tips話可以自行編寫SQL指令然後轉成php檔.......
代碼: 選擇全部
<?php
$USER="root";
$PASSED="12345";
$HOST="localhost";
$LinkToDB=mysql_pconnect("$HOST","$USER","PASSED");
mysql_db_query("taurus", "INSERT INTO phpbb_config(config_name , config_value) VALUES ('announce_enable','1')", $LinkToDB);
mysql_db_query("taurus", "INSERT INTO phpbb_config(config_name , config_value) VALUES ('announce_content','')", $LinkToDB);
?>
代碼: 選擇全部
##############################################################
## MOD Title: Split topic type
## MOD Author: Ptirhiik < admin@rpgnet-fr.com > (Pierre) http://rpgnet.clanmckeen.com
## MOD Description:
## This mod splits the topic per type in the viewform display
##
## MOD Version: 2.0.1
##
## Installation Level: Moderate
## Installation Time: 10 Minutes
## Files To Edit:
## viewforum.php
## includes/functions.php
## templates/subSilver/subSilver.cfg
## templates/subSilver/viewforum_body.tpl
##
## Included Files:
## mod_split_topic_type.php
## lang_extend_split_topic_type.php
##
## --- lang settings ---
## mod-lang_settings/lang_extend_mac.php
##
## --- mods settings ---
## mod-mods_settings/admin_board_extend.php
## mod-mods_settings/functions_mods_settings.php
## mod-mods_settings/lang_extend_mods_settings.php
## mod-mods_settings/board_config_extend_body.tpl
##
## --- topics list ---
## mod-topics_list/functions_topics_list.php
## mod-topics_list/topics_list_box.tpl
## mod-topics_list/graph.gif/folder_announce_own.gif
## mod-topics_list/graph.gif/folder_announce_new_own.gif
## mod-topics_list/graph.gif/folder_own.gif
## mod-topics_list/graph.gif/folder_new_own.gif
## mod-topics_list/graph.gif/folder_hot_own.gif
## mod-topics_list/graph.gif/folder_new_hot_own.gif
## mod-topics_list/graph.gif/folder_lock_own.gif
## mod-topics_list/graph.gif/folder_lock_new_own.gif
## mod-topics_list/graph.gif/folder_sticky_own.gif
## mod-topics_list/graph.gif/folder_sticky_new_own.gif
##
##############################################################
## For Security Purposes, Please Check: http://www.phpbb.com/mods/ for the
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered
## in our MOD-Database, located at: http://www.phpbb.com/mods/
##############################################################
## Author Notes:
## o users can choose their prefered setup (required full mods settings mod to be installed).
## Admin can also choose to override the users choice for each setup parameter.
##
##############################################################
## MOD History:
##
## 2003-10-21 - Version 2.0.1
## - add the lang_settings tool
## - upgrade the mods_settings tool
##
## 2003-09-09 - Version 2.0.0
## - use of the functions_topics_list
## - use the mods_settings for user preferences
##
## 2003-07-13 - Version 1.0.5
## - allow to split the topic in boxes
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################
#
#-----[ SQL ]-------------------------------------------------
#
#
# This part is optional : do it only if you want your users to be able to choose their setup
# if you want so, you'll have to install the MOD-mods_settings mod included in the pack
#
# note also you haven't to add the user_split_global_announce if you don't use global announces mod
#
ALTER TABLE phpbb_users ADD user_split_global_announce TINYINT(1) DEFAULT '1' NOT NULL;
ALTER TABLE phpbb_users ADD user_split_announce TINYINT(1) DEFAULT '1' NOT NULL;
ALTER TABLE phpbb_users ADD user_split_sticky TINYINT(1) DEFAULT '1' NOT NULL;
ALTER TABLE phpbb_users ADD user_split_topic_split TINYINT(1) DEFAULT '0' NOT NULL;
