public function up()
 {
     $this->createTable('db_user', array('primary' => 'dbUserID'), array(array('dbUserID', 'integer'), array('dbUserName', 'string', array('limit' => 20)), array('dbUserPW', 'string', array('limit' => 50)), array('dbUserFullName', 'string', array('limit' => 50, 'null' => true)), array('dbUserActive', 'string', array('limit' => 1, 'default' => 'Y')), array('ACLstring', 'text', array('null' => true, 'limit' => '1M'))));
     $this->createIndex('db_user', array('dbUserName'));
     // reset db metadata cache
     QFrame_Db_Table::scanDb();
     // create some default data
     $admin = new DbUserModel(array('dbUserName' => 'admin', 'dbUserPW' => 'admin', 'dbUserFullName' => 'Administrator'));
     $admin->save();
     $user = new DbUserModel(array('dbUserName' => 'user', 'dbUserPW' => 'user', 'dbUserFullName' => 'User'));
     $user->save();
 }
Beispiel #2
0
 /**
  * Edit action.  Sets a user up to be modified or, when posted to, edits a user
  * and redirects to the index page.
  */
 public function editAction()
 {
     $user = new DbUserModel(array('dbUserID' => $this->_getParam('id')));
     if ($this->getRequest()->isPost()) {
         foreach ($this->_getParam('user') as $field => $value) {
             $user->{$field} = $value;
         }
         $pw = $this->_getParam('dbUserPW');
         $pwConf = $this->_getParam('dbUserPWConf');
         if ($pw !== '' && $pw === $pwConf) {
             $user->dbUserPW = $pw;
         }
         if ($pw !== $pwConf) {
             $this->flashNow('error', 'Passwords do not match');
             $this->view->user = $user;
         } else {
             $user->save();
             $this->flash('notice', 'User updated successfully');
             $this->_redirector->gotoRoute(array('action' => 'index', 'id' => null));
         }
     } else {
         $this->view->user = $user;
     }
 }