Global player stats info
angrygamer
I used to play a game called America's Army (AA). I know many of you are familiar with it. On the game's home page, there's a little area where they display statistics on various levels of player achievement, expressed as percentages of the game's population: americasarmy.com (check the "User Stats" section, lower left)
For example, you could see that 20% of all AA players, globally, had achieved a marksmanship score of "Expert".
With as many title tracks as there are in GW, I figured they would have something similar at the GW website, but I was unable to locate anything.
I think it would be interesting, at least on a trivial level, to see similar statistics for the GW player base. For example:
- Percentage of players who have obtained Kind of a Big Deal
- Percentage of players who have maxed the Sweet Tooth track
- Percentage of players who have exceeded 1 million XP or 5 million XP, etc
Has anyone seen such information, either at the GW site or elsewhere?
For example, you could see that 20% of all AA players, globally, had achieved a marksmanship score of "Expert".
With as many title tracks as there are in GW, I figured they would have something similar at the GW website, but I was unable to locate anything.
I think it would be interesting, at least on a trivial level, to see similar statistics for the GW player base. For example:
- Percentage of players who have obtained Kind of a Big Deal
- Percentage of players who have maxed the Sweet Tooth track
- Percentage of players who have exceeded 1 million XP or 5 million XP, etc
Has anyone seen such information, either at the GW site or elsewhere?
Ctb
I hate that game. I never understood what they were telling me to do in the last training exercise so I always got frustrated and shot the CO.
I'm probably not prime military material...
I'm probably not prime military material...
Drop of Fear
pretty sure a.net has the technology to draw any stats about the players.
after the nightfall preview weekend there was even a chart on guildwars.com about the sunspear title, with names and the exact amount of points people top 20 people had
after the nightfall preview weekend there was even a chart on guildwars.com about the sunspear title, with names and the exact amount of points people top 20 people had
Zerdikus
what for a technology, the only what you need is a php script how can read the database, more not. the permission to do that, and a website how you can write it. not so much technology or?
but i think a problem if you make this, will be the server down if you make a daily refresh of the website. by so many players i think the server performance will be go dramatically down, if you read the database for all players and interesting stats.
but i think a problem if you make this, will be the server down if you make a daily refresh of the website. by so many players i think the server performance will be go dramatically down, if you read the database for all players and interesting stats.
Drop of Fear
with technology i meant more like "technicaly able to do it."
might be fun to do it once in a while tho, before gw2 ^
might be fun to do it once in a while tho, before gw2 ^
Esan
Yeah, they should do this. It would be nice to have figures to back up my impression that the number of GWAMMs is now in the thousands.
Zerdikus
can you imagine, there are 3-4 millions player and by only 4 stats for every player
that's are 12-16 millions accesses on the database, more to the normal accesses.
if you like, a massively lag about a intervall for a half to a hour every day,
maybe with login problems, so i think it's not a problem to do this.
that's are 12-16 millions accesses on the database, more to the normal accesses.
if you like, a massively lag about a intervall for a half to a hour every day,
maybe with login problems, so i think it's not a problem to do this.
Ctb
Quote:
Originally Posted by Zerdikus
if you like, a massively lag about a intervall for a half to a hour, every day. maybe with login problems. so i think it's not a problem to do this.
|
Zerdikus
Quote:
Originally Posted by Ctb
So don't run the reports using live data. This isn't the sort of reporting that requires or even really benefits from up-to-the-minute accounting anyway.
|
Michael805
Quote:
Originally Posted by Zerdikus
But you have a time of the day how you must report the data's if you like a daily list. in this time have you a massiv database transfer, that's fact. if you like a weekly list, so have it on one time in the week, etc.
|
Zerdikus
Quote:
Originally Posted by Michael805
They already pull thousands (actually, tens of thousands) of stats daily for the guild/HB ladders. What the OP is asking is for a percentage of people with a max title. The only time this could cause lag was the first day, really, because it would have to go through millions of accounts to check for maxed titles. Assuming this percentage is updated once daily, they simply would have to run a check to see how many people maxed each title that day... which would be easy since it's already displayed int he chat box anyway, you could just simply draw the information from that and store it in a file until it is needed.
|
the second case will be faster, in the first case (worst case) you have the 3-4 millions accesses. its a question about the structure of the database.
Ok, for the check how have max the title on this day. you need a seperate table in there you storage the information and the database query how ask this and store this in the table. this query must run in realtime, to collect the information. So you have only a table with playername and max title, thats right. But you have a realtime query how cost processortime and the question is, is the database after this stable.
Michael805
Quote:
Originally Posted by Zerdikus
the request must check all players in the database, if the stats have change or not. and this every time if you like to actualy your website. or must read the name of players how have max title in case it give a seperat table for the titles.
the second case will be faster, in the first case you have the 3-4 millions accesses. |
Look, I'll draw you a picture:
Original count -> count/number of accounts -> daily count of x title achieved (names do not matter, a simple little script that +1'd ever time a certain title was achieved would be plenty) -> Daily + original count + all the other daily counts (or count +1) -> that count/number of accounts = the percentage of people that got that title.
No millions of checks a day. And for the account numbers, they don't even have to be exact or close to exact, they could round it to the nearest 100,000 or so.
Zerdikus
Ok sorry my fault, i have understand wrong. I have think it's needed a website with playername and stats.
In this kind
Name Max Title
Player Name1 Kind of a Big Deal, Sweet Tooth track
Player Name2 Sweet Tooth track
etc.
A simple counter, is a other thing, okay. you become anyway a message ig, if have change a title to max. so will this easy to count.
In this kind
Name Max Title
Player Name1 Kind of a Big Deal, Sweet Tooth track
Player Name2 Sweet Tooth track
etc.
A simple counter, is a other thing, okay. you become anyway a message ig, if have change a title to max. so will this easy to count.
Musei Karasu
Code:
for(Player a : listOfPlayers) //let's assume that there's a list of all player accounts, which they should have. { if(hasTitle(KOABD)) //easy to write if they haven't already title++; } double avg = title/listOfPlayers.size();
pOmrAkkUn
that would be nice! I wanna know about top rank PvP titles, who is leading on each title too xD
Alex the Great
Quote:
Originally Posted by Ctb
I hate that game. I never understood what they were telling me to do in the last training exercise so I always got frustrated and shot the CO.
I'm probably not prime military material... |
I never finished the training either XD.
The Op's idea is alright, but not really needed.
Sethellington
i like the idea. i like numbers and graphs haha.
mazza558
/Signed.
I'd love this - it would give everyone an idea of the composition of the playerbase. Is there really an elite minority who browses forums and is very experienced, or is everyone in the game experienced?
I'd love this - it would give everyone an idea of the composition of the playerbase. Is there really an elite minority who browses forums and is very experienced, or is everyone in the game experienced?
Zerdikus
Quote:
Originally Posted by Musei Karasu
Code:
for(Player a : listOfPlayers) //let's assume that there's a list of all player accounts, which they should have. { if(hasTitle(KOABD)) //easy to write if they haven't already title++; } double avg = title/listOfPlayers.size(); |
like this EXEC SQL SELECT...
Nobody has a knowledge about the structure of the used database. maybe she have no table for titles,
maybe she have and this table have follow structure player_id, title_id, title_rang. The kind of the
sql query it's founded on the structure of the database.
If the table has this structure you need a query how read the needed title_id for KOABD in case if title_rang => 5.
If you like it more excat, you need more querys like this ... if title_rang => 5 and title_rang < 10,
title_rang => 10 and title_rang < 15 etc.
Try it and you will it realize. And for the first run you need a sql query, later you can maybe it realize
with a simple counter.
Diddy bow
As cool as it would be i doubt its possible or cost worthly for A-net, we can hope though ^^.
vixro
Maybe its an idea to be implemented into GW2 while its in developing stages.
While I also think it would be cool for GW, they wouldn't have to update it daily. As trivial as it is, you could update partial stats for each piece maybe a couple times per month. Spread out you could still get the same idea, without much server load.
While I also think it would be cool for GW, they wouldn't have to update it daily. As trivial as it is, you could update partial stats for each piece maybe a couple times per month. Spread out you could still get the same idea, without much server load.
Crom The Pale
It would also have to either restrict the display to single accounts or denote when a players has the title accross multiple chars.
There are more than a few people with KOBD on every char simply because they have 5 of the account wide titles maxed.
All that said I would like to know just how many God Among Mortals there are out there...
There are more than a few people with KOBD on every char simply because they have 5 of the account wide titles maxed.
All that said I would like to know just how many God Among Mortals there are out there...
Burst Cancel
Quote:
Originally Posted by Esan
It would be nice to have figures to back up my impression that the number of GWAMMs is now in the thousands.
|
pumpkin pie
A "PvE Player's Ladder" would be nice, like what they are doing here.
A list of all the players who have achieved God Walking Amongst Mere Mortals.
A list of all the players who have achieved God Walking Amongst Mere Mortals.
lutz
If Guild Wars does this, then the game is officially dead.
That would mean whoever spends the most time grinding titles gets recognized. Yay. This should never be the case. PvP is much more competitive than PvE, and will continue to be. If there is a "PvE ladder", Guild Wars will lose almost all support from its PvP community, and Guild Wars 2's "competitive side" will be almost entirely inactive.
There can never be a PvE ladder. What would be a good idea, though, is a PvP individuals ladder, where individuals can view their own stats and see what games they have won in which guilds, etc.
That would mean whoever spends the most time grinding titles gets recognized. Yay. This should never be the case. PvP is much more competitive than PvE, and will continue to be. If there is a "PvE ladder", Guild Wars will lose almost all support from its PvP community, and Guild Wars 2's "competitive side" will be almost entirely inactive.
There can never be a PvE ladder. What would be a good idea, though, is a PvP individuals ladder, where individuals can view their own stats and see what games they have won in which guilds, etc.
Drop of Fear
Quote:
Originally Posted by Burst Cancel
(emphasis added). The bolded assertion is almost certainly true.
|
pumpkin pie
Quote:
Originally Posted by lutz
If Guild Wars does this, then the game is officially dead.
That would mean whoever spends the most time grinding titles gets recognized. Yay. This should never be the case. PvP is much more competitive than PvE, and will continue to be. If there is a "PvE ladder", Guild Wars will lose almost all support from its PvP community, and Guild Wars 2's "competitive side" will be almost entirely inactive. There can never be a PvE ladder. What would be a good idea, though, is a PvP individuals ladder, where individuals can view their own stats and see what games they have won in which guilds, etc. |
there is no PvP without PvE players
Lagg
There are far more urgent issues to worry about.
And why has this thread not been banished to Sardelac yet?
And why has this thread not been banished to Sardelac yet?
Alexandra-Sweet
Displaying player names on a website that gets visited thousand~ times a day? The #1 player would probably get spammed with PMs, and maybe even have his/her account hacked.
/not signed.
/not signed.
Arduin
GWChars.de does the job, player made though.
Abedeus
Yeah, because everyone can read and use German perfectly.
Arduin
Musei Karasu
Quote:
Originally Posted by Zerdikus
it's a bit a difference on the performance between a simple c++ code and c++ code with sql querys,
like this EXEC SQL SELECT... Nobody has a knowledge about the structure of the used database. maybe she have no table for titles, maybe she have and this table have follow structure player_id, title_id, title_rang. The kind of the sql query it's founded on the structure of the database. If the table has this structure you need a query how read the needed title_id for KOABD in case if title_rang => 5. If you like it more excat, you need more querys like this ... if title_rang => 5 and title_rang < 10, title_rang => 10 and title_rang < 15 etc. Try it and you will it realize. And for the first run you need a sql query, later you can maybe it realize with a simple counter. |
Yes, I'm well aware of how a SQL database works. I work with one everyday. You can go on about tables and access data as much as you'd like, but at the end of the day it's all variables, and variables need to be accessed, can be counted, can be added, and can be manipulated. You've also made the mistake of assuming they use a mySQL database for GW, which I don't see where you could draw that assumption.