Problème message d'erreur "Warning: date()..."

par **sirakawa** » 27 févr. 2014, 09:03

C'est ma faute, etc
var_dump($missionStartTime);die(); sans quotes autour...

par **Lavazza** » 26 févr. 2014, 23:44

Bonsoir sirakawa, j'ai ajouté en suivant tes instructions la ligne "var_dump($missionStartTime);die();" Rien ne se passe en rafraîchissent ma page. Pardonne moi pour ma grande ignorance mais pourrais tu m'expliquer plus précisément

Amicalement

par **sirakawa** » 26 févr. 2014, 21:40

En gros
connexion
$mysqli = new mysqli("localhost", "user", "password", "database");
détails ici:
http://us2.php.net/manual/fr/mysqli.qui ... ctions.php

requetes ici:
http://us2.php.net/manual/fr/mysqli.qui ... ements.php

Le var_dump() est important pour savoir ce que php voit à cet endroit.

par **Lavazza** » 26 févr. 2014, 20:33

Merci a vous deux!!! J'ai retirer l'@ ligne 17

$result = @mysql_query("SELECT missionName, timeLeft, missionStartTime, rObjectivesLeft,
                               rTargetObjectivesLeft, bObjectivesLeft, bTargetObjectivesLeft,
                               rPilotsPlanesLeft, bPilotsPlanesLeft
                          FROM activeMission");

Aucune évolution en rafraîchissent ma page. Au sujet de ma table activeMission cette dernière n'est pas vide voir ci-dessous:

DROP TABLE IF EXISTS `activeMission`;
CREATE TABLE `activeMission` (
  `missionName` varchar(50)  NOT NULL,
  `rPilotsPlanesLeft` varchar(100)  NOT NULL DEFAULT 'Unknown',
  `bPilotsPlanesLeft` varchar(100)  NOT NULL DEFAULT 'Unknown',
  `rObjectivesLeft` varchar(500)  NULL DEFAULT 'None',
  `bObjectivesLeft` varchar(500)  NULL DEFAULT 'None',
  `missionStartTime` int(11) NOT NULL DEFAULT '0',
  `rTargetObjectivesLeft` varchar(500) NULL DEFAULT 'None',
  `bTargetObjectivesLeft` varchar(500) NULL DEFAULT 'None',
  `timeLeft` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB;

Par contre ou dois je exactement ajouter "var_dump($missionStartTime);die();"

Au sujet de mysqli effectivement j'ai le message d'erreur suivant:

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\Apache24\htdocs\Server_IL2\includes\header.inc on line 41

Pourrais tu m'expliquer comment dois-je faire pour convertir mysql en mysqli en sachant que j'ai bien activé mon extension mysqli dans php.ini

Cordialement

par **sirakawa** » 26 févr. 2014, 10:00

Bjr,
ajoute cette ligne 35:
var_dump($missionStartTime);die();
et donne le résultat.
Tu peux donner la sructure de ta table activeMission;
Enfin il faudrait remplacer mysql par mysqli.

par **Genova** » 26 févr. 2014, 02:25

Bah en gros la variable $missionStartTime devrait contenir un timestamp, c'est à dire un nombre entier qui représente un nombre de seconde, et à partir de ce nombre la fonction date() l'affichera sous forme d'une vraie date. Or cette variable ne contient pas de nombre visiblement. Donc le problème vient de la ligne 33, ça ne rentre pas dans la boucle et donc ça ne rempli pas correctement la variable.
Enlèves le @ à la ligne 17 devant mysql_query(), histoire de voir si ta requête n'a pas d'erreur. Autrement vérifie dans ta base de donnée si la table activeMission n'est pas vide.

par **Lavazza** » 26 févr. 2014, 02:14

Merci pour votre réponse aussi rapide...

Je me permet de mettre en ligne ma page pour répondre à votre question car étant un débutant de chez Débutant j'ai peur de dire une bêtise

<?php
/*************************************************
file: index.php  sd
Date: 7-Jul-2008
Author: WildWillie - Outback Computer Consultants, Inc.
description: This is the default page for FBDj Stats
Updates:
4-May-2009 - Converted to using MySQLi for DB activity
**************************************************/

// Get set up and under way
require('./config.php');

include('./includes/header.inc');

// Get Active Mission Information
$result = @mysql_query("SELECT missionName, timeLeft, missionStartTime, rObjectivesLeft,
                               rTargetObjectivesLeft, bObjectivesLeft, bTargetObjectivesLeft,
                               rPilotsPlanesLeft, bPilotsPlanesLeft
                          FROM activeMission");
if ($result) {
         $currentMission = "";
         $missionStartTime = "";
         $missionTimeLeft = "";
         $rPilotsPlanesLeft = "";
         $rObjectivesLeft = "";
         $bPilotsPlanesLeft = "";
         $bObjectivesLeft = "";
         $rTargetObjectivesLeft = "";
         $bTargetObjectivesLeft = "";
      while ($row = mysql_fetch_array($result))
      {
         $currentMission = $row['missionName'];
         $missionStartTime = $row['missionStartTime'];
         $missionTimeLeft = $row['timeLeft'];
         $rPilotsPlanesLeft = $row['rPilotsPlanesLeft'];
         $rObjectivesLeft = $row['rObjectivesLeft'];
         $bPilotsPlanesLeft = $row['bPilotsPlanesLeft'];
         $bObjectivesLeft = $row['bObjectivesLeft'];
         $rTargetObjectivesLeft = $row['rTargetObjectivesLeft'];
         $bTargetObjectivesLeft = $row['bTargetObjectivesLeft'];
      }
      mysql_free_result($result);
}
else {
    print_error("Mysql Error Selecting ActiveMission: " . mysql_error());
}
$bgcolor = "#000000";
?>
<p align="center"><font class="fontTitle"><b><?php echo $Current_Mission; ?> - <?php echo $currentMission; ?></b></font></p>
<!--************************** Main Table *****************************-->
<table width="90%" align="center" border="0" cellspacing="5" cellpadding="1">
<tr>
<td width="40%" valign="top">
     <!--************************** Mission Info Table *****************************-->
     <table align="center" valign="top" border="0" cellpadding="2" cellspacing="1" width="100%" class="table">
          <tr align="center" class="tableheader">
              <td align="center" valign="top"><font  class="fontHeader"><?php echo $Mission_Status; ?></td>
          </tr>
          <tr align="center">
              <td ><font class=fontNormal><b><?php echo $Start_Time; ?>:</b> <?php echo date("d.m.Y H:i", $missionStartTime); ?></td>
          </tr>
          <tr align="center">
              <td ><font class=fontNormal><b><?php echo $Time_Left; ?>:</b> <?php echo  round($missionTimeLeft/60); ?> <?php echo  $Minutes; ?></td>
          </tr>
          <tr align="center">
              <td><font class=fontHeader><?php echo $Red_Objectives_Remaining; ?></font></td>
          </tr>
          <tr align="center">
              <td ><font color=#FF0000 class=fontNormal><b><?php echo $rPilotsPlanesLeft; ?></b></font></td>
          </tr>
          <tr align="center">
              <td ><font color=#FF0000 class=fontNormal><b><?php echo $rObjectivesLeft; ?></b></font></td>
          </tr>
          <tr align="center">
              <td ><font color=#FF0000 class=fontNormal><b><?php echo $rTargetObjectivesLeft; ?></b></font></td>
          </tr>
          <tr align="center">
              <td ><font class=fontHeader><?php echo $Blue_Objectives_Remaining; ?></font></td>
          </tr>
          <tr align="center">
              <td ><font color=#0000FF class=fontNormal><b><?php echo $bPilotsPlanesLeft; ?></b></font></td>
          </tr>
          <tr align="center">
              <td ><font color=#0000FF class=fontNormal><b><?php echo $bObjectivesLeft; ?></b></font></td>
          </tr>
          <tr align="center">
              <td ><font color=#0000FF class=fontNormal><b><?php echo $bTargetObjectivesLeft; ?></b></font></td>
          </tr>
          <tr align="center">
              <td ><font class=fontHeader><?php echo $Limited_Plane_Availability; ?></font></td>
          </tr>

          <?php
           // Get Plane Limits
              $query= "SELECT army, planeLimit
                         FROM activeMissionPlaneLimits
                        ORDER BY army";

              $result = @mysql_query($query);
              if ($result)
              {
                while ($row = mysql_fetch_array($result))
                {
                  $army = $row['army'];
                  $planeLimit = $row['planeLimit'];

                  if ($army == $redTeam) {
                     $armyColor = " color=#FF0000 class=fontNormal";
                  }
                  else
                  {
                    $armyColor = " color=#0000FF class=fontNormal";
                  }

                  echo "<tr >
                         <td align='center'><font $armyColor><b>$planeLimit</b></font></td>
                        </tr>";
                }
              }
              else
              {
                 print_error("Mysql Error Selecting ActiveMissionPlaneLimits: " . mysql_error());
              }
              mysql_free_result($result);
          ?>
     </table>
     <br>
     <!--************************** Mission Victories Table *****************************-->
     <table border=0 cellpadding=2 cellspacing=1 width=100% class="table">
        <tr class=tableheader>
           <td align=center valign=top colspan=2><font  class=fontHeader><?php echo $Mission_Victories; ?></td>
        </tr>
        <?php

        // Get Mission Count/Winner Info
        $query= "SELECT
             COUNT(*) missionCount,
             SUM(IF(winner=$blueTeam,1, 0)) AS winBlue,
             SUM(IF(winner=$redTeam,1, 0)) AS winRed
             FROM missions";

        $result = @mysql_query($query);
        if ($result) {
        	$row = mysql_fetch_array($result, MYSQL_ASSOC);
        	$bluemissionwinner = $row['winBlue'];
            $redmissionwinner = $row['winRed'];
            $totalMissionsRun = $row['missionCount'];
        }
        else {
        	print_error("Mysql Error Selecting Mission Count/Winners: " . mysql_error());
        }
        mysql_free_result($result);

        // Get Mission Specific Count/Winner Info
        $query= "SELECT
             COUNT(*) mission_count,
             SUM(IF(winner=$blueTeam,1, 0)) AS win_blue,
             SUM(IF(winner=$redTeam,1, 0)) AS win_red
            FROM missions
            WHERE missionName = '$currentMission'";

        $result = @mysql_query($query);
        if ($result) {
            $row = mysql_fetch_array($result, MYSQL_ASSOC);
            $current_bluemissionwinner = $row['win_blue'];
            $current_redmissionwinner = $row['win_red'];
            $currentMissionRunTotal = $row['mission_count'];
        }
        else {
            print_error("Mysql Error Selecting Current Mission Win Counts: " . mysql_error());
        }
        mysql_free_result($result);

        // Get Current Number of Players
        $query= "SELECT COUNT(*) playerCount
                   FROM activePilots";

        $result = @mysql_query($query);
        if ($result) {
        	$row = mysql_fetch_array($result, MYSQL_ASSOC);
        	$playerCount = $row['playerCount'];
        }
        else {
        	print_error("Mysql Error Selecting Player Count: " . mysql_error());
        }
        mysql_free_result($result);

        $totalMissionWinner = $bluemissionwinner + $redmissionwinner;
        if ($totalMissionWinner > 0)
        {
             $totalMissionGraph =  graphteam($redmissionwinner,$totalMissionWinner, 50, 10);
        }
        else
        {
             $totalMissionGraph = $No_Winners_Yet;
        }
        $currentMissionWinner = $current_bluemissionwinner + $current_redmissionwinner;
        if ($currentMissionWinner > 0)
        {
             $currentMissionGraph =  graphteam($current_redmissionwinner,$currentMissionWinner, 50, 10);
        }
        else
        {
             $currentMissionGraph = $No_Winners_Yet;
        }

        ?>
    <tr align="center" class="fontNormal">
        <td align="center"><?php echo  $All_Missions;?> (&nbsp;<?php echo $totalMissionsRun; ?>&nbsp;)</font></td>
        <td align="center"><?php echo  $redmissionwinner."&nbsp;".$totalMissionGraph."&nbsp;".$bluemissionwinner;?></font></td>
    </tr>
    <tr align="center" class="fontNormal">
        <td align="center"><a href='./missionstats.php?id=<?php echo $currentMission?>' class='missionname'><i><?php echo $currentMission?> (&nbsp;<?php echo $currentMissionRunTotal; ?>&nbsp;)</i></a></td>
        <td align="center"><font class="fontNormal"><?php echo  $current_redmissionwinner."&nbsp;".$currentMissionGraph."&nbsp;".$current_bluemissionwinner;?></font></td>
    </tr>
   </table>
   <br />
   <!--************************** Chat Messages Table *****************************-->
   <table border="0" cellpadding="2" cellspacing="1" width="100%" class="table">
      <tr class="tableheader">
         <td align="center" valign="top" colspan="3"><font  class=fontHeader><?php echo  $Messages_from_the_Front;?></td>
      </tr>
      <?php
      // Get Game Chat
      $query= "SELECT army, author, chat
                 FROM gamechat
                WHERE author != 'Server'
                  AND chatType = 'MESSAGE'
             ORDER BY timeStamp DESC
             LIMIT 0, 20";

      $getResults = mysqli_query($mysqli, $query) or die(mysqli_error($mysqli));
      if (mysqli_num_rows($getResults) > 0)
      {
  	   while ($row = @mysqli_fetch_array($getResults))
         {
             $chatUcode = $row['chat'];

             $army = $row['army'];
             if ($army == "1")
             {
               $armyColor = " color=#FF0000 class=fontNormal";
             }
             else if ($army =="2")
             {
               $armyColor = " color=#0000FF class=fontNormal";
             }
             else
             {
               $armyColor = " class=fontNormal";
             }

             echo "<tr class='listing1'>
                     <td align='left'><font $armyColor><b>".$row['author'].": </b></font>".$chatUcode."</td>
                   </tr>";
         }
         mysqli_free_result($getResults);
      }
      else
      {
 //                print_error("Mysql Error Selecting GameChat: " . mysql_error());
      }

      ?>
   </table>
</td>
<td width="50%" valign="top">
    <!--************************** Active Players *****************************-->
    <table border="0" cellpadding="2" cellspacing="1" width="100%" class="table">
        <tr class="tableheader" valign="top">
            <td align="center" colspan="6" ><font  class="fontHeader"><?php echo $Active_Players; ?> (&nbsp;<?php echo $playerCount; ?>&nbsp;)</font></td>
        </tr>
        <tr align="center" class="tableheader">
            <td></td>
            <td ><b><?php echo $Rank; ?></b></td>
            <td ><b><?php echo $Pilot; ?></b></td>
            <td ><b><?php echo $Pilot_Plane_Status; ?></b></td>
            <td ><b><?php echo $Aircraft_s; ?></b></td>
            <td ><b><?php echo $Markings; ?></b></td>
        </tr>

        <?php
        // Current Pilots
        $result = @mysql_query("SELECT
                            b.pilotId,
                            a.pilotName,
                            a.state,
                            a.country,
                            a.army,
                            a.aircraft,
                            a.markings,
                            getPilotRank(b.pilotId) AS pilotRank
                        FROM
                            activePilots a, pilots b
                        WHERE a.pilotName = b.pilotName
                        ORDER BY
                            army, pilotName");
        if ($result) {
            while ($row = mysql_fetch_row($result))
            {
                switch($row[4])
                {
                      case "2": $bgcolor = "listing2"; $color=" class='playerblue'"; break;
                      case "1" : $bgcolor = "listing1"; $color=" class='playerred'"; break;
                      default : $bgcolor = "";  $color=" class='fontNormal'";
                }

                $country = $row[3];
                if ($country == "0") {
                    $country = "";
                } else {
                $image = preg_replace("/\s/", "%20", $country);
                $image .= ".gif";
            	}

                echo "<tr class=$bgcolor>
                      <td align=center>";


            	if ($country == "") {
                echo "&nbsp;";
                } else {
        		echo "<img alt='$country' width='20' height='12' border='0' valign='top' align='center' src='images/flags/$image'>";
            	}
                $playerName = $row[1];
                $playerRank = $row[7];
                echo "</td>
                      <td align='left' $color>$playerRank</td>";
                echo "<td align=left valign=top><font class=fontNormal><a href='./playerdetails.php?id=$row[0]'$color>$playerName</font></a></td>
                      ";

                echo "<td align='center' valign=top><font class=fontNormal>$row[2]</font></td>
                      <td align='center' valign=top><font class=fontNormal>$row[5]</font></td>
                      <td align='center' valign=top><font class=fontNormal>$row[6]</font></td>
                      </tr>\n";
            }
            mysql_free_result($result);
        }
        else
        {
            print_error("Mysql Error Selecting Active Players: " . mysql_error());
        }
        ?>
    </table>
</td>
</tr>
</table>
<table width="90%" align="center" border="0" cellspacing="5" cellpadding="1">
<tr>
<td width="50%" valign="top">
  <!--************************** Squadron Table *****************************-->
  <table border=0 cellpadding=2 cellspacing=1 width=100% class="table">
      <tr class=tableheader>
          <td align="center" colspan="7" valign="top"><font  class="fontHeader"><?php echo $Top_Scores_by_Squadron; ?></td>
      </tr>
      <tr class=tableheader>
          <td align=center><?php echo $Squadron; ?></td>
          <td align=center><?php echo $Q_Pilots; ?></td>
          <td align=center><?php echo $Total_Sorties; ?></td>
          <td align=center><?php echo $Total_Air_Kills; ?></td>
          <td align=center><?php echo $Total_Ground_Kills; ?></td>
          <td align=center><?php echo $Total_Score; ?></td>
      </tr>
         <?php
         // Top 10 Squadrons
         $result = @mysql_query("SELECT a.squadronId,
                                        b.squadronName as squadronName,
                                        COUNT(DISTINCT pilotId) as numPilots,
                                        SUM(numSorties) as totalSorties,
                                        SUM(score) as totalScore,
                                        SUM(eAirConfirmed + eAirAdjusted) AS airKills,
                                        SUM(eGroundKills) AS eGroundKills
                                  FROM pilotTotals a, squadrons b
                                   WHERE a.squadronId = b.squadronId
                                     AND a.squadronId is not null
                                  GROUP BY b.squadronName
                                  ORDER BY totalScore DESC
                                  LIMIT 0, 20");
        if ($result)
        {
            while ($row = mysql_fetch_array($result))
            {
                $squadronId = $row['squadronId'];
                $squadronName = $row['squadronName'];
                $totalPilots = $row['numPilots'];
                $totalScore = $row['totalScore'];
                $totalSorties = $row['totalSorties'];
                $totalAirKills = $row['airKills'];
                $groundKills = $row['eGroundKills'];

                $bgcolor = ($bgcolor!="listing1")? "listing1" : "listing2";
                echo "<tr class=$bgcolor>
                   <td align=left><a href='squadronDetails.php?id=$squadronId'><font class=fontNormal>$squadronName</a></td>
                   <td align=right valign=top><font class=fontNormal>$totalPilots</td>
                   <td align=right valign=top><font class=fontNormal>".number_format($totalSorties, 0, '.', ',')."</td>
                   <td align=right valign=top><font class=fontNormal>".number_format($totalAirKills, 2, '.', ',')."</td>
                   <td align=right valign=top><font class=fontNormal>".number_format($groundKills, 0, '.', ',')."</td>
                   <td align=right valign=top><font class=fontNormal>".number_format($totalScore, 0, '.', ',')."</td>
                  </tr>\n";
            }
            mysql_free_result($result);
        }
        else
        {
            print_error("Mysql Error Selecting Squadron totals: " . mysql_error());
        }
        ?>

   </table>
</td>
<td width="50%" valign="top">
   <!--************************** Top Pilots Table *****************************-->
   <table border="0" cellpadding="2" cellspacing="1" width="100%" class="table">
      <tr class="tableheader">
          <td align="center" colspan="6" valign="top"><font class="fontHeader"><?php echo $Top_Scores_by_Pilot; ?></td>
      </tr>
      <tr align="center" class="tableheader">
          <td ><b><?php echo $Rank; ?></b></td>
          <td ><b><?php echo $Pilot; ?></b></td>
          <td ><b><?php echo $Q_Sorties; ?></b></td>
          <td ><b><?php echo $Avg_Score; ?></b></td>
          <td ><b><?php echo $Total_Score; ?></b></td>
      </tr>
         <?php
         // Top 20 Scores
         $result = @mysql_query("SELECT sorties.pilotId as pilotId,
                                 pilots.pilotName as pilotName,
                                 getPilotRank(sorties.pilotId) AS pilotRank,
                                 getPrimaryArmy(sorties.pilotId) AS army,
                                 COUNT(*) AS numSorties,
                                 SUM(sorties.score) AS totalScore,
                                 SUM(sorties.score)/COUNT(*) AS avgScore
                            FROM sorties
                        LEFT JOIN pilots ON pilots.pilotId = sorties.pilotId
                            WHERE 1
                            GROUP BY sorties.pilotId
                            ORDER BY totalScore DESC
                            LIMIT 0, 20");
        if ($result)
        {
            while ($row = mysql_fetch_array($result))
            {

             switch( $row['army'] )
                {
                      case $blueTeam: $color=" class='playerblue'"; break;
                      case $redTeam : $color=" class='playerred'"; break;
                      default :  $color=" class='fontNormal'";
                }

            $pilotName = $row['pilotName'];
            $bgcolor = ($bgcolor!="listing1")? "listing1" : "listing2";
            $pilotName = $row['pilotName'];
            $pilotRank = $row['pilotRank'];
            echo "<tr class=$bgcolor>
                   <td align='center' $color>$pilotRank</td>
                   <td align='left' ><font class='fontNormal'><a href='./playerdetails.php?id=$row[pilotId]'$color>$pilotName</font></a></td>
                   <td align=right valign=top><font class=fontNormal>".number_format($row["numSorties"], 0, '.', ',')."</td>
                   <td align=right valign=top><font class=fontNormal>".number_format($row["avgScore"], 0, '.', ',')."</td>
                   <td align=right valign=top><font class=fontNormal>".number_format($row["totalScore"], 0, '.', ',')."</td>
                  </tr>\n";
            }
            mysql_free_result($result);
        }
        else
        {
            print_error("Mysql Error Selecting Top Pilots: " . mysql_error());
        }
        ?>

   </table>
</td>
</tr>
<br>
<tr>
<td valign="top">
   <table border=0 cellpadding=2 cellspacing=1 width=100% class="table">
      <tr class=tableheader>
          <td align="center" colspan="5" valign="top"><font  class="fontHeader"><?php echo $Top_Fighter_Pilots; ?></td>
      </tr>
      <tr align="center" class="tableheader">
          <td><?php echo $Rank; ?></td>
          <td ><?php echo $Pilot; ?></td>
          <td ><?php echo $Q_Sorties; ?></td>
          <td ><?php echo $Confirmed_Kills; ?></td>
          <td ><?php echo $Return_Alive_Kills; ?></td>
      </tr>
         <?php
         // Top 10 Top Guns
         $result = @mysql_query("SELECT b.pilotId,
                                        b.pilotName,
                                        c.rank AS pilotRank,
                                        c.primaryArmy AS army,
                                  COUNT(a.sortieid) as sorties,
                                    SUM(a.eAirConfirmed + a.eAirAdjusted) as confirmedKills,
                                    landedKills
                                   FROM sorties a, pilots b, pilotTotals c
                                  WHERE a.pilotId = b.pilotId
                                    AND a.pilotId = c.pilotId
                                  GROUP BY b.pilotName
                                  ORDER BY landedKills DESC
                                  LIMIT 0, 20");
        if ($result)
        {
            while ($row = mysql_fetch_array($result))
            {

             switch( $row['army'] )
                {
                      case $blueTeam: $color=" class='playerblue'"; break;
                      case $redTeam : $color=" class='playerred'"; break;
                      default :  $color=" class='fontNormal'";
                }

            $pilotId = $row['pilotId'];
            $pilotName = $row['pilotName'];

            $bgcolor = ($bgcolor!="listing1")? "listing1" : "listing2";

            $pilotRank = $row['pilotRank'];
            echo "<tr class='$bgcolor' valign='top'>
                   <td align='left' $color>$pilotRank</td>
                   <td align='left' ><font class='fontNormal'><a href='./playerdetails.php?id=$row[pilotId]'$color>$pilotName</font></a></td>
                   <td align=center>".number_format($row["sorties"], 0, '.', ',')."</td>
                   <td align=right valign=top><font class=fontNormal>".number_format($row["confirmedKills"], 2, '.', ',')."</td>
                   <td align=right valign=top><font class=fontNormal>".number_format($row["landedKills"], 2, '.', ',')."</td>
                  </tr>\n";
            }
            mysql_free_result($result);
        }
        else
        {
            print_error("Mysql Error Selecting Top Fighter Pilots: " . mysql_error());
        }
        ?>
   </table>
</td>
<td valign="top">
   <table border="0" cellpadding="2" cellspacing="1" width="100%" class="table">
      <tr class="tableheader">
          <td align="center" colspan="5" valign="top"><font  class="fontHeader"><?php echo $Top_Bomber_Pilots; ?></td>
      </tr>
      <tr align="center" class="tableheader">
          <td width="15%"><?php echo $Rank; ?></td>
          <td width="25%"><?php echo $Pilot; ?></td>
          <td width="10%"><?php echo $Q_Sorties; ?></td>
          <td width="20%"><?php echo $Confirmed_Kills; ?></td>
          <td width="30%" ><?php echo $Total_Enemy_Targets_Destroyed; ?></td>
      </tr>
      <?PHP
      // TOP 10 ground killers
      $query = "SELECT b.pilotId,
                        b.pilotName,
                        c.rank AS pilotRank,
                        c.primaryArmy AS army,
                  COUNT(a.sortieid) as sorties,
                  SUM(a.eAirConfirmed + a.eAirAdjusted) as confirmedKills,
                    SUM(eGround) as groundKills
                   FROM sorties a, pilots b, pilotTotals c
                  WHERE a.pilotId = b.pilotId
                    AND a.pilotId = c.pilotId
                  GROUP BY b.pilotName
                  ORDER BY groundKills DESC
                  LIMIT 0, 20";

        $result = @mysql_query($query);
        if ($result)
        {

            while ($row = mysql_fetch_array($result))
            {

                switch( $row['army'] )
                {
                      case $blueTeam: $color=" class='playerblue'"; break;
                      case $redTeam : $color=" class='playerred'"; break;
                      default :  $color=" class='fontNormal'";
                }

                $pilotName = $row['pilotName'];
                $pilotRank = $row['pilotRank'];
                $bgcolor = ($bgcolor!="listing1")? "listing1" : "listing2";

                echo "<tr class='$bgcolor' >
                        <td align='center' $color >$pilotRank</td>
                        <td align='left' ><font class='fontNormal'><a href='./playerdetails.php?id=$row[pilotId]'$color>$pilotName</font></a></td>
                        <td align=right valign=top><font class=fontNormal>".number_format($row["sorties"], 0, '.', ',')."</td>
                        <td align=right valign=top><font class=fontNormal>".number_format($row["confirmedKills"], 2, '.', ',')."</td>
                        <td align=right valign=top><b><font class=fontNormal>".number_format($row["groundKills"], 0, '.', ',')."<b></td>
                      </tr>\n";
            }
            mysql_free_result($result);
        }
        else {
            print_error("Mysql Error Selecting Top Bomber Pilots: " . mysql_error());
        }

        ?>
   </table>
</td>
</tr>
</table>

<?php
include('./includes/footer.inc');

function graphteam($value1,$value2,$maxsize_x=50,$maxsize_y=16)
{
     $value2 = ($value1>=$value2)? $value1 : $value2;
      if ($value2 == 0) {$value2 = 1;} //added mako 9-7-07
          $unit = $maxsize_x/$value2;
          $w1 = $value1*$unit;
          $w2 = $maxsize_x-$w1;
          $im = "<img src='./images/red.gif' width='$w1' height='$maxsize_y'><img src='./images/blue.gif' width='$w2' height='$maxsize_y'>";
     return $im;
 }

?>

Cordialement

par **Genova** » 26 févr. 2014, 02:00

$missionStartTime devrait contenir un nombre entier, et visiblement d'après le message d'erreur ce n'est pas le cas.
Comment initialises tu ta variable ?

par **Lavazza** » 26 févr. 2014, 01:50

Bonsoir à tous

Nouveau parmi vous, je me présente je m'appel Guillaume j'ai 29 ans et je réside dans la région de Montauban (82)
Débutant en PhP, Je permet de solliciter de l'aide car je rencontre l'erreur suivante:

Warning: date() expects parameter 2 to be long, string given in C:\Apache24\htdocs\Server_IL2\index.php on line 61

LIGNE 61:

  <tr align="center">
              <td ><font class=fontNormal><b><?php echo $Start_Time; ?>:</b> <?php echo date("d.m.Y H:i", $missionStartTime); ?></td>
          </tr>

Auriez vous une idée de l'erreur que j'ai pu faire?

Cordialement

Problème message d'erreur "Warning: date()..."

Répondre

Étendre la vue Revue du sujet : Problème message d'erreur "Warning: date()..."

Re: Problème message d'erreur "Warning: date()..."

Re: Problème message d'erreur "Warning: date()..."

Re: Problème message d'erreur "Warning: date()..."

Re: Problème message d'erreur "Warning: date()..."

Re: Problème message d'erreur "Warning: date()..."

Re: Problème message d'erreur "Warning: date()..."

Re: Problème message d'erreur "Warning: date()..."

Re: Problème message d'erreur "Warning: date()..."

Problème message d'erreur "Warning: date()..."