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:19] ztb2011 |
pl:dydaktyka:ztb:2011:projekty:trener:projekt_logiczny [2019/06/27 15:50] (aktualna) |
||
|---|---|---|---|
| Linia 153: | Linia 153: | ||
| ==== Usuwanie meczu ==== | ==== Usuwanie meczu ==== | ||
| - | delete from fth_matches | + | update fth_players set pl_matches = pl_matches - 1, pl_goals = pl_goals - ( |
| - | where mts_id = 3; | + | |
| + | select count(*) from fth_stats | ||
| + | where sts_match = 1 | ||
| + | AND sts_player = 79 | ||
| + | AND sts_event ='G'), | ||
| + | pl_ycards = pl_ycards - ( | ||
| + | select count(*) from fth_stats | ||
| + | where sts_match = 1 | ||
| + | AND sts_player = 79 | ||
| + | AND sts_event ='Y'), | ||
| + | pl_rcards = pl_rcards - ( | ||
| + | select count(*) from fth_stats | ||
| + | where sts_match = 1 | ||
| + | AND sts_player = 79 | ||
| + | AND sts_event ='R') where pl_id =79; | ||
| + | |||
| + | 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; | ||
| ==== Dodawanie transferu ==== | ==== Dodawanie transferu ==== | ||
| Linia 166: | Linia 186: | ||
| ==== Dodawanie roli ==== | ==== Dodawanie roli ==== | ||
| + | insert into fth_roles values(51,'TRN','trainer'); | ||
