Car System MySQL
#1

Im newbie in SA-MP programming but trying to figure out the code.

When i buy a car i store car details to MySQL like that :

ID, CARID, OWNER, X, Y, Z, COLOR1, COLOR2, HEALTH

ID(mysql generates unique ID by auto increment
CARDID - GetPlayerVehicleID (if i buy infernus it shows 70 when i go with another nickname and buy infernus it shows 70 aswell).
Owner (who bought the car)
X, Y,Z bought car position (save when player exit the car, and when player disconnect).
COLOR1, COLOR2 (don't know how to get vehicle colors)
Health (car health).

Question is how to know when i bought a car (infernus) and my friend bought(infernus) which oh these infernus is mine? Couse i want to make lock system but until i don't know how to see difference between two same cars i cant make that system. Becouse when i lock 1 infernus lock's all or not mine.

Thanks for help guys and sorry from my bad english.
Reply
#2

and one more question how to know when car is destroyed?
Like OnPlayerDeath i could in user table make HAVECAR make 0 instead of 1 .
1 means that player have a car and 0 that he hasn't car.
Reply
#3

anyone ?
Reply
#4

One: Stop bumping.

Two: Sow us the code you have so far,
Reply
#5

/// When the player enter car in shop ///

if(newstate == PLAYER_STATE_DRIVER && GetPlayerVehicleID(playerid) == shopInfernus)
{
ShowPlayerDialog(playerid, 10, DIALOG_STYLE_MSGBOX, "CAR SHOP", "Car model: Infernus\nYear: 2012\nPrice: 50 000$\nWant to buy?","Buy", "Close");
}

if(newstate == PLAYER_STATE_DRIVER && GetPlayerVehicleID(playerid) == shopCheetah)
{
ShowPlayerDialog(playerid, 10, DIALOG_STYLE_MSGBOX, "CAR SHOP", "Car model: Infernus\nYear: 2012\nPrice: 40 000$\nWant to buy?","Buy", "Close");
}
////////////////////////////////////////
/// If player push Buy /////
if(dialogid == 10)
{
if(!response) {
RemovePlayerFromVehicle(playerid);
} else {
new Float:health;
new buyingCarId = GetPlayerVehicleID(playerid);
GetVehicleHealth(buyingCarId, health);
new buyingCarModel = GetVehicleModel(buyingCarId);
new name[MAX_PLAYER_NAME+1];
GetPlayerName(playerid, name, sizeof(name));
/// If player already have car ///
if(haveAuto[playerid] == 1)
{
ShowPlayerDialog(playerid,6,DIALOG_STYLE_MSGBOX,"C AR SHOP", "ATTENTION!\nYou already have car!\n","CLOSE","");
}

if(buyingCarId == 411 && PlayerMoney[playerid] < 50000)
{
/// If not enough money!!!
ShowPlayerDialog(playerid,6,DIALOG_STYLE_MSGBOX,"C AR SHOP", "Attention!\nYou dont have enough money to buy this car","CLOSE","");
}

if(buyingCarid == 415 && PlayerMoney[playerid] < 40000)
{
/// If not enough money!!!
ShowPlayerDialog(playerid,6,DIALOG_STYLE_MSGBOX,"C AR SHOP", "ATTENTION!\nYou dont have enought money to buy this car","CLOSE","");
}
/// If money enough ///

autoID[playerid] = buyingCarId;
autoModel[playerid] = buyingCarModel;
haveAuto[playerid] = 1;
if(buyingCarModel == 415){ GivePlayerMoney(playerid, -40000);}
if(buyingCarModel == 411){ GivePlayerMoney(playerid, -50000);}
new Query[1024];
format(Query, sizeof(Query), "INSERT INTO auto (carid,owner,X,Y,Z,color1,color2,health) VALUES ('%d','%s','0','0','0','0','0','%f')", buyingCarId, name, health);
mysql_query(Query);
new randVeh = random(sizeof(RandVehSpawn));
AddStaticVehicleEx(buyingCarModel, RandVehSpawn[randVeh][0], RandVehSpawn[randVeh][1], RandVehSpawn[randVeh][2], RandVehSpawn[randVeh][3], 0, 0, 0);
RemovePlayerFromVehicle(playerid);
}
return 1;
}

public OnPlayerExitVehicle(playerid, vehicleid)
{


if(haveCar[playerid] == 1 && GetPlayerVehicleID(playerid) == autoID[playerid])
{
new query[1024];
new Float:health;
new car;
car = GetPlayerVehicleID(playerid);
GetVehicleHealth(car, health);

new ownern[MAX_PLAYER_NAME+1];
GetPlayerName(playerid, ownern, sizeof(ownern));

new vairuojamaAuto;
whatAuto = GetPlayerVehicleID(playerid);

new Float:autox, Float:autoy, Float:autoz;
GetVehiclePos(whatAuto, autox, autoy, autoz);

format(query, sizeof(query), "UPDATE auto SET X=%f, Y=%f, Z=%f, health=%f WHERE owner='%s'",autox, autoy, autoz, health, ownern);
mysql_query(query);
SetVehiclePos(vehicleid, autox, autoy, autoz);
}

return 1;
}
Reply


Forum Jump:


Users browsing this thread: 3 Guest(s)