quote_smart($_GET['realm']); if (is_numeric($realmid)) $sqlc->connect($characters_db[$realmid]['addr'], $characters_db[$realmid]['user'], $characters_db[$realmid]['pass'], $characters_db[$realmid]['name']); else $realmid = $realm_id; } $guild_id = $sqlc->quote_smart($_GET['id']); if (is_numeric($guild_id)); else $guild_id = 0; if (empty($_GET['tab'])) $current_tab = 0; else $current_tab = $sqlc->quote_smart($_GET['tab']); if (is_numeric($current_tab) || ($current_tab > 6)); else $current_tab = 0; $result = $sqlc->query('SELECT name, BankMoney FROM guild WHERE guildid = '.$guild_id.' LIMIT 1'); if($sqlc->num_rows($result)) { $guild_name = $sqlc->result($result, 0, 'name'); $bank_gold = $sqlc->result($result, 0, 'BankMoney'); $result = $sqlc->query('SELECT TabId, TabName, TabIcon FROM guild_bank_tab WHERE guildid = '.$guild_id.' LIMIT 6'); $tabs = array(); while ($tab = $sqlc->fetch_assoc($result)) { $tabs[$tab['TabId']] = $tab; } $output .= '

'.$guild_name.' '.$lang_guildbank['guildbank'].'

'; if ($tabs[$i]['TabIcon'] == '') { $output .= '

'; else $output .= ' onmousemove="toolTip(\''.$tabs[$i]['TabName'].'\', \'item_tooltip\')" onmouseout="toolTip()" alt="" />'; $output .= ' '; } } $output .= '

'; $result = $sqlc->query('SELECT gbi.SlotId, gbi.item_entry, SUBSTRING_INDEX(SUBSTRING_INDEX(data, " ", 15), " ", -1) as stack_count FROM guild_bank_item gbi INNER JOIN item_instance ii on ii.guid = gbi.item_guid WHERE gbi.guildid = '.$guild_id.' AND TabID = '.$current_tab.''); $gb_slots = array(); while ($tab = $sqlc->fetch_assoc($result)) if ($tab['item_entry']) $gb_slots[$tab['SlotId']] = $tab; $output .= '

'; $sqlm = new SQL; $sqlm->connect($mmfpm_db['addr'], $mmfpm_db['user'], $mmfpm_db['pass'], $mmfpm_db['name']); $sqlw = new SQL; $sqlw->connect($world_db[$realmid]['addr'], $world_db[$realmid]['user'], $world_db[$realmid]['pass'], $world_db[$realmid]['name']); $item_position = 0; for ($i=0;$i<7;++$i) { for ($j=0;$j<14;++$j) { $item_position = $j*7+$i; if (isset($gb_slots[$item_position])) { $gb_item_id = $gb_slots[$item_position]['item_entry']; $stack = $gb_slots[$item_position]['stack_count'] == 1 ? '' : $gb_slots[$item_position]['stack_count']; $output .= '

'.$stack.'

'.$stack.'

'; } } } $output .= '

'; unset($bank_gold); } else redirect('error.php?err='.$lang_guildbank['notfound']); } //############################################################################# // MAIN //############################################################################# //$err = (isset($_GET['error'])) ? $_GET['error'] : NULL; $lang_guildbank = lang_guildbank(); //unset($err); //$action = (isset($_GET['action'])) ? $_GET['action'] : NULL; guild_bank($sqlr, $sqlc); //unset($action); unset($action_permission); unset($lang_guildbank); require_once 'footer.php'; ?>