📄 audioadmin.php
字号:
print("<p>Genre \"".$_POST['genre']."\" deleted succesfully.</p>");
} else {
$query = "SELECT * FROM genre WHERE id = '".$id."'";
$row = mysql_fetch_assoc( mysql_query($query) );
$genre = $row['genre'];
// Form
print("<form action='?action=genre&page=del&save=yes&id=".$id."' method='post' name='form' id='form'>\n");
print("<p>Are you sure that you would like to delete the genre \"".$genre."\"?");
print("<input type='hidden' name='genre' value='".$genre."'></p>\n");
print("<p><input name='Submit' type='submit' class='year' id='Submit' value='Confirm Delete'>\n");
print("</p></form>\n");
}
}
/********** Song Functions **********/
function song()
{
$page = $_GET['page'];
switch( $page ) {
case 'del':
$this->delSong(addslashes($_GET['id']));
break;
case 'edit':
$this->infoSong('edit');
break;
default: // default new
$this->infoSong('new');
break;
}
print("<h1>Add Multiple Files</h1>");
print("<p>----> <a href='?action=songdir' style='font-weight:bold'>Use Browse Add Songs to add multiple songs.</a></p>");
$query = "SELECT song.id as id, song.song_name as Song_Name, ar.name as Artist_Name, al.album_name as album_Name FROM album as al, artist as ar, song WHERE song.artist_id = ar.id AND song.album_id = al.id ORDER BY ar.name ASC, al.album_name ASC, song.song_name ASC";
if( $result = mysql_query($query) ) { $this->mysqlTable($result,array('Delete'=>'page=del','Edit'=>'page=edit'),"?action=song&id=[id]&",false); }
}
function infoSong($type)
{
global $_GET;
$id = addslashes($_GET['id']);
print("<div id='info'>\n");
// Save Information?
if( $_GET['save'] == 'yes' ) {
if( $type == 'new' ) {
$query = "INSERT INTO song ( song_name, artist_id, album_id, format_id, song_path ) VALUES ";
$query .= "('".addslashes($_POST['song_name'])."','".$_POST['artist_id']."','".$_POST['album_id']."','".$_POST['format_id']."','".addslashes($_POST['song_path'])."')";
} else {
$query = "UPDATE song SET song_name = '".addslashes($_POST['song_name'])."', artist_id = '".$_POST['artist_id']."', album_id='".$_POST['album_id']."', format_id='".$_POST['format_id']."', song_path='".addslashes($_POST['song_path'])."' WHERE id = '".$id."'";
}
// Run Query
if( mysql_query($query) ) {
print("<p>Success! We were able to ".(($type=='new')?"create a new":"edit the specified")." Song.</p>");
} else {
print("<p>Warning: We were unable to ".(($type=='new')?"create a new":"edit the specified")." Song.</p>");
}
}
// Determine Type of Form
if( $type == 'new' ) {
print("<h1>New Song</h1>\n");
$song_name = "";
$artist_id = "";
$album_id = "";
$length_min = 0;
$length_sec = 0;
$format_id = "";
$song_path = $this->musicpath;
} else {
print("<h1>Edit Song</h1>\n");
$query = "SELECT * FROM song WHERE id = '".$id."'";
$row = mysql_fetch_assoc( mysql_query($query) );
$song_name = $row['song_name'];
$artist_id = $row['artist_id'];
$album_id = $row['album_id'];
$length_min = floor($row['length']/60);
$length_sec = $row['length']%60;
$format_id = $row['format_id'];
$song_path = $row['song_path'];
}
// Form
print("<form action='?action=song&page=".$type."&save=yes&id=".$id."' method='post' name='form' id='form'>\n");
print(" <table class='tdrow2' width='500' border='0' cellpadding='0' cellspacing='0'>\n");
print(" <tr>\n");
print(" <td>Song Name: </td>\n");
print(" <td><input name='song_name' type='text' id='song_name' maxlength='255' value='".$song_name."'></td>\n");
print(" </tr>\n");
print(" <tr>\n");
print(" <td>Artist Name: </td>\n");
print(" <td><select name='artist_id' id='artist_id'>\n");
$query = "SELECT * FROM artist ORDER BY name ASC";
$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>album Name: </td>\n");
print(" <td><select name='album_id' id='album_id'>\n");
$query = "SELECT * FROM album ORDER BY album_name ASC";
$result = mysql_query($query);
while( $row = mysql_fetch_assoc($result) ) {
print(" <option value='".$row['id']."' ".(($row['id']==$album_id)?'SELECTED':'').">".$row['album_name']."</option>\n");
}
print(" </select></td>\n");
print(" </tr>\n");
print(" <tr>\n");
print(" <td>Format:</td>\n");
print(" <td><select name='format_id' id='format_id'>\n");
$query = "SELECT * FROM format ORDER BY format ASC";
$result = mysql_query($query);
while( $row = mysql_fetch_assoc($result) ) {
print(" <option value='".$row['id']."' ".(($row['id']==$format_id)?'SELECTED':'').">".$row['format']."</option>\n");
}
print(" </select></td>\n");
print(" </tr>\n");
print(" <tr>\n");
print(" <td>Song Path: </td>\n");
print(" <td><input name='song_path' type='text' id='song_path' maxlength='255' value='".$song_path."'></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'>\n");
print(" <input name='Reset' type='reset' class='year' id='Reset' value='Reset'>\n");
print(" </td>\n");
print(" </tr>\n");
print(" </table>\n");
print("</form></p>\n");
print("</div>\n");
}
function delSong($id)
{
if( $_GET['save'] ) {
$query = "DELETE FROM song WHERE id = '".$id."'";
mysql_query($query);
print("<p>Song \"".$_POST['song_name']."\" deleted succesfully.</p>");
} else {
$query = "SELECT * FROM song WHERE id = '".$id."'";
$row = mysql_fetch_assoc( mysql_query($query) );
$song = $row['song_name'];
// Form
print("<form action='?action=song&page=del&save=yes&id=".$id."' method='post' name='form' id='form'>\n");
print("<p>Are you sure that you would like to delete the song \"".$song."\"?");
print("<input type='hidden' name='song_name' value='".$song."'></p>\n");
print("<p><input name='Submit' type='submit' class='year' id='Submit' value='Confirm Delete'>\n");
print("</p></form>\n");
}
}
function songDirListing( $path ) {
if( sizeof($this->extensions) == 0 ){
die("Error: Must define formats supported by player first");
}
print("<h1>Browse Add Songs</h1>\n");
// Get Song Info
if( $_GET['page'] == 'details' ) {
if( $_GET['save'] == 'yes' ) {
$artist_id = -1;
$album_id = -1;
if( $_POST['artist_id'] != -1 ) {
$artist_id = $_POST['artist_id'];
}
if( $_POST['album_id'] != -1 ) {
$album_id = $_POST['album_id'];
}
// Loop through all
for( $i=0 ; $_POST[$i.'artist_id'] != '' ; $i++ ) {
$query = "INSERT INTO song ( song_name, artist_id, album_id, format_id, song_path ) VALUES ";
$query .= "('".addslashes($_POST[$i.'song_name'])."','".(($artist_id==-1)?$_POST[$i.'artist_id']:$artist_id)."','".(($album_id==-1)?$_POST[$i.'album_id']:$album_id)."','".$_POST[$i.'format_id']."','".addslashes($_POST[$i.'song_path'])."')";
mysql_query($query) or die(mysql_error());
}
print("<p>Songs succesfully save.</p>");
return;
}
$count=0;
print("<form action='?action=songdir&page=details&save=yes' method='post' name='form1' id='form1'>");
print("<h2>Apply Details to All Songs</h2>\n");
print("<p><table class='tdrow2' border='0' cellspacing='0' cellpadding='0'>\n");
print(" <td>Artist Name: </td>\n");
print(" <td><select name='artist_id' id='artist_id'>\n");
print(" <option value='-1' SELECTED>-------</option>\n");
$query = "SELECT * FROM artist WHERE 1";
$result = mysql_query($query);
while( $row = mysql_fetch_assoc($result) ) {
print(" <option value='".$row['id']."'>".$row['name']."</option>\n");
}
print(" </select></td>\n");
print(" </tr>\n");
print(" <tr>\n");
print(" <td>album Name: </td>\n");
print(" <td><select name='album_id' id='album_id'>\n");
print(" <option value='-1' SELECTED>-------</option>\n");
$query = "SELECT * FROM album ORDER BY album_name ASC";
$result = mysql_query($query);
while( $row = mysql_fetch_assoc($result) ) {
print(" <option value='".$row['id']."' ".(($row['id']==$album_id)?'SELECTED':'').">".$row['album_name']."</option>\n");
}
print(" </select></td>\n");
print(" </tr>\n");
print("</table>\n");
print("<h2>Individual Song Details</h2>\n");
foreach( $_POST as $song ) {
// Determine song name
$temp = split("/",$song);
$element = count($temp)-1;
list($song_name, $song_ext) = split("\.",$temp[$element]);
print("<p><table class='tdrow2' border='0' cellspacing='0' cellpadding='0'>\n");
print(" <tr>\n");
print(" <td>Song Name: </td>\n");
print(" <td><input name='".$count."song_name' type='text' id='".$count."song_name' value='".$song_name."'></td>\n");
print(" </tr>\n");
print(" <tr>\n");
print(" <td>Artist Name: </td>\n");
print(" <td><select name='".$count."artist_id' id='".$count."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['name']."</option>\n");
}
print(" </select></td>\n");
print(" </tr>\n");
print(" <tr>\n");
print(" <td>album Name: </td>\n");
print(" <td><select name='".$count."album_id' id='".$count."album_id'>\n");
$query = "SELECT * FROM album ORDER BY album_name ASC";
$result = mysql_query($query);
while( $row = mysql_fetch_assoc($result) ) {
print(" <option value='".$row['id']."' ".(($row['id']==$album_id)?'SELECTED':'').">".$row['album_name']."</option>\n");
}
print(" </select></td>\n");
print(" </tr>\n");
print(" <tr>\n");
print(" <td>Format:</td>\n");
print(" <td><select name='".$count."format_id' id='".$count."format_id'>\n");
$query = "SELECT * FROM format ORDER BY format ASC";
$result = mysql_query($query);
while( $row = mysql_fetch_assoc($result) ) {
print(" <option value='".$row['id']."' ".(preg_match("/".$song_ext."$/i",$row['extension'])?'SELECTED':'').">".$row['format']."</option>\n");
}
print(" </select></td>\n");
print(" </tr>\n");
print(" <tr>\n");
print(" <td>Song Path: </td>\n");
print(" <td><input name='".$count."song_path' type='hidden' id='".$count."song_path' value='".$song."'>".$song."</td>\n");
print(" </tr>\n");
print(" </table></p>\n");
$count++;
}
print("<input name='total' type='hidden' id='total' value='".$count."'>\n");
print("<p><input name='Submit' type='submit' class='year' id='Submit' value='Submit'>\n");
print("</p></form>\n");
} else {
print("<h2>Unlisted Files:</h2>\n");
print("<form action='?action=songdir&page=details' method='post' name='form1' id='form1'>\n");
$this->dirListing($path);
print("<p><input type='submit' class='year' id='Submit' value='Submit'>\n");
print("</p></form>\n");
}
}
function dirListing( $path ) {
if( $handle = opendir($path) ) {
while( false !== ($file = readdir($handle))) {
if( $file == "." || $file == ".." ) {
// do nothing
} else if( is_dir($path."/".$file) ) {
print("<p style='color: black; font-weight: bold;'>".$file."</p>\n");
print("<blockquote>\n");
$this->dirListing( $path."/".$file );
print("</blockquote>\n");
} else {
foreach( $this->extensions as $ext )
{
if( preg_match("/\.".$ext."$/i",$file) ) {
$query = "SELECT id FROM song WHERE song_path = '".$path."/".$file."'";
$result = mysql_query($query);
if( $oldfile = mysql_fetch_assoc($result) ) {
} else {
print("<p><input type='checkbox' class='checkbox' name='".$path."/".$file."' value='".$path."/".$file."'>".$file."</p>\n");
}
}
}
}
}
}
closedir($handle);
}
function addlyrics() {
$save = addslashes($_GET['save']);
if( $save == 'yes' ) {
for( $i = 0 ; $i < $_POST['num'] ; $i++ ) {
if( $_POST['song_'.$i] != "" ) {
$query = "UPDATE song SET lyrics_approved = '1', lyric_id = '".$_POST['lyric_'.$i]."' WHERE id = '".$_POST['song_'.$i]."'";
mysql_query($query) or die(mysql_error());
print("<p>Lyric ".$_POST['lyric_'.$i]." approved</p>");
} else if( $_POST['del_'.$i] != "" ) {
$query = "UPDATE song SET lyrics_approved = '0', lyric_id = '0' WHERE id = '".$_POST['song_'.$i]."'";
mysql_query($query) or die(mysql_error());
$query = "DELETE FROM lyric WHERE id ='".$_POST['lyric_'.$i]."'";
mysql_query($query) or die(mysql_error());
print("<p>Lyric ".$_POST['lyric_'.$i]." removed</p>");
}
$query = "UPDATE lyric SET lyrics = '".addslashes($_POST["lyrics_".$i])."' WHERE id = '".$_POST['lyric_'.$i]."'";
mysql_query($query) or die(mysql_error());
print("<p>Lyric ".$_POST['lyric_'.$i]." updated</p>");
}
}
$query = "SELECT AVG(song.rating/song.num_rating) as average_rating, album.album_name as album, song.lyric_id, album.id as album_id, artist.id as artist_id, artist.name AS artist_name, lyric.lyrics, song.song_name, song.id as song_id FROM song, album, artist, lyric WHERE album.id = song.album_id AND artist.id = song.artist_id AND lyric.id = song.lyric_id AND song.lyric_id != '0' AND song.lyrics_approved != '1' GROUP BY song.id";
$result = mysql_query($query) or die(mysql_error());
print("<form name='listing' action='?action=addlyrics&save=yes' method='post'>\n");
print("<table style='width: 100%; border: 0px;'>\n");
$i = 0;
for( $i = 0 ; $row = mysql_fetch_assoc($result); $i++ ) {
print("<tr><td>Approve: <input type='checkbox' name='song_".$i."' value='".$row['song_id']."' style='width:15px'> Delete: <input type='checkbox' name='del_".$i."' value='".$row['song_id']."' style='width:15px'> Song: <a href='index.php?action=song&id=".$row['song_id']."' target='_blank'>".$row['song_name']."</a></td></tr>\n");
print("<tr><td><span style='font-weight:bold;'>Artist Name:</span> <a href='index.php?action=artist&id=".$row['artist_id']."' target='_blank'>".$row['artist_name']."</a></td></tr>\n");
print("<tr><td><span style='font-weight:bold;'>Album Name:</span> <a href='index.php?action=album&id=".$row['album_id']."' target='_blank'>".$row['album']."</a></td></tr>\n");
print("<tr><td><input type='hidden' name='lyric_".$i."' value='".$row['lyric_id']."' style='width:15px'><textarea name='lyrics_".$i."'>".$row['lyrics']."</textarea></td></tr>\n");
print("<tr><td> </td></tr>\n");
}
if( $i == 0 ) {
print("<tr><td>No lyrics submitted</td></tr>\n");
}
print("<tr><td colspan='2'><input type='hidden' name='num' value='".$i."'><input type='submit' value='Submit'></td></tr>\n");
print("</table></form>\n");
}
}
// Login stuff
$myadmin = new Admin($action);
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -