EvilHogg
03-10-15, 21:06
Been keeping track of outpost fighting statistics using the API, just wanted to share. The full results are in the attached text file, though here are some highlights. Just a note, the ninja and zerg formulas were edited a few times....so there are likely more zergs and ninjas than what appear in the results. There is a lot of info here that I compiled pretty quick so there are likely a few mistakes below. If I catch them ill edit/fix them.
Please keep in mind I can only grab this data when an outpost changes ownership. I cannot keep track of successful defenses and other skirmishes. In summary, we all suck :)
SoaD
Record 89W 79L
"fair" wins - 4 (Fights where SoaD won when the enemy had at least 2 players online. Both clans were within 2 players of each others numbers.)
"fair" losses - 8 (same as above, but where SoaD lost)
Outposts SoaD has taken where they won with less people online than the enemy:
mysql> select * from fight_result where clanwin = "SoaD" and clanwin_online < clanlose_online;
Empty set (0.00 sec)
Outposts SoaD has taken where they won with more people online than the enemy:
mysql> select * from fight_result where clanwin = "SoaD" and clanwin_online > clanlose_online;
87 rows in set (0.01 sec)
Outposts SoaD has taken where the enemy had 1 person or less online:
mysql> select * from fight_result where clanwin = "SoaD" and ninja = 1;
48 rows in set (0.00 sec)
Outposts SoaD has taken where they had at least 5 more than the opponent:
mysql> select * from fight_result where clanwin = "SoaD" and (clanwin_online - clanlose_online) > 4;
60 rows in set (0.00 sec)
Most often SoaD wins against: (winning clan online vs losing clan online)
Wolf Pack - 30 wins (an average of 8.9 vs 2.2)
-=fcuk=- - 23 wins (an average of 8.4 vs 2.6)
-GP- - 20 wins (an average of 10.9 vs 6.2)
Most often SoaD loses to: (winning clan online vs losing clan online)
Wolf Pack - 31 losses (an average of 7.2 vs 4.9)
-GP- - 25 losses ( an average of 8.0 vs 6.8)
-=fcuk=- - 21 losses (an average of 6.0 vs 3.6)
-GP-
Record 31W 27L
"fair" wins - 2
"fair" losses - 1
Outposts -GP- has taken where they won with less people online than the enemy:
mysql> select * from fight_result where clanwin = "-GP-" and clanwin_online < clanlose_online;
8 rows in set (0.00 sec)
Outposts -GP- has taken where they won with more people online than the enemy:
mysql> select * from fight_result where clanwin = "-GP-" and clanwin_online > clanlose_online;
21 rows in set (0.00 sec)
Outposts -GP- has taken where the enemy had 1 person or less online:
mysql> select * from fight_result where clanwin = "-GP-" and ninja = 1;
1 row in set (0.01 sec)
Outposts -GP- has taken where they had at least 5 more than the opponent:
mysql> select * from fight_result where clanwin = "-GP-" and (clanwin_online - clanlose_online) > 4;
9 rows in set (0.00 sec)
Most often -GP- wins against: (winning clan online vs losing clan online)
SoaD - 25 wins (an average of 8.0 vs 6.8)
-=fcuk=- - 3 wins (an average of 9.0 vs 1.3)
Wolf Pack - 2 wins (an average of 5.0 vs 0)
Most often -GP- loses to: (winning clan online vs losing clan online)
SoaD - 20 losses (an average of 10.9 vs 6.2)
-=fcuk=- - 5 losses (an average of 7.4 vs 1.6)
Wolf Pack - 1 losses (an average of 3 vs 0)
** wolf pack**
Record: 33W 33L
"fair" wins - 4
"fair" losses - 1
Outposts **wolf pack** has taken where they won with less people online than the enemy:
mysql> select * from fight_result where clanwin = "**wolf pack**" and clanwin_online < clanlose_online;
5 rows in set (0.00 sec)
Outposts **wolf pack** has taken where they won with more people online than the enemy:
mysql> select * from fight_result where clanwin = "**wolf pack**" and clanwin_online > clanlose_online;
23 rows in set (0.00 sec)
Outposts **wolf pack** has taken where the enemy had 1 person or less online:
mysql> select * from fight_result where clanwin = "**wolf pack**" and ninja = 1;
9 rows in set (0.00 sec)
Outposts **wolf pack** has taken where they had at least 5 more than the opponent:
mysql> select * from fight_result where clanwin = "**wolf pack**" and (clanwin_online - clanlose_online) > 4;
7 rows in set (0.00 sec)
Most often **wolf pack** wins against: (winning clan online vs losing clan online)
SoaD - 31 wins (an average of 7.2 vs 4.9)
-GP- - 1 wins (an average of 3.0 vs 0)
-=fcuk=- - 0 wins (allies)
Most often **wolf pack** loses to: (winning clan online vs losing clan online)
SoaD - 30 losses (an average of 8.9 vs 2.2)
-GP- - 2 losses (an average of 5.0 vs 0.0)
-=fcuk=- - 0 losses (allies)
-=fcuk=-
Record 26W 26L
"fair" wins - 2
"fair" losses - 2
Outposts -=fcuk=- has taken where they won with less people online than the enemy:
mysql> select * from fight_result where clanwin = "-=fcuk=-" and clanwin_online < clanlose_online;
5 rows in set (0.00 sec)
Outposts -=fcuk=- has taken where they won with more people online than the enemy:
mysql> select * from fight_result where clanwin = "-=fcuk=-" and clanwin_online > clanlose_online;
20 rows in set (0.00 sec)
Outposts -=fcuk=- has taken where the enemy had 1 person or less online:
mysql> select * from fight_result where clanwin = "-=fcuk=-" and ninja = 1;
2 rows in set (0.00 sec)
Outposts -=fcuk=- has taken where they had at least 5 more than the opponent:
mysql> select * from fight_result where clanwin = "-=fcuk=-" and (clanwin_online - clanlose_online) > 4;
12 row in set (0.00 sec)
Most often -=fcuk=- wins against: (winning clan online vs losing clan online)
SoaD - 21 wins (an average of 6.0 vs 3.6)
-GP- - 5 wins (an average of 7.4 vs 1.6)
Wolf Pack - 0 wins (allies)
Most often -=fcuk=- loses to: (winning clan online vs losing clan online)
SoaD - 23 losses (an average of 8.4 vs 2.6)
-GP- - 3 losses (an average of 9.0 vs 1.3)
Wolf Pack - 0 losses (allies)
Please keep in mind I can only grab this data when an outpost changes ownership. I cannot keep track of successful defenses and other skirmishes. In summary, we all suck :)
SoaD
Record 89W 79L
"fair" wins - 4 (Fights where SoaD won when the enemy had at least 2 players online. Both clans were within 2 players of each others numbers.)
"fair" losses - 8 (same as above, but where SoaD lost)
Outposts SoaD has taken where they won with less people online than the enemy:
mysql> select * from fight_result where clanwin = "SoaD" and clanwin_online < clanlose_online;
Empty set (0.00 sec)
Outposts SoaD has taken where they won with more people online than the enemy:
mysql> select * from fight_result where clanwin = "SoaD" and clanwin_online > clanlose_online;
87 rows in set (0.01 sec)
Outposts SoaD has taken where the enemy had 1 person or less online:
mysql> select * from fight_result where clanwin = "SoaD" and ninja = 1;
48 rows in set (0.00 sec)
Outposts SoaD has taken where they had at least 5 more than the opponent:
mysql> select * from fight_result where clanwin = "SoaD" and (clanwin_online - clanlose_online) > 4;
60 rows in set (0.00 sec)
Most often SoaD wins against: (winning clan online vs losing clan online)
Wolf Pack - 30 wins (an average of 8.9 vs 2.2)
-=fcuk=- - 23 wins (an average of 8.4 vs 2.6)
-GP- - 20 wins (an average of 10.9 vs 6.2)
Most often SoaD loses to: (winning clan online vs losing clan online)
Wolf Pack - 31 losses (an average of 7.2 vs 4.9)
-GP- - 25 losses ( an average of 8.0 vs 6.8)
-=fcuk=- - 21 losses (an average of 6.0 vs 3.6)
-GP-
Record 31W 27L
"fair" wins - 2
"fair" losses - 1
Outposts -GP- has taken where they won with less people online than the enemy:
mysql> select * from fight_result where clanwin = "-GP-" and clanwin_online < clanlose_online;
8 rows in set (0.00 sec)
Outposts -GP- has taken where they won with more people online than the enemy:
mysql> select * from fight_result where clanwin = "-GP-" and clanwin_online > clanlose_online;
21 rows in set (0.00 sec)
Outposts -GP- has taken where the enemy had 1 person or less online:
mysql> select * from fight_result where clanwin = "-GP-" and ninja = 1;
1 row in set (0.01 sec)
Outposts -GP- has taken where they had at least 5 more than the opponent:
mysql> select * from fight_result where clanwin = "-GP-" and (clanwin_online - clanlose_online) > 4;
9 rows in set (0.00 sec)
Most often -GP- wins against: (winning clan online vs losing clan online)
SoaD - 25 wins (an average of 8.0 vs 6.8)
-=fcuk=- - 3 wins (an average of 9.0 vs 1.3)
Wolf Pack - 2 wins (an average of 5.0 vs 0)
Most often -GP- loses to: (winning clan online vs losing clan online)
SoaD - 20 losses (an average of 10.9 vs 6.2)
-=fcuk=- - 5 losses (an average of 7.4 vs 1.6)
Wolf Pack - 1 losses (an average of 3 vs 0)
** wolf pack**
Record: 33W 33L
"fair" wins - 4
"fair" losses - 1
Outposts **wolf pack** has taken where they won with less people online than the enemy:
mysql> select * from fight_result where clanwin = "**wolf pack**" and clanwin_online < clanlose_online;
5 rows in set (0.00 sec)
Outposts **wolf pack** has taken where they won with more people online than the enemy:
mysql> select * from fight_result where clanwin = "**wolf pack**" and clanwin_online > clanlose_online;
23 rows in set (0.00 sec)
Outposts **wolf pack** has taken where the enemy had 1 person or less online:
mysql> select * from fight_result where clanwin = "**wolf pack**" and ninja = 1;
9 rows in set (0.00 sec)
Outposts **wolf pack** has taken where they had at least 5 more than the opponent:
mysql> select * from fight_result where clanwin = "**wolf pack**" and (clanwin_online - clanlose_online) > 4;
7 rows in set (0.00 sec)
Most often **wolf pack** wins against: (winning clan online vs losing clan online)
SoaD - 31 wins (an average of 7.2 vs 4.9)
-GP- - 1 wins (an average of 3.0 vs 0)
-=fcuk=- - 0 wins (allies)
Most often **wolf pack** loses to: (winning clan online vs losing clan online)
SoaD - 30 losses (an average of 8.9 vs 2.2)
-GP- - 2 losses (an average of 5.0 vs 0.0)
-=fcuk=- - 0 losses (allies)
-=fcuk=-
Record 26W 26L
"fair" wins - 2
"fair" losses - 2
Outposts -=fcuk=- has taken where they won with less people online than the enemy:
mysql> select * from fight_result where clanwin = "-=fcuk=-" and clanwin_online < clanlose_online;
5 rows in set (0.00 sec)
Outposts -=fcuk=- has taken where they won with more people online than the enemy:
mysql> select * from fight_result where clanwin = "-=fcuk=-" and clanwin_online > clanlose_online;
20 rows in set (0.00 sec)
Outposts -=fcuk=- has taken where the enemy had 1 person or less online:
mysql> select * from fight_result where clanwin = "-=fcuk=-" and ninja = 1;
2 rows in set (0.00 sec)
Outposts -=fcuk=- has taken where they had at least 5 more than the opponent:
mysql> select * from fight_result where clanwin = "-=fcuk=-" and (clanwin_online - clanlose_online) > 4;
12 row in set (0.00 sec)
Most often -=fcuk=- wins against: (winning clan online vs losing clan online)
SoaD - 21 wins (an average of 6.0 vs 3.6)
-GP- - 5 wins (an average of 7.4 vs 1.6)
Wolf Pack - 0 wins (allies)
Most often -=fcuk=- loses to: (winning clan online vs losing clan online)
SoaD - 23 losses (an average of 8.4 vs 2.6)
-GP- - 3 losses (an average of 9.0 vs 1.3)
Wolf Pack - 0 losses (allies)