CODI

<? include ("seguridad.php"); ?>
<? include ("cabecera.inc"); ?>
<? include ("intranet.inc"); ?>
<script language="JavaScript">
	function openWindow(){
		url="personalcodi.htm";
		windowprops ="top=30,left=30,toolbar=no,location=no,status=no, menubar=no,scrollbars=no, resizable=no,width=660 ,height=300";
		window.open(url,"",windowprops);
	}
</script>
<div id="Layer2" style="position:absolute; width:32px; height:19px; z-index:205; left: 0px; top: 90px;">
	<a href="#" onClick='openWindow()' title="Codi de la pàgina"><img src="imagenes/tachuela.jpg" width="40" height="44" border="0"></a>
</div>
<div id="titulos" style="position:absolute; left:48px; top:162px; width:566px; height:30px; z-index:9;" class="opaco"> 
  <?php 
	$usuario=$_SESSION['usuario'];
	echo "<table width='100%' border='0' cellspacing='0'> \n";
		echo "<tr> \n";
			echo "<td colspan='5'><font size='+1'>".$usuario." - <font color='#CC0000'>$opersonal</font></font> </td> \n";
		echo "</tr> \n";
		echo "<tr bgcolor='#F7F7F7'> \n";
				echo "<td width='33%' > </td> \n";
				echo "<td width='18%' ><a href='personal.php?opersonal=dades'>Dades personals</a></td> \n";
				echo "<td width='12%' ><a href='personal.php?opersonal=missatges'>Missatges</a></td> \n";
		echo "</tr> \n";
	echo "</table> \n";
	?>
</div>

<div id="mensajes" style="position:absolute; width:567px; height:80px; z-index:2; left:48px; top:212px;"> 
 
  <?php
		switch ($opersonal){
			case"dades":
			$link=mysql_pconnect('','pame','pame');
			if (mysql_select_db("basepame",$link)){
				if ($eliminarfoto!=''){
					$eliminarfoto= explode('-',$eliminarfoto);
					$sql="UPDATE usuarios SET foto='' WHERE usuario='$usuario'";
					$result=mysql_query($sql);
					@unlink('imagenes/fotos/'.$eliminarfoto[1]);	
				}
				if ($eliminarvideo!=''){
					$eliminarvideo= explode('-',$eliminarvideo);
					$sql="UPDATE usuarios SET nomvideo='' WHERE usuario='$usuario'";
					$result=mysql_query($sql);
					@unlink('imagenes/videos/'.$eliminarvideo[1]);
				}
				if ($foto!=''){
					if ($cambiofoto!=''){
						@unlink('imagenes/fotos/'.$cambiofoto);
					}
					$fotonombre=$_FILES['foto']['name'];
					$upfile='imagenes/fotos/'.$fotonombre;
					move_uploaded_file($foto,$upfile);
					$sql="UPDATE usuarios SET foto='$fotonombre' WHERE usuario='$usuario'";
					$result=mysql_query($sql);	
				}
				if ($video!=''){
					if ($cambiovideo!=''){
						@unlink('imagenes/videos/'.$cambiovideo);
					}
					$videonombre=$_FILES['video']['name'];
					$upfile='imagenes/videos/'.$videonombre;
					move_uploaded_file($video,$upfile);
					$sql="UPDATE usuarios SET nomvideo='$videonombre' WHERE usuario='$usuario'";
					$result=mysql_query($sql);	
				}
				if ($canvinova!=''){
					$sql="SELECT clave FROM usuarios WHERE usuario='$usuario'";
					$result=mysql_query($sql,$link);
					$row=mysql_fetch_row($result);					
					if ($canviantiga==$row[0]){
						$sql="UPDATE usuarios SET clave='$canvinova' WHERE usuario='$usuario'";
						$result=mysql_query($sql);
						echo "<script language='JavaScript' type='text/javascript'> \n";
							echo "alert('SI'); \n";
						echo "</script> \n";
					} else {
						echo "<script language='JavaScript' type='text/javascript'> \n";
							echo "alert('NO'); \n";
						echo "</script> \n";							
					}
				}
				$sql="SELECT * FROM usuarios WHERE usuario='$usuario'";
				$result=mysql_query($sql,$link);
				$row=mysql_fetch_row($result);
				$extension= explode('.',$row[6]);
				if ($row[5]!=''){
					echo "Foto -<img src='imagenes/fotos/".$row[5]."' width='100' height='100' border='0'>\n";
					$fototexto=$row[5];
				}
				if ($row[6]!=''){
					$videotexto=$row[6];
					echo " Vídeo -\n";
					switch ($extension[1]){
						case"avi":
							echo "<OBJECT ID='MediaPlayer' WIDTH=100 HEIGHT=146 classid='CLSID:22D6F312-B0F6-11D0-94AB-0080C74C7E95' codebase='http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=6,4,7,1112' type='application/x-oleobject' > \n";
								echo "<PARAM NAME='FileName' VALUE='imagenes/videos/".$row[6]."'> \n";
								echo "<PARAM NAME='ShowControls' VALUE='1'> \n";
								echo "<PARAM NAME='Autostart' VALUE='false'> \n";
								echo "<Embed type='application/x-mplayer2' pluginspage='http://www.microsoft.com/windows/windowsmedia/download/' src='imagenes/videos/".$row[6]."' Name=MediaPlayer WIDTH=100 HEIGHT=146 > \n";
								echo "</EMBED> \n";
							echo "</OBJECT> \n";
						break;
						case"mov":
							echo "<object classid='clsid:02bf25d5-8c17-4b23-bc80-d3488abddc6b' width=100 height=146 codebase='http://www.apple.com/qtactivex/qtplugin.cab' border='0'> \n";
    							echo "<param name='src' value='imagenes/videos/".$row[6]."'> \n";
    							echo "<param name='autoplay' value='true'>  \n";
    							echo "<param name='controller' value='true'> \n";
    							echo "<embed src='imagenes/videos/".$row[6]."' width=100 height=146 controller='true' pluginspage='http://www.apple.com/quicktime/download/'> \n";
  							echo "</object> \n";
						break;
					}
				}
				echo "<table width='100%' border='0' cellspacing='0'> \n";
					echo "<tr> \n";
						echo "<td width='10%' > </td> \n";
						echo "<td width='12%' > </td> \n";
						echo "<td width='78%' > </td> \n";
					echo "</tr> \n";
					echo "<tr> \n";
						echo "<td>Foto/Vídeo</td> \n";
						echo "<td colspan='2' ><a href='#' onClick='hideLayer('contraw'); showLayer('fotow')'><font color='#FF6666' size='-2'>canviar</font></a></td> \n";
					echo "</tr> \n";								
					echo "<tr> \n";
						echo "<td>Usuari </td> \n";
						echo "<td colspan='2'>".$usuario."</td> \n";
					echo "</tr> \n";
					echo "<tr> \n";
						echo "<td>Nom </td> \n";
						echo "<td colspan='2'>".$row[1]."</td> \n";
					echo "</tr> \n";
					echo "<tr> \n";
						echo "<td>Àmbit </td> \n";
						echo "<td colspan='2'>".$row[7]."</td> \n";
					echo "</tr> \n";					
					echo "<tr> \n";
						echo "<td>Contrasenya </td> \n";
						echo "<td>******</td> \n";
						echo "<td ><a href='#' onClick='hideLayer('fotow'); showLayer('contraw')'><font color='#FF6666' size='-2'>canviar</font></a></td> \n";
					echo "</tr> \n";					
				echo "</table> \n";
					echo "<div id='fotow' style='position:absolute; width:350px; height:70px; z-index:25; left: 225px; top:90px; visibility: hidden; background-color: #FAFFF0; layer-background-color: #FAFFF0; border: 1px none #000000;' class='menupr'; > \n";
						echo "<form name='canvifoto' method='post' enctype='multipart/form-data' action='personal.php'> \n";
							echo "<table width='100%' border='0' cellspacing='5'> \n";
								echo "<tr> \n"; 
									echo "<td colspan='2'> </td> \n";	
									echo "<input name='opersonal' type='hidden' value='dades'>";
									echo "<input name='cambiofoto' type='hidden' value='$fototexto'>";
									echo "<input name='cambiovideo' type='hidden' value='$videotexto'>";
								echo "</tr> \n";
								echo "<tr> \n"; 
									echo "<td colspan='2'><div align='center'><u>Canvi de fotografia / vídeo</u></div></td> \n";	
								echo "</tr> \n";
								echo "<tr> \n"; 
									echo "<td colspan='2'> </td> \n";	
								echo "</tr> \n";
								echo "<tr> \n"; 
									echo "<td  width='18%'><strong>Fotografia</strong></td> \n";	
									echo "<td>format: jpg - tamany i pes 100x100px 2Kb</td> \n";
								echo "</tr> \n";
								echo "<tr> \n"; 
									echo "<td colspan='2'><input name='foto' type='file' size='50'></td> \n";
								echo "</tr> \n";
								if ($fototexto!=''){
									echo "<tr> \n"; 
										echo "<td colspan='2'><input name='eliminarfoto' type='submit' value='eliminar-$fototexto'></td> \n";									echo "</tr> \n";
									echo "</tr> \n";
								}
								echo "<tr> \n"; 
									echo "<td  width='18%'><strong>Vídeo</strong></td> \n";	
									echo "<td>format: mov ó avi - tamany i pes 100x75px màx.1990Kb</td> \n";
								echo "</tr> \n";
								echo "<tr> \n"; 
									echo "<td colspan='2'><input name='video' type='file' size='50'></td> \n";
								echo "</tr> \n";
								if ($videotexto!=''){
									echo "<tr> \n"; 
										echo "<td colspan='2'><input name='eliminarvideo' type='submit' value='eliminar-$videotexto'></td> \n";
									echo "</tr> \n";
								}
							echo "</table> \n";
							echo "<table width='100%' border='0' cellspacing='5'> \n";
								echo "<tr> \n"; 
									echo "<td><div align='center'><a href='#' onClick='hideLayer('fotow')'>cancelar</a></div></td> \n";
									echo "<td><div align='center'><a href='#' onClick='canvifoto.submit()'>aceptar</a></div></td> \n";
								echo "</tr> \n";								
							echo "</table> \n";
						echo "</form> \n";
					echo "</div> \n";
					echo "<div id='contraw' style='position:absolute; width:200px; height:70px; z-index:27; left: 275px; top:90px; visibility: hidden; background-color: #FAFFF0; layer-background-color: #FAFFF0; border: 1px none #000000;' class='menupr'; > \n";
						echo "<form name='canvi' method='post' action='personal.php'> \n";
							echo "<table width='100%' border='0' cellspacing='5'> \n";
								echo "<tr> \n"; 
									echo "<td colspan='2'> </td> \n";	
								echo "</tr> \n";
								echo "<tr> \n"; 
									echo "<td colspan='2'><div align='center'><u>Canvi de contrasenya</u></div></td> \n";	
								echo "</tr> \n";
								echo "<tr> \n"; 
									echo "<td colspan='2'> </td> \n";	
								echo "</tr> \n";
								echo "<tr> \n"; 
									echo "<td>contrasenya antiga</td> \n";	
									echo "<td><input name='canviantiga' type='text' size='6'></td> \n";
									echo "<input name='opersonal' type='hidden' value='dades'>";
								echo "</tr> \n";
								echo "<tr> \n"; 
									echo "<td>contrasenya nova</td> \n";	
									echo "<td><input name='canvinova' type='text' size='6'></td> \n";
								echo "</tr> \n";
								echo "<tr> \n"; 
									echo "<td><div align='center'><a href='#' onClick='hideLayer('contraw')'>cancelar</a></div></td> \n";
									echo "<td><a href='#' onClick='canvi.submit()'>aceptar</a></td> \n";
								echo "</tr> \n";								
							echo "</table> \n";
						echo "</form> \n";
					echo "</div> \n";					
				}
			break;
			default:
				$origen="personal.php";
				$_SESSION['mensaje'] ="inicio";
				include ("mlectura.php");
				 
		}
?>
<?php 
	include ("pie.inc"); 
?>