function __construct()
{
global $mySQLdefaultdb;
$this->_options = array("db_update" => array('diz' => DBLAN_15, 'label' => DBLAN_16), "verify_sql" => array('diz' => DBLAN_4, 'label' => DBLAN_5), 'optimize_sql' => array('diz' => DBLAN_6, 'label' => DBLAN_7), 'plugin_scan' => array('diz' => DBLAN_28, 'label' => DBLAN_29), 'pref_editor' => array('diz' => DBLAN_19, 'label' => DBLAN_20), 'verify_sql_record' => array('diz' => DBLAN_35, 'label' => DBLAN_36), 'importForm' => array('diz' => DBLAN_59, 'label' => DBLAN_59), 'exportForm' => array('diz' => DBLAN_58, 'label' => DBLAN_58), 'sc_override_scan' => array('diz' => DBLAN_55, 'label' => DBLAN_56), 'convert_to_utf8' => array('diz' => 'Convert Database to UTF-8', 'label' => 'Convert DB to UTF-8'), 'correct_perms' => array('diz' => 'Correct File and Directory perms', 'label' => 'Correct Perms'));
if (isset($_POST['delplug'])) {
$this->delete_plugin_entry($_POST['pref_type']);
}
if (isset($_POST['upload'])) {
$this->importXmlFile();
}
if (isset($_POST['delpref']) || isset($_POST['delpref_checked']) && isset($_POST['delpref2'])) {
$this->del_pref_val($_POST['pref_type']);
}
if (isset($_POST['verify_sql']) || varset($_GET['mode']) == 'verify_sql') {
require_once e_HANDLER . "db_verify_class.php";
$dbv = new db_verify();
$dbv->backUrl = e_SELF . "?mode=verify_sql";
$dbv->verify();
return;
}
if (isset($_POST['verify_sql_record']) || varset($_GET['mode']) == 'verify_sql_record' || isset($_POST['check_verify_sql_record']) || isset($_POST['delete_verify_sql_record'])) {
//$this->verify_sql_record(); // - currently performed in db_verify_class.php
}
if (isset($_POST['importForm']) || $_GET['mode'] == 'importForm') {
$this->importForm();
}
if (isset($_POST['convert_to_utf8']) || $_GET['mode'] == 'convert_to_utf8') {
$this->convertUTF8Form();
}
if (isset($_POST['exportForm']) || $_GET['mode'] == 'exportForm') {
$this->exportXmlForm();
}
if (isset($_POST['optimize_sql']) || $_GET['mode'] == 'optimize_sql') {
$this->optimizesql($mySQLdefaultdb);
}
if (isset($_POST['pref_editor']) || $_GET['mode'] == 'pref_editor' || isset($_POST['delpref']) || isset($_POST['delpref_checked'])) {
$type = isset($_GET['type']) ? $_GET['type'] : "core";
$this->pref_editor($type);
}
if (isset($_POST['sc_override_scan']) || $_GET['mode'] == 'sc_override_scan') {
$this->scan_override();
}
if (isset($_POST['plugin_scan']) || e_QUERY == "plugin" || isset($_POST['delplug']) || $_GET['mode'] == 'plugin_scan') {
$this->plugin_viewscan();
}
if (vartrue($_POST['perform_utf8_convert'])) {
$this->perform_utf8_convert();
return;
}
if (varset($_GET['mode']) == 'correct_perms') {
$this->correct_perms();
return;
}
if (!vartrue($_GET['mode']) && !isset($_POST['db_execute'])) {
$this->render_options();
}
}
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;
}
function step2()
{
require_once e_HANDLER . "db_verify_class.php";
$dv = new db_verify();
$frm = e107::getForm();
$ns = e107::getRender();
$mes = e107::getMessage();
$newplug = $_GET['newplugin'];
$this->pluginName = $newplug;
// $data = e107::getXml()->loadXMLfile(e_PLUGIN.'links_page/plugin.xml', 'advanced');
// print_a($data);
// echo "<pre>".var_export($data,true)."</pre>";
$sqlFile = e_PLUGIN . $newplug . "/" . $newplug . "_sql.php";
$ret = array();
if (file_exists($sqlFile)) {
$data = file_get_contents($sqlFile);
$ret = $dv->getTables($data);
}
$text = $frm->open('newplugin-step3', 'post', e_SELF . '?mode=create&newplugin=' . $newplug . '&createFiles=' . $this->createFiles . '&step=3');
$text .= "<ul class='nav nav-tabs'>\n";
$text .= "<li class='active'><a data-toggle='tab' href='#xml'>" . EPL_ADLAN_109 . "</a></li>";
$this->tableCount = count($ret['tables']);
foreach ($ret['tables'] as $key => $table) {
$text .= "<li><a data-toggle='tab' href='#" . $table . "'>Table: " . $table . "</a></li>";
$this->tableList[] = $table;
}
$text .= "<li><a data-toggle='tab' href='#preferences'>" . LAN_PREFS . "</a></li>";
$text .= "</ul>";
$text .= "<div class='tab-content'>\n";
$text .= "<div class='tab-pane active' id='xml'>\n";
$text .= $this->pluginXml();
$text .= "</div>";
if (!empty($ret['tables'])) {
foreach ($ret['tables'] as $key => $table) {
$text .= "<div class='tab-pane' id='" . $table . "'>\n";
$fields = $dv->getFields($ret['data'][$key]);
$text .= $this->form($table, $fields);
$text .= "</div>";
}
}
$text .= "<div class='tab-pane' id='preferences'>\n";
$text .= $this->prefs();
$text .= "</div>";
if (empty($ret['tables'])) {
$text .= $frm->hidden($this->pluginName . '_ui[mode]', 'main');
$text .= $frm->hidden($this->pluginName . '_ui[pluginName]', $this->pluginName);
}
$text .= "</div>";
$text .= "\n\t\t\t<div class='buttons-bar center'>\n\t\t\t" . $frm->hidden('newplugin', $this->pluginName) . "\n\t\t\t" . $frm->admin_button('step', 3, 'other', LAN_GENERATE) . "\n\t\t\t</div>";
$text .= $frm->close();
$mes->addInfo(EPL_ADLAN_112);
$mes->addInfo(EPL_ADLAN_113);
$ns->tablerender(ADLAN_98 . SEP . EPL_ADLAN_114 . SEP . EPL_ADLAN_115, $mes->render() . $text);
}
/**
* Parse {plugin}_sql.php file and install/upgrade/uninstall tables.
* @param $function string install|upgrade|uninstall
* @param $plug - array of plugin data - mostly $plug['plugin_path']
* @param array $options
*/
function XmlTables($function, $plug, $options = array())
{
$sqlFile = e_PLUGIN . $plug['plugin_path'] . '/' . str_replace("_menu", "", $plug['plugin_path']) . "_sql.php";
if (!file_exists($sqlFile)) {
e107::getMessage()->addDebug("No SQL File Found at: " . $sqlFile);
return;
}
if (!is_readable($sqlFile)) {
e107::getMessage()->addError("Can't read SQL definition: " . $sqlFile);
return;
}
require_once e_HANDLER . "db_verify_class.php";
$dbv = new db_verify();
$sql = e107::getDb();
// Add or Remove Table --------------
if ($function == 'install' || $function == 'uninstall') {
$contents = file_get_contents($sqlFile);
if (empty($contents)) {
e107::getMessage()->addError("Can't read SQL definition: " . $sqlFile);
return;
}
$tableData = $dbv->getTables($contents);
foreach ($tableData['tables'] as $k => $v) {
switch ($function) {
case "install":
$query = "CREATE TABLE `" . MPREFIX . $v . "` (\n";
$query .= $tableData['data'][$k];
$query .= "\n) ENGINE=" . vartrue($tableData['engine'][$k], "InnoDB") . " DEFAULT CHARSET=utf8 ";
$txt = "Adding Table: <b>{$v}</b> ";
$status = $sql->db_Query($query) ? E_MESSAGE_SUCCESS : E_MESSAGE_ERROR;
break;
case "uninstall":
if (!empty($options['delete_tables'])) {
$query = "DROP TABLE `" . MPREFIX . $v . "`; ";
$txt = "Removing Table: {$v} <br />";
$status = $sql->db_Query_all($query) ? E_MESSAGE_SUCCESS : E_MESSAGE_ERROR;
} else {
$status = E_MESSAGE_SUCCESS;
$txt = "Table {$v} left in place.";
}
break;
}
e107::getMessage()->add($txt, $status);
e107::getMessage()->addDebug($query);
}
}
// Upgrade Table --------------
if ($function == 'upgrade') {
$dbv->errors = array();
$dbv->compare($plug['plugin_path']);
if ($dbv->errors()) {
$dbv->compileResults();
$dbv->runFix();
}
}
}
function __construct()
{
global $mySQLdefaultdb;
$this->_utf8_exclude = array(MPREFIX . "core");
$this->_options = array("db_update" => array('diz' => DBLAN_15, 'label' => DBLAN_16), "verify_sql" => array('diz' => DBLAN_4, 'label' => DBLAN_5), 'optimize_sql' => array('diz' => DBLAN_6, 'label' => DBLAN_7), 'plugin_scan' => array('diz' => DBLAN_28, 'label' => DBLAN_29), 'pref_editor' => array('diz' => DBLAN_19, 'label' => DBLAN_20), 'importForm' => array('diz' => DBLAN_59, 'label' => DBLAN_59), 'exportForm' => array('diz' => DBLAN_58, 'label' => DBLAN_58), 'sc_override_scan' => array('diz' => DBLAN_55, 'label' => DBLAN_56), 'convert_to_utf8' => array('diz' => DBLAN_64, 'label' => DBLAN_65), 'correct_perms' => array('diz' => DBLAN_66, 'label' => DBLAN_67), 'backup' => array('diz' => DBLAN_68, 'label' => DBLAN_69));
if (deftrue('e_DEVELOPER')) {
$this->_options['multisite'] = array('diz' => "<span class='label label-warning'>Developer Mode Only</span>", 'label' => 'Multi-Site');
$this->_options['github'] = array('diz' => "<span class='label label-warning'>Developer Mode Only</span> Overwrite local files with the latest from github.", 'label' => 'Sync with Github');
}
$this->_options = multiarray_sort($this->_options, 'label');
if (isset($_POST['delplug'])) {
$this->delete_plugin_entry($_POST['pref_type']);
}
if (isset($_POST['upload'])) {
$this->importXmlFile();
}
if (isset($_POST['delpref']) || isset($_POST['delpref_checked']) && isset($_POST['delpref2'])) {
$this->del_pref_val($_POST['pref_type']);
}
if (isset($_POST['verify_sql']) || varset($_GET['mode']) == 'verify_sql') {
require_once e_HANDLER . "db_verify_class.php";
$dbv = new db_verify();
$dbv->backUrl = e_SELF . "?mode=verify_sql";
$dbv->verify();
return;
}
// ----------------- Processes ------------------
// if(isset($_POST['verify_sql_record']) || varset($_GET['mode'])=='verify_sql_record' || isset($_POST['check_verify_sql_record']) || isset($_POST['delete_verify_sql_record']))
// {
//$this->verify_sql_record(); // - currently performed in db_verify_class.php
// }
if (isset($_POST['importForm']) || $_GET['mode'] == 'importForm') {
$this->importForm();
}
if (isset($_POST['db_update']) || varset($_GET['mode']) == 'db_update') {
// header("location: ".e_ADMIN."e107_update.php");
require_once e_ADMIN . "update_routines.php";
new e107Update($dbupdate);
return;
}
if (isset($_POST['convert_to_utf8']) || $_GET['mode'] == 'convert_to_utf8') {
$this->convertUTF8Form();
}
if (isset($_POST['exportForm']) || $_GET['mode'] == 'exportForm') {
$this->exportXmlForm();
}
if (isset($_POST['optimize_sql']) || $_GET['mode'] == 'optimize_sql') {
$this->optimizesql($mySQLdefaultdb);
}
if (isset($_POST['pref_editor']) || $_GET['mode'] == 'pref_editor' || isset($_POST['delpref']) || isset($_POST['delpref_checked'])) {
$type = isset($_GET['type']) ? $_GET['type'] : "core";
$this->pref_editor($type);
}
if (isset($_POST['sc_override_scan']) || $_GET['mode'] == 'sc_override_scan') {
$this->scan_override();
}
if (isset($_POST['plugin_scan']) || e_QUERY == "plugin" || isset($_POST['delplug']) || $_GET['mode'] == 'plugin_scan') {
$this->plugin_viewscan('refresh');
}
if (!empty($_POST['create_multisite'])) {
$this->multiSiteProcess();
}
if (!empty($_POST['perform_utf8_convert'])) {
$this->perform_utf8_convert();
return;
}
if (!empty($_POST['githubSyncProcess'])) {
$this->githubSyncProcess();
return;
}
// --------------------- Modes --------------------------------.
if (varset($_GET['mode']) == 'correct_perms') {
$this->correct_perms();
return;
}
if (varset($_GET['mode']) == 'multisite') {
$this->multiSite();
return;
}
if (varset($_GET['mode']) == 'github') {
$this->githubSync();
}
if (varset($_GET['mode']) == 'backup') {
$this->backup();
return;
}
if (!vartrue($_GET['mode']) && !isset($_POST['db_execute'])) {
$this->render_options();
}
}
