תבנית:QueryGamesTemplate: הבדלים בין גרסאות בדף
מתוך מכביפדיה
אין תקציר עריכה
(הוספת תמיכה בהצגת המדים של מכבי)
שורה 21: שורה 21:
Without 'PlayersEventsInSameMinute', because that param will be 'False' as default (so it contains data).
Without 'PlayersEventsInSameMinute', because that param will be 'False' as default (so it contains data).
-->{{#cargo_query:
-->{{#cargo_query:
tables=Games_Catalog, Competitions_Catalog, Games_Results, Games_Events, Games_Events=Events2, Days_In_Week, Games_Videos
tables=Games_Catalog, Competitions_Catalog, Games_Results, Games_Events, Games_Events=Events2, Days_In_Week, Games_Videos, Football_Games_Uniforms
|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
שורה 28: שורה 28:
         ,Games_Catalog._pageID = Games_Videos._pageID  
         ,Games_Catalog._pageID = Games_Videos._pageID  
         ,Games_Events._pageID = Events2._pageID
         ,Games_Events._pageID = Events2._pageID
        ,Games_Catalog._pageID = Football_Games_Uniforms._pageID
|where=1=1
|where=1=1
{{#if: {{{Player|}}}{{{PlayerAction|}}}{{{PlayerActionMinute|}}}{{{PlayerSubAction|}}}{{{PlayerSubActionMinute|}}}{{{Player2|}}}{{{PlayerAction2|}}}{{{PlayerActionMinute2|}}}{{{PlayerSubAction2|}}}{{{PlayerSubActionMinute2|}}}| And Games_Events.Team = 1}}
{{#if: {{{Player|}}}{{{PlayerAction|}}}{{{PlayerActionMinute|}}}{{{PlayerSubAction|}}}{{{PlayerSubActionMinute|}}}{{{Player2|}}}{{{PlayerAction2|}}}{{{PlayerActionMinute2|}}}{{{PlayerSubAction2|}}}{{{PlayerSubActionMinute2|}}}| And Games_Events.Team = 1}}
שורה 44: שורה 45:
{{#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: {{{Uniforms|}}} |  AND Football_Games_Uniforms.KitName = "{{{Uniforms}}}" }}


{{#if: {{{Player|}}} |  AND Games_Events.PlayerName= "{{{Player}}}" }}
{{#if: {{{Player|}}} |  AND Games_Events.PlayerName= "{{{Player}}}" }}
שורה 82: שורה 85:
           ,CONCAT('[', Games_Videos.FullGame,  ' לינק]')=משחק מלא
           ,CONCAT('[', Games_Videos.FullGame,  ' לינק]')=משחק מלא
           ,CONCAT('[', Games_Videos.Highlights, ' לינק]')=תקציר
           ,CONCAT('[', Games_Videos.Highlights, ' לינק]')=תקציר
          ,CONCAT('[[', 'מדי עונת ', Football_Games_Uniforms.Season, '|', Football_Games_Uniforms.KitName, ']]' )=מדים,


|limit=5000
|limit=5000

גרסה מ־12:43, 19 בספטמבר 2020

לינק לעמוד לחיפוש משחקים

ערכו את הדף כדי לצפות בטקסט התבנית.