<? /* _______________________________________________________________________________ | Autor: Guilherme Buozzi Pachella ICQ: 127049217 e-mail: gui_pachela@uol.com.br| | Este script foi totalmente reestruturado por mim, s� peguei pronta a parte de | | montar o calend�rio, implementei as consultas no banco para ver os dias de | | festa, converti o idioma e coloquei em destaque o dia atual. | | FAVOR MANTER ESTES CR�DITOS | | | ALTERADO POR | joseaugustomoraes@hotmail.com |_______________________________________________________________________________ */ ?> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <? include "config.php"; $SQL="select * from calendario order by id desc"; $result = mysql_db_query($DB,$SQL,$link); $linha=mysql_num_rows($result); if (isset($show_month)) { if ($show_month==">") { if($month==12) { $month=1; $year++; } else { $month++; } } if ($show_month=="<") { if($month==1) { $month=12; $year--; } else { $month--; } } } if (isset($day)) { if ($day<="9"&ereg("(^[1-9]{1})",$day)) { $day="0".$day; } } if (isset($month)) { if ($month<="9"&ereg("(^[1-9]{1})",$month)) { $month="0".$month; } } if (!isset($year)) { $year=date("Y",mktime()); } if (!isset($month)) { $month=date("m",mktime()); } if (!isset($day)) { $day=date("d",mktime()); } $thisday="$year-$month-$day"; $day_name=array("Seg","Ter","Qua","Qui","Sex","S�b" ,"<font color=\"#FF0000\">Dom</font>"); $month_abbr=array("","Janeiro","Fevereiro","Mar�o","Abril","Maio","Junho","Julho","Agosto","Setembro","Outubro","Novembro","Dezembro"); $y=date("Y"); switch ($month) { case 1: $month_name = "Jan"; break; case 2: $month_name = "Fevereiro"; break; case 3: $month_name = "Mar�o"; break; case 4: $month_name = "Abril"; break; case 5: $month_name = "Maio"; break; case 6: $month_name = "Junho"; break; case 7: $month_name = "Julho"; break; case 8: $month_name = "Agosto"; break; case 9: $month_name = "Setembro"; break; case 10: $month_name = "Outubro"; break; case 11: $month_name = "Novembro"; break; case 12: $month_name = "Dezembro"; break; } if (empty($month)) { $month = date("m"); $year = date("Y"); } $next = mktime(0,0,0,$month + 1,1,$year); $nextano = date("Y",$next); $nextmonth = date("m",$next); $prev = mktime(0,0,0,$month - 1,1,$year); $prevano = date("Y",$prev); $prevmonth = date("m",$prev); ?> <link href="colegio.css" rel="stylesheet" type="text/css" /> <div align="center"> <table width="150" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF"> <tr> <td width="100"><div align="center"> <table width="100%" border="0" cellpadding="1" cellspacing="2"> <tr align="center"> <td colspan="7" align="center" class="ano"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="5"><a class="setas" href="calendario.php?month=<? echo $prevmonth; ?>&year=<? echo $prevano; ?>"><img src="img/seta.png" width="19" height="18" border="0" /></a></td> <td align="center" valign="top" background="img/setabg.png"><a class="setas" href="calendario.php?month=<? echo $prevmonth; ?>&year=<? echo $prevano; ?>"></a> <span class="mes"><? echo "$month_name $year";?></span> <a class="setas" href="calendario.php?month=<? echo $nextmonth; ?>&year=<? echo $nextano; ?>"></a></td> <td width="5"><a class="setas" href="calendario.php?month=<? echo $nextmonth; ?>&year=<? echo $nextano; ?>"><img src="img/seta2.png" width="19" height="18" border="0" /></a></td> </tr> </table></td> </tr> <tr class="dia" align="center"> <? for ($i=0;$i<7;$i++) { ?> <td width="39" align="center" bgcolor="#FFFFFF"><? echo "$day_name[$i]"; ?></td> <? } ?> </tr> <tr class="dia" align="center"> <? // DATA Q VEM ANTES --------------------------------------------- if (date("w",mktime(0,0,0,$month,1,$year))==0) { $start=7; } else { $start=date ("w",mktime(0,0,0,$month,1,$year)); } for($a=($start-2);$a>=0;$a--) { $d=date("t",mktime(0,0,0,$month,0,$year))-$a; ?> <td bgcolor="#EEEEEE" align="center"> <?=$d?> </td> <? } // DATAS ATUAIS --------------------------------------------- for($d=1;$d<=date("t",mktime(0,0,0,($month+1),0,$year));$d++) { global $linha; if($month==date("m") && $year==date("Y") && $d==date("d")) { $bg="bgcolor=\"#B0CCE4\""; $linkando=""; $fimlink=""; } else { $bg="bgcolor=\"#d4e3f1\""; $linkando=""; $fimlink=""; } for ($i=0;$i<$linha;$i++){ global $month,$year,$d; $dia_sql=mysql_result($result,$i,'dia'); $mes_sql=mysql_result($result,$i,'mes'); $ano_sql=mysql_result($result,$i,'ano'); $id_sql=mysql_result($result,$i,'id'); $ano = ltrim(rtrim($ano_sql)); $mes = ltrim(rtrim($mes_sql)); $dia = ltrim(rtrim($dia_sql)); $id_cod = ltrim(rtrim($id_sql)); if($d==$dia&$year==$ano&$month==$mes) { $bg="bgcolor=#ffa800"; $linkando="<a href=xxxxx.php?id_cod=$id_cod><font color=#ffffff>"; $fimlink="</font></a>"; } } ?> <td align="center" <?php echo $bg; ?>> <? echo $linkando; ?> <? echo $d; ?> <? echo $fimlink; ?> </td> <? // DATA Q VEM DEPOIS --------------------------------------------- if(date("w",mktime(0,0,0,$month,$d,$year))==0&date("t",mktime(0,0,0,($month+1),0,$year))>$d) { ?> </tr> <tr class="dia" align="center"> <? }} $da=$d+1; if(date("w",mktime(0,0,0,$month+1,1,$year))<>1) { $d=1; while(date("w",mktime(0,0,0,($month+1),$d,$year))<>1) { ?> <td bgcolor="#EEEEEE" align="center"> <?=$d?> </td> <? $d++; } } ?> </tr> </table> </div></td> </tr> <tr> <td><table width="100%" border="0" cellpadding="1" cellspacing="2"> <tr class="dia" align="center"> <td colspan="2" align="center" bgcolor="#eaeaea"><? $date = date("d / m / Y"); echo "Hoje é dia $date"; ?> </td> </tr> </table> <font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><?php for ($i=0;$i<$linha;$i++){ $dia_sql=mysql_result($result,$i,'dia'); $mes_sql=mysql_result($result,$i,'mes'); $ano_sql=mysql_result($result,$i,'ano'); if($mes_sql==date("m") && $ano_sql==date("Y")) { $dados_sql=mysql_result($result,$i,'dados'); echo "<b>:: $dia_sql"."/"."$mes_sql"."/"."$ano_sql"." :"."</b> $dados_sql<br>"; } } ?></font></td> </tr> </table> </div>