62 lines
2.6 KiB
PHP
62 lines
2.6 KiB
PHP
<?php
|
|
if (!defined('BASE_DIR')) exit;
|
|
|
|
/**
|
|
* AVE.cms - Модуль Баннеры (Modernized)
|
|
*/
|
|
|
|
$module_sql_install = array();
|
|
$module_sql_deinstall = array();
|
|
$module_sql_update = array();
|
|
|
|
// УДАЛЕНИЕ
|
|
$module_sql_deinstall[] = "DROP TABLE IF EXISTS `%%PRFX%%_module_banner_categories`;";
|
|
$module_sql_deinstall[] = "DROP TABLE IF EXISTS `%%PRFX%%_module_banners`;";
|
|
|
|
// УСТАНОВКА: Категории
|
|
$module_sql_install[] = "CREATE TABLE `%%PRFX%%_module_banner_categories` (
|
|
`id` mediumint(5) unsigned NOT NULL auto_increment,
|
|
`category_name` varchar(100) NOT NULL default '',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
|
|
|
|
// УСТАНОВКА: Баннеры
|
|
$module_sql_install[] = "CREATE TABLE `%%PRFX%%_module_banners` (
|
|
`id` int(10) unsigned NOT NULL auto_increment,
|
|
`category_id` mediumint(5) unsigned NOT NULL default '1',
|
|
`banner_file` varchar(255) NOT NULL default '',
|
|
`banner_url` varchar(255) NOT NULL default '',
|
|
`weight` tinyint(3) unsigned NOT NULL default '0',
|
|
`banner_name` varchar(100) NOT NULL default '',
|
|
`views` int(10) unsigned NOT NULL default '0',
|
|
`clicks` int(10) unsigned NOT NULL default '0',
|
|
`image_alt` varchar(255) NOT NULL default '',
|
|
`max_clicks` int(10) unsigned NOT NULL default '0',
|
|
`max_views` int(10) unsigned NOT NULL default '0',
|
|
`start_hour` smallint(2) unsigned NOT NULL default '0',
|
|
`end_hour` smallint(2) unsigned NOT NULL default '0',
|
|
`is_active` tinyint(1) unsigned NOT NULL default '1',
|
|
`target` varchar(255) NOT NULL default '_blank',
|
|
`width` int(10) unsigned NOT NULL default '0',
|
|
`height` int(10) unsigned NOT NULL default '0',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
|
|
|
|
$module_sql_install[] = "INSERT INTO `%%PRFX%%_module_banner_categories` VALUES (1, 'Категория 1');";
|
|
$module_sql_install[] = "INSERT INTO `%%PRFX%%_module_banner_categories` VALUES (2, 'Категория 2');";
|
|
|
|
$module_sql_install[] = "INSERT INTO `%%PRFX%%_module_banners` VALUES (0, 1, 'media_ave.jpg', 'https://ave-cms.ru', 1, 'AVE.CMS-Banner', 0, 0, 'Бесплатная система управления сайтом.', 0, 0, 0, 0, 1, '_self', 0, 0);";
|
|
$module_sql_install[] = "INSERT INTO `%%PRFX%%_module_banners` VALUES (0, 1, 'media_gitget.jpg', 'https://gitget.ru', 1, 'GitGet-Banner', 0, 0, 'Репозитории сообщества AVE.CMS.', 0, 0, 0, 0, 1, '_blank', 0, 0);";
|
|
|
|
$module_sql_update[] = "
|
|
UPDATE `%%PRFX%%_module`
|
|
SET
|
|
ModuleAveTag = '" . $module['ModuleAveTag'] . "',
|
|
ModulePHPTag = '" . $module['ModulePHPTag'] . "',
|
|
ModuleVersion = '" . $module['ModuleVersion'] . "'
|
|
WHERE
|
|
ModuleSysName = '" . $module['ModuleSysName'] . "'
|
|
LIMIT 1;
|
|
";
|
|
|
|
?>
|