Error in Spy mission

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • Error in Spy mission

      There is an error in the spy mission.
      It shows you in the report deployed the fleets that are still on their way to deploy.

      Existe un error en la mision espiar.
      Te muestra en el reporte desplegadas las flotas que aun van en camino a desplegar.

      The error is in the SQL query:
      El error esta en la consulta SQL:

      The solution:
      La solucion:

      Source Code: MissionCaseSpy.class.php

      1. $sql = 'SELECT * FROM %%FLEETS%% WHERE fleet_end_id = :planetId AND fleet_mission = 5 AND fleet_end_stay > :time;';
      2. $targetStayFleets = $db->select($sql, array(
      3. ':planetId' => $this->_fleet['fleet_end_id'],
      4. ':time' => $this->_fleet['fleet_start_time'],
      5. ));
    • habre confundido la consulta, voy a ver y te lo posteo luego.

      La consulta es esta:

      PHP Source Code: MissionCaseSpy.class.php

      1. $sql = 'SELECT * FROM %%FLEETS%% WHERE fleet_end_id = :planetId AND fleet_mission = 5 AND fleet_end_stay > :time AND fleet_start_time < :time2;';



      Reemplaza el fichero por el que tienes.

      Edicion: Es que subi el fichero sin corregir.
      Files

      The post was edited 1 time, last by Skylon: Fichero corregido. Consulta SQL corregida ().