Zandronum

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.

---

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][/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
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][/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 [spoiler]

[/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.

Impressive work here, how long has this been worked on?

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.

This is some awesome stuff!

Might use that power shell script actually :D Cheers Mobius

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

Keep up the good work!

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

Absolutely amazing job here.

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

Right.

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.

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.

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

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.