$item_img = '';
}
if ($row['element_img'] != '' && $row['item_element'] != 0) {
$element_img = '<img src="adr/images/elements/' . $row['element_img'] . '">';
} else {
$element_img = $lang['Adr_store_element_none'];
}
$template->assign_vars(array("ROW_CLASS" => $theme['td_class1'], "ROW_CLASS_2" => $theme['td_class2'], "ACTION_SELECT" => $action_select, "ITEM_ID" => $row['item_id'], "ITEM_NAME" => adr_get_lang($row['item_name']), "ITEM_DESC" => adr_get_lang($row['item_desc']), "ITEM_IMG" => $item_img, "ITEM_QUALITY" => $lang[$row['item_quality_lang']], "ITEM_TYPE" => $lang[$row['item_type_lang']], "ITEM_DURA" => $row['item_duration'], "ITEM_DURA_MAX" => $row['item_duration_max'], "ITEM_POWER" => $row['item_power'], "ITEM_PRICE" => $row['item_price'], "ITEM_WEIGHT" => $row['item_weight'], "ITEM_ELEMENT" => $element_img, "ITEM_ADD_POWER" => $row['item_add_power'], "ITEM_MP" => $row['item_mp_use'], "ITEM_POINTS" => $points_name, "SHOP_OWNER_ID" => $store_owner_id, "L_ITEM_INFO" => $lang['Adr_store_item'], "L_ITEM_NAME" => $lang['Adr_store_name'], "L_ITEM_DESC" => $lang['Adr_store_desc'], "L_ITEM_QUALITY" => $lang['Adr_store_quality'], "L_ITEM_POWER" => $lang['Adr_store_power'], "L_ITEM_ADD_POWER" => $lang['Adr_items_dex'], "L_ITEM_MP" => $lang['Adr_items_mp_use'], "L_ITEM_DURA" => $lang['Adr_store_duration'], "L_ITEM_IMG" => $lang['Adr_races_image'], "L_ITEM_PRICE" => $lang['Adr_store_price'], "L_ITEM_TYPE" => $lang['Adr_items_type_use'], "L_ITEM_WEIGHT" => $lang['Adr_store_weight'], "L_ITEM_ELEMENT" => $lang['Adr_store_element'], "L_ACTION" => $lang['Adr_items_action'], "L_SUBMIT" => $lang['Submit']));
break;
case 'sell':
// Define some values
$items = isset($_POST['item_box']) && is_array($_POST['item_box']) ? $_POST['item_box'] : array();
// Deny sale if the user is in a battle
$sql = "SELECT battle_id FROM " . ADR_BATTLE_LIST_TABLE . "\r\t\t\t\tWHERE battle_challenger_id = '{$user_id}'\r\t\t\t\tAND battle_result = '0'\r\t\t\t\tAND battle_type = '1'";
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not query battle list', '', __LINE__, __FILE__, $sql);
}
$bat = $db->sql_fetchrow($result);
if (is_numeric($bat['battle_id'])) {
adr_previous('Adr_battle_no_sell_items', 'adr_character_inventory', '');
}
$item_id_list = '(' . implode(',', $items) . ',0)';
$sql = "SELECT i.* FROM " . ADR_SHOPS_ITEMS_TABLE . " i\r\t\t\t\tWHERE i.item_owner_id = {$user_id}\r\t\t\t\tAND i.item_in_shop = 0\r\t\t\t\tAND i.item_duration > 0 \r\t\t\t\tAND i.item_auth = 0 \r\t\t\t\tAND i.item_no_sell = 0 \r\t\t\t\tAND i.item_id IN {$item_id_list} \r\t\t\t\tORDER BY i.item_name ";
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not obtain items information', "", __LINE__, __FILE__, $sql);
}
$items = $db->sql_fetchrowset($result);
$items_name = '';
while (list(, $item) = @each($items)) {
$item_id = $item['item_id'];
$temp_price = adr_get_item_real_price($item_id, $user_id);
function adr_sell_item($item_id, $user_id)
{
global $db, $adr_general;
// Fix the values
$user_id = intval($user_id);
$item_id = intval($item_id);
$sql = "SELECT character_trading_limit FROM " . ADR_CHARACTERS_TABLE . "\n\t\t\tWHERE character_id = {$user_id} ";
$result = $db->sql_query($sql);
if (!$result) {
message_die(GENERAL_ERROR, 'Could not obtain shops items information', "", __LINE__, __FILE__, $sql);
}
$trading_limit = $db->sql_fetchrow($result);
if ($adr_general['Adr_character_limit_enable'] != 0 && $trading_limit['character_trading_limit'] < 1) {
adr_previous(Adr_trading_limit, adr_shops, '');
} else {
adr_trading_limit($user_id);
}
// Get the item real price
$temp_price = adr_get_item_real_price($item_id, $user_id);
// Apply the trading skill modification
$price = adr_use_skill_trading($user_id, $temp_price, sell);
// Delete the item
$sql = "DELETE FROM " . ADR_SHOPS_ITEMS_TABLE . "\n\t\tWHERE item_owner_id = {$user_id}\n\t\tAND item_id = {$item_id} ";
$result = $db->sql_query($sql);
if (!$result) {
adr_previous(Adr_shop_items_failure_deleted, adr_character_inventory, '');
}
// Give points to the seller - has to be done at the end to prevent treacherous users !
adr_add_points($user_id, $price);
}