Bug

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

    • Bonjour, le système de bash est non opérationnel, il me renvois une erreur sql dans le fichier class.FleetFunctions.php

      SQL-Query

      1. [17-Jan-2017 23:07:38] USER ERROR: "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
      2. AND fleet_end_id = '36',
      3. AND fleet_state != '2',
      4. AND fleet_start_time ' at line 3
      5. Query-Code:SELECT COUNT(*) as state
      6. FROM gwk1_log_fleets
      7. WHERE fleet_owner = 7,
      8. AND fleet_end_id = 36,
      9. AND fleet_state != 2,
      10. AND fleet_start_time > 1484604458,
      11. AND fleet_mission IN (1,2,9);"
      12. File: /includes/classes/Database.class.php | Line: 123
      13. URL: https://sun10moons.com/game.php?page=fleetStep3 | Version: 1.8.git
      14. Stack trace:
      15. #0 /includes/classes/Database.class.php(199): Database->_query('SELECT COUNT(*)...', Array, 'select')
      16. #1 /includes/classes/class.FleetFunctions.php(475): Database->selectSingle('SELECT COUNT(*)...', Array)
      17. #2 /includes/pages/game/ShowFleetStep3Page.class.php(268): FleetFunctions::CheckBash('36')
      18. #3 /game.php(57): ShowFleetStep3Page->show()
      19. #4 {main}
      Display All



      PHP Source Code

      1. public static function CheckBash($Target)
      2. {
      3. global $USER;
      4. if(!BASH_ON)
      5. {
      6. return false;
      7. }
      8. $sql = 'SELECT COUNT(*) as state
      9. FROM %%LOG_FLEETS%%
      10. WHERE fleet_owner = :fleetOwner,
      11. AND fleet_end_id = :fleetEndId,
      12. AND fleet_state != :fleetState,
      13. AND fleet_start_time > :fleetStartTime,
      14. AND fleet_mission IN (1,2,9);';
      15. $Count = Database::get()->selectSingle($sql, array(
      16. ':fleetOwner' => $USER['id'],
      17. ':fleetEndId' => $Target,
      18. ':fleetState' => 2,
      19. ':fleetStartTime' => (TIMESTAMP - BASH_TIME),
      20. ));
      21. return $Count >= BASH_COUNT;
      22. }
      Display All
      si on peut m'aider svp car je ne vois pas l'erreur à la requête :/
      Files