[eluser]davidinchi[/eluser]
Hi again,
More info:
I write a select in the last line of CodeIgniter.php:
CodeIgniter.php
Code:
/*
* ------------------------------------------------------
* Close the DB connection if one exists
* ------------------------------------------------------
*/
log_message('debug', '**CodeIgniter $CI->session->userdata '.serialize($CI->session->userdata));
//select for debug
$sql_select = array('user_data');
$query = $CI->db->select($sql_select)
->where('session_id', $CI->session->userdata['session_id'])
->limit(1)
->get('ci_sessions');
$result = $query->row();
if ($query->num_rows() !== 1)
{
log_message('debug', '**CodeIgniter.php SELECT with NO results');
//return FALSE;
}
else {
$db_user_data = $result->{'user_data'};
log_message('debug', '**CodeIgniter.php SELECT result $db_user_data : '.$db_user_data);
}
if (class_exists('CI_DB') AND isset($CI->db))
{
$CI->db->close();
}
/* End of file CodeIgniter.php */
/* Location: ./system/core/CodeIgniter.php */
log debug:
Code:
DEBUG - 2012-11-06 20:56:43 --> File loaded: application/views/pages/home.php
DEBUG - 2012-11-06 20:56:43 --> Final output sent to browser
DEBUG - 2012-11-06 20:56:43 --> Total execution time: 0.0723
DEBUG - 2012-11-06 20:56:43 --> **CodeIgniter $CI->session->userdata a:7:{s:10:"session_id";s:32:"2fab71fddad97ff2337e1f9705b088fc";s:10:"ip_address";s:14:"87.223.230.193";s:10:"user_agent";s:106:"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.94 Safari/537.4";s:13:"last_activity";i:1352231790;s:9:"user_data";s:0:"";s:10:"flexi_auth";a:7:{s:15:"user_identifier";s:26:"[email protected]";s:7:"user_id";s:2:"51";s:5:"admin";b:0;s:5:"group";a:1:{i:1;s:6:"Public";}s:10:"privileges";a:0:{}s:22:"logged_in_via_password";b:1;s:19:"login_session_token";s:40:"1dadbfcfa0d5b5db34413beba499691b5aa59eb9";}s:17:"flash:old:message";s:61:"<p class="status_msg">Has iniciado sesión correctamente.</p>";}
DEBUG - 2012-11-06 20:56:43 --> **mysql_driver _EXECUTE(...) sql = SELECT `user_data`
FROM (`ci_sessions`)
WHERE `session_id` = '2fab71fddad97ff2337e1f9705b088fc'
LIMIT 1
DEBUG - 2012-11-06 20:56:43 --> **CodeIgniter.php SELECT result $db_user_data : a:3:{s:9:"user_data";s:0:"";s:10:"flexi_auth";a:7:{s:15:"user_identifier";s:26:"[email protected]";s:7:"user_id";s:2:"51";s:5:"admin";b:0;s:5:"group";a:1:{i:1;s:6:"Public";}s:10:"privileges";a:0:{}s:22:"logged_in_via_password";b:1;s:19:"login_session_token";s:40:"1dadbfcfa0d5b5db34413beba499691b5aa59eb9";}s:17:"flash:old:message";s:61:"<p class="status_msg">Has iniciado sesión correctamente.</p>";}
But in Database... USER_DATA hasn't that info !!!
Code:
session_id = '2fab71fddad97ff2337e1f9705b088fc',
ip_address = '87.223.230.193',
user_agent = 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.94 Safari/537.4',
last_activity = '1352231790',
user_data = 'a:1:{s:9:"user_data";s:0:"";}',
prevent_update = '0'