Hello, EQClassic. I have some great news today for all of you who wish to contribute to the project: I am pleased to announce the independent, open source database project which may be used to drive the EQC server-side code.
The project is located at google code:
http://code.google.com/p/eqclassicdb/What does this mean for you? It means you finally have a way to contribute to the project! You, the community, will finally be able to help recreate the database within the game as it was during the SoV era. This includes merchants, NPCs, loot, spawns, and faction. I do not expect anyone to be creating additional spawns, but I do expect incorrect, post-classic era spawns to be purged from the database.
All it requires is that you have a PHP-based webserver (you can download one like WAMP for local use) and a MySQL database available. Every query and change you make to your local database will generate an SQL query through the tool. For this purpose, I suggest you do not use anything else with the tool unless it logs queries, or your submissions may be lost. In addition to this, you must give an explanation to as what changes you have made. All submissions will be reviewed by the database team (currently, that is me, Secrets). At this time, the submissions forum is unavailable, but it will be added soon.
The tool is very easy to set up: You must have a web server with PHP & MySQL enabled, and you MUST fill out config.php for local use, located in the phpeditor directory.
A sample of this tool is available here:
http://totalanarchy.vpscustomer.com/phpeditor/There will be NO support for the tool past being set up. Any bugs are to be reported in the database forum WHEN IT IS SET UP. If you have a question about the schema, well, that's what the questions forum is for.
A big thanks to Cavedude & Team of EQEMu's ProjectEQ.net for making the editor source code available for public use. Without him, I would not have made this editor.
Oh, and good luck, submitters. I look forward to seeing your SQL knowledge.
Thank you Secrets.