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"); } ?>