| <html> |
| <head> |
| <link rel="stylesheet" type="text/css" href="//fonts.googleapis.com/css?family=Open+Sans" /> |
| <link rel="stylesheet" href="./css/basic.css" /> |
| <link rel="stylesheet" href="./css/ranking.css" /> |
| </head> |
| |
| <body> |
| |
| <?php |
| require './credentials.php'; |
| require './php/utils.php'; |
| |
| // $getranking = "SELECT morts.assassi AS id, users.grau, users.curs, count(morts.assassi) AS kills FROM morts INNER JOIN users ON morts.assassi = users.id GROUP BY morts.assassi"; |
| // $getranking = "SELECT morts.assassi AS id, users.grau, users.curs, count(morts.assassi) AS kills, sum(CASE WHEN morts.grau = users.grau THEN 1 ELSE 2 END) AS kills_pondered FROM morts INNER JOIN users ON morts.assassi = users.id GROUP BY morts.assassi ORDER BY kills_pondered DESC"; |
| // Mateix grau i curs => 1, Mateix grau diferent curs => 2, Diferent grau => 3 |
| // $getranking = "SELECT morts.assassi AS id, users.grau, users.curs, count(morts.assassi) AS kills, sum(CASE WHEN morts.grau = users.grau AND morts.curs = users.curs THEN 1 WHEN morts.grau = users.grau AND morts.curs != users.curs THEN 2 ELSE 3 END) AS kills_pondered FROM morts INNER JOIN users ON morts.assassi = users.id GROUP BY morts.assassi ORDER BY kills_pondered DESC"; |
| |
| // Mateix grau i curs => 100, Mateix grau diferent curs => 150, Diferent grau => 200 |
| $getranking = "SELECT morts.assassi AS id, users.nom, users.grau, users.curs, count(morts.assassi) AS kills, |
| sum(morts.grau = users.grau AND morts.curs = users.curs) AS companys_classe, |
| sum(morts.grau = users.grau AND morts.curs != users.curs) AS companys_grau, |
| sum(morts.grau != users.grau) AS companys_facu, |
| sum(CASE WHEN morts.grau = users.grau AND morts.curs = users.curs THEN 100 WHEN morts.grau = users.grau AND morts.curs != users.curs THEN 150 ELSE 200 END) AS score |
| FROM morts INNER JOIN users ON morts.assassi = users.id GROUP BY morts.assassi ORDER BY score DESC"; |
| |
| $results = query($getranking); |
| ?> |
| |
| <div id="outter-container"> |
| <div id="inner-container"> |
| <h1>RÃ nquing</h1> |
| <p>La puntuació de cada jugador es calcula com a una suma ponderada entre companys de classe (mateix curs, mateix grau), companys de grau (mateix grau) i companys de facultat (diferents grau). Amb puntuacions +100, +150 i +200; respectivament.</p> |
| |
| <table id="ranking" cellspacing="0" cellpadding="0"> |
| <tr id="header"> |
| <th></th> |
| <th>Nom</th> |
| <th>Classe</th> |
| <th>Grau</th> |
| <th>Facu</th> |
| <th>Total</th> |
| <th>Punts</th> |
| </tr> |
| <?php |
| $id = 43; |
| $i = 1; |
| |
| while ($row = $results->fetch_object()) { |
| if ($i == 1) echo "<tr class='gold top3'>"; |
| else if ($i == 2) echo "<tr class='silver top3'>"; |
| else if ($i == 3) echo "<tr class='bronze top3'>"; |
| else if ($row->id == $id) echo "<tr class='me'>"; |
| else echo "<tr>"; |
| |
| echo "<td>". ($i > 3 ? $i : '') ."</td>"; |
| echo "<td>$row->nom</td>"; |
| echo "<td>$row->companys_classe</td>"; |
| echo "<td>$row->companys_grau</td>"; |
| echo "<td>$row->companys_facu</td>"; |
| echo "<td>$row->kills</td>"; |
| echo "<td>$row->score</td>"; |
| echo "</tr>"; |
| |
| $i = $i + 1; |
| } |
| ?> |
| </table> |
| </div> |
| </div> |
| |
| </body> |
| </html> |