<?xml version="1.0" encoding="utf-8"?>
<versions>
<version>
<number>1.0.1</number>
<queries></queries>
</version>
<version>
<number>1.0.2</number>
<queries></queries>
</version>
<version>
<number>1.0.3</number>
<queries>
<query><![CDATA[
INSERT IGNORE {PREFIX}settings (id ,field ,value) VALUES (41 , 'default_language', 'eng')
]]>
</query>
</queries>
</version>
<version>
<number>1.0.4</number>
<queries>
<query> <![CDATA[
INSERT IGNORE {PREFIX}settings (id, field, value) VALUES (43, 'disable_registration', '0'), (44,
'time_format', '12h'), (45, 'date_format', 'F j \\a\\t g:ia'), (46, 'logo', ''), (47, 'hide_admin_link',
'0'), (48, 'admin_password', '')
]]>
</query>
</queries>
</version>
<version>
<number>1.1.0</number>
<queries>
<query> <![CDATA[
INSERT IGNORE {PREFIX}settings (id, field, value) VALUES (49, 'recently_joined', '1'), (50,
'featured_members', '1'), (51, 'select_language', '1'), (52, 'analytics_code', '')
]]>
</query>
<query><![CDATA[
ALTER TABLE {PREFIX}users ADD username VARCHAR( 64 ) COLLATE utf8_unicode_ci NOT NULL, ADD about TEXT
COLLATE utf8_unicode_ci NOT NULL, ADD featured tinyint(1) unsigned NOT NULL DEFAULT '0', ADD INDEX
(username)
]]>
</query>
<query><![CDATA[
ALTER TABLE {PREFIX}events ADD address VARCHAR( 256 ) COLLATE utf8_unicode_ci NOT NULL;
]]>
</query>
<query><![CDATA[ ALTER TABLE {PREFIX}notifications ADD action VARCHAR( 32 ) COLLATE utf8_unicode_ci NOT NULL AFTER
text, ADD params TEXT COLLATE utf8_unicode_ci NOT NULL;
]]>
</query>
<query><![CDATA[ ALTER TABLE {PREFIX}groups ADD topic_count smallint(5) unsigned NOT NULL DEFAULT '0', ADD video_count
smallint(5) unsigned NOT NULL DEFAULT '0', ADD event_count smallint(5) unsigned NOT NULL DEFAULT '0'
]]>
</query>
<query><![CDATA[
ALTER TABLE {PREFIX}topics ADD group_id int(10) unsigned NOT NULL, ADD INDEX (group_id)
]]>
</query>
<query><![CDATA[
ALTER TABLE {PREFIX}videos ADD group_id int(10) unsigned NOT NULL, ADD INDEX (group_id)
]]>
</query>
<query><![CDATA[
ALTER TABLE {PREFIX}activities ADD params TEXT COLLATE utf8_unicode_ci NOT NULL
]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}admin_notifications` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL,
`created` datetime NOT NULL,
`text` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`message` text COLLATE utf8_unicode_ci NOT NULL,
`url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`read` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
]]>
</query>
</queries>
</version>
<version>
<number>1.1.1</number>
<queries>
<query> <![CDATA[
INSERT IGNORE {PREFIX}settings (id ,field ,value) VALUES (53 , 'registration_notify', '0')
]]>
</query>
<query><![CDATA[ ALTER TABLE {PREFIX}users ADD lang VARCHAR( 4 ) COLLATE utf8_unicode_ci NOT NULL
]]></query>
<query><![CDATA[ ALTER TABLE {PREFIX}activities ADD like_count smallint(5) unsigned NOT NULL DEFAULT '0'
]]></query>
<query><![CDATA[ ALTER TABLE {PREFIX}activity_comments ADD like_count smallint(5) unsigned NOT NULL DEFAULT '0'
]]>
</query>
<query><![CDATA[ ALTER TABLE {PREFIX}comments ADD like_count smallint(5) unsigned NOT NULL DEFAULT '0'
]]></query>
</queries>
</version>
<version>
<number>1.2.0</number>
<queries>
<query><![CDATA[ CREATE TABLE IF NOT EXISTS `{PREFIX}themes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`key` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`core` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
]]>
</query>
<query> <![CDATA[
INSERT IGNORE {PREFIX}themes (`id`, `key`, `name`, `core`) VALUES (1, 'light', 'Light Theme', 1)
]]>
</query>
<query> <![CDATA[
INSERT IGNORE {PREFIX}themes (`id`, `key`, `name`, `core`) VALUES (2, 'blue', 'Blue Theme', 1)
]]>
</query>
<query> <![CDATA[
INSERT IGNORE {PREFIX}settings (id ,field ,value) VALUES (54 , 'hide_activites', '0')
]]>
</query>
<query><![CDATA[ ALTER TABLE {PREFIX}topics ADD pinned tinyint(1) unsigned NOT NULL DEFAULT '0'
]]></query>
</queries>
</version>
<version>
<number>1.2.1</number>
<queries>
<query> <![CDATA[
INSERT IGNORE {PREFIX}settings (id ,field ,value) VALUES (55, 'username_change', '1')
]]>
</query>
</queries>
</version>
<version>
<number>1.2.2</number>
<queries>
<query> <![CDATA[
INSERT IGNORE {PREFIX}settings (id ,field ,value) VALUES (57, 'save_original_image', '0'), (58,
'mail_transport', 'Mail'), (59, 'smtp_host', 'localhost'), (60, 'smtp_username', ''), (61,
'smtp_password', '')
]]>
</query>
<query><![CDATA[ ALTER TABLE {PREFIX}users ADD hide_online tinyint(1) unsigned NOT NULL DEFAULT '0'
]]></query>
<query><![CDATA[ ALTER TABLE {PREFIX}events ADD category_id smallint(5) unsigned NOT NULL DEFAULT '0', ADD INDEX
(category_id)
]]></query>
<query> <![CDATA[
INSERT IGNORE {PREFIX}categories (type, name, description, item_count, active, weight) VALUES
('event', 'Default Category', '', 0, 1, 0)
]]>
</query>
<query><![CDATA[ ALTER TABLE {PREFIX}photos ADD original VARCHAR( 256 ) COLLATE utf8_unicode_ci NOT NULL
]]></query>
</queries>
</version>
<version>
<number>1.2.3</number>
<queries>
<query><![CDATA[ ALTER TABLE {PREFIX}profile_fields ADD profile tinyint(1) unsigned NOT NULL DEFAULT '1'
]]></query>
<query><![CDATA[ ALTER TABLE {PREFIX}users ADD cover VARCHAR( 256 ) COLLATE utf8_unicode_ci NOT NULL
]]></query>
<query><![CDATA[ ALTER TABLE {PREFIX}albums ADD type VARCHAR( 50 ) COLLATE utf8_unicode_ci NOT NULL
]]></query>
</queries>
</version>
<version>
<number>1.3.0</number>
<queries>
<query><![CDATA[ ALTER TABLE {PREFIX}albums ADD dislike_count smallint(5) unsigned NOT NULL DEFAULT '0'
]]></query>
<query><![CDATA[ ALTER TABLE {PREFIX}blogs ADD dislike_count smallint(5) unsigned NOT NULL DEFAULT '0'
]]></query>
<query><![CDATA[ ALTER TABLE {PREFIX}activities ADD dislike_count smallint(5) unsigned NOT NULL DEFAULT '0'
]]></query>
<query><![CDATA[ ALTER TABLE {PREFIX}activity_comments ADD dislike_count smallint(5) unsigned NOT NULL DEFAULT '0'
]]></query>
<query><![CDATA[ ALTER TABLE {PREFIX}comments ADD dislike_count smallint(5) unsigned NOT NULL DEFAULT '0'
]]></query>
<query><![CDATA[ ALTER TABLE {PREFIX}photos ADD dislike_count smallint(5) unsigned NOT NULL DEFAULT '0'
]]></query>
<query><![CDATA[ ALTER TABLE {PREFIX}topics ADD dislike_count smallint(5) unsigned NOT NULL DEFAULT '0'
]]></query>
<query><![CDATA[ ALTER TABLE {PREFIX}videos ADD dislike_count smallint(5) unsigned NOT NULL DEFAULT '0'
]]></query>
<query><![CDATA[ ALTER TABLE {PREFIX}likes ADD thumb_up tinyint(1) unsigned NOT NULL DEFAULT '1'
]]></query>
<query><![CDATA[ ALTER TABLE {PREFIX}groups ADD featured tinyint(1) unsigned NOT NULL DEFAULT '0'
]]></query>
<query><![CDATA[ INSERT IGNORE {PREFIX}themes (`key`, `name`, `core`) VALUES ('mobile', 'Mobile Theme', 1) ]]></query>
<query><![CDATA[ INSERT IGNORE {PREFIX}settings (field ,value) VALUES ('num_new_members', '10'),
('num_friend_suggestions', '2'), ('friend_birthdays', '0'), ('restricted_usernames', ''),
('enable_registration_code', '0'), ('registration_code', ''), ('languages', 'eng=English')
]]>
</query>
<query><![CDATA[ DELETE FROM {PREFIX}notifications WHERE user_id = 0
]]></query>
</queries>
</version>
<version>
<number>1.3.1</number>
</version>
<version>
<number>1.3.2</number>
<queries>
<query><![CDATA[ ALTER TABLE {PREFIX}topics ADD locked tinyint(1) unsigned NOT NULL DEFAULT '0'
]]></query>
<query> <![CDATA[
INSERT IGNORE {PREFIX}settings (field ,value) VALUES ('smtp_port', ''), ('google_dev_key', '')
]]>
</query>
</queries>
</version>
<version>
<number>1.3.3</number>
</version>
<version>
<number>2.0.0</number>
<queries>
<query><![CDATA[ CREATE TABLE IF NOT EXISTS `{PREFIX}acos` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`group` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`key` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`description` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `group` (`group`,`key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
]]>
</query>
<query><![CDATA[
INSERT IGNORE `{PREFIX}acos` (`group`, `key`, `description`) VALUES
('user', 'username', 'Select username'),
('blog', 'view', 'View blog entry'),
('blog', 'create', 'Create/Edit blog entry'),
('album', 'create', 'Create/Edit photo album'),
('album', 'view', 'View photo album'),
('event', 'create', 'Create/Edit event'),
('event', 'view', 'View event'),
('group', 'create', 'Create/Edit group'),
('group', 'view', 'View group'),
('photo', 'upload', 'Upload photos'),
('photo', 'view', 'View photo'),
('topic', 'create', 'Create/Edit topic'),
('topic', 'view', 'View topic'),
('video', 'share', 'Share video'),
('video', 'view', 'View video'),
('attachment', 'upload', 'Upload attachment'),
('attachment', 'download', 'Download attachment');
]]>
</query>
<query><![CDATA[ CREATE TABLE IF NOT EXISTS `{PREFIX}attachments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`plugin_id` int(10) unsigned NOT NULL,
`target_id` int(10) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`filename` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`original_filename` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`extension` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
`created` datetime NOT NULL,
`downloads` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `plugin_id` (`plugin_id`,`target_id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
]]>
</query>
<query><![CDATA[ CREATE TABLE IF NOT EXISTS `{PREFIX}hooks` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`key` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`controller` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`action` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`position` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`weight` smallint(6) NOT NULL DEFAULT '0',
`enabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
`version` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
`settings` text COLLATE utf8_unicode_ci NOT NULL,
`permission` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key` (`key`),
KEY `controller` (`controller`),
KEY `action` (`action`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
]]>
</query>
<query><![CDATA[
INSERT IGNORE `{PREFIX}hooks` (`id`, `name`, `key`, `controller`, `action`, `position`, `weight`,
`enabled`, `version`, `settings`, `permission`) VALUES
(2, 'Featured Members', 'featured_members', 'home', 'index', 'home_sidebar', 6, 1, '2.0', 'a:0:{}', ''),
(16, 'Popular Blogs', 'popular_blogs', 'blogs', 'index', 'blogs_sidebar', 2, 1, '2.0',
'a:1:{s:9:"num_blogs";s:1:"5";}', ''),
(15, 'Popular Albums', 'popular_albums', 'photos', 'index', 'photos_sidebar', 3, 1, '2.0',
'a:1:{s:10:"num_albums";s:1:"5";}', ''),
(14, 'Today Birthdays', 'today_birthdays', 'home', 'index', 'home_sidebar', 4, 1, '2.0',
'a:1:{s:16:"friend_birthdays";s:1:"1";}', ''),
(12, 'Online Users', 'online_users', '', '', 'global_sidebar', 5, 1, '2.0',
'a:1:{s:16:"num_online_users";s:2:"12";}', ''),
(13, 'Recently Joined', 'recently_joined', 'home', 'index', 'home_sidebar', 7, 1, '2.0',
'a:1:{s:15:"num_new_members";s:2:"10";}', ''),
(17, 'Popular Events', 'popular_events', 'events', 'index', 'events_sidebar', 8, 1, '2.0',
'a:1:{s:10:"num_events";s:1:"5";}', ''),
(18, 'Popular Groups', 'popular_groups', 'groups', 'index', 'groups_sidebar', 9, 1, '2.0',
'a:1:{s:10:"num_groups";s:1:"5";}', ''),
(19, 'Popular Topics', 'popular_topics', 'topics', 'index', 'topics_sidebar', 10, 1, '2.0',
'a:1:{s:10:"num_topics";s:1:"5";}', ''),
(20, 'Popular Videos', 'popular_videos', 'videos', 'index', 'videos_sidebar', 11, 1, '2.0',
'a:1:{s:10:"num_videos";s:1:"5";}', ''),
(21, 'Friend Suggestions', 'friend_suggestions', '', '', 'global_sidebar', 12, 1, '2.0',
'a:1:{s:22:"num_friend_suggestions";s:1:"2";}', ''),
(22, 'Featured Groups', 'featured_groups', 'groups', 'index', 'groups_sidebar', 13, 1, '2.0', 'a:0:{}',
'');
]]>
</query>
<query><![CDATA[ CREATE TABLE IF NOT EXISTS `{PREFIX}languages` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`key` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key` (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
]]>
</query>
<query><![CDATA[ <![CDATA[ INSERT IGNORE `{PREFIX}languages` (`id`, `key`, `name`) VALUES (1, 'eng', 'English'); ]]></query>
<query><![CDATA[ CREATE TABLE IF NOT EXISTS `{PREFIX}pages` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
`alias` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`content` text COLLATE utf8_unicode_ci NOT NULL,
`permission` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
`params` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`menu` tinyint(1) unsigned NOT NULL DEFAULT '0',
`icon_class` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`weight` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `alias` (`alias`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
]]>
</query>
<query><![CDATA[ CREATE TABLE IF NOT EXISTS `{PREFIX}plugins` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`key` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`permission` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
`settings` text COLLATE utf8_unicode_ci NOT NULL,
`enabled` tinyint(1) unsigned NOT NULL DEFAULT '1',
`core` tinyint(1) unsigned NOT NULL,
`version` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
`weight` smallint(5) unsigned NOT NULL,
`menu` tinyint(1) unsigned NOT NULL DEFAULT '1',
`url` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
`icon_class` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key` (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
]]>
</query>
<query><![CDATA[
INSERT IGNORE `{PREFIX}plugins` (`id`, `name`, `key`, `permission`, `settings`, `enabled`, `core`,
`version`, `weight`, `menu`, `url`, `icon_class`) VALUES
(1, 'People', 'user', '', 'a:0:{}', 1, 1, '2.0', 1, 1, '/users', 'icon-user'),
(2, 'Blogs', 'blog', '', '', 1, 1, '2.0', 2, 1, '/blogs', 'icon-edit'),
(3, 'Photos', 'photo', '', '', 1, 1, '2.0', 3, 1, '/photos', 'icon-picture'),
(4, 'Videos', 'video', '', '', 1, 1, '2.0', 4, 1, '/videos', 'icon-facetime-video'),
(5, 'Topics', 'topic', '', '', 1, 1, '2.0', 5, 1, '/topics', 'icon-comments'),
(6, 'Groups', 'group', '', '', 1, 1, '2.0', 6, 1, '/groups', 'icon-group'),
(7, 'Events', 'event', '', '', 1, 1, '2.0', 7, 1, '/events', 'icon-calendar'),
(8, 'Conversations', 'conversation', '', '', 1, 1, '2.0', 8, 0, '', ''),
(9, 'Pages', 'page', '', '', 1, 1, '2.0', 9, 0, '', '');
]]>
</query>
<query><![CDATA[ CREATE TABLE IF NOT EXISTS `{PREFIX}roles` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`is_admin` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_super` tinyint(1) unsigned NOT NULL DEFAULT '0',
`params` text COLLATE utf8_unicode_ci NOT NULL,
`core` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
]]>
</query>
<query><![CDATA[
INSERT IGNORE `{PREFIX}roles` (`id`, `name`, `is_admin`, `is_super`, `params`, `core`) VALUES
(1, 'Super Admin', 1, 1,
'global_search,user_username,blog_view,blog_create,album_create,album_view,event_create,event_view,group_create,group_view,group_delete,photo_upload,photo_view,topic_create,topic_view,video_share,video_view,attachment_upload,attachment_download',
1),
(2, 'Member', 0, 0,
'global_search,user_username,blog_view,blog_create,album_create,album_view,event_create,event_view,group_create,group_view,photo_upload,photo_view,topic_create,topic_view,video_share,video_view,attachment_upload,attachment_download',
1),
(3, 'Guest', 0, 0,
'global_search,user_username,blog_view,blog_create,album_create,album_view,event_create,event_view,group_create,group_view,photo_upload,photo_view,topic_create,topic_view,video_share,video_view,attachment_upload,attachment_download',
1);
]]>
</query>
<query><![CDATA[ CREATE TABLE IF NOT EXISTS `{PREFIX}spam_challenges` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`question` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
`answers` text COLLATE utf8_unicode_ci NOT NULL,
`active` tinyint(1) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
]]>
</query>
<query><![CDATA[
INSERT IGNORE {PREFIX}settings (field ,value) VALUES ('timezone', '0'), ('enable_timezone_selection',
'1'), ('require_birthday', '1'), ('enable_spam_challenge', '0'), ('show_credit', '0'), ('name_change',
'1')
]]>
</query>
<query><![CDATA[ ALTER TABLE {PREFIX}categories ADD parent_id smallint(5) unsigned NOT NULL DEFAULT '0', ADD header
tinyint(1) unsigned NOT NULL DEFAULT '0', ADD create_permission varchar(256) COLLATE utf8_unicode_ci NOT
NULL, ADD INDEX (parent_id)
]]>
</query>
<query><![CDATA[ ALTER TABLE {PREFIX}topics ADD attachment tinyint(1) unsigned NOT NULL DEFAULT '0'</query>
<query><![CDATA[ ALTER TABLE {PREFIX}users CHANGE `timezone` `timezone` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE
utf8_unicode_ci NOT NULL
]]>
</query>
</queries>
</version>
<version>
<number>2.0.1</number>
<queries>
<query><![CDATA[ INSERT IGNORE {PREFIX}settings (field ,value) VALUES ('registration_message', '') ]]></query>
</queries>
</version>
<version>
<number>2.0.2</number>
<queries></queries>
</version>
<version>
<number>2.0.3</number>
<queries></queries>
</version>
<version>
<number>2.1.1</number>
<queries>
<query><![CDATA[ ALTER TABLE `{PREFIX}blogs` ADD `thumbnail` VARCHAR( 255 ) NOT NULL AFTER `body`;
]]></query>
<query><![CDATA[ ALTER TABLE `{PREFIX}topics` ADD `thumbnail` VARCHAR( 255 ) NOT NULL AFTER `body`; ]]></query>
<query><![CDATA[ CREATE TABLE IF NOT EXISTS `{PREFIX}core_blocks` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(75) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`path_view` varchar(75) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`params` text NOT NULL,
`is_active` tinyint(1) NOT NULL DEFAULT '1',
`plugin_id` int(11) NOT NULL,
`group` varchar(75) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`restricted` text NOT NULL,
PRIMARY KEY (`id`),
KEY `is_active` (`is_active`)
); ]]>
</query>
<query>
<![CDATA[
INSERT IGNORE INTO `{PREFIX}core_blocks` (`id`, `name`, `path_view`, `params`, `is_active`, `plugin_id`, `group`, `restricted`) VALUES
(1, 'Who''s Online', 'user.onlineUsers', '{"0":{"label":"Title","input":"text","value":"Who''s online","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'user', ''),
(4, 'Recently Joined', 'user.recentlyJoined', '{"0":{"label":"Title","input":"text","value":"Recently Joined","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'user', ''),
(5, 'Popular Tags', 'core.tags', '{"0":{"label":"Title","input":"text","value":"Popular Tags","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Type","input":"select","value":{"all":"all","blog":"blog","album":"album","topic":"topic","video":"video"},"name":"type"},"3":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'core', ''),
(6, 'What''s New ', 'ajax.home_activity', '{"0":{"label":"Title","input":"text","value":"What''s new","name":"title"},"1":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, '', ''),
(7, 'Friends', 'user.friend', '{"0":{"label":"Title","input":"text","value":"Friends","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'user', ''),
(8, 'Upcoming Events', 'events.upcoming', '{"0":{"label":"Title","input":"text","value":"Upcoming Event","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, '', ''),
(9, 'My Joined Groups', 'groups.myJoined', '{"0":{"label":"Title","input":"text","value":"My Joined Groups","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'group', ''),
(14, 'Popular Blogs', 'blogs.popular', '{"0":{"label":"Title","input":"text","value":"Popular Blogs","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'blogs', ''),
(15, 'Popular Albums ', 'photos.popularAlbums', '{"0":{"label":"Title","input":"text","value":"Popular Albums","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'photo', ''),
(16, 'Popular Videos', 'videos.popular', '{"0":{"label":"Title","input":"text","value":"Popular Videos","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'video', ''),
(17, 'Popular Topics', 'topics.popular', '{"0":{"label":"Title","input":"text","value":"Popular Topics","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'topic', ''),
(18, 'Popular Groups', 'groups.popular', '{"0":{"label":"Title","input":"text","value":"Popular Groups","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'group', ''),
(19, 'Popular Events', 'events.popular', '{"0":{"label":"Title","input":"text","value":"Popular Events","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'event', ''),
(21, 'Mutual Friends', 'user.mutualFriends', '{"0":{"label":"Title","input":"text","value":"Mutual Friends","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'user', 'users.view'),
(49, 'Featured Members', 'user.featured', '{"0":{"label":"Title","input":"text","value":"Feature Members","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'user', ''),
(51, 'Group Admin', 'groups.adminList', '{"0":{"label":"Title","input":"text","value":"Admin","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'group', 'groups.view'),
(52, 'Group Members', 'groups.memberList', '{"0":{"label":"Title","input":"text","value":"Members","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'group', 'groups.view'),
(53, 'People You May Know', 'user.suggestions', '{"0":{"label":"Title","input":"text","value":"People You May Know","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'user', ''),
(54, 'RSVP', 'events.rsvp', '{"0":{"label":"Title","input":"text","value":"RSVP","name":"title"},"1":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'events', 'events.view'),
(55, 'Event Attending', 'events.attending', '{"0":{"label":"Title","input":"text","value":"Event Attending","name":"title"},"1":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'events', 'events.view'),
(56, 'Html Block', 'htmlBlock', '{"0":{"label":"Title","input":"text","value":"Html Block","name":"title"},"1":{"label":"Html Content","input":"textarea","value":"","name":"html_block"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'core', '');
]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}core_contents` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`page_id` int(11) unsigned NOT NULL,
`type` enum('container','widget') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT
'widget',
`name` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`component` varchar(64) NOT NULL,
`parent_id` int(11) unsigned DEFAULT NULL,
`order` int(11) NOT NULL DEFAULT '1',
`params` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`attribs` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`lft` int(11) unsigned DEFAULT NULL,
`rght` int(10) unsigned DEFAULT NULL,
`column` tinyint(1) unsigned NOT NULL,
`core_block_id` int(11) unsigned NOT NULL,
`core_content_count` int(11) unsigned NOT NULL DEFAULT '0',
`invisible` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `page_id` (`page_id`,`order`)
); ]]>
</query>
<query>
<![CDATA[
INSERT IGNORE INTO `{PREFIX}core_contents` (`id`, `page_id`, `type`, `name`, `component`, `parent_id`, `order`, `params`, `attribs`, `lft`, `rght`, `column`, `core_block_id`, `core_content_count`, `invisible`) VALUES
(1, 1, 'container', 'west', '', NULL, 1, NULL, NULL, 1, 4, 0, 0, 2, 0),
(2, 6, 'container', 'west', '', NULL, 1, NULL, NULL, 5, 8, 0, 0, 2, 0),
(3, 1, 'container', 'east', '', NULL, 1, NULL, NULL, 9, 20, 0, 0, 5, 0),
(4, 8, 'container', 'east', '', NULL, 1, NULL, NULL, 21, 24, 0, 0, 1, 0),
(5, 3, 'container', 'east', '', NULL, 1, NULL, NULL, 25, 26, 0, 0, 1, 0),
(6, 63, 'container', 'west', '', NULL, 1, NULL, NULL, 27, 40, 0, 0, 5, 0),
(7, 63, 'container', 'east', '', NULL, 1, NULL, NULL, 41, 50, 0, 0, 5, 0),
(8, 63, 'container', 'center', '', NULL, 1, NULL, NULL, 51, 58, 0, 0, 2, 0),
(9, 18, 'container', 'west', '', NULL, 1, NULL, NULL, 59, 64, 0, 0, 2, 0),
(10, 18, 'container', 'east', '', NULL, 1, NULL, NULL, 65, 70, 0, 0, 2, 0),
(11, 12, 'container', 'west', '', NULL, 1, NULL, NULL, 71, 74, 0, 0, 2, 0),
(12, 18, 'widget', 'invisiblecontent', '', 10, 2, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 66, 67, 0, 52, 0, 0),
(13, 4, 'container', 'east', '', NULL, 1, NULL, NULL, 75, 76, 0, 0, 0, 0),
(14, 15, 'container', 'west', '', NULL, 1, NULL, NULL, 77, 82, 0, 0, 3, 0),
(15, 21, 'container', 'west', '', NULL, 1, NULL, NULL, 83, 90, 0, 0, 3, 0),
(16, 1, 'container', 'center', '', NULL, 1, NULL, NULL, 91, 92, 0, 0, 1, 0),
(17, 11, 'container', 'west', '', NULL, 1, NULL, NULL, 93, 94, 0, 0, 0, 0),
(18, 2, 'container', 'west', '', NULL, 1, NULL, NULL, 95, 96, 0, 0, 0, 0),
(19, 64, 'container', 'north', '', NULL, 1, NULL, NULL, 97, 102, 0, 0, 2, 0),
(20, 64, 'widget', 'hooks.friendSuggestions', '', 19, 1, '{"title":"People you may know","friend_sugget[]":"0"}', NULL, 98, 99, 0, 3, 0, 0),
(21, 64, 'container', 'west', '', NULL, 1, NULL, NULL, 103, 108, 0, 0, 2, 0),
(22, 64, 'widget', 'user.onlineUsers', '', 21, 1, '{"title":"Who''s online","num_item_show":"10"}', NULL, 104, 105, 0, 1, 0, 0),
(23, 64, 'container', 'east', '', NULL, 1, NULL, NULL, 109, 114, 0, 0, 2, 0),
(24, 64, 'widget', 'user.recentlyJoined', '', 23, 1, '{"title":"Recently Joined","num_item_show":"10"}', NULL, 110, 111, 0, 4, 0, 0),
(25, 64, 'container', 'center', '', NULL, 1, NULL, NULL, 115, 120, 0, 0, 2, 0),
(26, 64, 'widget', 'registration', '', 25, 1, '{"title":"Registration","users_role":"0"}', NULL, 116, 117, 0, 2, 0, 0),
(27, 64, 'widget', 'user.friend', '', 19, 2, '{"title":"Friends","num_item_show":"10"}', NULL, 100, 101, 0, 7, 0, 0),
(28, 64, 'widget', 'core.tags', '', 21, 2, '{"title":"Popular Tags","num_item_show":"10","type":"all"}', NULL, 106, 107, 0, 5, 0, 0),
(29, 64, 'widget', 'user.friend', '', 23, 2, '{"title":"Friends","num_item_show":"10"}', NULL, 112, 113, 0, 7, 0, 0),
(30, 64, 'widget', 'ajax.homeActivity', '', 25, 2, '{"title":"What''s new","home_activity":"0"}', NULL, 118, 119, 0, 6, 0, 0),
(31, 63, 'container', 'north', '', NULL, 1, NULL, NULL, 121, 124, 0, 0, 1, 0),
(32, 1, 'container', 'north', '', NULL, 1, NULL, NULL, 125, 128, 0, 0, 1, 0),
(33, 69, 'container', 'footer', '', NULL, 1, NULL, NULL, 129, 130, 0, 0, 0, 0),
(34, 67, 'container', 'north', '', NULL, 1, NULL, NULL, 131, 144, 0, 0, 3, 0),
(35, 67, 'container', 'center', '', NULL, 1, NULL, NULL, 145, 150, 0, 0, 2, 0),
(36, 67, 'container', 'footer', '', NULL, 1, NULL, NULL, 151, 152, 0, 0, 0, 0),
(37, 68, 'container', 'header', '', NULL, 1, NULL, NULL, 153, 154, 0, 0, 0, 0),
(38, 71, 'container', 'north', '', NULL, 1, NULL, NULL, 155, 158, 0, 0, 1, 0),
(39, 71, 'widget', 'user.onlineUsers', '', 38, 1, '{"title":"Who''s online","num_item_show":"10"}', NULL, 156, 157, 0, 1, 0, 0),
(40, 71, 'container', 'west', '', NULL, 1, NULL, NULL, 159, 162, 0, 0, 1, 0),
(41, 71, 'widget', 'core.tags', '', 40, 1, '{"title":"Popular Tags","num_item_show":"10","type":"all"}', NULL, 160, 161, 0, 5, 0, 0),
(42, 71, 'container', 'east', '', NULL, 1, NULL, NULL, 163, 166, 0, 0, 1, 0),
(43, 71, 'widget', 'groups.myJoined', '', 42, 1, '{"title":"My Joined Groups","num_item_show":"10"}', NULL, 164, 165, 0, 9, 0, 0),
(44, 71, 'container', 'center', '', NULL, 1, NULL, NULL, 167, 170, 0, 0, 1, 0),
(45, 71, 'widget', 'core.tags', '', 44, 1, '{"title":"Popular Tags","num_item_show":"10","type":"all"}', NULL, 168, 169, 0, 5, 0, 0),
(46, 67, 'container', 'east', '', NULL, 1, NULL, NULL, 171, 174, 0, 0, 1, 0),
(47, 67, 'container', 'west', '', NULL, 1, NULL, NULL, 175, 178, 0, 0, 1, 0),
(48, 67, 'widget', 'invisiblecontent', '', 34, 2, '{"title":"Content Block","maincontent":"1"}', NULL, 138, 139, 0, 0, 0, 0),
(49, 67, 'widget', 'user.onlineUsers', '', 34, 3, '{"title":"Who''s online 1","num_item_show":"102"}', NULL, 140, 141, 0, 1, 0, 0),
(50, 67, 'widget', 'user.onlineUsers', '', 34, 1, '{"title":"Who''s online 2","num_item_show":"10"}', NULL, 142, 143, 0, 1, 0, 0),
(51, 67, 'widget', 'invisiblecontent', '', 47, 1, '{"title":"Content Block","maincontent":"1"}', NULL, 176, 177, 0, 0, 0, 0),
(52, 67, 'widget', 'invisiblecontent', '', 46, 1, '{"title":"Content Block","maincontent":"1"}', NULL, 172, 173, 0, 0, 0, 0),
(53, 67, 'widget', 'invisiblecontent', '', 35, 1, '{"title":"Content Block","maincontent":"1"}', NULL, 146, 147, 0, 0, 0, 0),
(54, 67, 'widget', 'hooks.friendSuggestions', '', 35, 2, '{"title":"People you may know","friend_sugget[]":"0"}', NULL, 148, 149, 0, 3, 0, 0),
(55, 67, 'container', 'south', '', NULL, 1, NULL, NULL, 179, 182, 0, 0, 1, 0),
(56, 67, 'widget', 'invisiblecontent', '', 55, 1, '{"title":"Content Block","maincontent":"1"}', NULL, 180, 181, 0, 0, 0, 0),
(57, 63, 'container', 'south', '', NULL, 1, NULL, NULL, 183, 186, 0, 0, 1, 0),
(58, 1, 'widget', 'invisiblecontent', '', 1, 1, '{"title":"Home Menu","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 1),
(59, 1, 'container', 'south', '', NULL, 1, NULL, NULL, 187, 190, 0, 0, 1, 0),
(60, 11, 'container', 'north', '', NULL, 1, NULL, NULL, 191, 194, 0, 0, 1, 0),
(61, 11, 'widget', 'invisiblecontent', '', 60, 1, '{"title":"Page Content","maincontent":"1"}', NULL, 192, 193, 0, 0, 0, 0),
(62, 11, 'container', 'east', '', NULL, 1, NULL, NULL, 195, 198, 0, 0, 1, 0),
(63, 11, 'widget', 'invisiblecontent', '', 62, 1, '{"title":"Page Content","maincontent":"1"}', NULL, 196, 197, 0, 0, 0, 0),
(64, 11, 'container', 'center', '', NULL, 1, NULL, NULL, 199, 202, 0, 0, 1, 0),
(65, 11, 'widget', 'invisiblecontent', '', 64, 1, '{"title":"Page Content","maincontent":"1"}', NULL, 200, 201, 0, 0, 0, 0),
(66, 11, 'container', 'south', '', NULL, 1, NULL, NULL, 203, 206, 0, 0, 1, 0),
(67, 11, 'widget', 'invisiblecontent', '', 66, 1, '{"title":"Page Content","maincontent":"1"}', NULL, 204, 205, 0, 0, 0, 0),
(68, 1, 'widget', 'invisiblecontent', '', 16, 1, '{"title":"What''s New","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(69, 3, 'container', 'north', '', NULL, 1, NULL, NULL, 207, 210, 0, 0, 1, 0),
(70, 3, 'container', 'west', '', NULL, 1, NULL, NULL, 211, 214, 0, 0, 1, 0),
(71, 3, 'widget', 'invisiblecontent', '', 70, 1, '{"title":"Menu friend & Search","maincontent":"1"}', NULL, 212, 213, 0, 0, 0, 0),
(72, 3, 'container', 'center', '', NULL, 1, NULL, NULL, 215, 218, 0, 0, 1, 0),
(73, 3, 'widget', 'invisiblecontent', '', 72, 1, '{"title":"People","maincontent":"1"}', NULL, 216, 217, 0, 0, 0, 0),
(74, 3, 'container', 'south', '', NULL, 1, NULL, NULL, 219, 224, 0, 0, 1, 0),
(75, 3, 'widget', 'invisiblecontent', '', 5, 1, '{"title":"Theme & Language","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(76, 3, 'widget', 'invisiblecontent', '', 74, 1, '{"title":"Invisible Content","maincontent":"1"}', NULL, 222, 223, 0, 0, 0, 0),
(77, 9, 'container', 'west', '', NULL, 1, NULL, NULL, 225, 228, 0, 0, 2, 0),
(78, 9, 'container', 'center', '', NULL, 1, NULL, NULL, 229, 230, 0, 0, 1, 0),
(79, 9, 'widget', 'invisiblecontent', '', 77, 1, '{"title":"List photos & Search","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(80, 9, 'widget', 'invisiblecontent', '', 78, 1, '{"title":"Photos","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(81, 12, 'container', 'north', '', NULL, 1, NULL, NULL, 231, 236, 0, 0, 1, 0),
(82, 12, 'container', 'east', '', NULL, 1, NULL, NULL, 237, 242, 0, 0, 1, 0),
(83, 12, 'container', 'center', '', NULL, 1, NULL, NULL, 5, 246, 0, 0, 1, 0),
(84, 12, 'widget', 'invisiblecontent', '', 83, 1, '{"title":"Videos","maincontent":"1"}', NULL, 244, 6, 0, 0, 0, 0),
(85, 12, 'container', 'south', '', NULL, 1, NULL, NULL, 247, 252, 0, 0, 1, 0),
(86, 12, 'widget', 'invisiblecontent', '', 11, 1, '{"title":"Menu video & Search","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(87, 12, 'widget', 'invisiblecontent', '', 81, 1, '{"title":"Invisible Content","maincontent":"1"}', NULL, 2, 235, 0, 0, 0, 0),
(88, 12, 'widget', 'invisiblecontent', '', 82, 1, '{"title":"Invisible Content","maincontent":"1"}', NULL, 240, 4, 0, 0, 0, 0),
(89, 12, 'widget', 'invisiblecontent', '', 85, 1, '{"title":"Invisible Content","maincontent":"1"}', NULL, 250, 251, 0, 0, 0, 0),
(90, 15, 'container', 'center', '', NULL, 1, NULL, NULL, 8, 254, 0, 0, 1, 0),
(91, 15, 'widget', 'invisiblecontent', '', 14, 1, '{"title":"Topic''s setting","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(92, 15, 'widget', 'invisiblecontent', '', 90, 1, '{"title":"Topics contents","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(93, 15, 'container', 'east', '', NULL, 1, NULL, NULL, 255, 9, 0, 0, 1, 0),
(94, 15, 'widget', 'invisiblecontent', '', 93, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(95, 23, 'container', 'west', '', NULL, 1, NULL, NULL, 257, 258, 0, 0, 1, 0),
(96, 23, 'container', 'east', '', NULL, 1, NULL, NULL, 10, 260, 0, 0, 1, 0),
(97, 23, 'container', 'center', '', NULL, 1, NULL, NULL, 261, 11, 0, 0, 1, 0),
(98, 23, 'widget', 'invisiblecontent', '', 95, 1, '{"title":"Topics menu & Search","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(99, 23, 'widget', 'invisiblecontent', '', 96, 1, '{"title":"Themes & Langguages","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(100, 23, 'widget', 'invisiblecontent', '', 97, 1, '{"title":"Topics","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(101, 16, 'container', 'west', '', NULL, 1, NULL, NULL, 263, 264, 0, 0, 1, 0),
(102, 16, 'container', 'east', '', NULL, 1, NULL, NULL, 265, 266, 0, 0, 1, 0),
(103, 16, 'container', 'center', '', NULL, 1, NULL, NULL, 267, 268, 0, 0, 1, 0),
(104, 16, 'widget', 'invisiblecontent', '', 101, 1, '{"title":"Groups menu & Search","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(105, 16, 'widget', 'invisiblecontent', '', 102, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(106, 16, 'widget', 'invisiblecontent', '', 103, 1, '{"title":"Groups","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(107, 19, 'container', 'west', '', NULL, 1, NULL, NULL, 12, 14, 0, 0, 2, 0),
(108, 19, 'container', 'east', '', NULL, 1, NULL, NULL, 273, 274, 0, 0, 1, 0),
(109, 19, 'container', 'center', '', NULL, 1, NULL, NULL, 275, 276, 0, 0, 1, 0),
(110, 19, 'widget', 'invisiblecontent', '', 107, 1, '{"title":"Events menu & Search","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(111, 19, 'widget', 'invisiblecontent', '', 108, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(112, 4, 'container', 'north', '', NULL, 1, NULL, NULL, 277, 280, 0, 0, 0, 0),
(113, 4, 'container', 'west', '', NULL, 1, NULL, NULL, 281, 284, 0, 0, 1, 0),
(114, 4, 'widget', 'invisiblecontent', '', 113, 2, '{"title":"Profile menu & Users","maincontent":"1"}', NULL, 282, 283, 0, 0, 0, 0),
(115, 4, 'container', 'center', '', NULL, 1, NULL, NULL, 285, 288, 0, 0, 1, 0),
(116, 4, 'widget', 'invisiblecontent', '', 115, 2, '{"title":"Recent Activities","maincontent":"1"}', NULL, 286, 287, 0, 0, 0, 0),
(117, 4, 'container', 'south', '', NULL, 1, NULL, NULL, 289, 292, 0, 0, 1, 0),
(118, 4, 'widget', 'invisiblecontent', '', 117, 2, '{"title":"Invisible Content","maincontent":"1"}', NULL, 290, 291, 0, 0, 0, 0),
(119, 19, 'widget', 'invisiblecontent', '', 109, 1, '{"title":"Events","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(120, 6, 'container', 'east', '', NULL, 1, NULL, NULL, 293, 296, 0, 0, 2, 0),
(121, 6, 'container', 'center', '', NULL, 1, NULL, NULL, 297, 298, 0, 0, 1, 0),
(122, 6, 'widget', 'invisiblecontent', '', 2, 1, '{"title":"Blogs menu & Search","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(123, 6, 'widget', 'invisiblecontent', '', 120, 2, '{"title":"Themes & Languages","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(124, 6, 'widget', 'invisiblecontent', '', 121, 1, '{"title":"Blogs","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(125, 2, 'container', 'east', '', NULL, 1, NULL, NULL, 299, 300, 0, 0, 1, 0),
(126, 2, 'container', 'center', '', NULL, 1, NULL, NULL, 301, 302, 0, 0, 1, 0),
(127, 2, 'widget', 'invisiblecontent', '', 125, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(128, 2, 'widget', 'invisiblecontent', '', 126, 1, '{"title":"Contact","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(129, 5, 'container', 'center', '', NULL, 1, NULL, NULL, 303, 304, 0, 0, 1, 0),
(130, 5, 'widget', 'invisiblecontent', '', 129, 1, '{"title":"User Register","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(131, 8, 'container', 'west', '', NULL, 1, NULL, NULL, 305, 308, 0, 0, 1, 0),
(132, 8, 'widget', 'invisiblecontent', '', 131, 1, '{"title":"Blogs settings","maincontent":"1"}', NULL, 306, 307, 0, 1, 0, 0),
(133, 8, 'widget', 'invisiblecontent', '', 4, 1, '{"title":"Other Entries","maincontent":"1"}', NULL, 22, 23, 0, 1, 0, 0),
(134, 8, 'container', 'center', '', NULL, 1, NULL, NULL, 309, 312, 0, 0, 1, 0),
(135, 8, 'widget', 'invisiblecontent', '', 134, 1, '{"title":"Blog Detail","maincontent":"1"}', NULL, 310, 311, 0, 1, 0, 0),
(136, 10, 'container', 'east', '', NULL, 1, NULL, NULL, 313, 316, 0, 0, 1, 0),
(137, 10, 'widget', 'invisiblecontent', '', 136, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 314, 315, 0, 1, 0, 0),
(138, 10, 'container', 'center', '', NULL, 1, NULL, NULL, 317, 320, 0, 0, 1, 0),
(139, 10, 'widget', 'invisiblecontent', '', 138, 1, '{"title":"Album''s photos","maincontent":"1"}', NULL, 318, 319, 0, 1, 0, 0),
(140, 13, 'container', 'east', '', NULL, 1, NULL, NULL, 321, 324, 0, 0, 1, 0),
(141, 13, 'widget', 'invisiblecontent', '', 140, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 322, 323, 0, 1, 0, 0),
(142, 13, 'container', 'center', '', NULL, 1, NULL, NULL, 325, 328, 0, 0, 1, 0),
(143, 13, 'widget', 'invisiblecontent', '', 142, 1, '{"title":"Video''s content","maincontent":"1"}', NULL, 326, 327, 0, 1, 0, 0),
(144, 18, 'widget', 'invisiblecontent', '', 9, 1, '{"title":"Group info & setting","maincontent":"1"}', NULL, 60, 61, 0, 1, 0, 0),
(145, 18, 'container', 'center', '', NULL, 1, NULL, NULL, 329, 332, 0, 0, 1, 0),
(146, 18, 'widget', 'invisiblecontent', '', 145, 1, '{"title":"Info & Photos & Recent Activities","maincontent":"1"}', NULL, 330, 331, 0, 1, 0, 0),
(147, 21, 'widget', 'invisiblecontent', '', 15, 1, '{"title":"Event''s setting","maincontent":"1"}', NULL, 84, 85, 0, 1, 0, 0),
(148, 21, 'container', 'east', '', NULL, 1, NULL, NULL, 333, 336, 0, 0, 1, 0),
(149, 21, 'widget', 'invisiblecontent', '', 148, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 334, 335, 0, 1, 0, 0),
(150, 21, 'container', 'center', '', NULL, 1, NULL, NULL, 337, 340, 0, 0, 1, 0),
(151, 21, 'widget', 'invisiblecontent', '', 150, 1, '{"title":"Event''s detail & Message","maincontent":"1"}', NULL, 338, 339, 0, 1, 0, 0),
(152, 22, 'container', 'east', '', NULL, 1, NULL, NULL, 341, 344, 0, 0, 1, 0),
(153, 22, 'widget', 'invisiblecontent', '', 152, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 342, 343, 0, 1, 0, 0),
(154, 22, 'container', 'center', '', NULL, 1, NULL, NULL, 345, 348, 0, 0, 1, 0),
(155, 22, 'widget', 'invisiblecontent', '', 154, 1, '{"title":"Forgot Password","maincontent":"1"}', NULL, 346, 347, 0, 1, 0, 0),
(156, 63, 'widget', 'invisiblecontent', '', 7, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, NULL, NULL, 0, 0, 0, 0),
(157, 1, 'widget', 'invisiblecontent', '', 32, 1, '{"title":"Invisible Content","maincontent":"1"}', NULL, 126, 127, 0, 0, 0, 0),
(158, 1, 'widget', 'invisiblecontent', '', 3, 5, '{"title":"Themes & Language","maincontent":"1"}', NULL, 10, 11, 0, 0, 0, 0),
(159, 1, 'widget', 'user.onlineUsers', '', 3, 1, '{"title":"Who''s online","num_item_show":"10"}', NULL, 12, 13, 0, 1, 0, 0),
(160, 10, 'container', 'north', '', NULL, 1, NULL, NULL, 349, 350, 0, 0, 0, 0),
(161, 10, 'container', 'west', '', NULL, 1, NULL, NULL, 351, 352, 0, 0, 0, 0),
(162, 10, 'container', 'south', '', NULL, 1, NULL, NULL, 353, 354, 0, 0, 0, 0),
(163, 1, 'widget', 'user.featured', '', 3, 2, '{"title":"Feature Members","num_item_show":"10"}', NULL, 14, 15, 0, 49, 0, 0),
(164, 1, 'widget', 'user.suggestions', '', 3, 3, '{"title":"People You May Know","num_item_show":"10"}', NULL, 16, 17, 0, 53, 0, 0),
(165, 73, 'container', 'east', '', NULL, 1, NULL, NULL, 355, 356, 0, 0, 0, 0),
(166, 73, 'container', 'center', '', NULL, 1, NULL, NULL, 357, 358, 0, 0, 0, 0),
(167, 75, 'container', 'north', '', NULL, 1, NULL, NULL, 359, 362, 0, 0, 1, 0),
(168, 75, 'widget', 'hooks.friendSuggestions', '', 167, 1, '{"title":"People you may know","friend_sugget[]":"0"}', NULL, 360, 361, 0, 3, 0, 0),
(169, 75, 'container', 'center', '', NULL, 1, NULL, NULL, 363, 366, 0, 0, 1, 0),
(170, 75, 'widget', 'core.tags', '', 169, 1, '{"title":"Popular Tags","num_item_show":"10","type":"all"}', NULL, 364, 365, 0, 5, 0, 0),
(171, 76, 'container', 'east', '', NULL, 1, NULL, NULL, 367, 370, 0, 0, 1, 0),
(172, 76, 'widget', 'ajax.homeEvent', '', 171, 1, '{"title":"Upcoming Event","home_event":""}', NULL, 15, 369, 0, 8, 0, 0),
(173, 76, 'container', 'center', '', NULL, 1, NULL, NULL, 371, 374, 0, 0, 1, 0),
(174, 76, 'widget', 'user.recentlyJoined', '', 173, 1, '{"title":"Recently Joined","num_item_show":"10"}', NULL, 372, 373, 0, 4, 0, 0),
(175, 66, 'container', 'center', '', NULL, 1, NULL, NULL, 375, 382, 0, 0, 3, 0),
(176, 66, 'container', 'north', '', NULL, 1, NULL, NULL, 16, 386, 0, 0, 1, 0),
(177, 66, 'widget', 'photos.popularAlbums', '', 176, 1, '{"title":"Popular Albums","num_item_show":"10"}', NULL, 384, 17, 0, 15, 0, 0),
(178, 66, 'widget', 'core.tags', '', 175, 2, '{"title":"Popular Tags","num_item_show":"10","type":"all"}', NULL, 376, 377, 0, 5, 0, 0),
(179, 66, 'widget', 'htmlBlock', '', 175, 3, '{"title":"Html Block","html_block":"aaaaaa","title_enable":"0"}', NULL, 378, 379, 0, 56, 0, 0),
(180, 84, 'container', 'north', '', NULL, 1, NULL, NULL, 387, 19, 0, 0, 2, 0),
(181, 84, 'widget', 'user.onlineUsers', '', 180, 1, '{"title":"Who''s online","num_item_show":"10"}', NULL, 388, 18, 0, 1, 0, 0),
(182, 84, 'widget', 'user.recentlyJoined', '', 180, 2, '{"title":"Recently Joined","num_item_show":"10"}', NULL, 390, 391, 0, 4, 0, 0),
(183, 66, 'widget', 'invisiblecontent', '', 175, 1, '{"title":"Page Content","maincontent":"1"}', NULL, 380, 381, 0, 0, 0, 0),
(184, 85, 'container', 'west', '', NULL, 1, NULL, NULL, 393, 20, 0, 0, 0, 0),
(185, 85, 'container', 'north', '', NULL, 1, NULL, NULL, 21, 22, 0, 0, 0, 0),
(186, 86, 'container', 'north', '', NULL, 1, NULL, NULL, 23, 30, 0, 0, 3, 0),
(187, 86, 'widget', 'user.onlineUsers', '', 186, 1, '{"title":"","num_item_show":"10"}', NULL, 24, 25, 0, 1, 0, 0),
(188, 86, 'widget', 'user.recentlyJoined', '', 186, 2, '{"title":"Recently Joined","num_item_show":"10"}', NULL, 26, 27, 0, 4, 0, 0),
(189, 86, 'widget', 'ajax.home_event', '', 186, 3, '{"title":"Upcoming Event","home_event":""}', NULL, 28, 29, 0, 8, 0, 0),
(190, 87, 'container', 'west', '', NULL, 1, NULL, NULL, 31, 416, 0, 0, 5, 0),
(191, 87, 'container', 'north', '', NULL, 1, NULL, NULL, 417, 420, 0, 0, 1, 0),
(192, 87, 'widget', 'core.tags', '', 191, 1, '{"title":"2222","num_item_show":"10","type":"all"}', NULL, 418, 419, 0, 5, 0, 0),
(193, 87, 'widget', 'registration', '', 190, 1, '{"title":"Registration","users_role":"0"}', NULL, 406, 407, 0, 2, 0, 0),
(194, 87, 'widget', 'user.recentlyJoined', '', 190, 2, '{"title":"Recently Joined","num_item_show":"10"}', NULL, 408, 409, 0, 4, 0, 0),
(195, 87, 'widget', 'photos.popularAlbums', '', 190, 3, '{"title":"Popular Albums","num_item_show":"10"}', NULL, 410, 411, 0, 15, 0, 0),
(196, 87, 'widget', 'videos.popular', '', 190, 4, '{"title":"Popular Videos","num_item_show":"10"}', NULL, 412, 413, 0, 16, 0, 0),
(197, 87, 'widget', 'user.featured', '', 190, 5, '{"title":"Feature Members","num_item_show":"10"}', NULL, 414, 415, 0, 49, 0, 0),
(198, 87, 'container', 'east', '', NULL, 1, NULL, NULL, 421, 36, 0, 0, 8, 0),
(199, 87, 'widget', 'user.onlineUsers', '', 198, 1, '{"title":"Who''s online","num_item_show":"10"}', NULL, 422, 423, 0, 1, 0, 0),
(200, 87, 'widget', 'user.friend', '', 198, 2, '{"title":"Friends","num_item_show":"10"}', NULL, 424, 425, 0, 7, 0, 0),
(201, 87, 'widget', 'groups.myJoined', '', 198, 3, '{"title":"My Joined Groups","num_item_show":"10"}', NULL, 426, 427, 0, 9, 0, 0),
(202, 87, 'widget', 'blogs.popular', '', 198, 4, '{"title":"Popular Blogs","num_item_show":"10"}', NULL, 32, 429, 0, 14, 0, 0),
(203, 87, 'widget', 'topics.popular', '', 198, 5, '{"title":"Popular Topics","num_item_show":"10"}', NULL, 430, 431, 0, 17, 0, 0),
(204, 87, 'widget', 'groups.popular', '', 198, 6, '{"title":"Popular Groups","num_item_show":"10"}', NULL, 33, 433, 0, 18, 0, 0),
(205, 87, 'widget', 'events.popular', '', 198, 7, '{"title":"Popular Events","num_item_show":"10"}', NULL, 34, 435, 0, 19, 0, 0),
(206, 87, 'widget', 'user.suggestions', '', 198, 8, '{"title":"People You May Know","num_item_show":"10"}', NULL, 35, 437, 0, 53, 0, 0),
(207, 87, 'container', 'center', '', NULL, 1, NULL, NULL, 439, 38, 0, 0, 2, 0),
(208, 87, 'widget', 'ajax.home_activity', '', 207, 1, '{"title":"What''s new","home_activity":"0"}', NULL, 37, 441, 0, 6, 0, 0),
(209, 88, 'container', 'east', '', NULL, 1, NULL, NULL, 39, 42, 0, 0, 1, 0),
(210, 88, 'widget', 'photos.popularAlbums', '', 209, 1, '{"title":"Popular Albums","num_item_show":"10"}', NULL, 40, 41, 0, 15, 0, 0),
(211, 88, 'container', 'center', '', NULL, 1, NULL, NULL, 43, 46, 0, 0, 1, 0),
(212, 88, 'widget', 'user.friend', '', 211, 1, '{"title":"Friends","num_item_show":"10"}', NULL, 44, 45, 0, 7, 0, 0),
(213, 90, 'container', 'center', '', NULL, 1, NULL, NULL, 453, 456, 0, 0, 1, 0),
(214, 90, 'widget', 'invisiblecontent', '', 213, 1, '{"title":"Login form","maincontent":"1"}', NULL, 47, 455, 0, 1, 0, 0),
(215, 85, 'container', 'center', '', NULL, 1, NULL, NULL, 457, 49, 0, 0, 2, 0),
(216, 85, 'widget', 'invisiblecontent', '', 215, 1, '{"title":"Page Content","maincontent":"1"}', NULL, 458, 459, 0, 0, 0, 0),
(217, 87, 'widget', 'invisiblecontent', '', 207, 2, '{"title":"Page Content","maincontent":"1"}', NULL, 442, 443, 0, 0, 0, 0),
(218, 94, 'container', 'center', '', NULL, 1, NULL, NULL, 50, 55, 0, 0, 2, 0),
(219, 94, 'widget', 'invisiblecontent', '', 218, 1, '{"title":"Page Content","maincontent":"1"}', NULL, 51, 52, 0, 0, 0, 0),
(220, 94, 'widget', 'user.onlineUsers', '', 218, 2, '{"title":"Who''s online","num_item_show":"10"}', NULL, 53, 54, 0, 1, 0, 0),
(221, 95, 'container', 'center', '', NULL, 1, NULL, NULL, 56, 472, 0, 0, 1, 0),
(222, 95, 'widget', 'invisiblecontent', '', 221, 1, '{"title":"Page Content","maincontent":"1"}', NULL, 470, 471, 0, 0, 0, 0),
(223, 96, 'container', 'center', '', NULL, 1, NULL, NULL, 57, 59, 0, 0, 1, 0),
(224, 96, 'widget', 'invisiblecontent', '', 223, 1, '{"title":"Register Form","maincontent":"1"}', NULL, 474, 58, 0, 0, 0, 0),
(225, 85, 'widget', 'signup', '', 215, 2, '{"title":"Sign Up"}', NULL, 460, 48, 0, 67, 0, 0),
(226, 1, 'widget', 'htmlBlock', '', 3, 4, '{"title":"Html Block","html_block":"","title_enable":"0"}', NULL, 18, 19, 0, 56, 0, 0),
(227, 1, 'widget', 'events.upcoming', '', 1, 2, '{"title":"Upcoming Event","num_item_show":"10"}', NULL, 2, 3, 0, 8, 0, 0),
(228, 6, 'widget', 'blogs.popular', '', 2, 2, '{"title":"Popular Blogs","num_item_show":"10","title_enable":"0"}', NULL, 6, 7, 0, 14, 0, 0),
(229, 6, 'widget', 'core.tags', '', 120, 1, '{"title":"Popular Tags","num_item_show":"10","type":"all","title_enable":"0"}', NULL, 294, 295, 0, 5, 0, 0),
(230, 9, 'widget', 'photos.popularAlbums', '', 77, 2, '{"title":"Popular Albums","num_item_show":"10","title_enable":"0"}', NULL, 226, 227, 0, 15, 0, 0),
(231, 12, 'widget', 'videos.popular', '', 11, 2, '{"title":"Popular Videos","num_item_show":"10","title_enable":"0"}', NULL, 72, 73, 0, 16, 0, 0),
(232, 15, 'widget', 'core.tags', '', 14, 2, '{"title":"Popular Tags","num_item_show":"10","type":"all","title_enable":"0"}', NULL, 78, 79, 0, 5, 0, 0),
(233, 15, 'widget', 'topics.popular', '', 14, 3, '{"title":"Popular Topics","num_item_show":"10","title_enable":"0"}', NULL, 80, 81, 0, 17, 0, 0),
(234, 18, 'widget', 'groups.adminList', '', 9, 2, '{"title":"Admin","num_item_show":"10","title_enable":"0"}', NULL, 62, 63, 0, 51, 0, 0),
(235, 18, 'widget', 'user.onlineUsers', '', 10, 1, '{"title":"Who''s online","num_item_show":"10","title_enable":"0"}', NULL, 68, 69, 0, 1, 0, 0),
(236, 19, 'widget', 'events.popular', '', 107, 2, '{"title":"Popular Events","num_item_show":"10","title_enable":"0"}', NULL, 13, 271, 0, 19, 0, 0),
(237, 21, 'widget', 'events.rsvp', '', 15, 2, '{"title":"RSVP","title_enable":"0"}', NULL, 86, 87, 0, 54, 0, 0),
(238, 21, 'widget', 'events.attending', '', 15, 3, '{"title":"Event Attending","title_enable":"0"}', NULL, 88, 89, 0, 55, 0, 0),
(239, 90, 'container', 'west', '', NULL, 1, NULL, NULL, 477, 63, 0, 0, 2, 0),
(240, 90, 'widget', 'user.onlineUsers', '', 239, 1, '{"title":"Who''s online","num_item_show":"10","title_enable[]":"0"}', NULL, 478, 60, 0, 1, 0, 0),
(241, 90, 'widget', 'user.recentlyJoined', '', 239, 2, '{"title":"Recently Joined","num_item_show":"10","title_enable[]":"0"}', NULL, 61, 62, 0, 4, 0, 0),
(242, 63, 'widget', 'ajax.home_activity', '', 8, 2, '{"title":"What''s new","title_enable[]":"0"}', NULL, 54, 55, 0, 6, 0, 0),
(243, 63, 'widget', 'user.onlineUsers', '', 6, 1, '{"title":"Who''s online","num_item_show":"10","title_enable":"1"}', NULL, 30, 31, 0, 1, 0, 0),
(244, 63, 'widget', 'events.upcoming', '', 6, 2, '{"title":"Upcoming Event","num_item_show":"10","title_enable":"1"}', NULL, 32, 33, 0, 8, 0, 0),
(245, 63, 'widget', 'blogs.popular', '', 6, 3, '{"title":"Popular Blogs","num_item_show":"10","title_enable":"1"}', NULL, 34, 35, 0, 14, 0, 0),
(246, 63, 'widget', 'videos.popular', '', 6, 4, '{"title":"Popular Videos","num_item_show":"10","title_enable":"1"}', NULL, 36, 37, 0, 16, 0, 0),
(247, 63, 'widget', 'user.featured', '', 6, 5, '{"title":"Feature Members","num_item_show":"10","title_enable":"1"}', NULL, 38, 39, 0, 49, 0, 0),
(248, 63, 'widget', 'core.tags', '', 7, 2, '{"title":"Popular Tags","num_item_show":"10","type":"all","title_enable":"1"}', NULL, 42, 43, 0, 5, 0, 0),
(249, 63, 'widget', 'photos.popularAlbums', '', 7, 3, '{"title":"Popular Albums","num_item_show":"10","title_enable":"1"}', NULL, 44, 45, 0, 15, 0, 0),
(250, 63, 'widget', 'topics.popular', '', 7, 4, '{"title":"Popular Topics","num_item_show":"10","title_enable":"1"}', NULL, 46, 47, 0, 17, 0, 0),
(251, 63, 'widget', 'events.popular', '', 7, 5, '{"title":"Popular Events","num_item_show":"10","title_enable":"1"}', NULL, 48, 49, 0, 19, 0, 0),
(252, 63, 'widget', 'user.recentlyJoined', '', 8, 1, '{"title":"Recently Joined","num_item_show":"10","title_enable":"1"}', NULL, 56, 57, 0, 4, 0, 0);
]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}pages_backup` like `{PREFIX}pages`; ]]>
</query>
<query> <![CDATA[
INSERT INTO `{PREFIX}pages_backup` select * from `{PREFIX}pages`;
]]>
</query>
<query><![CDATA[
DROP TABLE IF EXISTS `{PREFIX}pages`; ]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}pages` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
`alias` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`content` text COLLATE utf8_unicode_ci NOT NULL,
`permission` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
`params` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`menu` tinyint(1) unsigned NOT NULL DEFAULT '0',
`icon_class` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`weight` int(10) unsigned NOT NULL,
`url` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`uri` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`description` text COLLATE utf8_unicode_ci NOT NULL,
`keywords` text COLLATE utf8_unicode_ci NOT NULL,
`custom` tinyint(1) NOT NULL DEFAULT '1',
`fragment` tinyint(1) NOT NULL DEFAULT '0',
`layout` int(11) NOT NULL DEFAULT '0',
`levels` text COLLATE utf8_unicode_ci,
`provides` text COLLATE utf8_unicode_ci,
`view_count` int(11) unsigned NOT NULL DEFAULT '0',
`type` enum('core','plugin','page') COLLATE utf8_unicode_ci DEFAULT NULL,
`search` tinyint(1) NOT NULL DEFAULT '0',
`theme_id` int(11) unsigned NOT NULL,
`core_content_count` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `alias` (`alias`)
) AUTO_INCREMENT=100 ; ]]>
</query>
<query><![CDATA[
INSERT IGNORE INTO `{PREFIX}pages` (`id`, `title`, `alias`, `content`, `permission`, `params`,
`created`, `modified`, `menu`, `icon_class`, `weight`, `url`, `uri`, `description`, `keywords`,
`custom`, `fragment`, `layout`, `levels`, `provides`, `view_count`, `type`, `search`, `theme_id`,
`core_content_count`) VALUES
(1, 'Home Page', 'home_index', '', '', '', '0000-00-00 00:00:00', '2014-09-10 02:06:12', 0, '', 0,
'/home', 'home.index', '', '', 1, 0, 1, NULL, NULL, 0, 'core', 0, 0, 14),
(2, 'Contact Page', 'home_contact', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0,
'/home/contact', 'home.contact', '', '', 1, 0, 1, NULL, NULL, 0, 'core', 0, 0, 5),
(3, 'People Page', 'users_index', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0,
'/users', 'users.index', '', '', 1, 0, 1, NULL, NULL, 0, 'core', 0, 0, 12),
(4, 'Profile Page', 'users_view', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0,
'/users/view/$id', 'users.view', '', '', 1, 0, 1, NULL, NULL, 0, 'core', 0, 0, 12),
(5, 'Join Page', 'users_register', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0,
'/users/register', NULL, '', '', 1, 0, 0, NULL, NULL, 0, 'core', 0, 0, 3),
(6, 'Blogs Browse Page', 'blogs_index', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '',
0, '/blogs', 'blogs.index', '', '', 1, 0, 1, NULL, NULL, 0, 'core', 0, 0, 8),
(8, 'Blog Detail Page', 'blogs_view', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '',
0, '/blogs/view/$id', 'blogs.view', '', '', 1, 0, 1, NULL, NULL, 0, 'core', 0, 0, 6),
(9, 'Photos Browse Page', 'photos_index', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0,
'', 0, '/photos', 'photos.index', '', '', 1, 0, 2, NULL, NULL, 0, 'core', 0, 0, 5),
(10, 'Album Browse Page', 'albums_view', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0,
'', 0, '/albums/view/$id/{album name}', 'albums.view', '', '', 1, 0, 0, NULL, NULL, 0, 'core', 0, 0, 7),
(11, 'Photo Detail Pages', 'photos_view', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0,
'', 0, '/photos/view/$id', 'photos.view', '', '', 1, 0, 4, NULL, NULL, 0, 'core', 0, 0, 9),
(12, 'Videos Browse Pages', 'videos', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '',
0, '/videos', 'videos.index', '', '', 1, 0, 2, NULL, NULL, 0, 'core', 0, 0, 11),
(13, 'Video Detail Page', 'videos_view', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0,
'', 0, '/videos/view/$id/{video''s name}', 'videos.view', '', '', 1, 0, 3, NULL, NULL, 0, 'core', 0, 0,
4),
(15, 'Topic Detail Page', 'topics_view', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0,
'', 0, '/topics/view/$id/{topic''s name}', 'topics.view', '', '', 1, 0, 1, NULL, NULL, 0, 'core', 0, 0,
8),
(16, 'Groups Page', 'groups', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0,
'/groups', 'groups.index', '', '', 1, 0, 0, NULL, NULL, 0, 'core', 0, 0, 6),
(18, 'Group Detail Page', 'groups_view', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0,
'', 0, '/groups/view/$id/{group''s name}', 'groups.view', '', '', 1, 0, 0, NULL, NULL, 0, 'core', 0, 0,
8),
(19, 'Events Page', 'events', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0,
'/events', 'events.index', '', '', 1, 0, 0, NULL, NULL, 0, 'core', 0, 0, 7),
(21, 'Event Detail Page', 'events_view', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0,
'', 0, '/events/view/$id/{event''s name}', 'events.view', '', '', 1, 0, 0, NULL, NULL, 0, 'core', 0, 0,
8),
(22, 'Forgot Password Page', 'user_recover', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00',
0, '', 0, '/users/recover', 'users.recover', '', '', 1, 0, 0, NULL, NULL, 0, 'core', 0, 0, 4),
(23, 'Topics Page', 'topics', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0,
'/topics', 'topics.index', '', '', 1, 0, 0, NULL, NULL, 0, 'core', 0, 0, 6),
(63, 'Landing Page', 'landing_index', '', '', '', '2014-08-28 04:20:32', '2014-08-28 04:20:32', 0, '',
0, '/home/landing', 'home.landing', '', '', 1, 0, 1, NULL, NULL, 0, 'core', 0, 0, 10),
(68, 'Site Header', 'site_header', '', '', '', '0000-00-00 00:00:00', '2014-09-08 01:58:40', 0, '', 0,
'site/header', 'site.header', '', '', 1, 0, 4, NULL, NULL, 0, 'core', 0, 0, 1),
(69, 'Site Footer', 'site_footer', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0,
'site/footer', 'site.footer', '', '', 1, 0, 4, NULL, NULL, 0, 'core', 0, 0, 1),
(90, 'Sign in', 'signin', '', '', '', '2014-09-11 09:14:58', '2014-09-11 09:14:58', 0, '', 0,
'/users/member_login', 'users.member_login', '', '', 1, 0, 4, NULL, NULL, 0, 'core', 0, 0, 5),
(96, 'Sign up', 'signup', '', '', '', '2014-09-15 03:34:56', '2014-09-15 03:34:56', 0, '', 0,
'/users/register', 'users.member_signup', '', '', 1, 0, 0, NULL, NULL, 0, 'core', 0, 0, 2);
]]>
</query>
<query><![CDATA[
INSERT INTO `{PREFIX}pages`(`title`, `alias`, `content`, `permission`, `params`, `created`, `modified`,
`menu`, `icon_class`, `weight`) SELECT `title`, `alias`, `content`, `permission`, `params`, `created`,
`modified`, `menu`, `icon_class`, `weight` FROM `{PREFIX}pages_backup`;
]]>
</query>
<query><![CDATA[
INSERT IGNORE INTO `{PREFIX}settings` (`id`, `field`, `value`) VALUES
(63, 'google_client_id', ''),
(64, 'google_integration', '0');
]]>
</query>
<query><![CDATA[
REPLACE INTO `{PREFIX}themes` (`id`, `key`, `name`, `core`) VALUES
(1, 'default', 'Default Theme', 1),
(2, 'dark', 'Dark Theme', 0),
(3, 'light', 'Light Theme', 0); ]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}activity_fetch_videos` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`source` char(10) DEFAULT NULL,
`source_id` varchar(300) DEFAULT NULL,
`title` varchar(300) DEFAULT NULL,
`description` text,
`thumb` varchar(300) DEFAULT NULL,
`activity_id` int(11) NOT NULL,
`category_id` int(11) DEFAULT NULL,
`privacy` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
); ]]>
</query>
<query><![CDATA[
DELETE FROM `{PREFIX}plugins` WHERE `{PREFIX}plugins`.`id` = 8; ]]>
</query>
</queries>
</version>
<version>
<number>2.1.2</number>
<queries>
<query>
<![CDATA[
INSERT IGNORE INTO `{PREFIX}core_blocks` (`id`, `name`, `path_view`, `params`, `is_active`, `plugin_id`, `group`, `restricted`) VALUES(10, 'Login', 'user.login','{"0":{"label":"Title","input":"text","value":"Login","name":"title"},"1":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'landing', 'home.landing'),(11, 'Sign up', 'user.signup', '{"0":{"label":"Title","input":"text","value":"Sign up","name":"title"},"1":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'landing', 'home.landing');
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `name` = 'HTML Block', `params` ='{"0":{"label":"Title","input":"text","value":"HTML Block","name":"title"},"1":{"label":"Html Content","input":"textarea","value":"","name":"html_block"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}' WHERE `{PREFIX}core_blocks`.`id` = 56;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `params` = '{"0":{"label":"Title","input":"text","value":"Upcoming Events","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}' WHERE `{PREFIX}core_blocks`.`id` = 8;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `params` = '{"0":{"label":"Title","input":"text","value":"Who''s Online","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}' WHERE `{PREFIX}core_blocks`.`id` = 1;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `params` = '{"0":{"label":"Title","input":"text","value":"Featured Members","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}' WHERE `{PREFIX}core_blocks`.`id` = 49;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_contents`
SET `params` = REPLACE(params, "Feature Members", "Featured Members")
WHERE `params` LIKE ("%Feature Members%");
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_contents`
SET `params` = REPLACE(params, "Upcoming Event", "Upcoming Events")
WHERE `params` LIKE ("%Upcoming Event%");
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_contents`
SET `params` = REPLACE(params, "Html Block", "HTML Block")
WHERE `params` LIKE ("%Html Block%");
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_contents`
SET `params` = REPLACE(params, "Who's online", "Who's Online")
WHERE `params` LIKE ("%Who's online%");
]]>
</query>
<query><![CDATA[
truncate `{PREFIX}core_contents` ]]>
</query>
<query>
<![CDATA[
INSERT INTO `{PREFIX}core_contents` (`id`, `page_id`, `type`, `name`, `component`, `parent_id`, `order`, `params`, `attribs`, `lft`, `rght`, `column`, `core_block_id`, `core_content_count`, `invisible`) VALUES
(1, 1, 'container', 'west', '', NULL, 1, NULL, NULL, 1, 18, 0, 0, 8, 0),
(2, 1, 'widget', 'invisiblecontent', '', 1, 1, '{"title":"Home Menu","maincontent":"1"}', NULL, 2, 3, 0, 1, 0, 0),
(3, 1, 'container', 'center', '', NULL, 1, NULL, NULL, 19, 22, 0, 0, 1, 0),
(4, 1, 'widget', 'invisiblecontent', '', 3, 1, '{"title":"What''s New","maincontent":"1"}', NULL, 20, 21, 0, 1, 0, 0),
(5, 1, 'container', 'east', '', NULL, 1, NULL, NULL, 23, 36, 0, 0, 6, 0),
(6, 1, 'widget', 'invisiblecontent', '', 5, 6, '{"title":"Themes & Language","maincontent":"1"}', NULL, 24, 25, 0, 1, 0, 0),
(7, 2, 'container', 'east', '', NULL, 1, NULL, NULL, 37, 40, 0, 0, 1, 0),
(8, 2, 'widget', 'invisiblecontent', '', 7, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 38, 39, 0, 1, 0, 0),
(9, 2, 'container', 'center', '', NULL, 1, NULL, NULL, 41, 44, 0, 0, 1, 0),
(10, 2, 'widget', 'invisiblecontent', '', 9, 1, '{"title":"Contact","maincontent":"1"}', NULL, 42, 43, 0, 1, 0, 0),
(11, 3, 'container', 'west', '', NULL, 1, NULL, NULL, 45, 48, 0, 0, 1, 0),
(12, 3, 'widget', 'invisiblecontent', '', 11, 1, '{"title":"Menu friend & Search","maincontent":"1"}', NULL, 46, 47, 0, 1, 0, 0),
(13, 3, 'container', 'east', '', NULL, 1, NULL, NULL, 49, 52, 0, 0, 1, 0),
(14, 3, 'widget', 'invisiblecontent', '', 13, 1, '{"title":"Theme & Language","maincontent":"1"}', NULL, 50, 51, 0, 5, 0, 0),
(15, 3, 'container', 'center', '', NULL, 1, NULL, NULL, 53, 56, 0, 0, 1, 0),
(16, 3, 'widget', 'invisiblecontent', '', 15, 1, '{"title":"People","maincontent":"1"}', NULL, 54, 55, 0, 4, 0, 0),
(17, 4, 'container', 'west', '', NULL, 1, NULL, NULL, 57, 60, 0, 0, 1, 0),
(18, 4, 'widget', 'invisiblecontent', '', 17, 1, '{"title":"Profile menu & Users","maincontent":"1"}', NULL, 58, 59, 0, 1, 0, 0),
(19, 4, 'container', 'center', '', NULL, 1, NULL, NULL, 61, 66, 0, 0, 2, 0),
(20, 4, 'widget', 'invisiblecontent', '', 19, 1, '{"title":"Recent Activities","maincontent":"1"}', NULL, 62, 63, 0, 4, 0, 0),
(21, 5, 'container', 'center', '', NULL, 1, NULL, NULL, 67, 70, 0, 0, 1, 0),
(22, 5, 'widget', 'invisiblecontent', '', 21, 1, '{"title":"User Register","maincontent":"1"}', NULL, 68, 69, 0, 1, 0, 0),
(23, 6, 'container', 'west', '', NULL, 1, NULL, NULL, 71, 76, 0, 0, 2, 0),
(24, 6, 'widget', 'invisiblecontent', '', 23, 1, '{"title":"Blogs menu & Search","maincontent":"1"}', NULL, 72, 73, 0, 1, 0, 0),
(25, 6, 'container', 'east', '', NULL, 1, NULL, NULL, 77, 82, 0, 0, 2, 0),
(26, 6, 'widget', 'invisiblecontent', '', 25, 2, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 78, 79, 0, 5, 0, 0),
(27, 6, 'container', 'center', '', NULL, 1, NULL, NULL, 83, 86, 0, 0, 1, 0),
(28, 6, 'widget', 'invisiblecontent', '', 27, 1, '{"title":"Blogs","maincontent":"1"}', NULL, 84, 85, 0, 4, 0, 0),
(29, 8, 'container', 'west', '', NULL, 1, NULL, NULL, 87, 90, 0, 0, 1, 0),
(30, 8, 'widget', 'invisiblecontent', '', 29, 1, '{"title":"Blogs settings","maincontent":"1"}', NULL, 88, 89, 0, 1, 0, 0),
(31, 8, 'container', 'east', '', NULL, 1, NULL, NULL, 91, 94, 0, 0, 1, 0),
(32, 8, 'widget', 'invisiblecontent', '', 31, 1, '{"title":"Other Entries","maincontent":"1"}', NULL, 92, 93, 0, 5, 0, 0),
(33, 8, 'container', 'center', '', NULL, 1, NULL, NULL, 95, 98, 0, 0, 1, 0),
(34, 8, 'widget', 'invisiblecontent', '', 33, 1, '{"title":"Blog Detail","maincontent":"1"}', NULL, 96, 97, 0, 4, 0, 0),
(35, 9, 'container', 'west', '', NULL, 1, NULL, NULL, 99, 104, 0, 0, 2, 0),
(36, 9, 'widget', 'invisiblecontent', '', 35, 1, '{"title":"List photos & Search","maincontent":"1"}', NULL, 100, 101, 0, 1, 0, 0),
(37, 9, 'container', 'center', '', NULL, 1, NULL, NULL, 105, 108, 0, 0, 1, 0),
(38, 9, 'widget', 'invisiblecontent', '', 37, 1, '{"title":"Photos","maincontent":"1"}', NULL, 106, 107, 0, 4, 0, 0),
(39, 12, 'container', 'west', '', NULL, 1, NULL, NULL, 109, 114, 0, 0, 2, 0),
(40, 12, 'widget', 'invisiblecontent', '', 39, 1, '{"title":"Menu video & Search","maincontent":"1"}', NULL, 110, 111, 0, 1, 0, 0),
(41, 12, 'container', 'east', '', NULL, 1, NULL, NULL, 115, 118, 0, 0, 1, 0),
(42, 12, 'widget', 'invisiblecontent', '', 41, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 116, 117, 0, 5, 0, 0),
(43, 12, 'container', 'center', '', NULL, 1, NULL, NULL, 119, 122, 0, 0, 1, 0),
(44, 12, 'widget', 'invisiblecontent', '', 43, 1, '{"title":"Videos","maincontent":"1"}', NULL, 120, 121, 0, 4, 0, 0),
(45, 13, 'container', 'east', '', NULL, 1, NULL, NULL, 123, 126, 0, 0, 1, 0),
(46, 13, 'widget', 'invisiblecontent', '', 45, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 124, 125, 0, 4, 0, 0),
(47, 13, 'container', 'center', '', NULL, 1, NULL, NULL, 127, 130, 0, 0, 1, 0),
(48, 13, 'widget', 'invisiblecontent', '', 47, 1, '{"title":"Video''s content","maincontent":"1"}', NULL, 128, 129, 0, 1, 0, 0),
(49, 15, 'container', 'west', '', NULL, 1, NULL, NULL, 131, 138, 0, 0, 3, 0),
(50, 15, 'widget', 'invisiblecontent', '', 49, 1, '{"title":"Topic''s setting","maincontent":"1"}', NULL, 132, 133, 0, 1, 0, 0),
(51, 15, 'container', 'east', '', NULL, 1, NULL, NULL, 139, 142, 0, 0, 1, 0),
(52, 15, 'widget', 'invisiblecontent', '', 51, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 140, 141, 0, 5, 0, 0),
(53, 15, 'container', 'center', '', NULL, 1, NULL, NULL, 143, 146, 0, 0, 1, 0),
(54, 15, 'widget', 'invisiblecontent', '', 53, 1, '{"title":"Topics contents","maincontent":"1"}', NULL, 144, 145, 0, 4, 0, 0),
(55, 16, 'container', 'west', '', NULL, 1, NULL, NULL, 147, 150, 0, 0, 1, 0),
(56, 16, 'widget', 'invisiblecontent', '', 55, 1, '{"title":"Groups menu & Search","maincontent":"1"}', NULL, 148, 149, 0, 1, 0, 0),
(57, 16, 'container', 'east', '', NULL, 1, NULL, NULL, 151, 154, 0, 0, 1, 0),
(58, 16, 'widget', 'invisiblecontent', '', 57, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 152, 153, 0, 5, 0, 0),
(59, 16, 'container', 'center', '', NULL, 1, NULL, NULL, 155, 158, 0, 0, 1, 0),
(60, 16, 'widget', 'invisiblecontent', '', 59, 1, '{"title":"Groups","maincontent":"1"}', NULL, 156, 157, 0, 4, 0, 0),
(61, 18, 'container', 'west', '', NULL, 1, NULL, NULL, 159, 164, 0, 0, 2, 0),
(62, 18, 'widget', 'invisiblecontent', '', 61, 1, '{"title":"Group info & setting","maincontent":"1"}', NULL, 160, 161, 0, 1, 0, 0),
(63, 18, 'container', 'east', '', NULL, 1, NULL, NULL, 165, 170, 0, 0, 2, 0),
(64, 18, 'widget', 'invisiblecontent', '', 63, 2, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 166, 167, 0, 5, 0, 0),
(65, 18, 'container', 'center', '', NULL, 1, NULL, NULL, 171, 174, 0, 0, 1, 0),
(66, 18, 'widget', 'invisiblecontent', '', 65, 1, '{"title":"Info & Photos & Recent Activities","maincontent":"1"}', NULL, 172, 173, 0, 4, 0, 0),
(67, 19, 'container', 'west', '', NULL, 1, NULL, NULL, 175, 180, 0, 0, 2, 0),
(68, 19, 'widget', 'invisiblecontent', '', 67, 1, '{"title":"Events menu & Search","maincontent":"1"}', NULL, 176, 177, 0, 1, 0, 0),
(69, 19, 'container', 'east', '', NULL, 1, NULL, NULL, 181, 184, 0, 0, 1, 0),
(70, 19, 'widget', 'invisiblecontent', '', 69, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 182, 183, 0, 5, 0, 0),
(71, 19, 'container', 'center', '', NULL, 1, NULL, NULL, 185, 188, 0, 0, 1, 0),
(72, 19, 'widget', 'invisiblecontent', '', 71, 1, '{"title":"Events","maincontent":"1"}', NULL, 186, 187, 0, 4, 0, 0),
(73, 22, 'container', 'east', '', NULL, 1, NULL, NULL, 189, 192, 0, 0, 1, 0),
(74, 22, 'widget', 'invisiblecontent', '', 73, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 190, 191, 0, 4, 0, 0),
(75, 22, 'container', 'center', '', NULL, 1, NULL, NULL, 193, 196, 0, 0, 1, 0),
(76, 22, 'widget', 'invisiblecontent', '', 75, 1, '{"title":"Forgot Password","maincontent":"1"}', NULL, 194, 195, 0, 1, 0, 0),
(77, 23, 'container', 'west', '', NULL, 1, NULL, NULL, 197, 200, 0, 0, 1, 0),
(78, 23, 'widget', 'invisiblecontent', '', 77, 1, '{"title":"Topics menu & Search","maincontent":"1"}', NULL, 198, 199, 0, 1, 0, 0),
(79, 23, 'container', 'east', '', NULL, 1, NULL, NULL, 201, 204, 0, 0, 1, 0),
(80, 23, 'widget', 'invisiblecontent', '', 79, 1, '{"title":"Themes & Langguages","maincontent":"1"}', NULL, 202, 203, 0, 5, 0, 0),
(81, 23, 'container', 'center', '', NULL, 1, NULL, NULL, 205, 208, 0, 0, 1, 0),
(82, 23, 'widget', 'invisiblecontent', '', 81, 1, '{"title":"Topics","maincontent":"1"}', NULL, 206, 207, 0, 4, 0, 0),
(83, 63, 'container', 'east', '', NULL, 1, NULL, NULL, 209, 222, 0, 0, 6, 0),
(84, 63, 'widget', 'invisiblecontent', '', 83, 6, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 210, 211, 0, 1, 0, 0),
(85, 96, 'container', 'center', '', NULL, 1, NULL, NULL, 223, 226, 0, 0, 1, 0),
(86, 96, 'widget', 'invisiblecontent', '', 85, 1, '{"title":"Register Form","maincontent":"1"}', NULL, 224, 225, 0, 1, 0, 0),
(87, 90, 'container', 'center', '', NULL, 1, NULL, NULL, 227, 230, 0, 0, 1, 0),
(88, 90, 'widget', 'invisiblecontent', '', 87, 1, '{"title":"Login form","maincontent":"1"}', NULL, 228, 229, 0, 1, 0, 0),
(89, 10, 'container', 'east', '', NULL, 1, NULL, NULL, 231, 234, 0, 0, 1, 0),
(90, 10, 'widget', 'invisiblecontent', '', 89, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 232, 233, 0, 4, 0, 0),
(91, 10, 'container', 'center', '', NULL, 1, NULL, NULL, 235, 238, 0, 0, 1, 0),
(92, 10, 'widget', 'invisiblecontent', '', 91, 1, '{"title":"Album''s photos","maincontent":"1"}', NULL, 236, 237, 0, 1, 0, 0),
(93, 11, 'container', 'center', '', NULL, 1, NULL, NULL, 239, 246, 0, 0, 3, 0),
(94, 11, 'widget', 'invisiblecontent', '', 93, 1, '{"title":"Page Content","maincontent":"1"}', NULL, 240, 241, 0, 1, 0, 0),
(95, 21, 'container', 'west', '', NULL, 1, NULL, NULL, 247, 254, 0, 0, 3, 0),
(96, 21, 'widget', 'invisiblecontent', '', 95, 1, '{"title":"Event''s setting","maincontent":"1"}', NULL, 248, 249, 0, 1, 0, 0),
(97, 21, 'container', 'east', '', NULL, 1, NULL, NULL, 255, 258, 0, 0, 1, 0),
(98, 21, 'widget', 'invisiblecontent', '', 97, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 256, 257, 0, 5, 0, 0),
(99, 21, 'container', 'center', '', NULL, 1, NULL, NULL, 259, 262, 0, 0, 1, 0),
(100, 21, 'widget', 'invisiblecontent', '', 99, 1, '{"title":"Event''s detail & Message","maincontent":"1"}', NULL, 260, 261, 0, 4, 0, 0),
(101, 1, 'widget', 'events.upcoming', '', 1, 2, '{"title":"Upcoming Events","num_item_show":"10","title_enable":"1"}', NULL, 4, 5, 0, 8, 0, 0),
(102, 1, 'widget', 'groups.myJoined', '', 1, 3, '{"title":"My Joined Groups","num_item_show":"10","title_enable":"1"}', NULL, 6, 7, 0, 9, 0, 0),
(103, 1, 'widget', 'blogs.popular', '', 1, 4, '{"title":"Popular Blogs","num_item_show":"10","title_enable":"1"}', NULL, 8, 9, 0, 14, 0, 0),
(104, 1, 'widget', 'photos.popularAlbums', '', 1, 5, '{"title":"Popular Albums","num_item_show":"10","title_enable":"1"}', NULL, 10, 11, 0, 15, 0, 0),
(105, 1, 'widget', 'videos.popular', '', 1, 6, '{"title":"Popular Videos","num_item_show":"10","title_enable":"1"}', NULL, 12, 13, 0, 16, 0, 0),
(106, 1, 'widget', 'groups.popular', '', 1, 7, '{"title":"Popular Groups","num_item_show":"10","title_enable":"1"}', NULL, 14, 15, 0, 18, 0, 0),
(107, 1, 'widget', 'events.popular', '', 1, 8, '{"title":"Popular Events","num_item_show":"10","title_enable":"1"}', NULL, 16, 17, 0, 19, 0, 0),
(108, 1, 'widget', 'user.onlineUsers', '', 5, 1, '{"title":"Who''s Online","num_item_show":"10","title_enable":"1"}', NULL, 26, 27, 0, 1, 0, 0),
(109, 1, 'widget', 'user.recentlyJoined', '', 5, 2, '{"title":"Recently Joined","num_item_show":"10","title_enable":"1"}', NULL, 28, 29, 0, 4, 0, 0),
(110, 1, 'widget', 'user.friend', '', 5, 3, '{"title":"Friends","num_item_show":"10","title_enable":"1"}', NULL, 30, 31, 0, 7, 0, 0),
(111, 1, 'widget', 'user.featured', '', 5, 4, '{"title":"Featured Members","num_item_show":"10","title_enable":"1"}', NULL, 32, 33, 0, 49, 0, 0),
(112, 1, 'widget', 'user.suggestions', '', 5, 5, '{"title":"People You May Know","num_item_show":"10","title_enable":"1"}', NULL, 34, 35, 0, 53, 0, 0),
(113, 6, 'widget', 'blogs.popular', '', 23, 2, '{"title":"Popular Blogs","num_item_show":"10","title_enable":"1"}', NULL, 74, 75, 0, 14, 0, 0),
(114, 6, 'widget', 'core.tags', '', 25, 1, '{"title":"Popular Tags","num_item_show":"10","type":"all","title_enable":"1"}', NULL, 80, 81, 0, 5, 0, 0),
(115, 9, 'widget', 'photos.popularAlbums', '', 35, 2, '{"title":"Popular Albums","num_item_show":"10","title_enable":"1"}', NULL, 102, 103, 0, 15, 0, 0),
(116, 11, 'widget', 'events.upcoming', '', 93, 2, '{"title":"Upcoming Events","num_item_show":"10","title_enable":"1"}', NULL, 242, 243, 0, 8, 0, 0),
(117, 11, 'widget', 'user.onlineUsers', '', 93, 3, '{"title":"Who''s Online","num_item_show":"10","title_enable":"1"}', NULL, 244, 245, 0, 1, 0, 0),
(118, 12, 'widget', 'videos.popular', '', 39, 2, '{"title":"Popular Videos","num_item_show":"10","title_enable":"1"}', NULL, 112, 113, 0, 16, 0, 0),
(119, 15, 'widget', 'core.tags', '', 49, 2, '{"title":"Popular Tags","num_item_show":"10","type":"all","title_enable":"1"}', NULL, 134, 135, 0, 5, 0, 0),
(120, 15, 'widget', 'topics.popular', '', 49, 3, '{"title":"Popular Topics","num_item_show":"10","title_enable":"1"}', NULL, 136, 137, 0, 17, 0, 0),
(121, 18, 'widget', 'groups.adminList', '', 61, 2, '{"title":"Admin","num_item_show":"10","title_enable":"1"}', NULL, 162, 163, 0, 51, 0, 0),
(122, 18, 'widget', 'user.onlineUsers', '', 63, 1, '{"title":"Who''s Online","num_item_show":"10","title_enable":"1"}', NULL, 168, 169, 0, 1, 0, 0),
(123, 19, 'widget', 'events.popular', '', 67, 2, '{"title":"Popular Events","num_item_show":"10","title_enable":"1"}', NULL, 178, 179, 0, 19, 0, 0),
(124, 21, 'widget', 'events.rsvp', '', 95, 2, '{"title":"RSVP","title_enable":"1"}', NULL, 250, 251, 0, 54, 0, 0),
(125, 21, 'widget', 'events.attending', '', 95, 3, '{"title":"Event Attending","title_enable":"1"}', NULL, 252, 253, 0, 55, 0, 0),
(126, 63, 'container', 'west', '', NULL, 1, NULL, NULL, 263, 284, 0, 0, 10, 0),
(127, 63, 'widget', 'events.upcoming', '', 126, 1, '{"title":"Upcoming Events","num_item_show":"10","title_enable":"1"}', NULL, 264, 265, 0, 8, 0, 0),
(128, 63, 'widget', 'groups.myJoined', '', 126, 2, '{"title":"My Joined Groups","num_item_show":"10","title_enable":"1"}', NULL, 266, 267, 0, 9, 0, 0),
(129, 63, 'widget', 'blogs.popular', '', 126, 3, '{"title":"Popular Blogs","num_item_show":"10","title_enable":"1"}', NULL, 268, 269, 0, 14, 0, 0),
(130, 63, 'widget', 'photos.popularAlbums', '', 126, 4, '{"title":"Popular Albums","num_item_show":"10","title_enable":"1"}', NULL, 270, 271, 0, 15, 0, 0),
(131, 63, 'widget', 'videos.popular', '', 126, 5, '{"title":"Popular Videos","num_item_show":"10","title_enable":"1"}', NULL, 272, 273, 0, 16, 0, 0),
(132, 63, 'widget', 'groups.popular', '', 126, 6, '{"title":"Popular Groups","num_item_show":"10","title_enable":"1"}', NULL, 274, 275, 0, 18, 0, 0),
(133, 63, 'widget', 'events.popular', '', 126, 7, '{"title":"Popular Events","num_item_show":"10","title_enable":"1"}', NULL, 276, 277, 0, 19, 0, 0),
(134, 63, 'widget', 'user.onlineUsers', '', 83, 1, '{"title":"Who''s Online","num_item_show":"10","title_enable":"1"}', NULL, 212, 213, 0, 1, 0, 0),
(135, 63, 'widget', 'user.recentlyJoined', '', 83, 2, '{"title":"Recently Joined","num_item_show":"10","title_enable":"1"}', NULL, 214, 215, 0, 4, 0, 0),
(136, 63, 'widget', 'user.friend', '', 83, 3, '{"title":"Friends","num_item_show":"10","title_enable":"1"}', NULL, 216, 217, 0, 7, 0, 0),
(137, 63, 'widget', 'user.featured', '', 83, 4, '{"title":"Featured Members","num_item_show":"10","title_enable":"1"}', NULL, 218, 219, 0, 49, 0, 0),
(138, 63, 'widget', 'user.suggestions', '', 83, 5, '{"title":"People You May Know","num_item_show":"10","title_enable":"1"}', NULL, 220, 221, 0, 53, 0, 0),
(139, 63, 'container', 'center', '', NULL, 1, NULL, NULL, 285, 290, 0, 0, 2, 0),
(140, 63, 'widget', 'ajax.home_activity', '', 139, 2, '{"title":"What''s new","title_enable":"1"}', NULL, 286, 287, 0, 6, 0, 0),
(141, 4, 'widget', 'ajax.home_activity', '', 19, 2, '{"title":"What''s new","title_enable":"1"}', NULL, 64, 65, 0, 6, 0, 0),
(142, 63, 'widget', 'htmlBlock', '', 126, 8, '{"title":"HTML Block","html_block":"<h3>Fast & Flexible</h3><p>mooSocial is fast and user friendly thanks to the use of ajax. It is also easy to make changes to the layout because all the template files are separated from the logic code.</p>","title_enable":""}', NULL, 278, 279, 0, 56, 0, 0),
(143, 63, 'widget', 'htmlBlock', '', 126, 9, '{"title":"HTML Block","html_block":"<h3>CMS Independent</h3><p>Unlike some social networking scripts, mooSocial is a standalone product. You don''t need to install a CMS to run it. As a result, your site will be much faster and easier to customize</p>","title_enable":""}', NULL, 280, 281, 0, 56, 0, 0),
(144, 63, 'widget', 'htmlBlock', '', 126, 10, '{"title":"HTML Block","html_block":"<h3>RESPONSIVENESS</h3><p>mooSocial''s mobile theme is optimized for mobile devices. It gives your users a better experience when browsing on their phones or tablets.</p>","title_enable":""}', NULL, 282, 283, 0, 56, 0, 0),
(145, 63, 'widget', 'htmlBlock', '', 139, 1, '{"title":"HTML Block","html_block":"<h3>Your Social Network starts here with mooSocial!</h3><p>mooSocial has all the features to build a successful community. It is fast, easy to customize, and CMS independent</p>","title_enable":""}', NULL, 288, 289, 0, 56, 0, 0);
]]>
</query>
</queries>
</version>
<version>
<number>2.1.3</number>
<queries>
<query><![CDATA[
UPDATE `{PREFIX}core_contents` SET `name` = 'invisiblecontent' WHERE `{PREFIX}core_contents`.`id` = 74;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_contents` SET `name` = 'invisiblecontent' WHERE `{PREFIX}core_contents`.`id` = 76;
]]>
</query>
<query><![CDATA[
DELETE FROM `{PREFIX}pages` WHERE `{PREFIX}pages`.`id` = 5; ]]>
</query>
<query><![CDATA[
truncate `{PREFIX}core_contents` ]]>
</query>
<query>
<![CDATA[
INSERT INTO `{PREFIX}core_contents` (`id`, `page_id`, `type`, `name`, `component`, `parent_id`, `order`, `params`, `attribs`, `lft`, `rght`, `column`, `core_block_id`, `core_content_count`, `invisible`) VALUES
(1, 1, 'container', 'west', '', NULL, 1, NULL, NULL, 1, 18, 0, 0, 8, 0),
(2, 1, 'widget', 'invisiblecontent', '', 1, 1, '{"title":"Home Menu","maincontent":"1"}', NULL, 2, 3, 0, 1, 0, 0),
(3, 1, 'container', 'east', '', NULL, 1, NULL, NULL, 19, 34, 0, 0, 7, 0),
(4, 1, 'widget', 'invisiblecontent', '', 3, 6, '{"title":"Themes & Language","maincontent":"1"}', NULL, 20, 21, 0, 5, 0, 0),
(5, 1, 'container', 'center', '', NULL, 1, NULL, NULL, 35, 38, 0, 0, 1, 0),
(6, 1, 'widget', 'invisiblecontent', '', 5, 1, '{"title":"What''s New","maincontent":"1"}', NULL, 36, 37, 0, 4, 0, 0),
(7, 1, 'widget', 'events.upcoming', '', 1, 2, '{"title":"Upcoming Events","num_item_show":"10","title_enable":"1"}', NULL, 4, 5, 0, 8, 0, 0),
(8, 1, 'widget', 'groups.myJoined', '', 1, 3, '{"title":"My Joined Groups","num_item_show":"10","title_enable":"1"}', NULL, 6, 7, 0, 9, 0, 0),
(9, 1, 'widget', 'blogs.popular', '', 1, 4, '{"title":"Popular Blogs","num_item_show":"10","title_enable":"1"}', NULL, 8, 9, 0, 14, 0, 0),
(10, 1, 'widget', 'photos.popularAlbums', '', 1, 5, '{"title":"Popular Albums","num_item_show":"10","title_enable":"1"}', NULL, 10, 11, 0, 15, 0, 0),
(11, 1, 'widget', 'videos.popular', '', 1, 6, '{"title":"Popular Videos","num_item_show":"10","title_enable":"1"}', NULL, 12, 13, 0, 16, 0, 0),
(12, 1, 'widget', 'groups.popular', '', 1, 7, '{"title":"Popular Groups","num_item_show":"10","title_enable":"1"}', NULL, 14, 15, 0, 18, 0, 0),
(13, 1, 'widget', 'events.popular', '', 1, 8, '{"title":"Popular Events","num_item_show":"10","title_enable":"1"}', NULL, 16, 17, 0, 19, 0, 0),
(14, 1, 'widget', 'user.onlineUsers', '', 3, 1, '{"title":"Who''s Online","num_item_show":"10","title_enable":"1"}', NULL, 22, 23, 0, 1, 0, 0),
(15, 1, 'widget', 'user.recentlyJoined', '', 3, 2, '{"title":"Recently Joined","num_item_show":"10","title_enable":"1"}', NULL, 24, 25, 0, 4, 0, 0),
(16, 1, 'widget', 'user.friend', '', 3, 3, '{"title":"Friends","num_item_show":"10","title_enable":"1"}', NULL, 26, 27, 0, 7, 0, 0),
(17, 1, 'widget', 'user.featured', '', 3, 4, '{"title":"Featured Members","num_item_show":"10","title_enable":"1"}', NULL, 28, 29, 0, 49, 0, 0),
(18, 1, 'widget', 'user.suggestions', '', 3, 5, '{"title":"People You May Know","num_item_show":"10","title_enable":"1"}', NULL, 30, 31, 0, 53, 0, 0),
(19, 2, 'container', 'east', '', NULL, 1, NULL, NULL, 39, 42, 0, 0, 1, 0),
(20, 2, 'widget', 'invisiblecontent', '', 19, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 40, 41, 0, 4, 0, 0),
(21, 2, 'container', 'center', '', NULL, 1, NULL, NULL, 43, 46, 0, 0, 1, 0),
(22, 2, 'widget', 'invisiblecontent', '', 21, 1, '{"title":"Contact","maincontent":"1"}', NULL, 44, 45, 0, 1, 0, 0),
(23, 3, 'container', 'west', '', NULL, 1, NULL, NULL, 47, 50, 0, 0, 1, 0),
(24, 3, 'widget', 'invisiblecontent', '', 23, 1, '{"title":"Menu friend & Search","maincontent":"1"}', NULL, 48, 49, 0, 1, 0, 0),
(25, 3, 'container', 'east', '', NULL, 1, NULL, NULL, 51, 54, 0, 0, 1, 0),
(26, 3, 'widget', 'invisiblecontent', '', 25, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 52, 53, 0, 5, 0, 0),
(27, 3, 'container', 'center', '', NULL, 1, NULL, NULL, 55, 58, 0, 0, 1, 0),
(28, 3, 'widget', 'invisiblecontent', '', 27, 1, '{"title":"People","maincontent":"1"}', NULL, 56, 57, 0, 4, 0, 0),
(29, 4, 'container', 'west', '', NULL, 1, NULL, NULL, 59, 62, 0, 0, 1, 0),
(30, 4, 'widget', 'invisiblecontent', '', 29, 1, '{"title":"Profile menu & Users","maincontent":"1"}', NULL, 60, 61, 0, 1, 0, 0),
(31, 4, 'container', 'center', '', NULL, 1, NULL, NULL, 63, 66, 0, 0, 1, 0),
(32, 4, 'widget', 'invisiblecontent', '', 31, 1, '{"title":"Recent Activities","maincontent":"1"}', NULL, 64, 65, 0, 4, 0, 0),
(34, 6, 'container', 'west', '', NULL, 1, NULL, NULL, 67, 72, 0, 0, 2, 0),
(35, 6, 'widget', 'invisiblecontent', '', 34, 1, '{"title":"Blogs menu & Search","maincontent":"1"}', NULL, 68, 69, 0, 1, 0, 0),
(36, 6, 'container', 'east', '', NULL, 1, NULL, NULL, 73, 78, 0, 0, 2, 0),
(37, 6, 'widget', 'invisiblecontent', '', 36, 2, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 74, 75, 0, 5, 0, 0),
(38, 6, 'container', 'center', '', NULL, 1, NULL, NULL, 79, 82, 0, 0, 1, 0),
(39, 6, 'widget', 'invisiblecontent', '', 38, 1, '{"title":"Blogs","maincontent":"1"}', NULL, 80, 81, 0, 4, 0, 0),
(40, 6, 'widget', 'blogs.popular', '', 34, 2, '{"title":"Popular Blogs","num_item_show":"10","title_enable":"1"}', NULL, 70, 71, 0, 14, 0, 0),
(41, 6, 'widget', 'core.tags', '', 36, 1, '{"title":"Popular Tags","num_item_show":"10","type":"all","title_enable":"1"}', NULL, 76, 77, 0, 5, 0, 0),
(42, 8, 'container', 'west', '', NULL, 1, NULL, NULL, 83, 86, 0, 0, 1, 0),
(43, 8, 'widget', 'invisiblecontent', '', 42, 1, '{"title":"Blogs settings","maincontent":"1"}', NULL, 84, 85, 0, 1, 0, 0),
(44, 8, 'container', 'east', '', NULL, 1, NULL, NULL, 87, 90, 0, 0, 1, 0),
(45, 8, 'widget', 'invisiblecontent', '', 44, 1, '{"title":"Other Entries","maincontent":"1"}', NULL, 88, 89, 0, 5, 0, 0),
(46, 8, 'container', 'center', '', NULL, 1, NULL, NULL, 91, 94, 0, 0, 1, 0),
(47, 8, 'widget', 'invisiblecontent', '', 46, 1, '{"title":"Blog Detail","maincontent":"1"}', NULL, 92, 93, 0, 4, 0, 0),
(48, 9, 'container', 'west', '', NULL, 1, NULL, NULL, 95, 100, 0, 0, 2, 0),
(49, 9, 'widget', 'invisiblecontent', '', 48, 1, '{"title":"List photos & Search","maincontent":"1"}', NULL, 96, 97, 0, 1, 0, 0),
(50, 9, 'container', 'center', '', NULL, 1, NULL, NULL, 101, 104, 0, 0, 1, 0),
(51, 9, 'widget', 'invisiblecontent', '', 50, 1, '{"title":"Photos","maincontent":"1"}', NULL, 102, 103, 0, 4, 0, 0),
(52, 9, 'widget', 'photos.popularAlbums', '', 48, 2, '{"title":"Popular Albums","num_item_show":"10","title_enable":"1"}', NULL, 98, 99, 0, 15, 0, 0),
(53, 10, 'container', 'east', '', NULL, 1, NULL, NULL, 105, 108, 0, 0, 1, 0),
(54, 10, 'widget', 'invisiblecontent', '', 53, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 106, 107, 0, 4, 0, 0),
(55, 10, 'container', 'center', '', NULL, 1, NULL, NULL, 109, 112, 0, 0, 1, 0),
(56, 10, 'widget', 'invisiblecontent', '', 55, 1, '{"title":"Album''s photos","maincontent":"1"}', NULL, 110, 111, 0, 1, 0, 0),
(57, 11, 'container', 'center', '', NULL, 1, NULL, NULL, 113, 120, 0, 0, 3, 0),
(58, 11, 'widget', 'invisiblecontent', '', 57, 1, '{"title":"Page Content","maincontent":"1"}', NULL, 114, 115, 0, 1, 0, 0),
(59, 11, 'widget', 'events.upcoming', '', 57, 2, '{"title":"Upcoming Events","num_item_show":"10","title_enable":"1"}', NULL, 116, 117, 0, 8, 0, 0),
(60, 11, 'widget', 'user.onlineUsers', '', 57, 3, '{"title":"Who''s Online","num_item_show":"10","title_enable":"1"}', NULL, 118, 119, 0, 1, 0, 0),
(61, 12, 'container', 'west', '', NULL, 1, NULL, NULL, 121, 126, 0, 0, 2, 0),
(62, 12, 'widget', 'invisiblecontent', '', 61, 1, '{"title":"Menu video & Search","maincontent":"1"}', NULL, 122, 123, 0, 1, 0, 0),
(63, 12, 'container', 'east', '', NULL, 1, NULL, NULL, 127, 130, 0, 0, 1, 0),
(64, 12, 'widget', 'invisiblecontent', '', 63, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 128, 129, 0, 5, 0, 0),
(65, 12, 'container', 'center', '', NULL, 1, NULL, NULL, 131, 134, 0, 0, 1, 0),
(66, 12, 'widget', 'invisiblecontent', '', 65, 1, '{"title":"Videos","maincontent":"1"}', NULL, 132, 133, 0, 4, 0, 0),
(67, 12, 'widget', 'videos.popular', '', 61, 2, '{"title":"Popular Videos","num_item_show":"10","title_enable":"1"}', NULL, 124, 125, 0, 16, 0, 0),
(68, 13, 'container', 'east', '', NULL, 1, NULL, NULL, 135, 138, 0, 0, 1, 0),
(69, 13, 'widget', 'invisiblecontent', '', 68, 1, '{"title":"Tags & Similar Videos","maincontent":"1"}', NULL, 136, 137, 0, 4, 0, 0),
(70, 13, 'container', 'center', '', NULL, 1, NULL, NULL, 139, 142, 0, 0, 1, 0),
(71, 13, 'widget', 'invisiblecontent', '', 70, 1, '{"title":"Video''s content","maincontent":"1"}', NULL, 140, 141, 0, 1, 0, 0),
(72, 15, 'container', 'west', '', NULL, 1, NULL, NULL, 143, 150, 0, 0, 3, 0),
(73, 15, 'widget', 'invisiblecontent', '', 72, 1, '{"title":"Topic''s setting","maincontent":"1"}', NULL, 144, 145, 0, 1, 0, 0),
(74, 15, 'container', 'east', '', NULL, 1, NULL, NULL, 151, 154, 0, 0, 1, 0),
(75, 15, 'widget', 'invisiblecontent', '', 74, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 152, 153, 0, 5, 0, 0),
(76, 15, 'container', 'center', '', NULL, 1, NULL, NULL, 155, 158, 0, 0, 1, 0),
(77, 15, 'widget', 'invisiblecontent', '', 76, 1, '{"title":"Topics contents","maincontent":"1"}', NULL, 156, 157, 0, 4, 0, 0),
(78, 15, 'widget', 'core.tags', '', 72, 2, '{"title":"Popular Tags","num_item_show":"10","type":"all","title_enable":"1"}', NULL, 146, 147, 0, 5, 0, 0),
(79, 15, 'widget', 'topics.popular', '', 72, 3, '{"title":"Popular Topics","num_item_show":"10","title_enable":"1"}', NULL, 148, 149, 0, 17, 0, 0),
(80, 16, 'container', 'west', '', NULL, 1, NULL, NULL, 159, 162, 0, 0, 1, 0),
(81, 16, 'widget', 'invisiblecontent', '', 80, 1, '{"title":"Groups menu & Search","maincontent":"1"}', NULL, 160, 161, 0, 1, 0, 0),
(82, 16, 'container', 'east', '', NULL, 1, NULL, NULL, 163, 166, 0, 0, 1, 0),
(83, 16, 'widget', 'invisiblecontent', '', 82, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 164, 165, 0, 5, 0, 0),
(84, 16, 'container', 'center', '', NULL, 1, NULL, NULL, 167, 170, 0, 0, 1, 0),
(85, 16, 'widget', 'invisiblecontent', '', 84, 1, '{"title":"Groups","maincontent":"1"}', NULL, 168, 169, 0, 4, 0, 0),
(86, 18, 'container', 'west', '', NULL, 1, NULL, NULL, 171, 176, 0, 0, 2, 0),
(87, 18, 'widget', 'invisiblecontent', '', 86, 1, '{"title":"Group info & setting","maincontent":"1"}', NULL, 172, 173, 0, 1, 0, 0),
(88, 18, 'container', 'east', '', NULL, 1, NULL, NULL, 177, 182, 0, 0, 2, 0),
(89, 18, 'widget', 'invisiblecontent', '', 88, 2, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 178, 179, 0, 5, 0, 0),
(90, 18, 'container', 'center', '', NULL, 1, NULL, NULL, 183, 186, 0, 0, 1, 0),
(91, 18, 'widget', 'invisiblecontent', '', 90, 1, '{"title":"Info & Photos & Recent Activities","maincontent":"1"}', NULL, 184, 185, 0, 4, 0, 0),
(92, 18, 'widget', 'groups.adminList', '', 86, 2, '{"title":"Admin","num_item_show":"10","title_enable":"1"}', NULL, 174, 175, 0, 51, 0, 0),
(93, 18, 'widget', 'user.onlineUsers', '', 88, 1, '{"title":"Who''s Online","num_item_show":"10","title_enable":"1"}', NULL, 180, 181, 0, 1, 0, 0),
(94, 19, 'container', 'west', '', NULL, 1, NULL, NULL, 187, 192, 0, 0, 2, 0),
(95, 19, 'widget', 'invisiblecontent', '', 94, 1, '{"title":"Events menu & Search","maincontent":"1"}', NULL, 188, 189, 0, 1, 0, 0),
(96, 19, 'container', 'east', '', NULL, 1, NULL, NULL, 193, 196, 0, 0, 1, 0),
(97, 19, 'widget', 'invisiblecontent', '', 96, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 194, 195, 0, 5, 0, 0),
(98, 19, 'container', 'center', '', NULL, 1, NULL, NULL, 197, 200, 0, 0, 1, 0),
(99, 19, 'widget', 'invisiblecontent', '', 98, 1, '{"title":"Events","maincontent":"1"}', NULL, 198, 199, 0, 4, 0, 0),
(100, 19, 'widget', 'events.popular', '', 94, 2, '{"title":"Popular Events","num_item_show":"10","title_enable":"1"}', NULL, 190, 191, 0, 19, 0, 0),
(101, 21, 'container', 'west', '', NULL, 1, NULL, NULL, 201, 208, 0, 0, 3, 0),
(102, 21, 'widget', 'invisiblecontent', '', 101, 1, '{"title":"Event''s setting","maincontent":"1"}', NULL, 202, 203, 0, 1, 0, 0),
(103, 21, 'container', 'east', '', NULL, 1, NULL, NULL, 209, 212, 0, 0, 1, 0),
(104, 21, 'widget', 'invisiblecontent', '', 103, 1, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 210, 211, 0, 5, 0, 0),
(105, 21, 'container', 'center', '', NULL, 1, NULL, NULL, 213, 216, 0, 0, 1, 0),
(106, 21, 'widget', 'invisiblecontent', '', 105, 1, '{"title":"Event''s detail & Message","maincontent":"1"}', NULL, 214, 215, 0, 4, 0, 0),
(107, 21, 'widget', 'events.rsvp', '', 101, 2, '{"title":"RSVP","title_enable":"1"}', NULL, 204, 205, 0, 54, 0, 0),
(108, 21, 'widget', 'events.attending', '', 101, 3, '{"title":"Event Attending","title_enable":"1"}', NULL, 206, 207, 0, 55, 0, 0),
(109, 22, 'container', 'east', '', NULL, 1, NULL, NULL, 217, 218, 0, 0, 0, 0),
(111, 22, 'container', 'center', '', NULL, 1, NULL, NULL, 219, 222, 0, 0, 1, 0),
(112, 22, 'widget', 'invisiblecontent', '', 111, 1, '{"title":"Forgot Password","maincontent":"1"}', NULL, 220, 221, 0, 1, 0, 0),
(113, 23, 'container', 'west', '', NULL, 1, NULL, NULL, 223, 226, 0, 0, 1, 0),
(114, 23, 'widget', 'invisiblecontent', '', 113, 1, '{"title":"Topics menu & Search","maincontent":"1"}', NULL, 224, 225, 0, 1, 0, 0),
(115, 23, 'container', 'east', '', NULL, 1, NULL, NULL, 227, 230, 0, 0, 1, 0),
(116, 23, 'widget', 'invisiblecontent', '', 115, 1, '{"title":"Themes & Langguages","maincontent":"1"}', NULL, 228, 229, 0, 5, 0, 0),
(117, 23, 'container', 'center', '', NULL, 1, NULL, NULL, 231, 234, 0, 0, 1, 0),
(118, 23, 'widget', 'invisiblecontent', '', 117, 1, '{"title":"Topics","maincontent":"1"}', NULL, 232, 233, 0, 4, 0, 0),
(119, 63, 'container', 'east', '', NULL, 1, NULL, NULL, 235, 248, 0, 0, 6, 0),
(120, 63, 'widget', 'invisiblecontent', '', 119, 6, '{"title":"Themes & Languages","maincontent":"1"}', NULL, 236, 237, 0, 1, 0, 0),
(121, 63, 'container', 'west', '', NULL, 1, NULL, NULL, 249, 270, 0, 0, 10, 0),
(122, 63, 'widget', 'events.upcoming', '', 121, 1, '{"title":"Upcoming Events","num_item_show":"10","title_enable":"1"}', NULL, 250, 251, 0, 8, 0, 0),
(123, 63, 'widget', 'groups.myJoined', '', 121, 2, '{"title":"My Joined Groups","num_item_show":"10","title_enable":"1"}', NULL, 252, 253, 0, 9, 0, 0),
(124, 63, 'widget', 'blogs.popular', '', 121, 3, '{"title":"Popular Blogs","num_item_show":"10","title_enable":"1"}', NULL, 254, 255, 0, 14, 0, 0),
(125, 63, 'widget', 'photos.popularAlbums', '', 121, 4, '{"title":"Popular Albums","num_item_show":"10","title_enable":"1"}', NULL, 256, 257, 0, 15, 0, 0),
(126, 63, 'widget', 'videos.popular', '', 121, 5, '{"title":"Popular Videos","num_item_show":"10","title_enable":"1"}', NULL, 258, 259, 0, 16, 0, 0),
(127, 63, 'widget', 'groups.popular', '', 121, 6, '{"title":"Popular Groups","num_item_show":"10","title_enable":"1"}', NULL, 260, 261, 0, 18, 0, 0),
(128, 63, 'widget', 'events.popular', '', 121, 7, '{"title":"Popular Events","num_item_show":"10","title_enable":"1"}', NULL, 262, 263, 0, 19, 0, 0),
(129, 63, 'widget', 'htmlBlock', '', 121, 8, '{"title":"HTML Block","html_block":"<h3>Fast & Flexible</h3><p>mooSocial is fast and user friendly thanks to the use of ajax. It is also easy to make changes to the layout because all the template files are separated from the logic code.</p>","title_enable":""}', NULL, 264, 265, 0, 56, 0, 0),
(130, 63, 'widget', 'htmlBlock', '', 121, 9, '{"title":"HTML Block","html_block":"<h3>CMS Independent</h3><p>Unlike some social networking scripts, mooSocial is a standalone product. You don''t need to install a CMS to run it. As a result, your site will be much faster and easier to customize</p>","title_enable":""}', NULL, 266, 267, 0, 56, 0, 0),
(131, 63, 'widget', 'htmlBlock', '', 121, 10, '{"title":"HTML Block","html_block":"<h3>RESPONSIVENESS</h3><p>mooSocial''s mobile theme is optimized for mobile devices. It gives your users a better experience when browsing on their phones or tablets.</p>","title_enable":""}', NULL, 268, 269, 0, 56, 0, 0),
(132, 63, 'widget', 'user.onlineUsers', '', 119, 1, '{"title":"Who''s Online","num_item_show":"10","title_enable":"1"}', NULL, 238, 239, 0, 1, 0, 0),
(133, 63, 'widget', 'user.recentlyJoined', '', 119, 2, '{"title":"Recently Joined","num_item_show":"10","title_enable":"1"}', NULL, 240, 241, 0, 4, 0, 0),
(134, 63, 'widget', 'user.friend', '', 119, 3, '{"title":"Friends","num_item_show":"10","title_enable":"1"}', NULL, 242, 243, 0, 7, 0, 0),
(135, 63, 'widget', 'user.featured', '', 119, 4, '{"title":"Featured Members","num_item_show":"10","title_enable":"1"}', NULL, 244, 245, 0, 49, 0, 0),
(136, 63, 'widget', 'user.suggestions', '', 119, 5, '{"title":"People You May Know","num_item_show":"10","title_enable":"1"}', NULL, 246, 247, 0, 53, 0, 0),
(137, 63, 'container', 'center', '', NULL, 1, NULL, NULL, 271, 276, 0, 0, 2, 0),
(138, 63, 'widget', 'htmlBlock', '', 137, 1, '{"title":"HTML Block","html_block":"<h3>Your Social Network starts here with mooSocial!</h3><p>mooSocial has all the features to build a successful community. It is fast, easy to customize, and CMS independent</p>","title_enable":""}', NULL, 272, 273, 0, 56, 0, 0),
(139, 63, 'widget', 'ajax.home_activity', '', 137, 2, '{"title":"What''s new","title_enable":"1"}', NULL, 274, 275, 0, 6, 0, 0),
(140, 90, 'container', 'center', '', NULL, 1, NULL, NULL, 277, 280, 0, 0, 1, 0),
(141, 90, 'widget', 'invisiblecontent', '', 140, 1, '{"title":"Login form","maincontent":"1"}', NULL, 278, 279, 0, 1, 0, 0),
(142, 96, 'container', 'center', '', NULL, 1, NULL, NULL, 281, 284, 0, 0, 1, 0),
(143, 96, 'widget', 'invisiblecontent', '', 142, 1, '{"title":"Register Form","maincontent":"1"}', NULL, 282, 283, 0, 1, 0, 0),
(145, 1, 'widget', 'birthdayBlock', '', 3, 7, '{"title":"Today''s birthday","title_enable":"1"}', NULL, 32, 33, 0, 57, 0, 0);
]]>
</query>
<query>
<![CDATA[
INSERT IGNORE INTO `{PREFIX}core_blocks` (`id`, `name`, `path_view`, `params`, `is_active`, `plugin_id`, `group`, `restricted`) VALUES(57, 'Today''s birthday', 'birthdayBlock', '{"0":{"label":"Title","input":"text","value":"Today''s birthday","name":"title"},"1":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'user', '');
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}pages` SET `uri` = 'users.register' WHERE `{PREFIX}pages`.`id` = 96;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}pages` SET `title` = 'Album Detail Page' WHERE `{PREFIX}pages`.`id` = 10;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `restricted` = 'home.landing' WHERE `{PREFIX}core_blocks`.`id` = 6;
]]>
</query>
</queries>
</version>
<version>
<number>2.2.0</number>
<queries>
<query><![CDATA[
ALTER TABLE `{PREFIX}activities` ADD `plugin` VARCHAR( 128 ) NOT NULL; ]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}categories` SET `type` = 'Photo' WHERE `type`='album';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}categories` SET `type` = 'Group' WHERE `type`='group';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}categories` SET `type` = 'Topic' WHERE `type`='topic';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}categories` SET `type` = 'Video' WHERE `type`='video';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}categories` SET `type` = 'Event' WHERE `type`='event';
]]>
</query>
<query><![CDATA[
ALTER TABLE `{PREFIX}core_blocks` ADD `plugin` VARCHAR( 128 ) NOT NULL;]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `plugin`='Event' WHERE `path_view`='events.upcoming';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `plugin`='Group' WHERE `path_view`='groups.myJoined';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `plugin`='Blog' WHERE `path_view`='blogs.popular';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `plugin`='Photo' WHERE `path_view`='photos.popularAlbums';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `plugin`='Video' WHERE `path_view`='videos.popular';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `plugin`='Topic' WHERE `path_view`='topics.popular';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `plugin`='Group' WHERE `path_view`='groups.popular';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `plugin`='Event' WHERE `path_view`='events.popular';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `plugin`='Group' WHERE `path_view`='groups.adminList';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `plugin`='Group' WHERE `path_view`='groups.memberList';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `plugin`='Event' WHERE `path_view`='events.rsvp';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `plugin`='Event' WHERE `path_view`='events.attending';
]]>
</query>
<query><![CDATA[
ALTER TABLE `{PREFIX}core_contents` ADD `core_block_title` varchar(50) CHARACTER SET utf8 DEFAULT NULL; ]]>
</query>
<query>
<![CDATA[
INSERT INTO `{PREFIX}core_blocks` (`name`, `path_view`, `params`, `is_active`, `plugin_id`, `group`, `restricted`, `plugin`) VALUES('Themes & Languages', 'theme_lang', '{"0":{"label":"Title","input":"text","value":"Themes & Languages","name":"title"},"1":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'core', '',''),('User Menu', 'welcomeBox', '{"0":{"label":"Title","input":"text","value":"User Menu","name":"title"},"1":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'core', 'home.index',''),('Main Menu', 'menu.widget', '[{"label":"Title","input":"text","value":"Main Menu","name":"title"},{"label":"Plugin","input":"hidden","value":"Menu","name":"plugin"},{"label":"Menu ID","input":"hidden","value":"1","name":"menu_id"}]', 1, 0, 'menu', '', 'Menu'),('Footer Menu', 'menu.widget', '[{"label":"Title","input":"text","value":"Footer Menu","name":"title"},{"label":"Plugin","input":"hidden","value":"Menu","name":"plugin"},{"label":"Menu ID","input":"hidden","value":"2","name":"menu_id"}]', 1, 0, 'menu', '', 'Menu');
]]>
</query>
<query>
<![CDATA[
UPDATE `{PREFIX}core_blocks` SET `params` = '{"0":{"label":"Title","input":"text","value":"Popular Tags","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Type","input":"select","value":{"all":"all","blog":"blog","album":"album","topic":"topic","video":"video"},"name":"type"},"3":{"label":"Title","input":"checkbox","value":"Enable
Title","name":"title_enable"}}' WHERE `id` = 5;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `params` = '{"0":{"label":"Title","input":"text","value":"Upcoming Events","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"3":{"label":"plugin","input":"hidden","value":"Event","name":"plugin"}}' WHERE `id` = 8;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `params` = '{"0":{"label":"Title","input":"text","value":"My Joined Groups","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"3":{"label":"plugin","input":"hidden","value":"Group","name":"plugin"}}' WHERE `id` = 9;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `params` = '{"0":{"label":"Title","input":"text","value":"Popular Blogs","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"3":{"label":"plugin","input":"hidden","value":"Blog","name":"plugin"}}' WHERE `id` = 14;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `params` = '{"0":{"label":"Title","input":"text","value":"PopularAlbums","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"3":{"label":"plugin","input":"hidden","value":"Photo","name":"plugin"}}' WHERE `id` = 15;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `params` = '{"0":{"label":"Title","input":"text","value":"PopularVideos","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"3":{"label":"plugin","input":"hidden","value":"Video","name":"plugin"}}' WHERE `id` = 16;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `params` = '{"0":{"label":"Title","input":"text","value":"PopularTopics","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"3":{"label":"plugin","input":"hidden","value":"Topic","name":"plugin"}}'
WHERE `id` = 17;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `params` = '{"0":{"label":"Title","input":"text","value":"Popular Groups","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"3":{"label":"plugin","input":"hidden","value":"Group","name":"plugin"}}' WHERE `id` = 18;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `params` = '{"0":{"label":"Title","input":"text","value":"Popular Events","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"3":{"label":"plugin","input":"hidden","value":"Event","name":"plugin"}}' WHERE `id` = 19;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `params` = '{"0":{"label":"Title","input":"text","value":"Admin","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"3":{"label":"plugin","input":"hidden","value":"Group","name":"plugin"}}' WHERE `id` = 51;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `params` = '{"0":{"label":"Title","input":"text","value":"Members","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"3":{"label":"plugin","input":"hidden","value":"Group","name":"plugin"}}' WHERE `id` = 52;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `params` = '{"0":{"label":"Title","input":"text","value":"RSVP","name":"title"},"1":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"2":{"label":"plugin","input":"hidden","value":"Event","name":"plugin"}}' WHERE `id` = 54;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `params` = '{"0":{"label":"Title","input":"text","value":"Event Attending","name":"title"},"1":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"2":{"label":"plugin","input":"hidden","value":"Event","name":"plugin"}}' WHERE `id` = 55;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_contents` SET `name` = 'welcomeBox', `params` = '{"title":"User Menu"}',
`core_block_id` = '59' WHERE `{PREFIX}core_contents`.`id` = 2;
]]>
</query>
<query>
<![CDATA[
UPDATE `{PREFIX}core_contents` SET `name` = 'theme_lang', `params` = '{"title":"Themes & Languages","title_enable":"1"}', `core_block_id` = '58' WHERE `{PREFIX}core_contents`.`id` = 4;
]]>
</query>
<query>
<![CDATA[
UPDATE `{PREFIX}core_contents` SET `name` = 'ajax.home_activity', `params` = '{"title":"What''s New","title_enable":"1"}', `core_block_id` = '6' WHERE `{PREFIX}core_contents`.`id` = 6;
]]>
</query>
<query>
<![CDATA[
UPDATE `{PREFIX}core_contents` SET `name` = 'theme_lang', `params` = '{"title":"Themes & Languages","title_enable":"1"}', `core_block_id` = '58' WHERE `{PREFIX}core_contents`.`id` = 20;
]]>
</query>
<query>
<![CDATA[
UPDATE `{PREFIX}core_contents` SET `name` = 'theme_lang', `params` = '{"title":"Themes & Languages","title_enable":"1"}', `core_block_id` = '58' WHERE `{PREFIX}core_contents`.`id` = 26;
]]>
</query>
<query>
<![CDATA[
UPDATE `{PREFIX}core_contents` SET `name` = 'theme_lang', `params` = '{"title":"Themes & Languages","title_enable":"1"}', `core_block_id` = '58' WHERE `{PREFIX}core_contents`.`id` = 37;
]]>
</query>
<query>
<![CDATA[
UPDATE `{PREFIX}core_contents` SET `name` = 'theme_lang', `params` = '{"title":"Themes & Languages","title_enable":"1"}', `core_block_id` = '58' WHERE `{PREFIX}core_contents`.`id` = 54;
]]>
</query>
<query>
<![CDATA[
UPDATE `{PREFIX}core_contents` SET `name` = 'theme_lang', `params` = '{"title":"Themes & Languages","title_enable":"1"}', `core_block_id` = '58' WHERE `{PREFIX}core_contents`.`id` = 64;
]]>
</query>
<query>
<![CDATA[
UPDATE `{PREFIX}core_contents` SET `name` = 'theme_lang', `params` = '{"title":"Themes & Languages","title_enable":"1"}', `core_block_id` = '58' WHERE `{PREFIX}core_contents`.`id` = 75;
]]>
</query>
<query>
<![CDATA[
UPDATE `{PREFIX}core_contents` SET `name` = 'theme_lang', `params` = '{"title":"Themes & Languages","title_enable":"1"}', `core_block_id` = '58' WHERE `{PREFIX}core_contents`.`id` = 83;
]]>
</query>
<query>
<![CDATA[
UPDATE `{PREFIX}core_contents` SET `name` = 'theme_lang', `params` = '{"title":"Themes & Languages","title_enable":"1"}', `core_block_id` = '58' WHERE `{PREFIX}core_contents`.`id` = 89;
]]>
</query>
<query>
<![CDATA[
UPDATE `{PREFIX}core_contents` SET `name` = 'theme_lang', `params` = '{"title":"Themes & Languages","title_enable":"1"}', `core_block_id` = '58' WHERE `{PREFIX}core_contents`.`id` = 97;
]]>
</query>
<query>
<![CDATA[
UPDATE `{PREFIX}core_contents` SET `name` = 'theme_lang', `params` = '{"title":"Themes & Languages","title_enable":"1"}', `core_block_id` = '58' WHERE `{PREFIX}core_contents`.`id` = 104;
]]>
</query>
<query>
<![CDATA[
UPDATE `{PREFIX}core_contents` SET `name` = 'theme_lang', `params` = '{"title":"Themes & Languages","title_enable":"1"}', `core_block_id` = '58' WHERE `{PREFIX}core_contents`.`id` = 116;
]]>
</query>
<query>
<![CDATA[
UPDATE `{PREFIX}core_contents` SET `name` = 'theme_lang', `params` = '{"title":"Themes & Languages","title_enable":"1"}', `core_block_id` = '58' WHERE `{PREFIX}core_contents`.`id` = 120;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}activities` SET `plugin` = 'Group' WHERE `action`='group_join';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}activities` SET `plugin` = 'Group' WHERE `action`='group_create';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}activities` SET `plugin` = 'Blog' WHERE `action`='blog_create';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}activities` SET `plugin` = 'Event' WHERE `action`='event_attend';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}activities` SET `plugin` = 'Event' WHERE `action`='event_create';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}activities` SET `plugin` = 'Photo', `item_type` ='Photo_Album' WHERE
`action`='photos_add' AND `params`='item';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}activities` SET `item_type` ='Photo_Album', `items` = `item_id` WHERE
`action`='wall_post' AND `item_type`='photo';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}activities` SET `plugin` = 'Photo', `action`='photo_create' WHERE `action`='photos_add'
AND `params`='';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}activities` SET `plugin` = 'Photo', `action`='comment_add_photo' WHERE
`action`='comment_add';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}activities` SET `plugin` = 'Video',`action`='video_create' WHERE `action`='video_add';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}activities` SET `plugin` = 'Photo' WHERE `action`='photos_tag';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}activities` SET `plugin` = 'Topic' WHERE `action`='topic_create';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}activities` SET `action` = 'wall_post_link' WHERE `params` LIKE '%"title"%' AND
`action`='wall_post' AND id NOT IN (SELECT activity_id FROM `{PREFIX}activity_fetch_videos` );
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}activities` SET `item_type` = 'Blog_Blog' WHERE `item_type`='blog';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}activities` SET `item_type` = 'Event_Event' WHERE `item_type`='event';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}activities` SET `item_type` = 'Group_Group' WHERE `item_type`='group';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}activities` SET `item_type` = 'Photo_Photo' WHERE `item_type`='photo';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}activities` SET `item_type` = 'Topic_Topic' WHERE `item_type`='topic';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}activities` SET `item_type` = 'Video_Video' WHERE `item_type`='video';
]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}core_menus` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(256) NOT NULL,
`style` enum('horizontal','vertical') NOT NULL,
`alias` varchar(255) NOT NULL,
`menuid` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; ]]>
</query>
<query><![CDATA[
INSERT INTO `{PREFIX}core_menus` (`id`, `name`, `style`, `alias`, `menuid`) VALUES
(1, 'Main Menu', 'horizontal', 'main-menu', 'menu-1'),
(2, 'Footer Menu', 'horizontal', 'footer-menu', 'menu-2');
]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}core_menu_items` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) DEFAULT NULL,
`lft` int(11) NOT NULL,
`rght` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`original_name` varchar(255) NOT NULL,
`url` varchar(255) NOT NULL,
`title_attribute` varchar(255) NOT NULL,
`font_class` varchar(255) NOT NULL,
`is_active` tinyint(1) NOT NULL,
`new_blank` tinyint(1) NOT NULL,
`role_access` text NOT NULL,
`menu_id` int(11) NOT NULL,
`type` enum('page','link','header','plugin') DEFAULT NULL,
`menu_order` int(11) NOT NULL DEFAULT '0',
`plugin` varchar(255) NOT NULL,
`group` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ; ]]>
</query>
<query><![CDATA[
INSERT INTO `{PREFIX}core_menu_items` (`id`, `parent_id`, `lft`, `rght`, `name`, `original_name`, `url`,
`title_attribute`, `font_class`, `is_active`, `new_blank`, `role_access`, `menu_id`, `type`,
`menu_order`, `plugin`, `group`) VALUES
(1, NULL, 1, 2, 'Home', 'Home', '/home', '', '', 1, 0, '["1","2", "3"]', 1, 'page', 1, '', ''),
(2, NULL, 9, 10, 'People', 'People', '/users', '', '', 1, 0, '["1","2", "3"]', 1, 'page', 2, '', ''),
(3, NULL, 11, 12, 'Blogs', 'Blogs', '/blogs', '', '', 1, 0, '["1","2", "3"]', 1, 'page', 3, '', ''),
(4, NULL, 13, 14, 'Photos', 'Photos', '/photos', '', '', 1, 0, '["1","2", "3"]', 1, 'page', 4, '', ''),
(5, NULL, 5, 6, 'Groups', 'Groups', '/groups', '', '', 1, 0, '["1","2", "3"]', 1, 'page', 7, '', ''),
(6, NULL, 3, 4, 'Topics', 'Topics', '/topics', '', '', 1, 0, '["1","2", "3"]', 1, 'page', 6, '', ''),
(7, NULL, 15, 16, 'Videos', 'Videos', '/videos', '', '', 1, 0, '["1","2", "3"]', 1, 'page', 5, '', ''),
(8, NULL, 7, 8, 'Events', 'Events', '/events', '', '', 1, 0, '["1","2", "3"]', 1, 'page', 8, '', '');
]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}currencies` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`currency_code` varchar(3) NOT NULL,
`symbol` varchar(15) NOT NULL,
`name` varchar(255) NOT NULL,
`description` text,
`ordering` mediumint(8) unsigned NOT NULL DEFAULT '0',
`is_default` tinyint(1) NOT NULL DEFAULT '0',
`is_active` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ; ]]>
</query>
<query><![CDATA[
INSERT INTO `{PREFIX}currencies` (`id`, `currency_code`, `symbol`, `name`, `description`, `ordering`,
`is_default`, `is_active`) VALUES
(1, 'HKD', 'HK$', 'Hong Kong Dollar', '', 0, 0, 1),
(2, 'SGD', 'SGD$', 'Singapore Dollar', '', 0, 0, 1),
(3, 'CHF', 'Fr', 'Swiss Franc', '', 0, 0, 1),
(4, 'CNY', 'Â¥', 'Chinese Yuan', '', 0, 0, 0),
(5, 'AUD', 'A$', 'Australian Dollar', NULL, 0, 0, 1),
(6, 'CAD', 'C$', 'Canadian Dollar', NULL, 0, 0, 1),
(7, 'JPY', 'Â¥', 'Japanese Yen', 'This currency does not support decimals. Passing a decimal amount
will throw an error.', 0, 0, 1),
(8, 'GBP', '£', 'Pound Sterling ', '', 0, 0, 1),
(9, 'EUR', '€', 'Euro', '', 0, 0, 1),
(10, 'USD', '$', 'U.S. Dollar ', '', 0, 1, 1);
]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}email_templates` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`meta_key` varchar(255) NOT NULL,
`meta_value` varchar(255) NOT NULL,
`description` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1; ]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}i18n` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`locale` varchar(6) NOT NULL,
`model` varchar(255) NOT NULL,
`foreign_key` int(10) NOT NULL,
`field` varchar(255) NOT NULL,
`content` text,
PRIMARY KEY (`id`),
KEY `locale` (`locale`),
KEY `model` (`model`),
KEY `row_id` (`foreign_key`),
KEY `field` (`field`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1; ]]>
</query>
<query>
<![CDATA[
INSERT INTO `{PREFIX}i18n` (`locale`, `model`, `foreign_key`, `field`, `content`) VALUES
('eng', 'CoreMenuItem', 1, 'name', 'Home'),
('eng', 'CoreMenuItem', 2, 'name', 'People'),
('eng', 'CoreMenuItem', 3, 'name', 'Blogs'),
('eng', 'CoreMenuItem', 4, 'name', 'Photos'),
('eng', 'CoreMenuItem', 5, 'name', 'Groups'),
('eng', 'CoreMenuItem', 6, 'name', 'Topics'),
('eng', 'CoreMenuItem', 7, 'name', 'Videos'),
('eng', 'CoreMenuItem', 8, 'name', 'Events'),
('eng', 'Mailtemplate', 1, 'content', 'Hello,'),
('eng', 'Mailtemplate', 1, 'subject', ''),
('eng', 'Mailtemplate', 2, 'content', '<p>Best Regards,<br />Social Network Administration</p>'),
('eng', 'Mailtemplate', 2, 'subject', ''),
('eng', 'Mailtemplate', 3, 'content', '<p>Hello [recipient_title],</p>'),
('eng', 'Mailtemplate', 3, 'subject', ''),
('eng', 'Mailtemplate', 4, 'subject', ''),
('eng', 'Mailtemplate', 4, 'content', '<p>Best Regards,<br />Social Network Administration</p>'),
('eng', 'Mailtemplate', 5, 'content', '<p>[header]</p><p>[name] has sent you a message using the contact page:</p><p>Email : [sender_email]</p><p>Subject: [subject]</p><p>Message:</p><p>[message]</p><p>[footer]</p>'),
('eng', 'Mailtemplate', 5, 'subject', 'A member has sent you a message using the contact page.'),
('eng', 'Mailtemplate', 6, 'content', '<p>[header]</p>\r\n<p>You have been invited to join the event "[event_title]". Please click the following link to view it:</p>\r\n<p><a href="[event_link]">[event_title]</a></p>\r\n<p>[footer]</p>'),
('eng', 'Mailtemplate', 6, 'subject', 'You have been invited to join the event [event_title]'),
('eng', 'Mailtemplate', 7, 'content', '<p>[header]</p>\r\n<p>[sender_title] wants to be friends with you.</p>\r\n<p>[message]</p>\r\n<p>[footer]</p>'),
('eng', 'Mailtemplate', 7, 'subject', '[sender_title] has sent you a friend request.'),
('eng', 'Mailtemplate', 8, 'content', '<p>[header]</p>\r\n<p>You have been invited by [sender_title] to join our social network. To join, please follow the link below:</p>\r\n<p><a href="[signup_link]">[signup_link]</a></p>\r\n<p>----------------------------------------<br />[message]<br />----------------------------------------</p>\r\n<p>[footer]</p>'),
('eng', 'Mailtemplate', 8, 'subject', 'You have received an invitation to join our social network.'),
('eng', 'Mailtemplate', 9, 'content', '<p>[header]</p>\r\n<p>You have been invited to join the group "[group_title]". Please click the following link to view it:</p>\r\n<p><a href="[group_link]">[group_title]</a></p>\r\n<p>[footer]</p>'),
('eng', 'Mailtemplate', 9, 'subject', 'You have been invited to join the group [group_title]'),
('eng', 'Mailtemplate', 10, 'content', ''),
('eng', 'Mailtemplate', 10, 'subject', ''),
('eng', 'Mailtemplate', 11, 'content', '<p>[header]</p>\r\n<p>Thank you for joining our social network. Click the following link and enter your information below to login:</p>\r\n<p><a href="[login_link]">[login_link]</a></p>\r\n<p>Email: [email]</p>\r\n<p>[footer]</p>'),
('eng', 'Mailtemplate', 11, 'subject', 'Welcome to [site_name]'),
('eng', 'Mailtemplate', 12, 'content', '<p>[header]</p>\r\n<p>Thank you for joining our social network. Please click the link below to validate your email:</p>\r\n<p><a href="[confirm_link]">[confirm_link]</a></p>\r\n<p>Email: [email]</p>\r\n<p>[footer]</p>'),
('eng', 'Mailtemplate', 12, 'subject', 'Welcome to [site_name]'),
('eng', 'Mailtemplate', 13, 'content', '<p>[header]</p>\r\n<p><a href="[new_user_link]">[new_user_title]</a> has just signed up on [site_name]</p>\r\n<p>[footer]</p>'),
('eng', 'Mailtemplate', 13, 'subject', 'New Registration'),
('eng', 'Mailtemplate', 14, 'content', '<p>[header]</p>\r\n<p>A request to reset password was submitted. If it\'s not you, please ignore this email.</p>\r\n<p>To reset your password, please click <a href="[reset_link]">[reset_link]</a></p>\r\n<p>[footer]</p>'),
('eng', 'Mailtemplate', 14, 'subject', 'Password Change Request'),
('eng', 'Mailtemplate', 15, 'content', '<p>[header]</p>\r\n<p>The admin has changed your password to [password]</p>\r\n<p>[footer]</p>'),
('eng', 'Mailtemplate', 15, 'subject', 'Your password has been changed'),
('eng', 'Mailtemplate', 16, 'content', '<p>[header]</p>\r\n<p>[element]</p>\r\n<p>[footer]</p>'),
('eng', 'Mailtemplate', 16, 'subject', 'Your Notifications Summary');
]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}jobs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`jobtype_id` int(10) unsigned NOT NULL,
`state` enum('pending','active','sleeping','failed','cancelled','completed','timeout') COLLATE
utf8_unicode_ci NOT NULL DEFAULT 'pending',
`is_complete` tinyint(1) unsigned NOT NULL DEFAULT '0',
`progress` decimal(5,4) unsigned NOT NULL DEFAULT '0.0000',
`creation_date` datetime NOT NULL,
`modified_date` datetime DEFAULT NULL,
`started_date` datetime DEFAULT NULL,
`completion_date` datetime DEFAULT NULL,
`priority` mediumint(9) NOT NULL DEFAULT '100',
`data` text COLLATE utf8_unicode_ci,
`messages` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`id`),
KEY `jobtype_id` (`jobtype_id`),
KEY `state` (`state`),
KEY `is_complete` (`is_complete`,`priority`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; ]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}jobtypes` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`class` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`plugin` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`enabled` tinyint(1) unsigned NOT NULL DEFAULT '1',
`priority` mediumint(9) NOT NULL DEFAULT '100',
`multi` tinyint(3) unsigned DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=2 ; ]]>
</query>
<query><![CDATA[
INSERT INTO `{PREFIX}jobtypes` (`id`, `title`, `class`, `plugin`, `enabled`, `priority`, `multi`) VALUES
(1, 'Test', 'Cron_Task_Job_Test', 'cron', 1, 100, 1);
]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}mailrecipients` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`params` longtext COLLATE utf8_unicode_ci NOT NULL,
`priority` smallint(3) DEFAULT '100',
`creation_time` datetime NOT NULL,
`recipient` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
`type` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `priority` (`priority`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; ]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}mailtemplates` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`content` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`plugin` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`vars` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`subject` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=17 ; ]]>
</query>
<query><![CDATA[
INSERT INTO `{PREFIX}mailtemplates` (`id`, `type`, `content`, `plugin`, `vars`, `subject`) VALUES
(1, 'header', '', 'Mail', '', ''),
(2, 'footer', '', 'Mail', '', ''),
(3, 'header_member', '', 'Mail', '', ''),
(4, 'footer_member', '', 'Mail', '', ''),
(5, 'mail_contact', '', 'Mail', '[message],[name],[subject],[sender_email]', ''),
(6, 'event_invite_none_member', '<p>[header]</p>\r\n<p>You have been invited to join the event
"[event_title]". Please click the following link to view it:</p>\r\n
<p>
<a href="[event_link]">[event_title]</a>
</p>
\r\n<p>[footer]</p>', 'Event', '[email],[sender_title],[sender_link],[event_link],[event_title]', 'You
have been invited to join the event [event_title]'),
(7, 'friend_request', '<p>[header]</p>\r\n<p>[sender_title] wants to be friends with you.</p>\r\n<p>
[message]</p>\r\n<p>[footer]</p>', 'Mail',
'[recipient_title],[recipient_link],[sender_title],[sender_link],[message]', '[sender_title] has sent
you a friend request.'),
(8, 'site_invite', '<p>[header]</p>\r\n<p>You have been invited by [sender_title] to join our social
network. To join, please follow the link below:</p>\r\n
<p>
<a href="[signup_link]">[signup_link]</a>
</p>
\r\n
<p>----------------------------------------<br/>[message]<br/>----------------------------------------
</p>
\r\n<p>[footer]</p>', 'Mail', '[email],[sender_title],[sender_link],[message],[sigup_link]', 'You have
received an invitation to join our social network.'),
(9, 'group_invite_none_member', '<p>[header]</p>\r\n<p>You have been invited to join the group
"[group_title]". Please click the following link to view it:</p>\r\n
<p>
<a href="[group_link]">[group_title]</a>
</p>
\r\n<p>[footer]</p>', 'Group', '[email],[sender_title],[sender_link],[group_link],[group_title]', 'You
have been invited to join the group [group_title]'),
(10, 'bulkmail', '', 'Mail', '[recipient_title],[recipient_link],[sender_title],[sender_link]', ''),
(11, 'welcome_user', '<p>[header]</p>\r\n<p>Thank you for joining our social network. Click the
following link and enter your information below to login:</p>\r\n
<p>
<a href="[login_link]">[login_link]</a>
</p>
\r\n<p>Email: [email]</p>\r\n<p>[footer]</p>', 'Mail',
'[recipient_title],[recipient_link],[site_name],[login_link],[email]', 'Welcome to [site_name]'),
(12, 'welcome_user_confirm', '<p>[header]</p>\r\n<p>Thank you for joining our social network. Please
click the link below to validate your email:</p>\r\n
<p>
<a href="[confirm_link]">[confirm_link]</a>
</p>
\r\n<p>Email: [email]</p>\r\n<p>[footer]</p>', 'Mail',
'[recipient_title],[recipient_link],[site_name],[email],[confirm_link]', 'Welcome to [site_name]'),
(13, 'new_registration', '<p>[header]</p>\r\n
<p>
<a href="[new_user_link]">[new_user_title]</a>
has just signed up on [site_name]
</p>
\r\n<p>[footer]</p>', 'Mail', '[new_user_title],[new_user_link],[site_name]', 'New Registration'),
(14, 'reset_password', '<p>[header]</p>\r\n<p>A request to reset password was submitted. If it\'s not
you, please ignore this email.</p>\r\n
<p>To reset your password, please click
<a href="[reset_link]">[reset_link]</a>
</p>
\r\n<p>[footer]</p>', 'Mail', '[recipient_title],[recipient_link],[reset_link]', 'Password Change
Request'),
(15, 'admin_change_password', '<p>[header]</p>\r\n<p>The admin has changed your password to
[password]</p>\r\n<p>[footer]</p>', 'Mail', '[recipient_title],[recipient_link],[password]', 'Your
password has been changed'),
(16, 'notifications_summary', '<p>[header]</p>\r\n<p>[element]</p>\r\n<p>[footer]</p>', 'Mail',
'[recipient_title],[recipient_link],[element]', 'Your Notifications Summary');
]]>
</query>
<query><![CDATA[
ALTER TABLE `{PREFIX}notifications` ADD `plugin` VARCHAR( 128 ) NOT NULL; ]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}notification_stops` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`user_id` int(10) NOT NULL,
`item_type` varchar(255) NOT NULL,
`item_id` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1; ]]>
</query>
<query><![CDATA[
DROP TABLE IF EXISTS `{PREFIX}plugins`; ]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}plugins` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`key` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`permission` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
`enabled` tinyint(1) unsigned NOT NULL DEFAULT '1',
`core` tinyint(1) unsigned NOT NULL,
`version` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
`weight` smallint(5) unsigned NOT NULL,
`menu` tinyint(1) unsigned NOT NULL DEFAULT '1',
`url` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
`icon_class` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`bootstrap` tinyint(1) NOT NULL DEFAULT '0',
`routes` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `key` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ; ]]>
</query>
<query><![CDATA[
INSERT INTO `{PREFIX}plugins` (`id`, `name`, `key`, `permission`, `enabled`, `core`, `version`,
`weight`, `menu`, `url`, `icon_class`, `bootstrap`, `routes`) VALUES
(2, 'Billing', 'Billing', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
(3, 'Menu', 'Menu', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
(4, 'Payment Gateway', 'PaymentGateway', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
(5, 'Cron', 'Cron', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
(6, 'Mail', 'Mail', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
(7, 'Photo', 'Photo', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
(8, 'Video', 'Video', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
(9, 'Page', 'Page', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
(10, 'Event', 'Event', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
(11, 'Topic', 'Topic', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
(12, 'Blog', 'Blog', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
(13, 'Group', 'Group', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
(14, 'Social Integration', 'SocialIntegration', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
(15, 'MooUpload', 'MooUpload', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1);
]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}processes` (
`pid` int(10) unsigned NOT NULL,
`parent_pid` int(10) unsigned NOT NULL DEFAULT '0',
`system_pid` int(10) unsigned NOT NULL DEFAULT '0',
`started` int(10) unsigned NOT NULL,
`timeout` mediumint(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY (`pid`),
KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; ]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}social_users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`provider` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`provider_uid` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`access_token` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`code_secret` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`expires` bigint(20) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; ]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}tasks` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`plugin` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`timeout` int(11) unsigned NOT NULL DEFAULT '60',
`processes` smallint(3) unsigned NOT NULL DEFAULT '1',
`semaphore` smallint(3) NOT NULL DEFAULT '0',
`started_last` int(11) NOT NULL DEFAULT '0',
`started_count` int(11) unsigned NOT NULL DEFAULT '0',
`completed_last` int(11) NOT NULL DEFAULT '0',
`completed_count` int(11) unsigned NOT NULL DEFAULT '0',
`failure_last` int(11) NOT NULL DEFAULT '0',
`failure_count` int(11) unsigned NOT NULL DEFAULT '0',
`success_last` int(11) NOT NULL DEFAULT '0',
`success_count` int(11) unsigned NOT NULL DEFAULT '0',
`enable` tinyint(1) NOT NULL,
`class` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `started_last` (`started_last`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ; ]]>
</query>
<query><![CDATA[
INSERT INTO `{PREFIX}tasks` (`id`, `title`, `plugin`, `timeout`, `processes`, `semaphore`,
`started_last`, `started_count`, `completed_last`, `completed_count`, `failure_last`, `failure_count`,
`success_last`, `success_count`, `enable`, `class`) VALUES
(1, 'Job Queue', 'Cron', 5, 1, 0, 1423111512, 3, 1423111512, 3, 0, 0, 1423111512, 3, 1,
'Cron_Task_Jobs'),
(2, 'Background Mailer', 'Mail', 60, 1, 0, 1423106024, 1, 1423106024, 1, 0, 0, 1423106024, 1, 1,
'Mail_Task_Cron'),
(3, 'Notifications Summary', 'Core', 86400, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1,
'Task_Reminder_Notifications');
]]>
</query>
<query><![CDATA[
ALTER TABLE `{PREFIX}users` ADD `approved` tinyint(1) NOT NULL COMMENT 'admin approved user feature'; ]]>
</query>
<query><![CDATA[
ALTER TABLE `{PREFIX}users` ADD `is_social` tinyint(1) NOT NULL DEFAULT '0'; ]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}users` SET `approved` = 1;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}photos` SET `type` = 'Photo_Album' WHERE `type`='album';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}photos` SET `type` = 'Group_Group' WHERE `type`='group';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}comments` SET `type` = 'Photo_Album' WHERE `type`='album';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}comments` SET `type` = 'Blog_Blog' WHERE `type`='blog';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}comments` SET `type` = 'Group_Group' WHERE `type`='group';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}comments` SET `type` = 'Photo_Album' WHERE `type`='album';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}comments` SET `type` = 'Page_Page' WHERE `type`='page';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}comments` SET `type` = 'Photo_Photo' WHERE `type`='photo';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}comments` SET `type` = 'Topic_Topic' WHERE `type`='topic';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}comments` SET `type` = 'Video_Video' WHERE `type`='video';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}likes` SET `type` = 'core_activity_comment' WHERE `type`='activity_comment';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}likes` SET `type` = 'Photo_Album' WHERE `type`='album';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}likes` SET `type` = 'Blog_Blog' WHERE `type`='blog';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}likes` SET `type` = 'Photo_Photo' WHERE `type`='photo';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}likes` SET `type` = 'Topic_Topic' WHERE `type`='topic';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}likes` SET `type` = 'Video_Video' WHERE `type`='video';
]]>
</query>
<query><![CDATA[
DROP TABLE IF EXISTS `{PREFIX}settings`; ]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) DEFAULT NULL,
`label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`field` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`value` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`is_hidden` tinyint(1) NOT NULL DEFAULT '0',
`version_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`type_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`value_actual` mediumtext COLLATE utf8_unicode_ci,
`value_default` mediumtext COLLATE utf8_unicode_ci,
`description` text COLLATE utf8_unicode_ci,
`ordering` tinyint(3) NOT NULL,
`is_boot` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ; ]]>
</query>
<query>
<![CDATA[
INSERT INTO `{PREFIX}settings` (`group_id`, `label`, `name`, `field`, `value`, `is_hidden`, `version_id`, `type_id`, `value_actual`, `value_default`, `description`, `ordering`, `is_boot`) VALUES
(1, 'Site Name', 'site_name', 'site_name', 'test', 0, NULL, 'text', 'mooSocial', 'mooSocial', NULL, 1, 0),
(1, 'Site Email', 'site_email', 'site_email', 'info@socialloft.com', 0, NULL, 'text', 'info@socialloft.com', 'info@socialloft.com', NULL, 2, 0),
(1, 'Site Keywords', 'site_keywords', 'site_keywords', '', 0, NULL, 'textarea', '', '', '', 3, 0),
(1, 'Site Description', 'site_description', 'site_description', '', 0, NULL, 'textarea', '', '', '', 4, 0),
(1, 'Default Home Feed', 'default_feed', 'default_feed', 'everyone', 0, NULL, 'select', '[{"name":"Everyone","value":"everyone","select":1},{"name":"Friends & Me","value":"0","select":0}]', '[{"name":"Everyone","value":"everyone","select":0},{"name":"Friends & Me","value":"friends","select":0}]', NULL, 10, 0),
(1, 'Note', 'admin_notes', 'admin_notes', '', 0, NULL, 'textarea', '', '', '', 4, 0),
(3, 'Enable reCaptcha', 'recaptcha', 'recaptcha', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"1","select":"1"}]', 'You must enter recaptcha public and private key if you<br>enable this. Click <a href="http://www.google.com/recaptcha" target="_blank">this</a> for more details', 2, 0),
(3, 'reCaptcha Public Key', 'recaptcha_publickey', 'recaptcha_publickey', '', 0, NULL, 'text', '', '', NULL, 3, 0),
(3, 'reCaptcha Private Key', 'recaptcha_privatekey', 'recaptcha_privatekey', '', 0, NULL, 'text', '', '', NULL, 4, 0),
(3, 'Require Email Validation', 'email_validation', 'email_validation', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '0', NULL, 1, 0),
(4, 'Homepage Guest Message', 'guest_message', 'guest_message', '', 0, NULL, 'textarea', '', '', NULL, 2, 0),
(4, 'Header Block Code', 'header_code', 'header_code', '', 0, NULL, 'textarea', '', '', NULL, 4, 0),
(4, 'Footer Block Code', 'footer_code', 'footer_code', '', 0, NULL, 'textarea', '', '', NULL, 7, 0),
(4, 'Homepage Member Message', 'member_message', 'member_message', '', 0, NULL, 'textarea', '', '', NULL, 3, 0),
(2, 'Allow Users To Select Theme', 'select_theme', 'select_theme', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '1', NULL, 8, 0),
(2, 'Allow Guests To Search', 'guest_search', 'guest_search', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '1', NULL, 1, 0),
(1, 'Default Theme', 'default_theme', 'default_theme', 'default', 0, NULL, 'select', '[{"name":"Default Theme","value":"default","select":1},{"name":"Light Theme","value":"light","select":0},{"name":"Dark Theme","value":"dark","select":0},{"name":"Mobile Theme","value":"mobile","select":0}]', 'default', NULL, 9, 0),
(2, 'Force Login', 'force_login', 'force_login', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"1","select":"0"}]', 'Check this to force users to login to view the site', 5, 0),
(4, 'Homepage Block Code', 'homepage_code', 'homepage_code', '', 0, NULL, 'textarea', '', '', NULL, 6, 0),
(3, 'Ban IP Addresses', 'ban_ips', 'ban_ips', '', 0, NULL, 'text', '', '', 'Enter xyz.xyz.xyz.xyz to ban the exact ip address<br>Or xyz.xyz.xyz to ban ip addresses that start with xyz.xyz.xyz<br>One ip address per line', 5, 0),
(2, 'Enable Activities Feed Selection', 'feed_selection', 'feed_selection', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '1', NULL, 2, 0),
(9, 'Take Site Offline', 'site_offline', 'site_offline', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '0', NULL, 5, 0),
(9, 'Offline Message', 'offline_message', 'offline_message', '', 0, NULL, 'textarea', '', '', '', 6, 0),
(1, 'Default Profile Privacy', 'profile_privacy', 'profile_privacy', '[{"name":"Everyone","value":"1","select":1},{"name":"Friends & Me","value":"2","select":0},{"name":"Only Me","value":"3","select":0}]', 0, NULL, 'select', '[{"name":"Everyone","value":"1","select":1},{"name":"Friends & Me","value":"2","select":0},{"name":"Only Me","value":"3","select":0}]', '1', NULL, 8, 0),
(1, 'Popular Items Interval', 'popular_interval', 'popular_interval', '30', 0, NULL, 'text', '30', '30', 'Display popular items within X days ', 7, 0),
(1, 'Default Language', 'default_language', 'default_language', 'eng', 0, NULL, 'language', 'eng', 'eng', '', 15, 0),
(2, 'Disable Registration', 'disable_registration', 'disable_registration', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '0', NULL, 6, 0),
(1, 'Time Format', 'time_format', 'time_format', '12h', 0, NULL, 'select', '[{"name":"12-hour","value":"12","select":1},{"name":"24-hour","value":"24","select":0}]', '[{"name":"12-hour","value":"12","select":"1"},{"name":"24-hour","value":"24","select":0}]', NULL, 11, 0),
(1, 'Date Format', 'date_format', 'date_format', '%B %d at %I:%M %p', 0, NULL, 'text', '%B %d at %I:%M %p', '%B %d at %I:%M %p', '<a target="_blank" href="http://php.net/manual/en/function.date.php">Refer to PHP date function for more information about<br>date format. Click this for more details</a>', 12, 0),
(6, 'Upload New Logo', 'logo', 'logo', 'theme/default/img/logo.png', 0, NULL, 'text', 'theme/default/img/logo.png', '', NULL, 1, 0),
(3, 'Remove Admin Link', 'hide_admin_link', 'hide_admin_link', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"1","select":"0"}]', 'Check this box to remove Admin link from user menu', 6, 0),
(2, 'Allow Users To Select Language', 'select_language', 'select_language', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '1', NULL, 9, 0),
(5, 'Analytics Code', 'analytics_code', 'analytics_code', '', 0, NULL, 'textarea', '', '', 'Enter your analytics code here<br>Click <a href="http://www.google.com/analytics/" target="_blank">this</a> to visit Google Analytics', 4, 0),
(2, 'Registration Notification', 'registration_notify', 'registration_notify', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"1","select":"0"}]', 'Check this to enable the system to send a notification email to the site email whenever a new user signs up', 7, 0),
(2, 'Hide Activities Feed From Guests', 'hide_activites', 'hide_activites', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '0', NULL, 3, 0),
(2, 'Allow Username Change', 'username_change', 'username_change', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '1', NULL, 11, 0),
(2, 'Save Original Image', 'save_original_image', 'save_original_image', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"1","select":"0"}]', 'Check this to store original image when users upload photos<br/>You might wanna disable if you are concerned about server space', 4, 0),
(3, 'Restricted Usernames', 'restricted_usernames', 'restricted_usernames', '', 0, NULL, 'textarea', '', '', 'Enter usernames that you do not want users to register with. One username per line', 7, 0),
(3, 'Enable Registration Code', 'enable_registration_code', 'enable_registration_code', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"1","select":"0"}]', 'Check this box to force users to enter the correct registration code defined below in order to register', 8, 0),
(3, 'Registration Code', 'registration_code', 'registration_code', '', 0, NULL, 'text', '', '', NULL, 9, 0),
(5, 'Google Developer Key', 'google_dev_key', 'google_dev_key', ' ', 0, NULL, 'text', '', '', 'Use for youtube API for more info please go to <a href="https://developers.google.com/youtube/v3/getting-started">link</a>', 5, 0),
(1, 'Default Timezone', 'timezone', 'timezone', 'Africa/Accra', 0, NULL, 'timezone', 'Asia/Ho_Chi_Minh', 'Asia/Ho_Chi_Minh', '', 13, 0),
(1, 'Enable Timezone Selection', 'enable_timezone_selection', 'enable_timezone_selection', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '[{"name":"","value":"1","select":"0"}]', 'If your users live in different timezones then enable this ', 14, 0),
(2, 'Require Birthday', 'require_birthday', 'require_birthday', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '1', NULL, 12, 0),
(3, 'Enable Spam Challenge', 'enable_spam_challenge', 'enable_spam_challenge', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"1","select":"0"}]', 'Check this box to force users to answer a<br>challenge question in order to register<br>Click <a href="/admin/spam_challenges">here</a> to manage challenge questions/answers', 10, 0),
(1, 'Show "Powered by" link', 'show_credit', 'show_credit', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"1","select":"0"}]', NULL, 16, 0),
(2, 'Allow Name Change', 'name_change', 'name_change', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '[{"name":"","value":"1","select":"1"}]', 'Check this to allow users to change name ', 10, 0),
(4, 'Registration Message', 'registration_message', 'registration_message', '', 0, NULL, 'textarea', '', '', NULL, 1, 0),
(3, 'Enable SSL Mode', 'ssl_mode', NULL, '', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":0}]', '[{"name":"","value":"1","select":0}]', '', 1, 1),
(9, 'System Mode', 'production_mode', NULL, '', 0, NULL, 'radio', '[{"name":"Production","value":"0","select":1},{"name":"Development 1","value":"1","select":0},{"name":"Development 2","value":"2","select":0}]', '[{"name":"Production","value":"0","select":1},{"name":"Development 1","value":"1","select":0},{"name":"Development 2","value":"2","select":0}]', 'Production Mode: No error messages, errors, or warnings shown. Flash messages redirect.Development Mode: 1: Errors and warnings shown, model caches refreshed, flash messages halted. 2: As in 1, but also with full debug messages and SQL output.', 1, 1),
(1, 'Notification Interval', 'notification_interval', 'notification_interval', '10', 0, NULL, 'text', '10', '10', 'Refresh notification within X seconds', 7, 0),
(1, 'Version', 'version', 'version', '2.2.0', 0, NULL, 'text', '2.2.0', '2.2.0', '', 17, 0),
(3, 'Approve Users', 'approve_users', 'approve_users', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"1","select":"0"}]', 'Enable this if you want to approve users before they can do activities on the site.', 1, 0),
(1, 'Photo Image Sizes', 'photo_image_sizes', 'photo_image_sizes', '75_square|150_square|300_square|250|450|850|1500', 0, NULL, 'text', '75_square|150_square|300_square|250|450|850|1500', NULL, 'File sizes to crop when user upload photo', 18, 0),
(13, 'Enable Blog Plugin', 'blog_enabled', NULL, '', 0, NULL, 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '', 1, 1),
(12, 'Trigger Access Key', 'cron_key', NULL, '', 0, NULL, 'text', '3FSE@', '3FSE@', 'Used to prevent unauthorized running of the task scheduler.', 1, 0),
(12, 'Trigger Interval', 'cron_interval', NULL, '', 0, NULL, 'text', '60', '60', 'The minimum time between running tasks, in seconds.', 1, 0),
(12, 'Concurrent Processes', 'cron_processes', NULL, '', 0, NULL, 'text', '2', '2', 'The maximum number of concurrent processes running tasks that are allowed.', 1, 0),
(12, 'Tasks Run per Request', 'cron_count', NULL, '', 0, NULL, 'text', '1', '1', 'The maximum number of tasks that are run during each request. If a task is determined to have done nothing, it may not count towards this number.', 1, 0),
(12, 'Time per Request', 'cron_time', NULL, '', 0, NULL, 'text', '120', '120', 'The maximum time allowed per request. This number will be automatically scaled if ini_get() can read max_execution_time from php.ini.', 1, 0),
(12, 'Process Timeout', 'cron_timeout', NULL, '', 0, NULL, 'text', '900', '900', 'The maximum time before a task is considered to have died. The task will then be reset and freed to execute again.', 1, 0),
(12, 'Concurrent Jobs', 'cron_jobs', NULL, '', 0, NULL, 'text', '3', '3', 'The maximum number of concurrently running jobs. This setting is limited by "Concurrent Processes"', 1, 0),
(12, 'Javascript Enable', 'cron_javascript', NULL, '', 0, NULL, 'checkbox', '[{"name":"Enable","value":"1","select":"1"}]', '[{"name":"Enable","value":"1","select":"1"}]', 'Cron job auto call when user go to site', 2, 0),
(14, 'Item per pages', 'topic_item_per_pages', NULL, '', 0, NULL, 'text', '10', '10', '', 1, 0),
(14, 'Enable Topic Plugin', 'topic_enabled', NULL, '', 0, NULL, 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '', 1, 1),
(13, 'Item per pages', 'blog_item_per_pages', NULL, '', 0, NULL, 'text', '10', '10', 'The number of blogs to display per page', 1, 0),
(15, 'Photo item per pages', 'photo_item_per_pages', NULL, '', 0, NULL, 'text', '10', '10', '', 1, 0),
(15, 'Album item per pages', 'album_item_per_pages', NULL, '', 0, NULL, 'text', '10', '10', '', 1, 0),
(15, 'Enable Photo Plugin', 'photo_enabled', NULL, '', 0, NULL, 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '', 1, 1),
(16, 'Enable Video Plugin', 'video_enabled', '', '', 0, '2.2.0', 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', NULL, 1, 1),
(16, 'Item per pages', 'video_item_per_pages', NULL, '', 0, '2.2.0', 'text', '10', '10', NULL, 1, 0),
(17, 'Enable Page Plugin', 'page_enabled', '', '', 0, '2.2.0', 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', NULL, 1, 1),
(18, 'Enable Event Plugin', 'event_enabled', '', '', 0, '2.2.0', 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', NULL, 1, 1),
(18, 'Item per pages', 'event_item_per_pages', NULL, '', 0, '2.2.0', 'text', '10', '10', NULL, 1, 0),
(19, 'Item per pages', 'group_item_per_pages', NULL, '', 0, NULL, 'text', '10', '10', '', 1, 0),
(19, 'Enable Group Plugin', 'group_enabled', NULL, '', 0, NULL, 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '', 1, 1),
(7, 'From Name', 'mail_name', NULL, '', 0, NULL, 'text', '', '', 'Enter the name you want the emails from the system to come from in the field below.', 1, 0),
(7, 'From Address', 'mail_from', NULL, '', 0, NULL, 'text', '', '', 'Enter the email address you want the emails from the system to come from in the field below.', 2, 0),
(7, 'Send through SMTP', 'mail_smtp', 'mail_smtp', 'Mail', 0, NULL, 'radio', '[{"name":"Use the built-in mail() function","value":"0","select":1},{"name":"Send emails through an SMTP server","value":"1","select":0}]', '[{"name":"Use the built-in mail() function","value":"0","select":1},{"name":"Send emails through an SMTP server","value":"1","select":0}]', 'Emails typically get sent through the web server using the PHP mail() function. Alternatively you can have emails sent out using SMTP, usually requiring a username and password, and optionally using an external mail server.', 5, 0),
(7, 'SMTP Host', 'mail_smtp_host', 'mail_smtp_host', 'localhost', 0, NULL, 'text', 'localhost', 'localhost', 'In some cases, you might need to include ssl:// in the hostname ', 6, 0),
(7, 'SMTP Username', 'mail_smtp_username', 'mail_smtp_username', '', 0, NULL, 'text', '', '', NULL, 8, 0),
(7, 'SMTP Password', 'mail_smtp_password', 'mail_smtp_password', '', 0, NULL, 'text', '', '', NULL, 9, 0),
(7, 'SMTP Port', 'mail_smtp_port', 'mail_smtp_port', '', 0, NULL, 'text', '', '', 'Default: 25. Also commonly on port 465 (SMTP over SSL) or port 587.', 7, 0),
(7, 'Email Queue', 'mail_queueing', 'mail_queueing', '', 0, NULL, 'radio', '[{"name":"Yes, enable email queue","value":"1","select":0},{"name":"No, always send emails immediately","value":"0","select":1}]', '[{"name":"Yes, enable email queue","value":"1","select":0},{"name":"No, always send emails immediately","value":"0","select":1}]', 'Utilizing an email queue, you can allow your website to throttle the emails being sent out to prevent overloading the mail server.', 4, 0),
(7, 'Use SSL or TLS?', 'mail_smtp_ssl', NULL, '', 0, NULL, 'radio', '[{"name":"None","value":"","select":1},{"name":"TLS","value":"tls","select":0},{"name":"SSL","value":"ssl","select":0}]', '[{"name":"None","value":"","select":1},{"name":"TLS","value":"tls","select":0},{"name":"SSL","value":"ssl","select":0}]', '', 10, 0),
(7, 'Mail Count', 'mail_count', NULL, '', 0, NULL, 'text', '25', '25', 'The number of emails to send out each time the Background Mailer task is run.', 3, 0),
(21, 'Facebook App Api', 'facebook_app_id', NULL, '1413388488948132', 0, NULL, 'text', '', '', '', 2, 0),
(21, 'Facebook App Secret', 'facebook_app_secret', NULL, '', 0, NULL, 'text', '', '', '', 3, 0),
(21, 'Scope', 'facebook_app_scope', NULL, '', 0, NULL, 'textarea', 'public_profile, email, user_friends', '', '', 4, 0),
(21, 'Return Url', 'facebook_app_return_url', NULL, '', 0, NULL, 'text', 'http://localhost/social/auths/endpoint/facebook/', '', '', 5, 0),
(21, 'SDK version', 'facebook_sdk_version', 'facebook_sdk_version', '[{"name":"4.0.0","value":"4.0.0","select":0},{"name":"3.2.3","value":"3.2.3","select":1}]', 0, NULL, 'select', '[{"name":"4.0.0","value":"4.0.0","select":0},{"name":"3.2.3","value":"3.2.3","select":1}]', '4.0.0', NULL, 6, 0),
(21, 'Enable', 'facebook_integration', 'facebook_integration', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"0","select":"1"}]', 'You must enter FB application ID and secret if you enable this', 7, 0),
(22, 'Google App Api', 'google_app_id', 'google_app_id', '', 0, NULL, 'text', '', '', '', 2, 0),
(22, 'Google Client secret', 'google_app_secret', NULL, '', 0, NULL, 'text', '', '', '', 6, 0),
(22, 'Scope', 'google_app_scope', NULL, '', 0, NULL, 'textarea', 'profile email', '', '', 7, 0),
(22, 'Return Url', 'google_app_return_url', NULL, '', 0, NULL, 'text', 'http://localhost/social/auths/endpoint/google?hauth.done=Google', '', '', 8, 0),
(22, 'Enable', 'google_integration', 'google_integration', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"0","select":"1"}]', 'You must enter Google application ID and secret if you enable this', 9, 0),
(2, 'Allow Profile Picture upload during SignUp', 'allow_upload_avatar_signup', NULL, '', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '[{"name":"","value":"1","select":"1"}]', '', 13, 0),
(2, 'Allow and require Profile Picture upload during SignUp', 'require_upload_avatar', NULL, '', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '[{"name":"","value":"1","select":"1"}]', '', 14, 0),
(2, 'Auto add friend with', 'auto_add_friend', NULL, '', 0, NULL, 'text', '', '', '', 15, 0),
(2, 'Auto Load More', 'auto_load_more', 'auto_load_more', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '1', NULL, 16, 0);
]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}setting_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) NOT NULL DEFAULT '0',
`lft` int(11) DEFAULT NULL,
`rght` int(11) DEFAULT NULL,
`group_type` varchar(255) NOT NULL,
`module_id` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `group_id` (`id`)
) DEFAULT CHARSET=utf8 ; ]]>
</query>
<query><![CDATA[
INSERT INTO `{PREFIX}setting_groups` (`id`, `parent_id`, `lft`, `rght`, `group_type`, `module_id`,
`name`) VALUES
(1, 0, NULL, NULL, 'core', 'core', 'General'),
(2, 0, NULL, NULL, 'core', 'core', 'Features'),
(3, 0, NULL, NULL, 'core', 'core', 'Security'),
(4, 0, NULL, NULL, 'core', 'core', 'Custom Blocks'),
(5, 0, NULL, NULL, 'core', 'core', 'Intergration'),
(6, 0, NULL, NULL, 'core', 'core', 'Logo'),
(7, 0, NULL, NULL, 'core', 'Mail', 'Mail'),
(9, 0, NULL, NULL, 'core', 'core', 'System Mode'),
(10, 0, NULL, NULL, 'core', 'Billing', 'Billing'),
(12, 0, NULL, NULL, 'core', 'Cron', 'Cron'),
(13, 0, NULL, NULL, 'Blog', 'Blog', 'Blog'),
(14, 0, NULL, NULL, 'Topic', 'Topic', 'Topic'),
(15, 0, NULL, NULL, 'Photo', 'Photo', 'Photo'),
(16, 0, NULL, NULL, 'Video', 'Video', 'Video'),
(17, 0, NULL, NULL, 'Page', 'Page', 'Page'),
(18, 0, NULL, NULL, 'Event', 'Event', 'Event'),
(19, 0, NULL, NULL, 'Group', 'Group', 'Group'),
(20,0,NULL,NULL,'SocialIntegration','SocialIntegration','Social Integration'),
(21,20,NULL,NULL,'FacebookIntegration','FacebookIntegration','Facebook Integration'),
(22,20,NULL,NULL,'GoogleIntegration','GoogleIntegration','Google Integration');
]]>
</query>
<query><![CDATA[
ALTER TABLE `{PREFIX}photos` CHANGE `thumb` `thumbnail` VARCHAR(255) CHARACTER SET utf8 COLLATE
utf8_unicode_ci NOT NULL; ]]>
</query>
<query><![CDATA[
ALTER TABLE `{PREFIX}activity_comments` ADD `thumbnail` VARCHAR( 255 ) NOT NULL ]]>
</query>
<query><![CDATA[
ALTER TABLE `{PREFIX}comments` ADD `thumbnail` VARCHAR( 255 ) NOT NULL ]]>
</query>
<query><![CDATA[
ALTER TABLE `{PREFIX}activities` ADD `edited` BOOLEAN NOT NULL ]]>
</query>
<query><![CDATA[
ALTER TABLE `{PREFIX}activity_comments` ADD `edited` BOOLEAN NOT NULL ]]>
</query>
<query><![CDATA[
ALTER TABLE `{PREFIX}comments` ADD `edited` BOOLEAN NOT NULL ]]>
</query>
<query><![CDATA[
ALTER TABLE `{PREFIX}photos` ADD `privacy` INT NOT NULL DEFAULT '1' ]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}comment_histories` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`content` text NOT NULL,
`created` datetime NOT NULL,
`photo` int(1) NOT NULL,
`type` varchar(128) NOT NULL,
`target_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; ]]>
</query>
<query><![CDATA[
ALTER TABLE `{PREFIX}core_contents` ADD `plugin` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci
DEFAULT NULL ; ]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_contents`
SET `plugin` = 'Event' WHERE `{PREFIX}core_contents`.`name` = 'events.upcoming';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_contents`
SET `plugin` = 'Event' WHERE `{PREFIX}core_contents`.`name` = 'events.popular';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_contents`
SET `plugin` = 'Event' WHERE `{PREFIX}core_contents`.`name` = 'events.rsvp';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_contents`
SET `plugin` = 'Event' WHERE `{PREFIX}core_contents`.`name` = 'events.attending';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_contents`
SET `plugin` = 'Group' WHERE `{PREFIX}core_contents`.`name` = 'groups.myJoined';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_contents`
SET `plugin` = 'Group' WHERE `{PREFIX}core_contents`.`name` = 'groups.popular';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_contents`
SET `plugin` = 'Group' WHERE `{PREFIX}core_contents`.`name` = 'groups.adminList';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_contents`
SET `plugin` = 'Group' WHERE `{PREFIX}core_contents`.`name` = 'groups.memberList';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_contents`
SET `plugin` = 'Blog' WHERE `{PREFIX}core_contents`.`name` = 'blogs.popular';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_contents`
SET `plugin` = 'Photo' WHERE `{PREFIX}core_contents`.`name` = 'photos.popularAlbums';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_contents`
SET `plugin` = 'Video' WHERE `{PREFIX}core_contents`.`name` = 'videos.popular';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_contents`
SET `plugin` = 'Topic' WHERE `{PREFIX}core_contents`.`name` = 'topics.popular';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_contents`
SET `plugin` = 'Menu' WHERE `{PREFIX}core_contents`.`name` = 'menu.widget';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}pages`
SET `title` = 'Groups Browse Page' WHERE `{PREFIX}pages`.`id` = 16;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}pages`
SET `title` = 'Events Browse Page' WHERE `{PREFIX}pages`.`id` = 19;
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}pages`
SET `title` = 'Topics Browse Page' WHERE `{PREFIX}pages`.`id` = 23
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}pages`
SET `url` = '/users/member_login' WHERE `{PREFIX}pages`.`id` = 90
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}pages`
SET `url` = '/users/register' WHERE `{PREFIX}pages`.`id` = 96
]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}gateways` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(128) NOT NULL,
`description` text,
`enabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
`plugin` varchar(128) NOT NULL,
`test_mode` tinyint(1) unsigned NOT NULL DEFAULT '0',
`ipn_log` tinyint(1) unsigned NOT NULL DEFAULT '0',
`config` text NOT NULL,
PRIMARY KEY (`id`)
); ]]>
</query>
</queries>
</version>
<version>
<number>2.2.1</number>
<queries>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}hashtags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_id` int(11) NOT NULL,
`item_table` varchar(80) NOT NULL,
`hashtags` varchar(800) CHARACTER SET utf8 NOT NULL,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8; ]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}user_taggings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_id` int(11) NOT NULL,
`item_table` varchar(80) NOT NULL,
`users_taggings` varchar(800) CHARACTER SET utf8 NOT NULL,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8; ]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}user_mentions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_id` int(11) NOT NULL,
`item_table` varchar(80) NOT NULL,
`users_mentions` varchar(800) CHARACTER SET utf8 NOT NULL,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8; ]]>
</query>
<query>
<![CDATA[
INSERT INTO `{PREFIX}settings` (`group_id`, `label`, `name`, `field`, `value`, `is_hidden`, `version_id`, `type_id`, `value_actual`, `value_default`, `description`, `ordering`, `is_boot`) VALUES
(2, 'Photo theater mode', 'photo_theater_mode', 'photo_theater_mode', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '1', NULL, 1, 0),
(2, 'Enable hashtag on activity feed', 'enable_hashtag_activity', NULL, '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '1', '', 17, 0),
(13, 'Enable Blog Hashtag', 'blog_hashtag_enabled', NULL, '', 0, NULL, 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '', 2, 0),
(14, 'Enable Topic Hashtag', 'topic_hashtag_enabled', NULL, '', 0, NULL, 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '', 2, 0),
(15, 'Enable Photo Hashtag', 'photo_hashtag_enabled', NULL, '', 0, NULL, 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '', 2, 0),
(16, 'Enable Video Hashtag', 'video_hashtag_enabled', NULL, '', 0, NULL, 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '', 2, 0),
(18, 'Enable Event Hashtag', 'event_hashtag_enabled', NULL, '', 0, NULL, 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '', 2, 0),
(19, 'Enable Group Hashtag', 'group_hashtag_enabled', NULL, '', 0, NULL, 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '', 2, 0);
]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}group_user_invites` (
`id` int(11) unsigned NOT NULL,
`group_id` int(11) unsigned NOT NULL,
`email` varchar(50) NOT NULL,
`invite_checksum` varchar(50) NOT NULL,
`created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8; ]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}settings` SET `value_actual` = '[{"name":"Default Theme","value":"default","select":1},{"name":"Light Theme","value":"light","select":0},{"name":"Dark Theme","value":"dark","select":0}]' WHERE `{PREFIX}settings`.`name` = 'default_theme';
]]>
</query>
<query>
<![CDATA[
UPDATE `{PREFIX}settings` SET `value_actual` = '[{"name":"Everyone","value":"everyone","select":1},{"name":"Friends & Me","value":"friends","select":0}]' WHERE `{PREFIX}settings`.`name` = 'default_feed';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}mailtemplates` SET `vars` = '[recipient_title],[recipient_link],[sender_title],[sender_link],[message],[request_link]' WHERE `type` = 'friend_request';
]]>
</query>
<query><![CDATA[
ALTER TABLE `{PREFIX}users` ADD `has_active_subscription` TINYINT(1) NOT NULL DEFAULT '0'; ]]>
</query>
<query><![CDATA[
INSERT INTO `{PREFIX}setting_groups` (`parent_id`, `lft`, `rght`, `group_type`, `module_id`, `name`) VALUES
(0, NULL, NULL, 'core', 'Subscription', 'Subscription');
]]>
</query>
<query><![CDATA[
INSERT INTO `{PREFIX}settings` (`group_id`, `label`, `name`, `field`, `value`, `is_hidden`, `version_id`, `type_id`, `value_actual`, `value_default`, `description`, `ordering`, `is_boot`) VALUES
((SELECT `id` FROM `{PREFIX}setting_groups` WHERE `module_id` = 'Subscription'), 'Enable Subscription Packages', 'enable_subscription_packages', NULL, '', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"1","select":0}]', 'Enable Subscription Packages ', 1, 0),
((SELECT `id` FROM `{PREFIX}setting_groups` WHERE `module_id` = 'Subscription'), 'Select theme', 'select_theme_subscription_packages', NULL, '', 0, NULL, 'radio', '[{"name":"Select plan basic theme","value":"0","select":1},{"name":"Select plan compare table theme","value":"1","select":0}]', '[{"name":"Select plan basic theme","value":"0","select":1},{"name":"Select plan compare table theme","value":"1","select":0}]', 'Select Theme Subscription Packages ', 1, 0);
]]>
</query>
<query><![CDATA[
INSERT INTO `{PREFIX}gateways`(`id`,`name`,`description`,`enabled`,`plugin`,`test_mode`) VALUES
(1,'PayPal Adaptive','PayPal Adaptive',0,'PaypalAdaptive',0);
]]>
</query>
<query><![CDATA[
INSERT INTO `{PREFIX}tasks` (`title`, `plugin`, `timeout`, `processes`, `semaphore`, `started_last`, `started_count`, `completed_last`, `completed_count`, `failure_last`, `failure_count`, `success_last`, `success_count`, `enable`, `class`) VALUES
('Subscription', 'Subscription', 600, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Subscription_Task_Subscription');
]]>
</query>
<query><![CDATA[
INSERT INTO `{PREFIX}mailtemplates` (`type`, `content`, `plugin`, `vars`, `subject`) VALUES
('subscription_activated', '', 'Subscription', '[subscription_title],[subscription_description],[login_link],[plan_title],[plan_description]', ''),
('subscription_pending', '', 'Subscription', '[subscription_title],[subscription_description],[link],[plan_title],[plan_description]', ''),
('subscription_expire', '', 'Subscription', '[subscription_title],[subscription_description],[link],[plan_title],[plan_description]', ''),
('subscription_reminder', '', 'Subscription', '[subscription_title],[subscription_description],[link],[expire_time],[plan_title],[plan_description]', ''),
('subscription_recurrence', '', 'Subscription', '[subscription_title],[subscription_description],[link],[plan_title],[plan_description]', ''),
('subscription_cancel_admin', '', 'Subscription', '[subscription_title],[subscription_description],[sender_title],[sender_link],[reason],[plan_title],[plan_description]', ''),
('subscription_refund_admin', '', 'Subscription', '[subscription_title],[subscription_description],[sender_title],[sender_link],[reason],[plan_title],[plan_description]', ''),
('subscription_refund_deny', '', 'Subscription', '[subscription_title],[subscription_description],[reason],[link],[plan_title],[plan_description]', ''),
('subscription_refund_accept', '', 'Subscription', '[subscription_title],[subscription_description],[link],[plan_title],[plan_description]', ''),
('subscription_cancel', '', 'Subscription', '[subscription_title],[subscription_description],[link],[plan_title],[plan_description]', '');
]]>
</query>
<query>
<![CDATA[
INSERT INTO `{PREFIX}i18n` (`locale`, `model`, `foreign_key`, `field`, `content`) VALUES
('eng', 'Mailtemplate', (SELECT `id` FROM `{PREFIX}mailtemplates` WHERE `type` = 'subscription_activated'), 'content', '<p>[header]</p>\r\n<p>Thank you for subscribing to our social network! Your subscription is now active.</p>\r\n<p>[subscription_title]</p>\r\n<p>[subscription_description]</p>\r\n<p>[plan_title]</p>\r\n<p>[plan_description]</p>\r\n<p>Please follow the link below to sign in.</p>\r\n<p><a href="[login_link]">[login_link]</a></p>\r\n<p>[footer]</p>'),
('eng', 'Mailtemplate', (SELECT `id` FROM `{PREFIX}mailtemplates` WHERE `type` = 'subscription_activated'), 'subject', 'Your subscription is now active.'),
('eng', 'Mailtemplate', (SELECT `id` FROM `{PREFIX}mailtemplates` WHERE `type` = 'subscription_pending'), 'content', '<p>[header]</p>\r\n<p>Your subscription cannot be completed because of a failed or missed payment.</p>\r\n<p>[subscription_title]</p>\r\n<p>[subscription_description]</p>\r\n<p>[plan_title]</p>\r\n<p>[plan_description]</p>\r\n<p>Please follow the link below to try again.</p>\r\n<p><a href="[link]">[link]</a></p>\r\n<p>[footer]</p>'),
('eng', 'Mailtemplate', (SELECT `id` FROM `{PREFIX}mailtemplates` WHERE `type` = 'subscription_pending'), 'subject', 'Your subscription is Pending.'),
('eng', 'Mailtemplate', (SELECT `id` FROM `{PREFIX}mailtemplates` WHERE `type` = 'subscription_expire'), 'content', '<p>[header]</p>\r\n<p>Your subscription has expired.</p>\r\n<p>[subscription_title]</p>\r\n<p>[subscription_description]</p>\r\n<p>[plan_title]</p>\r\n<p>[plan_description]</p>\r\n<p>Please follow the link below to renew your subscription.</p>\r\n<p><a href="[link]">[link]</a></p>\r\n<p></p>\r\n<p>[footer]</p>'),
('eng', 'Mailtemplate', (SELECT `id` FROM `{PREFIX}mailtemplates` WHERE `type` = 'subscription_expire'), 'subject', 'Your subscription has expired.'),
('eng', 'Mailtemplate', (SELECT `id` FROM `{PREFIX}mailtemplates` WHERE `type` = 'subscription_reminder'), 'content', '<p>[header]</p>\r\n<p>Your [subscription_title] will be expired on [expire_time].</p>\r\n<p>Please follow the link below to renew your membership.</p>\r\n<p><a href="[link]">[link]</a></p>\r\n<p>[footer]</p>'),
('eng', 'Mailtemplate', (SELECT `id` FROM `{PREFIX}mailtemplates` WHERE `type` = 'subscription_reminder'), 'subject', 'Subscription Reminder'),
('eng', 'Mailtemplate', (SELECT `id` FROM `{PREFIX}mailtemplates` WHERE `type` = 'subscription_recurrence'), 'content', '<p>[header]</p>\r\n<p>Your subscription has been billed. You should receive an email from the</p>\r\n<p>payment gateway regarding this charge. Thank you for subscribing to our social</p>\r\n<p>network.</p>\r\n<p>[subscription_title]</p>\r\n<p>[subscription_description]</p>\r\n<p>[plan_title]</p>\r\n<p>[plan_description]</p>\r\n<p>You may follow the link below to sign in.</p>\r\n<p><a href="[link]">[link]</a></p>\r\n<p>[footer]</p>'),
('eng', 'Mailtemplate', (SELECT `id` FROM `{PREFIX}mailtemplates` WHERE `type` = 'subscription_recurrence'), 'subject', 'Your subscription has been billed'),
('eng', 'Mailtemplate', (SELECT `id` FROM `{PREFIX}mailtemplates` WHERE `type` = 'subscription_cancel_admin'), 'content', '<p>[header]</p>\r\n<p>[sender_title] cancels his/her subscription.</p>\r\n<p>[subscription_title]</p>\r\n<p>[subscription_description]</p>\r\n<p>[plan_title]</p>\r\n<p>[plan_description]</p>\r\n<p>Reason: [Reason]</p>\r\n<p>[footer]</p>'),
('eng', 'Mailtemplate', (SELECT `id` FROM `{PREFIX}mailtemplates` WHERE `type` = 'subscription_cancel_admin'), 'subject', '[sender_title] cancelled his subscription'),
('eng', 'Mailtemplate', (SELECT `id` FROM `{PREFIX}mailtemplates` WHERE `type` = 'subscription_refund_admin'), 'content', '<p>[header]</p>\r\n<p>[sender_title] sent a refund request.</p>\r\n<p>[subscription_title]</p>\r\n<p>[subscription_description]</p>\r\n<p>[plan_title]</p>\r\n<p>[plan_description]</p>\r\n<p>Reason: [Reason]</p>\r\n<p>[footer]</p>'),
('eng', 'Mailtemplate', (SELECT `id` FROM `{PREFIX}mailtemplates` WHERE `type` = 'subscription_refund_admin'), 'subject', 'Request Refund'),
('eng', 'Mailtemplate', (SELECT `id` FROM `{PREFIX}mailtemplates` WHERE `type` = 'subscription_refund_deny'), 'content', '<p>[header]</p>\r\n<p>Admin denies your refund request.</p>\r\n<p>[subscription_title]</p>\r\n<p>[subscription_description]</p>\r\n<p>[plan_title]</p>\r\n<p>[plan_description]</p>\r\n<p>Reason: [Reason]</p>\r\n<p>Please follow the link below to sign in.</p>\r\n<p><a href="[link]">[link]</a></p>\r\n<p>[footer]</p>'),
('eng', 'Mailtemplate', (SELECT `id` FROM `{PREFIX}mailtemplates` WHERE `type` = 'subscription_refund_deny'), 'subject', 'Refund Deny'),
('eng', 'Mailtemplate', (SELECT `id` FROM `{PREFIX}mailtemplates` WHERE `type` = 'subscription_refund_accept'), 'content', '<p>[header]</p>\r\n<p></p>\r\n<p>Your subscription has been refunded and is no longer active.</p>\r\n<p>[subscription_title]</p>\r\n<p>[subscription_description]</p>\r\n<p>[plan_title]</p>\r\n<p>[plan_description]</p>\r\n<p>Please follow the link below to choose a different package.</p>\r\n<p><a href="[link]">[link]</a></p>\r\n<p></p>\r\n<p>[footer]</p>'),
('eng', 'Mailtemplate', (SELECT `id` FROM `{PREFIX}mailtemplates` WHERE `type` = 'subscription_refund_accept'), 'subject', 'Accept Refund'),
('eng', 'Mailtemplate', (SELECT `id` FROM `{PREFIX}mailtemplates` WHERE `type` = 'subscription_cancel'), 'content', '<p>[header]</p>\r\n<p>Your subscription has been cancelled.</p>\r\n<p>[subscription_title]</p>\r\n<p>[subscription_description]</p>\r\n<p>[plan_title]</p>\r\n<p>[plan_description]</p>\r\n<p>Please follow the link below to re-subscribe.</p>\r\n<p><a href="[link]">[link]</a></p>\r\n<p>[footer]</p>'),
('eng', 'Mailtemplate', (SELECT `id` FROM `{PREFIX}mailtemplates` WHERE `type` = 'subscription_cancel'), 'subject', 'Your subscription has been cancelled.');
]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}subscription_packages` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(128) NOT NULL,
`description` text NOT NULL,
`role_id` int(10) DEFAULT '0',
`recommended` tinyint(1) unsigned NOT NULL DEFAULT '1',
`default` tinyint(1) unsigned NOT NULL DEFAULT '0',
`ordering` int(11) DEFAULT '1',
`deleted` tinyint(2) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
); ]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}subscription_package_plans` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(128) NOT NULL,
`subscription_package_id` int(11) unsigned NOT NULL,
`type` tinyint(2) NOT NULL,
`price` decimal(16,2) unsigned NOT NULL,
`plan_duration` int(11) unsigned NOT NULL,
`plan_type` enum('day','week','month','year','forever') NOT NULL,
`expiration_reminder` int(11) unsigned NOT NULL,
`expiration_reminder_type` enum('day','week','month','year') NOT NULL,
`show_at` varchar(50) NOT NULL,
`enable_plan` tinyint(1) NOT NULL DEFAULT '0',
`billing_cycle` int(11) unsigned NOT NULL,
`billing_cycle_type` enum('day','week','month','year') NOT NULL,
`trial_price` decimal(16,2) unsigned NOT NULL,
`trial_duration` int(11) unsigned NOT NULL,
`trial_duration_type` enum('day','week','month','year') NOT NULL,
`deleted` tinyint(2) NOT NULL DEFAULT '0',
`order` tinyint(2) NOT NULL,
PRIMARY KEY (`id`)
); ]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}subscribes` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL,
`plan_id` int(11) unsigned NOT NULL,
`status` enum('initial','active','pending','expired','refunded','failed','cancel','process','inactive') NOT NULL DEFAULT 'initial',
`active` tinyint(1) unsigned NOT NULL DEFAULT '0',
`created` datetime NOT NULL,
`modified` datetime DEFAULT NULL,
`expiration_date` datetime DEFAULT NULL,
`reminder_date` datetime DEFAULT NULL,
`pay_date` datetime DEFAULT NULL,
`end_date` datetime DEFAULT NULL,
`gateway_id` int(10) DEFAULT NULL,
`is_warning_email_sent` tinyint(1) DEFAULT '0',
`currency_code` text NOT NULL,
`package_id` int(11) NOT NULL,
`is_trial` tinyint(1) NOT NULL DEFAULT '1',
`is_request_refund` tinyint(1) NOT NULL DEFAULT '0',
`transaction_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
); ]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}subscription_transactions` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`subscribes_id` int(11) DEFAULT NULL,
`package_id` int(11) DEFAULT NULL,
`gateway_id` int(10) unsigned NOT NULL,
`status` enum('initial','completed','pending','expired','refunded','failed','cancel','inactive') NOT NULL DEFAULT 'initial',
`amount` decimal(16,2) NOT NULL,
`currency` char(3) NOT NULL DEFAULT '',
`callback_params` text,
`plan_id` int(11) NOT NULL,
`created` datetime NOT NULL,
`type` enum('receive','pay') NOT NULL DEFAULT 'receive',
`admin` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
); ]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}subscription_compares` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`compare_name` varchar(255) NOT NULL,
`compare_value` text NOT NULL,
PRIMARY KEY (`id`)
); ]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}subscription_refunds` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`subscribe_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`status` enum('initial','denied','process','completed','failed') NOT NULL DEFAULT 'initial',
`account` varchar(128) NOT NULL,
`reason` text NOT NULL,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`transaction_id` int(11) NOT NULL,
`plan_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; ]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}settings` SET `value_actual` = 'img/logo.png', `value` = 'img/logo.png' WHERE `{PREFIX}settings`.`name` = 'logo';
]]>
</query>
<query><![CDATA[
INSERT INTO `{PREFIX}plugins` (`name`, `key`, `permission`, `enabled`, `core`, `version`, `weight`, `menu`, `url`, `icon_class`, `bootstrap`, `routes`) VALUES
('Subscription', 'Subscription', '', 1, 1, '2.2.1', 0, 1, '', '', 1, 1),
('Paypal Adaptive', 'PaypalAdaptive', '', 1, 1, '2.2.1', 0, 1, '', '', 1, 1);
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}core_blocks` SET `params` = '{"0":{"label":"Title","input":"text","value":"Tags","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Type","input":"select","value":{"all":"all","activities":"activity","comments":"comment","blogs":"blog","albums":"album","photos":"photo","topics":"topic","events":"event","videos":"video","groups":"group"},"name":"type"},"3":{"label":"Order by","input":"select","value":{"newest":"Newest","popular":"Popular","random":"Random"},"name":"order_by"},"4":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}' WHERE `{PREFIX}core_blocks`.`path_view` = 'core.tags';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}settings` SET `type_id` = 'textarea' WHERE `{PREFIX}settings`.`name` = 'ban_ips';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}settings` SET `value_actual` = '[{"name":"Default Theme","value":"default","select":1},{"name":"Bright Theme","value":"bright","select":0},{"name":"Dark Theme","value":"dark","select":0}]' WHERE `{PREFIX}settings`.`name` = 'default_theme';
]]>
</query>
<query><![CDATA[
UPDATE `{PREFIX}themes` SET `key` = 'bright', `name` = 'Bright Theme' WHERE `{PREFIX}themes`.`key` = 'light';
]]>
</query>
</queries>
</version>
<version>
<number>2.3.0</number>
<queries>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}ratings` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
`plugin` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
`type_id` int(10) DEFAULT NULL,
`score` tinyint(2) NOT NULL DEFAULT '0',
`rating_user_count` int(10) unsigned DEFAULT NULL,
`total_score` int(11) unsigned DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}rating_users` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL,
`rating_id` int(11) unsigned NOT NULL,
`score` tinyint(2) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}rating_settings` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`label` varchar(50) NOT NULL,
`name` varchar(50) NOT NULL,
`value` text NOT NULL,
`type` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;]]>
</query>
<query><![CDATA[
INSERT INTO `{PREFIX}rating_settings` (`label`, `name`, `value`, `type`) VALUES
('Enable Rating', 'enable_rating', '{"users":"1","blogs":"1","albums":"1","photos":"1","topics":"1","events":"1","videos":"1","groups":"1"}', 'checkbox'),
('Allow re-rating', 're_rating', '1', 'checkbox'),
('Skin', 'skin', 'skin.png', 'text'),
('Rating system', 'rating_system', '5', 'number');
]]>
</query>
<query><![CDATA[
INSERT INTO `{PREFIX}settings` (`group_id`, `label`, `name`, `field`, `value`, `is_hidden`, `version_id`, `type_id`, `value_actual`, `value_default`, `description`, `ordering`, `is_boot`) VALUES
(3, 'Ban Email Addresses', 'ban_emails', 'ban_emails', '', '0', NULL, 'textarea', '', '', 'Enter abc@def.xyz to ban the exact email address<br>Or abc@* to ban email addresses that start with abc@<br>Or *@abc.com to ban email addresses that end with @abc.com<br>One email address per line', '5', '0');
]]>
</query>
<query><![CDATA[
ALTER TABLE `{PREFIX}videos` ADD `in_process` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `thumb` ,
ADD `destination` VARCHAR( 255 ) NOT NULL AFTER `in_process`,
ADD `pc_upload` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `destination`;
]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}oauth_access_tokens` (
`access_token` varchar(40) NOT NULL,
`client_id` varchar(80) DEFAULT NULL,
`user_id` varchar(255) DEFAULT NULL,
`expires` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`scope` varchar(2000) DEFAULT NULL,
PRIMARY KEY (`access_token`)
);
]]>
</query>
<query><![CDATA[
CREATE TABLE IF NOT EXISTS `{PREFIX}oauth_refresh_tokens` (
`refresh_token` varchar(40) NOT NULL,
`client_id` varchar(80) DEFAULT NULL,
`user_id` varchar(255) DEFAULT NULL,
`expires` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`scope` varchar(2000) DEFAULT NULL,
PRIMARY KEY (`refresh_token`)
);
]]>
</query>
<query><![CDATA[
ALTER TABLE `{PREFIX}languages` ADD `rtl` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';
]]>
</query>
<query><![CDATA[
ALTER TABLE `{PREFIX}activities` ADD `share` TINYINT( 1 ) NOT NULL DEFAULT 0 ;
]]>
</query>
<query><![CDATA[
ALTER TABLE `{PREFIX}activities` ADD `parent_id` INT( 10 ) NOT NULL DEFAULT 0 ;
]]>
</query>
<query>
<![CDATA[
INSERT INTO `{PREFIX}settings` (`group_id`, `label`, `name`, `field`, `value`, `is_hidden`, `version_id`, `type_id`, `value_actual`, `value_default`, `description`, `ordering`, `is_boot`) VALUES
(2, 'Enable Cookies', 'enable_cookies', 'enable_cookies', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '1', 'You must enter deny url if you<br>enable this.', 17, 0),
(2, 'Deny Url', 'deny_url', 'deny_url', '', 0, NULL, 'text', '', '', 'Please include protocol http:// or https://', 17, 0);
]]>
</query>
<query>
<![CDATA[
ALTER TABLE `{PREFIX}users` ADD `group_count` smallint(5) unsigned NOT NULL DEFAULT '0';
]]>
</query>
<query>
<![CDATA[
ALTER TABLE `{PREFIX}users` ADD `event_count` smallint(5) unsigned NOT NULL DEFAULT '0';
]]>
</query>
<query>
<![CDATA[
ALTER TABLE `{PREFIX}videos` ADD `comment_count` smallint(5) unsigned NOT NULL DEFAULT '0';
]]>
</query>
<query>
<![CDATA[
ALTER TABLE `{PREFIX}photos` ADD `comment_count` smallint(5) unsigned NOT NULL DEFAULT '0';
]]>
</query>
<query>
<![CDATA[
ALTER TABLE `{PREFIX}albums` ADD `comment_count` smallint(5) unsigned NOT NULL DEFAULT '0';
]]>
</query>
<query>
<![CDATA[
ALTER TABLE `{PREFIX}blogs` ADD `share_count` smallint(5) unsigned NOT NULL DEFAULT '0';
]]>
</query>
<query>
<![CDATA[
ALTER TABLE `{PREFIX}topics` ADD `share_count` smallint(5) unsigned NOT NULL DEFAULT '0';
]]>
</query>
<query>
<![CDATA[
INSERT INTO `{PREFIX}settings` (`group_id`, `label`, `name`, `field`, `value`, `is_hidden`, `version_id`, `type_id`, `value_actual`, `value_default`, `description`, `ordering`, `is_boot`) VALUES
(2, 'Hide dislike', 'hide_dislike', 'hide_dislike', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"1","select":"0"}]', '', 19, 0);
]]>
</query>
<query>
<![CDATA[
ALTER TABLE `{PREFIX}mailrecipients` CHANGE `recipient` `recipient` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL;
]]>
</query>
<query>
<![CDATA[
UPDATE `{PREFIX}settings` SET `value_actual` = '[{"name":"5.0.0","value":"5.0.0","select":1},{"name":"3.2.3","value":"3.2.3","select":0}]' WHERE `{PREFIX}settings`.`name` = 'facebook_sdk_version';
]]>
</query>
<query>
<![CDATA[
UPDATE `{PREFIX}core_blocks` SET `params` = '{"0":{"label":"Title","input":"text","value":"Who''s Online","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Show member only","name":"member_only"},"3":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}' WHERE `{PREFIX}core_blocks`.`path_view` = 'user.onlineUsers';
]]>
</query>
<query><![CDATA[
ALTER TABLE `{PREFIX}activities` ADD `status` enum('ok','waiting') COLLATE utf8_unicode_ci DEFAULT 'ok' ;
]]>
</query>
<query>
<![CDATA[
INSERT INTO `{PREFIX}settings` (`group_id`, `label`, `name`, `field`, `value`, `is_hidden`, `version_id`, `type_id`, `value_actual`, `value_default`, `description`, `ordering`, `is_boot`) VALUES
(2, 'Allow sending message to non-friend', 'send_message_to_non_friend', 'send_message_to_non_friend', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '1', 'Check if users are allowed to send message to non-friend. Individual users can set option whether or not to only receive message from friend in profile setting. Otherwise, If unchecked, users can send message to friends only.', 18, 0);
]]>
</query>
<query>
<![CDATA[
ALTER TABLE `{PREFIX}users` ADD `receive_message_from_non_friend` tinyint(1) unsigned NOT NULL DEFAULT '1';
]]>
</query>
<query>
<![CDATA[
ALTER TABLE `{PREFIX}events` ADD `timezone` VARCHAR( 64 ) NOT NULL DEFAULT 'America/New_York';
]]>
</query>
<query>
<![CDATA[
UPDATE `{PREFIX}tags` set `tag` = replace(`tag`, ' ', '');
]]>
</query>
<query>
<![CDATA[
INSERT INTO `{PREFIX}core_blocks` (`name`, `path_view`, `params`, `is_active`, `plugin_id`, `group`, `restricted`, `plugin`) VALUES('Featured Groups', 'groups.featured', '{"0":{"label":"Title","input":"text","value":"Featured Groups","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"3":{"label":"plugin","input":"hidden","value":"Group","name":"plugin"}}', 1, 0, 'group', '', 'Group');
]]>
</query>
</queries>
</version>
</versions>