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 "\r\n"; echo "\r\n"; echo "
Nu spelas:$song
Tid Spelad:$timeplayed

\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 "
"; echo "\r\n"; echo ""; echo ""; 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 "
"; echo ""; echo "Fil:\r\n"; echo ""; echo " "; echo ""; 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 "
\r\n"; echo "

\r\n"; echo "\r\n"; $res = mysql_unbuffered_query("SELECT id, variable, value FROM gms_settings ORDER BY variable"); while(list($id, $variable, $value) = mysql_fetch_row($res)) { if($variable == "ADMIN_IP") $value = long2ip($value); echo "\r\n"; echo "\r\n"; echo ""; echo "\r\n"; } mysql_free_result($res); echo ""; echo ""; echo "
$variable
\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"); ?>