| <html> |
| <head> |
| <meta name="viewport" content="width=device-width, initial-scale=1"> |
| <link rel="preconnect" href="https://fonts.googleapis.com"> |
| <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin> |
| <link href="https://fonts.googleapis.com/css2?family=Open+Sans:ital,wght@0,400;0,500;1,400;1,500" rel="stylesheet"> |
| <link rel="stylesheet" href="./css/ranking.css" /> |
| </head> |
| |
| <body> |
| |
| <?php |
| require './credentials.php'; |
| require './php/utils.php'; |
| |
| $credentials = new Credentials(); |
| $usersdb = $credentials->usersdb(); |
| $mortsdb = $credentials->mortsdb(); |
| |
| // Mateix grau i curs => 100, Mateix grau diferent curs => 150, Diferent grau => 200 |
| $getranking = "SELECT $mortsdb.assassi AS id, $usersdb.nom, $usersdb.grau, $usersdb.curs, count($mortsdb.assassi) AS kills, |
| sum($mortsdb.grau = $usersdb.grau AND $mortsdb.curs = $usersdb.curs) AS companys_classe, |
| sum($mortsdb.grau = $usersdb.grau AND $mortsdb.curs != $usersdb.curs) AS companys_grau, |
| sum($mortsdb.grau != $usersdb.grau) AS companys_facu, |
| sum(CASE WHEN $mortsdb.grau = $usersdb.grau AND $mortsdb.curs = $usersdb.curs THEN 100 WHEN $mortsdb.grau = $usersdb.grau AND $mortsdb.curs != $usersdb.curs THEN 150 ELSE 200 END) AS score |
| FROM $mortsdb INNER JOIN $usersdb ON $mortsdb.assassi = $usersdb.id GROUP BY $mortsdb.assassi ORDER BY score DESC"; |
| |
| $results = query($getranking); |
| // die($getranking); |
| ?> |
| |
| <div id="outter-container"> |
| <div id="inner-container"> |
| <header> |
| <div id="leftlinks"><a id="info" href="javascript:void(0);" onclick="js: toggleinfo();">+Info</a></div> |
| <div id="rightlinks"><a href="./main.php">Tornar a la pàgina principal</a></div> |
| </header> |
| |
| <p><img src="./bin/images/info.png" width="32px" /> La puntuació de cada jugador es calcula com a una suma ponderada depenent del caràcter de les seves víctimes: companys de <b>c</b>lasse (mateix any d'entrada i torn, mateix grau), companys de <b>g</b>rau (mateix grau) i companys de <b>f</b>acultat (diferents graus). Amb puntuacions +100, +150 i +200; respectivament.</p> |
| |
| <div id="table-container"> |
| <table id="ranking" cellspacing="0" cellpadding="0"> |
| <tr id="header"> |
| <th></th> |
| <th>Assassins</th> |
| <th>T</th> |
| <th>P</th> |
| <th>C</th> |
| <th>G</th> |
| <th>F</th> |
| </tr> |
| <?php |
| $id = 0; |
| $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 class='name'><div> |
| <div class='username'>$row->nom</div> |
| <div class='userinfo'>".nomcurs($row->curs)." - ".nomgrau($row->grau)."</div> |
| </div></td>"; |
| echo "<td>$row->kills</td>"; |
| echo "<td><b>$row->score</b></td>"; |
| echo "<td>$row->companys_classe</td>"; |
| echo "<td>$row->companys_grau</td>"; |
| echo "<td>$row->companys_facu</td>"; |
| echo "</tr>"; |
| |
| $i = $i + 1; |
| } |
| ?> |
| </table> |
| </div> |
| </div> |
| </div> |
| |
| <script> |
| function toggleinfo() { |
| let state = document.getElementsByTagName("p")[0].style.display; |
| if (state == "block") { |
| document.getElementsByTagName("p")[0].style.display = "none"; |
| document.getElementsByTagName("a")[0].innerHTML = "+Info"; |
| } else { |
| document.getElementsByTagName("p")[0].style.display = "block"; |
| document.getElementsByTagName("a")[0].innerHTML = "-Info"; |
| } |
| return false; |
| } |
| </script> |
| |
| </body> |
| </html> |