/**
*
* @param Config $config
* @param IData $dbData
*/
protected function loadFromDatabase(Config $config, IData $dbData)
{
if ($dbData && $config->settingsUseDatabase) {
$this->table = $config->settingsTable;
$this->columnKey = $config->settingsKeyColumn;
$this->columnValue = $config->settingsValueColumn;
if ($this->table && $this->columnKey && $this->columnValue) {
$sql = "Select `{$this->columnKey}` as `key`, `{$this->columnValue}` as `value` From {$this->table} ";
$query = $dbData->query($sql);
$results = $dbData->result($query);
if ($results) {
foreach ($results as $row) {
$key = $row->key;
$this->data[$key] = $row->value;
}
}
}
}
}
public function isLoginUsed($login)
{
if (!$this->enabled) {
return false;
}
$sql = "Select * From {$this->tableUser} Where {$this->columnUsername} = '{$login}' Limit 1";
$query = $this->dbProvider->query($sql);
$row = $this->dbProvider->row($query);
if ($row) {
return true;
} else {
return false;
}
}
