В настоящее время я использую phpjobscheduler, который использует strftime. Самая большая проблема, с которой я сталкиваюсь, – это преобразование setlocale для Европы / Лондона, это текущие функции. Php Мне нужна помощь с
log_date=strftime("Date: %d %b %Y Time: %H:%M:%S",$date_added); При текущих настройках в коде ниже задача расписания не запускается в заданное время, а иногда выполняется 15 – 30 минут, что я думаю, это setlocale. Если кто-то может дать представление о том, как изменить код, чтобы он работал в Европе / Лондоне , я был бы очень признателен
Я рассмотрел следующие примеры, которые я пробовал
setlocale(LC_ALL, array('en_GB.UTF8','en_GB@euro','en_GB','english')); setlocale(LC_ALL, 'en-UK');
ни работа
funtions.php
include_once("config.inc.php"); include_once("constants.inc.php"); $app_name = "phpJobScheduler"; $phpJobScheduler_version = "3.8"; // --------------------------------------------------------- if (DBNAME=="")//not configured { header("location: ../readme.html?noconfig=1"); exit; } if (!function_exists('clean_input')) // check to see if function is not already defined by another application { function clean_input($string) { $patterns[0] = "/'/"; $patterns[1] = "/\"/"; $string = preg_replace($patterns,'',$string); $string = trim($string); $string = stripslashes($string); return preg_replace("/[<>]/", '_', $string); } } function update_db() { db_connect(); if(mysql_num_rows(pjs_mysql_query("SHOW TABLES LIKE '".LOGS_TABLE."'"))==0) { $q_create_table = " CREATE TABLE ".LOGS_TABLE." ( id int(11) NOT NULL, script varchar(128) default NULL, output text default NULL, execution_time varchar(60) default NULL, PRIMARY KEY (id) )"; $result=pjs_mysql_query($q_create_table); } if(mysql_num_rows(pjs_mysql_query("SHOW TABLES LIKE '".PJS_TABLE."'"))==0) { $main_table="CREATE TABLE ".PJS_TABLE." ( id int(11) NOT NULL auto_increment, scriptpath varchar(255) default NULL, name varchar(128) default NULL, time_interval int(11) default NULL, fire_time int(11) NOT NULL default '0', time_last_fired int(11) default NULL, run_only_once tinyint(1) NOT NULL DEFAULT '0', currently_running BOOLEAN NOT NULL DEFAULT '0', PRIMARY KEY (id), KEY fire_time (fire_time))"; $result=pjs_mysql_query($main_table); } $result=pjs_mysql_query("SHOW COLUMNS FROM ".LOGS_TABLE." LIKE 'date_added' "); if (!mysql_num_rows($result)) $result=pjs_mysql_query("ALTER TABLE ".LOGS_TABLE." ADD date_added int AFTER id, CHANGE `id` `id` INT( 11 ) NOT NULL AUTO_INCREMENT "); } function pjs_mysql_query($q) { return mysql_query($q); if (mysql_error() AND DEBUG) echo "<hr>MySQL ERROR: ".mysql_error()."<hr>"; } function time_unit($time_interval) { global $app_name; $unit = array(0, 'type'); //check if its minutes if ($time_interval <= (59 * 60)) { $unit[0]=$time_interval/60; $unit[1]="<font color=\"#000000\">minute(s)</font>"; } //check if its hours if ( ($time_interval > (59 * 60)) AND ($time_interval<= (23 * 3600)) ) { $unit[0]=$time_interval/3600; $unit[1]="<font color=\"#ff0000\">hour(s)</font>"; } // check if its days if ( ($time_interval > (23 * 3600)) AND ($time_interval <= (6 * 86400)) ) { $unit[0]=$time_interval/86400; $unit[1]="<font color=\"#FF8000\">day(s)</font>"; } if ($time_interval >(6 * 86400)) { $unit[0]=$time_interval/604800; $unit[1]="<font color=\"#C00000\">week(s)</font>"; } $thedomain = $_SERVER['HTTP_HOST']; return $unit; } function db_connect() { @$db_link = mysql_connect(DBHOST, DBUSER, DBPASS); if ($db_link) @mysql_select_db(DBNAME); if (mysql_error() AND DEBUG) echo "<hr>MySQL ERROR: ".mysql_error()."<hr>"; if (mysql_error()) exit(); return $db_link; } function db_close() { global $db_link; if ($db_link) $result = mysql_close($db_link); } function js_msg($msg) { echo "<script><!--\n alert(\"$msg\");\n// --></script>"; } function show_jobs() { db_connect(); $query="select * from ".PJS_TABLE; $result = pjs_mysql_query($query); if (mysql_num_rows($result)) // check has got some { $i = 0; $table_rows=""; $bg_colour="#FFFFFF"; while ($i < mysql_num_rows($result)) { $id=mysql_result($result,$i, 'id'); $scriptpath=mysql_result($result,$i, 'scriptpath'); $name=mysql_result($result,$i, 'name'); $time_interval=mysql_result($result,$i, 'time_interval'); $fire_time=mysql_result($result,$i, 'fire_time'); $time_last_fired=mysql_result($result,$i, 'time_last_fired'); $run_only_once_txt= (mysql_result($result,$i, 'run_only_once'))? "<i><font color=\"#ff0000\"> Will run just once</font></i>":""; $time_interval = time_unit($time_interval); 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"; $table_rows.=" <tr align=\"center\"> <th align=\"left\" bgcolor=\"$bg_colour\"> <div id=\"pjs$id\"> <font color=\"#008000\">"$name"</font> - <a href=\"javascript:modify($id);\">MODIFY</a> - <a href=\"javascript:deletepjs('".PJS_TABLE."',$id,'$name');\">DELETE?</a> $run_only_once_txt<br> <small>Script path: <font color=\"#000000\">$scriptpath</font></small> </div> </th> <th align=\"center\" bgcolor=\"$bg_colour\"> <div id=\"pjs$id\"> $last_fire_hours $last_fire_date </div> </th> <th align=\"center\" bgcolor=\"$bg_colour\"> <div id=\"pjs$id\"> $fire_hours on<br> $fire_date </div> </th> <th align=\"center\" bgcolor=\"$bg_colour\"> <div id=\"pjs$id\"> $time_interval[0] $time_interval[1] </div> </th> </tr>"; $i++; } } 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>"; db_close(); echo $table_rows; } function show_logs($qstart) { db_connect(); $num=20;// logs to display $next_logs=$num+$qstart; $query="select * from ".LOGS_TABLE." ORDER BY id DESC LIMIT $qstart, $num"; $result = pjs_mysql_query($query); if (mysql_num_rows($result)) // check has got some { $i = 0; $table_rows=""; $bg_colour="#FFFFFF"; while ($i < mysql_num_rows($result)) { $id=mysql_result($result,$i, 'id'); $date_added=mysql_result($result,$i, 'date_added'); $script=mysql_result($result,$i, 'script'); $output= mysql_result($result,$i, 'output') ; $output_decoded=html_entity_decode($output); $execution_time= mysql_result($result,$i,'execution_time'); $log_date=strftime("Date: %d %b %Y Time: %H:%M:%S",$date_added); if ($bg_colour=="#E9E9E9") $bg_colour="#FFFFFF"; else $bg_colour="#E9E9E9"; if ($output!="") $show_hide="<a href=\"javascript:show_hide('$id');\">Show/Hide</a>"; else $show_hide="NO data"; $table_rows.=" <tr align=\"center\"> <th align=\"left\" bgcolor=\"$bg_colour\"> <div id=\"pjs$id\"> <small>Script: <font color=\"#000000\">$script</font> <br>Execution time: <font color=\"#000000\">$execution_time</font> Output: <font color=\"#FF8000\">*</font> $show_hide <div id=\"$id\" style=\"display:none;background-color:#FFE6E6;color:#FF0000\"> <blockquote>$output <br></blockquote> </div> </small></small> </div> </th> <th align=\"center\" bgcolor=\"$bg_colour\"> <small><div id=\"pjs$id\">$log_date <br> <a href=\"javascript:deletepjs('".LOGS_TABLE."',$id,'$script');\">DELETE?</a> <br></small></div> </th> </tr>"; $i++; } $qend=$i+$qstart; db_close(); echo "$table_rows </table></center></div></form> <center><strong> Currently displaying most recent logs from $qstart to $qend<br></strong>"; $next_link="<strong><a href=\"error-logs.php?start=$next_logs\">Show Next $num logs >></a> </strong><br><br><br>"; if ($num==$i) echo $next_link; echo '<p align="center"><font color="#FF8000">* Maximum length of output will be <strong>'.MAX_ERROR_LOG_LENGTH.' characters</strong>. </font>To change this <a href="../readme.html#error_log">please see the readme file</a><br>'; } else echo "<b><center><font color=\"#FF0000\">NO logs.</font>"; } function fire_script($script,$id,$buffer_output=1) { if($buffer_output) ob_start(); $scriptRunning = new scriptStatus; $scriptRunning->script=$script; if ($scriptRunning->Running($id) ) { $start_time = microtime(true); $fire_type = (function_exists('curl_exec') ) ? " PHP CURL " : " PHP fsockopen "; // "://" satisfies both cases http:// and https:// if (strstr($script,"://") ) fire_remote_script($script); else { include(LOCATION.$script); $fire_type=" PHP include "; } if($buffer_output) $scriptRunning->output=ob_get_contents(); else $scriptRunning->output=""; $scriptRunning->execution_time=number_format( (microtime(true) - $start_time), 5 )." seconds via".$fire_type; $scriptRunning->Stopped($id); } if($buffer_output) ob_end_clean(); } class scriptStatus { public $script; public $output; public $executionTime; public function Running($id) { $result=pjs_mysql_query("UPDATE ".PJS_TABLE." SET currently_running='1' where id='$id' "); register_shutdown_function('Clear', $id);// registed incase execution times out before Stopped called return $result; } public function Stopped($id) { $result=pjs_mysql_query("UPDATE ".PJS_TABLE." SET currently_running='0' where id='$id' "); if (ERROR_LOG) //save log to db { $now = time(); $this->script=clean_input($this->script); $this->output=substr(htmlentities($this->output), 0, MAX_ERROR_LOG_LENGTH);// truncate output to defined length $query="INSERT INTO ".LOGS_TABLE." (`id`, `date_added`,`script`, `output`, `execution_time`) VALUES (null,'$now', '$this->script','$this->output','$this->execution_time') "; pjs_mysql_query($query); //echo $query; } } } function fire_remote_script($url) { $url_parsed = parse_url($url); $scheme = $url_parsed["scheme"]; $host = $url_parsed["host"]; $port = isset($url_parsed["port"]) ? $url_parsed["port"] : 80; $path = isset($url_parsed["path"]) ? $url_parsed["path"] : "/"; $query = isset($url_parsed["query"]) ? $url_parsed["query"] : ""; $user = isset($url_parsed["user"]) ? $url_parsed["user"] : ""; $pass = isset($url_parsed["pass"]) ? $url_parsed["pass"] : ""; $useragent="phpJobScheduler (http://www.dwalker.co.uk/phpjobscheduler/)"; $referer=$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF']; $buffer=""; if (function_exists('curl_exec')) { $ch = curl_init($scheme."://".$host.$path); curl_setopt($ch, CURLOPT_PORT, $port); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_HEADER, 0); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER,false); curl_setopt($ch, CURLOPT_FAILONERROR,1); // true to fail silently curl_setopt($ch, CURLOPT_AUTOREFERER,1); curl_setopt($ch, CURLOPT_POSTFIELDS,$query); curl_setopt($ch, CURLOPT_REFERER,$referer); curl_setopt($ch, CURLOPT_USERAGENT,$useragent); curl_setopt($ch, CURLOPT_USERPWD,$user.":".$pass); $buffer = curl_exec($ch); curl_close($ch); } elseif ( $fp = @fsockopen($host, $port, $errno, $errstr, 30) ) { $header = "POST $path HTTP/1.0\r\nHost: $host\r\nReferer: $referer\r\n" ."Content-Type: application/x-www-form-urlencoded\r\n" ."User-Agent: $useragent\r\n" ."Content-Length: ". strlen($query)."\r\n"; if($user!= "") $header.= "Authorization: Basic ".base64_encode("$user:$pass")."\r\n"; $header.= "Connection: close\r\n\r\n"; fputs($fp, $header); fputs($fp, $query); if ($fp) while (!feof($fp)) $buffer.= fgets($fp, 8192); @fclose($fp); } echo $buffer; } function version_check() { global $phpJobScheduler_version; $version_url="HTTP://www.dwalker.co.uk/versions/"; echo '<script src="'.$version_url.'" type="text/javascript"></script> <script language="JavaScript"><!-- var phpJobScheduler_version = "'.$phpJobScheduler_version.'"; var version_txt=phpJobScheduler_version; if (LATEST_phpJobScheduler_version==phpJobScheduler_version) { version_txt=version_txt+"<br><font color=#008000>which is the most recent version.</font>"; } else { version_txt=version_txt+"<br><b><font color=#FF0000>UPGRADE REQUIRED"; version_txt=version_txt+"<br>Please <a href=http://www.phpJobScheduler.co.uk/>visit here</a> "; version_txt=version_txt+"to download the latest version </b>"; } document.write(version_txt); // --></script>'; } function Clear($id) { db_connect(); //If things go wrong, or script timeout CLEAR script so will run next time $result=pjs_mysql_query("UPDATE ".PJS_TABLE." SET currently_running = '0' where id='$id' "); db_close(); }поinclude_once("config.inc.php"); include_once("constants.inc.php"); $app_name = "phpJobScheduler"; $phpJobScheduler_version = "3.8"; // --------------------------------------------------------- if (DBNAME=="")//not configured { header("location: ../readme.html?noconfig=1"); exit; } if (!function_exists('clean_input')) // check to see if function is not already defined by another application { function clean_input($string) { $patterns[0] = "/'/"; $patterns[1] = "/\"/"; $string = preg_replace($patterns,'',$string); $string = trim($string); $string = stripslashes($string); return preg_replace("/[<>]/", '_', $string); } } function update_db() { db_connect(); if(mysql_num_rows(pjs_mysql_query("SHOW TABLES LIKE '".LOGS_TABLE."'"))==0) { $q_create_table = " CREATE TABLE ".LOGS_TABLE." ( id int(11) NOT NULL, script varchar(128) default NULL, output text default NULL, execution_time varchar(60) default NULL, PRIMARY KEY (id) )"; $result=pjs_mysql_query($q_create_table); } if(mysql_num_rows(pjs_mysql_query("SHOW TABLES LIKE '".PJS_TABLE."'"))==0) { $main_table="CREATE TABLE ".PJS_TABLE." ( id int(11) NOT NULL auto_increment, scriptpath varchar(255) default NULL, name varchar(128) default NULL, time_interval int(11) default NULL, fire_time int(11) NOT NULL default '0', time_last_fired int(11) default NULL, run_only_once tinyint(1) NOT NULL DEFAULT '0', currently_running BOOLEAN NOT NULL DEFAULT '0', PRIMARY KEY (id), KEY fire_time (fire_time))"; $result=pjs_mysql_query($main_table); } $result=pjs_mysql_query("SHOW COLUMNS FROM ".LOGS_TABLE." LIKE 'date_added' "); if (!mysql_num_rows($result)) $result=pjs_mysql_query("ALTER TABLE ".LOGS_TABLE." ADD date_added int AFTER id, CHANGE `id` `id` INT( 11 ) NOT NULL AUTO_INCREMENT "); } function pjs_mysql_query($q) { return mysql_query($q); if (mysql_error() AND DEBUG) echo "<hr>MySQL ERROR: ".mysql_error()."<hr>"; } function time_unit($time_interval) { global $app_name; $unit = array(0, 'type'); //check if its minutes if ($time_interval <= (59 * 60)) { $unit[0]=$time_interval/60; $unit[1]="<font color=\"#000000\">minute(s)</font>"; } //check if its hours if ( ($time_interval > (59 * 60)) AND ($time_interval<= (23 * 3600)) ) { $unit[0]=$time_interval/3600; $unit[1]="<font color=\"#ff0000\">hour(s)</font>"; } // check if its days if ( ($time_interval > (23 * 3600)) AND ($time_interval <= (6 * 86400)) ) { $unit[0]=$time_interval/86400; $unit[1]="<font color=\"#FF8000\">day(s)</font>"; } if ($time_interval >(6 * 86400)) { $unit[0]=$time_interval/604800; $unit[1]="<font color=\"#C00000\">week(s)</font>"; } $thedomain = $_SERVER['HTTP_HOST']; return $unit; } function db_connect() { @$db_link = mysql_connect(DBHOST, DBUSER, DBPASS); if ($db_link) @mysql_select_db(DBNAME); if (mysql_error() AND DEBUG) echo "<hr>MySQL ERROR: ".mysql_error()."<hr>"; if (mysql_error()) exit(); return $db_link; } function db_close() { global $db_link; if ($db_link) $result = mysql_close($db_link); } function js_msg($msg) { echo "<script><!--\n alert(\"$msg\");\n// --></script>"; } function show_jobs() { db_connect(); $query="select * from ".PJS_TABLE; $result = pjs_mysql_query($query); if (mysql_num_rows($result)) // check has got some { $i = 0; $table_rows=""; $bg_colour="#FFFFFF"; while ($i < mysql_num_rows($result)) { $id=mysql_result($result,$i, 'id'); $scriptpath=mysql_result($result,$i, 'scriptpath'); $name=mysql_result($result,$i, 'name'); $time_interval=mysql_result($result,$i, 'time_interval'); $fire_time=mysql_result($result,$i, 'fire_time'); $time_last_fired=mysql_result($result,$i, 'time_last_fired'); $run_only_once_txt= (mysql_result($result,$i, 'run_only_once'))? "<i><font color=\"#ff0000\"> Will run just once</font></i>":""; $time_interval = time_unit($time_interval); 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"; $table_rows.=" <tr align=\"center\"> <th align=\"left\" bgcolor=\"$bg_colour\"> <div id=\"pjs$id\"> <font color=\"#008000\">"$name"</font> - <a href=\"javascript:modify($id);\">MODIFY</a> - <a href=\"javascript:deletepjs('".PJS_TABLE."',$id,'$name');\">DELETE?</a> $run_only_once_txt<br> <small>Script path: <font color=\"#000000\">$scriptpath</font></small> </div> </th> <th align=\"center\" bgcolor=\"$bg_colour\"> <div id=\"pjs$id\"> $last_fire_hours $last_fire_date </div> </th> <th align=\"center\" bgcolor=\"$bg_colour\"> <div id=\"pjs$id\"> $fire_hours on<br> $fire_date </div> </th> <th align=\"center\" bgcolor=\"$bg_colour\"> <div id=\"pjs$id\"> $time_interval[0] $time_interval[1] </div> </th> </tr>"; $i++; } } 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>"; db_close(); echo $table_rows; } function show_logs($qstart) { db_connect(); $num=20;// logs to display $next_logs=$num+$qstart; $query="select * from ".LOGS_TABLE." ORDER BY id DESC LIMIT $qstart, $num"; $result = pjs_mysql_query($query); if (mysql_num_rows($result)) // check has got some { $i = 0; $table_rows=""; $bg_colour="#FFFFFF"; while ($i < mysql_num_rows($result)) { $id=mysql_result($result,$i, 'id'); $date_added=mysql_result($result,$i, 'date_added'); $script=mysql_result($result,$i, 'script'); $output= mysql_result($result,$i, 'output') ; $output_decoded=html_entity_decode($output); $execution_time= mysql_result($result,$i,'execution_time'); $log_date=strftime("Date: %d %b %Y Time: %H:%M:%S",$date_added); if ($bg_colour=="#E9E9E9") $bg_colour="#FFFFFF"; else $bg_colour="#E9E9E9"; if ($output!="") $show_hide="<a href=\"javascript:show_hide('$id');\">Show/Hide</a>"; else $show_hide="NO data"; $table_rows.=" <tr align=\"center\"> <th align=\"left\" bgcolor=\"$bg_colour\"> <div id=\"pjs$id\"> <small>Script: <font color=\"#000000\">$script</font> <br>Execution time: <font color=\"#000000\">$execution_time</font> Output: <font color=\"#FF8000\">*</font> $show_hide <div id=\"$id\" style=\"display:none;background-color:#FFE6E6;color:#FF0000\"> <blockquote>$output <br></blockquote> </div> </small></small> </div> </th> <th align=\"center\" bgcolor=\"$bg_colour\"> <small><div id=\"pjs$id\">$log_date <br> <a href=\"javascript:deletepjs('".LOGS_TABLE."',$id,'$script');\">DELETE?</a> <br></small></div> </th> </tr>"; $i++; } $qend=$i+$qstart; db_close(); echo "$table_rows </table></center></div></form> <center><strong> Currently displaying most recent logs from $qstart to $qend<br></strong>"; $next_link="<strong><a href=\"error-logs.php?start=$next_logs\">Show Next $num logs >></a> </strong><br><br><br>"; if ($num==$i) echo $next_link; echo '<p align="center"><font color="#FF8000">* Maximum length of output will be <strong>'.MAX_ERROR_LOG_LENGTH.' characters</strong>. </font>To change this <a href="../readme.html#error_log">please see the readme file</a><br>'; } else echo "<b><center><font color=\"#FF0000\">NO logs.</font>"; } function fire_script($script,$id,$buffer_output=1) { if($buffer_output) ob_start(); $scriptRunning = new scriptStatus; $scriptRunning->script=$script; if ($scriptRunning->Running($id) ) { $start_time = microtime(true); $fire_type = (function_exists('curl_exec') ) ? " PHP CURL " : " PHP fsockopen "; // "://" satisfies both cases http:// and https:// if (strstr($script,"://") ) fire_remote_script($script); else { include(LOCATION.$script); $fire_type=" PHP include "; } if($buffer_output) $scriptRunning->output=ob_get_contents(); else $scriptRunning->output=""; $scriptRunning->execution_time=number_format( (microtime(true) - $start_time), 5 )." seconds via".$fire_type; $scriptRunning->Stopped($id); } if($buffer_output) ob_end_clean(); } class scriptStatus { public $script; public $output; public $executionTime; public function Running($id) { $result=pjs_mysql_query("UPDATE ".PJS_TABLE." SET currently_running='1' where id='$id' "); register_shutdown_function('Clear', $id);// registed incase execution times out before Stopped called return $result; } public function Stopped($id) { $result=pjs_mysql_query("UPDATE ".PJS_TABLE." SET currently_running='0' where id='$id' "); if (ERROR_LOG) //save log to db { $now = time(); $this->script=clean_input($this->script); $this->output=substr(htmlentities($this->output), 0, MAX_ERROR_LOG_LENGTH);// truncate output to defined length $query="INSERT INTO ".LOGS_TABLE." (`id`, `date_added`,`script`, `output`, `execution_time`) VALUES (null,'$now', '$this->script','$this->output','$this->execution_time') "; pjs_mysql_query($query); //echo $query; } } } function fire_remote_script($url) { $url_parsed = parse_url($url); $scheme = $url_parsed["scheme"]; $host = $url_parsed["host"]; $port = isset($url_parsed["port"]) ? $url_parsed["port"] : 80; $path = isset($url_parsed["path"]) ? $url_parsed["path"] : "/"; $query = isset($url_parsed["query"]) ? $url_parsed["query"] : ""; $user = isset($url_parsed["user"]) ? $url_parsed["user"] : ""; $pass = isset($url_parsed["pass"]) ? $url_parsed["pass"] : ""; $useragent="phpJobScheduler (http://www.dwalker.co.uk/phpjobscheduler/)"; $referer=$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF']; $buffer=""; if (function_exists('curl_exec')) { $ch = curl_init($scheme."://".$host.$path); curl_setopt($ch, CURLOPT_PORT, $port); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_HEADER, 0); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER,false); curl_setopt($ch, CURLOPT_FAILONERROR,1); // true to fail silently curl_setopt($ch, CURLOPT_AUTOREFERER,1); curl_setopt($ch, CURLOPT_POSTFIELDS,$query); curl_setopt($ch, CURLOPT_REFERER,$referer); curl_setopt($ch, CURLOPT_USERAGENT,$useragent); curl_setopt($ch, CURLOPT_USERPWD,$user.":".$pass); $buffer = curl_exec($ch); curl_close($ch); } elseif ( $fp = @fsockopen($host, $port, $errno, $errstr, 30) ) { $header = "POST $path HTTP/1.0\r\nHost: $host\r\nReferer: $referer\r\n" ."Content-Type: application/x-www-form-urlencoded\r\n" ."User-Agent: $useragent\r\n" ."Content-Length: ". strlen($query)."\r\n"; if($user!= "") $header.= "Authorization: Basic ".base64_encode("$user:$pass")."\r\n"; $header.= "Connection: close\r\n\r\n"; fputs($fp, $header); fputs($fp, $query); if ($fp) while (!feof($fp)) $buffer.= fgets($fp, 8192); @fclose($fp); } echo $buffer; } function version_check() { global $phpJobScheduler_version; $version_url="HTTP://www.dwalker.co.uk/versions/"; echo '<script src="'.$version_url.'" type="text/javascript"></script> <script language="JavaScript"><!-- var phpJobScheduler_version = "'.$phpJobScheduler_version.'"; var version_txt=phpJobScheduler_version; if (LATEST_phpJobScheduler_version==phpJobScheduler_version) { version_txt=version_txt+"<br><font color=#008000>which is the most recent version.</font>"; } else { version_txt=version_txt+"<br><b><font color=#FF0000>UPGRADE REQUIRED"; version_txt=version_txt+"<br>Please <a href=http://www.phpJobScheduler.co.uk/>visit here</a> "; version_txt=version_txt+"to download the latest version </b>"; } document.write(version_txt); // --></script>'; } function Clear($id) { db_connect(); //If things go wrong, or script timeout CLEAR script so will run next time $result=pjs_mysql_query("UPDATE ".PJS_TABLE." SET currently_running = '0' where id='$id' "); db_close(); }.include_once("config.inc.php"); include_once("constants.inc.php"); $app_name = "phpJobScheduler"; $phpJobScheduler_version = "3.8"; // --------------------------------------------------------- if (DBNAME=="")//not configured { header("location: ../readme.html?noconfig=1"); exit; } if (!function_exists('clean_input')) // check to see if function is not already defined by another application { function clean_input($string) { $patterns[0] = "/'/"; $patterns[1] = "/\"/"; $string = preg_replace($patterns,'',$string); $string = trim($string); $string = stripslashes($string); return preg_replace("/[<>]/", '_', $string); } } function update_db() { db_connect(); if(mysql_num_rows(pjs_mysql_query("SHOW TABLES LIKE '".LOGS_TABLE."'"))==0) { $q_create_table = " CREATE TABLE ".LOGS_TABLE." ( id int(11) NOT NULL, script varchar(128) default NULL, output text default NULL, execution_time varchar(60) default NULL, PRIMARY KEY (id) )"; $result=pjs_mysql_query($q_create_table); } if(mysql_num_rows(pjs_mysql_query("SHOW TABLES LIKE '".PJS_TABLE."'"))==0) { $main_table="CREATE TABLE ".PJS_TABLE." ( id int(11) NOT NULL auto_increment, scriptpath varchar(255) default NULL, name varchar(128) default NULL, time_interval int(11) default NULL, fire_time int(11) NOT NULL default '0', time_last_fired int(11) default NULL, run_only_once tinyint(1) NOT NULL DEFAULT '0', currently_running BOOLEAN NOT NULL DEFAULT '0', PRIMARY KEY (id), KEY fire_time (fire_time))"; $result=pjs_mysql_query($main_table); } $result=pjs_mysql_query("SHOW COLUMNS FROM ".LOGS_TABLE." LIKE 'date_added' "); if (!mysql_num_rows($result)) $result=pjs_mysql_query("ALTER TABLE ".LOGS_TABLE." ADD date_added int AFTER id, CHANGE `id` `id` INT( 11 ) NOT NULL AUTO_INCREMENT "); } function pjs_mysql_query($q) { return mysql_query($q); if (mysql_error() AND DEBUG) echo "<hr>MySQL ERROR: ".mysql_error()."<hr>"; } function time_unit($time_interval) { global $app_name; $unit = array(0, 'type'); //check if its minutes if ($time_interval <= (59 * 60)) { $unit[0]=$time_interval/60; $unit[1]="<font color=\"#000000\">minute(s)</font>"; } //check if its hours if ( ($time_interval > (59 * 60)) AND ($time_interval<= (23 * 3600)) ) { $unit[0]=$time_interval/3600; $unit[1]="<font color=\"#ff0000\">hour(s)</font>"; } // check if its days if ( ($time_interval > (23 * 3600)) AND ($time_interval <= (6 * 86400)) ) { $unit[0]=$time_interval/86400; $unit[1]="<font color=\"#FF8000\">day(s)</font>"; } if ($time_interval >(6 * 86400)) { $unit[0]=$time_interval/604800; $unit[1]="<font color=\"#C00000\">week(s)</font>"; } $thedomain = $_SERVER['HTTP_HOST']; return $unit; } function db_connect() { @$db_link = mysql_connect(DBHOST, DBUSER, DBPASS); if ($db_link) @mysql_select_db(DBNAME); if (mysql_error() AND DEBUG) echo "<hr>MySQL ERROR: ".mysql_error()."<hr>"; if (mysql_error()) exit(); return $db_link; } function db_close() { global $db_link; if ($db_link) $result = mysql_close($db_link); } function js_msg($msg) { echo "<script><!--\n alert(\"$msg\");\n// --></script>"; } function show_jobs() { db_connect(); $query="select * from ".PJS_TABLE; $result = pjs_mysql_query($query); if (mysql_num_rows($result)) // check has got some { $i = 0; $table_rows=""; $bg_colour="#FFFFFF"; while ($i < mysql_num_rows($result)) { $id=mysql_result($result,$i, 'id'); $scriptpath=mysql_result($result,$i, 'scriptpath'); $name=mysql_result($result,$i, 'name'); $time_interval=mysql_result($result,$i, 'time_interval'); $fire_time=mysql_result($result,$i, 'fire_time'); $time_last_fired=mysql_result($result,$i, 'time_last_fired'); $run_only_once_txt= (mysql_result($result,$i, 'run_only_once'))? "<i><font color=\"#ff0000\"> Will run just once</font></i>":""; $time_interval = time_unit($time_interval); 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"; $table_rows.=" <tr align=\"center\"> <th align=\"left\" bgcolor=\"$bg_colour\"> <div id=\"pjs$id\"> <font color=\"#008000\">"$name"</font> - <a href=\"javascript:modify($id);\">MODIFY</a> - <a href=\"javascript:deletepjs('".PJS_TABLE."',$id,'$name');\">DELETE?</a> $run_only_once_txt<br> <small>Script path: <font color=\"#000000\">$scriptpath</font></small> </div> </th> <th align=\"center\" bgcolor=\"$bg_colour\"> <div id=\"pjs$id\"> $last_fire_hours $last_fire_date </div> </th> <th align=\"center\" bgcolor=\"$bg_colour\"> <div id=\"pjs$id\"> $fire_hours on<br> $fire_date </div> </th> <th align=\"center\" bgcolor=\"$bg_colour\"> <div id=\"pjs$id\"> $time_interval[0] $time_interval[1] </div> </th> </tr>"; $i++; } } 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>"; db_close(); echo $table_rows; } function show_logs($qstart) { db_connect(); $num=20;// logs to display $next_logs=$num+$qstart; $query="select * from ".LOGS_TABLE." ORDER BY id DESC LIMIT $qstart, $num"; $result = pjs_mysql_query($query); if (mysql_num_rows($result)) // check has got some { $i = 0; $table_rows=""; $bg_colour="#FFFFFF"; while ($i < mysql_num_rows($result)) { $id=mysql_result($result,$i, 'id'); $date_added=mysql_result($result,$i, 'date_added'); $script=mysql_result($result,$i, 'script'); $output= mysql_result($result,$i, 'output') ; $output_decoded=html_entity_decode($output); $execution_time= mysql_result($result,$i,'execution_time'); $log_date=strftime("Date: %d %b %Y Time: %H:%M:%S",$date_added); if ($bg_colour=="#E9E9E9") $bg_colour="#FFFFFF"; else $bg_colour="#E9E9E9"; if ($output!="") $show_hide="<a href=\"javascript:show_hide('$id');\">Show/Hide</a>"; else $show_hide="NO data"; $table_rows.=" <tr align=\"center\"> <th align=\"left\" bgcolor=\"$bg_colour\"> <div id=\"pjs$id\"> <small>Script: <font color=\"#000000\">$script</font> <br>Execution time: <font color=\"#000000\">$execution_time</font> Output: <font color=\"#FF8000\">*</font> $show_hide <div id=\"$id\" style=\"display:none;background-color:#FFE6E6;color:#FF0000\"> <blockquote>$output <br></blockquote> </div> </small></small> </div> </th> <th align=\"center\" bgcolor=\"$bg_colour\"> <small><div id=\"pjs$id\">$log_date <br> <a href=\"javascript:deletepjs('".LOGS_TABLE."',$id,'$script');\">DELETE?</a> <br></small></div> </th> </tr>"; $i++; } $qend=$i+$qstart; db_close(); echo "$table_rows </table></center></div></form> <center><strong> Currently displaying most recent logs from $qstart to $qend<br></strong>"; $next_link="<strong><a href=\"error-logs.php?start=$next_logs\">Show Next $num logs >></a> </strong><br><br><br>"; if ($num==$i) echo $next_link; echo '<p align="center"><font color="#FF8000">* Maximum length of output will be <strong>'.MAX_ERROR_LOG_LENGTH.' characters</strong>. </font>To change this <a href="../readme.html#error_log">please see the readme file</a><br>'; } else echo "<b><center><font color=\"#FF0000\">NO logs.</font>"; } function fire_script($script,$id,$buffer_output=1) { if($buffer_output) ob_start(); $scriptRunning = new scriptStatus; $scriptRunning->script=$script; if ($scriptRunning->Running($id) ) { $start_time = microtime(true); $fire_type = (function_exists('curl_exec') ) ? " PHP CURL " : " PHP fsockopen "; // "://" satisfies both cases http:// and https:// if (strstr($script,"://") ) fire_remote_script($script); else { include(LOCATION.$script); $fire_type=" PHP include "; } if($buffer_output) $scriptRunning->output=ob_get_contents(); else $scriptRunning->output=""; $scriptRunning->execution_time=number_format( (microtime(true) - $start_time), 5 )." seconds via".$fire_type; $scriptRunning->Stopped($id); } if($buffer_output) ob_end_clean(); } class scriptStatus { public $script; public $output; public $executionTime; public function Running($id) { $result=pjs_mysql_query("UPDATE ".PJS_TABLE." SET currently_running='1' where id='$id' "); register_shutdown_function('Clear', $id);// registed incase execution times out before Stopped called return $result; } public function Stopped($id) { $result=pjs_mysql_query("UPDATE ".PJS_TABLE." SET currently_running='0' where id='$id' "); if (ERROR_LOG) //save log to db { $now = time(); $this->script=clean_input($this->script); $this->output=substr(htmlentities($this->output), 0, MAX_ERROR_LOG_LENGTH);// truncate output to defined length $query="INSERT INTO ".LOGS_TABLE." (`id`, `date_added`,`script`, `output`, `execution_time`) VALUES (null,'$now', '$this->script','$this->output','$this->execution_time') "; pjs_mysql_query($query); //echo $query; } } } function fire_remote_script($url) { $url_parsed = parse_url($url); $scheme = $url_parsed["scheme"]; $host = $url_parsed["host"]; $port = isset($url_parsed["port"]) ? $url_parsed["port"] : 80; $path = isset($url_parsed["path"]) ? $url_parsed["path"] : "/"; $query = isset($url_parsed["query"]) ? $url_parsed["query"] : ""; $user = isset($url_parsed["user"]) ? $url_parsed["user"] : ""; $pass = isset($url_parsed["pass"]) ? $url_parsed["pass"] : ""; $useragent="phpJobScheduler (http://www.dwalker.co.uk/phpjobscheduler/)"; $referer=$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF']; $buffer=""; if (function_exists('curl_exec')) { $ch = curl_init($scheme."://".$host.$path); curl_setopt($ch, CURLOPT_PORT, $port); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_HEADER, 0); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER,false); curl_setopt($ch, CURLOPT_FAILONERROR,1); // true to fail silently curl_setopt($ch, CURLOPT_AUTOREFERER,1); curl_setopt($ch, CURLOPT_POSTFIELDS,$query); curl_setopt($ch, CURLOPT_REFERER,$referer); curl_setopt($ch, CURLOPT_USERAGENT,$useragent); curl_setopt($ch, CURLOPT_USERPWD,$user.":".$pass); $buffer = curl_exec($ch); curl_close($ch); } elseif ( $fp = @fsockopen($host, $port, $errno, $errstr, 30) ) { $header = "POST $path HTTP/1.0\r\nHost: $host\r\nReferer: $referer\r\n" ."Content-Type: application/x-www-form-urlencoded\r\n" ."User-Agent: $useragent\r\n" ."Content-Length: ". strlen($query)."\r\n"; if($user!= "") $header.= "Authorization: Basic ".base64_encode("$user:$pass")."\r\n"; $header.= "Connection: close\r\n\r\n"; fputs($fp, $header); fputs($fp, $query); if ($fp) while (!feof($fp)) $buffer.= fgets($fp, 8192); @fclose($fp); } echo $buffer; } function version_check() { global $phpJobScheduler_version; $version_url="HTTP://www.dwalker.co.uk/versions/"; echo '<script src="'.$version_url.'" type="text/javascript"></script> <script language="JavaScript"><!-- var phpJobScheduler_version = "'.$phpJobScheduler_version.'"; var version_txt=phpJobScheduler_version; if (LATEST_phpJobScheduler_version==phpJobScheduler_version) { version_txt=version_txt+"<br><font color=#008000>which is the most recent version.</font>"; } else { version_txt=version_txt+"<br><b><font color=#FF0000>UPGRADE REQUIRED"; version_txt=version_txt+"<br>Please <a href=http://www.phpJobScheduler.co.uk/>visit here</a> "; version_txt=version_txt+"to download the latest version </b>"; } document.write(version_txt); // --></script>'; } function Clear($id) { db_connect(); //If things go wrong, or script timeout CLEAR script so will run next time $result=pjs_mysql_query("UPDATE ".PJS_TABLE." SET currently_running = '0' where id='$id' "); db_close(); }