<commit_before><?php
/**
 *                    Jojo CMS
 *                ================
 *
 * Copyright 2007-2008 <NAME> <<EMAIL>>
 * Copyright 2007-2008 <NAME> <<EMAIL>>
 * Copyright 2007 <NAME> <<EMAIL>>
 *
 * See the enclosed file license.txt for license information (LGPL). If you
 * did not receive this file, see http://www.fsf.org/copyleft/lgpl.html.
 *
 * @author  <NAME> <<EMAIL>>
 * @author  <NAME> <<EMAIL>>
 * @license http://www.fsf.org/copyleft/lgpl.html GNU Lesser General Public License
 * @link    http://www.jojocms.org JojoCMS
 */

/* add newsletter subscription page */
$data = Jojo::selectQuery("SELECT pageid FROM {page} WHERE pg_link='Jojo_Plugin_Jojo_Newsletter_Subscribe'");
if (!count($data)) {
    echo "Adding <b>Subscribe to a Newsletter</b> Page to menu<br />";
    Jojo::insertQuery("INSERT INTO {page} SET pg_title='Subscribe to a Newsletter', pg_link='Jojo_Plugin_Jojo_Newsletter_Subscribe', pg_url='subscribe'");
}

/* add newsletter unsubscribe page */
$data = Jojo::selectQuery("SELECT pageid FROM {page} WHERE pg_link='Jojo_Plugin_Jojo_Newsletter_Unsubscribe'");
if (!count($data)) {
    echo "Adding <b>Unsubscribe From Newsletter</b> Page to menu<br />";
    Jojo::insertQuery("INSERT INTO {page} SET pg_title='Unsubscribe From Newsletter', pg_link='Jojo_Plugin_Jojo_Newsletter_Unsubscribe', pg_url='unsubscribe'");
}

/* Add Edit Newsletter Page */
$data = Jojo::selectRow("SELECT pageid FROM {page} WHERE pg_url='admin/newsletters'");
if (!$data) {
    echo "Adding <b>Newsletters</b> Page to Admin menu<br />";
    $_ADMIN_NEWSLETTER_ID = Jojo::insertQuery("INSERT INTO {page} SET pg_title='Edit Newsletters', pg_link='', pg_url='admin/newsletters', pg_parent = ?, pg_order = 2", array($_ADMIN_ROOT_ID));
} else {
    $_ADMIN_NEWSLETTER_ID = $data['pageid'];
}

/* Add Edit Newsletter Page */
$data = Jojo::selectQuery("SELECT pageid FROM {page} WHERE pg_url='admin/edit/newsletter'");
if (!count($data)) {
    echo "Adding <b>Edit Newsletters</b> Page to menu<br />";
    Jojo::insertQuery("INSERT INTO {page} SET pg_title='Newsletters', pg_link='jojo_plugin_admin_edit', pg_url='admin/edit/newsletter', pg_parent = ?", $_ADMIN_NEWSLETTER_ID);
}

/* Add Edit Newsletter Page */
$data = Jojo::selectQuery("SELECT pageid FROM {page} WHERE pg_url='admin/edit/newslettersuser'");
if (!count($data)) {
    echo "Adding <b>Edit Newsletter Users</b> Page to menu<br />";
    Jojo::insertQuery("INSERT INTO {page} SET pg_title='Edit Newsletter Users', pg_link='jojo_plugin_admin_edit', pg_url='admin/edit/newslettersuser', pg_parent = ?", $_ADMIN_NEWSLETTER_ID);
}

/* Add Edit Newsletter Groups Page */
$data = Jojo::selectQuery("SELECT pageid FROM {page} WHERE pg_url='admin/edit/phplist_list'");
if (!count($data)) {
    echo "Adding <b>Edit Newsletter Groups</b> Page to menu<br />";
    Jojo::insertQuery("INSERT INTO {page} SET pg_title='Edit Newsletter Groups', pg_link='jojo_plugin_admin_edit', pg_url='admin/edit/phplist_list', pg_parent = ?", $_ADMIN_NEWSLETTER_ID);
}

/* add newsletter statistics page */
$data = Jojo::selectQuery("SELECT pageid FROM {page} WHERE pg_url='admin/newsletterstats'");
if (!count($data)) {
    echo "Adding <b>Newsletter Statistics</b> Page to Admin menu<br />";;
    Jojo::insertQuery("INSERT INTO {page} SET pg_title='Newsletter Statistics', pg_link='jojo_plugin_jojo_admin_newsletter_stats', pg_url='admin/newsletterstats', pg_parent=?, pg_status='active', pg_order='4'", $_ADMIN_NEWSLETTER_ID);
}

/* add more newsletter statistics page */
$data = Jojo::selectQuery("SELECT pageid FROM {page} WHERE pg_url='admin/more-newsletter-stats'");
if (!count($data)) {
    echo "Adding <b>More Newsletter Statistics</b> Page to Admin menu<br />";
    Jojo::insertQuery("INSERT INTO {page} SET pg_title='More Newsletter Statistics', pg_link='jojo_plugin_jojo_admin_newsletter_statistics', pg_url='admin/more-newsletter-stats', pg_status='active', pg_order='4',pg_parent=?", $_ADMIN_NEWSLETTER_ID);
}<commit_msg>newsletter pages were appearing in xml sitemap.<commit_after><?php
/**
 *                    Jojo CMS
 *                ================
 *
 * Copyright 2007-2008 <NAME> <<EMAIL>>
 * Copyright 2007-2008 <NAME> <<EMAIL>>
 * Copyright 2007 <NAME> <<EMAIL>>
 *
 * See the enclosed file license.txt for license information (LGPL). If you
 * did not receive this file, see http://www.fsf.org/copyleft/lgpl.html.
 *
 * @author  <NAME> <<EMAIL>>
 * @author  <NAME> <<EMAIL>>
 * @license http://www.fsf.org/copyleft/lgpl.html GNU Lesser General Public License
 * @link    http://www.jojocms.org JojoCMS
 */

/* add newsletter subscription page */
$data = Jojo::selectQuery("SELECT pageid FROM {page} WHERE pg_link='Jojo_Plugin_Jojo_Newsletter_Subscribe'");
if (!count($data)) {
    echo "Adding <b>Subscribe to a Newsletter</b> Page to menu<br />";
    Jojo::insertQuery("INSERT INTO {page} SET pg_title='Subscribe to a Newsletter', pg_link='Jojo_Plugin_Jojo_Newsletter_Subscribe', pg_url='subscribe'");
}

/* add newsletter unsubscribe page */
$data = Jojo::selectQuery("SELECT pageid FROM {page} WHERE pg_link='Jojo_Plugin_Jojo_Newsletter_Unsubscribe'");
if (!count($data)) {
    echo "Adding <b>Unsubscribe From Newsletter</b> Page to menu<br />";
    Jojo::insertQuery("INSERT INTO {page} SET pg_title='Unsubscribe From Newsletter', pg_link='Jojo_Plugin_Jojo_Newsletter_Unsubscribe', pg_url='unsubscribe'");
}

/* Add Edit Newsletter Page */
$data = Jojo::selectRow("SELECT pageid FROM {page} WHERE pg_url='admin/newsletters'");
if (!$data) {
    echo "Adding <b>Newsletters</b> Page to Admin menu<br />";
    $_ADMIN_NEWSLETTER_ID = Jojo::insertQuery("INSERT INTO {page} SET pg_title='Edit Newsletters', pg_link='', pg_url='admin/newsletters', pg_parent = ?, pg_order = 2, pg_breadcrumbnav='no', pg_footernav='no', pg_sitemapnav='no', pg_xmlsitemapnav='no'", array($_ADMIN_ROOT_ID));
} else {
    $_ADMIN_NEWSLETTER_ID = $data['pageid'];
}

/* Add Edit Newsletter Page */
$data = Jojo::selectQuery("SELECT pageid FROM {page} WHERE pg_url='admin/edit/newsletter'");
if (!count($data)) {
    echo "Adding <b>Edit Newsletters</b> Page to menu<br />";
    Jojo::insertQuery("INSERT INTO {page} SET pg_title='Newsletters', pg_link='jojo_plugin_admin_edit', pg_url='admin/edit/newsletter', pg_parent = ?", $_ADMIN_NEWSLETTER_ID);
}

/* Add Edit Newsletter Page */
$data = Jojo::selectQuery("SELECT pageid FROM {page} WHERE pg_url='admin/edit/newslettersuser'");
if (!count($data)) {
    echo "Adding <b>Edit Newsletter Users</b> Page to menu<br />";
    Jojo::insertQuery("INSERT INTO {page} SET pg_title='Edit Newsletter Users', pg_link='jojo_plugin_admin_edit', pg_url='admin/edit/newslettersuser', pg_parent = ?", $_ADMIN_NEWSLETTER_ID);
}

/* Add Edit Newsletter Groups Page */
$data = Jojo::selectQuery("SELECT pageid FROM {page} WHERE pg_url='admin/edit/phplist_list'");
if (!count($data)) {
    echo "Adding <b>Edit Newsletter Groups</b> Page to menu<br />";
    Jojo::insertQuery("INSERT INTO {page} SET pg_title='Edit Newsletter Groups', pg_link='jojo_plugin_admin_edit', pg_url='admin/edit/phplist_list', pg_parent = ?", $_ADMIN_NEWSLETTER_ID);
}

/* add newsletter statistics page */
$data = Jojo::selectQuery("SELECT pageid FROM {page} WHERE pg_url='admin/newsletterstats'");
if (!count($data)) {
    echo "Adding <b>Newsletter Statistics</b> Page to Admin menu<br />";;
    Jojo::insertQuery("INSERT INTO {page} SET pg_title='Newsletter Statistics', pg_link='jojo_plugin_jojo_admin_newsletter_stats', pg_url='admin/newsletterstats', pg_parent=?, pg_status='active', pg_order='4', pg_breadcrumbnav='no', pg_footernav='no', pg_sitemapnav='no', pg_xmlsitemapnav='no'", $_ADMIN_NEWSLETTER_ID);
}

/* add more newsletter statistics page */
$data = Jojo::selectQuery("SELECT pageid FROM {page} WHERE pg_url='admin/more-newsletter-stats'");
if (!count($data)) {
    echo "Adding <b>More Newsletter Statistics</b> Page to Admin menu<br />";
    Jojo::insertQuery("INSERT INTO {page} SET pg_title='More Newsletter Statistics', pg_link='jojo_plugin_jojo_admin_newsletter_statistics', pg_url='admin/more-newsletter-stats', pg_status='active', pg_order='4',pg_parent=?, pg_breadcrumbnav='no', pg_footernav='no', pg_sitemapnav='no', pg_xmlsitemapnav='no'", $_ADMIN_NEWSLETTER_ID);
}
{'fraction_non_alphanumeric': 0.16143877921763353, 'fraction_numerical': 0.005571030640668524, 'mean_word_length': 5.824793388429752, 'pattern_counts': {'":': 0, '<': 83, '<?xml version=': 0, '>': 81, 'https://': 0, 'lorem ipsum': 0, 'www.': 6, 'xml': 4}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2785255', 'n_tokens_mistral': 2857, 'n_tokens_neox': 2754, 'n_words': 636}