Global player stats info

angrygamer

angrygamer

Ascalonian Squire

Join Date: Oct 2007

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?

Ctb

Desert Nomad

Join Date: Apr 2006

W/

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...

Drop of Fear

Drop of Fear

Forge Runner

Join Date: Nov 2006

W/

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

Zerdikus

Ascalonian Squire

Join Date: May 2008

Dragon Templar

D/E

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.

Drop of Fear

Drop of Fear

Forge Runner

Join Date: Nov 2006

W/

with technology i meant more like "technicaly able to do it."
might be fun to do it once in a while tho, before gw2 ^

Esan

Esan

Jungle Guide

Join Date: Jul 2007

Wars

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

Ascalonian Squire

Join Date: May 2008

Dragon Templar

D/E

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.

Ctb

Desert Nomad

Join Date: Apr 2006

W/

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.
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.

Zerdikus

Ascalonian Squire

Join Date: May 2008

Dragon Templar

D/E

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.
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.

Michael805

Michael805

Frost Gate Guardian

Join Date: Jan 2006

Going Out Of Business Sale [GWII]

A/W

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.
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 in the chat box anyway, you could just simply draw the information from that and store it in a file until it is needed.

Zerdikus

Ascalonian Squire

Join Date: May 2008

Dragon Templar

D/E

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 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 (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

Michael805

Frost Gate Guardian

Join Date: Jan 2006

Going Out Of Business Sale [GWII]

A/W

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.
I have no idea what the bold part is supposed to say.

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

Ascalonian Squire

Join Date: May 2008

Dragon Templar

D/E

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.

Musei Karasu

Lion's Arch Merchant

Join Date: Nov 2007

Mo/

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();
That code can easily execute on my computer several thousand times in a second. Let's assume that there's 5million players, since there was recently a thread about how NCSoft has now sold 5million copies of GW. It would take this code less than a minute to execute, and calcuate that for each title. So we can say since there's 36 titles, that it'd likely take 36 minutes or so to compile this little bit of data. Here's the easy part, once you have the list, just do title++ every time someone earns the title. It'll take less than a second. Definately not lag causing.

pOmrAkkUn

pOmrAkkUn

Desert Nomad

Join Date: Oct 2005

Bangkok

Me/Mo

that would be nice! I wanna know about top rank PvP titles, who is leading on each title too xD

Alex the Great

Alex the Great

Jungle Guide

Join Date: Feb 2007

America.....got a problem with that?

[Lite]

W/

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

Sethellington

Jungle Guide

Join Date: Sep 2005

nn

N/

i like the idea. i like numbers and graphs haha.

mazza558

Lion's Arch Merchant

Join Date: Mar 2006

R/

/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?

Zerdikus

Ascalonian Squire

Join Date: May 2008

Dragon Templar

D/E

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();
That code can easily execute on my computer several thousand times in a second. Let's assume that there's 5million players, since there was recently a thread about how NCSoft has now sold 5million copies of GW. It would take this code less than a minute to execute, and calcuate that for each title. So we can say since there's 36 titles, that it'd likely take 36 minutes or so to compile this little bit of data. Here's the easy part, once you have the list, just do title++ every time someone earns the title. It'll take less than a second. Definately not lag causing.
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.

Diddy bow

Diddy bow

Furnace Stoker

Join Date: Oct 2006

Jawsome!!!!!!!!!!!

looking for one :p

A/D

As cool as it would be i doubt its possible or cost worthly for A-net, we can hope though ^^.

vixro

Lion's Arch Merchant

Join Date: Apr 2006

Stranded Among New Players [SANP]

Mo/

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.

Crom The Pale

Crom The Pale

Furnace Stoker

Join Date: Nov 2006

Ageis Ascending

W/

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...

Burst Cancel

Burst Cancel

Desert Nomad

Join Date: Dec 2006

Domain of Broken Game Mechanics

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.
(emphasis added). The bolded assertion is almost certainly true.

pumpkin pie

pumpkin pie

Furnace Stoker

Join Date: Jul 2006

behind you

bumble bee

E/

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.

lutz

Jungle Guide

Join Date: Apr 2006

Battery Powered Best Friends [Vibe]

Me/

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.

Drop of Fear

Drop of Fear

Forge Runner

Join Date: Nov 2006

W/

Quote:
Originally Posted by Burst Cancel
(emphasis added). The bolded assertion is almost certainly true.
hence the need for kobd r7

pumpkin pie

pumpkin pie

Furnace Stoker

Join Date: Jul 2006

behind you

bumble bee

E/

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

Lagg

Wilds Pathfinder

Join Date: Jun 2005

W/

There are far more urgent issues to worry about.

And why has this thread not been banished to Sardelac yet?

Alexandra-Sweet

Alexandra-Sweet

Wilds Pathfinder

Join Date: Dec 2006

That one place with the trees, mountains and snow

Ember Power Mercenaries [EMP]

Me/

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.

Arduin

Arduin

Grotto Attendant

Join Date: May 2005

The Netherlands

Limburgse Jagers [LJ]

R/

GWChars.de does the job, player made though.

Abedeus

Abedeus

Grotto Attendant

Join Date: Jan 2007

Niflheim

R/

Yeah, because everyone can read and use German perfectly.

Arduin

Arduin

Grotto Attendant

Join Date: May 2005

The Netherlands

Limburgse Jagers [LJ]

R/

Quote:
Originally Posted by Abedeus
Yeah, because everyone can read and use German perfectly.


, or you would be having any problems with English, that is.

Musei Karasu

Lion's Arch Merchant

Join Date: Nov 2007

Mo/

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.
Actually I wrote that in Java. Yes, no one knows what exactly the database looks like, but honestly, think about this logically. What's the likelihood they don't have a way to access all the variables on a character? What's the likelihood they don't have a way to grab that data?

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.