MySQL Fehler beim Account Speichern/Laden

Wichtiger Hinweis: Bitte ändert nicht manuell die Schriftfarbe auf schwarz sondern belasst es bei der Standardeinstellung. Somit tragt ihr dazu bei dass euer Text auch bei Verwendung unseren dunklen Forenstils noch lesbar ist!

Tipp: Ihr wollt längere Codeausschnitte oder Logfiles bereitstellen? Benutzt unseren eigenen PasteBin-Dienst Link

    HeiHo Breadfish Com,


    Ich bräuchte mal eben Hilfe, und zwar werden meine Account Daten leider nicht gespeichert, der Name und das Passwort werden aber Komischerweise gespeichert...


    Ebenso wird nur der Name das Passwort und das Adminlevel ausgelesen...


    Hier mal mein "SavePlayerData":



    stock SavePlayerData(playerid)
    {
    new query[100 + MAX_PLAYER_NAME];
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `Geld` = '%d' WHERE `Name` = '%s'",User[playerid][Geld]);
    mysql_function_query(mycon,query,false,"","");
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `banned` = '%d' WHERE `Name` = '%s'",User[playerid][banned]);
    mysql_function_query(mycon,query,false,"","");
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `Bank` = '%d' WHERE `Name` = '%s'",User[playerid][Bank]);
    mysql_function_query(mycon,query,false,"","");
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `Level` = '%d' WHERE `Name` = '%s'",User[playerid][Level]);
    mysql_function_query(mycon,query,false,"","");
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `Adminlevel` = '%d' WHERE `Name` = '%s'",User[playerid][Adminlevel]);
    mysql_function_query(mycon,query,false,"","");
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `Userrat` = '%d' WHERE `Name` = '%s'",User[playerid][Userrat]);
    mysql_function_query(mycon,query,false,"","");
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `UserratLeader` = '%d' WHERE `Name` = '%s'",User[playerid][UserratLeader]);
    mysql_function_query(mycon,query,false,"","");
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `ExistenzLeader` = '%d' WHERE `Name` = '%s'",User[playerid][ExistenzLeader]);
    mysql_function_query(mycon,query,false,"","");
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `Existenz` = '%d' WHERE `Name` = '%s'",User[playerid][Existenz]);
    mysql_function_query(mycon,query,false,"","");
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `CMDallow` = '%d' WHERE `Name` = '%s'",User[playerid][CMDallow]);
    mysql_function_query(mycon,query,false,"","");
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `Werkzeugkasten` = '%d' WHERE `Name` = '%s'",User[playerid][Werkzeugkasten]);
    mysql_function_query(mycon,query,false,"","");
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `HangarKey` = '%d' WHERE `Name` = '%s'",User[playerid][HangarKey]);
    mysql_function_query(mycon,query,false,"","");
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `Leader` = '%d' WHERE `Name` = '%s'",User[playerid][Leader]);
    mysql_function_query(mycon,query,false,"","");
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `Member` = '%d' WHERE `Name` = '%s'",User[playerid][Member]);
    mysql_function_query(mycon,query,false,"","");
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `Rang` = '%d' WHERE `Name` = '%s'",User[playerid][Rang]);
    mysql_function_query(mycon,query,false,"","");
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `Skin` = '%d' WHERE `Name` = '%s'",User[playerid][Skin]);
    mysql_function_query(mycon,query,false,"","");
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `InPrison` = '%d' WHERE `Name` = '%s'",User[playerid][InPrison]);
    mysql_function_query(mycon,query,false,"","");
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `PrisonCPsgegeben` = '%d' WHERE `Name` = '%s'",User[playerid][PrisonCPsgegeben]);
    mysql_function_query(mycon,query,false,"","");
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `PrisonCPsgelaufen` = '%d' WHERE `Name` = '%s'",User[playerid][PrisonCPsgelaufen]);
    mysql_function_query(mycon,query,false,"","");
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `Skilllevel` = '%d' WHERE `Name` = '%s'",User[playerid][Skilllevel]);
    mysql_function_query(mycon,query,false,"","");
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `Skillpunkte` = '%d' WHERE `Name` = '%s'",User[playerid][Skillpunkte]);
    mysql_function_query(mycon,query,false,"","");
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `ZeitzumSkillpunkt` = '%d' WHERE `Name` = '%s'",User[playerid][ZeitzumSkillpunkt]);
    mysql_function_query(mycon,query,false,"","");
    mysql_format(mycon,query, sizeof(query), "UPDATE `accounts` SET `ZeitseidSkillpunkt` = '%d' WHERE `Name` = '%s'",User[playerid][ZeitseidSkillpunkt]);
    mysql_function_query(mycon,query,false,"","");
    return 1;
    }



    Hatte zuvor auf rat von Pablo Borsellino: %s in %d geändert... ohne erfolg.



    Und hier mein "LoadPlayerDataSequenze":



    public LoadPlayerDataSequence(playerid, l_step)
    {
    switch(l_step)
    {
    case 1:
    {
    new count = cache_get_field_content_int(0,"count");
    if(count)
    {
    ShowPlayerDialog(playerid, Dialog_Login, DIALOG_STYLE_PASSWORD, "{00FF00}[Just-Roleplay - Login]","{FFFFFF}Bitte geben Sie Ihr Passwort ein!","Login","Abbrechen");
    return 1;
    }
    else
    {
    ShowPlayerDialog(playerid, Dialog_Reg, DIALOG_STYLE_PASSWORD, "{00FF00}[Just-Roleplay - Registrierung]","{FFFFFF}Bitte geben Sie Ihr gewünschtes Passwort ein!","Register","Abbrechen");
    return 1;
    }
    }
    case 2:
    {
    new count = cache_get_field_content_int(0,"count");
    if(count)
    {
    new query[60 + MAX_PLAYER_NAME];
    mysql_format(mycon,query, sizeof(query), "SELECT * FROM `accounts` WHERE `Name` = '%e'",User[playerid][Name]);
    mysql_function_query(mycon,query,true,"LoadPlayerDataSequence","dd",playerid,3);
    return 1;
    }
    else
    {
    ShowPlayerDialog(playerid, Dialog_Login, DIALOG_STYLE_PASSWORD, "{00FF00}[Passwort Eingabe - Loginsequenz]","{FFFFFF}Bitte geben Sie Ihr richtiges Passwort ein!\n{FF0000}Die vorherige Eingabe war falsch!","Login","Abbrechen");
    return 1;
    }
    }
    case 3:
    {
    User[playerid][Geld] = cache_get_field_content_int(0,"Geld");
    User[playerid][banned] = cache_get_field_content_int(0,"banned");
    User[playerid][Bank] = cache_get_field_content_int(0,"Bank");
    User[playerid][Level] = cache_get_field_content_int(0,"Level");
    User[playerid][Adminlevel] = cache_get_field_content_int(0,"Adminlevel");
    User[playerid][Userrat] = cache_get_field_content_int(0,"Userrat");
    User[playerid][UserratLeader] = cache_get_field_content_int(0,"UserratLeader");
    User[playerid][ExistenzLeader] = cache_get_field_content_int(0,"ExistenzLeader");
    User[playerid][Existenz] = cache_get_field_content_int(0,"Existenz");
    User[playerid][CMDallow] = cache_get_field_content_int(0,"CMDallow");
    User[playerid][Werkzeugkasten] = cache_get_field_content_int(0,"Werkzeugkasten");
    User[playerid][HangarKey] = cache_get_field_content_int(0,"HangarKey");
    User[playerid][Leader] = cache_get_field_content_int(0,"Leader");
    User[playerid][Member] = cache_get_field_content_int(0,"Member");
    User[playerid][InPrison] = cache_get_field_content_int(0,"InPrison");
    User[playerid][PrisonCPsgelaufen] = cache_get_field_content_int(0,"PrisonCPsgelaufen");
    User[playerid][PrisonCPsgegeben] = cache_get_field_content_int(0,"PrisonCPsgegeben");
    User[playerid][Rang] = cache_get_field_content_int(0,"Rang");
    User[playerid][Skin] = cache_get_field_content_int(0,"Skin");
    User[playerid][Skilllevel] = cache_get_field_content_int(0,"Skilllevel");
    User[playerid][Skillpunkte] = cache_get_field_content_int(0,"Skillpunkte");
    User[playerid][ZeitzumSkillpunkt] = cache_get_field_content_int(0,"ZeitzumSkillpunkt");
    User[playerid][ZeitseidSkillpunkt] = cache_get_field_content_int(0,"ZeitseidSkillpunkt");
    SpawnPlayer(playerid);
    return 1;
    }
    default:
    {
    SendClientMessage(playerid,0xFF0000FF,"Es könnte ein Bug aufgetreten sein! Bitte reconnecten Sie!");
    SetTimerEx("KickPlayer",250,0,"i",playerid);
    return 1;
    }
    }
    return 1;
    }

    R8 ist nur die Version des Plugins, welches Plugin (von wem) verwendest du?


    Advertising has us chasing cars and clothes, working jobs we hate so we can buy shit we don’t need.
    – Tyler Durden


    Sobald Werbung im Spiel ist, bist du, die Nutzerin, der Nutzer, das Produkt.


    Dein Saven ist total Fail
    Du benutzt für alles einen neuen Query


    Du musst auch am Ende des Formats User[playerid][pName]


    Du hast 2 Faktoren und Weißt nur einen Wert zu


    Wenn du bin 16Uhr noch immer nicht drauf kommst
    Also es nicht verstehst helfe ich dir
    Weil bin am Handy ist nicht So gut