Spell and styles db/id's?

[chichikuri]

Hey!

Where can i find a list of spells and styles id's?
trying to fix my db values but i'm having a hard time finding a nice post or site with a list of id's, could someone point me in the right direction please.

<3 Chichikuri +++

[sooid]

Tables spell and style.

[chichikuri]

Tables spell and style.

i would use them but there all wrong, the icons ain't right and million other small problems, both 1.9.1393 and 1902 db are flawed.
what i need is a post,hompage,url or just some place where i can find the id's for each and every spell and style and i'll fix the problem myself.

<3 Chichikuri +++

[Roozzz]

Like he said the id's are determined in those 2 tables. Spell Effect and Icon Ids and stuff are found here: http://metty.the-bart.org/other/daoc/li ... iew=spells

[chichikuri]

Like he said the id's are determined in those 2 tables. Spell Effect and Icon Ids and stuff are found here: http://metty.the-bart.org/other/daoc/li ... iew=spells

I'm already looking through that list, and im working on fixing the official 1902 db.
but im having a hard time finding the correct style id's, do you have any insights on where i might find style id's?
Also, is there anyone activly working on upgrading the official 1902 db?

<3 Chichikuri +++

[Graveen]

the official is now the 1.9.0.1393, this is the storm one on styles/spells. Use this base instead !

[chichikuri]

the official is now the 1.9.0.1393, this is the storm one on styles/spells. Use this base instead !

Yeah i changed my mind after going through the 1902 db tables and values, so much stuff missing in there..
i still need to work on getting the icons with the 1.9.0.1393 db, since they aint correct in that version either.
So i guess it's back to searching the DOL forums and google for correct id (number) tables, i have no clue where else to find this info =/

<3 Chichikuri +++

[Graveen]

well, i hope in 1 month +- i'll be able to host here such a list.

[Roozzz]

Isn't this somewhere in the Daoc files? Not sure, never looked into this.

[Graveen]

if the daoc files you can grab the ID list, but imho the interest is to have a picture associated to each member of the list.

[Luhz]

The ids are in the client MPK files.

For icons they map to the icon files by number (search the forums for the method how).

[chichikuri]

The ids are in the client MPK files.

For icons they map to the icon files by number (search the forums for the method how).

I did read all the faq's and "how too's" b4 i even started asking questions
I found them pretty easy, i'll be browsing through em later today. Thanks!

why aint the db values set up as the original mpk's?
wouldn't it be easier in case of a patch? might it be that the mpk's are just a reference for the client to know what's what?
sorry if im asking alot of newb questions, still trying to get a grip on things

<3 Chichikuri +++

[Graveen]

they are intended too, in most case.

Simply keep in mind some contributers are not really aware of this, and i guess id can also change over patchs

[chichikuri]

they are intended too, in most case.

Simply keep in mind some contributers are not really aware of this, and i guess id can also change over patchs

I guess your right ^^
But even tho the patches might change from time to time i would like to see some kinda general standard when it comes to the db's, sure the 1902 and 1901 are pretty similar and still needs a lot of work, but i have found it hard implementing stuff to it that others have released, most of the material aint compatible and/or missing important information/values. wich means that in the end i'll still have to implement almost everything by hand, and i'm pretty sure im not the only one. take Merec's Item Creator for example, it's not possible to create something from scratch and implementing it into the 1902/1901 db w/o getting the error "Field 'CanUseEvery' doesn't have a default value", im guessing the problem is cuz it's not creating this field or setting the value to NULL/0, one has to manualy create an empty item and then load it up and after that add the changes to it.

What im trying to say is that everyone is using their own version of the db's, wich in the end means the db progress is very slow, am i right?
copy/paste tables or rows inside db's is a pain in the ass! atleast when one is trying to move stuff from one version to the next, theres always something missing wich leads to an error.

sorry for going out of topic but i just couldn't help myself

<3 Chichikuri +++

[Graveen]

In fact the DB problem is twice:

first: the differents DBs spread all over the community
- Storm, on its server role, got a private DB, partly released (via the DB1.9.0.1393 and the previous (1902,1901, rev848...))
- I try to catch and making contribute, people that appears serious to me, and i direct them on Storm's work. The Storm db structure - i WOULD like to put on 1.9.0.1393 (i forgot on the end ), is spread as datas they need to contribute if applicable.

second: the fact DOL code is evolving and can implies DB changes (tables, fields, etc...)
- We want to push the core up, w/o worrying about structurals designs. Of course this is a problem we consider, but if a decent structural change need DB changes, it 'll be done. well, don't panic, this is really kept in mind