A IP-related question

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
tozequio
Registered User
Posts: 29
Joined: Tue Aug 21, 2007 11:48 pm

A IP-related question

Post by tozequio » Mon Dec 29, 2008 8:56 pm

Is it possible to view a IP of a member that hasn't posted, but has logged in and voted in a few topics?

User avatar
ChrisRLG
Former Team Member
Posts: 3420
Joined: Wed Nov 24, 2004 3:18 pm
Location: Essex, UK
Contact:

Re: A IP-related question

Post by ChrisRLG » Mon Dec 29, 2008 10:05 pm

no
phpBB: The All Important Rules - Bertie Bear 3.0 - No support via PM system - use the forums please.
phpBB v2: Retirement (1/1/2009) : phpBB v3: Read Me Topic - Custom BBCodes - Support Template
Matthew 7:7"Ask and it will be given to you; seek and you will find; knock and a door will be opened to you."
My Links: MS MVP (Consumer Security) - Malware Removal:University - Own Forum: Custom BBCode testing

User avatar
Dogs and things
Registered User
Posts: 2114
Joined: Fri Sep 01, 2006 9:04 am
Location: Spain
Contact:

Re: A IP-related question

Post by Dogs and things » Mon Dec 29, 2008 10:16 pm

Well,

No, not without a MOD, to be more correct. :P
For phpBB2 support visit phpBB2refugees.

tozequio
Registered User
Posts: 29
Joined: Tue Aug 21, 2007 11:48 pm

Re: A IP-related question

Post by tozequio » Mon Dec 29, 2008 10:34 pm

So can you point me to a mod that does so, please?

User avatar
Dogs and things
Registered User
Posts: 2114
Joined: Fri Sep 01, 2006 9:04 am
Location: Spain
Contact:

Re: A IP-related question

Post by Dogs and things » Mon Dec 29, 2008 10:53 pm

Log IP Address on Registration gives you the possibility to view the IP a user registered with and you can also make it so that every time a user logs in the IP he logged from gets registered. Thus you will always have the last IP from which a user connected to your board.

Read the MOD's release topic, there's many suggestions and ideas in it. I know it's a long thread, 71 pages, but it's worth reading.

But one question, how do you know exactly who voted in a topic?
For phpBB2 support visit phpBB2refugees.

RobbieRoad
Registered User
Posts: 84
Joined: Thu Sep 16, 2004 3:17 pm
Location: Netherlands, Oosterhout

Re: A IP-related question

Post by RobbieRoad » Mon Dec 29, 2008 11:00 pm

In the table prefix_vote_voters you can see who voted for what from which IP. So there you can find a connection between user ID and the IP address the vote came from.

tozequio
Registered User
Posts: 29
Joined: Tue Aug 21, 2007 11:48 pm

Re: A IP-related question

Post by tozequio » Mon Dec 29, 2008 11:17 pm

Well, we are running the year awards in my forum, so everyone is preety enthusiastic about it. I noticed a new member registering, setting a hidden status, and going to the awards subforum. Quite suspicious behaviour in my opinion.

Thanks for the mod, but still we couldn't trace the IP, as far as I understand the MOD doesn't work retrospectively :|

@Robbie - how I can see that? With a SQL editor I suppose?

User avatar
ric323
Former Team Member
Posts: 22908
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: A IP-related question

Post by ric323 » Mon Dec 29, 2008 11:32 pm

tozequio wrote:Thanks for the mod, but still we couldn't trace the IP, as far as I understand the MOD doesn't work retrospectively :|
No it doesn't.
Plain phpBB doesn't record the IP, so it is impossible to access information that was never recorded in the first place.
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

RobbieRoad
Registered User
Posts: 84
Joined: Thu Sep 16, 2004 3:17 pm
Location: Netherlands, Oosterhout

Re: A IP-related question

Post by RobbieRoad » Tue Dec 30, 2008 8:26 am

Hi,

You can look in the database using phpmyadmin or similar. Most of the times the hoster provides you with a tool like that, or you can install it yourself.

User avatar
ric323
Former Team Member
Posts: 22908
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: A IP-related question

Post by ric323 » Tue Dec 30, 2008 10:22 am

RobbieRoad wrote:Hi,

You can look in the database using phpmyadmin or similar. Most of the times the hoster provides you with a tool like that, or you can install it yourself.
So?
That isn't going to help you find something that was not recorded in the database in the first place!
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

RobbieRoad
Registered User
Posts: 84
Joined: Thu Sep 16, 2004 3:17 pm
Location: Netherlands, Oosterhout

Re: A IP-related question

Post by RobbieRoad » Tue Dec 30, 2008 11:11 am

If it is not recorded, why do I see it?

Code: Select all

Table phpbb_vote_voters

  vote_id  vote_user_id  vote_user_ip  
      1           7            43ac712c 
      1          11            c34b19e7 
      1           6            d99bcd8a 
      1           5            c159bee8 
      1          12            18a5988b 
In another table you can look up what was actually voted. Here, you can see the IP addresses of users 5, 6, 7, 11 and 12. In the user table, you can look up what their nick names are.

User avatar
ric323
Former Team Member
Posts: 22908
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: A IP-related question

Post by ric323 » Tue Dec 30, 2008 11:27 am

Oops, please accept my apologies, I never noticed that there before. :oops:
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

RobbieRoad
Registered User
Posts: 84
Joined: Thu Sep 16, 2004 3:17 pm
Location: Netherlands, Oosterhout

Re: A IP-related question

Post by RobbieRoad » Tue Dec 30, 2008 11:49 am

Of course I do. I was wondering if there was something I didn't understand correctly so I'm glad you respond.

Locked

Return to “2.0.x Support Forum”

Who is online

Users browsing this forum: No registered users and 21 guests

cron