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']}'");
}
}
<center><strong><?php
echo number_format($streams[0]['COUNT(*)']);
?>
</strong> Total Streams</center>
</font>
<?php
} elseif ($which == 2) {
?>
<?php
$songs = DatabaseQueryReturn("SELECT COUNT(*) FROM `users`");
?>
<font face="Century Gothic" style="letter-spacing : 2px;" size="0.7em">
<center><strong><?php
echo number_format($songs[0]['COUNT(*)']);
?>
</strong> Songs In Grid</center>
</font>
<?php
} elseif ($which == 3) {
?>
<?php
$registered_users = DatabaseQueryReturn("SELECT COUNT(*) FROM `registered`");
?>
<font face="Century Gothic" style="letter-spacing : 2px;" size="0.7em">
<center><strong><?php
echo number_format($registered_users[0]['COUNT(*)']);
?>
</strong> Registered Users</center>
</font>
<?php
}
<?php
require_once 'database.php';
$val = $_POST['search'];
$query = DatabaseQueryReturn("SELECT COUNT(*) as occurrences, title, artist, uid FROM `users` WHERE (`title` LIKE '%{$val}%' OR `artist` LIKE '%{$val}%') GROUP BY title,artist ORDER BY occurrences DESC LIMIT 8 ");
?>
<div class="entry">
<ul>
<?php
foreach ($query as $row) {
?>
<div class="example" id="demo-effect-appear" onclick="Effect. Pulsate(this)">
<center><table width="350" border="0">
<tr>
<td>
<li>
<a href="javascript:void(0);" onclick="jah('grid_player.php?id=<?php
echo $row['uid'];
?>
','player');">
<?php
echo $row['title'];
?>
<span><?php
echo $row['artist'];
?>
</span>
</a>
</li>
</td>
$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/";
$f = end(explode("/", $info[0]['location']));
$f = "/" . $f . "";
$server = str_replace($f, '', $info[0]['location']);
$server = str_replace('/uploads', '', $server);
$t = time() + 0 * 3 * 0 * 0;
$t_hex = sprintf("%08x", $t);
<?php
include_once 'database.php';
$recent = DatabaseQueryReturn("SELECT * FROM `live` ORDER BY `id` DESC LIMIT 10");
?>
<div class="entry">
<ul>
<?php
foreach ($recent as $row) {
?>
<div class="example" id="demo-effect-appear" onclick="Effect. Pulsate(this)">
<center><table width="350" border="0">
<tr>
<td>
<li>
<a href="javascript:void(0);" onclick="jah('grid_player.php?id=<?php
echo $row['sid'];
?>
','player');">
<?php
echo $row['title'];
?>
<span><?php
echo $row['artist'];
?>
</span>
</a>
</li>
</td>
</tr>
function DatabaseConnect()
{
$dbhost = 'p50mysql3.secureserver.net';
$dbuser = '******';
$dbpass = '******';
$dbname = 'mandodb';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die("Cannot connect to MySQL database. Check your configuration and that the server is running.");
mysql_select_db($dbname) or die("Can't use the MySQL database. Check your configuration and that the user you have specified has sufficient priveleges to use this database.");
return $conn;
}
function DatabaseQueryReturn($query)
{
stripslashes($query);
$conn = DatabaseConnect();
$result = mysql_query($query) or die("Couldn't run mysql query " . mysql_error());
$data = array();
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$data[] = $row;
}
mysql_close($conn);
return $data;
}
?>
<?php
$columns = DatabaseQueryReturn("SHOW COLUMNS FROM `table`");
?>
<?php
$data = DatabaseQueryReturn("SELECT * FROM `jos_facileforms_subrecords`");
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");
}
?>
<div class="entry">
<ul>
<?php
foreach ($info as $row) {
?>
<div class="example" onclick="Effect. Pulsate(this)">
<center><table width="350" border="0">
<tr>
<td width="85%">
<li>
<a href="javascript:void(0);" onclick="jah('grid_player.php?id=<?php
echo $row['sid'];
