It's whatever you want kept to your self as it's a signing password that no one should know, but you.when replacing the SECRETKEY, can that be any string of characters? meaning could i use all letters, or all numbers, or a combination of both? example something like this: TESTPASSWORD
i hate to ask, would you be so kind as to help me produce the sql query code to complete the update to all cbsubs of each specific subscription/plan?
UPDATE `jos_comprofiler` AS cb SET cb.`cb_license` = ( SELECT CONCAT_WS( '_', cb.`id`, cbsubs.`plan_id`, cbsubs.`id`, 'SECRETKEY' ) FROM `jos_cbsubs_subscriptions` AS cbsubs WHERE cb.`id` = cbsubs.`user_id` AND cbsubs.`status` = 'A' LIMIT 1 )
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.