Results 1 to 3 of 3

Threaded View

  1. #1
    Join Date
    Nov 2005
    Plugin Contributions

    Default HELP Zen Cart dev team - admin/customers.php - Where has this query been moved to?

    I'm doing a trial run upgrade from 1.5.7d to 1.5.8 so I can see what's involved and discovered that an sql query that was modified in admin/customers.php no longer exists in the ZC 1.5.8 version of the file.
    The query starts on line 412 in a 1.5.7d file and is

    $customers = $db->Execute("SELECT c.customers_id, c.customers_gender, c.customers_firstname,
                                            c.customers_lastname, c.customers_dob, c.customers_email_address,
                                            a.entry_company, a.entry_street_address, a.entry_suburb,
                                            a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id,
                                            a.entry_country_id, c.customers_telephone, c.customers_fax,
                                            c.customers_newsletter, c.customers_default_address_id,
                                            c.customers_email_format, c.customers_group_pricing,
                                            c.customers_authorization, c.customers_referral, c.customers_secret
                                     FROM " . TABLE_CUSTOMERS . " c
                                     LEFT JOIN " . TABLE_ADDRESS_BOOK . " a ON c.customers_default_address_id = a.address_book_id
                                     WHERE a.customers_id = c.customers_id
                                     AND c.customers_id = " . (int)$customers_id);
    Where is this query run in 1.5.8 so I can add the additional table fields that I need to query?
    Last edited by strelitzia; 19 Oct 2022 at 12:02 AM.



Similar Threads

  1. v156 admin/orders.php changes. Where has the code been moved to?
    By strelitzia in forum Upgrading to 1.5.x
    Replies: 2
    Last Post: 29 Dec 2018, 02:56 AM
  2. Can someone help, has this been done before. help please
    By kldezine in forum Templates, Stylesheets, Page Layout
    Replies: 5
    Last Post: 28 Apr 2009, 03:50 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Zen-Cart, Internet Selling Services, Klamath Falls, OR