PHP check_saved_key Examples

Example #1

File: manage.func.php Project: Covert-Inferno/eve-jackknife

function add_api_key($link, $uid, $keyID, $vCode, $name, $notes = "")
{
    $apikey = make_short_key($link, $keyID, $vCode, $uid);
    $ID = check_saved_key($link, $apikey, $uid);
    if ($ID) {
        return $ID . "<321>Api Code Already added";
    }
    if (!$name) {
        $name = "No Name Set";
    }
    $name = mysql_real_escape_string($name, $link);
    $keyInfo = cache_api_retrieve($link, "/account/APIKeyInfo.xml.aspx", array("keyID" => $keyID, "vCode" => $vCode), 5 * 60)->value;
    echo $keyInfo->error;
    if ($keyInfo->error) {
        if ($keyInfo->error == 222) {
            return "0<321>Api Key expired";
        } else {
            if ($keyInfo->error == 203) {
                return "0<321>Api vCode or Id Incorrect";
            } else {
                return "0<321>Unable to load API. Verify the key is correct and not expired.";
            }
        }
        return false;
    }
    $type = (string) $keyInfo->result->key["type"];
    $notes = mysql_real_escape_string($notes, $link);
    foreach ($keyInfo->result->key->rowset->row as $char) {
        if (isset($char["characterName"])) {
            if (isset($characters)) {
                $characters .= "<br/>" . $char["characterName"] . "," . $char["characterId"];
            } else {
                $characters = $char["characterName"] . "," . $char["characterId"];
            }
        }
    }
    $keyID = mysql_real_escape_string($apikey, $link);
    $sql = "INSERT INTO " . DB_PREFIX . "keyInformation (apiKey,userID,keyName,characters,type,notes) VALUES ('{$keyID}','{$uid}','{$name}','{$characters}','{$type}','{$notes}')";
    $result = mysql_query($sql, $link);
    if (!$result) {
        echo "QUERY: '{$sql}'\n\n" . mysql_error() . "\n\nBacktrace:\n";
        debug_print_backtrace();
        exit;
    }
    if (mysql_affected_rows($link)) {
        return mysql_insert_id($link) . "<321>Api Key successfully added";
    }
}

Example #2

File: manage.func.php Project: Covert-Inferno/eve-jacknife

function add_api_key($Db, $uid, $keyID, $vCode, $name, $notes = "")
{
    $apikey = make_short_key($Db, $keyID, $vCode, $uid);
    $ID = check_saved_key($apikey, $uid);
    if ($ID) {
        return ["result" => "failure", "id" => $ID, "response" => "Api Code Already added"];
    }
    if (!$name) {
        $name = "No Name Set";
    }
    $keyInfo = cache_api_retrieve($Db, "/account/APIKeyInfo.xml.aspx", array("keyID" => $keyID, "vCode" => $vCode), 5 * 60)->value;
    echo $keyInfo->error;
    if ($keyInfo->error) {
        if ($keyInfo->error == 222) {
            return ["result" => "failure", "response" => "Api Key expired"];
        } else {
            if ($keyInfo->error == 203) {
                return ["result" => "failure", "response" => "Api vCode or Id Incorrect"];
            } else {
                return ["result" => "failure", "response" => "Unable to load API. Verify the key is correct and not expired."];
            }
        }
        return false;
    }
    $type = (string) $keyInfo->result->key["type"];
    foreach ($keyInfo->result->key->rowset->row as $char) {
        if (isset($char["characterName"])) {
            if (isset($characters)) {
                $characters .= "<br/>" . $char["characterName"] . "," . $char["characterId"];
            } else {
                $characters = $char["characterName"] . "," . $char["characterId"];
            }
        }
    }
    $result = $Db->insert("keyInformation", ['apiKey' => $apikey, 'userID' => $uid, 'keyName' => $name, 'characters' => $characters, 'type' => $type, 'notes' => $notes]);
    if (!$result) {
        return false;
    } else {
        return ["id" => $Db->lastid, "response" => "Api Key successfully added"];
    }
}