islp

@bcworkz First of all, thanks for your kind reply. I want to simply login the user and retrieve his/her name and surname (if possible), it’s the only thing I need in the app: WordPress is used by the app only to identify a user of a website, that’s all.

@wfalaa: it is perfectly working since the first time I tried it. Maybe the validator doesn’t like the final character (“) ??

@wfalaa: do you see something wrong in the syntax of the query? Or you suspect something won’t work? Apparently it is returning what I ask, I don’t see any issues ??

Ok, maybe I got it, but, if you have any time, please confirm: the query is ok, the important thing is to uncheck “Don’t log signed-in users with publishing access”.

Any suggestion is appreciated. ??

Thank you very much!

@wfalaa

Sorry for the late reply, I received no notification about this post.

Ok, so, at this point I have another question and the question is related to the question you replied here: https://www.ads-software.com/support/topic/client-derived-from-live-traffic-feature/

To build my client I queried Wordfence table wfhits this way:

SELECT 
hits.ctime, 
hits.URL, 
hits.UA, 
hits.IP, 
users.user_login, 
users.user_email, 
m1.meta_value AS firstname, 
m2.meta_value AS lastname FROM 'wp_wfHits' as hits 
JOIN wp_users as users ON hits.userID = users.ID 
JOIN wp_usermeta m1 ON (m1.user_id = hits.userID AND m1.meta_key = 'first_name') 
JOIN wp_usermeta m2 ON (m2.user_id = hits.userID AND m2.meta_key = 'last_name')
WHERE hits.userID!=0 
ORDER BY hits.ctime DESC"

This way I apparently retrieve data as if “Don’t log signed-in users with publishing access” was enabled.

How do I get the returning, previously logged-in user?

• This reply was modified 8 years ago by islp.
• This reply was modified 8 years ago by islp.

Yes, I’m on 5.5.54 (but some way, Wordfence can eventually retrieve the human readable IP) ??

Hi wfalaa, I get:

#1305 – FUNCTION INET6_NTOA does not exist

No problem, maybe I can retrieve the data, then use inet_ntop or something similar from PHP.

Thank you very much ??

Hey, I’ve done anything: could you only tell me how to convert the binary(16) IP in wfHits to a human readable IP?

Ok, thanks ??

Ok, I did it before your reply and anything went fine (thanks, anyway). After very few capures, TOR traffic suddenly disappeared.

Very interesting, thank you ??

“Diagnostic report has been sent successfully” (right now) ??

Hi (and thanks):

– no, sometimes it looks for an svg file or wof file;
– no, it’s not only that plugin;
– I made this test many times: no 404, except for something that MUST be 404;
– no caching plugin installed;

I’m sending the report as soon as possible.

@wfalaa

Here it is one (during a day they are dozens: they are real, I personally know many of them):
https://postimg.org/image/e9o6z49rn/

Hi wfalaa,

it’s not a crawler, but many human beings ??
Any user visiting the website with Safari Desktop or Safari iOS or, apparently, UIWebview, hit non-existent pages.

I’ll show you this as soon as possible. ??