MySQL Problem bei Autosystem

Unique! · 13. Oktober 2013

Hallo Community,

ich habe gerade mein Autosystem "fertig" umgeschrieben und dabei ein Problem entdeckt. Ich kann mich in das Auto setzen und es zeigt mir auch den Dialog an, aber wenn ich auf Kaufen klicke passiert nichts. Im .log von der MySQL kommt auch kein Error, man sieht aber, dass er etwas abgefragt hat. Hier mal kurz der Abschnitt der File:

Code

[10:56:04] CMySQLHandler::Query(SELECT * FROM pAutos WHERE aOwner='ChaoZz__' AND aCarkey='0') - Successfully executed.


[10:56:04] >> mysql_store_result( Connection handle: 1 )


[10:56:04] CMySQLHandler::StoreResult() - Result was stored.


[10:56:04] >> mysql_num_rows( Connection handle: 1 )


[10:56:04] CMySQLHandler::NumRows() - Returned 0 row(s)


[10:56:04] >> mysql_free_result( Connection handle: 1 )


[10:56:04] CMySQLHandler::FreeResult() - Result was successfully free'd.


[10:56:04] >> mysql_query( Connection handle: 1 )


[10:56:04] CMySQLHandler::Query(SELECT * FROM pAutos WHERE aOwner='ChaoZz__' AND aCarkey='1') - Successfully executed.


[10:56:04] >> mysql_store_result( Connection handle: 1 )


[10:56:04] CMySQLHandler::StoreResult() - Result was stored.


[10:56:04] >> mysql_num_rows( Connection handle: 1 )


[10:56:04] CMySQLHandler::NumRows() - Returned 0 row(s)


[10:56:04] >> mysql_free_result( Connection handle: 1 )


[10:56:04] CMySQLHandler::FreeResult() - Result was successfully free'd.


[10:56:04] >> mysql_query( Connection handle: 1 )


[10:56:04] CMySQLHandler::Query(SELECT * FROM pAutos WHERE aOwner='ChaoZz__' AND aCarkey='2') - Successfully executed.


[10:56:04] >> mysql_store_result( Connection handle: 1 )


[10:56:04] CMySQLHandler::StoreResult() - Result was stored.


[10:56:04] >> mysql_num_rows( Connection handle: 1 )


[10:56:04] CMySQLHandler::NumRows() - Returned 0 row(s)


[10:56:04] >> mysql_free_result( Connection handle: 1 )


[10:56:04] CMySQLHandler::FreeResult() - Result was successfully free'd.


[10:56:04] >> mysql_query( Connection handle: 1 )


[10:56:04] CMySQLHandler::Query(SELECT * FROM pAutos WHERE aOwner='ChaoZz__' AND aCarkey='0') - Successfully executed.


[10:56:04] >> mysql_store_result( Connection handle: 1 )


[10:56:04] CMySQLHandler::StoreResult() - Result was stored.


[10:56:04] >> mysql_num_rows( Connection handle: 1 )


[10:56:04] CMySQLHandler::NumRows() - Returned 0 row(s)


[10:56:04] >> mysql_free_result( Connection handle: 1 )


[10:56:04] CMySQLHandler::FreeResult() - Result was successfully free'd.


[10:56:04] >> mysql_query( Connection handle: 1 )


[10:56:04] CMySQLHandler::Query(SELECT * FROM pAutos WHERE aOwner='ChaoZz__' AND aCarkey='1') - Successfully executed.


[10:56:04] >> mysql_store_result( Connection handle: 1 )


[10:56:04] CMySQLHandler::StoreResult() - Result was stored.


[10:56:04] >> mysql_num_rows( Connection handle: 1 )


[10:56:04] CMySQLHandler::NumRows() - Returned 0 row(s)


[10:56:04] >> mysql_free_result( Connection handle: 1 )


[10:56:04] CMySQLHandler::FreeResult() - Result was successfully free'd.


[10:56:04] >> mysql_query( Connection handle: 1 )


[10:56:04] CMySQLHandler::Query(SELECT * FROM pAutos WHERE aOwner='ChaoZz__' AND aCarkey='2') - Successfully executed.


[10:56:04] >> mysql_store_result( Connection handle: 1 )


[10:56:04] CMySQLHandler::StoreResult() - Result was stored.


[10:56:04] >> mysql_num_rows( Connection handle: 1 )


[10:56:04] CMySQLHandler::NumRows() - Returned 0 row(s)


[10:56:04] >> mysql_free_result( Connection handle: 1 )


[10:56:04] CMySQLHandler::FreeResult() - Result was successfully free'd.


[10:56:07] >> mysql_real_escape_string( Connection handle: 1 )


[10:56:07] CMySQLHandler::EscapeString(ChaoZz__); - Escaped 8 characters to ChaoZz__.


[10:56:07] >> mysql_query( Connection handle: 1 )

Alles anzeigen

Man sieht, dass er die Abfrage 2 mal macht und bei mysql_num_rows 0 raus kommt. Hier mal der Code für die Abfrage:

stock mysql_CheckAuto(CName[],Slot)
{
new Query[128],count;
format(Query, sizeof(Query), "SELECT * FROM pAutos WHERE aOwner='%s' AND aCarkey='%i'", CName,Slot);
mysql_query(Query);
mysql_store_result();
count = mysql_num_rows();
mysql_free_result();
return count;
}

Aber wenn ich auf kaufen klicke passiert gar nichts. Der Code von "OnDialogResponse":
else if(dialogid == DIALOG_AUTOKAUF)
{
if(!response)return RemovePlayerFromVehicle(playerid);
if(response)
{
new vid = GetPlayerVehicleID(playerid);
for(new i = 0; i < sizeof Buycars; i++)
{
if(vid == kaufauto[i])
{
for(new a=0;a < MAX_CARS_PER_PLAYER;a++){
if(mysql_CheckAuto(PlayerName(playerid),a) == 0){
AutoKaufen(playerid,a,i);
RemovePlayerFromVehicle(playerid);
return 1;
}
else continue;
}
}
}
SendClientMessage(playerid,COLOR_GREY," Du besitzt schon die maximale Anzahl an Fahrzeugen!");
}
}

Ich frage mich was ich hier falsch mache Ich hatte schon mehrmals überprüft und nachgedacht, aber nichts gefunden. Es wäre super lieb von euch wenn ihr mir helfen könnten. Einen schönen Sonntag noch

Mit freundlichen Grüßen
Ch4oS

Slash™ · 13. Oktober 2013

Also wenn ich das richtig verstehe kann man ein auto haben, und du willst auslesen ob der spieler schon ein auto hat oder verstehe ich das falsch?
Wenn es soo ist kannst du es doch auch einfacher mit einer variable machen

Unique! · 13. Oktober 2013

Verstehe ich nciht ganz. Also wenn man bereits ein Auto hat zum Beispiel soll es nach einem freien Slot schauen. Wenn einer vorhanden ist soll er in der Tabelle in der DB dann das Auto erstellen. Aber soweit kommt es gar nicht.

Slash™ · 13. Oktober 2013

probiere mal das return 1; weg zunehmen, da es ja eig die schleife unterbricht, else continue; auch mal wegnehmen, weil es geht die schleife ja normal weiter durch

Unique! · 13. Oktober 2013

Dann würde er aber mir 3 Autos spawnen und in die Datenbank schreiben

Slash™ · 13. Oktober 2013

okay dann lasse das return aber das else lass weg, sonst habe ich auch kein plan mehr.

Unique! · 13. Oktober 2013

Also das else kann ja auch weg bleiben stimmt, aber es klappt immer noch nicht Werde mir mal kurz den ganzen Prozess printen lassen

edit: Hab's hinbekommen, nur ich habe nun noch ein Problem wenn ich mein Auto modifiziere, dann speichert er das nicht. Es ist auch ein Error da in der log. Hier mal der Error:

Code

[11:53:31] CMySQLHandler::Query(UPADTE `pAutos` SET `aColor1` = '2' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = '') - 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 'UPADTE `pAutos` SET `aColor1` = '2' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = ' at line 1)


[11:53:31] >> mysql_query( Connection handle: 1 )


[11:53:31] CMySQLHandler::Query(UPADTE `pAutos` SET `aColor2` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = '') - 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 'UPADTE `pAutos` SET `aColor2` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = ' at line 1)


[11:53:32] >> mysql_query( Connection handle: 1 )


[11:53:32] CMySQLHandler::Query(UPADTE `pAutos` SET `aSpoiler` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = '') - 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 'UPADTE `pAutos` SET `aSpoiler` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` =' at line 1)


[11:53:32] >> mysql_query( Connection handle: 1 )


[11:53:32] CMySQLHandler::Query(UPADTE `pAutos` SET `aHood` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = '') - 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 'UPADTE `pAutos` SET `aHood` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = ''' at line 1)


[11:53:32] >> mysql_query( Connection handle: 1 )


[11:53:32] CMySQLHandler::Query(UPADTE `pAutos` SET `aRoof` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = '') - 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 'UPADTE `pAutos` SET `aRoof` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = ''' at line 1)


[11:53:32] >> mysql_query( Connection handle: 1 )


[11:53:32] CMySQLHandler::Query(UPADTE `pAutos` SET `aSideskirt` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = '') - 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 'UPADTE `pAutos` SET `aSideskirt` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey`' at line 1)


[11:53:32] >> mysql_query( Connection handle: 1 )


[11:53:32] CMySQLHandler::Query(UPADTE `pAutos` SET `aLamps` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = '') - 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 'UPADTE `pAutos` SET `aLamps` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = '' at line 1)


[11:53:32] >> mysql_query( Connection handle: 1 )


[11:53:32] CMySQLHandler::Query(UPADTE `pAutos` SET `aNitro` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = '') - 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 'UPADTE `pAutos` SET `aNitro` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = '' at line 1)


[11:53:32] >> mysql_query( Connection handle: 1 )


[11:53:32] CMySQLHandler::Query(UPADTE `pAutos` SET `aExhaust` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = '') - 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 'UPADTE `pAutos` SET `aExhaust` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` =' at line 1)


[11:53:32] >> mysql_query( Connection handle: 1 )


[11:53:32] CMySQLHandler::Query(UPADTE `pAutos` SET `aWheels` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = '') - 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 'UPADTE `pAutos` SET `aWheels` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = ' at line 1)


[11:53:32] >> mysql_query( Connection handle: 1 )


[11:53:32] CMySQLHandler::Query(UPADTE `pAutos` SET `aStereo` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = '') - 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 'UPADTE `pAutos` SET `aStereo` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = ' at line 1)


[11:53:32] >> mysql_query( Connection handle: 1 )


[11:53:32] CMySQLHandler::Query(UPADTE `pAutos` SET `aHydraulics` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = '') - 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 'UPADTE `pAutos` SET `aHydraulics` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey' at line 1)


[11:53:32] >> mysql_query( Connection handle: 1 )


[11:53:32] CMySQLHandler::Query(UPADTE `pAutos` SET `aFrontBumper` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = '') - 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 'UPADTE `pAutos` SET `aFrontBumper` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarke' at line 1)


[11:53:32] >> mysql_query( Connection handle: 1 )


[11:53:32] CMySQLHandler::Query(UPADTE `pAutos` SET `aRearBumper` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = '') - 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 'UPADTE `pAutos` SET `aRearBumper` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey' at line 1)


[11:53:32] >> mysql_query( Connection handle: 1 )


[11:53:32] CMySQLHandler::Query(UPADTE `pAutos` SET `aVentRight` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = '') - 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 'UPADTE `pAutos` SET `aVentRight` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey`' at line 1)


[11:53:32] >> mysql_query( Connection handle: 1 )


[11:53:32] CMySQLHandler::Query(UPADTE `pAutos` SET `aVentLeft` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = '') - 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 'UPADTE `pAutos` SET `aVentLeft` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` ' at line 1)


[11:53:35] >> mysql_query( Connection handle: 1 )

Alles anzeigen

Bei aCarkey ist nichts hier mal der Code von OnVehicleMod:
new query[512];
format(query,sizeof query,"UPADTE `pAutos` SET `aSpoiler` = '%i' WHERE `aOwner` = '%s' AND `aCarkey` = '%s'",GetVehicleComponentInSlot(Spielercar[p][i],0),PlayerName(p),i);
mysql_query(query);
format(query,sizeof query,"UPADTE `pAutos` SET `aHood` = '%i' WHERE `aOwner` = '%s' AND `aCarkey` = '%s'",GetVehicleComponentInSlot(Spielercar[p][i],1),PlayerName(p),i);
mysql_query(query);
format(query,sizeof query,"UPADTE `pAutos` SET `aRoof` = '%i' WHERE `aOwner` = '%s' AND `aCarkey` = '%s'",GetVehicleComponentInSlot(Spielercar[p][i],2),PlayerName(p),i);
mysql_query(query);
format(query,sizeof query,"UPADTE `pAutos` SET `aSideskirt` = '%i' WHERE `aOwner` = '%s' AND `aCarkey` = '%s'",GetVehicleComponentInSlot(Spielercar[p][i],3),PlayerName(p),i);
mysql_query(query);
format(query,sizeof query,"UPADTE `pAutos` SET `aLamps` = '%i' WHERE `aOwner` = '%s' AND `aCarkey` = '%s'",GetVehicleComponentInSlot(Spielercar[p][i],4),PlayerName(p),i);
mysql_query(query);
format(query,sizeof query,"UPADTE `pAutos` SET `aNitro` = '%i' WHERE `aOwner` = '%s' AND `aCarkey` = '%s'",GetVehicleComponentInSlot(Spielercar[p][i],5),PlayerName(p),i);
mysql_query(query);
format(query,sizeof query,"UPADTE `pAutos` SET `aExhaust` = '%i' WHERE `aOwner` = '%s' AND `aCarkey` = '%s'",GetVehicleComponentInSlot(Spielercar[p][i],6),PlayerName(p),i);
mysql_query(query);
format(query,sizeof query,"UPADTE `pAutos` SET `aWheels` = '%i' WHERE `aOwner` = '%s' AND `aCarkey` = '%s'",GetVehicleComponentInSlot(Spielercar[p][i],7),PlayerName(p),i);
mysql_query(query);
format(query,sizeof query,"UPADTE `pAutos` SET `aStereo` = '%i' WHERE `aOwner` = '%s' AND `aCarkey` = '%s'",GetVehicleComponentInSlot(Spielercar[p][i],8),PlayerName(p),i);
mysql_query(query);
format(query,sizeof query,"UPADTE `pAutos` SET `aHydraulics` = '%i' WHERE `aOwner` = '%s' AND `aCarkey` = '%s'",GetVehicleComponentInSlot(Spielercar[p][i],9),PlayerName(p),i);
mysql_query(query);
format(query,sizeof query,"UPADTE `pAutos` SET `aFrontBumper` = '%i' WHERE `aOwner` = '%s' AND `aCarkey` = '%s'",GetVehicleComponentInSlot(Spielercar[p][i],10),PlayerName(p),i);
mysql_query(query);
format(query,sizeof query,"UPADTE `pAutos` SET `aRearBumper` = '%i' WHERE `aOwner` = '%s' AND `aCarkey` = '%s'",GetVehicleComponentInSlot(Spielercar[p][i],11),PlayerName(p),i);
mysql_query(query);
format(query,sizeof query,"UPADTE `pAutos` SET `aVentRight` = '%i' WHERE `aOwner` = '%s' AND `aCarkey` = '%s'",GetVehicleComponentInSlot(Spielercar[p][i],12),PlayerName(p),i);
mysql_query(query);
format(query,sizeof query,"UPADTE `pAutos` SET `aVentLeft` = '%i' WHERE `aOwner` = '%s' AND `aCarkey` = '%s'",GetVehicleComponentInSlot(Spielercar[p][i],13),PlayerName(p),i);
mysql_query(query);

Slash™ · 13. Oktober 2013

warum soviele querys?
Du hast nen syntax error, checke mal deine querys genau nach der form

Unique! · 13. Oktober 2013

Hab es gefunden ok Es sollen ja alle geupdatet werden also alle komponenten, die geändert werden. Weiß keine methode um es zu vereinfachen. Ich habe kein SaveCar weil ich zu blöd dafür bin

Slash™ · 13. Oktober 2013

jap aber dafür brauchst du nicht für jeden 1 query, kannst auch mehrere in einem packen

format(query,sizeof query,"UPADTE `pAutos` SET `aSpoiler` = '%i',`aHood` = '%i' WHERE `aOwner` = '%s' AND `aCarkey` = '%s'",GetVehicleComponentInSlot(Spielercar[p][i],0),GetVehicleComponentInSlot(Spielercar[p][i],1),PlayerName(p),i);

so zb

Unique! · 13. Oktober 2013

Funktioniert imemr noch nicht Er 'veschluckt einige teile wie man jetzt im log sehen kann:

Code

(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 'UPADTE `pAutos` SET `aColor1` = '1' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = ' at line 1)
(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 'UPADTE `pAutos` SET `aColor2` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = ' at line 1)
(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 'UPADTE `pAutos` SET `aSideskirt` = '0' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey`' at line 1)

Edit:
Am besten sieht man das beim Parken:

Code

[15:12:04] CMySQLHandler::Query(UPADTE `pAutos` SET `aPosX` = '443.944061' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = '') - 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 'UPADTE `pAutos` SET `aPosX` = '443.944061' WHERE `aOwner` = 'ChaoZz__' AND `aCar' at line 1)


[15:12:04] >> mysql_query( Connection handle: 1 )


[15:12:04] CMySQLHandler::Query(UPADTE `pAutos` SET `aPosY` = '-1737.312255' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = '') - 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 'UPADTE `pAutos` SET `aPosY` = '-1737.312255' WHERE `aOwner` = 'ChaoZz__' AND `aC' at line 1)


[15:12:04] >> mysql_query( Connection handle: 1 )


[15:12:04] CMySQLHandler::Query(UPADTE `pAutos` SET `aPosZ` = '9.108406' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = '') - 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 'UPADTE `pAutos` SET `aPosZ` = '9.108406' WHERE `aOwner` = 'ChaoZz__' AND `aCarke' at line 1)


[15:12:04] >> mysql_query( Connection handle: 1 )


[15:12:04] CMySQLHandler::Query(UPADTE `pAutos` SET `aPosA` = '359.400085' WHERE `aOwner` = 'ChaoZz__' AND `aCarkey` = '') - 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 'UPADTE `pAutos` SET `aPosA` = '359.400085' WHERE `aOwner` = 'ChaoZz__' AND `aCar' at line 1)


[15:12:31] >> mysql_real_escape_string( Connection handle: 1 )

Alles anzeigen

Fabi.StaR · 13. Oktober 2013

Du willst du den CarKey einfügen/auslessen dann mach anstat :`aCarkey` = '%s' das : `aCarkey` = '%d'

Slash™ · 13. Oktober 2013

wie fabi sagt, du möchtest doch nen integer also %d oder %i
%s ist ein string also ein wort etc.

Fabi.StaR · 13. Oktober 2013

das wiess ich un %d ist ein string odder ein Int :))

Unique! · 13. Oktober 2013

Hatte ich vor ner Stunde auch gesehen und schon behoben, aber es funktionierte danach auch nicht

Slash™ · 13. Oktober 2013

zeig mal den completten public wo du das speicherst.

Unique! · 13. Oktober 2013

Speichere das gleich wenn es passiert, wobei ich denke das umzuschreiben:
if(strcmp(cmd, "/parken", true) == 0 || strcmp(cmd, "/park", true) == 0)
{
if(!IsPlayerInAnyVehicle(playerid)) return SendClientMessage(playerid,COLOR_GREY," Du musst in einem Fahrzeug sitzen, um es zu parken!");
if(GetPlayerState(playerid) != PLAYER_STATE_DRIVER)return SendClientMessage(playerid,COLOR_GREY," Du musst der Fahrer dieses Fahrzeuges sein, um es zu parken!");
new vehicleid = GetPlayerVehicleID(playerid);
for(new i = 0; i < MAX_CARS_PER_PLAYER; i++)
{
if(vehicleid == Spielercar[playerid][i])
{
new Float:x, Float:y, Float:z, Float:a;
GetVehiclePos(vehicleid,x,y,z);
GetVehicleZAngle(vehicleid,a);
Autos[playerid][i][aPosX] = x;
Autos[playerid][i][aPosY] = y;
Autos[playerid][i][aPosZ] = z;
Autos[playerid][i][aPosA] = a;
new query[512];
format(query,sizeof query,"UPADTE `pAutos` SET `aPosX` = '%f' WHERE `aOwner` = '%s' AND `aCarkey` = '%i'",x,PlayerName(playerid),i);
mysql_query(query);
format(query,sizeof query,"UPADTE `pAutos` SET `aPosY` = '%f' WHERE `aOwner` = '%s' AND `aCarkey` = '%i'",y,PlayerName(playerid),i);
mysql_query(query);
format(query,sizeof query,"UPADTE `pAutos` SET `aPosZ` = '%f' WHERE `aOwner` = '%s' AND `aCarkey` = '%i'",z,PlayerName(playerid),i);
mysql_query(query);
format(query,sizeof query,"UPADTE `pAutos` SET `aPosA` = '%f' WHERE `aOwner` = '%s' AND `aCarkey` = '%i'",a,PlayerName(playerid),i);
mysql_query(query);
return SendClientMessage(playerid,COLOR_GREEN,"Dein Fahrzeug wurde geparkt!");
}
else continue;
}
SendClientMessage(playerid,COLOR_GREY,"Dir gehört dieses Auto nicht!");
return 1;
}

Fabi.StaR · 13. Oktober 2013

format(query,sizeof query,"UPADTE `pAutos` SET `aPosZ` = '%f' WHERE `aOwner` = '%s' AND `aCarkey` = '%i'",z,PlayerName(playerid),GetVehicleComponentInSlot(Spielercar[p][i],1));

Unique! · 13. Oktober 2013

EDIT: xD da sieht man was passieren kann, wenn man zu schnell tippt: UPDATE wäre es und geschrieben wurde von mir: UPADTE

breadfish.de 12. März 2022