Massive Assault Official Forum
   
It is currently Thu Oct 31, 2024 6:50 pm

All times are UTC - 5 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 13 posts ] 
Author Message
 Post subject: Data used in Battle and creating a database
PostPosted: Tue Oct 19, 2004 9:58 am 
Offline
Sea Wolf

Joined: Wed Jun 02, 2004 4:01 pm
Posts: 240
Karma: 0

Location: Lyon (France)
hello,


i have a look on differents datas (.dat) and way they are used (for instance in glyco forms.)

i do think it may be very usefull to use a Mysql database to store datas.
it would be easier to manipulate.

would it be possible to make a small database (you got one because you put phpbb on one) dedicated to clan war in a first step but with whole data.

i've thought of a MCD (if someone want to tell me his opinion on it, i can give in a model), i'm using DataBase Designor 4.

if your are not sure this is a good idea i will make one on rotm website and show data in order for you to have an idea.


i got some good idea (ex : different way to show battle results with graphics : gd library or flash/php grahics)

the actual glyco doesn't show many stats about number of battle win/loose with PL/FNU witch is an important indicator.

and it's acurate only with many battles.

_________________
let's play !

rotm clan website :
http://rotm.free.fr/


Top
 Profile  
 
 Post subject: Re: Data used in Battle and creating a database
PostPosted: Tue Oct 19, 2004 10:17 am 
Offline
Sea Wolf
User avatar

Joined: Sat Dec 13, 2003 3:06 am
Posts: 1338
Karma: 1

Location: USA
warchrisMA wrote:
the actual glyco doesn't show many stats about number of battle win/loose with PL/FNU witch is an important indicator.

and it's acurate only with many battles.


Actually, we are using a modified version of Glicko that does keep track of PL vs FNU victories on a per map basis. These values are then averaged together to form our modified values.

Here are some excerpts from the Clan War rules:

"
i) The Glicko rating will use the Averaged Glicko approach as shown at
http://www.massiveassault.com/clans/nwo/allratings2.php .

ii) This rating will be modified only to include the following maps in the average: Emerald, Antarcticus, Craetus, Noble Rust, Anubis, and New Paradise.
"

The averaged Glicko does a better job of dividing games into comparable sets, but due to its averaging, it requires even more complete games to be accurate.

_________________
Founder of The New World Order, and moderator for the Andromeda Clan War.

NWO website:
http://www.freewebs.com/massiveassault-nwo/index.htm

Clan War website:
http://www.massiveassault.com/clans/nwo/ClanWar


Top
 Profile  
 
 Post subject:
PostPosted: Tue Oct 19, 2004 11:16 am 
Offline
Sea Wolf

Joined: Wed Jun 02, 2004 4:01 pm
Posts: 240
Karma: 0

Location: Lyon (France)
i didn't mean, glyco wasn't good ('cause i was talking of glyco2...)

i meant that a player can't easily answer to those simple question :

how many battle i've player with FNU or PL ?
how many battle i've played with player x ?

how many battle i've won with players with glyco rating higher than 1800 on crateus.

the only way is to read 100 lines and counting....

_________________
let's play !

rotm clan website :
http://rotm.free.fr/


Top
 Profile  
 
 Post subject:
PostPosted: Tue Oct 19, 2004 11:38 am 
Offline
Sea Wolf
User avatar

Joined: Sun May 23, 2004 2:47 am
Posts: 280
Karma: 0

Location: Phoenix AZ
Speaking of the glicko, I think we should require a minimum number of games played before entering clan wars. There is a dramatic difference in the number of units you start with compairing the best and worst player. A player who has not established their glicko score will unbalance the wars by making their clan either very strong or very weak.

This does not stop anyone from entering, just makes them play some games before. Their clan mates could challenge them and establish a statistically sound glicko pretty fast.

_________________
"It's the little things that separate the good from the great"

http://www.freewebs.com/7thwanzer


Top
 Profile  
 
 Post subject:
PostPosted: Tue Oct 19, 2004 11:44 am 
Offline
Sea Wolf

Joined: Wed Jun 02, 2004 4:01 pm
Posts: 240
Karma: 0

Location: Lyon (France)
i agree with you but it is very difficult to say how many battle to have done to be acurate.

if you consider 100 battles for each map...
you got many battles and may be only Marshall...

if you say 10 battles each MAP (near 100) : it's not realy acurate...

_________________
let's play !

rotm clan website :
http://rotm.free.fr/


Top
 Profile  
 
 Post subject:
PostPosted: Tue Oct 19, 2004 11:52 am 
Offline
Sea Wolf
User avatar

Joined: Sun May 23, 2004 2:47 am
Posts: 280
Karma: 0

Location: Phoenix AZ
I don't think we need to be crazy about this. Lets say 30 total games on the maps(not on each map) used to put together the average would be enough. The big fear is a new player lik Madjazz comes around who had few games before the world champioship tourney. His glicko rating put him in the 300s, where after all the tourney games he is 33 and from what I saw will continue to improve. Him playing at the beginning of his career would have gave his team a large advantage in units. He was in the 30s after around 30 games. For that matter, I did the same thing. I started ranked very low, but advanced quickly based on my past wargame experience.

We don't need to be perfect here since prices are adjusted over time, but we should have folks starting the wars with glickos in the right order of magnitude.

_________________
"It's the little things that separate the good from the great"

http://www.freewebs.com/7thwanzer


Top
 Profile  
 
 Post subject: data's have been imported
PostPosted: Thu Oct 21, 2004 10:38 am 
Offline
Sea Wolf

Joined: Wed Jun 02, 2004 4:01 pm
Posts: 240
Karma: 0

Location: Lyon (France)
well, i got the feeling that data aren't complete.

i got coutries data but not all gif linked to those countries (the glyco takes gif on a part of the MAN server i can't see, i could do the same but it would no be efficient... so i try to get gif i need with glyco table...

see pb on rotm menu player list.
i got too many player (9600..) it's because many people (like me) has got 2 or 3 nickname.

that not the main pb.
for battles, i got near 30 000 , and battles should be near 44 000...
so :
1) programmer of Man has made counter begin near 10 000 to make people think many battles already played..
2) 10 000 battled of test that has been erased.
3) my data import isn't good (might be , i don't think so)
4) other reason

it can be several reason of those.


for 1st test it's gonna be ok.

_________________
let's play !

rotm clan website :
http://rotm.free.fr/


Top
 Profile  
 
 Post subject:
PostPosted: Thu Oct 21, 2004 10:44 am 
Offline
Sea Wolf
User avatar

Joined: Sun Mar 21, 2004 3:00 pm
Posts: 693
Karma: 0

Location: University of Tennessee, USA
Well, #1 is not a possibility, because people were around and playing long before I was, and my first game was #4500

On #2, it might have erased broken games as well, though I don't like the thought of there being 10,000 of them.....

_________________
Q: How many ADHD people does it take to change a lightbulb?

A: Oooh look, a kitty!!!


Top
 Profile  
 
 Post subject:
PostPosted: Thu Oct 21, 2004 2:23 pm 
Offline
Veteran
User avatar

Joined: Thu Jan 01, 2004 6:47 pm
Posts: 161
Karma: 0
Is the rating for the war the total rating or just the rating on games played against the other players in the war.

It might be more useful if it was just the relevant games, but I guess that might not give enough games to rate each player on.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Oct 21, 2004 2:59 pm 
Offline
Sea Wolf
User avatar

Joined: Sun Mar 21, 2004 3:00 pm
Posts: 693
Karma: 0

Location: University of Tennessee, USA
Total rating.

_________________
Q: How many ADHD people does it take to change a lightbulb?

A: Oooh look, a kitty!!!


Top
 Profile  
 
 Post subject:
PostPosted: Thu Oct 21, 2004 3:36 pm 
Offline
Sea Wolf

Joined: Thu Jan 15, 2004 8:50 am
Posts: 1443
Karma: 0
we might consider just using clan war ratings once we have some data to use :) (so not for a few wars)

_________________
Have fun, that's an order! If you win even better!!
Clan War Site: http://www.massiveassault.com/clans/nwo/ClanWar/

Dragonshard Fan Site: http://www.rpgplanet.com/dragonshard/


Top
 Profile  
 
 Post subject:
PostPosted: Thu Oct 21, 2004 8:12 pm 
Offline
Sea Wolf
User avatar

Joined: Sat Dec 13, 2003 3:06 am
Posts: 1338
Karma: 1

Location: USA
The problem with any kind of rating system is the amount of data we need to make an accurate rating. Its a particular problem with Massive Assault, as each game takes weeks to complete on average, and so we have so little data to work with from the beginning. Especially considering that battles on different planets have different levels of tactics and strategy, and are hard to group into one rating accurately.

MWigor uses a special rating system for Tournament seeding, which looks at glicko ratings, MA ratings, and performance in previous tournaments. With this amount of data to draw from it could possibly be more accurate than Glicko alone (especially since it looks at tournament results), but it will be difficult to make this rating easy to calculate for large numbers of people. Once the method is given a more digestible form, it may be a better solution.

_________________
Founder of The New World Order, and moderator for the Andromeda Clan War.

NWO website:
http://www.freewebs.com/massiveassault-nwo/index.htm

Clan War website:
http://www.massiveassault.com/clans/nwo/ClanWar


Top
 Profile  
 
 Post subject: Re: data's have been imported
PostPosted: Sun Oct 24, 2004 10:29 am 
Offline
Veteran
User avatar

Joined: Tue May 25, 2004 5:54 pm
Posts: 137
Karma: 0

Location: Russia, Rostov region
warchrisMA wrote:
i got coutries data but not all gif linked to those countries (the glyco takes gif on a part of the MAN server i can't see, i could do the same but it would no be efficient... so i try to get gif i need with glyco table...

Yes, not all countries have their gifs, even on MAN web server. Maybe I can help you on this matter. Contact me by email (vzverev@nm.ru) if you interested.


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 13 posts ] 

All times are UTC - 5 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:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Karma functions powered by Karma MOD © 2007, 2009 m157y