$cgccpf = str_replace(".", "", $cgccpf); $cgccpf = str_replace("/", "", $cgccpf); $cgccpf = str_replace("-", "", $cgccpf); $sql_exe = "select ident from db_config"; $result = pg_exec($sql_exe) or die("Erro: " . pg_ErrorMessage($conn)); db_fieldsmemory($result, 0); /* $sql_exe = "select * from iptubase,cgm where j01_matric = $matricula and j01_numcgm = z01_numcgm "; if ( $db_verifica_ip == "0" ) { $sql_exe = $sql_exe . " and trim(z01_cgccpf) = '$cgccpf' and trim(z01_cgccpf) != ''"; } $result = pg_exec($sql_exe) or die("Erro: ".pg_ErrorMessage($conn)); */ $result = $cliptubase->sql_record($cliptubase->sql_query("", "*", "", "iptubase.j01_matric = {$matricula} and j01_numcgm = z01_numcgm")); } else { /* $result = pg_exec("select * from iptubase,cgm where j01_matric = $matricula and j01_numcgm = z01_numcgm") or die("Erro: ".pg_ErrorMessage($conn)); $cgccpf = trim(pg_result($result,0,'z01_cgccpf')); */ $result = $cliptubase->sql_record($cliptubase->sql_query("", "*", "", "iptubase.j01_matric = {$matricula} and cgm.j01_numcgm = z01_numcgm")); } db_fieldsmemory($result, 0); include "libs/db_mens.php"; if ($cliptubase->numrows == 0) { db_logs("{$matricula}", "", 0, "Dados Inconsistentes. Numero : {$matricula}"); db_redireciona("digitaitbi.php?" . base64_encode("erroscripts=Os dados informados não conferem, verifique!")); $script = false;
if ($id_usuario != "" || $_COOKIE["cookie_codigo_cgm"] != "") { $usuario = $id_usuario == "" ? $_COOKIE["cookie_codigo_cgm"] : $id_usuario; $result = $clcgm->sql_record($clcgm->sql_query("", "cgm.z01_cgccpf, cgm.z01_nome, cgm.z01_numcgm", "", "cgm.z01_numcgm = {$usuario}")); $linhas = $clcgm->numrows; if ($linhas != 0) { db_fieldsmemory($result, 0); //11 14 if (strlen($z01_cgccpf) > 11) { $cgc = $z01_cgccpf; $cpf = ""; } else { $cgc = ""; $cpf = $z01_cgccpf; } // iptu $result2 = $cliptubase->sql_record($cliptubase->sql_query("", "*", "", "cgm.z01_numcgm = {$z01_numcgm}")); $linhas2 = $cliptubase->numrows; ?> <table width="60%" border="1" bordercolor="#cccccc" cellpadding="5" cellspacing="0" class="texto"> <tr> <td width="100%" nowrap height="28" bgcolor="<?php echo $w01_corfundomenu; ?> "> <table width="100%" border="0" cellpadding="1" cellspacing="0" class="texto"> <tr><td> <img src="imagens/icone.gif" border="0"> </td><td> CNPJ/CPF: <span class="bold3"><?php echo $z01_cgccpf; ?>