public function subscribe() { $user = Input::get('user'); $password = Input::get('password'); $name = Input::get('name'); $email = Input::get('email'); $address = Input::get('address'); $gender = Input::get('gender'); $result = User::query()->where('user', '=', $user)->first(); if (!is_null($result)) { return Response::redirect('/login?error=subscribe'); } User::insert(array('user' => $user, 'password' => md5($password), 'name' => $name, 'email' => $email, 'address' => $address, 'gender' => $gender)); return Response::redirect('/login'); }
`user` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `password` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `name` varchar(80) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `address` varchar(150) COLLATE utf8_unicode_ci NOT NULL, `gender` varchar(10) COLLATE utf8_unicode_ci NOT NULL, `admin` tinyint(1) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_user` (`user`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci', 'CREATE TABLE IF NOT EXISTS `news`( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(500) COLLATE utf8_unicode_ci NOT NULL, `body` text COLLATE utf8_unicode_ci NOT NULL, `image` tinyint(1) NOT NULL, `section` varchar(20) NOT NULL, `created` timestamp DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci', 'CREATE TABLE IF NOT EXISTS `comments`( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `newsId` int(10) unsigned NOT NULL, `userId` int(10) unsigned NOT NULL, `comment` text COLLATE utf8_unicode_ci NOT NULL, `created` timestamp DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci'); foreach ($queries as $value) { $statement = Connection::prepare($value); $statement->execute(); } User::insert(array('user' => 'admin', 'password' => md5('admin'), 'name' => 'admin', 'email' => '*****@*****.**', 'address' => 'admin', 'gender' => 'man', 'admin' => 1)); Connection::disconnect();
public function run() { DB::statement('SET FOREIGN_KEY_CHECKS=0;'); DB::table('user')->truncate(); DB::table('role')->truncate(); DB::table('role_user')->truncate(); DB::table('event')->truncate(); DB::table('exp_level')->truncate(); DB::statement('SET FOREIGN_KEY_CHECKS=1;'); $faker = Factory::create(); $uQ = new User(); $uQ->login = '******'; $uQ->pseudo = 'QsAnakrose'; $uQ->password = Hash::make('quentin'); $uQ->email = '*****@*****.**'; $uQ->streaming = 1; $uQ->twitch_channel = 'riotgames'; $uQ->save(); $data = []; for ($i = 0; $i < 110; $i++) { $username = $faker->unique()->username; $data[] = ['login' => $username, 'pseudo' => $username, 'email' => $faker->unique()->freeEmail, 'password' => Hash::make($username)]; } User::insert($data); $this->command->info('Users created'); $admin = new Role(); $admin->title = 'admin'; $admin->save(); $streamer = new Role(); $streamer->title = 'streamer'; $streamer->save(); $this->command->info('Roles created'); $uQ->becomeAdmin(); $uQ->becomeStreamer(); for ($i = 2; $i < 13; $i++) { $u = User::find($i); $u->becomeStreamer(); $u->twitch_channel = $i; $u->description = $u->login . 'lorem ipsum dolor. Lol.'; $rand = rand(0, 2); if ($rand == 0) { $u->streaming = 1; } else { $u->streaming = 0; } /* $avatarManager = new AvatarManager(); $intervManager = $avatarManager->getImgManager(); $width = $avatarManager->getAvatarWidth(); $color = substr(md5(rand()), 0, 6); $intervManager->canvas($width, $width, $color); */ $u->save(); } $su = new StreamingUserService(); $su->update(); $this->command->info('Roles attached'); $event = new Event(); $event->title = 'Hugo'; $event->start = '2015-06-26T12:30:00+02:00'; $event->end = '2015-06-26T15:30:00+02:00'; $event->allDay = 'false'; $event->color = '#FF0000'; $event->timezone = '+02:00'; $event->save(); $this->command->info('Test event created'); $expManager = new ExperienceManager(); $data = $expManager->generateExperienceSystem(); ExpLevel::insert($data); $this->command->info('Experience system initialized'); }