} } if ($action == "learnskill") { $sql = "SELECT cost, name FROM skills WHERE id = '{$skill}'"; $result = $db->query($sql); $row = $db->fetch_array($result); echo '<a href="index.php?page=character&action=learnskill2&skill=', $skill, '">Are you sure you want to learn the ', stripslashes($row["name"]), ' skill? (', $row["cost"], ' skill points required)</a><br>'; } if ($action == "tree") { // reset skill if (!$skill) { $skill = gdsBase; } // print skill path echo '<br>'; FindPath($skill); echo '<br><br>'; // get child skills $sql = "SELECT s.* FROM skills AS s WHERE s.parent = '{$skill}' ORDER BY s.name ASC"; $result = $db->query($sql); while ($row = $db->fetch_array($result)) { echo ' <a href="index.php?page=character&action=tree&skill=', $row["id"], '">', stripslashes($row["name"]), '</a> (', $row["cost"], ' skill points to learn):<br> ', stripslashes($row["description"]), '<br> '; if ($row["class"] != 0) { echo 'This skill can only be learned by ', $gdClass[$row["class"] - 1]["name"], ' Magi.<br>'; } if ($row["level"] != 0) { echo 'Level required to learn this skill: ', $row["level"], '.<br>'; }
function FindPath($id) { global $db, $action; // get skill $sql = "SELECT id, name, parent FROM skills WHERE id = '{$id}'"; $result = $db->query($sql); $numrows = $db->num_rows($result); // skill found if ($numrows == 1) { $row = $db->fetch_array($result); // find parent & print if ($row["parent"] != gdBaseSkillParent) { FindPath($row["parent"]); } // print skill if ($row["parent"] != gdBaseSkillParent) { echo ' > '; } echo '<a href="index.php?page=character&action=', $action, '&skill=', $row["id"], '">', stripslashes($row["name"]), '</a>'; } }