אין תקציר עריכה |
אין תקציר עריכה |
||
| שורה 13: | שורה 13: | ||
-->{{#vardefine: PlayerEvent|{{המרות/תיאור אירוע לשליפת משחקים למספר אירוע| אירוע={{{PlayerAction|}}} }} }}<!-- | -->{{#vardefine: PlayerEvent|{{המרות/תיאור אירוע לשליפת משחקים למספר אירוע| אירוע={{{PlayerAction|}}} }} }}<!-- | ||
-->{{#vardefine: PlayerSubEvent|{{תבנית: המרות/תיאור תת אירוע למספר תת אירוע| תת אירוע={{{PlayerSubAction|}}} }} }}<!-- | -->{{#vardefine: PlayerSubEvent|{{תבנית: המרות/תיאור תת אירוע למספר תת אירוע| תת אירוע={{{PlayerSubAction|}}} }} }}<!-- | ||
-->{{#vardefine: PlayerEvent2|{{המרות/תיאור אירוע לשליפת משחקים למספר אירוע| אירוע={{{PlayerAction2|}}} }} }}<!-- | |||
-->{{#vardefine: PlayerSubEvent2|{{תבנית: המרות/תיאור תת אירוע למספר תת אירוע| תת אירוע={{{PlayerSubAction2|}}} }} }}<!-- | |||
-->{{#cargo_query: | -->{{#cargo_query: | ||
tables=Games_Catalog, Competitions_Catalog, Games_Results, Games_Events, Days_In_Week, Games_Videos | tables=Games_Catalog, Competitions_Catalog, Games_Results, Games_Events, Games_Events as Events2, Days_In_Week, Games_Videos | ||
|join on=Games_Catalog.Competition = Competitions_Catalog.CompID | |join on=Games_Catalog.Competition = Competitions_Catalog.CompID | ||
,Games_Catalog.ResultOpt = Games_Results.ResultType | ,Games_Catalog.ResultOpt = Games_Results.ResultType | ||
| שורה 20: | שורה 22: | ||
,Games_Catalog.MatchDay = Days_In_Week.DayNumber | ,Games_Catalog.MatchDay = Days_In_Week.DayNumber | ||
,Games_Catalog._pageID = Games_Videos._pageID | ,Games_Catalog._pageID = Games_Videos._pageID | ||
,Games_Events._pageID = Events2._pageID | |||
|where=1=1 | |where=1=1 | ||
And Games_Events.Team = 1 | And Games_Events.Team = 1 | ||
| שורה 34: | שורה 37: | ||
{{#if: {{{OpponentGoals|}}} | AND Games_Catalog.ResultOpponent {{#var: GoalsForOpponentOperator}} {{{OpponentGoals}}} }} | {{#if: {{{OpponentGoals|}}} | AND Games_Catalog.ResultOpponent {{#var: GoalsForOpponentOperator}} {{{OpponentGoals}}} }} | ||
{{#if: {{{GameResult|}}} | AND Games_Results.ResultString = "{{{GameResult}}}" }} | {{#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}}) }} | ||
| שורה 39: | שורה 43: | ||
{{#if: {{{PlayerSubAction|}}} | AND Games_Events.SubType IN ({{#var: PlayerSubEvent}}) }} | {{#if: {{{PlayerSubAction|}}} | AND Games_Events.SubType IN ({{#var: PlayerSubEvent}}) }} | ||
{{#if: {{{PlayerSubActionMinute|}}} | AND Games_Events.Minute = {{{PlayerSubActionMinute}}} }} | {{#if: {{{PlayerSubActionMinute|}}} | AND Games_Events.Minute = {{{PlayerSubActionMinute}}} }} | ||
{{#if: {{{Player2|}}} | AND Events2.PlayerName= "{{{Player2}}}" }} | |||
{{#if: {{{PlayerAction2|}}} | AND Events2.EventType IN ({{#var: PlayerEvent2}}) }} | |||
{{#if: {{{PlayerActionMinute2|}}} | AND Events2.Minute = {{{PlayerActionMinute2}}} }} | |||
{{#if: {{{PlayerSubAction2|}}} | AND Events2.SubType IN ({{#var: PlayerSubEvent2}}) }} | |||
{{#if: {{{PlayerSubActionMinute2|}}} | AND Events2.Minute = {{{PlayerSubActionMinute2}}} }} | |||
{{#if: {{{GameDayInWeek|}}} | AND Games_Catalog.MatchDay = {{{GameDayInWeek}}} }} | {{#if: {{{GameDayInWeek|}}} | AND Games_Catalog.MatchDay = {{{GameDayInWeek}}} }} | ||
{{#ifeq: {{{FullGame|}}}| רק משחקים עם משחק מלא| AND Games_Videos.FullGame IS NOT NULL}} | {{#ifeq: {{{FullGame|}}}| רק משחקים עם משחק מלא| AND Games_Videos.FullGame IS NOT NULL}} | ||
גרסה מ־01:23, 9 באוגוסט 2020
ערכו את הדף כדי לצפות בטקסט התבנית.