DB Query

This forum contains information about 3rd party applications which may be of use to those who run the FAH client and one place where you might be able to get help when using one of those apps.

Moderator: Site Moderators

Post Reply
real_ate
Posts: 4
Joined: Wed Mar 26, 2008 3:12 pm

DB Query

Post by real_ate »

Not sure if this is the right place to ask this but i'll give it a shot...

I'm just wondering, is there any way ( via a url or something ) to make a query about user/team statistics and get a result in xml? i noticed that it says "Please do not use scripts to access the donor or team pages, but use the full donor list" but that seems to just be a waste of bandwidth (on both sides) if someone was just interested in their one ( or two ) individual stats.
smartcat99s
Posts: 14
Joined: Sun Dec 02, 2007 7:32 pm

Re: DB Query

Post by smartcat99s »

At EOC (http://folding.extremeoverclocking.com/?nav=XML), you can request access to XML based stats that are updated every three hours. It's not available for all teams and users though.
Image
real_ate
Posts: 4
Joined: Wed Mar 26, 2008 3:12 pm

Re: DB Query

Post by real_ate »

thats pretty much exactly what i needed but still with another problem. the reason why i'm interested is because my team is just below the threshold of ones that EOC look at, well in fact very far below the threshold. So i reckoned that i could get the data myself and process my own team's data for my own website, i kinda need that data to present to a committee so that i might get a good part of 15000 ( my college ) people involved. People always like pretty pictures and those graphs ( which i could program myself ) would be what nail the deal for me.

so you see my problem. I guess then that there is no way to access that data directly from F@H servers then? no like really simple php scripts?
Flathead74
Posts: 266
Joined: Sun Dec 02, 2007 6:08 pm
Location: Central New York
Contact:

Re: DB Query

Post by Flathead74 »

Have you tried kakaostats?
MstrBlstr
Posts: 578
Joined: Thu Nov 29, 2007 7:03 pm
Location: Texas

Re: DB Query

Post by MstrBlstr »

Did you take a look at the FCI stats script?

Or are you just wanting to program something simpler yourself?
-=MB=-
real_ate
Posts: 4
Joined: Wed Mar 26, 2008 3:12 pm

Re: DB Query

Post by real_ate »

Flathead74 wrote:Have you tried kakaostats?
well for some strange reason the particular team that i'm interested in is not there :(
MstrBlstr wrote:Did you take a look at the FCI stats script?

Or are you just wanting to program something simpler yourself?
i was hoping to do something similar myself, the only difference being that i don't actually download the entire daily_team_summary.txt and daily_user_summary.txt files. My question was is there any query that we can make to the web server ( possibly via some url variables ) that would return only one line of those files ( or something similar in a xml format, but doing the xml is super easy yourself :D ). only returning part of the file will really reduce "unused" bandwidth.
anandhanju
Posts: 526
Joined: Mon Dec 03, 2007 4:33 am
Location: Australia

Re: DB Query

Post by anandhanju »

real_ate wrote:
Flathead74 wrote:Have you tried kakaostats?
well for some strange reason the particular team that i'm interested in is not there :(
http://kakaostats.com/tsum.php?t=116767
http://kakaostats.com/t.php?t=116767

Does this help?
real_ate
Posts: 4
Joined: Wed Mar 26, 2008 3:12 pm

Re: DB Query

Post by real_ate »

Yes that helps with regards to being able to get the data, but does not help with the ease of parsing or in fact with limiting traffic to their servers.
real_ate wrote:
MstrBlstr wrote:Did you take a look at the FCI stats script?

Or are you just wanting to program something simpler yourself?
i was hoping to do something similar myself
What i was really esquiring about was just the availability of some sort of download ( or query to the database ) that represented what a single line in the daily_team_summary.txt and daily_user_summary.txt files do. with a few requirements:
  • it must be easily parseable, making it easy for any old joe to make sense of the data in their own way i.e. xml
  • it must be concise, thus limiting the bandwidth/usage of the database server (unlike downloading the entire daily_X_summary.txt files
  • an easy query method i.e. just an example from the url that anandhanju gave http://kakaostats.com/tsum.php?t=116767&type=xml
Cajun_Don
Posts: 89
Joined: Sun Dec 02, 2007 7:05 pm
Location: Cajun Country, Louisiana
Contact:

Re: DB Query

Post by Cajun_Don »

real_ate wrote:Yes that helps with regards to being able to get the data, but does not help with the ease of parsing or in fact with limiting traffic to their servers.
real_ate wrote:
MstrBlstr wrote:Did you take a look at the FCI stats script?

Or are you just wanting to program something simpler yourself?
i was hoping to do something similar myself
What i was really esquiring about was just the availability of some sort of download ( or query to the database ) that represented what a single line in the daily_team_summary.txt and daily_user_summary.txt files do. with a few requirements:
  • it must be easily parseable, making it easy for any old joe to make sense of the data in their own way i.e. xml
  • it must be concise, thus limiting the bandwidth/usage of the database server (unlike downloading the entire daily_X_summary.txt files
  • an easy query method i.e. just an example from the url that anandhanju gave http://kakaostats.com/tsum.php?t=116767&type=xml
You can contact kakao on his forum. http://forum.kakaostats.com/ He might be able to help you. :D

Good luck.
Image

Have a great day.
Post Reply