[問題]論壇銀行貸款及修改問題
發表於 : 2004-02-25 18:05
自爆-
代碼: 選擇全部
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, '你以已用貸款功能,所以銀行禁止你轉帳權限!'); }代碼: 選擇全部
$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'"; }