Różnice między wybraną wersją a wersją aktualną.
| Both sides previous revision Poprzednia wersja Nowa wersja | Poprzednia wersja | ||
|
pl:dydaktyka:ztb:2011:projekty:trener:projekt_logiczny [2011/06/19 20:40] ztb2011 |
pl:dydaktyka:ztb:2011:projekty:trener:projekt_logiczny [2019/06/27 15:50] (aktualna) |
||
|---|---|---|---|
| Linia 153: | Linia 153: | ||
| ==== Usuwanie meczu ==== | ==== Usuwanie meczu ==== | ||
| - | update fth_players set pl_matches = pl_matches - 1, | + | update fth_players set pl_matches = pl_matches - 1, pl_goals = pl_goals - ( |
| - | pl_goals = pl_goals - ( | + | |
| - | select count(*) from fth_stats | + | select count(*) from fth_stats |
| - | where sts_match = 1 | + | where sts_match = 1 |
| AND sts_player = 79 | AND sts_player = 79 | ||
| AND sts_event ='G'), | AND sts_event ='G'), | ||
| - | pl_ycards = pl_ycards - ( | + | pl_ycards = pl_ycards - ( |
| - | select count(*) from fth_stats | + | select count(*) from fth_stats |
| - | where sts_match = 1 | + | where sts_match = 1 |
| AND sts_player = 79 | AND sts_player = 79 | ||
| AND sts_event ='Y'), | AND sts_event ='Y'), | ||
| - | pl_rcards = pl_rcards - ( | + | pl_rcards = pl_rcards - ( |
| - | select count(*) from fth_stats | + | select count(*) from fth_stats |
| - | where sts_match = 1 | + | where sts_match = 1 |
| AND sts_player = 79 | AND sts_player = 79 | ||
| - | AND sts_event ='R') | + | AND sts_event ='R') where pl_id =79; |
| - | where pl_id =79; | + | |
| - | delete from fth_match_set where mset_match = 1; | + | delete from fth_match_set where mset_match = 1; |
| - | delete from fth_stats where sts_match = 1; | + | |
| - | delete from fth_matches where mts_id = 1; | + | delete from fth_stats where sts_match = 1; |
| + | |||
| + | delete from fth_matches where mts_id = 1; | ||
| ==== Dodawanie transferu ==== | ==== Dodawanie transferu ==== | ||
