[OLD] DoL Public DB Releases

[viper1805]

Hi,

some Databases for DoL:

Merged Misi's ad DoLPubDB:
http://sourceforge.net/projects/dolpubd ... p/download
Credits: Gadariel

DoLPubDBV2.1:
http://sourceforge.net/projects/dolpubd ... p/download

SVN URL:
https://dolpubdb.svn.sourceforge.net/svnroot/dolpubdb/

SVN-Browser:
http://dolpubdb.svn.sourceforge.net/viewvc/dolpubdb/


If you want to help us contact deathwish or me (=

regards,

viper1805

[deathwish]

Right, where yo start
For Graveen, database engine is MyISAM.

Based on the the v 1.9.4 r2500 DOL public database, and the old 1.9.3 r2018, i have merged them together as a template.
after i merged my database with Vipers database and created a new public database.

The database should now have most mobs in every zone apart from Toa, Cata, DR,Lab.
Work on the other zone will start very soon, but im trying to focus more on the classic and si zones first.

The database has the following:
Itemtemplate = 34454
loottemplate = 19617
merchantitems = 26012
mobs = 88261
mobxloottemplate = 3852
npcequipment = 26216
npc template = 342

Smaller updates for the database will be available as they are made, so keep a eye out for them.

For more info, or like to add some info please do, help always welcome
Thanks for your time.


Sql Patch for double mobs withing region 249 (Darkness Falls)
The Patch will delete all mobs withing region 249 and reinstall them for you.

[Roozzz]

Great job

How are you planning to release updates? Just add it to the entire database, or provide them as a single zone download or both maybe? Would make things nice and easy to add in for people

[viper1805]

we will in longer rages release complete packages (like this)

and all small updates will release in a SVN (each table on it's own)

[viper1805]

New Update:
- V2.1 released
- added everything to SVN

V2.1
removed some not needed tables (account, dolcharacters, bans, etc.)
fixed some incompatibility problems with the current DOL SVN

http://dolpubdb.svn.sourceforge.net/vie ... revision=7

Links in first post updated

[Argo]

Great job viper, a big thx for all your work from my side

[viper1805]

don't forget deathwish

... but thanks

[craqed]

Thanks! I'm pulling the svn as we speak.

[tegstewart]

I can't give this the thumbs up it deserves without needing physio afterwards. Incredible job Viper, Deathwish, Zycron and Misi!

[deathwish]

hehe thx, still no where finished yet, but with in time im sure we have almost everything done, im going to start working on adding mobs with spells soon, so many mobs cast spell, buffs, etc but dont have their spells yet, so im going to start working on the mobs / spells soon, keep your eye out for an update soon! (it will just be a small sql addon to add the spells to the mobs)

[tegstewart]

I've noticed that there are some duplicate mobs with identical X,Y, and Z coordinates. Umbrood Warriors in DF are a good example. I'm trying to come up with a select statement to generate a list of them, but my SQL fu is weak, I'm afraid.

I'll let you know when I figure it out.

Edit: Figured it out. Select statement is:
select `mob`.`Name` AS `Name`,`mob`.`X` AS `X`,`mob`.`Y` AS `Y`,`mob`.`Z` AS `Z`,`mob`.`Mob_ID` AS `mob_ID`,count(0) AS `cnt`
from `mob`
group by `mob`.`Name`,`mob`.`X`,`mob`.`Y`,`mob`.`Z`
having (count(0) > 1)

It returns 10279 mobs with 2 entries each.

Double-edit: The query returns the duplicate Mob_IDs of one of each duplicate, but not both. So you can delete everything with a Mob_ID this query returns to fix the problem. Score!

[Graveen]

Thank you for the SQL. The next enhancement is to delete the mobs which do not have a valid equiptemplate (this is mainly the problem).

[deathwish]

thank you for the report, i will have a look and remove this silly error for the next update

[deathwish]

I have fixed all mobs withing region 249.
The patch is a sql file that will delete all the mobs in region 249 then reinstall them with out the doubles, sorry about this silly error.

Where to find the patch:
See the first reply on this post for a link to download or
http://sourceforge.net/projects/dolpubd ... p/download


How to install:
Just drag the DF Patch.sql into your database and it will do all the work.

[Dream]

You guys have a database for dragon items such as Fine Steel Long Sword?
Dragon loot
NOT Dragonslayer..


And possibly a full live like Astral Database?