| Author |
Messages |
|
osesu96
Posts:10
 |
| 03/09/2009 08:27 |
|
Why? This was a great module. If I don't have the source code, how hard is it to update the brackets? Do you have any documentation on how to update? I.e. what tables it uses, etc? I had hoped to use it again this year and though you do have the source code available, the fee is a little steep for my wallet.
Do you have any other options for us dedicated NCAA bracket users?
Regards.
|
|
|
|
|
host
Posts:497
|
| 03/09/2009 23:41 |
|
| Sorry, we will have some unavailability during this years tourney which will impact our ablity to support the module and given the time sensitivity of this particular module, we couldn't risk it. You are welcome to use last years module and modify the sql script yourself, it is fairly easy to do once you look at the sql scripts. Sorry for this years situation. |
|
|
|
|
osesu96
Posts:10
|
| 03/10/2009 21:59 |
|
Sure. Where can I locate the SQL script? If it can just clear out the old data and input the new teams, I can likely apply the SQL myself.
I hope you guys get back to this as it is a good module for sport sites. |
|
|
|
|
host
Posts:497
|
| 03/11/2009 06:04 |
|
| In the install file from last year, contained in the zip file, you can see how it works. |
|
|
|
|
hwilson
Posts:1
|
| 03/12/2009 19:06 |
|
| Wow.. that's disappointing. I was excited to get 2009 up and going.. I have 08 and it worked great.
Is there any way you could give us an update script and we could plug in the 09 teams.
I know some sql, but looking at the tables and scripts i think it's a bit much for me...
Or tell us what tables to delete the 08 info from.... just looking for some kind of guidance to do 09' myself |
|
|
|
|
host
Posts:497
|
| 03/13/2009 08:14 |
|
| Yeah, we're sorry, there are a number of people who have been using this module the last few years who are bumbed, unfortunately this year we couldn't make the update happen. Basically if you have last years zip file you used to install the module, open up the 1.04.01 script. This script modified the 2007 tourney to the 2008 tourney. In a nutshell, you delete the old game pairings, predictions and results. Then you go and add any new teams (which last year we just updated the team names of some of the unused teams with the new team name). Then you insert this years pairings when the bracket is released and that is it. The issue is the window from when the bracket is released to when you have to do this script. In our case, we'll have no availability those few days, so even though we have time today to work on the module to do the script, we won't when it is most critical. Hope this makes sense. |
|
|
|
|
mmeenan
Posts:8
|
| 03/16/2009 09:29 |
|
I did not think to modify the scripts from the install file. I used DTS to insert the parings and teams. I am seeing the bracket just fine. However, when teams are selected, the results are not saved. I can make my selections and click save, nothing is actaully saved.
I may have caused this by removing the contents of NCAAAPreceedingGames. Can I repopulate this or is another item the cause? |
|
|
|
|
mmeenan
Posts:8
|
| 03/16/2009 09:49 |
|
| Does anyone have the script alreeady created and willing to share? |
|
|
|
|
osesu96
Posts:10
|
| 03/16/2009 18:48 |
|
| I agree. Anyone with additional details on what can be deleted, updated. I have some idea how it works but not all. Anyone figure out the sql, let me know as well. |
|
|
|
|
osesu96
Posts:10
|
| 03/16/2009 18:56 |
|
Ok, found the sql script in question from last year. Look in the zip file for this file: 01.05.00.SqlDataProvider
when you look at this, the beginning has the tables that need deleting and then the team name changes for the teams and then the pairings. So just need to put a little work into it and it should come out ok.
Caveat: I think... :-) |
|
|
|
|
mmeenan
Posts:8
|
| 03/16/2009 21:33 |
|
I think my issue is related to the fact that I deleted everything in NCAAPreceedingGames. Can anyone script out their table with its contents?
|
|
|
|
|
osesu96
Posts:10
|
| 03/16/2009 22:28 |
|
I'd recommend reloading the module to repopulate that table. Here's the script:
/************************************************************/
/***** SQLDataProvider *****/
/***** NCAAPoolBracket *****/
/************************************************************/
/*
NOW LETS MAKE SOME DATA INSERTS FOR THE TEAMS AND INITIAL PAIRINGS
*/
/* ***** Put the name of the Nuke db below in the USE statement ***** */
Use [Database Name here]
--delete the team pairings, predictions, and results
delete from [NCAAPairings]
delete from [NCAAPredictions]
delete from [NCAAResults]
--Midwest
--Louisville
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id001',1,1)
--AL St./Morehead St.
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id002',2,16)
--Ohio St
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id003',3,8)
--Siena
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id004',4,9)
--Utah
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id005',5,5)
--Arizona
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id006',6,12)
--Wake Forest
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id007',7,4)
--Cleveland St
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id008',8,13)
--West Virginia
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id009',9,6)
--Dayton
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id010',10,11)
--Kansas
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id011',11,3)
--N Dakota St
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id012',12,14)
--Boston College
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id013',13,7)
--USC
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id014',14,10)
--Michigan St
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id015',15,2)
--Robert Morris
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id016',16,15)
--West
--UConn
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id017',49,1)
--Chattanooga
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id018',50,16)
--BYU
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id019',51,8)
--Texas A&M
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id020',52,9)
--Purdue
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id021',53,5)
--Northern Iowa
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id022',54,12)
--Washington
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id023',55,4)
--Miss. St.
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id024',56,13)
--Marquette
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id025',57,6)
--Utah St.
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id026',58,11)
--Missouri
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id027',59,3)
--Cornell
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id028',60,14)
--Cal
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id029',61,7)
--Maryland
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id030',62,10)
--Memphis
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id031',63,2)
--CSU Northridge
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id032',64,15)
--South
--N.C.
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id033',17,1)
--Radford
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id034',18,16)
--LSU
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id035',19,8)
--Butler
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id036',20,9)
--Illinois
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id037',21,5)
--W. Kentucky
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id038',22,12)
--Gonzaga
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id039',23,4)
--Akron
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id040',24,13)
--Arizona St.
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id041',25,6)
--Temple
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id042',26,11)
--Syracuse
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id043',27,3)
--Stephen F. Austin
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id044',28,14)
--Clemson
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id045',29,7)
--Michigan
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id046',30,10)
--Oklahoma
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id047',31,2)
--Morgan St.
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id048',32,15)
--East
--Pitt
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id049',33,1)
--E. Tenn St.
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id050',34,16)
--Ok. St
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id051',35,8)
--Tennessee
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id052',36,9)
--Florida St.
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id053',37,5)
--Wisconsin
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id054',38,12)
--Xavier
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id055',39,4)
--Portland St.
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id056',40,13)
--UCLA
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id057',41,6)
--VCU
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id058',42,11)
--Villanova
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id059',43,3)
--American
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id060',44,14)
--Texas
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id061',45,7)
--Minnesota
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id062',46,10)
--Duke
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id063',47,2)
--Binghampton
INSERT INTO [NCAAPairings] ([GameId],[TeamId],[TeamSeed])VALUES('id064',48,15)
|
|
|
|
|
osesu96
Posts:10
|
| 03/16/2009 22:29 |
|
| NOTE: Use at your own risk!!!! |
|
|
|
|
mmeenan
Posts:8
|
| 03/16/2009 23:12 |
|
Thanks, just finished doing just that and reloaded my teams and pairings. I'd used DTS to transfer them in. Bracket is working for me now.
For clarification, I removed and reinstalled the module, then DTS transferred my teams and pairings back into the DB.
Good luck to all.
|
|
|
|
|
osesu96
Posts:10
|
| 03/16/2009 23:17 |
|
Hey mmeenan, keep in mind I had to manually update the NCAA Teams table and put those values in the SQL query I posted... just make sure your "teams" table has the same teams/IDs, etc... The IDs I used were the ones I created from scratch in that table...
forgot to post that earlier... |
|
|
|
|
mmeenan
Posts:8
|
| 03/19/2009 10:33 |
|
Need a quick tip. I missed that my teams are not playing the right group in the semis. I should have Midwest meeting West and East meeting South. I do NOT. I have East meeting MidWest and West meeting South. Anyone think of a quick fix?
|
|
|
|
|
mmeenan
Posts:8
|
| 03/19/2009 12:58 |
|
| Got the teams fixed. Only issue now is going in and fixing the regional titles so that they match the proper regions. (Not the same as last year.) I'm surprised that is not in the DB. |
|
|
|
|
|