/** * 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 75 NYR v PIT 7:00pm MSG – Page 3 – Hit The Road Jake – OutsideTheGarden Boards
FEBRUARY
«
Wed
17
Thu
18
7:00PM
Fri
19
Sat
20
NHL Stadium Series
NHL Stadium Series
12:00PM
Sun
21
1:00PM
Mon
22
Tue
23
7:00PM
»
Forums
Categories
Hit The Road Jake
GAME 75 NYR v PIT 7...
 
Notifications
Clear all

GAME 75 NYR v PIT 7:00pm MSG

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

Rangers were due a clunker I guess...but yeah


ReplyQuote
Topic starter Posted : 01/04/2024 6:49 pm
x10003q
 x10003q
(@x10003q)
Legend

kakko is so average.


1 Cup in 86 years
2048

ReplyQuote
Posted : 01/04/2024 7:06 pm
Doug Glatt
 Doug Glatt
(@pierre_pdare)
Legend

Posted by: @Anonymous
↑

The boo birds are out for Miller.

He is so dumb and does not know when to be physical....He is the second coming of Tom Poti.... He needs some press box time.

 


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

ReplyQuote
Posted : 01/04/2024 7:07 pm
x10003q
 x10003q
(@x10003q)
Legend

malkin has always been a guy to spear/slash and then the fucker complains. What a douche.


1 Cup in 86 years
2048

ReplyQuote
Posted : 01/04/2024 7:10 pm
Doug Glatt
 Doug Glatt
(@pierre_pdare)
Legend

waved off


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

ReplyQuote
Posted : 01/04/2024 7:11 pm
 Anonymous 4
(@Anonymous 4)

Kreider was in the crease but still a terrible call.


ReplyQuote
Posted : 01/04/2024 7:12 pm
Fish
 Fish
(@fish)
Member Moderator

Don't see that often, but Kreider made contact with Ned before the puck went in


ReplyQuote
Topic starter Posted : 01/04/2024 7:12 pm
 Anonymous 4
(@Anonymous 4)

Going to be one of those nights.


ReplyQuote
Posted : 01/04/2024 7:13 pm
x10003q
 x10003q
(@x10003q)
Legend

CK engaged gets the goal called off.


1 Cup in 86 years
2048

ReplyQuote
Posted : 01/04/2024 7:13 pm
Doug Glatt
 Doug Glatt
(@pierre_pdare)
Legend

Miller you suck


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

ReplyQuote
Posted : 01/04/2024 7:14 pm
Doug Glatt
 Doug Glatt
(@pierre_pdare)
Legend

Darren Turcotte


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

ReplyQuote
Posted : 01/04/2024 7:20 pm
x10003q
 x10003q
(@x10003q)
Legend

Roslovic misses a CK cross ice pass


1 Cup in 86 years
2048

ReplyQuote
Posted : 01/04/2024 7:20 pm
 Anonymous 4
(@Anonymous 4)

Mark Pavelich.

All goals.


ReplyQuote
Posted : 01/04/2024 7:21 pm
Doug Glatt reacted
x10003q
 x10003q
(@x10003q)
Legend

Don Murdoch or Alex Kovalev -


1 Cup in 86 years
2048

ReplyQuote
Posted : 01/04/2024 7:24 pm
Fish
 Fish
(@fish)
Member Moderator

Posted by: @x10003q
↑

Don Murdoch or Alex Kovalev -

Yeah I thought Murdoch too

 


ReplyQuote
Topic starter Posted : 01/04/2024 7:26 pm
Page 3 / 5
Forum Jump:
  Previous Topic
Next Topic  
Share: