(Game_Events_Catalog->Games_Events) |
(Games_Results_Catalog->Games_Results) |
||
| שורה 13: | שורה 13: | ||
-->{{#vardefine: PlayerEvent|{{תבנית: המרות/תיאור אירוע למספר אירוע| אירוע={{{PlayerAction|}}} }} }}<!-- | -->{{#vardefine: PlayerEvent|{{תבנית: המרות/תיאור אירוע למספר אירוע| אירוע={{{PlayerAction|}}} }} }}<!-- | ||
-->{{#cargo_query: | -->{{#cargo_query: | ||
tables=Games_Catalog, Opponents, Competitions_Catalog, Stadiums_Catalog, | tables=Games_Catalog, Opponents, Competitions_Catalog, Stadiums_Catalog, Games_Results, Games_Events, Days_In_Week | ||
|join on=Games_Catalog.Opponent = Opponents._ID | |join on=Games_Catalog.Opponent = Opponents._ID | ||
,Games_Catalog.Competition = Competitions_Catalog.CompID | ,Games_Catalog.Competition = Competitions_Catalog.CompID | ||
,Games_Catalog.Stadium = Stadiums_Catalog.StadiumID | ,Games_Catalog.Stadium = Stadiums_Catalog.StadiumID | ||
,Games_Catalog.ResultOpt = | ,Games_Catalog.ResultOpt = Games_Results.ResultType | ||
,Games_Catalog._pageID=Games_Events._pageID | ,Games_Catalog._pageID=Games_Events._pageID | ||
,Games_Catalog.MatchDay=Days_In_Week.DayNumber | ,Games_Catalog.MatchDay=Days_In_Week.DayNumber | ||
| שורה 33: | שורה 33: | ||
{{#if: {{{MaccabiGoalsDifferent|}}} | AND Games_Catalog.ResultMaccabi - Games_Catalog.ResultOpponent {{#var: GoalsDiffForMaccabiOperator}} {{{MaccabiGoalsDifferent}}} }} | {{#if: {{{MaccabiGoalsDifferent|}}} | AND Games_Catalog.ResultMaccabi - Games_Catalog.ResultOpponent {{#var: GoalsDiffForMaccabiOperator}} {{{MaccabiGoalsDifferent}}} }} | ||
{{#if: {{{OpponentGoals|}}} | AND Games_Catalog.ResultOpponent {{#var: GoalsForOpponentOperator}} {{{OpponentGoals}}} }} | {{#if: {{{OpponentGoals|}}} | AND Games_Catalog.ResultOpponent {{#var: GoalsForOpponentOperator}} {{{OpponentGoals}}} }} | ||
{{#if: {{{GameResult|}}} | AND | {{#if: {{{GameResult|}}} | AND Games_Results.ResultString = "{{{GameResult}}}" }} | ||
{{#if: {{{Player|}}} | AND Games_Events.PlayerName= "{{{Player}}}" }} | {{#if: {{{Player|}}} | AND Games_Events.PlayerName= "{{{Player}}}" }} | ||
{{#if: {{{PlayerAction|}}} | AND Games_Events.EventType IN ({{#var: PlayerEvent}}) }} | {{#if: {{{PlayerAction|}}} | AND Games_Events.EventType IN ({{#var: PlayerEvent}}) }} | ||
| שורה 49: | שורה 49: | ||
,Games_Catalog.ResultMaccabi=תוצאה למכבי | ,Games_Catalog.ResultMaccabi=תוצאה למכבי | ||
,Games_Catalog.ResultOpponent=תוצאה ליריבה | ,Games_Catalog.ResultOpponent=תוצאה ליריבה | ||
, | ,Games_Results.ResultString=תוצאת משחק <!-- Cast number to string from games results table --> | ||
,CONCAT('[[', Games_Catalog.CoachMaccabi, ']]')=מאמן מכבי | ,CONCAT('[[', Games_Catalog.CoachMaccabi, ']]')=מאמן מכבי | ||
,CONCAT('[[', Games_Catalog.CoachOpponent, ']]')=מאמן יריבה | ,CONCAT('[[', Games_Catalog.CoachOpponent, ']]')=מאמן יריבה | ||
גרסה מ־19:12, 11 בדצמבר 2018
ערכו את הדף כדי לצפות בטקסט התבנית.