";
echo "
Scripts";
echo "
New";
$getschedqry = mysqli_query($link, "SELECT * from schedules where assetid = $asset ORDER BY runtime DESC");
while($row = mysqli_fetch_array($getschedqry)){
$scriptid = $row['scriptid'];
$schedtime = $row['runtime'];
$schedid = $row['id'];
$getscriptqry = mysqli_query($link, "SELECT * from scripts where id = $scriptid");
while($row = mysqli_fetch_array($getscriptqry)){
$scriptname = $row['name'];
}
echo "
$scriptname $schedtime";
}
echo "
";
if(isset($sched) && $sched != 'new' && $sched != 'set'){
$getschedqry = mysqli_query($link, "SELECT * from schedules where id = $sched");
while($row = mysqli_fetch_array($getschedqry)){
$scriptid = $row['scriptid'];
$schedtime = $row['runtime'];
$rantime = $row['rantime'];
$status = $row['status'];
$output = $row['output'];
$userid = $row['userid'];
}
$getscriptqry = mysqli_query($link, "SELECT * from scripts where id = $scriptid");
while($row = mysqli_fetch_array($getscriptqry)){
$scriptname = $row['name'];
$scriptdesc = $row['description'];
}
$getuserqry = mysqli_query($link, "SELECT * from users where id = $userid");
while($row = mysqli_fetch_array($getuserqry)){
$username = $row['username'];
}
echo "