Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //session_start();
- include 'dbConnect.php';
- function loginaction(){
- include 'dbConnect.php';
- $time = time();
- if(isset($_REQUEST['login'])){
- $key = $_GET['telegram_key'];
- $query = $db->prepare("SELECT operators.operator_id, telegramlog.telegram_key FROM
- telegramlog LEFT JOIN operators ON telegramlog.operator_id = operators.operator_id WHERE telegramlog.telegram_key = ?, key_time = ? ;");
- $query->execute(array($key,$time));
- $result = $query->fetchAll();
- if(isset($_REQUEST['error'])){
- $error= $_REQUEST['error'];
- echo errorDefine($err);
- }
- statements ();
- }
- else if (isset($_REQUEST['loginnorm'])){
- $username=$_REQUEST['user'];
- $password=$_REQUEST['pass'];
- if(isset($_REQUEST['error'])){
- $error= $_REQUEST['error'];
- echo errorDefine($err);
- }
- $squery = $db->prepare("SELECT * FROM operators WHERE email = ? and heslo = ?;");
- $sResult = $squery->execute(array($username,$password));
- statements();
- }
- else if($_SERVER['REQUEST_METHOD'] == 'POST'){
- if(isset($_GET['token'])) {
- if ($_GET['token'] == "yes") {
- $newtoken = generateRandomString();
- $time = time() + (0 * 0 * 0 * 60);
- $pquery= $db ->prepare ("UPDATE telegramlog SET telegram_key = ? and key_time = ? WHERE telegram_key = ? ;");
- $presult = $pquery ->execute (array($newtoken, $time,$key));
- }
- }
- }
- function generateRandomString($length) {
- $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
- $charactersLength = strlen($characters);
- $randomString = '';
- for ($i = 0; $i < $length; $i++) {
- $randomString .= $characters[rand(0, $charactersLength - 1)];
- }
- return $randomString;
- }
- function errorDefine($err){
- if ($err=="1"){
- $deferr="Čas vypršel";
- }
- else if ($err=="2"){
- $deferr="Špatné příhlášení";
- }
- else if ($err=="3"){
- $deferr="Vyplňte všechna pole";
- }
- return $deferr;
- }
- function statements(){
- if($time > $row['key_time']){
- if($result){
- header('location: user.php');
- }
- }
- elseif($sResult){
- while($row = $squery ->fetch(PDO::FETCH_ASSOC)){
- echo '<script type="text/javascript">alert("You are logged in as user '. $row['users'] . '")</script>';
- if($row['users']=="a"){
- header('location: admin.php');
- }
- elseif($row['users']=="b"){
- header('location: leader.php');
- }
- elseif($row['users']=="c"){
- header('location: user.php');
- }
- else{
- header("location: function.php?error=2");
- }
- }
- }
- else if ($time < $row['key_time']) {
- header("location: function.php?error=1");
- }
- else if('empty'){
- header("location: function.php?error=3");
- }
- }
- //external
- //$error = errorDefine(2);
- // echo $error;
- //funkce se string bude volaná na jiné stránce
- //if isset get error
- }
- loginaction();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement