author | jreyes (SF: jreyesg) |
changelog | 0.1 initial package 0.2 fixed some bugs 0.3 fixed some bugs 0.4 TikiWiki 1.10 support 0.5 support to new Tiki resources 0.6 AulaWiki Workspaces renamed to Tiki Workspaces 0.7 fixed some bugs 0.8 fixed some bugs 1.6 updated to work on Tiki 2.x 1.7.0 new permission scheme. Works on tw 3.0 1.7.1 fixed some bugs, deleted some disturbing local tpl (tiki-user_menu.tpl, templates/styles/modules/mod-application_menu.tpl), and fixed display on tiki 2.x and 3.x through patching workspaces.css 1.7.2 group admin by non-admins is done. CRSF ticket when deleting a workspace fixed. Working without major issues with current Tiki 3 branch (LTS) 1.7.3 deleted outdated module.tpl and tiki-show_page.tpl so that default (and updated) ones in Tiki are used 4.0.0 Code modified to work on Tiki 4. See http://edu.tikiwiki.org/tiki-view_forum_thread.php?forumId=1&comments_parentId=357#threadId1 for more information. |
contributor | jreyesg |
description | AulaWiki offers team collaboration environments (workspaces), allowing you to manage sets of Tiki resources in an easy way. See: http://doc.tikiwiki.org/Mod+AulaWiki |
files | aulawiki-assignments_admin.php tiki-workspaces_objectpermissions.php tiki-workspaces_get_resource.php tiki-workspaces_roles.php aulawiki-view_gradebook.php aulawiki-view_gradebook_xml.php tiki-workspaces_view_module.php tiki-workspaces_view_structure.php tiki-workspaces_admin.php tiki-workspaces_desktop.php tiki-workspaces_modules.php tiki-workspaces_types.php tiki-workspaces_types_resources.php tiki-workspaces_types_roles.php tiki-workspaces_assigned_modules.php images/workspaces/key.gif images/workspaces/edu_survey.gif images/workspaces/edu_tracker.gif images/workspaces/edu_sheet.gif images/workspaces/config.gif images/workspaces/copy.gif images/workspaces/delete.gif images/workspaces/degrada.gif images/workspaces/degrada2.gif images/workspaces/degrada2gris.gif images/workspaces/degrada2verde.gif images/workspaces/degrada3.gif images/workspaces/edu_article.gif images/aulawiki/edu_assignments.gif images/workspaces/edu_blog.gif images/workspaces/edu_calendar.gif images/workspaces/edu_faq.gif images/workspaces/edu_filegallery.gif images/workspaces/edu_folder.png images/workspaces/edu_folder_closed.png images/workspaces/edu_folder_dim.png images/workspaces/edu_folder_open.png images/workspaces/edu_forum.gif images/workspaces/edu_group.gif images/workspaces/edu_group.jpg images/workspaces/edu_group_add.gif images/workspaces/edu_group_new.gif images/workspaces/edu_group_remove.gif images/workspaces/edu_imagegallery.gif images/workspaces/edu_nav_down.gif images/workspaces/edu_nav_left.gif images/workspaces/edu_nav_right.gif images/workspaces/edu_nav_up.gif images/workspaces/edu_paste.gif images/workspaces/edu_quiz.gif images/workspaces/edu_stop.gif images/workspaces/edu_structure.gif images/workspaces/edu_user_new.gif images/workspaces/edu_wikipage.gif images/workspaces/edu_workspace.gif images/workspaces/edu_workspace.png images/workspaces/edu_workspaceActive.png images/workspaces/edu_workspaceActiveFOLDER.png images/workspaces/edu_workspaceFOLDER.png images/workspaces/edu_workspaceInactive.png images/workspaces/edu_workspaces.png images/workspaces/edu_workspace_grey.png images/workspaces/edu_workspace_inactive.png images/workspaces/user_blue.gif images/workspaces/user_red.gif images/workspaces/page.gif images/workspaces/pageNueva.gif images/workspaces/edu_zones.png images/workspaces/edu_zones_add.png images/workspaces/edu_zones_edit.png images/workspaces/edu_zones_remove.png images/workspaces/module.png images/workspaces/module_add.png images/workspaces/module_edit.png images/workspaces/module_remove.png images/workspaces/redarrow.gif images/workspaces/grayarrow.gif images/workspaces/info.png images/workspaces/edu_role.gif lib/aulawiki/assignmentslib.php lib/workspaces/resourceslib.php lib/workspaces/userlib.php lib/aulawiki/periodslib.php lib/workspaces/printlib.php lib/workspaces/roleslib.php lib/workspaces/workspacelib.php lib/workspaces/workspacemoduleslib.php lib/workspaces/typeslib.php lib/smarty_tiki/function.edumenu.php lib/smarty_tiki/block.tiki_workspaces_module.php lib/smarty_tiki/block.ws_help.php lib/smarty_tiki/function.workspaces_menu.php styles/workspaces.css styles/workspaces/index.php styles/workspaces/options/index.php styles/workspaces/options/wider_left_column.css templates/tiki-workspaces_blog.tpl templates/tiki-workspaces_objectpermissions.tpl templates/aulawiki-assignments_admin.tpl templates/tiki-workspaces_copy_to_clipboard.tpl templates/tiki-workspaces_help.tpl templates/tiki-workspaces_list_resources.tpl templates/tiki-workspaces_module.tpl templates/tiki-workspaces_module_error.tpl templates/tiki-workspaces_menu.tpl templates/tiki-workspaces_print.tpl templates/tiki-workspaces_print_page.tpl templates/tiki-workspaces_resource_types.tpl templates/tiki-workspaces_roles.tpl templates/tiki-workspaces_structure_tree.tpl templates/aulawiki-view_gradebook.tpl templates/aulawiki-view_gradebook_xml.tpl templates/tiki-workspaces_view_module.tpl templates/tiki-workspaces_admin.tpl templates/tiki-workspaces_desktop.tpl templates/tiki-workspaces_types.tpl templates/tiki-workspaces_types_resources.tpl templates/tiki-workspaces_types_roles.tpl templates/tiki-workspaces_zones.tpl templates/tiki-workspaces_assigned_modules.tpl templates/modules/mod-workspaces_assistant.tpl templates/modules/mod-aulawiki_assignments.tpl templates/modules/mod-workspaces_break.tpl templates/modules/mod-workspaces_calendar.tpl templates/modules/mod-workspaces_calendar.tpl.nocache templates/modules/mod-workspaces_childs.tpl templates/modules/mod-workspaces_clipboard.tpl templates/modules/mod-workspaces_clipboard.tpl.nocache templates/modules/mod-workspaces_last_blog_posts.tpl templates/modules/mod-workspaces_last_blog_posts.tpl.nocache templates/modules/mod-workspaces_last_files.tpl templates/modules/mod-workspaces_last_image.tpl templates/modules/mod-workspaces_list_resources.tpl templates/modules/mod-workspaces_my.tpl templates/modules/mod-workspaces_my.tpl.nocache templates/modules/mod-workspaces_resources.tpl templates/modules/mod-workspaces_resources.tpl.nocache templates/modules/mod-workspaces_user_groups.tpl templates/modules/mod-workspaces_user_groups.tpl.nocache templates/modules/mod-workspaces_owner.tpl templates/modules/mod-workspaces_owner.tpl.nocache templates/modules/mod-workspaces_viewpage.tpl templates/modules/mod-workspaces_viewstructure.tpl templates/modules/mod-aulawiki_view_assignment.tpl templates/modules/mod-workspaces_who_is_there.tpl templates/modules/mod-workspaces_who_is_there.tpl.nocache templates/styles/workspaces/index.php templates/styles/workspaces/tiki-user_edumenu.tpl templates/styles/workspaces/tiki-user_information.tpl templates/styles/workspaces/tiki-user_preferences.tpl modules/mod-aulawiki_assignments.php modules/mod-workspaces_calendar.php modules/mod-workspaces_childs.php modules/mod-workspaces_clipboard.php modules/mod-workspaces_last_blog_posts.php modules/mod-workspaces_last_files.php modules/mod-workspaces_last_image.php modules/mod-workspaces_list_resources.php modules/mod-workspaces_my.php modules/mod-workspaces_resources.php modules/mod-workspaces_user_groups.php modules/mod-workspaces_owner.php modules/mod-workspaces_viewpage.php modules/mod-workspaces_viewstructure.php modules/mod-aulawiki_view_assignment.php modules/mod-workspaces_who_is_there.php modules/conf/modconf-workspaces_calendar.php modules/conf/modconf-workspaces_childs.php modules/conf/modconf-workspaces_clipboard.php modules/conf/modconf-workspaces_last_blog_posts.php modules/conf/modconf-workspaces_last_files.php modules/conf/modconf-workspaces_last_image.php modules/conf/modconf-workspaces_list_resources.php modules/conf/modconf-workspaces_resources.php modules/conf/modconf-workspaces_user_groups.php modules/conf/modconf-workspaces_owner.php modules/conf/modconf-workspaces_viewpage.php modules/conf/modconf-workspaces_viewstructure.php |
lastmodif | 2010-01-14 10:11:22 |
licence | GNU/LGPL |
modname | features-aulawiki_tiki_4 |
name | aulawiki_tiki_4 |
revision | 4.0.0 |
sql_install | DROP TABLE IF EXISTS `tiki_workspace_role_wstype`; DROP TABLE IF EXISTS `tiki_workspace_roles`; DROP TABLE IF EXISTS `tiki_workspaces`; DROP TABLE IF EXISTS `tiki_workspace_modules`; DROP TABLE IF EXISTS `tiki_workspace_types`; DROP TABLE IF EXISTS `tiki_workspace_zones`; DROP TABLE IF EXISTS `aulawiki_assignment`; DROP TABLE IF EXISTS `aulawiki_gradebook`; DROP TABLE IF EXISTS `aulawiki_period`; DROP TABLE IF EXISTS `aulawiki_period_type`; CREATE TABLE `tiki_workspace_role_wstype` (`roleName` varchar(250) NOT NULL default '0',`typeId` int(14) NOT NULL default '0',`wstypePermGroup` varchar(250) default NULL, PRIMARY KEY (`typeId`,`roleName`)) TYPE=MyISAM; CREATE TABLE `tiki_workspace_roles` (`name` varchar(100) NOT NULL default '',`uid` varchar(100) NOT NULL default '',`permgroup` varchar(250) default NULL,`description` varchar(250) NOT NULL default '', PRIMARY KEY (`name`)) TYPE=MyISAM; CREATE TABLE `tiki_workspaces` (`workspaceId` int(14) NOT NULL auto_increment, `code` varchar(100) NOT NULL default '',`name` varchar(100) NOT NULL default '',`description` varchar(250) default '',`created` int(14) default '0',`startDate` int(14) default '0',`endDate` int(14) default '0',`closed` char(1) NOT NULL default 'y',`type` int(14) NOT NULL default '0',`parentId` int(14) NOT NULL default '0',`uid` varchar(100) NOT NULL default '',`owner` varchar(100) default '',`isuserws` char(1) NOT NULL default '',`hide` char(1) NOT NULL default '',`categoryId` int(12) NOT NULL default '0', PRIMARY KEY (`workspaceId`)) TYPE=MyISAM; CREATE TABLE `tiki_workspace_modules` (`moduleId` int(10) NOT NULL auto_increment,`name` varchar(200) NOT NULL default '',`position` char(1) default NULL,`ord` int(4) default NULL,`zoneId` int(11) NOT NULL default '0',`title` varchar(255) default NULL,`cache_time` int(14) default NULL,`rows` int(4) default NULL,`params` text,`groups` text,`style_data` varchar(150) default NULL,`style_title` varchar(150) default NULL, `uid` varchar(100) NOT NULL default '', PRIMARY KEY (`moduleId`)) TYPE=MyISAM; CREATE TABLE `tiki_workspace_types` (`wstypeId` int(14) NOT NULL auto_increment,`code` varchar(100) NOT NULL default '',`name` varchar(100) NOT NULL default '',`description` varchar(100) NOT NULL default '',`uid` varchar(100) NOT NULL default '',`menuid` int(8) NOT NULL default '0',`resources` text NOT NULL,`userwstype` int(14) NOT NULL default '0',`hide` char(1) NOT NULL default '',`active` char(1) NOT NULL default '', PRIMARY KEY (`wstypeId`)) TYPE=MyISAM; CREATE TABLE tiki_workspace_zones (`zoneId` int(11) NOT NULL auto_increment,`name` varchar(100) NOT NULL default '',`description` varchar(100) NOT NULL default '',`workspaceId` int(14) NOT NULL,`type` varchar(100) NOT NULL default '',`ord` int(4) NOT NULL default '0',`uid` varchar(100) NOT NULL default '', PRIMARY KEY (`zoneId`)) TYPE=MyISAM; CREATE TABLE `aulawiki_assignment` (`assignmentId` int(14) NOT NULL auto_increment,`workspaceId` int(14) NOT NULL default '0',`periodId` int(14) NOT NULL default '0',`gradeWeight` int(5) NOT NULL default '0',`name` varchar(150) NOT NULL default '',`description` varchar(250) NOT NULL default '',`wikipage` varchar(100) NOT NULL default '',`createdby` varchar(100) NOT NULL default '',`creationDate` int(14) NOT NULL default '0',`startDate` int(14) NOT NULL default '0',`uid` varchar(100) NOT NULL default '',`type` int(11) NOT NULL default '0',`endDate` int(14) NOT NULL default '0', PRIMARY KEY (`assignmentId`)) TYPE=MyISAM; CREATE TABLE `aulawiki_gradebook` (`assignmentId` int(14) NOT NULL default '0',`userId` varchar(100) NOT NULL default '',`comment` varchar(250) NOT NULL default '',`grade` int(4) NOT NULL default '0') TYPE=MyISAM; CREATE TABLE `aulawiki_period` (`periodId` int(5) NOT NULL auto_increment,`periodTypeId` int(5) default '0',`name` varchar(100) NOT NULL default '',`description` varchar(100) default '',`startDate` int(11) NOT NULL default '0',`endDate` int(14) NOT NULL default '0',`uid` varchar(100) NOT NULL default '',`gradeWeight` int(14) NOT NULL default '50', PRIMARY KEY (`periodId`)) TYPE=MyISAM; CREATE TABLE `aulawiki_period_type` (`periodTypeId` int(14) NOT NULL auto_increment,`name` varchar(100) NOT NULL default '',`description` varchar(250) NOT NULL default '', PRIMARY KEY (`periodTypeId`)) TYPE=MyISAM; DELETE FROM tiki_menu_options WHERE url LIKE '%aulawiki%'; DELETE FROM tiki_menus WHERE menuid=100 AND description LIKE '%AulaWiki%'; DELETE FROM tiki_menu_options WHERE url LIKE '%workspaces%'; DELETE FROM tiki_menus WHERE menuid=100 AND description LIKE '%workspace%'; DELETE FROM `users_permissions` WHERE `permName` LIKE 'aulawiki_p_%'; DELETE FROM `users_permissions` WHERE `permName` LIKE '%workspace%'; DELETE FROM `tiki_preferences` WHERE name = 'feature_aulawiki'; DELETE FROM `tiki_preferences` WHERE name = 'feature_workspaces'; DELETE FROM `tiki_modules` WHERE `name` LIKE '%aulawiki%'; DELETE FROM `tiki_user_assigned_modules` WHERE `name` LIKE '%aulawiki%'; DELETE FROM `tiki_modules` WHERE `name` LIKE '%aulawiki%'; DELETE FROM `tiki_modules` WHERE `name` LIKE '%workspaces%'; INSERT INTO `tiki_workspace_roles` (`name`,`uid`,`permgroup`,`description`) VALUES ('Teacher', '2fd99c1c873d19ee003a5bde9b832607', 'RolePerms-Teacher', 'Teacher'); INSERT INTO `tiki_workspace_roles` (`name`,`uid`,`permgroup`,`description`) VALUES ('Student', '9d94a9b153bc6e7a162262b109ce3829', 'RolePerms-Student', 'Student'); INSERT INTO `tiki_workspace_roles` (`name`,`uid`,`permgroup`,`description`) VALUES ('Owner', 'cf658411eca2e230d90276c5a0235a1b', 'RolePerms-Owner', 'Portfolio owner'); INSERT INTO `tiki_workspace_roles` (`name`,`uid`,`permgroup`,`description`) VALUES ('Registered', 'a671a29eef794f7423ae567f7d964d42', 'Registered', 'Registered users'); INSERT INTO `tiki_workspace_roles` (`name`,`uid`,`permgroup`,`description`) VALUES ('Anonymous', '77f08d9b1ee1a29d11aabefbeca5d1e5', 'Anonymous', 'Anonymous users'); DELETE FROM `users_groups` WHERE `groupName`='RolePerms-Teacher'; DELETE FROM `users_groups` WHERE `groupName`='RolePerms-Student'; DELETE FROM `users_groups` WHERE `groupName`='RolePerms-Owner'; DELETE FROM `users_groups` WHERE `groupName`='ROLEGRPTeacher'; DELETE FROM `users_groups` WHERE `groupName`='ROLEGRPStudent'; DELETE FROM `users_groups` WHERE `groupName`='ROLEGRPOwner'; INSERT INTO `users_groups` (groupName,groupDesc) VALUES ('RolePerms-Teacher', 'Teacher role permissions template'); INSERT INTO `users_groups` (groupName,groupDesc) VALUES ('RolePerms-Student', 'Student role permissions template'); INSERT INTO `users_groups` (groupName,groupDesc) VALUES ('RolePerms-Owner', 'Owner role permissions template'); INSERT INTO `users_groups` (groupName,groupDesc) VALUES ('ROLEGRPTeacher', 'Teacher role group'); INSERT INTO `users_groups` (groupName,groupDesc) VALUES ('ROLEGRPStudent', 'Student role group'); INSERT INTO `users_groups` (groupName,groupDesc) VALUES ('ROLEGRPOwner', 'Owner role group'); INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('aulawiki_p_admin_assignments','Can admin assignments','admin','assignments','NULL'); INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('aulawiki_p_view_assignments','Can view assignments','basic','assignments',''); INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('aulawiki_p_edit_assignments','Can edit existing assignments','editors','assignments',''); INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('aulawiki_p_create_assignments','Can create new assignments','editors','assignments',''); INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('aulawiki_p_remove_assignments','Can remove assignments','admin','assignments',''); INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('tiki_p_view_workspace','Can view a workspace','basic','workspace',''); INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('tiki_p_admin_workspace','Can admin workspaces','admin','workspace',''); INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('tiki_p_create_workspace_resour','Can create new workspace resources','editors','workspace',''); INSERT INTO tiki_menus (menuId, name, description, type, icon) VALUES (100,'Workspace menu','Sample workspace menu','d', ''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'s','Workspaces','./tiki-workspaces_admin.php',1020,'','tiki_p_admin_workspace',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Admin Workspaces','./tiki-workspaces_admin.php',1022,'','tiki_p_admin_workspace',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Workspace Types','./tiki-workspaces_types.php',1024,'','tiki_p_admin_workspace',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Admin Roles','./tiki-workspaces_roles.php',1026,'','tiki_p_admin_workspace',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Users/Groups','./tiki-workspaces_view_module.php?module=workspaces_user_groups',10,'','',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Resources','./tiki-workspaces_view_module.php?module=workspaces_resources',52,'','',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Blogs list','tiki-workspaces_view_module.php?module=workspaces_list_resources&type=blog',60,'','',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Img galeries','tiki-workspaces_view_module.php?module=workspaces_list_resources&type=image gallery',70,'','',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','File galleries','tiki-workspaces_view_module.php?module=workspaces_list_resources&type=file gallery',71,'','',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Wiki Pages','tiki-workspaces_view_module.php?module=workspaces_list_resources&type=wiki page',72,'','',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Forums','tiki-workspaces_view_module.php?module=workspaces_list_resources&type=forum',73,'','',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Calendars','tiki-workspaces_view_module.php?module=workspaces_list_resources&type=calendar',74,'','',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','History','./tiki-workspaces_get_resource.php?name=History',80,'','',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Gradebook','./aulawiki-view_gradebook.php',1,'','',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Assignments','./aulawiki-assignments_admin.php',41,'','',''); INSERT INTO tiki_preferences (name,value) VALUES ( 'feature_workspaces', 'y'); INSERT INTO tiki_workspace_types VALUES ('1','PORTFOLIO','Portfolio','','f6dfa6643939c4887a68710a5b8c27b5','100','a:2:{i:0;a:3:{s:4:"name";s:6:"MyBlog";s:4:"desc";s:7:"My Blog";s:4:"type";s:4:"blog";}i:1;a:3:{s:4:"name";s:4:"Home";s:4:"desc";s:19:"Home portfolio page";s:4:"type";s:9:"wiki page";}}','0','n','y'); INSERT INTO tiki_workspace_types VALUES ('2','COURSE','Course','Sample course type','bcff9b0c6b65e3d060685650d3e6b6e1','100','a:5:{i:0;a:3:{s:4:"name";s:4:"Home";s:4:"desc";s:16:"Home course page";s:4:"type";s:9:"wiki page";}i:1;a:3:{s:4:"name";s:7:"History";s:4:"desc";s:12:"History blog";s:4:"type";s:4:"blog";}i:2;a:3:{s:4:"name";s:5:"Files";s:4:"desc";s:12:"Course files";s:4:"type";s:12:"file gallery";}i:3;a:3:{s:4:"name";s:6:"Images";s:4:"desc";s:13:"Course images";s:4:"type";s:13:"image gallery";}i:4;a:3:{s:4:"name";s:5:"Forum";s:4:"desc";s:12:"Course forum";s:4:"type";s:5:"forum";}}','3','n','y'); INSERT INTO tiki_workspace_types VALUES ('3','PERSONAL','Personal workspace type','Sample personal workspace','dcd9e72f70d04fa9399db80a3fa056d8','100','a:2:{i:0;a:3:{s:4:"name";s:7:"History";s:4:"desc";s:12:"History blog";s:4:"type";s:4:"blog";}i:1;a:3:{s:4:"name";s:4:"Home";s:4:"desc";s:18:"Personal home page";s:4:"type";s:9:"wiki page";}}','0','y','y'); INSERT INTO tiki_workspace_types VALUES ('4','FOLDER','Folder','','9e39b5e9a566a61ce60417a9429ff0f0','0','a:1:{i:0;s:8:"wikipage";}','0','','y'); INSERT INTO tiki_workspace_types VALUES ('5','GROUP','Student group','','b4a6f4eef0d1e1111d568b50195b45e0','100','a:2:{i:0;a:3:{s:4:"name";s:4:"Home";s:4:"desc";s:15:"Group home page";s:4:"type";s:9:"wiki page";}i:1;a:3:{s:4:"name";s:7:"History";s:4:"desc";s:10:"Group blog";s:4:"type";s:4:"blog";}}','0','y','y'); INSERT INTO tiki_workspace_zones VALUES (1,'main','main zone',1,'workspace type',1,'ade0ff330c3ebb57865e34c2ce476c39'); INSERT INTO tiki_workspace_zones VALUES (2,'main','main zone',2,'workspace type',1,'ade0ff330c3ebb57865e34c2ce476c40'); INSERT INTO tiki_workspace_zones VALUES (3,'main','main zone',3,'workspace type',1,'ade0ff330c3ebb57865e34c2ce476c41'); INSERT INTO tiki_workspace_zones VALUES (5,'main','main zone',5,'workspace type',1,'ade0ff330c3ebb57865e34c2ce476c43'); INSERT INTO tiki_workspace_modules VALUES ('1','workspaces_last_blog_posts','2','3',1,'My Blog','0','0','name=%WSCODE%-MyBlog','','','','68809e75ced4d1f52bec9eb73bc32cdc'); INSERT INTO tiki_workspace_modules VALUES ('2','workspaces_viewpage','1','1',1,'Portfolio Home','0','0','name=%WSCODE%-Home','','','','6ac0bc2518a0c836de87662defbada90'); INSERT INTO tiki_workspace_modules VALUES ('3','workspaces_who_is_there','2','1',2,'Course users','0','0','','','','','cbbbb0122cb4aca6c83859cda85bdecd'); INSERT INTO tiki_workspace_modules VALUES ('5','workspaces_last_blog_posts','1','3',2,'Course History','0','0','name=%WSCODE%-History&maxPosts=3&showBar=n','','','','da1d338b0fb3d87256341b4154ba96c5'); INSERT INTO tiki_workspace_modules VALUES ('6','workspaces_viewpage','2','1',3,'Home page','0','0','name=%WSCODE%-Home','','','','1f1b76a1f4dff160d31ae36a11170ede'); INSERT INTO tiki_workspace_modules VALUES ('7','workspaces_last_blog_posts','2','5',3,'History','0','0','name=%WSCODE%-History','','','','ae744c4a52b38e5386c99ddc43edc8be'); INSERT INTO tiki_workspace_modules VALUES ('9','workspaces_last_files','3','11',2,'Course files','0','0','name=%WSCODE%-Files&maxFiles=3&showBar=y&','','','','ce32d51600a7f6b3f999be9ec467c5d7'); INSERT INTO tiki_workspace_modules VALUES ('10','workspaces_break','1','5',2,'','0','0','','','','','781330d16d490e7a88237e2aa1983ce1'); INSERT INTO tiki_workspace_modules VALUES ('19','workspaces_break','2','2',1,'','0','0','','','','','b0678bf202e5b4417bb6fdcae969626e'); INSERT INTO tiki_workspace_modules VALUES ('17','workspaces_last_image','3','15',2,'Images','0','0','name=%WSCODE%-Images&maxImages=3&showBar=y&','','','','f73d1e5f2a56721284d38eba1da56de0'); INSERT INTO tiki_workspace_modules VALUES ('15','workspaces_calendar','2','6',2,'Course calendar','0','0','','','','','7126d03da3815b92f80feef1e8598ddb'); INSERT INTO tiki_workspace_modules VALUES ('14','workspaces_childs','2','5',2,'Child workspaces','0','0','','','','','e4604c1cea8879a11425ebcae8aab4d1'); INSERT INTO tiki_workspace_modules VALUES ('16','workspaces_viewpage','1','10',2,'View page','0','0','name=%WSCODE%-Home&showBar=y','','','','a91e337ce2b81ce208523635e1471faa'); INSERT INTO tiki_workspace_modules VALUES ('22','workspaces_owner','1','1',3,'Workspace owner','0','0','showName=y&showWorkspaces=y','','','','017e28f378066a9c8c6d2a66f435f3cd'); INSERT INTO tiki_workspace_modules VALUES ('20','workspaces_owner','2','1',1,'Workspace owner','0','0','showName=y&showWorkspaces=y','','','','b162f68536c92a270150ae475bd8308f'); INSERT INTO tiki_workspace_modules VALUES ('28','workspaces_viewpage','1','1',5,'View page','0','0','name=%WSCODE%-Home&showBar=y','','','','40ca0c9474d974dba3e73ff3fc9db3a7'); INSERT INTO tiki_workspace_modules VALUES ('29','workspaces_last_blog_posts','1','2',5,'Blog','0','0','name=%WSCODE%-History&maxPosts=5&showBar=y&','','','','a8fa9590762ec2cceee9934378631b3b'); INSERT INTO tiki_workspace_role_wstype VALUES ('Owner','1',''); INSERT INTO tiki_workspace_role_wstype VALUES ('Student','2',''); INSERT INTO tiki_workspace_role_wstype VALUES ('Teacher','2',''); INSERT INTO tiki_workspace_role_wstype VALUES ('Owner','3',''); INSERT INTO tiki_workspace_role_wstype VALUES ('Teacher','3',''); INSERT INTO tiki_workspace_role_wstype VALUES ('Teacher','5',''); INSERT INTO tiki_workspace_role_wstype VALUES ('Student','5',''); INSERT INTO tiki_workspace_role_wstype VALUES ('Registered','2',''); INSERT INTO tiki_workspace_role_wstype VALUES ('Anonymous','2',''); INSERT INTO tiki_modules (name,position,ord,cache_time,groups) VALUES ('workspaces_assistant','r',9,0,'a:2:{i:0;s:10:"Registered";i:1;s:9:"Anonymous";}'); |
sql_remove | DELETE FROM tiki_menu_options WHERE url LIKE '%aulawiki%'; DELETE FROM tiki_menus WHERE menuid=100 AND description LIKE '%AulaWiki%'; DELETE FROM tiki_menu_options WHERE url LIKE '%workspaces%'; DELETE FROM tiki_menus WHERE menuid=100 AND description LIKE '%workspace%'; DELETE FROM `users_permissions` WHERE `permName` LIKE 'aulawiki_p_%'; DELETE FROM `users_permissions` WHERE `permName` LIKE '%workspace%'; DELETE FROM `tiki_preferences` WHERE name = 'feature_aulawiki'; DELETE FROM `tiki_modules` WHERE `name` LIKE '%aulawiki%'; DELETE FROM `tiki_user_assigned_modules` WHERE `name` LIKE '%aulawiki%'; DELETE FROM `tiki_modules` WHERE `name` LIKE '%aulawiki%'; DELETE FROM `tiki_modules` WHERE `name` LIKE '%workspaces%'; DROP TABLE IF EXISTS `aulawiki_assignment`; DROP TABLE IF EXISTS `aulawiki_gradebook`; DROP TABLE IF EXISTS `aulawiki_period`; DROP TABLE IF EXISTS `aulawiki_period_type`; DROP TABLE IF EXISTS `tiki_workspace_role_wstype`; DROP TABLE IF EXISTS `tiki_workspace_roles`; DROP TABLE IF EXISTS `tiki_workspaces`; DROP TABLE IF EXISTS `tiki_workspace_modules`; DROP TABLE IF EXISTS `tiki_workspace_types`; DROP TABLE IF EXISTS `tiki_workspace_zones`; |
sql_upgrade | DELETE FROM tiki_menus WHERE menuid=100 AND description LIKE '%AulaWiki%'; DELETE FROM `users_grouppermissions` WHERE `permName`='tiki_p_admin_workspaces_roles'; ALTER TABLE tiki_workspace_types CHANGE `id` `wstypeId` int(14) NOT NULL auto_increment; DELETE FROM tiki_menu_options WHERE menuid=42 AND position=1020; Array Array |
type | features |
version | 4.1 |