It would enable checking the remaining time on Righteous Indignation without ever being near the camp.
Thats already possible without a timestamp
(edited by smiley.1438)
(edited by smiley.1438)
(edited by smiley.1438)
Your link points to the gw1 wiki
http://wiki.guildwars2.com/wiki/API/item_details <- correct link
(edited by smiley.1438)
I’ve forgot the chat code - i know we can calculate them on our own, but it would be more reliable to have them from the original source
once we get a good objective_names.json file
I know, it’s not official, but it’s all you need – i believe, objectives are the least thing which will change
(edited by smiley.1438)
As for the world names, map names, etc. they hardly change so it makes sense for you to cache them too.
Thats why i’ve already created SQL and JSON for most of the static stuff
https://forum-en.gw2archive.eu/forum/community/api/SQL-data-for-static-stuff
Thanks for the quick response!
…and there we’ve killed the API
Page not found
Host
pubstats-live.ncplatform.net
URL
/v1/item_details.json?item_id=23250
Remote Address
84.162.253.193:15725
SpawnSrv/301.3051201 Instance/0.391033534That being said, the server does appear to be Microsoft’s IIS 7.5, which is an odd choice for RoR (Truth be told, I didn’t even know IIS+Passenger was possible; the preferred choice is Nginx/Apache+Passenger).
I believe the IIS is just a proxy – the application server may be a completely different
Have you discovered funny stuff you haven’t seen before while digging in the data?
I’ve just found “Fiat Lux” which is a phrase from the bible which means “let there be light” – right, it’s a torch. The funny thing is: the weapon is called Fiat Lux only in german which may be a pun on the swiss based cult led by Uriella.
Why is that funny? Well, go to youtube and check for yourself…
[…]
€: Why is there so much space between those links? :o
(edited by smiley.1438)
(edited by smiley.1438)
I’ve added the spanish translations and a .json to my gist:
https://gist.github.com/codemasher/bac2b4f87e7af128087e
re the map names: i’ve kept them short since they’re for internal use only, you’ll need to add translation anyway if you want to use them out of the DB – i didn’t want to add 3 more columns for just 4 different words
several item names contain double spaces like: https://api.guildwars2.com/v1/item_details.json?item_id=1794&lang=fr
I don’t see any double spaces in this example. If any exist, it’s likely an issue in the original item data too.
I’ve seen a lot of double spaces especially in spanish and french translations – the original response to the above request looks like this, take a look on Manteau de voleur solide de l’aigle:
{"item_id":"1794","name":"Manteau de voleur solide de l'aigle","description":"","type":"Armor","level":"60","rarity":"Rare","vendor_value":"234","game_types":["Activity",
"Dungeon",
"Pve",
"Wvw"],"flags":[],"restrictions":[],"armor":{"type":"Coat","weight_class":"Medium","defense":"202","infusion_slots":[],"infix_upgrade":{"buff":"","attributes":[{"attribute":"Power","modifier":"58"},
{"attribute":"Precision","modifier":"41"}]},"suffix_item_id":"24722"}}
€: it seems that most of the items with a suffix are affected (~4.5k) – there is a double space before the suffix. Oh, and there is one german item with a double space: https://api.guildwars2.com/v1/item_details.json?item_id=20286&lang=de
Some other items have HTML-like markup in their descriptions like https://api.guildwars2.com/v1/item_details.json?item_id=29175
Any strip_tags function should remove it, but it doesn’t look good or may break code if it’s not removed.That’s intentional, though it should probably be better documented in the future since it’s a completely custom markup. If your goal is to re-create an item’s information box to look like it does in the game, you’ll need those tags to show the right color or style for the text.
I thought that this is intentional, a documentation of that would be nice
(edited by smiley.1438)
Images in signatures aren’t allowed anyway.
Nice work btw. – i must admit, i love stats signature images – i love to create stuff like this too
kinda OT but: http://worldofpadman.net/website/servers/image/78.46.97.51:27961/2.png
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!
(edited by smiley.1438)
There are alot of reason to not query all the languages at all times.
This may be true for the events list which would grow huge if it delivers all languages but for those detailed requests it may be fine
simple calculation:
the original response is ~650 bytes
this * 4 languages * ~25k items = 65MB traffic
the response i suggested is ~1050 bytes
this * ~25k items = 26.25MB traffic and 1/4 of the requests
(edited by smiley.1438)
Oh, while we’re at it: what about adding all languages to a response instead of retrieving 4 responses? So that a response for https://api.guildwars2.com/v1/item_details.json?item_id=29175 would look like this:
{
item_id: "29175",
name: {
de: "Der Jäger",
en: "The Hunter",
es: "El Cazador",
fr: "Le chasseur"
}
description: {
de: "<c=@flavor>Diese Waffe wird verwendet, um das legendäre Gewehr "Das Raubtier" zu fertigen</c>",
en: "<c=@flavor>This weapon is used to craft the legendary rifle The Predator</c>",
es: "<c=@flavor>Esta arma se usó para forjar el legendario rifle El Depredador</c>",
fr: "<c=@flavor>Cette arme sert à fabriquer le légendaire fusil Prédateur.</c>"
}
type: "Weapon",
level: "80",
rarity: "Exotic",
vendor_value: "396",
game_types: [
"Activity",
"Dungeon",
"Pve",
"Wvw"
],
flags: [
"HideSuffix"
],
restrictions: [ ],
weapon: {
type: "Rifle",
damage_type: "Physical",
min_power: "986",
max_power: "1205",
defense: "0",
infusion_slots: [ ],
infix_upgrade: {
buff: "",
attributes: [
{
attribute: "Power",
modifier: "179"
},
{
attribute: "Precision",
modifier: "128"
},
{
attribute: "CritDamage",
modifier: "9"
}
]
},
suffix_item_id: "24561"
}
}This way you could reduce requests and traffic beside making our lives easier
(edited by smiley.1438)
I’ve collected some data (thanks to millenium.org ) and threw it into a DB. However, spanish tanslation is still missing – anyone here to help out?
protip: try the [pre] tag to post code
What i’ve written just one post before applies also to your first code example.
- Events
- add map_id to the event_names response
I’m currently creating a local database for most of the static stuff – a corresponding map_id for every event would make life easier.
Hmm…
http://php.net/manual/en/function.strip-tags.php
http://api.prototypejs.org/language/String/prototype/stripTags/
something like this may help