Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation on 04/21/19 in Posts

  1. 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); }
    1 point
×
×
  • Create New...