login-validation.php

 
1
<?php
2
if(!isset($_COOKIE['username'])) //an den exei kanei login
3
{
4
  $loggedflag=0;
5
  
6
  if(isset($_REQUEST['loginbt'])) //an exei kanei submit sth forma login
7
  {
8
        include_once('sql_connection2.php');
9
        
10
        if(isset($ConnectionFlag)) //$ConnectionFlag arxeikopoieite sthn sql_connection.php h sql_connection2.php
11
        {
12
                if($ConnectionFlag == false)
13
                {
14
                        $problem=connectdb2();
15
                        $sideConnectionFlag = true;
16
                }
17
                else $sideConnectionFlag = false;
18
        }
19
        else if(!isset($ConnectionFlag))
20
        {
21
                $problem=connectdb2();
22
                $sideConnectionFlag = true;
23
        }
24
        
25
        if(empty($problem))
26
        {
27
                if(trim($_REQUEST['user']))
28
                {
29
                        if(trim($_REQUEST['pass'])) //an exei dwsei onoma kai kodiko
30
                        {
31
                                if(!empty($_REQUEST['keeplogged'])) $keeplogged=1;
32
                                else $keeplogged=0;
33
                                
34
                                $username=trim($_REQUEST['user']);
35
                                $password=trim($_REQUEST['pass']);
36
                                $username=mysqli_real_escape_string($con,$username);
37
                                $password=sha1(mysqli_real_escape_string($con,$password)); //vazw hash sha1 gia na sygrinw me th vash
38
                                
39
                                $searchdata=mysqli_query($con,"SELECT usersID, username, userRights, avatar FROM users WHERE (username='$username' AND password='$password') AND active=TRUE") ; 
40
                                
41
                                if(mysqli_num_rows($searchdata)==1) //an yparxei taftish
42
                                {
43
                                        $data=mysqli_fetch_array($searchdata); // dhmiourgo pinaka me ta dedomena pou peira apo thn vash
44
                                        
45
                                        if($keeplogged==1) 
46
                                        {
47
                                                setcookie('usersID',$data['usersID'],time()+60*60*24*365);
48
                                                setcookie('username',$data['username'],time()+60*60*24*365);
49
                                                setcookie('userRights',$data['userRights'],time()+60*60*24*365);
50
                                                setcookie('avatar',$data['avatar'],time()+60*60*24*365);
51
                                                setcookie('time',1,time()+60*60*24*365);
52
                                        }
53
                                        else 
54
                                        {
55
                                                setcookie('usersID',$data['usersID'],time()+60*10);
56
                                                setcookie('username',$data['username'],time()+60*10);
57
                                                setcookie('userRights',$data['userRights'],time()+60*10);
58
                                                setcookie('avatar',$data['avatar'],time()+60*10);
59
                                                setcookie('time',0,time()+60*10);
60
                                                
61
                                        }
62
                                        $loggedflag=1;
63
                                        $cookiecontentusername=$data['username'];
64
                                        $cookiecontentuserrights=$data['userRights'];
65
                                        $cookiecontentavatar=$data['avatar'];
66
                                        
67
                                }
68
                                else
69
                                {
70
                                        $login_message = 'Wrong Username or Password. Please fill your Username and your Password properly and try again to login.';
71
                                }                                
72
                        }
73
                        else
74
                        {
75
                                 $login_message = 'Empty Username or Password. Please fill your Username and your Password properly and try again to login.';
76
                        }
77
                }
78
                else
79
                {
80
                        $login_message = 'Empty Username or Password. Please fill your Username and your Password properly and try again to login.';
81
                }
82
        }
83
        
84
        if($sideConnectionFlag == true) closedb2($con);
85
  }
86
}
87
else if(isset($_REQUEST['logout'])) //an exei kanei logout
88
{
89
        $loggedflag=0;
90
        setcookie('usersID','',time()-60*60*24*365);
91
        setcookie('username','',time()-60*60*24*365);
92
        setcookie('userRights','',time()-60*60*24*365);
93
        setcookie('avatar','',time()-60*60*24*365);
94
}
95
else //an exei kanei login... ananeono kai to cookie, an den exei kanei check to keep me logged in.
96
{
97
        
98
        $loggedflag=1;
99
        
100
        if($_COOKIE['time']==0)
101
        {
102
                setcookie('usersID',$_COOKIE['usersID'],time()+60*10);
103
                setcookie('username',$_COOKIE['username'],time()+60*10);
104
                setcookie('userRights',$_COOKIE['userRights'],time()+60*10);
105
                setcookie('avatar',$_COOKIE['avatar'],time()+60*10);
106
                setcookie('time',0,time()+60*10);
107
        }
108
        
109
        $cookiecontentusername=$_COOKIE['username'];
110
        $cookiecontentuserrights=$_COOKIE['userRights'];
111
        if(!isset($cookiedebug)) $cookiecontentavatar=$_COOKIE['avatar'];
112
}
113
?>