21.01.2019, 18:17
I managed to fix it, now I am occuring a different error.
after creating a house, it does not spawn
Code:
CMD:createhouse(playerid, params[]) { new price, Float:x, Float:y, Float:z, query[800], str[350]; if(PlayerInfo[playerid][pAdmin] < 4) return SendClientMessage(playerid, COLOR_GREY, "Not authorized!"); if(sscanf(params, "d", price)) return SendClientMessage(playerid, COLOR_GREY, "Usage:{FFFFFF} /createhouse [price]"); for(new i=1;i<MAX_HOUSES;i++) { GetPlayerPos(playerid, x, y, z); HouseInfo[i][hOutInterior] = GetPlayerInterior(playerid); HouseInfo[i][hOutWorld] = GetPlayerVirtualWorld(playerid); HouseInfo[i][hOutPos][0] = x; HouseInfo[i][hOutPos][1] = y; HouseInfo[i][hOutPos][2] = z; HouseInfo[i][hPrice] = price; format(query, sizeof(query), "INSERT INTO `houses` (`Out_X`, `Out_Y`, `Out_Z`, `OutInt`, `OutWorld`, `Price`) VALUES ('%f', '%f', '%f', '%d', '%d', '%d')", HouseInfo[i][hOutPos][0], HouseInfo[i][hOutPos][1], HouseInfo[i][hOutPos][2], HouseInfo[i][hOutInterior], HouseInfo[i][hOutWorld], HouseInfo[i][hPrice]); mysql_function_query(dbhandle, query, true, "LoadHouses", ""); format(str, sizeof(str), "You created a house at X: %f, Y: %f, Z: %f, for price of: %d, house ID: %d", x, y, z, price, i); SendClientMessage(playerid, COLOR_GREY, str); return 1; } return 1; }