<?php
menuitem("News", "news");
// at home
if (is_null($acc[x]) && is_null($acc[y])) {
$time = time();
if ($acc["attacked"]) {
$flash = TRUE;
} else {
$flash = FALSE;
}
menuitem("Battles", "battles", "", $flash);
menuitem("Character", "character", "", gGetSkillPointsLeft() > 0);
menuitem("Creatures", "creatures");
menuitem("Items", "items");
menuitem("Amulets", "amulets");
$workers = $acc["b_workers"] + $acc["c_workers"] + $acc["e_workers"] + $acc["g_workers"];
$workersleft = $acc["level"] * gdWorkersPerLevel - $workers;
menuitem("Spellbook", "spellbook", "", $workersleft > 0 || $acc["castcurse"] != 0);
menuitem("Buildings", "buildings", "", $acc["arcanechamber"] > 99);
menuitem("Defense", "defense");
echo '<table height="3" width="1"><tr><td></td></table>';
menuitem("Your Kingdom", "kingdom");
menuitem("Pub", "kingdom", "&action=pub&type=0");
menuitem("Marketplace", "kingdom", "&action=pub&type=1");
$sql = "SELECT count(*) FROM mails WHERE receiver = '{$acc['id']}' AND receiverstatus = '0'";
$result = $db->query($sql);
$numrows = $db->result($result, 0);
if ($numrows > 0) {
$flash = TRUE;
} else {
echo $array["minutes"], ' minute', $addon, ' until next income (current time: ', date("Y-m-d @ H:i"), ').<br>';
} else {
echo 'Income is being processed right now.<br>';
}
tEnd();
}
if ($action == "skills") {
// reset skill
if (!$skill) {
$skill = gdsBase;
}
// print skill path
echo '<br>';
FindPath($skill);
echo '<br><br>';
$skillsleft = gGetSkillPointsLeft();
if ($skillsleft <= 0) {
echo 'You don\'t have any skill points available.<br><br><br>';
} else {
echo $skillsleft, ' skill points left.<br><br>';
}
// get child skills
$sql = "SELECT s.*, acs.account AS asid FROM (skills AS s) LEFT JOIN accskills AS acs ON acs.account = '{$acc['id']}' AND acs.skill = s.id WHERE s.parent = '{$skill}' AND (s.class = {$acc['class']} OR s.class = 0) AND s.level <= '{$acc['level']}' ORDER BY s.name ASC";
$result = $db->query($sql);
while ($row = $db->fetch_array($result)) {
// skill not learned yet
if ($row["asid"] == "") {
echo '
', stripslashes($row["name"]), ' (', $row["cost"], ' skill points to learn):<br>
', stripslashes($row["description"]), '<br>
';
if ($acc["level"] < gdSkillLevelMin) {
$output .= 'Your level is too low.<br>';
$no = 1;
}
}
if ($no == 0) {
$sql = "LOCK TABLES accounts LOW_PRIORITY WRITE, accskills LOW_PRIORITY WRITE, skills READ";
$result = $db->query($sql);
$sql = "SELECT class, forest, death, air, earth, skills FROM accounts WHERE id = '{$acc['id']}'";
$result = $db->query($sql);
$arow = $db->fetch_array($result);
// amount of skill points left
$sql = "SELECT SUM(skills.cost) AS totalcost, COUNT(*) AS aantal FROM accskills, skills WHERE accskills.account = '{$acc['id']}' AND accskills.skill = skills.id";
$result = $db->query($sql);
$tmp = $db->fetch_array($result);
$arow["skills"] = $tmp["aantal"] == 0 ? 0 : $tmp["totalcost"];
$arow["level"] = $acc["level"];
$left = gGetSkillPointsLeft($arow);
if ($left >= $row["cost"]) {
$sql = "INSERT INTO accskills (account, skill) VALUES ('{$acc['id']}', '{$skill}')";
$result = $db->query($sql);
$sql = "UPDATE accounts SET skills = skills + {$row['cost']} WHERE id = '{$acc['id']}'";
$result = $db->query($sql);
$acc["skills"] += $row["cost"];
$output .= 'You succesfully learn that skill!<br><br>';
$action = "skills";
}
$sql = "UNLOCK TABLES";
$result = $db->query($sql);
}
}
