stock CreateHouse(cijena, Float:X, Float:Y, Float:Z, Float:kIntX, Float:kIntY, Float:kIntZ, adresa[], intid)
{
new Query[512], i;
i = db_get_rows(Database, "HOUSES") + 1;
format(HouseInfo[i][Adresa], 64, "%s", adresa);
format(HouseInfo[i][Vlasnik], 64, "Nema");
HouseInfo[i][ID] = i;
HouseInfo[i][Cijena] = cijena;
HouseInfo[i][kX] = X;
HouseInfo[i][kY] = Y;
HouseInfo[i][kZ] = Z;
HouseInfo[i][IntX] = kIntX;
HouseInfo[i][IntY] = kIntY;
HouseInfo[i][IntZ] = kIntZ;
HouseInfo[i][Interior] = intid;
print("Pocetak");
format(Query, sizeof(Query), "INSERT INTO `HOUSES` ('ID') VALUES('%d')", HouseInfo[i][ID]);
db_query(Database, Query);
print(Query);
format(Query, sizeof(Query), "UPDATE `HOUSES` SET VLASNIK = '%d', CIJENA = '%d', ADRESA = '%s', X = '%f', Y = '%f', Z = '%f' WHERE `ID` = '%d' ", HouseInfo[i][Vlasnik], HouseInfo[i][Cijena], adresa, HouseInfo[i][kX], HouseInfo[i][kY], HouseInfo[i][kZ], HouseInfo[i][ID]);
db_query(Database, Query);
print(Query);
format(Query, sizeof(Query), "UPDATE `HOUSES` SET INTX = '%f', INTY = '%f', INTZ = '%f', MATS = '0', DROGA = '0', NOVAC = '0', BRAVA = '1' WHERE `ID` = '%d' ", HouseInfo[i][IntX], HouseInfo[i][IntY], HouseInfo[i][IntZ], HouseInfo[i][ID]);
db_query(Database, Query);
print(Query);
format(Query, sizeof(Query), "UPDATE `HOUSES` SET INT = '%d', RENTABIL = '%d', RENT = '%d', ALARM = '%d' WHERE `ID` = '%d' ", HouseInfo[i][Interior], HouseInfo[i][Rentabil], HouseInfo[i][Rent], HouseInfo[i][Alarm], HouseInfo[i][ID]);
db_query(Database, Query);
print(Query);
format(KucniLabel, sizeof(KucniLabel), ""ZELENA"Kuca na PRODAJU!\n"ZELENA"Adresa: "BIJELA"%s\n"ZELENA"Cijena: "BIJELA"$%i",HouseInfo[i][Adresa],HouseInfo[i][Cijena]);
HouseInfo[i][LabelKuce] = CreateDynamic3DTextLabel(KucniLabel,LIGHTBLUE,HouseInfo[i][kX], HouseInfo[i][kY], HouseInfo[i][kZ]+0.1,20.0,0,1);
return 1;
}
stock CreateHouse(cijena, Float:X, Float:Y, Float:Z, Float:kIntX, Float:kIntY, Float:kIntZ, adresa[], intid)
{
new Query[512], i;
i = db_get_rows(Database, "HOUSES") + 1;
format(HouseInfo[i][Adresa], 64, "%s", adresa);
format(HouseInfo[i][Vlasnik], 64, "Nema");
HouseInfo[i][ID] = i;
HouseInfo[i][Cijena] = cijena;
HouseInfo[i][kX] = X;
HouseInfo[i][kY] = Y;
HouseInfo[i][kZ] = Z;
HouseInfo[i][IntX] = kIntX;
HouseInfo[i][IntY] = kIntY;
HouseInfo[i][IntZ] = kIntZ;
HouseInfo[i][Interior] = intid;
print("Pocetak");
format(Query, sizeof(Query), "INSERT INTO `HOUSES` ('ID') VALUES('%d')", HouseInfo[i][ID]);
db_query(Database, Query);
print(Query);
format(Query, sizeof(Query), "UPDATE `HOUSES` SET VLASNIK = '%d', CIJENA = '%d', ADRESA = '%s', X = '%f', Y = '%f', Z = '%f' WHERE `ID` = '%d' ", HouseInfo[i][Vlasnik], HouseInfo[i][Cijena], adresa, HouseInfo[i][kX], HouseInfo[i][kY], HouseInfo[i][kZ], HouseInfo[i][ID]);
db_query(Database, Query);
print(Query);
format(Query, sizeof(Query), "UPDATE `HOUSES` SET INTX = '%f', INTY = '%f', INTZ = '%f', MATS = '0', DROGA = '0', NOVAC = '0', BRAVA = '1' WHERE `ID` = '%d' ", HouseInfo[i][IntX], HouseInfo[i][IntY], HouseInfo[i][IntZ], HouseInfo[i][ID]);
db_query(Database, Query);
print(Query);
format(Query, sizeof(Query), "UPDATE `HOUSES` SET INT = '%d', RENTABIL = '%d', RENT = '%d', ALARM = '%d' WHERE `ID` = '%d' ", HouseInfo[i][Interior], HouseInfo[i][Rentabil], HouseInfo[i][Rent], HouseInfo[i][Alarm], HouseInfo[i][ID]);
db_query(Database, Query);
print(Query);
format(KucniLabel, sizeof(KucniLabel), "{ZELENA}Kuca na PRODAJU!\n{ZELENA}Adresa: {BIJELA}%s\n{ZELENA}Cijena: {BIJELA}$%i",HouseInfo[i][Adresa],HouseInfo[i][Cijena]);
HouseInfo[i][LabelKuce] = Text3D:CreateDynamic3DTextLabel(KucniLabel,LIGHTBLUE,HouseInfo[i][kX], HouseInfo[i][kY], HouseInfo[i][kZ]+0.1,20.0,0,1);
return 1;
}
|
#include <streamer> |
HouseInfo[i][LabelKuce] = CreateDynamic3DTextLabel(KucniLabel,LIGHTBLUE,HouseInfo[i][kX], HouseInfo[i][kY], HouseInfo[i][kZ]+0.1,20.0);
native Text3D:CreateDynamic3DTextLabel(const text[], color, Float:x, Float:y, Float:z, Float:drawdistance, attachedplayer = INVALID_PLAYER_ID, attachedvehicle = INVALID_VEHICLE_ID, testlos = 0, worldid = -1, interiorid = -1, playerid = -1, Float:streamdistance = 100.0);