Where are guest ip addresses stored in the database? SOLVED

[bnadauld]

SOLVED - I upgraded my store to 8 and installed reCAPTCHA Free v1.1.3 - by PrestaHero

I can see the ip address of guests in BO - stats - visitor ids screen. But when i go to ps_connection in the db the ip_address column is garbled?

or (even better) does anyone know of a sql query that will cross check a customer order with their ip address. Ive got a non paying customer and i'd like to pull their ip address.

Thanks

 

Edited January 30 by bnadauld (see edit history)

[Guest]

This way you can find it by customer number, by order number or by customer email.

Otherwise, there is also the option to edit PaymentModule.php or Order.php and save the IP address in the ps_orders table (add column).
But that's something else.

SELECT a.id_order, a.id_customer, b.id_guest, c.ip_address, c.date_add, d.email 
FROM ps_orders a
LEFT JOIN ps_guest b ON (a.id_customer = b.id_customer)
LEFT JOIN ps_connections c ON (b.id_guest = c.id_guest)
LEFT JOIN ps_customer d ON (a.id_customer = d.id_customer)
WHERE d.email = '[email protected]' OR a.id_customer = 3 OR a.id_order = 3
ORDER BY c.ip_address

[bnadauld]

16 hours ago, Guest said:

This way you can find it by customer number, by order number or by customer email.

Otherwise, there is also the option to edit PaymentModule.php or Order.php and save the IP address in the ps_orders table (add column).
But that's something else.

SELECT a.id_order, a.id_customer, b.id_guest, c.ip_address, c.date_add, d.email 
FROM ps_orders a
LEFT JOIN ps_guest b ON (a.id_customer = b.id_customer)
LEFT JOIN ps_connections c ON (b.id_guest = c.id_guest)
LEFT JOIN ps_customer d ON (a.id_customer = d.id_customer)
WHERE d.email = '[email protected]' OR a.id_customer = 3 OR a.id_order = 3
ORDER BY c.ip_address

appreciate that - thanks - worked perfectly

note for anyone else that reads this: I had to keep the ' ' around the email address part as my sql syntax was different(?)

Edited May 15, 2020 by bnadauld (see edit history)

[bnadauld]

any idea how i place the '.' in the saved ip addresses so i can use them to track?

[Guest]

I do not understand

[bnadauld]

normally with an ip id expect to see something like 172.82.06.69 not 172820669

[Guest]

 

[ShresthaBros.com]

I don't think this will solve the Robot Email Spam issue. Robot email registration won't allow users to log in initially, and the server won’t capture any IP until back office admin approval is granted.

[bnadauld]

i fixed the robot spam issue with 

reCAPTCHA Free

v1.1.3 - by PrestaHero

 

[Divine]

Hello, don't forget to edit your first post and to add [Solved] in the title