[問題]防止大量註冊程式

[future]

問題外掛：[2.0.4]防止大量註冊程式(Anti Robotic Register Flood)
參考連結：http://phpbb-tw.net/phpbb/viewtopic.php?t=17097
使用版本：phpBB 2.04
網站位置：http://pc178.besa.nchu.edu.tw/classmate/
狀況描述： 修改好了 也能運作 不過出現一個小問題
就是在確認身分檢查的欄 並沒有出現中文或英文的描述 不知怎麼修改\r
請大家幫幫忙想一下 多謝嚕

[salamander]

此mod原先是英文版本\r
如果是中文的話請修改如下:

代碼: 選擇全部

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

# 
#-----[ FIND ]-------------------------------------------- 
# 
// 
// That's all, Folks! 

# 
#-----[ BEFORE, ADD ]------------------------------------- 
# 
// Anti Robotic Registration 
$lang['Wrong_reg_key'] = 'Anti Robotic Register Validation Error'; 
$lang['Validation'] = '註冊身分檢查'; 
$lang['Validation_explain'] = '請輸入您在此相片中所看到的文字並填入空格中...'; 

[future]

阿~真是多謝嚕
偶還以為這是中文版ㄉQQ
小弟偶啥都不懂^^"
是新手唷\r
多謝幫忙嚕^^Y

[pat731]

代碼: 選擇全部

$lang['Wrong_reg_key'] = 'Anti Robotic Register Validation Error'; 

$lang['Wrong_reg_key'] = '您輸入錯誤認証號，請看清楚從新再輸入。'; 

[diegod]

#
#-----[ SQL ]---------------------------------------------
#
CREATE TABLE phpbb_anti_robotic_reg (
session_id char(32) DEFAULT '' NOT NULL,
reg_key char(5) NOT NULL,
timestamp int(11) unsigned NOT NULL,
PRIMARY KEY (session_id));

上面這一段是要在mysql裡面打嗎？
還有我照著打了，他說沒有選擇database

[Mac]

那你叫要先選擇你的 phpBB 的資料庫囉
不然他搞不清楚你要增加的資料表要加在哪裡

~Mac

[william91]

將以下內容儲存成db_update.php, 上傳到伺服器上執行他:

代碼: 選擇全部

<?php
/***************************************************************************
 *                               db_update.php
 *                            -------------------
 *   copyright            : ?003 Freakin' Booty ;-P & Antony Bailey
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

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


if( !$userdata['session_logged_in'] )
{
	$header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: ';
	header($header_location . append_sid('login.'.$phpEx.'?redirect=db_update.'.$phpEx));
	exit;
}

if( $userdata['user_level'] != ADMIN )
{
	message_die(GENERAL_MESSAGE, 'You are not authorised to access this page');
}


$page_title = 'Updating the database';
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

echo '<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">';
echo '<tr><th>Updating the database</th></tr><tr><td><span class="genmed"><ul type="circle">';


$sql = array();
$sql[] = "CREATE TABLE phpbb_anti_robotic_reg ( 
session_id char(32) DEFAULT '' NOT NULL, 
reg_key char(5) NOT NULL, 
timestamp int(11) unsigned NOT NULL, 
PRIMARY KEY (session_id))";

for( $i = 0; $i < count($sql); $i++ )
{
	if( !$result = $db->sql_query ($sql[$i]) )
	{
		$error = $db->sql_error();

		echo '<li>' . $sql[$i] . '<br /> +++ <font color="#FF0000"><b>Error:</b></font> ' . $error['message'] . '</li><br />';
	}
	else
	{
		echo '<li>' . $sql[$i] . '<br /> +++ <font color="#00AA00"><b>Successfull</b></font></li><br />';
	}
}


echo '</ul></span></td></tr><tr><td class="catBottom" height="28"> </td></tr>';

echo '<tr><th>End</th></tr><tr><td><span class="genmed">Installation is now finished. Please be sure to delete this file now.<br />If you have run into any errors, please visit the <a href="http://www.phpbbhacks.com/forums" target="_phpbbhacks">phpBBHacks.com support forums</a> and ask someone for help.</span></td></tr>';
echo '<tr><td class="catBottom" height="28" align="center"><span class="genmed"><a href="' . append_sid("index.$phpEx") . '">Have a nice day</a></span></td></table>';

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

?>