1
|
<?php
|
2
|
if(!isset($_COOKIE['username']))
|
3
|
{
|
4
|
$loggedflag=0;
|
5
|
|
6
|
if(isset($_REQUEST['loginbt']))
|
7
|
{
|
8
|
include_once('sql_connection2.php');
|
9
|
|
10
|
if(isset($ConnectionFlag))
|
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']))
|
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));
|
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)
|
42
|
{
|
43
|
$data=mysqli_fetch_array($searchdata);
|
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']))
|
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
|
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
|
?>
|