Login | Register


All times are UTC - 5 hours


It is currently Tue Nov 13, 2018 2:23 am




Post new topic Reply to topic  [ 32 posts ] 
Author Message
 Post subject: A dynamic database site written in Javascript
PostPosted: Tue Dec 16, 2014 2:19 pm 

Joined: Tue Dec 16, 2014 2:16 pm
Posts: 18
Hey guys! I wanted to make a site that would be easier to modify and update as changes are made to the game as time goes on. Most of the work so far is on this page:

http://hellunleashed.github.io/#items-unique

What it does is parse the actual .txt files of the game (located in data/ in this repository) making it easy to use for different data sets. Simply fork the repository, and replace the files in the data directory.

There is a lot of work still to be done, but I feel this is a good start. If you see a mod not supported make a ticket or implement it yourself and bit by bit we can have the best possible Hell Unleashed Database possible :)

Here is the Github repository for the code for anyone wanting to help:

https://github.com/hellunleashed/hellunleashed.github.io/

(I've been a bit inactive recently as Path of Exile has some updates)


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Tue Dec 16, 2014 2:48 pm 
User avatar

Joined: Wed Sep 09, 2009 10:06 am
Posts: 1206
Nice work. :)

_________________
LockDown wrote:
Go outside.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Tue Dec 16, 2014 2:52 pm 
User avatar

Joined: Tue Feb 01, 2011 5:48 pm
Posts: 1670
holy shit you are a god

_________________
PureRage-DoD wrote:
Cowards die in shame, I ain't afraid to lose a char, it's not like it's important. :lol:


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Tue Dec 16, 2014 4:45 pm 

Joined: Tue Dec 16, 2014 2:16 pm
Posts: 18
Glad you guys like it so far. Feel free to post here if you don't have a Github account and I will fix the bugs or at least enter them into the tracker in case anyone else wants to work on it.

Right now I have the code listing unknown item effects so we can get an idea of which ones aren't supported. Here is the mapping used to do that:

https://github.com/hellunleashed/hellunleashed.github.io/blob/master/js/Effects.js

Please let me know which effects aren't supported and how they should read out. If I've butchered the wording of something please let me know.

Cheers!


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Tue Dec 16, 2014 4:56 pm 
User avatar

Joined: Wed Sep 09, 2009 10:06 am
Posts: 1206
A quick look at it and it seems like all the numbers have been doubled.

For example:

The Gnasher
+12 Strength
100% Chance of Open Wounds
20% Increased Attack Speed
200% Enhanced Damage
Prevent Monster Heal

only has:
6 str
50% ow
20 ias
100ed

Also, class skills are showing the skill id from skills.txt, ex:

+4 to 74 (Class Only)

74 is the skill id of the skill, in this case corpse explosion

but the "skill" mod ( and oskill, as well) in the txt files can use the skill ID or the skills name from skills.txt, so that might be tricky to work out

_________________
LockDown wrote:
Go outside.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Tue Dec 16, 2014 5:27 pm 
User avatar

Joined: Tue Sep 01, 2009 9:01 pm
Posts: 1378
Damn spiffy!
It's always fun to see someone just do something like this of their own accord, and plop it down for us to enjoy.
You are the person of the hour...er minute...er at least til I am done hitting enter!
Cheers and thanks for your work.

_________________
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: A dynamic database site written in Javascript
PostPosted: Tue Dec 16, 2014 5:38 pm 
User avatar

Joined: Tue Sep 01, 2009 9:01 pm
Posts: 1378
This should probably be stickied as a work in progress or something. If not now, then in the near future as stuff begins to get filled in. Can only Duff or 'true blues' do this I assume? I didn't see the button in the moderator tools at least...
Edit: Doh, I found the button. Didn't sticky it yet, but tempted :D

_________________
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: A dynamic database site written in Javascript
PostPosted: Tue Dec 16, 2014 7:02 pm 

Joined: Tue Dec 16, 2014 2:16 pm
Posts: 18
Thanks guys. I've filed two issues so I can fix them as time permits.

The first is about the doubling of the modifiers being displayed:

https://github.com/hellunleashed/hellunleashed.github.io/issues/1

The next one is how we need to cross reference skills.txt

https://github.com/hellunleashed/hellunleashed.github.io/issues/2


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Wed Dec 17, 2014 9:01 pm 

Joined: Tue Dec 16, 2014 2:16 pm
Posts: 18
I fixed the bug #1 where it was doubling the values and I think I can get it to show skill names within the next short bit. Let me know if you guys want more features :)

Almost got #2 done and some kewl search filtering will probably get implemented shortly after since I now have an index.

Got #2 done and updated the online copy of the site.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Thu Dec 18, 2014 3:54 pm 

Joined: Tue Dec 16, 2014 2:16 pm
Posts: 18
Trying to finish up the quick-searching stuff I was working on. It will let you search by name and specific item mods.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Thu Dec 18, 2014 5:43 pm 

Joined: Tue Dec 16, 2014 2:16 pm
Posts: 18
I was able to get searching working pretty easily. You can currently search by name and item mods. Both are straight-forward text matches. The item mod searching is pretty cool for how simple it is. I will add support later for multiple words most likely.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Thu Dec 18, 2014 8:11 pm 
User avatar

Joined: Wed Sep 09, 2009 10:06 am
Posts: 1206
I am so happy you are doing this for everyone. Great work. :D

_________________
LockDown wrote:
Go outside.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Thu Dec 18, 2014 8:58 pm 
User avatar

Joined: Mon Aug 31, 2009 6:42 am
Posts: 724
I really just want to know the stats on the challenge rings :)


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Thu Dec 18, 2014 10:26 pm 
User avatar

Joined: Wed Sep 09, 2009 10:06 am
Posts: 1206
they are super OP, I'm too lazy/busy to post exact stats but they have a lot of DR%, magic res, absorbs, oskills, all skills, life, resists, conc aura on equip, max res

you see why I changed them in my patch they make all other rings useless.

_________________
LockDown wrote:
Go outside.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Thu Dec 18, 2014 11:41 pm 

Joined: Tue Dec 16, 2014 2:16 pm
Posts: 18
It's good knowing you guys like the changes!

What should I add next?


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Thu Dec 18, 2014 11:54 pm 
User avatar

Joined: Wed Sep 09, 2009 10:06 am
Posts: 1206
any stats based on level usually use the param column for the value and it is handled in 8ths. So if an item has: hp/lvl 8, you get 1 hp per level; 16 would be 2 hp; 20 would be 2.5 hp, etc

_________________
LockDown wrote:
Go outside.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Fri Dec 19, 2014 7:38 am 
User avatar

Joined: Tue Sep 01, 2009 9:01 pm
Posts: 1378
kayrice wrote:
It's good knowing you guys like the changes!

What should I add next?


Level Requriements and Sets! :)

Edit: I noticed that Summon Resist is still used. This should be the Spirit Blade skill. (Ume's Lament for example)

_________________
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: A dynamic database site written in Javascript
PostPosted: Fri Dec 19, 2014 1:28 pm 
User avatar

Joined: Mon Aug 31, 2009 6:42 am
Posts: 724
and a way to sort by items :)


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Fri Dec 19, 2014 2:05 pm 

Joined: Tue Dec 16, 2014 2:16 pm
Posts: 18
Quote:
and a way to sort by items


I'm adding filtering to the item type as well as displaying the base item type and hopefully required level.

Quote:
and sets


There is a separate page I am making for sets that shows the partial / full bonuses.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Sat Dec 20, 2014 2:56 am 

Joined: Tue Dec 16, 2014 2:16 pm
Posts: 18
I added the level requirement to the item listing as well as filtering by item type. This means you can type "Double Axe" into the search for example it and it will only show weapons of that type, or you can type "Axe" and find all weapons that match that text.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Sat Dec 20, 2014 9:08 am 
User avatar

Joined: Wed Sep 09, 2009 10:06 am
Posts: 1206
Sexy, it looks great and it's getting better and better.

_________________
LockDown wrote:
Go outside.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Sat Dec 20, 2014 3:52 pm 

Joined: Tue Dec 16, 2014 2:16 pm
Posts: 18
For sets I was going to make a page where it lists the full and partial bonuses, so it would be different than the item listing page unless I can find a way to combine them.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Sat Dec 20, 2014 4:47 pm 

Joined: Tue Dec 16, 2014 2:16 pm
Posts: 18
I got lazy and decided to simply re-use the item listing widget I had made already and with one line of code was able to get Set items to display in a table with almost all of the base stats correctly, so I think I'll keep working from here to get the partial and full-set bonuses displaying in this table.

The Github copy of the page has been updated and you can see the set page here:

http://hellunleashed.github.io/#items-set


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Sat Dec 20, 2014 4:49 pm 

Joined: Tue Dec 16, 2014 2:16 pm
Posts: 18
Also I am fixing a nasty bug with the searches being case sensitive that a friend brought to my attention.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Mon Dec 22, 2014 7:06 pm 

Joined: Tue Dec 16, 2014 2:16 pm
Posts: 18
Fixing the case sensitive meant I replaced the matching code with a regular expression. This means you can do fancy searches like:

(strength|energy)

The Github copy has been updated.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Tue Dec 23, 2014 5:54 am 

Joined: Tue Dec 16, 2014 2:16 pm
Posts: 18
I'm going to be working on a inventory screen where you can equip various items, possibly even download the character as a .d2s file. Any ideas would be welcome or if anyone wants to help.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Sun Dec 28, 2014 2:29 am 

Joined: Tue Dec 16, 2014 2:16 pm
Posts: 18
Can anyone point me to the 1.4 data files?


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Sun Dec 28, 2014 1:25 pm 

Joined: Mon Nov 23, 2009 2:09 am
Posts: 734
I would try to use the files from Mraws patch since it will hopefully be uploaded soon. Suggestions page --> thread "here is my patch". It should be towards the bottom of the first post


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Sun Dec 28, 2014 1:40 pm 
User avatar

Joined: Wed Sep 09, 2009 10:06 am
Posts: 1206
Those files are a bit old. I can send you the up to date files. Let me know.

_________________
LockDown wrote:
Go outside.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Mon Dec 29, 2014 8:18 am 

Joined: Tue Dec 16, 2014 2:16 pm
Posts: 18
Please send them to kristopher.ives@gmail.com if you could.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Thu Jan 08, 2015 5:29 am 
User avatar

Joined: Fri Feb 25, 2011 7:44 am
Posts: 96
Where do i get the text files for new patch? Like you can view ones for the last on the java site???


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: A dynamic database site written in Javascript
PostPosted: Fri Jan 09, 2015 1:02 am 

Joined: Tue Dec 16, 2014 2:16 pm
Posts: 18
@ Zen1337 I originally got the .txt files from the released patch MPQ I downloaded.

@Mrawskrad Thanks for the files I'll get the Github site updated with some option to switch between data sets within the next few days.

Sorry for the lack of updates guys I just recently moved.


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

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 2 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