How best to store names and IP addresses in SQLite?
#1

I'm wanting to store all players IP addresses when they connect to my server.

That way if I suspect someone is ban evading, i can check the IP address or IP range.

So for example, i may want to make a command in IRC which i would do !check playername

That would give me all the ip addresses that the player has used.

Or i may want to write !ipcheck 127.0.0.1

Then get all the players names displayed who have connected with the specified IP or IP range.

I'm just not really sure on the best way to store the data.

Woulds it be to create a new table per name? or per IP?

Or create a colum of names, then colums for every new IP?
Reply


Messages In This Thread
How best to store names and IP addresses in SQLite? - by Outbreak - 08.12.2009, 19:32
Re: How best to store names and IP addresses in SQLite? - by Dabombber - 09.12.2009, 06:20

Forum Jump:


Users browsing this thread: 2 Guest(s)