<?php
include_once ('settings.php');

    foreach ($_GET as $key => $value) 
        $_GET[$key] = str_replace(array("'",'"'),array('',''),$value);    
    
    foreach ($_POST as $key => $value) 
        $_POST[$key] = str_replace(array("'",'"'),array('',''),$value);   
    
$catalogo_prefijo = $_POST['catalogo_prefijo'];



/*
        adm_cnf_prop_cor =  '".$_POST['adm_cnf_prop_cor']."',
        adm_cnf_fabr_cor =  '".$_POST['adm_cnf_fabr_cor']."',
        adm_cnf_enva_cor =  '".$_POST['adm_cnf_enva_cor']."',
        adm_cnf_impo_cor =  '".$_POST['adm_cnf_impo_cor']."',
        adm_cnf_dist_cor =  '".$_POST['adm_cnf_dist_cor']."',
        adm_cnf_repr_cor =  '".$_POST['adm_cnf_repr_cor']."',
        adm_cnf_acon_cor =  '".$_POST['adm_cnf_acon_cor']."',
        adm_cnf_alma_cor =  '".$_POST['adm_cnf_alma_cor']."',
        adm_cnf_labo_cor =  '".$_POST['adm_cnf_labo_cor']."',
        adm_cnf_pesc_cor =  '".$_POST['adm_cnf_pesc_cor']."',
				adm_cnf_penc_cor =  '".$_POST['adm_cnf_penc_cor']."',
*/




if ($_POST['op'] == 'graba') {

    if(($_POST['modeofform']=="u") || ($_POST['modeofform']=="i")) {

//adm_cnf_newing =  '".intval($_POST['cnf_newing'])."',

        $sql="UPDATE adm_config SET
        adm_cnf_pais      =  '".$_POST['codigo']."',
        adm_cnf_siglas    =  '".$_POST['adm_cnf_siglas']."',
        adm_cnf_licence   =  '".$_POST['adm_cnf_licence']."',
        adm_cnf_licence2  =  '".$_POST['adm_cnf_licence2']."',
        adm_cnf_ver       =  '".$_POST['adm_cnf_ver']."',
        adm_cnf_lang      =  '".$_POST['adm_cnf_lang']."',
        adm_cnf_tit_cor  =  '".$_POST['adm_cnf_tit_cor']."',

        adm_cnf_user     =  '".$_POST['adm_cnf_user']."',
        adm_cnf_passw    =  '".$_POST['adm_cnf_passw']."',
        adm_cnf_email1   =  '".$_POST['email1']."',
        adm_cnf_email2   =  '".$_POST['email2']."',
        adm_cnf_email3   =  '".$_POST['email3']."',
        adm_cnf_ipint    =  '".$_POST['ipint']."',
        adm_cnf_ipext    =  '".$_POST['ipext']."',
        adm_cnf_acceso    =  '".$_POST['acceso']."',
		adm_cnf_color     =  '".$_POST['adm_cfg_color']."',
		adm_cnf_timref    =  '".$_POST['adm_cnf_timref']."',
        adm_cnf_masktels    =  '".$_POST['masktels']."',
        adm_cnf_maskdates    =  '".$_POST['maskdates']."',
        adm_cnf_maskvalues    =  '".$_POST['maskvalues']."',
        
        adm_cnf_actividades    =  '".intval($_POST['cnf_actividades'])."',
        adm_cnf_mensajes    =  '".intval($_POST['cnf_mensajes'])."',
        adm_cnf_notas    =  '".intval($_POST['cnf_notas'])."',
        adm_cnf_frame    =  '".intval($_POST['cnf_frame'])."',
        
        adm_cnf_uts_costo = '".intval($_POST['uts_costo'])."',
 
        adm_cnf_numfal = ".intval($_POST['adm_cnf_numfal']).",
        adm_cnf_numfaldias = ".intval($_POST['adm_cnf_numfaldias']).",
        adm_cnf_numbol = ".intval($_POST['adm_cnf_numbol']).",
        adm_cnf_numrecfis= ".intval($_POST['adm_cnf_numrecfis']).",
        adm_cnf_numboldias = ".intval($_POST['adm_cnf_numboldias']).",
        adm_cnf_filesizeupl = ".intval($_POST['adm_cnf_filesizeupl']).",

        sistema_siglas = '".$_POST['sistema_siglas']."',
        sistema_name = '".$_POST['sistema_name']."',
        sistema_version = '".$_POST['sistema_version']."',
        adm_cnf_firma = '".$_POST['adm_cnf_firma']."',
        adm_cnf_firma2 = '".$_POST['adm_cnf_firma2']."',
        adm_cnf_desig1 = '".$_POST['adm_cnf_desig1']."',
        adm_cnf_desig2 = '".$_POST['adm_cnf_desig2']."',
        adm_cnf_cdvcor = '".$_POST['adm_cnf_cdvcor']."',
        
        adm_cnf_backup = '".intval($_POST['adm_cnf_backup'])."',
        adm_cnf_revfalbol = '".intval($_POST['adm_cnf_revfalbol'])."',

        adm_cnf_formnr = '".$_POST['adm_cnf_formnr']."',
        adm_cnf_versnr = '".$_POST['adm_cnf_versnr']."',
        adm_cnf_sopnr = '".$_POST['adm_cnf_sopnr']."',

        adm_cnf_formnr2 = '".$_POST['adm_cnf_formnr2']."',
        adm_cnf_versnr2 = '".$_POST['adm_cnf_versnr2']."',
        adm_cnf_sopnr2 = '".$_POST['adm_cnf_sopnr2']."',
        adm_cnf_superoff ='".$_POST['adm_cnf_superoff']."',   
        adm_cnf_cod_acc_tm = ".intval($_POST['adm_cnf_cod_acc_tm']).",

        adm_cnf_email_asoc1 = '".$_POST['email_asoc1']."',
        adm_cnf_email_asoc2 = '".$_POST['email_asoc2']."',
        adm_cnf_email_asoc3 = '".$_POST['email_asoc3']."',
        adm_cnf_email_asoc4 = '".$_POST['email_asoc4']."',
        adm_cnf_email_asoc5 = '".$_POST['email_asoc5']."',
        adm_cnf_email_asoc6 = '".$_POST['email_asoc6']."',
        adm_cnf_email_asoc7 = '".$_POST['email_asoc7']."',
        adm_cnf_email_asoc8 = '".$_POST['email_asoc8']."',
        adm_cnf_email_asoc9 = '".$_POST['email_asoc9']."',

        sistema_logo = '".$_POST['sistema_logo']."';";
echo $sql;
        $result = $connection->Execute ( $sql );
        if ($connection->Affected_Rows() == 1)
            $info = $arr_label['datos_grabados'];
        $error = $connection->ErrorMsg();
//echo $error;
        $info = $arr_label['datos_grabados'];

        //$sql = "UPDATE ctg_tipo_tramites SET ctg_tpt_costo = ctg_tpt_uts  * ".intval($_POST['uts_costo'])." WHERE ctg_tpt_uts > 0";
        //echo $sql."<br>";
        //$result = $connection->Execute ( $sql );
        
        
    }
}

        //echo $sql."<br>".$error."<br>".$info;
        
if ($error != '') {
    include_once ("send_error_mail.php");
    $error = 1; 
    $info = "";
} 

//sleep(1);
?>
<script language="javascript" type="text/javascript">
window.top.window.result_op('<?=$error?>','<?=$info?>','<?=$_POST["codigo"]?>');
</script>
<?php
die(); // Dont forget this, if not you'll echo the form again.
?>
