IPSC Canada Stats Page

hungrybeagle

hungrybeagle

CGN frequent flyer
EE Expired
Rating - 0%
0   0   0
Location
Vancouver
Okay, so the idea of an IPSC Canada Match Calendar wasn't very well received.

How about an IPSC Canada Stats Page? No more waiting; as soon as a match director uploads the stats to the website, they're available for viewing.

I've been working on the IPSCBC version to add a user management system (so people can create their own accounts, find lost passwords, etc) and it currently only shows last names if you have cookies set from the IPSCBC forums. However, it wouldn't be hard to have a public front end that hides last names, and a members only section protected by IPSC Canada password that shows last names.
 
hungrybeagle said:
Okay, so the idea of an IPSC Canada Match Calendar wasn't very well received.

How about an IPSC Canada Stats Page? No more waiting; as soon as a match director uploads the stats to the website, they're available for viewing.

I've been working on the IPSCBC version to add a user management system (so people can create their own accounts, find lost passwords, etc) and it currently only shows last names if you have cookies set from the IPSCBC forums. However, it wouldn't be hard to have a public front end that hides last names, and a members only section protected by IPSC Canada password that shows last names.
Click to expand...

Why wasn't the match calendar well received? I think it's a great idea, it's just the implementation of it that I personally questioned :) Regardless of implementation though the idea is a good one.

re: a USPSA style match results system, I'm not sure whether there is enough value in it or not. I think one of the reasons it works well for USPSA is because of the number of major matches they have and how many of the same people travel to them. It's great being able to see how the top guys do at those matches, but it seems to me that in Canada it's a lot more Level II matches that are only attended by those who are local with the odd major match like Provincials (which are still mostly local people). Since each section also has their own method for handling provincial standings and getting match results out (at least as far as I know they all do) does having those results in one place really provide that much additional value?
 
I've been working on a system for looking and analyzing match results. Right now it has results from Ontario matches from 2009 loaded but it can accommodate other sections as well. If anyone would like to look at that, please let me know.

Right now it shows the full names, but it won't be hard to make it to don't show the last names.
 
Last edited:
96Brigadier said:
re: a USPSA style match results system, I'm not sure whether there is enough value in it or not. I think one of the reasons it works well for USPSA is because of the number of major matches they have and how many of the same people travel to them. It's great being able to see how the top guys do at those matches, but it seems to me that in Canada it's a lot more Level II matches that are only attended by those who are local with the odd major match like Provincials (which are still mostly local people). Since each section also has their own method for handling provincial standings and getting match results out (at least as far as I know they all do) does having those results in one place really provide that much additional value?
Click to expand...

Well, I imagine a system where you have your own provincial website. However, you use an iframe to embed the stats page directly into your own website. When you do so, it automatically strips out all of the other provinces, and shows you only your own.

Example. I use this on the IPSCBC Webpage. Currently, all I do to embed the stats page is to add the following code to the IPSCBC "template".

Code: 
 <iframe id=frame src="http://www.ipscbc.com/results2/results.php?province=BC" width="100%" height=500 frameborder=0>
  <p>Your browser does not support iframes.</p>
</iframe>

If you want to show only your province, then you set it in the iframe src, otherwise, it shows all of the matches. If you want to show all provinces, you just get rid of the "?province=XX" :

Code: 
<iframe id=frame src="http://www.ipscbc.com/results2/results.php" width="100%" height="500" frameborder=0>
<p>Your browser does not support iframes.</p>
</iframe>

Next thing I will be adding is searching by date range, level, province or club.

The editing side is easy, too. Screenshot

You just create a new match, enter in your relevant data, and once your match is created, you get to upload your overall and stage results in report emulation .txt format. The editing window shows you a list of all the matches that you have permission to edit (ones that you've created, or ones that are lower access level than you).

One database for all matches in Canada. If you want to have a public version that hides last names, you embed one bit of html. If you want to have a private version that shows last names, it goes behind a password protection system and you embed a different bit of html but the look/layout is exactly the same.
 
It would be nice if you keep a link for downloading an original archive with the match results. That way it would be easier to pull them into my system for the future analysis. :D
 
euxx said:
To give you an idea what I am talking about (click on the image to see a bigger picture):
Click to expand...

I'm guessing that the blurred out sections are two people that you're comparing? I can't figure out what the % are in the "Level" column though. Percentage of the total match points available?

In any case, I'm done.
www.ipscbc.com/results.php to see the finished product.

www.ipscbc.com/results2/results.php if you want to see what it looks like without the IPSCBC page around it. (this is what gets embedded into other websites).

www.ipscbc.com/results2/results.php?province=XX (upper case only) to see just a single province.


I left a version that can be played around with on www.hungrybeagle.com, with the results visible at www.hungrybeagle.com/results.php. I also turned down the permissions so that anyone can try it out as soon as they sign up. Future versions will have a "validation" so that I can make sure that we don't get a bunch of spam bots signing up. I thought about skill testing questions... (Who's the Regional Director? Who's the Vice Regional Director) but I thought people might not be able to answer them all. :)
 
Right, the columns are for one or more people to compare. On the right is the % of the maximum possible match points in that given stage (to easily see which stages matters most). There is other info in a tooltips not shown on the screenshot.
 
You must log in or register to reply here.
Back
Top Bottom