/** * 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 67: NYR @ CBJ 7:00pm – Hit The Road Jake – OutsideTheGarden Boards
JANUARY
«
Thu
14
Fri
15
Sat
16
12:00PM
Sun
17
6:00PM
Mon
18
Tue
19
7:00PM
Wed
20
»
Forums
Categories
Hit The Road Jake
GAME 67: NYR @ CBJ ...
 
Notifications
Clear all

GAME 67: NYR @ CBJ 7:00pm

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

Fox back in, appears Soucy will sit


Quote
Topic starter Posted : 15/03/2025 5:51 pm
CuyllRanger
 CuyllRanger
(@cuyllranger)
Hall of Famer

Must win? Gotta keep Ottawa in the sights.


ReplyQuote
Posted : 15/03/2025 6:00 pm
CuyllRanger
 CuyllRanger
(@cuyllranger)
Hall of Famer

Schneider should be moved up the lineup. Time to see if he can play with Fox. 


ReplyQuote
Posted : 15/03/2025 6:04 pm
Doug Glatt
 Doug Glatt
(@pierre_pdare)
Legend

I would have sat Vaakaheineken


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

ReplyQuote
Posted : 15/03/2025 6:08 pm
Doug Glatt
 Doug Glatt
(@pierre_pdare)
Legend

So we are going to have 2 smurfs on D?... You go in the cage...cage goes in the water....shark's in the water...


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

ReplyQuote
Posted : 15/03/2025 6:09 pm
CuyllRanger
 CuyllRanger
(@cuyllranger)
Hall of Famer

Trochek get your friggin head in the game. 


ReplyQuote
Posted : 15/03/2025 6:11 pm
x10003q
 x10003q
(@x10003q)
Legend

lazy Laf skating lets Zib do the hard work and gets a goal 1-0


1 Cup in 86 years
2048

ReplyQuote
Posted : 15/03/2025 6:11 pm
Doug Glatt
 Doug Glatt
(@pierre_pdare)
Legend

Laf scores in to the wide open net.... Which is about the only way he can score


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

ReplyQuote
Posted : 15/03/2025 6:11 pm
CuyllRanger
 CuyllRanger
(@cuyllranger)
Hall of Famer

Nice play Zib even Laf couldn’t miss that.


ReplyQuote
Posted : 15/03/2025 6:12 pm
Doug Glatt
 Doug Glatt
(@pierre_pdare)
Legend

MF'ers falling all over the place.... Ice must be slippery... 🤣 🤣 🤣 


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

ReplyQuote
Posted : 15/03/2025 6:13 pm
x10003q reacted
x10003q
 x10003q
(@x10003q)
Legend

Rangers trying to get to 3 minutes without giving up a goal in the first!


1 Cup in 86 years
2048

ReplyQuote
Posted : 15/03/2025 6:13 pm
x10003q
 x10003q
(@x10003q)
Legend

Posted by: @pierre_pdare
↑

MF'ers falling all over the place.... Ice must be slippery... 🤣 🤣 🤣 

Vaaka just slipped

 


1 Cup in 86 years
2048

ReplyQuote
Posted : 15/03/2025 6:15 pm
x10003q
 x10003q
(@x10003q)
Legend

zib with a check away from the puck!!!


1 Cup in 86 years
2048

ReplyQuote
Posted : 15/03/2025 6:15 pm
CuyllRanger
 CuyllRanger
(@cuyllranger)
Hall of Famer

Bérard should be in the lineup every game. 


ReplyQuote
Posted : 15/03/2025 6:15 pm
CuyllRanger
 CuyllRanger
(@cuyllranger)
Hall of Famer

A Mika shank. 


ReplyQuote
Posted : 15/03/2025 6:16 pm
Page 1 / 5
Forum Jump:
  Previous Topic
Next Topic  
Share: