/** * @param string $event * @param string $due_date */ public function redateUniqueEvent($request, $event, $due_date, $context = array(), $params = array(), $customparams = array()) { $db = JFactory::getDBO(); $query = 'SELECT `id`' . ' FROM #__acctexp_event' . ' WHERE `userid` = \'' . $request->metaUser->userid . '\'' . ' AND `appid` = \'' . $this->id . '\'' . ' AND `event` = \'' . $event . '\'' . ' AND `type` = \'mi\'' . ' AND `status` = \'waiting\''; $db->setQuery($query); $id = $db->loadResult(); if ($id) { $aecEvent = new aecEvent(); $aecEvent->load($id); if ($aecEvent->due_date != $due_date) { $aecEvent->due_date = $due_date; $aecEvent->storeload(); } } else { return $this->issueEvent($request, $event, $due_date, $context, $params, $customparams); } }