$sys_id = $id; break; } $contracttarget = new ContractTarget($contract, $crp_id, $all_id, $reg_id, $sys_id); $contracttarget->add(); header("Location: " . htmlspecialchars_decode($editURL)); } if (isset($_POST['add_name'])) { $page->setTitle("Add target"); if (strlen($_POST['add_name']) < 3) { $html .= "Please type atleast 3 letters."; } else { $qry = new DBQuery(); switch ($_POST['add_type']) { case 0: $sql = "select crp.crp_id as id, crp.crp_name as name\n from kb3_corps crp\n where lower( crp.crp_name ) like '%" . $qry->escape(strtolower($_POST['add_name']), true) . "%'"; break; case 1: $sql = "select ali.all_id as id, ali.all_name as name\n from kb3_alliances ali\n where lower( ali.all_name ) like '%" . $qry->escape(strtolower($_POST['add_name']), true) . "%'"; break; case 2: $sql = "select reg_id as id, reg_name as name\n from kb3_regions\n where lower( reg_name ) like '%" . $qry->escape(strtolower($_POST['add_name']), true) . "%'"; break; case 3: $sql = "select sys_id as id, sys_name as name\n from kb3_systems\n where lower( sys_name ) like '%" . $qry->escape(strtolower($_POST['add_name']), true) . "%'"; break; } $qry->execute($sql) or die($qry->getErrorMsg()); if ($qry->recordCount()) { $html .= "<table class='kb-table' width='450'>"; $html .= "<tr class='kb-table-header'><td width='340'>Name</td><td width='80' align='center'>Action</td></tr>";
$html .= '>Constellation</option> <option value="sys"'; if ($_POST['selector'] == 'sys') { $html .= " selected"; } $html .= '>System</option> </select><br /> <br /> <input name="" type="submit" value="Search"/> </form>'; if (isset($_POST['search_string']) && $_POST['search_string'] != "") { $html .= '<br /><br />'; $qry = new DBQuery(); switch ($_POST['selector']) { case "reg": $sql = "\tSELECT reg_id, reg_name\n\t\t\t\t\t\tFROM `kb3_regions`\n\t\t\t\t\t\tWHERE `reg_name` LIKE '%" . $qry->escape($_POST['search_string'], true) . "%'"; break; case "con": $sql = "\tSELECT con.con_name, reg.reg_id, reg.reg_name\n\t\t\t\t\t\tFROM kb3_constellations con, kb3_regions reg\n\t\t\t\t\t\tWHERE reg.reg_id = con.con_reg_id\n\t\t\t\t\t\tAND con.con_name LIKE '%" . $qry->escape($_POST['search_string'], true) . "%'"; break; case "sys": $sql = "\tSELECT sys.sys_name, reg.reg_id, reg.reg_name\n\t\t\t\t\t\tFROM kb3_systems sys, kb3_constellations con, kb3_regions reg\n\t\t\t\t\t\tWHERE con.con_id = sys.sys_con_id\n\t\t\t\t\t\tAND reg.reg_id = con.con_reg_id\n\t\t\t\t\t\tAND sys.sys_name LIKE '%" . $qry->escape($_POST['search_string'], true) . "%'"; break; default: exit; } $qry->execute($sql) or die($qry->getErrorMsg()); if ($qry->recordCount()) { $html .= '<table width="250" border="0" cellspacing="1" cellpadding="1">'; while ($row = $qry->getRow()) { $html .= '<tr>';
continue; } $active = isset($val["active"]) ? 1 : 0; $lastkill = intval($val["lastkill"]); // check feed doesn't already exist foreach ($feeds as $fid => $fval) { if ($fval['uri'] == $uri) { $html .= "<br />Not Adding Duplicate Feed with URL: " . $uri; continue 2; } } $feed_flags = 0; if ($active) { $feed_flags |= FEED_ACTIVE; } $sql = "INSERT INTO kb3_feeds( feed_url, feed_lastkill, feed_kbsite, feed_flags) VALUES ( '" . $qry->escape($uri) . "', {$lastkill}, '" . KB_SITE . "', '{$feed_flags}' )"; $qry->execute($sql); $qry->execute("SELECT * FROM kb3_feeds WHERE feed_kbsite = '" . KB_SITE . "' AND feed_url='" . $qry->escape($uri) . "'"); while ($row = $qry->getRow()) { $active = (bool) ($row["feed_flags"] & FEED_ACTIVE); $feeds[$row["feed_id"]] = array('id' => $row["feed_id"], 'updated' => $row["feed_updated"], 'active' => $active, 'uri' => $row["feed_url"], 'lastkill' => $row["feed_lastkill"]); } } else { // update $id = intval($key); $uri = $val["url"]; $active = isset($val["active"]) ? 1 : 0; $lastkill = intval($val["lastkill"]); if ($feeds[$id]['active'] != $active) { // flags have changed $feed_flags = 0;
break; case 222: if ($act->isOldKey($row['key_id'], $row['key_key'])) { $flags |= KB_APIKEY_LEGACY; break; } $flags |= KB_APIKEY_EXPIRED; break; default: } } else { // no error so user didn't have '256' access } } $qry2 = new DBQuery(); $sql = "UPDATE kb3_api_keys SET key_flags = {$flags} WHERE key_name='" . $qry->escape($row['key_name']) . "' AND key_id='" . $qry->escape($row['key_id']) . "' AND key_key='" . $qry->escape($row['key_key']) . "' AND key_kbsite = '" . KB_SITE . "'"; $qry2->execute($sql); } if ($flags & KB_APIKEY_LEGACY) { $html .= "<td></td><td>-</td><td>-</td>"; } else { $html .= "<td>"; $chars = array(); if (!($flags & KB_APIKEY_BADAUTH || $flags & KB_APIKEY_EXPIRED)) { $act = new API_Account(); $characters = $act->fetch($row['key_id'], $row['key_key']); if (is_array($characters)) { foreach ($act->fetch($row['key_id'], $row['key_key']) as $character) { $chars[] = $character["characterName"] . ", " . $character["corporationName"]; } } else {
function getShipStats($param_ship) { //global $shipStats; $qry = new DBQuery(); $qry->execute("select kb3_invtypes.typeID, kb3_invtypes.description from kb3_invtypes WHERE kb3_invtypes.typeName = '" . $qry->escape($param_ship) . "'"); $typeID = $qry->getRow(); self::$shipStats->setShipIcon($typeID['typeID']); self::$shipStats->setShipDesc($typeID['description']); //$itemquery = mysql_query("select kb3_invtypes.typeID from kb3_invtypes WHERE kb3_invtypes.typeName = '".$param_ship."'") or die(mysql_error()); //$typeID = mysql_fetch_array($itemquery); $qry2 = new DBQuery(); $qry2->execute("select kb3_dgmtypeattributes.value, kb3_dgmattributetypes.attributeName, kb3_dgmattributetypes.displayName, kb3_dgmattributetypes.stackable, kb3_eveunits.displayName as unit\nfrom kb3_dgmtypeattributes\ninner join kb3_dgmattributetypes on kb3_dgmtypeattributes.attributeID = kb3_dgmattributetypes.attributeID\nleft join kb3_eveunits on kb3_dgmattributetypes.unitID = kb3_eveunits.unitID\nwhere typeID = " . $typeID['typeID']); //$row = $qry2->getRow(); while ($row = $qry2->getRow()) { if (strtolower($row['attributeName']) == "shieldcapacity") { self::$shipStats->setShieldAmount($row['value']); } if (strtolower($row['attributeName']) == "armorhp") { self::$shipStats->setArmorAmount($row['value']); } if (strtolower($row['attributeName']) == "hp") { self::$shipStats->setHullAmount($row['value']); } if (strtolower($row['attributeName']) == "scanradarstrength" && $row['value'] > 0) { self::$shipStats->setSensorType(fittingTools::getSensorTypeImg('radar')); self::$shipStats->setSensorAmount($row['value']); } if (strtolower($row['attributeName']) == "scanladarstrength" && $row['value'] > 0) { self::$shipStats->setSensorType(fittingTools::getSensorTypeImg('ladar')); self::$shipStats->setSensorAmount($row['value']); } if (strtolower($row['attributeName']) == "scanmagnetometricstrength" && $row['value'] > 0) { self::$shipStats->setSensorType(fittingTools::getSensorTypeImg('magnetometric')); self::$shipStats->setSensorAmount($row['value']); } if (strtolower($row['attributeName']) == "scangravimetricstrength" && $row['value'] > 0) { self::$shipStats->setSensorType(fittingTools::getSensorTypeImg('gravimetric')); self::$shipStats->setSensorAmount($row['value']); } if (strtolower($row['attributeName']) == "shieldemdamageresonance") { self::$shipStats->setShieldEM((1 - $row['value']) * 100); } if (strtolower($row['attributeName']) == "shieldthermaldamageresonance") { self::$shipStats->setShieldTh((1 - $row['value']) * 100); } if (strtolower($row['attributeName']) == "shieldkineticdamageresonance") { self::$shipStats->setShieldKi((1 - $row['value']) * 100); } if (strtolower($row['attributeName']) == "shieldexplosivedamageresonance") { self::$shipStats->setShieldEx((1 - $row['value']) * 100); } if (strtolower($row['attributeName']) == "shieldrechargerate") { self::$shipStats->setShieldRecharge($row['value'] / 1000); } if (strtolower($row['attributeName']) == "armoremdamageresonance") { self::$shipStats->setArmorEM((1 - $row['value']) * 100); } if (strtolower($row['attributeName']) == "armorthermaldamageresonance") { self::$shipStats->setArmorTh((1 - $row['value']) * 100); } if (strtolower($row['attributeName']) == "armorkineticdamageresonance") { self::$shipStats->setArmorKi((1 - $row['value']) * 100); } if (strtolower($row['attributeName']) == "armorexplosivedamageresonance") { self::$shipStats->setArmorEx((1 - $row['value']) * 100); } if (strtolower($row['attributeName']) == "emdamageresonance") { self::$shipStats->setHullEM((1 - $row['value']) * 100); } if (strtolower($row['attributeName']) == "thermaldamageresonance") { self::$shipStats->setHullTh((1 - $row['value']) * 100); } if (strtolower($row['attributeName']) == "kineticdamageresonance") { self::$shipStats->setHullKi((1 - $row['value']) * 100); } if (strtolower($row['attributeName']) == "explosivedamageresonance") { self::$shipStats->setHullEx((1 - $row['value']) * 100); } if (strtolower($row['attributeName']) == "maxvelocity") { self::$shipStats->setShipSpeed($row['value']); } if (strtolower($row['attributeName']) == "signatureradius") { self::$shipStats->setSigRadius($row['value']); } if (strtolower($row['attributeName']) == "scanresolution") { self::$shipStats->setScan($row['value']); } if (strtolower($row['attributeName']) == "maxtargetrange") { self::$shipStats->setDistance($row['value']); } if (strtolower($row['attributeName']) == "maxlockedtargets") { self::$shipStats->setTarget($row['value']); } if (strtolower($row['attributeName']) == "capacitorcapacity") { self::$shipStats->setCapAmount($row['value']); } if (strtolower($row['attributeName']) == "rechargerate") { self::$shipStats->setCapRecharge($row['value']); } if (strtolower($row['attributeName']) == "rigsize") { self::$shipStats->setRSize(fittingTools::returnShipSize($row['value'])); } if (strtolower($row['attributeName']) == "lowslots") { $arr = self::$shipStats->getShipSlots(); $arr['lowslots'] = $row['value']; self::$shipStats->setShipSlots($arr); } if (strtolower($row['attributeName']) == "medslots") { $arr = self::$shipStats->getShipSlots(); $arr['medslots'] = $row['value']; self::$shipStats->setShipSlots($arr); } if (strtolower($row['attributeName']) == "hislots") { $arr = self::$shipStats->getShipSlots(); $arr['hislots'] = $row['value']; self::$shipStats->setShipSlots($arr); } if (strtolower($row['attributeName']) == "rigslots") { $arr = self::$shipStats->getShipSlots(); $arr['rigslots'] = $row['value']; self::$shipStats->setShipSlots($arr); } if (strtolower($row['attributeName']) == "upgradecapacity") { self::$shipStats->setCalAmount($row['value']); } if (strtolower($row['attributeName']) == "cpuoutput") { self::$shipStats->setCpuAmount($row['value']); } if (strtolower($row['attributeName']) == "poweroutput") { self::$shipStats->setPrgAmount($row['value']); } if (strtolower($row['attributeName']) == "turretslotsleft") { self::$shipStats->setTurAmount($row['value']); self::$shipStats->setTurUsed($row['value']); } if (strtolower($row['attributeName']) == "launcherslotsleft") { self::$shipStats->setMisAmount($row['value']); self::$shipStats->setMisUsed($row['value']); } } $qry3 = new DBQuery(); $qry3->execute("select mass from kb3_invtypes left join kb3_item_types on itt_id = groupID where typeID = " . $typeID['typeID']); $row3 = $qry3->getRow(); self::$shipStats->setMass(fittingTools::calculateMass($row3['mass'])); //echo self::$shipStats->getMass(); }