7 réponses à ce sujet

[Sidrat2009]

 Hi there I'm trying to piece together item names and stats for the purpose of creating a tool for character creation and best practice stuff.

I've got the SQL database sorted out  and I've linked it to MS Access to make things more graphical - however I really can't find where the relationships are, for e.g. Items, spells, skills names and their respective statistics and pre-requisites.

Can anyone point me in the right direction please?

[Challseus]

You'll want to read up on 2DA's and more specifically, ABI_base.xls. Finally, take a look at the String Editor with regards to item names/descriptions/etc.

If you need any other info, let me know.

[Sidrat2009]

Oh right I see, so what are the database tables storing then? I'll guess I'll just import the xml files to access so I can sort and query it better.

Thanks for the tips.

Edit:  It seems these 2DA's are created by a database in the first place, so there's linkage there and for the sake of my own sanity there must be relationships on the tables within the database - Just got to find them.

Modifié par Sidrat2009, 25 février 2010 - 04:08 .

[Challseus]

Sidrat2009 wrote...

Oh right I see, so what are the database tables storing then? I'll guess I'll just import the xml files to access so I can sort and query it better.

Thanks for the tips.

Edit:  It seems these 2DA's are created by a database in the first place, so there's linkage there and for the sake of my own sanity there must be relationships on the tables within the database - Just got to find them.

Checkout this page on Design Resources. Essentially, certain resources you create, like npcs, items, etc. are stored in the DB. Hell, your module itself is stored there! It acts as a repository, like SVN/CVS/GIT, so you can check in changes, do diffs, roll back to previous versions, etc.

As for the 2DA's being generated by the database, I'm pretty sure that was just when the game was in development. For all we know (I'm sure a Bio dev can straighten this out), it could have been generated from another DB somewhere at Bioware. Anyway, from here on out, we make our changes to the 2DA's directly (or through some 3rd party tool).

Hope this helps.

[Sidrat2009]

Thanks for the response Challseus, I'm going to stick with the database as all I'm looking for are lists and descriptions for the items, spell etc in the game. Should be easier to do with the database than on a 2da spreadsheet that apparently gets overwritten/updated each time, hopefully the database (especially as it's a backup in a different area from the game itself) will hold a static list of the base information.

[Challseus]

Sidrat2009 wrote...

Thanks for the response Challseus, I'm going to stick with the database as all I'm looking for are lists and descriptions for the items, spell etc in the game. Should be easier to do with the database than on a 2da spreadsheet that apparently gets overwritten/updated each time, hopefully the database (especially as it's a backup in a different area from the game itself) will hold a static list of the base information.

Just one more thing while I'm at it. If you don't find the item descriptions and whatnot in the DB, you can definitely find them in the talk tables. This little bit should interest you:

 For example, the lines of dialogue in [url=../../../wiki/datoolset/index.php/Conversation]conversations[/url] or the descriptions of [url=../../../wiki/datoolset/index.php/Item]items[/url] are automatically converted into talk table strings and stored there.

[Sidrat2009]

So far I've linked items with descriptions.



SELECT dbo_t_Item.BaseItemType, Items.ItemID, Items.[Item Name], Items.[Item Description]

FROM dbo_t_Item INNER JOIN Items ON dbo_t_Item.NameStringID = Items.ItemID

ORDER BY dbo_t_Item.BaseItemType, Items.ItemID;



This creates a list of items (some unnamed too?) that are sorted by BaseItemType and it's a start.



The next step would be to obtain the names of the attributes that items have, sadly I really can't find where those are stored.



I have experience using the database from Eve Online which was fun. Trying to sort and export for use in a standalone application that can be easily updated from excel sheets is a nightmare (I know I've done it before) hence my preference over using access to obtain the data.

[Sidrat2009]

 Just an update to the progress or lack of it so far.  I found a website that features an online item list fully searchable and I've linked it here www.gamebanshee.com/dragonageorigins/searchequipment.php 

Having spent the best part of a few hours trying to negotiate the structure of the database I've not come across any references to the statistics that are referenced in game i.e. Two handed weapon tier 1 Broadsword etc etc - plus due to the staggered release of Game banshee' online reference it may be that it was done by hand (yikes!).

Perhaps there's a small chance that I missed a table when importing the whole lot to access.  Perhaps the database was designed to use the field name as the reference all along hence the 2DA usage.  Who knows I'm certainly stumped with the design of it if anyone could confirm the status in regards to the item references I'd be most grateful.

For example there should be within the database the following information.

Item class/Type, Item Name, Item Description, Item Tier, Base Material Object, and that's just for starters, there should also be of course the enchantment listings and the base damage/protection amounts too.