public function execute()
 {
     require_once PATH_site . 'typo3conf/ext/additional_scheduler/Classes/Utils.php';
     require_once PATH_site . 'typo3conf/ext/additional_scheduler/Classes/Templating.php';
     // templating
     $template = new \Sng\Additionalscheduler\Templating();
     if (!empty($this->emailtemplate)) {
         $template->initTemplate($this->emailtemplate);
     } else {
         $template->initTemplate('typo3conf/ext/additional_scheduler/Resources/Private/Templates/execquery.html');
     }
     $markersArray = array();
     // exec query
     $res = $GLOBALS['TYPO3_DB']->sql_query($this->query);
     $return = '';
     if (preg_match('/SELECT.*?FROM/i', $this->query, $matches)) {
         $i = 0;
         $return .= '<table>';
         while ($item = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
             if ($i === 0) {
                 $return .= '<thead>';
                 $return .= '<tr>';
                 foreach ($item as $itemKey => $itemValue) {
                     $return .= '<th>' . $itemKey . '</th>';
                 }
                 $return .= '</tr>';
                 $return .= '</thead>';
                 $return .= '<tbody>';
             }
             $return .= '<tr>';
             foreach ($item as $itemKey => $itemValue) {
                 $return .= '<td>' . $itemValue . '</td>';
             }
             $return .= '</tr>';
             $i++;
         }
         $return .= '</tbody>';
         $return .= '</table>';
         $GLOBALS['TYPO3_DB']->sql_free_result($res);
     } else {
         $return .= 'SQL : ' . $this->query;
     }
     $markersArray['###MAIL_CONTENT###'] = $return;
     $mailcontent = $template->renderAllTemplate($markersArray, '###EMAIl_TEMPLATE###');
     preg_match('/<title\\>(.*?)<\\/title>/', $mailcontent, $matches);
     // mail
     $mailTo = $this->email;
     $mailSubject = '[additional_scheduler] : ' . $GLOBALS['LANG']->sL('LLL:EXT:additional_scheduler/Resources/Private/Language/locallang.xml:task.execquery.name');
     if (!empty($matches[1])) {
         $mailSubject = $matches[1];
     }
     if (empty($this->email) !== TRUE) {
         \Sng\Additionalscheduler\Utils::sendEmail($mailTo, $mailSubject, $mailcontent, 'html', $this->emailfrom, $this->emailfrom, 'utf-8');
     }
     return TRUE;
 }
 public function execute()
 {
     require_once PATH_site . 'typo3conf/ext/additional_scheduler/Classes/Utils.php';
     // exec SH
     $saveScript = PATH_site . 'typo3conf/ext/additional_scheduler/Resources/Shell/save_typo3_website.sh';
     $cmd = $saveScript . ' -p ' . PATH_site . ' -o ' . $this->path . ' -f';
     $return = shell_exec($cmd . ' 2>&1');
     // mail
     $mailTo = $this->email;
     $mailSubject = '[additional_scheduler] : ' . $GLOBALS['LANG']->sL('LLL:EXT:additional_scheduler/Resources/Private/Language/locallang.xml:task.savewebsite.name');
     $mailBody = $cmd . LF . LF . $return;
     if (empty($this->email) !== true) {
         \Sng\Additionalscheduler\Utils::sendEmail($mailTo, $mailSubject, $mailBody, 'plain', 'utf-8');
     }
     return true;
 }
 /**
  * Executes the commit task and returns TRUE if the execution was
  * succesfull
  *
  * @return    boolean    returns TRUE on success, FALSE on failure
  */
 public function execute()
 {
     require_once PATH_site . 'typo3conf/ext/additional_scheduler/Classes/Utils.php';
     // exec SH
     if (substr($this->path, 0, 1) == '/') {
         $cmd = $this->path;
     } else {
         $cmd = PATH_site . $this->path;
     }
     $return = shell_exec($cmd . ' 2>&1');
     // mail
     $mailTo = $this->email;
     $mailSubject = '[additional_scheduler] : ' . $GLOBALS['LANG']->sL('LLL:EXT:additional_scheduler/Resources/Private/Language/locallang.xml:task.exec.name');
     $mailBody = $cmd . LF . LF . $return;
     if (empty($this->email) !== TRUE) {
         \Sng\Additionalscheduler\Utils::sendEmail($mailTo, $mailSubject, $mailBody, 'plain', $this->emailfrom, $this->emailfrom, 'utf-8');
     }
     return TRUE;
 }
<?php

if (!defined('TYPO3_MODE')) {
    die('Access denied.');
}
$extensionPath = \TYPO3\CMS\Core\Utility\ExtensionManagementUtility::extPath('additional_scheduler');
require_once $extensionPath . 'Classes/Utils.php';
require_once $extensionPath . 'Classes/AdditionalFieldProviderInterface.php';
$tasks = \Sng\Additionalscheduler\Utils::getTasksList();
foreach ($tasks as $task) {
    require_once $extensionPath . 'Classes/Tasks/class.tx_additionalscheduler_' . $task . '.php';
    require_once $extensionPath . 'Classes/Tasks/class.tx_additionalscheduler_' . $task . '_fields.php';
}
foreach ($tasks as $task) {
    $GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['scheduler']['tasks']['tx_additionalscheduler_' . $task] = array('extension' => $_EXTKEY, 'title' => 'LLL:EXT:' . $_EXTKEY . '/Resources/Private/Language/locallang.xml:task.' . $task . '.name', 'description' => 'LLL:EXT:' . $_EXTKEY . '/Resources/Private/Language/locallang.xml:task.' . $task . '.description', 'additionalFields' => 'tx_additionalscheduler_' . $task . '_fields');
}
Example #5
0
 /**
  * Constructor
  */
 public function __construct()
 {
     if (\Sng\Additionalscheduler\Utils::intFromVer(TYPO3_version) < 6002000) {
         require_once PATH_t3lib . 'class.\\TYPO3\\CMS\\Core\\Html\\HtmlParser.php';
     }
 }