woggly4 Posted June 2, 2018 Share Posted June 2, 2018 Hi, I think I've found a bug on the site. Today, after 8 years (yeah, it really is a coincidence that it's exactly 8 years), I played Saboteur again and got a trophy, please have a look here: https://psnprofiles.com/trophies/239-the-saboteur/woggly4?order=date The time difference shows "+8 years, 3 days, 18 hours" but it's actually 8 years and nearly 4 hours. Or am I missing something here? Link to comment Share on other sites More sharing options...
Darkette Posted June 2, 2018 Share Posted June 2, 2018 Leap years? Link to comment Share on other sites More sharing options...
woggly4 Posted June 2, 2018 Author Share Posted June 2, 2018 Didn't think about that, but there were only two, 2012 and 2016. Would explain 2 more days, but not 3 days and 18 hours. ? Link to comment Share on other sites More sharing options...
MMDE Posted June 6, 2018 Share Posted June 6, 2018 (edited) I got a script running that recalculate the time between every trophy for me down to the second. var d = [31536000,2678400,604800,86400,3600,60,1], dn = ["year","month","week","day","hour","minute","second"], First list is the amount of seconds for what the second list represent. This usually matches PSNP in my experience. I view the times in UTC time with no daylight saving stuff. First part there would be the time I calculate from first to this last trophy. I see PSNP says this: Yes, even the minutes are off. There's not 5 minutes between 52 and 34. That's either around +-42 or +-18, which matches my script. I've seen stuff like this before though, but it was related to people who edit timestamps. Not saying you do this, and it's kinda silly how little you'd have to do it for this to happen. Basically, I think the Gap stuff is cached separately from the time between trophies. Not sure if the gap is gotten directly from PSN, or if it's just calculated separately, but often in such cases there is a mismatch between your trophies on PSN and the ones on PSNP, because PSNP caches the dates, not refetching them every time you update your profile. I can send you a PM about something I wanna test to see if it fixes this. Edited June 6, 2018 by MMDE 1 Link to comment Share on other sites More sharing options...
fastflowdaman Posted June 6, 2018 Share Posted June 6, 2018 23 minutes ago, MMDE said: I can send you a PM about something I wanna test to see if it fixes this. It's a trap Link to comment Share on other sites More sharing options...
MMDE Posted June 6, 2018 Share Posted June 6, 2018 1 hour ago, fastflowdaman said: It's a trap Tempted to post a picture of what a trap looks like... I just couldn't hold back anymore! 3 Link to comment Share on other sites More sharing options...
Popular Post fastflowdaman Posted June 6, 2018 Popular Post Share Posted June 6, 2018 I was really curious what I'd find within the spoiler. Gotta say it was cheesy 11 Link to comment Share on other sites More sharing options...
woggly4 Posted June 6, 2018 Author Share Posted June 6, 2018 7 hours ago, fastflowdaman said: It's a trap Nah, he just asked me to send him my PS3 and the copy of Saboteur I played with, so nothing to worry about. Package is on its way. /jk Link to comment Share on other sites More sharing options...
dmland12 Posted June 6, 2018 Share Posted June 6, 2018 I'm also seeing something screwy with the gap calculation. I recently started playing Divinity: Original Sin again, which I had played a little of last year. 1 year, 2 months, 2 weeks looks fine, but how do you get a difference of 11 hours 53 minutes there? It should be 2 hours, 17 minutes, so it's off by 576 minutes in my case. Link to comment Share on other sites More sharing options...
woggly4 Posted August 2, 2018 Author Share Posted August 2, 2018 This is really weird. Again the difference is wrong: It should be something around 19 hours, not 9. ? Link to comment Share on other sites More sharing options...
PViddy Posted August 2, 2018 Share Posted August 2, 2018 I too have had this issue... I just did Super Stardust HD on the EXACT day of my first trophy ever earned on my acct. I call it my 10 year anniversary completion lol. First trophy I ever earned was on July 31st 2008 at 9:13am and my final trophy was July 31st 2018 at 2:15. Now that should read 10 years 5 hours... instead it says 10 years 4days 5 hours. It doesn't matter if there are leap year days or not bc a year is a year. The whole extra day every 4 years doesnt have anything to do with the calculations. Over on PSNTL it reads 10 years 5 hours like it should, but over here the coding is definitely off. Link to comment Share on other sites More sharing options...
aerosol_grey Posted August 4, 2018 Share Posted August 4, 2018 I asked about this some time ago... Basically the site assumes a month is equal to 30.4 days which introduces an error in time gaps that are over a month. 2 Link to comment Share on other sites More sharing options...
woggly4 Posted August 4, 2018 Author Share Posted August 4, 2018 (edited) Ah, thanks for the info, aerosol_grey. @Sly Ripper Wouldn't momentjs and its difference function solve this problem? (https://momentjs.com/docs/#/displaying/difference/, see "Month and year diffs") Edited August 4, 2018 by woggly4 Link to comment Share on other sites More sharing options...
Sly Ripper Posted August 14, 2018 Share Posted August 14, 2018 On 8/4/2018 at 11:26 AM, woggly4 said: Ah, thanks for the info, aerosol_grey. @Sly Ripper Wouldn't momentjs and its difference function solve this problem? (https://momentjs.com/docs/#/displaying/difference/, see "Month and year diffs") Don't think so, looks like it outputs the length as one metric, (8 years/96 months). I don't think anyone's written anything accurate that takes into account exact leap years or DST changes. i could rewrite the current implementation to be a relative difference between the exact numbers if that's what users prefer. 2 Link to comment Share on other sites More sharing options...
hore Posted June 5, 2020 Share Posted June 5, 2020 I'm guessing nothing ever came of this? my script is trying to compare fastest completions (even to users not on leaderboards), but looking at users' trophy gaps, they still seem totally inaccurate due to the month=30.4d assumption... I guess I'll implement the same assumption, but for accuracy's sake it really should've used a larger mantissa like 30.4167 (via Google) 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