Lukket

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;

Færdigheder:

Se mere: 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

Om arbejdsgiveren:
( 6 bedømmelser ) Knoxville, United States

Projekt-ID: #85442

6 freelancere byder i gennemsnit $68 for dette job

Gudoc

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

$100 USD in 3 dage
(153 bedømmelser)
6.2
mistersoft

Can help you within 2 hours. Thanks!

$30 USD in 0 dage
(480 bedømmelser)
4.5
eelance

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

$30 USD på 1 dag
(571 bedømmelser)
4.4
websoftinfo

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. Mere

$100 USD in 5 dage
(99 bedømmelser)
3.4
alexsmith

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 Mere

$100 USD in 2 dage
(2 bedømmelser)
0.0
cgaya

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

$50 USD in 2 dage
(0 bedømmelser)
0.0