public function down(Schema $schema)
{
$pe = Type::getByHandle('page_owner');
$category = Category::getByHandle('page_type');
if (is_object($category) && is_object($pe)) {
$category->deassociateAccessEntityType($pe);
}
}
public function import(\SimpleXMLElement $sx)
{
if (isset($sx->permissioncategories)) {
foreach ($sx->permissioncategories->category as $pkc) {
$pkg = static::getPackageObject($pkc['package']);
$category = Category::getByHandle((string) $pkc['handle']);
if (!is_object($category)) {
Category::add((string) $pkc['handle'], $pkg);
}
}
}
}
public function categoryExists($handle, $batch)
{
$category = Category::getByHandle($handle);
if (is_object($category)) {
return true;
}
$categories = $batch->getObjectCollection('permission_key_category');
foreach ($categories->getCategories() as $c) {
if ($c->getHandle() == $handle) {
return true;
}
}
}
public function execute(Batch $batch)
{
$categories = $batch->getObjectCollection('permission_key_category');
if (!$categories) {
return;
}
foreach ($categories->getCategories() as $category) {
if (!$category->getPublisherValidator()->skipItem()) {
$pkg = null;
if ($category->getPackage()) {
$pkg = \Package::getByHandle($category->getPackage());
}
Category::add($category->getHandle(), $pkg);
}
}
}
public function import(\SimpleXMLElement $sx)
{
if (isset($sx->permissionkeys)) {
foreach ($sx->permissionkeys->permissionkey as $pk) {
if (is_object(Key::getByHandle((string) $pk['handle']))) {
continue;
}
$pkc = Category::getByHandle((string) $pk['category']);
$c1 = $pkc->getPermissionKeyClass();
$pkx = call_user_func(array($c1, 'import'), $pk);
$assignments = array();
if (isset($pk->access)) {
foreach ($pk->access->children() as $ch) {
if ($ch->getName() == 'group') {
/*
* Legacy
*/
$g = Group::getByName($ch['name']);
if (!is_object($g)) {
$g = Group::add($g['name'], $g['description']);
}
$pae = GroupEntity::getOrCreate($g);
$assignments[] = $pae;
}
if ($ch->getName() == 'entity') {
$type = Type::getByHandle((string) $ch['type']);
$class = $type->getAccessEntityTypeClass();
if (method_exists($class, 'configureFromImport')) {
$pae = $class::configureFromImport($ch);
$assignments[] = $pae;
}
}
}
}
if (count($assignments)) {
$pa = Access::create($pkx);
foreach ($assignments as $pae) {
$pa->addListItem($pae);
}
$pt = $pkx->getPermissionAssignmentObject();
$pt->assignPermissionAccess($pa);
}
}
}
}
public function setUp()
{
$this->tables = array_merge($this->tables, array('PermissionAccessList', 'PageTypeComposerFormLayoutSets', 'AttributeSetKeys', 'AttributeSets', 'AttributeKeyCategories', 'PermissionAccessEntityTypes', 'Packages', 'AttributeKeys', 'AttributeTypes', 'PageFeeds'));
parent::setUp();
\Concrete\Core\Permission\Access\Entity\Type::add('page_owner', 'Page Owner');
\Concrete\Core\Permission\Category::add('page');
\Concrete\Core\Permission\Key\Key::add('page', 'view_page', 'View Page', '', 0, 0);
PageTemplate::add('left_sidebar', 'Left Sidebar');
PageTemplate::add('right_sidebar', 'Right Sidebar');
PageType::add(array('handle' => 'alternate', 'name' => 'Alternate'));
PageType::add(array('handle' => 'another', 'name' => 'Another'));
foreach ($this->pageData as $data) {
$c = call_user_func_array(array($this, 'createPage'), $data);
$c->reindex();
}
$this->list = new \Concrete\Core\Page\PageList();
$this->list->ignorePermissions();
}
public function import(\SimpleXMLElement $sx)
{
if (isset($sx->permissionaccessentitytypes)) {
foreach ($sx->permissionaccessentitytypes->permissionaccessentitytype as $pt) {
$type = Type::getByHandle((string) $pt['handle']);
if (!is_object($type)) {
$pkg = static::getPackageObject($pt['package']);
$name = $pt['name'];
if (!$name) {
$name = \Core::make('helper/text')->unhandle($pt['handle']);
}
$type = Type::add($pt['handle'], $name, $pkg);
}
if (isset($pt->categories)) {
foreach ($pt->categories->children() as $cat) {
$catobj = Category::getByHandle((string) $cat['handle']);
$catobj->associateAccessEntityType($type);
}
}
}
}
}
public function execute(Batch $batch)
{
$types = $batch->getObjectCollection('permission_access_entity_type');
if (!$types) {
return;
}
foreach ($types->getTypes() as $type) {
if (!$type->getPublisherValidator()->skipItem()) {
$pkg = null;
if ($type->getPackage()) {
$pkg = \Package::getByHandle($type->getPackage());
}
$type = Type::add($type->getHandle(), $type->getName(), $pkg);
$categories = $type->getCategories();
foreach ($categories as $category) {
$co = Category::getByHandle($category);
if (is_object($co)) {
$co->associateAccessEntityType($type);
}
}
}
}
}
public function up(Schema $schema)
{
$ft = FlagType::getByhandle('spam');
if (!is_object($ft)) {
FlagType::add('spam');
}
$bt = BlockType::getByHandle('image_slider');
$bt->refresh();
$types = array(Type::getByHandle('group'), Type::getByHandle('user'), Type::getByHandle('group_set'), Type::getByHandle('group_combination'));
$categories = array(Category::getByHandle('conversation'), Category::getByHandle('conversation_message'));
foreach ($categories as $category) {
foreach ($types as $pe) {
if (is_object($category) && is_object($pe)) {
$category->associateAccessEntityType($pe);
}
}
}
try {
$gat = AuthenticationType::getByHandle('google');
} catch (Exception $e) {
$gat = AuthenticationType::add('google', 'Google');
if (is_object($gat)) {
$gat->disable();
}
}
// fix register page permissions
$g1 = \Group::getByID(GUEST_GROUP_ID);
$register = \Page::getByPath('/register', "RECENT");
$register->assignPermissions($g1, array('view_page'));
// add new permissions, set it to the same value as edit page permissions on all pages.
$epk = PermissionKey::getByHandle('edit_page_permissions');
$msk = PermissionKey::getByHandle('edit_page_multilingual_settings');
$ptk = PermissionKey::getByHandle('edit_page_page_type');
if (!is_object($msk)) {
$msk = PermissionKey::add('page', 'edit_page_multilingual_settings', 'Edit Multilingual Settings', 'Controls whether a user can see the multilingual settings menu, re-map a page or set a page as ignored in multilingual settings.', false, false);
}
if (!is_object($ptk)) {
$ptk = PermissionKey::add('page', 'edit_page_page_type', 'Edit Page Type', 'Change the type of an existing page.', false, false);
}
$db = \Database::get();
$r = $db->Execute('select cID from Pages where cInheritPermissionsFrom = "OVERRIDE" order by cID asc');
while ($row = $r->FetchRow()) {
$c = Page::getByID($row['cID']);
if (is_object($c) && !$c->isError()) {
$epk->setPermissionObject($c);
$msk->setPermissionObject($c);
$ptk->setPermissionObject($c);
$rpa = $epk->getPermissionAccessObject();
if (is_object($rpa)) {
$pt = $msk->getPermissionAssignmentObject();
if (is_object($pt)) {
$pt->clearPermissionAssignment();
$pt->assignPermissionAccess($rpa);
}
$pt = $ptk->getPermissionAssignmentObject();
if (is_object($pt)) {
$pt->clearPermissionAssignment();
$pt->assignPermissionAccess($rpa);
}
}
}
}
// add new page type permissions
$epk = PermissionKey::getByHandle('edit_page_type_permissions');
$msk = PermissionKey::getByHandle('edit_page_type');
$dsk = PermissionKey::getByHandle('delete_page_type');
if (!is_object($msk)) {
$msk = PermissionKey::add('page_type', 'edit_page_type', 'Edit Page Type', '', false, false);
}
if (!is_object($dsk)) {
$dsk = PermissionKey::add('page_type', 'delete_page_type', 'Delete Page Type', '', false, false);
}
$list = \Concrete\Core\Page\Type\Type::getList();
foreach ($list as $pagetype) {
$epk->setPermissionObject($pagetype);
$msk->setPermissionObject($pagetype);
$dsk->setPermissionObject($pagetype);
$rpa = $epk->getPermissionAccessObject();
if (is_object($rpa)) {
$pt = $msk->getPermissionAssignmentObject();
if (is_object($pt)) {
$pt->clearPermissionAssignment();
$pt->assignPermissionAccess($rpa);
}
$pt = $dsk->getPermissionAssignmentObject();
if (is_object($pt)) {
$pt->clearPermissionAssignment();
$pt->assignPermissionAccess($rpa);
}
}
}
// add new multilingual tables.
$sm = $db->getSchemaManager();
$schemaTables = $sm->listTableNames();
if (!in_array('MultilingualPageRelations', $schemaTables)) {
$mpr = $schema->createTable('MultilingualPageRelations');
$mpr->addColumn('mpRelationID', 'integer', array('notnull' => true, 'unsigned' => true, 'default' => 0));
$mpr->addColumn('cID', 'integer', array('notnull' => true, 'unsigned' => true, 'default' => 0));
$mpr->addColumn('mpLanguage', 'string', array('notnull' => true, 'default' => ''));
$mpr->addColumn('mpLocale', 'string', array('notnull' => true));
$mpr->setPrimaryKey(array('mpRelationID', 'cID', 'mpLocale'));
}
if (!in_array('MultilingualSections', $schemaTables)) {
$mus = $schema->createTable('MultilingualSections');
$mus->addColumn('cID', 'integer', array('notnull' => true, 'unsigned' => true, 'default' => 0));
$mus->addColumn('msLanguage', 'string', array('notnull' => true, 'default' => ''));
$mus->addColumn('msCountry', 'string', array('notnull' => true, 'default' => ''));
$mus->setPrimaryKey(array('cID'));
}
if (!in_array('MultilingualTranslations', $schemaTables)) {
$mts = $schema->createTable('MultilingualTranslations');
$mts->addColumn('mtID', 'integer', array('autoincrement' => true, 'unsigned' => true));
$mts->addColumn('mtSectionID', 'integer', array('unsigned' => true, 'notnull' => true, 'default' => 0));
$mts->addColumn('msgid', 'text', array('notnull' => false));
$mts->addColumn('msgstr', 'text', array('notnull' => false));
$mts->addColumn('context', 'text', array('notnull' => false));
$mts->addColumn('comments', 'text', array('notnull' => false));
$mts->addColumn('reference', 'text', array('notnull' => false));
$mts->addColumn('flags', 'text', array('notnull' => false));
$mts->addColumn('updated', 'datetime', array('notnull' => false));
$mts->setPrimaryKey(array('mtID'));
}
// block type
$bt = BlockType::getByHandle('switch_language');
if (!is_object($bt)) {
$bt = BlockType::installBlockType('switch_language');
}
// single pages
$sp = Page::getByPath('/dashboard/system/multilingual');
if (!is_object($sp) || $sp->isError()) {
$sp = SinglePage::add('/dashboard/system/multilingual');
$sp->update(array('cName' => 'Multilingual'));
$sp->setAttribute('meta_keywords', 'multilingual, localization, internationalization, i18n');
}
$sp = Page::getByPath('/dashboard/system/multilingual/setup');
if (!is_object($sp) || $sp->isError()) {
$sp = SinglePage::add('/dashboard/system/multilingual/setup');
$sp->update(array('cName' => 'Multilingual Setup'));
}
$sp = Page::getByPath('/dashboard/system/multilingual/page_report');
if (!is_object($sp) || $sp->isError()) {
$sp = SinglePage::add('/dashboard/system/multilingual/page_report');
$sp->update(array('cName' => 'Page Report'));
}
$sp = Page::getByPath('/dashboard/system/multilingual/translate_interface');
if (!is_object($sp) || $sp->isError()) {
$sp = SinglePage::add('/dashboard/system/multilingual/translate_interface');
$sp->update(array('cName' => 'Translate Interface'));
}
$sp = Page::getByPath('/dashboard/pages/types/attributes');
if (!is_object($sp) || $sp->isError()) {
$sp = SinglePage::add('/dashboard/pages/types/attributes');
$sp->update(array('cName' => 'Page Type Attributes'));
}
}
public function skipItem()
{
$category = \Concrete\Core\Permission\Category::getByHandle($this->object->getHandle());
return is_object($category);
}
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();
}
/**
* Note, this queries both the pkgID found on the PermissionKeys table AND any permission keys of a special type
* installed by that package, and any in categories by that package.
*/
public static function getListByPackage($pkg)
{
$db = Loader::db();
$kina[] = '-1';
$kinb = $db->GetCol('select pkCategoryID from PermissionKeyCategories where pkgID = ?', array($pkg->getPackageID()));
if (is_array($kinb)) {
$kina = array_merge($kina, $kinb);
}
$kinstr = implode(',', $kina);
$r = $db->Execute('select pkID, pkCategoryID from PermissionKeys where (pkgID = ? or pkCategoryID in (' . $kinstr . ')) order by pkID asc', array($pkg->getPackageID()));
while ($row = $r->FetchRow()) {
$pkc = PermissionKeyCategory::getByID($row['pkCategoryID']);
$pk = $pkc->getPermissionKeyByID($row['pkID']);
$list[] = $pk;
}
$r->Close();
return $list;
}
public static function exportTranslations()
{
$translations = new Translations();
$categories = PermissionKeyCategory::getList();
foreach ($categories as $cat) {
$permissions = static::getList($cat->getPermissionKeyCategoryHandle());
foreach ($permissions as $p) {
$translations->insert('PermissionKeyName', $p->getPermissionKeyName());
if ($p->getPermissionKeyDescription()) {
$translations->insert('PermissionKeyDescription', $p->getPermissionKeyDescription());
}
}
}
return $translations;
}
public function getPackageItems(Package $package)
{
return Category::getListByPackage($package);
}
public function setPropertiesFromArray($arr)
{
return parent::setPropertiesFromArray($arr);
}