[Zens]

How can I possibly combine the licenseplate system with MySQL?

Here is the CMD:

Код:

CMD:licenseplate(playerid,params[])
{
    if(PlayerData[playerid][pLevel] < 1)
	return SendClientMessage(playerid,COLOR_RED,"ERROR: You need to be level 1 use this command");
	if(GetPlayerState(playerid) != 2)
	return SendClientMessage(playerid,-1,"Error: You have to be the driver of a vehicle to change its licence plate");
    new VehicleID = GetPlayerVehicleID(playerid), LModel = GetVehicleModel(VehicleID);
    switch(LModel)
    {
    	case 448,461,462,463,468,471,509,510,521,522,523,581,586, 449: return SendClientMessage(playerid,-1,"ERROR: You can not tune this vehicle");
    }
	new plate[32];
	if(sscanf(params,"s[32]",plate)) return SendClientMessage(playerid,-1,"Correct Usage : /licenseplate [PLATE] ");
	new Float:pos[3];
	GetPlayerPos(playerid,pos[0],pos[1],pos[2]);
	SetVehicleNumberPlate(VehicleID, plate);
	SetVehicleToRespawn(VehicleID);
	SetVehiclePos(VehicleID, pos[0], pos[1], pos[2]);
 	SetTimerEx("TuneLCar",4000,0,"d",VehicleID);
 	PutPlayerInVehicle(playerid,VehicleID,0);
 	PlayerPlaySound(playerid,1133,0.0,0.0,0.0);
	return 1;
}

Car enum:

Код:

enum carData {
	carID,
	carExists,
	carModel,
	carOwner,
	Float:carPos[4],
	carColor1,
	carColor2,
	carPaintjob,
	carLocked,
	carMods[14],
	carImpounded,
	carImpoundPrice,
	carFaction,
	carWeapons[5],
	carAmmo[5],
	carVehicle
};

[Abagail]

I don't see any type of MySQL anything you here. Are you trying to simply place it into the enum and save it into MySQL or what?

[Zens]

Quote:

Originally Posted by Abagail I don't see any type of MySQL anything you here. Are you trying to simply place it into the enum and save it into MySQL or what?

Well, I've added the license plate to the enums/the whole MySQL savings. However, I'm abit lost on how to implement it into the cmd:licenseplate. It's carPlate fyi. Should I stock it somehow?

Код:

CMD:licenseplate(playerid, params[])
{
	if(GetPlayerState(playerid) != 2)
	return SendClientMessage(playerid,-1,"Error: You have to be the driver of a vehicle to change its licence plate");
    new vehicleid = GetPlayerVehicleID(playerid), LModel = GetVehicleModel(vehicleid);
    switch(LModel)
    {
    	case 448,461,462,463,468,471,509,510,521,522,523,581,586, 449: return SendClientMessage(playerid,-1,"ERROR: You can not tune this vehicle");
    }
	new plate[32];
	if(sscanf(params,"s[32]",plate)) return SendClientMessage(playerid,-1,"Correct Usage : /licenseplate [PLATE] ");
	new Float:pos[3];
	GetPlayerPos(playerid,pos[0],pos[1],pos[2]);
	SetVehicleNumberPlate(vehicleid, plate);
	SetVehicleToRespawn(vehicleid);
	SetVehiclePos(vehicleid, pos[0], pos[1], pos[2]);
 	SetTimerEx("TuneLCar",4000,0,"d",vehicleid);
 	PutPlayerInVehicle(playerid,vehicleid,0);
 	PlayerPlaySound(playerid,1133,0.0,0.0,0.0);
	return 1;
}

[Abagail]

You mean you want to set the string simply? Well, ****** would've helped or the search function but something such as this should suffice:

pawn Код:

strmid(YourEnum[vehicleid][carPlate], plate, 0, strlen(plate));

[Zens]

I'm still abit lost on this, been searching around for a while now.. Sorry
I want it to save the carPlate into the database upon the usage of /licenseplate.. Right now it just changes the plate, but doesnt really save together with the car system.

[Zens]

Push... Anyone who knows?

[Abagail]

Show the code you use for saving the vehicle.

[Zens]

Quote:

Originally Posted by Abagail Show the code you use for saving the vehicle.

Код:

Car_Save(carid)
{
	static
	    query[900];

	if (CarData[carid][carVehicle] != INVALID_VEHICLE_ID)
	{
	    for (new i = 0; i < 14; i ++) {
			CarData[carid][carMods][i] = GetVehicleComponentInSlot(CarData[carid][carVehicle], i);
	    }
	}
	format(query, sizeof(query), "UPDATE `cars` SET `carModel` = '%d', `carOwner` = '%d', `carPosX` = '%.4f', `carPosY` = '%.4f', `carPosZ` = '%.4f', `carPosR` = '%.4f', `carPlate` = '%d', `carColor1` = '%d', `carColor2` = '%d', `carPaintjob` = '%d', `carLocked` = '%d'",
        CarData[carid][carModel],
        CarData[carid][carOwner],
        CarData[carid][carPos][0],
        CarData[carid][carPos][1],
        CarData[carid][carPos][2],
        CarData[carid][carPos][3],
        CarData[carid][carPlate],
        CarData[carid][carColor1],
        CarData[carid][carColor2],
        CarData[carid][carPaintjob],
        CarData[carid][carLocked]
	);
	format(query, sizeof(query), "%s, `carMod1` = '%d', `carMod2` = '%d', `carMod3` = '%d', `carMod4` = '%d', `carMod5` = '%d', `carMod6` = '%d', `carMod7` = '%d', `carMod8` = '%d', `carMod9` = '%d', `carMod10` = '%d', `carMod11` = '%d', `carMod12` = '%d', `carMod13` = '%d', `carMod14` = '%d'",
		query,
		CarData[carid][carMods][0],
		CarData[carid][carMods][1],
		CarData[carid][carMods][2],
		CarData[carid][carMods][3],
		CarData[carid][carMods][4],
		CarData[carid][carMods][5],
		CarData[carid][carMods][6],
		CarData[carid][carMods][7],
		CarData[carid][carMods][8],
		CarData[carid][carMods][9],
		CarData[carid][carMods][10],
		CarData[carid][carMods][11],
		CarData[carid][carMods][12],
		CarData[carid][carMods][13]
	);
	format(query, sizeof(query), "%s, `carImpounded` = '%d', `carImpoundPrice` = '%d', `carFaction` = '%d', `carWeapon1` = '%d', `carWeapon2` = '%d', `carWeapon3` = '%d', `carWeapon4` = '%d', `carWeapon5` = '%d', `carAmmo1` = '%d', `carAmmo2` = '%d', `carAmmo3` = '%d', `carAmmo4` = '%d', `carAmmo5` = '%d' WHERE `carID` = '%d'",
		query,
		CarData[carid][carImpounded],
		CarData[carid][carImpoundPrice],
		CarData[carid][carFaction],
		CarData[carid][carWeapons][0],
		CarData[carid][carWeapons][1],
		CarData[carid][carWeapons][2],
		CarData[carid][carWeapons][3],
		CarData[carid][carWeapons][4],
		CarData[carid][carAmmo][0],
		CarData[carid][carAmmo][1],
		CarData[carid][carAmmo][2],
		CarData[carid][carAmmo][3],
		CarData[carid][carAmmo][4],
		CarData[carid][carID]
	);
	return mysql_function_query(g_iHandle, query, false, "", "");
}

[Abagail]

Is "carid" the object of the player's vehicle or the SA:MP vehicle ID?

[Zens]

Quote:

Originally Posted by Abagail Is "carid" the object of the player's vehicle or the SA:MP vehicle ID?

It's the players vehicle.