1. #1

    Red face Outpost Fight Statistics 7/30 - 10/2

    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)
    Attached Files Attached Files
    Last edited by EvilHogg; 03-10-15 at 21:16.

  2. #2

    Default

    Nice to see the API being put to use

    Maybe you could team up with Brammers or LG and put it on the websites?
    If you want to fix the game, start with the most essential part: The Community...
    Quote Originally Posted by Danae
    <&Danae> i don't like anything that's furry, totally dependant on me, and shits and pisses in sneaky places
    <&Danae> i have kids, i don't need pets ^^

  3. #3
    i carry a laaaazer......blade gstyle40's Avatar
    Join Date
    July 2004
    Location
    Stuck on a m'fn plane wit some m'fn snakes ><
    Posts
    402

    Default

    i think that just about sums it up lol. Good job Hogg! was wonderin what all that info u were sittin on was about
    [Signature removed - please see the forum rules on signature sizes]

  4. #4

    Default

    cool stuff indeed !
    Maybe one day we could have Neocron kill mails just like in eve online ? )

  5. #5
    Xpertz William Antrim's Avatar
    Join Date
    November 2005
    Location
    Norfolk.
    Posts
    4,112

    Default

    Can it tell you numbers per side? Like 6v6 or 15v15 or whatever or does it just count the "zerg" vs "normal" fights?
    "dulce et decorum est pro patria mori"

  6. #6

    Default

    Loled on this one hard...

    After all these years.. do ppl still dont get it? The fight is what matters not the Outposts taken...
    Last edited by Hackebeil; 19-10-15 at 15:25.

  7. #7

    Default

    Nice to see good work, very interesting to see
    Just a side reminder though, ppl. online is not really meaningful since every member tends to have at least 1 dual log.

  8. #8

    Default

    Quote Originally Posted by Hackebeil View Post
    Loled on this one hard...

    After all these years.. do ppl still dont get it? The fight is what matters not the Outposts taken...
    hey, nice.
    subms - reaps - aesthetics

  9. #9

    Default

    Where is that api?

  10. #10
    Final Boss of the Internet Kanedax's Avatar
    Join Date
    March 2007
    Location
    Tampa, FL
    Posts
    917

    Default

    Zerg, zerg never changes.

  11. #11
    i carry a laaaazer......blade gstyle40's Avatar
    Join Date
    July 2004
    Location
    Stuck on a m'fn plane wit some m'fn snakes ><
    Posts
    402

    Default

    stats dont lie lol. from what i see 1 clan mainly ninja's or zergs, and lost more fights even when they have the advantage.
    [Signature removed - please see the forum rules on signature sizes]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •