$valor){ $sql = 'SELECT * FROM vistos WHERE vistos.evento = "'.mysql_real_escape_string($clave).'"'; $sql .= ' AND vistos.user = "'.mysql_real_escape_string($user).'"'; $numero = mysql_query($sql) or die(mysql_error()); if (!($row = mysql_fetch_array($numero))){ $mostrar['rojo'][$valor] = 1; $mostrar['verde'][$valor] = 0; } $sql = 'SELECT * FROM vistos WHERE vistos.evento = "'.mysql_real_escape_string($clave).'"'; $sql .= ' AND vistos.user = "'.mysql_real_escape_string($user).'"'; $sql .= ' AND vistos.modificado = 1'; $numero = mysql_query($sql) or die(mysql_error()); while($row = mysql_fetch_array($numero)){ $mostrar['azul'][$valor] = 1; $mostrar['verde'][$valor] = 0; } } $DiaSemanaEmpiezaMes = date(w,mktime(0,0,0,$mes,1,$ano)); $DiaSemanaEmpiezaMes--; if($DiaSemanaEmpiezaMes<0)$DiaSemanaEmpiezaMes = 6; $DiaSemanaTerminaMes = date(w,mktime(0,0,0,$mes,$TotalDiasMes,$ano)); $DiaSemanaTerminaMes--; if($DiaSemanaTerminaMes<0)$DiaSemanaTerminaMes = 6; $EmpiezaMesCalOffset = $DiaSemanaEmpiezaMes; $TerminaMesCalOffset = 6 - $DiaSemanaTerminaMes; $TotalDeCeldas = $TotalDiasMes + $DiaSemanaEmpiezaMes + $TerminaMesCalOffset; if($mes == 1){ $MesAnterior = 12; $MesSiguiente = $mes + 1; $AnoAnterior = $ano - 1; $AnoSiguiente = $ano; }elseif($mes == 12){ $MesAnterior = $mes - 1; $MesSiguiente = 1; $AnoAnterior = $ano; $AnoSiguiente = $ano + 1; }else{ $MesAnterior = $mes - 1; $MesSiguiente = $mes + 1; $AnoAnterior = $ano; $AnoSiguiente = $ano; } $AnoAnteriorAno = $ano - 1; $AnoSiguienteAno = $ano + 1; print ""; print ""; print ""; print ""; print ""; foreach($DIA_SEMANA AS $valor){ print ""; } print ""; for($a=1;$a <= $TotalDeCeldas;$a++){ if(!$b) $b = 0; if($b == 7) $b = 0; if($b == 0) print ""; if(!$c) $c = 1; if($a > $EmpiezaMesCalOffset AND $c <= $TotalDiasMes){ if($c == date(d) && $mes == date(m) && $ano == date(Y)){ print ""; }elseif($b == 5 OR $b == 6){ print ""; }else{ print ""; } $c++; }else{ print ""; } if($b == 6) print ''; $b++; } print "
"; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print "
año-mes-" . $MESES[$mes] . "-" . $ano . "mes+año+
"; print "
$valor
$c
"; if($mostrar['rojo'][$c]=="1")print ''; if($mostrar['azul'][$c]=="1")print ''; if($mostrar['verde'][$c]=="1")print ''; print "
$c
"; if($mostrar['rojo'][$c]=="1")print ''; if($mostrar['azul'][$c]=="1")print ''; if($mostrar['verde'][$c]=="1")print ''; print "
$c
"; if($mostrar['rojo'][$c]=="1")print ''; if($mostrar['azul'][$c]=="1")print ''; if($mostrar['verde'][$c]=="1")print ''; print "		 
"; print '
'; print ''; print ''; print '
'; ?>