<?php require_once('Connections/crbm21.php'); ?>
<?php
mysql_select_db($database_crbm21, $crbm21);
$query_Rslinks = "SELECT * FROM link ORDER BY NomeLink ASC";
$Rslinks = mysql_query($query_Rslinks, $crbm21) or die(mysql_error());
$row_Rslinks = mysql_fetch_assoc($Rslinks);
$totalRows_Rslinks = mysql_num_rows($Rslinks);

mysql_select_db($database_crbm21, $crbm21);
$query_RsDestaques = "SELECT * FROM destaques ORDER BY DataNoticia DESC";
$RsDestaques = mysql_query($query_RsDestaques, $crbm21) or die(mysql_error());
$row_RsDestaques = mysql_fetch_assoc($RsDestaques);
$totalRows_RsDestaques = mysql_num_rows($RsDestaques);

$maxRows_RsNoticias = 5;
$pageNum_RsNoticias = 0;
if (isset($_GET['pageNum_RsNoticias'])) {
  $pageNum_RsNoticias = $_GET['pageNum_RsNoticias'];
}
$startRow_RsNoticias = $pageNum_RsNoticias * $maxRows_RsNoticias;

mysql_select_db($database_crbm21, $crbm21);
$query_RsNoticias = "SELECT * FROM noticia ORDER BY DataNoticia DESC";
$query_limit_RsNoticias = sprintf("%s LIMIT %d, %d", $query_RsNoticias, $startRow_RsNoticias, $maxRows_RsNoticias);
$RsNoticias = mysql_query($query_limit_RsNoticias, $crbm21) or die(mysql_error());
$row_RsNoticias = mysql_fetch_assoc($RsNoticias);

if (isset($_GET['totalRows_RsNoticias'])) {
  $totalRows_RsNoticias = $_GET['totalRows_RsNoticias'];
} else {
  $all_RsNoticias = mysql_query($query_RsNoticias);
  $totalRows_RsNoticias = mysql_num_rows($all_RsNoticias);
}
$totalPages_RsNoticias = ceil($totalRows_RsNoticias/$maxRows_RsNoticias)-1;

$maxRows_RsAssessoria = 3;
$pageNum_RsAssessoria = 0;
if (isset($_GET['pageNum_RsAssessoria'])) {
  $pageNum_RsAssessoria = $_GET['pageNum_RsAssessoria'];
}
$startRow_RsAssessoria = $pageNum_RsAssessoria * $maxRows_RsAssessoria;

mysql_select_db($database_crbm21, $crbm21);
$query_RsAssessoria = "SELECT * FROM assessoria ORDER BY DataAssessoria DESC";
$query_limit_RsAssessoria = sprintf("%s LIMIT %d, %d", $query_RsAssessoria, $startRow_RsAssessoria, $maxRows_RsAssessoria);
$RsAssessoria = mysql_query($query_limit_RsAssessoria, $crbm21) or die(mysql_error());
$row_RsAssessoria = mysql_fetch_assoc($RsAssessoria);

if (isset($_GET['totalRows_RsAssessoria'])) {
  $totalRows_RsAssessoria = $_GET['totalRows_RsAssessoria'];
} else {
  $all_RsAssessoria = mysql_query($query_RsAssessoria);
  $totalRows_RsAssessoria = mysql_num_rows($all_RsAssessoria);
}
$totalPages_RsAssessoria = ceil($totalRows_RsAssessoria/$maxRows_RsAssessoria)-1;

$maxRows_RsEventos = 3;
$pageNum_RsEventos = 0;
if (isset($_GET['pageNum_RsEventos'])) {
  $pageNum_RsEventos = $_GET['pageNum_RsEventos'];
}
$startRow_RsEventos = $pageNum_RsEventos * $maxRows_RsEventos;

mysql_select_db($database_crbm21, $crbm21);
$query_RsEventos = "SELECT * FROM eventos";
$query_limit_RsEventos = sprintf("%s LIMIT %d, %d", $query_RsEventos, $startRow_RsEventos, $maxRows_RsEventos);
$RsEventos = mysql_query($query_limit_RsEventos, $crbm21) or die(mysql_error());
$row_RsEventos = mysql_fetch_assoc($RsEventos);

if (isset($_GET['totalRows_RsEventos'])) {
  $totalRows_RsEventos = $_GET['totalRows_RsEventos'];
} else {
  $all_RsEventos = mysql_query($query_RsEventos);
  $totalRows_RsEventos = mysql_num_rows($all_RsEventos);
}
$totalPages_RsEventos = ceil($totalRows_RsEventos/$maxRows_RsEventos)-1;

mysql_select_db($database_crbm21, $crbm21);
$query_RsTaxas = "SELECT * FROM taxas ORDER BY IdTaxas DESC";
$RsTaxas = mysql_query($query_RsTaxas, $crbm21) or die(mysql_error());
$row_RsTaxas = mysql_fetch_assoc($RsTaxas);
$totalRows_RsTaxas = mysql_num_rows($RsTaxas);

$colname_RsDestaquedetalhe = "1";
if (isset($_GET['IdNoticia'])) {
  $colname_RsDestaquedetalhe = (get_magic_quotes_gpc()) ? $_GET['IdNoticia'] : addslashes($_GET['IdNoticia']);
}
mysql_select_db($database_crbm21, $crbm21);
$query_RsDestaquedetalhe = sprintf("SELECT * FROM destaques WHERE IdNoticia = %s", $colname_RsDestaquedetalhe);
$RsDestaquedetalhe = mysql_query($query_RsDestaquedetalhe, $crbm21) or die(mysql_error());
$row_RsDestaquedetalhe = mysql_fetch_assoc($RsDestaquedetalhe);
$totalRows_RsDestaquedetalhe = mysql_num_rows($RsDestaquedetalhe);

$colname_RsNoticiadetalhe = "1";
if (isset($_GET['IdNoticia'])) {
  $colname_RsNoticiadetalhe = (get_magic_quotes_gpc()) ? $_GET['IdNoticia'] : addslashes($_GET['IdNoticia']);
}
mysql_select_db($database_crbm21, $crbm21);
$query_RsNoticiadetalhe = sprintf("SELECT * FROM noticia WHERE IdNoticia = %s", $colname_RsNoticiadetalhe);
$RsNoticiadetalhe = mysql_query($query_RsNoticiadetalhe, $crbm21) or die(mysql_error());
$row_RsNoticiadetalhe = mysql_fetch_assoc($RsNoticiadetalhe);
$totalRows_RsNoticiadetalhe = mysql_num_rows($RsNoticiadetalhe);

$colname_RsAssessoriadetalhe = "1";
if (isset($_GET['IdAssessoria'])) {
  $colname_RsAssessoriadetalhe = (get_magic_quotes_gpc()) ? $_GET['IdAssessoria'] : addslashes($_GET['IdAssessoria']);
}
mysql_select_db($database_crbm21, $crbm21);
$query_RsAssessoriadetalhe = sprintf("SELECT * FROM assessoria WHERE IdAssessoria = %s", $colname_RsAssessoriadetalhe);
$RsAssessoriadetalhe = mysql_query($query_RsAssessoriadetalhe, $crbm21) or die(mysql_error());
$row_RsAssessoriadetalhe = mysql_fetch_assoc($RsAssessoriadetalhe);
$totalRows_RsAssessoriadetalhe = mysql_num_rows($RsAssessoriadetalhe);

$colname_RsCurriculodetalhe = "1";
if (isset($_GET['IdCurriculo'])) {
  $colname_RsCurriculodetalhe = (get_magic_quotes_gpc()) ? $_GET['IdCurriculo'] : addslashes($_GET['IdCurriculo']);
}
mysql_select_db($database_crbm21, $crbm21);
$query_RsCurriculodetalhe = sprintf("SELECT * FROM curriculos WHERE IdCurriculo = %s", $colname_RsCurriculodetalhe);
$RsCurriculodetalhe = mysql_query($query_RsCurriculodetalhe, $crbm21) or die(mysql_error());
$row_RsCurriculodetalhe = mysql_fetch_assoc($RsCurriculodetalhe);
$totalRows_RsCurriculodetalhe = mysql_num_rows($RsCurriculodetalhe);

$colname_RsEventosdetalhe = "1";
if (isset($_GET['IdEvento'])) {
  $colname_RsEventosdetalhe = (get_magic_quotes_gpc()) ? $_GET['IdEvento'] : addslashes($_GET['IdEvento']);
}
mysql_select_db($database_crbm21, $crbm21);
$query_RsEventosdetalhe = sprintf("SELECT * FROM eventos WHERE IdEvento = %s", $colname_RsEventosdetalhe);
$RsEventosdetalhe = mysql_query($query_RsEventosdetalhe, $crbm21) or die(mysql_error());
$row_RsEventosdetalhe = mysql_fetch_assoc($RsEventosdetalhe);
$totalRows_RsEventosdetalhe = mysql_num_rows($RsEventosdetalhe);

mysql_select_db($database_crbm21, $crbm21);
$query_RsBancodecurriculos = "SELECT * FROM curriculos ORDER BY NomeCurriculo ASC";
$RsBancodecurriculos = mysql_query($query_RsBancodecurriculos, $crbm21) or die(mysql_error());
$row_RsBancodecurriculos = mysql_fetch_assoc($RsBancodecurriculos);
$totalRows_RsBancodecurriculos = mysql_num_rows($RsBancodecurriculos);

mysql_select_db($database_crbm21, $crbm21);
$query_RsEventossub = "SELECT * FROM eventos ORDER BY DataEvento DESC";
$RsEventossub = mysql_query($query_RsEventossub, $crbm21) or die(mysql_error());
$row_RsEventossub = mysql_fetch_assoc($RsEventossub);
$totalRows_RsEventossub = mysql_num_rows($RsEventossub);

mysql_select_db($database_crbm21, $crbm21);
$query_RsConcursos = "SELECT * FROM concursos ORDER BY NomeConcurso ASC";
$RsConcursos = mysql_query($query_RsConcursos, $crbm21) or die(mysql_error());
$row_RsConcursos = mysql_fetch_assoc($RsConcursos);
$totalRows_RsConcursos = mysql_num_rows($RsConcursos);

$colname_RsConcursodetalhe = "1";
if (isset($_GET['IdConcurso'])) {
  $colname_RsConcursodetalhe = (get_magic_quotes_gpc()) ? $_GET['IdConcurso'] : addslashes($_GET['IdConcurso']);
}
mysql_select_db($database_crbm21, $crbm21);
$query_RsConcursodetalhe = sprintf("SELECT * FROM concursos WHERE IdConcurso = %s", $colname_RsConcursodetalhe);
$RsConcursodetalhe = mysql_query($query_RsConcursodetalhe, $crbm21) or die(mysql_error());
$row_RsConcursodetalhe = mysql_fetch_assoc($RsConcursodetalhe);
$totalRows_RsConcursodetalhe = mysql_num_rows($RsConcursodetalhe);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>

<!-- InstanceBeginEditable name="doctitle" --><!-- TemplateBeginEditable name="doctitle" -->
<title>Conselho Regional de Biomedicina 2&ordf;Regi&atilde;o</title>
<!-- TemplateEndEditable --><!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
	background-image:  url(images/backgroundlistrado.gif);
}
-->
</style>
<link href="css/crbm.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style4 {color: #FFCC00}
.style6 {font-size: 12}
-->
</style>
<script language="JavaScript" type="text/JavaScript">
<!--


function MM_reloadPage(init) {  //reloads the window if Nav4 resized
  if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
    document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
  else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</script>
<!-- InstanceBeginEditable name="head" --><!-- TemplateBeginEditable name="head" --><!-- TemplateEndEditable --><!-- InstanceEndEditable -->
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
</head>

<body>
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
var pageTracker = _gat._getTracker("UA-5585662-1");
pageTracker._trackPageview();
</script>
<div align="center">
  <table width="779" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td>        <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0','width','779','height','205','src','flash/framesecundarias','quality','high','pluginspage','http://www.macromedia.com/go/getflashplayer','movie','flash/framesecundarias' ); //end AC code
</script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="779" height="205">
          <param name="movie" value="flash/framesecundarias.swf">
          <param name="quality" value="high">
          <embed src="flash/framesecundarias.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="779" height="205"></embed>
      </object></noscript></td>
    </tr>
  </table>
  <table width="779" height="35" border="0" cellpadding="0" cellspacing="0" background="images/tarjadata.gif" bgcolor="#FFFFFF">
    <tr>
      <td width="20">&nbsp;</td>
      <td width="759" valign="middle" class="link-branco"><div align="left">
        <SCRIPT language="JavaScript">
<!--
//
//
        hoje = new Date()
        dia = hoje.getDate()
        dias = hoje.getDay()
        mes = hoje.getMonth()
        ano = hoje.getYear()
        if (dia < 10)
                dia = "0" + dia
        if (ano < 2000)
                ano = "19" + ano
        function CriaArray (n) {
        this.length = n }
        NomeDia = new CriaArray(7)
        NomeDia[0] = "Domingo"
        NomeDia[1] = "Segunda-feira"
        NomeDia[2] = "Terça-feira"
        NomeDia[3] = "Quarta-feira"
        NomeDia[4] = "Quinta-feira"
        NomeDia[5] = "Sexta-feira"
        NomeDia[6] = "Sábado"
        //
        NomeMes = new CriaArray(12)
        NomeMes[0] = "Janeiro"
        NomeMes[1] = "Fevereiro"
        NomeMes[2] = "Março"
        NomeMes[3] = "Abril"
        NomeMes[4] = "Maio"
        NomeMes[5] = "Junho"
        NomeMes[6] = "Julho"
        NomeMes[7] = "Agosto"
        NomeMes[8] = "Setembro"
        NomeMes[9] = "Outubro"
        NomeMes[10] = "Novembro"
        NomeMes[11] = "Dezembro"

// function WriteDate() {
        document.write ("<font color='#005C41'  face='arial'>" + NomeDia[dias] + ", " + dia + " de " + NomeMes[mes] + " de " + ano + " </b></font>")
// }
// -->

      </SCRIPT>
      </div></td>
    </tr>
  </table>
  <table width="779" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td height="11" bgcolor="#FFFFFF"></td>
    </tr>
  </table>
  <table width="779" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
    <tr valign="top">
      <td width="184"><table width="184" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td height="24"><script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0','width','184','height','288','src','flash/menu','quality','high','pluginspage','http://www.macromedia.com/go/getflashplayer','movie','flash/menu' ); //end AC code
</script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="184" height="288">
            <param name="movie" value="flash/menu.swf">
            <param name="quality" value="high">
            <embed src="flash/menu.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="184" height="288"></embed>
          </object></noscript></td>
        </tr>
      </table>
        <div align="center">
          <table width="180" border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td height="10"></td>
            </tr>
            <tr>
              <td height="10"><a href="mailto:%20crbm2@veloxmail.com.br"><img src="images/cadastro.gif" width="180" height="61" border="0"></a></td>
            </tr>
            <tr>
              <td height="10"></td>
            </tr>
            <tr>
              <td><a href="prazosdocumentos.php"><img src="images/prazos.gif" width="180" height="61" border="0"></a></td>
            </tr>
            <tr>
              <td height="10"></td>
            </tr>
            <tr>
              <td><a href="revista.php"><img src="images/revista.gif" width="180" height="61" border="0"></a></td>
            </tr>
            <tr>
              <td height="10"></td>
            </tr>
            <tr>
              <td height="10"><a href="convite.php"><img src="images/quinta.gif" width="180" height="61" border="0"></a></td>
            </tr>
            <tr>
              <td height="10"></td>
            </tr>
            <tr>
              <td height="10"><img src="images/eventos.gif" width="179" height="21"></td>
            </tr>
            <tr>
              <td height="10" bgcolor="#FFFFFF"></td>
            </tr>
            <tr>
              <td height="10" bgcolor="#FFFFFF" class="link-noticias"><?php do { ?>
                <table width="179" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td>&nbsp;</td>
                    <td><div align="left"><span class="titulo1"><?php echo $row_RsEventos['PalavraEvento']; ?></span><br>
                            <a href="detalheevento.php?IdEvento=<?php echo $row_RsEventos['IdEvento']; ?>" class="link-noticias"><?php echo $row_RsEventos['ChamadaEvento']; ?></a> </div></td>
                  </tr>
                  <tr>
                    <td width="10">&nbsp;</td>
                    <td><div align="left"><img src="images/linhagrad.gif" width="158" height="1"></div></td>
                  </tr>
                </table>
              <?php } while ($row_RsEventos = mysql_fetch_assoc($RsEventos)); ?></td>
            </tr>
          </table>
</div></td>
      <td width="14">&nbsp;</td>
      <td><!-- InstanceBeginEditable name="conteudo" -->
        <table width="380" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td height="14"><p align="left" class="titulo1">CONSULTA P&Uacute;BLICA</p>
              <p align="left" class="texto">Estamos fazendo uma consulta p&uacute;blica &agrave;s empresas que est&atilde;o inscritas no CRBM 2 sobre os pre&ccedil;os &eacute;ticos conforme a tabela anexa. Esta iniciativa foi conjunta entre CFF, CRFs, CRBMs, CFBM, SBAC. </p>
            <p align="left" class="texto">Enviar sugest&otilde;es para o e-mail crbm2@hotlink.com.br e crbm2@veloxmail.com.br at&eacute; 18/09/2009.</p>
            <p align="left" class="titulo1"><a href="http://www.crbm2.com.br/arquivos/cff493precoseticos.pdf" class="economia">Clique aqui para baixar a tabela</a></p></td>
          </tr>
        </table>
      <!-- InstanceEndEditable --></td>
      <td width="14">&nbsp;</td>
      <td width="185" align="left"><table width="185" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td height="7"></td>
          </tr>
        </table>
        <table width="180" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td><img src="images/bannerhorario.gif" width="180" height="61"></td>
          </tr>
      </table>      </td>
    </tr>
  </table>
  <table width="779" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td height="25" bgcolor="#FFFFFF">&nbsp;</td>
    </tr>
  </table>
  <table width="779" height="81" border="0" cellpadding="0" cellspacing="0" background="images/tarjarodape.gif" bgcolor="#FFFFFF">
    <tr>
      <td width="20" height="25">&nbsp;</td>
      <td width="559">&nbsp;</td>
      <td width="200" rowspan="3" valign="bottom"><div align="right"><img src="images/dna.gif" width="71" height="75"></div></td>
    </tr>
    <tr>
      <td width="20">&nbsp;</td>
      <td width="559" valign="top"><div align="left"><span class="texto">Rua Gerv&aacute;sio Pires N&ordm; 1075 - Soledade- Recife - PE - CEP: 50.050-070 Telefones: (81) 3222.3200, 3221.1245<br> 
        FAX 3221.1080 - 
E-mails: <a href="mailto:%20crbm2@veloxmail.com.br" class="link-branco">crbm2@veloxmail.com.br</a> e <a href="mailto:%20crbm2@hotlink.com.br" class="link-branco">crbm2@hotlink.com.br</a></span></div></td>
    </tr>
    <tr>
      <td width="20" height="20">&nbsp;</td>
      <td width="559">&nbsp;</td>
    </tr>
  </table>
  <table width="779" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
    <tr>
      <td height="8"></td>
    </tr>
  </table>
  <table width="779" border="0" cellspacing="0" cellpadding="0">
    <tr bgcolor="#FFFFFF">
      <td>&nbsp;</td>
      <td width="140"><a href="http://www.helionegromonte.com.br" class="link-noticias">Cr&eacute;ditos de constru&ccedil;&atilde;o</a></td>
    </tr>
  </table>
  <table width="779" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
    <tr>
      <td height="8"></td>
    </tr>
  </table>
</div>
</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($Rslinks);

mysql_free_result($RsDestaques);

mysql_free_result($RsNoticias);

mysql_free_result($RsAssessoria);

mysql_free_result($RsEventos);

mysql_free_result($RsTaxas);

mysql_free_result($RsDestaquedetalhe);

mysql_free_result($RsNoticiadetalhe);

mysql_free_result($RsAssessoriadetalhe);

mysql_free_result($RsCurriculodetalhe);

mysql_free_result($RsEventosdetalhe);

mysql_free_result($RsBancodecurriculos);

mysql_free_result($RsEventossub);

mysql_free_result($RsConcursos);

mysql_free_result($RsConcursodetalhe);
?>