php - Crontab file is corrupted after remove an job on list? -

-

im using database controlled cronjobs newsletter. crontab job add / remove functions works fine, when remove job on list main trigger file not work properly. here workbench;

task list table;

id   campaign_id    remove  date                      cron_command  1        1            0     2015-04-22 17:00:00       * * * * * curl -s http://example.com/tasks.php?id=1

main trigger file (cron.php) checking table, if date reach current date add cron_command crontab, works fine here. tasks.php file works fine , send "id1" campaign mails.

after campaign task done , mails sent successfully, above record updated to

id   campaign_id    remove  date                      cron_command  1        1            1     2015-04-22 17:00:00       * * * * * curl -s http://example.com/tasks.php?id=1

main trigger file check remove 1 marked commands , should have remove record both side (crontab / db table). not remove command on crontab , db table, main trigger file gives error "php command error: no input file specified", "curl command error: 400 bad request", "wget command: ambiguous redirect"

crontab manager class

class crontab {      // in class, array instead of string standard input / output format.      // legacy way add job:     // $output = shell_exec('(crontab -l; echo "'.$job.'") | crontab -');      static private function stringtoarray($jobs = '') {         $array = explode("\r\n", trim($jobs)); // trim() gets rid of last \r\n         foreach ($array $key => $item) {             if ($item == '') {                 unset($array[$key]);             }         }         return $array;     }      static private function arraytostring($jobs = array()) {         $string = implode("\r\n", $jobs);         return $string;     }      static public function getjobs() {         $output = shell_exec('crontab -l');         return self::stringtoarray($output);     }      static public function savejobs($jobs = array()) {         $output = shell_exec('echo "'.self::arraytostring($jobs).'" | crontab -');         return $output;      }      static public function doesjobexist($job = '') {         $jobs = self::getjobs();         if (in_array($job, $jobs)) {             return true;         } else {             return false;         }     }      static public function addjob($job = '') {         if (self::doesjobexist($job)) {             return false;         } else {             $jobs = self::getjobs();             $jobs[] = $job;             return self::savejobs($jobs);         }     }      static public function removejob($job = '') {         if (self::doesjobexist($job)) {             $jobs = self::getjobs();             unset($jobs[array_search($job, $jobs)]);             return self::savejobs($jobs);         } else {             return false;         }     }  }

main trigger file cron.php

/* task list modifier */ $modchr = new crontab(); $optasks = $myconn->query("select * tasks order remove desc") or die(mysqli_error($myconn)); while($optasksrs = $optasks->fetch_assoc()){     /* remove crons */     if($optasksrs['remove']==1){         if($modchr->removejob($optasksrs['cron_command'])){             $myconn->query("delete tasks id=". $optasksrs['id'] ."");         }else{             echo('command not executed');         }     }     /* add crons */     else{         if($optasksrs['date']<=date('y-m-d h:i:s')){             $modchr->addjob($optasksrs['cron_command']);         }     } } $optasks->free();

shortly issue; cron.php file not work after add new cron job via shell, when try run cron.php file via browser works fine. whats wrong?

regards.


Comments

Post a Comment

Popular posts from this blog

SQL php on different pages to Insert (mysqli) -

-
i have piece of php code, works when placed on index page ( index.php ), nothing if put in page, i.e. add.php for example: having code add.php page, tried go to: www.myhost.com/add.php , nothing happen. if copy code index.php , go page www.myhost.com/index.php add row in sql table. why that? <?php $server="mysql.server.com"; $user="randomusr"; $pass="randompwd"; $db="randomdb"; $link=mysqli_connect($server, $user, $pass, $db); $result=mysqli_query($link,"select * `battery` `id`"); $query = "insert battery (id,type,owner,charge,time) values ('1','lily002','maisnow','15','2015-04-22 17:20:28')"; mysqli_query($link, $query); header("location: index.php"); //this 1 comment out when copied index.php ?> l # name type collation attributes null 1 id int(16) no ...
Read more

php - How can an email be returned from Stripe Checkout? -

-
using stripe, want store customer email address email supplied in checkout. unfortunately, posting stripeemail in charge.php file returns null . how can return email checkout can use send receipt? here's form code: <script src="https://checkout.stripe.com/v2/checkout.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.js"></script> <form action="charge.php" method="post"> <input type="hidden" id="amount" name="chargeamount"/> <button data-charge-amount="300000" data-charge-name="name" data-charge-description="description">select pledge level</button> <button data-charge-amount="123123" data-charge-name="name2" data-charge-description="description2">donate</button> </form> <script> $('button').click(function(){ var token...
Read more

sql - Partition elimination in Greenplum -

-
i have scenario this: select * package package_type in ('box','card') the table partitioned package_type field. assume there twenty possible values package_type field. there twenty partitions including box , card , default partitions. when above query run, partition elimination happens correctly , box , card partitions scanned. result quick. however, when same query written this: select * package package_type in (select package_type package_list_table) , column package_type in package_list_table contains 2 values box , card . when above query run, 20 partitions being scanned. degrades performance. it seems compiler failing identify second query correctly , result partitions getting accessed. any workarounds overcome this? thanks in advance. the postgres manual page on partitioning includes caveat constraint exclusion works when query's clause contains constants (or externally supplied parameters). example, comparison agains...
Read more