Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls
X-Cart Home FAQ Forum rules Calendar User manuals Login  

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 offline
 

eXpert
   
Join Date: Oct 2008
Posts: 317
 
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 offline
 

eXpert
   
Join Date: Oct 2008
Posts: 317
 
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

« Previous Thread | Next Thread »


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 02:48 PM.

   
 
X-Cart forums © 2001-2020