Register / Log in

Server Costs Oct

Ends in 12 days 0%
It is currently Sun Oct 20, 2019 8:13 am

All times are UTC - 8 hours




Post new topic Reply to topic  [ 30 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: Tools -- Dailies (inf, combat lvls, profits)[online, stable]
PostPosted: Tue Mar 09, 2010 2:17 pm 
Moostro

Joined: Sat Dec 08, 2007 10:56 am
Posts: 795
Location: Vancouver, WA
Faction: Flight School
Offline
The Dailies tools are up at http://skyrates.zosimple.net

Notice: The official dailies do not run at 03:00am us/pacific, they're off by quite a bit, over half an hour at this point, so the final numbers for the day wont always match up. Not much I can do consistently, we'll just have to wait until they fix the clock.

Profits: There is some kind of data issue that causes some people to show remarkably lower profits at times (compared to the official dailies) while all others are just fine. I am not sure if this is related to the timing issue or not, so be aware that profits are still a bit off, primarily for those at the top of the list.


There are influence, combat levels defeated, and profits pages.
In addition, there is a "split" page that shows all three for the current day.
These update once per hour, on the hour (actually 1-3 minutes after due to doing very slow pulls from dynaRank to be nice.)
The dailies have a restart time of 3AM us/pacific (to mirror the existing dailies.)


This currently covers all members of every faction except for flight school (but gets most every active player)
The regular daily shows four days (today tracking + 3 previous days) with the top 50 displayed in pages of up to 20.
The (long) daily shows two days (today tracking + 1 previous day) with the top 200 displayed in pages of up to 100.


---

Both have the same design:
* The top area contains entries for filtering the data, including name (currently case sensitive), faction, plane tier, and plane type.
* All filters affect all the tables simultaneously.
* The individual headers can be clicked to sort, this works even with active filters

* # will also show the original sort order rank (top true influence at this point)
* User names are coded with their faction color
* Plane names are coded with their plane style (combat, trade, performance, stock, upgrade)
* Up to three sets of numbers are available
1) [default] total gained per day (INF, LVL, PROFIT)
For influence, this is true gained influence per day
This number (under the day-of-week) should reflect gained influence, IGNORING decay. Therefore all influence gained will be displayed, but it should calculated to avoid reflecting the decay reduction that occurs at night.
This number does include apprentice reputation, until such time as dynaRank offers a no-apprentice count.
2) Net (INF)
This number is only displayed in long formats (Current day and the Long page).
Net is your effective actual inf after decay is added in. (This unfortunately also has apprentice rep for now.)
This applies decay immediately in the beginning of the day, so you can actually see how far you have to go to 'beat' the decay. Keep in mind that since apprentice rep is stuck in the totals, you'll have to exceed '0' Net to offset your apprentices.
3) Total (INF, LVL, PROFIT)
This number is the current actual total. (For influence, this only reflects decay after skyrates processes it.)

* Faction total counts are sums from all of the processed individuals, it reflects up to three numbers:
Combat Levels:
1) Total combat levels defated

Profit:
1) Total of those who have net profit on the day
2) Total of those who have net loss on the day
3) Total combined profit and loss
*** This is not individual profit + loss, but splits those who are currently at a loss because they're mid-carry of an expensive load or had a bad sale.

Influence:
1) Total true gained influence per day, ignoring decay
2) Total expected decay
3) Total net gain per day
As above, the apprentice rep is still included, so numbers are not totally precise at this point.
Flight school is obviously not a totally complete number.


{{{Notes}}}
* Please do comment, note possible errors, make suggestions, etc.
* If you note an error, I would especially appreciate a screenshot. Many errors are much easier to fix if I can see the problem numbers or formats to fix them.
* I don't expect a traffic issue for my server, but given that they don't update more than once per hour, I do appreciate y'all not trying to reload them all that often.
* They're not very tiny pages, and they rely heavily on javascript. They should load fine without javascript, just lacking functionality and showing the full set of rows.


{{{Todo}}}
* I plan to migrate sorts these to master/all table sorts at some point
* I am hoping to add an optional cookie/preferences so that you can retain customized filter/sort settings
* Possible longer-term tracking, including weekly or monthly for long-haul competition.
* Skyland based integration, as much as is possible, is one of the next goals

_________________
Senator nehp
http://skyrates.zosimple.net


Last edited by nehp on Mon Jul 18, 2011 8:41 am, edited 3 times in total.

Top
 Profile  
 
 Post subject: Re: Tools -- Daily influence [online, dev]
PostPosted: Tue Mar 09, 2010 3:48 pm 
Flirt

Joined: Sun Nov 22, 2009 12:01 am
Posts: 470
Faction: Azure League

Offline
Post moved to correct topic. Move along, nothing to see here.

_________________
Image


Last edited by Herley on Wed Mar 10, 2010 2:31 pm, edited 1 time in total.

Top
 Profile  
 
 Post subject: Re: Tools -- Daily influence [online, dev]
PostPosted: Wed Mar 10, 2010 7:23 am 
Combat Guru

Joined: Sun Dec 17, 2006 6:28 pm
Posts: 1924
Faction: Azure League

Offline
You make me feel so lazy, dude.

_________________
If brute force isn't working, you're just not using enough
Image
Proud recipient of the Golden Waffle Award


Top
 Profile  
 
 Post subject: Re: Tools -- Daily influence [online, dev]
PostPosted: Wed Mar 10, 2010 2:41 pm 
Developer

Joined: Tue Dec 12, 2006 7:05 am
Posts: 3635
Location: Skybrary Archives
Offline
WIN!
This bit was especially helpful:
nehp wrote:
Net is your effective actual inf after decay is added in. (This unfortunately also has apprentice rep for now.)
This applies decay immediately in the beginning of the day, so you can actually see how far you have to go to 'beat' the decay. Keep in mind that since apprentice rep is stuck in the totals, you'll have to exceed '0' Net to offset your apprentices.
..albeit a little depressing.


Top
 Profile  
 
 Post subject: Re: Tools -- Daily influence [online, dev]
PostPosted: Fri Mar 12, 2010 6:19 am 

Joined: Tue Jan 22, 2008 11:21 am
Posts: 569
Faction: Flight School
Offline
Thank you, sir, for the awesomeness.

_________________
Image
Image


Top
 Profile  
 
 Post subject: Re: Tools -- Daily influence [online, dev]
PostPosted: Fri Mar 12, 2010 11:55 am 
Developer

Joined: Tue Dec 12, 2006 7:05 am
Posts: 3635
Location: Skybrary Archives
Offline
Dead Cloud wrote:
Thank you, sir, for the awesomeness.
Suddenly, this just popped to mind: http://knowyourmeme.com/memes/im-sorry- ... esome-i-am


Top
 Profile  
 
 Post subject: Re: Tools -- Daily influence [online, stable]
PostPosted: Sun Mar 14, 2010 6:12 am 

Joined: Tue Jan 22, 2008 11:21 am
Posts: 569
Faction: Flight School
Offline
Awesomeness can be deafening.
:smile:

Calvin, I admire that quirky mind you have.

_________________
Image
Image


Top
 Profile  
 
 Post subject: Re: Tools -- Daily influence [online, stable]
PostPosted: Sun Mar 14, 2010 6:12 pm 
Developer

Joined: Tue Dec 12, 2006 7:05 am
Posts: 3635
Location: Skybrary Archives
Offline
Dead Cloud wrote:
Calvin, I admire that quirky mind you have.
/em bows.


Top
 Profile  
 
 Post subject: Re: Tools -- Daily influence [online, stable]
PostPosted: Wed Mar 17, 2010 1:17 am 
Moostro

Joined: Sat Dec 08, 2007 10:56 am
Posts: 795
Location: Vancouver, WA
Faction: Flight School
Offline
*** Decay hour changed.
Decay seems to be applying between 00:00 and 1:00 (am) us/pacific now, rather than between 22:00 and 23:00 (pm) us/pacific. This made gross inf calculations from 23:00 to 01:00 off. I have made a couple modification to allow for this new decay change exception, but it could still calc wrong if I didn't get my logic correct.

If you see numbers that appear too large, check for negative net numbers (there should almost always be SOMEBODY with negative, just sort the Net column.) If you see a minimum of '0' (zero) in Net, screen shot for me, or copy/past the first few *gross* leaders, as well as the reported stats run time from the top of the page.

(And don't worry, even if it suddenly became random-decay-change-times, I have ways I can make it deal with that. Hopefully it doesn't happen that way though, hehe.)

_________________
Senator nehp
http://skyrates.zosimple.net


Top
 Profile  
 
 Post subject: Re: Tools -- Dailies (inf, combat lvls, profits)[online, stable]
PostPosted: Wed Mar 24, 2010 6:16 pm 
Moostro

Joined: Sat Dec 08, 2007 10:56 am
Posts: 795
Location: Vancouver, WA
Faction: Flight School
Offline
*** Added combat levels (working fine), and profits (sometimes an individual is pretty notably off, read the note)

As I note above, the actual skyrates dailies do not run at 03:00am, they run over half an hour early. Until this is fixed, the skyrates.zo.com dailies will just be off a bit from the top10 on the skyrates dailies.

Also a nice current day split dailies (all three) has been added, and the skyrates.zo.com page updated with them all.

_________________
Senator nehp
http://skyrates.zosimple.net


Top
 Profile  
 
 Post subject: Re: Tools -- Dailies (inf, combat lvls, profits)[online, stable]
PostPosted: Thu Apr 22, 2010 10:35 pm 

Joined: Thu Jan 08, 2009 12:49 pm
Posts: 779
Faction: Azure League

Offline
Profit board suggestion, could we see a three or five day single ranking of profit? We have a lot of big traders who only make the trade boards every other day, a sample from a longer period would be more accurate.

_________________
Pilot-in-Command, Our Chief Export Is Violence III
Incarnation of Industry
Angels' wings are icing over, McDonnell Douglas olive drab. They bear the names of our sweethearts, and the captain smiles, as we crash.


Top
 Profile  
 
 Post subject: Re: Tools -- Dailies (inf, combat lvls, profits)[online, stable]
PostPosted: Fri Apr 23, 2010 12:17 am 
Moostro

Joined: Sat Dec 08, 2007 10:56 am
Posts: 795
Location: Vancouver, WA
Faction: Flight School
Offline
Amira Navaras wrote:
Profit board suggestion, could we see a three or five day single ranking of profit? We have a lot of big traders who only make the trade boards every other day, a sample from a longer period would be more accurate.


This is the long term plan, but I need to switch the storage method to a database and a few other rebuilds, and I just kind of put things on hold to see what was up with the event. I need to build a slightly more flexible system so we can explore variations to find what actually works nicely. After the event settles in, I'll go back and rebuild the backend so we can have some more fun with that, hehe.

_________________
Senator nehp
http://skyrates.zosimple.net


Top
 Profile  
 
 Post subject: Re: Tools -- Dailies (inf, combat lvls, profits)[online, sta
PostPosted: Mon Mar 28, 2011 9:59 am 
Legend

Joined: Wed Jan 23, 2008 9:51 am
Posts: 1481
Location: Cynoscephalae
Faction: Court of Violets

Offline
Hey nehp, can we get a column for manual kills in addition to levels on the dailies? If it helps, the dynarank query for kills is manual only, not AR, so seems like this should be fairly easy.


Top
 Profile  
 
 Post subject: Re: Tools -- Dailies (inf, combat lvls, profits)[online, sta
PostPosted: Mon Mar 28, 2011 1:35 pm 
Legend

Joined: Wed Jan 23, 2008 9:51 am
Posts: 1481
Location: Cynoscephalae
Faction: Court of Violets

Offline
Wow, that was fast: http://skyrates.zo.com/dailies/kills-daily-100.html

One issue, though: it appears to be using the Dynarank query "Total Kills" for the totals, which includes auto-resolved kills. Can it be switched to the query "Kills", which is just manual, or at least, separate the two?


Top
 Profile  
 
 Post subject: Re: Tools -- Dailies (inf, combat lvls, profits)[online, sta
PostPosted: Mon Mar 28, 2011 9:50 pm 
Moostro

Joined: Sat Dec 08, 2007 10:56 am
Posts: 795
Location: Vancouver, WA
Faction: Flight School
Offline
Zabrak! wrote:
Wow, that was fast: http://skyrates.zo.com/dailies/kills-daily-100.html

One issue, though: it appears to be using the Dynarank query "Total Kills" for the totals, which includes auto-resolved kills. Can it be switched to the query "Kills", which is just manual, or at least, separate the two?



Adjusted.

http://skyrates.zo.com/dailies/kills-daily.html
http://skyrates.zo.com/dailies/kills-daily-100.html

and added to http://skyrates.zo.com

I'm leaving them out of the footer for now, since I'd like to see more about merging the combat pages rather than just adding extra tables.

_________________
Senator nehp
http://skyrates.zosimple.net


Top
 Profile  
 
 Post subject: Re: Tools -- Dailies (inf, combat lvls, profits)[online, sta
PostPosted: Mon Mar 28, 2011 11:21 pm 
Moostro

Joined: Sat Dec 08, 2007 10:56 am
Posts: 795
Location: Vancouver, WA
Faction: Flight School
Offline
Further adjustments:

I've added the average level (lvl/K) to the regular combat page (on the wide table, so current on short form, and both on long form.)

I've added the true manual kill / HR to the new kills combat page (also on the wide tables.)

Give these a looksee and tell me how they seem to be working, this is some changes in the modular system that should let me manipulate the tables, but I haven't tested it extensively yet.

_________________
Senator nehp
http://skyrates.zosimple.net


Top
 Profile  
 
 Post subject: Re: Tools -- Dailies (inf, combat lvls, profits)[online, sta
PostPosted: Sun Apr 03, 2011 12:45 am 

Joined: Fri Feb 06, 2009 9:37 pm
Posts: 84
Faction: Flight School
Offline
Yesterday's kills/hour isn't being divided by 24. Rather, it's being divided by the same number as today's kills/hour.

That is to say, if it's 20 hours in, then both today's and yesterday's kills are divided by 20.

_________________
http://skyrates.wikia.com/wiki/User:Kasarn
http://vimeo.com/3910012


Top
 Profile  
 
 Post subject: Re: Tools -- Dailies (inf, combat lvls, profits)[online, sta
PostPosted: Sun Apr 03, 2011 3:18 am 
True Friend

Joined: Tue May 12, 2009 12:52 pm
Posts: 80
Faction: Crimson Armada

Offline
Arikatas wrote:
Yesterday's kills/hour isn't being divided by 24. Rather, it's being divided by the same number as today's kills/hour.

That is to say, if it's 20 hours in, then both today's and yesterday's kills are divided by 20.


So that explains why the numbers kept changing on me while I was trying to figure things out on my thread.


Top
 Profile  
 
 Post subject: Re: Tools -- Dailies (inf, combat lvls, profits)[online, sta
PostPosted: Sun Apr 03, 2011 10:53 am 
Moostro

Joined: Sat Dec 08, 2007 10:56 am
Posts: 795
Location: Vancouver, WA
Faction: Flight School
Offline
Arikatas wrote:
Yesterday's kills/hour isn't being divided by 24. Rather, it's being divided by the same number as today's kills/hour.

That is to say, if it's 20 hours in, then both today's and yesterday's kills are divided by 20.


Corrected

_________________
Senator nehp
http://skyrates.zosimple.net


Top
 Profile  
 
 Post subject: Re: Tools -- Dailies (inf, combat lvls, profits)[online, sta
PostPosted: Sun Apr 03, 2011 2:35 pm 

Joined: Wed Apr 23, 2008 5:30 am
Posts: 38
Location: Greece
Faction: Flight School
Offline
The inf dailies may also have a slight problem. They currently show me as having run 91,003 inf so far today, while the only single mission I'm sure I finished after the update is a whale for 108,057.

_________________
Red or dead


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 30 posts ]  Go to page 1, 2  Next

All times are UTC - 8 hours


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group