PHP seo42_utils::updateRedirectsFile Examples

Example #1

File: class.seo42_utils.inc.php Project: omphteliba/seo42

 public static function afterDBImport($params)
 {
     global $REX, $I18N;
     $sql = rex_sql::factory();
     $sql->setQuery('SELECT seo_title, seo_description, seo_keywords, seo_custom_url, seo_canonical_url, seo_noindex, seo_ignore_prefix FROM ' . $REX['TABLE_PREFIX'] . 'article');
     $sql2 = rex_sql::factory();
     $sql2->setQuery('SELECT create_date, expire_date FROM ' . $REX['TABLE_PREFIX'] . 'redirects');
     // check for db fields
     if ($sql->getError() != '' || $sql2->getError() != '') {
         require $REX['INCLUDE_PATH'] . '/addons/seo42/install.inc.php';
         echo rex_info($I18N->msg('seo42_dbfields_readded', $REX['ADDON']['name']['seo42']));
         echo rex_info($I18N->msg('seo42_dbfields_readded_check_setup', $REX['ADDON']['name']['seo42']));
     }
     seo42_utils::updateRedirectsFile(false);
 }

Example #2

File: redirects.inc.php Project: omphteliba/seo42

    $createDate = seo42_utils::getDate();
    $expireDate = seo42_utils::getDate($maxAge);
    if (!seo42_utils::redirectsDoExpire()) {
        $expireDate = 0;
    }
    $sql = rex_sql::factory();
    $sql->setDebug(true);
    $sql->setQuery('UPDATE `' . $REX['TABLE_PREFIX'] . 'redirects` SET create_date = "' . $createDate . '", expire_date = "' . $expireDate . '" WHERE id = ' . $redirectId);
    seo42_utils::updateRedirectsFile(false);
    // use exit statement, if you want to debug
    return true;
});
// delete redirect (after form submit)
rex_register_extension('REX_FORM_DELETED', function ($params) {
    global $REX;
    seo42_utils::updateRedirectsFile(false);
    // use exit statement, if you want to debug
    return true;
});
// output
echo '<div class="rex-addon-output-v2">';
if ($func == '') {
    // rex list
    $query = 'SELECT * FROM ' . $REX['TABLE_PREFIX'] . 'redirects ORDER BY id';
    $list = rex_list::factory($query, 9999);
    $list->setNoRowsMessage($I18N->msg('seo42_redirect_no_sytles_available'));
    $list->setCaption($I18N->msg('seo42_redirect_list_of_redirects'));
    $list->addTableAttribute('summary', $I18N->msg('seo42_redirect_list_of_redirects'));
    $list->setColumnLabel('id', $I18N->msg('seo42_redirect_id'));
    $list->setColumnLabel('source_url', $I18N->msg('seo42_redirect_source_url'));
    $list->setColumnLabel('target_url', $I18N->msg('seo42_redirect_target_url'));