if (trim($v_Code) == "") { $fail = true; } } else { $fail = true; } if (!$fail) { $api = new eveAPI(); $charIds[0] = 0; $charNames[0] = ""; $corpIds[0] = 0; $corpNames[0] = 0; $api->Init($key_ID, $v_Code); $ret = $api->getCharXML(); if ($ret) { $charIds = $api->getValueArrayFromXML($ret, "characterID"); $charNames = $api->getValueArrayFromXML($ret, "name"); $corpIds = $api->getValueArrayFromXML($ret, "corporationID"); $corpNames = $api->getValueArrayFromXML($ret, "corporationName"); } else { $fail = true; } if (!$fail) { if (IsProduction()) { mysql_select_db("eve.tdsin"); } else { mysql_select_db("naed_Sapphire"); } $sql = "CALL sp_AddAPIKey(" . $key_ID . ", '" . $v_Code . "', " . $charIds[0] . ", '" . $charNames[0] . "', " . $corpIds[0] . ", '" . $corpNames[0] . "')"; $result = mysql_query($sql, $conn) or die(mysql_error()); Success();
} } if ($keyIdYo != -1) { $itemIDs[0] = 0; $typeIDs[0] = 0; $locationIDs[0] = 0; $moonIDs[0] = 0; $states[0] = 0; $stateTimes[0] = ""; $onlineTimes[0] = ""; $lastUpdates[0] = ""; $api = new eveAPI(); $api->Init($keyIdYo, $vCode); $ret = $api->getTowerListXML(); if ($ret) { $itemIDs = $api->getValueArrayFromXML($ret, "itemID"); $typeIDs = $api->getValueArrayFromXML($ret, "typeID"); $locationIDs = $api->getValueArrayFromXML($ret, "locationID"); $moonIDs = $api->getValueArrayFromXML($ret, "moonID"); $states = $api->getValueArrayFromXML($ret, "state"); $stateTimes = $api->getValueArrayFromXML($ret, "stateTimestamp"); $onlineTimes = $api->getValueArrayFromXML($ret, "onlineTimestamp"); } else { $fail = true; } } else { $fail = true; } if (!$fail) { for ($i = 0; $i < count($itemIDs); $i++) { $starbasePK = 0;
} if ($name == "itemID") { $starBaseId[$starBaseCount] = $value; $starBaseCount++; } } } $api = new eveAPI(); $api->Init($keyIdYo, $vCode); for ($i = 0; $i < $starBaseCount; $i++) { $types[0] = 0; $amounts[0] = 0; $detailCount = 0; $ret = $api->getTowerDetailXML($starBaseId[$i]); if ($ret) { $types = $api->getValueArrayFromXML($ret, "typeID"); $amounts = $api->getValueArrayFromXML($ret, "quantity"); $sql = "Select\n\t\t\t\t\t\tdetail_id\n\t\t\t\t\tFrom\n\t\t\t\t\t\tStarbase_Details\n\t\t\t\t\tWhere\n\t\t\t\t\t\tstarbase_id =" . $starBasePks[$i]; $result = mysql_query($sql, $conn) or die(mysql_error()); while ($row = mysql_fetch_assoc($result)) { foreach ($row as $name => $value) { if ($name == "detail_id") { $detailCount++; } } } if ($detailCount == 0) { //Add Everything for ($x = 0; $x < count($types); $x++) { //Add Fuel $detailPk = 0;