public function unblock($token, $logger)
{
// prune old tokens:
$this->_db->setQuery('DELETE FROM #__bfstop_unblock_token ' . 'WHERE DATE_ADD(crdate, INTERVAL ' . self::TokenValidDays . ' DAY) < ' . $this->_db->quote(date('Y-m-d H:i:s')));
$this->_db->execute();
BFStopDBHelper::checkDBError($this->_db, $logger);
// get token:
$this->_db->setQuery('SELECT * FROM #__bfstop_unblock_token WHERE token=' . $this->_db->quote($token));
$unblockTokenEntry = $this->_db->loadObject();
BFStopDBHelper::checkDBError($this->_db, $logger);
if ($unblockTokenEntry == null) {
$logger->log("com_bfstop-tokenunblock: Token not found.", JLog::ERROR);
return false;
}
BFStopUnblockHelper::unblock($this->_db, array($unblockTokenEntry->block_id), 1, $logger);
$sql = 'DELETE FROM #__bfstop_unblock_token WHERE token=' . $this->_db->quote($token);
$this->_db->setQuery($sql);
$success = $this->_db->execute();
BFStopDBHelper::checkDBError($this->_db, $logger);
if (!$success) {
$logger->log("com_bfstop-tokenunblock: Could not delete unblock_token.", JLog::ERROR);
} else {
$logger->log("com_bfstop-tokenunblock: Successfully unblocked with token.", JLog::INFO);
}
return $success;
}
public static function unblock($db, $ids, $source, $logger)
{
if (!is_array($ids) || sizeof($ids) == 0) {
$logger->log("com_bfstop unblock: Invalid parameter IDs given!", JLog::ERROR);
return false;
}
$sql = 'SELECT * FROM #__bfstop_unblock WHERE ' . 'block_id IN (' . implode(", ", $ids) . ')';
$db->setQuery($sql);
$unblockEntry = $db->loadObject();
BFStopDBHelper::checkDBError($db, $logger);
if ($unblockEntry != null) {
$logger->log("com_bfstop unblock: Unblock already exists!", JLog::ERROR);
return false;
}
$unblockResult = true;
$unblockDate = date('Y-m-d H:i:s');
foreach ($ids as $id) {
$unblock = new stdClass();
$unblock->block_id = $id;
$unblock->source = $source;
// source of 1 indicates unblock via email
$unblock->crdate = $unblockDate;
$unblockResult = $db->insertObject('#__bfstop_unblock', $unblock);
BFStopDBHelper::checkDBError($db, $logger);
if (!$unblockResult) {
$logger->log("com_bfstop-tokenunblock: Inserting unblock failed!", JLog::ERROR);
}
}
return $unblockResult;
}
public function remove($ids, $logger)
{
$db = JFactory::getDBO();
$query = $db->getQuery(true);
$conditions = array($db->quoteName('id') . ' IN (' . implode(", ", $ids) . ')');
$query->delete($db->quoteName('#__bfstop_whitelist'));
$query->where($conditions);
$db->setQuery($query);
$db->query();
BFStopDBHelper::checkDBError($db, $logger);
}
public function myCheckDBError()
{
BFStopDBHelper::checkDBError($this->db, $this->logger);
}
