OsCommerce Modification

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;


Daha fazlasını gör: value city, php modification, db query, cg, notes search, modification pending order, Need Modification, sort table, oscommerce table, select country state city php, join file, modification system, file notes, search query, oscommerce order order, sort file, php state country city, value table, city search, modification need, oscommerce insert, modification store, store modification, oscommerce insert order, needing

İşveren Hakkında:
( 6 değerlendirme ) Knoxville, United States

Proje NO: #85442

Bu iş için 6 freelancer ortalamada $68 teklif veriyor


Ready to start immediately on your project, as we are the experts in such things. Waiting for your selection. Thanks!

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(153 Değerlendirme)

Can help you within 2 hours. Thanks!

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(480 Değerlendirme)

i have finished more complex problem ,please contact with me .

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(571 Değerlendirme)

Hello Sir We are an offshore well established company for about more than five years. We have experienced developers (PHP, ASP, ASP.NET, MYSQL, C#,JAVA,JSP, C++ etc.) and those are dedicated in their respective fields. Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(99 Değerlendirme)

Dear Sir Hello, I am Alex Smith. I have 4 year experience in the php fields as a freelancer and job experience.I have done lot of successful projects.I had worked on several UK,USA and other countries p Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

Sir. I can help you. I have lots of experience in what you are asking. Plz contact me.

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)