public static function register($login, $password)
{
$sql = 'SELECT * FROM main WHERE login = :login';
$result = User::sql_inner($sql, $login);
$user = $result->fetch();
if ($user) {
echo "Данный Login уже используется. ";
return false;
} else {
$sql = 'INSERT INTO main (login, password)
VALUES (:login, :password)';
$result = User::sql_inner($sql, $login, $password);
User::create_dir($login);
return $result;
}
}
public static function register($forms)
{
$sql = "SELECT * FROM users WHERE login = :login";
array_unshift($forms, $sql);
array_pop($forms);
$result = User::sql_inner($forms);
$user = $result->fetch();
if ($user) {
return false;
} else {
$sql = "INSERT INTO users (login, password, first_name, last_name, surname, index, address)\n VALUES (:login, :password, :first_name, :last_name, :surname, :index, :address)";
array_shift($forms);
array_unshift($forms, $sql);
$_SESSION['forms'] = $forms;
$result = User::sql_inner($forms);
return $result;
}
}
public static function change($login, $password, $first_name, $last_name)
{
$sql = "SELECT * FROM users WHERE login = :login";
$result = User::sql_inner($login, $sql);
$id = $_SESSION['id'];
$user = $result->fetch();
if ($user) {
if ($_SESSION['user'] == $user["login"]) {
$sql = "UPDATE users SET login=:login, password=:password, first_name=:first_name, last_name=:last_name WHERE id={$id}";
$result = User::sql_inner($login, $sql, $password, $first_name, $last_name);
return $result;
}
return false;
} else {
$sql = "UPDATE users SET login=:login, password=:password, first_name=:first_name, last_name=:last_name WHERE id={$id}";
$result = User::sql_inner($login, $sql, $password, $first_name, $last_name);
return $result;
}
}