Commit | Line | Data |
---|---|---|
51ff3226 | 1 | <?php |
2 | function login() { | |
51ff3226 | 3 | |
4 | global $db,$error,$node_id; | |
5 | $login = mysql_real_escape_string($_POST['login']); | |
46c0767c | 6 | $password = $_POST['password']; // Not SQLi but be carefull |
1ca26066 H |
7 | $password_hash_algos=array('sha256','sha1','md5'); //List of supported algos can be obtained using: php -r 'print_r(hash_algos());' |
8 | ||
9 | $hash_query='('; | |
10 | foreach($password_hash_algos as $algo) { | |
11 | $hash_query.="password='".hash($algo, $password)."' OR "; | |
12 | } | |
13 | $hash_query.='false )'; | |
14 | ||
51ff3226 | 15 | $login_type = $_POST['login_type']; |
16 | $referer = $_SERVER['HTTP_REFERER']; | |
17 | ||
18 | if (!session_id()) { | |
19 | $error='asi nemas zapnute cookies alebo co'; | |
20 | return false; | |
21 | } | |
22 | ||
95712c2e H |
23 | switch ($login_type) { |
24 | case "name": | |
25 | $q = "select * from users where login='$login' and $hash_query"; | |
26 | break; | |
27 | case "base36id": | |
28 | $login = base_convert($login, 36, 10); | |
29 | case "id": | |
30 | $login=intval($login); //HA! if it is number, escape_string is not enough | |
31 | $q="select * from users where user_id='$login' and $hash_query"; | |
32 | break; | |
33 | } | |
46c0767c | 34 | |
95712c2e H |
35 | $set = $db->query($q); |
36 | $set->next(); | |
37 | $user_id = $set->getString('user_id'); | |
38 | $user_name = $set->getString('login'); | |
51ff3226 | 39 | |
41bddecc | 40 | if (!$set) { //XXX test |
51ff3226 | 41 | $error="Zadal si nespravne uzivatelske meno [alebo id] alebo heslo. Rob so sebou nieco"; |
42 | return false; | |
43 | } | |
44 | elseif ($set->getString('header_id') == 2091520) { | |
45 | $error='Tvoja registracia este nebola schvalena.'; | |
46 | return false; | |
47 | } | |
48 | else { | |
49 | $now=date("Y-m-d H:i:s"); | |
50 | $lockout=$set->getString('acc_lockout'); | |
51 | if ($lockout >= $now ) { | |
52 | global $error; | |
53 | $error="Account lockout mas aktivny. Sorry ale neprihlasis sa minimalne do $lockout. | |
54 | Prajem prijemnu odvykacku:-)"; | |
55 | return false; | |
56 | } | |
57 | ||
1e66e7ac | 58 | // Login sucessfull |
51ff3226 | 59 | |
1e66e7ac | 60 | // prevent session fixation |
61 | session_regenerate_id(); | |
51ff3226 | 62 | |
51ff3226 | 63 | $cube_vector=$set->getString('cube_vector'); |
64 | ||
65 | // saves friends list as an array into user session | |
66 | $q="select distinct node_parent,node_name from nodes where node_creator='$user_id' and | |
67 | external_link='session://friend' order by node_parent"; | |
68 | $friendset=$db->query($q); | |
69 | while ($friendset->next()){ | |
70 | $_SESSION['friends'][$friendset->getString('node_parent')]=true; | |
71 | } | |
72 | ||
73 | // saves bookmarks as an array into user session | |
74 | $q="select nodes.node_name,nodes.node_id from node_access left join nodes on node_access.node_id=nodes.node_id | |
75 | where node_access.user_id='$user_id' and node_bookmark='yes' order by node_name"; | |
76 | $bookmarkset=$db->query($q); | |
77 | while ($bookmarkset->next()){ | |
78 | $_SESSION['bookmarks'][$bookmarkset->getString('node_id')]=$bookmarkset->getString('node_name'); | |
79 | } | |
80 | ||
81 | //saves ignored users as an array into user session | |
82 | $q="select node_parent from nodes where node_creator='$user_id' and external_link='session://ignore'"; | |
83 | $ignoreset=$db->query($q); | |
84 | while ($ignoreset->next()){ | |
85 | $_SESSION['ignore'][$ignoreset->getString('node_parent')]=true; | |
86 | } | |
87 | ||
88 | //saves fooked forums as an array into user session | |
89 | $q="select node_parent from nodes where node_creator='$user_id' and external_link='session://fook'"; | |
90 | $fookset=$db->query($q); | |
91 | while ($fookset->next()){ | |
92 | $_SESSION['fook'][$fookset->getString('node_parent')]=true; | |
93 | } | |
94 | ||
51ff3226 | 95 | |
96 | //save bookstyle into user session | |
97 | $q="select node_content from nodes where node_parent=19 and external_link='session://bookstyl' and node_creator='$user_id'"; | |
98 | $bookstylset=$db->query($q); | |
99 | $bookstylset->next(); | |
100 | $_SESSION['bookstyl'] = $bookstylset->getString('node_content'); | |
101 | ||
102 | // mood | |
103 | $mset = $db->query(sprintf('select moods from users where user_id = %d', $user_id)); | |
104 | $mset->next(); | |
105 | $moods_expl = explode(";",$set->getString('moods')); | |
106 | if (!empty($moods_expl[count($moods_expl)-1])) { | |
107 | $_SESSION['mood_id'] = $moods_expl[count($moods_expl)-1]; | |
108 | $mset = $db->query(sprintf('select node_name, node_content from nodes where node_id = %d', $moods_expl[count($moods_expl)-1])); | |
109 | $mset->next(); | |
110 | $_SESSION['mood_name'] = $mset->getString('node_name'); | |
111 | $_SESSION['mood_content'] = addslashes(substr(strip_tags($mset->getString('node_content')),0,223)); | |
112 | } | |
51ff3226 | 113 | // last login |
fe69da5f | 114 | |
115 | $db->query(sprintf('update users set date_last_login = NOW() where user_id = %d', $user_id)); | |
51ff3226 | 116 | |
117 | $_SESSION['user_id']=$user_id; | |
118 | $_SESSION['user_name']=addslashes($user_name); | |
a47460db H |
119 | setcookie('jabber_login', strtolower($user_name), time()+60*60*24*10, '/'); //10days on whole domain - should have persistent username in future... |
120 | setcookie('jabber_password', hash('md5', 'jabber:'.$_POST['password']), time()+60*60*24*10, '/'); //10days on whole domain | |
51ff3226 | 121 | if (!empty($cube_vector)) $_SESSION['cube_vector']=$cube_vector; |
122 | if (empty($_SESSION['template_set'])) $_SESSION['template_set']=$set->getString('template_set'); | |
123 | if (is_numeric($_POST['screen_width'])) $_SESSION['browser']['screen_width']=$_POST['screen_width']; | |
124 | if (is_numeric($_POST['screen_height'])) $_SESSION['browser']['screen_height']=$_POST['screen_height']; | |
125 | $_SESSION['listing_amount']=$set->getString('listing_amount'); | |
126 | $_SESSION['listing_order']=$set->getString('listing_order'); | |
127 | $_SESSION['header_id']=$set->getString('header_id'); | |
128 | } | |
129 | // header("Location: $referer"); | |
130 | return true; | |
131 | } | |
e909f81b | 132 | ?> |