No problem, but changed the table's field names to be the same.
1. edit file open
includes/classes/PlayerUtil.class.php
near line 468
fleet_id = fleetId ----> fleet_id = fleetID
Display All
1. edit file open
includes/classes/PlayerUtil.class.php
near line 468
fleet_id = fleetId ----> fleet_id = fleetID
PHP Source Code
- $sql = 'DELETE %%FLEETS%%, %%FLEETS_EVENT%%
- FROM %%FLEETS%% LEFT JOIN %%FLEETS_EVENT%% on fleet_id = fleetId
- WHERE fleet_owner = :userId;';
- $db->delete($sql, array(
- ':userId' => $userId
- ));
- //Modify like below
- $sql = 'DELETE %%FLEETS%%, %%FLEETS_EVENT%%
- FROM %%FLEETS%% LEFT JOIN %%FLEETS_EVENT%% on fleet_id = fleetID
- WHERE fleet_owner = :userId;';
- $db->delete($sql, array(
- ':userId' => $userId
- ));
--------------------------------------------------------------------------------------