x10003q – Activity – OutsideTheGarden Boards – Page 66

// ========================================================================= // SHORTCODE: Recent Team Transactions (Abbreviated Front Page Feed) // ========================================================================= /** * Shortcode to Display a Clean, Abbreviated Recent Transactions Feed for Front Pages * Usage: [otg_recent_transactions limit="10"] */ add_shortcode('otg_recent_transactions', 'otg_render_recent_transactions'); function otg_render_recent_transactions($atts) { global $wpdb; $transactions_table = 'otg_transactions'; // Parse attributes for row limit (default to 10 rows) $atts = shortcode_atts(array( 'limit' => 10, ), $atts); $limit = intval($atts['limit']); // Fetch the most recent transactions without filters or pagination $sql = " SELECT t.TransIndex, t.ID AS Player_ID, t.Partner AS Team_Name, DATE_FORMAT(t.Date, '%M %e, %Y') AS Transaction_Date, t.Name AS Player_Name, t.Transaction AS Transaction_Type, t.Included, t.Notes FROM {$transactions_table} AS t ORDER BY t.Date DESC, t.TransIndex DESC LIMIT %d "; $results = $wpdb->get_results($wpdb->prepare($sql, $limit)); // Build HTML Output Container $html = '

'; $html .= '

Recent Transactions

'; if (empty($results)) { $html .= '

No recent transactions found.

'; $html .= '

'; return $html; } // Render Compact Data Table (No Headers, matching the provided screenshot style) $html .= ''; $html .= ''; foreach ($results as $row) { $player_display = '-'; if (!empty($row->Player_Name)) { if (!empty($row->Player_ID)) { $profile_url = esc_url(home_url('/profile/?player_id=' . intval($row->Player_ID))); $player_display = '' . esc_html($row->Player_Name) . ''; } else { $player_display = esc_html($row->Player_Name); } } $tx_type = trim($row->Transaction_Type ?: ''); $tx_color = '#0073aa'; // default fallback color $tx_icon = ''; // Transaction Color & Icon Mapping based on requirements switch ($tx_type) { case 'Signed': case 'Resigned': $tx_color = '#ffd700'; // yellow $tx_icon = '$'; break; case 'Acquired': $tx_color = '#2ecc71'; // green $tx_icon = '＋'; break; case 'Traded': $tx_color = '#e74c3c'; // red $tx_icon = '−'; break; case 'Reassigned': $tx_color = '#1b4f72'; // darker blue $tx_icon = '& کاهش;'; // fallback down arrow symbol or character break; case 'Called Up': $tx_color = '#5dade2'; // lighter blue $tx_icon = '▲'; break; case 'Deceased': case 'Passed Away': $tx_color = '#ffffff'; // white $tx_icon = '🌹'; break; case 'Retired': $tx_color = '#f39c12'; // orange $tx_icon = '🪇'; break; case 'Lost on waivers': $tx_color = '#f1948a'; // light red $tx_icon = '✖'; break; case 'Waiver Claim': $tx_color = '#abeb78'; // light green $tx_icon = '✔'; break; case 'Signed PTO': $tx_color = '#ffd700'; // yellow $tx_icon = '$'; break; case 'Released from PTO': $tx_color = '#f39c12'; // orange $tx_icon = '✖'; break; case 'Contract Terminated': $tx_color = '#e74c3c'; // red $tx_icon = ''; break; default: $tx_color = '#0073aa'; $tx_icon = ''; break; } // Override arrow icon explicitly for Reassigned using clean unicode down arrow if ($tx_type === 'Reassigned') { $tx_icon = '▼'; } // 4th column displays the Notes field $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; } $html .= ''; $html .= '

' . esc_html($row->Transaction_Date ?: '-') . '

' . $player_display . '

' . $tx_icon . esc_html($row->Transaction_Type ?: '-') . '

' . esc_html($row->Notes ?: '-') . '

'; // Link at the bottom to go to the /transactions/ page $transactions_page_url = esc_url(home_url('/transactions/')); $html .= '

'; $html .= 'View All Transactions »'; $html .= '

'; $html .= ''; return $html; } x10003q – Activity – OutsideTheGarden Boards – Page 66

APRIL

Wed

7

Thu

8

Fri

9

Sat

10

7:00PM

Sun

11

Mon

12

Tue

13

x10003q

Group: Registered

Joined: 2023-09-04

Legend

Follow

	panarin and sheary out there with trocheck In forum Where Smit Hits The Fan	9 months ago
	dreaded last 1:06 In forum Where Smit Hits The Fan	9 months ago
	makar dirty wrap 2-2 In forum Where Smit Hits The Fan	9 months ago
	Trocheck should have shot that one instead of trying to pass... In forum Where Smit Hits The Fan	9 months ago
	Somebody shoved a cattle prod up laf s butt - he was all ove... In forum Where Smit Hits The Fan	9 months ago
	killed it In forum Where Smit Hits The Fan	9 months ago
	Miller is effed up from that collision - left arm was not mo... In forum Where Smit Hits The Fan	9 months ago
	nonsense call on Sheary - makar leans into Sheary and Sheary... In forum Where Smit Hits The Fan	9 months ago
	11:30 left Rangers have 1 shot - the goal In forum Where Smit Hits The Fan	9 months ago
	Flying in all alone - how do you not see that effin guy?????... In forum Where Smit Hits The Fan	9 months ago
	Makar gets a post In forum Where Smit Hits The Fan	9 months ago
	Carrick feeds Edstrom for the goal - 4th line - maybe Sully ... In forum Where Smit Hits The Fan	9 months ago
	Miller just does not have good acceleration in tight spaces ... In forum Where Smit Hits The Fan	9 months ago
	Laf with an open look misses the net - again In forum Where Smit Hits The Fan	9 months ago
	end of 1 - weak shit like that from Panarin never ends In forum Where Smit Hits The Fan	9 months ago

Page 66 / 417 Prev Next