// 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,
// 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);
?>
medlemmar är online nu