#!c:\perl\bin\perl.exe
##########################################################################
# CGI        UNTITLED 													 # 	
# VERSION    0.0.1														 #
# DATE       26/11/2000													 #
# AUTHOR     Paulo Dom													 #
# EMAIL      paulodom@hotmail.com										 #
# COMPANY    System-Fox www.systemfox.cjb.net							 #
##########################################################################
 
   
    $title = "UnionBrasil Guia On-Line Bragança Paulista e Região";     # Titulo do Servidor  
    $fields = 12;                                                       # Numero de campos no mesmo registro
    $results = 1000;                                                    # Numero maximo de resultados obtidos
    &parse_form;
    
    $searchstring = $FORM{'procurar-string'};
    $bairstring = $FORM{'perto-string'};
    $indicestring = $FORM{'indice-procura'};
	$cidadestring = 'Bragança Paulista';
    $verbanner = 1;
	&addrecord if ($searchstring eq "**NOVO REGISTRO**");
	

#----------------------------- TODAS AS CIDADES--------------------------------------
    
 
#---------------------------- BRAGANÇA PAULISTA -------------------------------------
 
    if ($cidadestring  eq 'Bragança Paulista'){
    if ($indicestring eq 'Todos os Indices') {
	   $filename = 'D:\webs\unionb\data\database\braganca\urls.txt';       # dados
	}   

	if ($indicestring eq 'Todos') {
	   $filename = 'D:\webs\unionb\data\database\braganca\urls.txt';       # dados
	}   
    if ($indicestring eq 'Financia') {
	   $filename = 'D:\webs\unionb\data\database\braganca\financia.txt';   # dados
	}   
      if ($indicestring eq 'Cartão') {
	  $filename = 'D:\webs\unionb\data\database\braganca\cartao.txt';      # dados
	}   
     if ($indicestring eq 'Cheque Pré') {
	  $filename = 'D:\webs\unionb\data\database\braganca\cheque.txt';      # dados
	}   
     if ($indicestring eq 'Entrega') {
	  $filename = 'D:\webs\unionb\data\database\braganca\entrega.txt';     # dados
	}   
     if ($indicestring eq '24 Horas') {
	  $filename = 'D:\webs\unionb\data\database\braganca\24horas.txt';     # dados
	}   
    if ($indicestring eq 'Dom/feriados') {
	  $filename = 'D:\webs\unionb\data\database\braganca\dom.txt';         # dados
	}   
	if ($indicestring eq 'Horario') {
	  $filename = 'D:\webs\unionb\data\database\braganca\horario.txt';     # dados	  
	}   
   if ($indicestring eq 'Parcelado') {
	  $filename = 'D:\webs\unionb\data\database\braganca\parc.txt';        # dados
	}   
   if ($indicestring eq 'Promoções') {
	  $filename = 'D:\webs\unionb\data\database\braganca\promo.txt';       # dados
	}   
    if ($indicestring eq 'On-line') {
	  $filename = 'D:\webs\unionb\data\database\braganca\online.txt';      # dados
	}   
    if ($indicestring eq 'Grátis') {
	  $filename = 'D:\webs\unionb\data\database\braganca\gratis.txt';      # dados
	}   
	}
	
	
	
	&open_file("FILE1","",$filename); 
    &open_file("FILE2","",$filename);
#	&open_file("FILE3","",$filename);
    
    print "Content-type: text/html\n\n";
    print "<BODY  BGCOLOR=#FFFFFF TEXT=#000000 LINK=#0000FF VLINK=#0000FF ALINK=#0000FF topmargin='0' leftmargin='0'>";
  	print "<style>";
	print "a:hover{text-decoration:none;color:#FF0000}";
	print "a:link{text-decoration:none;color:#0000FF}";
	print "a:visited{text-decoration:none;color:#0000FF}";
	print "</style>";
	print "<title> Resultado da Pesquisa - <<UNION BRASIL GUIA ON-LINE <BRAGANÇA PAULISTA E REGIÃO>> </title>";    
	
#------------------------------------------------------------------------------------------------
#---------pate superior---------



#-----fim da parte superior----


    $counter = 0;
     while ($cont = &read_file("FILE2"))  {
         # Separa os campos pelo caractere | 
         @tabledata = split(/\s*\|\s*/,$cont ,$fields);
	     if ($bairstring) {    
   		     &check_record2;
			 }
		 else {
		     &check_record;
		 }	 	 
         if ($counter==0) {
		     $banner = $var2;
	     }		        
          if ($found == 1) {
            $counter++;
                     }
		 

    }
    if ($counter == 0) {
       $banner = 0;
	   &formulario3;
#	   &newform;
	  &nao_encontrado;
	  # print "<BR>\n";
	  # print "<BR><B> <CENTER><FONT SIZE=3 FACE=\"HELVETICA\"><FONT COLOR='#FFFFFF'> Não foi encontrada nada com <B> $searchstring </B>.</B></CENTER>\n";
    }
    else{
#    &newform;
    &formulario3;
#-----------contador-----------------	

print "<center>";



#----imagem de fundo--------------
print "<body bgcolor='#FFCC33'>";
print "<body bgcolor='#FFFFFF' topmargin='0' background='/imagem/fundo_union.gif' bgproperties='fixed'>";
#------fim de imagem de fundo-----

print "<CENTER>";
print "<table width='620' border='0' cellspacing='0' cellpadding='0'>";
print "    <tr> ";
print "      <td width='167' bgcolor='#FFCC33'> ";
#print "        <div align='right'><a href='http://www.unionbrasil.com.br' target='_self'><img src='/0/logo.gif' width='125' height='20' border='0'></a></div>";
#print "      </td>";
#print "      <td width='453' bgcolor='#FFCC33'> ";
#print "        <div align='center'><font size='2' face='Arial, Helvetica, sans-serif'><b><font color='#000000'><a href='/0/termo.htm' class='test' target='_self'>Cadastro</a> ";
#print "          | </font><font size='2' face='Arial, Helvetica, sans-serif'><b><font color='#000000'><a href='comofun.htm' class='white' target='_self'>Ajuda ! ";
#print "          !</a></font></b></font><font color='#000000'> | </font><font size='2' face='Arial, Helvetica, sans-serif'><b><font color='#000000'><a href='cancel.htm' class='white' target='_self'>Cancela</a></font></b></font><font color='#000000'> ";
#print "          | </font><font size='2' face='Arial, Helvetica, sans-serif'><b><font size='2' face='Arial, Helvetica, sans-serif'><b><font color='#000000'><a href='class.htm' class='white' target='_self'>Classificação</a></font></b></font><font color='#000000'> ";
#print "          | </font><font size='2' face='Arial, Helvetica, sans-serif'><b><font color='#000000'><a href='/1' class='test' target='_self'>Bate-Papo</a> ";
#print "          </font></b></font></b></font></b></font></div>";
print "      </td>";
print "    </tr>";
print "  </table>";
print "<\CENTER>";


#---fim do supr----


print "<tr>";
print "<td width='453' bgcolor='#FFFFFF'>";
print "<font face='arial' color='#FF0000' size='1'><LI>Foram encontrados";
print "</A>$refe $counter<b></B> &nbsp$searchstring em $indicestring perto do $bairstring<BR></center></td>";
print "</tr>";

  	    
}
#------------------------------------------------------------------------------------------------
# FAZ A PROCURA NA TABELA

     $teste1 = $FORM{'indice-soma'};		
	 $teste = $teste1+10;
     #$banner =0;
    $counter = 0;         
    $page = -1;
    $break = 0;	
	$prox = 0;  
    while ($line = &read_file("FILE1"))  {
         # Separa os campos pelo caractere | 
         @tabledata = split(/\s*\|\s*/,$line ,$fields);        
	     if ($bairstring) {    
   		     &check_record2;
			 }
		 else {
		     &check_record;
		 }	 	 
		  if ($found == 1) {	 	   
			   if ($counter==0)   {
			     #print "</UL>\n";
			 	 print "<div align='center'><center>";
                 print "<table border='0' cellpadding='0' cellspacing='0' width='620' height='15' bgcolor='#ffffff'>";
                 print "<tr>";
                 if ($banner==0) {			  
 				     print "<td width='76' bgcolor='#FFCC33'></td>";
			         print "<td width='468'><FONT SIZE=4 FACE=\"HELVETICA\" COLOR='FF0000'><img src='/imagem/legenda.gif'> </td>";
				     print "<td width='76' bgcolor='#FFCC33'></td>";
                     print "</tr>";
                     print "</table>";
 				    
   			    	 print "<div align='center'><center>";
                 }
				 }
				          
			  if ($break ==$teste) {
 				       $soma = $teste1+10;
					   $menos = $teste1-10;
					   if ($teste1) {
				      print "<p><B><a href='/0/bus.cgi?procurar-string=$searchstring&B1=Enviar&indice-cidade=Bragan%E7a+Paulista&indice-procura=$indicestring&perto-string=$bairstring&indice-pagina=p1&indice-soma=$menos'><FONT SIZE=4 FACE=\"HELVETICA\">&nbsp;&nbsp<img border='0' src='anterior.gif' width='172' height='24'></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp</B>";
						  }
				      print "<B><a href='/0/bus.cgi?procurar-string=$searchstring&B1=Enviar&indice-cidade=Bragan%E7a+Paulista&indice-procura=$indicestring&perto-string=$bairstring&indice-pagina=p1&indice-soma=$soma'><FONT SIZE=4 FACE=\"HELVETICA\"><img border='0' src='proxima.gif' width='172' height='24'></a></p></B>";		       					  
					  
					   &formulario3;
#					   &newform;
					   $break=0;								
  				       exit;
   				}
				else {
  				     if ($page < $teste1) {
				        $page++;
   				      } 
  				     if ($page>=$teste1) {			    												
						if ($grupo ne $var){
                        if ($banner==0) {			  
						    $grupo = $var;
 			#	            $banners = $banner;
			#				$banner=1;
							}
						$grupo = $var;
                        print "<CENTER>";
						print "<table border='0' cellpadding='0' cellspacing='0' width='620' height='15' bgcolor='#FFFFFF'>";
                        print "<tr>";
                        print "<td width='76' bgcolor='#FFCC33'></td>";
				        print "<td width='468' bgcolor='#FFCC33'><B><FONT SIZE=3 FACE=\"HELVETICA\" COLOR'#29A050'>&nbsp$grupo</td></B>";
				        print "<td width='76' bgcolor='#FFCC33'></td>";
                        print "</tr>";
                        print "</table>";
                        print "</center></div>";
  				        print "<div align='center'><center>";
                       # print "<table border='0' cellpadding='0' cellspacing='0' width='620' height='15' bgcolor='#FFFFFF'>";
                       # print "<tr>";
                       # print "<td width='76' bgcolor='#FFCC33'></td>";
				       # print "<td width='468'height='15'><FONT SIZE=3 FACE=\"HELVETICA\" COLOR='FF0000'> </td>";
				       # print "<td width='76' bgcolor='#FFCC33'></td>";
                       # print "</tr>";
                       # print "</table>";
                       #print "</center></div>";
                       #print "</center></div>";
					   #$grupo = $var;
				 }
						

						&print_record;		
						  
				      }
				}
			if ($group eq $var){		 
			    $counter++;
                $break++;
			  }				     
			  else {
               $group = $var;
               $break++;
			   				      }
			            }

    }    
    if (found !=0) {
	   print "<B><p><a href='/0/bus.cgi?procurar-string=$searchstring&B1=Enviar&indice-cidade=Bragan%E7a+Paulista&indice-procura=$indicestring&perto-string=$bairstring&indice-pagina=p1&indice-soma=$menos'><FONT SIZE=3 FACE=\"HELVETICA\">voltar</a></B>";
	   }
    &formulario3;
#	&newform;
#	&formulario3;   
    close(FILE1);


#########################################
#	   		 		   					#																																																		
#  Imprime os Registros					#
#  		   	  							#
#########################################
sub print_record {

#----------------teste-------------------

#--------fim do teste----------

print "<table width='620' border='0' cellspacing='0' cellpadding='0' align='center'>";
print "  <tr> ";
print "    <td width='76' bgcolor='#FFCC33' height='14'>&nbsp;</td>";
print "    <td bgcolor='#FFFFFF' height='14'> ";
print "      <table width='100%' border='0' cellspacing='0' cellpadding='0' bgcolor='#FFFFFF' height='5'>";
print "        <tr bgcolor='#FFCC33'> ";
print "          <td colspan='2'> ";
print "            <div align='center'><img src='/images/barrazul.gif' width='468' height='5'></div>";
print "          </td>";
print "        </tr>";
print "      </table>";
print "    </td>";
print "    <td width='76' align='center' bgcolor='#FFCC33' height='14'>&nbsp;</td>";
print "  </tr>";
print "  <tr> ";
print "    <td width='76' bgcolor='#FFCC33' height='68'>&nbsp;</td>";
print "    <td height='68'> ";
print "      <table width='100%' border='0' cellspacing='0' cellpadding='0' bgcolor='#270852' height='10'>";
print "        <tr bgcolor='#FFFFFF'> ";
if ($linklogo) {
   print "            <td rowspan='3' width='25%'> ";
   print "            <div align='center'><a href='$linkurl'><img src='$linklogo'></div>";
   }
else {
   print "          <td rowspan='3' width='1%'> ";
   #print "            <div align='center'><img src='/images/sembarra.gif' width='10' height='10'></div>";
}          



print "          </td>";
print "          <td width='81%' height='20'><font face='Arial, Helvetica, sans-serif' size='2'><b><font color='#FF0000'>". $linktitle . "</font></b></font></td>";
print "        </tr>";
print "        <tr bgcolor='#FFFFFF'> ";
print "          <td width='81%' height='20'><font size='2' face='Arial, Helvetica, sans-serif' color='#0000BF'>End:".$linkdescrip. "</font></td>";
print "        </tr>";
print "        <tr bgcolor='#FFFFFF'> ";
print "          <td width='81%' height='24'><font face='Arial, Helvetica, sans-serif' size='2' color='#0000BF'>".$linkbair." Tel: ".$linkfone."</font></td>";
print "        </tr>";
print "        <tr bgcolor='#FFFFFF'> ";
print "          <td colspan='2'>";
print "            <table width='100%' border='0' cellspacing='0' cellpadding='0' bgcolor='#FFFFFF' height='5'>";
print "              <tr bgcolor='#FFFFFF'> ";
print "                <td colspan='2'> ";
print "                  <div align='center'></div>";
print "                </td>";
print "              </tr>";
print "            </table>";
print "          </td>";
print "        </tr>";
print "      </table>";
print "    </td>";
print "    <td width='76' align='center' bgcolor='#FFCC33' height='68'>&nbsp;</td>";
print "  </tr>";

if ($linkurl) {
print "  <tr>";
print "    <td width='76' bgcolor='#FFCC33'>&nbsp;</td>";
print "    <td height='5'>";
print "      <table width='100%' border='0' cellspacing='0' cellpadding='0' bgcolor='#270852' height='10'>";
print "        <tr bgcolor='#FFFFFF'> ";
print "          <td width='3%'> ";
print "            <div align='right'></div>";
print "          </td>";
print "          <td width='49%'><img src='/imagem/cliqueai.gif' width='150' height='15'></td>";
print "          <td width='48%'> ";
print "            <div align='right'><a href='$linkurl'><img src='/barras/$linkimage' width='159' height='15' border='0'></div>";
print "          </td>";
print "        </tr>";
print "      </table>";
print "    </td>";
print "    <td width='76' align='center' bgcolor='#FFCC33'>&nbsp;</td>";
print "  </tr>";
print "</table>";
}
else{
print "  <tr>";
print "    <td width='76' bgcolor='#FFCC33'>&nbsp;</td>";
print "    <td height='5'>";
print "      <table width='100%' border='0' cellspacing='0' cellpadding='0' bgcolor='#270852' height='10'>";
print "        <tr bgcolor='#FFFFFF'> ";
print "          <td width='3%'> ";
print "            <div align='right'></div>";
print "          </td>";
print "          <td width='49%'></td>";
print "          <td width='48%'> ";
print "            <div align='right'><img src='/imagem/classificacao.gif' width='159' height='15' border='0'></div>";
print "          </td>";
print "        </tr>";
print "      </table>";
print "    </td>";
print "    <td width='76' align='center' bgcolor='#FFCC33'>&nbsp;</td>";
print "  </tr>";
print "</table>";
}

}


sub print_record2 {
print "<div align='center'><center>";
print" <table border='0' cellpadding='0' cellspacing='0' width='620' height='5' >";
print "<tr>";
print "<td width='76' bgcolor='#FFCC33'B ></td>";
print "<td width='468'bgcolor='#FFFFFF' > </A>   </B></td>";
print "<td width='76' bgcolor='#FFCC33'></td>";
print "</tr>";
print "</table>";

print "<div align='center'><center>";
print" <table border='0' cellpadding='0' cellspacing='0' width='620' height='5' >";
print "<tr>";
print "<td width='76' bgcolor='#FFCC33'B ></td>";
print "<td width='468'bgcolor='#0000BF' > </A>   </B></td>";
print "<td width='76' bgcolor='#FFCC33'></td>";
print "</tr>";
print "</table>";


print "<div align='center'><center>";
print" <table border='0' cellpadding='0' cellspacing='0' width='620'>";
print "<tr>";
print "<td width='76' bgcolor='#FFCC33'></td>";
print "<td width='468'bgcolor='#FFFFFF'><p aling='left'><B><FONT SIZE=4 FACE=\"HELVETICA\" COLOR='#0000BF'>&nbsp" . $linktitle ." </A>   </B></td>";
print "<td width='76' bgcolor='#FFCC33'></td>";
print "</tr>";
print "</table>";

print "<div align='center'><center>";
print" <table border='0' cellpadding='0' cellspacing='0' width='620'>";
print "<tr>";
print "<td width='76' bgcolor='#FFCC33'></td>";
print "<td width='468'bgcolor='#FFFFFF'><p aling='left'><FONT SIZE=2 FACE=\"HELVETICA\" COLOR='#0000BF'>&nbspEnd. " . $linkdescrip ." </A>   </B></td>";
print "<td width='76' bgcolor='#FFCC33'></td>";
print "</tr>";
print "</table>";

print "<div align='center'><center>";
print" <table border='0' cellpadding='0' cellspacing='0' width='620'>";
print "<tr>";
print "<td width='76' bgcolor='#FFCC33'></td>";
print "<td width='468'bgcolor='#FFFFFF'><p aling='left'><FONT SIZE=2 FACE=\"HELVETICA\" COLOR='#0000BF'>&nbsp" . $linkbair ."   <B> - Tel:	   ".$linkfone. " </A>   </B></td>";
print "<td width='76' bgcolor='#FFCC33'></td>";
print "</tr>";
print "</table>";



if ($linkurl) {
   print "<div align='center'><center>";
   print" <table border='0' cellpadding='0' cellspacing='0' width='620'>";
   print "<tr>";
   print "<td width='76' bgcolor='#FFCC33'></td>";
   print "<td width='234'bgcolor='#0000BF'><p aling='left'><FONT SIZE=3 FACE=\"HELVETICA\" COLOR='#FFFFFF'></A><img src='/imagem/cliqueai.gif'>   </B></td></p>";
   print "<td width='234'bgcolor='#0000BF'><p aling='right'><a href='$linkurl'><img src='/barras/$linkimage' align='right' border='0'> </A>   </B></td>";
   print "<td width='76' bgcolor='#FFCC33'></td>";
   print "</tr>";
   print "</table>";
      }
else {   
   print "<div align='center'><center>";
   print" <table border='0' cellpadding='0' cellspacing='0' width='620' height='15'>";
   print "<tr>";
   print "<td width='76'height='15' bgcolor='#000000'></td>";
   print "<td width='234'height='15'bgcolor='#000000'><p aling='left'><FONT SIZE=3 FACE=\"HELVETICA\" COLOR='000000'></A> </B></td>";
   print "<td width='234'bgcolor='#000000'><p aling='right'><FONT SIZE=3 FACE=\"HELVETICA\" COLOR='000000'><img src='/barras/none.gif' align='right'> </A>   </B></td>";
   print "<td width='76'height='15' bgcolor='#000000'></td>";
   print "</tr>";
   print "</table>";
  }

}


##########################################
#
#  Cheka para ver se existe a String
#
##########################################
sub check_record {
    # pega os dados do registro vindo do arquivo e le. $tabledata

   $linktitle = $tabledata[0];   #name company
   $linkdescrip = $tabledata[1]; #address the company
   $linkwords = $tabledata[2];   #primary key
   $var = $tabledata[2];        #rotate image
   $linkbair   = $tabledata[3];  #bair of the company
   $linkfone  = $tabledata[4];   #telephone of the company
   $linkimage  = $tabledata[6];  #location the image of the company
   $linkurl = $tabledata[7];     #hyperlink the page of the company
   $linkchave = $tabledata[8];   #secundary key
   $linklogo = $tabledata[11];    #logo
   $var2 = $tabledata[8];
    if ($counter ==0){
      $group = $tabledata[2];
	}
 

    #Constroi as linhas com os campos resultado da pesquisa

   $searchline = $linktitle ." " . $linkwords ."  ".$linkchave;
#    $searchline = $linktitle ." " . $linkwords ."  " .$linkchave;

   # Pesquisa por palavras chaves
   # A pesquisa so sera feita se a String tiver mais de dois caracteres
   # don't think we want people to search for and  or or etc.
   $sfound = 0;
   $found = 0;
   $notfound = 1; 

   if ($searchstring eq '*.*') {
      $notfound =0;
	}  
   
   $stlen = length($searchstring);
   if ($stlen == 1){
       $notfound =0;
	}  
   if ($stlen > -1) {
       @words = split(/ +/,$searchstring);
		foreach $aword (@words) {			
		   if ($searchline =~ /\b$aword/i){              
		      $sfound = 1;
           } 
           else {
                  $notfound = 0;
            }
         }
     }

    if ($sfound == 1 && $notfound == 1) {
        $found = 1;
     }

    # Se a string for muito pequena .. faca found = 1
    if ($stlen <= -1) {
        $found = 1;
    }
    # Se esta pagina nao tiver titulo entao retorne nao encontrado
    $tlen = length($linktitle);
    if ($tlen < -1) {
        $found = 0;
    }
}


sub check_record2 {
    # pega os dados do registro vindo do arquivo e le. $tabledata

   $linktitle = $tabledata[0];
   $linkdescrip = $tabledata[1];
   $linkwords = $tabledata[2];
   $var = $tabledata[2];
   $linkbair   = $tabledata[3];
   $linkfone  = $tabledata[4];
   $linkimage  = $tabledata[6];
   $linkchave = $tabledata[8];
   $linklogo = $tabledata[11];    
   $var2 = $tabledata[8];
    if ($counter ==0){
      $group = $tabledata[2];
	}
   #chop($linkurl);

    #Constroi as linhas com os campos resultado da pesquisa
    $searchline = $linktitle ." " . $linkwords ."  " .$linkchave;
	#$searchline = $linktitle . " " . $linkdescrip . " " . $linkwords;
    $searchline2 = $linkbair . " " . $linkdescrip;   
   # Pesquisa por palavras chaves
   # A pesquisa so sera feita se a String tiver mais de dois caracteres
   # don't think we want people to search for and  or or etc.
   $sfound = 0;
   $found = 0;
   $notfound = 1; 

   $stlen = length($searchstring);
   #$stlen2 = length($bairstring);
   if ($stlen > -1) {
       @words = split(/ +/,$searchstring);
       @words2 =  split(/ +/,$bairstring);
		foreach $aword (@words) {
		foreach $aword2 (@words2) {         
		
		if ($searchline2 =~ /\b$aword2/i){              
		   if ($searchline =~ /\b$aword/i){              
		      $sfound = 1;
           } 
           else {
                  $notfound = 0;
            }
         }
     }
	 }
	 }
    if ($sfound == 1 && $notfound == 1) {
        $found = 1;
     }

    # Se a string for muito pequena .. faca found = 1
    if ($stlen <= -1) {
        $found = 1;
    }
    # Se esta pagina nao tiver titulo entao retorne nao encontrado
    $tlen = length($linktitle);
    if ($tlen < -1) {
        $found = 0;
    }
}


############################################
#
#  Gravando Novo Endereco
#
############################################

sub addrecord {

  $linktitle    = $FORM{'linktitle'};
  $linkdescrip    = $FORM{'linkdescrip'};
  $linkwords    = $FORM{'linkwords'};
  $linkemail   = $FORM{'linkemail'};
  $linkurl = $FORM{'linkurl'};

  # Convertendo < tags para &lt;
  $linktitle =~ s/</\&lt;/g;
  $linkdescrip =~ s/</\&lt;/g;
  $linkwords =~ s/</\&lt;/g;
  $linkemail =~ s/</\&lt;/g;
  $linkurl =~ s/</\&lt;/g;

  
  &open_file("FILE1",">>",$filename);

  &write_file("FILE1",$linktitle . "|". $linkdescrip. "|" .$linkwords ."|" .$linkemail ."|" .$linkurl ."\n");
   close(FILE1);
   print "Content-type: text/html\n\n";
   print "<html><head><title>Obrigado !!!</title></head>\n";
#   print "<body Bgcolor='#FFFFFF'><BR><h3><CENTER>Obrigado pela contribuição !</CENTER></h3>\n";
   print "</body></html>\n";
   exit;
}




sub parse_form {

   read(STDIN, $buffer, $ENV{'CONTENT_LENGTH'});
   if (length($buffer) < 5) {
         $buffer = $ENV{QUERY_STRING};
    }
 
  @pairs = split(/&/, $buffer);
   foreach $pair (@pairs) {
      ($name, $value) = split(/=/, $pair);

      $value =~ tr/+/ /;
      $value =~ s/%([a-fA-F0-9][a-fA-F0-9])/pack("C", hex($1))/eg;

      $FORM{$name} = $value;
   }
}


sub open_file {

  local ($filevar, $filemode, $filename) = @_;
  
  open ($filevar,$filemode . $filename) ||
     die ("Não posso abrir $filename");
}

sub read_file {

  local ($filevar) = @_;

  <$filevar>;  
}

sub write_file {

  local ($filevar, $line, $cont) = @_;

  print $filevar ($line);
}


sub formulario3 {
print "<form method='get' action='/0/bus.cgi'>";
#if ($verbanner eq 1){  
print "<div align='center'><center>";
print "<table border='0' cellpadding='0' cellspacing='0' width='620' height='15' bgcolor='#FFFFFF'>";
print "<tr>";
print "<td width='76' bgcolor='#FFCC33'></td>";

#if ($found !=1) {
#     print "<td width='468'bgcolor='#0000BF'height='30'><FONT SIZE=3 COLOR='#0000BF' FACE=\"HELVETICA\"><B><center><FONT COLOR='#FFFFFF'><p align='center'><img src='/braganca/banners/0.gif'></FONT></B><BR></center></td>";     
#}
#else {
   print "<td width='468'bgcolor='#0000BF'height='30'><FONT SIZE=3 COLOR='#0000BF' FACE=\"HELVETICA\"><B><center><FONT COLOR='#FFFFFF'><p align='center'><img src='/braganca/banners/$banner.gif'></FONT></B><BR></center></td>";
#}  
print "<td width='76' bgcolor='#FFCC33'></td>";
print "</tr>";

#}

print "<div align='center'><center>";
print "<table border='0' width='620' cellspacing='0' cellpadding='0' vspace='0' hspace='0'>";
print "      <tr> ";
print "        <td width='76' bgcolor='#FFCC33' rowspan='3'>&nbsp;</td>";
print "        <td width='468' bgcolor='#FFFFFF'> ";
print "          <table border='0' width='446' vspace='0' hspace='0' cellspacing='0' cellpadding='0'>";
print "            <tr> ";
print "              <td nowrap>";
if ($verbanner eq 1){
#print "<div align='center'> <img src='/news/princ.gif' width='468' height='32'></div>";
   $verbanner = 2;
}
print "              </td>";
print "            </tr>";
print "          </table>";
print "        </td>";
print "        <td width='76' bgcolor='#FFCC33' rowspan='3'>&nbsp;</td>";
print "      </tr>";
print "      <tr> ";
print "        <td width='468' height='53' bgcolor='#FFFFFF'> ";



#-------busca-----
#print "<table>";
print "<CENTER>\n";
print "<table height='117' cellSpacing='0' cellPadding='0' width='230' border='0'>\n";
print "<tr>\n";
print "<td vAlign='top' width='200' height='117'>\n";
print "<div align='center'>\n";
print "<center>\n";
print "<table cellSpacing='0' cellPadding='0' width='468' border='0'>\n";
print "<tbody>\n";
print "<tr>\n";
print "<td align='middle' width='468' bgColor='#ffffff'>\n";
print "<form name='Pesquisar' action='/cgi-bin/engine.cgi' method='get'>\n";
print "<table height='31' cellSpacing='0' cellPadding='0' width='180' bgColor='#f8da60' border='1' hspace='0' vspace='0'>\n";
print "<tbody>\n";
print "<tr>\n";
print "<td width='646'>\n";
print "<table borderColor='#f8da60' height='91' cellSpacing='0' cellPadding='2' bgColor='#fdf5d1' border='0'>\n";
print "<tbody>\n";
print "<tr>\n";
print "<td borderColor='#f8da60' bgColor='#ffffff' height='87' rowSpan='3'>\n";
print "<table cellSpacing='0' cellPadding='5' width='1' border='0'>\n";
print "<tbody>\n";
print "<tr>\n";
print "<td borderColor='#f8da60' align='middle' width='192' bgColor='#f8da60' colSpan='2'><font face='Arial' color='#333399' size='2'><b>Atividade\n";
print "ou Produto</b></font></td>\n";
print "</tr>\n";
print "<tr>\n";
print "<td borderColor='#f8da60' width='39' bgColor='#ffffff'><img src='/imagem/lupa.gif' border='0' width='25' height='25'></td>\n";
print "<td borderColor='#f8da60' width='71' bgColor='#ffffff'><input size='14' name='procurar-string'></td>\n";
print "</tr>\n";
print "<tr>\n";
print "<td borderColor='#f8da60' width='39' bgColor='#fdf5d1'><font face='Arial' color='#333399' size='2'><b>Índices*</b></font></td>\n";
print "<td borderColor='#f8da60' width='141' bgColor='#fdf5d1'><b><font face='Arial, Helvetica, sans-serif' color='#3366cc'><select size='1' name='indice-procura'>\n";
print "<option value='Todos os Indices' selected>Todos os Indeces</option>\n";




print "</select></font></b></td>\n";
print "</tr>\n";
print "</tbody>\n";
print "</table>\n";
print "</td>\n";
print "<td borderColor='#f8da60' bgColor='#f8da60' colSpan='2' height='16'>\n";
print "<p align='center'>&nbsp;<font face='Arial' color='#333399' size='2'><b>Perto\n";
print "de*</b></font></p>\n";
print "</td>\n";
print "</tr>\n";
print "<tr>\n";
print "<td borderColor='#f8da60' bgColor='#ffffff' height='35'>\n";
print "<p align='center'><b><font face='Arial, Helvetica, sans-serif' color='#3366cc'><input size='12' name='perto-string'></font></b></p>\n";
print "</td>\n";
print "<td borderColor='#f8da60' bgColor='#ffffff' height='35'><input type='image' src='/imagem/ok.gif' border='0' name='I1' width='24' height='24'></td>\n";
print "</tr>\n";
print "<tr>\n";
print "<td borderColor='#f8da60' bgColor='#fdf5d1' height='28'>\n";
print "<p align='center'><font face='Arial' color='#ff0000' size='1'>&nbsp;(Indique\n";
print "o bairro)*</font></p>\n";
print "</td>\n";
print "<td borderColor='#f8da60' bgColor='#fdf5d1' height='28'>&nbsp;</td>\n";
print "</tr>\n";
print "</tbody>\n";
print "</table>\n";
print "</td>\n";
print "</tr>\n";
print "</tbody>\n";
print "</table>\n";
print "</form>\n";
print "</td>\n";
print "</tr>\n";
print "</tbody>\n";
print "</table>\n";
print "</div>\n";
print "</center></td>\n";
print "</tr>\n";
print "</table>\n";
print "</CENTER>\n";
print "</table>";


}
#----fim busca----
sub newform {

# print "<table width='620' border='0' cellspacing='0' cellpadding='0' align='center'>";
# print "      <tr> ";
# print "        <td bgcolor='#FFCC33' width='76' rowspan='3' valign='top'> ";
# print "          <div align='center'></div>";
# print "        </td>";
#if ($counter==0 ) {
#    print "        <td bgcolor='#FFFFFF' width='468'><img src='/braganca/banners/$banner.gif' width='468' height='60'></td>";
#}
#else{
if ($found==0) {
print "        <td bgcolor='#FFFFFF' width='468'><img src='/braganca/banners/0.gif' width='468' height='60'></td>";
}
else {
print "        <td bgcolor='#FFFFFF' width='468'><img src='/braganca/banners/$banner.gif' width='468' height='60'></td>";
}
#}      	
print "        <td bgcolor='#FFCC33' width='76' rowspan='3' valign='top'> ";
print "          <div align='center'></div>";
print "        </td>";
print "      </tr>";
print "      <tr> ";
print "        <td bgcolor='#FFFFFF'><img src='/news/princ.gif' width='468' height='32'></td>"; 
print "      </tr>";
print "      <tr> ";
print "        <td bgcolor='#FFFFFF' width='468'> ";
print "          <form method='get' action='0/bus.cgi' name='busca'>";
print "            <table border='0' width='468' cellspacing='0' cellpadding='0' vspace='0' hspace='0' bgcolor='#FFFFFF'>";
print "              <tr> ";
print "                <td bgcolor='#0000BF' valign='middle' nowrap width='11' height='31'> ";
print "                  <p><font color='#FFFFFF' face='Arial, Helvetica, sans-serif'><b> ";
print "                    </b></font><font color='#FFFFFF' face='Arial, Helvetica, sans-serif' size='2'><b><font color='#0000BF'> ";
print "                    </font></b></font></p>";
print "                </td>";
print "                <td bgcolor='#0000BF' valign='middle' nowrap colspan='2' height='31'><font color='#FFFFFF' face='Arial, Helvetica, sans-serif'><b><font size='2'>buscar</font></b></font> ";
print "                  <input type='TEXT' name='procurar-string' size='50'>";
print "                </td>";
print "                <td bgcolor='#0000BF' valign='bottom' rowspan='2' width='39' nowrap align='left'> ";
print "                  <div align='left'> ";
print "                    <input type='image' border='0' name='imageField3' src='/images/ok.gif' width='32' height='46'>";
print "                  </div>";
print "                </td>";
print "              </tr>";
print "              <tr valign='middle'> ";
print "                <td bgcolor='#FFCC33' width='11' valign='middle' nowrap height='28'>&nbsp;</td>";
print "                <td bgcolor='#FFCC33' width='193' valign='middle' nowrap height='28'><b><font color='#0000BF' face='Arial, Helvetica, sans-serif' size='2'> ";
print "                  e em </font><font color='#FFCC33' face='Arial, Helvetica, sans-serif' size='2'>.</font><font color='#0000BF' face='Arial, Helvetica, sans-serif'> ";
print "                  <select name='indice-procura'>";
print "                    <option value='Todos os Indices'>Todos os Indices</option>";

print "                  </select>";
print "                  <font size='2'> </font> </font></b></td>";
print "                <td bgcolor='#FFCC33' width='225' valign='middle' nowrap height='28'><b><font color='#0000BF' face='Arial, Helvetica, sans-serif'><font size='2'>perto do(a)</font> ";
print "                  <input type='TEXT' name='perto-string' size='19'>";
print "                  </font></b></td>";
print "              </tr>";
print "            </table>";
print "            <b><font color='#0000BF' face='Arial, Helvetica, sans-serif'><font color='#FFFFFF' size='1'>..d</font>";
print "<font size='1'>ex.: Informática em Bragança Paulista e em entrega perto do Jd. Europa</font></font></b> ";
print "          </form>";
print "        </td>";
print "      </tr>";
print "    </table>";

}

sub nao_encontrado{
#print "<CENTER>";
#print "<table border='0' width='620' cellspacing='0' cellpadding='0'vspace='0' hspace='0'>";
#print " <tr> ";
#print " <td>&nbsp;</td>";
#print "</tr>";
#print "</table>";
#print "<table border='0' width='620' cellspacing='0' cellpadding='0' vspace='0' hspace='0' align='center'>";
#print "    <tr> ";
#print "      <td width='76' bgcolor='#FFCC33' height='22' rowspan='3' valign='top'> ";

#print "        <div align='center'>";
#print "          <p>&nbsp;</p>";
#print "          <p>&nbsp;</p>";
#print "          <p>&nbsp;</p>";
#print "          <p>&nbsp;</p>";
#print "          <p>&nbsp;</p>";
#print "          <p>&nbsp;</p>";
#print "          <p>&nbsp;</p>";
#print "        </div>";
#print "      </td>";

#print "      <td width='468' height='18' bgcolor='#0000BF' nowrap> ";
#print "        <div align='center'> <font color='#FFFFFFFF'><b><font face='Arial, Helvetica, sans-serif' color='#FFFFFF' size='2'>Resultado da pesquisa</font></b></font></div>";
#print "      </td>";
#print "      <td width='76' bgcolor='#FFCC33' height='22' rowspan='3' align='left' valign='top'> ";
#print "        <div align='center'>";
#print "        </div>";
#print "      </td>";
#print "    </tr>";
#print "    <tr>";
#print "      <td width='468' height='18' bgcolor='#FFFFFF' nowrap> ";
#print "        <div align='CENTER'><br>";
print "<center><font face='Arial, Helvetica, sans-serif' color='#000000'>não foi encontrada nada como<B><font color='#ff0000'> $searchstring </B></font></div></center>";
#print "      </td>";
#print "    </tr>";
#print "    <tr>";

 #print "      <td width='468' height='208' bgcolor='#FFFFFF' nowrap valign='top'>";
 #print "        <p align='center'>&nbsp;</p>";
 #print "        <p align='center'>&nbsp;</p>";
 #print "        <p align='center'>&nbsp;</p>";
 #print "        <p align='center'>&nbsp;</p>";

 #print "        <p align='center'><font color='#000000' face='Arial, Helvetica, sans-serif' size='-1'><b></b></font></p>";
 #print "      </td>";
 #print "    </tr>";
 #print "  </table>";
 
#print "<table border='0' width='620' cellspacing='0' cellpadding='0'vspace='0' hspace='0'>";
#print " <tr> ";
#print " <td>&nbsp;</td>";
#print "</tr>";
print "</table>";

}