[Tool] GD Stash

Grim Dawn Utilities and Resources
6633 
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                < ā€      ƮƆƄ< u                                                      =     2 0records/items/gearweapons/melee2h/d104_axe2h.dbr             tWā€“X                                          	Legendary    T             P  WeaponMelee_Axe2h    T  MYTHICAL DEATH'S REACH      7 5records/skills/itemskills/legendary/item_lifewave.dbr                                                   a=     ; 9records/items/upgraded/gearweapons/melee2h/d002_axe2h.dbr             akW                                          	Legendary    T             P  WeaponMelee_Axe2h    T  MYTHICAL GUILLOTINE      ; 9records/skills/itemskills/legendary/item_revelindeath.dbr                                                   =     4 2records/items/gearweapons/melee2h/d209_blunt2h.dbr             -iĀØā€ž                                          	Legendary    ^             s  WeaponMelee_Mace2h    ^  eSCION OF THE SCREAMING VEIL      8 6records/skills/itemskillsgdx2/legendary/veilripple.dbr  Life  Aether                                                   	=     4 2records/items/gearweapons/melee2h/d004_blunt2h.dbr             VŒ e                                          	Legendary    :             Ƙ  WeaponMelee_Mace2h    :  OBSIDIAN JUGGERNAUT      = ;records/skills/itemskills/legendary/item_obsidiantremor.dbr

Physical a Chaos
= 2 0records/items/gearweapons/melee2h/d105_axe2h.dbr gEĀ±Ć‹ Legendary ^ s WeaponMelee_Axe2h ^ $ "MYTHICAL GUARDIAN OF DEATHā€™S GATES @O Mrecords/skills/itemskillsgdx1/pets/item_petbonusd_guardianofdeathgates_02.dbr = 4 2records/items/gearweapons/melee2h/d108_blunt2h.dbr `Ā¦Ć” Legendary ^ s WeaponMelee_Mace2h ^ ) ā€˜records/items/lootsets/itemset_d102.dbr AVENGERā€™S CRUSHER 7 5records/skills/itemskillsgdx1/legendary/briarwave.dbr Lightning
Physical = a = ;records/items/upgraded/gearweapons/melee2h/d001_blunt2h.dbr |D} Legendary T P WeaponMelee_Mace2h T e MYTHICAL STONEFIST REBUKE 5 3records/skills/itemskills/legendary/item_rebuke.dbr
= = ;records/items/upgraded/gearweapons/melee2h/d003_sword2h.dbr aĆ„{% Legendary T P WeaponMelee_Sword2h T eMYTHICAL NIGHTSHADEā€™S REACH > <records/skills/itemskills/legendary/item_nightshadevenom.dbr = ; 9records/items/upgraded/gearweapons/melee2h/d010_axe2h.dbr Ƨ Legendary ^ s WeaponMelee_Axe2h ^ * (records/items/lootsets/itemset_d017b.dbr eMYTHICAL ULTOSā€™ STORMSEEKER < :records/skills/itemskills/legendary/item_lightningnova.dbr
Physical Lightning =
4 2records/items/gearweapons/melee2h/d204_sword2h.dbr
Ā¼ Legendary ^ s WeaponMelee_Sword2h ^ MYTHICAL NADAANā€™S REACH Fire Pierce = = ;records/items/upgraded/gearweapons/melee2h/d005_blunt2h.dbr ZĀVƇ Legendary ^ s WeaponMelee_Mace2h ^ eMYTHICAL INFERNAL BRIMSTONE : 8records/skills/itemskills/legendary/item_firerain_2h.dbr = 4 2records/items/gearweapons/melee2h/d203_sword2h.dbr Ʀ}d Legendary ^ s WeaponMelee_Sword2h ^ MYTHICAL DREEGALā€™ANORE
Physical Poison =
4 2records/items/gearweapons/melee2h/d106_sword2h.dbr 0ƝƎJ Legendary ^ s WeaponMelee_Sword2h ^ ) 'MYTHICAL ARCANOR, BLADE OF THE LUMINARI ? =records/skills/itemskillsgdx1/legendary/arcanedevastation.dbr = = ;records/items/upgraded/gearweapons/melee2h/d011_blunt2h.dbr ā€œ,L Legendary ^ s WeaponMelee_Mace2h ^ MYTHICAL LEVIATHAN 8 6records/skills/itemskills/legendary/item_greattide.dbr Cold
Physical = 6 4records/items/crafting/consumables/elixir_hunt01.dbr NCĆøƙ aMagical OneShot_Scroll ELIXIR OF THE HUNT @D Brecords/skills/itemskills/consumableskills/item_elixir_hunt_01.dbr

it shows the items,but i just cannot get them to show up in the stash transfer,even with clear and only selecting 2hand weapons with legendary
c4c1 is just gibberish with a lot of y
Edit:i restarted grim stash and i can now use character transfer,but stash transfer still doesnt work

6634

I meant attach the files, I donā€™t care whether they are gibberish :wink:

6635

Im a new user,so i cannot attach zips yet

Is there a way to save my stashed legendaries,if i reinstall grim stash?

6636

Reinstalling does not delete your database, for that you would need to manually delete C:\users\username\GDStash\db.

To export your items into a file, use

image
image.png1353Ɨ232 42.5 KB

To import them again after you wiped the DB, use ā€˜Load GD Stash fileā€™

I donā€™t think this will make any difference though.

6637

downloaded the newest version, imported my items and everything works

I have no idea what changed,if i had a faulty installation or messed up the settings,but it works perfectly now
Finally some stash space

6638

Hey @mamba,

Just noticed a weird behavior when trying to craft a Rime-Rotten Wand (it also happens with the Deathborne Scepter). Affixes for some Rare prefixes arenā€™t showing up in the dropbox such as the level 82 or level 92 options. Suffixes appear to work as normal, just not prefixes. Iā€™m using 1.52c and GD 1.1.7.2 with the most up-to-date database imported. Hereā€™s the screenshot showing the weird behavior:

image
image.png1920Ɨ1160 497 KB

Iā€™m not sure if this is prevented as an option with GD itself or just GDStash.

6639

This question has already come up a few times in different constallations. In general, if you do not find an affix in GD Stash, then that means the affix is not available for the item in GD.

This is true here as well. The weapon uses tdyn_craft_caster1h_b106.dbr, the Frostborn affix is in prefixb01_weapon_castercold_02.dbr

rarePrefixTableName2,records/items/lootaffixes/prefix/prefixtables/prefixb01_weapon_castercold_02.dbr,

but only for

randomizerName6,records/items/lootaffixes/prefix/b_wpn013_melee1h_a.dbr,
randomizerName7,records/items/lootaffixes/prefix/b_wpn013_melee1h_b.dbr,
randomizerName8,records/items/lootaffixes/prefix/b_wpn013_melee1h_c.dbr,
randomizerName9,records/items/lootaffixes/prefix/b_wpn013_melee1h_d.dbr,
randomizerName10,records/items/lootaffixes/prefix/b_wpn013_melee1h_e.dbr,

The higher level versions of the affix (f and g) are not included.

6640

Thanks for that info @mamba - I appreciate it greatly! However, it doesnā€™t make sense to me since the Deathborne Scepter is a level 90 crafted item and the Rime-Rotten Wand is a level 92 craft. Why would they not have access to the highest level prefixes? :face_with_raised_eyebrow:

@Zantai, is this just missing from prefixb01_weapon_castercold_02.dbr or is this working as intended? :thinking:

6641

You know, a bug report is a better way to get my attention. :wink:

This affects all crafted caster weapons and will be addressed in v1.1.8.0.

1 Like
6642

Thanks Z, sorry about that - Iā€™ll do correctly next time. Keep up the great work! :sunglasses:

6643

Hello, after getting back into GD after a break I noticed my stash appears to be broken. I get the following error messages on bootup:

Error reading ID in table GD_AFFIX
Column ā€˜21ā€™ not found. java.sql.SQLException: Column ā€˜21ā€™ not found. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)

Followed by similar messages.

When trying to import the stash I get these messages:

Error creating GD_ITEM table
The conglomerate (7,792) requested does not exist.

Can anyone advise on what might be the issue?

6644

Have you updated to the latest version of the game and the stash and re-imported the database again?

6645

Yes, the game is up to date and I downloaded the newest version of GDstash to see if it would solve the issue. Same errors before and after.

6646

sounds like you have an old DB while the GD Stash you use has more data / fields in the table.

Import the GD data on the Config page to update to the current DB

weird that you would have the affix table but not the item table. They both should be created at the same time.
In any case, same fix as before, ie import the GD data on the Config page

6647

Apologies, I am a little confused. The error posted here:

Error creating GD_ITEM table
The conglomerate (7,792) requested does not exist.

is what happens when I try to ā€œimport databaseā€. Is importing GD data different?

Again, apologies for my lack of literacy in regards to the general workings of the program.

6648

You said you get that error when importing the stash, which is not the same as the GD data to me.

GD data and database are the same thing. I am talking about the last button on the Config page.

If you got that error from it, that would be very weird, as the import should create that table, so it not existing should not result in errors (while it not existing definitely is an issue when you want to display your stash)

6649

Yep, this is the error from hitting the bottom button ā€œimport databaseā€. The full text is:

Error creating GD_ITEM table

The conglomerate (7,792) requested does not exist.
java.sql.SQLException: The conglomerate (7,792) requested does not exist.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)

ā€¦and it continues like that.

Thank you for taking the time to assist me with this by the way.

6650

Weird, do you have any collected items ?

If so, rename c:\users\username\GDStash\db to e.g. _db and then import again.

Once the DB is set up correctly, we can then figure out how to get your items back :wink:

If you did not collect any items, simply delete the db dir and import again.

6651

Yes, I had probably a few hundred collected items I think,

Changing the folder name allowed me to import database. I can now see my shared stash, but I did a search and I have none of my collected items.

6652

That was to be expected, as they are in _db :wink:

So the question now is how comfortable you are with computers. The easiest way to figure out which files from _db you need would be to install SQuirreL and then run a query on _db.

Make sure you have the Apache Embedded driver installed, select it, set up a connection to jdbc:derby:C:\Users\username\GDStash_db;create=false and run a query (I can provide the query) to figure out which files contain your items.

EDIT the path is C:\ Users \ username \ GDStash \ _db not sure why it seems to swallow the \ before _db

EDIT2:

If you rather take a shot in the dark, search for c4b0.dat and c4c1.dat in c:\users\username\GDStash_db\seg0 but that would depend on which version you used before. So open c4b0.dat with a Hex Editor or a Text Editor and see if it looks anything like this

Hex-Editor:

image
image.png763Ɨ618 26.8 KB

Text editor

image
image.png1407Ɨ270 13.3 KB

Provided you find it at allā€¦

If you find it and it looks similar, copy them over to db\seg0 and import the GD data again (this is needed as by now the items are no longer stored in this table, and the update will transfer them to the current table)