/** * 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; } }