 |
Dielantha
Beginner
Joined: 29 Nov 2002
Posts: 12
Location: USA
|
 Posted: Wed Jan 29, 2003 4:50 am
I need some help.
|
I wanna make a database to store characters sites. I'm an admin on a mud and this could come in handy.
The mud output is:
Gibson@4.46.173.22 has connected.
I want to take that information and store it in a simple database so I can look it up later. Also I just had a thought but dunno if this will be easy to do. Lets say I store Gibson but lets say his IP changes to
Gibson@4.46.173.25 has connected
is there a way to tell the database to store this new IP underneath the old one rather then having two database entries for Gibson. Does that make sense? Any help is appreciated.
Dielantha |
|
|
|
|
LightBulb
MASTER
Joined: 28 Nov 2000
Posts: 4817
Location: USA
|
Posted: Wed Jan 29, 2003 5:38 am
|
Assuming you've created a "characters" database with fields named "Name" and "URL".
#TR {^(%w)~@(%x) has connected.$} {#ADDKEY Connect Name {%1};#ADDKEY Connect URL {%2};#NEW All {@Connect}}
Checking for and amending previous entries is more involved. Perhaps someone else will feel like tackling it.
LightBulb
Senior Member |
|
|
|
|
tbone235
Apprentice
Joined: 02 Nov 2002
Posts: 107
Location: Australia
|
Posted: Wed Jan 29, 2003 7:38 am
|
eer checking for previous entries would just require you running a query on that person's name and ip address right... then if to make it more simple just delete the current entry and add the new one. Rather then trying to update the one that already exists...(dunno how to do that)
|
|
|
|
|
TonDiening
GURU
Joined: 26 Jul 2001
Posts: 1958
Location: Canada
|
Posted: Thu Jan 30, 2003 2:35 am
|
That or keep doing an #ADDITEM to the ip addresses to the name so you get a string list
you can use to compare as required.
Ton Diening |
|
|
|
|
|
|
|
