PHP код:
case 6:
{
if(response)
{
new Float:x[3], str[32];
GetPlayerPos(playerid, x[0], x[1], x[2]);
GetPVarString(playerid, "h_name", str, 32);
new mysql_querys[32]; // Подсчитывай строку, тут точно не 32.....
TotalHouse++;
HouseInfo[TotalHouse][hID] = TotalHouse;
HouseInfo[TotalHouse][hX] = x[0];
HouseInfo[TotalHouse][hY] = x[1];
HouseInfo[TotalHouse][hZ] = x[2];
HouseInfo[TotalHouse][hPrice] = GetPVarInt(playerid, "h_price");
HouseInfo[TotalHouse][hInterior] = GetPVarInt(playerid, "h_int");
HouseInfo[TotalHouse][hVirtWorld] = TotalHouse;
strmid(HouseInfo[TotalHouse][hAddress], str, 0, 32, 32);
strmid(HouseInfo[TotalHouse][hOwner], "None", 0, 5, 5);
SaveHouse();
HouseInfo[TotalHouse][hVirtWorld] = CreatePickup(19470,23,x[0],x[1],x[2],0);
format(LString, 128, "Продаётся\nАндрес: %s\nЦена: $%d", HouseInfo[TotalHouse][hAddress], HouseInfo[TotalHouse][hPrice]);
HouseInfo[TotalHouse][hText] = Create3DTextLabel(LString, 0xFFFFFFFF, x[0], x[1], x[2] + 0.5, 10.0, 0, 0);
mysql_format(mysql_variable, mysql_querys, sizeof(mysql_querys), "INSERT INTO `house` (`hID`, `hX`,`hY`, `hZ`,`hPrice`,`hInterior`,`hVirtWorld`,`hAddress`,`hOwner`)
mysql_format(mysql_variable, mysql_querys, sizeof(mysql_querys), "%sVALUES ('%d', '%f', '%f', '%f', '%d', '%d', '%d', '%s','%s')",
mysql_querys,HouseInfo[TotalHouse][hID],x[0], x[1], x[2],HouseInfo[TotalHouse][hPrice],HouseInfo[TotalHouse][hInterior],
HouseInfo[TotalHouse][hVirtWorld],HouseInfo[TotalHouse][hAddress],HouseInfo[TotalHouse][hOwner]);
mysql_function_query(mysql_variable, mysql_querys, false, "", "");
GameTextForPlayer(playerid, "~w~House ~g~Created",100,1);
DeletePVar(playerid, "h_price"), DeletePVar(playerid, "h_name"), DeletePVar(playerid, "h_int");
}
else DeletePVar(playerid,"h_price"), DeletePVar(playerid, "h_name"), DeletePVar(playerid, "h_int");
}