Post by goodusernamenowbob on Jan 10, 2016 0:02:24 GMT -5
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.
[align=center]ClientSide Stat Recorder
Credit to Heavenwraith[/align]
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
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
[align=center]Cube2016 Stat Book
Made by Aabra, modified by Mobius[/align]
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.
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
[align=center]
Youtube Tutorial
by Mobius[/align]
[align=center]Screenshots[/align]
Tips:
[*]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[/ul]
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.
[align=center]ClientSide Stat Recorder
Credit to Heavenwraith[/align]
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
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
[align=center]Cube2016 Stat Book
Made by Aabra, modified by Mobius[/align]
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.
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
[align=center]
Youtube Tutorial
by Mobius[/align]
[align=center]Screenshots[/align]
Tips:
[*]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[/ul]
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.
