function adr_weight_check($user_id)
{
global $db, $lang, $adr_general;
$user_id = intval($user_id);
$sql = "SELECT c.*, r.race_weight, r.race_weight_per_level\r\n\t\tFROM " . ADR_CHARACTERS_TABLE . " c, " . ADR_RACES_TABLE . " r\r\n\t\tWHERE c.character_id= '{$user_id}'\r\n\t\tAND r.race_id = c.character_race";
if (!($result = $db->sql_query($sql))) {
message_die(CRITICAL_ERROR, 'Error Getting Adr Users!');
}
$row = $db->sql_fetchrow($result);
// START weight reqs
$max_weight = adr_weight_stats($row['character_level'], $row['race_weight'], $row['race_weight_per_level'], $row['character_might']);
// Count up characters current weight
$sql = "SELECT SUM(item_weight) AS total FROM " . ADR_SHOPS_ITEMS_TABLE . "\r\n\t\tWHERE item_owner_id = '{$user_id}'\r\n\t\tAND item_in_warehouse = '0'\r\n\t\tAND item_in_shop = '0'";
if (!($result = $db->sql_query($sql))) {
message_die(CRITICAL_ERROR, 'Error Getting Adr Users!');
}
$weight = $db->sql_fetchrow($result);
$current_weight = $weight['total'];
if ($adr_general['weight_enable'] && $current_weight > $max_weight) {
adr_previous(Adr_battle_over_weight, adr_character_inventory, '');
}
// END Weight reqs
}
} else {
$stolen_by = 'n/a';
}
$template->assign_block_vars('main.items.stolen_info', array("L_STOLEN_INFO" => sprintf($lang['Adr_shop_stolen_info'], '<i><b>', '</b>', sprintf($lang['Adr_shop_stolen_by'], $stolen_by), $shop_name, date("D j M 'y", $row['item_stolen_timestamp']), '</i>')));
}
##=== END: Show stolen status
##=== START: Show donated info
if ($row['item_donated_by'] != '') {
$template->assign_block_vars('main.items.donated_info', array("L_DONATED_INFO" => sprintf($lang['Adr_shop_donated_by'], '<i><b>', '</b>', $row['item_donated_by'], date("D j M 'y", $row['item_donated_timestamp']), '</i>')));
}
##=== END: Show donated status
// If viewer is owner then show additional options
if ($user_id == $searchid) {
$template->assign_block_vars("main.items.owner", array());
}
$i++;
} while ($row = $db->sql_fetchrow($result));
}
if ($user_id == $searchid) {
$colspan = 9;
$template->assign_block_vars("main.owner", array());
##== START: Showing weight bar ==##
if ($adr_general['weight_enable'] == '1') {
$adr_user = adr_get_user_infos($user_id);
$adr_user_race = adr_get_race_infos($adr_user['character_race']);
$sql = "SELECT SUM(item_weight) AS total FROM " . ADR_SHOPS_ITEMS_TABLE . "\r\t\t\t\tWHERE item_owner_id = '{$searchid}'\r\t\t\t\tAND item_in_warehouse = '0'\r\t\t\t\tAND item_duration > '0'\r\t\t\t\tAND item_in_shop = '0'";
if (!($result = $db->sql_query($sql))) {
message_die(CRITICAL_ERROR, 'Error Getting Adr Users!');
}
$weight = $db->sql_fetchrow($result);
$max_weight = adr_weight_stats($adr_user['character_level'], $adr_user_race['race_weight'], $adr_user_race['race_weight_per_level'], $adr_user['character_might']);
$template->assign_block_vars('character.limit', array());
}
}
$avatar_img = '';
if ($view_userdata['user_avatar_type'] && $view_userdata['user_allowavatar']) {
switch ($view_userdata['user_avatar_type']) {
case USER_AVATAR_UPLOAD:
$avatar_img = $board_config['allow_avatar_upload'] ? '<img src="' . $board_config['avatar_path'] . '/' . $view_userdata['user_avatar'] . '" alt="" border="0" />' : '';
break;
case USER_AVATAR_REMOTE:
$avatar_img = $board_config['allow_avatar_remote'] ? '<img src="' . $view_userdata['user_avatar'] . '" alt="" border="0" />' : '';
break;
case USER_AVATAR_GALLERY:
$avatar_img = $board_config['allow_avatar_local'] ? '<img src="' . $board_config['avatar_gallery_path'] . '/' . $view_userdata['user_avatar'] . '" alt="" border="0" />' : '';
break;
}
}
$sql = "SELECT c.* , r.race_name , r.race_weight , r.race_weight_per_level , r.race_img , e.element_name , e.element_img , a.alignment_name , a.alignment_img , cl.class_name , cl.class_img , cl.class_update_xp_req\r\t\tFROM " . ADR_CHARACTERS_TABLE . " c , " . ADR_RACES_TABLE . " r , " . ADR_ELEMENTS_TABLE . " e , " . ADR_ALIGNMENTS_TABLE . " a , " . ADR_CLASSES_TABLE . " cl\r\t\tWHERE c.character_id= {$searchid}\r\t\tAND cl.class_id = c.character_class\r\t\tAND r.race_id = c.character_race\r\t\tAND e.element_id = c.character_element\r\t\tAND a.alignment_id = c.character_alignment ";
if (!($result = $db->sql_query($sql))) {
message_die(CRITICAL_ERROR, 'Error Getting Adr Users!');
}
$row = $db->sql_fetchrow($result);
if ($row['character_desc']) {
$template->assign_block_vars('character.bio', array());
}
$class = adr_get_lang($row['class_name']);
$race = adr_get_lang($row['race_name']);
$element = adr_get_lang($row['element_name']);
$alignment = adr_get_lang($row['alignment_name']);
// Work out weight stats
$max_weight = adr_weight_stats($row['character_level'], $row['race_weight'], $row['race_weight_per_level'], $row['character_might']);
