function get_skills() { global $TPL; global $skill_class; $skills = array("" => "Any Skill"); $query = "SELECT * FROM skill"; if ($skill_class != "") { $query .= prepare(" WHERE skillClass='%s'", $skill_class); } $query .= " ORDER BY skillClass,skillName"; $db = new db_alloc(); $db->query($query); while ($db->next_record()) { $skill = new skill(); $skill->read_db_record($db); $skills[$skill->get_id()] = sprintf("%s - %s", $skill->get_value('skillClass'), $skill->get_value('skillName')); } return $skills; }
function get_skills($proficiency) { // Return a string of skills with a given proficiency $query = "SELECT * FROM proficiency LEFT JOIN skill on proficiency.skillID=skill.skillID"; $query .= prepare(" WHERE personID=%d AND skillProficiency='%s' ORDER BY skillName", $this->get_id(), $proficiency); $db = new db_alloc(); $db->query($query); while ($db->next_record()) { $skill = new skill(); $skill->read_db_record($db); if ($rtn) { $rtn .= ", "; } $rtn .= $skill->get_value('skillName'); } return $rtn; }
function show_skills_list() { global $TPL; global $personID; global $skills; $db = new db_alloc(); $query = prepare("SELECT * FROM proficiency WHERE personID=%d", $personID); $db->query($query); $skills_got = array(); while ($db->next_record()) { $skill = new skill(); $skill->read_db_record($db); array_push($skills_got, $skill->get_id()); } $query = "SELECT * FROM skill ORDER BY skillClass"; $db->query($query); while ($db->next_record()) { $skill = new skill(); $skill->read_db_record($db); if (in_array($skill->get_id(), $skills_got)) { // dont show this item } else { $skills[$skill->get_id()] = sprintf("%s - %s", $skill->get_value('skillClass'), $skill->get_value('skillName')); } } if (count($skills) > 0) { $TPL["skills"] = page::select_options($skills, ""); } }
function show_skill_expertise() { global $TPL; global $people_ids; global $people_header; global $talent; global $skill_class; $currSkillClass = null; $db = new db_alloc(); $query = "SELECT * FROM proficiency"; $query .= " LEFT JOIN skill ON proficiency.skillID=skill.skillID"; if ($talent != "" || $skill_class != "") { if ($talent != "") { $query .= prepare(" WHERE proficiency.skillID=%d", $talent); } else { $query .= prepare(" WHERE skillClass='%s'", $skill_class); } } $query .= " GROUP BY skillName ORDER BY skillClass,skillName"; $db->query($query); while ($db->next_record()) { $skill = new skill(); $skill->read_db_record($db); $thisSkillClass = $skill->get_value('skillClass'); if ($currSkillClass != $thisSkillClass) { $currSkillClass = $thisSkillClass; if (!isset($people_header)) { get_people_header(); } $class_header = sprintf("<tr class=\"highlighted\">\n<th width=\"5%%\">%s </th>\n", $skill->get_value('skillClass', DST_HTML_DISPLAY)); print $class_header . $people_header . "</tr>\n"; } print sprintf("<tr>\n<th>%s</th>\n", $skill->get_value('skillName', DST_HTML_DISPLAY)); for ($i = 0; $i < count($people_ids); $i++) { $db2 = new db_alloc(); $query = "SELECT * FROM proficiency"; $query .= prepare(" WHERE skillID=%d AND personID=%d", $skill->get_id(), $people_ids[$i]); $db2->query($query); if ($db2->next_record()) { $proficiency = new proficiency(); $proficiency->read_db_record($db2); $p = sprintf("<td align=\"center\"><img src=\"../images/skill_%s.png\" alt=\"%s\"/></td>\n", strtolower($proficiency->get_value('skillProficiency')), substr($proficiency->get_value('skillProficiency'), 0, 1)); print $p; } else { print "<td align=\"center\">-</td>\n"; } } print "</tr>\n"; } }