Outdated New Public DB Link can be found in this topic

[PlanarChaosRvrtwo]

From now on tegstewart will develope this db i gonna sent him time to time some fixes but now its time for my own server^^.
And soon he did the adjusted he will post down in this topic his developement thread.
(this Public DB is meant to be under permanent developement, old developer give it to next by that we can ensure the public db get better and better and the user files sent to topic of current developer can add it to public db like graveen do with code)

(there may be some npc in *j dftest but those are workhelper)
Mostly combinated most useful dbs rest you can see below.

Download:
https://sourceforge.net/projects/yggdra ... p/download

Following things are supposed to not working if you use it (to make sure not everyone can one click making server and get alot of money by donates just to close it after)

Paths not assigned to mobs/items
Housing NPCs that are placed on hookpoints missing sell lists
A few item stats.
A few to much duplicates of mobs you need remove if you use this DB. (that is supposed so you can see ingame what package work best for you in wich zone and then you can do an combined sql command to find the wrong packages in specific zone and delete em couse otherwise you ether have empty zones or need remove to much by hand and if i decide for you i maybe find out in 1 year or something wait for toa this package and for si another would have been good)
Only Old Keeps in DB

Following things are added:
Fixed Housing
Full list of Teleport locs on teleporter npcs.
Classic One time drops
The missing town Brynach in Valley of Bri Leith has been added
The issue that Gale the mob in Cliffs of Moher in Hib was leather dye merchant has been solved.
The issue that Trahern the merchant in hib and the mob in dartmoor alb used the same npc template has been solved.
Missing Doors has been added to all clasic / Si maps and the frontier relic gates has been added
Most renegade guards has been removed from classic and si map and also Tir na Nog the ones in frontiers still exist couse you can do keeps around the towns and relic keeps to change it.
Championlevel skills has been fixed with the query you find in this topic.
Vikings now got staff ability due to the query you find in this topic.
Pictslayer Weapons and Merchants with their Banner has been added to capitals (or to be exact not removed to upload)
(The Pictslayer Items are an alpha Version they gonna be reworked but allready work temporal)
The Special Npcs in Hib ''Scrios de Atlantis'' has been set to realm 3 changed Mob Class and item AtlanteanGlass has been added so they dialog messages displayed correct and the item have model level stacksize should be also correct.
Speed of 12k mobs has been fixed.
Dragonsworn Staff (Alb) has been fixed on storm by me and is now correct in this DB too.
Thanks to hope the missmatches of loot and itemtemplate has been fixed.
Proper realmguards in NF (for svasud faste, vindsaul faste, druim ligen, druim cain,castle sauvage, snowdonia fortress)
Check Default Portal Keep guards looking here (npc template n such you can check yourself db wise later^^):
http://www.dolserver.net/viewtopic.php? ... 87#p158387

fixed mobclass on a long list of mobs
corrected 28 issues of db reading issue of server
fixed dragon items
added dragonscale class to dragonscale merchants

PLEASE NOTE: This DB may look very like a finished server but its just an more stable start for an Livelike server it dont fit every of your needs.

(thanks to following peeps helping me)
Yay of Storm - Helping me to solve the things that occured by merging.
Leodagan - Explaining me a few scripts so the Database merge with latest Code
Satyr of Storm - Remembering the things i should do and wich not
Trishin of Uthgard - Sorting my boiling brain as some things broke
Mzae of Atlantis - For sharing my OTD work i did 5 years ago
Graveen - For explaning me what is important


List of the otds i added:
http://www.dolserver.net/viewtopic.php?f=70&t=23042

[Graveen]

Very good job... time for me to create a brand new DOLSetup.exe with the most up to date Database

[PlanarChaosRvrtwo]

I noticed there is one last issue that some of the loottemplate ids not merging with the itemtemplate id (not many but still) so you need fix that if using this DB.

[LugusSkye]

can you please clarify on a few things:

...
The database will be mainly a combination of most useful dbs around and reworked to match with the newest sourcecode...

What DBs were used in your project and what entities from which DB were migrated? A lot of tables are connected and links have to be preserved. Can we get better understanding on your work so maybe other servers can reuse it as well?

...
Following things are supposed to not working if you use it (to make sure not everyone can one click making server and get alot of money by donates just to close it after)...

I am not clear on above statement as well as whatever following it. Were those issues fixed? And...sorry but I am yet to see anyone getting lots of donations to close right after, I might have missed some servers, I wasn't here from the beginning of DOL revolution

[PlanarChaosRvrtwo]

The used Databases Are last dol publicdb sniperwolfdb misimousedb and some small parts from Whiria.

The things that supposed to not work is the result of combination and can be very easyly fixed if you know how to use database.
And years ago we had many servers and some of em were only used to get donations not to be open for players couse the problem is if donations > server rent and some kind of peeps will do it so if we leave some work to em its not rentable for em to prank players.
And i think its very important that we protect players from such peeps with our work.

(i could tell you a list of servers that were made just to get donations but its in the past and maybe some of the owners changed their behavior and i dont want destroy their actual reputation so im not telling you who did that / wich servers.)

[Eyebalze]

hi all,

just wondering, because i couldn't find the info in the explanation above,
for what DOL Server Version is this DB working for? I am not able to test it atm.
but would be nice to know on what revision you were working with.

thanks,

eyebalze

[PlanarChaosRvrtwo]

The data i used i downloaded here: https://github.com/Dawn-of-Light/DOLSha ... 1.9.7.3595

[Eyebalze]

The data i used i downloaded here: https://github.com/Dawn-of-Light/DOLSha ... 1.9.7.3595

Thank you!
Good work Planar! - keep it up

[PlanarChaosRvrtwo]

Will do but ofc its possible i need rework it a bit couse its the first time i publish a database and im gonna do my own server and by that i gonna upgrade this db again but i wanted release the db early.

[ontheDOL]

Thanks for sharing

grabbing those one time drops

[Velloro]

Always nice to see new work being completed on the DOL scene. Not many people contributing these days.

[Hope]

Hi,

Thank you for your work.

I'm currently trying to understand how DOL works and everything. So I wanted to start with a fresh install, the less errors the better, to understand things gradually and then add/remove/change stuff if needed. I thought I could try your database, but so far I have had severall issues. Maybe I'm doing something wrong, I don't know.

I'm using :
- DOL 1.9.7.3595 release from Github
- Latest client files 1.122 i think ?
- game.dll version 1.109 from this thread

Some of the issues I've had so far while trying to test your database :
- Not really a issue, but your account and characters tables are not empty (i think there is an account called admin and some characters).
- A lot of item names missmatch between the loottemplate and the itemtemplate tables (I've managed to fix most of theses).
- A lot of "ERROR - DOL.GS.Keeps.GameKeepDoor - Failed to load keep door from position!" I don't know what to do with.
- In game there are renegade guards everywhere, so it's impossible to play with a normal character without being killed over and over. I don't really know what's causing that and how to fix it.

Maybe I'm not doing things right, or I should look for a smaller database, with less stuff but no errors, but so far I've been unable to do that.

Anyway the work you did seems huge so thank you again for sharing it.

[PlanarChaosRvrtwo]

Cool 37 downloads and one appeal just good for my first DB release

[HunabKu]

Hi Hope.
For the KeepDoor errors, they don't affect the gameplay.
For the renegade guards, PlanarChaosRvrtwo need to fix it by changing their Realm.

[PlanarChaosRvrtwo]

Yeah Renegade Guards and Keepgates i fix in next version with a few other things.
Thanks for your Appeal Hope.

(Will not do work atm couse im ill but if im back up and brain stops bug i do the work^^)