$message = sprintf($lang['Adr_report_pm_msg2'], $userdata['username']);
adr_send_pm($member_id, $subject, $message);
adr_previous(Adr_vault_cheater, 'adr_vault', '');
}
if ($vault['loan_sum'] != 0) {
adr_previous(Adr_vault_loan_no_double, adr_vault, '');
}
if ($userdata['user_posts'] < $vault_general['loan_requirements'] || $vault['loan_sum'] != 0) {
$message = $lang['Adr_vault_loan_no_explain'] . $vault_general['loan_requirements'] . $lang['Posts'];
$message .= '<br /><br />' . sprintf($lang['Adr_return'], "<a href=\"" . append_sid("adr_vault.{$phpEx}") . "\">", "</a>");
message_die(GENERAL_MESSAGE, $message);
}
if ($loan_sum > $vault_general['loan_max_sum'] || $loan_sum < 0) {
adr_previous(Adr_vault_loan_no_such, adr_vault, '');
}
add_reward($user_id, $loan_sum);
$sql = "UPDATE " . ADR_VAULT_USERS_TABLE . "\n\t\tSET loan_sum = {$loan_sum} ,\n\t\tloan_time = " . time() . "\n\t\tWHERE owner_id = {$user_id}";
if (!$db->sql_query($sql)) {
message_die(GENERAL_ERROR, 'Could not obtain accounts information', "", __LINE__, __FILE__, $sql);
}
$message = $lang['Adr_vault_loan_ok'] . $loan_sum . ' ' . get_reward_name();
$message .= '<br /><br />' . sprintf($lang['Adr_return'], "<a href=\"" . append_sid("adr_vault.{$phpEx}") . "\">", "</a>");
message_die(GENERAL_MESSAGE, $message);
}
if ($loan_back) {
$pay_off = $vault['loan_sum'] * (1 + $vault_general['loan_interests'] / 100);
if ($pay_off > $userdata['user_points']) {
adr_previous(Adr_vault_loan_lack_points, adr_vault, '');
}
subtract_reward($user_id, $pay_off);
$sql = "UPDATE " . ADR_VAULT_USERS_TABLE . "\n\t\tSET loan_sum = 0,\n\t\tloan_time = 0\n\t\tWHERE owner_id = {$user_id}";
$reward = floor(($current_level - $opponent_level) * $adr_general['pvp_base_reward_modifier'] / 100);
}
// Write the result in the db
if ($user_id == $battle_pvp['battle_challenger_id']) {
$sql = " UPDATE " . ADR_BATTLE_PVP_TABLE . "\n SET battle_result = 2\n WHERE battle_id = {$battle_id}\n AND battle_result = 3 ";
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not update battle list', '', __LINE__, __FILE__, $sql);
}
} else {
$sql = " UPDATE " . ADR_BATTLE_PVP_TABLE . "\n SET battle_result = 1\n WHERE battle_id = {$battle_id}\n AND battle_result = 3 ";
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not update battle list', '', __LINE__, __FILE__, $sql);
}
}
// Give the rewards
add_reward($dest, $reward);
$sql = " UPDATE " . ADR_CHARACTERS_TABLE . "\n\t\t\t\t\tSET character_xp = character_xp + {$exp} ,\n\t\t\t\t\t\tcharacter_victories_pvp = (character_victories_pvp + 1)\n\t\t\t\t\tWHERE character_id = {$dest} ";
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not update character', '', __LINE__, __FILE__, $sql);
}
$sql = " UPDATE " . ADR_CHARACTERS_TABLE . "\n\t\t\t\t\tSET character_defeats_pvp = (character_defeats_pvp + 1)\n\t\t\t\t\tWHERE character_id = {$user_id} ";
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not update character', '', __LINE__, __FILE__, $sql);
}
if ($opponent_pm_me) {
$subject = $lang['Adr_pvp_won'];
$message = sprintf($lang['Adr_pvp_won_by'], $current_dmg, $current_infos['character_name'], $exp, $reward, get_reward_name());
adr_send_pm($dest, $subject, $message);
}
$message = sprintf($lang['Adr_battle_pvp_lost'], $current_dmg);
$message .= '<br /><br />' . sprintf($lang['Adr_battle_temple'], "<a href=\"" . 'adr_temple.' . $phpEx . "\">", "</a>");
}
//皇冠团队奖
$get_member_list = 'select `account` from ' . $db->table('member') . ' where `level_id`=6 and `id` in (' . $path . '0) order by find_in_set(`id`,\'' . $path . '0\')';
$member_list = $db->fetchAll($get_member_list);
while ($account = array_pop($member_list)) {
$account = $account['account'];
$check_total_number = 'select sum(`number`) from ' . $db->table('achievement') . ' where `account`=\'' . $account . '\'';
$_total_number = $db->fetchOne($check_total_number);
if ($_total_number > 5000) {
if ($_total_number - $total_number > 5000) {
$reward = $total_number * 10;
add_reward($account, $reward, 0, '', '团队奖');
} else {
$total_number = $_total_number - 5000 + $total_number;
$reward = $total_number * 10;
add_reward($account, $reward, 0, '', '团队奖');
}
}
}
//结算结束
$response['msg'] = '报单成功';
$response['content'] = <<<HTML
<p>订单提交成功。</p>
<p>订单编号:%s</p>
HTML;
$response['content'] = sprintf($response['content'], $order_sn);
$db->commit();
$response['error'] = 0;
} else {
$response['msg'] = '提交订单失败，请稍后再试';
$db->rollback();
while ($U2row = $db->sql_fetchrow($U2result)) {
$approve_name = $U2row['character_name'];
}
$paid_fee = $newfees[$xy];
$this_user = $newapprove[$xy];
$newfees[$xy] = '';
$newapprove[$xy] = '';
for ($c = 0; $c < count($newfees); $c++) {
if ($newfees[$c] != '' || $newapprove[$c] != '') {
$newfees[$c] = 'ß' . $newfees[$c] . 'Þ';
$newapprove[$c] = 'ß' . $newapprove[$c] . 'Þ';
}
}
$upd_approve = implode("", $newapprove);
$upd_fees = implode("", $newfees);
add_reward($this_user, $paid_fee);
// $sql10 = "UPDATE ". USERS_TABLE ."
// SET user_points = user_points + '".$paid_fee."'
// WHERE user_id = '".$this_user."' ";
// if ( !$db->sql_query($sql10) ) { message_die(GENERAL_ERROR, 'Error updating clan info', '', __LINE__, __FILE__, $sql10); }
$sql9 = "UPDATE " . ADR_CLANS_TABLE . "\r\n\t\t\t\t\t\t\t\tSET\tapprovelist = '" . $upd_approve . "',\r\n\t\t\t\t\t\t\t\tapprove_fee = '" . $upd_fees . "' \r\n\t\t\t\t\t\t\t\tWHERE id = '" . intval($_GET['clan']) . "' ";
if (!$db->sql_query($sql9)) {
message_die(GENERAL_ERROR, 'Error updating clan info', '', __LINE__, __FILE__, $sql9);
}
$text = sprintf($lang['clans_clp_members_approve_disapprove'], '<b>' . $approve_name . '</b>');
$text .= '<br />' . sprintf($lang['clans_clp_members_approve_points_back'], '<b>' . $paid_fee, $points_name . '</b>', '<b>' . $approve_name . '</b>');
clans_sendpm($row2['leader'], $_GET['member'], $lang['clans_pm_disapproved_s'], sprintf($lang['clans_pm_disapproved_t'], '<b>' . $row2['name'] . '</b>', '<b>' . $paid_fee, $points_name . '</b>'), $lang['clans_pm_little_note']);
message_die(GENERAL_MESSAGE, $text . '<br /><br />' . sprintf($lang['clans_click_here'], '<a href="' . $file . '?action=clp&t=members&clan=' . $_GET['clan'] . '">', '</a>'));
}
}
message_die(GENERAL_MESSAGE, $lang['clans_clp_members_approve_err_not_on_list'] . '<br /><br />' . sprintf($lang['clans_click_here'], '<a href="' . $file . '?action=clp&t=members&clan=' . $_GET['clan'] . '">', '</a>'));
// The monster is dead , give money and xp to the users , then update the database
// Get the experience earned
$exp = rand($adr_general['battle_base_exp_min'], $adr_general['battle_base_exp_max']);
if ($monster['monster_level'] - $challenger['character_level'] > 1) {
$exp = floor(($monster['monster_level'] - $challenger['character_level']) * $adr_general['battle_base_exp_modifier'] / 100);
}
// Get the money earned
$reward = rand($adr_general['battle_base_reward_min'], $adr_general['battle_base_reward_max']);
if ($monster['monster_level'] - $challenger['character_level'] > 1) {
$reward = floor(($monster['monster_level'] - $challenger['character_level']) * $adr_general['battle_base_reward_modifier'] / 100);
}
$sql = " UPDATE " . ADR_BATTLE_LIST_TABLE . " \n\t\t\tSET battle_result = 1 ,\n\t\t\t\tbattle_opponent_hp = 0,\n\t\t\t\tbattle_finish = " . time() . ",\n\t\t\t\tbattle_text = ''\n\t\t\tWHERE battle_challenger_id = {$user_id}\n\t\t\tAND battle_result = 0\n\t\t\tAND battle_type = 1 ";
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not update battle list', '', __LINE__, __FILE__, $sql);
}
add_reward($user_id, $reward);
// If $challenger['character_hp'] is < '1' then update sql to hp = 1
$sql_update_hp = $challenger['character_hp'] < '1' ? 'character_hp = 1' : '';
$sql = " UPDATE " . ADR_CHARACTERS_TABLE . " \n\t\t\tSET character_xp = character_xp + {$exp} ,\n\t\t\t\tcharacter_victories = character_victories + 1 ,\n\t\t\t\t{$sql_update_hp}\n\t\t\t\tcharacter_sp = character_sp + '" . $bat['battle_opponent_sp'] . "'\n\t\t\tWHERE character_id = {$user_id} ";
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not update character', '', __LINE__, __FILE__, $sql);
}
// Remove item stolen status
$sql = "UPDATE " . ADR_SHOPS_ITEMS_TABLE . "\n\t\t\tSET item_monster_thief = 0 \n\t\t\tWHERE item_owner_id = {$user_id} ";
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not update stolen item status', '', __LINE__, __FILE__, $sql);
}
// Delete broken items from users inventory
$sql = " DELETE FROM " . ADR_SHOPS_ITEMS_TABLE . "\n\t\t\tWHERE item_duration < 1 \n\t\t\tAND item_owner_id = {$user_id} ";
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not delete broken items', '', __LINE__, __FILE__, $sql);
