$facts_table_sql =<<<SQL
CREATE TABLE IF NOT EXISTS {$facts_table} (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 255 ) NULL DEFAULT NULL ,
`data` MEDIUMTEXT NULL DEFAULT NULL ,
`url` VARCHAR( 255 ) NULL DEFAULT NULL ,
`clicks` INT( 11 ) NOT NULL DEFAULT '0' ,
`created` DATETIME NULL DEFAULT NULL ,
`updated` DATETIME NULL DEFAULT NULL ,
PRIMARY KEY ( `id` )
) ENGINE=MYISAM DEFAULT CHARSET=utf8
SQL;
if ( ! Installer::createTable($facts_table,$facts_table_sql) ) Installer::failInstall( 'facts', __('Could not create table 1 of 1.') );
// create new permissions
if ( ! Installer::createPermissions('facts_view,facts_new,facts_edit,facts_delete') ) Installer::failInstall( 'facts' );
// create new roles
if ( ! Installer::createRoles('facts admin,facts editor,facts user') ) Installer::failInstall( 'facts' );
// assign permissions
// note: admin_view is needed in case they don't have any other permissions, otherwise they won't be able to log in to admin interface
if ( ! Installer::assignPermissions('administrator','facts_view,facts_new,facts_edit,facts_delete') ) Installer::failInstall( 'facts' );
if ( ! Installer::assignPermissions('editor','facts_view') ) Installer::failInstall( 'facts' );
if ( ! Installer::assignPermissions('facts admin','admin_view,facts_view,facts_new,facts_edit,facts_delete') ) Installer::failInstall( 'facts' );
if ( ! Installer::assignPermissions('facts editor','admin_view,facts_view,facts_new,facts_edit,facts_delete') ) Installer::failInstall( 'facts' );
if ( ! Installer::assignPermissions('facts user','admin_view,facts_view') ) Installer::failInstall( 'facts' );
// setup plugin settings
$settings = array(
'version' => '0.0.2'
`target` VARCHAR( 25 ) NULL DEFAULT NULL ,
`width` VARCHAR( 5 ) NULL DEFAULT NULL ,
`height` VARCHAR( 5 ) NULL DEFAULT NULL ,
`dcount` int(11) NOT NULL DEFAULT 0,
`ccount` int(11) NOT NULL DEFAULT 0,
`active` tinyint(1) NOT NULL DEFAULT 1,
`created` DATETIME NULL DEFAULT NULL ,
`expires` DATE NULL DEFAULT NULL,
`updated` DATETIME NULL DEFAULT NULL,
PRIMARY KEY ( `id` )
) ENGINE=MyISAM DEFAULT CHARSET=utf8
SQL;
if ( ! Installer::createTable($banner_table,$banner_table_sql) ) Installer::failInstall( 'banner', __('Could not create table 1 of 1.') );
// create new permissions
if ( ! Installer::createPermissions('banner_view,banner_new,banner_edit,banner_delete,banner_settings') ) Installer::failInstall('banner');
// create new roles
if ( ! Installer::createRoles('banner admin,banner manager') ) Installer::failInstall('banner');
// assign permissions
// note: admin_view is needed in case they don't have any other permissions, otherwise they won't be able to log in to admin interface
if ( ! Installer::assignPermissions('banner admin','admin_view,banner_view,banner_new,banner_edit,banner_delete,banner_settings') ) Installer::failInstall('banner');
if ( ! Installer::assignPermissions('banner manager','admin_view,banner_view,banner_new,banner_edit,banner_delete') ) Installer::failInstall('banner');
if ( ! Installer::assignPermissions('administrator','banner_view,banner_new,banner_edit,banner_delete,banner_settings') ) Installer::failInstall('banner');
// setup plugin settings
$settings = array(
'version' => '0.0.2',
'imgpath' => 'public/banners',
'imguri' => 'public/banners',
`id` INTEGER PRIMARY KEY AUTOINCREMENT ,
`url` VARCHAR( 255 ) ,
`hits` INT( 11 ) DEFAULT 0 NOT NULL ,
`created` DATETIME DEFAULT NULL ,
`updated` DATETIME DEFAULT NULL
);
INSERT INTO `{$errors_table}` ( `url`, `hits`, `created`, `updated` )
SELECT `url`, `hits`, `created_on`, `created_on`
FROM `{$errors_table}_old`;
DROP TABLE `{$errors_table}_old`;
SQL;
$sql = $driver == 'mysql' ? $errors_table_mysql : $errors_table_sqlite ;
if ( ! Installer::query($sql) ) Installer::failInstall( 'redirector', __('Could not alter table 2 of 2.') );
// create new permissions
if ( ! Installer::createPermissions('redirector_view,redirector_new,redirector_edit,redirector_delete,redirector_settings') ) Installer::failInstall( 'redirector' );
// create new roles
if ( ! Installer::createRoles('redirector admin,redirector editor,redirector user') ) Installer::failInstall( 'redirector' );
// assign permissions
// note: admin_view is needed in case they don't have any other permissions, otherwise they won't be able to log in to admin interface
if ( ! Installer::assignPermissions('administrator','redirector_view,redirector_new,redirector_edit,redirector_delete,redirector_settings') ) Installer::failInstall( 'redirector' );
if ( ! Installer::assignPermissions('editor','redirector_view') ) Installer::failInstall( 'redirector' );
if ( ! Installer::assignPermissions('redirector admin','admin_view,redirector_view,redirector_new,redirector_edit,redirector_delete,redirector_settings') ) Installer::failInstall( 'redirector' );
if ( ! Installer::assignPermissions('redirector editor','admin_view,redirector_view,redirector_new,redirector_edit,redirector_delete') ) Installer::failInstall( 'redirector' );
if ( ! Installer::assignPermissions('redirector user','admin_view,redirector_view') ) Installer::failInstall( 'redirector' );
// setup plugin settings
$settings = array(
'version' => '0.2.5',
) ENGINE=MYISAM DEFAULT CHARSET=utf8
SQL;
if ( ! Installer::createTable($downloadtags_table,$downloadtags_table_sql) ) Installer::failInstall( 'downloads', __('Could not create table 2 of 3.') );
$downloads_tags_table = TABLE_PREFIX.'downloads_tags';
$downloads_tags_table_sql =<<<SQL
CREATE TABLE IF NOT EXISTS {$downloads_tags_table} (
`download_id` INT( 11 ) NOT NULL ,
`tag_id` INT( 11 ) NOT NULL,
INDEX `download_tag` ( `download_id` , `tag_id` )
) ENGINE=MYISAM DEFAULT CHARSET=utf8
SQL;
if ( ! Installer::createTable($downloads_tags_table,$downloads_tags_table_sql) ) Installer::failInstall( 'downloads', __('Could not create table 3 of 3.') );
// create new permissions
if ( ! Installer::createPermissions('downloads_view,downloads_new,downloads_edit,downloads_delete,downloads_settings') ) Installer::failInstall('downloads');
// create new roles
if ( ! Installer::createRoles('download manager admin,download manager editor,download manager user') ) Installer::failInstall('downloads');
// assign permissions
// note: admin_view is needed in case they don't have any other permissions, otherwise they won't be able to log in to admin interface
if ( ! Installer::assignPermissions('download manager admin','admin_view,downloads_view,downloads_new,downloads_edit,downloads_delete,downloads_settings') ) Installer::failInstall('downloads');
if ( ! Installer::assignPermissions('download manager editor','admin_view,downloads_view,downloads_new,downloads_edit,downloads_delete') ) Installer::failInstall('downloads');
if ( ! Installer::assignPermissions('download manager user','admin_view,downloads_view') ) Installer::failInstall('downloads');
if ( ! Installer::assignPermissions('administrator','downloads_view,downloads_new,downloads_edit,downloads_delete,downloads_settings') ) Installer::failInstall('downloads');
// setup plugin settings
$settings = array(
'version' => '0.0.3',
'download_path' => 'public/downloads',
