function writeSuperChars($charArray) { //print_r($charArray); $i = 0; $all = count($charArray); foreach ($charArray as $char) { $info = getCharInfos($char["characterID"]); $char["corporationID"] = (string) $info["corporationID"]; $char["corporationName"] = (string) $info["corporationName"]; $char["allianceID"] = (string) $info["allianceID"]; $char["allianceName"] = (string) $info["allianceName"]; echo $char["characterName"] . " "; $i = $i + 1; echo $i . "/" . $all; echo "\n"; $sql = "INSERT INTO superpilots (characterID, characterName, corporationID, corporationName, allianceID, allianceName,shipTypeID, lastKill)"; $sql = $sql . ' VALUES ("' . $char["characterID"] . '", "' . $char["characterName"] . '","' . $char["corporationID"] . '","' . $char["corporationName"] . '","' . $char["allianceID"] . '","' . $char["allianceName"] . '","' . $char["shipTypeID"] . '","' . $char["killtime"] . '")'; //echo $sql; sql_write($sql); echo "<br>"; flush(); } }
function writePurSuperPilots($isSuper, $id) { $sql = "INSERT INTO issuper (characterID, isSuper) VALUES (" . $id . ", " . $isSuper . ")"; sql_write($sql); }