/**
* Run Method.
*/
public function run()
{
User::connection()->query('SET FOREIGN_KEY_CHECKS = 0');
$data = [];
$genders = ['male', 'female'];
$logins = ['admin', 'moder', 'user', 'guest', 'banned'];
$faker = Faker\Factory::create('ru_RU');
foreach ($logins as $login) {
$gender = $genders[array_rand($genders)];
$data[] = ['login' => $login, 'password' => password_hash($login, PASSWORD_BCRYPT), 'email' => $faker->freeEmail, 'gender' => $gender, 'level' => $login, 'name' => $faker->firstName($gender), 'country' => $faker->country, 'city' => $faker->city, 'info' => $faker->realText(rand(30, 100)), 'phone' => $faker->phoneNumber, 'birthday' => $faker->date('d-m-Y'), 'created_at' => $faker->dateTimeBetween('-3 year')->format('Y-m-d H:i:s')];
}
User::connection()->query('TRUNCATE users');
$table = $this->table('users');
$table->insert($data)->save();
Forum::connection()->query('SET FOREIGN_KEY_CHECKS = 1');
}
<?php
session_start();
require_once '../dbFunction.php';
$connect = new User();
if ($connect->isNotEmpty($_POST) == true) {
$_SESSION['pseudo'] = $_POST['login'];
$connect->connection($_POST['login'], $_POST['password']);
}
public static function SetConnection(mysqli $newConnection)
{
User::$connection = $newConnection;
}
function get_ranking()
{
$query = "\n SELECT u.*, count(a.id) as score\n FROM users u\n LEFT JOIN achievements a ON a.winner_id = u.id\n GROUP BY u.id\n ORDER BY score DESC, login ASC;";
return User::connection()->query($query);
}
public static function SetConnection(mysqli $newConnection)
{
//z duzej litery funkcja bo jest statyczna
User::$connection = $newConnection;
}
