MySQL Plugin R5 Problem

Guten Tag,
Mein MySQL Plugin R5 weist fehler auf und nun suche ich nac heiner Lösung.
Danke im vorraus,
Mfg, Daniel

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

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 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

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

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

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

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

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

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