function recup_infos($key)
{
    $result = ryzom_guild_api($key);
    if (isset($result[$key])) {
        $xml = $result[$key];
    }
    $info = '';
    if ($xml === false || isset($xml->error)) {
        $error = 'ERROR: apikey error<br>';
        if (isset($xml->error)) {
            $error .= sprintf('Server said: [%d]: %s<br>', (int) $xml->error['code'], (string) $xml->error);
        }
    } else {
        $apikey = (string) $xml['apikey'];
        $info = '';
    }
    return $xml;
}
<?php

// il faut récupérer l'id de la guilde
if (!empty($_POST['clenouvelle'])) {
    $dbconn = new mysqli($dbhost, $dbuser, $dbpassword, $dbname);
    $cle = $dbconn->real_escape_string($_POST['clenouvelle']);
    $nomguilde = $dbconn->real_escape_string($_POST['nomnouvelle']);
    $xml = ryzom_guild_api($cle);
    $idnouvelle = $xml[$cle]->gid;
    $SQL = "INSERT INTO " . $dbprefixe . "guilde_api VALUES('" . $idnouvelle . "','" . $nomguilde . "','" . $cle . "','" . $guildid . "')";
    //$SQL=mysqli_real_escape_string($dbconn,$SQL);
    //echo $SQL;
    if ($dbconn->connect_errno) {
        require 'noconfig.php';
    } else {
        $result = $dbconn->query($SQL);
        if (!($result = $dbconn->query($SQL))) {
            echo $dbconn->error;
        }
    }
}
if (!empty($_POST['clenouveau'])) {
    $dbconn = new mysqli($dbhost, $dbuser, $dbpassword, $dbname);
    $cle = $dbconn->real_escape_string($_POST['clenouveau']);
    $nommembre = $dbconn->real_escape_string($_POST['nomnouveau']);
    $xml = ryzom_character_api($cle);
    //var_dump($xml);
    $idnouveau = $xml[$cle]->id;
    $SQL = "INSERT INTO " . $dbprefixe . "perso_api VALUES(\"" . $idnouveau . "\",\"" . $nommembre . "\",\"" . $cle . "\",\"" . $guildid . "\")";
    //$SQL=mysqli_real_escape_string($dbconn,$SQL);
    if (!($result = $dbconn->query($SQL))) {