Spieler werden nicht richtig gespeichert.

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
  • Hallo,


    hab leider wieder ein Problem :(


    Unzwar werden die Spieleraccounts nicht richtig gespeichert, also das Passwort wird gespeichert und man wird auch gespawnt nur leider wird das Restliche (Geschlecht,Position,etc) nicht gespeichert also wenn man reloggt, fängt man nach der Passwort Eingabe wieder an die Daten(Geschlecht,Alter,etc) anzugeben.


    Um selber ein Bild zu machen was ich genau meine:


    Zu den Server -> //Ist keine "Werbung"Hoffe ihr könnt mir helfen



    LG Trabuhot :)

  • Spieler Speichern:

    Spoiler anzeigen

    if(!IsPlayerNPC(playerid) && SpielerInfo[playerid][sEingeloggt]){
    GetPlayerPos(playerid,SpielerInfo[playerid][sLogoutPos][0],SpielerInfo[playerid][sLogoutPos][1],SpielerInfo[playerid][sLogoutPos][2]);
    MySQLCheckConnection();
    new Float:lx,Float:ly,Float:lz,Float:la;
    GetPlayerPos(playerid,lx,ly,lz);
    GetPlayerFacingAngle(playerid,la);
    new Query[2048];
    format(Query,sizeof(Query),"UPDATE `accounts` SET `Ausgeloggt`='%d',`IpAdresse`='%s',`Adminlevel`='%d',`Helper`='%d',`Verwarnungen`='%d',`Premium`='%d',`Spielzeit`='%d',`Geschlecht`='%d',`Level`='%d',`Tutorial`='%d',`Aussehen`='%d',`Geld`='%d',`Bank`='%d',`Telefon`='%d',`Telefonnummer`='%d',`Telefonbuch`='%d',`Klingelton`='%d',`Personalausweis`='%d',`PersonalausweisAntrag`='%d',`Arbeitslos`='%d',`ArbeitslosAntrag`='%d',`Job`='%d',`Jobzeit`='%d',",
    gettime(),
    SpielerInfo[playerid][sIp],
    SpielerInfo[playerid][sAdminlevel],
    SpielerInfo[playerid][sWarns],
    SpielerInfo[playerid][sPremium],
    SpielerInfo[playerid][sSpielzeit],
    SpielerInfo[playerid][sGeschlecht],
    SpielerInfo[playerid][sLevel],
    SpielerInfo[playerid][sTutorial],
    SpielerInfo[playerid][sSkin],
    GetPlayerMoney(playerid),
    SpielerInfo[playerid][sBank],
    SpielerInfo[playerid][sTelefon],
    SpielerInfo[playerid][sTelefonnummer],
    SpielerInfo[playerid][sTelefonbuch],
    SpielerInfo[playerid][sKlingelton],
    SpielerInfo[playerid][sPerso],
    SpielerInfo[playerid][sPersoAntrag],
    SpielerInfo[playerid][sArbeitslos],
    SpielerInfo[playerid][sArbeitslosAntrag],
    SpielerInfo[playerid][sJob],
    SpielerInfo[playerid][sLastJob]);

    Spoiler anzeigen
    format(Query,sizeof(Query),"%s`Fahrlizenz`='%d',`Angellizenz`='%d',`FahrlizenzSperre`='%d',`Fluglizenz`='%d',`FluglizenzSperre`='%d',`Lastkraftwagenlizenz`='%d',`LastkraftwagenlizenzSperre`='%d',`Motorradlizenz`='%d',`MotorradlizenzSperre`='%d',`Schifffahrtslizenz`='%d',`SchifffahrtslizenzSperre`='%d',`Waffenlizenz`='%d',`WaffenlizenzSperre`='%d',",
    Query,
    SpielerInfo[playerid][sFahrlizenz],
    SpielerInfo[playerid][sAngellizenz],
    SpielerInfo[playerid][sFahrlizenzLock],
    SpielerInfo[playerid][sFlyLic],
    SpielerInfo[playerid][sFlyLicLock],
    SpielerInfo[playerid][sLKWLic],
    SpielerInfo[playerid][sLKWLicLock],
    SpielerInfo[playerid][sBikeLic],
    SpielerInfo[playerid][sBikeLicLock],
    SpielerInfo[playerid][sBoatLic],
    SpielerInfo[playerid][sBoatLicLock],
    SpielerInfo[playerid][sWeaponLic],
    SpielerInfo[playerid][sWeaponLicLock]);

    Spoiler anzeigen
    format(Query,sizeof(Query),"%s`Gehalt`='%d',`Fraktion`='%d',`Fraktionssperre`='%d',`Boss`='%d',`Rang`='%d',`Strafpunkte`='%d',`PaydayZeit`='%d',`Respektpunkte`='%d',`Fischskill`='%d',`SaveMats`='%d',`SaveDrogen`='%d',`Mats`='%d',`Bmod`='%d',`Coints`='%d',`Ticketsopen`='%d',`Drogen`='%d',",
    Query,
    SpielerInfo[playerid][sGehalt],
    SpielerInfo[playerid][sFraktion],
    SpielerInfo[playerid][sInviteLock],
    SpielerInfo[playerid][sBoss],
    SpielerInfo[playerid][sRang],
    SpielerInfo[playerid][sPunkte],
    SpielerInfo[playerid][sPaydayZeit],
    SpielerInfo[playerid][sRespektpunkte],
    SpielerInfo[playerid][sFishSkill],
    SpielerInfo[playerid][sSaveMats],
    SpielerInfo[playerid][sSaveDrogen],
    SpielerInfo[playerid][sMats],
    SpielerInfo[playerid][sBmod],
    SpielerInfo[playerid][sCoints],
    SpielerInfo[playerid][sTicketsopen],
    SpielerInfo[playerid][sDrogen]);

    Spoiler anzeigen
    format(Query,sizeof(Query),"%s`Krankenhaus`='%d',`Friedhof`='%d',`TotX`='%f',`TotY`='%f',`TotZ`='%f',`Tode`='%d',`LogoutX`='%f',`LogoutY`='%f',`LogoutZ`='%f',`Fische`='%d',`Haus`='%d',`Spawn`='%d',`Morde`='%d',`Kills`='%d',`Verbrechen`='%d',`Wantedlevel`='%d',`Knast`='%d',`KnastZeit`='%d',`posX`='%f',`posY`='%f',`posZ`='%f',`posA`='%f' WHERE `Spielername`='%s'",
    Query,
    SpielerInfo[playerid][sKrankenhaus],
    SpielerInfo[playerid][sFriedhof],
    SpielerInfo[playerid][sTx],
    SpielerInfo[playerid][sTy],
    SpielerInfo[playerid][sTz],
    SpielerInfo[playerid][sTode],
    SpielerInfo[playerid][sLogoutPos][0],
    SpielerInfo[playerid][sLogoutPos][1],
    SpielerInfo[playerid][sLogoutPos][2],
    SpielerInfo[playerid][sFishes],
    SpielerInfo[playerid][sHaus],
    SpielerInfo[playerid][sSpawn],
    SpielerInfo[playerid][sMorde],
    SpielerInfo[playerid][sKills],
    SpielerInfo[playerid][sVerbrechen],
    SpielerInfo[playerid][sWantedlevel],
    SpielerInfo[playerid][sGefangen],
    SpielerInfo[playerid][sGefangenZeit],
    lx,
    ly,
    lz,
    la,
    SpielerInfo[playerid][sName]);
    mysql_query(Query);
    return 1;
    }
    return 0;
    }


    Ausschnicht aus den MySQL Log:

    Spoiler anzeigen
    [Sat Jun 6 16:41:26 2015] -------------------------
    [Sat Jun 6 16:41:26 2015] Logging Started
    [Sat Jun 6 16:41:26 2015] -------------------------
    [Sat Jun 6 16:44:31 2015] -------------------------
    [Sat Jun 6 16:44:31 2015] Logging Started
    [Sat Jun 6 16:44:31 2015] -------------------------
    [Sat Jun 6 16:50:01 2015] -------------------------
    [Sat Jun 6 16:50:01 2015] Logging Started
    [Sat Jun 6 16:50:01 2015] -------------------------
    [Sat Jun 6 16:51:13 2015] -------------------------
    [Sat Jun 6 16:51:13 2015] Logging Started
    [Sat Jun 6 16:51:13 2015] -------------------------
    [Sat Jun 6 16:51:13 2015] Connected (0) to zrlserver @ 134.255.220.143 via TCP/IP.
    [Sat Jun 6 16:51:13 2015] MySQL Server Version 5.5.41-0+wheezy1.
    [Sat Jun 6 16:53:23 2015] -------------------------
    [Sat Jun 6 16:53:23 2015] Logging Started
    [Sat Jun 6 16:53:23 2015] -------------------------
    [Sat Jun 6 16:53:23 2015] Connected (0) to zrlserver @ 134.255.220.143 via TCP/IP.
    [Sat Jun 6 16:53:23 2015] MySQL Server Version 5.5.41-0+wheezy1.
    [Sat Jun 6 17:39:37 2015] -------------------------
    [Sat Jun 6 17:39:37 2015] Logging Started
    [Sat Jun 6 17:39:37 2015] -------------------------
    [Sat Jun 6 17:40:28 2015] -------------------------
    [Sat Jun 6 17:40:28 2015] Logging Started
    [Sat Jun 6 17:40:28 2015] -------------------------
    [Sun Jun 7 12:47:24 2015] -------------------------
    [Sun Jun 7 12:47:24 2015] Logging Started
    [Sun Jun 7 12:47:24 2015] -------------------------
    [Sun Jun 7 13:26:59 2015] -------------------------
    [Sun Jun 7 13:26:59 2015] Logging Started
    [Sun Jun 7 13:26:59 2015] -------------------------
    [Sun Jun 7 13:27:22 2015] -------------------------
    [Sun Jun 7 13:27:22 2015] Logging Started
    [Sun Jun 7 13:27:22 2015] -------------------------
    [Sun Jun 7 13:28:19 2015] -------------------------
    [Sun Jun 7 13:28:19 2015] Logging Started
    [Sun Jun 7 13:28:19 2015] -------------------------
    [Sun Jun 7 13:30:07 2015] -------------------------
    [Sun Jun 7 13:30:07 2015] Logging Started
    [Sun Jun 7 13:30:07 2015] -------------------------
    [Sun Jun 7 13:30:57 2015] -------------------------
    [Sun Jun 7 13:30:57 2015] Logging Started
    [Sun Jun 7 13:30:57 2015] -------------------------
    [Sun Jun 7 13:32:32 2015] -------------------------
    [Sun Jun 7 13:32:32 2015] Logging Started
    [Sun Jun 7 13:32:32 2015] -------------------------
    [Sun Jun 7 13:33:58 2015] -------------------------
    [Sun Jun 7 13:33:58 2015] Logging Started
    [Sun Jun 7 13:33:58 2015] -------------------------
    [Sun Jun 7 13:37:05 2015] -------------------------
    [Sun Jun 7 13:37:05 2015] Logging Started
    [Sun Jun 7 13:37:05 2015] -------------------------
    [Sun Jun 7 13:52:49 2015] -------------------------
    [Sun Jun 7 13:52:49 2015] Logging Started
    [Sun Jun 7 13:52:49 2015] -------------------------
    [Sun Jun 7 13:52:49 2015] Connected (0) to zrlserver @ 134.255.220.143 via TCP/IP.
    [Sun Jun 7 13:52:49 2015] MySQL Server Version 5.5.41-0+wheezy1.
    [Sun Jun 7 14:02:31 2015] -------------------------
    [Sun Jun 7 14:02:31 2015] Logging Started
    [Sun Jun 7 14:02:31 2015] -------------------------
    [Sun Jun 7 14:02:31 2015] Connected (0) to zrlserver @ 134.255.220.143 via TCP/IP.
    [Sun Jun 7 14:02:31 2015] MySQL Server Version 5.5.41-0+wheezy1.
    [Sun Jun 7 14:48:24 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Sun Jun 7 14:49:34 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Sun Jun 7 14:49:57 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Sun Jun 7 14:51:09 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Sun Jun 7 14:52:27 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Sun Jun 7 14:52:27 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Sun Jun 7 14:52:27 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Sun Jun 7 14:52:27 2015] MySQL closed. Logging ended.
    [Sun Jun 7 14:52:38 2015] Connected (0) to zrlserver @ 134.255.220.143 via TCP/IP.
    [Sun Jun 7 14:52:38 2015] MySQL Server Version 5.5.41-0+wheezy1.
    [Sun Jun 7 15:04:28 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Sun Jun 7 15:05:18 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Sun Jun 7 15:08:45 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Sun Jun 7 15:10:29 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Sun Jun 7 15:18:57 2015] -------------------------
    [Sun Jun 7 15:18:57 2015] Logging Started
    [Sun Jun 7 15:18:57 2015] -------------------------
    [Sun Jun 7 15:18:57 2015] Connected (0) to zrlserver @ 134.255.220.143 via TCP/IP.
    [Sun Jun 7 15:18:57 2015] MySQL Server Version 5.5.41-0+wheezy1.
    [Sun Jun 7 15:20:48 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Sun Jun 7 15:23:05 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Sun Jun 7 15:26:26 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Sun Jun 7 16:47:49 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Sun Jun 7 16:47:55 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Sun Jun 7 18:47:34 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Sun Jun 7 19:00:29 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Mon Jun 8 00:00:26 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Mon Jun 8 02:15:37 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Mon Jun 8 08:15:04 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Mon Jun 8 13:52:50 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Mon Jun 8 13:54:55 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Mon Jun 8 13:59:37 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Mon Jun 8 14:15:16 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Mon Jun 8 14:18:05 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Mon Jun 8 14:19:06 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Mon Jun 8 14:19:09 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Mon Jun 8 14:24:14 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Mon Jun 8 14:32:03 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Mon Jun 8 14:32:33 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Mon Jun 8 14:42:40 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Mon Jun 8 14:50:52 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Tue Jun 9 07:16:12 2015] MySQL closed. Logging ended.
    [Tue Jun 9 07:16:12 2015] Connected (0) to zrlserver @ 134.255.220.143 via TCP/IP.
    [Tue Jun 9 07:16:12 2015] MySQL Server Version 5.5.41-0+wheezy1.
    [Tue Jun 9 07:18:05 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Tue Jun 9 11:10:56 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Tue Jun 9 11:15:43 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Tue Jun 9 11:17:01 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Tue Jun 9 11:33:19 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Tue Jun 9 12:45:10 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.
    [Tue Jun 9 12:46:54 2015] Error (0): Failed to exeute query. Unknown column 'Helper' in 'field list'.