IP record customers ip

[schrøder]

Anyone now how to record and store the IP address for each order placed on a OsCommerce site.

 

(1) The customer's IP is grabbed during the checkout process

(2) The customer is informed at E-mail :blink: that their IP has been recorded for security purposes at the checkout confirmation page

(3) The IP is stored along with the rest of the info for that particualr Order ID

(4) The IP is displayed in Admin -> Customers -> Orders ->

[Guest]

check the contributions

http://www.oscommerce.com/community/contributions,2138

[schrøder]

I have already tried this and it came out with just the

IP Address:

ISP: text, showing up at invoice.php and packingslip.php

But no IP adresses shows up, anyone..

[Guest]

you need to figure out if the ip is retrieved. $_SERVER['REMOTE_ADDR']

 

Does this work? If not use something like the ['HTTP_X_FORWARDED_FOR'] header. Do not rely on the remote_addr btw because the visitor can be behind a proxy for instance. It can also be the server btw and so you may need to mod the code and retrieve the field from the correct server variable.

[schrøder]

Thanks all works fine, exept at the last checkout_process.php button.. when confirm then I got this error

1054 - Unknown column 'ipaddy' in 'field list'

 

insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value, ipaddy, ipisp) values ('2', 'even scroder', '', 'mele4', '', 'viggja', '7354', '', 'Norway', '7766554433', 'fotpleien@yahoo.no', '1', 'even scroder', '', 'mele4', '', 'viggja', '7354', '', 'Norway', '1', 'even scroder', '', 'mele4', '', 'viggja', '7354', '', 'Norway', '1', 'Cash on Delivery', '', '', '', '', now(), '1', 'USD', '1.00000000', '82.194.204.81', 'loqal.no')

 

[TEP STOP]

Think its something with --RUN the SQL--- and

ALTER TABLE `orders` ADD `ipaddy` VARCHAR(15) NOT NULL;

ALTER TABLE `orders` ADD `ipisp` VARCHAR(15) NOT NULL;

But where shall I configure this?? :lol:

[Guest]

you need to properly install the module. You have to update the database. There should be documentation or an sql file about it.

[schrøder]

It aint no more info still sittin stuffed, anyone have the experience to this pro..