Awesome, Realityincarnate
And to explain a bit about the spells_new table:
This is a table that AndMetal implemented a while back. Basically, you can import/export the spells_us.txt file into it or out of it. The PEQ DB now comes with that table fully populated, I believe, so there is no need to import or export unless you want a spells_us.txt (to share with players if it is custom, or to use the ailia/bleh spell editor). Basically, the table completely replaces the need to have the spells_us.txt in your server folder. This option is not defined by default, so the precompiled binaries still require the file. IMO, it is ready to become the default now.
There are quite only a few benefits to having the spells in the database vs using the file. One of them is that developers for your server that have access to your database could edit spells directly without requiring any special access to the file or anything. Another is that web-tools could be created to manage the new table. But, I think the most beneficial reason to have them in a table is that it opens up new possibilities like adding new fields to the table that we can use to do anything we want with, like the example I gave. I am sure there are more possibilities, but that is just the first one I have thought of so far that would be really cool to have.
I bet someone could even make a web-tool that would generate a spells_us.txt file on-the-fly from that table. So, then you could do edits to your spells table and then any player that downloads the file would get the latest version with your updates included.
Hybrid Mode
