get_row( $wpdb->prepare( 'SELECT id, goal_id, status FROM ' . $wpdb->prefix . 'sg_donations WHERE id = %d', $donationId ), ARRAY_A ); if ( ! is_array( $row ) || 'completed' !== ( $row['status'] ?? '' ) || (int) $row['goal_id'] <= 0 ) { return array(); } $goalId = (int) $row['goal_id']; $repo = new TierRepository( $wpdb ); if ( ! $repo->forGoal( $goalId ) ) { return array(); } $raised = ( new \StreamGoals\Core\GoalRepository( $wpdb ) )->raised_minor( $goalId ); return $repo->markReached( $goalId, $raised, $donationId ); } catch ( \Throwable $e ) { error_log( 'StreamGoals: tier unlock failed for donation ' . $donationId . ': ' . $e->getMessage() ); // phpcs:ignore WordPress.PHP.DevelopmentFunctions return array(); } } }