Spiral Knights - Guild Record Donations Tracker

Guild Record Donations Tracker

9 replies [Last post]

Thu, 01/31/2013 - 01:05

Hexzyle

Ahoy, fellow Guild Masters and Officers!

I'm been working hard over the last few days on a (rather sloppily programmed but functional) record compiler using only GameMaker for checking up on who isn't paying upkeep for the guild. This program has the functionality to:

Add and remove members from the list by reading Membership records
Total up all of each member's crown contribution to the treasury
Can be used to apply a "fee" or "rent" to every guild member
Search up guild member's names quickly and easily to find their total contribution
Bring up a list of the highest (or lowest) crown contributors of the guild! (NEW)

So, without further ado, I present thee, the Spiral Knights guild record compiler, or SKGRC for short! (Not really)
Version 1.2.1 (Select preferred format)
Download: RAR file
Download: ZIP file

If you have any problems with this program (as I suspect many people will, because I haven't been able to test it much for bugs) please post them here. (the full bug report will help greatly in identifying the problem)
As it is, the program is teetering on the pretense that you don't enter invalid information into input boxes (No safety nets at all :P)
Feedback would also be muchly appreciated, as is suggestions on what to implement next.

Instructions:

Extract the compiler.
Put all your .csv guild records into the same directory as the compiler. Note that the compiler can only scan one file per date, so if you have multiple records saved for the one particular date, choose just one to put in the folder. (it doesn't matter which, the compiler has measures in place to prevent double scanning of overlapping records)
Remove the timestamp from all the csv files so that it just shows your guild name and date. (like: Guildname_YYYY-MM-DD.csv) Your setout should now look like this. (Except that you might have more guild records than I have)
[OPTIONAL] In the file "memberlist.txt", you'll need to type in all your current guild member's names. Make sure to leave a line between each name, this is where the crown amount will be displayed. Don't worry, this tedious process you will only have to complete once. The compiler checks the Member records to add new members and remove old ones from the list.
Start the compiler and click on the initialize icon to configure the settings. If you skipped step 4, you should use this to enter in your guild member's names.
Once configuration is complete, click the compiler button!

Note that when entering your guild name into the initialization and member names into memberlist.txt, the names are case sensitive. Use capital letters for the start of words and for the first letter after a dash: Exa-Mple.

Short-Term Planned Features:

Customizable alert messages
Furniture Donation
Button Tooltips
Readme File

Wed, 02/06/2013 - 06:13

Hexzyle

They have been squashed.

UPDATE 1.2 NEWS
I just finished fixing some pretty big bugs, one being that the compiler would compile the first file, but ignore the second if it had entries that overlapped with the first. If you have compiled two or more logs that are a week apart (do not share entries), it erm.... may have missed a big bunch of records :/
If anyone has been the victim of this, I'll be glad to program something to wipe all your guildmate's crown records but not their names so you don't have to type them all in again ^^
For this and future updates, here's the changelog.

Thu, 01/31/2013 - 13:23

Msaad

This is a brilliant creation

Thu, 01/31/2013 - 22:22

Hexzyle

Thanks Msaad. :3

Thu, 01/31/2013 - 22:43

Mzculet

Fri, 02/01/2013 - 23:20

Hexzyle

Updated the program. Currently I'm looking for ideas on what to implement next. Anyone?

Fri, 02/01/2013 - 23:48

Quakeman

array showing of actual

array showing of actual weekly donation AND totall donation for each playing + writing down every furnitures/mats given by a player
also tracking who USED money (officers)

additionaly maybe a self promoting system (prettry sure u cant but what ever), in my guild it cost 12k to be member ... but there is no weekly fee .. this purpose is to prevent people to come , pick stuff up or participate to events , then quit

Sat, 02/02/2013 - 00:07

Hexzyle

@Quakeman

Saving every single material that each member donates would end up inflating the memberlist file to quite an unmanagable state.
I'd rather just create a database containing every item and its approximate value, and then having a separate variable for each member that is increased when they contribute items to storage, and decreases when they withdraw.

"also tracking who USED money (officers)"
I'm not sure if Officer purchase tracking is required, I mean it's fairly obvious when people buy things because the changes are evident.

"additionaly maybe a self promoting system (prettry sure u cant but what ever)"
Yeah, that's not really possible with what I'm doing, I'm just taking values from the logs and compiling it, I'm not using a bot to actually interact with the client itself.

I'm thinking perhaps a "Membership Contribution" record, where each guild invite, kick, promotion and demotion would add another point to that player's record. Players with high numbers would evidently be large contributors to the Guild's member structure, meaning either that they're helping the guild grow and prosper, or they're filling the guild with people they know will help them overthrow :P

Sat, 02/02/2013 - 11:34

Quakeman

how about furniture tracking

how about furniture tracking only then instead of mats too?

Sun, 02/03/2013 - 04:38

Hexzyle

@Quakeman

Oh right, you were referring to donations to the treasury. Well yes then, furniture should definitely be added as a new value or something. I'll figure something out.
EDIT: Just rolled out an important bugfix, I strongly recommend you download it before compiling any more records.

Search

Guild Record Donations Tracker