|
|
Joined: Nov 2006
Posts: 3,097 Likes: 1
Carpal Tunnel
|
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,097 Likes: 1 |
In the UBBT_USERS table there is a column named USER_REGISTRATION
It seems that almost all the entries have 127.0.0.1 except for Administrators and Moderators
Why is that and what is it used for ?
The main Administrator account (2) also has 127.0.0.1 but the other Admins do not.
.
|
|
|
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150 |
127.0.0.1 would mean localhost and i think it'd be used if no ip was logged perhaps?
|
|
|
|
|
Joined: Aug 2006
Posts: 1,659 Likes: 1
Pooh-Bah
|
|
Pooh-Bah
Joined: Aug 2006
Posts: 1,659 Likes: 1 |
You mean USER_REGISTRATION_IP ? Should be self-explanatory.  Mine are filled in pretty well, and fully for those who've registered under Threads. If it can't determine the IP address they registered with, it'll default to 127.0.0.1
|
|
|
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150 |
Should be self-explanatory. Mine are filled in quit well, and fully for those who've registered under Threads. If it can't determine the IP address they registered with, it'll default to 127.0.0.1 jsut what i thought
|
|
|
|
|
Joined: Nov 2006
Posts: 3,097 Likes: 1
Carpal Tunnel
|
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,097 Likes: 1 |
You mean USER_REGISTRATION_IP ? No I do not mean USER_REGISTRATION_IP Boy what a tough crowd - you guys just looking for people to be wrong or what? It is USER_REGISTRATION and Every account has 127.0.0.1 except Admins/Mods
|
|
|
|
|
Joined: Aug 2006
Posts: 1,659 Likes: 1
Pooh-Bah
|
|
Pooh-Bah
Joined: Aug 2006
Posts: 1,659 Likes: 1 |
I don't have a USER_REGISTRATION field in UBBT_USERS -- that's why I asked. 
|
|
|
|
|
Joined: Nov 2006
Posts: 3,097 Likes: 1
Carpal Tunnel
|
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,097 Likes: 1 |
 Doh! My fault was looking at wrong data. Yes you were correct Geoff about the name. But still doesn't make sense that ALL of them would be 127.0.0.1 @Gizmo (thanks for the tip on localhost being 127.0.0.1 must have learned that I suppose a decade ago) I can understand a few of them maybe being 127.0.0.1 but not all of them. Okay - got curious and did a full query - seems that the software was probably broken or configured wrong at some time as old accounts are set at 127.0.0.1 and not new ones. .
|
|
|
|
|
Joined: Aug 2006
Posts: 1,659 Likes: 1
Pooh-Bah
|
|
Pooh-Bah
Joined: Aug 2006
Posts: 1,659 Likes: 1 |
Yes you were correct Geoff... you guys just looking for people to be wrong or what? Yeah, pretty much.  j/k
|
|
|
|
|
Joined: Nov 2006
Posts: 3,097 Likes: 1
Carpal Tunnel
|
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,097 Likes: 1 |
ROFL - Mean crowd
|
|
|
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150 |
@Gizmo (thanks for the tip on localhost being 127.0.0.1 must have learned that I suppose a decade ago) My response to the above has been removed.
|
|
|
|
|
Joined: Jun 2006
Posts: 3,839 Likes: 1
Carpal Tunnel
|
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,839 Likes: 1 |
might theses have been set to this on the import as it was imported by the localhost?
|
|
|
|
|
Joined: Nov 2006
Posts: 3,097 Likes: 1
Carpal Tunnel
|
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,097 Likes: 1 |
Nothing Gizmo, my fault. I apologize. I took it as a dig at me when obviously it was not.
Sorry guy.
|
|
|
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150 |
might theses have been set to this on the import as it was imported by the localhost? My thoughts are that if it's from an import that the users who didn't have a registration ip stored pre-import that it inserted them as 127.0.0.1
|
|
|
|
|
Joined: Jun 2006
Posts: 3,839 Likes: 1
Carpal Tunnel
|
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,839 Likes: 1 |
indeed 
|
|
|
|
|
Joined: Nov 2006
Posts: 3,097 Likes: 1
Carpal Tunnel
|
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,097 Likes: 1 |
Why would Admins and Mods be blank ?
When they originally registered they were not Admins or Mods and when they are logged in right now you see their IP so I'm assuming that it's blank for some reason and it was made blank when they became an Admin or Mod, just not sure why that would be.
Trying to understand the application better.
|
|
|
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150 |
i think that in classic when you registered and it couldn't read your ip (not sure why) it would enter a blank; im' not sure if it'd happen in threads either.
Basically sometimes an ip can't be read, or is read as the webserver; especially when php is running as a cgi.
|
|
|
|
|
Joined: Aug 2006
Posts: 1,659 Likes: 1
Pooh-Bah
|
|
Pooh-Bah
Joined: Aug 2006
Posts: 1,659 Likes: 1 |
Yeah, it can't always be determined... just look at your stats - a lot of things are "unknown" :/
|
|
|
|
|
Joined: Jun 2006
Posts: 3,839 Likes: 1
Carpal Tunnel
|
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,839 Likes: 1 |
|
|
|
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150 |
lol yeh, a stats logger is a good way to look at things; mine has a ton that are "unknown" or listed as my server name.
|
|
|
|
0 members (),
206
guests, and
158
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
