Domenicano_RolePlay
Новичок
Всем привет, обновил mysql до R41-4, был R39.
Не загружаюся системы, подключение к БД есть.
Как только не пробовал.
Загрузка:
Пример одной загрузки:
Не загружаюся системы, подключение к БД есть.
Как только не пробовал.
Загрузка:
HTML:
public OnGameModeInit()
{
mysql_tquery(DATABASE,"SELECT * FROM `"TABLE_HOUSE"`","@LoadHouse","");
mysql_tquery(DATABASE,"SELECT * FROM `"TABLE_BIZZ"`","@OnMySQL_QUERY,","iis",6,-1,"");
mysql_tquery(DATABASE,"SELECT * FROM `"TABLE_GROOP"`","@OnMySQL_QUERY,","iis",8,-1,"");
mysql_tquery(DATABASE,"SELECT * FROM `"TABLE_GROOPCARS"`","@OnMySQL_QUERY,","iis",23,-1,"");
mysql_tquery(DATABASE,"SELECT * FROM `"TABLE_OTHERS"`","@OnMySQL_QUERY,","iis",0,-1,"");
mysql_tquery(DATABASE,"SELECT * FROM `"TABLE_ATM"`","@OnMySQL_QUERY,","iis",22,-1,"");
mysql_tquery(DATABASE,"SELECT * FROM `"TABLE_TELEPORT"`","@OnMySQL_QUERY,","iis",10,-1,"");
mysql_tquery(DATABASE,"SELECT * FROM `"TABLE_SEEDLING"`","@OnMySQL_QUERY,","iis",31,-1,"");
mysql_tquery(DATABASE,"SELECT * FROM `"TABLE_TELEPORT"`", "@OnMySQL_QUERY,","iis",23,-1,"");
}
Код:
@LoadHouse();
@LoadHouse()
{
new r, f, x;
cache_get_row_count(r);
cache_get_field_count(f);
if(!r) return printf("[Загрузка ...] Данные домов не получены!");
for(x = 1; x <= r; x++)
{
cache_get_value_name_int(x-1,"hID",HouseInfo[x][hID]);
cache_get_value_name_float(x-1,"hEntrancex",HouseInfo[x][hEntrancex]);
cache_get_value_name_float(x-1,"hEntrancey",HouseInfo[x][hEntrancey]);
cache_get_value_name_float(x-1,"hEntrancez",HouseInfo[x][hEntrancez]);
cache_get_value_name_float(x-1,"hExitx",HouseInfo[x][hExitx]);
cache_get_value_name_float(x-1,"hExity",HouseInfo[x][hExity]);
cache_get_value_name_float(x-1,"hExitz",HouseInfo[x][hExitz]);
cache_get_value_name_float(x-1,"hCarx",HouseInfo[x][hCarx]);
cache_get_value_name_float(x-1,"hCary",HouseInfo[x][hCary]);
cache_get_value_name_float(x-1,"hCarz",HouseInfo[x][hCarz]);
cache_get_value_name(x-1,"hOwner",HouseInfo[x][hOwner],32);
cache_get_value_name(x-1,"Gosti_1",HouseInfo[x][Gosti_1],32);
cache_get_value_name(x-1,"Gosti_2",HouseInfo[x][Gosti_2],32);
cache_get_value_name(x-1,"Gosti_3",HouseInfo[x][Gosti_3],32);
cache_get_value_name(x-1,"Gosti_4",HouseInfo[x][Gosti_4],32);
cache_get_value_name(x-1,"Gosti_5",HouseInfo[x][Gosti_5],32);
cache_get_value_name_int(x-1,"hValue",HouseInfo[x][hValue]);
cache_get_value_name_int(x-1,"hHel",HouseInfo[x][hHel]);
cache_get_value_name_int(x-1,"hInt",HouseInfo[x][hInt]);
cache_get_value_name_int(x-1,"hGarage",HouseInfo[x][hGarage]);
cache_get_value_name_int(x-1,"hLock",HouseInfo[x][hLock]);
cache_get_value_name_int(x-1,"hTakings",HouseInfo[x][hTakings]);
cache_get_value_name_int(x-1,"hKlass",HouseInfo[x][hKlass]);
if(strcmp(HouseInfo[x][hOwner],"None",true) == 0)
{
HouseInfo[x][hPickup] = CreatePickup(1273, 23, HouseInfo[x][hEntrancex], HouseInfo[x][hEntrancey], HouseInfo[x][hEntrancez],-1);
HouseInfo[x][hMIcon] = CreateDynamicMapIcon(HouseInfo[x][hEntrancex], HouseInfo[x][hEntrancey], HouseInfo[x][hEntrancez], 31, -1, 0, -1, -1);
}
else
{
HouseInfo[x][hPickup] = CreatePickup(1272, 23, HouseInfo[x][hEntrancex], HouseInfo[x][hEntrancey], HouseInfo[x][hEntrancez],-1);
HouseInfo[x][hMIcon] = CreateDynamicMapIcon(HouseInfo[x][hEntrancex], HouseInfo[x][hEntrancey], HouseInfo[x][hEntrancez], 32, -1, 0, -1, -1);
}
HouseInfo[x][hExitText] = CreateDynamic3DTextLabel("Чтобы выйти из дома {FFFFFF}[ Нажмите ENTER ]\n{FFCD00}Открыть меню дома {FFFFFF}[ Нажмите ALT ]",0xFFCD00FF,HouseInfo[x][hExitx],HouseInfo[x][hExity],HouseInfo[x][hExitz]+1,5.0,INVALID_PLAYER_ID,INVALID_VEHICLE_ID,0,x+50);
TotalHouse++;
}
printf("[Загрузка...] Данные из домов получены! (%i шт.)",TotalHouse);
return true;
}
