[MYSQL]Script Speichert nicht.

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
    Ja wenn ich deise Funktion aufruffe kommt unknow command und er speicherts nicht.


    stock SpielerSpeichern(playerid)
    {
    if(Login[playerid] == 1)
    {
    new waffe,ammo;
    new name[MAX_PLAYER_NAME];
    new query[4000];
    GetPlayerName(playerid,name,sizeof(name));
    format(query, 4000, "UPDATE `accounts` SET");
    format(query, 4000, "%s `Level` = '%d',",query,pDaten[playerid][Level]);
    format(query, 4000, "%s `Admin` = '%d',",query,pDaten[playerid][AdminLevel]);
    format(query, 4000, "%s `Money` = '%d',",query,pDaten[playerid][Money]);
    format(query, 4000, "%s `PKWLic` = '%d',",query,pDaten[playerid][PKWLic]);
    format(query, 4000, "%s `MOTORADLic` = '%d',",query,pDaten[playerid][MOTORADLic]);
    format(query, 4000, "%s `LKWLic` = '%d',",query,pDaten[playerid][LKWLic]);
    format(query, 4000, "%s `BUSLic` = '%d',",query,pDaten[playerid][BUSLic]);
    format(query, 4000, "%s `BOOTLic` = '%d',",query,pDaten[playerid][BOOTLic]);
    format(query, 4000, "%s `FLUGLic` = '%d',",query,pDaten[playerid][FLUGLic]);
    format(query, 4000, "%s `GunLic` = '%d',",query,pDaten[playerid][GunLic]);
    format(query, 4000, "%s `Perso` = '%d',",query,pDaten[playerid][Perso]);
    format(query, 4000, "%s `PerssoAntrag` = '%d',",query,pDaten[playerid][PerssoAntrag]);
    format(query, 4000, "%s `Respekt` = '%d',",query,pDaten[playerid][Respekt]);
    format(query, 4000, "%s `PayDayZeit` = '%d',",query,pDaten[playerid][PayDayZeit]);
    format(query, 4000, "%s `HausKey` = '%d',",query,pDaten[playerid][HausKey]);
    format(query, 4000, "%s `SpawnChanger` = '%d',",query,pDaten[playerid][SpawnChanger]);
    format(query, 4000, "%s `HausOwner` = '%d',",query,pDaten[playerid][HausOwner]);
    format(query, 4000, "%s `Leader` = '%d',",query,pDaten[playerid][Leader]);
    format(query, 4000, "%s `Member` = '%d',",query,pDaten[playerid][Member]);
    format(query, 4000, "%s `FLohn` = '%d',",query,pDaten[playerid][FLohn]);
    format(query, 4000, "%s `FRank` = '%d',",query,pDaten[playerid][FRank]);
    format(query, 4000, "%s `Skin` = '%d',",query,pDaten[playerid][Skin]);
    format(query, 4000, "%s `BizKey` = '%d',",query,pDaten[playerid][BizKey]);
    format(query, 4000, "%s `Flat` = '%d',",query,pDaten[playerid][pHFlat]);
    format(query, 4000, "%s `HCash` = '%d',",query,pDaten[playerid][pHCash]);
    format(query, 4000, "%s `HandyNr` = '%d',",query,pDaten[playerid][pHandyNr]);
    format(query, 4000, "%s `PhoneBook` = '%d',",query,pDaten[playerid][PhoneBook]);
    format(query, 4000, "%s `Handy` = '%d',",query,pDaten[playerid][pHandy]);
    format(query, 4000, "%s `Startbonus` = '%d',",query,pDaten[playerid][Startbonus]);
    format(query, 4000, "%s `Job` = '%d',",query,pDaten[playerid][Job]);
    format(query, 4000, "%s `Bank` = '%d',",query,pDaten[playerid][Bank]);
    format(query, 4000, "%s `Wanteds` = '%d',",query,pDaten[playerid][Wanteds]);
    format(query, 4000, "%s `Jailtime` = '%d',",query,pDaten[playerid][Jailtime]);
    format(query, 4000, "%s `Cuffed` = '%d',",query,pDaten[playerid][Cuffed]);
    format(query, 4000, "%s `pRoadblock` = '%d',",query,pDaten[playerid][pRoadblock]);
    format(query, 4000, "%s `Arrested` = '%d',",query,pDaten[playerid][Arrested]);
    format(query, 4000, "%s `Jailed` = '%d',",query,pDaten[playerid][Jailed]);
    format(query, 4000, "%s `FrakSperre` = '%d',",query,pDaten[playerid][FrakSperre]);
    format(query, 4000, "%s `Origin` = '%d',",query,pDaten[playerid][pOrigin]);
    format(query, 4000, "%s `Sex` = '%d',",query,pDaten[playerid][pSex]);
    format(query, 4000, "%s `Alter` = '%d',",query,pDaten[playerid][pAge]);
    format(query, 4000, "%s `Warns` = '%d',",query,pDaten[playerid][Warns]);
    format(query, 4000, "%s `LoginZeit` = '%d',",query,pDaten[playerid][LoginZeit]);
    format(query, 4000, "%s `Kills` = '%d',",query,pDaten[playerid][Kills]);
    format(query, 4000, "%s `Death` = '%d',",query,pDaten[playerid][Death]);
    format(query, 4000, "%s `pHeadValue` = '%d',",query,pDaten[playerid][pHeadValue]);
    format(query, 4000, "%s `Tutorial` = '%d',",query,pDaten[playerid][Tutorial]);
    format(query, 4000, "%s `pSHealth` = '%d',",query,pDaten[playerid][pSHealth]);
    format(query, 4000, "%s `gPupgrade` = '%d',",query,pDaten[playerid][gPupgrade]);
    format(query, 4000, "%s `pAlcoholPerk` = '%d',",query,pDaten[playerid][pAlcoholPerk]);
    format(query, 4000, "%s `Harndrang` = '%d',",query,pDaten[playerid][Harndrang]);
    format(query, 4000, "%s `Essen` = '%d',",query,pDaten[playerid][Essen]);
    format(query, 4000, "%s `pMechSkill` = '%d',",query,pDaten[playerid][pMechSkill]);
    format(query, 4000, "%s `pNewsSkill` = '%d',",query,pDaten[playerid][pNewsSkill]);
    format(query, 4000, "%s `pMats` = '%d',",query,pDaten[playerid][pMats]);
    format(query, 4000, "%s `pDrugs` = '%d',",query,pDaten[playerid][pDrugs]);
    format(query, 4000, "%s `pDrugPerk` = '%d',",query,pDaten[playerid][pDrugPerk]);
    format(query, 4000, "%s `pDrugsSkill` = '%d',",query,pDaten[playerid][pDrugsSkill]);
    format(query, 4000, "%s `pSexSkill` = '%d',",query,pDaten[playerid][pSexSkill]);
    format(query, 4000, "%s `pCarTime` = '%d',",query,pDaten[playerid][pCarTime]);
    format(query, 4000, "%s `pJackSkill` = '%d',",query,pDaten[playerid][pJackSkill]);
    format(query, 4000, "%s `pDetSkill` = '%d',",query,pDaten[playerid][pDetSkill]);
    format(query, 4000, "%s `pWins` = '%d',",query,pDaten[playerid][pWins]);
    format(query, 4000, "%s `pLoses` = '%d',",query,pDaten[playerid][pLoses]);
    format(query, 4000, "%s `pBoxSkill` = '%d',",query,pDaten[playerid][pBoxSkill]);
    format(query, 4000, "%s `pMarried` = '%d',",query,pDaten[playerid][pMarried]);
    format(query, 4000, "%s `pMarriedTo` = '%s',",query,pDaten[playerid][pMarriedTo]);
    format(query, 4000, "%s `Premium` = '%d',",query,pDaten[playerid][PremiumPunkte]);
    format(query, 4000, "%s `PremiumAutos` = '%d',",query,pDaten[playerid][PremiumAutos]);
    format(query, 4000, "%s `PremiumLaser` = '%d',",query,pDaten[playerid][PremiumLaser]);
    format(query, 4000, "%s `PremiumFulllife` = '%d',",query,pDaten[playerid][PremiumFulllife]);
    format(query, 4000, "%s `PremiumRespekt` = '%d',",query,pDaten[playerid][PremiumRespekt]);
    format(query, 4000, "%s `PremiumZinsen` = '%d',",query,pDaten[playerid][PremiumZinsen]);
    format(query, 4000, "%s `PremiumGhost` = '%d',",query,pDaten[playerid][PremiumGhost]);
    format(query, 4000, "%s `PremiumTempo` = '%d',",query,pDaten[playerid][PremiumTempo]);
    format(query, 4000, "%s `FlensPunkteDriving` = '%d',",query,pDaten[playerid][FlensPunkteDriving]);
    format(query, 4000, "%s `FlensPunkteMot` = '%d',",query,pDaten[playerid][FlensPunkteMot]);
    format(query, 4000, "%s `FlensPunkteFly` = '%d',",query,pDaten[playerid][FlensPunkteFly]);
    format(query, 4000, "%s `Banned` = '%d',",query,pDaten[playerid][Banned]);
    GetPlayerWeaponData(playerid,0,waffe,ammo);
    format(query, 4000, "%s `wslot` = '%d',",query,waffe);
    format(query, 4000, "%s `aslot` = '%d',",query,ammo);
    GetPlayerWeaponData(playerid,1,waffe,ammo);
    format(query, 4000, "%s `wslot1` = '%d',",query,waffe);
    format(query, 4000, "%s `aslot1` = '%d',",query,ammo);
    GetPlayerWeaponData(playerid,2,waffe,ammo);
    format(query, 4000, "%s `wslot2` = '%d',",query,waffe);
    format(query, 4000, "%s `aslot2` = '%d',",query,ammo);
    GetPlayerWeaponData(playerid,3,waffe,ammo);
    format(query, 4000, "%s `wslot3` = '%d',",query,waffe);
    format(query, 4000, "%s `aslot3` = '%d',",query,ammo);
    GetPlayerWeaponData(playerid,4,waffe,ammo);
    format(query, 4000, "%s `wslot4` = '%d',",query,waffe);
    format(query, 4000, "%s `aslot4` = '%d',",query,ammo);
    GetPlayerWeaponData(playerid,5,waffe,ammo);
    format(query, 4000, "%s `wslot5` = '%d',",query,waffe);
    format(query, 4000, "%s `aslot5` = '%d',",query,ammo);
    GetPlayerWeaponData(playerid,6,waffe,ammo);
    format(query, 4000, "%s `wslot6` = '%d',",query,waffe);
    format(query, 4000, "%s `aslot6` = '%d',",query,ammo);
    GetPlayerWeaponData(playerid,7,waffe,ammo);
    format(query, 4000, "%s `wslot7` = '%d',",query,waffe);
    format(query, 4000, "%s `aslot7` = '%d',",query,ammo);
    GetPlayerWeaponData(playerid,8,waffe,ammo);
    format(query, 4000, "%s `wslot8` = '%d',",query,waffe);
    format(query, 4000, "%s `aslot8` = '%d',",query,ammo);
    GetPlayerWeaponData(playerid,9,waffe,ammo);
    format(query, 4000, "%s `wslot9` = '%d',",query,waffe);
    format(query, 4000, "%s `aslot9` = '%d',",query,ammo);
    GetPlayerWeaponData(playerid,10,waffe,ammo);
    format(query, 4000, "%s `wslot10` = '%d',",query,waffe);
    format(query, 4000, "%s `aslot10` = '%d',",query,ammo);
    GetPlayerWeaponData(playerid,11,waffe,ammo);
    format(query, 4000, "%s `wslot11` = '%d',",query,waffe);
    format(query, 4000, "%s `aslot11` = '%d'",query,ammo);
    format(query, 4000, "%s WHERE `Name` = '%s'",query,name);
    mysql_query(query);
    }
    }Ich wollte mal den User nur mit 1Query speichern und nicht mit 105 pro spieler