SHOW:
|
|
- or go back to the newest paste.
| 1 | UPDATE bb_team_finances f | |
| 2 | SET league_today_revenue = league_today_revenue + ( | |
| 3 | - | SELECT CASE WHEN m.playoff_status = 'SIX PLACE' THEN s.league_revenue_of_6th_team |
| 3 | + | SELECT CASE |
| 4 | - | WHEN m.playoff_status = 'FINAL' THEN s.league_final_revenue |
| 4 | + | WHEN m.playoff_status = 'SIX PLACE' THEN s.league_revenue_of_6th_team |
| 5 | - | ELSE 0 |
| 5 | + | WHEN m.playoff_status = 'WILD CARD GAME' THEN s.league_revenue_of_wild_card |
| 6 | - | END |
| 6 | + | WHEN m.playoff_status = 'DIVISION SERIES' THEN s.league_revenue_of_division_series |
| 7 | WHEN m.playoff_status = 'SEMI-FINAL' THEN s.league_revenue_of_semi_final | |
| 8 | - | JOIN bb_manager m ON s.level = m.level |
| 8 | + | WHEN m.playoff_status = 'CHAMPION' THEN s.league_revenue_of_champion |
| 9 | WHEN m.playoff_status = 'FINAL' THEN s.league_final_revenue | |
| 10 | ELSE s.league_revenue_of_the_rest | |
| 11 | END | |
| 12 | FROM bb_level_settings s | |
| 13 | JOIN bb_manager m ON s.level = m.level | |
| 14 | WHERE m.bb_team_info_id = f.bb_team_info_id) |
