function otg_render_opening_night_page($atts) { global $wpdb; // 1. Get the current active season from otg_rangers_season_settings $active_season = $wpdb->get_var(" SELECT season FROM otg_rangers_season_settings WHERE active_season = 'y' LIMIT 1 "); // Fallback if no active_season row is flagged if (empty($active_season)) { $active_season = $wpdb->get_var(" SELECT season FROM otg_rangers_season_settings ORDER BY season DESC LIMIT 1 "); } // 2. Look up the earliest regular season game (game_type = 2) for that active season $opening_game = $wpdb->get_row($wpdb->prepare(" SELECT * FROM otg_rangers_games WHERE season = %s AND game_type = 2 AND (home_team_abbr = 'NYR' OR away_team_abbr = 'NYR') ORDER BY game_date ASC, game_id ASC LIMIT 1 ", $active_season)); // Fallback if active season schedule is not yet in otg_rangers_games if (!$opening_game) { $opening_game = $wpdb->get_row(" SELECT * FROM otg_rangers_games WHERE game_type = 2 AND (home_team_abbr = 'NYR' OR away_team_abbr = 'NYR') ORDER BY game_date DESC, game_id ASC LIMIT 1 "); } // 3. Determine Opponent Abbreviation and Logos $game_id = $opening_game ? intval($opening_game->game_id) : 0; $opp_abbr = ''; if ($opening_game) { $opp_abbr = ($opening_game->home_team_abbr === 'NYR') ? $opening_game->away_team_abbr : $opening_game->home_team_abbr; } $nyr_logo = function_exists('otg_get_team_logo') ? otg_get_team_logo('NYR', $active_season) : ''; $opp_logo = ($opp_abbr && function_exists('otg_get_team_logo')) ? otg_get_team_logo($opp_abbr, $active_season) : ''; // ========================================================================= // RENDER LAYOUT // ========================================================================= $html = '
'; $html .= ''; // Header Block $html .= '
'; $html .= '

New York Rangers — Opening Night Preview (' . esc_html($active_season) . ')

'; if ($opp_abbr) { $html .= '

Season Opener Matchup: NYR vs ' . esc_html($opp_abbr) . '

'; } $html .= '
'; // Main Layout Flex Split $html .= '
'; $html .= '
'; // 1. All-Time Opening Night Games vs. Current Opponent if ($opp_abbr) { $html .= otg_render_opening_nights_vs_opponent($opp_abbr, $opp_logo); } // 2. Skater Stats (Last 10 Opening Nights) $html .= otg_render_opening_night_skater_stats($nyr_logo); // 3. Goaltender Stats (Last 10 Opening Nights) $html .= otg_render_opening_night_goalie_stats($nyr_logo); // 4. All-Time Top 25 Opening Night Skaters $html .= otg_render_top_25_opening_night_skaters(); // 5. All-Time Top 10 Opening Night Goaltenders $html .= otg_render_top_10_opening_night_goalies(); // 6. Current Ranger Injuries Summary Table if (function_exists('otg_render_preview_injuries_section')) { $html .= otg_render_preview_injuries_section(); } $html .= '
'; // Close left column // Right Sidebar $html .= '
'; // Sidebar: Game Log (Last 10 Opening Nights) $html .= otg_render_opening_night_history_sidebar(); $html .= '
'; return $html; } New York Rangers In The System
JULY
«
Sat
18
Sun
19
Mon
20
NHL Arbitration
Tue
21
NHL Arbitration
Wed
22
NHL Arbitration
Thu
23
NHL Arbitration
Fri
24
NHL Arbitration
»
Sep 26
ANA 1312-1144-271
2
LAK 2167-2103-312
6
PRESEASON • FINAL
Sep 26
CAR 1248-945-247
6
NSH 1174-930-229
0
PRESEASON • FINAL
Sep 26
COL 1488-974-225
0
UTA 92-73-23
2
PRESEASON • FINAL
Sep 26
PIT 2376-2055-299
3
BUF 2208-1847-290
1
PRESEASON • FINAL
Sep 26
SEA 202-209-47
3
VAN 2025-2050-292
4
PRESEASON • FINAL
Sep 26
WSH 2144-1751-310
5
PHI 2542-1843-340
1
PRESEASON • FINAL
Sep 26
STL 2400-2023-293
2
CHI 2800-2585-316
3
PRESEASON • FINAL
Sep 26
CGY 1881-1512-290
1
EDM 2006-1593-292
4
PRESEASON • FINAL
Sep 26
CBJ 941-972-228
4
DET 2963-2473-321
2
PRESEASON • FINAL
Sep 26
NJD 1810-1490-284
4
NYI 2123-1887-299
1
PRESEASON • FINAL
Sep 26
SJS 1389-1267-274
4
VGK 511-284-94
2
PRESEASON • FINAL
Sep 26
MTL 3422-2160-340
3
OTT 1319-1219-253
4
PRESEASON • FINAL
Sep 26
OTT 1319-1219-253
2
MTL 3422-2160-340
4
PRESEASON • FINAL
Sep 26
TBL 1421-1188-242
3
FLA 1258-1103-285
2
PRESEASON • FINAL
Sep 29
FLA 0-0-0
5:00 PM
CAR 0-0-0
Upcoming
Sep 29
MTL 0-0-0
7:00 PM
TOR 0-0-0
Upcoming
Sep 29
NYR 0-0-0
8:00 PM
BOS 0-0-0
Upcoming
Sep 29
VAN 0-0-0
10:00 PM
EDM 0-0-0
Upcoming
Sep 29
CHI 0-0-0
10:30 PM
VGK 0-0-0
Upcoming
Sep 30
PIT 0-0-0
7:30 PM
PHI 0-0-0
Upcoming
Sep 30
NYI 0-0-0
7:30 PM
TOR 0-0-0
Upcoming
Sep 30
LAK 0-0-0
10:00 PM
COL 0-0-0
Upcoming
Oct 1
PHI 0-0-0
7:00 PM
NJD 0-0-0
Upcoming
Oct 1
TBL 0-0-0
7:00 PM
NYR 0-0-0
Upcoming
Oct 1
BUF 0-0-0
7:00 PM
CBJ 0-0-0
Upcoming
Oct 1
MIN 0-0-0
8:00 PM
NSH 0-0-0
Upcoming
Oct 1
SEA 0-0-0
9:00 PM
CGY 0-0-0
Upcoming
Oct 1
CHI 0-0-0
9:30 PM
UTA 0-0-0
Upcoming
Oct 1
EDM 0-0-0
10:00 PM
VAN 0-0-0
Upcoming
Oct 1
FLA 0-0-0
10:00 PM
SJS 0-0-0
Upcoming
Oct 2
NYR 0-0-0
6:30 PM
DET 0-0-0
Upcoming
Oct 2
WSH 0-0-0
7:00 PM
CAR 0-0-0
Upcoming
Oct 2
BOS 0-0-0
8:00 PM
WPG 0-0-0
Upcoming
Oct 2
STL 0-0-0
9:00 PM
DAL 0-0-0
Upcoming
Oct 2
ANA 0-0-0
10:00 PM
VGK 0-0-0
Upcoming
Total College / US Players
6
Average Age
19.3
Average Height
6-3
Average Weight
194 lbs
Forwards
Avg Age: 20Avg Ht: 6-3Avg Wt: 200 lbs
Name Position League Birthplace Country Birthday Age Hand Height Weight
Malcolm Spence Left Wing NCAANCAA - Univ. of Michigan Mississauga, ON Canada September 22, 2006 19 Left 6-1 190
Ty Henricks Left Wing NCAANCAA - Western Michigan Univ. Mission Viejo, CA United States June 28, 2005 21 Left 6-4 209
Defense
Avg Age: 19Avg Ht: 6-3Avg Wt: 191 lbs
Name Position League Birthplace Country Birthday Age Hand Height Weight
Ben MacBeath Defenseman NCAANCAA - Denver University Calgary, AB Canada March 4, 2008 18 Left 6-2 188
EJ Emery Defenseman NCAANCAA - Univ. of North Dakota Compton, CA United States March 30, 2006 20 Right 6-4 183
Felix Farhammar Defenseman USHLUSHL - Muskegon Lumberjacks Stockholm Sweden April 11, 2007 19 Left 6-0 184
Sean Barnhill Defenseman NCAANCAA - Michigan State Univ. Scottsdale, AZ United States January 8, 2007 19 Right 6-6 209
Goaltenders
Avg Age: 0Avg Ht: 0-0Avg Wt: 0 lbs
Name Position League Birthplace Country Birthday Age Hand Height Weight
No players found for this category.
TOP