function get_ids() { # order matters!!!! if (is_null($this->alliance_id)) { $this->alliance_id = get_alliance_id($this->alliance); } if (is_null($this->corp_id)) { $this->corp_id = get_corp_id($this->corp, $this->alliance_id); } if (is_null($this->pilot_id)) { $this->pilot_id = get_pilot_id($this->pilot, $this->corp_id); } if (is_null($this->char_id)) { $this->char_id = get_pilot_charid($this->pilot_id); } if (is_null($this->ship_id)) { $this->ship_id = get_item_id($this->ship); } if (is_null($this->group_id)) { $this->group_id = get_item_group_id($this->ship_id); } if (is_null($this->weapon_id)) { $this->weapon_id = get_item_id($this->weapon); } }
function get_alliance_id($name, $first = 1) { global $ft; if (is_null($name) || $name == 'None' || $name == 'Unknown') { # None/Unknown seems to be a hint used by the game when a corp doesn't have an alliance return 0; } $allianceid = $ft->dbh->_select_one('SELECT allianceid FROM tbl:alliances WHERE name = ?', array($name)); if (!$allianceid && $first) { $ft->dbh->_do_query('INSERT INTO tbl:alliances (name) VALUES (?)', array($name)); $allianceid = get_alliance_id($name, 0); } return $allianceid; }
function get_pilot_with_info($charid, $name, $corpname, $alliancename) { # creates the pilot if needed $allid = get_alliance_id($alliancename); $corpid = get_corp_id($corpname, $allid); $pilotid = get_pilot_id($name, $corpid); $ocid = get_pilot_charid($pilotid); if ($ocid != $charid) { global $ft; $ft->dbh->_do_query('UPDATE tbl:pilots SET charid = ? WHERE pilotid = ?', array($charid, $pilotid)); } return $pilotid; }