[Data dump] SQL data for static stuff

Original Url: http://forum-en.guildwars2.com/forum/community/api/Data-dump-SQL-data-for-static-stuff

smiley.1438:

22 May 2013

Hey,

i’ve created some SQL tables for the static data in order to cache results and reduce API requests like Cliff recommended over here. Currently i have tables for events, maps, worlds and WvW objectives, recipes and items are still WIP since these are huge databases :o

• Events: https://gist.github.com/codemasher/b0abd0f0a7a3781c6907
• Maps (+.json): https://gist.github.com/codemasher/dc3b232b3ccd2609a43b
• Worlds (+.json): https://gist.github.com/codemasher/b3b26a77dd0681697c59
• WvW-Objectives (+.json): https://gist.github.com/codemasher/bac2b4f87e7af128087e

Let me know if you need this in a different format, e.g. XML, CSV or even Excel…

Happy coding!

smiley.1438:

25 May 2013

Ok, i’m done with items and recipes:

• Items: http://chillerlan.de/gw2/gw2_items.zip
• Recipes: http://chillerlan.de/gw2/gw2_recipes.zip

(these may need to be updated from time to time)