/** * Automatically aggregate games from otg_rangers_games and update/insert otg_coach_statistics. */ private static function sync_rangers_season_stats($coach_id, $season) { global $wpdb; if ($coach_id <= 0 || empty($season)) { echo '

Invalid Coach or Season specified for sync.

'; return; } // 1. Regular Season Calculation (game_type = 2) $reg_sql = $wpdb->prepare( "SELECT COUNT(*) as gc, SUM(CASE WHEN rangers_score > opponent_score THEN 1 ELSE 0 END) as wins, SUM(CASE WHEN rangers_score < opponent_score AND overtime_status != 'OT' AND overtime_status != 'SO' THEN 1 ELSE 0 END) as losses, SUM(CASE WHEN rangers_score = opponent_score THEN 1 ELSE 0 END) as ties, SUM(CASE WHEN rangers_score < opponent_score AND overtime_status = 'OT' THEN 1 ELSE 0 END) as ot, SUM(CASE WHEN rangers_score < opponent_score AND overtime_status = 'SO' THEN 1 ELSE 0 END) as sol, SUM(CASE WHEN rangers_score > opponent_score AND overtime_status = 'SO' THEN 1 ELSE 0 END) as sow FROM otg_rangers_games WHERE game_type = 2 AND season = %s", $season ); $reg = $wpdb->get_row($reg_sql); // 2. Playoff Calculation (game_type = 3) - Fetching series/opponent details ordered by date/game $playoff_games_sql = $wpdb->prepare( "SELECT opponent, rangers_score, opponent_score FROM otg_rangers_games WHERE game_type = 3 AND season = %s ORDER BY game_date ASC, game_id ASC", $season ); $playoff_games = $wpdb->get_results($playoff_games_sql); $gc = $reg->gc ? intval($reg->gc) : 0; $w = $reg->wins ? intval($reg->wins) : 0; $l = $reg->losses ? intval($reg->losses) : 0; $t = $reg->ties !== null ? intval($reg->ties) : 0; $ot = $reg->ot !== null ? intval($reg->ot) : 0; $sol = $reg->sol !== null ? intval($reg->sol) : 0; $sow = $reg->sow !== null ? intval($reg->sow) : 0; $pgc = count($playoff_games); $pw = 0; $pl = 0; $pt = 0; $sw = 0; $sl = 0; $sc = 0; $scf = 0; if ($pgc > 0) { $series_records = []; $current_opponent = null; $opp_wins = 0; $nyr_wins = 0; foreach ($playoff_games as $g) { if (intval($g->rangers_score) > intval($g->opponent_score)) { $pw++; $nyr_wins++; } elseif (intval($g->rangers_score) < intval($g->opponent_score)) { $pl++; $opp_wins++; } else { $pt++; } if ($current_opponent === null) { $current_opponent = $g->opponent; $nyr_wins = (intval($g->rangers_score) > intval($g->opponent_score)) ? 1 : 0; $opp_wins = (intval($g->rangers_score) < intval($g->opponent_score)) ? 1 : 0; } elseif ($current_opponent !== $g->opponent) { // Previous series concluded because opponent changed if ($nyr_wins > $opp_wins) { $sw++; } else { $sl++; } $current_opponent = $g->opponent; $nyr_wins = (intval($g->rangers_score) > intval($g->opponent_score)) ? 1 : 0; $opp_wins = (intval($g->rangers_score) < intval($g->opponent_score)) ? 1 : 0; } } // Final series check after loop finishes if ($current_opponent !== null) { // Check if this was the Stanley Cup Finals (last series) and if they won the Cup (4 wins in final series or overall context, typically 4 wins wins a modern NHL playoff series) if ($nyr_wins > $opp_wins) { $sw++; // If it's the final round and they won, check if it's the Stanley Cup win // (Assuming final round win equates to SC = 1 if it's the ultimate round) } else { $sl++; } } // Determine if they won the Stanley Cup (e.g. won 4 rounds total, or check standard criteria) // If they won 4 series in a 4-round playoff format, they are Stanley Cup Champions if ($sw >= 4) { $sc = 1; $scf = 1; } elseif ($sw == 3 && $sl > 0) { $scf = 1; $sc = 0; } } $data = array( 'CoachID' => $coach_id, 'Team' => 'New York Rangers', 'League' => 'NHL', 'Season' => $season, 'GC' => $gc, 'W' => $w, 'L' => $l, 'T' => $t, 'OT' => $ot, 'SOL' => $sol, 'SOW' => $sow, 'PGC' => $pgc, 'PW' => $pw, 'PL' => $pl, 'PT' => $pt, 'SCF' => $scf, 'SC' => $sc, 'SW' => $sw, 'SL' => $sl, ); $existing = $wpdb->get_var($wpdb->prepare( "SELECT COUNT(*) FROM otg_coach_statistics WHERE CoachID = %d AND Season = %s AND Team = 'New York Rangers'", $coach_id, $season )); if ($existing > 0) { $wpdb->update('otg_coach_statistics', $data, array('CoachID' => $coach_id, 'Season' => $season, 'Team' => 'New York Rangers')); echo '

Successfully synced Rangers stats for season ' . esc_html($season) . '!

'; } else { $wpdb->insert('otg_coach_statistics', $data); echo '

Successfully inserted synced Rangers stats for season ' . esc_html($season) . '!

'; } } GAME 8: NYR v MIN – 7:00pm MSG – Hit The Road Jake – OutsideTheGarden Boards
DECEMBER
«
Wed
24
Thu
25
Fri
26
Sat
27
Sun
28
Mon
29
Tue
30
»
Forums
Categories
Hit The Road Jake
GAME 8: NYR v MIN -...
 
Notifications
Clear all

GAME 8: NYR v MIN - 7:00pm MSG

 
Page 1 / 4
    Last Post
 
Fish
 Fish
(@fish)
Member Moderator

Soucy looks like he'll be back in the line-up, though he'll be a game time decision.  Vaakanainen looks like the guy who'll drop out, meaning Robertson stays in


Quote
Topic starter Posted : 20/10/2025 11:30 am
mjolnir
 mjolnir
(@mjolnir)
Team MVP

You are correct.  Too bad we didn't get to see Morrow -- he was sent back to Hartford.


ReplyQuote
Posted : 20/10/2025 3:56 pm
Doug Glatt
 Doug Glatt
(@pierre_pdare)
Legend

 saw Soucy in the pre game skate and threw up a little 🤮 


If they need me to bleed, then I'll bleed for my team

ReplyQuote
Posted : 20/10/2025 5:49 pm
Doug Glatt
 Doug Glatt
(@pierre_pdare)
Legend

Rangers eed to have some jump from the first faceoff and put this scorless streak behind them... the longer it goes the harder you squeeze the stick


If they need me to bleed, then I'll bleed for my team

ReplyQuote
Posted : 20/10/2025 6:08 pm
x10003q
 x10003q
(@x10003q)
Legend

Zib to Panarin 1-0 first goal - fast start


1 Cup in 86 years
2048

ReplyQuote
Posted : 20/10/2025 6:11 pm
Doug Glatt
 Doug Glatt
(@pierre_pdare)
Legend

Bread breaks the SCHNEID


If they need me to bleed, then I'll bleed for my team

ReplyQuote
Posted : 20/10/2025 6:11 pm
x10003q
 x10003q
(@x10003q)
Legend

draw win - brodin shoots =, Laf deflects and it is a goal 1-1


1 Cup in 86 years
2048

ReplyQuote
Posted : 20/10/2025 6:18 pm
Doug Glatt
 Doug Glatt
(@pierre_pdare)
Legend

I missed it ... who efed up on that?


If they need me to bleed, then I'll bleed for my team

ReplyQuote
Posted : 20/10/2025 6:19 pm
Doug Glatt
 Doug Glatt
(@pierre_pdare)
Legend

Posted by: @x10003q
↑

draw win - brodin shoots =, Laf deflects and it is a goal 1-1

Keep Laf away from D zone face offs....

 


If they need me to bleed, then I'll bleed for my team

ReplyQuote
Posted : 20/10/2025 6:20 pm
x10003q
 x10003q
(@x10003q)
Legend

Posted by: @pierre_pdare
↑

I missed it ... who efed up on that?

bad puck luck as laf changed the flight of the puck into Igor

 


1 Cup in 86 years
2048

ReplyQuote
Posted : 20/10/2025 6:28 pm
x10003q
 x10003q
(@x10003q)
Legend

That last waved off Minn goal due to high stick was close


1 Cup in 86 years
2048

ReplyQuote
Posted : 20/10/2025 6:29 pm
x10003q
 x10003q
(@x10003q)
Legend

Panarin with another turnover on the Minn end


1 Cup in 86 years
2048

ReplyQuote
Posted : 20/10/2025 6:33 pm
x10003q
 x10003q
(@x10003q)
Legend

Rangers with a couple of long d shifts


1 Cup in 86 years
2048

ReplyQuote
Posted : 20/10/2025 6:36 pm
x10003q
 x10003q
(@x10003q)
Legend

Borgen delay of game PP MINN


1 Cup in 86 years
2048

ReplyQuote
Posted : 20/10/2025 6:39 pm
x10003q
 x10003q
(@x10003q)
Legend

Laba and Sheary on the PK


1 Cup in 86 years
2048

ReplyQuote
Posted : 20/10/2025 6:40 pm
Page 1 / 4
Forum Jump:
  Previous Topic
Next Topic  
Share: