#1  
Old 09-16-2014, 03:43 PM
wilmheath wilmheath is offline
Newbie
 
Join Date: Feb 2012
Location: Wilmington, NC
Courses Played: 2
Posts: 11
Looking for tournament reporting software

Have any clubs had software built for their website and might be willing to pass on the name of their developer so we can hire them for our website?

http://www.newhanoverdgc.com/scoreboard.php We have to do all of this by hand currently and I'm looking for someone that is able to do it via mysql/php. If you have any information feel free to reply here or send me a pm. Any help is appreciated.
Reply With Quote
  #2  
Old 09-16-2014, 04:53 PM
ejvogie's Avatar
ejvogie ejvogie is offline
* Ace Member *
 
Join Date: Sep 2008
Location: Toledo, OH
Years Playing: 6.1
Courses Played: 61
Throwing Style: RHBH
Posts: 3,305
I feel your pain. I used to do this via Excel spreadsheet, but we stopped doing point series because it wasn't drawing any additional interest.
Reply With Quote
  #3  
Old 09-16-2014, 05:05 PM
riltim riltim is offline
Par Member
 
Join Date: Mar 2011
Location: Lehigh Valley, PA
Years Playing: 3.7
Courses Played: 24
Throwing Style: LHBH
Posts: 105
What do you mean by "do it by hand"? Like manually edit the html file?
Reply With Quote
  #4  
Old 09-16-2014, 05:07 PM
wilmheath wilmheath is offline
Newbie
 
Join Date: Feb 2012
Location: Wilmington, NC
Courses Played: 2
Posts: 11
Quote:
Originally Posted by riltim View Post
What do you mean by "do it by hand"? Like manually edit the html file?
Yeah we have to manually edit the html file and then resort it all after we edit it. Can take up to 2 hours if we have a lot of people show up.
Reply With Quote
  #5  
Old 09-16-2014, 05:13 PM
j0atz's Avatar
j0atz j0atz is offline
Double Eagle Member
 
Join Date: Aug 2010
Location: DFW, TX
Years Playing: 4.4
Courses Played: 35
Throwing Style: RHBH
Posts: 1,773
Yeah, that's a pain. I have actually been throwing around the idea of creating something for this with PHP/MYSQL. I would be interested to get some of your thoughts on how you would want to interface with it.
Reply With Quote
  #6  
Old 09-16-2014, 05:20 PM
wilmheath wilmheath is offline
Newbie
 
Join Date: Feb 2012
Location: Wilmington, NC
Courses Played: 2
Posts: 11
Here is an e-mail I sent to someone else that was thinking about doing it:

"Disc golf reporting:

Problem: Currently we manually update our monthly results on this site here: http://www.newhanoverdgc.com/scoreboard.php It takes a long time to do manually

Solution: I would like to have a password protected backend where a user can log in to a secure website and post scores which are automatically updated on the home page.

How I envision it working:

When you log into the backend the first thing you do is select the month and year that you are updating and which league they are in(such as pro, am, rec, etc.) There is a pull down menu with all of the current users in it. You select the user that you want and you can add the results from the tournament. If the user is not in the database there will be a place to add a new user. A user would consist of just their name or nickname but would need to be a unique name.

When you post a user’s score you would post the score for the first round, second round and payout if applicable. Once you submit all of the user’s scores it would post them to the results for that specific month as you can see on the current scoreboard page. Click the January results for an example. You would take round 1 + round 2 for the total and then you award points based on a 20 point system. First place gets 20 all the way through 20th place which gets 1. 1 point is the least you can get. People that “Do Not Finish” or DNF as you see it on the website get the amount that the person in last place got divided by 2, rounded down. When there is a tie in points both people share the same amount of points and then the person with the next highest score gets the amount that he would of gotten regardless of a tie. You can look at some of the past months that were scored for some examples of ties and how they work.

After we submit the results for a specific league it would update the “points race”. The points race shows how many points each player got every month and keeps a tally of their totals. We use the top 8 scores of the year for each person and rank them by their current total. We only do a points race for Pro and Amateur.

We would need a way to select which year to display on the website along with a way to display past year’s tournaments. I really like the current layout and would like to keep that if possible.
"
Reply With Quote
  #7  
Old 09-16-2014, 05:28 PM
ejvogie's Avatar
ejvogie ejvogie is offline
* Ace Member *
 
Join Date: Sep 2008
Location: Toledo, OH
Years Playing: 6.1
Courses Played: 61
Throwing Style: RHBH
Posts: 3,305
I had an Excel spreadsheet I would update, and the save as a web page. I'd then open the page in Wordpad (I know, I know) and copy all the relevant data and post it to the website from there.
Reply With Quote
  #8  
Old 09-16-2014, 05:35 PM
j0atz's Avatar
j0atz j0atz is offline
Double Eagle Member
 
Join Date: Aug 2010
Location: DFW, TX
Years Playing: 4.4
Courses Played: 35
Throwing Style: RHBH
Posts: 1,773
Spreadsheet methods will always be the easiest way to go. You could always design the spreadsheet to look like it does on the site and just screenshot it and just put an image of it on there or something.
Reply With Quote
  #9  
Old 09-16-2014, 06:18 PM
Grayson's Avatar
Grayson Grayson is offline
Newbie
 
Join Date: Jun 2007
Location: Tupelo, MS
Years Playing: 36.3
Courses Played: 44
Throwing Style: RHBH
Posts: 7
spreadsheet

Not sure if you saw this but this spreadsheet performs the points allocation you mentioned and ranks them ... all per division. I included some test players to test and validate. I believe it performs as desired.

Download the sheet, newhanover.xlsx.

The sheet uploads to the DB but the DB does allocate points slightly different.
Reply With Quote
 

  #10  
Old 09-16-2014, 08:26 PM
wilmheath wilmheath is offline
Newbie
 
Join Date: Feb 2012
Location: Wilmington, NC
Courses Played: 2
Posts: 11
Quote:
Originally Posted by Grayson View Post
Not sure if you saw this but this spreadsheet performs the points allocation you mentioned and ranks them ... all per division. I included some test players to test and validate. I believe it performs as desired.

Download the sheet, newhanover.xlsx.

The sheet uploads to the DB but the DB does allocate points slightly different.
Wow, thanks I will try this out. I would still like a long term solution that automatically updates the site with formatting but this may hold us over for a bit.
Reply With Quote
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 12:09 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.