IFO Spawns

[Drakia]

Actually what I meant was even converting the IFO to SQL is slow, the problem is the major increase in SQL rows (3200 mob groups for the entire server, then each group has 1-10 entries of mobs that need to be stored) I'll attach a current dump from the IFO's of the structure I was using as a test. It can't be used unless the server is re-written to use it though, so this is just to look through mainly, try to find a better way to do it.

[Rifke]

What about reconverting that sql to the current sql?

You've also have two tables

• list_spawnareas
• list_spawnareas

[Drakia]

The current system uses a polygon based spawn area, the client uses a circle based (x/y/radius) system. The current system also only uses one table, not two like my test, though I might have thought up a way to make it use only one (I'm currently working on making the server read from the IFO based table)

[Maxxon]

I think the loading time would be longer because the server stores everything when it loads. It would save loading time when only the spawns are loaded when the map is used.

As it is a server i would not mind how long it loads. And i would not try to opimize it for minimal memory consumption. In my opinion, the server should be optimized for performance for gameplay (at least that what i do :p). Even if that comes at the cost of more memory consumption or increasing load time.

[lmame]

It's more the traversing that concerns me actually.

[Drakia]

Which traversing?

Ok, I have the server loading and using the IFO based spawns (Converted to SQL). Here's a picture of El Verloon with the Aqua King spawned. The system still needs work (I don't know what a couple of the values are for still) but it's coming along. I'll post instructions when I have a few more kinks worked out (Including the load time, it's about +30 seconds right now, which is far too long)

[Blackdpd]

well finally some damn nice spawns... and im going to steal that from you for my rose server because i like those spawns like they are my family

Blackdpd `

[lmame]

Which traversing?

I don't really know how spawns are working server side. If it's like the traversing of players or stuff, it could take quite some time.

[Drakia]

I'm not sure how the respawning and updating and such is done.
I managed to merge the two tables into one (Using a ,| split mobList column) and it sped up the loading time, it now takes the same time as before switching over, so no +30 seconds Gonna work on some more tweaks, then post what I have (Not production ready! There are still many fields that aren't utilized, as I don't know what they do, and a lot of this is guesswork)

[Rescudo]

Good work Drakia - I really hope this works out