Salut Simon,
Est-ce que ça serait possible d'ajouté les recherches par positions dans la page Search.php ?
Voici un exemple:
Ajout position - Page Search
-
- The Passion One / Le Passionné
- Posts: 190
- Joined: Fri Sep 16, 2016 3:16 pm
- Location: Quebec, QC.
- Contact:
-
- STHS Owner / Propriétaire du STHS
- Posts: 14782
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: Ajout position - Page Search
Oui mais si tu sais que tu peux le faire avec la fonction à l'intérieur de la page? Parce c'est un peu complexe avec les positions multiples cette recherche.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
-
- The Passion One / Le Passionné
- Posts: 190
- Joined: Fri Sep 16, 2016 3:16 pm
- Location: Quebec, QC.
- Contact:
Re: Ajout position - Page Search
Alright, cool ça fonctionne.
Merci Simon!
Pour ceux qui veulent savoir comment:
1. Open PlayerStat.php
2. On lines 97, find:
3. Replace by:
Ceci va faire en sorte que la page va vous affichez seulement les défenseurs, du meilleur pointeur au plus mauvais.
Merci Simon!
Pour ceux qui veulent savoir comment:
1. Open PlayerStat.php
2. On lines 97, find:
Code: Select all
$Query = "SELECT Player" . $TypeText . "Stat.*, PlayerInfo.PosC, PlayerInfo.PosLW, PlayerInfo.PosRW, PlayerInfo.PosD, PlayerInfo.TeamName, ROUND((CAST(Player" . $TypeText . "Stat.G AS REAL) / (Player" . $TypeText . "Stat.Shots))*100,2) AS ShotsPCT, ROUND((CAST(Player" . $TypeText . "Stat.SecondPlay AS REAL) / 60 / (Player" . $TypeText . "Stat.GP)),2) AS AMG,ROUND((CAST(Player" . $TypeText . "Stat.FaceOffWon AS REAL) / (Player" . $TypeText . "Stat.FaceOffTotal))*100,2) as FaceoffPCT,ROUND((CAST(Player" . $TypeText . "Stat.P AS REAL) / (Player" . $TypeText . "Stat.SecondPlay) * 60 * 20),2) AS P20 FROM PlayerInfo INNER JOIN Player" . $TypeText . "Stat ON PlayerInfo.Number = Player" . $TypeText . "Stat.Number WHERE Player" . $TypeText . "Stat.GP > " . $MinimumGP;
Code: Select all
$Query = "SELECT Player" . $TypeText . "Stat.*, PlayerInfo.PosC, PlayerInfo.PosLW, PlayerInfo.PosRW, PlayerInfo.PosD, PlayerInfo.TeamName, ROUND((CAST(Player" . $TypeText . "Stat.G AS REAL) / (Player" . $TypeText . "Stat.Shots))*100,2) AS ShotsPCT, ROUND((CAST(Player" . $TypeText . "Stat.SecondPlay AS REAL) / 60 / (Player" . $TypeText . "Stat.GP)),2) AS AMG,ROUND((CAST(Player" . $TypeText . "Stat.FaceOffWon AS REAL) / (Player" . $TypeText . "Stat.FaceOffTotal))*100,2) as FaceoffPCT,ROUND((CAST(Player" . $TypeText . "Stat.P AS REAL) / (Player" . $TypeText . "Stat.SecondPlay) * 60 * 20),2) AS P20 FROM PlayerInfo INNER JOIN Player" . $TypeText . "Stat ON PlayerInfo.Number = Player" . $TypeText . "Stat.Number WHERE (PlayerInfo.PosD = 'True') AND Player" . $TypeText . "Stat.GP > " . $MinimumGP;