Код:
enum hInfo
{
id,
Float:hEntrx,
Float:hEntry,
Float:hEntrz,
Float:hExitx,
Float:hExity,
Float:hExitz,
Float:hCarx,
Float:hCary,
Float:hCarz,
Float:hCarfa,
hOwner[32],
hDiscript[16],
hPrice,
hBuyPrice,
hInt,
hVirtual,
hLock,
hMIcon,
hPickup,
Text3D:hPickupExit,
hOplata,
hHeal,
bool:hRob,
/**/
dID,
dOwner[32],
Float:dEntrx,
Float:dEntry,
Float:dEntrz,
Float:dExitx,
Float:dExity,
Float:dExitz,
dPrice,
dPickup,
Text3D:dPickupExit,
dLock,
dInt,
dVirtual,
dMIcon
};
=======================================================
stock LoadHouse() // HouseInfo
{
new time = GetTickCount();
mysql_query("SELECT * FROM `"TABLE_HOUSE"` ORDER BY `"TABLE_HOUSE"`.`id` ASC ");
mysql_store_result();
for(new i; i < TOTALHOUSE; i++)
{
strmid(HouseInfo[i][hOwner],"None_Nones",0,strlen("None_Nones"),32);
}
if(mysql_num_rows() > 0)
{
for(new idx = 1; idx <= mysql_num_rows(); idx++)
{
mysql_fetch_row(query);
sscanf(query, "p<|>iffffffffffs[32]s[16]iiiiiii",
HouseInfo[idx][id],// 1
HouseInfo[idx][hEntrx],// 2
HouseInfo[idx][hEntry],// 3
HouseInfo[idx][hEntrz],// 4
HouseInfo[idx][hExitx],// 5
HouseInfo[idx][hExity],// 6
HouseInfo[idx][hExitz],// 7
HouseInfo[idx][hCarx],// 8
HouseInfo[idx][hCary],// 9
HouseInfo[idx][hCarz],// 10
HouseInfo[idx][hCarfa],// 11
HouseInfo[idx][hOwner],// 12
HouseInfo[idx][hDiscript],// 13
HouseInfo[idx][hPrice],// 14
HouseInfo[idx][hBuyPrice],// 15
HouseInfo[idx][hInt],// 16
HouseInfo[idx][hVirtual],// 17
HouseInfo[idx][hLock],// 18
HouseInfo[idx][hOplata],// 19
HouseInfo[idx][hHeal]);
if(!strcmp(HouseInfo[idx][hOwner],"None",true))
{
HouseInfo[idx][hMIcon] = CreateDynamicMapIcon(HouseInfo[idx][hEntrx], HouseInfo[idx][hEntry], HouseInfo[idx][hEntrz], 31, 0,-1,-1,-1,200.0);
HouseInfo[idx][hPickup] = CreatePickup(1273, 1, HouseInfo[idx][hEntrx], HouseInfo[idx][hEntry], HouseInfo[idx][hEntrz]);
}
else
{
HouseInfo[idx][hMIcon] = CreateDynamicMapIcon(HouseInfo[idx][hEntrx], HouseInfo[idx][hEntry], HouseInfo[idx][hEntrz], 32, 0,-1,-1,-1,200.0);
HouseInfo[idx][hPickup] = CreatePickup(1272, 1, HouseInfo[idx][hEntrx], HouseInfo[idx][hEntry], HouseInfo[idx][hEntrz]);
}
HouseInfo[idx][hPickupExit] = Create3DTextLabel("Äëÿ âûõîäà ââåäèòå '/exit' èëè êëàâèøà 'Alt'\nÓïðàâëåíèå äîìîì: '/hpanel' èëè êëàâèøà 'H'",0x33CCFFFF,HouseInfo[idx][hExitx], HouseInfo[idx][hExity], HouseInfo[idx][hExitz],6.0,HouseInfo[idx][hVirtual],1);
TOTALHOUSE++;
}
}
mysql_free_result();
print("\n----------------------------------");
printf(" [LOAD]: Успешная загрузка 'LoadHouses' - загружено %d за %d м.с", TOTALHOUSE,GetTickCount() - time);
}