Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Search for Order by IP Address

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions
 
Thread Tools Search this Thread
  #1  
Old 08-31-2018, 06:34 AM
 
dpcompany dpcompany is online now
 

eXpert
  
Join Date: Oct 2008
Posts: 313
 

Default 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...
__________________
Michael

Development
X-Cart Gold Plus v4.7.12
- php 7.3
- reBOOT reDUX
- other goodies

X-Cart Gold v4.7.7
- reBOOT Template
- XPayments 3.0.2
- Abandoned Cart Reminder
- BCSE Reward Points
- BCSE Stock Notify
- XPDF Invoices
Reply With Quote
  #2  
Old 09-03-2018, 02:22 AM
  qualiteam's Avatar 
qualiteam qualiteam is offline
 

X-Guru
  
Join Date: Dec 2010
Posts: 6,373
 

Default 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';
__________________
Alex Solovev,
Qualiteam

---

User manual Video tutorials X-Cart FAQ

You are welcome to press "Thanks" button
if you find this post useful

Click here to learn how to apply patches

X-Cart Extensions
Reply With Quote

The following user thanks qualiteam for this useful post:
dpcompany (09-03-2018)
  #3  
Old 09-03-2018, 03:54 AM
 
dpcompany dpcompany is online now
 

eXpert
  
Join Date: Oct 2008
Posts: 313
 

Default 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.
__________________
Michael

Development
X-Cart Gold Plus v4.7.12
- php 7.3
- reBOOT reDUX
- other goodies

X-Cart Gold v4.7.7
- reBOOT Template
- XPayments 3.0.2
- Abandoned Cart Reminder
- BCSE Reward Points
- BCSE Stock Notify
- XPDF Invoices
Reply With Quote
  #4  
Old 09-03-2018, 09:57 AM
  qualiteam's Avatar 
qualiteam qualiteam is offline
 

X-Guru
  
Join Date: Dec 2010
Posts: 6,373
 

Default Re: Search for Order by IP Address

You're welcome.
__________________
Alex Solovev,
Qualiteam

---

User manual Video tutorials X-Cart FAQ

You are welcome to press "Thanks" button
if you find this post useful

Click here to learn how to apply patches

X-Cart Extensions
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Dev Questions


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 12:33 AM.

   

 
X-Cart forums © 2001-2020