X-Cart forums - Search for Order by IP Address

X-Cart forums (https://forum.x-cart.com/index.php)

- Dev Questions (https://forum.x-cart.com/forumdisplay.php?f=20)

- - Search for Order by IP Address (https://forum.x-cart.com/showthread.php?t=76503)

dpcompany

08-31-2018 06:34 AM

Search for Order by IP Address

Has anyone thought of implementing this feature into the admin order search form? I am trying to get it working, but I am coming up short on how to create the query...

qualiteam

09-03-2018 02:22 AM

Re: Search for Order by IP Address

It should be something like this.

Code:

select xcart_orders.orderid from xcart_orders left join xcart_order_extras on xcart_orders.orderid = xcart_order_extras.orderid where xcart_order_extras.khash = 'ip' and xcart_order_extras.value = '24.245.16.66';

dpcompany

09-03-2018 03:54 AM

Re: Search for Order by IP Address

Thanks Alex, I'll give this a shot! It looks like it should work the way I want.

qualiteam

09-03-2018 09:57 AM

Re: Search for Order by IP Address

You're welcome.

All times are GMT -8. The time now is 09:48 AM.