CuyllRanger – Activity – OutsideTheGarden Boards – Page 41

/** * Import landing summary data and update game stats, ensuring robust empty-net goal detection. * * @param int $game_id * @param array $landing_data * @return bool */ function otg_import_landing_summary($game_id, $landing_data) { global $wpdb; $table_goals = $wpdb->prefix . 'otg_game_goals'; if (empty($landing_data) || !isset($landing_data['summary']['scoring'])) { return false; } $scoring_periods = $landing_data['summary']['scoring']; foreach ($scoring_periods as $period) { if (empty($period['goals'])) { continue; } foreach ($period['goals'] as $goal) { $goal_id = intval($goal['eventId'] ?? 0); $goal_modifier = sanitize_text_field($goal['goalModifier'] ?? ''); $landing_modifier = sanitize_text_field($goal['landingModifier'] ?? ''); // Robust direct empty net evaluation using the official API goal node properties $is_empty_net = 0; if (isset($goal['emptyNet']) && $goal['emptyNet'] === true) { $is_empty_net = 1; } elseif (in_array(strtolower($goal_modifier), ['empty-net', 'en', 'empty-net-goal'], true) || in_array(strtolower($landing_modifier), ['empty-net', 'en', 'empty-net-goal'], true)) { $is_empty_net = 1; } // Update database record for the specific goal event $wpdb->update( $table_goals, ['is_empty_net' => $is_empty_net], [ 'game_id' => $game_id, 'goal_id' => $goal_id ], ['%d'], ['%d', '%d'] ); } } return true; } /** * Backfill season empty-net goals using play-by-play data payloads. * * @param int $season * @return void */ function otg_backfill_season_empty_net_goals($season) { global $wpdb; $table_goals = $wpdb->prefix . 'otg_game_goals'; $table_games = $wpdb->prefix . 'otg_games'; // Retrieve completed games for the designated season $games = $wpdb->get_results($wpdb->prepare( "SELECT game_id, pbp_json FROM $table_games WHERE season = %d AND status = 'OFF'", $season )); foreach ($games as $game) { $game_id = intval($game->game_id); $pbp_data = json_decode($game->pbp_json, true); if (empty($pbp_data) || !isset($pbp_data['plays'])) { continue; } foreach ($pbp_data['plays'] as $play) { if (($play['typeCode'] ?? 0) !== 505) { // 505 represents a goal event in the NHL API continue; } $details = $play['details'] ?? []; $goal_id = intval($play['eventId'] ?? 0); $is_empty_net = false; if (!empty($details['emptyNet']) && $details['emptyNet'] === true) { $is_empty_net = true; } elseif (in_array(strtolower($play['goalModifier'] ?? ''), ['empty-net', 'en', 'empty-net-goal'], true)) { $is_empty_net = true; } if ($is_empty_net) { $wpdb->update( $table_goals, ['is_empty_net' => 1], [ 'game_id' => $game_id, 'goal_id' => $goal_id ], ['%d'], ['%d', '%d'] ); } } } } CuyllRanger – Activity – OutsideTheGarden Boards – Page 41

JANUARY

Wed

15

Thu

16

Fri

17

Sat

18

Sun

19

Mon

20

Tue

21

CuyllRanger

Group: Registered

Joined: 2024-12-02

Hall of Famer

3

Follow

	Johnny B is a great soldier under appreciated but a... In forum Where Smit Hits The Fan	9 months ago
	Rangers showed some want in winning tonight which is somethi... In forum Where Smit Hits The Fan	9 months ago
	Break up the Rangers. In forum Where Smit Hits The Fan	9 months ago
	Big kill. In forum Where Smit Hits The Fan	9 months ago
	These not totally invested in winning are piling up. And th... In forum Where Smit Hits The Fan	9 months ago
	Robertsons hometown and sits out first game here. That sucks... In forum Where Smit Hits The Fan	9 months ago
	Turn down the power play and punt. In forum Where Smit Hits The Fan	9 months ago
	Dave in love with Shearys dump in. In forum Where Smit Hits The Fan	9 months ago
	Soucy = Scrub. In forum Where Smit Hits The Fan	9 months ago
	Garrick with fluke. 2-0 take it, get changed quick and the h... In forum Where Smit Hits The Fan	9 months ago
	Rangers hanging on. In forum Where Smit Hits The Fan	9 months ago
	Sullsheary fails to clear twice. In forum Where Smit Hits The Fan	9 months ago
	Asinine to have Lafreniere who is better on left wing playin... In forum Where Smit Hits The Fan	9 months ago
	Soucy doing Soucy things off to the box. In forum Where Smit Hits The Fan	9 months ago
	Gotta like Laba’s compete level, very evident his last shift... In forum Where Smit Hits The Fan	9 months ago

Page 41 / 213 Prev Next