// startar sessioner session_start(); // ansluter till databasen include($_SERVER['DOCUMENT_ROOT']."/cgi-bin/php/config2.php"); include($_SERVER['DOCUMENT_ROOT']."/cgi-bin/php/connect_database.php"); // lokal tid för besöket $time_local = date('H:i:s'); // hämtar besökarens IP-nummer $ip = $_SERVER["REMOTE_ADDR"]; // anger sessionsID $session = session_id(); // hämtar aktuell tid i formatet "Unix timestamp" $time = time(); // tid i sekunder innan besökarens session raderas $timeout = 1200; $time_check = $time - $timeout; // kontrollerar om sessionsID redan finns i MySQL-tabellen $result1 = mysqli_query($opendb_wds, "SELECT * FROM users_online WHERE session='$session'") or die(mysqli_error()); $count_rows = mysqli_num_rows($result1); // lägger till sessionsID i MySQL-tabellen if($count_rows == '0') { mysqli_query($opendb_wds, "INSERT INTO users_online (time_local, time, session, ip) VALUES('$time_local', '$time', '$session', '$ip')") or die(mysqli_error()); } // uppdaterar tiden för sessionsID som redan finns i MySQL-tabellen else { mysqli_query($opendb_wds, "UPDATE users_online SET time='$time' WHERE session = '$session'") or die(mysqli_error()); } // hämtar antal sessionsID från MySQL-tabellen $result2 = mysqli_query($opendb_wds, "SELECT * FROM users_online") or die(mysqli_error()); $count_users_online = mysqli_num_rows($result2); // startar session som lagrar variabel för antal besökare online $_SESSION['users_online'] = $count_users_online; // om tiden (i variabeln $time_check) gått ut raderas sessionsID från MySQL-tabellen mysqli_query($opendb_wds, "DELETE FROM users_online WHERE time<$time_check") or die(mysqli_error()); ########################################################################################### // WDS_USERS_ONLINE ########################################################################################### $result_wds_users = mysqli_query($opendb_wds, "SELECT * FROM wds_users_online") or die(mysqli_error()); $count_wds_users_online = mysqli_num_rows($result_wds_users); $result_licenskund = mysqli_query($opendb_wds, "SELECT * FROM licenskund_online") or die(mysqli_error()); $count_licenskund_online = mysqli_num_rows($result_licenskund); // startar session som lagrar variabel för antal besökare online $_SESSION['wds_users_online'] = $count_wds_users_online; $_SESSION['licenskund_online'] = $count_licenskund_online; // stänger databasen mysqli_close($opendb_wds); ?> besökare online