'; } else { // No @, try add orgid $suffix = $organizationid; $login .= "@$suffix"; } $ok = Database::queryFirst('SELECT organizationid FROM organization_suffix WHERE organizationid = :o AND suffix = :s LIMIT 1', array( 'o' => $organizationid, 's' => $suffix )); if ($ok === false) { Message::addError('Login-Suffix @{{0}} ist ungültig.', $suffix); } else { Database::exec('INSERT INTO user (userid, password, organizationid, firstname, lastname, email) ' . ' VALUES (:userid, :password, :organization, :firstname, :lastname, :email)', array( 'userid' => $login, 'password' => Crypto::hash6($password), 'organization' => $organizationid, 'firstname' => $firstname, 'lastname' => $lastname, 'email' => Request::post('email') )); Message::addSuccess('Benutzer {{0}} angelegt', $login); } } Util::redirect('?do=Main'); } } protected function doRender() { // Show mask $res = Database::simpleQuery('SELECT organizationid, name FROM organization ORDER BY name ASC'); $orgs = array(); $orgs[] = array( 'organizationid' => '', 'name' => ' -- Bitte wählen -- ' ); while ($row = $res->fetch(PDO::FETCH_ASSOC)) { $orgs[] = $row; } Render::addTemplate('adduser/_page', array('orgs' => $orgs)); } }