MSQL Speichert als "Null"

Jeffry · 29. Januar 2016

1.)
Versuche es dann mal so:
public OnPlayerCarUpdate_SQL(playerid)
{
if(IsPlayerConnected(playerid))
{
for(new x = 0; x < MaxVeh; x++)
{
if(Dtc_PlayerHaveCar[playerid][x])
{
print("OnPlayerCarUpdate_SQL 1");
DestroyObject(Neonrohr[playerid][Neon]);
DestroyObject(Neonrohr[playerid][Neon1]);
DestroyVehicle(PlayerCar[playerid][x][CarId]);
print("OnPlayerCarUpdate_SQL 2");
Dtc_Carlock[PlayerCar[playerid][x][CarId]] = 0;
Dtc_LockCar(PlayerCar[playerid][x][CarId]);
print("OnPlayerCarUpdate_SQL 3");
new query[256];
GetPlayerName(playerid, query, MAX_PLAYER_NAME);
mysql_format(handle, query, sizeof(query), "SELECT * FROM Privatcar WHERE `CarOwner` = '%s_%d'", query,x);
mysql_pquery(handle, query, "SaveMysqlCars", "sii", query,x,playerid);
print("OnPlayerCarUpdate_SQL 3");
}
}
}
return 1;
}
Sinnvoll wäre es hier aber auch, die Schleife zu entfernen und "x" als Parameter mitzugeben, damit du nicht alle Fahrzeuge neu erstellen musst (ändert sich ja nur das eine).

2.)
Erledigt?

3.)
Ist das damit dann auch erledigt?

RedDragon28080 · 9. Juli 2016

so habe mich mal wieder ans autohaus gesetzt und hbae folgendes Problem
das fahrzeug wird erstellt und auch geladen ,
nur das problem ist es speichert nichts ab egal ob /opark oder nur /park

hier mal die cods

Code

public OnPlayerCarUpdate_SQL(playerid)
{
	if(IsPlayerConnected(playerid))
	{
	    for(new x = 0; x < MaxVeh; x++)
		{
			if(Dtc_PlayerHaveCar[playerid][x])
			{
				print("OnPlayerCarUpdate_SQL 1");
				DestroyObject(Neonrohr[playerid][Neon]);
				DestroyObject(Neonrohr[playerid][Neon1]);
				DestroyVehicle(PlayerCar[playerid][x][CarId]);
				print("OnPlayerCarUpdate_SQL 2");
				Dtc_Carlock[PlayerCar[playerid][x][CarId]] = 0;
				Dtc_LockCar(PlayerCar[playerid][x][CarId]);
				print("OnPlayerCarUpdate_SQL 3");
				new query[256];
				GetPlayerName(playerid, query, MAX_PLAYER_NAME);
				mysql_format(handle, query, sizeof(query), "SELECT * FROM Privatcar WHERE `CarOwner` = '%s_%d'", query,x);
				mysql_pquery(handle, query, "SaveMysqlCars", "sii", query,x,playerid);
				print("OnPlayerCarUpdate_SQL 3");
			}
		}
	}
	return 1;
}

Alles anzeigen

Code

forward SaveMysqlCars(playername2[],x,playerid);
public SaveMysqlCars(playername2[],x,playerid)
{
	print("SaveMysqlCars 1");
	new rows,fields,string3[1024];
	cache_get_data(rows,fields);
	if(rows) {
		print("SaveMysqlCars 2");
		format(string3, sizeof(string3), "UPDATE Privatcar SET CarModel`='%d',`CarPos_X`='%f',`CarPos_Y`='%f',`CarPos_Z`='%f',`CarPos_A`='%f',`CarNitro`='%d',`CarHyd`='%d',`CarWheel`='%d',`CarAusp`='%d'\
		,`CarSideL`='%d',`CarSideR`='%d',`CarFB`='%d',`CarRB`='%d',`CarSpoiler`='%d',`CarRoof`='%d',`CarHood`='%d',`CarVents`='%d',`CarLamps`='%d'\
		,`CarPJ`='%d',`CarC1`='%d',`CarC2`='%d',`Preis`='%d',`Neon`='%d',`Plate`='%d',`Number`='%s',`Gesperrt`='%d',`Sperrpreis`='%d',`Kralle`='%d',`Abgeschleppt`='%d' WHERE `CarOwner`='%s_%d'",
		PlayerCar[playerid][x][CarModel], PlayerCar[playerid][x][CarPos_x], PlayerCar[playerid][x][CarPos_y], PlayerCar[playerid][x][CarPos_z], PlayerCar[playerid][x][CarRotate],
		PlayerCar[playerid][x][CarNitro],PlayerCar[playerid][x][CarHyd], PlayerCar[playerid][x][CarWheel], PlayerCar[playerid][x][CarAusp], PlayerCar[playerid][x][CarSideL],
		PlayerCar[playerid][x][CarSideR], PlayerCar[playerid][x][CarFB], PlayerCar[playerid][x][CarRB], PlayerCar[playerid][x][CarSpoiler], PlayerCar[playerid][x][CarRoof],
		PlayerCar[playerid][x][CarHood], PlayerCar[playerid][x][CarVents], PlayerCar[playerid][x][CarLamps], PlayerCar[playerid][x][CarPJ], PlayerCar[playerid][x][CarC1],
		PlayerCar[playerid][x][CarC2], PlayerCar[playerid][x][CarPreis], PlayerCar[playerid][x][Neon], PlayerCar[playerid][x][CarPlate], PlayerCar[playerid][x][CarNumber],
		PlayerCar[playerid][x][CarGesperrt], PlayerCar[playerid][x][CarSperrpreis], PlayerCar[playerid][x][Kralle],PlayerCar[playerid][x][Abgeschleppt], Spielerinfo[playerid][Name], x);
		mysql_pquery(handle, string3);
		print("SaveMysqlCars 3");
	}
	return 1;
}

Alles anzeigen

hier die /opark und /park

Code

if(strcmp("/park", cmdtext, true, 10) == 0)
	{
		if(Dtc_PlayerHaveCar[playerid][Dtc_PlayerKey[playerid]])
		{
		    	new newcar = GetPlayerVehicleID(playerid);
	       	 	if (newcar == PlayerCar[playerid][Dtc_PlayerKey[playerid]][CarId])
	       	 	{
					new Float:X,Float:Y,Float:Z;
					new Float:z_rot;
					GetPlayerPos(playerid, X,Y,Z);
					GetVehicleZAngle(newcar, z_rot);
    				PlayerCar[playerid][Dtc_PlayerKey[playerid]][CarPos_x] = X;
			    	PlayerCar[playerid][Dtc_PlayerKey[playerid]][CarPos_y] = Y;
			    	PlayerCar[playerid][Dtc_PlayerKey[playerid]][CarPos_z] = Z;
			    	PlayerCar[playerid][Dtc_PlayerKey[playerid]][CarRotate] = z_rot;
			    	OnPlayerCarUpdate_SQL2(playerid);
		    		SendClientMessage(playerid, COLOR_YELLOW, "Du hast dein Fahrzeug hier geparkt, ab nun kannst du dein Fahrzeug hier finden!");
				}
				else
				{
					SendClientMessage(playerid,COLOR_GREY,"Du bist nicht in deinem Fahrzeug/Du hast nicht den Schlüssel zu diesem Fahrzeug ausgewählt!");
					return 1;
				}
		}
		else
		{
 			SendClientMessage(playerid, COLOR_GREY, "Du besitzt kein Fahrzeug für deinen ausgewählten Schlüssel!");
		    return 1;
		}
		return 1;
	}

Alles anzeigen

Code

if (strcmp("/opark", cmd, true, 10) == 0)
    {
        if(Spielerinfo[playerid][pMember] == 6||Spielerinfo[playerid][pLeader] == 6)
        {
	        if(IsPlayerInAnyVehicle(playerid) && GetVehicleModel(GetPlayerVehicleID(playerid)) == 525 && GetPlayerState(playerid) == PLAYER_STATE_DRIVER)
	        {
                if(IsPlayerInZone(playerid,807.1006,-1307.1543,930.5479,-1160.2494))
				{
	                if(!IsTrailerAttachedToVehicle(GetPlayerVehicleID(playerid)))
	                {
	                    SendClientMessage(playerid, COLOR_GREY, "An deinem Abschleppwagen ist kein Auto angehängt!");
	                    return 1;
	                }
	                new trailercar = GetVehicleTrailer(GetPlayerVehicleID(playerid));
	                tmp = strtok(cmdtext, idx);
					if(!strlen(tmp))
					{
						SendClientMessage(playerid, COLOR_GRAD2, "Benutze: /opark [preis]");
						return 1;
					}
					moneys = strval(tmp);
					if(moneys < 1 || moneys > 10000) { SendClientMessage(playerid, COLOR_GREY, "   Nicht weniger als 1 oder mehr als 99999 !"); return 1; }
	                new Float:X,Float:Y,Float:Z;
	                new Float:z_rot;
	                new query[128],stringn[250];
	                GetVehiclePos(trailercar, X,Y,Z);
	                GetVehicleZAngle(trailercar, z_rot);
	                new carowner = GetDtCarOwner(trailercar);
	                new engine, lights, alarm, doors, bonnet, boot, objective;
			        for(new fc = 0; fc < sizeof(FactionCars); fc++){
			            if(FactionCars[fc][fVehid] >= 400 && FactionCars[fc][fVehid] <= 611){
							if(trailercar == FactionCars[fc][fCarid]){
								FactionCars[fc][fPos][0]=X;
						        FactionCars[fc][fPos][1]=Y;
						        FactionCars[fc][fPos][2]=Z;
						        FactionCars[fc][fPos][3]=z_rot;
								FactionCars[fc][fGesperrt]=1;
						        FactionCars[fc][fSperrpreis]=moneys;
						        format(stringn, sizeof(stringn), "Du hast das Fraktionsauto (%s (%d)) erfolgreich abgeschleppt!", CarName[FactionCars[fc][fVehid]-400],FactionCars[fc][fCarid]);
			    				SendClientMessage(playerid, 0xFF0000FF, stringn);
							}
						}
					}
					if(carowner != 555)
					{
						PlayerCar[carowner][Dtc_PlayerKey[carowner]][CarPos_x] = X;
						PlayerCar[carowner][Dtc_PlayerKey[carowner]][CarPos_y] = Y;
						PlayerCar[carowner][Dtc_PlayerKey[carowner]][CarPos_z] = Z;
						PlayerCar[carowner][Dtc_PlayerKey[carowner]][CarRotate] = z_rot;
						PlayerCar[carowner][Dtc_PlayerKey[carowner]][CarGesperrt] = 1;
						PlayerCar[carowner][Dtc_PlayerKey[carowner]][CarSperrpreis] = moneys;
						format(query, sizeof(query), "UPDATE `Privatcar` SET `Gesperrt`='1',`Sperrpreis`='%d' WHERE `CarOwner`='%s_%d'", PlayerCar[carowner][Dtc_PlayerKey[carowner]][CarSperrpreis], carowner, Dtc_PlayerKey[carowner]);
      					mysql_pquery(handle, query);
						OnPlayerCarUpdate_SQL2(carowner);
						SendClientMessage(playerid, COLOR_YELLOW, "    Du hast das Privatauto erfolgreich abgeschleppt!");
					}
					DetachTrailerFromVehicle(GetPlayerVehicleID(playerid));
					GetVehicleParamsEx(trailercar,engine,lights,alarm,doors,bonnet,boot,objective);
					SetVehicleParamsEx(trailercar,VEHICLE_PARAMS_OFF,VEHICLE_PARAMS_OFF,alarm,doors,bonnet,boot,objective);
					licht[trailercar] = 0;
					return 1;
				} else {
	                SendClientMessage(playerid, COLOR_GREY, "Du bist nicht am Ordungsamtstellplatz!");
	                return 1;
           		}
	        }
	        else
	        {
	            SendClientMessage(playerid, COLOR_GREY, " Du musst einen Abschleppwagen fahren!");
	            return 1;
	        }
		}
		return 1;
    }

Alles anzeigen

Jeffry · 10. Juli 2016

Was sagt der Server Log (prints) und der MySQL Log (Queries)?

mskamilor4 · 10. Juli 2016

Code

format(string3, sizeof(string3), "UPDATE Privatcar SET CarModel`='%d'

Da fehlt ja ein ` bevor CarModel

breadfish.de 12. März 2022