Login | Register


All times are UTC - 5 hours


It is currently Thu Mar 28, 2024 6:33 am




Post new topic Reply to topic  [ 29 posts ] 
Author Message
 Post subject: Database Status
PostPosted: Wed Jan 14, 2015 3:24 am 
User avatar

Joined: Tue May 25, 2010 12:33 pm
Posts: 1175
Location: Knoxville, TN
Runewords 100% Done
Vanilla Uniques - 100%
Expansion Uniques - 2%
Sets - 0%

Just a progress tracker for anyone interested as I go through and clean up a bit.

_________________
PureRage-DoD wrote:
Ze dictatorship hast simply changed hands ya?
Let us crunch ze numbers


Last edited by LockDown on Mon Jan 19, 2015 10:04 pm, edited 4 times in total.

Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Wed Jan 14, 2015 9:49 am 
User avatar

Joined: Sun Jul 27, 2014 11:52 pm
Posts: 81
Thank you for updating this. :)


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Wed Jan 14, 2015 11:49 am 

Joined: Mon Nov 23, 2009 2:09 am
Posts: 736
This is awesome, very appreciated!


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Thu Jan 15, 2015 1:20 am 
User avatar

Joined: Tue May 25, 2010 12:33 pm
Posts: 1175
Location: Knoxville, TN
I use it just as much as anyone so no problem. Gonna update some more tomorrow while I do laundry.

_________________
PureRage-DoD wrote:
Ze dictatorship hast simply changed hands ya?
Let us crunch ze numbers


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Thu Jan 15, 2015 11:53 am 

Joined: Sun May 02, 2010 8:51 pm
Posts: 192
nice one coty :)

_________________
Trolling LockDown since 14/01/2012.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Thu Jan 15, 2015 1:19 pm 

Joined: Sun Oct 27, 2013 5:12 am
Posts: 204
yes thanks a lot. already been using the rw section a lot. great work


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Thu Jan 15, 2015 2:43 pm 
User avatar

Joined: Tue May 25, 2010 12:33 pm
Posts: 1175
Location: Knoxville, TN
The only section I forsee problems with is sets. I didn't do sets originally and Dew had a way to export the data from the file to the site for sets at least. Still waiting to hear back from him.

_________________
PureRage-DoD wrote:
Ze dictatorship hast simply changed hands ya?
Let us crunch ze numbers


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Thu Jan 15, 2015 2:44 pm 

Joined: Mon Aug 31, 2009 7:13 pm
Posts: 112
Can someone post a link? Or is it the like hudb in the stickies? I really appreciate you doing this too. I use them all the time!


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Thu Jan 15, 2015 2:46 pm 
User avatar

Joined: Wed Sep 09, 2009 10:06 am
Posts: 1206
http://hudb.arimyth.com/

_________________
LockDown wrote:
Go outside.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Thu Jan 15, 2015 10:06 pm 
User avatar

Joined: Tue May 25, 2010 12:33 pm
Posts: 1175
Location: Knoxville, TN
All Classic D2 Unique Items Done (Most starter uniques) Going to start the Expansion and Mod Original next time I have a free moment.

_________________
PureRage-DoD wrote:
Ze dictatorship hast simply changed hands ya?
Let us crunch ze numbers


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Sat Jan 17, 2015 10:41 am 

Joined: Wed Dec 12, 2012 7:24 pm
Posts: 1031
I really appreciate this, hopefully it all gets updated. :)


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Sun Jan 18, 2015 7:22 am 
User avatar

Joined: Tue May 25, 2010 12:33 pm
Posts: 1175
Location: Knoxville, TN
Ensley03 wrote:
I really appreciate this, hopefully it all gets updated. :)


My weekend is Wednesday Thursday. So I'll be doing some more then.

_________________
PureRage-DoD wrote:
Ze dictatorship hast simply changed hands ya?
Let us crunch ze numbers


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Fri Jan 23, 2015 9:25 am 

Joined: Mon Nov 23, 2009 2:09 am
Posts: 736
Any progress on this (just curious is all)?

Also if not completed, is there a way that the community can pitch in to help? If we were able to split up the work amongst several people, would be able to get it done quicker and also not have to put a lot of work on one person.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Sat Jan 24, 2015 2:26 pm 
User avatar

Joined: Tue May 25, 2010 12:33 pm
Posts: 1175
Location: Knoxville, TN
The best help I could get is if other people would go through and write down the stats of the items and post them in a thread so I can just copy paste it over. Right now I have to go into notepad read the item stats then translate it into terms that we actually use and not ac 200% which would be 200% Enhanced Defense.

I work full time and have a 13 month old so my free time is very limited. If you want me to e-mail you the file so you can type some items out just PM me your e-mail and I'd get back to you asap. I'd just add you to the site but I think only Dew can do that.

_________________
PureRage-DoD wrote:
Ze dictatorship hast simply changed hands ya?
Let us crunch ze numbers


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Sat Jan 24, 2015 8:38 pm 

Joined: Mon Aug 31, 2009 7:13 pm
Posts: 112
LockDown wrote:
The best help I could get is if other people would go through and write down the stats of the items and post them in a thread so I can just copy paste it over. Right now I have to go into notepad read the item stats then translate it into terms that we actually use and not ac 200% which would be 200% Enhanced Defense.

I work full time and have a 13 month old so my free time is very limited. If you want me to e-mail you the file so you can type some items out just PM me your e-mail and I'd get back to you asap. I'd just add you to the site but I think only Dew can do that.

Would it be possible to set the file up as a google doc or something so everyone could contribute to it?


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Sat Jan 24, 2015 11:27 pm 
User avatar

Joined: Tue May 25, 2010 12:33 pm
Posts: 1175
Location: Knoxville, TN
Very possible

Go to this link. Every item you "decode" for lack of better terms just post in a comment and I'd edit it in I'll check it daily.

https://docs.google.com/document/d/1YJ0 ... sp=sharing

Also obviously item stats start after the item type. It's 66 pages. Down from 100 or so so I did make some solo progress :D

_________________
PureRage-DoD wrote:
Ze dictatorship hast simply changed hands ya?
Let us crunch ze numbers


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Sun Jan 25, 2015 12:23 am 
User avatar

Joined: Tue May 25, 2010 12:33 pm
Posts: 1175
Location: Knoxville, TN
Also check to make sure someone hasn't done the item yet. I will update as I put them on the site but I can't be at it 24/7.

_________________
PureRage-DoD wrote:
Ze dictatorship hast simply changed hands ya?
Let us crunch ze numbers


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Sun Jan 25, 2015 7:08 pm 
User avatar

Joined: Tue May 25, 2010 12:33 pm
Posts: 1175
Location: Knoxville, TN
https://docs.google.com/document/d/1XgC ... sp=sharing

New share link. Didn't let anyone edit it.

_________________
PureRage-DoD wrote:
Ze dictatorship hast simply changed hands ya?
Let us crunch ze numbers


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Mon Jan 26, 2015 2:36 am 
User avatar

Joined: Tue May 25, 2010 12:33 pm
Posts: 1175
Location: Knoxville, TN
Will do exceptional items tomorrow after work. I've set aside time for it. After that it will be class specific jewelry and elite items.

_________________
PureRage-DoD wrote:
Ze dictatorship hast simply changed hands ya?
Let us crunch ze numbers


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Tue Jan 27, 2015 2:28 pm 
User avatar

Joined: Fri Feb 25, 2011 7:44 am
Posts: 96
Would like to help a bit, however after trying to understand walls of text, and different values, I have no idea how to decipher this... Would it be possible to view this with some d2 excel tool or mpq viewer in a more easier to understand form?


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Wed Jan 28, 2015 4:44 am 
User avatar

Joined: Tue May 25, 2010 12:33 pm
Posts: 1175
Location: Knoxville, TN
I can give a sort of glossary.

AC = Def
AC% = Ed
Hit2 = Faster Attack Rate
Damage % = Enhanced Damage

if you have specific ones you don't understand just let me know. If you copy it into excel it should work.

_________________
PureRage-DoD wrote:
Ze dictatorship hast simply changed hands ya?
Let us crunch ze numbers


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Wed Jan 28, 2015 7:37 pm 
User avatar

Joined: Tue Sep 01, 2009 9:01 pm
Posts: 1413
master code list
http://d2mods.info/resources/mcml-v110.php

link to a page with other important things you may want
http://d2mods.info/index.php?ind=review ... ew&idev=21

_________________
The reader should not be discouraged if...he does not have the prerequisites to read the prerequisites. P. Halmos


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Thu Jan 29, 2015 12:12 am 
User avatar

Joined: Tue May 25, 2010 12:33 pm
Posts: 1175
Location: Knoxville, TN
kramuti wrote:
master code list
http://d2mods.info/resources/mcml-v110.php

link to a page with other important things you may want
http://d2mods.info/index.php?ind=review ... ew&idev=21


Would've been so useful when I started had to figure it all out by braille lol

_________________
PureRage-DoD wrote:
Ze dictatorship hast simply changed hands ya?
Let us crunch ze numbers


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Sun Feb 01, 2015 7:09 pm 
User avatar

Joined: Tue May 25, 2010 12:33 pm
Posts: 1175
Location: Knoxville, TN
78 Pages left down from 90. Sorry for the snails pace of this.

_________________
PureRage-DoD wrote:
Ze dictatorship hast simply changed hands ya?
Let us crunch ze numbers


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Mon Feb 02, 2015 5:28 am 
User avatar

Joined: Fri Feb 25, 2011 7:44 am
Posts: 96
I started from the bottom of the page, hope nobody done this already.
Arrows and bolts :

Bolts


Sparkles
Bolts

Required Lvl: 10

+1 to Amazon Skills
adds 30-60 Fire Damage
adds 30-50 Cold Damage
+ 10% Pierce
+ 5 to Minimum & Maximum Damage
5% Mana stolen
Replenish Quantity


Ground Quiver
Bolts

Required Lvl: 40

Knockback
+ 50 to Mana
+ 15 to Minimum & Maximum Damage
+ 10 to Dexterity
+ 15% attack speed
5% life stolen
Replenish Quantity


Iron Tip
Bolts

Required Lvl: 70

+ 1 to Amazon Skills
+ 20-25 to Dexterity
+ 25 to Minimum & Maximum Damage
+ 20% attack speed
+ 10-15 to Vitality
25 HP gained after every kill
Replenish Quantity


Field Quiver
Bolts

Required Lvl: 95

LvL 5 Fanaticism Aura When equipped
+ 40 to Minimum & Maximum Damage
+ 180-200 to Health
+ 15% to Resist All
8% life stolen
+ 10-15% pierce
Replenish Quantity


Last edited by Zen1337 on Mon Feb 02, 2015 8:05 am, edited 5 times in total.

Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Mon Feb 02, 2015 5:29 am 
User avatar

Joined: Fri Feb 25, 2011 7:44 am
Posts: 96
Arrows

Leather Quiver
Arrows

Required Lvl: 10

+ 15-20% run/walk speed
+ 5% to Resist All
5- 10% Mana stolen
+ 8-10 to Dexterity
Replenish Quantity


Marksman's Quiver
Arrows

Required Lvl: 40

+ 1 to Amazon Skills
+ X to Maximum damage (Based on Clvl)
+ 10-15% Pierce
+ 10-15 to Dexterity
Replenish Quantity


Archer's Quiver
Arrows

Required Lvl: 70

+ 1 To Amazon Skills
Cannot be Frozen
+ 20-25 to Dexterity
- 5% to Enemy Fire Resistance
- 5% to Enemy Cold Resistance
- 5% to enemy Magic Resistance
Replenish Quantity


Maiden's Quiver
Arrows

Required Lvl: 95

LvL 1 Sanctuary Aura When equipped
+ 180-200 to Mana
+ 90-100 to Health
+ 10-15% Pierce
+ 30% run/walk speed
+ 10-25 to Minimum & Maximum damage
Replenish Quantity


Last edited by Zen1337 on Mon Feb 02, 2015 8:04 am, edited 1 time in total.

Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Mon Feb 02, 2015 8:02 am 
User avatar

Joined: Fri Feb 25, 2011 7:44 am
Posts: 96
Just tell me if this is correct, and are you happy with this format.

Next bit done. Going as follows from the bottom.

Oddyssey
Siege Boots

Defense:37-66
Required Lvl :55
Required Strength:88

+ 250-300% Enhanced Defense
+ 50% run/walk speed
3% Chance of Crushing Blow
+ 10 to Strength
15% Deadly Strike
20% chance to cause open wounds
Reduces Damage Taken by 15
Cannot be Frozen


Ring of Engagement
Ring

Required Lvl:75

+ 300-400 Defense
+ 14-18 to Strength
Damage Reduced by 6-8%
+ 300-400 to Attack Rating
8-12% Deadly Strike


Ring of Truth
Ring

Required Lvl:60

+ 200-250 to Health
+ 12-15% to Resist All
Damage Reduced by 4%
+ 150-200 to Attack Rating


Ring of Regna
Ring

Required Lvl:35

+ 150-200 to Mana
+ 80-160 to Health
+ 30% cast speed
Resist Magic 10%


Empyrean Band
Ring

Required Lvl:30

+ 8-12 to All stats
+ 120-160 to Attack Rating
Magic Damage Reduced by 8-12
+ 15-25% hit recovery speed


Gnarled Root
Ring

Required Lvl:95

+ 25-30 to Minimum Damage
+ 50-60 to Maximum Damage
+ 20-30 to Dexterity
+ 30% attack speed
6-8% Life Stolen
6-8% Mana Stolen


Optic Amulet
Amulet

Required Lvl:18

+ 30-40% to Resist Lightning
Reduces Damage Taken by 8-12
+ 150-200 to Mana
+ 10 to Light Radius
+ 40-50% to Mana Regeneration
+ 20-25% cast speed


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Tue Feb 03, 2015 5:35 pm 
User avatar

Joined: Tue May 25, 2010 12:33 pm
Posts: 1175
Location: Knoxville, TN
Looks great man. I'll put it on site now.

_________________
PureRage-DoD wrote:
Ze dictatorship hast simply changed hands ya?
Let us crunch ze numbers


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Database Status
PostPosted: Sat Feb 07, 2015 5:35 am 

Joined: Sat Jan 02, 2010 1:36 am
Posts: 971
Gnarled root = http://gyazo.com/dcacd31da21f91619fc2d9ead46bf39c

Ring of Regha = http://gyazo.com/d9ac7f965dd53b516d734edd4a56eb05

Ring of Truth = http://gyazo.com/56e6424252067e331ba7a185e72f0968

I had all the rings but *mati stole half of them. Found some on a friend's mule:

Empyrean band = http://gyazo.com/af922a9181c3a27ab0ace6132b274f4b

Ring of Engagement = http://gyazo.com/c2dc4e1e6a0eec9355cd1cc18b02db8c


Top
 Offline Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 29 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: Google [Bot] and 65 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron