Addition in mysql query Magento
$10-30 USD
Pagado a la entrega
I have this query which fetches all customer info + billing info + payment info. I want to fetch customer password as well from magento db. So need addition of customer password column.
SELECT increment_id,customer_email,[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],sfoa.country_id,[url removed, login to view],[url removed, login to view],sfop.cc_owner,sfop.cc_type,sfop.cc_exp_month,sfop.cc_exp_year,sfop.cc_secure_verify,sfop.cc_approval,sfop.cc_last4,sfop.cc_number_enc FROM `sales_flat_order` as sfo left join sales_flat_order_address as sfoa on sfoa.parent_id = sfo.entity_id left join sales_flat_order_payment as sfop on sfop.parent_id=sfo.entity_id where sfoa.address_type='billing'
Need it done ASAP!
Nº del proyecto: #6938674
Sobre el proyecto
Adjudicado a:
Hi, I'm magento developer certified ([login to view URL]), and you can not show the field "password" exactly, but you can show "password hash" field with md5 encryptation. Thanks.
6 freelancers están ofertando un promedio de $34 por este trabajo
hello sir, i can do your project.... please accept my bid so that i can start it... i m expert in this type of project... u can also see my portfolio... please sir accept my bid.. please hope u will do i m waiting f Más
Hello Client, Lets complete your task immediately. I would like to take opportunity to work with you on your Magento & MYSQL requirement. Basically, I need to fetch customer password from the DB. Lets make it Más