CODI

<? include ("revistab.inc"); ?>
<? 
$via ="revista";
include ("controlacceso.php"); ?>
<?php

if ($treure=="si") {
		$link = mysql_pconnect('','pame','pame');
		mysql_select_db("basepame", $link);
		$sql="UPDATE articulorevista SET orden='' WHERE id=$id"; 
		$result=mysql_query($sql,$link);
	}		
	if ($agendap!=''){
		$link = mysql_pconnect('','pame','pame');
		mysql_select_db("basepame", $link);
		$sql="UPDATE articulorevista SET orden='agenda' WHERE id=$agendap"; 
		$result=mysql_query($sql,$link);
	}
	if ($portada!=''){
		$link = mysql_pconnect('','pame','pame');
		mysql_select_db("basepame", $link);
		$sql="UPDATE articulorevista SET orden='portada' WHERE id=$portada"; 
		$result=mysql_query($sql,$link);
	}
?>
<SCRIPT language=JavaScript type=text/JavaScript>
		posicioH=(ample-787)/2;
		document.write("<div id='SECCION' style='position:absolute; left:"+posicioH+"px; top:137px; width:765px; height:1px; z-index:4; visibility: visible;'>")
</SCRIPT>
	<TABLE cellSpacing=0 cellPadding=0 width=765 border=0>
		<tr>
			<td width="14" height=15 bgColor=#205599><IMG height=1 src="revista/punto.gif" width=1></td>
			<td width="4" height=15 bgColor=#205599><IMG height=1 src="revista/punto.gif" width=1></td>
			<td width="539" height=15 bgColor=#205599><IMG height=1 src="revista/punto.gif" width=1></td>
			<td width="4" height=15 bgColor=#205599><IMG height=1 src="revista/punto.gif" width=1></td>
			<td width="27" height=15 bgColor=#205599><IMG height=1 src="revista/punto.gif" width=1></td>
			<td width="177" height=15 bgColor=#ECEEF9><IMG height=1 src="revista/punto.gif" width=1></td>
		</tr>
		<tr>
    		<td bgColor=#205599 height=5 ><IMG height=1 src="revista/punto.gif" width=1></td>	
			<td bgColor=#4075b9 height=17 colspan="3">
				<TABLE cellSpacing=1 cellPadding=0 width="100%" border=0>
		        	<tr>
          				<td bgColor=#205599 height=15><div align='center'><font color="#FFFFFF">Portada</font></div></td>
					</tr>
				</TABLE>
			</td>
			<td height=5 bgColor=#205599><IMG height=1 src="revista/punto.gif" width=1></td>
			<td height=5 bgColor=#ECEEF9><IMG height=1 src="revista/punto.gif" width=1></td>
		</tr>
		<tr>
			<td bgColor=#205599 height=5><IMG height=1 src="revista/punto.gif" width=1></td>
			<td bgColor=#205599 height=5><IMG height=1 src="revista/punto.gif" width=1></td>
			<td bgColor=#000066 height=5><IMG height=1 src="revista/punto.gif" width=1></td>
			<td height=5 bgColor=#205599><IMG height=1 src="revista/punto.gif" width=1></td>
			<td height=5 bgColor=#205599><IMG height=1 src="revista/punto.gif" width=1></td>
			<td height=5 bgColor=#ECEEF9><IMG height=1 src="revista/punto.gif" width=1></td>
		</tr>
	</TABLE>
<SCRIPT language=JavaScript type=text/JavaScript> document.write("</div>") </SCRIPT>

<SCRIPT language=JavaScript type=text/JavaScript>
		posicioH=(ample-787)/2;
		document.write("<div id='PORTADA' style='position:absolute; left:"+posicioH+"px; top:173px; width:220px; height:1px; z-index:4; visibility: visible;'>")
</SCRIPT>
<?php
$link = mysql_pconnect('','pame','pame');
mysql_select_db("basepame", $link);
echo "<form action='revista.php' method='post' name='form'> \n";	
	echo "<table width='765' border='0' cellspacing='0'> \n";
	  echo "<tr> \n";
		echo "<td width='14' height=10' bgColor='#205599'><IMG height='1' src='revista/punto.gif' width='1'></td> \n";
		echo "<td width='4' height='10' bgColor='#205599'><IMG height='1' src='revista/punto.gif' width='1'></td> \n";
		echo "<td width='550' height='10' bgColor='#205599'><IMG height='1' src='revista/punto.gif' width='1'></td> \n";
		echo "<td width='3' height='10' bgColor='#205599'><IMG height='1' src='revista/punto.gif' width='1'></td> \n";
		echo "<td width='7' height=10' bgColor='#205599'><IMG height='1' src='revista/punto.gif' width='1'></td> \n";
		echo "<td width='175' height='10' bgColor='#ECEEF9'><IMG height='1' src='revista/punto.gif' width='1'></td> \n";
	  echo "</tr> \n";
	  
	  echo "<tr> \n";
		echo "<td bgColor='#205599' height='5'><IMG height='1' src='revista/punto.gif' width='1'></td> \n";
		echo "<td bgColor='#CCCCCC' colspan='2'> \n";
		  	echo "<TABLE cellSpacing='0' cellPadding='0' width='100%' border='0' class='noticia' > \n";
						//Agenda
						if ($_SESSION['cargo']=="coordinador informàtica" OR $_SESSION['cargo']=="director revista"){
							$result = mysql_query("SELECT id, titulo FROM articulorevista ORDER BY fecha2 desc", $link);
							if (mysql_num_rows($result)!=0){
								echo "<tr> \n";
									echo "<td width='2%' bgColor='#FFFFFF'>  \n";
									echo "<td bgColor='#FFFFFF'><div align='right'>Agenda<select name='agendap' onChange='form.submit()'> \n";
										echo "<option value=''> </option> \n";
										while ($row = mysql_fetch_row($result)){
											echo "<option value='".$row[0]."'>".$row[1]."</option> \n";
										}
										echo "</select></div></td> \n";
									echo "<td width='2%' bgColor='#FFFFFF'>  \n";
								echo "</tr> \n";
							}
						}
						//Noticias de portada 
						if ($_SESSION['cargo']=="coordinador informàtica" OR $_SESSION['cargo']=="director revista"){
							$result = mysql_query("SELECT id, titulo FROM articulorevista ORDER BY fecha2 desc", $link);
							if (mysql_num_rows($result)!=0){
								echo "<tr> \n";
									echo "<td width='2%' bgColor='#FFFFFF'>  \n";
									echo "<td bgColor='#FFFFFF'><div align='right'>Portada<select name='portadaf' onChange='form.submit()'> \n";
										echo "<option value=''> </option> \n";
										while ($row = mysql_fetch_row($result)){
											echo "<option value='".$row[0]."'>".$row[1]."</option> \n";
										}
										echo "</select></div></td> \n";
									echo "<td width='2%' bgColor='#FFFFFF'>  \n";
								echo "</tr> \n";
							}
						}
						$result2 = mysql_query("SELECT * FROM articulorevista WHERE orden='portadaf' ORDER BY fecha2 desc", $link);
						if (mysql_num_rows($result2)!=0){
							while ($row2 = mysql_fetch_row($result2)){
								echo "<tr> \n";
									echo "<td width='2%' bgColor='#FFFFFF'>  \n";
									echo "<td bgColor='#FFFFFF' height='15'> </td> \n";
									echo "<td width='2%' bgColor='#FFFFFF'>  \n";
								echo "</tr> \n";
								echo "<tr> \n";
									echo "<td width='2%' bgColor='#FFFFFF'>  \n";
									if ($_SESSION['cargo']=="coordinador informàtica" OR $_SESSION['cargo']=="director revista"){
										echo "<td bgColor='#FFFFFF'><a href='renoticia.php?referencia=$row2[11]&fondocolor=$row2[9]'>$row2[5]</a><a href='revista.php?id=$row2[0]&treure=si'><font color='#999999' size='-1'> treure</font></a></td> \n";
									}else { echo "<td bgColor='#FFFFFF'><a href='renoticia.php?referencia=$row2[11]&fondocolor=$row2[9]'>$row2[5]</a></td> \n"; }
									echo "<td width='2%' bgColor='#FFFFFF'>  \n";
								echo "</tr> \n";
								echo "<tr> \n";
									echo "<td width='2%' bgColor='#FFFFFF'> </td> \n";
									$texto=substr($row2[6],0,350);
									echo "<td bgColor='#FFFFFF'><font color='#000000'>$texto... </font><br><br> \n";
									echo "<div align='left'><font color='#999999'>$row2[2]<br>$row2[1]<br>$row2[7]: $row2[10]</font></div></td> \n";
									echo "<td width='2%' bgColor='#FFFFFF'> </td> \n";
								echo "</tr> \n";
							}
						}	
					echo "<tr> \n";
						echo "<td width='2%' bgColor='#FFFFFF'>  \n";
						echo "<td bgColor='#FFFFFF' height='15'> </td> \n";
						echo "<td width='2%' bgColor='#FFFFFF'>  \n";
					echo "</tr> \n";							
			echo "</TABLE> \n";
		echo "</td> \n";
    	echo "<td bgColor='#ECEEF9' height='5'><IMG height='1' src='revista/punto.gif' width='1'></td> \n";
		echo "<td bgColor='#205599'><IMG height='1' src='revista/punto.gif' width='1'></td> \n";
		echo "<td bgColor='#ECEEF9' height='5'><IMG height='1' src='revista/punto.gif' width='1'></td> \n";
  	echo "</tr> \n";
    echo "<tr> \n";
		echo "<td height='5' bgColor='#205599'><IMG height=1 src='revista/punto.gif' width='1'></td> \n";
		echo "<td height='5' bgColor='#205599'><IMG height=1 src='revista/punto.gif' width='1'></td> \n";
		echo "<td height='5' bgColor='#ECEEF9'><IMG height=1 src='revista/punto.gif' width='1'></td> \n";
		echo "<td height='5' bgColor='#ECEEF9'><IMG height=1 src='revista/punto.gif' width='1'></td> \n";
		echo "<td bgColor='#205599'><IMG height='1' src='revista/punto.gif' width='1'></td> \n";
		echo "<td bgColor='#ECEEF9' height='5'><IMG height=1 src='revista/punto.gif' width='1'></td> \n";
  	echo "</tr> \n";
    echo "<tr> \n";
		echo "<td height='15' bgColor='#205599'><IMG height='1' src='revista/punto.gif' width='1'></td> \n";
		echo "<td height='15' bgColor='#205599'><IMG height='1' src='revista/punto.gif' width='1'></td> \n";
		echo "<td height='15' bgColor='#205599'><IMG height='1' src='revista/punto.gif' width='1'></td> \n";
		echo "<td bgColor='#205599' height='15'><IMG height='1' src='revista/punto.gif' width='1'></td> \n";
		echo "<td bgColor='#205599'><IMG height='1' src='revista/punto.gif' width='1'></td> \n";
		echo "<td bgColor='#ECEEF9' height='15'><IMG height='1' src='revista/punto.gif' width='1'></td> \n";
  	echo "</tr> \n";
echo "</table> \n";
echo "<table width='765' border='0' cellspacing='0' cellpadding='10'> \n";
  	echo "<tr> \n";
		echo "<td width='200' height='20'><IMG height='1' src='revista/punto.gif' width='1'></td> \n";
		echo "<td width='300' height='20' bgColor='#ECEEF9'><div align='center'><IMG height='1' src='revista/punto.gif' width='1'>REVISTA DIGITAL <a href='mailto:revista@terra.es'>Contacti amb nosaltres</a> </div></td> \n";
		echo "<td width='265' height='20' bgColor='#ECEEF9'><IMG height=1 src='revista/punto.gif' width='1'></td> \n";
	echo "</tr> \n";
echo "</table> \n";
echo "</form> \n";
?>
<SCRIPT language=JavaScript type=text/JavaScript> document.write("</div>") </SCRIPT>

<SCRIPT language=JavaScript type=text/JavaScript>
		posicioH=(ample-787)/2+600;
		document.write("<div id='PORTADACORTA' style='position:absolute; left:"+posicioH+"px; top:175px; width:210px; height:1px; z-index:4; visibility: visible;'>")
</SCRIPT>
<table width="160" border="0" cellspacing="0">
  <tr>
    <td>
		<table width="100%" border="0" cellspacing="5">
  			<tr>
    			<td bgcolor="#CCCCCC">
					<table width="100%" border="0" cellspacing="0"  cellpadding="0">
						<?php
									echo "<tr> \n";
										echo "<td colspan='3' bgColor='#FFFFFF'> </td> \n";
									echo "</tr> \n";
							//Agenda
							$result6 = mysql_query("SELECT * FROM articulorevista WHERE orden='agenda' ORDER BY fecha2 desc", $link);
							if (mysql_num_rows($result6)!=0){
									echo "<tr> \n";
										echo "<td width='2%' bgColor='#FFFFFF'> </td> \n";
										echo "<td colspan='2' bgColor='#FFFFFF'><font color='#CC3300'>Agenda</font></td> \n";
									echo "</tr> \n";
									echo "<tr> \n";
										echo "<td height='1' width='2%' bgColor='#FFFFFF'><IMG height='1' width='1' src='revista/puntog.gif' ></td> \n";
										echo "<td height='1' bgColor='#CC3300'><IMG height='1' width='1' src='revista/puntog.gif' ></td> \n";
										echo "<td height='1' width='2%' bgColor='#FFFFFF'><IMG height='1' width='1' src='revista/puntog.gif' ></td> \n";
									echo "</tr> \n";
								while ($row6 = mysql_fetch_row($result6)){
									echo "<tr> \n";
										echo "<td width='2%' bgColor='#FFFFFF'> </td> \n";
										if ($_SESSION['cargo']=="coordinador informàtica" OR $_SESSION['cargo']=="director revista"){
										echo "<td bgcolor='#FFFFFF'><a href='renoticia.php?referencia=$row6[11]&fondocolor=$row6[9]'><font size='-6'>$row6[5]</font></a><a href='revista.php?id=$row6[0]&treure=si'><font color='#999999' size='-8'> treure</font></a></td> \n";
										}else { echo "<td bgcolor='#FFFFFF'><a href='renoticia.php?referencia=$row6[11]&fondocolor=$row6[9]'><font size='-6'>$row6[5]</font></a></td> \n"; }
										echo "<td width='2%' bgColor='#FFFFFF'> </td> \n";
									echo "</tr> \n";
									echo "<tr> \n";
										echo "<td colspan='3' bgColor='#FFFFFF'> </td> \n";
									echo "</tr> \n";
								}
							}	
						?>										
					</table>
				</td>
  			</tr>
		</table>
	</td>
  </tr>
</table>

<SCRIPT language=JavaScript type=text/JavaScript> document.write("</div>") </SCRIPT>

</body>
</html>