/** * 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) . '!

'; } } Kreider?? – Hit The Road Jake – OutsideTheGarden Boards
JANUARY
«
Wed
27
7:30PM
Thu
28
Fri
29
7:00PM
Sat
30
7:00PM
Sun
31
Mon
1
Tue
2
»
Forums
Categories
Hit The Road Jake
Kreider??
 
Notifications
Clear all

Kreider??

 
    Last Post
 
CuyllRanger
 CuyllRanger
(@cuyllranger)
Hall of Famer

How do you go 19 games without a assist? Almost impossible. His total lack of leadership and to to many invisible games is unacceptable. Time to move on from this guy. Cuylle totally capable of being the net front guy, and he might even mix it up while there. Kreider has a 15 team no trade list so might be the most moveable, and justified Vet to trade.


Quote
Topic starter Posted : 25/11/2024 12:06 pm
Fish
 Fish
(@fish)
Member Moderator

Well he'll sit out tonight with an upper body injury....oh and

image

ReplyQuote
Posted : 25/11/2024 1:58 pm
Doug Glatt
 Doug Glatt
(@pierre_pdare)
Legend

Good luck trying to get any value for a 33 year old power forward who now talks about his (chronic???) back issues

 

Funny how you never hear about what an injury issue is with a player but now we all know Kreider has back issues...


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

ReplyQuote
Posted : 27/11/2024 5:28 pm
CuyllRanger
 CuyllRanger
(@cuyllranger)
Hall of Famer

Posted by: @pierre_pdare
↑

Good luck trying to get any value for a 33 year old power forward who now talks about his (chronic???) back issues

 

Funny how you never hear about what an injury issue is with a player but now we all know Kreider has back issues...

Almost like he’s trying to devalue his value.

 


ReplyQuote
Topic starter Posted : 27/11/2024 6:52 pm
mjolnir reacted
Fish
 Fish
(@fish)
Member Moderator

Posted by: @pierre_pdare
↑

Good luck trying to get any value for a 33 year old power forward who now talks about his (chronic???) back issues

Funny how you never hear about what an injury issue is with a player but now we all know Kreider has back issues...

I wondered whether it was more a way to deflect the conversation rather than a major issue.  I've had a back issues at times in my life, but managed to find ways to recover and have it not effect me for years after.  Not sure what specifically is wrong with Kreider's back, but don't think it's necessarily a big deal.  That, and he has 10 goals this year, which is something that GMs still value, especially on the PP from a forward. 

I think there'll be plenty of offers for him if he's truly available, but given how early we are in the season, not sure there's a lot who feel they have to make that move yet...which is more the problem.

 


ReplyQuote
Posted : 05/12/2024 3:04 pm
x10003q
 x10003q
(@x10003q)
Legend

Posted by: @cuyllranger
↑

Posted by: @pierre_pdare
↑

Good luck trying to get any value for a 33 year old power forward who now talks about his (chronic???) back issues

 

Funny how you never hear about what an injury issue is with a player but now we all know Kreider has back issues...

Almost like he’s trying to devalue his value.

 

Any trade partners get to medically exam him and see his medical history.

 


1 Cup in 86 years
2048

ReplyQuote
Posted : 06/12/2024 2:29 pm
Forum Jump:
  Previous Topic
Next Topic  
Share: