Notifications
Clear all

wpForo 1.x.x [Closed] user id=0 and encrypted ip address in wpforo_visits table

9 Posts
3 Users
1 Reactions
2,041 Views
Posts: 10
Topic starter
(@chs2019)
Active Member
Joined: 6 years ago

wpforo version 1.6.5; wordpress version 5.3.2

I'm seeing what looks like weird activity in my wpforo_visits table.  I don't know if it's normal or not.  I see an entry with a user id of 0 and an encrypted ip address.  It seems to happen after a new post is created on the forum (see attached screenshot).  Is this behavior expected?

Thanks

8 Replies
Robert
Posts: 10591
Admin
(@robert)
Support Team
Joined: 9 years ago

Hi @chs2019,

All is correct, the entries with userid =0 are guest visitors, they dont have userids so we use their ip addresses for tracking.

Posts: 10
Topic starter
(@chs2019)
Active Member
Joined: 6 years ago

Why is the ip address encrypted?  Is there a way to figure out what it is in the standard format nnn.nnn.nnn.nnn?   I've had some suspicious activity in my log files & I'm trying to correlate it by ip address.  This is supposed to be a private forum, so there shouldn't be any guest access.

Thanks

1 Reply
Robert
Admin
(@robert)
Joined: 9 years ago

Support Team
Posts: 10591

@chs2019

I'm sorry but there is no way to stop hashing IP addresses, unless you can edit the core file /wpforo/wpf-includes/class-logs.php , find this line:

$ip = ( wpfval( $_SERVER, 'REMOTE_ADDR' ) ) ? substr( md5( $_SERVER['REMOTE_ADDR'] ),0, 32 ) : '-noip-';

And change it to this:

$ip = ( wpfval( $_SERVER, 'REMOTE_ADDR' ) ) ? strip_tags( $_SERVER['REMOTE_ADDR'] ) : '-noip-';

 

Posts: 10
Topic starter
(@chs2019)
Active Member
Joined: 6 years ago

I just double checked and all of my forums are configured for guest having "no access".  How would they get in?

Thanks

1 Reply
Robert
Admin
(@robert)
Joined: 9 years ago

Support Team
Posts: 10591

@chs2019

The no access doesn't matter. Visitor logging works even if they load the forum home page and even if on that page they don't see any forum. What is your forum home page? Can it be called?

 

Posts: 10
Topic starter
(@chs2019)
Active Member
Joined: 6 years ago

Thank you for the remote address code.  I do have access & will make the change.

Yes, the forum homepage is callable.  When not logged in, it lands on the title page with the icon for unread posts at the right (which is clickable with the full pulldown menu, but no text displays.)  I'd really like to redirect all traffic to the login page if the user isn't logged in. After typing in the url for the forum homepage, I checked the data base & log files.  Nothing is recorded in the visits table, but the wp log files do show access.  Under what specific circumstances is the visit actually logged in the db?

What concerns me is that this pattern happens after a new post occurs, which makes me think that some unknown user is receiving notifications. I've combed the database & don't find anything out of the ordinary in terms of unknown users (it's a small community) or access activity. I have no clue how to track something like this down.

Thank you

Page 1 / 2