function show_jobs()
{
$dbc = dbc::instance();
$result = $dbc->prepare("select * from " . PJS_TABLE);
$rows = $dbc->executeGetRows($result);
if (count($rows)) {
$table_rows = "";
$bg_colour = "#FFFFFF";
foreach ($rows as $row) {
foreach ($row as $key => $value) {
${$key} = $value;
}
if ($time_last_fired == 0) {
$last_fire_hours = "<font color=\"#FF8000\">NOT yet fired</font>";
$last_fire_date = "";
} else {
$last_fire_hours = strftime("%H:%M:%S ", $time_last_fired);
$last_fire_date = strftime("on<br> %b %d, %Y", $time_last_fired);
}
$fire_hours = strftime("%H:%M:%S ", $fire_time);
$fire_date = strftime("%b %d, %Y", $fire_time);
if ($bg_colour == "#E9E9E9") {
$bg_colour = "#FFFFFF";
} else {
$bg_colour = "#E9E9E9";
}
$run_only_once_txt = $run_only_once ? "<i><font color=\"#ff0000\"> Will run just once</font></i>" : "";
$time_interval = time_unit($time_interval);
$paused_txt = $paused ? '<font color="#ff0000">PAUSED</font>' : '';
$table_rows .= "\n <tr align=\"center\">\n <th align=\"left\" bgcolor=\"{$bg_colour}\">\n <div id=\"pjs{$id}\">\n <font color=\"#008000\">{$paused_txt} "{$name}"</font> - <a\n href=\"javascript:modify({$id});\">MODIFY</a> -\n <a href=\"javascript:deletepjs('" . PJS_TABLE . "',{$id},'{$name}');\">DELETE?</a> {$run_only_once_txt}<br>\n <small>Script path: <font color=\"#000000\">{$scriptpath}</font></small>\n </div>\n </th>\n <th align=\"center\" bgcolor=\"{$bg_colour}\">\n <div id=\"pjs{$id}\">\n {$last_fire_hours} {$last_fire_date}\n </div>\n </th>\n <th align=\"center\" bgcolor=\"{$bg_colour}\">\n <div id=\"pjs{$id}\">\n {$fire_hours} on<br> {$fire_date}\n </div>\n </th>\n <th align=\"center\" bgcolor=\"{$bg_colour}\">\n <div id=\"pjs{$id}\">\n {$time_interval['0']} {$time_interval['1']}\n </div>\n </th>\n </tr>";
}
} else {
$table_rows = "<b><font color=\"#FF0000\">NO Jobs saved - to add a NEW scheduled job click the Add NEW schedule link above.</font></b><br><br>";
}
echo $table_rows;
}
<?php
$app_name = "phpJobScheduler";
$phpJobScheduler_version = "3.9";
// -------------------------------
include "functions.php";
$id = clean_input($_POST['id']);
$dbc = dbc::instance();
$result = $dbc->prepare("select * from " . PJS_TABLE . " where id='{$id}' ");
$rows = $dbc->executeGetRows($result);
if (count($rows) < 1) {
js_msg("There has been an error!");
}
$row = $rows[0];
// check if its hours
$interval_array = time_unit($row["time_interval"]);
if (preg_match("/minute/", $interval_array[1]) > 0) {
$minutes = $interval_array[0];
} else {
$minutes = -1;
}
if (preg_match("/hour/", $interval_array[1]) > 0) {
$hours = $interval_array[0];
} else {
$hours = -1;
}
if (preg_match("/day/", $interval_array[1]) > 0) {
$days = $interval_array[0];
} else {
$days = -1;
}
