I need someone who knows oscommerce. YOU MUST KNOW the OSCOMERCE system.
I am needing a db query changed.
I have added STORE_ID to the configuration table of oscommerce.
I added store_id to the CUSTOMERS table.
I am needing to make [url removed, login to view] (file attached) only show customers that the value of store_id in the customers table is the same as STORE_ID from configuration. I have included the [url removed, login to view] file also - so you can see how I have changed it to make it insert the store id in store_id. I think this is the query below that needs to be changed.:
$customers_query_raw = 'select c.customers_id, c.customers_username, c.customers_lastname, c.customers_firstname, customers_private_messages, c.customers_notes as notes, c.customers_email_address , c.customers_group_id, cg.customers_group_name, c.customers_group_ra, c.customers_telephone, c.customers_dob, ci.customers_info_date_of_last_logon as last_logon, ci.customers_info_number_of_logons as num_logons, ci.customers_info_date_account_created as date_account_created, a.entry_city as city, z.zone_name as state, ctry.countries_iso_code_2 as country, a.entry_country_id, a.entry_company 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 left join ' . TABLE_CUSTOMERS_GROUPS . ' cg on c.customers_group_id = cg.customers_group_id left join ' . TABLE_CUSTOMERS_INFO . ' ci on c.customers_id = ci.customers_info_id left join ' . TABLE_COUNTRIES . ' ctry on a.entry_country_id = ctry.countries_id left join ' . TABLE_ZONES . ' z on a.entry_zone_id = z.zone_id ' . $search . ' order by ' . $db_orderby . ' ' . $sort;