Advertisement
Guest User

Untitled

a guest
Jun 26th, 2017
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.77 KB | None | 0 0
  1. <?php
  2. include_once ('bazapodaci.php');
  3.  
  4. if($_SESSION['logovan'] != 1) { /* */ }
  5.  
  6. else {
  7. $online_user = $_SESSION['korisnickoime'];
  8.  
  9. $nadji_id = "SELECT * FROM $tabela_users WHERE korisnickoime = '$online_user'";
  10. $provera = mysql_query ($nadji_id);
  11.     if ($provera){
  12.     $id_online = mysql_fetch_assoc ($provera);
  13.     $id_usera = $id_online['id'];
  14. }
  15.  
  16. $ip = $_SERVER['REMOTE_ADDR'];
  17. $session = session_id();
  18. $vrijeme_logina = time();
  19. $provjera_vremena = $vrijeme_logina - (24*3600); // provjera na 1 dan
  20. $id_posjetioca = $id_usera;
  21.  
  22. $sql = "SELECT * FROM $online WHERE id_usera='$id_posjetioca'";
  23. $result = mysql_query($sql);
  24. if(mysql_num_rows($result)== 0){
  25.  
  26. $sql1 = "INSERT INTO $online (id_usera , ip, vrijeme_logina , session)
  27. VALUES('$id_posjetioca','$ip','$vrijeme_logina','$session')";
  28. $result1 = mysql_query($sql1);
  29. } else {
  30. $sql2= "UPDATE $online SET  ip = '$ip' , session='$session' WHERE id_usera = '$id_posjetioca'";
  31. $result2=mysql_query($sql2);
  32. }
  33.  
  34. // if over 10 minute, delete session
  35. $sql4="DELETE FROM $online WHERE vrijeme_logina < '$provjera_vremena'";
  36. $result4=mysql_query($sql4);
  37.  
  38.  
  39. $sql_online = "SELECT * FROM $online ORDER BY id_usera ASC";
  40. $rezz_z = mysql_query ($sql_online);
  41. if ($rezz_z) {
  42. for ($i=0; $i< mysql_num_rows ($rezz_z); $i++ ){
  43.     $nickovi = mysql_fetch_assoc ($rezz_z);
  44.     $id_usera = $nickovi ['id_usera'];
  45.  
  46.     $sql_korisnicko = "SELECT * FROM korisnici WHERE id='$id_usera'";
  47.     $rezzzz = mysql_query ($sql_korisnicko);
  48. if ($rezzzz) {
  49.     $korisnicko_user = mysql_fetch_assoc ($rezzzz);
  50.     $nick = $korisnicko_user['korisnickoime'];
  51.  
  52.     $korisnik_joj =  $nick . " , ";
  53.     $online_korisnici .= $korisnik_joj;
  54.  
  55.         }
  56.     }
  57.    
  58.     $online_korisnici_ = substr($online_korisnici,0,strlen($online_korisnici)-2 );
  59. $online_korisnici = '<div class="korisnici_online">' . $online_korisnici_ . '</div>';
  60.  
  61.  
  62.     }
  63.  
  64. }
  65.  
  66. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement