Guest User

Untitled

a guest
May 16th, 2018
149
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.47 KB | None | 0 0
  1. if (isset($_POST['login_user'])) {
  2. $username = mysqli_real_escape_string($db, $_POST['username']);
  3. $password = mysqli_real_escape_string($db, $_POST['password']);
  4.  
  5. if (empty($username)) {
  6. array_push($errors, "Se requereix nombre de usuari");
  7. }
  8. if (empty($password)) {
  9. array_push($errors, "Se requereix contrasenya");
  10. }
  11.  
  12. // Quan et loguejes sense errors
  13. if (count($errors) == 0) {
  14. $password = md5($password);
  15. $query = "SELECT * FROM users WHERE username = '$username' AND password = '$password'";
  16. $results = mysqli_query($db, $query);
  17. if (mysqli_num_rows($results) == 1) {
  18. $_SESSION['username'] = $username;
  19. $_SESSION['success'] = "Ara estàs conectat";
  20. header('location: ../index.php');
  21. }
  22. else {
  23. array_push($errors, "Combinació usuari/contrasenya malament");
  24. }
  25. }
  26.  
  27. <div class="row">
  28. <div class="main">
  29. <a name="jocs">
  30. <table class="table_jocs">
  31. <tr align="center">
  32. <td><h2>Typer</h2></td>
  33. <td><h2>Brainer</h2></td>
  34. <td><h2>PPT</h2></td>
  35. <td><h2>Draw me!</h2></td>
  36. </tr>
  37. <tr>
  38. <td><a href="/typer" target="_blank"><img src="/imagens/mecanografia.png" class="iconos_jocs"></a></td>
  39. <td><a href="/brainer" target="_blank"><img src="/imagens/brainer.png" class="iconos_jocs"></a></td>
  40. <td><a href="/pedra_paper_tisores" target="_blank"><img src="/imagens/ppt.png" class="iconos_jocs"></a></td>
  41. <td><a href="/draw" target="_blank"><img src="/imagens/dibuix.png" class="iconos_jocs"></a></td>
  42. </tr>
  43. <tr align="center">
  44. <td><h2>Velocity</h3></td>
  45. <td><h2>Were's Wally?</h2></td>
  46. <td><h2>Bowser Game</h2></td>
  47. <td><h2>Moveless</h2></td>
  48. </tr>
  49. <tr>
  50. <?php if (($_SESSION['premium']) == 'si') { ?>
  51. <td><a href="/velocity" target="_blank"><img src="/imagens/velocity.png" class="iconos_jocs"></a></td>
  52. <td><a href="/wally" target="_blank"><img src="/imagens/wally.png" class="iconos_jocs"></a></td>
  53. <td><a href="/bowser" target="_blank"><img src="/imagens/bowser.png" class="iconos_jocs"></a></td>
  54. <td><a href="/moveless" target="_blank"><img src="/imagens/ma.svg" class="iconos_jocs"></a></td>
  55. <?php } ?>
  56. </tr>
  57. </table>
  58. </a>
  59. </div>
  60. </div>
  61.  
  62. if (isset($_POST['login_user'])) {
  63. $username = mysqli_real_escape_string($db, $_POST['username']);
  64. $password = mysqli_real_escape_string($db, $_POST['password']);
  65.  
  66. if (empty($username)) {
  67. array_push($errors, "Se requereix nombre de usuari");
  68. }
  69. if (empty($password)) {
  70. array_push($errors, "Se requereix contrasenya");
  71. }
  72.  
  73. // Quan et loguejes sense errors
  74. if (count($errors) == 0) {
  75. $password = md5($password);
  76. $query = "SELECT * FROM users WHERE username = '$username' AND password = '$password'";
  77. $results = mysqli_query($db, $query);
  78. if (mysqli_num_rows($results) == 1) {
  79. $fila = mysqli_fetch_array($resuls)//Debes obtener el resultado
  80. $_SESSION['username'] = $username;
  81. $_SESSION['premium'] = $fila[0]['premium'];//Obtienes el valor de
  82. //la columna premium
  83. $_SESSION['success'] = "Ara estàs conectat";
  84. header('location: ../index.php');
  85. }
  86. else {
  87. array_push($errors, "Combinació usuari/contrasenya malament");
  88. }
  89. }
  90.  
  91. if (count($errors) == 0)
  92. {
  93. $password = md5($password);
  94. $query = "SELECT * FROM users WHERE username = '$username' AND password = '$password'";
  95. $results = mysqli_query($db, $query);
  96. $fila = mysqli_fetch_array($resuls) //Variable $fila
  97. if (mysqli_num_rows($results) == 1)
  98. {
  99. $_SESSION['username'] = $username;
  100. $_SESSION['success'] = "Ara estàs conectat";
  101. header('location: ../index.php');
  102. }
  103. else if (mysqli_num_rows($results) == 1 && $fila['premium'] == "si")
  104. {
  105. $_SESSION['premium'] = "si";//Variable para saber si el usuario es premium
  106. $_SESSION['username'] = $username;
  107. $_SESSION['success'] = "Ara estàs connectat usuari premium";
  108. header('location: ../index.php');
  109. }
  110. else
  111. {
  112. array_push($errors, "Combinació usuari/contrasenya malament");
  113. }
  114. }
Add Comment
Please, Sign In to add comment