i’m using saved credit card to process orders, the site currently stores the encrypted credit card number and the encrypted ccv number. When i invoice the order i want it to delete these numbers or replace them with xxxxxx ect but i am having trouble using sql to delete the right value.
i am currently setting this up in the app/code/core/mage/sales/model/order/invoice.php
and want it to work something like this, it connects to the database fine but i dont know or cant figure out the sql query to use which references the sales_quote_entity_varchar table with the actual order number:
public function pay()
$order id = $this->getOrderId();
$conn = Mage::getModel(’Core/Mysql4_Config’)->getReadConnection();
SET value = xxx
WHERE orderId = $order id AND attribute_Id = 222);
I’m sure that makes no sense, but if it does to someone i would much appreciate your help.