I have mysql system on my mod, and i was wondering how to make a command "/createhouse" to make house InGame.
Код:
mysql_store_result();
new linija[270];
if(mysql_num_rows() == 1)
{
if(mysql_fetch_row(linija))
{
mysql_free_result();
new k[2];
sscanf(linija, "p<|>iis[24]s[32]ffffffffffffiiiiiiiiiiiiiiiiiiiiiiiiiiiiis[32]iiiiii",
k[0], Kuce[extraid][ImaVlasnika], Kuce[extraid][Vlasnik], Kuce[extraid][Vrsta], Kuce[extraid][UlazX], Kuce[extraid][UlazY], Kuce[extraid][UlazZ], Kuce[extraid][UlazA], Kuce[extraid][IzlazX], Kuce[extraid][IzlazY],
Kuce[extraid][IzlazZ], Kuce[extraid][IzlazA], Kuce[extraid][HCX], Kuce[extraid][HCY], Kuce[extraid][HCZ], Kuce[extraid][HCA], Kuce[extraid][BrojSoba], Kuce[extraid][DostupnoZaRent],
Kuce[extraid][RentCena], Kuce[extraid][hDroga], Kuce[extraid][Oruzje1], Kuce[extraid][Municija1], Kuce[extraid][Oruzje2], Kuce[extraid][Municija2], Kuce[extraid][Oruzje3], Kuce[extraid][Municija3],
Kuce[extraid][tTorba], Kuce[extraid][tDroga], Kuce[extraid][tPizza], Kuce[extraid][tSok], Kuce[extraid][tHotdog], Kuce[extraid][tZice], Kuce[extraid][tKanister], Kuce[extraid][tSemena], Kuce[extraid][tKoka],
Kuce[extraid][tGDOruzje], Kuce[extraid][tGDProdaja], Kuce[extraid][tGPS], Kuce[extraid][tUze], Kuce[extraid][HCModel], Kuce[extraid][HCBoja1], Kuce[extraid][HCBoja2], Kuce[extraid][Zakljucano],
Kuce[extraid][Cena], Kuce[extraid][Enterijer], Kuce[extraid][Adresa], Kuce[extraid][VW], Kuce[extraid][kNivo], Kuce[extraid][kHeal], Kuce[extraid][kSef], Kuce[extraid][kAlarm], k[1]);
if(Kuce[extraid][ImaVlasnika] == 0)
{
format(CmdString, 128, "Kuca na prodaju! (%d)\nVrsta: %s\nAdresa: %s\nCena: $%d | Nivo: %d\nZa kupovinu upisite /kupikucu", extraid, Kuce[extraid][Vrsta], Kuce[extraid][Adresa], Kuce[extraid][Cena], Kuce[extraid][kNivo]);
KucaLabel[extraid] = CreateDynamic3DTextLabel(CmdString, 0x00FF00AA, Kuce[extraid][UlazX], Kuce[extraid][UlazY], Kuce[extraid][UlazZ], 25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 100.0);
KucaPickup[extraid] = CreateDynamicPickup(1273, 1, Kuce[extraid][UlazX], Kuce[extraid][UlazY], Kuce[extraid][UlazZ]);
}
else if(Kuce[extraid][ImaVlasnika] == 1)
{
if(Kuce[extraid][DostupnoZaRent] == 0)
{
format(CmdString, 128, "Vlasnik kuce: %s\nAdresa: %s\nVrsta: %s\nNivo: %d | ID: %d", Kuce[extraid][Vlasnik], Kuce[extraid][Adresa], Kuce[extraid][Vrsta], Kuce[extraid][kNivo], extraid);
}
else if(Kuce[extraid][DostupnoZaRent] == 1)
{
format(CmdString, 128, "Vlasnik kuce: %s\nAdresa: %s\nVrsta: %s\nRent: $%d ( /iznajmisobu )\nNivo: %d | ID: %d", Kuce[extraid][Vlasnik], Kuce[extraid][Adresa], Kuce[extraid][Vrsta], Kuce[extraid][RentCena], Kuce[extraid][kNivo], extraid);
}
KucaLabel[extraid] = CreateDynamic3DTextLabel(CmdString, 0xFFFFFFAA, Kuce[extraid][UlazX], Kuce[extraid][UlazY], Kuce[extraid][UlazZ], 25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 100.0);
KucaPickup[extraid] = CreateDynamicPickup(1239, 1, Kuce[extraid][UlazX], Kuce[extraid][UlazY], Kuce[extraid][UlazZ]);
if(Kuce[extraid][HCModel] != -1)
{
Kuce[extraid][HCV] = CreateVehicle_H(Kuce[extraid][HCModel], Kuce[extraid][HCX], Kuce[extraid][HCY], Kuce[extraid][HCZ], Kuce[extraid][HCA], 0, 0, 200);
}
}
}
}
use ZCMD for it, or if your script already uses another command processor, use that one