/** * 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 77 NYR @ DET &:00 PM- MSG – Hit The Road Jake – OutsideTheGarden Boards
FEBRUARY
«
Fri
13
Sat
14
Sun
15
Mon
16
Tue
17
Wed
18
Thu
19
»
Forums
Categories
Hit The Road Jake
GAME 77 NYR @ DET &...
 
Notifications
Clear all

GAME 77 NYR @ DET &:00 PM- MSG

 
Page 1 / 7
    Last Post
 
Doug Glatt
 Doug Glatt
(@pierre_pdare)
Legend

Red Wings are HUNGRY


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

Quote
Topic starter Posted : 05/04/2024 5:58 pm
CuyllRanger
 CuyllRanger
(@cuyllranger)
Hall of Famer

Where’s Joe finally fired?


ReplyQuote
Posted : 05/04/2024 6:02 pm
CuyllRanger
 CuyllRanger
(@cuyllranger)
Hall of Famer

What a record Quick has outstanding.


ReplyQuote
Posted : 05/04/2024 6:09 pm
Doug Glatt
 Doug Glatt
(@pierre_pdare)
Legend

Pretty high pace so far


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

ReplyQuote
Topic starter Posted : 05/04/2024 6:11 pm
Rangerjunkiekimmie
 Rangerjunkiekimmie
(@rangerjunkie)
NHL All Star

Lavi has made some great decisions this year, but Brodzinski doesn't make the 4th line a 4th line. Rempe does.


De Oppresso Liber..
from the left elites

ReplyQuote
Posted : 05/04/2024 6:16 pm
Doug Glatt
 Doug Glatt
(@pierre_pdare)
Legend

I knew Cuylle was going to score tomite


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

ReplyQuote
Topic starter Posted : 05/04/2024 6:17 pm
Rangerjunkiekimmie
 Rangerjunkiekimmie
(@rangerjunkie)
NHL All Star

Cuylle!!

1-0


De Oppresso Liber..
from the left elites

ReplyQuote
Posted : 05/04/2024 6:17 pm
Rangerjunkiekimmie
 Rangerjunkiekimmie
(@rangerjunkie)
NHL All Star

That didn't last long


De Oppresso Liber..
from the left elites

ReplyQuote
Posted : 05/04/2024 6:19 pm
Doug Glatt
 Doug Glatt
(@pierre_pdare)
Legend

how many goals by ex rangers tonite?


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

ReplyQuote
Topic starter Posted : 05/04/2024 6:20 pm
CuyllRanger
 CuyllRanger
(@cuyllranger)
Hall of Famer

Glad Copp is in Detroit. 😎


ReplyQuote
Posted : 05/04/2024 6:20 pm
Rangerjunkiekimmie
 Rangerjunkiekimmie
(@rangerjunkie)
NHL All Star

What's the over/under of Sam saying "good job"?


De Oppresso Liber..
from the left elites

ReplyQuote
Posted : 05/04/2024 6:24 pm
Rangerjunkiekimmie
 Rangerjunkiekimmie
(@rangerjunkie)
NHL All Star

Posted by: @pierre_pdare
↑

how many goals by ex rangers tonite?

That's the only 1

 


De Oppresso Liber..
from the left elites

ReplyQuote
Posted : 05/04/2024 6:24 pm
Doug Glatt
 Doug Glatt
(@pierre_pdare)
Legend

Posted by: @rangerjunkie
↑

What's the over/under of Sam saying "good job"?

438.5

 


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

ReplyQuote
Topic starter Posted : 05/04/2024 6:24 pm
Doug Glatt
 Doug Glatt
(@pierre_pdare)
Legend

Did y'all see Miller didn't let the guy coming out of the box get behind him?


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

ReplyQuote
Topic starter Posted : 05/04/2024 6:30 pm
Rangerjunkiekimmie
 Rangerjunkiekimmie
(@rangerjunkie)
NHL All Star

Posted by: @pierre_pdare
↑

Posted by: @rangerjunkie
↑

What's the over/under of Sam saying "good job"?

438.5

 

Hahaha I'll take the over

 


De Oppresso Liber..
from the left elites

ReplyQuote
Posted : 05/04/2024 6:31 pm
Page 1 / 7
Forum Jump:
  Previous Topic
Next Topic  
Share: