Dom3 DB: Weapons, Armor & Magic Items
 

All right, folks!

First installment of the DB after the previously released forts and poptypes.

This is just a partial version and subject to revision, but it should help people get started. The weapons list is complete. The armor list is incomplete, because it is impossible to assign armor by the id number so I had no way to find out some of the armor names toward the end.

Gandalf, you need to do a new string dump from the armor list, the old one's missing far too many.

The item database is very preliminary and does not list non-forgeable items except for the Sun Shield. Only item numbers, names, research level and primary and secondary path requirements are listed. The rest will follow some day, but this should be some help to modders.

Oh, and the file is in Open Office spreadsheet format. If you do not have Open Office, do NOT come crying to me, because I will forthwith tell you to sod off in very explicit terms. The DB is work enough that I cannot be bothered with providing separate file formats for people who use different software than I do.

In case anyone is wondering about the very narrow empty columns, those are there to deal with a very annoying format overflow bug in Open Office, namely that the data formatting of the previous column will overflow into the next if the values in the cells are effectively the same (e.g. a column having percentage data and a value of 0% in the cell and the next column is pure numbers with value of 0, the number cell will show value of 0%). The empty column is the only way to work around it.

DB file attached.

Edi

Re: Dom3 DB: Weapons, Armor & Magic Items
 

Thanks Edi - you rock!

Re: Dom3 DB: Weapons, Armor & Magic Items
 

Awesome Awesome Awesome Awesome http://forum.shrapnelgames.com/images/smilies/happy.gif :-) Edi++

Re: Dom3 DB: Weapons, Armor & Magic Items
 

Can I get a copy of the database as a Photoshop file? So I can apply a sharpening filter to it?

Re: Dom3 DB: Weapons, Armor & Magic Items
 

You want a screenshot of it? In what format?

Re: Dom3 DB: Weapons, Armor & Magic Items
 

For us M$/Excel users, any chance to have a xls version ?
I suppose that a "save to/export..." exists, it's like 1 min effort http://forum.shrapnelgames.com/images/smilies/wink.gif

Re: Dom3 DB: Weapons, Armor & Magic Items
 

For you Excel users:
You can download openoffice for free at:
http://www.openoffice.org/
and use the import/export function.

Edi rocks !

Re: Dom3 DB: Weapons, Armor & Magic Items
 

Great job Edi!

Re: Dom3 DB: Weapons, Armor & Magic Items
 

All hail Edi!

Oh, and Openoffice rocks! http://forum.shrapnelgames.com/images/smilies/happy.gif

Re: Dom3 DB: Weapons, Armor & Magic Items
 

Thanks Edi, I will be very useful.

Note : just found a small error in the armor list. The flame helmet does not five 5 body protection, it give 5 points of untyped protection, meaning that it adds both to head and body (similar to the bonus protection from the bracers of protection)

Re: Dom3 DB: Weapons, Armor & Magic Items
 

Damn. Missed that. I'll fix it for the next version.

The reason I'm loath to start fiddling with making an Excel version is because Excel doesn't have Boolean values as a ready cell format. Even saving it as an Excel file will not correctly translate the Booleans, so you need to modify the formatting of each column that has them and it's a pain in the arse, especially with different language settings. It'll show things in Finnish when it should preserve the English formatting and otherwise screw things up.

If somebody else wants to do the conversion, be my guest, but I'll rather work on the DB.

Edi

Re: Dom3 DB: Weapons, Armor & Magic Items
 

I'd kinda like to see DB stuff in .csv format (which excel could easily open, although that's a side issue), so that I can parse it in an automated way - specifically, so that I can automatically add mods in the same formatting.

I have some scripts that read mods and produce .csv files - I could try to update them to produce open office file format instead, certainly that is worth considering.

This is more of an issue with the unit DB - my script will have the intelligence to remember the stats of a unit, and then when those stats are *copied*, the script will know to spit out the same stats (unless they are subsequently over-written.)

But this is an issue we can discuss after your DB is finished. Excellent work, Edi!

Re: Dom3 DB: Weapons, Armor & Magic Items
 

OFS is the new open format for spreadsheets. Its "good for everybody". So it wasnt a bad choice since it wasnt proprietary to one company and one software.

CSV is a comma seperated ascii text file which is older than PCs. Good for easy programming and also should be able to be read by any program.

Personally I was kindof glad to see something not being put up as DOC or XLS. But if anyone wants it in another format I could probably go ahead and create one to make available off of my site. But first you should check and see if your program isnt willing to read it as it is. Its rather obnoxious if it wont.

Re: Dom3 DB: Weapons, Armor & Magic Items
 

Thank you for not making the type microscopic and the form easy to read!

Re: Dom3 DB: Weapons, Armor & Magic Items
 

Thank you Edi. You should get money for your work http://forum.shrapnelgames.com/images/smilies/happy.gif.

Re: Dom3 DB: Weapons, Armor & Magic Items
 

For you OSx users, NeoOffice works just fine for this.

http://www.planamesa.com/neojava/en/download.php

It is based on OpenOffice and has fewer install problems

Re: Dom3 DB: Weapons, Armor & Magic Items
 

Could anyone who already converted it to an excel file quickly attach it to this thread? Downloading ~94meg (OpenOffice) on dialup takes a lot longer than an excel sheet.

Thanks in advance.