public function up(Schema $schema)
{
\Concrete\Core\Database\Schema\Schema::refreshCoreXMLSchema(array('ConversationPermissionAddMessageAccessList', 'ConversationSubscriptions', 'Conversations'));
// Subscribe admin to conversations by default, if we have no subscriptions
$users = \Conversation::getDefaultSubscribedUsers();
if (count($users) == 0) {
$admin = \UserInfo::getByID(USER_SUPER_ID);
if (is_object($admin)) {
$users = array($admin);
\Conversation::setDefaultSubscribedUsers($users);
}
}
$db = \Database::get();
$db->Execute('DROP TABLE IF EXISTS PageStatistics');
$pp = $schema->getTable('PagePaths');
if (!$pp->hasColumn('ppGeneratedFromURLSlugs')) {
$db->Execute('alter table PagePaths add column ppGeneratedFromURLSlugs tinyint(1) unsigned not null default 0');
// we have to do this directly because the page path calls below will die otherwise.
}
$bt = BlockType::getByHandle('page_list');
if (is_object($bt)) {
$bt->refresh();
}
$bt = BlockType::getByHandle('page_title');
if (is_object($bt)) {
$bt->refresh();
}
$bt = BlockType::getByHandle('form');
if (is_object($bt)) {
$bt->refresh();
}
$c = \Page::getByPath('/dashboard/system/seo/urls');
if (is_object($c) && !$c->isError()) {
$c->update(array('cName' => 'URLs and Redirection'));
}
$sp = \Page::getByPath('/dashboard/system/environment/entities');
if (!is_object($sp) || $sp->isError()) {
$sp = \SinglePage::add('/dashboard/system/environment/entities');
$sp->update(array('cName' => 'Database Entities'));
$sp->setAttribute('meta_keywords', 'database, entities, doctrine, orm');
}
$pkx = Category::getByHandle('multilingual_section');
if (!is_object($pkx)) {
$pkx = Category::add('multilingual_section');
}
$pkx->associateAccessEntityType(Type::getByHandle('group'));
$pkx->associateAccessEntityType(Type::getByHandle('user'));
$pkx->associateAccessEntityType(Type::getByHandle('group_combination'));
$db->Execute("alter table QueueMessages modify column body longtext not null");
$ms = $schema->getTable('MultilingualSections');
if (!$ms->hasColumn('msNumPlurals')) {
$ms->addColumn('msNumPlurals', 'integer', array('notnull' => true, 'unsigned' => true, 'default' => 2));
$this->updateSectionPlurals = true;
}
if (!$ms->hasColumn('msPluralRule')) {
$ms->addColumn('msPluralRule', 'string', array('notnull' => true, 'length' => 400, 'default' => '(n != 1)'));
$this->updateSectionPlurals = true;
}
if (!$ms->hasColumn('msPluralCases')) {
$ms->addColumn('msPluralCases', 'string', array('notnull' => true, 'length' => 1000, 'default' => "one@1\nother@0, 2~16, 100, 1000, 10000, 100000, 1000000, …"));
$this->updateSectionPlurals = true;
}
$mt = $schema->getTable('MultilingualTranslations');
if (!$mt->hasColumn('msgidPlural')) {
$mt->addColumn('msgidPlural', 'text', array('notnull' => false));
$this->updateMultilingualTranslations = true;
}
if (!$mt->hasColumn('msgstrPlurals')) {
$mt->addColumn('msgstrPlurals', 'text', array('notnull' => false));
$this->updateMultilingualTranslations = true;
}
$cms = $schema->getTable('ConversationMessages');
if (!$cms->hasColumn('cnvMessageAuthorName')) {
$cms->addColumn('cnvMessageAuthorName', 'string', array('notnull' => false, 'length' => 255));
}
if (!$cms->hasColumn('cnvMessageAuthorEmail')) {
$cms->addColumn('cnvMessageAuthorEmail', 'string', array('notnull' => false, 'length' => 255));
}
if (!$cms->hasColumn('cnvMessageAuthorWebsite')) {
$cms->addColumn('cnvMessageAuthorWebsite', 'string', array('notnull' => false, 'length' => 255));
}
$this->updatePermissionDurationObjects();
$key = Key::getByHandle('add_conversation_message');
if (is_object($key) && !$key->permissionKeyHasCustomClass()) {
$key->setPermissionKeyHasCustomClass(true);
}
$this->installMaintenanceModePermission();
}
$attachmentOverridesEnabled = 0;
$attachmentsEnabled = 1;
$fileAccessFileTypes = Config::get('conversations.files.allowed_types');
//is nothing's been defined, display the constant value
if (!$fileAccessFileTypes) {
$fileAccessFileTypes = $helperFile->unserializeUploadFileExtensions(Config::get('concrete.upload.extensions'));
} else {
$fileAccessFileTypes = $helperFile->unserializeUploadFileExtensions($fileAccessFileTypes);
}
$maxFileSizeGuest = Config::get('conversations.files.guest.max_size');
$maxFileSizeRegistered = Config::get('conversations.files.registered.max_size');
$maxFilesGuest = Config::get('conversations.files.guest.max');
$maxFilesRegistered = Config::get('conversations.files.registered.max');
$fileExtensions = implode(',', $fileAccessFileTypes);
$attachmentsEnabled = intval(Config::get('conversations.attachments_enabled'));
$notificationUsers = Conversation::getDefaultSubscribedUsers();
$subscriptionEnabled = intval(Config::get('conversations.subscription_enabled'));
}
if (!$dateFormat) {
$dateFormat = 'default';
}
?>
<fieldset>
<legend><?php
echo t('Message List');
?>
</legend>
<div class="form-group">
<label class="control-label"><?php
echo t('Display Mode');
