Temragon Posted April 11, 2018 Share Posted April 11, 2018 Community tool author with the regular request for machine-readable (json, etc) file to go with the html version, ideally including the starmap node name used in worldstate. 1 Link to comment Share on other sites More sharing options...
Guest Posted April 12, 2018 Share Posted April 12, 2018 On 4/2/2018 at 1:09 AM, KingMarth said: Requesting that War Blade and War Hilt be added back to the drop table listing. They are back. Link to comment Share on other sites More sharing options...
Spaceotter1203 Posted April 17, 2018 Share Posted April 17, 2018 Creating a .csv of each section myself so that I may create a local SQL database to query different information on the fly while in game. This information is greatly appreciated. Foo foo the naysayers. :) Link to comment Share on other sites More sharing options...
Tobiah Posted April 18, 2018 Share Posted April 18, 2018 (edited) 20 hours ago, Spaceotter1203 said: Creating a .csv of each section myself so that I may create a local SQL database to query different information on the fly while in game. This information is greatly appreciated. Foo foo the naysayers. :) I ended up standing up a simple api for people to use to grab formatted sections of the drop data. https://api.warframestat.us/drops/ mirrors a formatted version of https://drops.warframestat.us/data/all.json if that's something you're into. (another dev friend made the drops.warframestat.us site, i just provide the hostname. I can't take credit for that.) Edited April 18, 2018 by Tobiah credit where credit is due Link to comment Share on other sites More sharing options...
Spaceotter1203 Posted April 20, 2018 Share Posted April 20, 2018 On 4/18/2018 at 1:08 PM, Tobiah said: I ended up standing up a simple api for people to use to grab formatted sections of the drop data. https://api.warframestat.us/drops/ mirrors a formatted version of https://drops.warframestat.us/data/all.json if that's something you're into. (another dev friend made the drops.warframestat.us site, i just provide the hostname. I can't take credit for that.) Nice! Thank you! Link to comment Share on other sites More sharing options...
WFCD Posted April 25, 2018 Share Posted April 25, 2018 On 4/5/2018 at 10:42 AM, CroqueMortTime said: Hi guys, Could you put somewhere on the drop page (ideally near the top I guess ^^ ) the date at which you change it and also the update it is synced to ? That would be helpful to see when we need to update the database on the wikia for example ;) It would look like this probably Reveal hidden contents [...] Thank you for playing Warframe. Uptaded on March 28th 2018, Update 22.17.0 Table of Contents: [...] Thanks ! :) There's a header on the page, "last-modified" that seems to be an accurate representation of when the page was last modified. Now all you need to do is cross-reference it to see if there's a version number associated with it. At the time of writing, the header is set to "Fri, 20 Apr 2018 14:29:31 GMT" (1524234571000) which corresponds to the rough release time of update 22.18. Pretty much what you'd want to do is pick the closest matching update and you should be good to go. ...of course, there could be a random page update in case of an exploit fix, for example, but that could be solved by only adding the update name when the update has occurred on the same date. Link to comment Share on other sites More sharing options...
(PSN)batareika300 Posted April 29, 2018 Share Posted April 29, 2018 Когда миссия на нейрооптику вобана ? Link to comment Share on other sites More sharing options...
napei_ Posted May 5, 2018 Share Posted May 5, 2018 @[DE]Rebecca can we get the data serialized as JSON? Would make parsing it easier if we want to use this data elsewhere Thanks 🙂 Link to comment Share on other sites More sharing options...
TyrianMollusk Posted May 6, 2018 Share Posted May 6, 2018 (edited) On 2017-06-28 at 5:34 PM, [DE]Rebecca said: This list can be discussed here in this thread. Please add a "Last generated" date to the page text. It's important people can see both that the list is up-to-date and precisely when it was last generated, on the off chance something has changed since. This is a necessity, both for reassurance and for transparency (ie, it demonstrates commitment and that the updates are still happening, as previously promised). It would also be cool to include a "Last changed" date, for the last time anything in the tables actually changed. Your automated tool won't have any problem with either of these. Edited May 6, 2018 by TyrianMollusk Link to comment Share on other sites More sharing options...
beercritch Posted May 29, 2018 Share Posted May 29, 2018 (edited) On 2018-05-06 at 8:42 PM, TyrianMollusk said: Please add a "Last generated" date to the page text. It's important people can see both that the list is up-to-date and precisely when it was last generated, on the off chance something has changed since. This is a necessity, both for reassurance and for transparency (ie, it demonstrates commitment and that the updates are still happening, as previously promised). It would also be cool to include a "Last changed" date, for the last time anything in the tables actually changed. Your automated tool won't have any problem with either of these. what this guy says ^^ I have been running a few nightmare missions and am not getting the expected rewards as shown in the table for rotation C nightmare missions. The table is out of date in some areas I suspect Edited May 29, 2018 by beercritch Link to comment Share on other sites More sharing options...
WFCD Posted May 29, 2018 Share Posted May 29, 2018 (edited) On 2018-05-06 at 9:42 PM, TyrianMollusk said: Please add a "Last generated" date to the page text. It's important people can see both that the list is up-to-date and precisely when it was last generated, on the off chance something has changed since. This is a necessity, both for reassurance and for transparency (ie, it demonstrates commitment and that the updates are still happening, as previously promised). It would also be cool to include a "Last changed" date, for the last time anything in the tables actually changed. Your automated tool won't have any problem with either of these. 9 hours ago, beercritch said: what this guy says ^^ I have been running a few nightmare missions and am not getting the expected rewards as shown in the table for rotation C nightmare missions. The table is out of date in some areas I suspect This is already a thing. The response header "last-modified" does exactly this, although it's not actually in text form on the page. This should be easy to retrieve however. I've hinted at this in an earlier post. On 2018-05-05 at 11:27 AM, NattyMan0007 said: @[DE]Rebecca can we get the data serialized as JSON? Would make parsing it easier if we want to use this data elsewhere Thanks 🙂 There's a community project that aims to do just this for you. See: https://github.com/WFCD/warframe-drop-data Edited May 29, 2018 by WFCD Link to comment Share on other sites More sharing options...
Am0rph15 Posted May 29, 2018 Share Posted May 29, 2018 On 18/04/2018 at 7:08 PM, Tobiah said: I ended up standing up a simple api for people to use to grab formatted sections of the drop data. https://api.warframestat.us/drops/ mirrors a formatted version of https://drops.warframestat.us/data/all.json if that's something you're into. (another dev friend made the drops.warframestat.us site, i just provide the hostname. I can't take credit for that.) Thanks, I shall investigate this (coincidentally, I started designing and building a (Kimball) DW for all these data just this weekend with SSIS to amend dimensions and facts but wasn't looking forward to potentially keying data...). Link to comment Share on other sites More sharing options...
Tobiah Posted May 29, 2018 Share Posted May 29, 2018 7 hours ago, Am0rph15 said: Thanks, I shall investigate this (coincidentally, I started designing and building a (Kimball) DW for all these data just this weekend with SSIS to amend dimensions and facts but wasn't looking forward to potentially keying data...). I hope it helps you out. Link to comment Share on other sites More sharing options...
TyrianMollusk Posted May 30, 2018 Share Posted May 30, 2018 On 2018-05-29 at 6:37 AM, WFCD said: The response header "last-modified" does exactly this, although it's not actually in text form on the page. No, it does not do the same thing. That is the equivalent of a last modified date in your file system and is used so your browser can properly manage cache vs new versions. You could copy over an identical copy of the file and it will get a new date, but that does not tell us anything about when the data was extracted from the build/source. We should see both when the data was genuinely extracted and when it last actually changed. Header dates are irrelevant to either of these unless they are carefully setting the date that header reads from, in which case there's no reason not to include it in the actual person-visible data. People are not supposed to have to examine headers to get basic information, even if that information were genuinely useful, which it is not. Link to comment Share on other sites More sharing options...
WFCD Posted May 30, 2018 Share Posted May 30, 2018 (edited) 1 hour ago, TyrianMollusk said: No, it does not do the same thing. That is the equivalent of a last modified date in your file system and is used so your browser can properly manage cache vs new versions. You could copy over an identical copy of the file and it will get a new date, but that does not tell us anything about when the data was extracted from the build/source. We should see both when the data was genuinely extracted and when it last actually changed. Header dates are irrelevant to either of these unless they are carefully setting the date that header reads from, in which case there's no reason not to include it in the actual person-visible data. People are not supposed to have to examine headers to get basic information, even if that information were genuinely useful, which it is not. It has nothing to do with client-sided cache, apart from validation. It is supplied by the server itself, meaning it's consistent, and it denotes when it believes the page to have been last modified. Which is reliable enough in this case, and has been for a while. It's a response header, it is independent of browser (or other implementation) and "just so happens" to almost exactly match the last update time. Good enough for what we're getting. I agree that people shouldn't have to examine headers to get information, but then again, people shouldn't have to parse a HTML <table> element to get meaningful data. Sadly, it seems we can't have everything we want. Edited May 30, 2018 by WFCD Clarified and get rid of passive :clem:. Link to comment Share on other sites More sharing options...
TyrianMollusk Posted May 31, 2018 Share Posted May 31, 2018 3 hours ago, WFCD said: It has nothing to do with client-sided cache, apart from validation. It is supplied by the server itself, meaning it's consistent, and it denotes when it believes the page to have been last modified. Which is reliable enough in this case, and has been for a while. I said it was used to know if the cache was out of date. Of course it's supplied by the server, and it denotes nothing except when the server's filesystem says the file has something done to it or was created. If DE generated the file monthly, and a script uploaded the file daily, the "last modified" date would only be right once a month, regardless of any actual changes to the file or drop tables. If DE generates the table, then updates the game with new drop tables, then uploads the old file, it will be dated after the change but have data from before the change. The header date is simply not a useful piece of information. It's utility depends entirely on chance in how DE uploads the file. The right thing to do is to honestly include the relevant dates in the generation process, because they are part of the data. This is completely trivial for them to do, and a basic bit of honesty in what they are saying is specifically intended to be an open and honest process. Arguing against it is pointless and ridiculous. Server headers are not content. They are for reference by the browser and the server, not for users, and even if they do happen to coincide with the intended information sometimes, they have no meaning. Link to comment Share on other sites More sharing options...
skRose Posted June 2, 2018 Share Posted June 2, 2018 On 2018-04-02 at 12:09 AM, KingMarth said: Requesting that War Blade and War Hilt be added back to the drop table listing. This x100 jfc the frustration behind these parts are unreal. Link to comment Share on other sites More sharing options...
(PSN)Zero_bigraw5021 Posted June 7, 2018 Share Posted June 7, 2018 Can we get one for the consoles Link to comment Share on other sites More sharing options...
(PSN)iICapitano3 Posted June 12, 2018 Share Posted June 12, 2018 This is brilliant. Thanks Link to comment Share on other sites More sharing options...
Fire2box Posted June 16, 2018 Share Posted June 16, 2018 Can DE please add pigment drop rates as well? Link to comment Share on other sites More sharing options...
.Raf Posted June 16, 2018 Share Posted June 16, 2018 21 minutes ago, Fire2box said: Can DE please add pigment drop rates as well? It's not perfect, but enough clans have gone for the pigments that we have estimated drop rates listed on the wiki: https://warframe.wikia.com/wiki/Pigment Link to comment Share on other sites More sharing options...
Fire2box Posted June 21, 2018 Share Posted June 21, 2018 On 2018-06-16 at 12:02 PM, .Raf said: It's not perfect, but enough clans have gone for the pigments that we have estimated drop rates listed on the wiki: https://warframe.wikia.com/wiki/Pigment I just did the arid evisorator one and it was no where close to 100% even with my resource drop chance booster and nekros desecrate. Link to comment Share on other sites More sharing options...
Rydian Posted July 25, 2018 Share Posted July 25, 2018 Could chances/possibilities for syndicate relic packs be added to the output? Link to comment Share on other sites More sharing options...
Harestation Posted July 30, 2018 Share Posted July 30, 2018 (edited) There may be several mistakes in the list, but i saw one trying to see where you could get Shell Shock on Eris with the caches. There are 5 missions in the list when only one exists : Eris/Naeglar. The list of the missions that are still there and don't exist anymore : Eris/Candiru Eris/Lepis Eris/Psoro Eris/Viver Edited July 30, 2018 by Harestation Link to comment Share on other sites More sharing options...
Kothophed Posted July 30, 2018 Share Posted July 30, 2018 2 hours ago, Harestation said: Eris/Viver RIP Viver. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now