Spiral Knights - Guild Record Web App

Guild Record Web App

5 replies [Last post]

Mon, 12/31/2012 - 19:45

Heruncle

I made a web application to store exported guild log data into a database so that it's easier to navigate and can go more than 10 days back. Here is a demo with sample data, and here are the required files. In order to set this up, you'll need a web server with PHP and MySQL, and some basic knowledge of PHP and MySQL for installation and configuration (can't be arsed to make a proper installer for such a small app).

Installation:

Extract index.php and _guild_record.php to a public folder on the web server.
Within that folder, create a subfolder named "guild_record_csv".
Execute the queries in mysql_queries.txt inside a MySQL database.
Open index.php and configure all of the defined constants at the top of the file, as well as the $LOGINS data.

User notes:

The page bar doesn't work on IE8 or older. Seriously, update or better yet switch if you're still using one of those.
A 'guest' can view the logs, and an 'uploader' can view the logs and upload CSV files.

Admin notes:

Only trusted officers/GMs should be in the 'uploader' group, obviously. Only those with database access should be in the 'admin' group.
If a bad CSV is uploaded, then delete the corresponding row from the `guild_record_uploads` table, log into the page as an admin and load the script with ?resync=1 in the URL to reinsert all the other data. This could take a while.
The authorisation in index.php is very lightweight and not very secure. phpbb.php uses phpBB session IDs and forum ranks for authentication, in case your guild has a phpBB forum like mine.

Tue, 01/01/2013 - 03:05

Donkey-Haute

not to derail, but here's another

I don't want to derail your thread, but I might as well mention the Python script that we're using for this same purpose in our guild: Lancer_Knightz_(Guild)/Guild_Records. It seems to be far less capable than your solution, but it may also be simpler.

Tue, 01/01/2013 - 07:43

Heruncle

Not a problem, since I doubt

Not a problem, since I doubt many players in the community are into IT. Your script is definitely much simpler, but I need to take more than the last 10 days worth of data, as well as make it easily accessible by the rest of my guild. I made a minor optimisation to the script you published, but I'm pretty rusty at Python and didn't bother checking for compile/runtime errors.

Tue, 01/01/2013 - 09:56

Donkey-Haute

thanks a lot

Thanks for catching that glaring inefficiency in my version. It would start to get pretty nasty, if I were to add more regular expressions to the mix. And yes your version works.

When I wrote my script, I didn't know that guild records go back only 10 days. Handling this is a major advantage of your approach over mine. Cheers.

Wed, 01/02/2013 - 09:22

Bopp

thanks (both of you)

Thanks for putting these tools together (both of you). I'm surprised that there hasn't been more interest in this thread. Surely there must be a ton of guild masters out there, who are trying to keep track of their guilds. Some of them are even trying to enforce mandatory weekly contributions. I'd expect them to love these tools.

Wed, 01/02/2013 - 09:41

Ndognine-Forums

It seems like a cool app, but

It seems like a cool app, but I think as long as the guild upkeep is being paid, and guild member are paying at least enough to do what the guild needs to be done...or you could be like me...dumping 400k cr so i dont have to worry about it for a while.

I will however be referring my GM to this, and may end up using it myself.

Search

Guild Record Web App