This is a discussion on Control Login within the New osCommerce Contributions forums, part of the osCommerce 2.2 Forums category; From kesters last post I figured it out. The customers_status column needs to be added to the query above where ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| ||||
| ||||
| From kesters last post I figured it out. The customers_status column needs to be added to the query above where the data gets used. In admin/customers.php Find this: QUOTE $customers_query_raw = "select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id " . $search . " order by c.customers_lastname, c.customers_firstname"; Change to this: QUOTE $customers_query_raw = "select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, c.customers_status, a.entry_country_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id " . $search . " order by c.customers_lastname, c.customers_firstname"; -------------------- Gary More...
__________________ Michael Sasek osCMax Developer
|
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Control more image sizes from admin | michael_s | New osCommerce Contributions | 0 | 03-25-2007 07:11 AM |
| Help - Lost my Access to the Control Panel | PGelsman | osCMax v2 Installation issues | 0 | 08-08-2006 10:03 PM |
| need assistance with inventory control | rebron11 | osCommerce 2.2 Modification Help | 0 | 04-13-2005 01:07 PM |
| Is there a tree-control for OSC22ms2 | amstel48 | osCommerce 2.2 Installation Help | 0 | 12-18-2004 02:56 AM |
| what pages does the static.tpl.php control? | Kristine | osCMax v1.7 Discussion | 2 | 03-26-2004 06:05 PM |