Verified:

Slagpit Game profile

Administrator
Game Development
5055

Jun 26th 2024, 15:31:36

We plan to add clan statistics to the game that represent a clan's achievements over all rounds of the game instead of just the current round. Ideally we would calculate statistics for previous rounds but we need to the community's help to associate past tags to the owning tag. Clan leaders for CURRENTLY ACTIVE clans may choose to participate in this thread by providing a list of tags that their clan owns. The list does not need to be comprehensive but please do not include any tags where ownership is in dispute. The data is due by July 11th and must be provided in the following format:

Round number-tag name
Round number-tag name
Round number-tag name


For example, if Evo wanted to participate they would make a post like the following in this thread:

1-EVOfoo
2-EVOata
3-EVOee
...
88-EvoDuff

Marc

Member
83

Jun 27th 2024, 1:47:12

Clan: GARGLE

Round 88 - GARGLE
<Earthnews> BR - Covid Booster 3 (#53) [GARGLE] -> Neal (#483) [iLaF] 6C 7B

Dark Demon Game profile

Game Moderator
EE Patron
Express
1891

Jun 27th 2024, 3:14:41

Demon/Whooze NBK FFA
Demon/symbolic/rasp Mercs 1a
Demon/symba darkness hunter d3rkness so many team
Mercs
Natural Born Killers

galleri Game profile

Game Moderator
Primary, Express, Tourney, & FFA
14,317

Jun 27th 2024, 17:49:41

Slagpit,
I think we need some clarification here. I have several thoughts on what you might be looking for. I believe other players have several different thoughts too.
Elaborate, please?


https://gyazo.com/...b3bb28dddf908cdbcfd162513

Kahuna: Ya you just wrote the fkn equation, not helping me at all. Lol n I hated algebra.

Slagpit Game profile

Administrator
Game Development
5055

Jun 27th 2024, 22:33:29

If clan leaders would like for statistics/leaderboards/rankings to be calculated for their clan's previous sets then they need to tell me which tags they have owned in the past. Some clans change their tags from round to round after all.

Here's an example from FFA: https://www.earthempires.com/...-statistics-52922#1039449

Rasp Game profile

Member
1003

Jun 28th 2024, 13:11:40

If you can query the master ranks file, we might be able to pull the info like this:

select distinct serverid, resetid, tag, count(*) from alliance_ranks where tag like '%sol%' group by tag having count(tag) > 3;

+----------+---------+---------+----------+
| serverid | resetid | tag | count(*) |
+----------+---------+---------+----------+
| 9 | 5089 | SOL | 19 |
| 9 | 3851 | SOLove | 28 |
| 9 | 4877 | SoLxTTM | 12 |
+----------+---------+---------+----------+
3 rows in set (0.00 sec)

select distinct serverid, resetid, tag, count(*) from alliance_ranks where tag like '%evo%' group by tag having count(tag) > 3;

+----------+---------+---------+----------+
| serverid | resetid | tag | count(*) |
+----------+---------+---------+----------+
| 9 | 3851 | Evo | 7 |
| 9 | 5089 | EvoDuff | 7 |
+----------+---------+---------+----------+
2 rows in set (0.00 sec)


[16:18:00] znc-rasp: We can kill bushido, but not bushifo, zack, moriarty, ghost rider, or darkling
[16:18:07] Req: Is that all the same person?
[16:18:12] symba: yea
[16:18:25] mob: my kids are like dad why are you laughing so much

Tertius Game profile

Member
EE Patron
1645

Jun 28th 2024, 14:01:10

That could be a good starting point for alliance leaders to then confirm? I know there were a few examples where tags were stolen / tweaked, which wouldn't be obvious with that query, even if you look at counts (iLaF, paradime / PDM / paradigm, etc).

Rasp Game profile

Member
1003

Jun 28th 2024, 14:59:34

Originally posted by Tertius:
That could be a good starting point for alliance leaders to then confirm? I know there were a few examples where tags were stolen / tweaked, which wouldn't be obvious with that query, even if you look at counts (iLaF, paradime / PDM / paradigm, etc).


yeah, leaders would have to confirm but I think most stolen tags might stand out for review if you have 2+ tags in the same reset with more than 3 countries.

There will of course be a few other exceptions to be reviewed (ie. recent laf jumping/splitting into 5+ tags to avoid war with clan gdi updates, etc)

[16:18:00] znc-rasp: We can kill bushido, but not bushifo, zack, moriarty, ghost rider, or darkling
[16:18:07] Req: Is that all the same person?
[16:18:12] symba: yea
[16:18:25] mob: my kids are like dad why are you laughing so much

TAN Game profile

Member
3402

Jun 28th 2024, 18:02:11

Did anyone ever scrape all the data from E2025 before it went down? I'm having trouble finding any info on Paradigm tags before EE (~2010).
FREEEEEDOM!!!

galleri Game profile

Game Moderator
Primary, Express, Tourney, & FFA
14,317

Jun 28th 2024, 23:11:26

Originally posted by TAN:
Did anyone ever scrape all the data from E2025 before it went down? I'm having trouble finding any info on Paradigm tags before EE (~2010).

All I could find for the earth 2025 game:
https://web.archive.org/web/20040601000000*/http://stats.earth2025.net/


https://gyazo.com/...b3bb28dddf908cdbcfd162513

Kahuna: Ya you just wrote the fkn equation, not helping me at all. Lol n I hated algebra.

Requiem Game profile

Member
EE Patron
9477

Jun 28th 2024, 23:23:50

Ask the guy who bought utopia maybe he has Earth: 2025 data.

galleri Game profile

Game Moderator
Primary, Express, Tourney, & FFA
14,317

Jun 28th 2024, 23:29:24

Originally posted by Requiem:
Ask the guy who bought utopia maybe he has Earth: 2025 data.

Good idea.
I can ask him on Utopia's discord.
I sent him a pm. We wait now lol

Edited By: galleri on Jun 28th 2024, 23:32:49


https://gyazo.com/...b3bb28dddf908cdbcfd162513

Kahuna: Ya you just wrote the fkn equation, not helping me at all. Lol n I hated algebra.

Suicidal Game profile

Member
2412

Jun 29th 2024, 2:12:55

10"

Symbolic Game profile

Member
847

Jun 29th 2024, 2:28:36

'
Originally posted by Suicidal:
10"

"
We need the real data on sui's "Country" in battle for this statment to be true.

galleri Game profile

Game Moderator
Primary, Express, Tourney, & FFA
14,317

Jun 29th 2024, 15:39:55

Originally posted by galleri:
Originally posted by Requiem:
Ask the guy who bought utopia maybe he has Earth: 2025 data.

Good idea.
I can ask him on Utopia's discord.
I sent him a pm. We wait now lol

He said:
No data, only the code.


https://gyazo.com/...b3bb28dddf908cdbcfd162513

Kahuna: Ya you just wrote the fkn equation, not helping me at all. Lol n I hated algebra.

Detmer Game profile

Member
4283

Jun 29th 2024, 19:55:37

Paradigm:

88: PDM
87: Paradigm
86: PDM
85: PDM
84: PDM2025
73-83: PDM
72: Paradigm
71: Paradigm
66-70: LaF
59-65: Paradigm
57-58: PDM
55-56: Paradigm
54: PDM
49-53: Paradigm
48: PDM
30-47: Paradigm
29: PDM
13-28: Paradigm
12: ParaBOO
5-11: Paradigm
4: PDM
3: PDM50
2: xPDMx
1: ParadigM

Edited By: Detmer on Jun 29th 2024, 20:02:31. Reason: Added alliance name clarification, in case it wasn't obvious

Slagpit Game profile

Administrator
Game Development
5055

Jun 29th 2024, 20:02:40

Originally posted by Detmer:
88: PDM
87: Paradigm
86: PDM
85: PDM
84: PDM2025
73-83: PDM
72: Paradigm
71: Paradigm
66-70: LaF
59-65: Paradigm
57-58: PDM
55-56: Paradigm
54: PDM
49-53: Paradigm
48: PDM
30-47: Paradigm
29: PDM
13-28: Paradigm
12: ParaBOO
5-11: Paradigm
4: PDM
3: PDM50
2: xPDMx
1: ParadigM


Is this line a mistake/joke? 66-70: LaF

Detmer Game profile

Member
4283

Jun 29th 2024, 20:04:33

Originally posted by Slagpit:
Originally posted by Detmer:
88: PDM
87: Paradigm
86: PDM
85: PDM
84: PDM2025
73-83: PDM
72: Paradigm
71: Paradigm
66-70: LaF
59-65: Paradigm
57-58: PDM
55-56: Paradigm
54: PDM
49-53: Paradigm
48: PDM
30-47: Paradigm
29: PDM
13-28: Paradigm
12: ParaBOO
5-11: Paradigm
4: PDM
3: PDM50
2: xPDMx
1: ParadigM


Is this line a mistake/joke? 66-70: LaF


Yes

Slagpit Game profile

Administrator
Game Development
5055

Jun 29th 2024, 20:06:23

Good enough, thanks. If no one else posts then PDM will be the undisputed greatest alliance of all time.

Detmer Game profile

Member
4283

Jun 29th 2024, 20:06:54

Originally posted by Slagpit:
Good enough, thanks. If no one else posts then PDM will be the undisputed greatest alliance of all time.


Mods, please close this thread

cyref Game profile

Member
EE Patron
852

Jun 30th 2024, 15:51:45

88: MONSTERS
87: MONSTERS
86: M0N5T3R5
66-85: MONSTERS
65: MONSTERZ
11-64: MONSTERS
10: Monsters
05-09: MONSTERS
04: Monsters
01-03: MONSTERS
👽

LittleItaly Game profile

Game Moderator
Alliance, FFA, & Cooperation
2219

Jun 30th 2024, 18:12:27

Can't let PDM win

35-SOL
65-SOLdier
83-TSA
104-SOL
121-SOL
143-SOL
162-SOL
183-SOLxK3nt
204-SOLdiers
223-SOL
243-SOLdiers
270-SpoOkyL
289-SOL
308-SOLx75
327-SOLdier
347-SOLdier
366-SOLtrain
386-SOLband
407-SOLdier
427-SOLdier
446-SOLBBQ
466-abSOLute
487-SOLidify
506-SOLdiers
526-SoLdier
560-Liberty
595-Liberty
632-VampsSoL
672-SoL
713-SoL
753-XmasSol
793-SoL
834-SoL
875-SoL
914-SoL
953-SoL4Gonz
994-SoL
1033-SoL
1074-SoL100
1115-SoL
1155-SOL4LIFE
1194-SOL
1235-xSOLmas
1275-SOLarwen
1315-SOL
1356-SOLxJAB
1395-SOLxSC
1436-SOLxLI
1476-SOLxmas
1516-SoL
1557-SOLx20yr
1597-SOL
1637-SOL
1678-SOLxMaki
1719-SOLxmas
1758-SOLxLI
1799-SOL
1839-SoL
1878-SOL
1919-SOL
1960-SOL2020
1999-SoLxABM
2039-SoL
2080-SoL
2120-xSOLx
2160-xSOLx
2200-xSOLx
2240-xSOLx
2314-xSOLx
2451-xSOLx
2591-xSoLx
2731-SOLnet
2871-SOL2022
3011-SOLnet
3151-SOLFC
3292-SOL
3431-SOL
3571-xSOLx
3712-SOL2023
3851-SOLove
3991-xSoLx
4133-SOLtree
4275-doesnt exist
4417-SoL
4560-SoL
4701-SoLxDM
4877-SoLxTTM
LittleItaly
SOL Vet
-Discord: LittleItaly#2905
-IRC: irc.scourge.se #sol
-Apply today @ http://sol.ghqnet.com for Alliance

Detmer Game profile

Member
4283

Jun 30th 2024, 18:29:31

The victors write history. I'm excited to look back on the PDM-Monsters-SoL centric view of Earth.

Detmer Game profile

Member
4283

Jun 30th 2024, 18:29:42

s Game profile

Member
401

Jun 30th 2024, 19:39:18

1 - LaF
2 - LaF
3 - LaF
4 - LaF
5 - LaF
6 - LaFizWIN
7 - LaF
8 - LaF
9 - LaF
10 - LaF
11 - LaF
12 - LaF
13 - LaF
14 - LaF
15 - LaF
16 - LaF
17 - LaF
18 - LaF
19 - LaF
20 - LaF
21 - LaF
22 - LaF
23 - LaF
24 - LaF
25 - LaF
26 - LaF
27 - LaF
28 - LaF
29 - LaF
30 - LaF
31 - LaF
32 - LaF
33 - LaF
34 - LaF
35 - LaFisWiN
36 - LaF
37 - LaF
38 - LaF
39 - LaF101
40 - LaF
41 - LaF
42 - LaF
43 - LaF
44 - LaF
45 - LaF
46 - LaF
47 - LaF
48 - LaFx
49 - LaF
50 - LaF
51 - LaF
52 - LaF
53 - LaF
54 - LaF
55 - LaF
56 - LaF, LaFxFUED
57 - LaF
58 - xLaFx
59 - LaF
60 - LaF
61 - LaF
62 - LaFxDD, LaF
63 - LaF
64 - LaF
65 - xLaFx
66 - LaF
67 - LaF
68 - LaF
69 - LaF
70 - LaF
71 - LaF
72 - LaF
73 - LaF
74 - LaF
75 - LaF
76 - LaF
77 - LaF
78 - LaF
79 - LaF
80 - LaF
81 - iLaF
82 - LaF
83 - LaF
84 - LaF, LaF4Eva, xAFHx, LaF2ghq, LaF2box, LaF2LaF

Edited By: s on Jun 30th 2024, 20:58:46
See Original Post

Ivan Game profile

Member
2368

Jun 30th 2024, 21:04:22

Zzz

VicRattlehead Game profile

Member
2005

Jul 1st 2024, 12:37:15

SOL is ranked too high.

galleri Game profile

Game Moderator
Primary, Express, Tourney, & FFA
14,317

Jul 2nd 2024, 4:40:11

EVO

1-EVOfoo
2-EVOata
3-EVOee
4-EVOnet
5-EVOata
6-EVOdiez
7-EVOdiez
8-EVOosso
9-Evolve
10-EVOwhore
11-EVOlens
12-EVOdiez
13-EVOkj
14-EVOqz
15-EVOwhore
16-EVOvince
17-EVOlve
18-EVOvince
19-Evolve
20-EVOtella
21-EVOosso
22-TiVo
23-EVOtella
24-LenoraVO
25-EVOvince
26-28:EVOsso
29-EvoAzN
30-EVOtella
31-32:EvoAzN
33-evoDJB
34-EvOAzN
35-bEifVO
36-38:EvO
39-EvOchol
40-rEVOr
41-EVObeif
42-EVOgibby
43-EVOchem
44-EVOchem2
45-EVOchem3
46-EVOeg
47-EVOchem4
48-EVoIrivx
49-EVOeg
50-EVoMmixX
51-EVOeg
52-EVOchem
53-EVOmarsh
54-EVOdrEG
55-EVOdrEG2
56-EVOed
57-EVOeg1
58-EVOeRKg
59-EVOacad
60-EVOchem
61-EVOegp
62-EVOchem
63-64:EVOtmac
65-EVOtmars
66-EVOtmac
67-EVOtma
68-EVOall41
69-EVOguess
70-EVOall4
71-vEVOv
72-1Evo1
73-76:Evo
77-1Evo1
78-80:Evo
81-EvoTrees
82-85:Evo
86-EvoMose
87-EvoEn4
88-EvoDuff


https://gyazo.com/...b3bb28dddf908cdbcfd162513

Kahuna: Ya you just wrote the fkn equation, not helping me at all. Lol n I hated algebra.

Marc

Member
83

Jul 2nd 2024, 21:32:38

Originally posted by Slagpit:
Good enough, thanks. If no one else posts then PDM will be the undisputed greatest alliance of all time.


Originally posted by Marc:
Clan: GARGLE

Round 88 - GARGLE


I was literally the first post doing exactly as you asked, no questions, and yet no love?

This is number one bullfluff.
<Earthnews> BR - Covid Booster 3 (#53) [GARGLE] -> Neal (#483) [iLaF] 6C 7B

Rasp Game profile

Member
1003

Jul 3rd 2024, 18:34:03

Originally posted by Marc:
Originally posted by Slagpit:
Good enough, thanks. If no one else posts then PDM will be the undisputed greatest alliance of all time.


Originally posted by Marc:
Clan: GARGLE

Round 88 - GARGLE


I was literally the first post doing exactly as you asked, no questions, and yet no love?

This is number one bullfluff.


GARGLE #1 undisputed greatest alliance.
[16:18:00] znc-rasp: We can kill bushido, but not bushifo, zack, moriarty, ghost rider, or darkling
[16:18:07] Req: Is that all the same person?
[16:18:12] symba: yea
[16:18:25] mob: my kids are like dad why are you laughing so much

Lord MilkHole Game profile

Member
1

Jul 6th 2024, 8:50:11

BlackHole Game profile

Member
1741

Jul 6th 2024, 10:33:24

Originally posted by Lord MilkHole:


LOfluffINGL.


What the fluff is this amalgamation of a name??!?

Devo Game profile

Member
90

Jul 7th 2024, 2:39:28

Originally posted by galleri:
EVO

1-EVOfoo
2-EVOata
3-EVOee
4-EVOnet
5-EVOata
6-EVOdiez
7-EVOdiez
8-EVOosso
9-Evolve
10-EVOwhore
11-EVOlens
12-EVOdiez
13-EVOkj
14-EVOqz
15-EVOwhore
16-EVOvince
17-EVOlve
18-EVOvince
19-Evolve
20-EVOtella
21-EVOosso
22-TiVo
23-EVOtella
24-LenoraVO
25-EVOvince
26-28:EVOsso
29-EvoAzN
30-EVOtella
31-32:EvoAzN
33-evoDJB
34-EvOAzN
35-bEifVO
36-38:EvO
39-EvOchol
40-rEVOr
41-EVObeif
42-EVOgibby
43-EVOchem
44-EVOchem2
45-EVOchem3
46-EVOeg
47-EVOchem4
48-EVoIrivx
49-EVOeg
50-EVoMmixX
51-EVOeg
52-EVOchem
53-EVOmarsh
54-EVOdrEG
55-EVOdrEG2
56-EVOed
57-EVOeg1
58-EVOeRKg
59-EVOacad
60-EVOchem
61-EVOegp
62-EVOchem
63-64:EVOtmac
65-EVOtmars
66-EVOtmac
67-EVOtma
68-EVOall41
69-EVOguess
70-EVOall4
71-vEVOv
72-1Evo1
73-76:Evo
77-1Evo1
78-80:Evo
81-EvoTrees
82-85:Evo
86-EvoMose
87-EvoEn4
88-EvoDuff

Not all hero's are Galleri but this one is

farmer Game profile

Member
1221

Jul 7th 2024, 20:52:03

I say put a category in for best restart percentage.

Garry Owen Game profile

Member
878

Jul 8th 2024, 2:28:16

Rounds 1 to infinity tag: RAGE

There might have been a couple of rounds that used a variation of RAGE but maybe I am remembering the other version of Earth. The decades kind of blend together......

1 - RAGE
2 - RAGE
3 - RAGE
4 - RAGE
5 - RAGE
6 - RAGE
7 - RAGE
8 - RAGE
9 - RAGE
10 - RAGE
11 - RAGE
12 - RAGE
13 - RAGE
14 - RAGE
15 - RAGE
16 - RAGE
17 - RAGE
18 - RAGE
19 - RAGE
20 - RAGE
21 - RAGE
22 - RAGE
23 - RAGE
24 - RAGE
25 - RAGE
26 - RAGE
27 - RAGE
28 - RAGE
29 - RAGE
30 - RAGE
31 - RAGE
32 - RAGE
33 - RAGE
34 - RAGE
35 - RAGE
36 - RAGE
37 - RAGE
38 - RAGE
39 - RAGE
40 - RAGE
41 - RAGE
42 - RAGE
43 - RAGE
44 - RAGE
45 - RAGE
46 - RAGE
47 - RAGE
48 - RAGE
49 - RAGE
50 - RAGE
51 - RAGE
52 - RAGE
53 - RAGE
54 - RAGE
55 - RAGE
56 - RAGE
57 - RAGE
58 - RAGE
59 - RAGE
60 - RAGE
61 - RAGE
62 - RAGE
63 - RAGE
64 - RAGE
65 - RAGE
66 - RAGE
67 - RAGE
68 - RAGE
69 - RAGE
70 - RAGE
71 - RAGE
72 - RAGE
73 - RAGE
74 - RAGE
75 - RAGE
76 - RAGE
77 - RAGE
78 - RAGE
79 - RAGE
80 - RAGE
81 - RAGE
82 - RAGE
83 - RAGE
84 - RAGE
85 - RAGE
86 - RAGE
87 - RAGE
88 - RAGE

Edited By: Garry Owen on Jul 8th 2024, 2:35:33
See Original Post

Slagpit Game profile

Administrator
Game Development
5055

Jul 10th 2024, 5:17:59

Thank you to all who have participated so far. Reminder that the deadline is coming up very soon.