Rafael_Briston
Новичок
Перевожу мод на Мускул, составил паблик загрузки домов из бд, но в игре не отображаются не мапиконки, ни пикапы.
Вот загрузка:
Вот подключение и запрос в OnGameModeInit:
Вот загрузка:
PHP:
public LoadProperty()
{
new temp[32],rows,fields;
cache_get_data(rows,fields,mysql_connect_ID);
if (rows)
{
for(new idx = 1; idx <= rows; idx++)
{
cache_get_field_content(idx-1,"ID",temp,mysql_connect_ID), HouseInfo[idx][hID] = strval(temp);
cache_get_field_content(idx-1,"Entrancex",temp,mysql_connect_ID), HouseInfo[idx][hEntrancex] = floatstr(temp);
cache_get_field_content(idx-1,"Entrancey",temp,mysql_connect_ID), HouseInfo[idx][hEntrancey] = floatstr(temp);
cache_get_field_content(idx-1,"Entrancez",temp,mysql_connect_ID), HouseInfo[idx][hEntrancez] = floatstr(temp);
cache_get_field_content(idx-1,"Exitx",temp,mysql_connect_ID), HouseInfo[idx][hExitx] = floatstr(temp);
cache_get_field_content(idx-1,"Exity",temp,mysql_connect_ID), HouseInfo[idx][hExity] = floatstr(temp);
cache_get_field_content(idx-1,"Exitz",temp,mysql_connect_ID), HouseInfo[idx][hExitz] = floatstr(temp);
cache_get_field_content(idx-1,"Healthx",temp,mysql_connect_ID), HouseInfo[idx][hHealthx] = strval(temp);
cache_get_field_content(idx-1,"Healthy",temp,mysql_connect_ID), HouseInfo[idx][hHealthy] = strval(temp);
cache_get_field_content(idx-1,"Healthz",temp,mysql_connect_ID), HouseInfo[idx][hHealthz] = strval(temp);
cache_get_field_content(idx-1,"Armourx",temp,mysql_connect_ID), HouseInfo[idx][hArmourx] = strval(temp);
cache_get_field_content(idx-1,"Armoury",temp,mysql_connect_ID), HouseInfo[idx][hArmoury] = strval(temp);
cache_get_field_content(idx-1,"Armourz",temp,mysql_connect_ID), HouseInfo[idx][hArmourz] = strval(temp);
cache_get_field_content(idx-1,"Owner",HouseInfo[idx][hOwner],mysql_connect_ID,32);
cache_get_field_content(idx-1,"Discription",HouseInfo[idx][hDiscription],mysql_connect_ID,32);
cache_get_field_content(idx-1,"Value",temp,mysql_connect_ID), HouseInfo[idx][hValue] = strval(temp);
cache_get_field_content(idx-1,"Hel",temp,mysql_connect_ID), HouseInfo[idx][hHel] = strval(temp);
cache_get_field_content(idx-1,"Arm",temp,mysql_connect_ID), HouseInfo[idx][hArm] = strval(temp);
cache_get_field_content(idx-1,"Int",temp,mysql_connect_ID), HouseInfo[idx][hInt] = strval(temp);
cache_get_field_content(idx-1,"Lock",temp,mysql_connect_ID), HouseInfo[idx][hLock] = strval(temp);
cache_get_field_content(idx-1,"Owned",temp,mysql_connect_ID), HouseInfo[idx][hOwned] = strval(temp);
cache_get_field_content(idx-1,"Rooms",temp,mysql_connect_ID), HouseInfo[idx][hRooms] = strval(temp);
cache_get_field_content(idx-1,"Rent",temp,mysql_connect_ID), HouseInfo[idx][hRent] = strval(temp);
cache_get_field_content(idx-1,"Rentabil",temp,mysql_connect_ID), HouseInfo[idx][hRentabil] = strval(temp);
cache_get_field_content(idx-1,"Takings",temp,mysql_connect_ID), HouseInfo[idx][hTakings] = strval(temp);
cache_get_field_content(idx-1,"Vec",temp,mysql_connect_ID), HouseInfo[idx][hVec] = strval(temp);
cache_get_field_content(idx-1,"Vcol1",temp,mysql_connect_ID), HouseInfo[idx][hVcol1] = strval(temp);
cache_get_field_content(idx-1,"Vcol2",temp,mysql_connect_ID), HouseInfo[idx][hVcol2] = strval(temp);
cache_get_field_content(idx-1,"Date",temp,mysql_connect_ID), HouseInfo[idx][hDate] = strval(temp);
cache_get_field_content(idx-1,"Level",temp,mysql_connect_ID), HouseInfo[idx][hLevel] = strval(temp);
cache_get_field_content(idx-1,"Virtual",temp,mysql_connect_ID), HouseInfo[idx][hVirtual] = strval(temp);
cache_get_field_content(idx-1,"Garder",temp,mysql_connect_ID), HouseInfo[idx][hGarder] = strval(temp);
cache_get_field_content(idx-1,"Club",temp,mysql_connect_ID), HouseInfo[idx][hClub] = strval(temp);
cache_get_field_content(idx-1,"RedOb",temp,mysql_connect_ID), HouseInfo[idx][hRedOb] = strval(temp);
cache_get_field_content(idx-1,"Nark",temp,mysql_connect_ID), HouseInfo[idx][hNark] = strval(temp);
cache_get_field_content(idx-1,"Materl",temp,mysql_connect_ID), HouseInfo[idx][hMaterl] = strval(temp);
cache_get_field_content(idx-1,"AGNmoney",temp,mysql_connect_ID), HouseInfo[idx][hAGNmoney] = strval(temp);
if(HouseInfo[idx][hOwned] == 0) HouseInfo[idx][hMIcon] = CreateDynamicMapIcon(HouseInfo[idx][hEntrancex], HouseInfo[idx][hEntrancey], HouseInfo[idx][hEntrancez], 31, COLOR_WHITE, 0, 0, -1, 300.0);
else if(HouseInfo[idx][hOwned] == 1) HouseInfo[idx][hMIcon] = CreateDynamicMapIcon(HouseInfo[idx][hEntrancex], HouseInfo[idx][hEntrancey], HouseInfo[idx][hEntrancez], 32, COLOR_WHITE, 0, 0, -1, 300.0);
if(HouseInfo[idx][hOwned] == 0)
{
HouseInfo[idx][hPickup] = CreateDynamicPickupAC(1273, 23, HouseInfo[idx][hEntrancex], HouseInfo[idx][hEntrancey], HouseInfo[idx][hEntrancez],-1,-1,-1,100.0);
pickups++;
}
else if(HouseInfo[idx][hOwned] == 1)
{
HouseInfo[idx][hPickup] = CreateDynamicPickupAC(1318, 23, HouseInfo[idx][hEntrancex], HouseInfo[idx][hEntrancey], HouseInfo[idx][hEntrancez],-1,-1,-1,100.0);
pickups++;
}
CreateDynamicPickupAC(1318, 23, HouseInfo[idx][hExitx], HouseInfo[idx][hExity], HouseInfo[idx][hExitz], HouseInfo[idx][hVirtual],-1,-1,20.0);
idx++;
}
}
printf("Äîìà áëÿäü");
return true;
}
PHP:
mysql_connect_ID = mysql_connect(MYSQL_CONNECT_INFO);
mysql_function_query(mysql_connect_ID,"SELECT * FROM `houses`",true,"LoadProperty","");
