Salut,
Sur ce site j'ai trouvé un agenda d'événements que j'ai installé sur mon site web. Il fonctionnait trés bien sous phpMyAdmin 2.6.2-Debian-3sarge1 mais depuis que mon hebergeur est passé sous phpMyAdmin 2.6.2-Debian-3sarge3, mon agenda ne fonctionne plus correctement.
En effet, je ne peux plus changer de mois ni d'année. De plus, je n'arrive plus à afficher les événements en cliquant sur les jours qui correspondent à un événement.
Pour voir le pb: http://uschartronshockey.nix3.fr/agenda_hockey.php/
Voici le code de la page:
----------------------------------------------------------
<style type="text/css">
<!--
body {
background-image: url();
background-repeat: no-repeat;
margin-top: 0%;
margin-left: 0px;
margin-right: 0px;
background-color: #000000;
}
.Style1 {
color: #FFFFFF;
font-weight: bold;
}
.Style3 {color: #FFFFFF}
-->
</style><DIV class=popperlink id=topdecklink></DIV>
<table width="267" height="233" border="0" align="left">
<tr>
<td width="261" height="229"><div class=popperlink id=div></div>
<table width="275" height="208" border="0" align="left">
<tr>
<td width="26" height="21"><div class=popperlink id=div2></div> </td>
<td width="225"> </td>
</tr>
<tr>
<td height="176"><div class=popperlink id=div3></div> </td>
<td><table width="225" border="0" bgcolor="#FF00CC">
<tr>
<td><div class=popperlink id=div4></div>
<style type=text/css>
.popperlink {
Z-INDEX: 2; VISIBILITY: hidden; WIDTH: 200px; POSITION: absolute
}
</style>
<?
$db_host = "localhost"; // Nom du serveur sql
$db_login = "Monlogin"; // Login de connexion a la base
$db_pass = "MonMotDePasse"; // Pass de connexion a la base
$bdd = "MaBDD"; // Nom de la base sql
$daybgcolor="FFFFFF" ; // Couleur des jours de la semaine
$dombgcolor="228B22" ; // Couleur du jour sélectionné
$dayholcolor="FF00CC" ; // Couleur des WE
// Mois
$month[0] = "Janvier" ;
$month[1] = "Février" ;
$month[2] = "Mars" ;
$month[3] = "Avril" ;
$month[4] = "Mai" ;
$month[5] = "Juin" ;
$month[6] = "Juillet" ;
$month[7] = "Août" ;
$month[8] = "Septembre" ;
$month[9] = "Octobre" ;
$month[10] = "Novembre" ;
$month[11] = "Décembre" ;
// Première lettre des jours de la semaine
$day[0] = "D" ;
$day[1] = "L" ;
$day[2] = "M" ;
$day[3] = "M" ;
$day[4] = "J" ;
$day[5] = "V" ;
$day[6] = "S" ;
$error01 = "Erreur : date invalide"
?>
<script language=javascript>
function plus_atq(){
if (eval(document.maj_combat.def.value)>1){
document.maj_combat.def.value--;
document.maj_combat.atq.value++;
}
}
function plus_def(){
if (eval(document.maj_combat.atq.value)>1){
document.maj_combat.def.value++;
document.maj_combat.atq.value--;
}
}
skn = document.getElementById("topdecklink").style;
if(navigator.appName.substring(0,3) == "Net")
document.captureEvents(Event.MOUSEMOVE);
document.onmousemove = get_mouse;
function pop_info(mat)
{
poplink('<table width=250 bgcolor=white border=5 bordercolor="'+info_pj[mat][1]+'" cellpadding=3 align=center><tr><td colspan=3 align=middle bordercolor=white><b>Infos</b> (mat :'+ mat +')</td></tr><tr><td bordercolor=white>Nom</td><td bordercolor=white>'+info_pj[mat][0]+'</td></tr><tr><td bordercolor=white>Race</td><td bordercolor=white>'+info_pj[mat][2]+'</td></tr><tr><td bordercolor=white>Blason</td><td bordercolor=white>'+info_pj[mat][3]+'</td></tr><tr><td align=center colspan=2 bordercolor=white><b>Message</b></td></tr><tr><td colspan=2 bordercolor=palegoldenrod bgcolor=palegoldenrod>'+info_pj[mat][4]+'</td></tr></table>');
}
function poplink(msg)
{
var content = msg;
document.getElementById("topdecklink").innerHTML = content;
skn.visibility = "visible";
}
function get_mouse(e)
{
var x = (navigator.appName.substring(0,3) == "Net") ? e.pageX : event.x+document.body.scrollLeft;
var y = (navigator.appName.substring(0,3) == "Net") ? e.pageY : event.y+document.body.scrollTop;
skn.left = x+20;
skn.top = y-50;
}
function killlink()
{
poplink('');
skn.visibility = "hidden";
}
</script>
<script language='JavaScript'>
function modifier (jour)
{
window.location.href = "agenda_hockey1.php?form=<?echo $form;?>&elem=<?echo $elem;?>&mois=" + document.forms["Agenda"].elements['month'].options[document.forms["Agenda"].elements['month'].selectedIndex].value + "&jour=" + jour +"&annee=" + document.forms["Agenda"].elements['year'].options[document.forms["Agenda"].elements['year'].selectedIndex].value
}
<?
if (!isset($jour))
$jour = date("j") ;
if (!isset($mois))
$mois = date("m") ;
if (!isset($annee))
$annee = date("Y") ;
$nbjmonth[0] = 31 ;
$nbjmonth[1] = ($annee%4==0?($annee%100==0?($annee%400?29:28):29):28) ;
$nbjmonth[2] = 31 ;
$nbjmonth[3] = 30 ;
$nbjmonth[4] = 31 ;
$nbjmonth[5] = 30 ;
$nbjmonth[6] = 31;
$nbjmonth[7] = 31 ;
$nbjmonth[8] = 30 ;
$nbjmonth[9] = 31 ;
$nbjmonth[10] = 30 ;
$nbjmonth[11] = 31 ;
if(!checkdate($mois,$jour,$annee))
{
echo "alert('$error01')\n" ;
$jour = date("j") ;
$mois = date("m") ;
$annee = date("Y") ;
}
$connexion = mysql_connect("$db_host","$db_login","$db_pass");
$db = mysql_select_db("$bdd", $connexion);
$query = "select * from tge_agenda where jour=$jour and mois=$mois and annee=$annee";
$result = mysql_db_query("$bdd", $query);
while ($r = mysql_fetch_array($result))
{
$description = $r["description"];
}
// Calcul du jour julien et du numéro du jour
$HR = 0;
$GGG = 1;
if( $annee < 1582 ) $GGG = 0;
if( $annee <= 1582 && $mois < 10 ) $GGG = 0;
if( $annee <= 1582 && $mois == 10 && 1 < 5 ) $GGG = 0;
$JD = -1 * floor(7 * (floor(($mois + 9) / 12) + $annee) / 4);
$S = 1;
if (($mois - 9)<0) $S=-1;
$A = abs($mois - 9);
$J1 = floor($mois + $S * floor($A / 7));
$J1 = -1 * floor((floor($J1 / 100) + 1) * 3 / 4);
$JD = $JD + floor(275 * $mois / 9) + 1 + ($GGG * $J1);
$JD = $JD + 1721027 + 2 * $GGG + 367 * $annee - 0.5;
/*$tmp = ((int)(($mois>2?$annee:$annee-1)/100)) ;
$jj = (int)((((int)(365.25*($mois>2?$annee:$annee-1))) + ((int)(30.6001*($mois>2?$mois+1:$mois+13))) + $jour + 1720994.5 + ($annee > 1582 && $mois > 10 && $jour > 15?2-$tmp+((int)($tmp/4)):0))) ;
$jj = (int)(($jj) % 7)*/
$jj = (($JD+.5)%7) ;
?>
</script>
<script language=javascript> var info_pj=new Array();info_pj["47909"]=new Array("Yoann","red","Démon","","je rejoins le red squadron pro-humain je connais amok 47788 en defense negative ");info_pj["50332"]=new Array("Dark Vador","red","Démon","","Anges, ne m\'attaquez point je suis avec PinChU");info_pj["49704"]=new Array("Darksid_1","red","Démon","","Un bon bon est un bon mort! Amen");info_pj["39161"]=new Array("Devender","red","Démon","MAFIA","[Chef Infanterie Scout]abusé en un tour!!fait chier!");info_pj["27902"]=new Array("Manouche","red","Démon","","Je reviens de vacances !!");info_pj["43857"]=new Array("Elric De Melniboné","red","Démon","","[Hell\'s Angel](*)[Born to Pete Your Tronche!]Vous n\'auriez pas vu StormBringer par hazard??? VRRRRRRRRRRRR VRRRRRRRRRRRR *fait rugir sa Harley-Davidson*");info_pj["47061"]=new Array("Darkangelus","red","Démon","","Salut les gars, je suis nouveau !");info_pj["48657"]=new Array("FurFurr","red","Démon","","Hardcore Attitude !");info_pj["24328"]=new Array("DKTan","red","Démon","","");info_pj["36437"]=new Array("Shadow","red","Démon","","[Scout Demoniaque]");</script>
<?
echo "<body onUnLoad=''>\n" ;
?>
<div align="center" bgcolor="#FF00CC">
<table width="199" height="50" border="0" cellpadding="0" cellspacing="0" >
<tr>
<td width="20"> </td>
<td width="169" valign="middle" class="categorie_title"><div align="center" class="Style1">Agenda des matchs et des événements du club de Nationnal 3 </div></td>
<td width="10"> </td>
</tr>
</table>
<?
echo "<center><form name='Agenda'>\n" ;
echo "<table width='170' cellspacing='0' cellspading='0' border='0'><tr>\n" ;
// Affichage de la sélection du mois et de l'année
echo "<td><select name='month' onChange=\"modifier($jour)\">\n" ;
for ($i=0;$i<12;$i++)
{
echo "<option value='".($i+1)."'".($mois==($i+1)?" selected":"").">".$month[$i]."</option>\n" ;
}
echo "</select></td>\n" ;
echo "<td align='right'><select name='year' onChange=\"modifier($jour)\">\n" ;
$y = date("Y") ;
for ($i=$y-10;$i<$y+10;$i++)
{
echo "<option value='$i'".($annee==($i)?" selected":"").">$i</option>\n" ;
}
echo "</select></td></tr><tr><td colspan='2'> </td></tr>\n" ;
echo "<tr><td colspan='2'><table width='100%' cellspacing='0' cellspading='0' border='0'>\n" ;
echo "</form>\n" ;
// D L M M J V S
for($i=0;$i<7;$i++)
{
echo "<td width='14%'><font id='general'>".$day[$i]."</font></td>" ;
}
echo "</tr>\n<tr><td colspan='7'> </td></tr>\n<tr>\n" ;
$j = $jj ;//date ("w", mktime (0,0,0,$mois,1,$annee)) ;
$dom = 1 ;
for ($i=0;$i<7;$i++)
{
if ($j<=$i)
{
echo "<td".($dom==$jour?" bgcolor='#$dombgcolor'":"").">";
$connexion = mysql_connect("$db_host","$db_login","$db_pass");
$db = mysql_select_db("$bdd", $connexion);
$query = "select * from tge_agenda where jour=$dom and mois=$mois and annee=$annee";
$result = mysql_db_query("$bdd", $query);
if (!$result) {
$nom = "";
}
else {
while ($r = mysql_fetch_array($result))
{
$nom = $r["nom"];
$jourt = $r["jour"];
?>
</div>
<a href='javascript:modifier(<? echo $dom ?>)' onmouseover="poplink('<b> <? echo $nom ?></b>');" onmouseout=killlink()>
<?
}
}
echo "<font id='general' ";
$query = "select * from tge_agenda where mois=$mois and annee=$annee";
$result = mysql_db_query("$bdd", $query);
while ($r = mysql_fetch_array($result))
{
$jourc = $r["jour"];
if ($jourc == $dom) {
echo "color='#CCFF00'";
}
}
echo ">".$dom++."</font></a></td>\n" ;
}
else
echo "<td> </td>\n" ;
}
echo "</tr>\n" ;
// Le reste
for ($i=0;$i<5;$i++)
{
echo "<tr>\n" ;
for ($j=0;$j<7;$j++)
{
$j_inac = ($j==0 || $j==6) ;
if($dom < $nbjmonth[($mois-1)]) {
echo "<td".($dom==$jour?" bgcolor='#$dombgcolor'":($j_inac ?" bgcolor='#$dayholcolor'":"")).">";
$query = "select * from tge_agenda where jour=$dom and mois=$mois and annee=$annee";
$result = mysql_db_query("$bdd", $query);
if (!$result) {
$nom = "";
}
else {
while ($r = mysql_fetch_array($result))
{
$nom = $r["nom"];
$jourt = $r["jour"];
?>
</a><a href='javascript:modifier(<? echo $dom ?>)' onmouseover="poplink('<b> <? echo $nom ?></b>');" onmouseout=killlink()>
<?
}
}
echo "<font id='general' ";
$query = "select * from tge_agenda where mois=$mois and annee=$annee";
$result = mysql_db_query("$bdd", $query);
while ($r = mysql_fetch_array($result))
{
$jourc = $r["jour"];
if ($jourc == $dom) {
echo "color='#CCFF00'";
} }
echo ">".$dom++."</font></a></td>\n" ; }
else if (checkdate($mois,$dom,$annee)) {
echo "<td".($dom==$jour?" bgcolor='#$dombgcolor'":($j_inac ?" bgcolor='#$dayholcolor'":"")).">";
$query = "select * from tge_agenda where jour=$dom and mois=$mois and annee=$annee";
$result = mysql_db_query("$bdd", $query);
if (!$result) {
$nom = "";
}
else {
while ($r = mysql_fetch_array($result))
{
$nom = $r["nom"];
$jourt = $r["jour"];
?>
</a><a href='javascript:modifier(<? echo $dom ?>)' onmouseover="poplink('<b> <? echo $nom ?></b>');" onmouseout=killlink()>
<?
}
}
echo "<font id='general' ";
$query = "select * from tge_agenda where mois=$mois and annee=$annee";
$result = mysql_db_query("$bdd", $query);
while ($r = mysql_fetch_array($result))
{
$jourc = $r["jour"];
if ($jourc == $dom) {
echo "color='#CCFF00'";
} }
echo ">".$dom++."</font></a></td>\n" ; }
else
echo "<td> </td>\n" ;
}
echo "</tr>\n" ;
}
echo "\n</tr></table>\n" ;
echo "</td></tr></table>" ;
echo "</form>$description</center>" ;
echo "</body>\n" ;
?>
<div class=popperlink id=div4></div>
<script language=javascript>
</script>
</a></td>
</tr>
</table></td>
</tr>
</table>
</td>
</tr>
</table>
<span class="Style3"></span>
<SCRIPT language=javascript>function plus_atq(){
if (eval(document.maj_combat.def.value)>1){
document.maj_combat.def.value--;
document.maj_combat.atq.value++;
}
}
function plus_def(){
if (eval(document.maj_combat.atq.value)>1){
document.maj_combat.def.value++;
document.maj_combat.atq.value--;
}
}
skn = document.getElementById("topdecklink").style;
if(navigator.appName.substring(0,3) == "Net")
document.captureEvents(Event.MOUSEMOVE);
document.onmousemove = get_mouse;
function pop_info(mat)
{
poplink('<table width=250 bgcolor=white border=5 bordercolor="'+info_pj[mat][1]+'" cellpadding=3 align=center><tr><td colspan=3 align=middle bordercolor=black><b>Infos</b> (mat :'+ mat +')</td></tr><tr><td bordercolor=white>Nom</td><td bordercolor=white>'+info_pj[mat][0]+'</td></tr><tr><td bordercolor=white>Race</td><td bordercolor=white>'+info_pj[mat][2]+'</td></tr><tr><td bordercolor=white>Blason</td><td bordercolor=white>'+info_pj[mat][3]+'</td></tr><tr><td align=center colspan=2 bordercolor=white><b>Message</b></td></tr><tr><td colspan=2 bordercolor=palegoldenrod bgcolor=palegoldenrod>'+info_pj[mat][4]+'</td></tr></table>');
}
function poplink(msg)
{
var content = msg;
document.getElementById("topdecklink").innerHTML = content;
skn.visibility = "visible";
}
function get_mouse(e)
{
var x = (navigator.appName.substring(0,3) == "Net") ? e.pageX : event.x+document.body.scrollLeft;
var y = (navigator.appName.substring(0,3) == "Net") ? e.pageY : event.y+document.body.scrollTop;
skn.left = x+0;
skn.top = y-10;
}
function killlink()
{
poplink('');
skn.visibility = "hidden";
}
</SCRIPT>
---------------------------------------------------------
Merci de m'avoir lu jusqu'ici.
Si quelqu'un pouvait m'aider ca m'enléverai une grosse épine du pied!!
Merci.
Grominet