X-Cart: shopping cart software

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 10:00 PM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.