function listrecipeitems($subitem_id)
{
global $conn, $recipe_exist;
$sql = "SELECT \r\n\tetcitem.item_id, \r\n\tl2wh_recitems.q, \r\n\tetcitem.name,\r\n\tetcitem.crystal_type \r\n\tFROM l2wh_recitems\r\n\tINNER JOIN etcitem on l2wh_recitems.item = etcitem.item_id\r\n\tWHERE rid = '{$subitem_id}'";
$result = mysql_query($sql, $conn) or die(mysql_error());
while ($newArray = mysql_fetch_array($result)) {
$sub_item_id = $newArray['item_id'];
$sub_recipe_id = $newArray['id'];
$subitem_quantity = $newArray['q'];
$subitem_name = $newArray['name'];
$subitem_grade = $newArray['crystal_type'];
$x = checkifrecipeexist($sub_item_id);
if ($x == false) {
echo "<li class=\"nochild\"><img src=\"images/items/{$sub_item_id}.png\"> {$subitem_name} [{$subitem_quantity}]</li>";
} else {
$label_id = rand(1, 500);
echo "<li><label for=\"{$label_id}\"><img src=\"images/items/{$sub_item_id}.png\"> {$subitem_name} [{$subitem_quantity}]</label> <input type=\"checkbox\" id=\"{$label_id}\" />";
echo "<ol>";
listrecipeitems($recipe_exist);
echo "</ol>";
echo "</li>";
}
}
}
include 'lib.inc.php';
include 'menu.php';
include 'member.php';
dbconnect();
if (!empty($_GET[recipeid])) {
$sql = "SELECT \r\n\t\tl2wh_recipes.id, \r\n\t\tetcitem.item_id, \r\n\t\tl2wh_recipes.success, \r\n\t\tetcitem.name\r\n\t\tFROM l2wh_recipes\r\n\t\tINNER JOIN etcitem on l2wh_recipes.recid = etcitem.item_id\r\n\t\tWHERE id ='{$_GET['recipeid']}'";
}
if (!empty($_GET[recipeitemid])) {
$sql = "SELECT \r\n\t\tl2wh_recipes.id, \r\n\t\tetcitem.item_id, \r\n\t\tl2wh_recipes.success, \r\n\t\tetcitem.name\r\n\t\tFROM l2wh_recipes\r\n\t\tINNER JOIN etcitem on l2wh_recipes.recid = etcitem.item_id\r\n\t\tWHERE recid ='{$_GET['recipeitemid']}'";
}
$result = mysql_query($sql, $conn) or die(mysql_error());
echo "<table border=\"0\" cellpadding=\"1\" cellspacing=\"1\" width=\"531\">";
echo "<tr>";
while ($newArray = mysql_fetch_array($result)) {
$queryid = $newArray['id'];
$item_id = $newArray['item_id'];
$recipe_success = $newArray['success'];
$item_name = $newArray['name'];
echo "<td><img src=\"images/items/{$item_id}.png\"> {$item_name}</td>";
}
echo "</tr>";
echo "<tr>";
echo "<td>";
echo "<ol class=\"tree\">";
listrecipeitems($queryid);
echo "</ol>";
echo "</td>";
echo "</tr>";
echo "</table>";
dbclose();
include 'footer.inc.php';
