novichockpawno
Дебютант
Доброго времени суток! Столкнулся с такой проблемой - ввожу команду /createhouse - создается пикап и сохраняется его положение в базе данных, но если выйти с сервера и выключить его, потом включить и зайти на сервер - не отобразится дом(пикап его), в логах MySQL нету никаких ошибок. Прошу помочь!
[/I][/I][/I][/I][/I][/I][/I][/I][/I][/I][/I][/I]
Версия MySQL - R40
PHP:
CMD:createhouse(playerid)
{
if(GetPlayerState(playerid) != PLAYER_STATE_ONFOOT) return 1;
new Float:x, Float:y, Float:z, Float:a;
GetPlayerPos(playerid, x, y, z);
GetPlayerFacingAngle(playerid, a);
new string[200];
format(string, sizeof(string), "INSERT INTO `houses` (`id`,`x`, `y`, `z`, `a`) VALUES (%d, '%.3f','%.3f','%.3f','%.3f')", house_info[Houses][h_id], x, y, z, a);
mysql_query(dbHandle, string);
house_info[Houses][h_id] = cache_insert_id();
house_info[Houses][h_pickup] = CreatePickup(1273, 23, x, y, z);
house_info[Houses][h_area] = CreateDynamicSphere(x, y, z, 1.5);
AddGroupGoodAreas(HouseGroup, house_info[Houses][h_area], Houses);
house_info[Houses][h_x] = x;
house_info[Houses][h_y] = y;
house_info[Houses][h_z] = z;
house_info[Houses][h_a] = a;
house_info[Houses][h_interior] = 1;
house_info[Houses][h_price] = 1;
house_info[Houses][h_class] = 1;
Houses++;
return 1;
}
mysql_tquery(dbHandle, "SELECT * FROM `houses` WHERE `id` = '%d' LIMIT 7", "LoadHouses");
PHP:
forward LoadHouses();
public LoadHouses()
{
new rows;
cache_get_row_count(rows);
if(rows)
{
new Float:x, Float:y, Float:z;
for(new i = 0; i < rows; i++)
{
cache_get_value_name_int(i, "id", house_info[I][h_id]);
cache_get_value_name_int(i, "owner", house_info[I][h_owner]);
cache_get_value_name_int(i, "interior", house_info[I][h_interior]);
cache_get_value_name_int(i, "price", house_info[I][h_price]);
cache_get_value_name_int(i, "class", house_info[I][h_class]);
x = cache_get_value_name_float(i, "x", house_info[I][h_x]);
y = cache_get_value_name_float(i, "y", house_info[I][h_y]);
z = cache_get_value_name_float(i, "z", house_info[I][h_z]);
cache_get_value_name_float(i, "a", house_info[I][h_a]);
house_info[I][h_pickup] = CreatePickup(1273, 23, x, y, z);
house_info[I][h_area] = CreateDynamicSphere(x, y, z, 1.5);
AddGroupGoodAreas(HouseGroup, house_info[I][h_area], Houses);
}
Houses = rows;
}
return 1;
}
Версия MySQL - R40
Последнее редактирование модератором:
