Bonjour, le système de bash est non opérationnel, il me renvois une erreur sql dans le fichier class.FleetFunctions.php
Display All
Display All
si on peut m'aider svp car je ne vois pas l'erreur à la requête
SQL-Query
- [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 '
- AND fleet_end_id = '36',
- AND fleet_state != '2',
- AND fleet_start_time ' at line 3
- Query-Code:SELECT COUNT(*) as state
- FROM gwk1_log_fleets
- WHERE fleet_owner = 7,
- AND fleet_end_id = 36,
- AND fleet_state != 2,
- AND fleet_start_time > 1484604458,
- AND fleet_mission IN (1,2,9);"
- File: /includes/classes/Database.class.php | Line: 123
- URL: https://sun10moons.com/game.php?page=fleetStep3 | Version: 1.8.git
- Stack trace:
- #0 /includes/classes/Database.class.php(199): Database->_query('SELECT COUNT(*)...', Array, 'select')
- #1 /includes/classes/class.FleetFunctions.php(475): Database->selectSingle('SELECT COUNT(*)...', Array)
- #2 /includes/pages/game/ShowFleetStep3Page.class.php(268): FleetFunctions::CheckBash('36')
- #3 /game.php(57): ShowFleetStep3Page->show()
- #4 {main}
PHP Source Code
- public static function CheckBash($Target)
- {
- global $USER;
- if(!BASH_ON)
- {
- return false;
- }
- $sql = 'SELECT COUNT(*) as state
- FROM %%LOG_FLEETS%%
- WHERE fleet_owner = :fleetOwner,
- AND fleet_end_id = :fleetEndId,
- AND fleet_state != :fleetState,
- AND fleet_start_time > :fleetStartTime,
- AND fleet_mission IN (1,2,9);';
- $Count = Database::get()->selectSingle($sql, array(
- ':fleetOwner' => $USER['id'],
- ':fleetEndId' => $Target,
- ':fleetState' => 2,
- ':fleetStartTime' => (TIMESTAMP - BASH_TIME),
- ));
- return $Count >= BASH_COUNT;
- }