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;
|
||
";
|
||
|
||
?>
|