[SOLVED] User auto generated number

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

It's whatever you want kept to your self as it's a signing password that no one should know, but you.

The below will probably work. Replace jos_ with whatever your table prefix is. If it throws errors adjust as needed as I did not test it.

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?

oh so close! this did put the information together, but it didn't actually generate a license key from it. for example instead of coming out like a serial key it came out in this format "[user_id]_[plan_id]_[subsciption_id]_SECRETKEY", but it did have actual numbers so in the db it looks like this:
2089_15_2208_MYPASSWORD

basically it did run the query & did produce the information, it just didn't turn it into an encrypted serial key. it seems like the MD5 portion is not taking place?

Forgot the MD5. Add the MD5 function around the CONCAT_WS. Again, it was an example that I didn't test.

Thank you so much Kyle! I tried so many variations yesterday using this exact thought process, but until you said "around the CONCAT_WA" it didn't work. i was placing it in the wrong spots.
anyway thank you again & please mark this as resolved