Ajout position - Page Search

Your suggestions are always welcome. / Vos suggestions sont toujours bienvenues.
Post Reply
Showtime Hockey
The Passion One / Le Passionné
Posts: 189
Joined: Fri Sep 16, 2016 3:16 pm
Location: Quebec, QC.
Contact:

Ajout position - Page Search

Post by Showtime Hockey »

Salut Simon,

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

Voici un exemple:
Image
Image
SimonT
STHS Owner / Propriétaire du STHS
Posts: 14757
Joined: Sat Oct 08, 2005 4:18 pm
Location: Montreal, Canada
Contact:

Re: Ajout position - Page Search

Post by SimonT »

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
Showtime Hockey
The Passion One / Le Passionné
Posts: 189
Joined: Fri Sep 16, 2016 3:16 pm
Location: Quebec, QC.
Contact:

Re: Ajout position - Page Search

Post by Showtime Hockey »

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. :P
Image
Post Reply