SESSION & IP

[eluser]bogdan3l[/eluser]
Hello!

I use the ci session library with my database, but, i don't like the ip to be varchar(16).

Could somebody help me to change the ci session library to store the ip as INT 11?

I tried with ip2long but i am afraid not to spoil something !

I appreciate any help, thanks a lot.

Bye!

[eluser]Sbioko[/eluser]
You can easily change this in PHPMyAdmin :-)

[eluser]bogdan3l[/eluser]
I've done that but i want to change the ci session library too.

The default library store the ip exactly how it is (80.200.125.30) and i want the ip to be stored like (1355316510) => ip2long.

And i need some help to change the library and i don't want to mess things up .

[eluser]Sbioko[/eluser]
You can extend this library using MY_ prefix or prefix you specified in config.php file.

[eluser]bogdan3l[/eluser]
Can you give me an example or something?

I appreciate. Thanks!

[eluser]rogierb[/eluser]
Don't forget about ipv6...

[eluser]Sbioko[/eluser]
You need to alter yout table.

Code:

ALTER TABLE `ci_sessions` MODIFY `ip` NOT_NULL INT(11);

Something like this.