Hallo,
ich habe ein Problem, undzwar speichert sich bei mir nicht alles richtig wenn ich mich registriere.
Fehler in der MySQL Datei:
PHP
[02:55:29] [ERROR] CMySQLQuery::Execute[OnPlayerRegister(i)] - (error #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 '' at line 1Spielerspeichern:
PHP
stock SpielerSpeichern(playerid)
{
if(GetPVarInt(playerid,"loggedin")==1)
{
new query[3072];
format(query, sizeof(query), "UPDATE users SET jahre='%i',Personalausweis='%i',Spawnchange='%i',Geld='%i',Admin='%i',Skin='%i',Hunger='%i',Toilette='%i',Fraktionsrang='%i',Leader='%i',Member='%i',Arbeit='%i',Navigation='%i',Premium='%i',Handynummer='%i',Fraktion='%i',Registration='%i',BankKonto='%i',BankGeld='%i',BankRauben='%i',Level='%i',Respektpunkte='%i',MinutesSinceAn='%i',PlayMinutes='%i',Warnungen='%i',Points='%i',Gesamtspielzeit='%i',Tode='%i', WHERE id='%i'",
pInfo[playerid][pAlter],pInfo[playerid][pPerso],pInfo[playerid],GetPlayerMoney(playerid),pInfo[playerid][pAdmin],pInfo[playerid][pSkin],pInfo[playerid][pHunger],pInfo[playerid][pHarndrang],pInfo[playerid][pRank],pInfo[playerid][pLeader],pInfo[playerid][pMember],pInfo[playerid][pJob],pInfo[playerid][pNavi],pInfo[playerid][pPremium],
pInfo[playerid][pHandynummer],pInfo[playerid][pFraktion],pInfo[playerid][pReg],pInfo[playerid][pBankKonto],pInfo[playerid][pBankGeld],pInfo[playerid][pBankRauben],pInfo[playerid][pLevel],pInfo[playerid][pExp],pInfo[playerid][pMinutesSinceAn],pInfo[playerid][pPlayMinutes],pInfo[playerid][pWarn],pInfo[playerid][pLoGPoints],pInfo[playerid][pGesamtspielzeit],
pInfo[playerid][pTode],pInfo[playerid][pGameIntro],pInfo[playerid][pDB]);
mysql_function_query(dbhandle, query, false, "", "");
format(query, sizeof(query), "UPDATE users SET Wantedpunkte='%i',carlicense='%i',carlicensepoints='%i',bikelicense='%i',bikelicensepoints='%i',trucklicense='%i',trucklicensepoints='%i',planelicense='%i',planelicensepoints='%i',helilicense='%i',helilicensepoints='%i',bootlicense='%i',bootlicensepoints='%i',jailstate='%i',jailtimemin='%i',jailtimesek='%i',Hotel='%i',CarRepairPacks='%i',HandyGeld='%i',HandyVer='%i',Handymodel='%i',PhoneBook='%i' WHERE id='%i'",
pInfo[playerid][pWantedpunkte],pInfo[playerid][pcarlicense],pInfo[playerid][pcarlicensepoints],pInfo[playerid][pbikelicense],pInfo[playerid][pbikelicensepoints],pInfo[playerid][ptrucklicense],pInfo[playerid][ptrucklicensepoints],pInfo[playerid][pplanelicense],pInfo[playerid][pplanelicensepoints],pInfo[playerid][phelilicense],pInfo[playerid][phelilicensepoints],pInfo[playerid][pbootlicense],
pInfo[playerid][pbootlicensepoints],pInfo[playerid][pjailstate],pInfo[playerid][pjailtimemin],pInfo[playerid][pjailtimesek],pInfo[playerid][pHotel],pInfo[playerid][pCarRepairPacks],pInfo[playerid][pHandyGeld],pInfo[playerid][pHandyVer],pInfo[playerid][pHandyID],pInfo[playerid][pHandyID],pInfo[playerid][pDB]);
mysql_function_query(dbhandle, query, false, "", "");
}
return 1;
}MfG
Ronny
