UPDATE phones set extension='1607' , dialplan_number='1607' , voicemail_id='1607' , phone_ip='' , computer_ip='192.168.29.8' , server_ip='192.168.29.68' , login='1607' , pass='test' , status='ACTIVE' , active='Y' , phone_type='1607' , fullname='1607' , company='' , picture='' , protocol='SIP' , local_gmt='-5.00' , ASTmgrUSERNAME='cron' , ASTmgrSECRET='1234' , login_user='' , login_pass='' , login_campaign='' , park_on_extension='8301' , conf_on_extension='8302' , VICIDIAL_park_on_extension='8301' , VICIDIAL_park_on_filename='park' , monitor_prefix='8612' , recording_exten='8309' , voicemail_exten='8501' , voicemail_dump_exten='85026666666666' , ext_context='default' , dtmf_send_extension='local/8500998@default' , call_out_number_group='Zap/g2/' , client_browser='/usr/bin/mozilla' , install_directory='/usr/local/perl_TK' , local_web_callerID_URL='http://www.vicidial.org/test_callerid_output.php' , VICIDIAL_web_URL='' , AGI_call_logging_enabled='1' , user_switching_enabled='1' , conferencing_enabled='1' , admin_hangup_enabled='0' , admin_hijack_enabled='0' , admin_monitor_enabled='1' , call_parking_enabled='1' , updater_check_enabled='1' , AFLogging_enabled='1' , QUEUE_ACTION_enabled='1' , CallerID_popup_enabled='1' , voicemail_button_enabled='1' , enable_fast_refresh='0' , fast_refresh_rate='1000' , enable_persistant_mysql='0' , auto_dial_next_number='1' , VDstop_rec_after_each_call='1' , DBX_server='' , DBX_database='asterisk' , DBX_user='cron' , DBX_pass='1234' , DBX_port='3306' , DBY_server='' , DBY_database='asterisk' , DBY_user='cron' , DBY_pass='1234' , DBY_port='3306' , outbound_cid='1607' , enable_sipsak_messages='0' , email='' , template_id='' , conf_override='' ,phone_context='default' ,phone_ring_timeout='60' ,conf_secret='1DCk0gi4GntEk9t' , delete_vm_after_email='N' ,is_webphone='N' ,use_external_server_ip='N' ,codecs_list='' ,codecs_with_template='0' ,webphone_dialpad='Y' ,on_hook_agent='N' ,webphone_auto_answer='Y' ,voicemail_timezone='eastern' ,voicemail_options='' ,user_group='ADMIN' ,voicemail_greeting='' ,voicemail_dump_exten_no_inst='85026666666667' ,voicemail_instructions='Y' ,on_login_report='N' ,unavail_dialplan_fwd_exten='' ,unavail_dialplan_fwd_context='' , nva_call_url='' , nva_search_method='NONE' , nva_error_filename='' ,nva_new_list_id='995' ,nva_new_phone_code='1' ,nva_new_status='NVAINS' ,webphone_dialbox='Y' ,webphone_mute='Y' ,webphone_volume='Y' ,webphone_debug='N' ,outbound_alt_cid='' ,conf_qualify='Y' ,webphone_layout='' ,mohsuggest='' ,webphone_settings='VICIPHONE_SETTINGS' where extension='1607' and server_ip='192.168.29.68'
UPDATE servers SET rebuild_conf_files='Y' where generate_vicidial_conf='Y' and active_asterisk_server='Y' and server_ip='192.168.29.68'
UPDATE servers SET rebuild_conf_files='Y' ,sounds_update='Y' where generate_vicidial_conf='Y' and active_asterisk_server='Y' and server_ip='192.168.29.68'