Icy Phoenix

Hi to you all. How long... don't worry, I have notifications active and I am always up to date on what's new in here ;)


I need some help with database structure.
When a user logs in, his ip is logged and when he posts something, too.

- the user logs in
- he reads and replys to some topic
- he logs out.

During these 3 easy steps a lot of informations about him (ip, browser and so on) are stored. Specifically, I am interested on the ip.

Let's suppose I want to log in, post and log out, erasing time by time my registered ips. Where do I have to go to find this records and delete them?

I thought about:

table_posts
table_users
table_logins

Anything else?

If you send PM or add album pictures, or KB articles, then you may want to have a look at some extra tables as well.

You should also check ctracker_login_history table if you have that feature enabled.

I can't think on anything else... :roll:

You can use this icy ip encoder system powered:

http://www.icyphoenix.es/encode_decode.php

You can see your own's ip/reversed IP/icy encoded IP at the bold zones.

For others ips, you type/paste into the text box and click "decodificar IP" (decode IP)/"encode IP" (codificar IP)/"Resolver IP" (Resolve-Traceback IP) 8) 8)

Just search the encoded IP you want in the whole DB.

PS: @MG: We could make something like that for this page...

NOTE: DO NOT EVER change a IP adress for the encoded 255.255.255.255. It is the not-limited broadcast, which means it is used to contact all others IP adresses at once automaticly. Most times it is blocked by the hosts, but others do not and will take so many time and bandwith to load