Dealership - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Dealership (/showthread.php?tid=565968)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Dealership (/showthread.php?tid=565968)
Dealership - Tony$$ - 02.03.2015
Hello,
I got this bug when i type /v list it wont show the vehicle status of my car but it says that i have 1 car (that one i just bought) Here is the code:
pawn Код:
if(!strcmp(option, "list", true))
{
if(PlayerInfo[playerid][pVehicles] == 0) return SCM(playerid, COLOR_LIGHTRED, "You do not own any vehicles.");
SCMEx(playerid, COLOR_GREEN, "______________Your Vehicles(%d)______________", PlayerInfo[playerid][pVehicles]);
for(new i = 1; i <= PlayerInfo[playerid][pVehicles]; i++)
{
if(VehicleStatus[playerid][i][carOn] == 1)
{
if(FindVehicleByPlate(VehicleStatus[playerid][i][carPlate]))
{
SCMEx(playerid, COLOR_GREEN, "Vehicle %d: %s, Lock[%d], Alarm[%d], Immobiliser[%d], Insurances[%d], Times Destroyed[%d], Next Insurance Price[$%d]", i, VehicleNames[VehicleStatus[playerid][i][carModel]-400],VehicleStatus[playerid][i][carLock],VehicleStatus[playerid][i][carAlarm],VehicleStatus[playerid][i][carImmob],VehicleStatus[playerid][i][carInsurances],VehicleStatus[playerid][i][carDestroyed],GetInsurancePrice2(playerid, i));
}
else
{
SCMEx(playerid, COLOR_WHITE, "Vehicle %d: %s, Lock[%d], Alarm[%d], Immobiliser[%d], Insurances[%d], Times Destroyed[%d], Next Insurance Price[$%d]", i, VehicleNames[VehicleStatus[playerid][i][carModel]-400], VehicleStatus[playerid][i][carLock],VehicleStatus[playerid][i][carAlarm],VehicleStatus[playerid][i][carImmob],VehicleStatus[playerid][i][carInsurances],VehicleStatus[playerid][i][carDestroyed],GetInsurancePrice2(playerid, i));
}
}
}
return 1;
}
Here is the command too just in case you need it:
pawn Код:
if(!strcmp(option, "get", true))
{
new slot;
if(sscanf(params, "{s[7]}d", slot)) return SyntaxMSG(playerid, "/v get [slot(1-3)]");
if(slot > 3 || slot < 1) return SCM(playerid, -1, "Invalid slot.");
if(IsVehicleSpawned(PlayerInfo[playerid][pCarKey])) return ErrorMsg(playerid, "You already have a spawned vehicle.");
if(VehSpawned != 0) return SCM(playerid, COLOR_LIGHTRED, "Someone has just spawned a vehicle, please wait 3 seconds.");
LoadVehicleFromSlot(playerid, slot);
return 1;
}
Re: Dealership - Tony$$ - 03.03.2015
here is the other code
pawn Код:
if(listid == buyable)
{
if(response)
{
new Float:ParkX, Float:ParkY, Float:ParkZ;
if(GetOwnedVehicles(playerid) == MAX_OWNED_VEHICLES) return SCM(playerid, COLOR_GRAY, "You've reached the maximum owned vehicles.");
if(IsVehicleSpawned(PlayerInfo[playerid][pCarKey])) return SCM(playerid, COLOR_GRAY, "Please despawn your current spawned vehicle.");
if(PlayerInfo[playerid][pDonateRank] == 0)
{
if(IsABronzeCar(modelid) || IsASilverCar(modelid) || IsAGoldCar(modelid)) return SCM(playerid, COLOR_INFO, "Only donators are able to purchase this vehicle.");
}
if(PlayerInfo[playerid][pDonateRank] == 1)
{
if(IsASilverCar(modelid) || IsAGoldCar(modelid)) return SCM(playerid, COLOR_INFO, "You must be a silver/gold donator to afford one of this vehicles.");
}
if(PlayerInfo[playerid][pDonateRank] == 2)
{
if(IsAGoldCar(modelid)) return SCM(playerid, COLOR_INFO, "You must be a gold donator to afford one of this vehicles.");
}
new price = GetVehiclePrice(modelid);
if(GetCash(playerid) < price) return NoCashMSG(playerid);
format(msg, sizeof(msg), "Congratulations, you have bought a %s for $%d.", VehicleNames[modelid-400], price);
SCM(playerid, COLOR_YELLOWG, msg);
GiveCash(playerid, -price);
new slot;
if(!strcmp(PlayerVehicle[playerid][pVeh1], "None", true))
slot = 1;
else if(!strcmp(PlayerVehicle[playerid][pVeh2], "None", true))
slot = 2;
else if(!strcmp(PlayerVehicle[playerid][pVeh3], "None", true))
slot = 3;
if(IsABoatModel(modelid))
{
ParkX = 310.3268;
ParkY = -1941.7601;
ParkZ = 1.3952;
}
else if(IsAPlaneModel(modelid))
{
ParkX = 1943.5498;
ParkY = -2397.6553;
ParkZ = 13.5469;
}
else
{
ParkX = 1703.1804;
ParkY = -1509.0079;
ParkZ = 13.3893;
}
PlayerInfo[playerid][pCarKey] = CreateVehicle(modelid, ParkX, ParkY, ParkZ, 0.0, 1, 1, -1);
VehicleInfo[PlayerInfo[playerid][pCarKey]][carModel] = modelid;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carColor1] = 1;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carColor2] = 1;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carParkX] = ParkX;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carParkY] = ParkY;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carParkZ] = ParkZ;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carParkA] = 0.0;
format(VehicleInfo[PlayerInfo[playerid][pCarKey]][carPlate], 128, "%s%d", FirstNameLetters(GetName(playerid)), randomEx(10000, 99999));
format(VehicleInfo[PlayerInfo[playerid][pCarKey]][carOwner], 128, "%s", GetName(playerid));
VehicleInfo[PlayerInfo[playerid][pCarKey]][carOwned] = 1;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carSpawned] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carOn] = 1;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carAlarm] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carLock] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carImmob] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carInsurances] = 2;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carDestroyed] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carGps] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carOwnerSlot] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carFuel] = 50;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carRegistered] = 1;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carBroken] = 0;
for(new i = 0; i < MAX_VEHICLE_WEAPONS; i++)
{
VehicleInfo[PlayerInfo[playerid][pCarKey]][carTrunkWep][i] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carTrunkAmmo][i] = 0;
}
VehicleInfo[PlayerInfo[playerid][pCarKey]][carComponent][0] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carComponent][1] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carComponent][2] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carComponent][3] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carComponent][4] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carComponent][5] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carComponent][6] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carComponent][7] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carComponent][8] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carComponent][9] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carComponent][10] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carComponent][11] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carComponent][12] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carComponent][13] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carPaintJob] = 3;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carRadio] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carDupKey] = randomEx(1234567, 9999999);
VehicleInfo[PlayerInfo[playerid][pCarKey]][carComps] = 0;
for(new i = 0; i < MAX_DRUGS; i++)
{
VehicleInfo[PlayerInfo[playerid][pCarKey]][carDrug][i] = 0;
VehicleInfo[PlayerInfo[playerid][pCarKey]][carDrugAmount][i] = 0;
}
for(new i = 0; i < MAX_CAR_TICKETS; i++)
{
VehicleInfo[PlayerInfo[playerid][pCarKey]][carTicket][i] = 0;
}
PlayerInfo[playerid][pVehicles]++;
OnPlayerBuyCar(playerid, PlayerInfo[playerid][pCarKey], modelid, 1, 1, slot, ParkX, ParkY, ParkZ, 0.0, VehicleInfo[PlayerInfo[playerid][pCarKey]][carPlate], VehicleInfo[PlayerInfo[playerid][pCarKey]][carOwner]);
DestoryCar(PlayerInfo[playerid][pCarKey]);
PlayerInfo[playerid][pCarKey] = 0;
CheckOwnedVehicles(playerid);
}
else return SCM(playerid, COLOR_INFO, "Canceled vehicle selection.");
return 1;
}
return 1;
}
Re: Dealership - Tony$$ - 03.03.2015
also this
pawn Код:
stock OnPlayerBuyCar(playerid, vehid, model, color1, color2, slot, Float:ParkX, Float:ParkY, Float:ParkZ, Float:ParkA, plate[], owner[])
{
//======================================================================================
format(query, sizeof(query), "INSERT INTO `ownedvehicles` (model, color1, color2, parkx, parky, parkz, parka, plate, owner, owned, slot) VALUES (%d, %d, %d, %f, %f, %f, %f, '%s', '%s', %d, %d)",
model, color1, color2, ParkX, ParkY, ParkZ, ParkA, plate, owner, 1, slot);
mysql_function_query(dbHandle, query, true, "OnOwnedVehicleInsert", "%d", vehid);
//======================================================================================
format(query, sizeof(query), "UPDATE `ownedvehicles` SET `alarm` = %d, `lock` = %d, `immob` = %d, `insurances` = %d, `destroys` = %d, `gps` = %d, `fuel` = %d, `registered` = %d, `broken` = %d WHERE `owner` = '%s' AND `slot` = %d",
0, 0, 0, 2, 0, 0, 50, 1, 0, GetName(playerid), slot);
mysql_function_query(dbHandle, query, false, "", "");
//======================================================================================
format(query, sizeof(query), "UPDATE `ownedvehicles` SET `weapons` = '%s' WHERE `owner` = '%s' AND `slot` = %d", "0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0", GetName(playerid),slot);
mysql_function_query(dbHandle, query, false, "", "");
//======================================================================================
format(query, sizeof(query), "UPDATE `ownedvehicles` SET `comp0` = %d, `comp1` = %d, `comp2` = %d, `comp3` = %d, `comp4` = %d, `comp5` = %d, `comp6` = %d WHERE `owner` = '%s' AND `slot` = %d",
0, 0, 0, 0, 0, 0, 0, GetName(playerid), slot);
mysql_function_query(dbHandle, query, false, "", "");
//=====================================================================================
format(query, sizeof(query), "UPDATE `ownedvehicles` SET `comp7` = %d, `comp8` = %d, `comp9` = %d, `comp10` = %d, `comp11` = %d, `comp12` = %d, `comp13` = %d, `paintjob` = %d WHERE `owner` = '%s' AND `slot` = %d",
0, 0, 0, 0, 0, 0, 0, 3, GetName(playerid), slot);
mysql_function_query(dbHandle, query, false, "", "");
//=====================================================================================
format(query, sizeof(query), "UPDATE `ownedvehicles` SET `radio` = %d, `tickets` = '%s', `dupkey` = %d, `comps` = %d WHERE `owner` = '%s' AND `slot` = %d", 0, "0|0|0|0|0|0|0|0|0|0", VehicleInfo[vehid][carDupKey], 0, GetName(playerid), slot);
mysql_function_query(dbHandle, query, false, "", "");
//=====================================================================================
format(query, sizeof(query), "UPDATE `ownedvehicles` SET `drugs` = '%s' WHERE `owner` = '%s' AND `slot` = %d", "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", GetName(playerid), slot);
mysql_function_query(dbHandle, query, false, "", "");
//=====================================================================================
format(query, sizeof(query), "UPDATE `users` SET `vehicles` = %d WHERE `name` = '%s'", PlayerInfo[playerid][pVehicles], GetName(playerid));
mysql_function_query(dbHandle, query, false, "", "");
//======================================================================================
if(slot == 1)
{
format(query, sizeof(query), "UPDATE `users` SET `veh1` = '%s' WHERE `name` = '%s'", VehicleNames[model-400], GetName(playerid));
format(PlayerVehicle[playerid][pVeh1], 128, "%s", VehicleNames[model-400]);
mysql_function_query(dbHandle, query, false, "", "");
}
else if(slot == 2)
{
format(query, sizeof(query), "UPDATE `users` SET `veh2` = '%s' WHERE `name` = '%s'", VehicleNames[model-400], GetName(playerid));
format(PlayerVehicle[playerid][pVeh2], 128, "%s", VehicleNames[model-400]);
mysql_function_query(dbHandle, query, false, "", "");
}
else if(slot == 3)
{
format(query, sizeof(query), "UPDATE `users` SET `veh3` = '%s' WHERE `name` = '%s'", VehicleNames[model-400], GetName(playerid));
format(PlayerVehicle[playerid][pVeh3], 128, "%s", VehicleNames[model-400]);
mysql_function_query(dbHandle, query, false, "", "");
}
//======================================================================================
return 1;
}
Re: Dealership - Tony$$ - 04.03.2015
Does it change if i make it to true?
Re: Dealership - Tony$$ - 04.03.2015
Nah i tried it, Anyways when i buy a car it dosen't save inside mysql. Well i see no car in the table.
Re: Dealership - Tony$$ - 13.03.2015
Bump....
Re: Dealership - Tony$$ - 15.03.2015
Bump!
Anyone
Re: Dealership - Tony$$ - 20.03.2015
Bump
Respuesta: Dealership - [DOG]irinel1996 - 20.03.2015
You should debug your MySQL code to see which line fails exactly.
Your PAWN seems okay, try what I said.
Good luck.
