To: ">
No skill data"; return; } // Query description, experience and skill cost $qry="SELECT * FROM skill WHERE id=$skill_id"; $result=mysql_query($qry); // Get description if ($skill_data=mysql_fetch_assoc($result)) $toolTip.=$skill_data["description"]."

"; // Get skill mods $qry="SELECT skill_mod.name, granted_skills.value FROM skill "; $qry.="INNER JOIN granted_skills ON skill.id=granted_skills.skill_id INNER JOIN skill_mod ON granted_skills.skill_mod_id=skill_mod.id "; $qry.="WHERE skill.id=$skill_id ORDER BY skill_mod.name"; $result=mysql_query($qry); while ($skill_mod_data=mysql_fetch_assoc($result)) { $toolTip.="[Skill mod] ".$skill_mod_data["name"]." +".$skill_mod_data["value"]."
"; $otherData = true; } // Get certifications $qry="SELECT certification.name FROM skill "; $qry.="INNER JOIN granted_certifications ON skill.id=granted_certifications.skill_id INNER JOIN certification ON granted_certifications.certification_id=certification.id "; $qry.="WHERE skill.id=$skill_id ORDER BY certification.name"; $result=mysql_query($qry); while ($certifications_data=mysql_fetch_assoc($result)) { $toolTip.="[Certification] ".$certifications_data["name"]."
"; $otherData = true; } // Get schematics $qry="SELECT schematic.name FROM skill "; $qry.="INNER JOIN granted_schematics ON skill.id=granted_schematics.skill_id INNER JOIN schematic ON granted_schematics.schematic_id=schematic.id "; $qry.="WHERE skill.id=$skill_id ORDER BY schematic.name"; $result=mysql_query($qry); while ($schematics_data=mysql_fetch_assoc($result)) { $toolTip.="[Schematic] ".$schematics_data["name"]."
"; $otherData = true; } // Get abilities $qry="SELECT ability.name FROM skill "; $qry.="INNER JOIN granted_abilities ON skill.id=granted_abilities.skill_id INNER JOIN ability ON granted_abilities.ability_id=ability.id "; $qry.="WHERE skill.id=$skill_id ORDER BY ability.name"; $result=mysql_query($qry); while ($abilities_data=mysql_fetch_assoc($result)) { $toolTip.="[Ability] ".$abilities_data["name"]."
"; $otherData = true; } if ($otherData) $toolTip.="
"; // Get experience and skill cost if (isSet($skill_data)) { if ($skill_num==5 || $skill_num==0) $tier=$skill_num; $toolTip.="This skill requires ".$skill_data["skill_cost"]." skill points to learn.
"; if ($skill_data["exp_id"] <> 0) { $qry="SELECT * FROM exp_type WHERE id=".$skill_data["exp_id"]; $result=mysql_query($qry); $exp_type=mysql_result($result,0,"name"); $toolTip.="This skill requires ".number_format($skill_data["exp_cost"])." points of ".$exp_type." experience.
"; if ($skill_data["exp_cap"] > 0) $toolTip.="You may have up to ".number_format($skill_data["exp_cap"])." points of experience before reaching your limit.
"; } $linkText=$skill_data["name"]; if (isSet($skill_selection[$skill_id]) && $skill_selection[$skill_id] == 1) { $do_skill="rs"; $skillbox="images/skillbox2.gif"; $font_class="skillbox2"; } else { $do_skill="as"; $skillbox="images/skillbox.gif"; $font_class="skillbox1"; } print '"; print "".$linkText."\n"; //print "".$linkText.""; } } function getProfessionType($prof_id) { // Returns 0 for Starting Professions, 1 for Elite Professions $qry="SELECT type FROM profession WHERE id=$prof_id"; $result=mysql_query($qry); $prof_data=mysql_fetch_assoc($result); if ($prof_data) return $prof_data["type"]; else return 0; } function getSkillNum($skill_id) { $qry="SELECT skill_num FROM profession_skills WHERE skill_id=$skill_id"; $result=mysql_query($qry); $ps_data=mysql_fetch_assoc($result); if ($ps_data) return $ps_data["skill_num"]; else return 0; /***************************** if ($skill_id % 18 < 1) return 5; else if ($skill_id % 18 < 5) return 1; else if ($skill_id % 18 < 9) return 2; else if ($skill_id % 18 < 13) return 3; else if ($skill_id % 18 < 17) return 4; else return 0; ******************************/ } function selectProfessionPreReqs($prof_id) { global $skill_selection; if (getProfessionType($prof_id) > 0) { $qry="SELECT sub_profession_id, skill_num FROM profession_link WHERE profession_id=$prof_id"; $result=mysql_query($qry); while ($prof_data=mysql_fetch_assoc($result)) { if ($prof_data["skill_num"] == 5) { $start=18*$prof_data["sub_profession_id"]; $end=18*$prof_data["sub_profession_id"]-17; for($x=$start;$x>=$end;$x--) $skill_selection[$x]=1; } elseif ($prof_data["skill_num"] != 0) { $qry2="select skill_id from profession_skills where profession_id=".$prof_data["sub_profession_id"]." and skill_num='".$prof_data["skill_num"]."'"; $result2=mysql_query($qry2); while($skill_data=mysql_fetch_assoc($result2)) { $skill_selection[$skill_data["skill_id"]]=1; } $skill_selection[$prof_data["sub_profession_id"]*18-1]=1; } if ($prof_data["skill_num"] != 0) { selectProfessionPreReqs($prof_data["sub_profession_id"]); } } } } function removeProfessionPreReqs($sub_prof_id, $rs) { global $skill_selection; // Find the skill_num of the skill being surrendered. $skill_num = getSkillNum($rs); $qry="SELECT profession_id, skill_num FROM profession_link WHERE sub_profession_id=$sub_prof_id and skill_num='$skill_num'"; $result=mysql_query($qry); while ($prof_data=mysql_fetch_assoc($result)) { if ($prof_data["skill_num"] != 0) { removeSkill(($prof_data["profession_id"]*18)-1,0); removeProfessionPreReqs($prof_data["profession_id"], ($prof_data["profession_id"]*18)-1); } } } function removeSkill($rs, $t) { global $skill_selection; //$skill_selection[$rs]=0; unset($skill_selection[$rs]); if ($t==0) { // Tier (Novice) for($x=$rs+1;$x>($rs-17);$x--) { unset($skill_selection[$x]); removeProfessionPreReqs((intval($rs/18)+1), $x); } removeProfessionPreReqs((intval($rs/18)+1), (intval($rs/18)+1)*18); } else if ($t==5) { // Tier (Master) unset($skill_selection[$rs]); } else { // All tiers in between for($x=$rs;$x<($rs+5-$t);$x++) { unset($skill_selection[$x]); } unset($skill_selection[(intval($rs/18)+1)*18]); removeProfessionPreReqs((intval($rs/18)+1), (intval($rs/18)+1)*18); } } if (isSet($template)) { $qry="SELECT skill_selection FROM templates WHERE id=$template"; $result=mysql_query($qry); $_SESSION['skill_selection_s']=mysql_result($result,0,"skill_selection"); } // ================= Drop all skills ================= if (isSet($da)) { unset($_SESSION['skill_selection_s']); } // =============== Setup default values ============== if (!isSet($_SESSION["profession"]) && !isSet($prof_id)) { $_SESSION["profession"]=1; $prof_id=1; } else if (!isSet($prof_id)) { $prof_id=$_SESSION["profession"]; } else { $_SESSION["profession"]=$prof_id; } if (!isSet($_SESSION["skill_selection_s"])) { $skill_selection[0] = 1; } else { $skill_selection=unserialize($_SESSION["skill_selection_s"]); } if (isSet($_REQUEST['onlyfs'])) $_SESSION['onlyfs'] = $_REQUEST['onlyfs']; else if (!isSet($_SESSION['onlyfs'])) $_SESSION['onlyfs'] = "0"; // ==================== Add skill ==================== if (isSet($as)) { //$skill_selection[$as]=1; if ($t==5) { // If adding master skill for($x=$as;$x>($as-18);$x--) { $skill_selection[$x]=1; // Select all skills in the profesion } } else if ($t==0) { // Else if adding novice skill $skill_selection[$as]=1; // Select only novice skill } else { for($x=$as;$x>($as-$t);$x--) { $skill_selection[$x]=1; // Otherwise, add all skills in line below } $skill_selection[$prof_id*18-1]=1; // and the novice profession } // Elite Skills - select pre-reqs selectProfessionPreReqs($prof_id); } // =================== Remove skill =================== if (isSet($rs)) { removeSkill($rs, $t); removeProfessionPreReqs($prof_id, $rs); } // ============= Initialize skill id data ============= $_SESSION["skill_selection_s"]=serialize($skill_selection); $qry="SELECT * FROM profession_skills WHERE profession_id=$prof_id ORDER BY skill_num, tier"; $result=mysql_query($qry); $id_data=Array(); $tier_count=array(1=>0,2=>0,3=>0,4=>0); while ($prof_data=mysql_fetch_assoc($result)) { $id_data[$prof_data["skill_num"]][$prof_data["tier"]]=$prof_data["skill_id"]; $tier_count[$prof_data["tier"]]=$tier_count[$prof_data["tier"]]+1; } ?> <?=$page_title?> '; ?>
Starting Professions
Error: ".mysql_error()."
"; else { while ($prof_data=mysql_fetch_assoc($result)) { if ($prof_data["type"] >= 1 && !$bPrintedElite){ print "Elite/Hybrid Professions
"; $bPrintedElite = true; } if ($prof_data["id"] == $prof_id) print "".$prof_data["name"].""; else print "".$prof_data["name"].""; $novice_id=$prof_data["id"]*18-1; if (isSet($skill_selection[$novice_id]) && $skill_selection[$novice_id]==1) print " *"; $master_id=$prof_data["id"]*18; if (isSet($skill_selection[$master_id]) && $skill_selection[$master_id]==1) print "*"; ?>
'; ?>
'; ?>



'; ?> 1) writeLink(2,4); ?> 1) writeLink(3,4); ?> 1) writeLink(4,4); ?>
'; ?> 1) writeLink(2,3); ?> 1) writeLink(3,3); ?> 1) writeLink(4,3); ?>
'; ?> 1) writeLink(2,2); ?> 1) writeLink(3,2); ?> 1) writeLink(4,2); ?>
'; ?> 3) writeLink(2,1); ?> 3) writeLink(3,1); ?> 3) writeLink(4,1); ?>
'; ?>


0) writeProfessionLink(0); ?>

Skill points remaining: /250
Surrender All Skills | View Report | Save Template | Show All Professions Show Only FS/Jedi Professions

LucasArts and the LucasArts logo are registered trademarks of Lucasfilm Ltd. Star Wars Galaxies is a trademark of Lucasfilm Entertainment Company Ltd. SOE and the SOE logo are registered trademarks of Sony Online Entertainment Inc. © 2003 Lucasfilm Entertainment Company Ltd. or Lucasfilm Ltd. & ® or TM as indicated. All rights reserved.

Running version: $version
Modified by: David Trousdale and Malik Emami
Be sure to check for updates/news/information at the official homepage.
Page parsed in " . substr($run, 0, 5) . " secs.

"; ?>