Guten Tag liebe Community,
Ich bekomme beim Updaten meines Accounts folgende Fehlermeldung:
(Nur den Error kopiert)
SQL
(Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Char=0,Level=1,FSPunkte=0,Admin=0,Premium=0,UpgradePoints=0,ConnectedTime=0,Regi' at line 1)
An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Int=0,Local=255,Team=3,Model=264,Telefonnummer=5774,Haus=255,Bizz=255,Handygutha' at line 1)So sieht mein Stock SaveAccount aus:
SQL
format(query,sizeof(query),"UPDATE `accounts` SET pHealth=%f,pSHealth=%f,GWD=%f,Pos_x=%f,Pos_y=%f,Pos_z=%f,EMail='%s',IP='%s',Bargeld=%d,Member=%d,FMember=%d,Rank=%d,Char=%d,",
PlayerInfo[playerid][pHealth],PlayerInfo[playerid][pSHealth],PlayerInfo[playerid][pGWD],PlayerInfo[playerid][pPos_x],PlayerInfo[playerid][pPos_y],PlayerInfo[playerid][pPos_z],PlayerInfo[playerid][sEmail],
PlayerInfo[playerid][pIPAdresse],GetPlayerMoney(playerid),PlayerInfo[playerid][pMember],PlayerInfo[playerid][pFMember],PlayerInfo[playerid][pRank],PlayerInfo[playerid][pChar]);
strcat(mainquery,query);
strdel(query,0,sizeof(query));
format(query,sizeof(query),"Level=%d,FSPunkte=%d,Admin=%d,Premium=%d,UpgradePoints=%d,ConnectedTime=%d,Registriert=%d,Geschlecht=%d,Alter=%d,Origin=%d,CK=%d,Mute=%d,",
PlayerInfo[playerid][pLevel],PlayerInfo[playerid][FSPunkte],PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pDonateRank],PlayerInfo[playerid][gPupgrade],PlayerInfo[playerid][pConnectTime],PlayerInfo[playerid][pReg],
PlayerInfo[playerid][pSex],PlayerInfo[playerid][pAge],PlayerInfo[playerid][pOrigin],PlayerInfo[playerid][pCK],PlayerInfo[playerid][pMuted]);
strcat(mainquery,query);
strdel(query,0,sizeof(query));
format(query,sizeof(query),"Respektpunkte=%d,Bankguthaben=%d,Kredit=%d,KreditDauer=%d,Crimes=%d,Kills=%d,Tode=%d,Knast=%d,Arrested=%d,Knastbesuche=%d,Telefonbuch=%d,Lottozahl=%d,",
PlayerInfo[playerid][pExp],PlayerInfo[playerid][pAccount],PlayerInfo[playerid][pPlayerKredit],PlayerInfo[playerid][pPlayerKreditDauer],PlayerInfo[playerid][pCrimes],PlayerInfo[playerid][pKills],PlayerInfo[playerid][pDeaths],
Knast[playerid],PlayerInfo[playerid][pArrested],PlayerInfo[playerid][pWantedDeaths],PlayerInfo[playerid][pPhoneBook],PlayerInfo[playerid][pLottoNr]);
strcat(mainquery,query);
strdel(query,0,sizeof(query));
format(query,sizeof(query),"Fische=%d,BiggestFish=%d,Job=%d,PayCheck=%d,HeadValue=%d,Jailed=%d,Gangknast=%d,Mauled=%d,Knastzeit=%d,Materialien=%d,Drogen=%d,BoxMaterialien=%d,BoxDrogen=%d,Kampfstyle=%d,Leader=%d WHERE Name='%s'",
PlayerInfo[playerid][pFishes],PlayerInfo[playerid][pBiggestFish],PlayerInfo[playerid][pJob],PlayerInfo[playerid][pPayCheck],PlayerInfo[playerid][pHeadValue],PlayerInfo[playerid][pJailed],PlayerInfo[playerid][pGangJailed],PlayerInfo[playerid][pMauled],
PlayerInfo[playerid][pJailTime],PlayerInfo[playerid][pMats],PlayerInfo[playerid][pDrugs],PlayerInfo[playerid][pBoxMats],PlayerInfo[playerid][pBoxDrugs],GetPlayerFightingStyle(playerid),PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pSName]);
strcat(mainquery,query);
strdel(query,0,sizeof(query));
mysql_query(mainquery);
strdel(mainquery,0,sizeof(mainquery));
