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][/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
Made by Aabra, modified by Mobius
[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
by Mobius
[/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
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.