NCAA BK

CBK Scores

Share This Story

foxsports admin

 
   
 
<% set cur_time [fs_time_getUserTime] set cur_time [ns_fmttime $cur_time "%Y%m%d"] set confId [ns_queryget "conf"] set displayType [ns_queryget "categoryId"] set dayDesired [ns_queryget "yearCode"] if {$dayDesired != ""} { if {[ns_queryget "monthCode"] < 10} {append dayDesired 0} append dayDesired [ns_queryget "monthCode"] if {[ns_queryget "dayCode"] < 10} {append dayDesired 0} append dayDesired [ns_queryget "dayCode"] } ##current day of games if {$dayDesired == $cur_time || $dayDesired == ""} { if {$displayType == "135"} { set pageName "NCAA Tourney Scores and Scheds" set xslt_file "/SiteElement/Xsl/CBK/Scoreboard" set xml_file "/netapp/scores/CBK.XML" set tourney_code "1" } elseif {$displayType == "140"} { set pageName "NIT Scores and Scheds" set xslt_file "/SiteElement/Xsl/CBK/Non25_Scoreboard" set xml_file "/netapp/scores/CBK.XML" set tourney_code "2" } elseif {$confId != ""} { set pageName "College Basketball Scoreboard" set conference $confId set xslt_file "/scores/cbk/cbk25_conf_sb_xsl.adp" set xml_file "/netapp/scores/CBK.XML" try { append xml_output [fs_xml_processLiveStatsIncXml $xslt_file $xml_file] } catch errorMsg { fs_log error "Problem processing XML\n$errorInfo\n$errorCode" } set xslt_file "/SiteElement/Xsl/CBK/Non25_Scoreboard" set xml_file "/livexml/CBK/CBK_SCORES.XML" } else { set pageName "College Basketball Top 25 Scoreboard" set xslt_file "/SiteElement/Xsl/CBK/Scoreboard" set xml_file "/livexml/CBK/CBK_SCORES.XML" } try { set db [fs_db_getHandle] set logicalName [fs_cms_content_getByLogicalName $db $xslt_file] set contentId [ns_set get $logicalName "content_id"] set subtypeCode [ns_set get $logicalName "content_subtype_code"] set xslt_file [fs_cms_getBlobPath $db $contentId $subtypeCode -load] } catch errorMsg { fs_log error "$errorMsg\n$errorInfo\n$errorCode\n" return } finally { fs_db_releaseHandle $db } try { append xml_output [fs_xml_processLiveStatsIncXml $xslt_file $xml_file] } catch errorMsg { fs_log error "Problem processing XML\n$errorInfo\n$errorCode" } if {$displayType == 135 || $displayType == 140} { if {$xml_output != ""} { regsub -all "( |\n|\r)" $xml_output {} tester set tester set tester "[string length $tester]" if {$tester < 40} { try { set db [fs_db_getHandle] set calendarDate [fs_time_oraDate [fs_time_getUserTime]] set sql "select distinct cs.vc_home_city, cs.vc_away_city, cs.n_game_id, TO_CHAR(new_time(cs.d_central_time, 'CST', 'EST'), 'Dy, Mon. fmDD, HHfm:MI p.m.') AS start_time, cs.d_central_time from cbk_schedule cs where cs.n_tournament = :tourney_code and TRUNC(new_time(cs.d_central_time, 'CST', 'EST')) between to_date(:calendarDate, 'YYYY-MM-DD') and (to_date(:calendarDate, 'YYYY-MM-DD') + 2) order by cs.d_central_time asc" set xml_output [fs_db_listResultSet $db [ns_ora select $db $sql]] set display_type "before" } catch errorMsg { fs_log error "$errorMsg\n$errorInfo\n$errorCode\n" return } finally { fs_db_releaseHandle $db } ## clean up unset db unset sql } } } } else { ## previous/upcoming games if {$displayType == "135"} { set pageName "NCAA Tourney Scores and Scheds" set xslt_file_alt "/scores/cbk/cbk_final_boxscores_xsl.adp" set sql "select distinct cs.vc_home_city, cs.vc_away_city, cs.n_game_id,TO_CHAR(new_time(cs.d_central_time, 'CST', 'EST'), 'fmHHfm:MI p.m.') AS start_time, $dayDesired as game_day, cs.d_central_time from cbk_schedule cs where cs.n_tournament = 1 and substr(cs.n_game_id, 1, 8) = :dayDesired order by cs.d_central_time asc" } elseif {$displayType == "140"} { set pageName "NIT Scores and Scheds" set xslt_file_alt "/scores/cbk/cbknon_final_boxscores_xsl.adp" set sql "select cs.vc_home_city, cs.vc_away_city, cs.n_game_id, TO_CHAR(new_time(cs.d_central_time, 'CST', 'EST'),'fmHHfm:MI p.m.') AS start_time ,$dayDesired as game_day, cs.d_central_time from cbk_schedule cs where n_tournament = 2 and substr(n_game_id, 1, 8) = :dayDesired order by cs.d_central_time asc" } try { set db [fs_db_getHandle] set xml_temp [fs_db_listResultSet $db [ns_ora select $db $sql]] } catch errorMsg { fs_log error "$errorMsg\n$errorInfo\n$errorCode\n" return } finally { fs_db_releaseHandle $db } set display_type "after" set xslType "scores" foreach item $xml_temp { set gameId [ns_set get $item "n_game_id"] if {$displayType == "140"} { set xml_file_alt "/livexml/CBK/CBK_FINALBOX_NONTOP\$${gameId}.XML" } else { set xml_file_alt "/livexml/CBK/CBK_FINALBOX\$${gameId}.XML" } try { append xml_output [fs_xml_processLiveStatsIncXml $xslt_file_alt $xml_file_alt] } catch errorMsg { fs_log error "Problem processing XML\n$errorInfo\n$errorCode" } } if {$xml_temp != ""} { regsub -all "( |\n|\r)" $xml_output {} tester set tester set tester "[string length $tester]" if {$tester < 40} { set display_type "before" set xml_output $xml_temp } } else { set xml_output "Games to be determined." } } %>
All time ET
Error at Error Error
Score
Error
Error

Error at Error Error
" class="hed">Preview Score
Error
Error

Can't find calendar widget Can't find calendar widget



More Stories From foxsports admin



NCAA BK Videos

Georgetown, Syracuse to renew CBK rivalry Posted: Jun 10, 2014
Georgetown basketball coach John Thompson III on the renewal of the rivalry betw...

Cuonzo Martin new head coach at Cal Posted: Apr 16, 2014
Cuonzo Martin is introduced as Cal's new head coach.

UConn tops Notre Dame in women's final Posted: Apr 09, 2014
Hear from Geno Auriemma and his players after their National Championship victor...

Fox Sports Store

    itemName itemURL imageSrc price itemDescription
    Nike Florida Gators #1 Replica Elite Basketball Jersey - Black http://shop.foxsports.com/FOX_Florida_Gators/browse/featuredproduct/885881/source/foxsports_prsp_ca http://images.footballfanatics.com/FFImage/thumb.aspx?i=/productImages/_885000/ff_885881_xl.jpg&w=100 74.95 Nike Florida Gators #1 Replica Elite Basketball Jersey - Black
    Nike Georgetown Hoyas #22 Hyper Elite Road Performance Jersey - Navy Blue http://shop.foxsports.com/FOX_Georgetown_Hoyas/browse/featuredproduct/1030243/source/foxsports_prsp_ca http://images.footballfanatics.com/FFImage/thumb.aspx?i=/productImages/_1030000/ff_1030243_xl.jpg&w=100 119.95 Nike Georgetown Hoyas #22 Hyper Elite Road Performance Jersey - Navy Blue
    Nike Duke Blue Devils #5 Tourney Takeover Replica T-Shirt - Duke Blue http://shop.foxsports.com/FOX_Duke_Blue_Devils/browse/featuredproduct/1032710/source/foxsports_prsp_ca http://images.footballfanatics.com/FFImage/thumb.aspx?i=/productImages/_1032000/ff_1032710_xl.jpg&w=100 27.95 Nike Duke Blue Devils #5 Tourney Takeover Replica T-Shirt - Duke Blue
    Nike Oregon Ducks X-Ray Ball T-Shirt - Green http://shop.foxsports.com/FOX_Oregon_Ducks/browse/featuredproduct/1052002/source/foxsports_prsp_ca http://images.footballfanatics.com/FFImage/thumb.aspx?i=/productImages/_1052000/ff_1052002_xl.jpg&w=100 24.95 Nike Oregon Ducks X-Ray Ball T-Shirt - Green
    Nike Ohio State Buckeyes Road Warrior Tri-blend T-Shirt - Scarlet http://shop.foxsports.com/FOX_Ohio_State_Buckeyes/browse/featuredproduct/1052645/source/foxsports_prsp_ca http://images.footballfanatics.com/FFImage/thumb.aspx?i=/productImages/_1052000/ff_1052645_xl.jpg&w=100 29.95 Nike Ohio State Buckeyes Road Warrior Tri-blend T-Shirt - Scarlet
    Indiana Hoosiers 2013 NCAA Men\'s Basketball Road to March Madness T-Shirt - Crimson http://shop.foxsports.com/FOX_Indiana_Hoosiers/browse/featuredproduct/1124528/source/foxsports_prsp_ca http://images.footballfanatics.com/FFImage/thumb.aspx?i=/productImages/_1124000/ff_1124528_xl.jpg&w=100 19.95 Indiana Hoosiers 2013 NCAA Men\'s Basketball Road to March Madness T-Shirt - Cri..
    adidas Louisville Cardinals 2013 March Madness #10 Premier Swingman Jersey - Red http://shop.foxsports.com/FOX_Louisville_Cardinals/browse/featuredproduct/1127200/source/foxsports_prsp_ca http://images.footballfanatics.com/FFImage/thumb.aspx?i=/productImages/_1127000/ff_1127200_xl.jpg&w=100 89.95 adidas Louisville Cardinals 2013 March Madness #10 Premier Swingman Jersey - Red
    adidas Notre Dame Fighting Irish 2013 March Madness #45 Premier Swingman Jersey - White http://shop.foxsports.com/FOX_Notre_Dame_Fighting_Irish/browse/featuredproduct/1127218/source/foxsports_prsp_ca http://images.footballfanatics.com/FFImage/thumb.aspx?i=/productImages/_1127000/ff_1127218_xl.jpg&w=100 89.95 adidas Notre Dame Fighting Irish 2013 March Madness #45 Premier Swingman Jersey ..
    Nike Gonzaga Bulldogs March Madness Bracketville T-Shirt - Navy Blue http://shop.foxsports.com/FOX_Gonzaga_Bulldogs/browse/featuredproduct/1155821/source/foxsports_prsp_ca http://images.footballfanatics.com/FFImage/thumb.aspx?i=/productImages/_1155000/ff_1155821_xl.jpg&w=100 24.95 Nike Gonzaga Bulldogs March Madness Bracketville T-Shirt - Navy Blue
    Top of the World Miami Hurricanes 2013 NCAA ACC Men’s Basketball Tournament Champions Adjustable Hat – Green http://shop.foxsports.com/FOX_Miami_Hurricanes/browse/featuredproduct/1177723/source/foxsports_prsp_ca http://images.footballfanatics.com/FFImage/thumb.aspx?i=/productImages/_1177000/ff_1177723_xl.jpg&w=100 25.95 Top of the World Miami Hurricanes 2013 NCAA ACC Men’s Basketball Tournament Cham..