Esempio n. 1
0
            update_master_table($post_showid, $post_showtime);
        } else {
            remove_from_master_table($post_showid, $post_showtime);
        }
    }
}
$sql = "select * from masterschedule order by starttime";
if (!($result = mysql_query($sql))) {
    print mysql_error();
} else {
    while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
        print "<tr align='center'><td>";
        if ($line['showid'] == -1) {
            $showname = "Random";
        } else {
            $showname = get_showname($line['showid']);
        }
        $showtime = $line['starttime'];
        print $showname;
        print "</td><td>";
        print $showtime;
        print "</td></tr>";
    }
}
?>
</table>
<div id="contenttool">
<h3>Add/Edit Schedule</h3>
<form name=song action=schedule.php method=POST>
<?php 
$sql = "select showname,ID from shows";
Esempio n. 2
0
    $description = $_POST['description'];
    $logoimage = $_POST['showlogo'];
    $showname = $_POST['showname'];
    if (file_exists($show_path . "/" . $_POST['dir'])) {
        insert_into_shows($showname, $description, $logoimage, $show_path . "/" . $_POST['dir']);
        $showid = get_show_id($showname);
        import_show($showid, $show_path . "/" . $_POST['dir'], 0);
    } else {
        $error = 1;
        print 'Directory does not exist, Please create it and refresh';
    }
}
if ($error == 0) {
    if (isset($_GET['showid'])) {
        $showid = $_GET['showid'];
        $showname = get_showname($showid);
        if (isset($_GET['refresh'])) {
            delete_all_showtunes($showid);
        }
        $path = get_show_path($showid);
        import_show($showid, $path, 0);
    }
    print "<table align='center' border='1px dotted #909090'><tr><td><h2>Song Name</h2></td><td><h2>Artist</h2></td><td><h2>Album</h2></td><td><h2>time</h2></td><td>Operation</td><td>Order</td><td><h2>Filename</h2></td></tr>";
    $sql = "select * from tunes where showid='{$showid}'";
    if (!($result = mysql_query($sql))) {
        print mysql_error();
    } else {
        while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
            print "<tr align='center'><td>\n";
            print $line['title'] . "</td><td>\n";
            $artist_name = get_artist_name($line['artistid']);