תבנית:QueryGamesTemplate: הבדלים בין גרסאות בדף
מתוך מכביפדיה
אין תקציר עריכה
(Allow to query games without players events, don't execute the PlayersEventInSameMinute if content every search)
שורה 19: שורה 19:
We use the hacky way of concating all player related params in order to "turn on" the check for Team=1,
We use the hacky way of concating all player related params in order to "turn on" the check for Team=1,
There are some games without any maccabi players, we dont want to avoid querying them if we can avoid it (means we search for the game data and not players data).
There are some games without any maccabi players, we dont want to avoid querying them if we can avoid it (means we search for the game data and not players 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, Football_Games_Uniforms
tables=Games_Catalog, Competitions_Catalog, Games_Results, Games_Events, Games_Events=Events2, Days_In_Week, Games_Videos, Football_Games_Uniforms
שורה 63: שורה 62:
{{#if: {{{PlayerSubActionMinute2|}}} | AND Events2.Minute = {{{PlayerSubActionMinute2}}} }}
{{#if: {{{PlayerSubActionMinute2|}}} | AND Events2.Minute = {{{PlayerSubActionMinute2}}} }}


{{#if: {{{PlayersEventsInSameMinute|}}} | AND Events2.Minute = Games_Events.Minute }}
{{#ifeq: {{{PlayersEventsInSameMinute|}}}| כן| AND Events2.Minute = Games_Events.Minute }}





גרסה מ־03:30, 12 ביוני 2021

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

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