תבנית:SearchBasketballGames: הבדלים בין גרסאות בדף
מתוך מכביפדיה
(יצירת דף עם התוכן "<noinclude> לינק לעמוד לחיפוש משחקים ערכו את הדף כדי לצפות בטקסט התבנית. </noinclude><includeonly><!-- Define local parameters: -->{{#vardefine: ScoreForMaccabiOperator| {{#בחר:{{{MaccabiScoreAction|}}}|מתחת ל=<|בדיוק==|מעל ל=> }} }}<!-- -->{{#vardefine: ScoreForOpponentOperator| {{#בח...")
 
אין תקציר עריכה
 
(4 גרסאות ביניים של אותו משתמש אינן מוצגות)
שורה 5: שורה 5:
</noinclude><includeonly><!--
</noinclude><includeonly><!--
Define local parameters:
Define local parameters:
                         -->{{#vardefine: ScoreForMaccabiOperator| {{#בחר:{{{MaccabiScoreAction|}}}|מתחת ל=<|בדיוק==|מעל ל=> }} }}<!--
                         -->{{#vardefine: PointsForMaccabiOperator| {{#בחר:{{{MaccabiPointsAction|}}}|מתחת ל=<|בדיוק==|מעל ל=> }} }}<!--
                         -->{{#vardefine: ScoreForOpponentOperator| {{#בחר:{{{OpponentScoreAction|}}}|מתחת ל=<|בדיוק==|מעל ל=> }} }}<!--
                         -->{{#vardefine: PointsForOpponentOperator| {{#בחר:{{{OpponentPointsAction|}}}|מתחת ל=<|בדיוק==|מעל ל=> }} }}<!--
                         -->{{#vardefine: ScoreDiffForMaccabiOperator| {{#בחר:{{{MaccabiScoreDifferentAction|}}}|מתחת ל=<|בדיוק==|מעל ל=> }} }}<!--
                         -->{{#vardefine: PointsDiffForMaccabiOperator| {{#בחר:{{{MaccabiPointsDifferentAction|}}}|מתחת ל=<|בדיוק==|מעל ל=> }} }}<!--
                         -->{{#vardefine: SameOpponents| {{{Opponent|}}} }}<!--
                         -->{{#vardefine: SameOpponents| "{{{Opponent|}}}" }}<!--


-->{{#cargo_query:
-->{{#cargo_query:
tables=Basketball_Games, Games_Results, Days_In_Week, Basketball_Competitions
tables=Basketball_Games, Games_Results, Basketball_Competitions
|join on=Basketball_Games.ResultOpt = Games_Results.ResultType
|join on=Basketball_Games.ResultOpt = Games_Results.ResultType
        ,Basketball_Games.MatchDay = Days_In_Week.DayNumber
         ,Basketball_Games.Competition = Basketball_Competitions.OriginalName
         ,Basketball_Games.Competition = Basketball_Competitions.OriginalName


שורה 35: שורה 34:
{{#if: {{{Leg|}}} | {{#ifeq: {{{SimilarLegs|}}}| כן| AND Basketball_Games.Leg LIKE "%{{{Leg}}}%" | AND Basketball_Games.Leg = "{{{Leg}}}" }} }}
{{#if: {{{Leg|}}} | {{#ifeq: {{{SimilarLegs|}}}| כן| AND Basketball_Games.Leg LIKE "%{{{Leg}}}%" | AND Basketball_Games.Leg = "{{{Leg}}}" }} }}
{{#if: {{{Referee|}}} |  AND Basketball_Games.MainReferee = "{{{Referee}}}" }}
{{#if: {{{Referee|}}} |  AND Basketball_Games.MainReferee = "{{{Referee}}}" }}
{{#if: {{{MaccabiScore|}}} |  AND Basketball_Games.TotalPointsMaccabi {{#var: ScoreForMaccabiOperator}} {{{MaccabiScore}}} }}
{{#if: {{{MaccabiPoints|}}} |  AND Basketball_Games.TotalPointsMaccabi {{#var: PointsForMaccabiOperator}} {{{MaccabiPoints}}} }}
{{#if: {{{MaccabiScoreDifferent|}}} |  AND Basketball_Games.TotalPointsMaccabi - Basketball_Games.TotalPointsOpponent {{#var: ScoreDiffForMaccabiOperator}} {{{MaccabiScoreDifferent}}} }}
{{#if: {{{MaccabiPointsDifferent|}}} |  AND Basketball_Games.TotalPointsMaccabi - Basketball_Games.TotalPointsOpponent {{#var: PointsDiffForMaccabiOperator}} {{{MaccabiPointsDifferent}}} }}
{{#if: {{{OpponentScore|}}} |  AND Basketball_Games.TotalPointsOpponent {{#var: ScoreForOpponentOperator}} {{{OpponentScore}}} }}
{{#if: {{{OpponentPoints|}}} |  AND Basketball_Games.TotalPointsOpponent {{#var: PointsForOpponentOperator}} {{{OpponentPoints}}} }}
{{#if: {{{GameResult|}}} |  AND Games_Results.ResultString = "{{{GameResult}}}" }}
{{#if: {{{GameResult|}}} |  AND Games_Results.ResultString = "{{{GameResult}}}" }}


שורה 63: שורה 62:
           ,Basketball_Games.HomeAway=בית או חוץ
           ,Basketball_Games.HomeAway=בית או חוץ
           ,Basketball_Games.Stadium=אצטדיון
           ,Basketball_Games.Stadium=אצטדיון
           ,Basketball_Games.TotalScoreMaccabi=מערכות למכבי
           ,Basketball_Games.TotalPointsMaccabi=נקודות למכבי
           ,Basketball_Games.TotalScoreOpponent=מערכות ליריבה
           ,Basketball_Games.TotalPointsOpponent=נקודות ליריבה
           ,Games_Results.ResultString=תוצאת משחק <!-- Cast number to string from games results table -->
           ,Games_Results.ResultString=תוצאת משחק <!-- Cast number to string from games results table -->
           ,CONCAT('[[כדורסל:', Basketball_Games.CoachMaccabi, ']]')=מאמן מכבי
           ,CONCAT('[[כדורסל:', Basketball_Games.CoachMaccabi, ']]')=מאמן מכבי
שורה 71: שורה 70:
           ,IF(Basketball_Games.TotalPointsMaccabi>Basketball_Games.TotalPointsOpponent, Basketball_Games.TotalPointsMaccabi-Basketball_Games.TotalPointsOpponent, Basketball_Games.TotalPointsMaccabi-Basketball_Games.TotalPointsOpponent)=הפרש נק למכבי
           ,IF(Basketball_Games.TotalPointsMaccabi>Basketball_Games.TotalPointsOpponent, Basketball_Games.TotalPointsMaccabi-Basketball_Games.TotalPointsOpponent, Basketball_Games.TotalPointsMaccabi-Basketball_Games.TotalPointsOpponent)=הפרש נק למכבי
           ,Basketball_Games.TotalPointsOpponent=נק ליריבה
           ,Basketball_Games.TotalPointsOpponent=נק ליריבה
           ,Basketball_Games.Refs=שופט
           ,Basketball_Games.MainReferee=שופט
           ,Crowd=קהל
           ,Crowd=קהל
          ,Days_In_Week.DayString=יום המשחק בשבוע
           ,CONCAT('[', Basketball_Games.FullGameVideo,  ' לינק]')=משחק מלא
           ,CONCAT('[', Basketball_Games.FullGameVideo,  ' לינק]')=משחק מלא
           ,CONCAT('[', Basketball_Games.HighlightsVideo, ' לינק]')=תקציר
           ,CONCAT('[', Basketball_Games.HighlightsVideo, ' לינק]')=תקציר
שורה 91: שורה 89:
== התפלגות תוצאות משחקים ==
== התפלגות תוצאות משחקים ==
{{#cargo_query:
{{#cargo_query:
tables=Basketball_Games, Games_Results, Days_In_Week, Basketball_Competitions
tables=Basketball_Games, Games_Results, Basketball_Competitions
|join on=Basketball_Games.ResultOpt = Games_Results.ResultType
|join on=Basketball_Games.ResultOpt = Games_Results.ResultType
        ,Basketball_Games.MatchDay = Days_In_Week.DayNumber
         ,Basketball_Games.Competition = Basketball_Competitions.OriginalName
         ,Basketball_Games.Competition = Basketball_Competitions.OriginalName


שורה 115: שורה 112:
{{#if: {{{Leg|}}} | {{#ifeq: {{{SimilarLegs|}}}| כן| AND Basketball_Games.Leg LIKE "%{{{Leg}}}%" | AND Basketball_Games.Leg = "{{{Leg}}}" }} }}
{{#if: {{{Leg|}}} | {{#ifeq: {{{SimilarLegs|}}}| כן| AND Basketball_Games.Leg LIKE "%{{{Leg}}}%" | AND Basketball_Games.Leg = "{{{Leg}}}" }} }}
{{#if: {{{Referee|}}} |  AND Basketball_Games.MainReferee = "{{{Referee}}}" }}
{{#if: {{{Referee|}}} |  AND Basketball_Games.MainReferee = "{{{Referee}}}" }}
{{#if: {{{MaccabiScore|}}} |  AND Basketball_Games.TotalPointsMaccabi {{#var: ScoreForMaccabiOperator}} {{{MaccabiScore}}} }}
{{#if: {{{MaccabiPoints|}}} |  AND Basketball_Games.TotalPointsMaccabi {{#var: PointsForMaccabiOperator}} {{{MaccabiPoints}}} }}
{{#if: {{{MaccabiScoreDifferent|}}} |  AND Basketball_Games.TotalPointsMaccabi - Basketball_Games.TotalPointsOpponent {{#var: ScoreDiffForMaccabiOperator}} {{{MaccabiScoreDifferent}}} }}
{{#if: {{{MaccabiPointsDifferent|}}} |  AND Basketball_Games.TotalPointsMaccabi - Basketball_Games.TotalPointsOpponent {{#var: PointsDiffForMaccabiOperator}} {{{MaccabiPointsDifferent}}} }}
{{#if: {{{OpponentScore|}}} |  AND Basketball_Games.TotalPointsOpponent {{#var: ScoreForOpponentOperator}} {{{OpponentScore}}} }}
{{#if: {{{OpponentPoints|}}} |  AND Basketball_Games.TotalPointsOpponent {{#var: PointsForOpponentOperator}} {{{OpponentPoints}}} }}
{{#if: {{{GameResult|}}} |  AND Games_Results.ResultString = "{{{GameResult}}}" }}
{{#if: {{{GameResult|}}} |  AND Games_Results.ResultString = "{{{GameResult}}}" }}


גרסה אחרונה מ־00:44, 21 בינואר 2026

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

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