In core/common/SchedulesData.class.php, somewhere near line 792, you can replace and try this, however I am not sure it may work or not.
public static function deleteExpiredBids() {
$cache_time = Config::Get('BID_EXPIRE_TIME');
if ($cache_time == '') {
return;
}
/* Make sure the schedule bidids */
$sql = 'SELECT * FROM ' . TABLE_PREFIX . "bids
WHERE `dateadded` + INTERVAL {$cache_time} HOUR < NOW()";
$results = DB::get_results($sql);
if (count($results) > 0) {
foreach ($results as $row) {
$pilotdet = PilotData::getPilotData($row->pilotid);
$pilotname = $pilotdet->firstname.' '.$pilotdet->lastname;
$pilotemail = $pilotdet->email;
$subject = 'Vistara Virtual : Bid Deleted!';
$message = 'Hello '.$pilotname.', your Bid having ID: '.$row->bidid.' has been deleted since it has crossed the minimum days required to fly!';
mail($pilotemail,$subject,$message);
$sql = 'UPDATE ' . TABLE_PREFIX . "schedules
SET `bidid`=0 WHERE `id`={$row->routeid}";
DB::query($sql);
}
}
$sql = 'DELETE FROM ' . TABLE_PREFIX . "bids
WHERE `dateadded` + INTERVAL {$cache_time} HOUR < NOW()";
DB::query($sql);
}