1 頁 (共 1 頁)

[外掛] Fully integrated shoutbox 1.1.6論壇即時留言版

發表於 : 2006-11-10 , 8:12
懸壺子
[外掛] Fully integrated shoutbox 1.1.6論壇即時留言版
http://starryhometown.net/forum/viewtopic.php?t=440

代碼: 選擇全部

############################################################## 
## MOD Title:          Fully integrated shoutbox 
## MOD Author:         Niels < ncr@db9.dk > (Niels Chr. R鷣) http://mods.db9.dk 
## MOD Description:    A fully phpBB2 enabled shoutbox witch support:
##                     database abstration layer, timezones, languages
##                     templates, smilies, BBcode and censored words
##
## MOD Version:        1.1.6
## MOD Compatibility:  2.0.0->2.0.6
## 
## Installation Level: Intermediate
## Installation Time:  15 Minutes (1mn by EasyMOD of Nuttzy)
## Files To Edit:      12
##      index.php
##      viewonline.php
##      admin/admin_board.php
##      admin/admin_db_utilities.php
##      admin/admin_users.php
##      includes/constants.php
##      language/lang_english/lang_admin.php 
##      language/lang_english/lang_main.php
##      templates/subSilver/index_body.tpl
##      templates/subSilver/subSilver.cfg
##      templates/subsilver/admin/board_config.tpl
##
## Included Files:     10
##      shoutbox_db_update.php
##      root/shoutbox.php
##      root/shoutbox_max.php
##      root/shoutbox_view.php
##      root/templates/subSilver/bbcode.js
##      root/templates/subSilver/shoutbox_body.tpl
##      root/templates/subSilver/shoutbox_max_body.tpl
##      root/templates/subSilver/shoutbox_max_guest_body.tpl
##      root/templates/subSilver/shoutbox_view_body.tpl
##      root/templates/subSilver/images/icon_censor.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: 
## 
## 1. Full MOD description
## -----------
## A fully phpBB2 enabled shoutbox witch support: database
## abstration layer, timezones, languages templates, smilies,
## BBcode, censored words and user/usergroups.
## Shouts can be set to auto prune after X days, this will
## be executed when ever a user post a shout
##
## 2. EasyMOD
## -----------
n## This MOD is compatible and can be installed by EasyMOD
## of Nuttzy (but is not officially EasyMOD Compliant)!
## http://area51.phpbb.com/phpBB22/viewforum.php?sid=&f=15
##
## However, on alpha releases of EM and meanwhile beta or 
## final release some actions are NOT performed.
## You'll have to do them manually !
##
## 2.1 SQL commands are not performed
## -----------
## This MOD need a database update.
## Then, in any case if you install this MOD manually or using
## an alpha release of EM, please copying the *_db_update.php
## in your phpBB root directory, run it with your navigator,
## and then delete it from the phpBB root directory.
##
## Please, do it NOW! Before editing phpBB files by EM or manually!!!
## Otherwise, you may have an error message during your next
## connection.
##
## 2.2 Translation are not managed
## -----------
## Moreover, EM can not already manage actions for any other
## language than English (but language intructions are proceed
## to all installed languages in order to prevent errors).
## So the translations provided with this MOD must be installed
## manually if you need them.
##
## 3. Official last version link
## -----------
## Meanwhile the phpBB group validation and as the MOD is not yet
## in the phpBB MOD database, check this official link for updates...
## http://mods.db9.dk/viewtopic.php?t=1568
## 
############################################################## 
## MOD History: 
##
##   2005-09-03 - Version 1.1.6
##	- highlight exploit by alcaeus, shoutbox_max.php upgraded
## 
##   2004-03-18 - Version 1.1.5
##	- added a copy command, to copy all included files
##	- changed lang['smilies'] to lang['emoticons']
##
##   2004-03-10 - Version 1.1.4
##	- changed template "switch" in index_body.tpl
##
##   2004-03-10 - Version 1.1.3
##	- removed the change done into page_header.php as no longer needed
##
##   2004-03-08 - Version 1.1.2
##	- now also support language encoding
##
##   2004-03-08 - Version 1.1.1
##	- templates isues fixed, various places
##
##   2004-02-28 - Version 1.1.0
##	- added support bbcode on index, now no longer require my "Extra permission MOD"
##
##   2004-02-22 - Version 1.0.11
##	- added support for line breaks to shoutbox
##
##   2004-01-07 - Version 1.0.10
##	- flood error on the index, is now displayed more nicely
##
##   2004-01-07 - Version 1.0.9
##	- corrected a bug regarding flood control
##
##   2003-12-11 - Version 1.0.8 
##      - phpBB template & EasyMOD compliance enhancement
##      - Chinese Traditional Taiwan, Dutch, French, German
##        German_sie, Italian & Swedish translations now provide
##        with the MOD
## 
##   ????-??-?? - Version 1.0.7
##      - typo reported by [D]J see...
##        http://mods.db9.dk/viewtopic.php?t=3449
## 
##   ????-??-?? - Version 1.0.6
##      - typo reported by nullOs see...
##        http://mods.db9.dk/viewtopic.php?t=3449
## 
##   ????-??-?? - Version 1.0.5
##      - typo reported by RapidDr3am see...
##        http://mods.db9.dk/viewtopic.php?t=3328
## 
##   ????-??-?? - Version 1.0.4
##      - corrected included template files shoutbox_max.tpl
##        and shoutbox_max_guest-tpl
## 
##   ????-??-?? - Version 1.0.3
##      - added changes to admin_db_utils.php
## 
##   ????-??-?? - Version 1.0.2
##      - no change in the how-to, the included files updated
##        to handle username more correctly
## 
##   ????-??-?? - Version 1.0.1
##      - improved the included files
## 
##   ????-??-?? - Version 1.0.0
##      - added allowtransparency="true" to iframes
## 
##   ????-??-?? - Version 0.9.14
##      - added path to constants.php file, it was missing
## 
##   ????-??-?? - Version 0.9.13
##      - Now support auto prune of shouts
## 
##   ????-??-?? - Version 0.9.12
##      - DB change, added extra fields
## 
##   ????-??-?? - Version 0.9.11
##      - a previous upgrade was some how gone, from the how-to,
##        now pressent again !
## 
##   ????-??-?? - Version 0.9.10
##      - now handle, username if users are deleted
## 
##   ????-??-?? - Version 0.9.9
##      - corrected a typo in the how-to, making shout_id auto
##        increment
## 
##   ????-??-?? - Version 0.9.8
##      - improved permission control
## 
##   ????-??-?? - Version 0.9.7
##      - moved shoutbox above who-is-online, and fixed some
##        auth isues
## 
##   ????-??-?? - Version 0.9.6
##      - improved version, now also support censor of shout's
## 
##   ????-??-?? - Version 0.9.5
##      - require my "Extra permission mod", witch makes it
##        posible to control who may shout
## 
##   ????-??-?? - Version 0.9.4
##      - now maximized version have postes detail
## 
##   ????-??-?? - Version 0.9.3
##      - now support cenzored words
## 
##   ????-??-?? - Version 0.9.2
##      - now posible to "maximize" shoutbox, and view shouts
##        back in time
## 
##   ????-??-?? - Version 0.9.1
##      - DB changes now included
## 
##   ????-??-?? - Version 0.9.0
##      - initial beta  
##
############################################################## 
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
############################################################## 
# 
#-----[ COPY ]------------------------------------------------ 
#
copy shoutbox_db_update.php to shoutbox_db_update.php
copy root/shoutbox.php to shoutbox.php
copy root/shoutbox_max.php to shoutbox_max.php
copy root/shoutbox_view.php to shoutbox_view.php
copy root/templates/subSilver/shoutbox_body.tpl to templates/subSilver/shoutbox_body.tpl
copy root/templates/subSilver/shoutbox_max_body.tpl to templates/subSilver/shoutbox_max_body.tpl
copy root/templates/subSilver/shoutbox_max_guest_body.tpl to templates/subSilver/shoutbox_max_guest_body.tpl
copy root/templates/subSilver/shoutbox_view_body.tpl to templates/subSilver/shoutbox_view_body.tpl
copy root/templates/subSilver/images/icon_censor.gif to templates/subSilver/images/icon_censor.gif
copy root/templates/subSilver/bbcode.js to templates/subSilver/bbcode.js 

#
# This MOD need a database update.
# Then, as you must have now copied the shoutbox_db_update.php file
# in your phpBB root directory, run it with your navigator...
# http://www.yourWebSite.xxx/phpbbRootDir/shoutbox_db_update.php
#
# ...and then delete it from the phpBB root directory!!!
#
# Please, do it NOW! Before editing phpBB files by EM or manually!!!
# Otherwise, you may have an error message during your next
# connection.
#

# 
#-----[ OPEN ]------------------------------------------------ 
# 
index.php

# 
#-----[ FIND ]------------------------------------------------ 
#
'FORUM_LOCKED_IMG' =>

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#

// Start add - Fully integrated shoutbox MOD
'U_SHOUTBOX' => append_sid("shoutbox.$phpEx"),
'L_SHOUTBOX' => $lang['Shoutbox'],
'U_SHOUTBOX_MAX' => append_sid("shoutbox_max.$phpEx"),
// End add - Fully integrated shoutbox MOD

# 
#-----[ OPEN ]------------------------------------------------ 
# 
viewonline.php

# 
#-----[ FIND ]------------------------------------------------ 
#
$location_url = "faq.$phpEx";
break;

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#

// Start add - Fully integrated shoutbox MOD
case PAGE_SHOUTBOX:
	$location = $lang['Shoutbox'];
	$location_url = "shoutbox_max.$phpEx";
	break;
// End add - Fully integrated shoutbox MOD

# 
#-----[ OPEN ]------------------------------------------------ 
# 
admin/admin_board.php

# 
#-----[ FIND ]------------------------------------------------ 
# 
"L_ENABLE_PRUNE" =>

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#

// Start add - Fully integrated shoutbox MOD
'L_PRUNE_SHOUTS' => $lang['Prune_shouts'], 
'L_PRUNE_SHOUTS_EXPLAIN' => $lang['Prune_shouts_explain'], 
// End add - Fully integrated shoutbox MOD

# 
#-----[ FIND ]------------------------------------------------ 
# 
"PRUNE_NO" =>

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#

// Start add - Fully integrated shoutbox MOD
'PRUNE_SHOUTS' => $new['prune_shouts'], 
// End add - Fully integrated shoutbox MOD

# 
#-----[ OPEN ]------------------------------------------------ 
# 
nadmin/admin_db_utilities.php

# 
#-----[ FIND ]------------------------------------------------ 
#
$tables = array(

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#

// Start add - Fully integrated shoutbox MOD
$tables[] = 'shout';
// End add - Fully integrated shoutbox MOD

# 
#-----[ OPEN ]------------------------------------------------ 
# 
admin/admin_users.php

# 
#-----[ FIND ]------------------------------------------------ 
#
message_die(GENERAL_ERROR, 'Could not update posts for this user', '', __LINE__, __FILE__, $sql);
}

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#

// Start add - Fully integrated shoutbox MOD
$sql = "UPDATE " . SHOUTBOX_TABLE . "
	SET shout_user_id = " . DELETED . ", shout_username = '$username' 
	WHERE shout_user_id = $user_id";
	if( !$db->sql_query($sql) )
	{
n		message_die(GENERAL_ERROR, 'Could not update shouts for this user', '', __LINE__, __FILE__, $sql);
	}
// End add - Fully integrated shoutbox MOD

# 
#-----[ OPEN ]------------------------------------------------ 
# 
includes/constants.php

# 
#-----[ FIND ]------------------------------------------------ 
#
define('PAGE_GROUPCP', -11);

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#

// Start add - Fully integrated shoutbox MOD
define('PAGE_SHOUTBOX_MAX',-1035);
define('PAGE_SHOUTBOX',-1035);
// End add - Fully integrated shoutbox MOD

# 
#-----[ FIND ]------------------------------------------------ 
#
define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#

// Start add - Fully integrated shoutbox MOD
define('SHOUTBOX_TABLE', $table_prefix.'shout');
// End add - Fully integrated shoutbox MOD

# 
#-----[ OPEN ]------------------------------------------------ 
# 
#    (make sure to edit this file for every language your admin uses). 
language/lang_english/lang_admin.php
\r
# 
#-----[ FIND ]------------------------------------------------ 
# 
?>

# 
#-----[ BEFORE, ADD ]----------------------------------------- 
#

// Start add - Fully integrated shoutbox MOD
$lang['Prune_shouts'] = 'Auto prune shouts'; 
$lang['Prune_shouts_explain'] = 'Number of days, before the shouts are deleted, if a value of 0 is submittd, autoprune will be disabled'; 
// End add - Fully integrated shoutbox MOD

# 
#-----[ OPEN ]------------------------------------------------ 
# 
language/lang_english/lang_main.php

# 
#-----[ FIND ]------------------------------------------------ 
#
?>

# 
#-----[ BEFORE, ADD ]----------------------------------------- 
#

// Start add - Fully integrated shoutbox MOD
$lang['Shoutbox'] = 'Shoutbox';
$lang['Shoutbox_date'] = ' d m Y h:i:s';
$lang['Shout_censor'] = 'shout removed !';
$lang['Shout_refresh'] = 'Refresh';
$lang['Shout_text'] = 'Your text';
$lang['Viewing_Shoutbox']= 'Viewing shoutbox';
$lang['Censor'] ='Censor';
// End add - Fully integrated shoutbox MOD

# 
#-----[ OPEN ]------------------------------------------------ 
# 
templates/subSilver/index_body.tpl

# 
#-----[ FIND ]------------------------------------------------ 
#
<td align="right"><span class="gensmall">{S_TIMEZONE}</span></td>
</tr>
</table>

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#

<!-- Start add - Fully integrated shoutbox MOD -->
<table width="100%" cellspacing="0" border="0" align="center" cellpadding="2" class="forumline"> 
      <tr> 
         <td align="center" nowrap="nowrap" class="catHead"><span class="cattitle"><a href="{U_SHOUTBOX_MAX}">{L_SHOUTBOX}</a></span></td> 
      </tr> 
      <tr>
         <td> 
          <iframe src="{U_SHOUTBOX}" scrolling="NO" width="100%" height="180" frameborder="0" marginheight="0" marginwidth="0" allowtransparency="true"></iframe> 
         </td> 
  </tr> 
</table>
<br/>
<!-- End add - Fully integrated shoutbox MOD -->

# 
#-----[ OPEN ]------------------------------------------------ 
# 
templates/subSilver/subSilver.cfg

# 
#-----[ FIND ]------------------------------------------------ 
#
?>

# 
#-----[ BEFORE, ADD ]----------------------------------------- 
#

// Start add - Fully integrated shoutbox MOD
$images['icon_censor'] = "$current_template_images/icon_censor.gif";
// End add - Fully integrated shoutbox MOD

# 
#-----[ OPEN ]------------------------------------------------ 
# 
#  (make sure to edit this file for every theme your admin uses). 
templates/subSilver/admin/board_config_body.tpl

# 
#-----[ FIND ]------------------------------------------------ 
#

<tr>
	<td class="row1">{L_ENABLE_PRUNE}</td>
	<td class="row2"><input type="radio" name="prune_enable" value="1" {PRUNE_YES} /> {L_YES}  <input type="radio" name="prune_enable" value="0" {PRUNE_NO} /> {L_NO}</td>
</tr>

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#

<!-- Start add - Fully integrated shoutbox MOD -->
<tr> 
   <td class="row1">{L_PRUNE_SHOUTS}<br /><span class="gensmall">{L_PRUNE_SHOUTS_EXPLAIN}</span></td> 
   <td class="row2"><input type="text" size="6" maxlength="6" name="prune_shouts" value="{PRUNE_SHOUTS}" /></td> 
</tr>
<!-- End add - Fully integrated shoutbox MOD -->

# 
#-----[ SAVE/CLOSE ALL FILES ]-------------------------------- 
# 
# EoM

Re: [外掛] Fully integrated shoutbox 1.1.6

發表於 : 2006-11-10 , 8:13
懸壺子

代碼: 選擇全部

############################################################## 
## MOD Title:   Fully integrated shoutbox
## MOD Version: 1.0.8
## Translation: Chinese traditional Taiwan 
## Rev date:    11/12/2003 
## 
## Translator:  MacGyver < ycl_6@sinamail.com > (n/a) http://endless-tw.net
## 
n##############################################################
#
#-----[ OPEN ]------------------------------------------------
#
language/lang_chinese_traditional_taiwan/lang_admin.php 

#
#-----[ FIND ]------------------------------------------------
#
?>

#
#-----[ BEFORE, ADD ]-----------------------------------------
#

// Start add - Fully integrated shoutbox MOD
$lang['Prune_shouts'] = '自動刪除線上留言'; 
$lang['Prune_shouts_explain'] = '鍵入保留線上留言的天數, 如果設定為 0, 自動刪除的功能是關閉的';
// End add - Fully integrated shoutbox MOD

#
#-----[ OPEN ]------------------------------------------------
#
language/lang_chinese_traditional_taiwan/lang_main.php

#
#-----[ FIND ]------------------------------------------------
#
?>

#
#-----[ BEFORE, ADD ]-----------------------------------------
#

// Start add - Fully integrated shoutbox MOD
$lang['Shoutbox'] = '論壇及時留言版'; 
$lang['Shoutbox_date'] = ' d m Y h:i:s'; 
$lang['Shout_censor'] = '<font color=red>您的留言已被刪除!</font>'; 
$lang['Shout_refresh'] = '更新'; 
$lang['Shout_text'] = '您的留言'; 
$lang['Viewing_Shoutbox']= '觀看論壇及時留言版'; 
$lang['Censor'] ='消音';
// End add - Fully integrated shoutbox MOD

#
#-----[ SAVE/CLOSE ALL FILES ]--------------------------------
#
# EoM

補充說明

發表於 : 2006-11-10 , 8:16
懸壺子
補充說明

SOURCE: http://phpbb-tw.net/phpbb/viewtopic.php?p=160345#160345


天霜
版面管理員



註冊時間: 2003-04-15
文章: 995
來自: Starry Hometown
發表於: 2004-09-09 12:16 文章主題:

--------------------------------------------------------------------------------

於 index 首頁的論壇留言板的時間格式改為對應論壇的時間格式

#
#-----[ OPEN 打開 ]------------------------------------------------
#
代碼:
shoutbox_view.php


#
#-----[ FIND 尋找 ]------------------------------------------------ \r
#
代碼:
'TIME' => create_date($lang['Shoutbox_date'], $shout_row['shout_session_time'], $board_config['board_timezone']),


#
#-----[ REPLACE WITH 替換 ]----------------------------------------
#
代碼:
'TIME' => create_date($board_config['default_dateformat'], $shout_row['shout_session_time'], $board_config['board_timezone']),


#
#-----[ SAVE/CLOSE ALL FILES 儲存/關閉所有檔案 ]-------------------
#
# EoM 外掛修正結束




==========
SOURCE: http://phpbb-tw.net/phpbb/viewtopic.php?p=160346#160346


天霜
版面管理員



註冊時間: 2003-04-15
文章: 995
來自: Starry Hometown
發表於: 2004-09-09 12:16 文章主題:

--------------------------------------------------------------------------------

修正在 index 頁面的留言板沒顯示表情符號連結的問題:
#
#-----[ OPEN 打開 ]------------------------------------------------
#
代碼:
shoutbox.php


#
#-----[ FIND 尋找 ]------------------------------------------------
#
代碼:
'L_SMILIES' => $lang['Smilies'],


#
#-----[ REPLACE WITH 替換 ]----------------------------------------
#
代碼:
'L_SMILIES' => $lang['Emoticons'],


#
#-----[ SAVE/CLOSE ALL FILES 儲存/關閉所有檔案 ]-------------------
#
# EoM 外掛修正結束

###############################################################################
SOURCE: http://phpbb-tw.net/phpbb/viewtopic.php?p=199460#199460


sexm7
星球普通子民



註冊時間: 2003-07-09
文章: 3

發表於: 2005-06-21 12:24 文章主題: [問題] shoutbox1.1.5em如何修改成訪客也可留言

--------------------------------------------------------------------------------

問題外掛:(shoutbox1.1.5)
參考連結:(無)
使用版本:(例:phpBB 2.0.13)
網站位置:(無)
狀況描述:

(這裡描述您遇到的狀況)
shoutbox1.1.5em如何修改成訪客也可留言

已搜尋論壇,未發現相關討論





回頂端


~倉木麻衣~
竹貓忠實會員



註冊時間: 2004-03-21
文章: 432

發表於: 2005-06-23 04:36 文章主題:

--------------------------------------------------------------------------------

把shoutbox.php裡的
代碼:
$is_auth['auth_post'] = 0;


改成這樣即可
代碼:
$is_auth['auth_post'] = 1;

###############################################################################

Re: [外掛] Fully integrated shoutbox 1.1.6

發表於 : 2006-11-10 , 8:19
懸壺子
字型大小
http://starryhometown.net/forum/viewtop ... 7&start=30

代碼: 選擇全部

原文由:Vergil
<span class="gensmall"> 
   {shoutrow.TIME}<br /> r
   <b>{shoutrow.USERNAME}:</b><br /> 
   {shoutrow.SHOUT}<br/></span> 

字型的大小是由class來控制
你可以開啟subSilver.css
尋找gensmall這個字串

gensmall這個字串 :->: 岐黃採用postbody這個字串

Re: [外掛] Fully integrated shoutbox 1.1.6

發表於 : 2006-11-10 , 8:25
懸壺子

代碼: 選擇全部

 打開心霜給的  shoutbox_view_body.tpl 

代碼: 選擇全部

content="120;url={U_SHOUTBOX_VIEW}?auto_refresh=1"
120是自動更新的時間間隔

1則是 是否自動更新留言板內容

更改聊天室高度(加高)

發表於 : 2006-11-11 , 10:02
懸壺子
更改聊天室高度(加高)

shoutbox_body.tpl

代碼: 選擇全部

 <iframe src="{U_SHOUTBOX_VIEW}" align="left" width="100%" height="145" frameborder="0" marginheight="0" marginwidth="0" allowtransparency="true"> 
改為

代碼: 選擇全部

<iframe src="{U_SHOUTBOX_VIEW}" align="left" width="100%" height="245" frameborder="0" marginheight="0" marginwidth="0" allowtransparency="true"> 
index_body.tpl

代碼: 選擇全部

 <iframe src="{U_SHOUTBOX}" scrolling="NO" width="100%" height="180" frameborder="0" marginheight="0" marginwidth="0" allowtransparency="true"></iframe>   
改為
<iframe src="{U_SHOUTBOX}" scrolling="NO" width="100%" height="280" frameborder="0" marginheight="0" marginwidth="0" allowtransparency="true"></iframe>

發表於 : 2006-12-11 , 23:46
懸壺子
shoutbox_db_update.php

代碼: 選擇全部

<?php
#########################################################
## SQL commands to phpBB2
## Author: Niels Chr. R鷣
## Nickname: Niels Chr. Denmark
## Web: http://mods.db9.dk
## Email: ncr@db9.dk
##
## Ver 1.0.9
##
## phpBB2 database update script for mods
## this file is intended to use with phpBB2, when installing mods
## after so you may delete this file, but only admin can use so it really doesen't matter
## The script will look what prefix you are using, and use the existing DB defined by congig.php
## The execution of this script's included SQL is harmless, so you can run it as meny times you like
## note, though that the users last visit, will be set back to his/her last login, 
## but that is a minor cosmetic isue, that will correct it self next time the use  logs in
##r
## the following example are from my mods, and you can add some self, for other mods if you like
## you will after execution get a list over those commands that are run with succes and those with warnings !
## delete the sample lines if you are using it only for other mods
##
#########################################################

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'includes/functions_selects.'.$phpEx);
define('SHOUTBOX_TABLE', $table_prefix.'shout');

###################################################################################################
##
## put the SQL commands below here, the SQL commands listed below are only exampels, substitude them with the one you need ##
##
###################################################################################################
$sql=array(

"CREATE TABLE ".SHOUTBOX_TABLE." (
shout_id MEDIUMINT(8) UNSIGNED NOT NULL auto_increment, 
shout_username VARCHAR(25) NOT NULL, 
shout_user_id MEDIUMINT(8) NOT NULL, 
shout_group_id MEDIUMINT(8) NOT NULL,
shout_session_time INT(11) NOT NULL, 
shout_ip CHAR(8) NOT NULL, 
shout_text TEXT NOT NULL, 
shout_active MEDIUMINT(8) NOT NULL, 
enable_bbcode TINYINT (1) NOT NULL,
enable_html TINYINT (1) NOT NULL,
enable_smilies TINYINT (1) NOT NULL,
enable_sig TINYINT (1) NOT NULL,
shout_bbcode_uid VARCHAR(10) NOT NULL,
INDEX (shout_id)
)",
"INSERT INTO ".CONFIG_TABLE." (config_name, config_value) VALUES ('prune_shouts', '0')",
); 

$mods = array ( 
'fully integrated shoutbox','fully integrated shoutbox','fully integrated shoutbox'
);


############################################### Do not change anything below this line #######################################

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//

if ($userdata['user_level']!=ADMIN)
      message_die(GENERAL_ERROR, $lang['Not_Authorised']); 


$n=0;
$message="<b>This list is a result of the SQL queries needed for this Mod</b><br/><br/>";
while($sql[$n])
{
	$message .= ($mods[$n-1] != $mods[$n]) ? '<p><b><font size=3>'.$mods[$n].'</font></b><br/>' : '';
	if(!$result = $db->sql_query($sql[$n])) 
	$message .= '<b><font color=#FF0000>[Already added]</font></b> line: '.($n+1).' , '.$sql[$n].'<br />';
	else $message .='<b><font color=#0000fF>[Added/Updated]</font></b> line: '.($n+1).' , '.$sql[$n].'<br />';
	$n++;
}
 message_die(GENERAL_MESSAGE, $message); 
?>
執行此檔 shoutbox_db_update.php 前,要先登入管理員帳號
在瀏覽器執行後刪除

執行後出現


代碼: 選擇全部

This list is a result of the SQL queries needed for this Mod

fully integrated shoutbox
[Added/Updated] line: 1 , CREATE TABLE phpbb2_shout ( shout_id MEDIUMINT(8) UNSIGNED NOT NULL auto_increment, shout_username VARCHAR(25) NOT NULL, shout_user_id MEDIUMINT(8) NOT NULL, shout_group_id MEDIUMINT(8) NOT NULL, shout_session_time INT(11) NOT NULL, shout_ip CHAR(8) NOT NULL, shout_text TEXT NOT NULL, shout_active MEDIUMINT(8) NOT NULL, enable_bbcode TINYINT (1) NOT NULL, enable_html TINYINT (1) NOT NULL, enable_smilies TINYINT (1) NOT NULL, enable_sig TINYINT (1) NOT NULL, shout_bbcode_uid VARCHAR(10) NOT NULL, INDEX (shout_id) )
[Added/Updated] line: 2 , INSERT INTO phpbb2_config (config_name, config_value) VALUES ('prune_shouts', '0')