/**
* Create and save a new user.
*
* @param array
*/
public function create()
{
// Validate input
$params = array('username' => $this->app->request->post('username'), 'email_address' => $this->app->request->post('email_address'), 'password_hash' => Password::hash($this->app->request->post('password')));
$user = new User($params);
$user->save();
$this->app->redirectTo('home');
}
public function dologin()
{
$username = $this->app->request->post('username');
$password = $this->app->request->post('password');
$user = User::find($username);
if ($user && Password::verify($password, $user->password_hash)) {
$this->user = $user;
$_SESSION['username'] = $user;
return $this->app->redirectTo('home');
}
$this->app->flash('error', 'Login failed');
$this->app->redirectTo('auth@login');
}
/**
* Preload data into the database.
*
* @return bool
*/
public static function loadData()
{
return self::statement("INSERT INTO users (username, email_address, password_hash)\n VALUES ('admin', '*****@*****.**', '" . \App\Controller\Password::hash('admin123') . "')") && self::statement("INSERT INTO users (username, email_address, password_hash)\n VALUES ('john.doe', '*****@*****.**', '" . \App\Controller\Password::hash('johndoe') . "')") && self::statement("INSERT INTO users (username, email_address, password_hash)\n VALUES ('someuser34', '*****@*****.**', '" . \App\Controller\Password::hash('mypassword') . "')") && self::statement("INSERT INTO media_files VALUES\n ('b91e08416f0e16f724115f0f7cf1706f', '.jpg', '116305', '717', '960'),\n ('ab8d14e504fe8f75236c530de61be914', '.jpg', '123454', '685', '960'),\n ('7b7eeecb3398ede8f67a70b23d20f22d', '.jpg', '677333', '756', '960'),\n ('a88cfee8e29bc2f6012b4d7dee6c1399', '.jpg', '765424', '1024', '768'),\n ('d03d766134057d9186b4d370eaccf56b', '.jpg', '685466', '640', '800'),\n ('80fb7f3f49fa42e70aea7477603d855d', '.jpg', '867431', '567', '660'),\n ('2d51520fdd306e5741dcb86b8465ae37', '.jpg', '743745', '277', '630'),\n ('f7b0dad17d31e5f056fb1829c136753e', '.mp4', '245754321', '1080', '720'),\n ('3695df1af0b7f08f08f48b230ef411f5', '.flv', '116330544', '640', '800'),\n ('0188d372fcf6d09fcc84b725d41b662d', '.wmv', '13993509', '1024', '768')\n ") && self::statement("INSERT INTO media_instances (username, content_hash, name, description) VALUES\n ('john.doe', 'b91e08416f0e16f724115f0f7cf1706f','01','Vacation photo 01'),\n ('john.doe', 'ab8d14e504fe8f75236c530de61be914','02','Vacation photo 02'),\n ('john.doe', '7b7eeecb3398ede8f67a70b23d20f22d','03','Vacation photo 03'),\n ('someuser34', 'a88cfee8e29bc2f6012b4d7dee6c1399','#1','Christmas photo 1'),\n ('someuser34', 'd03d766134057d9186b4d370eaccf56b','#2','Christmas photo 2'),\n ('someuser34', '80fb7f3f49fa42e70aea7477603d855d','#3','Christmas photo 3'),\n ('someuser34', '2d51520fdd306e5741dcb86b8465ae37','#4','Christmas photo 4'),\n ('someuser34', 'f7b0dad17d31e5f056fb1829c136753e','Vid 1','Christmas video part 1'),\n ('someuser34', '3695df1af0b7f08f08f48b230ef411f5','Vid 2','christmas video part 2'),\n ('john.doe', '0188d372fcf6d09fcc84b725d41b662d','04','video of 2014 vacation')\n ") && self::statement("INSERT INTO tags (name, username) VALUES\n ('vacation 2014','john.doe'),\n ('christmas 08','someuser34')\n ") && self::statement("INSERT INTO categories (name, username) VALUES\n ('Photos', 'john.doe'),\n ('Videos', 'john.doe'),\n ('Misc', 'someuser34'),\n ('Uncategorized', 'someuser34'),\n ('Uncategorized', 'john.doe')\n ") && self::statement("INSERT INTO tags_media_instances (media_instance_id, tag_name, username) VALUES\n (1, 'vacation 2014', 'john.doe'),\n (2, 'vacation 2014', 'john.doe'),\n (3, 'vacation 2014', 'john.doe'),\n (4, 'christmas 08', 'someuser34'),\n (5, 'christmas 08', 'someuser34'),\n (6, 'christmas 08', 'someuser34'),\n (7, 'christmas 08', 'someuser34'),\n (8, 'christmas 08', 'someuser34'),\n (9, 'christmas 08', 'someuser34'),\n (10, 'vacation 2014', 'john.doe')\n ") && self::statement("INSERT INTO categories_media_instances (media_instance_id, category_name, username) VALUES\n (1, 'Photos', 'john.doe'),\n (2, 'Photos', 'john.doe'),\n (3, 'Photos', 'john.doe'),\n (4, 'Misc', 'someuser34'),\n (5, 'Misc', 'someuser34'),\n (6, 'Misc', 'someuser34'),\n (7, 'Misc', 'someuser34'),\n (8, 'Misc', 'someuser34'),\n (9, 'Misc', 'someuser34'),\n (10, 'Videos', 'john.doe')\n ");
}
}
}
$app->flash('columns', $columns);
$app->flash('rows', $result);
$app->redirectTo('Menu@PickAQuery');
});
$app->get('/create-user', function () use($app) {
$app->render('create_user.html', array('page' => 'CreateUser'));
})->name('Menu@CreateUser');
$app->post('/create-user', function () use($app) {
$username = trim($app->request->post('username'));
if ('' == $username) {
$app->flash('error', "Username cannot be blank.");
$app->redirectTo('Menu@CreateUser');
}
$password = \App\Controller\Password::hash($app->request->post('password'));
$email_address = $app->request->post('email_address');
$result = DB::statement("INSERT INTO users (username, password_hash, email_address) VALUES ('{$username}', '{$password}', '{$email_address}')");
if (!$result) {
$app->flash('error', mysql_error());
} else {
$app->flash('success', "New User {$username} Created!");
}
$app->flash('username', $username);
$app->flash('email_address', $email_address);
$app->redirectTo('Menu@CreateUser');
});
$app->get('/freeform', function () use($app) {
return $app->render('freeform_select.html', array('page' => 'FreeformSelect'));
})->name('Menu@FreeformSelect');
$app->post('/freeform/run', function () use($app) {
