Gates of Arimyth
http://forum.arimyth.com/

A dynamic database site written in Javascript
http://forum.arimyth.com/viewtopic.php?f=8&t=8398
Page 1 of 1

Author:  kayrice [ Tue Dec 16, 2014 2:19 pm ]
Post subject:  A dynamic database site written in Javascript

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)

Author:  Mrawskrad [ Tue Dec 16, 2014 2:48 pm ]
Post subject:  Re: A dynamic database site written in Javascript

Nice work. :)

Author:  slappyNuts [ Tue Dec 16, 2014 2:52 pm ]
Post subject:  Re: A dynamic database site written in Javascript

holy shit you are a god

Author:  kayrice [ Tue Dec 16, 2014 4:45 pm ]
Post subject:  Re: A dynamic database site written in Javascript

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!

Author:  Mrawskrad [ Tue Dec 16, 2014 4:56 pm ]
Post subject:  Re: A dynamic database site written in Javascript

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

Author:  kramuti [ Tue Dec 16, 2014 5:27 pm ]
Post subject:  Re: A dynamic database site written in Javascript

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.

Author:  kramuti [ Tue Dec 16, 2014 5:38 pm ]
Post subject:  Re: A dynamic database site written in Javascript

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

Author:  kayrice [ Tue Dec 16, 2014 7:02 pm ]
Post subject:  Re: A dynamic database site written in Javascript

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

Author:  kayrice [ Wed Dec 17, 2014 9:01 pm ]
Post subject:  Re: A dynamic database site written in Javascript

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.

Author:  kayrice [ Thu Dec 18, 2014 3:54 pm ]
Post subject:  Re: A dynamic database site written in Javascript

Trying to finish up the quick-searching stuff I was working on. It will let you search by name and specific item mods.

Author:  kayrice [ Thu Dec 18, 2014 5:43 pm ]
Post subject:  Re: A dynamic database site written in Javascript

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.

Author:  Mrawskrad [ Thu Dec 18, 2014 8:11 pm ]
Post subject:  Re: A dynamic database site written in Javascript

I am so happy you are doing this for everyone. Great work. :D

Author:  hunterAS [ Thu Dec 18, 2014 8:58 pm ]
Post subject:  Re: A dynamic database site written in Javascript

I really just want to know the stats on the challenge rings :)

Author:  Mrawskrad [ Thu Dec 18, 2014 10:26 pm ]
Post subject:  Re: A dynamic database site written in Javascript

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.

Author:  kayrice [ Thu Dec 18, 2014 11:41 pm ]
Post subject:  Re: A dynamic database site written in Javascript

It's good knowing you guys like the changes!

What should I add next?

Author:  Mrawskrad [ Thu Dec 18, 2014 11:54 pm ]
Post subject:  Re: A dynamic database site written in Javascript

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

Author:  kramuti [ Fri Dec 19, 2014 7:38 am ]
Post subject:  Re: A dynamic database site written in Javascript

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)

Author:  hunterAS [ Fri Dec 19, 2014 1:28 pm ]
Post subject:  Re: A dynamic database site written in Javascript

and a way to sort by items :)

Author:  kayrice [ Fri Dec 19, 2014 2:05 pm ]
Post subject:  Re: A dynamic database site written in Javascript

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.

Author:  kayrice [ Sat Dec 20, 2014 2:56 am ]
Post subject:  Re: A dynamic database site written in Javascript

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.

Author:  Mrawskrad [ Sat Dec 20, 2014 9:08 am ]
Post subject:  Re: A dynamic database site written in Javascript

Sexy, it looks great and it's getting better and better.

Author:  kayrice [ Sat Dec 20, 2014 3:52 pm ]
Post subject:  Re: A dynamic database site written in Javascript

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.

Author:  kayrice [ Sat Dec 20, 2014 4:47 pm ]
Post subject:  Re: A dynamic database site written in Javascript

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

Author:  kayrice [ Sat Dec 20, 2014 4:49 pm ]
Post subject:  Re: A dynamic database site written in Javascript

Also I am fixing a nasty bug with the searches being case sensitive that a friend brought to my attention.

Author:  kayrice [ Mon Dec 22, 2014 7:06 pm ]
Post subject:  Re: A dynamic database site written in Javascript

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.

Author:  kayrice [ Tue Dec 23, 2014 5:54 am ]
Post subject:  Re: A dynamic database site written in Javascript

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.

Author:  kayrice [ Sun Dec 28, 2014 2:29 am ]
Post subject:  Re: A dynamic database site written in Javascript

Can anyone point me to the 1.4 data files?

Author:  muleofal [ Sun Dec 28, 2014 1:25 pm ]
Post subject:  Re: A dynamic database site written in Javascript

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

Author:  Mrawskrad [ Sun Dec 28, 2014 1:40 pm ]
Post subject:  Re: A dynamic database site written in Javascript

Those files are a bit old. I can send you the up to date files. Let me know.

Author:  kayrice [ Mon Dec 29, 2014 8:18 am ]
Post subject:  Re: A dynamic database site written in Javascript

Please send them to kristopher.ives@gmail.com if you could.

Author:  Zen1337 [ Thu Jan 08, 2015 5:29 am ]
Post subject:  Re: A dynamic database site written in Javascript

Where do i get the text files for new patch? Like you can view ones for the last on the java site???

Author:  kayrice [ Fri Jan 09, 2015 1:02 am ]
Post subject:  Re: A dynamic database site written in Javascript

@ 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.

Page 1 of 1 All times are UTC - 5 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/