Need Direction on IP/user/ID database

We own several game servers and our servers record in game player connection data like IP, Player ID, name, and file check errors

I would like to tie this in with our forums IP search utility we got from you (or a new mod dont matter)

our main concern are the names, IDs and the IPs, the names change and the IPs change but the IDs usually do not

here is a bit of what our server records

Code:

now I'm pretty good and adding mods into our nuke and phpbb sites but to actually script the coding is another, I know phpmyadmin fairly well as well and do understand the basics of the souce code a little

I am planning on stripping the data above so it looks like this

Code:

and inserting it into the data base on our web server, iether in the forums db access threw the admin section or page seperate from every thing else

having a search function like 67.167.*.* (like the one used in IP search) is also what is throwing me off

I dont want you guys to write the program for me just walk me threw it's design so I get a better idea of php creation

I suposed information that is identical would need to be filtered out, but that would require more coding and tying up the web server when I can just re-insert the data every few weeks
the core data is 50 megs, the main data with IPs, IDs, Names would be about 5 megs or less

Quote:

To tie something like this in with IP Search, it would need to be in the forum's database. So that would probably be the best place to put it.

Quote:

The best thing I can tell you here is to take a look at how IP Search is coded to handle it. The key is to use an SQL query that uses a "LIKE" function for searching data.