Opencart 0.7 - Searching on phonenumber in customers list

Quote

Post by stefan » Sat Jun 02, 2007 8:52 pm

Why: A lot of customers uses their phonenumber as an account id here.

What: Changed SQL query where clause.

From:

Code: Select all

select customer_id, lastname, firstname from customer where lastname like '?' or firstname like '?'
To:

Code: Select all

select customer_id, lastname, firstname from customer where lastname like '?' or firstname like '?' or telephone = '?'
and safeQuery

From:

Code: Select all

$database->safeQuery($sql, $this->search, $this->search, $this->search), $cfg['max_rows'])
To:

Code: Select all

$database->safeQuery($sql, $this->search, $this->search, $this->search), $this->page, $cfg['max_rows'])

Diff file attached.
User avatar
stefan
Newbie
Posts
1
Joined
Fri Jun 01, 2007 8:02 pm
Location - Copenhagen, Denmark
Top

Re: Opencart 0.7 - Searching on phonenumber in customers list

Quote

Post by Daniel » Sun Jun 03, 2007 10:22 pm

Thanks!

OpenCart®
Project Owner & Developer.

User avatar
Daniel
Administrator
Posts
5627
Joined
Fri Nov 03, 2006 6:57 pm
Top
Locked
Return to “Development”
Who is online

Users browsing this forum: No registered users and 2 guests