Page 1 of 1

DB Query

Posted: Wed Mar 26, 2008 3:20 pm
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.

Re: DB Query

Posted: Wed Mar 26, 2008 9:44 pm
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.

Re: DB Query

Posted: Fri Mar 28, 2008 6:24 am
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?

Re: DB Query

Posted: Fri Mar 28, 2008 3:02 pm
by Flathead74
Have you tried kakaostats?

Re: DB Query

Posted: Fri Mar 28, 2008 4:31 pm
by MstrBlstr
Did you take a look at the FCI stats script?

Or are you just wanting to program something simpler yourself?

Re: DB Query

Posted: Fri Mar 28, 2008 11:54 pm
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.

Re: DB Query

Posted: Sat Mar 29, 2008 12:07 am
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?

Re: DB Query

Posted: Wed Apr 02, 2008 8:40 am
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

Re: DB Query

Posted: Fri Apr 04, 2008 10:28 am
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.