function procEmailQueue()
{
//global $pref;
if (CRON_MAIL_DEBUG) {
$e107 = e107::getInstance();
$e107->admin_log->e_log_event(10, debug_backtrace(), 'DEBUG', 'CRON Email', 'Email run started', FALSE, LOG_TO_ROLLING);
}
require_once e_HANDLER . 'mail_manager_class.php';
$mailManager = new e107MailManager();
$mailManager->doEmailTask(varset($pref['mail_workpertick'], 5));
if (CRON_MAIL_DEBUG) {
$e107->admin_log->e_log_event(10, debug_backtrace(), 'DEBUG', 'CRON Email', 'Email run completed', FALSE, LOG_TO_ROLLING);
}
}
/**
* Constructor
*
*
* @return void
*/
public function __construct($mode = '')
{
parent::__construct();
$dbTable = '';
if (isset($this->tasks[$mode])) {
$dbTable = $this->tasks[$mode]['defaultTable'];
}
if (isset($_GET['frm'])) {
$temp = intval($_GET['frm']);
if ($temp < 0) {
$temp = 0;
}
$this->showFrom = $temp;
}
if (isset($_GET['count'])) {
$temp = min(intval($_GET['count']), 50);
// Limit to 50 per page
$temp = max($temp, 5);
// ...and minimum 5 per page
$this->showCount = $temp;
}
if (isset($_GET['fld'])) {
$temp = e107::getParser()->toDB($_GET['fld']);
if (is_array($this->fields[$dbTable][$temp])) {
$this->sortField = $temp;
}
}
if (isset($_GET['asc'])) {
$temp = strtolower(e107::getParser()->toDB($_GET['asc']));
if ($temp == 'asc' || $temp == 'desc') {
$this->sortOrder = $temp;
}
}
$this->newMode($mode);
}
/**
* Constructor
*
*
* @return void
*/
public function __construct($mode = '')
{
parent::__construct();
// require_once(e_HANDLER.'calendar/calendar_class.ph_');
// $this->_cal = new DHTML_Calendar(true);
$dbTable = '';
if (isset($this->tasks[$mode])) {
$dbTable = $this->tasks[$mode]['defaultTable'];
}
if (isset($_GET['frm'])) {
$temp = intval($_GET['frm']);
if ($temp < 0) {
$temp = 0;
}
$this->showFrom = $temp;
}
if (isset($_GET['count'])) {
$temp = min(intval($_GET['count']), 50);
// Limit to 50 per page
$temp = max($temp, 5);
// ...and minimum 5 per page
$this->showCount = $temp;
}
if (isset($_GET['fld'])) {
$temp = $this->e107->tp->toDB($_GET['fld']);
if (is_array($this->fields[$dbTable][$temp])) {
$this->sortField = $temp;
}
}
if (isset($_GET['asc'])) {
$temp = strtolower($this->e107->tp->toDB($_GET['asc']));
if ($temp == 'asc' || $temp == 'desc') {
$this->sortOrder = $temp;
}
}
$this->newMode($mode);
}
function update_706_to_800($type = '')
{
global $pref, $e107info;
global $sysprefs, $eArrayStorage;
//$mes = new messageLog; // Combined logging and message displaying handler
//$mes = e107::getMessage();
$log = e107::getAdminLog();
// Used for combined logging and message displaying
$sql = e107::getDb();
$sql2 = e107::getDb('sql2');
$tp = e107::getParser();
$ns = e107::getRender();
e107::getCache()->clearAll('db');
e107::getCache()->clearAll('system');
// List of unwanted $pref values which can go
$obs_prefs = array('frontpage_type', 'rss_feeds', 'log_lvcount', 'zone', 'upload_allowedfiletype', 'real', 'forum_user_customtitle', 'utf-compatmode', 'frontpage_method', 'standards_mode', 'image_owner', 'im_quality', 'signup_option_timezone', 'modules', 'plug_sc', 'plug_bb', 'plug_status', 'plug_latest', 'subnews_hide_news', 'upload_storagetype');
// List of DB tables not required (includes a few from 0.6xx)
$obs_tables = array('flood', 'headlines', 'stat_info', 'stat_counter', 'stat_last', 'session', 'preset', 'tinymce');
// List of DB tables newly required (defined in core_sql.php) (The existing dblog table gets renamed)
// No Longer required. - automatically checked against core_sql.php.
// $new_tables = array('audit_log', 'dblog', 'news_rewrite', 'core_media', 'core_media_cat','cron', 'mail_recipients', 'mail_content');
// List of core prefs that need to be converted from serialized to e107ArrayStorage.
$serialized_prefs = array("'emote'", "'menu_pref'", "'search_prefs'", "'emote_default'", "'pm_prefs'");
$create_dir = array(e_MEDIA, e_SYSTEM, e_CACHE, e_CACHE_CONTENT, e_CACHE_IMAGE, e_CACHE_DB, e_LOG, e_BACKUP, e_CACHE_URL, e_TEMP, e_IMPORT);
foreach ($create_dir as $dr) {
if (!is_dir($dr)) {
mkdir($dr, 0755);
}
}
// List of changed DB tables (defined in core_sql.php)
// No Longer required. - automatically checked against core_sql.php.
// (primarily those which have changed significantly; for the odd field write some explicit code - it'll run faster)
// $changed_tables = array('user', 'dblog', 'admin_log', 'userclass_classes', 'banlist', 'menus',
// 'plugin', 'news', 'news_category', 'online', 'page', 'links', 'comments');
// List of changed DB tables from core plugins (defined in pluginname_sql.php file)
// key = plugin directory name. Data = comma-separated list of tables to check
// (primarily those which have changed significantly; for the odd field write some explicit code - it'll run faster)
// No Longer required. - automatically checked by db-verify
/* $pluginChangedTables = array('linkwords' => 'linkwords',
'featurebox' => 'featurebox',
'links_page' => 'links_page',
'poll' => 'polls',
'content' => 'pcontent'
);
*/
/*
$setCorePrefs = array( //modified prefs during upgrade.
'adminstyle' => 'infopanel',
'admintheme' => 'bootstrap',
'admincss' => 'admin_style.css',
'resize_dimensions' => array(
'news-image' => array('w' => 250, 'h' => 250),
'news-bbcode' => array('w' => 250, 'h' => 250),
'page-bbcode' => array('w' => 250, 'h' => 250)
)
);
*/
$do_save = TRUE;
// List of changed menu locations.
$changeMenuPaths = array(array('oldpath' => 'siteinfo_menu', 'newpath' => 'siteinfo', 'menu' => 'sitebutton_menu'), array('oldpath' => 'siteinfo_menu', 'newpath' => 'siteinfo', 'menu' => 'compliance_menu'), array('oldpath' => 'siteinfo_menu', 'newpath' => 'siteinfo', 'menu' => 'powered_by_menu'), array('oldpath' => 'siteinfo_menu', 'newpath' => 'siteinfo', 'menu' => 'sitebutton_menu'), array('oldpath' => 'siteinfo_menu', 'newpath' => 'siteinfo', 'menu' => 'counter_menu'), array('oldpath' => 'siteinfo_menu', 'newpath' => 'siteinfo', 'menu' => 'latestnews_menu'), array('oldpath' => 'compliance_menu', 'newpath' => 'siteinfo', 'menu' => 'compliance_menu'), array('oldpath' => 'powered_by_menu', 'newpath' => 'siteinfo', 'menu' => 'powered_by_menu'), array('oldpath' => 'sitebutton_menu', 'newpath' => 'siteinfo', 'menu' => 'sitebutton_menu'), array('oldpath' => 'counter_menu', 'newpath' => 'siteinfo', 'menu' => 'counter_menu'), array('oldpath' => 'usertheme_menu', 'newpath' => 'user', 'menu' => 'usertheme_menu'), array('oldpath' => 'userlanguage_menu', 'newpath' => 'user', 'menu' => 'userlanguage_menu'), array('oldpath' => 'lastseen_menu', 'newpath' => 'online', 'menu' => 'lastseen_menu'), array('oldpath' => 'other_news_menu', 'newpath' => 'news', 'menu' => 'other_news_menu'), array('oldpath' => 'other_news_menu', 'newpath' => 'news', 'menu' => 'other_news2_menu'), array('oldpath' => 'user_menu', 'newpath' => 'user', 'menu' => 'usertheme_menu'), array('oldpath' => 'user_menu', 'newpath' => 'user', 'menu' => 'userlanguage_menu'), array('oldpath' => 'poll_menu', 'newpath' => 'poll', 'menu' => 'poll_menu'), array('oldpath' => 'banner_menu', 'newpath' => 'banner', 'menu' => 'banner_menu'), array('oldpath' => 'online_menu', 'newpath' => 'online', 'menu' => 'online_menu'));
// List of DB tables (key) and field (value) which need changing to accommodate IPV6 addresses
$ip_upgrade = array('download_requests' => 'download_request_ip', 'submitnews' => 'submitnews_ip', 'tmp' => 'tmp_ip', 'chatbox' => 'cb_ip');
$db_parser = new db_table_admin();
// Class to read table defs and process them
$do_save = FALSE;
// Set TRUE to update prefs when update complete
$updateMessages = array();
// Used to log actions for the admin log - TODO: will go once all converted to new class
$just_check = $type == 'do' ? FALSE : TRUE;
// TRUE if we're just seeing whether an update is needed
// if (!$just_check)
// {
// foreach(vartrue($setCorePrefs) as $k=>$v)
// {
// $pref[$k] = $v;
// }
// }
if (!$just_check) {
$log->logMessage(LAN_UPDATE_14 . $e107info['e107_version'], E_MESSAGE_NODISPLAY);
}
$statusTexts = array(E_MESSAGE_SUCCESS => 'Success', E_MESSAGE_ERROR => 'Fail', E_MESSAGE_INFO => 'Info');
if (isset($pref['forum_user_customtitle']) && !isset($pref['signup_option_customtitle'])) {
if ($just_check) {
return update_needed('pref: forum_user_customtitle needs to be renamed');
}
$pref['signup_option_customtitle'] = $pref['forum_user_customtitle'];
unset($pref['forum_user_customtitle']);
$log->logMessage(LAN_UPDATE_20 . 'customtitle', E_MESSAGE_SUCCESS);
$do_save = TRUE;
}
// convert all serialized core prefs to e107 ArrayStorage;
$serialz_qry = "SUBSTRING( e107_value,1,5)!='array' AND e107_value !='' ";
$serialz_qry .= "AND e107_name IN (" . implode(",", $serialized_prefs) . ") ";
if (e107::getDb()->select("core", "*", $serialz_qry)) {
if ($just_check) {
return update_needed('Convert serialized core prefs');
}
while ($row = e107::getDb()->fetch(MYSQL_ASSOC)) {
$status = e107::getDb('sql2')->update('core', "e107_value=\"" . convert_serialized($row['e107_value']) . "\" WHERE e107_name='" . $row['e107_name'] . "'") ? E_MESSAGE_SUCCESS : E_MESSAGE_ERROR;
$log->addDebug(LAN_UPDATE_22 . $row['e107_name'] . ": " . $status);
}
}
if (e107::getDb()->select("core", "*", "e107_name='pm_prefs' LIMIT 1")) {
if ($just_check) {
return update_needed('Rename the pm prefs');
}
e107::getDb()->update("core", "e107_name='plugin_pm' WHERE e107_name = 'pm_prefs'");
}
//@TODO de-serialize the user_prefs also.
// Banlist
if (!$sql->field('banlist', 'banlist_id')) {
if ($just_check) {
return update_needed('Banlist table requires updating.');
}
$sql->gen("ALTER TABLE #banlist DROP PRIMARY KEY");
$sql->gen("ALTER TABLE `#banlist` ADD `banlist_id` INT( 11 ) unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST");
}
// Move the maximum online counts from menu prefs to a separate pref - 'history'
e107::getCache()->clearAll('system');
$menuConfig = e107::getConfig('menu', true, true);
if ($menuConfig->get('most_members_online') || $menuConfig->get('most_guests_online') || $menuConfig->get('most_online_datestamp')) {
$status = E_MESSAGE_DEBUG;
if ($just_check) {
return update_needed('Move online counts from menupref');
}
$newPrefs = e107::getConfig('history');
foreach (array('most_members_online', 'most_guests_online', 'most_online_datestamp') as $v) {
if (FALSE === $newPrefs->get($v, FALSE)) {
if (FALSE !== $menuConfig->get($v, FALSE)) {
$newPrefs->set($v, $menuConfig->get($v));
} else {
$newPrefs->set($v, 0);
}
}
$menuConfig->remove($v);
}
$result = $newPrefs->save(false, true, false);
if ($result === TRUE) {
$resultMessage = 'Historic member counts updated';
$result = $menuConfig->save(false, true, false);
// Only re-save if successul.
} elseif ($result === FALSE) {
$resultMessage = 'moving historic member counts';
$status = E_MESSAGE_ERROR;
} else {
// No change
$resultMessage = 'Historic member counts already updated';
$status = E_MESSAGE_INFO;
}
// $result = $menuConfig->save(false, true, false); // Save updated menuprefs - without the counts - don't delete them if it fails.
//$updateMessages[] = $statusTexts[$status].': '.$resultMessage; // Admin log message
$log->logMessage($resultMessage, $status);
// User message
}
// ++++++++ Modify Menu Paths +++++++.
if (varset($changeMenuPaths)) {
foreach ($changeMenuPaths as $val) {
$qry = "SELECT menu_path FROM `#menus` WHERE menu_name = '" . $val['menu'] . "' AND (menu_path='" . $val['oldpath'] . "' || menu_path='" . $val['oldpath'] . "/' ) LIMIT 1";
if ($sql->gen($qry)) {
if ($just_check) {
return update_needed('Menu path changed required: ' . $val['menu'] . ' ');
}
$updqry = "menu_path='" . $val['newpath'] . "/' WHERE menu_name = '" . $val['menu'] . "' AND (menu_path='" . $val['oldpath'] . "' || menu_path='" . $val['oldpath'] . "/' ) ";
$status = $sql->update('menus', $updqry) ? E_MESSAGE_DEBUG : E_MESSAGE_ERROR;
$log->logMessage(LAN_UPDATE_23 . '<b>' . $val['menu'] . '</b> : ' . $val['oldpath'] . ' => ' . $val['newpath'], $status);
// LAN_UPDATE_25;
// catch_error($sql);
}
}
}
// Leave this one here.. just in case..
//delete record for online_extended_menu (now only using one online menu)
if ($sql->db_Select('menus', '*', "menu_path='online_extended_menu' || menu_path='online_extended_menu/'")) {
if ($just_check) {
return update_needed("The Menu table needs to have some paths corrected in its data.");
}
$row = $sql->db_Fetch();
//if online_extended is activated, we need to activate the new 'online' menu, and delete this record
if ($row['menu_location'] != 0) {
$status = $sql->update('menus', "menu_name='online_menu', menu_path='online/' WHERE menu_path='online_extended_menu' || menu_path='online_extended_menu/' ") ? E_MESSAGE_DEBUG : E_MESSAGE_ERROR;
$log->logMessage(LAN_UPDATE_23 . "<b>online_menu</b> : online/", $status);
} else {
//else if the menu is not active
//we need to delete the online_extended menu row, and change the online_menu to online
$sql->delete('menus', " menu_path='online_extended_menu' || menu_path='online_extended_menu/' ");
$log->logMessage(LAN_UPDATE_31, E_MESSAGE_DEBUG);
}
catch_error($sql);
}
//change menu_path for online_menu (if it still exists)
if ($sql->db_Select('menus', 'menu_path', "menu_path='online_menu' || menu_path='online_menu/'")) {
if ($just_check) {
return update_needed('change menu_path for online menu');
}
$status = $sql->update('menus', "menu_path='online/' WHERE menu_path='online_menu' || menu_path='online_menu/' ") ? E_MESSAGE_DEBUG : E_MESSAGE_ERROR;
$log->logMessage(LAN_UPDATE_23 . "<b>online_menu</b> : online/", $status);
catch_error($sql);
}
if (!$just_check) {
// Alert Admin to delete deprecated menu folders.
$chgPath = array();
foreach ($changeMenuPaths as $cgpArray) {
if (is_dir(e_PLUGIN . $cgpArray['oldpath'])) {
if (!in_array($cgpArray['oldpath'], $chgPath)) {
$chgPath[] = $cgpArray['oldpath'];
}
}
}
if (count($chgPath)) {
$log->addWarning(LAN_UPDATE_57 . ' ');
array_unique($chgPath);
asort($chgPath);
foreach ($chgPath as $cgp) {
$log->addWarning(e_PLUGIN_ABS . "<b>" . $cgp . "</b>");
}
}
}
//---------------------------------------------------------
// Comments - split user field
//---------------------------------------------------------
if ($sql->db_Field('comments', 'comment_author')) {
if ($just_check) {
return update_needed('Comment table author field update');
}
if (!$sql->db_Field('comments', 'comment_author_id') && !$sql->gen("ALTER TABLE `#comments`\r\n\t\t\t\tADD COLUMN comment_author_id int(10) unsigned NOT NULL default '0' AFTER `comment_author`,\r\n\t\t\t\tADD COLUMN comment_author_name varchar(100) NOT NULL default '' AFTER `comment_author_id`")) {
// Flag error
// $commentMessage = LAN_UPDAXXTE_34;
$log->logMessage(LAN_UPDATE_21 . "comments", E_MESSAGE_ERROR);
} else {
if (FALSE === $sql->update('comments', "comment_author_id=SUBSTRING_INDEX(`comment_author`,'.',1), comment_author_name=SUBSTRING(`comment_author` FROM POSITION('.' IN `comment_author`)+1)")) {
// Flag error
$log->logMessage(LAN_UPDATE_21 . 'comments', E_MESSAGE_ERROR);
} else {
// Delete superceded field - comment_author
if (!$sql->gen("ALTER TABLE `#comments` DROP COLUMN `comment_author`")) {
// Flag error
$log->logMessage(LAN_UPDATE_24 . 'comments - comment_author', E_MESSAGE_ERROR);
}
}
}
$log->logMessage(LAN_UPDATE_21 . 'comments', E_MESSAGE_DEBUG);
}
// Add index to download history
// Deprecated by db-verify-class
// if (FALSE !== ($temp = addIndexToTable('download_requests', 'download_request_datestamp', $just_check, $updateMessages)))
// {
// if ($just_check)
// {
// return update_needed($temp);
// }
// }
// Extra index to tmp table
// Deprecated by db-verify-class
// if (FALSE !== ($temp = addIndexToTable('tmp', 'tmp_time', $just_check, $updateMessages)))
// {
// if ($just_check)
// {
// return update_needed($temp);
// }
// }
// Extra index to rss table (if used)
// Deprecated by db-verify-class
// if (FALSE !== ($temp = addIndexToTable('rss', 'rss_name', $just_check, $updateMessages, TRUE)))
// {
// if ($just_check)
// {
// return update_needed($temp);
// }
// }
// Front page prefs (logic has changed)
if (!isset($pref['frontpage_force'])) {
if ($just_check) {
return update_needed('Change front page prefs');
}
$pref['frontpage_force'] = array(e_UC_PUBLIC => '');
$fpdef = vartrue($pref['frontpage']['all']) == 'index.php' ? 'index.php' : 'news.php';
$pref['frontpage'] = array(e_UC_PUBLIC => $fpdef);
// $_pdateMessages[] = LAN_UPDATE_38; //FIXME
$log->logMessage(LAN_UPDATE_20 . "frontpage", E_MESSAGE_DEBUG);
$do_save = TRUE;
}
// Check need for user timezone before we delete the field
if (vartrue($pref['signup_option_timezone'])) {
if ($sql->db_Field('user', 'user_timezone', '', TRUE) && !$sql->db_Field('user_extended', 'user_timezone', '', TRUE)) {
if ($just_check) {
return update_needed('Move user timezone info');
}
if (!copy_user_timezone()) {
// Error doing the transfer
//$updateMessages[] = LAN_UPDATE_42;
$log->logMessage(LAN_UPDATE_42, E_MESSAGE_ERROR);
return FALSE;
}
//$updateMessages[] = LAN_UPDATE_41;
$log->logMessage(LAN_UPDATE_41, E_MESSAGE_DEBUG);
}
}
// Tables defined in core_sql.php to be RENAMED.
// Next bit will be needed only by the brave souls who used an early CVS - probably delete before release
if ($sql->isTable('rl_history') && !$sql->isTable('dblog')) {
if ($just_check) {
return update_needed('Rename rl_history to dblog');
}
$sql->gen('ALTER TABLE `' . MPREFIX . 'rl_history` RENAME `' . MPREFIX . 'dblog`');
//$updateMessages[] = LAN_UPDATE_44;
$log->logMessage(LAN_UPDATE_44, E_MESSAGE_DEBUG);
catch_error($sql);
}
//---------------------------------
if ($sql->isTable('dblog') && !$sql->isTable('admin_log')) {
if ($just_check) {
return update_needed('Rename dblog to admin_log');
}
$sql->gen('ALTER TABLE `' . MPREFIX . 'dblog` RENAME `' . MPREFIX . 'admin_log`');
catch_error($sql);
//$updateMessages[] = LAN_UPDATE_43;
$log->logMessage(LAN_UPDATE_43, E_MESSAGE_DEBUG);
}
// New tables required (list at top. Definitions in core_sql.php)
// ALL DEPRECATED by db_verify class.. see below.
/*
foreach ($new_tables as $nt)
{
if (!$sql->isTable($nt))
{
if ($just_check) return update_needed('Add table: '.$nt);
// Get the definition
$defs = $db_parser->get_table_def($nt,e_ADMIN.'sql/core_sql.php');
if (count($defs)) // **** Add in table here
{
$status = $sql->gen('CREATE TABLE `'.MPREFIX.$defs[0][1].'` ('.$defs[0][2].') TYPE='.$defs[0][3]) ? E_MESSAGE_SUCCESS : E_MESSAGE_ERROR;
// $updateMessages[] = LAN_UPDATE_45.$defs[0][1];
$log->logMessage(LAN_UPDATE_27.$defs[0][1], $status);
// catch_error($sql);
}
else
{ // error parsing defs file
$log->logMessage(LAN_UPDATE_46.$defs[0][1], E_MESSAGE_ERROR);
}
unset($defs);
}
}
// Tables whose definition needs changing significantly
$debugLevel = E107_DBG_SQLDETAILS;
foreach ($changed_tables as $ct)
{
$req_defs = $db_parser->get_table_def($ct,e_ADMIN."sql/core_sql.php");
$req_fields = $db_parser->parse_field_defs($req_defs[0][2]); // Required definitions
if ($debugLevel)
{
$log->logMessage("Required table structure: <br />".$db_parser->make_field_list($req_fields), E_MESSAGE_DEBUG);
}
if ((($actual_defs = $db_parser->get_current_table($ct)) === FALSE) || !is_array($actual_defs)) // Adds current default prefix
{
$log->logMessage("Couldn't get table structure: ".$ct, E_MESSAGE_DEBUG);
}
else
{
// echo $db_parser->make_table_list($actual_defs);
$actual_fields = $db_parser->parse_field_defs($actual_defs[0][2]);
if ($debugLevel)
{
$log->logMessage("Actual table structure: <br />".$db_parser->make_field_list($actual_fields), E_MESSAGE_DEBUG);
}
$diffs = $db_parser->compare_field_lists($req_fields,$actual_fields);
if (count($diffs[0]))
{ // Changes needed
if ($just_check) return update_needed("Field changes rqd; table: ".$ct);
// Do the changes here
if ($debugLevel)
{
$log->logMessage("List of changes found:<br />".$db_parser->make_changes_list($diffs), E_MESSAGE_DEBUG);
}
$qry = 'ALTER TABLE '.MPREFIX.$ct.' '.implode(', ',$diffs[1]);
if ($debugLevel)
{
$log->logMessage("Update Query used: ".$qry, E_MESSAGE_DEBUG);
}
$status = $sql->gen($qry) ? E_MESSAGE_SUCCESS : E_MESSAGE_ERROR;
$log->logMessage(LAN_UPDATE_21.$ct, $status);
catch_error($sql);
}
}
}
// Plugin tables whose definition needs changing significantly
foreach ($pluginChangedTables as $plugName => $plugList)
{
if (e107::isInstalled($plugName))
{
$ttc = explode(',',$plugList);
foreach ($ttc as $ct)
{
$sqlDefs = e_PLUGIN.$plugName.'/'.str_replace('_menu','',$plugName).'_sql.php'; // Filename containing definitions
// echo "Looking at file: {$sqlDefs}, table {$ct}<br />";
$req_defs = $db_parser->get_table_def($ct,$sqlDefs);
if (!is_array($req_defs))
{
echo "Couldn't get definitions from file {$sqlDefs}<br />";
continue;
}
$req_fields = $db_parser->parse_field_defs($req_defs[0][2]); // Required definitions
if (E107_DBG_SQLDETAILS)
{
$message = "Required plugin table structure: <br />".$db_parser->make_field_list($req_fields);
$log->logMessage($message, E_MESSAGE_DEBUG);
}
if ((($actual_defs = $db_parser->get_current_table($ct)) === FALSE) || !is_array($actual_defs)) // Adds current default prefix
{
// echo "Couldn't get table structure: {$ct}<br />";
}
else
{
// echo $db_parser->make_table_list($actual_defs);
$actual_fields = $db_parser->parse_field_defs($actual_defs[0][2]);
if (E107_DBG_SQLDETAILS)
{
$message= "Actual table structure: <br />".$db_parser->make_field_list($actual_fields);
$log->logMessage($message, E_MESSAGE_DEBUG);
}
$diffs = $db_parser->compare_field_lists($req_fields,$actual_fields);
if (count($diffs[0]))
{ // Changes needed
if (E107_DBG_SQLDETAILS)
{
$message = "List of changes found:<br />".$db_parser->make_changes_list($diffs);
$log->logMessage($message, E_MESSAGE_DEBUG);
}
if ($just_check) return update_needed("Field changes rqd; plugin table: ".$ct);
// Do the changes here
$qry = 'ALTER TABLE '.MPREFIX.$ct.' '.implode(', ',$diffs[1]);
if (E107_DBG_SQLDETAILS)
{
$message = "Update Query used: ".$qry."<br />";
$log->logMessage($message, E_MESSAGE_DEBUG);
}
$sql->gen($qry);
$updateMessages[] = LAN_UPDATE_51.$ct;
$log->logMessage(LAN_UPDATE_51.$ct, E_MESSAGE_SUCCESS);
catch_error($sql);
}
}
}
}
}
*/
// Obsolete tables (list at top)
$sql->mySQLtableList = false;
// clear the cached table list.
foreach ($obs_tables as $ot) {
if ($sql->isTable($ot)) {
if ($just_check) {
return update_needed("Delete table: " . $ot);
}
$status = $sql->gen('DROP TABLE `' . MPREFIX . $ot . '`') ? E_MESSAGE_DEBUG : E_MESSAGE_ERROR;
$log->logMessage(LAN_UPDATE_25 . $ot, $status);
}
}
// Tables where IP address field needs updating to accommodate IPV6
// Set to varchar(45) - just in case something uses the IPV4 subnet (see http://en.wikipedia.org/wiki/IPV6#Notation)
foreach ($ip_upgrade as $t => $f) {
if ($sql->isTable($t)) {
// Check for table - might add some core plugin tables in here
if ($field_info = $sql->db_Field($t, $f, '', TRUE)) {
if (strtolower($field_info['Type']) != 'varchar(45)') {
if ($just_check) {
return update_needed('Update IP address field ' . $f . ' in table ' . $t);
}
$status = $sql->gen("ALTER TABLE `" . MPREFIX . $t . "` MODIFY `{$f}` VARCHAR(45) NOT NULL DEFAULT '';") ? E_MESSAGE_DEBUG : E_MESSAGE_ERROR;
$log->logMessage(LAN_UPDATE_26 . $t . ' - ' . $f, $status);
// catch_error($sql);
}
} else {
// Got a strange error here
}
}
}
// Obsolete prefs (list at top)
// Intentionally do this last - we may check some of them during the update
$accum = array();
foreach ($obs_prefs as $p) {
if (isset($pref[$p])) {
if ($just_check) {
return update_needed('Remove obsolete prefs');
}
unset($pref[$p]);
$do_save = TRUE;
$log->addDebug('Removed obsolete pref: ' . $p);
// $accum[] = $p;
}
}
/* -------------- Upgrade Entire Table Structure - Multi-Language Supported ----------------- */
// ONLY ever add fields, never deletes.
require_once e_HANDLER . "db_verify_class.php";
$dbv = new db_verify();
if ($plugUpgradeReq = e107::getPlugin()->updateRequired()) {
$exclude = array_keys($plugUpgradeReq);
// search xxxxx_setup.php and check for 'upgrade_required()' == true.
asort($exclude);
} else {
$exclude = false;
}
$dbv->compareAll($exclude);
// core & plugins, but not plugins calling for an update with xxxxx_setup.php
if (count($dbv->errors)) {
if ($just_check) {
$mes = e107::getMessage();
$log->addDebug(print_a($dbv->errors, true));
return update_needed("Database Tables require updating.");
}
$dbv->compileResults();
$dbv->runFix();
// Fix entire core database structure and plugins too.
}
// print_a($dbv->results);
// print_a($dbv->fixList);
//TODO - send notification messages to Log.
if ($sql->field('page', 'page_theme') && $sql->gen("SELECT * FROM `#page` WHERE page_theme != '' AND menu_title = '' LIMIT 1")) {
if ($just_check) {
return update_needed("Pages/Menus Table requires updating.");
}
if ($sql->update('page', "menu_name = page_theme, menu_title = page_title, menu_text = page_text, menu_template='default', page_title = '', page_text = '' WHERE page_theme !='' AND menu_title = '' AND menu_text = '' ")) {
$sql->gen("ALTER TABLE `#page` DROP page_theme ");
$mes = e107::getMessage();
$log->addDebug("Successfully updated pages/menus table to new format. ");
}
}
if ($sql->field('plugin', 'plugin_releaseUrl')) {
if ($just_check) {
return update_needed('plugin_releaseUrl is deprecated and needs to be removed. ');
}
if ($sql->gen("ALTER TABLE `#plugin` DROP `plugin_releaseUrl`")) {
$log->addDebug("Successfully removed plugin_releaseUrl. ");
}
}
// --- Notify Prefs
// $notify_prefs = $sysprefs -> get('notify_prefs');
// $notify_prefs = $eArrayStorage -> ReadArray($notify_prefs);
e107::getCache()->clearAll('system');
$notify_prefs = e107::getConfig('notify', true, true)->getPref();
$nt_changed = 0;
if (vartrue($notify_prefs['event'])) {
foreach ($notify_prefs['event'] as $e => $d) {
if (isset($d['type'])) {
if ($just_check) {
return update_needed('Notify pref: ' . $e . ' outdated');
}
switch ($d['type']) {
case 'main':
$notify_prefs['event'][$e]['class'] = e_UC_MAINADMIN;
break;
case 'class':
// Should already have class defined
break;
case 'email':
$notify_prefs['event'][$e]['class'] = 'email';
break;
case 'off':
// Need to disable
// Need to disable
default:
$notify_prefs['event'][$e]['class'] = e_UC_NOBODY;
// Just disable if we don't know what else to do
}
$nt_changed++;
$notify_prefs['event'][$e]['legacy'] = 1;
unset($notify_prefs['event'][$e]['type']);
}
}
}
if ($nt_changed) {
$s_prefs = $tp->toDB($notify_prefs);
$s_prefs = $eArrayStorage->WriteArray($s_prefs);
// Could we use $sysprefs->set($s_prefs,'notify_prefs') instead - avoids caching problems ????
$status = $sql->update("core", "e107_value='" . $s_prefs . "' WHERE e107_name='notify_prefs'") !== FALSE ? E_MESSAGE_DEBUG : E_MESSAGE_ERROR;
$message = str_replace('--COUNT--', $nt_changed, LAN_UPDATE_20);
$log->logMessage($message, $status);
}
// --------------- Saved emails - copy across
if (!$just_check && $sql->db_Select('generic', '*', "gen_type='massmail'")) {
if ($just_check) {
return update_needed('Copy across saved emails');
}
require_once e_HANDLER . 'mail_manager_class.php';
$mailHandler = new e107MailManager();
$i = 0;
while ($row = $sql->db_Fetch(MYSQL_ASSOC)) {
$mailRecord = array('mail_create_date' => $row['gen_datestamp'], 'mail_creator' => $row['gen_user_id'], 'mail_title' => $row['gen_ip'], 'mail_subject' => $row['gen_ip'], 'mail_body' => $row['gen_chardata'], 'mail_content_status' => MAIL_STATUS_SAVED);
$mailHandler->mailtoDb($mailRecord, TRUE);
$mailHandler->saveEmail($mailRecord, TRUE);
$sql2->delete('generic', 'gen_id=' . intval($row['gen_id']));
// Delete as we go in case operation fails part way through
$i++;
}
unset($mailHandler);
$log->logMessage(str_replace('--COUNT--', $i, LAN_UPDATE_28));
}
// ------------------- Populate Plugin Table With Changes ------------------
if (!isset($pref['shortcode_legacy_list'])) {
if ($just_check) {
return update_needed('Legacy shortcode conversion');
}
// Reset, legacy and new shortcode list will be generated in plugin update routine
$pref['shortcode_legacy_list'] = array();
$pref['shortcode_list'] = array();
save_prefs();
$ep = e107::getPlugin();
$ep->update_plugins_table($mode);
// scan for e_xxx changes and save to plugin table.
$ep->save_addon_prefs($mode);
// generate global e_xxx_list prefs from plugin table.
}
// This has to be done after the table is upgraded
if ($sql->select('plugin', 'plugin_category', "plugin_category = ''")) {
if ($just_check) {
return update_needed('Update plugin table');
}
require_once e_HANDLER . 'plugin_class.php';
$ep = new e107plugin();
$ep->update_plugins_table('update');
// $_pdateMessages[] = LAN_UPDATE_XX24;
// catch_error($sql);
}
//-- Media-manger import --------------------------------------------------
// Autogenerate filetypes.xml if not found.
if (!is_readable(e_SYSTEM . "filetypes.xml")) {
$data = '<?xml version="1.0" encoding="utf-8"?>
<e107Filetypes>
<class name="253" type="zip,gz,jpg,jpeg,png,gif,xml" maxupload="2M" />
</e107Filetypes>';
file_put_contents(e_SYSTEM . "filetypes.xml", $data);
}
$root_media = str_replace(basename(e_MEDIA) . "/", "", e_MEDIA);
$user_media_dirs = array("images", "avatars", "avatars/default", "avatars/upload", "files", "temp", "videos", "icons");
// check for old paths and rename.
if (is_dir($root_media . "images") || is_dir($root_media . "temp")) {
foreach ($user_media_dirs as $md) {
@rename($root_media . $md, e_MEDIA . $md);
}
}
// create sub-directories if they do not exist.
if (!is_dir(e_MEDIA . "images") || !is_dir(e_MEDIA . "temp") || !is_dir(e_AVATAR_UPLOAD) || !is_dir(e_AVATAR_DEFAULT)) {
foreach ($user_media_dirs as $md) {
if (!is_dir(e_MEDIA . $md)) {
mkdir(e_MEDIA . $md);
}
}
}
// Move Avatars to new location
$av1 = e107::getFile()->get_files(e_FILE . 'public/avatars', '.jpg|.gif|.png|.GIF|.jpeg|.JPG|.PNG');
$av2 = e107::getFile()->get_files(e_IMAGE . 'avatars', '.jpg|.gif|.png|.GIF|.jpeg|.JPG|.PNG');
$avatar_images = array_merge($av1, $av2);
if (count($avatar_images)) {
if ($just_check) {
return update_needed('Avatar paths require updating.');
}
foreach ($avatar_images as $av) {
$apath = strstr($av['path'], 'public/') ? e_AVATAR_UPLOAD : e_AVATAR_DEFAULT;
@rename($av['path'] . $av['fname'], $apath . $av['fname']);
}
}
// -------------------------------
if (!e107::isInstalled('download') && $sql->gen("SELECT * FROM #links WHERE link_url LIKE 'download.php%' AND link_class != '" . e_UC_NOBODY . "' LIMIT 1")) {
if ($just_check) {
return update_needed('Download Plugin needs to be installed.');
}
// e107::getSingleton('e107plugin')->install('download',array('nolinks'=>true));
e107::getSingleton('e107plugin')->refresh('download');
}
if (!e107::isInstalled('banner') && $sql->isTable('banner')) {
if ($just_check) {
return update_needed('Banner Table found, but plugin not installed. Needs to be refreshed.');
}
e107::getSingleton('e107plugin')->refresh('banner');
}
// ---------------------------------
$med = e107::getMedia();
// Media Category Update
if ($sql->db_Field("core_media_cat", "media_cat_nick")) {
$count = $sql->gen("SELECT * FROM `#core_media_cat` WHERE media_cat_nick = '_common' ");
if ($count == 1) {
if ($just_check) {
return update_needed('Media-Manager Categories needs to be updated.');
}
$sql->update('core_media_cat', "media_cat_owner = media_cat_nick, media_cat_category = media_cat_nick WHERE media_cat_nick REGEXP '_common|news|page|_icon_16|_icon_32|_icon_48|_icon_64' ");
$sql->update('core_media_cat', "media_cat_owner = '_icon', media_cat_category = media_cat_nick WHERE media_cat_nick REGEXP '_icon_16|_icon_32|_icon_48|_icon_64' ");
$sql->update('core_media_cat', "media_cat_owner = 'download', media_cat_category='download_image' WHERE media_cat_nick = 'download' ");
$sql->update('core_media_cat', "media_cat_owner = 'download', media_cat_category='download_thumb' WHERE media_cat_nick = 'downloadthumb' ");
$sql->update('core_media_cat', "media_cat_owner = 'news', media_cat_category='news_thumb' WHERE media_cat_nick = 'newsthumb' ");
$log->addDebug("core-media-cat Categories and Ownership updated");
if ($sql->gen("ALTER TABLE `" . MPREFIX . "core_media_cat` DROP `media_cat_nick`")) {
$log->addDebug("core-media-cat `media_cat_nick` field removed.");
}
// $query = "INSERT INTO `".MPREFIX."core_media_cat` (`media_cat_id`, `media_cat_owner`, `media_cat_category`, `media_cat_title`, `media_cat_diz`, `media_cat_class`, `media_cat_image`, `media_cat_order`) VALUES
// (0, 'gallery', 'gallery_1', 'Gallery 1', 'Visible to the public at /gallery.php', 0, '', 0);
/// ";
//
// if(mysql_query($query))
// {
// $log->addDebug("Added core-media-cat Gallery.");
// }
}
}
// Media Update
$count = $sql->gen("SELECT * FROM `#core_media` WHERE media_category = 'newsthumb' OR media_category = 'downloadthumb' LIMIT 1 ");
if ($count == 1) {
if ($just_check) {
return update_needed('Media-Manager Data needs to be updated.');
}
$sql->update('core_media', "media_category='download_image' WHERE media_category = 'download' ");
$sql->update('core_media', "media_category='download_thumb' WHERE media_category = 'downloadthumb' ");
$sql->update('core_media', "media_category='news_thumb' WHERE media_category = 'newsthumb' ");
$log->addDebug("core-media Category names updated");
}
// Media Update - core media and core-file.
$count = $sql->gen("SELECT * FROM `#core_media` WHERE media_category = '_common' LIMIT 1 ");
if ($count == 1) {
if ($just_check) {
return update_needed('Media-Manager Category Data needs to be updated.');
}
$sql->update('core_media', "media_category='_common_image' WHERE media_category = '_common' ");
$log->addDebug("core-media _common Category updated");
}
// Media Update - core media and core-file. CATEGORY
$count = $sql->gen("SELECT * FROM `#core_media_cat` WHERE media_cat_category = '_common' LIMIT 1 ");
if ($count == 1) {
if ($just_check) {
return update_needed('Media-Manager Category Data needs to be updated.');
}
$sql->update('core_media_cat', "media_cat_category='_common_image' WHERE media_cat_category = '_common' ");
$sql->gen("INSERT INTO `" . MPREFIX . "core_media_cat` VALUES(0, '_common', '_common_file', '(Common Area)', 'Media in this category will be available in all areas of admin. ', 253, '', 0);");
$sql->gen("INSERT INTO `" . MPREFIX . "core_media_cat` VALUES(0, 'download', 'download_file', 'Download Files', '', 253, '', 0);");
$log->addDebug("core-media-cat _common Category updated");
}
$count = $sql->gen("SELECT * FROM `#core_media_cat` WHERE `media_cat_owner` = '_common' LIMIT 1 ");
if ($count != 1) {
if ($just_check) {
return update_needed('Add Media-Manager Categories and Import existing images.');
}
$e107_core_media_cat = array(array('media_cat_id' => 0, 'media_cat_owner' => '_common', 'media_cat_category' => '_common_image', 'media_cat_title' => '(Common Images)', 'media_cat_sef' => '', 'media_cat_diz' => 'Media in this category will be available in all areas of admin.', 'media_cat_class' => '253', 'media_cat_image' => '', 'media_cat_order' => '0'), array('media_cat_id' => 0, 'media_cat_owner' => '_common', 'media_cat_category' => '_common_file', 'media_cat_title' => '(Common Files)', 'media_cat_sef' => '', 'media_cat_diz' => 'Media in this category will be available in all areas of admin.', 'media_cat_class' => '253', 'media_cat_image' => '', 'media_cat_order' => '0'), array('media_cat_id' => 0, 'media_cat_owner' => 'news', 'media_cat_category' => 'news', 'media_cat_title' => 'News', 'media_cat_sef' => '', 'media_cat_diz' => 'Will be available in the news area.', 'media_cat_class' => '253', 'media_cat_image' => '', 'media_cat_order' => '1'), array('media_cat_id' => 0, 'media_cat_owner' => 'page', 'media_cat_category' => 'page', 'media_cat_title' => 'Custom Pages', 'media_cat_sef' => '', 'media_cat_diz' => 'Will be available in the custom pages area of admin.', 'media_cat_class' => '253', 'media_cat_image' => '', 'media_cat_order' => '0'), array('media_cat_id' => 0, 'media_cat_owner' => 'download', 'media_cat_category' => 'download_image', 'media_cat_title' => 'Download Images', 'media_cat_sef' => '', 'media_cat_diz' => '', 'media_cat_class' => '253', 'media_cat_image' => '', 'media_cat_order' => '0'), array('media_cat_id' => 0, 'media_cat_owner' => 'download', 'media_cat_category' => 'download_thumb', 'media_cat_title' => 'Download Thumbnails', 'media_cat_sef' => '', 'media_cat_diz' => '', 'media_cat_class' => '253', 'media_cat_image' => '', 'media_cat_order' => '0'), array('media_cat_id' => 0, 'media_cat_owner' => 'download', 'media_cat_category' => 'download_file', 'media_cat_title' => 'Download Files', 'media_cat_sef' => '', 'media_cat_diz' => '', 'media_cat_class' => '253', 'media_cat_image' => '', 'media_cat_order' => '0'), array('media_cat_id' => 0, 'media_cat_owner' => 'news', 'media_cat_category' => 'news_thumb', 'media_cat_title' => 'News Thumbnails (Legacy)', 'media_cat_sef' => '', 'media_cat_diz' => 'Legacy news thumbnails.', 'media_cat_class' => '253', 'media_cat_image' => '', 'media_cat_order' => '1'));
foreach ($e107_core_media_cat as $insert) {
$sql->insert('core_media_cat', $insert);
}
// $sql->gen("INSERT INTO `".MPREFIX."core_media_cat` VALUES(0, '_common', '_common_image', '(Common Images)', '', 'Media in this category will be available in all areas of admin. ', 253, '', 1);");
// $sql->gen("INSERT INTO `".MPREFIX."core_media_cat` VALUES(0, '_common', '_common_file', '(Common Files)', '', 'Media in this category will be available in all areas of admin. ', 253, '', 2);");
// $sql->gen("INSERT INTO `".MPREFIX."core_media_cat` VALUES(0, 'news', 'news', 'News', '', 'Will be available in the news area. ', 253, '', 3);");
// $sql->gen("INSERT INTO `".MPREFIX."core_media_cat` VALUES(0, 'page', 'page', 'Custom Pages', '', 'Will be available in the custom pages area of admin. ', 253, '', 4);");
// $sql->gen("INSERT INTO `".MPREFIX."core_media_cat` VALUES(0, 'download', 'download_image','', 'Download Images', '', 253, '', 5);");
// $sql->gen("INSERT INTO `".MPREFIX."core_media_cat` VALUES(0, 'download', 'download_thumb', '', 'Download Thumbnails', '', 253, '', 6);");
// $sql->gen("INSERT INTO `".MPREFIX."core_media_cat` VALUES(0, 'download', 'download_file', '', 'Download Files', '', 253, '', 7);");
// mysql_query("INSERT INTO `".MPREFIX."core_media_cat` VALUES(0, 'gallery', 'gallery_1', 'Gallery', 'Visible to the public at /gallery.php', 0, '', 0);");
// $sql->gen("INSERT INTO `".MPREFIX."core_media_cat` VALUES(0, 'news', 'news_thumb', 'News Thumbnails (Legacy)', '', 'Legacy news thumbnails. ', 253, '', 8);");
$med->import('news_thumb', e_IMAGE . 'newspost_images', "^thumb_");
$med->import('news', e_IMAGE . 'newspost_images');
$med->import('page', e_IMAGE . 'custom');
} else {
// $log->addDebug("Media COUNT was ".$count. " LINE: ".__LINE__);
}
// Check for Legacy Download Images.
$fl = e107::getFile();
$dl_images = $fl->get_files(e_FILE . 'downloadimages');
if (count($dl_images) && !$sql->gen("SELECT * FROM `#core_media` WHERE `media_category` = 'download_image' ")) {
if ($just_check) {
return update_needed('Import Download Images into Media Manager');
}
$med->import('download_image', e_FILE . 'downloadimages');
$med->import('download_thumb', e_FILE . 'downloadthumbs');
}
$dl_files = $fl->get_files(e_FILE . 'downloads', "", "standard", 5);
// don't use e_DOWNLOAD or a loop may occur.
$publicFilter = array('_FT', '^thumbs\\.db$', '^Thumbs\\.db$', '.*\\._$', '^\\.htaccess$', '^\\.cvsignore$', '^\\.ftpquota$', '^index\\.html$', '^null\\.txt$', '\\.bak$', '^.tmp');
// Default file filter (regex format)
// $publicFilter = array(1);
$public_files = $fl->get_files(e_FILE . 'public', '', $publicFilter);
if ((count($dl_files) || count($public_files)) && !$sql->gen("SELECT * FROM `#core_media` WHERE `media_category` = 'download_file' ")) {
if ($just_check) {
return update_needed('Import ' . count($dl_files) . ' Download File(s) and ' . count($public_files) . ' Public File(s) into Media Manager');
}
if ($sql->gen("SELECT download_url FROM `#download` ")) {
$allowed_types = array();
while ($row = $sql->fetch()) {
$ext = strrchr($row['download_url'], ".");
$suffix = ltrim($ext, ".");
if (!isset($allowed_types[$suffix])) {
$allowed_types[$suffix] = $suffix;
}
}
$allowed_types = array_unique($allowed_types);
} else {
$allowed_types = array('zip', 'gz', 'pdf');
}
$fmask = '[a-zA-z0-9_-]+\\.(' . implode('|', $allowed_types) . ')$';
$med->import('download_file', e_DOWNLOAD, $fmask);
$med->import('_common_file', e_FILE . 'public', $fmask);
}
$count = $sql->gen("SELECT * FROM `#core_media_cat` WHERE media_cat_owner='_icon' ");
if (!$count) {
if ($just_check) {
return update_needed('Add icons to media-manager');
}
$query = "INSERT INTO `" . MPREFIX . "core_media_cat` (`media_cat_id`, `media_cat_owner`, `media_cat_category`, `media_cat_title`, `media_cat_diz`, `media_cat_class`, `media_cat_image`, `media_cat_order`) VALUES\r\n\t\t(0, '_icon', '_icon_16', 'Icons 16px', 'Available where icons are used in admin. ', 253, '', 0),\r\n\t\t(0, '_icon', '_icon_32', 'Icons 32px', 'Available where icons are used in admin. ', 253, '', 0),\r\n\t\t(0, '_icon', '_icon_48', 'Icons 48px', 'Available where icons are used in admin. ', 253, '', 0),\r\n\t\t(0, '_icon', '_icon_64', 'Icons 64px', 'Available where icons are used in admin. ', 253, '', 0);\r\n\t\t";
if (!$sql->gen($query)) {
// echo "mysyql error";
// error or already exists.
}
$med->importIcons(e_PLUGIN);
$med->importIcons(e_IMAGE . "icons/");
$med->importIcons(e_THEME . $pref['sitetheme'] . "/images/");
$log->addDebug("Icon category added");
}
// Search Clean up ----------------------------------
$searchPref = e107::getConfig('search');
if ($searchPref->getPref('core_handlers/news')) {
if ($just_check) {
return update_needed('Core search handlers need to be updated.');
}
$searchPref->removePref('core_handlers/news')->save(false, true, false);
}
if ($searchPref->getPref('core_handlers/downloads')) {
if ($just_check) {
return update_needed('Core search handlers need to be updated.');
}
$searchPref->removePref('core_handlers/downloads')->save(false, true, false);
}
if ($searchPref->getPref('core_handlers/pages')) {
if ($just_check) {
return update_needed('Core search handlers need to be updated.');
}
$searchPref->removePref('core_handlers/pages')->save(false, true, false);
e107::getSingleton('e107plugin')->refresh('page');
}
// Clean up news keywords. - remove spaces between commas.
if ($sql->select('news', 'news_id', "news_meta_keywords LIKE '%, %' LIMIT 1")) {
if ($just_check) {
return update_needed('News keywords contain spaces between commas and needs to be updated. ');
}
$sql->update('news', "news_meta_keywords = REPLACE(news_meta_keywords, ', ', ',')");
}
// Any other images should be imported manually via Media Manager batch-import.
// ------------------------------------------------------------------
// Check that custompages have been imported from current theme.php file
if (!$just_check) {
if (!is_array($pref['sitetheme_layouts']) || !vartrue($pref['sitetheme_deflayout'])) {
$th = e107::getSingleton('themeHandler');
$tmp = $th->getThemeInfo($pref['sitetheme']);
if ($th->setTheme($pref['sitetheme'], false)) {
$log->addDebug("Updated SiteTheme prefs");
} else {
$log->addDebug("Couldn't update SiteTheme prefs");
}
}
$log->toFile('upgrade_v1_to_v2');
if ($do_save) {
save_prefs();
$log->logMessage(LAN_UPDATE_50);
// $log->logMessage(implode(', ', $accum), E_MESSAGE_NODISPLAY);
//$updateMessages[] = LAN_UPDATE_50.implode(', ',$accum); // Note for admin log
}
$log->flushMessages('UPDATE_01');
// Write admin log entry, update message handler
} else {
$log->toFile('upgrade_v1_to_v2_check');
}
//FIXME grab message-stack from $log for the log.
//if ($just_check) return TRUE;
//e107::getLog()->add('UPDATE_01',LAN_UPDATE_14.$e107info['e107_version'].'[!br!]'.implode('[!br!]',$updateMessages),E_LOG_INFORMATIVE,''); // Log result of actual update
return $just_check;
}
/**
* Display Progress-bar of real-time mail-out.
* @return
*/
function sendProgress($id)
{
// return rand(92,100);
$pref = e107::getPref();
ob_start();
$perAjaxHit = e107::getConfig()->get('mail_pause', 1);
$mailManager = new e107MailManager();
$mailManager->doEmailTask($perAjaxHit);
$sqld = e107::getDb('progress');
$sqld->select("mail_content", "mail_total_count,mail_togo_count,mail_sent_count,mail_fail_count", "mail_source_id= " . intval($id));
$row = $sqld->fetch();
$rand = $row['mail_sent_count'] + $row['mail_fail_count'];
$total = $row['mail_total_count'];
$errors = ob_get_clean();
$errors .= " id=" . $id;
e107::getMessage()->addDebug($errors);
$inc = round($rand / $total * 100);
$errors .= " inc=" . $inc;
file_put_contents(e_LOG . 'send-mail-progress.txt', $errors);
e107::getMessage()->addDebug("Returned: " . $inc);
return $inc;
}
/**
* Send an email notification following an event.
*
* The email is sent via a common interface, which will send immediately for small numbers of recipients, and queue for larger.
*
* @param string $id - identifies event actions
* @param string $subject - subject for email
* @param string $message - email message body
* @return void
*
* @todo handle 'everyone except' clauses (email address filter done)
* @todo set up pref to not notify originator of event which caused notify (see $blockOriginator)
*/
function send($id, $subject, $message, $media = array())
{
$tp = e107::getParser();
$sql = e107::getDb();
$subject = $tp->toEmail($subject);
$message = $tp->replaceConstants($message, "full");
// $message = $tp->toEmail($message);
$emailFilter = '';
$notifyTarget = $this->notify_prefs['event'][$id]['class'];
if ($notifyTarget == '-email') {
$emailFilter = $this->notify_prefs['event'][$id]['email'];
}
$blockOriginator = FALSE;
// TODO: set this using a pref
$recipients = array();
if ($notifyTarget == 'email') {
if (!$blockOriginator || $this->notify_prefs['event'][$id]['email'] != USEREMAIL) {
$recipients[] = array('mail_recipient_email' => $this->notify_prefs['event'][$id]['email'], 'mail_target_info' => array('SUBJECT' => $subject, 'DATE_SHORT' => $tp->toDate(time(), 'short'), 'DATE_LONG' => $tp->toDate(time(), 'long')));
}
} elseif (is_numeric($notifyTarget)) {
switch ($notifyTarget) {
case e_UC_MAINADMIN:
$qry = "`user_admin` = 1 AND `user_perms` = '0' AND `user_ban` = 0";
break;
case e_UC_ADMIN:
$qry = "`user_admin` = 1 AND `user_ban` = 0";
break;
case e_UC_MEMBER:
$qry = "`user_ban` = 0";
break;
default:
$qry = "user_ban = 0 AND user_class REGEXP '(^|,)(" . $notifyTarget . ")(,|\$)'";
break;
}
$qry = 'SELECT user_id,user_name,user_email,user_join,user_lastvisit FROM `#user` WHERE ' . $qry;
if ($blockOriginator) {
$qry .= ' AND `user_id` != ' . USERID;
}
if (false !== ($count = $sql->gen($qry))) {
// Now add email addresses to the list
while ($row = $sql->fetch(MYSQL_ASSOC)) {
if ($row['user_email'] != $emailFilter) {
$unsubscribe = array('date' => $row['user_join'], 'email' => $row['user_email'], 'id' => $row['user_id'], 'plugin' => 'user', 'userclass' => $notifyTarget);
$urlQuery = http_build_query($unsubscribe, null, '&');
$exclude = array(e_UC_MEMBER, e_UC_ADMIN, e_UC_MAINADMIN);
// no unsubscribing from these classes.
$unsubUrl = SITEURL . "unsubscribe.php?id=" . base64_encode($urlQuery);
$unsubMessage = "This message was sent to " . $row['user_email'] . ". If you don't want to receive these emails in the future, please <a href='" . $unsubUrl . "'>unsubscribe</a>.";
$recipients[] = array('mail_recipient_id' => $row['user_id'], 'mail_recipient_name' => $row['user_name'], 'mail_recipient_email' => $row['user_email'], 'mail_target_info' => array('USERID' => $row['user_id'], 'DISPLAYNAME' => $row['user_name'], 'SUBJECT' => $subject, 'USERNAME' => $row['user_name'], 'USERLASTVISIT' => $row['user_lastvisit'], 'UNSUBSCRIBE' => !in_array($notifyTarget, $exclude) ? $unsubUrl : '', 'UNSUBSCRIBE_MESSAGE' => !in_array($notifyTarget, $exclude) ? $unsubMessage : '', 'USERCLASS' => $notifyTarget, 'DATE_SHORT' => $tp->toDate(time(), 'short'), 'DATE_LONG' => $tp->toDate(time(), 'long')));
}
}
}
}
if (E107_DEBUG_LEVEL > 0) {
$data = array('id' => $id, 'subject' => $subject, 'recipients' => $recipients, 'prefs' => $this->notify_prefs['event'][$id], 'message' => $message);
e107::getMessage()->addDebug("<b>Mailing is simulated only while in DEBUG mode.</b>");
e107::getMessage()->addDebug(print_a($data, true));
e107::getLog()->add('Notify Debug', $data, E_LOG_INFORMATIVE, "NOTIFY_DBG");
return;
}
$siteadminemail = e107::getPref('siteadminemail');
$siteadmin = e107::getPref('siteadmin');
if (count($recipients)) {
require_once e_HANDLER . 'mail_manager_class.php';
$mailer = new e107MailManager();
// Create the mail body
$mailData = array('mail_total_count' => count($recipients), 'mail_content_status' => MAIL_STATUS_TEMP, 'mail_create_app' => 'core', 'mail_title' => 'NOTIFY', 'mail_subject' => $subject, 'mail_sender_email' => e107::getPref('replyto_email', $siteadminemail), 'mail_sender_name' => e107::getPref('replyto_name', $siteadmin), 'mail_notify_complete' => 0, 'mail_body' => $message, 'template' => 'notify', 'mail_send_style' => 'notify');
if (!empty($media) && is_array($media)) {
foreach ($media as $k => $v) {
$mailData['mail_media'][$k] = array('path' => $v);
}
}
$result = $mailer->sendEmails('notify', $mailData, $recipients);
e107::getLog()->e_log_event(10, -1, 'NOTIFY', $subject, $message, FALSE, LOG_TO_ROLLING);
} else {
$data = array('qry' => $qry, 'error' => 'No recipients');
e107::getLog()->add('Notify Debug', $data, E_LOG_WARNING_, "NOTIFY_DBG");
}
}
// Class handler for core mailout functions
require_once e_HANDLER . 'mailout_admin_class.php';
// Admin tasks handler
require_once e_HANDLER . 'mail_manager_class.php';
// Mail DB API
require_once e_HANDLER . 'message_handler.php';
$emessage =& eMessage::getInstance();
if ($_GET['mode'] == "process") {
session_write_close();
// allow other scripts to run in parallel.
header('Content-Encoding: none');
ignore_user_abort(true);
set_time_limit(0);
header("Content-Length: {$size}");
header('Connection: close');
$mailManager = new e107MailManager();
$mailManager->doEmailTask(999999);
echo "Completed Mailout ID: " . $_GET['id'];
exit;
}
$action = $e107->tp->toDB(varset($_GET['mode'], 'makemail'));
$pageMode = varset($_GET['savepage'], $action);
// Sometimes we need to know what brought us here - $action gets changed
$mailId = intval(varset($_GET['m'], 0));
$targetId = intval(varset($_GET['t'], 0));
// Create mail admin object, load all mail handlers
$mailAdmin = new mailoutAdminClass($action);
// This decodes parts of the query using $_GET syntax
e107::setRegistry('_mailout_admin', $mailAdmin);
if ($mailAdmin->loadMailHandlers() == 0) {
// No mail handlers loaded
/**
* Actually release an issue of a newsletter
* Add the mailing to the mail queue
*
* @param int id of issue
*
* @return boolean FALSE on error
*/
function releaseIssue($issue)
{
$pref = e107::getPref();
$sql = e107::getDb();
$mes = e107::getMessage();
$ns = e107::getRender();
$issue = intval(str_replace('nlmailnow_', '', $issue));
// Get details of current newsletter issue
if (!$sql->select('newsletter', '*', 'newsletter_id=' . $issue)) {
return FALSE;
}
$newsletterInfo = $sql->fetch(MYSQL_ASSOC);
// Get parent details - has header/footer and subscriber list
if (!$sql->select('newsletter', '*', "newsletter_id='" . $newsletterInfo['newsletter_parent'] . "' ")) {
return FALSE;
}
$newsletterParentInfo = $sql->fetch(MYSQL_ASSOC);
$memberArray = explode(chr(1), $newsletterParentInfo['newsletter_subscribers']);
require e_HANDLER . 'mail_manager_class.php';
$mailer = new e107MailManager();
// Start by creating the mail body
$mailData = array('mail_content_status' => MAIL_STATUS_TEMP, 'mail_create_app' => 'newsletter', 'mail_title' => NLLAN_01 . ' ' . $issue, 'mail_subject' => $newsletterParentInfo['newsletter_title'] . ': ' . $newsletterInfo['newsletter_title'], 'mail_sender_email' => $pref['siteadminemail'], 'mail_sender_name' => $pref['siteadmin'], 'mail_send_style' => 'themehtml', 'mail_include_images' => TRUE);
// Assemble body - we can leave a lot to to core mail sending routines
$mail_style = "<div style='width:90%; padding-top:10px'>";
$mail_style .= "<div><b>{$mailout['mail_subject']}<br />[ " . NLLAN_12 . " " . $newsletterInfo['newsletter_issue'] . " ]</b></div><br /><br />";
$mail_style .= "<div>";
$mailData['mail_body'] = $mail_style . $newsletterParentInfo['newsletter_header'] . "<hr />" . $newsletterInfo['newsletter_text'] . "<br /><br /><hr />" . $newsletterParentInfo['newsletter_footer'] . "<br /></div></div>";
$result = $mailer->saveEmail($mailData, TRUE);
if (is_numeric($result)) {
$mailMainID = $mailData['mail_source_id'] = $result;
} else {
// TODO: Handle error
}
$mailer->mailInitCounters($mailMainID);
// Initialise counters for emails added
// Now add email addresses to the list
foreach ($memberArray as $memberID) {
if ($memberID = intval($memberID)) {
if ($sql->select('user', 'user_name,user_email,user_loginname,user_lastvisit', 'user_id=' . $memberID)) {
$row = $sql->db_Fetch(MYSQL_ASSOC);
$uTarget = array('mail_recipient_id' => $memberID, 'mail_recipient_name' => $row['user_name'], 'mail_recipient_email' => $row['user_email'], 'mail_target_info' => array('USERID' => $memberID, 'DISPLAYNAME' => $row['user_name'], 'USERNAME' => $row['user_loginname'], 'USERLASTVISIT' => $row['user_lastvisit']));
// Probably overkill, but some user data in case we want to substitute
}
$result = $mailer->mailAddNoDup($mailMainID, $uTarget, MAIL_STATUS_TEMP);
//echo '<b>'.NLLAN_54.'</b> '.$uTarget['mail_recipient_name'].' ( '.$uTarget['mail_recipient_email'].' ) <br />';
}
}
$mailer->mailUpdateCounters($mailMainID);
// Update the counters
$counters = $mailer->mailRetrieveCounters($mailMainID);
// Retrieve the counters
if ($counters['add'] == 0) {
$mailer->deleteEmail($mailMainID);
// No subscribers - delete email
//$this->message = NLLAN_41;
$mes->addError(NLLAN_41);
} else {
$mailer->activateEmail($mailMainID, FALSE);
// Actually mark the email for sending
//$this->message = str_replace('--COUNT--', $counters['add'],NLLAN_40);
$mes->addSuccess(str_replace('--COUNT--', $counters['add'], NLLAN_40));
}
$sql->update('newsletter', "newsletter_flag='1' WHERE newsletter_id=" . $issue);
$ns->tablerender($caption, $mes->render() . $text);
}
/**
* Send an email to users who are tracking the topic/thread.
* @param $post
* @return bool
*/
function trackEmail($post)
{
$sql = e107::getDb();
$tp = e107::getParser();
$trackingPref = $this->prefs->get('track');
if (empty($trackingPref)) {
return false;
}
$data = $sql->retrieve('SELECT t.*, u.user_id, u.user_name, u.user_email, u.user_lastvisit FROM `#forum_track` AS t LEFT JOIN `#user` AS u ON t.track_userid = u.user_id WHERE t.track_thread=' . intval($post['post_thread']), true);
if (empty($data)) {
return false;
}
$threadData = $this->threadGet($post['post_thread']);
$recipients = array();
$thread_name = $tp->toText($threadData['thread_name']);
// $thread_name = str_replace('"', '"', $thread_name); // This not picked up by toText();
$datestamp = $tp->toDate($post['post_datestamp']);
$email_post = $tp->toHTML($post['post_entry'], true);
// $mail_link = "<a href='".SITEURL.$PLUGINS_DIRECTORY."forum/forum_viewtopic.php?".$thread_parent.".last'>".SITEURL.$PLUGINS_DIRECTORY."forum/forum_viewtopic.php?".$thread_parent.".last</a>";
$query = array('last' => 1);
$mail_link = e107::url('forum', 'topic', $threadData, array('mode' => 'full', 'query' => $query));
$subject = $this->prefs->get('eprefix') . " " . $thread_name;
foreach ($data as $row) {
$recipients[] = array('mail_recipient_id' => $row['user_id'], 'mail_recipient_name' => $row['user_name'], 'mail_recipient_email' => $row['user_email'], 'mail_target_info' => array('USERID' => $row['user_id'], 'DISPLAYNAME' => $row['user_name'], 'SUBJECT' => $subject, 'USERNAME' => $row['user_name'], 'USERLASTVISIT' => $row['user_lastvisit'], 'DATE_SHORT' => $tp->toDate(time(), 'short'), 'DATE_LONG' => $tp->toDate(time(), 'long')));
}
require_once e_HANDLER . 'mail_manager_class.php';
$mailer = new e107MailManager();
$vars = array('x' => USERNAME, 'y' => $thread_name, 'z' => $datestamp);
$message = "[html]" . $tp->lanVars(LAN_FORUM_8001, $vars, true) . "<br /><br /><blockquote>" . $tp->toEmail($email_post, false) . "</blockquote><br />" . LAN_FORUM_8002 . "<br /><a href='" . $mail_link . "'>" . $mail_link . "</a>[/html]";
// Create the mail body
$mailData = array('mail_total_count' => count($recipients), 'mail_content_status' => MAIL_STATUS_TEMP, 'mail_create_app' => 'forum', 'mail_title' => 'FORUM TRACKING', 'mail_subject' => $subject, 'mail_sender_email' => e107::getPref('replyto_email', SITEADMINEMAIL), 'mail_sender_name' => e107::getPref('replyto_name', SITEADMIN), 'mail_notify_complete' => 0, 'mail_body' => $message, 'template' => 'default', 'mail_send_style' => 'default');
/* if(!empty($media) && is_array($media))
{
foreach($media as $k=>$v)
{
$mailData['mail_media'][$k] = array('path'=>$v);
}
}*/
$opts = array();
// array('mail_force_queue'=>1);
$mailer->sendEmails('default', $mailData, $recipients, $opts);
}
/**
* Send an email notification following an event.
*
* For up to a (hard-coded) number of recipients, the mail is sent immediately.
* Otherwise its added to the queue
*
* @param string $id - identifies event actions
* @param string $subject - subject for email
* @param string $message - email message body
* @return none
*
* @todo handle 'everyone except' clauses (email address filter done)
* @todo set up pref to not notify originator of event which caused notify (see $blockOriginator)
*/
function send($id, $subject, $message)
{
$e107 = e107::getInstance();
$subject = $e107->tp->toEmail(SITENAME . ': ' . $subject);
$message = $e107->tp->toEmail($message);
$emailFilter = '';
$notifyTarget = $this->notify_prefs['event'][$id]['class'];
if ($notifyTarget == '-email') {
$emailFilter = $this->notify_prefs['event'][$id]['email'];
}
$blockOriginator = FALSE;
// TODO: set this using a pref
if (is_numeric($this->notify_prefs['event'][$id]['class'])) {
switch ($notifyTarget) {
case e_UC_MAINADMIN:
$qry = "`user_admin` = 1 AND `user_perms` = '0' AND `user_ban` = 0";
break;
case e_UC_ADMIN:
$qry = "`user_admin` = 1 AND `user_ban` = 0";
break;
case e_UC_MEMBER:
$qry = "`user_ban` = 0";
break;
default:
$qry = "user_ban = 0 AND user_class REGEXP '(^|,)(" . $this->notify_prefs['event'][$id]['class'] . ")(,|\$)'";
break;
}
$qry = 'SELECT user_id,user_name,user_email FROM `#user` WHERE ' . $qry;
if ($blockOriginator) {
$qry .= ' AND `user_id` != ' . USERID;
}
if (FALSE !== ($count = $e107->sql->db_Select_gen($qry))) {
if ($count <= 5) {
// Arbitrary number below which we send emails immediately
e107_require_once(e_HANDLER . 'mail.php');
while ($email = $e107->sql->db_Fetch()) {
if ($email['user_email'] != $emailFilter) {
sendemail($email['user_email'], $subject, $message, $email['user_name']);
}
}
} else {
// Otherwise add to mailout queue
require_once e_HANDLER . 'mail_manager_class.php';
$mailer = new e107MailManager();
// Start by creating the mail body
$mailData = array('mail_content_status' => MAIL_STATUS_TEMP, 'mail_create_app' => 'notify', 'mail_title' => 'NOTIFY', 'mail_subject' => $subject, 'mail_sender_email' => $pref['siteadminemail'], 'mail_sender_name' => $pref['siteadmin'], 'mail_send_style' => 'textonly', 'mail_notify_complete' => 0, 'mail_body' => $message);
$result = $mailer->saveEmail($mailData, TRUE);
if (is_numeric($result)) {
$mailMainID = $mailData['mail_source_id'] = $result;
} else {
// TODO: Handle error
return;
// Probably nothing else we can do
}
$mailer->mailInitCounters($mailMainID);
// Initialise counters for emails added
// Now add email addresses to the list
while ($row = $e107->sql->db_Fetch(MYSQL_ASSOC)) {
if ($row['user_email'] != $emailFilter) {
$uTarget = array('mail_recipient_id' => $row['user_id'], 'mail_recipient_name' => $row['user_name'], 'mail_recipient_email' => $row['user_email']);
$result = $mailer->mailAddNoDup($mailMainID, $uTarget, MAIL_STATUS_TEMP);
}
}
$mailer->mailUpdateCounters($mailMainID);
// Update the counters
$counters = $mailer->mailRetrieveCounters($mailMainID);
// Retrieve the counters
if ($counters['add'] == 0) {
$mailer->deleteEmail($mailMainID);
// Probably a fault, but precautionary - delete email
} else {
$mailer->activateEmail($mailMainID, FALSE);
// Actually mark the email for sending
}
}
$e107->admin_log->e_log_event(10, -1, 'NOTIFY', $subject, $message, FALSE, LOG_TO_ROLLING);
}
} elseif ($notifyTarget == 'email') {
// Single email address - that can always go immediately
if (!$blockOriginator || $this->notify_prefs['event'][$id]['email'] != USEREMAIL) {
e107_require_once(e_HANDLER . 'mail.php');
sendemail($this->notify_prefs['event'][$id]['email'], $subject, $message);
}
}
}
