📄 audioadmin.php
字号:
<?
/**
* Admin.php
* Musicbox Version 2.1
* TeaM SCRiPTMAFiA 2005
*/
/*** Start Configuring here ***/
include_once("../sources/session.php");
if(!$session->logged_in){
header("location:adminpanel.php");
}
class Admin {
/**** Please Enter You Database Details here ****/
// MySQL Information
// Please dont forget to enter mysql information here
var $mysqlHostname = "localhost";
var $mysqlUsername = "insert your database details here";
var $mysqlPassword = "insert your database details here";
var $mysqlDbName = "insert your database details here";
// Root path to start looking for songs in for browse add!!!
var $musicpath = "/home/username/public_html/musicboxv2/audio";
/**** Nothing Else needs to be setup here ****/
var $mysqlConn;
var $extensions;
function Admin($action)
{
// Connect to the database
$this->dbConnect();
// Get the File Types
$this->getExtensions();
$this->openHTML();
// Print the Menu
$this->menu();
// Print the body area
$this->openBody();
// Determine Action
switch( $action ) {
case 'genre':
$this->genre();
break;
case 'song':
$this->song();
break;
case 'format':
$this->format();
break;
case 'artist':
$this->artist();
break;
case 'album':
$this->album();
break;
case 'songdir':
if( $_GET['dir'] == "" ) { $dir = $this->musicpath; }
else { $dir = $_GET['dir']; }
$this->songDirListing($dir);
break;
case 'playlist':
$this->playlist();
break;
case 'mailfriend':
$this->mailfriend();
break;
case 'addlyrics':
$this->addlyrics();
break;
default:
$this->login();
}
// Close the body area
$this->closeBody();
$this->closeHTML();
}
/********** Database Functions **********/
function dbConnect()
{
$this->mysqlConn = mysql_connect( $this->mysqlHostname, $this->mysqlUsername, $this->mysqlPassword )
or die("Error: Unable to connect to MySQL server.");
mysql_select_db( $this->mysqlDbName, $this->mysqlConn ) or die("Error: Unable to connect to MySQL database.");
}
function getExtensions() {
$query = "SELECT extension FROM format WHERE 1";
$result = mysql_query( $query );
for( $i = 0 ; $row = mysql_fetch_assoc($result) ; $i++ ) {
$this->extensions[$i] = $row['extension'];
}
}
/********** Login Functions **********/
function login()
{
#print("login");
}
function menu()
{
global $session;
# print("<div id='menu' style='position: absolute; top: 10px; left: 10px; width: 160px;font-size:.7em'>");
echo " <table width=\"90%\" align=\"center\" class='tdrow2'>";
echo " <tr>";
echo " <td>";
if($session->isAdmin()){
print("Welcome Administrator");
}
echo " </td>";
echo " <td>";
echo " </td>";
echo " </tr>";
echo " </table>";
# print("</div>");
}
function openBody()
{
# print("<div id='body' style='position: absolute; top: 10px; left: 120px;'>");
}
function closeBody()
{
# print("</div>");
}
function openHTML()
{
print("<html>\n");
print("<head>\n");
print("<title>Administration</title>\n");
print("<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1'>\n");
print("<link rel='stylesheet' type='text/css' media='all' href='../template/css/admintheme.css' /> ");
print("</head>\n");
print("<body>\n");
}
function closeHTML()
{
print("</body>\n");
print("</htm1>\n");
}
/********** GUI Functions **********/
function mysqlTable($resource,$headers,$base_url,$include_id)
{
$rowid = 0;
$idcol = 0;
// Resource is empty!
if( !(mysql_num_rows($resource) > 0) )
{
print("<p>No records found</p>");
exit;
}
// Get First Row for Fields
$row = mysql_fetch_assoc($resource);
// Print Fields
print("<p><table class='tdrow2' style='width:100%;border-collapse:collapse;border-spacing:0px;'>\n");
print(" <tr>\n");
$count = 0;
while ($field = current($row)) {
$count++;
if( key($row) == 'id' ) {
$idcol = $count;
}
if( !(key($row) == 'id' && !$include_id) ) {
print(" <th>".preg_replace("/_/"," ",key($row))."</th>\n");
}
next($row);
}
// Print Extra Headers
while( $header = current($headers) ) {
print(" <th>".key($headers)."</th>\n");
next($headers);
}
print(" </tr>\n");
$id=0;
do {
print(" <tr id='row".$rowid."' onMouseOver=\"this.bgColor='#DFE7EF'\" onMouseOut=\"this.bgColor=''\">\n");
$count = 0;
foreach( $row as $field ) {
$count++;
if( $count == $idcol ) { $id = $field; }
if( !( $count == $idcol && !$include_id) ) {
if( preg_match("/http:\/\//",$field ) ) {
$field = "<a href='".$field."'>".$field."</a>";
}
print(" <td>".$field."</td>\n");
}
}
foreach( $headers as $field ) {
print(" <td style='text-align: center'>[ <a href='".preg_replace("/\[id\]/",$id,$base_url).$field."'>X</a> ]</td>\n");
}
print(" </tr>\n");
$rowid++;
} while( $row = mysql_fetch_assoc($resource) );
print("</table></p>\n");
}
/********** Album Functions **********/
function album()
{
global $_GET;
$page = $_GET['page'];
switch( $page ) {
case 'del':
$this->delalbum($_GET['id']);
break;
case 'edit':
$this->infoalbum('edit');
break;
default: // default new
$this->infoalbum('new');
break;
}
$query = "SELECT al.id as id, al.album_name as Album_Name, ar.name as Artist_Name, al.album_release as Release_Date FROM album as al, artist as ar WHERE al.artist_id = ar.id ORDER BY al.album_name ASC";
if( $result = mysql_query($query) ) { $this->mysqlTable($result,array('Delete'=>'page=del','Edit'=>'page=edit'),"?action=album&id=[id]&",false); }
}
function infoalbum($type)
{
global $_GET;
$id = addslashes($_GET['id']);
print("<div id='info'>\n");
// Save Information?
if( $_GET['save'] == 'yes' ) {
$album_name = $_POST['album_name'];
$artist_id = addslashes($_POST['artist_id']);
$genre_id = addslashes($_POST['genre_id']);
$album_release = addslashes($_POST['date_year'])."-".addslashes($_POST['date_month'])."-15";
$album_photo = addslashes($_POST['album_photo']);
$album_info = $_POST['album_info'];
if( $type == 'new' ) {
$query = "INSERT INTO album ( album_name , artist_id , genre_id , album_release , album_photo , album_info , post_date ) ";
$query .= "VALUES ('".$album_name."', '".$artist_id."', '".$genre_id."', '".$album_release."', '".$album_photo."', '".$album_info."', NOW() )";
} else {
$query = "UPDATE album SET album_name = '".$album_name."', artist_id = '".$artist_id."', genre_id = '".$genre_id."', album_release = '".$album_release."', album_photo = '".$album_photo."', album_info = '".$album_info."' WHERE id = '".$id."'";
}
// Run Query
if( mysql_query($query) ) {
print("<p>Success! We were able to ".(($type=='new')?"create a new":"edit the specified")." album.</p>");
} else {
print("<p>Warning: We were unable to ".(($type=='new')?"create a new":"edit the specified")." album.</p>");
}
}
// Determine Type of Form
if( $type == 'new' ) {
print("<h1>New album</h1>\n");
$album_name = "";
$artist_id = "";
$genre_id = "";
$date_month = "";
$date_year = "2004";
$album_photo = "http://";
$album_info = "";
} else {
print("<h1>Edit album</h1>\n");
$query = "SELECT * FROM album WHERE id = '".$id."'";
$row = mysql_fetch_assoc( mysql_query($query) );
$album_name = $row['album_name'];
$artist_id = $row['artist_id'];
$genre_id = $row['genre_id'];
$date_month = date('m',strtotime($row['album_release']." CST"));
$date_year = date('Y',strtotime($row['album_release']." CST"));
$album_photo = $row['album_photo'];
$album_info = $row['album_info'];
}
// Form
print("<form action='?action=album&page=".$type."&save=yes&id=".$id."' method='post' name='form' id='form'>\n");
print(" <table width='500' border='0' cellpadding='0' cellspacing='0'>\n");
print(" <tr>\n");
print(" <td width='150'><label for='album_name'>album Name:</label></td>\n");
print(" <td><input name='album_name' id='album_name' type='text' maxlength='255' value='".$album_name."'></td>\n");
print(" </tr>\n");
print(" <tr>\n");
print(" <td width='150'><label for='artist_id'>Artist Name:</label></td>\n");
print(" <td><select name='artist_id' id='artist_id'>\n");
$query = "SELECT * FROM artist WHERE 1";
$result = mysql_query($query);
while( $row = mysql_fetch_assoc($result) ) {
print(" <option value='".$row['id']."' ".(($row['id']==$artist_id)?'SELECTED':'').">".$row['name']."</option>\n");
}
print(" </select></td>\n");
print(" </tr>\n");
print(" <tr>\n");
print(" <td width='150'><label for='genre_id'>Genre:</label></td>\n");
print(" <td><select name='genre_id' id='genre_id'>\n");
$query = "SELECT * FROM genre WHERE 1";
$result = mysql_query($query);
while( $row = mysql_fetch_assoc($result) ) {
print(" <option value='".$row['id']."' ".(($row['id']==$genre_id)?'SELECTED':'').">".$row['genre']."</option>\n");
}
print(" </select></td>\n");
print(" </tr>\n");
print(" <tr>\n");
print(" <td width='150'><label>Release Date:</label></td>\n");
print(" <td><span id='date'>\n");
print(" <select name='date_month' class='month' id='date_month'>\n");
print(" <option value='01' ".(($date_month=='01')?'SELECTED':'').">January</option>\n");
print(" <option value='02' ".(($date_month=='02')?'SELECTED':'').">February</option>\n");
print(" <option value='03' ".(($date_month=='03')?'SELECTED':'').">March</option>\n");
print(" <option value='04' ".(($date_month=='04')?'SELECTED':'').">April</option>\n");
print(" <option value='05' ".(($date_month=='05')?'SELECTED':'').">May</option>\n");
print(" <option value='06' ".(($date_month=='06')?'SELECTED':'').">June</option>\n");
print(" <option value='07' ".(($date_month=='07')?'SELECTED':'').">July</option>\n");
print(" <option value='08' ".(($date_month=='08')?'SELECTED':'').">August</option>\n");
print(" <option value='09' ".(($date_month=='09')?'SELECTED':'').">September</option>\n");
print(" <option value='10' ".(($date_month=='10')?'SELECTED':'').">October</option>\n");
print(" <option value='11' ".(($date_month=='11')?'SELECTED':'').">November</option>\n");
print(" <option value='12' ".(($date_month=='12')?'SELECTED':'').">December</option>\n");
print(" </select>\n");
print(" / \n");
print(" <input name='date_year' type='text' class='year' id='date_year' value='".$date_year."' maxlength='255'>\n");
print(" </span></td>\n");
print(" </tr>\n");
print(" <tr>\n");
print(" <td width='150'><label for='album_photo'>Photo URL:</label></td>\n");
print(" <td><input name='album_photo' id='album_photo' type='text' maxlength='255' value='".$album_photo."'></td>\n");
print(" </tr>\n");
print(" <tr>\n");
print(" <td width='150' valign='top'><label for='album_info'>album Information:</label></td>\n");
print(" <td rowspan='2'><textarea name='album_info' id='album_info'>".$album_info."</textarea></td>\n");
print(" </tr>\n");
print(" <tr>\n");
print(" <td width='150'> </td>\n");
print(" </tr>\n");
print(" <tr>\n");
print(" <td width='150'> </td>\n");
print(" <td><input name='Submit' type='submit' class='year' id='Submit' value='Submit'> <input name='Reset' type='reset' class='year' id='Reset' value='Reset'> </td>\n");
print(" </tr>\n");
print(" </table>\n");
print("</div>\n");
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -