*/ $DatabasePrefix = $Context->Configuration['DATABASE_TABLE_PREFIX']; // Check to see if this extension has been configured if (!array_key_exists('MARKALLREADREDUX_SETUP', $Configuration)) { $Errors = 0; // Check if Column exists if (!mysql_query("SELECT MarkAllRead\r\n\t\t\tFROM " . $DatabasePrefix . "User\r\n\t\t\tLIMIT 1,1", $Context->Database->Connection)) { // Attempt to add the column if (!mysql_query("ALTER TABLE " . $DatabasePrefix . "User \r\n\t\t\tADD MarkAllRead timestamp null DEFAULT null", $Context->Database->Connection)) { $Errors = 1; } } // Add the db structure to the database configuration file if ($Errors == 0) { $Structure = "\$DatabaseColumns['User']['MarkAllRead'] = 'MarkAllRead';\r\n"; if (!AppendToConfigurationFile($Configuration['APPLICATION_PATH'] . 'conf/database.php', $Structure)) { $Errors = 1; } } // Mark this extension as enabled using a convenience method if ($Errors == 0) { AddConfigurationSetting($Context, 'MARKALLREADREDUX_SETUP'); } } /** * 3. Get the User's MarkAllRead data */ $result = mysql_query("\tSELECT MarkAllRead\r\n\t\t\tFROM " . $DatabasePrefix . "User\r\n\t\t\tWHERE UserID=" . $Context->Session->UserID . "", $Context->Database->Connection); $MarkAllReadRedux_UserData = strtotime(mysql_result($result, 0)); /** * 4. Change Discussion Properties
@mysql_close($Connection); } // If the database was created successfully, save all parameters to the conf/database.php file if ($Context->WarningCollector->Count() == 0) { $DBManager->DefineSetting('DATABASE_HOST', $DBHost, 1); $DBManager->DefineSetting('DATABASE_NAME', $DBName, 1); $DBManager->DefineSetting('DATABASE_USER', $DBUser, 1); $DBManager->DefineSetting('DATABASE_PASSWORD', $DBPass, 1); $DBManager->DefineSetting('DATABASE_TABLE_PREFIX', $DBTablePrefix, 1); $DBManager->DefineSetting('DATABASE_CHARACTER_ENCODING', $DatabaseCharacterEncoding, 1); if (!$DBManager->SaveSettingsToFile($DBFile)) { // $Context->WarningCollector->Clear(); // $Context->WarningCollector->Add('For some reason we couldn’t save your database settings to the '.$DBFile.' file.'); } // Save user table name if (!AppendToConfigurationFile($RootDirectory . 'conf/database.php', '$DatabaseTables[\'User\'] = \'' . $DBTablePrefix . "User';\n")) { // $Context->WarningCollector->Clear(); // $Context->WarningCollector->Add('For some reason we couldn’t save your database settings to the '.$DBFile.' file.'); } // Save the general settings as well (now that we know this person is authenticated to // a degree - knowing the database access params). $SettingsFile = $RootDirectory . 'conf/settings.php'; $SettingsManager = new ConfigurationManager($Context); $SettingsManager->DefineSetting('APPLICATION_PATH', $RootDirectory, 1); $SettingsManager->DefineSetting('DATABASE_PATH', $RootDirectory . 'conf/database.php', 1); $SettingsManager->DefineSetting('LIBRARY_PATH', $RootDirectory . 'library/', 1); $SettingsManager->DefineSetting('EXTENSIONS_PATH', $RootDirectory . 'extensions/', 1); $SettingsManager->DefineSetting('LANGUAGES_PATH', $RootDirectory . 'languages/', 1); $SettingsManager->DefineSetting('THEME_PATH', $RootDirectory . 'themes/vanilla modern/', 1); $SettingsManager->DefineSetting('DEFAULT_STYLE', $ThemeDirectory . 'vanilla modern/styles/default/', 1); $SettingsManager->DefineSetting('WEB_ROOT', $WebRoot, 1);