The Future of SRK Mafia (Possible Site Transition)

Just wanna make sure I understand: you want a database for the leaderboard, right?

If that’s the case, I probably should’ve stated before that while I do know how to use SQL, I’ve only had experience in using it in phpMyAdmin alongside php files. Also, I’ve only ever used FileZilla for uploading files to servers. So I can do that sort of stuff, I just need to learn how to do it in another context.

Also, I have no idea what VMWare is. :c

Basically, VMWare is a program that lets you do a fake install of an OS while you’re running another OS, and then run that OS within your native one. So you could run an empty Linux install in Windows or vice versa.

So we may have to do a little bit of research on how to make the database, if we can’t figure out how to implement it, I have no qualms about doing it by hand and putting it in a sticky. This is more of a convenience thing and allowing more flexibility on the GMs to do it themselves just in case I’m in a situation where I can’t.

I have experience with databases. @hecatom actually works with databases primarily I believe if he wants to pitch in.

Doing a leaderboard database is easy, tying it into the site gets conplicated and where I’d have to research

That’d all be a matter of knowing what to write to in SQL, and what fields to add to the form, IMO. If Forge knows how to make forms that’ll write to SQL, and someone else knows how to work with SQL, then it’s all a matter of coordination there.

Basically, you’d need a form for admins only that write to the SQL the following:

  • Name of the game
  • Who ran the game

Then a repetitive list, expandable by clicking “add new player” consisting of

  • Player name (selectable from a drop down list box)
  • Points accrued (make sure it can accept negative integers)
  • Win (could be a checkbox, where checking the box adds 1 to the win field of the database)

Really, that should be it, if I’m right.

We’d also need to be able edit games if we need to.

But there will be a bit research to go still, because we would need it to seemlessly work with SMF. So a little bit of searching through www.simplemachines.org/community may help, because the way you extend the forums is through installable zip files that you upload to the forum.

Plus it would be a great thing to make this something that could be sent upstream to SMF for others to use. Never a bad idea to give back to the software and to any other mafia communities that might be using SMF.

So is the JTM leaderboard gonna carry over our SRK points or are we starting fresh? Can we also get a tier list database starting with JTM games?

  1. Need to click LOL to your post.
  2. That’s something we need to discuss. I’m not sure what to do with that. This may be a hot button issue, but we could either start off fresh, or only carry over people’s points that come over to JTM. I’m really torn on this.
  3. That’s an idea I hadn’t thought of. If we can figure out how to make that happen, then I don’t see why that isn’t possible.

Just been brainstorming, and since I was talking about having the Leaderboard invites for the next All Star game only reflecting the games between All Star games, we could do a soft reset of the leaderboard on JTM, but keep the old leaderboard active as an All Time list. So, you can see both your results for the rolling total as well as All Time.

So this is what I came up with.

Spoiler

https://dl.dropboxusercontent.com/u/45366695/Jesus%20Toast%20Mafia.png

I like that version better, but it’s a bit harder to see the details when it’s icon size, so here’s a Black Jesus Toast Mafia logo.

Spoiler

https://dl.dropboxusercontent.com/u/45366695/Black%20Jesus%20Toast%20Mafia.png

Side note, FUCK PERSPECTIVE.

I’ve been on GGPO, trying to get VPN going right now, but if I can’t, can you imgur that?

OMG…that is AWESOME!

Sure thing.

imgur.com/Q41vuPW
imgur.com/cnUldyT

Let me know if you have any suggestions or whatever.

Trying to think if there’s something we can add. To me, it looks perfectly fine. Not what I was expecting, but quite indicative of what we’re doing.

Ok, I’m really starting to think Godonic really is Godots.

I had some other ideas, but most of them fell into either the ‘too religious’ or ‘too many things’ categories. So instead of a bunch of Mafia members with Jesus Toast (a.k.a. the Jesus Toast Mafia), we got the Mafia Jesus Toaster.

That’s kind of where I was going, was the Toaster. I was kind of expecting some imprint on bread, but that’s harder to do I think, and this is pretty darn awesome.

One other thing that would be awesome is that imprinted Jesus with the knife isolated for a favicon. That should definitely be our favicon, no doubt about it.

Okay, I figured out that I can do a test server on Windows without bother with Linux.

I’ll just try that soon and practice getting things set up.

Here’s the Mafia Jesus without any of the fancy embossing/perspective effects.

Spoiler

https://dl.dropboxusercontent.com/u/45366695/Jesus%20Mafia.png

imgur link: imgur.com/ABByXz7

Already batting 1000 on not getting this test server working.

Suddenly VPN decides to crap out too…so I can’t see the favicon.

Is the imgur link working? Also, same icon with black and white colouring.

Spoiler

https://dl.dropboxusercontent.com/u/45366695/Jesus%20Mafia%20Monochrome.png

imgur link: imgur.com/nIKI04d

Alternate version: Black Jesus

Spoiler

https://dl.dropboxusercontent.com/u/45366695/Black%20Jesus%20Mafia%20Monochrome.png

imgur link: imgur.com/yEEu4kt

Totally had a great idea, Alpha.

You have Jesus…with a knife.

Why not make it so that he is preparing to stab into some delicious toast?

I think we could have those two logos (white and black Jesus), one for a dark theme, and the other for a light theme.