ADMIN CHANGE LOG: Record Detail - 297
INSERT INTO vicidial_campaign_stats (campaign_id) values('REMOTEINBOUND')
INSERT INTO vicidial_campaign_stats_debug (campaign_id) values('REMOTEINBOUND')
INSERT INTO vicidial_inbound_group_agents (user,group_id,group_rank,group_weight,group_grade,group_web_vars,daily_limit) SELECT user,'REMOTEINBOUND' ,group_rank,group_weight,group_grade,group_web_vars,daily_limit from vicidial_inbound_group_agents where group_id="AGENTDIRECT"
UPDATE vicidial_users set closer_campaigns=REPLACE( closer_campaigns, ' AGENTDIRECT ' , ' AGENTDIRECT REMOTEINBOUND ' ) where closer_campaigns LIKE "% AGENTDIRECT %" and closer_campaigns NOT LIKE "% REMOTEINBOUND %"
INSERT INTO vicidial_url_multi (entry_type,active,url_type,url_rank,url_statuses,url_description,url_address,url_lists,campaign_id) SELECT entry_type,active,url_type,url_rank,url_statuses,url_description,url_address,url_lists,"REMOTEINBOUND" from vicidial_url_multi where campaign_id='AGENTDIRECT'
" readonly>
INSERT INTO vicidial_campaign_stats_debug (campaign_id) values('REMOTEINBOUND')
INSERT INTO vicidial_inbound_group_agents (user,group_id,group_rank,group_weight,group_grade,group_web_vars,daily_limit) SELECT user,'REMOTEINBOUND' ,group_rank,group_weight,group_grade,group_web_vars,daily_limit from vicidial_inbound_group_agents where group_id="AGENTDIRECT"
UPDATE vicidial_users set closer_campaigns=REPLACE( closer_campaigns, ' AGENTDIRECT ' , ' AGENTDIRECT REMOTEINBOUND ' ) where closer_campaigns LIKE "% AGENTDIRECT %" and closer_campaigns NOT LIKE "% REMOTEINBOUND %"
INSERT INTO vicidial_url_multi (entry_type,active,url_type,url_rank,url_statuses,url_description,url_address,url_lists,campaign_id) SELECT entry_type,active,url_type,url_rank,url_statuses,url_description,url_address,url_lists,"REMOTEINBOUND" from vicidial_url_multi where campaign_id='AGENTDIRECT'
" readonly>
