Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include_once ('bazapodaci.php');
- if($_SESSION['logovan'] != 1) { /* */ }
- else {
- $online_user = $_SESSION['korisnickoime'];
- $nadji_id = "SELECT * FROM $tabela_users WHERE korisnickoime = '$online_user'";
- $provera = mysql_query ($nadji_id);
- if ($provera){
- $id_online = mysql_fetch_assoc ($provera);
- $id_usera = $id_online['id'];
- }
- $ip = $_SERVER['REMOTE_ADDR'];
- $session = session_id();
- $vrijeme_logina = time();
- $provjera_vremena = $vrijeme_logina - (24*3600); // provjera na 1 dan
- $id_posjetioca = $id_usera;
- $sql = "SELECT * FROM $online WHERE id_usera='$id_posjetioca'";
- $result = mysql_query($sql);
- if(mysql_num_rows($result)== 0){
- $sql1 = "INSERT INTO $online (id_usera , ip, vrijeme_logina , session)
- VALUES('$id_posjetioca','$ip','$vrijeme_logina','$session')";
- $result1 = mysql_query($sql1);
- } else {
- $sql2= "UPDATE $online SET ip = '$ip' , session='$session' WHERE id_usera = '$id_posjetioca'";
- $result2=mysql_query($sql2);
- }
- // if over 10 minute, delete session
- $sql4="DELETE FROM $online WHERE vrijeme_logina < '$provjera_vremena'";
- $result4=mysql_query($sql4);
- $sql_online = "SELECT * FROM $online ORDER BY id_usera ASC";
- $rezz_z = mysql_query ($sql_online);
- if ($rezz_z) {
- for ($i=0; $i< mysql_num_rows ($rezz_z); $i++ ){
- $nickovi = mysql_fetch_assoc ($rezz_z);
- $id_usera = $nickovi ['id_usera'];
- $sql_korisnicko = "SELECT * FROM korisnici WHERE id='$id_usera'";
- $rezzzz = mysql_query ($sql_korisnicko);
- if ($rezzzz) {
- $korisnicko_user = mysql_fetch_assoc ($rezzzz);
- $nick = $korisnicko_user['korisnickoime'];
- $korisnik_joj = $nick . " , ";
- $online_korisnici .= $korisnik_joj;
- }
- }
- $online_korisnici_ = substr($online_korisnici,0,strlen($online_korisnici)-2 );
- $online_korisnici = '<div class="korisnici_online">' . $online_korisnici_ . '</div>';
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement