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);
}