Migrate Stripe Accounts into WHMCS

[Kieran Smith]

Hi,

We've just moved over to using WHMCS as our billing system and we have a number of existing customers who we charge through our Stripe account. I can get their cus_ and pm_ ID's out of Stripe and I would like to be able to add them directly to client records.

I'm guessing that this has to be done through the database. Looking at our MySQL db, I think that I have to add JSON into the form {"customer":"cus_XXXXXXXXXXX","method":"pm_XXXXXXXXXXXXX"} into  tblcreditcards.card_data

The JSON appears to have been encrypted as a BLOB . I'm happy writting MySQL queries to inject the data but how do i correctly encrypt the JSON package so that WHMCS will read it correctly.

Thanks

Kieran

[Kieran Smith]

Further info if it helps:

I've tried following various posts on how to decrypt the data already stored - however we're using MariaDB not MySQL and so it seems we can't use set block_encryption_mode = 'aes-256-cbc'; 

I've tried various combinations of AES_DECRYPT but can't get anything other than a NULL result back.

Thanks

Kieran

[SyfGe23]

Any news?