A New Generation of DOL Public DB Team

[PlanarChaosRvrtwo]

Hey guys we wanna start the DOL PUBLIC DB Team again!

Link to download Database: Incoming

We have already recently published a database that works with the current DOL source code revision in order to provide a common base for DB content development.
However, Since it is a merger of multiple databases there are still a lot of kinks to iron out.

Our goal is to continuously improve this database, fix issues, add content and make structural improvements to share with the community.
Additional improvements and support will be given to those who actually contribute.

That being said, we are looking for team members and contributors to focus our work efforts and push DOL forward again.
Ideally you have experience with at least one database system (MariaDB/MySQL), understand entity relationships and are able to write basic SQL queries.
But even if you don't you can assist by playtesting and documenting issues.

A few conditions apply:

1) Generally every contribution will be shared and made public. You agree to that.

2) Database content must adhere to certain conventions http://www.dolserver.net/viewtopic.php?f=24&t=23112 in order to get published.

3) You need to coordinate your work with the team to prevent multiple developers working on the same thing.
Once the teams grows we will provide a Discord channel and a Trello dashboard representing an agile workflow to further coordinate the workload.
For the time being you can post into this thread if you're working on something.


We would be happy to have you onboard

[Graveen]

Best of luck !!

[PlanarChaosRvrtwo]

Graveen that appeal is a bit short no?^^

Ok without jokes: Thanks mate

[Xanxicar]

Hi folks,

i just wanted to give you a little update about the ongoings at the public db team. We are very happy to announce that we have taken on a 3rd team member, Urza the owner of the Urzaria server who has something like 8 years experience in developing database content for DOL servers. He has started world building in Hibernia and already committed fixes for faulty item template references (there is like a shit ton of those currently) that are up for review in the near future. He is willing and eager to share his own work and contribute by integrating it back into the public db where applicable and we are very excited about it. For his exemplary outlook and attitude we have accepted him into the team and given him access to our latest development build and database.

Meanwhile we have been hard at work trying to fix the messed up Champion Ability system and I'm getting the feeling we opened up Pandora's Box there. We found some bugs, committed our first fix ourselves and got more code related CL issues in the pipeline. Currently some CL base lines are inseparable due to how the network protocol worked back in the day and the legacy code modeling that. But we will get around to that as well as the flawed DOT spell stacking and health transfer spells we discovered while testing CL abilities.

Other than that rebuilding the CL lines and trainer trees is going well and we're getting to the point where the first realm is pretty much done aside from cosmetics. If you would like early access to our work make sure to be on the contributing side!

[Graveen]

Yeah !

Hey guys, if you want Storm as a running server, tell me. It would perhaps be better to let us have a maintained and active server than a new one.

Feel free to discuss this in PM

[LRFalk01]

How does one contribute to this? I do not find the public db on github. My brother and I are trying to make is so running a vanilla DOL server is as simple as running a docker install. Part of that is fixing a number of DB inconsistencies. We fully intend on pushing these fixes back upstream, but we're unsure as to the way to go about that.

Thanks,
LT

[PlanarChaosRvrtwo]

Do Enhancements towards this DB and share with us:
(You can pm me on forum or join the Discord Channel)
http://www.dolserver.net/viewtopic.php?f=70&t=23083

[ontheDOL]

i like the github idea discussed on discord, if it can be done.

probably be able to get fixes to the public quicker

[Loki]

i like the github idea discussed on discord, if it can be done.

probably be able to get fixes to the public quicker

I also think this is a fantastic idea, and much needed.

Something like this https://bitbucket.org/misimouse/misidoldb/src but for each table.

[LRFalk01]

I have gone ahead and created a repo on github. It is currently just the schema and data as it exists in Ginnungagap DB - 1.2. I will be adding a readme today, and hopefully a script to turn this back into a single file. So far the only fix is table casing to match what is defined in DOLDatabase (for linux support). I also have a few comments about tables that I am pretty sure can be removed. Anyway, long road ahead.

https://github.com/Eve-of-Darkness/db-public

-LT