d2jsp
Log InRegister
d2jsp Forums > Off-Topic > Computers & IT > Programming & Development > Diablo 2 Item Inventory Manager
Add Reply New Topic New Poll
Member
Posts: 6,988
Joined: Apr 16 2019
Gold: 50.00
May 19 2019 04:19pm
Just wanted a clean way of managing my FT items ect.. so I designed this.

Works off of MySQL + VBNET

Add Item: The Item Name box is automatically populated with items already in your inventory, when you go to type it in it will auto-fill suggestions. IE: typing "Sh" will bring up "Shako" ect. ect.

Search By: List automatically filters by the name of items.

Quickly find what items you have + where you have it.

Export the entire list to create a neat FT topic in one click to your clipboard. (Example below image, exactly how it comes out)

If there's any interest I can share this but you will need to have access to a MySQL server (You can host a free one on your own PC!)

But just wanted to share my work with you guys :)



Code

-- Gloves --

Magefist - 30ED - 1
Bloodfist - 20ED - 2
Drac's - 8LS/116ED/10Str/5LAEK - 1
Drac's - 9LS/100ED/12Str/9LAEK - 1
Drac's - 7LS/117ED/14Str/5LAEK - 1
Drac's - 8/101/14/6 - 1
Drac's - 8/111/13/9 - 1
Bloodfist - 20ED - 1
Bloodfist - Perfect - 1
Java Gloves - +3 / 20IAS - 1

-- Boots --

Gore's - 177ED - 1
Waterwalk's - 193ED / 59Life - 1
Waterwalk's - 207/63 - 1
Trek's - Eth - 161/15/12/69 - 1
Trek's - 170/14/14/41 - 1

-- Helms --

Shako - 130 Def - 1
Griffon's - Unid - NA - 1
Griffon's - Unid - NA - 1
Crown of Thieves - 9/196/100GF - 1
IK Helm - Perfect - 1

-- Belts --

Dungo's - 125/37/12/106/12 - 1
Dungo's - 100/39/13/120/15 - 1

-- Armor --

Eth GBane's - 185ED/18DR/16MDR - Total Def: 2,110 - 1
Eth Crow Caw - Perfect - Total Def: 800 - 1
Ormus - 11 Cold / 15 Light / 10 Fire / +3 Nova / 19Def / 13 Regen - 1

-- Shields --

Stormshield - Unid 147 Def - 1
Stormshield - Unid 143 Def - 1
Stormshield - Unid 146 Def - 1
Stormshield - Unid 142 Def - 1

-- Weapons --

Eth Suicide Branch - NA - 1
Bartuc's - Perfect - 1
Up'd Eth Titan's - 200ED / 5LS - 1
Fathom - Unid - 1

-- Amulets --

Highlord's - Cross GFX - 1

-- Rings --

Raven - 242/20 - ETurn - 1
Raven - 240ATR / 20Dex - ETurn - 1
Raven - 225ATR / 20Dex - Chain GFX - 1
Raven - 201ATR / 20Dex - ETurn GFX - 1
Raven - 208/20 - Sloop GFX - 1

-- Grand Charms --

Mentalist's GC - +1 Shadow / 32Life - 1
Lion GC - +1 Combat / 7Life - Eye GFX - 1
Serpent's GC of Balance - 12FHR / 46 Mana - Eye GFX - 1
Entrapping GC - +1 Traps / 30Life - Monster GFX - 1
Burning GC - +1 Fire / 39Life - DNA GFX - 1
Lion GC - +1 Combat / 1-2 Fire Dmg - Eye GFX - 1
Harpoonist's GC - +1 Java / 36 Life - Eye GFX - 1
Harpoonist's GC - +1 Java / 33 Life - Monster GFX - 2
Harpoonist's GC - +1 Java / 35 Life - Eye GFX - 1
Fletcher's GC - +1 Bow / 38 Life - DNA GFX - 1
Harpoonist's GC - +1 Java / 35 Life - DNA GFX - 1
Harpoonist's GC - +1 Java / 39 Life - Eye GFX - 1
Fletcher's GC - +1 Bow / 39 Life - DNA GFX - 1
Fletcher's GC - +1 Bow / 38 Life - Monster GFX - 1
Fletcher's GC - +1 Bow / 44 Life - Monster GFX - 1
Fletcher's GC - +1 Bow / 41 Life - Eye GFX - 1
Gheed's - 100/35/14 - Eye GFX - 1

-- Small Charms --

Serpent's Small Charm of Balance - 5FHR / 17Mana - Football GFX - 1
Shimmering SC - @5 - Paw GFX - 1
Toxic Charm of Inertia - 3FRW / 100Psn Per 5 - Coin GFX - 2
Shimmering SC - @5 - Football GFX - 2
Sapphire SC of Balance - 5FHR / @11 Cold - Football GFX - 1
Steel SC of Greed - 32ATR / 10GF - Coin GFX - 1
Steel SC of Inertia - 3FRW / 36ATR - Coin GFX - 2
Serpent's SC of Inertia - 3FRW / 17Mana - Paw GFX - 1
Serpent's SC of Intertia - 3FRW / 17Mana - Football GFX - 1
Steel SC of Inertia - 3FRW / 36ATR - Football GFX - 1
Serpent's SC of Inertia - 3FRW / 17Mana - Coin GFX - 1

-- Jewels --

Facet - PSN - 5/5 Level - Pink - 1
Facet - Light - 5/5 Level - Green - 1
Facet - Fire - 5/5 Die - Green - 1
Facet - Cold - 5/5 Die - Peach - 1
Facet - Cold - 5/5 Level - Peach - 1
Facet - Fire - 5/5 Fire Die - Peach - 2
Facet - Light - 5/5 Level - Pink - 1

-- Bases / Whites --

Eth SA - No Stats / No OS - 1
Eth SA - 850 Def - No Stats / No OS - 1
Superior Broad Sword - 15ED / 3ATR - 1
Eth AP - 741 Def - No Stats / No OS - 1
Superior Stag Bow - +3 / 15ED / 3ATR - 1
Superior Monarch - 15ED - No OS - 1
Eth CV - No Stats / 4OS - 1
Superior Mage Plate - 15ED / 3OS - 1

-- Rares --

Skull Visage - 5% Lvl 3 Frost Nova / 2 Barb / 2 Grim Ward / 3 BO / 9Energy / 10Life / @28 Psn - 1
Doom Knuckle - +2 Jav / 20IAS / 91ED / 15Str / 11Dex - 1
Bitter Brow +5 Nado - Spirit Mask - +2 / +3 Nado / 27EDef / 8Energy / 7Life / @9 Fire - No OS - Green - 1




This post was edited by 3oDAtlas on May 19 2019 04:20pm
Member
Posts: 12,703
Joined: May 17 2013
Gold: 12,935.00
May 20 2019 12:37am
Why not just use SQlite? It makes it a lot more lightweight.

Also, you should probably have contacted a mod before posting this. I posted about something similar several years ago, and got suspended.
They don't really think about whether programs directly interface with d2 or not.

This post was edited by Klexmoo on May 20 2019 12:40am
Member
Posts: 6,988
Joined: Apr 16 2019
Gold: 50.00
May 20 2019 05:17am
Quote (Klexmoo @ May 20 2019 02:37am)
Why not just use SQlite? It makes it a lot more lightweight.

Also, you should probably have contacted a mod before posting this. I posted about something similar several years ago, and got suspended.
They don't really think about whether programs directly interface with d2 or not.


Eh, I already have a webserver on Godaddy for some work software, so I just used that for it :D

Well we'll see if they yell at me haha. But thanks for the warning :D
Member
Posts: 56,877
Joined: Jan 31 2008
Gold: 241,490.90
May 20 2019 03:12pm
Quote (3oDAtlas @ May 20 2019 03:17am)
Eh, I already have a webserver on Godaddy for some work software, so I just used that for it :D

Well we'll see if they yell at me haha. But thanks for the warning :D


This is really neat.
Member
Posts: 6,988
Joined: Apr 16 2019
Gold: 50.00
May 21 2019 06:06pm
Quote (Linux @ May 20 2019 05:12pm)
This is really neat.


Thanks :D

I think it came out quite nicely for what I needed and how little time I spent on it lol

Member
Posts: 6,988
Joined: Apr 16 2019
Gold: 50.00
May 23 2019 07:43am
Made a couple changes.

Added in a section to put cost when adding an item, showing it in the list and then to export accordingly.



Code
-- Gloves --

Drac's - 10/101/10/7 - 1x - 3FG per
Bloodfist - 20ED - 2x - 2FG per
Drac's - 8LS/116ED/10Str/5LAEK - 1x - 3FG per
Drac's - 9LS/100ED/12Str/9LAEK - 1x - 3FG per
Drac's - 7LS/117ED/14Str/5LAEK - 1x - 3FG per
Drac's - 8/101/14/6 - 1x - 3FG per
Drac's - 8/111/13/9 - 1x - 3FG per
Bloodfist - 20ED - 1x - 2FG per
Bloodfist - Perfect - 1x - 2FG per
Java Gloves - +3 / 20IAS - 1x - 20FG per
Drac's - 7/113/11/5 - 1x - 3FG per
Laying of Hands - NA - 1x - 2FG per
Drac's - 9/105/13/5 - 1x - 3FG per
Drac's - 7/105/10/6 - 1x - 3FG per
Drac's - 9/111/15/7 - 1x - 3FG per

-- Boots --

Gore's - 177ED - 1 - 3FG perx
Waterwalk's - 193ED / 59Life - 1 - 3FG perx
Trav's - 172/8/46 - 1 - 5FG perx
Waterwalk's - 207/63 - 1 - 5FG perx
Waterwalk's - 204/63 - 1 - 5FG perx
Waterwalk's - 206/57 - 1 - 3FG perx
Trek's - Eth - 161/15/12/69 - 1 - 5FG perx
Trav's - 171/9/48 - 1 - 5FG perx
Waterwalk's - 206/63 - 1 - 5FG perx
Waterwalk's - 187/57 - 1 - 3FG perx
Trav's - 181/9/47 - 1 - 5FG perx

-- Helms --

Shako - 130 Def - 1x - 2FG per
Crown of Thieves - 9/196/100GF - 1x - Offer per
IK Helm - Perfect - 1x - 3FG per
Priest's Coronet of the Magus - +2 Pally / 20FCR - No OS - 1x - Offer per

-- Belts --

Dungo's - 125/37/12/106/12 - 1x - 5FG per
Dungo's - 100/39/13/120/15 - 1x - 10FG per
Dungo's - 92/39/13/112/12 - 1x - 3FG per
Arach's - 117ED - 1x - 5FG per

-- Armor --

Eth GBane's - 185ED/18DR/16MDR - Total Def: 2,110 - 1x - Offer per
Eth Crow Caw - Perfect - Total Def: 800 - 1x - 20FG per
Ormus - 11 Cold / 15 Light / 10 Fire / +3 Nova / 19Def / 13 Regen - 1x - 5FG per

-- Shields --

Stormshield - Unid 147 Def - 1x - 3FG per
Stormshield - Unid 143 Def - 1x - 2FG per
Stormshield - Unid 146 Def - 1x - 3FG per
Stormshield - Unid 142 Def - 1x - 2FG per

-- Weapons --

Eth Suicide Branch - NA - 1x - 5FG per
Bartuc's - Perfect - 1x - 5FG per
Death's Web - Unid - 1x - Offer per

-- Amulets --

Highlord's - Cross GFX - 1x - 5FG per
Cat's Eye - NA - 1x - 2FG per

-- Rings --

Raven - 242/20 - ETurn - 1x - 5FG per
Raven - 240ATR / 20Dex - ETurn - 1x - 5FG per
Raven - 225ATR / 20Dex - Chain GFX - 1x - 4FG per
Raven - 201ATR / 20Dex - ETurn GFX - 1x - 3FG per
Raven - 208/20 - Sloop GFX - 1x - 3FG per
Raven - 208/20 - Sloop GFX - 1x - 3FG per
Raven - 240/20 - ETurn GFX - 1x - 5FG per
Raven - 244/20 - Orange GFX - 1x - 5FG per

-- Grand Charms --

Mentalist's GC - +1 Shadow / 32Life - 1x - Offer per
Lion GC - +1 Combat / 7Life - Eye GFX - 1x - 3FG per
Serpent's GC of Balance - 12FHR / 46 Mana - Eye GFX - 1x - Offer per
Entrapping GC - +1 Traps / 30Life - Monster GFX - 1x - Offer per
Burning GC - +1 Fire / 39Life - DNA GFX - 1x - Offer per
Lion GC - +1 Combat / 1-2 Fire Dmg - Eye GFX - 1x - 2FG per
Harpoonist's GC - +1 Java / 36 Life - Eye GFX - 1x - Offer per
Harpoonist's GC - +1 Java / 33 Life - Monster GFX - 2x - Offer per
Harpoonist's GC - +1 Java / 35 Life - Eye GFX - 1x - Offer per
Fletcher's GC - +1 Bow / 38 Life - DNA GFX - 1x - Offer per
Harpoonist's GC - +1 Java / 35 Life - DNA GFX - 1x - Offer per
Harpoonist's GC - +1 Java / 39 Life - Eye GFX - 1x - Offer per
Fletcher's GC - +1 Bow / 39 Life - DNA GFX - 1x - Offer per
Fletcher's GC - +1 Bow / 38 Life - Monster GFX - 1x - Offer per
Fletcher's GC - +1 Bow / 44 Life - Monster GFX - 1x - Offer per
Fletcher's GC - +1 Bow / 41 Life - Eye GFX - 1x - Offer per
Gheed's - 100/35/14 - Eye GFX - 1x - 5FG per
Harpoonist's GC - +1 Java / 36 Life - Eye GFX - 1x - Offer per
Serpent's GC of Inertia - 7FRW / 46 Mana - Monster GFX - 1x - Offer per

-- Small Charms --

Shimmering SC - @5 - Paw GFX - 1x - 5FG per
Toxic Charm of Inertia - 3FRW / 100Psn Per 5 - Coin GFX - 2x - 10FG per
Shimmering SC - @5 - Football GFX - 2x - 5FG per
Sapphire SC of Balance - 5FHR / @11 Cold - Football GFX - 1x - Offer per
Steel SC of Greed - 32ATR / 10GF - Coin GFX - 1x - 10FG per
Steel SC of Inertia - 3FRW / 36ATR - Coin GFX - 2x - Offer per
Serpent's SC of Inertia - 3FRW / 17Mana - Paw GFX - 1x - Offer per
Serpent's SC of Intertia - 3FRW / 17Mana - Football GFX - 1x - Offer per
Steel SC of Inertia - 3FRW / 36ATR - Football GFX - 1x - Offer per
Serpent's SC of Inertia - 3FRW / 17Mana - Coin GFX - 1x - Offer per
Amber SC of Balance - 5FHR / @11 Light - Coin GFX - 1x - Offer per
Coral SC of Intertia - 3FRW / @9 Light - Paw GFX - 1x - 5FG per
Steel SC of Greed - 10GF / 35ATR - Football GFX - 1x - 10FG per

-- Jewels --

Facet - PSN - 5/5 Level - Pink - 1x - 10FG per
Facet - Fire - 5/5 Die - Green - 1x - 20FG per
Facet - Fire - 5/5 Fire Die - Peach - 2x - 20FG per
Facet - PSN - 5/5 Die - Peach - 1x - 15FG per

-- Bases / Whites --

Eth SA - 760 Def / No Stats / No OS - 1x - 3FG per
Eth SA - 850 Def - No Stats / No OS - 1x - Offer per
Superior Broad Sword - 15ED / 3ATR - 1x - Offer per
Eth AP - 741 Def - No Stats / No OS - 1x - Offer per
Superior Stag Bow - +3 / 15ED / 3ATR - 1x - Offer per
Superior Monarch - 15ED - No OS - 1x - Offer per
Eth CV - No Stats / 4OS - 1x - Offer per
Superior Mage Plate - 15ED / 3OS - 1x - Offer per
Eth CV - No Stats / No OS - 1x - Offer per
Gnarled Staff - +2 Chilling / +3 ES / +1 Meteor - No OS - 1x - 25FG per
Eth SA - 841 Def - No Stats / No OS - 1x - Offer per

-- Runewords --

Eth Treachery - Eth SA - Total Def: 1,095 - 1x - 20FG per
Chains of Honor - GP - 15ED Base - 1x - Offer per
Phoenix - Monarch 15ED Base - 12Red / 381ED / 378 DvM / 15Sorb - 1x - Offer per

-- Rares --

Skull Visage - 5% Lvl 3 Frost Nova / 2 Barb / 2 Grim Ward / 3 BO / 9Energy / 10Life / @28 Psn - 1x - Offer per
Doom Knuckle - +2 Jav / 20IAS / 91ED / 15Str / 11Dex - 1x - Offer per
Bitter Brow +5 Nado - Spirit Mask - +2 / +3 Nado / 27EDef / 8Energy / 7Life / @9 Fire - No OS - Green - 1x - Offer per
Cruel Edge - 447ED / 2Min / 206ATR / 9LS / 11Str / Eth - 1x - Offer per
Bitter Horn - +2 Barb / X Bonus To ATR (Lvl) / +1 Nat Resist / 62EDef / 8Life / Repairs 1:20 Secs - No OS - White - 1x - Offer per
Viper Grasp - 10FCR / 82ATR / 20Str / 14Energy / 5Mana / @30 FRes - Chain GFX - 1x - Offer per


This post was edited by 3oDAtlas on May 23 2019 07:45am
Member
Posts: 6,988
Joined: Apr 16 2019
Gold: 50.00
May 29 2019 02:57pm
Got to thinking about it as well..

if anyone wants to for now, I would be willing to host the table for you and we could create a kind of 24/7 store like this in a way.

You can select a specific persons inventory and see what all they have FT and also have a master list with all items where you can search for an item and anyone who has it you can see theirs + prices to find the best deal :D

LMK if anyone is interested, would be a neat little project to take on, and the best part is I really don't have to re-write anything, just have to do some filtering :)
Member
Posts: 6,988
Joined: Apr 16 2019
Gold: 50.00
Jun 17 2019 05:13pm
Added in the ability to switch between Databases.

So I can keep track of my Non-ladder and Ladder items :D



This post was edited by 3oDAtlas on Jun 17 2019 05:13pm
Go Back To Programming & Development Topic List
Add Reply New Topic New Poll