25.05.2017, 23:16
I have a suggestion to support a lot more houses.
1.) Set the extraid to point to the primary integer key in your DB.
2.) Make query only when required to load house data.
- Check if house is already loaded if not load data
3.) Save house data into a per player array.
4.) Reference that array for any house actions.
Some other ideas, you could buffer loaded houses then check the buffer before making any queries this way if you got 10 guys going into a single house only one query would actually be made. The good thing is this is pretty much done for you already by using this kind of system! All you would have to do is loop through all the players.
Код:
public OnPlayerEnterDynamicArea(playerid, areaid)
{
new houseid = Streamer_GetIntData(STREAMER_TYPE_AREA, areaid, E_STREAMER_EXTRA_ID) - HOUSE_MAGIC;
2.) Make query only when required to load house data.
- Check if house is already loaded if not load data
3.) Save house data into a per player array.
4.) Reference that array for any house actions.
Some other ideas, you could buffer loaded houses then check the buffer before making any queries this way if you got 10 guys going into a single house only one query would actually be made. The good thing is this is pretty much done for you already by using this kind of system! All you would have to do is loop through all the players.