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';