/**
* Alle eingetragenen realms laden
*
* @access private
* @author prodigy
* @since 01.01.2009
* @version 0.1a
*/
private function DBLoadAll()
{
if (!$this->DBc->DB_Connect('mdm')) {
$this->objR->assign('SOVerror', 'innerHTML', 'Datenbank zur Zeit nicht verfügbar.<br />' . mysqli_connect_error());
return;
}
$res = $this->DBc->DB_Connection['mdm']->query("\n SELECT *\n FROM `realmdbs`;");
$this->DBc->DB_Close('mdm');
$this->objR->assign('SOVerror', 'innerHTML', "<pre>\n");
$this->objR->append('SOVerror', 'innerHTML', $res->num_rows . "\n");
foreach ($res as $db) {
$this->objR->append('SOVerror', 'innerHTML', print_r($db, true) . "\n");
}
$this->objR->append('SOVerror', 'innerHTML', '</pre>');
}
/**
* Login Funktionalität
*
* @access public
* @author prodigy
* @since 31.12.2008
* @version 0.1a
*/
public function LogIn($FormData)
{
$objR = new xajaxResponse();
if (!$this->DBc->DB_Connect('realmdb')) {
$this->smarty->assign('loginError', 'innerHTML', 'Datenbank zur Zeit nicht verfügbar.<br />' . mysqli_connect_error());
return $objR;
}
$res = $this->DBc->DB_Connection['realmdb']->query("SELECT `gmlevel`\n FROM `account`\n WHERE\n UPPER(`username`) = UPPER('" . $FormData['username'] . "')\n AND `sha_pass_hash` = SHA1(UPPER('" . $FormData['username'] . ":" . $FormData['password'] . "'));");
$res = $res->fetch_array();
$this->DBc->DB_Close('realmdb');
if ($res['gmlevel'] >= 3) {
$_SESSION['loggedin'] = true;
$_SESSION['username'] = $FormData['username'];
$_SESSION['page'] = 'main';
$objR->assign('pMenu', 'innerHTML', $this->smarty->fetch('layout_menu.tpl'));
$this->getContent('serveroverview', $objR);
return $objR;
} else {
$objR->assign('loginError', 'innerHTML', 'Falsche Benutzername / Passwort Kombination.');
return $objR;
}
}
