[問題]論壇銀行貸款及修改問題

[文]

自爆-

[文]

問題外掛：論壇銀行
參考連結：http://phpbb-tw.net/phpbb/viewtopic.php?t=19509
使用版本：2.0.6
網站位置：www.gamehack.idv.tw

狀況描述：

重新簡單敘述一次，我不要貸款功能！我怎麼做(刪除)會比較好！報告完畢...

再補充一個問題！就是我進BANK會出現語法錯誤...

行 2
字元 1
錯誤 語法錯誤
程式碼 0
URL bank.php

[文]

沒人理我那我就先講一下我目前的作法吧！

先將phpbb_users的user_loan欄位刪除\r
phpbb_config的bankloanfees&bankpayoutloantime&loanmaxbankpayloanset欄位刪除\r
刪除loan_popup.php
刪除bank.php中的

代碼: 選擇全部

	if(((int)$board_config['bankpayoutloantime']+(60*60*24*(int)$board_config['bankpayloanset']))<time())
	{
		$userdata["user_loan"]=(int)($userdata["user_loan"]+($userdata["user_loan"]*(float)$board_config['bankloanfees']));
		$sql="update ". USERS_TABLE." set user_loan=user_loan+(user_loan*".$board_config['bankloanfees'].") ";
		if ( !($db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, '貸款利息無法存入!'); }
		$sql="update ". CONFIG_TABLE." set config_value = '".time()."' where config_name='bankpayoutloantime'";
		if ( !($db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, '增加貸款利息時間無法設定!'); }
		$board_config['bankpayoutloantime']=time();

	}

代碼: 選擇全部

	break;
	case 'loan':
		loan($money);

代碼: 選擇全部

		'USER_LOAN'=>$userdata["user_loan"],

代碼: 選擇全部

		'LOAN_MAX'=>$board_config['loanmax'],

代碼: 選擇全部

		'LOAN_INTEREST'=>((float)$board_config['bankloanfees']*100).'%',

代碼: 選擇全部

		'LOAN_PAYTIME'=>date('Y-m-d H:i:s',(int)$board_config['bankpayoutloantime']))

代碼: 選擇全部

	if ($userdata['user_loan'] > 0) { message_die(GENERAL_MESSAGE, '你以已用貸款功能，所以銀行禁止你存款權限!'); }

代碼: 選擇全部

//########## loan begin #############
function loan($money)
{
	global $db,$board_config,$userdata,$template,$phpEx;
	$template->set_filenames(array( 'body' => 'bank_body_message.tpl'));
	if ( !$userdata['session_logged_in'] )
	{
		$redirect = "bank.$phpEx&act=loan&money=$money";
		$redirect .= ( isset($user_id) ) ? '&user_id=' . $user_id : '';
		header('Location: ' . append_sid("login.$phpEx?redirect=$redirect", true));
	}

	$money = round($money);
	if ((!is_numeric($money)) || ($money < 0) || empty($money)) { message_die(GENERAL_MESSAGE, '請輸入正確的數字!'); }
	//if ($money > $userdata['user_money']) { message_die(GENERAL_MESSAGE, '金額不足!'); }
	if ($money > $board_config['loanmax']) { message_die(GENERAL_MESSAGE, '不可超貸!'); }
	$sql = "update " . USERS_TABLE . " set user_money=user_money + ".$money." , user_loan=user_loan + ".$money." where user_id=".$userdata['user_id']."";
	if ( !($db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, '無法更新金額資料!'); }
	if ($userdata['user_loan'] > $board_config['loanmax']) { message_die(GENERAL_MESSAGE, '不可借貸!'); }
	$banklocation = ' -> <a href="'.append_sid("bank.".$phpEx).'" class="nav">'.$board_config['bankname'].'</a>';
	$title = '借貸';
	$template->assign_vars(array(
		'BANK_MESSAGE' => ' 借貸成功 ',
		'BANKLOCATION' => $banklocation,
		'L_LOAN_TITLE' => $title)
	);
	$template->assign_block_vars('', array());
}

代碼: 選擇全部

//########## withdraw begin #############
function repays($money)
{
	global $db,$board_config,$userdata,$template,$phpEx;
	$template->set_filenames(array( 'body' => 'bank_body_message.tpl'));
	if ( !$userdata['session_logged_in'] )
	{
		$redirect = "bank.$phpEx&act=repays&money=$money";
		$redirect .= ( isset($user_id) ) ? '&user_id=' . $user_id : '';
		header('Location: ' . append_sid("login.$phpEx?redirect=$redirect", true));
	}
	$money = round($money);
	if ((!is_numeric($money)) || ($money < 0) || ($userdata['user_loan'] == 0) || empty($money)) { message_die(GENERAL_MESSAGE, '請輸入正確的數字!'); }
	if($money > $userdata['user_loan'])
	{
	$sql = "update " . USERS_TABLE . " set user_money=user_money - ".$userdata['user_loan']." , user_loan=user_loan - ".$userdata['user_loan']." where user_id=".$userdata['user_id']."";
	}
	else
	{
	$sql = "update " . USERS_TABLE . " set user_money=user_money - ".$money." , user_loan=user_loan - ".$money." where user_id=".$userdata['user_id']."";
	}
	if ( !($db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, '無法更新金額資料!'); }
	$banklocation = ' -> <a href="'.append_sid("bank.".$phpEx).'" class="nav">'.$board_config['bankname'].'</a>';
	$title = '償還';
	$template->assign_vars(array(
		'BANK_MESSAGE' => ' 償還成功 ',
		'BANKLOCATION' => $banklocation,
		'L_REPAYS_TITLE' => $title)
	);
	$template->assign_block_vars('', array());
}

代碼: 選擇全部

	if ($userdata['user_loan'] > 0) { message_die(GENERAL_MESSAGE, '你以已用貸款功能，所以銀行禁止你轉帳權限!'); }

刪除admin_bank.php中的

代碼: 選擇全部

	$sql[] = "select config_value from " . CONFIG_TABLE . " where config_name='bankloanfees'";
	$sql[] = "select config_value from " . CONFIG_TABLE . " where config_name='bankpayoutloantime'";
	$sql[] = "select config_value from " . CONFIG_TABLE . " where config_name='bankpayloanset'";
	$sql[] = "select config_value from " . CONFIG_TABLE . " where config_name='loanmax'";

代碼: 選擇全部

	<tr><td class="row2"><span class="gensmall">貸款利率 </span></td><td class="row2"><input type="text" name="fees_loan" size="5" value="'.$bankinfo[4].'" maxlength="6"></td></tr>
	<tr><td class="row2"><span class="gensmall">貸款利息結算週期 </span></td><td class="row2"><input type="text" name="payset_loan" size="5" value="'.$bankinfo[6].'" maxlength="3"></td></tr>
	<tr><td class="row2"><span class="gensmall">貸款利息最後一次結算時間</span></td><td class="row2">'.date('Y-m-d H:i:s',$bankinfo[5]).' </td></tr>
	<tr><td class="row2"><span class="gensmall">貸款最高上限 </span></td><td class="row2"><input type="text" name="loanmax" size="8" value="'.$bankinfo[7].'"></td></tr>

代碼: 選擇全部

	if (isset($HTTP_POST_VARS['fees_loan'])) { $usql[] = "update ". CONFIG_TABLE . " set config_value='".$HTTP_POST_VARS['fees_loan']."' where config_name='bankloanfees'"; }
	if (isset($HTTP_POST_VARS['payset_loan'])) { $usql[] = "update ". CONFIG_TABLE . " set config_value='".$HTTP_POST_VARS['payset_loan']."' where config_name='bankpayloanset'"; }
	if (isset($HTTP_POST_VARS['loanmax'])) { $usql[] = "update ". CONFIG_TABLE . " set config_value='".$HTTP_POST_VARS['loanmax']."' where config_name='loanmax'"; }

再來我找到會出現錯誤訊息的地方就是bank_body.tpl&bank_body_message.tpl中的
<script language="JavaScript" src="face_ctb_js.js"></script>
因為檔案內沒夾帶這個檔案！我不知道這個的作用是？不管它就刪除了！

[atthis]

不要貸款的功能就裝舊版的銀行就好了
http://phpbb-tw.net/phpbb/viewtopic.php?t=16472

Demo: http://chianglab.bio.ncku.edu.tw/phpBB2/bank.php\r
id: guest passwd: guest

以前裝的，現在都用rpg 的bank ，不過也懶得拆只有把連結拿掉而已