Assets
".$row['name'].""; } ?>
"; echo "$assetname"; echo "$assetdesc"; echo "Exécution Scripts"; echo ""; if(isset($do) && $do == 'scripts'){ echo "
"; 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 "
"; echo "$scriptname"; echo "$scriptdesc"; echo "Time: $schedtime"; echo "CMD retreived: $rantime"; echo "Status: $status"; echo "Output: $output"; echo "Ran by: $username"; }elseif(isset($sched) && $sched == 'new'){ echo "
"; echo "New"; $getscriptsqry = mysqli_query($link, "SELECT * from scripts"); while($row = mysqli_fetch_array($getscriptsqry)){ echo "".$row['name'].""; } }elseif(isset($sched) && $sched == 'set'){ echo "
"; echo "Set time
"; echo "
"; } } } ?>