PHP код:
CMD:setpos(playerid, params[])
{
if(Player[playerid][pAdmin] < 8) return ESCM;
Adm2;
Adm1;
new string[128];
new query[128];
if(sscanf(params, "i", params[0])) return SCM(playerid, COLOR_WHITE, "Введите: /setpos [ID дома]");
if(params[0] < 0 || params[0] > 594) return SCM(playerid, COLOR_GREY, "ID дома не может быть меньше 0 или больше 594!");
new Float: X;
new Float: Y;
new Float: Z;
GetPlayerPos(playerid, X, Y, Z);
House[params[0]][hX][0] = X;
House[params[0]][hY][0] = Y;
House[params[0]][hZ][0] = Z;
UpdateHouse(params[0]);
mysql_format(Connection, query, sizeof(query), "UPDATE `house` SET ");
f("`Pickup X`= '%f',", House[params[0]][hX][0]);
strcat(query, string, sizeof(query));
f("`Pickup Y`= '%f',", House[params[0]][hY][0]);
strcat(query, string, sizeof(query));
f("`Pickup Z`= '%f'", House[params[0]][hZ][0]);
strcat(query, string, sizeof(query));
f("WHERE ID = '%d'", House[params[0]][hID]);
strcat(query, string, sizeof(query));
mysql_function_query(Connection, query, true, "", "");
f("Координаты дома №%d успшно изменены", params[0]);
SCM(playerid, COLOR_WHITE, string);
return true;
}
PHP код:
stock UpdateHouse(h)
{
DestroyDynamicMapIcon(House[h][hIcon]);
DestroyDynamicPickup(House[h][hPickup]);
if(strcmp(House[h][hPlayer],"None",true) == 0)
{
House[h][hPickup] = CreateDynamicPickup(1273, 23, House[h][hX][0], House[h][hY][0], House[h][hZ][0]);
House[h][hIcon] = CreateDynamicMapIcon(House[h][hX][0], House[h][hY][0], House[h][hZ][0], 31, 0, -1, -1, -1, 200.0);
}
else
{
House[h][hPickup] = CreateDynamicPickup(1272, 23, House[h][hX][0], House[h][hY][0], House[h][hZ][0]);
House[h][hIcon] = CreateDynamicMapIcon(House[h][hX][0], House[h][hY][0], House[h][hZ][0], 32, 0, -1, -1, -1, 200.0);
}
}