| Server IP : 80.87.202.40 / Your IP : 216.73.216.169 Web Server : Apache System : Linux rospirotorg.ru 5.14.0-539.el9.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Dec 5 22:26:13 UTC 2024 x86_64 User : bitrix ( 600) PHP Version : 8.2.27 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /home/bitrix/ext_www/ilovecveti.ru/bitrix/modules/statistic/install/db/mysql/ |
Upload File : |
insert into b_stat_adv ( ID,REFERER1,REFERER2,COST,REVENUE,EVENTS_VIEW,GUESTS,NEW_GUESTS,FAVORITES,C_HOSTS,SESSIONS,HITS,DATE_FIRST,DATE_LAST,GUESTS_BACK,FAVORITES_BACK,HOSTS_BACK,SESSIONS_BACK,HITS_BACK,DESCRIPTION,PRIORITY) values (1, 'Aport', '', '0.0000', '0.0000', null, 0, 0, 0, 0, 0, 0, null, null, 0, 0, 0, 0, 0, null, 100) ; insert into b_stat_adv ( ID,REFERER1,REFERER2,COST,REVENUE,EVENTS_VIEW,GUESTS,NEW_GUESTS,FAVORITES,C_HOSTS,SESSIONS,HITS,DATE_FIRST,DATE_LAST,GUESTS_BACK,FAVORITES_BACK,HOSTS_BACK,SESSIONS_BACK,HITS_BACK,DESCRIPTION,PRIORITY) values (2, 'Altavista', '', '0.0000', '0.0000', null, 0, 0, 0, 0, 0, 0, null, null, 0, 0, 0, 0, 0, null, 100) ; insert into b_stat_adv ( ID,REFERER1,REFERER2,COST,REVENUE,EVENTS_VIEW,GUESTS,NEW_GUESTS,FAVORITES,C_HOSTS,SESSIONS,HITS,DATE_FIRST,DATE_LAST,GUESTS_BACK,FAVORITES_BACK,HOSTS_BACK,SESSIONS_BACK,HITS_BACK,DESCRIPTION,PRIORITY) values (3, 'AOL', '', '0.0000', '0.0000', null, 0, 0, 0, 0, 0, 0, null, null, 0, 0, 0, 0, 0, null, 100) ; insert into b_stat_adv ( ID,REFERER1,REFERER2,COST,REVENUE,EVENTS_VIEW,GUESTS,NEW_GUESTS,FAVORITES,C_HOSTS,SESSIONS,HITS,DATE_FIRST,DATE_LAST,GUESTS_BACK,FAVORITES_BACK,HOSTS_BACK,SESSIONS_BACK,HITS_BACK,DESCRIPTION,PRIORITY) values (5, 'Google', null, '0.0000', '0.0000', '', 0, 0, 0, 0, 0, 0, null, null, 0, 0, 0, 0, 0, null, 100) ; insert into b_stat_adv ( ID,REFERER1,REFERER2,COST,REVENUE,EVENTS_VIEW,GUESTS,NEW_GUESTS,FAVORITES,C_HOSTS,SESSIONS,HITS,DATE_FIRST,DATE_LAST,GUESTS_BACK,FAVORITES_BACK,HOSTS_BACK,SESSIONS_BACK,HITS_BACK,DESCRIPTION,PRIORITY) values (6, 'Rambler', '', '0.0000', '0.0000', null, 0, 0, 0, 0, 0, 0, null, null, 0, 0, 0, 0, 0, null, 100) ; insert into b_stat_adv ( ID,REFERER1,REFERER2,COST,REVENUE,EVENTS_VIEW,GUESTS,NEW_GUESTS,FAVORITES,C_HOSTS,SESSIONS,HITS,DATE_FIRST,DATE_LAST,GUESTS_BACK,FAVORITES_BACK,HOSTS_BACK,SESSIONS_BACK,HITS_BACK,DESCRIPTION,PRIORITY) values (7, 'Yandex', '', '0.0000', '0.0000', null, 0, 0, 0, 0, 0, 0, null, null, 0, 0, 0, 0, 0, null, 100) ; insert into b_stat_adv ( ID,REFERER1,REFERER2,COST,REVENUE,EVENTS_VIEW,GUESTS,NEW_GUESTS,FAVORITES,C_HOSTS,SESSIONS,HITS,DATE_FIRST,DATE_LAST,GUESTS_BACK,FAVORITES_BACK,HOSTS_BACK,SESSIONS_BACK,HITS_BACK,DESCRIPTION,PRIORITY) values (8, 'Yahoo', null, '0.0000', '0.0000', '', 0, 0, 0, 0, 0, 0, null, null, 0, 0, 0, 0, 0, null, 100) ; insert into b_stat_adv ( ID,REFERER1,REFERER2,COST,REVENUE,EVENTS_VIEW,GUESTS,NEW_GUESTS,FAVORITES,C_HOSTS,SESSIONS,HITS,DATE_FIRST,DATE_LAST,GUESTS_BACK,FAVORITES_BACK,HOSTS_BACK,SESSIONS_BACK,HITS_BACK,DESCRIPTION,PRIORITY) values (10, 'MSN', null, '0.0000', '0.0000', '', 0, 0, 0, 0, 0, 0, null, null, 0, 0, 0, 0, 0, null, 100) ; insert into b_stat_adv_searcher ( ADV_ID,SEARCHER_ID) select adv.ID, searcher.ID from b_stat_adv adv inner join b_stat_searcher searcher on adv.REFERER1 = searcher.NAME ; update b_stat_adv set REFERER1 = lower(REFERER1);