function trackUser($name)
{
if ($name !== '') {
$name = $_SERVER['REMOTE_ADDR'];
}
$time = time();
$query = "SELECT COUNT(*) FROM `sessions` WHERE `id`='{$name}'";
$result = DatabaseQueryReturn($query);
$count = $result[0]['COUNT(*)'];
if ($count > 0) {
$query = "UPDATE `sessions` SET `timestamp`='" . $time . "' WHERE id='{$name}';";
} else {
$query = "INSERT INTO `sessions` (`id`, `timestamp`) " . "VALUES ('{$name}', '{$time}');";
}
DatabaseQuery($query);
$old_ids = DatabaseQueryReturn("SELECT * FROM `sessions` WHERE `timestamp` <= '" . ($time - VISIT_TIMEOUT) . "';");
foreach ($old_ids as $ids) {
DatabaseQuery("DELETE FROM `sessions` WHERE `id`='{$ids['id']}'");
DatabaseQuery("DELETE FROM `sessions_cache` WHERE `name`='{$ids['id']}'");
}
}
include_once 'database.php';
?>
<?php
$info = DatabaseQueryReturn("SELECT * FROM `users` WHERE `uid`='{$id}'");
$title = $info[0]['title'];
$artist = $info[0]['artist'];
$search = array("'", '"');
$replace = array("\\'", '\\"');
$title = str_replace($search, $replace, $title);
$artist = str_replace($search, $replace, $artist);
?>
<?php
DatabaseQuery("INSERT INTO `live` (`sid` , `title` , `artist`) VALUES ('{$id}' , '{$title}' , '{$artist}')");
?>
<?php
if (isset($_SESSION['username'])) {
$us = $_SESSION['username'];
$settings = DatabaseQueryReturn("SELECT * FROM `registered_settings` WHERE `name`='{$us}'");
}
$autostart = $settings[0]['autostart'];
$volume = $settings[0]['volume'];
$repeat = $settings[0]['repeat'];
?>
<?php
$secret = "MCpxR5y700oIiUUUVB2r5CFv9OUlkxOpE1lB0Mkl7KmpyFOBCZaefo5rWuNxvpk";
$uri_prefix = "/stream/";
$title = str_replace($search, $replace, $title);
$artist = str_replace($search, $replace, $artist);
DatabaseQuery("INSERT INTO `sessions_cache` (`name` , `sid` , `title` , `artist`) VALUES ('{$name}' , '{$add}' , '{$title}' , '{$artist}')");
}
die;
}
?>
<?php
if (isset($delete)) {
if (isset($_SESSION['us'])) {
$name = $_SESSION['us'];
DatabaseQuery("DELETE FROM `registered_cache` WHERE `name`='{$name}' AND `id`='{$delete}' LIMIT 1");
} else {
$name = $_SERVER['REMOTE_ADDR'];
DatabaseQuery("DELETE FROM `sessions_cache` WHERE `name`='{$name}' AND `id`='{$delete}' LIMIT 1");
}
die;
}
?>
<?php
if (isset($_SESSION['us'])) {
$name = $_SESSION['us'];
$info = DatabaseQueryReturn("SELECT * FROM `registered_cache` WHERE `name`='{$name}' ORDER BY `id` DESC LIMIT 10");
} else {
$name = $_SERVER['REMOTE_ADDR'];
$info = DatabaseQueryReturn("SELECT * FROM `sessions_cache` WHERE `name`='{$name}' ORDER BY `id` DESC LIMIT 10");
}
?>
