$query = "DELETE FROM character_inventory WHERE item='" . $item_guid . "'";
$query2 = "DELETE FROM item_instance WHERE guid='" . $item_guid . "';";
} else {
$query = "SELECT item FROM character_inventory\r\n LEFT JOIN item_instance ON character_inventory.item=item_instance.guid\r\n WHERE character_inventory.guid='" . $cid . "' AND itemEntry='" . $item . "' AND bag='" . $bag . "' AND slot='" . $slot . "'";
$result = $sql["char"]->query($query);
$result = $sql["char"]->fetch_assoc($result);
$item_guid = $result["item"];
$query = "DELETE FROM character_inventory WHERE item='" . $item_guid . "'";
$query2 = "DELETE FROM item_instance WHERE guid='" . $item_guid . "';";
}
$result = $sql["char"]->query($query);
if (isset($query2)) {
$result = $sql["char"]->query($query2);
}
redirect("char_inv.php?id=" . $cid . "&mode=" . $_GET["mode"]);
}
//#############################################################################
// MAIN
//#############################################################################
$action = isset($_GET["action"]) ? $_GET["action"] : NULL;
$output .= '
<div class="bubble">';
if ($action == "delete_item") {
delete_item();
} elseif ($action == "dodelete_item") {
dodelete_item();
} else {
char_inv();
}
unset($action_permission);
require_once "footer.php";
<br />';
require_once 'core/char/char_footer.php';
$output .= '
<br />
</center>
<!-- end of char_inv.php -->';
} else {
error($lang_char['no_permission']);
}
} else {
error($lang_char['no_char_found']);
}
}
//#############################################################################
// MAIN
//#############################################################################
// action variable reserved for future use
//$action = (isset($_GET['action'])) ? $_GET['action'] : NULL;
// load language
$lang_char = lang_char();
$output .= '
<div class="top">
<h1>' . $lang_char['character'] . '</h1>
</div>';
// we getting links to realm database and character database left behind by header
// header does not need them anymore, might as well reuse the link
char_inv($sqlr, $sqlc);
//unset($action);
unset($action_permission);
unset($lang_char);
require_once 'footer.php';