Public Database Svn Project OPEN!

[zycron80]

I have opened up the Public Database SvN with the first version of the database. KEEP in mind this project is 3 hours old. I will have more in the DB shortly and will be working on it as much as possible if anyone wants to help PM me for write access to the svn! hope everyone enjoys this! The project was started by merging Misi's DB Dawn of Lights DB and My own DB to get the most complete db i could to start off with and hopefully with some good effort i will have a pretty good DB for everyone very soon!


https://dolpublicdb.svn.sourceforge.net/svnroot/dolpublicdb/

[Graveen]

Good luck !

If you can define an ETA, this would help ! This is certainly an hard task, but doing this per zone/region/(w-e you find pertinent)
is good.

* Database population

- Mobs mapping: % completed
- Mobs behaviour: % completed (equipment, brains, roaming, faction, ambient...)
- Items creation: % completed
- Loottemplate creation: % completed
(etc)

* Focus points
- Zone X or Region Y, etc...
- Tools to use (itemcreator, etc...)


i wish you an huge good luck

[Tinantiol]

Great! If i'll find something wrong i'll let you know! We rly need a complete database, so DOL will be something near the PERFECTION!

[zycron80]

as it stands now its no where near complete but i willpost the %'s and all after i get home this eavining

[Tinantiol]

as it stands now its no where near complete but i willpost the %'s and all after i get home this eavining

Yeah i know, that's why i said :

so DOL will be something near the PERFECTION!

[Tinantiol]

is something near the impossible run that on navicat lol :

more than 1 hour and it's only at 17%

lol

[uhlersoth]

So how exactly do you go about creating a db like yours or misimouse's?

I mean, I understand SQL just fine. And I understand how to create NPCs in the DoL database --- for grins I created Aeniel, the TNN dye merchant, before I found out about misimouse's db. And you can go to allakhazam in order to get locs and some stats on those NPCs.

But what about mobs? How do you determine, "Yes, put three mudmen precisely here, here, and here, and have them respawn every 4 minutes." And in general, do people do much quality assurance on a database like that?

[Graveen]

The problem is related to items, and loots from mob.

For the mapping of mobs, you can simply use packetlogguer and plc filter (available in SVN) that are simply recording the position of the mobs from pendragon

[Roozzz]

I personally never tinkered with this but I was curious if there is an easy way to track the changes which have been made to the DB SVN?

Since I see we are at revision 15 now, but what has been done, or which files has been changed is impossible to see since it is one big db dump. Any convenient way to do this?

I ran into this: http://www.codeproject.com/KB/database/ ... B4Svn.aspx So it seems to be possible. Main issue will be to track the Data changes I think?

-edit-
How about Liquibase? That seems to do the trick.

[rdsandersjr]

This would be more "work" but couldnt you just upload each tables sql files (granted u wouldnt want todo that with 1 sql file from a complete database) just like you would a .cs, .vb ect.. file? it should detect the changes shouldnt it?

[Doomsday]

I can do the spell db if no one is working on updating that yet

[zycron80]

Just want to apologize i had my family in a different state have a house robbery and all 3 of them were killed. needless to say i had to fly up out of state for months and tie up loose buiness and personal ends. then come back home and get my RL back in order.. im back now and back to stay tomorrow i will move the svn to sourceforge and get started on this project for real!

[viper1805]

Hi,

we are already working on something: http://sourceforge.net/projects/dolpubdb/

and we have a runing database with about 700mb of data, currently deathwish and I are working on it

...

https://db.msv-graphics.de (You can trust this connection =P )

User: guest
PW: guest

(You can't see everything ^^)

regards,

viper

[Graveen]

Very good, my conclusion was all db related projects were dead !

Please use MyISAM for the releases

[craqed]

is there going to be a release of this db soon? it'ss been a while since hte last build listed for download.

is there svn access?