Beiträge von Corvus

Zitat von Mr.Reese

Du hast den Code hier doch zweimal gepostet, genau da findest Du den Query.

Nein
public PlayerUpdate(playerid)
{
if(IsPlayerConnected(playerid))
{
if(IsPlayerNPC(playerid))
{
return 1;
}
new playername[MAX_PLAYER_NAME];
GetPlayerName(playerid, playername, sizeof(playername));
new endstring[1600];
new var[129];
format(endstring, sizeof(endstring), "UPDATE `users` SET ");
format(var, sizeof(var), "`Key`='%s', ", PlayerInfo[playerid][pKey]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Level`='%d', ", PlayerInfo[playerid][pLevel]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`AdminLevel`='%d', ", PlayerInfo[playerid][pAdmin]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`DonateRank`='%d', ", PlayerInfo[playerid][pDonatorRank]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`UpgradePoints`='%d', ", PlayerInfo[playerid][gPupgrade]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`ConnectedTime`='%d', ", PlayerInfo[playerid][pConnectTime]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Registered`='%d', ", PlayerInfo[playerid][pReg]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Sex`='%d', ", PlayerInfo[playerid][pSex]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Age`='%d', ", PlayerInfo[playerid][pAlter]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Origin`='%d', ", PlayerInfo[playerid][pOrigin]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Muted`='%d', ", PlayerInfo[playerid][pMuted]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Respect`='%d', ", PlayerInfo[playerid][pRespekt]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Money`='%d', ", PlayerInfo[playerid][pCash]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Bank`='%d', ", PlayerInfo[playerid][pBank]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Allowed`='%d', ", PlayerInfo[playerid][pAllowed]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`wgs`='%d', ", PlayerInfo[playerid][pwgs]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Crimes`='%d', ", PlayerInfo[playerid][pCrimes]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Kills`='%d', ", PlayerInfo[playerid][pKills]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`sKills`='%d', ", PlayerInfo[playerid][psKills]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Deaths`='%d', ", PlayerInfo[playerid][pDeaths]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Arrested`='%d', ", PlayerInfo[playerid][pArrested]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`ArrestTime`='%d', ", PlayerInfo[playerid][pArrestTime]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`PhoneBook`='%d', ", PlayerInfo[playerid][pPhoneBook]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`LottoNr`='%d', ", PlayerInfo[playerid][pLottoNr]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Fishes`='%d', ", PlayerInfo[playerid][pFishes]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`BiggestFish`='%d', ", PlayerInfo[playerid][pBiggestFish]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Job`='%d', ", PlayerInfo[playerid][pJob]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Paycheck`='%d'", PlayerInfo[playerid][pPayCheck]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), " WHERE `Name`='%s'", playername);
strcat(endstring, var, sizeof(endstring));
self_mysql_query(endstring);

format(endstring, sizeof(endstring), "UPDATE `users` SET ");
format(var, sizeof(var), "`HeadValue`='%d', ", PlayerInfo[playerid][pContract]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Jailed`='%d', ", PlayerInfo[playerid][pJailed]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`JailTime`='%d', ", PlayerInfo[playerid][pJailTime]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Leader`='%d', ", PlayerInfo[playerid][pLeader]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Member`='%d', ", PlayerInfo[playerid][pMember]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Rank`='%d', ", PlayerInfo[playerid][pRank]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Skin`='%d', ", PlayerInfo[playerid][pChar]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Vertragszeit`='%d', ", PlayerInfo[playerid][pVertragszeit]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`DetSkill`='%d', ", PlayerInfo[playerid][pDetSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`SexSkill`='%d', ", PlayerInfo[playerid][pSexSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`LawSkill`='%d', ", PlayerInfo[playerid][pAnwaltSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`MechSkill`='%d', ", PlayerInfo[playerid][pMechSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`JackSkill`='%d'", PlayerInfo[playerid][pJackSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), " WHERE `Name`='%s'", playername);
strcat(endstring, var, sizeof(endstring));
self_mysql_query(endstring);

format(endstring, sizeof(endstring), "UPDATE `users` SET ");
format(var, sizeof(var), "`CarSkill`='%d', ", PlayerInfo[playerid][pCarSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`NewsSkill`='%d', ", PlayerInfo[playerid][pNewsSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`DrugsSkill`='%d', ", PlayerInfo[playerid][pDrugsSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`CookSkill`='%d', ", PlayerInfo[playerid][pCookSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`FishSkill`='%d', ", PlayerInfo[playerid][pFishSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`pSHealth`='%.1f', ", PlayerInfo[playerid][pSHealth]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`PhoneNr`='%d', ", PlayerInfo[playerid][pNummer]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`House`='%d', ", PlayerInfo[playerid][pPhousekey]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Biz`='%d', ", PlayerInfo[playerid][pBizKey]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`CarLic`='%d', ", PlayerInfo[playerid][pCarLic]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`FlyLic`='%d', ", PlayerInfo[playerid][pFlyLic]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`BoatLic`='%d', ", PlayerInfo[playerid][pBoatLic]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`FishLic`='%d', ", PlayerInfo[playerid][pFishLic]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`GunLic`='%d', ", PlayerInfo[playerid][pGunLic]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Zollpass`='%d'", PlayerInfo[playerid][pZollpass]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), " WHERE `Name`='%s'", playername);
strcat(endstring, var, sizeof(endstring));
self_mysql_query(endstring);

format(endstring, sizeof(endstring), "UPDATE `users` SET ");
format(var, sizeof(var), "`Gun1`='%d', ", PlayerInfo[playerid][pGun1]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Gun2`='%d', ", PlayerInfo[playerid][pGun2]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Gun3`='%d', ", PlayerInfo[playerid][pGun3]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Gun4`='%d', ", PlayerInfo[playerid][pGun4]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Ammo1`='%d', ", PlayerInfo[playerid][pAmmo1]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Ammo2`='%d', ", PlayerInfo[playerid][pAmmo2]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Ammo3`='%d', ", PlayerInfo[playerid][pAmmo3]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Ammo4`='%d', ", PlayerInfo[playerid][pAmmo4]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`CarTime`='%d', ", PlayerInfo[playerid][pCarTime]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`PayDay`='%d', ", PlayerInfo[playerid][pPayDay]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`PayDayHad`='%d', ", PlayerInfo[playerid][pPayDayHad]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`CDPlayer`='%d', ", PlayerInfo[playerid][pCDPlayer]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`AlcoholPerk`='%d', ", PlayerInfo[playerid][pAlcoholPerk]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`PainKillerPerk`='%d', ", PlayerInfo[playerid][pPainKillerPerk]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`DrugPerk`='%d', ", PlayerInfo[playerid][pDrugPerk]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`MiserPerk`='%d', ", PlayerInfo[playerid][pMiserPerk]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`TraderPerk`='%d', ", PlayerInfo[playerid][pTraderPerk]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Tutorial`='%d', ", PlayerInfo[playerid][pTut]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Warnings`='%d'", PlayerInfo[playerid][pWarns]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), " WHERE `Name`='%s'", playername);
strcat(endstring, var, sizeof(endstring));
self_mysql_query(endstring);

format(endstring, sizeof(endstring), "UPDATE `users` SET ");
format(var, sizeof(var), "`Fuel`='%d', ", PlayerInfo[playerid][pFuel]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Married`='%d', ", PlayerInfo[playerid][pMarried]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`MarriedTo`='%s', ", PlayerInfo[playerid][pMarriedTo]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`WantedLevel`='%d', ", PlayerInfo[playerid][pWantedLevel]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Spawn`='%d', ", PlayerInfo[playerid][pSpawn]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`SavedMaterials`='%d', ", PlayerInfo[playerid][pSaveMats]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`SavedDrugs`='%d', ", PlayerInfo[playerid][pSaveDrugs]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`BikeLic`='%d', ", PlayerInfo[playerid][pBikeLic]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`LKWLic`='%d', ", PlayerInfo[playerid][pLKWLic]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`DonatorTime`='%d', ", PlayerInfo[playerid][pDonatorZeit]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`WerberName`='%s', ", PlayerInfo[playerid][pWerberName]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`FightingStyle`='%d', ", PlayerInfo[playerid][pFightingStyle]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Handy`='%d'", PlayerInfo[playerid][pHandy]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), " WHERE `Name`='%s'", playername);
strcat(endstring, var, sizeof(endstring));
self_mysql_query(endstring);

format(endstring, sizeof(endstring), "UPDATE `users` SET ");
format(var, sizeof(var), "`OnDutySkin`='%d', ", PlayerInfo[playerid][pOnDutySkin]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`CarLicPoints`='%d', ", PlayerInfo[playerid][pCarLicPoints]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`BikeLicPoints`='%d', ", PlayerInfo[playerid][pBikeLicPoints]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`warntime1`='%d', ", PlayerInfo[playerid][pWarnTime1]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`warntime2`='%d', ", PlayerInfo[playerid][pWarnTime2]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Ticketsopen`='%d', ", PlayerInfo[playerid][pTicketsopen]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`DonatorTime`='%d', ", PlayerInfo[playerid][pDonatorZeit]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`OldName`='%s', ", PlayerInfo[playerid][pOldName]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`ClientIP`='%s', ", PlayerInfo[playerid][pUserIP]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`OrgMember`='%d', ", PlayerInfo[playerid][pOrgaID]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`OrgLeader`='%d', ", PlayerInfo[playerid][pOrgaLeader]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`OrgName`='%s'", PlayerInfo[playerid][pOrgaName]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Festgeld`='%d'", PlayerInfo[playerid][pFestgeld]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Festgeldpd`='%d'", PlayerInfo[playerid][pFestPD]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`BusSkill`='%d'", PlayerInfo[playerid][pBusSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Paket`='%d'", PlayerInfo[playerid][pPaket]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Krankenhaus`='%d'", PlayerInfo[playerid][pKrankenhaus]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), " WHERE `Name`='%s'", playername);
strcat(endstring, var, sizeof(endstring));
self_mysql_query(endstring);
new string[128];

Zitat von Mr.Reese

Ja, das habe ich durchaus schon im letzten Post gesehen.
Es bleibt aber bei der Tatsache, dass im Query die Kommata fehlen.

SQL

`OrgName`='Keine'`Festgeld`=12000`Festgeldpd`=0`BusSkill`=0`Paket`=0`Krankenhaus`=0

Wo find ich diesen Query?

Zitat von Mr.Reese

Du hast nach

SQL

`OrgName`='Keine'

keine Kommata mehr im Query, die die einzelnen Felder trennen.

Hab das ganze so:
format(var, sizeof(var), "`OrgName`='%s'", PlayerInfo[playerid][pOrgaName]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Festgeld`='%d'", PlayerInfo[playerid][pFestgeld]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Festgeldpd`='%d'", PlayerInfo[playerid][pFestPD]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`BusSkill`='%d'", PlayerInfo[playerid][pBusSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Paket`='%d'", PlayerInfo[playerid][pPaket]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Krankenhaus`='%d'", PlayerInfo[playerid][pKrankenhaus]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), " WHERE `Name`='%s'", playername);

Zitat von Mr.Reese

Wofür wird denn der Query geloggt? Damit Du ihn Dir anschaust.
Und was fällt direkt auf?

SQL

`carkey`=)

Da fehlt der Wert.

Mir gehts mehr um das:
[22:41:27] CMySQLHandler::Query(UPDATE `users` SET `Fuel`='0', `Married`='0', `MarriedTo`='Niemand', `WantedLevel`='2', `Spawn`='0', `SavedMaterials`='0', `SavedDrugs`='0', `BikeLic`='0', `LKWLic`='0', `DonatorTime`='-1', `WerberName`='geht hier', `FightingStyle`='0', `Handy`='0' WHERE `Name`='Heaven') - Successfully executed.
[22:41:27] >> mysql_query( Connection handle: 1 )
[22:41:27] CMySQLHandler::Query(UPDATE `users` SET `OnDutySkin`='0', `CarLicPoints`='0', `BikeLicPoints`='0', `warntime1`='0', `warntime2`='0', `Ticketsopen`='0', `DonatorTime`='-1', `OldName`='NULL', `ClientIP`='109.193.63.11', `OrgMember`='-1', `OrgLeader`='-1', `OrgName`='Keine'`Festgeld`=12000`Festgeldpd`=0`BusSkill`=0`Paket`=0`Krankenhaus`=0 WHERE `Name`='Heaven') - 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 '`Festgeld`=12000`Festgeldpd`=0`BusSkill`=0`Paket`=0`Krankenhaus`=0 WHERE `Name`=' at line 1)
[22:41:27] OnQueryError() - Called.
[22:41:27] OnQueryError() - Called.
[22:41:27] OnQueryError() - Called.
[22:41:27] OnQueryError() - Called.

format(var, sizeof(var), "`Festgeld`=%d", PlayerInfo[playerid][pFestgeld]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Festgeldpd`=%d", PlayerInfo[playerid][pFestPD]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`BusSkill`=%d", PlayerInfo[playerid][pBusSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Paket`=%d", PlayerInfo[playerid][pPaket]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Krankenhaus`=%d", PlayerInfo[playerid][pKrankenhaus]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), " WHERE `Name`='%s'", playername);
strcat(endstring, var, sizeof(endstring));
self_mysql_query(endstring);

Guten Abend.
Habe folgendes Problem:
[22:09:01] >> mysql_query( Connection handle: 1 )
[22:09:01] CMySQLHandler::Query(UPDATE `cars` SET `ingarage`=0,`AH_Typ`=-1,`AH_X`='0.000000',`AH_Y`='0.000000',`AH_Z`='0.000000',`AH_Rot`='0.000000',`AH_Status`=0,`AH_Lock`=0,`AH_Paintjob`=-1,`Farbe1`=-1,`Farbe2`=-1,`AH_mod1`=-1,`AH_mod2`=-1,`AH_mod3`=-1,`AH_mod4`=-1,`AH_mod5`=-1,`AH_mod6`=-1,`AH_mod7`=-1,`AH_mod8`=-1,`AH_mod9`=-1,`AH_mod10`=-1,`AH_mod11`=-1,`AH_mod12`=-1,`AH_mod13`=-1,`AH_mod14`=-1,`AH_mod15`=-1,`AH_mod16`=-1,`AH_mod17`=-1,`AH_SpawnSaveX`=0.000000,`AH_SpawnSaveY`='0.000000',`AH_SpawnSaveZ`='0.000000',`AH_SpawnSaveRot`='0.000000',`AH_TankVolumen`=0,`AH_Mats`=0,`AH_Neon`=0,`AH_NeonType`=0,`AH_Drugs`=0,`AH_Versicherung`=0,`AH_StandTime`=0,`AH_Meter`=1 WHERE `sqlid`=0 AND `carkey`=) - 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 '' at line 1)
[22:09:01] >> mysql_query( Connection handle: 1 )
[22:09:01] CMySQLHandler::Query(UPDATE `cars` SET `ingarage`=0,`AH_Typ`=-1,`AH_X`='0.000000',`AH_Y`='0.000000',`AH_Z`='0.000000',`AH_Rot`='0.000000',`AH_Status`=0,`AH_Lock`=0,`AH_Paintjob`=-1,`Farbe1`=-1,`Farbe2`=-1,`AH_mod1`=-1,`AH_mod2`=-1,`AH_mod3`=-1,`AH_mod4`=-1,`AH_mod5`=-1,`AH_mod6`=-1,`AH_mod7`=-1,`AH_mod8`=-1,`AH_mod9`=-1,`AH_mod10`=-1,`AH_mod11`=-1,`AH_mod12`=-1,`AH_mod13`=-1,`AH_mod14`=-1,`AH_mod15`=-1,`AH_mod16`=-1,`AH_mod17`=-1,`AH_SpawnSaveX`=0.000000,`AH_SpawnSaveY`='0.000000',`AH_SpawnSaveZ`='0.000000',`AH_SpawnSaveRot`='0.000000',`AH_TankVolumen`=0,`AH_Mats`=0,`AH_Neon`=0,`AH_NeonType`=0,`AH_Drugs`=0,`AH_Versicherung`=0,`AH_StandTime`=0,`AH_Meter`=1 WHERE `sqlid`=1 AND `carkey`=) - 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 '' at line 1)
[22:09:01] >> mysql_query( Connection handle: 1 )
[22:09:01] CMySQLHandler::Query(UPDATE `cars` SET `ingarage`=0,`AH_Typ`=-1,`AH_X`='0.000000',`AH_Y`='0.000000',`AH_Z`='0.000000',`AH_Rot`='0.000000',`AH_Status`=0,`AH_Lock`=0,`AH_Paintjob`=-1,`Farbe1`=-1,`Farbe2`=-1,`AH_mod1`=-1,`AH_mod2`=-1,`AH_mod3`=-1,`AH_mod4`=-1,`AH_mod5`=-1,`AH_mod6`=-1,`AH_mod7`=-1,`AH_mod8`=-1,`AH_mod9`=-1,`AH_mod10`=-1,`AH_mod11`=-1,`AH_mod12`=-1,`AH_mod13`=-1,`AH_mod14`=-1,`AH_mod15`=-1,`AH_mod16`=-1,`AH_mod17`=-1,`AH_SpawnSaveX`=0.000000,`AH_SpawnSaveY`='0.000000',`AH_SpawnSaveZ`='0.000000',`AH_SpawnSaveRot`='0.000000',`AH_TankVolumen`=0,`AH_Mats`=0,`AH_Neon`=0,`AH_NeonType`=0,`AH_Drugs`=0,`AH_Versicherung`=0,`AH_StandTime`=0,`AH_Meter`=1 WHERE `sqlid`=2 AND `carkey`=) - 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 '' at line 1)
[22:09:01] >> mysql_query( Connection handle: 1 )
[22:09:01] CMySQLHandler::Query(UPDATE `users` SET `Key`='123456', `Level`='3', `AdminLevel`='2000', `DonateRank`='1', `UpgradePoints`='0', `ConnectedTime`='20', `Registered`='1', `Sex`='1', `Age`='17', `Origin`='1', `Muted`='0', `Respect`='13', `Money`='2240976', `Bank`='10882', `Allowed`='0', `wgs`='0', `Crimes`='4', `Kills`='4', `sKills`='3', `Deaths`='19', `Arrested`='0', `ArrestTime`='0', `PhoneBook`='0', `LottoNr`='0', `Fishes`='0', `BiggestFish`='0', `Job`='19', `Paycheck`='0' WHERE `Name`='Heaven') - Successfully executed.
[22:09:01] >> mysql_query( Connection handle: 1 )
[22:09:01] CMySQLHandler::Query(UPDATE `users` SET `HeadValue`='0', `Jailed`='0', `JailTime`='0', `Leader`='0', `Member`='0', `Rank`='12', `Skin`='3', `Vertragszeit`='0', `DetSkill`='0', `SexSkill`='0', `LawSkill`='0', `MechSkill`='0', `JackSkill`='0' WHERE `Name`='Heaven') - Successfully executed.
[22:09:01] >> mysql_query( Connection handle: 1 )
[22:09:01] CMySQLHandler::Query(UPDATE `users` SET `CarSkill`='0', `NewsSkill`='0', `DrugsSkill`='0', `CookSkill`='0', `FishSkill`='0', `pSHealth`='50.0', `PhoneNr`='0', `House`='-1', `Biz`='-1', `CarLic`='1', `FlyLic`='0', `BoatLic`='0', `FishLic`='0', `GunLic`='0', `Zollpass`='0' WHERE `Name`='Heaven') - Successfully executed.
[22:09:01] >> mysql_query( Connection handle: 1 )
[22:09:01] CMySQLHandler::Query(UPDATE `users` SET `Gun1`='0', `Gun2`='0', `Gun3`='0', `Gun4`='0', `Ammo1`='0', `Ammo2`='0', `Ammo3`='0', `Ammo4`='0', `CarTime`='0', `PayDay`='54', `PayDayHad`='0', `CDPlayer`='0', `AlcoholPerk`='0', `PainKillerPerk`='0', `DrugPerk`='0', `MiserPerk`='0', `TraderPerk`='0', `Tutorial`='1', `Warnings`='0' WHERE `Name`='Heaven') - Successfully executed.
[22:09:01] >> mysql_query( Connection handle: 1 )
[22:09:01] CMySQLHandler::Query(UPDATE `users` SET `Fuel`='0', `Married`='0', `MarriedTo`='Niemand', `WantedLevel`='2', `Spawn`='0', `SavedMaterials`='0', `SavedDrugs`='0', `BikeLic`='0', `LKWLic`='0', `DonatorTime`='-1', `WerberName`='geht hier', `FightingStyle`='0', `Handy`='0' WHERE `Name`='Heaven') - Successfully executed.
[22:09:01] >> mysql_query( Connection handle: 1 )
[22:09:01] CMySQLHandler::Query(UPDATE `users` SET `OnDutySkin`='0', `CarLicPoints`='0', `BikeLicPoints`='0', `warntime1`='0', `warntime2`='0', `Ticketsopen`='0', `DonatorTime`='-1', `OldName`='NULL', `ClientIP`='109.193.63.11', `OrgMember`='-1', `OrgLeader`='-1', `OrgName`='Keine'`Onlinne`=''`Festgeld`=12000`Festgeldpd`=0`BusSkill`=0`Paket`=0`Krankenhaus`=0 WHERE `Name`='Heaven') - 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 '`Onlinne`=''`Festgeld`=12000`Festgeldpd`=0`BusSkill`=0`Paket`=0`Krankenhaus`=0 W' at line 1)
[22:09:01] OnQueryError() - Called.
[22:09:01] OnQueryError() - Called.
[22:09:01] OnQueryError() - Called.
[22:09:01] OnQueryError() - Called.

Was mach ich falsch?

Wie mache ich diese Textdraws so das sie 2 Stellen haben?

format(string,sizeof(string),"~r~%s",VehNames[GetVehicleModel(VID)-400]);
format(string1,sizeof(string1),"~r~KM/H:~g~ %d %f",value);
format(string2,sizeof(string2),"~r~Tank:~g~ %s %f", Tank, Gas[VID]);
format(string4,sizeof(string4),"~r~Zustand:~g~ %.1f",leben/10);
format(string3,sizeof(string3),"~r~Kilometer:~g~ %d %f Km",floatround(Kilometer[veh]));

//MOD: Keine unnötigen Fullquotes
Funktioniert leider immer noch nicht er setzt überall 0

Serverwerbung: 3/10 Gefällt mir nicht Name nicht passend.
Server: - / 10 (Wird getestet Erwarte aber kein Gutes Fazit da namen schon wieder massen SDM verspricht.

Zitat von riconeo

1. Woher willst du wissen, dass das alles Teammitglieder sind?
2. Forum geht doch?

Nein geht leider nicht

Zitat von Jeffry

Kommen da alle prints?
Wenn ja, poste mal deine CreateTunedCar Funktion.

Wenn nein, wo stoppt er?

Die CreateTunedCar Public.

public CreateTunedCar(playerid, CarKey1)
{
if(IsPlayerConnected(playerid) && Carlist[playerid][CarKey1][Typ] != -1)
{
if(Carlist[playerid][CarKey1][ingarage] == 1) return 1;
// new carid = CreateVehicle(Kaufliste[Carlist[playerid][CarKey1][Typ]][Modelid],Carlist[playerid][CarKey1][SpawnSaveX],Carlist[playerid][CarKey1][SpawnSaveY],Carlist[playerid][CarKey1][SpawnSaveZ],Carlist[playerid][CarKey1][SpawnSaveRot],-1,-1,-1);
new carid = CreateVehicle(Kaufliste[Carlist[playerid][CarKey1][Typ]][Modelid],Carlist[playerid][CarKey1][pos_x],Carlist[playerid][CarKey1][pos_y],Carlist[playerid][CarKey1][pos_z],Carlist[playerid][CarKey1][z_angle],-1,-1,-1);
new string[50];
format(string, sizeof(string), "{FFFF00}E-RP-{21DD00}%d", carid);
SetVehicleNumberPlate(carid,string);
Gas[carid] = Carlist[playerid][CarKey1][TankVolumen];
Locked[carid] = Carlist[playerid][CarKey1][Lock];
if(Carlist[playerid][CarKey1][Lock] == 1){
ForAllPlayers(i){
SetVehicleParamsForPlayer(carid,i,0,1);
}
}
if(Carlist[playerid][CarKey1][mod1]!=-1) { AddVehicleComponent(carid,Carlist[playerid][CarKey1][mod1]); }
if(Carlist[playerid][CarKey1][mod2]!=-1) { AddVehicleComponent(carid,Carlist[playerid][CarKey1][mod2]); }
if(Carlist[playerid][CarKey1][mod3]!=-1) { AddVehicleComponent(carid,Carlist[playerid][CarKey1][mod3]); }
if(Carlist[playerid][CarKey1][mod4]!=-1) { AddVehicleComponent(carid,Carlist[playerid][CarKey1][mod4]); }
if(Carlist[playerid][CarKey1][mod5]!=-1) { AddVehicleComponent(carid,Carlist[playerid][CarKey1][mod5]); }
if(Carlist[playerid][CarKey1][mod6]!=-1) { AddVehicleComponent(carid,Carlist[playerid][CarKey1][mod6]); }
if(Carlist[playerid][CarKey1][mod7]!=-1) { AddVehicleComponent(carid,Carlist[playerid][CarKey1][mod7]); }
if(Carlist[playerid][CarKey1][mod8]!=-1) { AddVehicleComponent(carid,Carlist[playerid][CarKey1][mod8]); }
if(Carlist[playerid][CarKey1][mod9]!=-1) { AddVehicleComponent(carid,Carlist[playerid][CarKey1][mod9]); }
if(Carlist[playerid][CarKey1][mod10]!=-1) { AddVehicleComponent(carid,Carlist[playerid][CarKey1][mod10]); }
if(Carlist[playerid][CarKey1][mod11]!=-1) { AddVehicleComponent(carid,Carlist[playerid][CarKey1][mod11]); }
if(Carlist[playerid][CarKey1][mod12]!=-1) { AddVehicleComponent(carid,Carlist[playerid][CarKey1][mod12]); }
if(Carlist[playerid][CarKey1][mod13]!=-1) { AddVehicleComponent(carid,Carlist[playerid][CarKey1][mod13]); }
if(Carlist[playerid][CarKey1][mod14]!=-1) { AddVehicleComponent(carid,Carlist[playerid][CarKey1][mod14]); }
if(Carlist[playerid][CarKey1][mod15]!=-1) { AddVehicleComponent(carid,Carlist[playerid][CarKey1][mod15]); }
if(Carlist[playerid][CarKey1][mod16]!=-1) { AddVehicleComponent(carid,Carlist[playerid][CarKey1][mod16]); }
if(Carlist[playerid][CarKey1][mod17]!=-1) { AddVehicleComponent(carid,Carlist[playerid][CarKey1][mod17]); }
if(Carlist[playerid][CarKey1][Paintjob]!=-1) { ChangeVehiclePaintjob(carid,Carlist[playerid][CarKey1][Paintjob]); }
if(Carlist[playerid][CarKey1][Farbe1]!=-1) { ChangeVehicleColor(carid,Carlist[playerid][CarKey1][Farbe1],Carlist[playerid][CarKey1][Farbe2]); }
for(new i; i<MaxVeh[playerid]; i++){
if(Carlist[playerid][i][Neon]!=0){
switch(Carlist[playerid][i][NeonType]){
case 0:AttachObjectToVehicle(CreateObject(18647,0,0,0,0,0,0), GetPlayerVehicleID(playerid), -0.8, 0.0, -0.70, 0.0, 0.0, 0.0), AttachObjectToVehicle(CreateObject(18647,0,0,0,0,0,0), GetPlayerVehicleID(playerid), 0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
case 1:AttachObjectToVehicle(CreateObject(18648,0,0,0,0,0,0), GetPlayerVehicleID(playerid), -0.8, 0.0, -0.70, 0.0, 0.0, 0.0), AttachObjectToVehicle(CreateObject(18648,0,0,0,0,0,0), GetPlayerVehicleID(playerid), 0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
case 2:AttachObjectToVehicle(CreateObject(18649,0,0,0,0,0,0), GetPlayerVehicleID(playerid), -0.8, 0.0, -0.70, 0.0, 0.0, 0.0), AttachObjectToVehicle(CreateObject(18649,0,0,0,0,0,0), GetPlayerVehicleID(playerid), 0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
case 3:AttachObjectToVehicle(CreateObject(18650,0,0,0,0,0,0), GetPlayerVehicleID(playerid), -0.8, 0.0, -0.70, 0.0, 0.0, 0.0), AttachObjectToVehicle(CreateObject(18650,0,0,0,0,0,0), GetPlayerVehicleID(playerid), 0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
case 4:AttachObjectToVehicle(CreateObject(18651,0,0,0,0,0,0), GetPlayerVehicleID(playerid), -0.8, 0.0, -0.70, 0.0, 0.0, 0.0), AttachObjectToVehicle(CreateObject(18651,0,0,0,0,0,0), GetPlayerVehicleID(playerid), 0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
case 5:AttachObjectToVehicle(CreateObject(18652,0,0,0,0,0,0), GetPlayerVehicleID(playerid), -0.8, 0.0, -0.70, 0.0, 0.0, 0.0), AttachObjectToVehicle(CreateObject(18652,0,0,0,0,0,0), GetPlayerVehicleID(playerid), 0.8, 0.0, -0.70, 0.0, 0.0, 0.0);
}
}
}
return carid;
}
return -1;
}

Zitat von Jeffry

Eigentlich sieht es gut, nur dass du drei mal in ID 1 speicherst, da passt irgendwas mit Carlist[playerid][h][cid] nicht, das wird möglicherweise beim Erstellen der Fahrzeuge schon falsch gesetzt.
Schau dir das mal an, vielleicht findest du das Problem ja. Ansonsten poste das mal, dann schau ich es mir heute Abend an, wenn ich wieder da bin!

Ach ja, was sagt der MySQL Log?

Das Problem entsteht hier:
if(strcmp("/buycar", cmd, true) == 0)
{
if(Spectating[playerid] != -1)
{
if(Carlist[playerid][CarKey[playerid]][Typ] == -1)
{
new preis = Kaufliste[Spectating[playerid]][Preis];
if(preis <= PlayerInfo[playerid][pCash])
{
new autohaus = Kaufliste[Spectating[playerid]][Autohaus];
print("OnPlayerDeath: message sent");
GivePlayerMoneys(playerid, - preis);
print("OnPlayerDeath: message sent1");
Carlist[playerid][CarKey[playerid]][Typ] = Spectating[playerid];
print("OnPlayerDeath: message sent2");
Carlist[playerid][CarKey[playerid]][pos_x] = Autospawns[autohaus][pos_x];
print("OnPlayerDeath: message sent3");
Carlist[playerid][CarKey[playerid]][pos_y] = Autospawns[autohaus][pos_y];
Carlist[playerid][CarKey[playerid]][pos_z] = Autospawns[autohaus][pos_z];
print("OnPlayerDeath: message sent4");
Carlist[playerid][CarKey[playerid]][z_angle] = Autospawns[autohaus][z_angle];
print("OnPlayerDeath: message sent5");
Carlist[playerid][CarKey[playerid]][SpawnSaveX] = Autospawns[autohaus][pos_x];
Carlist[playerid][CarKey[playerid]][SpawnSaveY] = Autospawns[autohaus][pos_y];
Carlist[playerid][CarKey[playerid]][SpawnSaveZ] = Autospawns[autohaus][pos_z];
print("OnPlayerDeath: message sent6");
Carlist[playerid][CarKey[playerid]][SpawnSaveRot] = Autospawns[autohaus][z_angle];
print("OnPlayerDeath: message sent7");
Carlist[playerid][CarKey[playerid]][Status] = 0;
print("OnPlayerDeath: message sent8");
Carlist[playerid][CarKey[playerid]][Lock] = 0;
Carlist[playerid][CarKey[playerid]][TankVolumen] = 100;
print("OnPlayerDeath: message sent9");
Carlist[playerid][CarKey[playerid]][Carid] = CreateTunedCar(playerid, CarKey[playerid]);
print("OnPlayerDeath: message sent10");
Carlist[playerid][CarKey[playerid]][Meter] = 0;
Gas[Carlist[playerid][CarKey[playerid]][Carid]] = Carlist[playerid][CarKey[playerid]][TankVolumen];
print("OnPlayerDeath: message sent11");
SetPlayerCheckpoint(playerid,Carlist[playerid][CarKey[playerid]][pos_x],Carlist[playerid][CarKey[playerid]][pos_y],Carlist[playerid][CarKey[playerid]][pos_z],10.0);
print("OnPlayerDeath: message sent12");
new query[900], h = CarKey[playerid];
format(query,sizeof(query),"INSERT INTO `cars` (`sqlid`,`carkey`,`ingarage`,`AH_Typ`,`AH_X`,`AH_Y`,`AH_Z`,`AH_Rot`,`AH_Status`,`AH_Lock`,`AH_Paintjob`,`AH_Farbe1`,`AH_Farbe2`,`AH_Mod1`,`AH_Mod2`,`AH_Mod3`,`AH_Mod4`,`AH_Mod5`,`AH_Mod6`,`AH_Mod7`,`AH_Mod8`,`AH_Mod9`,`AH_Mod10`,`AH_Mod11`,`AH_Mod12`,`AH_Mod13`,`AH_Mod14`,`AH_Mod15`,`AH_Mod16`,`AH_Mod17`,");
format(query,sizeof(query),"%s`AH_SpawnSaveX`,`AH_SpawnSaveY`,`AH_SpawnSaveZ`,`AH_SpawnSaveRot`,`AH_TankVolumen`,`AH_Mats`,`AH_Neon`,`AH_NeonType`,`AH_Drugs`,`AH_StandTime`,`AH_Meter`) VALUES (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)",query);
printf("Hier müsste der query stehen: %s",query);
mysql_query(query);
ForAllPlayers(i){
if(IsPlayerConnected(i)){
SetVehicleParamsForPlayer(Kaufliste[Spectating[playerid]][Carid], i, 0, 0);
print("OnPlayerDeath: message sent13");
}}
TogglePlayerControllable(playerid,1);
RemovePlayerFromVehicle(playerid);
format(string, sizeof(string), "Du hast dir erfolgreich für %s$ ein/einen %s gekauft!",GetPoint(preis),Kaufliste[Carlist[playerid][CarKey[playerid]][Typ]][Name]);
SendClientMessage(playerid, COLOR_LIGHTBLUE, "öffnen und Schließen kannst du es mit /lock und /carlock.");
SendClientMessage(playerid, COLOR_LIGHTBLUE, "Mehr Befehle kannst du unter /carhelp sehen.");
SendClientMessage(playerid, COLOR_YELLOW, "Dein Auto steht am Ausgabepunkt(Roter Marker) bereit! Viel Spaß beim Fahren!");
GetPlayerName(playerid, sendername, sizeof(sendername));
if(Kaufliste[Spectating[playerid]][Autohaus] == 2)
{
BizInfo[13][bTill] += (preis/100)*19;
}
Spectating[playerid] = -1;
}
else
{
format(string, sizeof(string), " Du hast nicht genug Geld für das Auto (benötigt: $%i)!", preis);
SendClientMessage(playerid, COLOR_ERRORTEXT, string);
}
}
else
{
SendClientMessage(playerid, COLOR_ERRORTEXT, " Du besitzt bereits ein Auto auf dem ausgewählten Schlüssel!");
}
}
else
{
SendClientMessage(playerid, COLOR_ERRORTEXT, " Du besichtigst kein Auto !");
}
return 1;
}

Zitat von Jeffry

Hier:
,Carlist[playerid][h][cDrugs],Carlist[playerid][h][StandTime],
zwischen denen zwei fehlt die Versicherungs-Variable.

,Carlist[playerid][h][cDrugs],HIER,Carlist[playerid][h][StandTime],

Hab das komplett raus :
[17:15:56] Query: UPDATE `cars` SET `sqlid`=1,`carkey`=0,`ingarage`=0,`AH_Typ`=6,`AH_X`='748.975219',`AH_Y`='-1345.818237',`AH_Z`='13.515500',`AH_Rot`='270.000000',`AH_Status`=0,`AH_Lock`=0,`AH_Paintjob`=-1,`Farbe1`=-1,`Farbe2`=-1,`AH_mod1`=-1,`AH_mod2`=-1,`AH_mod3`=-1,`AH_mod4`=-1,`AH_mod5`=-1,`AH_mod6`=-1,`AH_mod7`=-1,`AH_mod8`=-1,`AH_mod9`=-1,`AH_mod10`=-1,`AH_mod11`=-1,`AH_mod12`=-1,`AH_mod13`=-1,`AH_mod14`=-1,`AH_mod15`=-1,`AH_mod16`=-1,`AH_mod17`=-1,`AH_SpawnSaveX`=748.979309,`AH_SpawnSaveY`='-1345.819702',`AH_SpawnSaveZ`='13.311610',`AH_SpawnSaveRot`='270.001464',`AH_TankVolumen`=100,`AH_Mats`=0,`AH_Neon`=0,`AH_NeonType`=1,`AH_Drugs`=0,`AH_StandTime`=0,`AH_Meter`=0 WHERE `id`=1
[17:15:56] Query: UPDATE `cars` SET `sqlid`=1,`carkey`=1,`ingarage`=0,`AH_Typ`=0,`AH_X`='0.000000',`AH_Y`='0.000000',`AH_Z`='0.000000',`AH_Rot`='0.000000',`AH_Status`=0,`AH_Lock`=0,`AH_Paintjob`=0,`Farbe1`=0,`Farbe2`=0,`AH_mod1`=0,`AH_mod2`=0,`AH_mod3`=0,`AH_mod4`=0,`AH_mod5`=0,`AH_mod6`=0,`AH_mod7`=0,`AH_mod8`=0,`AH_mod9`=0,`AH_mod10`=0,`AH_mod11`=0,`AH_mod12`=0,`AH_mod13`=0,`AH_mod14`=0,`AH_mod15`=0,`AH_mod16`=0,`AH_mod17`=0,`AH_SpawnSaveX`=0.000000,`AH_SpawnSaveY`='0.000000',`AH_SpawnSaveZ`='0.000000',`AH_SpawnSaveRot`='0.000000',`AH_TankVolumen`=0,`AH_Mats`=0,`AH_Neon`=0,`AH_NeonType`=0,`AH_Drugs`=0,`AH_StandTime`=0,`AH_Meter`=0 WHERE `id`=1
[17:15:56] Query: UPDATE `cars` SET `sqlid`=1,`carkey`=2,`ingarage`=0,`AH_Typ`=0,`AH_X`='0.000000',`AH_Y`='0.000000',`AH_Z`='0.000000',`AH_Rot`='0.000000',`AH_Status`=0,`AH_Lock`=0,`AH_Paintjob`=0,`Farbe1`=0,`Farbe2`=0,`AH_mod1`=0,`AH_mod2`=0,`AH_mod3`=0,`AH_mod4`=0,`AH_mod5`=0,`AH_mod6`=0,`AH_mod7`=0,`AH_mod8`=0,`AH_mod9`=0,`AH_mod10`=0,`AH_mod11`=0,`AH_mod12`=0,`AH_mod13`=0,`AH_mod14`=0,`AH_mod15`=0,`AH_mod16`=0,`AH_mod17`=0,`AH_SpawnSaveX`=0.000000,`AH_SpawnSaveY`='0.000000',`AH_SpawnSaveZ`='0.000000',`AH_SpawnSaveRot`='0.000000',`AH_TankVolumen`=0,`AH_Mats`=0,`AH_Neon`=0,`AH_NeonType`=0,`AH_Drugs`=0,`AH_StandTime`=0,`AH_Meter`=0 WHERE `id`=1

Zitat von Jeffry

Das Query ist immernoch falsch, deshalb, allerdings sehe ich den Fehler nicht raus.
Füge mal vor:
self_mysql_query(string);
das ein:
printf("Query: %s", string);

Was steht dann im Server Log?

[16:52:57] Query: UPDATE `cars` SET `sqlid`=1,`carkey`=0,`ingarage`=0,`AH_Typ`=0,`AH_X`='0.000000',`AH_Y`='0.000000',`AH_Z`='0.000000',`AH_Rot`='0.000000',`AH_Status`=0,`AH_Lock`=0,`AH_Paintjob`=0,`Farbe1`=0,`Farbe2`=0,`AH_mod1`=0,`AH_mod2`=0,`AH_mod3`=0,`AH_mod4`=0,`AH_mod5`=0,`AH_mod6`=0,`AH_mod7`=0,`AH_mod8`=0,`AH_mod9`=0,`AH_mod10`=0,`AH_mod11`=0,`AH_mod12`=0,`AH_mod13`=0,`AH_mod14`=0,`AH_mod15`=0,`AH_mod16`=0,`AH_mod17`=0,`AH_SpawnSaveX`=0.000000,`AH_SpawnSaveY`='0.000000',`AH_SpawnSaveZ`='0.000000',`AH_SpawnSaveRot`='0.000000',`AH_TankVolumen`=0,`AH_Mats`=0,`AH_Neon`=0,`AH_NeonType`=0,`AH_Drugs`=0,`AH_Versicherung`=0,`AH_StandTime`=0,`AH_Meter`=1 WHERE `id`=
[16:52:57] Query: UPDATE `cars` SET `sqlid`=1,`carkey`=1,`ingarage`=0,`AH_Typ`=8,`AH_X`='748.975219',`AH_Y`='-1345.818237',`AH_Z`='13.515500',`AH_Rot`='270.000000',`AH_Status`=0,`AH_Lock`=0,`AH_Paintjob`=-1,`Farbe1`=-1,`Farbe2`=-1,`AH_mod1`=-1,`AH_mod2`=-1,`AH_mod3`=-1,`AH_mod4`=-1,`AH_mod5`=-1,`AH_mod6`=-1,`AH_mod7`=-1,`AH_mod8`=-1,`AH_mod9`=-1,`AH_mod10`=-1,`AH_mod11`=-1,`AH_mod12`=-1,`AH_mod13`=-1,`AH_mod14`=-1,`AH_mod15`=-1,`AH_mod16`=-1,`AH_mod17`=-1,`AH_SpawnSaveX`=748.971740,`AH_SpawnSaveY`='-1345.821777',`AH_SpawnSaveZ`='13.084108',`AH_SpawnSaveRot`='269.998962',`AH_TankVolumen`=100,`AH_Mats`=0,`AH_Neon`=0,`AH_NeonType`=1,`AH_Drugs`=0,`AH_Versicherung`=0,`AH_StandTime`=0,`AH_Meter`=1 WHERE `id`=
[16:52:57] Query: UPDATE `cars` SET `sqlid`=1,`carkey`=2,`ingarage`=0,`AH_Typ`=0,`AH_X`='0.000000',`AH_Y`='0.000000',`AH_Z`='0.000000',`AH_Rot`='0.000000',`AH_Status`=0,`AH_Lock`=0,`AH_Paintjob`=0,`Farbe1`=0,`Farbe2`=0,`AH_mod1`=0,`AH_mod2`=0,`AH_mod3`=0,`AH_mod4`=0,`AH_mod5`=0,`AH_mod6`=0,`AH_mod7`=0,`AH_mod8`=0,`AH_mod9`=0,`AH_mod10`=0,`AH_mod11`=0,`AH_mod12`=0,`AH_mod13`=0,`AH_mod14`=0,`AH_mod15`=0,`AH_mod16`=0,`AH_mod17`=0,`AH_SpawnSaveX`=0.000000,`AH_SpawnSaveY`='0.000000',`AH_SpawnSaveZ`='0.000000',`AH_SpawnSaveRot`='0.000000',`AH_TankVolumen`=0,`AH_Mats`=0,`AH_Neon`=0,`AH_NeonType`=0,`AH_Drugs`=0,`AH_Versicherung`=0,`AH_StandTime`=0,`AH_Meter`=1 WHERE `id`=

Zitat von Jeffry

Die Splate AH_Mod5 gibt es nicht. Die musst du auch hinzufügen.

Es wird nun etwas eingetragen aber komplett falsch:
[16:36:44] CMySQLHandler::Query(INSERT INTO `cars` (`sqlid`,`carkey`,`ingarage`,`AH_Typ`,`AH_X`,`AH_Y`,`AH_Z`,`AH_Rot`,`AH_Status`,`AH_Lock`,`AH_Paintjob`,`AH_Farbe1`,`AH_Farbe2`,`AH_Mod1`,`AH_Mod2`,`AH_Mod3`,`AH_Mod4`,`AH_Mod5`,`AH_Mod6`,`AH_Mod7`,`AH_Mod8`,`AH_Mod9`,`AH_Mod10`,`AH_Mod11`,`AH_Mod12`,`AH_Mod13`,`AH_Mod14`,`AH_Mod15`,`AH_Mod16`,`AH_Mod17`,`AH_SpawnSaveX`,`AH_SpawnSaveY`,`AH_SpawnSaveZ`,`AH_SpawnSaveRot`,`AH_TankVolumen`,`AH_Mats`,`AH_Neon`,`AH_NeonType`,`AH_Drugs`,`AH_Versicherung`,`AH_StandTime`,`AH_Meter`) VALUES (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)) - Successfully executed.
[16:36:46] >> mysql_query( Connection handle: 1 )
[16:36:46] CMySQLHandler::Query(UPDATE `users` SET `Online` = '0' WHERE Name = 'Heaven') - Successfully executed.
[16:36:46] >> mysql_query( Connection handle: 1 )
[16:36:46] CMySQLHandler::Query(UPDATE `cars` SET `sqlid`=1,`carkey`=0,`ingarage`=0,`AH_Typ`=18,`AH_X`='748.975219',`AH_Y`='-1345.818237',`AH_Z`='13.515500',`AH_Rot`='270.000000',`AH_Status`=0,`AH_Lock`=0,`AH_Paintjob`=-1,`Farbe1`=-1,`Farbe2`=-1,`AH_mod1`=-1,`AH_mod2`=-1,`AH_mod3`=-1,`AH_mod4`=-1,`AH_mod5`=-1,`AH_mod6`=-1,`AH_mod7`=-1,`AH_mod8`=-1,`AH_mod9`=-1,`AH_mod10`=-1,`AH_mod11`=-1,`AH_mod12`=-1,`AH_mod13`=-1,`AH_mod14`=-1,`AH_mod15`=-1,`AH_mod16`=-1,`AH_mod17`=-1,`AH_SpawnSaveX`=748.975219,`AH_SpawnSaveY`='-1345.818237',`AH_SpawnSaveZ`='13.674688',`AH_SpawnSaveRot`='270.000000',`AH_TankVolumen`=100,`AH_Mats`=0,`AH_Neon`=0,`AH_NeonType`=0,`AH_Drugs`=0,`AH_Versicherung`=0,`AH_StandTime`=0,`AH_Meter`=0 WHERE `id`=) - 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 '' at line 1)
[16:36:46] >> mysql_query( Connection handle: 1 )
[16:36:46] CMySQLHandler::Query(UPDATE `cars` SET `sqlid`=1,`carkey`=1,`ingarage`=0,`AH_Typ`=-1,`AH_X`='0.000000',`AH_Y`='0.000000',`AH_Z`='0.000000',`AH_Rot`='0.000000',`AH_Status`=0,`AH_Lock`=0,`AH_Paintjob`=-1,`Farbe1`=-1,`Farbe2`=-1,`AH_mod1`=-1,`AH_mod2`=-1,`AH_mod3`=-1,`AH_mod4`=-1,`AH_mod5`=-1,`AH_mod6`=-1,`AH_mod7`=-1,`AH_mod8`=-1,`AH_mod9`=-1,`AH_mod10`=-1,`AH_mod11`=-1,`AH_mod12`=-1,`AH_mod13`=-1,`AH_mod14`=-1,`AH_mod15`=-1,`AH_mod16`=-1,`AH_mod17`=-1,`AH_SpawnSaveX`=0.000000,`AH_SpawnSaveY`='0.000000',`AH_SpawnSaveZ`='0.000000',`AH_SpawnSaveRot`='0.000000',`AH_TankVolumen`=0,`AH_Mats`=0,`AH_Neon`=0,`AH_NeonType`=0,`AH_Drugs`=0,`AH_Versicherung`=0,`AH_StandTime`=0,`AH_Meter`=0 WHERE `id`=) - 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 '' at line 1)
[16:36:46] >> mysql_query( Connection handle: 1 )
[16:36:46] CMySQLHandler::Query(UPDATE `cars` SET `sqlid`=1,`carkey`=2,`ingarage`=0,`AH_Typ`=-1,`AH_X`='0.000000',`AH_Y`='0.000000',`AH_Z`='0.000000',`AH_Rot`='0.000000',`AH_Status`=0,`AH_Lock`=0,`AH_Paintjob`=-1,`Farbe1`=-1,`Farbe2`=-1,`AH_mod1`=-1,`AH_mod2`=-1,`AH_mod3`=-1,`AH_mod4`=-1,`AH_mod5`=-1,`AH_mod6`=-1,`AH_mod7`=-1,`AH_mod8`=-1,`AH_mod9`=-1,`AH_mod10`=-1,`AH_mod11`=-1,`AH_mod12`=-1,`AH_mod13`=-1,`AH_mod14`=-1,`AH_mod15`=-1,`AH_mod16`=-1,`AH_mod17`=-1,`AH_SpawnSaveX`=0.000000,`AH_SpawnSaveY`='0.000000',`AH_SpawnSaveZ`='0.000000',`AH_SpawnSaveRot`='0.000000',`AH_TankVolumen`=0,`AH_Mats`=0,`AH_Neon`=0,`AH_NeonType`=0,`AH_Drugs`=0,`AH_Versicherung`=0,`AH_StandTime`=0,`AH_Meter`=0 WHERE `id`=) - 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 '' at line 1)
[16:36:46] >> mysql_query( Connection handle: 1 )

Zitat von Jeffry

Die strings sind zu kurz.
Schreibe es so:

public PlayerCarUpdate(playerid)
{
if(IsPlayerNPC(playerid)) return 1;
new string[2048], playername[MAX_PLAYER_NAME];
GetPlayerName(playerid, playername, sizeof(playername));
for(new h = 0; h < MaxVeh[playerid]; h++)
{
format(string, sizeof(string), "UPDATE `cars` SET `sqlid`=%i,`carkey`=%i,`ingarage`=%i,`AH_Typ`=%i,`AH_X`='%f',`AH_Y`='%f',`AH_Z`='%f',`AH_Rot`='%f',`AH_Status`=%i,`AH_Lock`=%i,`AH_Paintjob`=%i,`Farbe1`=%i,`Farbe2`=%i,`AH_mod1`=%i,`AH_mod2`=%i,`AH_mod3`=%i,`AH_mod4`=%i,`AH_mod5`=%i,`AH_mod6`=%i,`AH_mod7`=%i,`AH_mod8`=%i,`AH_mod9`=%i,`AH_mod10`=%i,`AH_mod11`=%i,`AH_mod12`=%i,`AH_mod13`=%i,`AH_mod14`=%i,`AH_mod15`=%i,`AH_mod16`=%i,`AH_mod17`=%i,",
PlayerInfo[playerid][pSQLID],h,Carlist[playerid][h][ingarage],Carlist[playerid][h][Typ],Carlist[playerid][h][pos_x],Carlist[playerid][h][pos_y],Carlist[playerid][h][pos_z],
Carlist[playerid][h][z_angle],Carlist[playerid][h][Status],Carlist[playerid][h][Lock],Carlist[playerid][h][Paintjob],
Carlist[playerid][h][Farbe1],Carlist[playerid][h][Farbe2],Carlist[playerid][h][mod1],Carlist[playerid][h][mod2],
Carlist[playerid][h][mod3],Carlist[playerid][h][mod4],Carlist[playerid][h][mod5],Carlist[playerid][h][mod6],
Carlist[playerid][h][mod7],Carlist[playerid][h][mod8],Carlist[playerid][h][mod9],Carlist[playerid][h][mod10],
Carlist[playerid][h][mod11],Carlist[playerid][h][mod12],Carlist[playerid][h][mod13],Carlist[playerid][h][mod14],
Carlist[playerid][h][mod15],Carlist[playerid][h][mod16],Carlist[playerid][h][mod17]);

format(string, sizeof(string),"%s`AH_SpawnSaveX`=%f,`AH_SpawnSaveY`='%f',`AH_SpawnSaveZ`='%f',`AH_SpawnSaveRot`='%f',`AH_TankVolumen`=%i,`AH_Mats`=%i,`AH_Neon`=%i,`AH_NeonType`=%i,`AH_Drugs`=%i,`AH_Versicherung`=%i,`AH_StandTime`=%i,`AH_Meter`=%i WHERE `id`=%i",
string, Carlist[playerid][h][SpawnSaveX],Carlist[playerid][h][SpawnSaveY],Carlist[playerid][h][SpawnSaveZ],
Carlist[playerid][h][SpawnSaveRot],Carlist[playerid][h][TankVolumen],Carlist[playerid][h][cMats],
Carlist[playerid][h][Neon],Carlist[playerid][h][NeonType],Carlist[playerid][h][cDrugs],Carlist[playerid][h][StandTime],
Carlist[playerid][h][Meter],Carlist[playerid][h][cid]);

self_mysql_query(string);
}
return 1;
}

Alles anzeigen

Funktioniert immer noch nicht.
[16:19:51] >> mysql_ping( Connection handle: 1 )
[16:19:51] CMySQLHandler::Ping() - Connection is still alive.
[16:19:51] >> mysql_free_result( Connection handle: 1 )
[16:19:51] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:20:48] >> mysql_ping( Connection handle: 1 )
[16:20:48] CMySQLHandler::Ping() - Connection is still alive.
[16:20:50] >> mysql_query( Connection handle: 1 )
[16:20:50] CMySQLHandler::Query(INSERT INTO `cars` (`sqlid`,`carkey`,`ingarage`,`AH_Typ`,`AH_X`,`AH_Y`,`AH_Z`,`AH_Rot`,`AH_Status`,`AH_Lock`,`AH_Paintjob`,`AH_Farbe1`,`AH_Farbe2`,`AH_Mod1`,`AH_Mod2`,`AH_Mod3`,`AH_Mod4`,`AH_Mod5`,`AH_Mod6`,`AH_Mod7`,`AH_Mod8`,`AH_Mod9`,`AH_Mod10`,`AH_Mod11`,`AH_Mod12`,`AH_Mod13`,`AH_Mod14`,`AH_Mod15`,`AH_Mod16`,`AH_Mod17`,`AH_SpawnSaveX`,`AH_SpawnSaveY`,`AH_SpawnSaveZ`,`AH_SpawnSaveRot`,`AH_TankVolumen`,`AH_Mats`,`AH_Neon`,`AH_NeonType`,`AH_Drugs`,`AH_Versicherung`,`AH_StandTime`,`AH_Meter`) VALUES (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)) - An error has occured. (Error ID: 1054, Unknown column 'AH_Mod5' in 'field list')
[16:20:50] OnQueryError() - Called.
[16:21:00] >> mysql_query( Connection handle: 1 )
[16:21:00] CMySQLHandler::Query(UPDATE `users` SET `Online` = '0' WHERE Name = 'Heaven') - Successfully executed.
[16:21:00] >> mysql_query( Connection handle: 1 )
[16:21:00] CMySQLHandler::Query(UPDATE `cars` SET `sqlid`=1,`carkey`=0,`ingarage`=0,`AH_Typ`=12,`AH_X`='748.975219',`AH_Y`='-1345.818237',`AH_Z`='13.515500',`AH_Rot`='270.000000',`AH_Status`=0,`AH_Lock`=0,`AH_Paintjob`=-1,`Farbe1`=-1,`Farbe2`=-1,`AH_mod1`=-1,`AH_mod2`=-1,`AH_mod3`=-1,`AH_mod4`=-1,`AH_mod5`=-1,`AH_mod6`=-1,`AH_mod7`=-1,`AH_mod8`=-1,`AH_mod9`=-1,`AH_mod10`=-1,`AH_mod11`=-1,`AH_mod12`=-1,`AH_mod13`=-1,`AH_mod14`=-1,`AH_mod15`=-1,`AH_mod16`=-1,`AH_mod17`=-1,`AH_SpawnSaveX`=748.975097,`AH_SpawnSaveY`='-1345.817749',`AH_SpawnSaveZ`='13.242271',`AH_SpawnSaveRot`='269.998168',`AH_TankVolumen`=100,`AH_Mats`=0,`AH_Neon`=0,`AH_NeonType`=0,`AH_Drugs`=0,`AH_Versicherung`=0,`AH_StandTime`=0,`AH_Meter`=0 WHERE `id`=) - 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 '' at line 1)
[16:21:00] >> mysql_query( Connection handle: 1 )
[16:21:00] CMySQLHandler::Query(UPDATE `cars` SET `sqlid`=1,`carkey`=1,`ingarage`=0,`AH_Typ`=-1,`AH_X`='0.000000',`AH_Y`='0.000000',`AH_Z`='0.000000',`AH_Rot`='0.000000',`AH_Status`=0,`AH_Lock`=0,`AH_Paintjob`=-1,`Farbe1`=-1,`Farbe2`=-1,`AH_mod1`=-1,`AH_mod2`=-1,`AH_mod3`=-1,`AH_mod4`=-1,`AH_mod5`=-1,`AH_mod6`=-1,`AH_mod7`=-1,`AH_mod8`=-1,`AH_mod9`=-1,`AH_mod10`=-1,`AH_mod11`=-1,`AH_mod12`=-1,`AH_mod13`=-1,`AH_mod14`=-1,`AH_mod15`=-1,`AH_mod16`=-1,`AH_mod17`=-1,`AH_SpawnSaveX`=0.000000,`AH_SpawnSaveY`='0.000000',`AH_SpawnSaveZ`='0.000000',`AH_SpawnSaveRot`='0.000000',`AH_TankVolumen`=0,`AH_Mats`=0,`AH_Neon`=0,`AH_NeonType`=0,`AH_Drugs`=0,`AH_Versicherung`=0,`AH_StandTime`=0,`AH_Meter`=0 WHERE `id`=) - 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 '' at line 1)
[16:21:00] >> mysql_query( Connection handle: 1 )
[16:21:00] CMySQLHandler::Query(UPDATE `cars` SET `sqlid`=1,`carkey`=2,`ingarage`=0,`AH_Typ`=-1,`AH_X`='0.000000',`AH_Y`='0.000000',`AH_Z`='0.000000',`AH_Rot`='0.000000',`AH_Status`=0,`AH_Lock`=0,`AH_Paintjob`=-1,`Farbe1`=-1,`Farbe2`=-1,`AH_mod1`=-1,`AH_mod2`=-1,`AH_mod3`=-1,`AH_mod4`=-1,`AH_mod5`=-1,`AH_mod6`=-1,`AH_mod7`=-1,`AH_mod8`=-1,`AH_mod9`=-1,`AH_mod10`=-1,`AH_mod11`=-1,`AH_mod12`=-1,`AH_mod13`=-1,`AH_mod14`=-1,`AH_mod15`=-1,`AH_mod16`=-1,`AH_mod17`=-1,`AH_SpawnSaveX`=0.000000,`AH_SpawnSaveY`='0.000000',`AH_SpawnSaveZ`='0.000000',`AH_SpawnSaveRot`='0.000000',`AH_TankVolumen`=0,`AH_Mats`=0,`AH_Neon`=0,`AH_NeonType`=0,`AH_Drugs`=0,`AH_Versicherung`=0,`AH_StandTime`=0,`AH_Meter`=0 WHERE `id`=) - 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 '' at line 1)
[16:21:00] >> mysql_query( Connection handle: 1 )
[16:21:00] CMySQLHandler::Query(UPDATE `users` SET `Key`='123456', `Level`='3', `AdminLevel`='2000', `DonateRank`='1', `UpgradePoints`='0', `ConnectedTime`='20', `Registered`='1', `Sex`='1', `Age`='17', `Origin`='1', `Muted`='0', `Respect`='13', `Money`='2459726', `Bank`='10882', `Allowed`='0', `wgs`='0', `Crimes`='4', `Kills`='4', `sKills`='3', `Deaths`='18', `Arrested`='0', `ArrestTime`='0', `PhoneBook`='0', `LottoNr`='0', `Fishes`='0', `BiggestFish`='0', `Job`='19', `Paycheck`='0' WHERE `Name`='Heaven') - Successfully executed.

Zitat von Jeffry

UPDATE `cars` SET `sqlid`=

public PlayerCarUpdate(playerid)
{
if(IsPlayerNPC(playerid)) return 1;
new TextString[600],TextString1[400],TextString2[200], playername[MAX_PLAYER_NAME];
GetPlayerName(playerid, playername, sizeof(playername));
for(new h = 0; h < MaxVeh[playerid]; h++)
{
format(TextString1, sizeof(TextString1), "UPDATE `cars` SET `sqlid`=%i,`carkey`=%i,`ingarage`=%i,`AH_Typ`=%i,`AH_X`='%f',`AH_Y`='%f',`AH_Z`='%f',`AH_Rot`='%f',`AH_Status`=%i,`AH_Lock`=%i,`AH_Paintjob`=%i,`Farbe1`=%i,`Farbe2`=%i,`AH_mod1`=%i,`AH_mod2`=%i,`AH_mod3`=%i,`AH_mod4`=%i,`AH_mod5`=%i,`AH_mod6`=%i,`AH_mod7`=%i,`AH_mod8`=%i,`AH_mod9`=%i,`AH_mod10`=%i,`AH_mod11`=%i,`AH_mod12`=%i,`AH_mod13`=%i,`AH_mod14`=%i,`AH_mod15`=%i,`AH_mod16`=%i,`AH_mod17`=%i,",
PlayerInfo[playerid][pSQLID],h,Carlist[playerid][h][ingarage],Carlist[playerid][h][Typ],Carlist[playerid][h][pos_x],Carlist[playerid][h][pos_y],Carlist[playerid][h][pos_z],
Carlist[playerid][h][z_angle],Carlist[playerid][h][Status],Carlist[playerid][h][Lock],Carlist[playerid][h][Paintjob],
Carlist[playerid][h][Farbe1],Carlist[playerid][h][Farbe2],Carlist[playerid][h][mod1],Carlist[playerid][h][mod2],
Carlist[playerid][h][mod3],Carlist[playerid][h][mod4],Carlist[playerid][h][mod5],Carlist[playerid][h][mod6],
Carlist[playerid][h][mod7],Carlist[playerid][h][mod8],Carlist[playerid][h][mod9],Carlist[playerid][h][mod10],
Carlist[playerid][h][mod11],Carlist[playerid][h][mod12],Carlist[playerid][h][mod13],Carlist[playerid][h][mod14],
Carlist[playerid][h][mod15],Carlist[playerid][h][mod16],Carlist[playerid][h][mod17]);

format(TextString2, sizeof(TextString2),"`AH_SpawnSaveX`=%f,`AH_SpawnSaveY`='%f',`AH_SpawnSaveZ`='%f',`AH_SpawnSaveRot`='%f',`AH_TankVolumen`=%i,`AH_Mats`=%i,`AH_Neon`=%i,`AH_NeonType`=%i,`AH_Drugs`=%i,`AH_Versicherung`=%i,`AH_StandTime`=%i,`AH_Meter`=%i WHERE `id`=%i",
Carlist[playerid][h][SpawnSaveX],Carlist[playerid][h][SpawnSaveY],Carlist[playerid][h][SpawnSaveZ],
Carlist[playerid][h][SpawnSaveRot],Carlist[playerid][h][TankVolumen],Carlist[playerid][h][cMats],
Carlist[playerid][h][Neon],Carlist[playerid][h][NeonType],Carlist[playerid][h][cDrugs],Carlist[playerid][h][StandTime],
Carlist[playerid][h][Meter],Carlist[playerid][h][cid]);

strcat(TextString,TextString1);strcat(TextString,TextString2);
self_mysql_query(TextString);
}
return 1;
}

Zitat von Jeffry

Und was sagt der MySQL Log wenn du diesen Code ausführst?
Du hast ja hoffentlich den Debug Modus aktiviert, sodass alles dort geprintet wird. Wenn nicht, mach das.

[15:46:17] CMySQLHandler::Query(INSERT INTO `cars` (`sqlid`,`carkey`,`ingarage`,`AH_Typ`,`AH_X`,`AH_Y`,`AH_Z`,`AH_Rot`,`AH_Status`,`AH_Lock`,`AH_Paintjob`,`AH_Farbe1`,`AH_Farbe2`,`AH_Mod1`,`AH_Mod2`,`AH_Mod3`,`AH_Mod4`,`AH_Mod5`,`AH_Mod6`,`AH_Mod7`,`AH_Mod8`,`AH_Mod9`,`AH_Mod10`,`AH_Mod11`,`AH_Mod12`,`AH_Mod13`,`AH_Mod14`,`AH_Mod15`,`AH_Mod16`,`AH_Mod17`,`AH_SpawnSaveX`,`AH_SpawnSaveY`,`AH_SpawnSaveZ`,`AH_SpawnSaveRot`,`AH_TankVolumen`,`AH_Mats`,`AH_Neon`,`AH_NeonType`,`AH_Drugs`,`AH_Versicherung`,`AH_StandTime`,`AH_Meter`) VALUES (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)) - An error has occured. (Error ID: 1054, Unknown column 'AH_Mod5' in 'field list')
[15:46:17] OnQueryError() - Called.
[15:46:21] >> mysql_query( Connection handle: 1 )
[15:46:21] CMySQLHandler::Query(UPDATE `users` SET `Online` = '0' WHERE Name = 'Heaven') - An error has occured. (Error ID: 1054, Unknown column 'Online' in 'field list')
[15:46:21] >> mysql_query( Connection handle: 1 )
[15:46:21] CMySQLHandler::Query(UPDATE `cars` SET `sqlid`=1,`carkey`=0,`ingarage`=0,`AH_Typ`=8,`AH_X`='748.975219',`AH_Y`='-1345.818237',`AH_Z`='13.515500',`AH_Rot`='270.000000',`AH_Status`=0,`AH_Lock`=0,`AH_Paintjob`=-1,`Farbe1`=-1,`Farbe2`=-1,`AH_mod1`=-1,`AH_mod2`=-1,`AH_mod3`=-1,`AH_mod4`=-1,`AH_mod5`=-1,`AH_mod6`=-1,`AH_mod7`=-1,`AH_mod8`=-1,`AH_mod9`=-1,`AH_mod10`=-1,`AH_mod11`=-1,`AH_mod12`=-1,`AH_mod13`=-1,`AH_mod14`=-1`AH_SpawnSaveX`=748.969055,`AH_SpawnSaveY`='-1345.818969',`AH_SpawnSaveZ`='13.115738',`AH_SpawnSaveRot`='270.000366',`AH_TankVolumen`=100,`AH_Mats`=0,`AH_Neon`=0,`AH_NeonType`=0,`AH_Drugs`=0,`AH_Vers) - 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 '`AH_SpawnSaveX`=748.969055,`AH_SpawnSaveY`='-1345.818969',`AH_SpawnSaveZ`='13.11' at line 1)
[15:46:21] >> mysql_query( Connection handle: 1 )
[15:46:21] CMySQLHandler::Query(UPDATE `cars` SET `sqlid`=1,`carkey`=0,`ingarage`=0,`AH_Typ`=8,`AH_X`='748.975219',`AH_Y`='-1345.818237',`AH_Z`='13.515500',`AH_Rot`='270.000000',`AH_Status`=0,`AH_Lock`=0,`AH_Paintjob`=-1,`Farbe1`=-1,`Farbe2`=-1,`AH_mod1`=-1,`AH_mod2`=-1,`AH_mod3`=-1,`AH_mod4`=-1,`AH_mod5`=-1,`AH_mod6`=-1,`AH_mod7`=-1,`AH_mod8`=-1,`AH_mod9`=-1,`AH_mod10`=-1,`AH_mod11`=-1,`AH_mod12`=-1,`AH_mod13`=-1,`AH_mod14`=-1`AH_SpawnSaveX`=748.969055,`AH_SpawnSaveY`='-1345.818969',`AH_SpawnSaveZ`='13.115738',`AH_SpawnSaveRot`='270.000366',`AH_TankVolumen`=100,`AH_Mats`=0,`AH_Neon`=0,`AH_NeonType`=0,`AH_Drugs`=0,`AH_VersU) - 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 '`AH_SpawnSaveX`=748.969055,`AH_SpawnSaveY`='-1345.818969',`AH_SpawnSaveZ`='13.11' at line 1)
[15:46:21] >> mysql_query( Connection handle: 1 )
[15:46:21] CMySQLHandler::Query(UPDATE `cars` SET `sqlid`=1,`carkey`=0,`ingarage`=0,`AH_Typ`=8,`AH_X`='748.975219',`AH_Y`='-1345.818237',`AH_Z`='13.515500',`AH_Rot`='270.000000',`AH_Status`=0,`AH_Lock`=0,`AH_Paintjob`=-1,`Farbe1`=-1,`Farbe2`=-1,`AH_mod1`=-1,`AH_mod2`=-1,`AH_mod3`=-1,`AH_mod4`=-1,`AH_mod5`=-1,`AH_mod6`=-1,`AH_mod7`=-1,`AH_mod8`=-1,`AH_mod9`=-1,`AH_mod10`=-1,`AH_mod11`=-1,`AH_mod12`=-1,`AH_mod13`=-1,`AH_mod14`=-1`AH_SpawnSaveX`=748.969055,`AH_SpawnSaveY`='-1345.818969',`AH_SpawnSaveZ`='13.115738',`AH_SpawnSaveRot`='270.000366',`AH_TankVolumen`=100,`AH_Mats`=0,`AH_Neon`=0,`AH_NeonType`=0,`AH_Drugs`=0,`AH_VersU) - 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 '`AH_SpawnSaveX`=748.969055,`AH_SpawnSaveY`='-1345.818969',`AH_SpawnSaveZ`='13.11' at line 1)
[15:46:21] >> mysql_query( Connection handle: 1 )
[15:46:21] CMySQLHandler::Query(UPDATE `users` SET `Key`='123456', `Level`='3', `AdminLevel`='2000', `DonateRank`='1', `UpgradePoints`='0', `ConnectedTime`='20', `Registered`='1', `Sex`='1', `Age`='17', `Origin`='1', `Muted`='0', `Respect`='13', `Money`='14726', `Bank`='10882', `Allowed`='0', `wgs`='0', `Crimes`='4', `Kills`='4', `sKills`='3', `Deaths`='18', `Arrested`='0', `ArrestTime`='0', `PhoneBook`='0', `LottoNr`='0', `Fishes`='0', `BiggestFish`='0', `Job`='19', `Paycheck`='0' WHERE `Name`='Heaven') - Successfully executed.
[15:46:21] >> mysql_query( Connection handle: 1 )
[15:46:21] CMySQLHandler::Query(UPDATE `users` SET `HeadValue`='0', `Jailed`='0', `JailTime`='0', `Leader`='0', `Member`='0', `Rank`='12', `Skin`='3', `Vertragszeit`='0', `DetSkill`='0', `SexSkill`='0', `LawSkill`='0', `MechSkill`='0', `JackSkill`='0' WHERE `Name`='Heaven') - Successfully executed.
[15:46:21] >> mysql_query( Connection handle: 1 )
[15:46:21] CMySQLHandler::Query(UPDATE `users` SET `CarSkill`='0', `NewsSkill`='0', `DrugsSkill`='0', `CookSkill`='0', `FishSkill`='0', `pSHealth`='50.0', `PhoneNr`='0', `House`='-1', `Biz`='-1', `CarLic`='1', `FlyLic`='0', `BoatLic`='0', `FishLic`='0', `GunLic`='0', `Zollpass`='0' WHERE `Name`='Heaven') - Successfully executed.
[15:46:21] >> mysql_query( Connection handle: 1 )
[15:46:21] CMySQLHandler::Query(UPDATE `users` SET `Gun1`='0', `Gun2`='0', `Gun3`='0', `Gun4`='0', `Ammo1`='0', `Ammo2`='0', `Ammo3`='0', `Ammo4`='0', `CarTime`='0', `PayDay`='4', `PayDayHad`='0', `CDPlayer`='0', `AlcoholPerk`='0', `PainKillerPerk`='0', `DrugPerk`='0', `MiserPerk`='0', `TraderPerk`='0', `Tutorial`='1', `Warnings`='0' WHERE `Name`='Heaven') - Successfully executed.
[15:46:21] >> mysql_query( Connection handle: 1 )
[15:46:21] CMySQLHandler::Query(UPDATE `users` SET `Fuel`='0', `Married`='0', `MarriedTo`='Niemand', `WantedLevel`='2', `Spawn`='0', `SavedMaterials`='0', `SavedDrugs`='0', `BikeLic`='0', `LKWLic`='0', `DonatorTime`='-1', `WerberName`='geht hier', `FightingStyle`='0', `Handy`='0' WHERE `Name`='Heaven') - Successfully executed.
[15:46:21] >> mysql_query( Connection handle: 1 )
[15:46:21] CMySQLHandler::Query(UPDATE `users` SET `OnDutySkin`='0', `CarLicPoints`='0', `BikeLicPoints`='0', `warntime1`='0', `warntime2`='0', `Ticketsopen`='0', `DonatorTime`='-1', `OldName`='NULL', `ClientIP`='109.193.63.11', `OrgMember`='-1', `OrgLeader`='-1', `OrgName`='Keine'`Onlinne`=''`Festgeld`=12000`Festgeldpd`=0 `Tot`=0`BusSkill`=0`Paket`=0`Krankenhaus`=0`Krankenhaus`=0 WHERE `Name`='Heaven') - 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 '`Onlinne`=''`Festgeld`=12000`Festgeldpd`=0 `Tot`=0`BusSkill`=0`Paket`=0`Krankenh' at line 1)
[15:46:21] OnQueryError() - Called.
[15:46:21] OnQueryError() - Called.
[15:46:21] OnQueryError() - Called.
[15:46:21] OnQueryError() - Called.
[15:46:21] OnQueryError() - Called.

Zitat von Jeffry

Du sollst es aktivieren.

Und dann den Code ausführen, der dir Fehler bringt.

Code:

public PlayerCarConnect(playerid)
{
if(IsPlayerNPC(playerid))
{
return 1;
}
new playername[MAX_PLAYER_NAME];
GetPlayerName(playerid, playername, sizeof(playername));
for(new h = 0; h < MaxVeh[playerid]; h++)
{
new data[100],TextString[50];
format(TextString, sizeof(TextString), "SELECT * FROM `cars` WHERE `id`=%i", PlayerInfo[playerid][pSQLID]);
self_mysql_query(TextString);
mysql_store_result(MySQLConnection);
if(mysql_num_rows(MySQLConnection) != 0)
{
mysql_fetch_row_format(TextString);
self_mysql_get_field("id", data); Carlist[playerid][h][cid] = strval( data );
self_mysql_get_field("sqlid", data); Carlist[playerid][h][sqlid] = strval( data );
self_mysql_get_field("ingarage", data); Carlist[playerid][h][ingarage] = strval( data );
self_mysql_get_field("AH_Typ", data); Carlist[playerid][h][Typ] = strval( data );
self_mysql_get_field("AH_X", data); Carlist[playerid][h][pos_x] = floatstr( data );
self_mysql_get_field("AH_Y", data); Carlist[playerid][h][pos_y] = floatstr( data );
self_mysql_get_field("AH_Z", data); Carlist[playerid][h][pos_z] = floatstr( data );
self_mysql_get_field("AH_Rot", data); Carlist[playerid][h][z_angle] = floatstr( data );
self_mysql_get_field("AH_Status", data); Carlist[playerid][h][Status] = strval( data );
self_mysql_get_field("AH_Lock", data); Carlist[playerid][h][Lock] = strval( data );
self_mysql_get_field("AH_Paintjob", data); Carlist[playerid][h][Paintjob] = strval( data );
self_mysql_get_field("AH_Farbe1", data); Carlist[playerid][h][Farbe1] = strval( data );
self_mysql_get_field("AH_Farbe2", data); Carlist[playerid][h][Farbe2] = strval( data );
self_mysql_get_field("AH_mod1", data); Carlist[playerid][h][mod1] = strval( data );
self_mysql_get_field("AH_mod2", data); Carlist[playerid][h][mod2] = strval( data );
self_mysql_get_field("AH_mod3", data); Carlist[playerid][h][mod3] = strval( data );
self_mysql_get_field("AH_mod4", data); Carlist[playerid][h][mod4] = strval( data );
self_mysql_get_field("AH_mod5", data); Carlist[playerid][h][mod5] = strval( data );
self_mysql_get_field("AH_mod6", data); Carlist[playerid][h][mod6] = strval( data );
self_mysql_get_field("AH_mod7", data); Carlist[playerid][h][mod7] = strval( data );
self_mysql_get_field("AH_mod8", data); Carlist[playerid][h][mod8] = strval( data );
self_mysql_get_field("AH_mod9", data); Carlist[playerid][h][mod9] = strval( data );
self_mysql_get_field("AH_mod10", data); Carlist[playerid][h][mod10] = strval( data );
self_mysql_get_field("AH_mod11", data); Carlist[playerid][h][mod11] = strval( data );
self_mysql_get_field("AH_mod12", data); Carlist[playerid][h][mod12] = strval( data );
self_mysql_get_field("AH_mod13", data); Carlist[playerid][h][mod13] = strval( data );
self_mysql_get_field("AH_mod14", data); Carlist[playerid][h][mod14] = strval( data );
self_mysql_get_field("AH_mod15", data); Carlist[playerid][h][mod15] = strval( data );
self_mysql_get_field("AH_mod16", data); Carlist[playerid][h][mod16] = strval( data );
self_mysql_get_field("AH_mod17", data); Carlist[playerid][h][mod17] = strval( data );
self_mysql_get_field("AH_SpawnSaveX", data); Carlist[playerid][h][SpawnSaveX] = floatstr( data );
self_mysql_get_field("AH_SpawnSaveY", data); Carlist[playerid][h][SpawnSaveY] = floatstr( data );
self_mysql_get_field("AH_SpawnSaveZ", data); Carlist[playerid][h][SpawnSaveZ] = floatstr( data );
self_mysql_get_field("AH_SpawnSaveRot", data); Carlist[playerid][h][SpawnSaveRot] = floatstr( data );
self_mysql_get_field("AH_TankVolumen", data); Carlist[playerid][h][TankVolumen] = strval( data );
self_mysql_get_field("AH_Mats", data); Carlist[playerid][h][cMats] = strval(data);
self_mysql_get_field("AH_Neon", data); Carlist[playerid][h][Neon] = strval(data);
self_mysql_get_field("AH_NeonType", data); Carlist[playerid][h][NeonType] = strval(data);
self_mysql_get_field("AH_Drugs", data); Carlist[playerid][h][cDrugs] = strval(data);
self_mysql_get_field("AH_StandTime", data); Carlist[playerid][h][StandTime] = strval(data);
self_mysql_get_field("AH_Meter", data); Carlist[playerid][h][Meter] = strval(data);
if(Carlist[playerid][h][Typ] != -1 && Carlist[playerid][h][Status] == 0){
printf("Fahrzeugspeicherung: Beginning Spawn.");
Carlist[playerid][h][Carid] = CreateTunedCar(playerid, h);
printf("Fahrzeugspeicherung: End Spawn.");}

}
}
return 1;
}

stock mysql_GetIntCar(Table[], Is[])
{
new query[128];
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Is, Is);
format(query, 128, "SELECT %s FROM usercars WHERE Name = '%s' AND `CarSlotID`='0' ", Table, Is);
mysql_query(query);
mysql_store_result();
new sqlint = mysql_fetch_int();
mysql_free_result();
return sqlint;
}

stock Float:mysql_GetFloatCar(Table[], Is[])
{
new query[128], Float:sqlfloat;
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Is, Is);
format(query, 128, "SELECT %s FROM usercars WHERE Name = '%s' AND `CarSlotID`='0' ", Table, Is);
mysql_query(query);
mysql_store_result();
mysql_fetch_float(sqlfloat);
mysql_free_result();
return sqlfloat;
}
stock Float:mysql_GetFloatCartoo(Table[], Is[])
{
new query[128], Float:sqlfloat;
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Is, Is);
format(query, 128, "SELECT %s FROM usercars WHERE Name = '%s' AND `CarSlotID`='1' ", Table, Is);
mysql_query(query);
mysql_store_result();
mysql_fetch_float(sqlfloat);
mysql_free_result();
return sqlfloat;
}
stock mysql_GetIntCartoo(Table[], Is[])
{
new query[128];
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Is, Is);
format(query, 128, "SELECT %s FROM usercars WHERE Name = '%s' AND `CarSlotID`='1' ", Table, Is);
mysql_query(query);
mysql_store_result();
new sqlint = mysql_fetch_int();
mysql_free_result();
return sqlint;
}

Zitat von Jeffry

Dann schalte mal den MySQL Debug Modus an und poste was im MySQL Log geprintet wird.
Wie du das machst siehst du hier: Tipps: Scripting-Probleme richtig erklären (Kapitel 1.4)

[13:29:38] >> mysql_connect( )
[13:29:38] CMySQLHandler::CMySQLHandler() - constructor called.
[13:29:38] CMySQLHandler::CMySQLHandler() - Connecting to "" | DB: "" | Username: "" ...
[13:29:38] CMySQLHandler::Connect() - Connection was successful.
[13:29:38] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[13:29:38] ---------------------------
[13:29:38] MySQL Debugging de-activated
[13:29:38] ---------------------------

Zitat von PermanenT

Hey,
Krass schöner Fehler.
Ach warte der steht hier ja garnicht
merkst du den Fehler?

Fail.
Es werden keine Querys gesendet. Code stimmmt