4.1
-- NetCat 4.1 Extra [0] component file, generated 2010-10-04 12:26:19
INSERT INTO `Class` SET `Class_Name` = 'Баннеры: Баннеры', `Class_Group` = 'Баннеры', `DaysToHold` = '0', `AllowTags` = '1', `FormPrefix` = '$f_AdminCommon', `FormSuffix` = '', `RecordTemplate` = '".opt($ban_hab=@explode("x",$f_Size),"")."\r\n".opt($ban_width=$ban_hab[0],"")."\r\n".opt($ban_height=$ban_hab[1],"")."\r\n\r\n<table border=0 cellpadding=0 cellspacing=0 width=100%><tr><td bgcolor=cccccc><table border=0 cellpadding=4 cellspacing=1 width=100%>\r\n<tr><td bgcolor=eeeeee><b>Баннер #$f_RowID</b>".opt($f_Size," ($f_Size)")."</td></tr>\r\n<tr><td bgcolor=white align=center>\r\n".opt($f_Type_id==1,"<a target=_blank href=$f_Link><img border=0 src=$f_File width=$ban_width height=$ban_height alt=\'$f_Alt\'></a>")."\r\n".opt($f_Type_id==2,"<object classid=clsid:D27CDB6E-AE6D-11cf-96B8-444553540000 codebase=http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0 width=$ban_width height=$ban_height id=banner$f_RowID><param name=movie value=$f_File><param name=quality value=high><embed src=$f_File name=banner$f_RowID quality=high bgcolor=ffffff width=$ban_width height=$ban_height type=application/x-shockwave-flash pluginspage=http://www.macromedia.com/go/getflashplayer></embed></object>")."\r\n".opt($f_Type_id==3,$f_Text)."\r\n</td></tr>\r\n<tr><td bgcolor=white>\r\n<font size=-2>\r\nСценарий показа: <b>#$f_Script. ".listQuery("SELECT Name FROM Message".$MODULE_VARS[banner][SCRIPT_TABLE]." WHERE Message_ID=\'$f_Script\'","\\$data[Name]")."</b><br><br>\r\n\r\n<table border=0 cellpadding=2 cellspacing=2 width=100%>\r\n<tr><td width=25%><font size=-2><br></td><td width=25% bgcolor=eeeeee><font size=-2>показов</td><td bgcolor=eeeeee width=25%><font size=-2>нажатий</td><td bgcolor=eeeeee width=25%><font size=-2>CTR</td></tr>\r\n<tr><td><font size=-2>Сегодня:</td><td><font size=-2>".($shows=listQuery("SELECT SUM(Shows) AS sum FROM Banner_StatsBanner WHERE Banner_ID=\'$f_RowID\' AND Date=CURDATE()","\\$data[sum]")+0)."</td><td><font size=-2>".($clicks=listQuery("SELECT (SUM(Clicks)+0) AS sum FROM Banner_StatsBanner WHERE Banner_ID=\'$f_RowID\' AND Date=CURDATE()","\\$data[sum]")+0)."</td><td><font size=-2>".(@($clicks/$shows)*100)."</td></tr>\r\n<tr>\r\n<td><font size=-2>Вчера:</td>\r\n<td><font size=-2>".($shows=listQuery("SELECT SUM(Shows) AS sum FROM Banner_StatsBanner WHERE Banner_ID=\'$f_RowID\' AND Date=DATE_ADD(CURDATE(),INTERVAL -1 DAY)","\\$data[sum]")+0)."</td>\r\n<td><font size=-2>".($clicks=listQuery("SELECT SUM(Clicks) AS sum FROM Banner_StatsBanner WHERE Banner_ID=\'$f_RowID\' AND Date=DATE_ADD(CURDATE(),INTERVAL -1 DAY)","\\$data[sum]")+0)."</td>\r\n<td><font size=-2>".(@($clicks/$shows)*100)."</td></tr>\r\n<tr><td><font size=-2>Всего:</td>\r\n<td><font size=-2>".($shows=listQuery("SELECT SUM(Shows) AS sum FROM Banner_StatsBanner WHERE Banner_ID=\'$f_RowID\'","\\$data[sum]")+0)."</td>\r\n<td><font size=-2>".($clicks=listQuery("SELECT SUM(Clicks) AS sum FROM Banner_StatsBanner WHERE Banner_ID=\'$f_RowID\'","\\$data[sum]")+0)."</td>\r\n<td><font size=-2>".(@($clicks/$shows)*100)."</td></tr></table><br>\r\n\r\nУчаствует в рекламных кампаниях: <i>".listQuery("SELECT a.Campaign_ID,b.Name FROM Banner_CampaignBanner AS a,Message".$MODULE_VARS[banner][CAMPAIGN_TABLE]." AS b WHERE b.Message_ID=a.Campaign_ID AND a.Banner_ID=\'$f_RowID\'","\\$data[Name] (#\\$data[Campaign_ID]); ")."</i><br>\r\n<font color=gray>Последний раз показан: ".listQuery("SELECT FROM_UNIXTIME(LastShow,\'%d-%m-%Y %H:%i:%s\') AS lastshown FROM Banner_CampaignBanner WHERE Banner_ID=\'$f_RowID\'","\\$data[lastshown]")."\r\n\r\n".opt($f_Type_id==2,"<blockquote><font color=red>* - для организации статистики по данному баннеру необходимо в swf-файле отредактировать элемент button и использовать для него следующий скрипт: on (release) { getURL(banner_url,banner_target); }</blockquote>")."".opt($f_Type_id==3,"<blockquote><font color=red>* - для организации статистики по данному баннеру можно использовать переменные %banner_url% и %banner_target% в поле &quot;Текст HTML-баннера&quot;, например так: &lt;a href=&quot;%banner_url%&quot; target=&quot;%banner_target%&quot;&gt;ссылка&lt;/a&gt;</blockquote>")."\r\n</td></tr>\r\n</table></td></tr></table>\r\n$f_AdminButtons\r\n<br>\r\n', `RecordsPerPage` = '20', `SortBy` = 'Message_ID', `RecordTemplateFull` = '', `TitleTemplate` = '', `AddTemplate` = '', `EditTemplate` = '', `AddActionTemplate` = '', `EditActionTemplate` = '', `SearchTemplate` = '', `FullSearchTemplate` = '', `SubscribeTemplate` = '', `System_Table_ID` = '0', `Settings` = '', `AddCond` = '', `EditCond` = '', `SubscribeCond` = '', `DeleteCond` = '', `NL2BR` = '0', `UseCaptcha` = '0', `CheckActionTemplate` = '', `DeleteActionTemplate` = '', `CustomSettingsTemplate` = '', `ClassDescription` = 'Компонент используется в модуле "Управление рекламой на сайте".\nБолее подробная информация о компоненте содержится в документации к этому модулю.', `DeleteTemplate` = '', `ClassTemplate` = '0', `CacheForUser` = '0';
CREATE TABLE Message%INSERT_ID% (`Message_ID` int(11) NOT NULL auto_increment, `User_ID` int(11) NOT NULL, `Subdivision_ID` int(11) NOT NULL, `Sub_Class_ID` int(11) NOT NULL, `Priority` int(11) NOT NULL default '0', `Keyword` char(255) NOT NULL, `Checked` tinyint(4) NOT NULL default '1', `TimeToDelete` date default NULL, `TimeToUncheck` date default NULL, `IP` char(15) default NULL, `UserAgent` char(255) default NULL, `Parent_Message_ID` int(11) NOT NULL default '0', `Created` datetime NOT NULL, `LastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `LastUser_ID` int(11) NOT NULL, `LastIP` char(15) default NULL, `LastUserAgent` char(255) default NULL, `Type` int NOT NULL, `Size` int NULL, `File` char(255) NULL, `Alt` char(255) NULL, `Text` text NULL, `Link` char(255) NOT NULL, `Script` int NOT NULL DEFAULT '1', `Status` tinyint NOT NULL, `NewWindow` tinyint NOT NULL, PRIMARY KEY (`Message_ID`), UNIQUE KEY `Sub_Class_ID` (`Sub_Class_ID`,`Message_ID`,`Keyword`), KEY `User_ID` (`User_ID`), KEY `LastUser_ID` (`LastUser_ID`), KEY `Subdivision_ID` (`Subdivision_ID`), KEY `Parent_Message_ID` (`Parent_Message_ID`) ) TYPE=MyISAM;
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'Type', 'Тип баннера', 4, 'BannerType', 1, 1, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'Size', 'Размер', 4, 'BannerSize', 0, 2, 1, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'File', 'Файл', 6, '50000', 0, 3, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'Alt', 'Alt (для GIF/JPEG)', 1, '', 0, 4, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'Text', 'Текст HTML-баннера', 3, '6:60', 0, 5, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'Link', 'Ссылка баннера', 1, 'url', 1, 6, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'Script', 'Номер сценария показа', 2, '', 1, 7, 0, '1', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'Status', 'включить баннер', 5, '', 1, 9, 1, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'NewWindow', 'Открывать ссылку в новом окне', 5, '', 1, 8, 0, '', 1);