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; } Doug Glatt – Activity – OutsideTheGarden Boards – Page 53
AUGUST
«
Wed
12
Thu
13
Fri
14
Sat
15
Sun
16
Mon
17
Tue
18
»
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
Doug Glatt
Doug Glatt
@pierre_pdare
Forum Home   |   Recent Posts
Legend
Joined: August 26, 2023 2:21 pm
Last seen: September 28, 2026 11:06 am
Profile Activity
Topics: 113 / Replies: 5271
AllTopicsReplies
Reply
RE: Pre-Season BOS @ NYR 4 P.M.

Fox will be paired with Gavrikov...Let's see if Fox sucked last year because of his partners

1 year ago
Forum
Where Smit Hits The Fan
Reply
RE: Mathew Robertson

I saw Miller do that 100 times

1 year ago
Forum
Where Smit Hits The Fan
Reply
RE: Pre-Season Gane 1 NYR@NJD 1:00 NHL Net

Sheary playing like his life depends on it.

1 year ago
Forum
Where Smit Hits The Fan
Topic
Pre-Season Gane 1 NYR@NJD 1:00 NHL Net
1 year ago
Forum
Where Smit Hits The Fan
Replies: 5
Views: 1141
Reply
RE: Steady Eddie Passes

RIP Eddie

1 year ago
Forum
Where Smit Hits The Fan
Reply
RE: Miller named captain

Not many other choices here... I have low expectations for him so anything positive would be a plus. Cuylle will be Capt. in a couple of years.

1 year ago
Forum
Where Smit Hits The Fan
Reply
RE: Next Year's trade deadline / UFA targets.

Would be a nice get but he has 2yrs. @ $5.5M per left on his contract...I don't know what it would take to pry him away from the Habs but he is the ty...

1 year ago
Forum
Where Smit Hits The Fan
Reply
RE: McDavid?

McDavid will cost whatever the new league max is ~$20M/ for 7 years... That can be 4 or 5 players that fill important roles and resigning players like...

1 year ago
Forum
Where Smit Hits The Fan
Topic
Off Season Fun
1 year ago
Forum
Where Smit Hits The Fan
Replies: 3
Views: 640
Reply
RE: Next Year's trade deadline / UFA targets.

Not saying build thru UFA but fill needs with players, not a player, that can add to a teams overall improvement.... Like Graves, Chara, Niedermayer. ...

1 year ago
Forum
Where Smit Hits The Fan
Topic
Next Year's trade deadline / UFA targets.
1 year ago
Forum
Where Smit Hits The Fan
Replies: 5
Views: 737
Reply
RE: NYR sign Trey Fix-Wolansky

Who's on first

1 year ago
Forum
Where Smit Hits The Fan
Reply
RE: Miller trade to Carolina for 1st, 2nd and Scott Morrow

I think that is quite a haul for Miller the slacker... I wonder how long he will last in Carolina where Brind'amour plays fast. I think we got a bette...

1 year ago
Forum
Where Smit Hits The Fan
Reply
RE: Drury working on deal to send K'Andre Miller to Carolina

Conditional 1st a 2nd and a depth defenseman Scott Morrow

1 year ago
Forum
Where Smit Hits The Fan
Reply
RE: Drury working on deal to send K'Andre Miller to Carolina

Hearing Miller now signed 8 years $60M and waiting to hear what is coming back from Carolina

1 year ago
Forum
Where Smit Hits The Fan
Page 53 / 359
TOP