167 |
|
|
168 |
// Update the request count in the "hits" table: |
// Update the request count in the "hits" table: |
169 |
|
|
170 |
$sql = "UPDATE hits SET requestcount=requestcount+1 WHERE id='" . $common_sessiondata['hit_id'] . "';"; |
$sql = "UPDATE hits SET requestcount=requestcount+1, lastrequest=NOW() WHERE id='" . $common_sessiondata['hit_id'] . "';"; |
171 |
|
|
172 |
common_dbc_query($sql); |
common_dbc_query($sql); |
173 |
|
|
216 |
$common_sessiondata['user_auth']['logincount'] = $logincount; |
$common_sessiondata['user_auth']['logincount'] = $logincount; |
217 |
$common_sessiondata['user_auth']['logintime'] = $logintime; |
$common_sessiondata['user_auth']['logintime'] = $logintime; |
218 |
|
|
219 |
|
// Protocol the login: |
220 |
|
common_protocollogin(); |
221 |
|
|
222 |
$sql = "UPDATE users SET logincount='$logincount', lastlogin=FROM_UNIXTIME('$logintime') WHERE id='$userid';"; |
$sql = "UPDATE users SET logincount='$logincount', lastlogin=FROM_UNIXTIME('$logintime') WHERE id='$userid';"; |
223 |
|
|
224 |
$res = common_dbc_query($sql); |
$res = common_dbc_query($sql); |
242 |
$unixtime = $common_sessiondata['birthtime']; |
$unixtime = $common_sessiondata['birthtime']; |
243 |
$useragent = $_SERVER['HTTP_USER_AGENT']; |
$useragent = $_SERVER['HTTP_USER_AGENT']; |
244 |
|
|
245 |
$sql = "INSERT INTO hits (id, timestamp, address, entryurl, referer, sessionid, useragent, requestcount) VALUES (NULL, FROM_UNIXTIME('$unixtime'), '$address', '$entryurl', '$referer', '$sessionid', '$useragent', '1');"; |
$sql = "INSERT INTO hits (id, timestamp, address, entryurl, referer, sessionid, useragent, requestcount, lastrequest) VALUES (NULL, FROM_UNIXTIME('$unixtime'), '$address', '$entryurl', '$referer', '$sessionid', '$useragent', '1', FROM_UNIXTIME('$unixtime'));"; |
246 |
|
|
247 |
$res = common_dbc_query($sql); |
$res = common_dbc_query($sql); |
248 |
|
|
252 |
|
|
253 |
} |
} |
254 |
|
|
255 |
|
function common_protocollogin() { |
256 |
|
|
257 |
|
global $common_sessiondata; |
258 |
|
|
259 |
|
$hitid = $common_sessiondata['hit_id']; |
260 |
|
$sessionid = session_id(); |
261 |
|
$logintime = $common_sessiondata['user_auth']['logintime']; |
262 |
|
$userid = $common_sessiondata['user_auth']['id']; |
263 |
|
|
264 |
|
$sql = "INSERT INTO logins (id, timestamp, user_id, sessionid, hit_id) VALUES (NULL, FROM_UNIXTIME('$logintime'), '$userid', '$sessionid', '$hitid');"; |
265 |
|
|
266 |
|
$res = common_dbc_query($sql); |
267 |
|
|
268 |
|
if(!$res) return false; |
269 |
|
|
270 |
|
return true; |
271 |
|
|
272 |
|
} |
273 |
|
|
274 |
//---------------------------------------------------------- |
//---------------------------------------------------------- |
275 |
//- Database functions: |
//- Database functions: |
276 |
|
|