Mysql System.

die ersten fehler die ich sehe sind wie du beschrieben hast:

C:\Users\Patrick\Desktop\IRP-City\gamemodes\T2R.pwn(15696) : error 017: undefined symbol "UPDATE"
C:\Users\Patrick\Desktop\IRP-City\gamemodes\T2R.pwn(15696) : error 017: undefined symbol "players"

das sind einfach symbole die du nicht definiert hast.

Fehler busted

GetPlayerName(playerid, pmaname, sizeof(pmaname);

zu

GetPlayerName(playerid, pmaname, sizeof(pmaname));

zu

Zitat

Jeffry: Vielleicht xD

Immer diese Fanboys die sich auf Jeffry fixieren... hier gibt es auch andere Leute die was drauf haben.

mfg

stock SpielerSpeichern(playerid)
{
new query[2048], pmaname[MAX_PLAYER_NAME];
GetPlayerName(playerid, pmaname, sizeof(pmaname));
if(IsPlayerConnected(playerid)) return 1;//15695
format(query, sizeof(query), "UPDATE players SET username='%s',password='%s',Level='%d',Adminlevel='%d',DonateRank='%d',UpgradePoints='%d',ConnectedTime='%d',Registered='%d',Sex='%d',Age='%d',Origin='%d',Muted='%d',Respect='%d',Money='%d',Bank='%d',Crimes='%d',",
PlayerInfo[playerid][pKey],PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pDonateRank],PlayerInfo[playerid][gPugrade],PlayerInfo[playerid][pConnectTime],PlayerInfo[playerid][pReg],
PlayerInfo[playerid][pSex],PlayerInfo[playerid][pAge],PlayerInfo[playerid][pOrigin],PlayerInfo[playerid][pMuted],PlayerInfo[playerid][pExp],PlayerInfo[playerid][pCash],PlayerInfo[playerid][pBank],PlayerInfo[playerid][pCrimes]);

format(query, sizeof(query), "%sKills='%d',Deaths='%d',Arrested='%d',WantedDeaths='%d',Phonebook='%d',LottoNr='%d',Fishes='%d',BiggestFish='%d',Job='%d',Paycheck='%d',Jailed='%d',GangJailed='%d',Mauled='%d',Jailtime='%d',Materials='%d',Drugs='%d',",query,
PlayerInfo[playerid][pKills],PlayerInfo[playerid][pDeaths],PlayerInfo[playerid][pArrested],PlayerInfo[playerid][pWantedDeaths],PlayerInfo[playerid][pPhoneBook],PlayerInfo[playerid][pLottoNr],PlayerInfo[playerid][pFishes],PlayerInfo[playerid][pBiggestFish],
PlayerInfo[playerid][pJob],PlayerInfo[playerid][pPayCheck],PlayerInfo[playerid][pJailed],PlayerInfo[playerid][pGangJailed],PlayerInfo[playerid][pMauled],PlayerInfo[playerid][pJailTime],PlayerInfo[playerid][pMaterials],PlayerInfo[playerid][pDrugs]);

format(query, sizeof(query), "%sCokain='%d',nonworkedcocain='%d',BoxMaterials='%d',BoxDrugs='%d',FightingStyle='%d',Char='%d',ContractTime='%d',DetSkill='%d',SexSkill='%d',BoxSkill='%d',LawSkill='%d',MechSkill='%d',JackSkill='%d',CarSkill='%d',",query,
PlayerInfo[playerid][pKokain],PlayerInfo[playerid][pUnverarbeitetesKokain],PlayerInfo[playerid][pBoxMats],PlayerInfo[playerid][pBoxDrugs],GetPlayerFightingStyle(playerid),PlayerInfo[playerid][pChar],PlayerInfo[playerid][pContractTime],
PlayerInfo[playerid][pDetSkill],PlayerInfo[playerid][pSexSkill],PlayerInfo[playerid][pBoxSkill],PlayerInfo[playerid][pLawSkill],PlayerInfo[playerid][pMechSkill],PlayerInfo[playerid][pJackSkill],PlayerInfo[playerid][pCarSkill]);

format(query, sizeof(query), "%sNewsSkill='%d',DrugsSkill='%d',CookSkill='%d',FishSkill='%d',pSHealth='%f',pHealth='%f',Int='%d',Local='%d',Team='%d',Model='%d',GWD='%f',PhoneNr='%d',House='%d',Bizz='%d',HandyGeld='%d',HandyVer='%d',Pos_x='%f',",query,
PlayerInfo[playerid][pNewsSkill],PlayerInfo[playerid][pCookSkill],PlayerInfo[playerid][pFishSkill],PlayerInfo[playerid][pCookSkill],PlayerInfo[playerid][pFishSkill],PlayerInfo[playerid][pSHealth],PlayerInfo[playerid][pHealth],PlayerInfo[playerid][pInt],
PlayerInfo[playerid][pLocal],PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pModel],PlayerInfo[playerid][pPnumber],PlayerInfo[playerid][pPhousekey],PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pGWD],PlayerInfo[playerid][pHandyGeld],PlayerInfo[playerid][pHandyVer],PlayerInfo[playerid][pPos_x]);

format(query, sizeof(query), "%sPos_y='%f',Pos_z='%f',CarLic='%d',NewLic='%d',FlyLic='%d',BoatLic='%d',FishLic='%d',GunLic='%d',LKWLic='%d',RollerLic='%d', MotoLic='%d',SchwarzmarktLic='%d',KopfgeldSumme='%d',Kopfgeld='%d',Zig='%d',Kekse='%d',",query,
PlayerInfo[playerid][pPos_y],PlayerInfo[playerid][pPos_z],PlayerInfo[playerid][pCarLic],PlayerInfo[playerid][pNewLic],PlayerInfo[playerid][pFlyLic],PlayerInfo[playerid][pBoatLic],PlayerInfo[playerid][pFishLic],PlayerInfo[playerid][pGunLic],
PlayerInfo[playerid][pLKWLic],PlayerInfo[playerid][pRollerLic],PlayerInfo[playerid][pMotoLic],PlayerInfo[playerid][pZig],PlayerInfo[playerid][pKekse]);

format(query, sizeof(query), "%sZigSucht='%d',Gun1='%d',Gun2='%d',Gun3='%d',Gun4='%d',Ammo1='%d',Ammo2='%d',Ammo3='%d',Ammo4='%d',CarTime='%d',Mulltime='%d',PayDay='%d',PayDayHad='%d',CDPlayer='%d',Wins='%d',Loses='%d',AlcoholPerk='%d',",query,
PlayerInfo[playerid][pZigSucht],PlayerInfo[playerid][pGun1],PlayerInfo[playerid][pGun2],PlayerInfo[playerid][pGun3],PlayerInfo[playerid][pGun4],PlayerInfo[playerid][pAmmo1],PlayerInfo[playerid][pAmmo2],PlayerInfo[playerid][pAmmo3],PlayerInfo[playerid][pAmmo4],
PlayerInfo[playerid][pCarTime],PlayerInfo[playerid][pMulltime],PlayerInfo[playerid][pPayDay],PlayerInfo[playerid][pPayDayHad],PlayerInfo[playerid][pCDPlayer],PlayerInfo[playerid][pWins],PlayerInfo[playerid][pLoses]);

format(query, sizeof(query), "%sDrugPerk='%d',MiserPerk='%d',PainPerk='%d',TraderPerk='%d',Tutorial='%d',Warnings='%d',Adjustable='%d',Fuel='%d',Married='%d',MarriedTo='%s',SpawnChange='%d',WantedLevel='%d',WantedPoints='%d',PlayMinutes='%d',",query,
PlayerInfo[playerid][pAlcoholPerk],PlayerInfo[playerid][pDrugPerk],PlayerInfo[playerid][pMiserPerk],PlayerInfo[playerid][pPainPerk],PlayerInfo[playerid][pTraderPerk],PlayerInfo[playerid][pTut],PlayerInfo[playerid][pWarns],PlayerInfo[playerid][pAdjustable],
PlayerInfo[playerid][pFuel],PlayerInfo[playerid][pMarried],PlayerInfo[playerid][pMarriedTo],SpawnChange[playerid],WantedLevel[playerid],WantedPoints[playerid],PlayerInfo[playerid][pPlayMinutes]);

format(query, sizeof(query), "%sGesamtMinutes='%d',MinutesSinceAn='%d',SFPASS='%d',LSVPASS='%d',Offflucht='%d',Knast='%d',Uhr='%d',Handy='%d',KnastTime='%d',Perso='%d',FrakSperre='%d',Gehalt='%d',InvWeapon='%d',InvAmmo='%d',InvWeapon2='%d',",query,
PlayerInfo[playerid][pGesamtMinutes],PlayerInfo[playerid][pMinutesSinceAn],PlayerInfo[playerid][pSFPASS],PlayerInfo[playerid][pLVPASS],OfflineFlucht[playerid],Knast[playerid],PlayerInfo[playerid][pUhrID],PlayerInfo[playerid][pHandyID],
KnastTime[playerid],PlayerInfo[playerid][pOwnPerso],PlayerInfo[playerid][pFrakSperre],PlayerInfo[playerid][pGehalt],PlayerInfo[playerid][pInWeapon],PlayerInfo[playerid][pInvAmmo],PlayerInfo[playerid][pInvWeapon2]);

format(query, sizeof(query), "%sInvAmmo2='%d',InvMats='%d',InvDrugs='%d',FlugTime='%d',FarmTime='%d',GDeaths='%d',GKills='%d',Meldung='%d',Tanke='%d',Zollpass='%d',ZollpassTime='%d',Gesperrt='%d',waffenslot1='%d',ammoslot1='%d',waffenslot2='%d',",query,
PlayerInfo[playerid][pInvAmmo2],PlayerInfo[playerid][pInvMats],PlayerInfo[playerid][pInvDrugs],PlayerInfo[playerid][pFlugTime],PlayerInfo[playerid][pFarmTime],PlayerInfo[playerid][pGDeaths],PlayerInfo[playerid][pGKills],PlayerInfo[playerid][pMeldung],
PlayerInfo[playerid][pPtankekey],PlayerInfo[playerid][pZollPass],PlayerInfo[playerid][pZollPassTime],PlayerInfo[playerid][pGesperrt]);

format(query, sizeof(query), "%sammoslot2='%d',waffenslot3='%d',ammoslot3='%d', waffenslot4='%d',ammoslot4='%d',waffenslot5='%d',ammoslot5='%d',waffenslot6='%d',ammoslot6='%d',waffenslot7='%d',ammoslot7='%d',waffenslot8='%d',ammoslot8='%d',",query);

format(query, sizeof(query), "%swaffenslot9='%d',ammoslot9='%d',waffenslot10='%d',ammoslot10='%d',waffenslot11='%d',ammoslot11='%d',waffenslot12='%d',ammoslot12='%d',waffenslot13='%d',ammoslot13='%d' WHERE username='%s'",query, /*hier fehlen noch viele*/, pmaname);

mysql_tquery(mysqlHandle, query);
printf("Acc gespeichert (%s)",NamePlayer(playerid));
return 1;
}

ABER!
Das wird so noch nicht funktionieren, da bei den Spieler-Variablen hinter dem Format jeweils noch eine Menge fehlen, oft auch zwischendrin fehlt mal eine. Das musst du selbst prüfen.
Vor allem die letzten drei Zeilen sind extrem.