Jump to content

  • Curse Sites
Help
- - - - -

Android: Guild Wars Crafting Application

android crafting

  • Please log in to reply
12 replies to this topic

#1 Llewey

Llewey

    Fahrar Cub

  • New Members
  • 13 posts
  • Guild Tag:[iPNi]
  • Server:Ferguson’s Crossing

Posted 10 September 2012 - 07:29 AM

Hi All!

I would like to make an android application for crafting that will list all the recipes for each profession, the crafting level required to craft it, and what the item is dropped by for the base level ingredients (aspen tree for green wood; Bandits, Centaurs, etc. for Jute Cloth; Wurms, Spiders, etc for Tiny Venom Sacks) as well as allowing recipes to be filtered by base ingredients. If there is a clean and intuitive way to include other information I will do so, but I need the data first. There are some OK web solutions to this, but none of them are stellar. Also, I have to alt tab and navigate the clunky sites to find what I want. I envision sitting at the Chef Station and seeing in the discovery pane that I have 30 more recipes that I can discover using Carrots but I am only at 75 cooking skill, so I pull out the app and click "cooking", then in the ingredients filter I click "carrots" and in the level filter I click "75" and then below there are a series of expandable sections a la the GW2wiki and I am able to expand "Soups", "Meals", "Desserts" or whatever and find the recipes that use carrots and are craftable at the 0-150 bracket. But again, I need this data first.

I don't really want to go through and manually create my own database...what a pain! So is there an existing database that I can hook into to get the data from? I know the GW2 wiki has (incomplete) crafting information and gw2db has what appears to be a much larger list of items but without where to obtain them. Is there a way to directly pull the information from either of those sites? Does somebody have an existing crafting database that they would let me use? Or does someone have advice about writing a script to pull the information from a web resource to fill my own database?

Any help or advice you could give me would be great

#2 Llewey

Llewey

    Fahrar Cub

  • New Members
  • 13 posts
  • Guild Tag:[iPNi]
  • Server:Ferguson’s Crossing

Posted 27 December 2012 - 12:52 AM

I have just released version 1 of Guild Wars 2: Crafting DB on the Google Play store. Please check it out and if you have any comments feel free to share them here. If you have any problems with the app please let me know before leaving a bad review and I'll see if I can address it.

"GW2 Crafting DB is a tool to help players wade through the thousands of crafting recipes in Guild Wars 2. Search for recipes by name, ingredients, and stats; filter them by quality level and skill level; and see all the items you can make with the 100+ scraps of jute or iron ingots you have."


Play Store: play.google.com (free), play.google.com (paid - mostly to cover the cost of making a developer account)

Screenshots:

Dashboard   Recipes List    Recipe Information
Attached File  gw2craftdb_dash_small.png   65.12K   3 downloads   Attached File  gw2craftdb_profession_window_small.png   44.91K   0 downloads   Attached File  gw2craftdb_recipe_window_small.png   40.9K   0 downloads

Search Results

Edited by Llewey, 27 December 2012 - 11:51 AM.


#3 Operative 14

Operative 14

    Sylvari Specialist

  • Members
  • 670 posts

Posted 27 December 2012 - 07:31 AM

Very, very nice! I just downloaded it and this is a very slick app - thanks! It works very nicely on my Nexus 4.

What did you do you get the data? Are you hooking into an existing site or did you have to compile it all yourself and put it in a sqlite database?

#4 Llewey

Llewey

    Fahrar Cub

  • New Members
  • 13 posts
  • Guild Tag:[iPNi]
  • Server:Ferguson’s Crossing

Posted 27 December 2012 - 07:55 AM

View PostOperative 14, on 27 December 2012 - 07:31 AM, said:

Very, very nice! I just downloaded it and this is a very slick app - thanks! It works very nicely on my Nexus 4.

What did you do you get the data? Are you hooking into an existing site or did you have to compile it all yourself and put it in a sqlite database?

Thank you! I am glad you like it. I harvested the data from the GW2DB site (http://www.gw2db.com/)  into a sqlite db before they released the JSON API, so it isn't using network bandwidth to get the information.

#5 Minimal DJ

Minimal DJ

    Fahrar Cub

  • Members
  • 40 posts

Posted 31 December 2012 - 03:56 PM

Great work Llewey, would love to know how you built the Apk, in java ?

#6 Llewey

Llewey

    Fahrar Cub

  • New Members
  • 13 posts
  • Guild Tag:[iPNi]
  • Server:Ferguson’s Crossing

Posted 05 January 2013 - 06:14 PM

I would like to give a big thank you to the GW2 community for embracing this app. Yesterday marks a huge milestone...It already has over over 1000 downloads!! To make the app even better, feel free to pm me or post any feedback that you might have.

And yes DJ, it is written in Java with the android SDK.

#7 Llewey

Llewey

    Fahrar Cub

  • New Members
  • 13 posts
  • Guild Tag:[iPNi]
  • Server:Ferguson’s Crossing

Posted 16 January 2013 - 06:27 AM

Hello again and thanks for your continued support in making this app a success with nearly 3000 downloads to date. I can't believe so many people have downloaded it and checked it out.

I just wanted to let you all know that I just updated the app to fix a couple bugs that caused it to crash when viewing certain items with incomplete data. Hopefully this wasn't affecting many of you, but if it was please give the app another shot and let me know if you have any concerns or other bugs/issues.

Happy hunting,

Llewey

#8 Daesu

Daesu

    Seraph Guardian

  • Members
  • 1344 posts
  • Guild Tag:[NPO]
  • Server:Fort Aspenwood

Posted 17 January 2013 - 05:29 AM

I just got my Nexus 7 tablet and I downloaded your application.  It looks pretty neat.

#9 cobalt

cobalt

    Asuran Acolyte

  • Members
  • 98 posts
  • Profession:Elementalist
  • Server:Dragonbrand

Posted 17 January 2013 - 05:40 AM

i got it and used it a couple times already when crafting... thx for the great app.

#10 Nuclear_Herring

Nuclear_Herring

    Fahrar Cub

  • Members
  • 41 posts

Posted 17 January 2013 - 07:46 AM

Downloaded and in use. Thanks very much for your efforts.

#11 Llewey

Llewey

    Fahrar Cub

  • New Members
  • 13 posts
  • Guild Tag:[iPNi]
  • Server:Ferguson’s Crossing

Posted 31 January 2013 - 07:36 AM

Thanks for the comments and you're all very welcome :-)

I do have a question though: I was told that some recipes in the game have changed/aren't accurate in the app (in a review on the app, so I don't have any way of actually asking the person what they noticed different). a) When was that update? b ) Has that change been made in gw2db? c) Does gw2db or guildwars2guru make posts or announcements somewhere that I can find when the database changes? I see a post here that talks about items that were added on the 28th but I don't see anything about recipes being added and I don't want to re-crawl the DB and update the app if it doesn't actually have any changes AND I would like a place to bookmark to check once a week and make sure I don't miss any recipe updates.

Thanks all!!

Llewey

Edited by Llewey, 31 January 2013 - 04:42 PM.


#12 Daesu

Daesu

    Seraph Guardian

  • Members
  • 1344 posts
  • Guild Tag:[NPO]
  • Server:Fort Aspenwood

Posted 01 February 2013 - 10:05 AM

Honestly I haven't seen any API documentation from gw2db.  I requested on their api request thread sometime back but I never heard back from them.  I assume that they have only released api information to some people but their api is not public, so I don't know how that goes.  Gw2spidy has a public api and Ruben provides update on his api changes through his mailing list.

I have read some people claiming that gw2db has some outdated data.  I suppose somebody must be maintaining that data since users are not allowed to update it like a wiki.

Edited by Daesu, 01 February 2013 - 10:12 AM.


#13 Llewey

Llewey

    Fahrar Cub

  • New Members
  • 13 posts
  • Guild Tag:[iPNi]
  • Server:Ferguson’s Crossing

Posted 01 February 2013 - 08:31 PM

I have access to the API, but I didn't get it until after I scanned the DB and built my app and I don't really have time to change everything now and I'm not sure I'd be able to get everything I have now from the API as easily as I do now with a static DB, plus that requires constant network connection to use which is a negative, but the positive is that it would be as up-to-date as gw2db. But anyway, it is what it is, I just want to know when they update their db :P TELL ME GW2GURU!!! lol

Edited by Llewey, 02 February 2013 - 02:10 AM.






Also tagged with one or more of these keywords: android, crafting

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users