STHS Forum

Posted: **Sat Nov 17, 2018 7:47 am**

Salut Simon,

Est-ce que ça serait possible d'ajouté les recherches par positions dans la page Search.php ?

Voici un exemple:

Posted: **Sun Nov 18, 2018 9:54 am**

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.

Posted: **Tue Nov 20, 2018 3:57 pm**

Alright, cool ça fonctionne.
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;

3. Replace by:

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;

Ceci va faire en sorte que la page va vous affichez seulement les défenseurs, du meilleur pointeur au plus mauvais.

STHS Forum

Ajout position - Page Search

Ajout position - Page Search

Re: Ajout position - Page Search

Re: Ajout position - Page Search