0 ? intval($_GET['p']) : 1) : 1; // Låt-sida
$order = isset($_GET['o']) ? intval($_GET['o']) : 0; // Sortering
$s = isset($_GET['s']) ? intval($_GET['s']) : 0; // Söksträng
$IP = ip2long($_SERVER['REMOTE_ADDR']); // Användarens IP
/*** Logga ut *******************************************/
if(isset($_GET['logoff']) ) {
$admin = $_SESSION['admin'] = false;
unset($_SESSION['admin']);
unset($_SERVER['PHP_AUTH_USER']);
unset($_SERVER['PHP_AUTH_PW']);
}
/********************************************************/
/*** Logga in *****************************************************************************************************************/
if(!$admin && isset($_GET['admin'])) {
if (!isset($_SERVER['PHP_AUTH_USER'])) {
header('WWW-Authenticate: Basic realm="Geekmeet Music System"');
header('HTTP/1.0 401 Unauthorized');
die();
} else {
$admin = $_SESSION['admin'] = ($_SERVER['PHP_AUTH_USER'] == "admin" && $_SERVER['PHP_AUTH_PW'] == "schaliziBenis");
if(!$admin) {
header('WWW-Authenticate: Basic realm="Geekmeet Music System"');
header('HTTP/1.0 401 Unauthorized');
die();
}
}
}
/******************************************************************************************************************************/
/*** Uppdatera Inställningar ******************************************************************************************/
if($admin && isset($_POST['update'])) {
foreach($_POST as $variable => $value) {
if($variable == "ADMIN_IP") {
$value=ip2long($value);
}
mysql_query("UPDATE gms_settings
SET value=".intval($value)."
WHERE variable='".str_replace("'","'",$variable)."'");
}
}
/**********************************************************************************************************************/
/*** Avgör huruvida användaren kan rösta **********************************************************************/
$res = mysql_query("SELECT UNIX_TIMESTAMP() - MAX(UNIX_TIMESTAMP(vote_time))
FROM votes
WHERE ip=$IP LIMIT 1");
if($has_not_voted = mysql_num_rows($res)) {
list($last_voted) = mysql_fetch_row($res);
}
mysql_free_result($res);
$last_voted = $last_voted == NULL ? time() : $last_voted;
$can_vote = ($last_voted >= SECONDS_BETWEEN_VOTES || !$has_not_voted);
/**************************************************************************************************************/
?>
GMS - Geekmeet Music System - Powered By Monsquaz
";
}
/**********************************************************************************************************************/
?>
\r\n";
echo "Lyssna (Info ) \r\n";
/*************************************************************/
/*** Information om aktuell låt ***********************************************************************************************/
$res = mysql_query("SELECT id, filename, UNIX_TIMESTAMP() - UNIX_TIMESTAMP(last_played), title, album, artist, year, genre
FROM songs
WHERE times_played > 0 ORDER BY last_played DESC LIMIT 1");
list($id, $filename, $seconds_played, $title, $album, $artist, $year, $genre) = mysql_fetch_row($res);
mysql_free_result($res);
echo "";
$displayname = $title ? ($artist ? "$artist - $title" : $title) : basename($filename);
$time_played = minsec($seconds_played);
$song = " $displayname ";
$timeplayed = $time_played[0].":".($time_played[1] >= 0 && $time_played[1] <= 9 ? "0".$time_played[1] : $time_played[1])."";
echo "\r\n";
echo "Nu spelas: $song \r\n";
echo "Tid Spelad: $timeplayed \r\n";
echo "
\r\n";
/******************************************************************************************************************************/
/*** Sidnavigering ***************************************************************************************/
$res = mysql_unbuffered_query("SELECT COUNT(*)
FROM songs");
list($cnt) = mysql_fetch_row($res);
mysql_free_result($res);
$nav = "";
if(($pages = $cnt / SONGS_PER_PAGE) > 1) {
$nav = "Sida: ";
for($i = 1; $i <= intval($cnt / SONGS_PER_PAGE) + 1; $i++) {
$current = ($page == $i);
$nav.= ($i != 1 ? " | " : "") .
($current ? "" : "") .
$i .
($current ? " " : "");
}
$nav.= " \r\n";
}
echo $nav;
echo " \r\n";
/********************************************************************************************************/
/*** Sökruta **********************************************/
echo "";
/**********************************************************/
/*** Sökresultat ************************************************************************************************************************/
if(isset($_POST['search'])) {
$search = isset($_POST['searchstring']) ? mysql_real_escape_string(htmlentities($_POST['searchstring'])) : 0;
if($search) {
echo "Sökresultat: \r\n";
gmstable("songlist","SELECT id, filename, times_played, num_votes, title, album, artist, year, genre, uploader_ip, last_voter_ip, UNIX_TIMESTAMP()-UNIX_TIMESTAMP(last_played)
FROM songs
WHERE filename LIKE '%$search%' OR title LIKE '%$search%' OR artist LIKE '%$search%' LIMIT ".MAX_SEARCH_RESULTS);
echo " \r\n";
}
}
/****************************************************************************************************************************************/
/*** Låtar på aktuell sida **********************************************************************************************/
$BY_NAME = "CONCAT(artist,title,filename) " . ($order ? "ASC" : "DESC");
$SQL = "SELECT id, filename, times_played, num_votes, title, album, artist, year, genre, uploader_ip, last_voter_ip, UNIX_TIMESTAMP()-UNIX_TIMESTAMP(last_played) as delay_time
FROM songs
ORDER BY ".SORT." LIMIT ".(SONGS_PER_PAGE*($page-1)).", ". SONGS_PER_PAGE;
$SQL = $s ? "SELECT id, filename, times_played, num_votes, title, album, artist, year, genre, uploader_ip, last_voter_ip, delay_time
FROM ($SQL) AS DerivedTable
ORDER BY $BY_NAME" : $SQL;
gmstable("songlist",$SQL);
/************************************************************************************************************************/
echo " \r\n";
echo $nav; // Sidnavigering
if(!$can_vote) {
$timeleft = minsec(SECONDS_BETWEEN_VOTES-$last_voted);
echo "Du kan rösta igen om ". $timeleft[0] . " minuter och ". $timeleft[1] ." sekunder. \r\n";
}
/*** Uppladdningsformulär************************************************************************************/
$res = mysql_unbuffered_query("SELECT COUNT(*)
FROM gms_bans
WHERE IP=$IP");
list($banned) = mysql_fetch_row($res);
mysql_free_result($res);
if(!$banned) {
$res = mysql_query("SELECT UNIX_TIMESTAMP() - MAX(UNIX_TIMESTAMP(upload_time))
FROM uploads
WHERE ip=$IP");
list($last_uploaded) = mysql_fetch_row($res);
$last_uploaded = $last_uploaded == NULL ? time() : $last_uploaded;
$numrows = mysql_num_rows($res);
mysql_free_result($res);
if($last_uploaded >= SECONDS_BETWEEN_UPLOADS || $admin) {
echo "\r\n";
echo "Tillåtna format: ";
foreach($allowed_suffixes as $s) {
echo $s . " ";
}
echo " \r\n";
echo "Högsta filstorlek: ".MAX_SONG_FILESIZE."MB";
echo " \r\n";
} else {
$timeleft = minsec(SECONDS_BETWEEN_UPLOADS-$last_uploaded);
echo "Du kan ladda upp igen om ". $timeleft[0] . " minuter och ". $timeleft[1] ." sekunder. \r\n";
}
} else {
echo "Du är bannad från att ladda upp låtar.";
}
/***********************************************************************************************************/
/*** Admin-inställningar ***********************************************************************************/
if($admin) {
echo "Admin-mode \r\n";
echo "";
echo " \r\n";
echo "Uppdatera låtar \r\n";
echo "Logga ut \r\n";
} else {
echo "Admin \r\n";
}
/***********************************************************************************************************/
echo "Top 10 \r\n";
echo "Geekmeet Music System - Powered by Monsquaz. \r\n";
require_once("db_stop.php");
?>