CI session and session ID

[eluser]haXis[/eluser]
Hello,

I have a cart database table with session column which represent the CI session_id.

My question is - is there any way how to recognize that the session_id changed?

Debug session action:

Code:

SELECT *
FROM (`tc_ci_sessions`)
WHERE `session_id` = '99c86bd7597f7e463750ab94dbadb9dc'
AND `user_agent` = 'Opera/9.80 (Windows NT 6.1; U; cs) Presto/2.5.22 V'  

UPDATE `tc_ci_sessions` SET `last_activity` = 1267785550, `session_id` = 'd99c65b60773945ee125bd112e84903a' WHERE session_id = '99c86bd7597f7e463750ab94dbadb9dc'

Without changing the session ID in a cart I loose him and I dont want that before 7200 seconds.

[eluser]haXis[/eluser]
I did a little research in code and I think the best solution is add an extra db query in the Session library.

After

Code:

$this->CI->db->query($this->CI->db->update_string($this->sess_table_name, array('last_activity' => $this->now, 'session_id' => $new_sessid), array('session_id' => $old_sessid)));

Add

Code:

$this->CI->db->query($this->CI->db->update_string('my_table', array('session_id' => $new_sessid), array('session_id' => $old_sessid)));

Hope that helps anyone else with similar problems.

Another suggestions are welcomed.