A3 Clan Stats and Statistics For Everyone

Announce your great clan here.
Post Reply
Mobius
Banned
Posts: 815
Joined: Wed Jun 13, 2012 3:43 am
Location: The center of the A3's controversial and machiavellian conspiracy
Clan: Cube
Clan Tag: Aᵌ
Contact:
Banned: Permanently

A3 Clan Stats and Statistics For Everyone

#1

Post by Mobius » Sun Jan 03, 2016 2:20 am

Hello everyone. It's the guy who makes big post again and here to bring onto the clan scene of Zandronum two useful utilities for your clans. I'll cut straight to the chase.

ClientSide Stat Recorder
Credit to Heavenwraith

Description:
This little script uses powershell to record clientside information from a demo or live game for particular CTF announcements on the server. The information it filters out is anything but CTF related messages relayed onto a server such as Flag Touches, Captures, Drops, and Returns and even PickUp Scores from Dropped flags and tallies them with their assigning player. You do not need to be the player or a server host! All you need is to type Logfile before an official game starts and of course it by either closing a demo or typing logfile after the match. The printed information from the logfile will be filtered by the Stat.ps1 file to only show world events related to CTF and even tally them

[spoiler]Image[/spoiler]

When you are using demos for clientside recording you do not NEED to watch the demo to print the information in the console for logfile. You can use Demo_skiptonextmap to force Zandronum to print the information all at once (not technically) which bypasses your need to actually watch a game. The console will print that information anyway and hence you can use the stat file to your disposal.

Download here
Must run as Powershell

Just copy and paste the path of the logfile's file and it will generate a new file called stat.txt which filters everything. Use this to input information. Will be updated for universal stat logging and frags upon request. This file can be put in any folder.

Next
Cube2016 Stat Book
Made by Aabra, modified by Mobius
Description: This is the official Book of what is soon to be Cube's (A3) stats for all scrims; however, the book is loaded with bogus stats because it's for you as well. I am releasing this early version of the book that records all Frags, touches, pickups, MAP information, and player values in tandum with Heavenwraith's clientside recorder! Now if you use openoffice then I am sorry, but those with Microsoft Office can freely use this excel book. It comes already pre-made with formulas for automation so all that is needed of you is someone dedicated to punch numbers in the "scrim" sheet. The rest does itself. Some assembly is required.

[spoiler]Image[/spoiler]

I intentionally did not finish before releasing this simply for those that wish to edit or play with it. Since no one apparently seriously use Excel for anything that can be done by SQL I left some stuff for people who want to play with this and figure it out. My mindset is that if there's some already half-made information readily available you can easily understand what I am/was doing and attempting to do. All you really need to focus on is putting information manually in the scrim sheet of the book and the rest SHOULD update automatically with the exception of adding need clans and CTF match info stuff, but again you can figure it out.

Download Here
Excel

Next
Youtube Tutorial
by Mobius
phpBB [video]
The [video] tag is deprecated, please use the [media] tag
Screenshots
[spoiler]Image
Image
Image[/spoiler]

Tips:
  • You can easily add clan members in the main sheet called Memberstats by just changing the names of the A3 players there with your own members.
  • Scrim ID is important. Each round of a scrim (not the whole scrim) has its own unique ID in the Scrim sheet.
  • Highlight a row or column and right-click delete will do the job better.
  • Redo a lot
  • Save, and save often
  • The leaderboard information in the Main sheet will show erroneous information if the reference tables are turning values that aren't uniform. So fill your Scrim sheet with many scrims and then fix it or fill it with shit information like I did and do the same
Contact me for any help or request.

IRC - #A3 on Zandronum or any related channels
Youtube - U9B
Teamspeak - Check the A3 clan topic

Hope this helps other clans out there. There will be more to come!
This is posted in the competition section cause it caters to this crowd more I hope.
Last edited by Mobius on Sun Jan 03, 2016 2:27 am, edited 1 time in total.
dewsome: i can do this all day
dewsome: do you think you're somehow special? i spent years arguing with nostar, jenova, mobius
<+Thomas13> Mobius u r inferior, go outside and get beaten up
Alfonzo ~ "I wonder who will hear him trash talk when the dirt closes over him?"

Catastrophe
Retired Staff / Community Team Member
Posts: 2558
Joined: Sat Jun 02, 2012 2:44 am

RE: A3 Clan Stats and Statistics For Everyone

#2

Post by Catastrophe » Sun Jan 03, 2016 2:27 am

Impressive work here, how long has this been worked on?
Last edited by Catastrophe on Sun Jan 03, 2016 2:27 am, edited 1 time in total.

Mobius
Banned
Posts: 815
Joined: Wed Jun 13, 2012 3:43 am
Location: The center of the A3's controversial and machiavellian conspiracy
Clan: Cube
Clan Tag: Aᵌ
Contact:
Banned: Permanently

RE: A3 Clan Stats and Statistics For Everyone

#3

Post by Mobius » Sun Jan 03, 2016 2:29 am

Catastrophe wrote: Impressive work here, how long has this been worked on?
Since Yesterday. I've been trying to fix the Match index problem and found out ms office is DUMB with values it returns. HW has been tweaking his script for the same amount of time for better utility. Both will be updated soon.
dewsome: i can do this all day
dewsome: do you think you're somehow special? i spent years arguing with nostar, jenova, mobius
<+Thomas13> Mobius u r inferior, go outside and get beaten up
Alfonzo ~ "I wonder who will hear him trash talk when the dirt closes over him?"

mifu
Retired Staff / Community Team Member
Posts: 1075
Joined: Tue May 29, 2012 10:34 am
Location: Aussie Land
Clan: Demon RiderZ

RE: A3 Clan Stats and Statistics For Everyone

#4

Post by mifu » Sun Jan 03, 2016 3:55 am

This is some awesome stuff!

Might use that power shell script actually :D Cheers Mobius
Image

User avatar
IdeIdoom
Zandrone
Posts: 1112
Joined: Mon Jun 04, 2012 6:19 am
Location: Meldola, Italy
Contact:

RE: A3 Clan Stats and Statistics For Everyone

#5

Post by IdeIdoom » Sun Jan 03, 2016 9:55 am

Amazing, now we don't have to do manual stuff as much.

Keep up the good work!
THE ROMANIAN POWERImage

Code: Select all

<+Dastan>	edd
<+Dastan>	boxxy skin when
<+Shift>	dastan you really want to fap at it this much and now you are going crazy and shredding your hair into a million tiny pieces for this boxxy skin to come out that way you can cum out
<+Dastan>	Shift, yes
--------------------------------------------------------------------
21:53:26  <@Estar>	well, if i'd be a girl, i would say ideidoom has ok looks

User avatar
Samurai
Frequent Poster Miles card holder
Posts: 907
Joined: Thu Jun 07, 2012 12:17 am
Location: England
Clan: Lost Faction
Clan Tag: [LF]

RE: A3 Clan Stats and Statistics For Everyone

#6

Post by Samurai » Sun Jan 03, 2016 10:33 am

Look at Mobius being a good little boy for the community, how things change...

Code: Select all

00:11  <Jarin_cz>	i am pretty sure i have more doom friends than you

User avatar
Kara Kurt
Frequent Poster Miles card holder
Posts: 887
Joined: Sat Oct 12, 2013 6:58 pm
Location: Strasbourg, France
Contact:

RE: A3 Clan Stats and Statistics For Everyone

#7

Post by Kara Kurt » Sun Jan 03, 2016 11:06 am

Absolutely amazing job here.
IdeIdoom wrote: Amazing, now we don't have to do manual stuff as much.
Right.

Mobius
Banned
Posts: 815
Joined: Wed Jun 13, 2012 3:43 am
Location: The center of the A3's controversial and machiavellian conspiracy
Clan: Cube
Clan Tag: Aᵌ
Contact:
Banned: Permanently

RE: A3 Clan Stats and Statistics For Everyone

#8

Post by Mobius » Sun Jan 03, 2016 12:47 pm

Kara Kurt wrote: Absolutely amazing job here.
IdeIdoom wrote: Amazing, now we don't have to do manual stuff as much.
Right.
I forgot this existed. This book is for people and their clan exclusively, but it's good to know you and I are on the same page.
Last edited by Mobius on Sun Jan 03, 2016 12:54 pm, edited 1 time in total.
dewsome: i can do this all day
dewsome: do you think you're somehow special? i spent years arguing with nostar, jenova, mobius
<+Thomas13> Mobius u r inferior, go outside and get beaten up
Alfonzo ~ "I wonder who will hear him trash talk when the dirt closes over him?"

User avatar
IdeIdoom
Zandrone
Posts: 1112
Joined: Mon Jun 04, 2012 6:19 am
Location: Meldola, Italy
Contact:

RE: A3 Clan Stats and Statistics For Everyone

#9

Post by IdeIdoom » Sun Jan 03, 2016 1:12 pm

Kara Kurt wrote: Absolutely amazing job here.
IdeIdoom wrote: Amazing, now we don't have to do manual stuff as much.
Right.
I am sorry, but that one is very old, very flawed, and operated by 1 person (you).

This method lets the user make their own.
Last edited by IdeIdoom on Sun Jan 03, 2016 1:14 pm, edited 1 time in total.
THE ROMANIAN POWERImage

Code: Select all

<+Dastan>	edd
<+Dastan>	boxxy skin when
<+Shift>	dastan you really want to fap at it this much and now you are going crazy and shredding your hair into a million tiny pieces for this boxxy skin to come out that way you can cum out
<+Dastan>	Shift, yes
--------------------------------------------------------------------
21:53:26  <@Estar>	well, if i'd be a girl, i would say ideidoom has ok looks

User avatar
Combinebobnt
Retired Staff / Community Team Member
Posts: 1893
Joined: Mon Jun 04, 2012 3:37 am
Location: Erth
Contact:

RE: A3 Clan Stats and Statistics For Everyone

#10

Post by Combinebobnt » Sun Jan 03, 2016 9:17 pm

Nice karakurt, a stats page last updated 2014 and missing some clans even at the time, very good nice good.

User avatar
Kara Kurt
Frequent Poster Miles card holder
Posts: 887
Joined: Sat Oct 12, 2013 6:58 pm
Location: Strasbourg, France
Contact:

RE: A3 Clan Stats and Statistics For Everyone

#11

Post by Kara Kurt » Sun Jan 03, 2016 10:00 pm

The misunderstanding is real.
I didn't even had the intention to continue where I stopped? I simply mean't to say that it would've lasted longer if I had something like this script.

Post Reply