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