UPDATE system_settings set use_non_latin='0' ,webroot_writable='1' ,enable_queuemetrics_logging='0' ,queuemetrics_server_ip='' ,queuemetrics_dbname='' ,queuemetrics_login='' ,queuemetrics_pass='' ,queuemetrics_url='' ,queuemetrics_log_id='VIC' ,queuemetrics_eq_prepend='NONE' ,vicidial_agent_disable='ALL' ,allow_sipsak_messages='0' ,admin_home_url='../dialer/welcome.php' ,enable_agc_xfer_log='0' ,timeclock_end_of_day='0000' ,vdc_header_date_format='MS_DASH_24HR 2008-06-24 23:59:59' ,vdc_customer_date_format='AL_TEXT_AMPM OCT 24 2008 11:59:59 PM' ,vdc_header_phone_format='US_PARN (000)000-0000' ,vdc_agent_api_active='1' ,enable_vtiger_integration='0' ,vtiger_server_ip='' ,vtiger_dbname='' ,vtiger_login='' ,vtiger_pass='' ,vtiger_url='' ,qc_features_active='1' ,outbound_autodial_active='1' ,outbound_calls_per_second='10' ,enable_tts_integration='1' ,agentonly_callback_campaign_lock='1' ,sounds_central_control_active='1' ,sounds_web_server='192.168.29.68' ,sounds_web_directory='NxeGODESCAD2GoawSv7dwU6dQitfgHmG' ,active_voicemail_server='192.168.29.68' ,auto_dial_limit='20' ,user_territories_active='0' ,allow_custom_dialplan='1' ,enable_second_webform='1' ,default_webphone='1' ,default_external_server_ip='0' ,webphone_url='./ViciPhone_new_design/viciphone.php' ,enable_agc_dispo_log='0' ,queuemetrics_loginout='STANDARD' ,callcard_enabled='1' ,queuemetrics_callstatus='1' ,default_codecs='' ,admin_web_directory='dialer' ,label_title='' ,label_first_name='' ,label_middle_initial='' ,label_last_name='' ,label_address1='' ,label_address2='' ,label_address3='' ,label_city='' ,label_state='' ,label_province='' ,label_postal_code='' ,label_vendor_lead_code='' ,label_gender='' ,label_phone_number='' ,label_phone_code='' ,label_alt_phone='' ,label_security_phrase='' ,label_email='' ,label_comments='' ,label_lead_id='' ,label_list_id='' ,label_entry_date='' ,label_gmt_offset_now='' ,label_source_id='' ,label_called_since_last_reset='' ,label_status='' ,label_user='' ,label_date_of_birth='' ,label_country_code='' ,label_last_local_call_time='' ,label_called_count='' ,label_rank='' ,label_owner='' ,label_entry_list_id='' ,custom_fields_enabled='1' ,slave_db_server='' ,reports_use_slave_db='' ,custom_reports_use_slave_db='' ,webphone_systemkey='' ,first_login_trigger='N' ,default_phone_registration_password='1DCk0gi4GntEk9t' ,default_phone_login_password='test' ,default_server_password='FmhUrMH0JH5YcYy' ,admin_modify_refresh='0' ,nocache_admin='1' ,generate_cross_server_exten='0' ,queuemetrics_addmember_enabled='0' ,queuemetrics_dispo_pause='' ,label_hide_field_logs='Y' ,queuemetrics_pe_phone_append='0' ,test_campaign_calls='0' ,agents_calls_reset='1' ,default_voicemail_timezone='eastern' ,default_local_gmt='-5.00' ,noanswer_log='N' ,alt_log_server_ip='' ,alt_log_dbname='' ,alt_log_login='' ,alt_log_pass='' ,tables_use_alt_log_db='' ,did_agent_log='N' ,campaign_cid_areacodes_enabled='1' ,pllb_grouping_limit='100' ,did_ra_extensions_enabled='1' ,expanded_list_stats='1' ,contacts_enabled='1' ,call_menu_qualify_enabled='0' ,admin_list_counts='1' ,allow_voicemail_greeting='0' ,queuemetrics_socket='NONE' ,queuemetrics_socket_url='' ,enhanced_disconnect_logging='0' ,allow_emails='1' ,level_8_disable_add='0' ,queuemetrics_record_hold='0' ,country_code_list_stats='0' ,queuemetrics_pause_type='0' ,frozen_server_call_clear='0' ,callback_time_24hour='0' ,enable_languages='1' ,language_method='MYSQL' ,meetme_enter_login_filename='' ,meetme_enter_leave3way_filename='' ,enable_did_entry_list_id='1' ,enable_third_webform='1' ,allow_chats='1' ,chat_url='' ,chat_timeout='0' ,agent_debug_logging='0' ,default_language='1001' ,agent_whisper_enabled='0' ,user_hide_realtime_enabled='0' ,usacan_phone_dialcode_fix='0' ,cache_carrier_stats_realtime='0' ,log_recording_access='0' ,report_default_format='TEXT' ,alt_ivr_logging='0' ,default_phone_code='1' ,admin_row_click='1' ,admin_screen_colors='default' ,ofcom_uk_drop_calc='0' ,agent_screen_colors='default' ,script_remove_js='1' ,manual_auto_next='0' ,user_new_lead_limit='0' ,agent_xfer_park_3way='0' ,agent_soundboards='1' ,web_loader_phone_length='DISABLED' ,agent_script='agent.php' ,agent_chat_screen_colors='default' ,enable_auto_reports='1' ,enable_pause_code_limits='0' ,enable_drop_lists='1' ,allow_ip_lists='1' ,system_ip_blacklist='' ,agent_push_events='0' ,agent_push_url='' ,hide_inactive_lists='0' ,allow_manage_active_lists='0' ,expired_lists_inactive='0' ,did_system_filter='0' ,anyone_callback_inactive_lists='default' ,enable_gdpr_download_deletion='0' ,source_id_display='0' ,agent_logout_link='1' ,manual_dial_validation='0' ,mute_recordings='0' ,user_admin_redirect='0' ,list_status_modification_confirmation='0' ,sip_event_logging='0' ,call_quota_lead_ranking='0' ,enable_second_script='1' ,enable_first_webform='1' ,recording_buttons='START_STOP' ,opensips_cid_name='0' ,require_password_length='0' ,user_account_emails='DISABLED' ,outbound_cid_any='DISABLED' ,entries_per_page='0' ,browser_call_alerts='0' ,queuemetrics_pausereason='STANDARD' ,inbound_answer_config='0' ,enable_international_dncs='0' ,web_loader_phone_strip='DISABLED' ,manual_dial_phone_strip='DISABLED' ,daily_call_count_limit='0' ,allow_shared_dial='0' ,agent_search_method='0' ,phone_defaults_container='---DISABLED---' ,qc_claim_limit='3' ,qc_expire_days='3' ,two_factor_auth_hours='0' ,two_factor_container='---DISABLED---' ,agent_hidden_sound='click_quiet' ,agent_hidden_sound_volume='25' ,agent_hidden_sound_seconds='0' ,agent_screen_timer='setTimeout' ,call_limit_24hour='0' ,allowed_sip_stacks='SIP_and_PJSIP' ,agent_hide_hangup='0' ,allow_web_debug='0' ,max_logged_in_agents='0' ,user_codes_admin='0' ,login_kickall='0' ,abandon_check_queue='0' ,agent_notifications='0' ,demographic_quotas='0' ,log_latency_gaps='1' ,inbound_credits='0' ,weekday_resets='0' ,two_factor_auth_agent_hours='0' ,hopper_hold_inserts='0' ,coldstorage_server_ip='' ,coldstorage_dbname='' ,coldstorage_login='' ,coldstorage_pass='' ,coldstorage_port='' ,enhanced_agent_monitoring='0' ,agent_hide_dial_fail='0' ,agent_man_dial_filter='' ,agent_3way_dial_filter='' ,stereo_recording='0' ,recording_dtmf_detection='0' ,recording_dtmf_muting='0' ,stereo_parallel_recording='0' ,db_crashed_tables_check='1' ,xfer_min_container='' ,max_inbound_auto_reenable='1' ,amd_status_map='' ,custom_dialplan_entry=''


UPDATE vicidial_url_multi SET url_address='' WHERE campaign_id='-SYSTEM-API-NEWLEAD-' and entry_type='system' and url_type='apinewlead'