Jump to content

Cyber Nations Alliance Statistics Depot


Unspeakable Evil

Recommended Posts

  • Replies 2.5k
  • Created
  • Last Reply

Top Posters In This Topic

Thanks UE - That worked - Any chance we can get Kronos added to these next time around?

To be seen on the stats you need to be +1 million NS

At least that used to be the entry into the realm of precious UE stats.

Link to comment
Share on other sites

To be seen on the stats you need to be +1 million NS

At least that used to be the entry into the realm of precious UE stats.

Must have changed because 105 of the 207 entrys are below 1m NS and some even include Applicant AA's

Link to comment
Share on other sites

The exact same thing goes for me. Quite frankly, I cannot understand why people waste their time at the Amazing Sanction Race when you can get the exact same information and more here.

Cybernations Alliance Statistics Depot > Amazing Sanction Race

The best part is they do Amazing Sanction Race by HAND. And they don't know it can be done automatically. Shhh, don't tell them.

Link to comment
Share on other sites

The best part is they do Amazing Sanction Race by HAND. And they don't know it can be done automatically. Shhh, don't tell them.

Any chance there is a way to automate the bloc stats update? I'll be your best friend forever... I promise :wub:

Link to comment
Share on other sites

Thanks UE - That worked - Any chance we can get Kronos added to these next time around?
To be seen on the stats you need to be +1 million NS

At least that used to be the entry into the realm of precious UE stats.

Used to be, but now I grab all the alliances in the 'All Alliances' pages; which is every alliance with 20+ members. Outside that, there's no easy way to find alliances with less than 20 members.

The best part is they do Amazing Sanction Race by HAND. And they don't know it can be done automatically. Shhh, don't tell them.

By hand? How quaint.

Any chance there is a way to automate the bloc stats update? I'll be your best friend forever... I promise :wub:

Well, the problem with blocs is that they're out-of-game constructs so I can't harvest them automagically. The other problem is that membership in blocs change, so that my retroactive bloc stats would be inaccurate. I do occasionally enjoy a challenge. If I have time this weekend, I might see if I can throw something together relatively quickly...

Link to comment
Share on other sites

Yeah I figured us not having 20 members was the reason we weren't on these reports

If you do, I'll find a way to send you 100 tech b/c you'd be saving me atleast 5-8hrs from doing it by hand.

Link to comment
Share on other sites

Yeah I figured us not having 20 members was the reason we weren't on these reports

If you do, I'll find a way to send you 100 tech b/c you'd be saving me atleast 5-8hrs from doing it by hand.

I think I know how to do the bloc thing at the database level to my satisfaction.

The only thing that would break it would be if someone left a bloc and then rejoined later. Has that happened before?

Link to comment
Share on other sites

Updated 2009-06-19.

Bonus update! Prototype HTML (hey, it conforms now edition :v:):

MEGA Rankings, Day-to-Day:

http://uevil.maybe.net/2009-06-19_MEGARD.html

MEGA Military, Day-to-Day:

http://uevil.maybe.net/2009-06-19_MEGAMD.html

MEGA Rankings, Week-to-Today:

http://uevil.maybe.net/2009-06-19_MEGARW.html

MEGA Military, Week-to-Today:

http://uevil.maybe.net/2009-06-19_MEGAMW.html

Link to comment
Share on other sites

Updated 2009-06-20.

Bonus update! Prototype HTML (hey, it conforms now edition :v:):

MEGA Rankings, Day-to-Day:

http://uevil.maybe.net/2009-06-20_MEGARD.html

MEGA Military, Day-to-Day:

http://uevil.maybe.net/2009-06-20_MEGAMD.html

MEGA Rankings, Week-to-Today:

http://uevil.maybe.net/2009-06-20_MEGARW.html

MEGA Military, Week-to-Today:

http://uevil.maybe.net/2009-06-20_MEGAMW.html

Link to comment
Share on other sites

I've made some progress on 'bloc' stats. I'm starting with Citadel, SuperFriends and Complaints and Grievances. Partly because you gotta start somewhere and partly because some blocs have more specific CN Wiki entries than others (looking at you, Frostbite). Tomorrow hopefully I can waste spend some time with a script to print out some pretty HTML so we can track blocs against themselves and amongst the community.

Here's what I have so far. The data I need for each bloc is its members (naturally), when it (the bloc) formed and when each member joined and (if applicable) left. If Bob is still around in the year 9999, I'll need to migrate away from MySQL, however.

If you spot anything wrong with it, please let me know so I can fix it. If you want another bloc added sooner than later, you can help me out greatly by providing a short version of the bloc and it's dates and its membership and their dates. If you're feeling really nostalgic, there's no reason I can't pop in historical blocs such as the WUT, ~, UJP or whatever. If you're an insane madman who wants to dream up blocs that don't exist, I could toss them in too for giggles if I'm sufficiently drunk or bored.

Blocs:

+---------------------------------+-------+------------+------------+
| Bloc							| Kind  | Created	| Disbanded  |
+---------------------------------+-------+------------+------------+
| The SuperFriends				| MADP  | 2007-08-29 | 9999-12-31 | 
| The Citadel					 | MDoAP | 2007-09-28 | 9999-12-31 | 
| Complaints and Grievances Union | MDoAP | 2008-06-30 | 9999-12-31 | 
+---------------------------------+-------+------------+------------+

Bloc Membership Data:

+---------+-----------------------------------+------------+------------+
| Bloc	| Alliance						  | Joined	 | Departed   |
+---------+-----------------------------------+------------+------------+
| Citadel | FCC							   | 2007-09-28 | 9999-12-31 | 
| Citadel | The Grämlins				 | 2007-09-28 | 9999-12-31 | 
| Citadel | Old Guard						 | 2007-09-28 | 9999-12-31 | 
| Citadel | The Order of the Paradox		  | 2007-09-28 | 9999-12-31 | 
| Citadel | Umbrella						  | 2008-04-16 | 9999-12-31 | 
| Citadel | Argent							| 2009-06-02 | 9999-12-31 | 
| SF	  | Apocalypse						| 2007-08-29 | 9999-12-31 | 
| SF	  | Ascended Republic Of Elite States | 2007-08-29 | 9999-12-31 | 
| SF	  | Atlantic Shadow Confederation	 | 2007-08-29 | 2008-05-05 | 
| SF	  | FARK							  | 2007-08-29 | 9999-12-31 | 
| SF	  | Global Order of Darkness		  | 2007-10-31 | 9999-12-31 | 
| SF	  | Monos Archein					 | 2009-01-28 | 9999-12-31 | 
| SF	  | Ragnarok						  | 2008-01-28 | 9999-12-31 | 
| SF	  | Random Insanity Alliance		  | 2007-08-29 | 9999-12-31 | 
| SF	  | RnR							   | 2008-08-10 | 9999-12-31 | 
| SF	  | Halsa							 | 2007-08-29 | 9999-12-31 | 
| C&G	 | Camelot						   | 2008-06-30 | 2008-08-03 | 
| C&G	 | Deck of Cards					 | 2008-06-30 | 2008-07-09 | 
| C&G	 | Heroes Of The Union			   | 2008-06-30 | 2008-08-03 | 
| C&G	 | =LOST=							| 2008-06-30 | 9999-12-31 | 
| C&G	 | Mushroom Kingdom				  | 2008-06-30 | 9999-12-31 | 
| C&G	 | TDSM8							 | 2008-06-30 | 2009-02-19 | 
| C&G	 | Shinra Corporation				| 2008-06-30 | 2008-08-03 | 
| C&G	 | Athens							| 2008-08-03 | 9999-12-31 | 
| C&G	 | Vanguard						  | 2009-02-22 | 9999-12-31 | 
| C&G	 | Greenland Republic				| 2009-04-13 | 9999-12-31 | 
| C&G	 | Fly							   | 2008-06-08 | 9999-12-31 | 
+---------+-----------------------------------+------------+------------+

Link to comment
Share on other sites

(looking at you, Frostbite).

Frostbite formed May 25th, 2009 (announcement here) and is composed of the Siberian Tiger Alliance, the New Polar Order, the New Sith Order, and the Liquor Cabinet. All members joined at the bloc's inception and have been members ever since. Is that everything you need?

Also, well done and thanks for your contributions to the community here.

Edit: forgot my closing parenthesis

Edited by bzelger
Link to comment
Share on other sites

Frostbite formed May 25th, 2009 (announcement here) and is composed of the Siberian Tiger Alliance, the New Polar Order, the New Sith Order, and the Liquor Cabinet. All members joined at the bloc's inception and have been members ever since. Is that everything you need?

Also, well done and thanks for your contributions to the community here.

Edit: forgot my closing parenthesis

Exactly what I need. I'd been hoping the Wiki page would have a link to the creation thread or the date it was signed, but you've provided both so I'm much obliged.

Link to comment
Share on other sites

Updated 2009-06-21.

Bonus update! Prototype HTML (hey, it conforms now edition :v:):

MEGA Rankings, Day-to-Day:

http://uevil.maybe.net/2009-06-21_MEGARD.html

MEGA Military, Day-to-Day:

http://uevil.maybe.net/2009-06-21_MEGAMD.html

MEGA Rankings, Week-to-Today:

http://uevil.maybe.net/2009-06-21_MEGARW.html

MEGA Military, Week-to-Today:

http://uevil.maybe.net/2009-06-21_MEGAMW.html

Link to comment
Share on other sites

C&G is an MADP

Fixed.

Okay, here's an almost pointless use of my new abilities:

Bloc Summary:

http://uevil.maybe.net/blocstat/2009-06-21.html

I can do stuff like this (comparing bloc members versus themselves, 7 days prior) with relative ease:

Warning! Hideous: http://uevil.maybe.net/blocstat/2009-06-21.test.txt

So, some questions for my loyal consumers:

* In the Bloc summary, would you like to see the change in various columns by absolute value or percent; and versus a week prior or a month (or some other period of time)?

* Is there some column you'd like to see besides what I've put there?

* Any other aggregation you'd like to see of the numbers?

* Any other blocs I should add?

Based on feedback (if there is any), I'll fix up the bloc stats HTML to update daily and record for posterity in the coming day or three. There is really only one caveat I can think of, and that's that any bloc member with less than 20 members will not count (not because I wouldn't count them, but because there is nothing to count since that data cannot be recorded easily). The way I've set things up, it won't even be a problem if an alliance leaves and re-joins a bloc now.

Edited by Unspeakable Evil
Link to comment
Share on other sites

So, some questions for my loyal consumers:

* In the Bloc summary, would you like to see the change in various columns by absolute value or percent; and versus a week prior or a month (or some other period of time)?

* Is there some column you'd like to see besides what I've put there?

* Any other aggregation you'd like to see of the numbers?

* Any other blocs I should add?

Based on feedback (if there is any), I'll fix up the bloc stats HTML to update daily and record for posterity in the coming day or three. There is really only one caveat I can think of, and that's that any bloc member with less than 20 members will not count (not because I wouldn't count them, but because there is nothing to count since that data cannot be recorded easily). The way I've set things up, it won't even be a problem if an alliance leaves and re-joins a bloc now.

Looks great UE

I'd go with %

I'd add all the blocs listed here

Edited by Heracles the Great
Link to comment
Share on other sites

SF actually only has 6 signatories - MA, GOD, RIA, Fark, RoK, and R&R :)

I think I've got it right now. I misread the wiki, apparently.

Looks great UE

I'd go with %

I'd add all the blocs listed here

When did CN get so many blocs? Won't some merciless hegemon please wipe out most of them so my life is easier? No? FINE.

More seriously, below is a list of the blocs from Heracles' thread. A few I couldn't quickly ascertain the created dates on (CDT and Poseidon). If someone could help me out on that, I'd much appreciate it. For everything else, I welcome recommendations on the official Bloc Name/Treaty Name as well as preferred short names, bearing in mind there is a mostly artificial 10 character limit on short names.

I'll start initializing the blocs below Frostbite in the list with their current membership. Older blocs with rich and storied histories may not get fleshed out any time soon/ever unless I can harass a bloc historian about it. I don't suppose that's too awful a fate, since over time it'll be easier to keep things up to date.

+---------------------------------+------------+---------------------------------------------------+-------+------------+
| Name							| Short	  | Treaty											| Kind  | Created	|
+---------------------------------+------------+---------------------------------------------------+-------+------------+
| The Citadel					 | Citadel	| The Lux Aeterna								   | MDoAP | 2007-09-28 | 
| The SuperFriends				| SF		 | The SuperFriends Pact							 | MADP  | 2007-08-29 | 
| Complaints and Grievances Union | C&G		| Complaints and Grievances						 | MADP  | 2008-06-30 | 
| Frostbite					   | Frostbite  | The Treaty of Rhen Var							| MDoAP | 2009-05-25 | 
| The Chestnut Accords			| Chestnut   | The Chestnut Accords							  | MDP   | 2008-12-27 | 
| Watling Street Compact		  | Watling	| Watling Street Compact							| MDoAP | 2008-09-14 | 
| Common Defense Treaty		   | CDT		| Common Defense Treaty							 | MDP   | 0000-00-00 | 
| Poseidon						| Poseidon   | Poseidon										  | MDoAP | 0000-00-00 | 
| League of Extraordinary Oranges | LEO		| League of Extraordinary Oranges				   | MDoAP | 2008-01-01 | 
| Bastion						 | Bastion	| Bastion										   | MDP   | 2009-02-13 | 
| Below						   | Below	  | Below											 | MADP  | 2009-02-10 | 
| Aztec						   | Aztec	  | Assistance, Zeal, Trade, Economic & Combat Treaty | MADP  | 2008-03-01 | 
| Power Rangers				   | Power	  | The Megazord Accords							  | MDoAP | 2008-07-16 | 
| The Terra-Cotta Pact			| TerraCotta | The Terra-Cotta Pact							  | MDP   | 2009-03-19 | 
| Pink Warrior Network			| PWN		| Pink Warrior Network							  | MDoAP | 2009-01-22 | 
| The Stickmen					| Stickmen   | The Stickmen Accords							  | MDoAP | 2009-04-09 | 
| The Nexus Agreement			 | Nexus	  | The Nexus Agreement							   | MDoAP | 2008-03-29 | 
| Black Peace Initiative		  | BPI		| Black Peace Initiative							| MDoAP | 2008-01-01 | 
| Teen Titans					 | TeenTitans | Teen Titans									   | MADP  | 2008-10-20 | 
+---------------------------------+------------+---------------------------------------------------+-------+------------+
19 rows in set (0.00 sec)

Link to comment
Share on other sites

Okay, blocs should be populated with current members now. Proofreading of the following is greatly appreciated to make sure I didn't mess anything up again:

http://uevil.maybe.net/blocstat/bloc_members.txt

Re-running the query for today makes it a bit less boring:

http://uevil.maybe.net/blocstat/2009-06-21.html

The disfigured raw data from before is even more unreadable than before:

http://uevil.maybe.net/blocstat/2009-06-21.test2.txt

Soon, making it pretty!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...