guyc

Thanks SiteOx, the solution works perfectly. Just to add that the field of the password should be $postfields["password"] = md5(password)

can you give me an eample how to do it with curl from the command line? - - - Updated - - - never mind, I got it. Thanks.

after further investigation we realized that each (per user) exp date/cc number is encrypted using a different hash. This is not the hash in cofiguration.php mind you. how can we find this hash for each user?

we had a list of 300 users with their credit card info that we didn't want to insert manually. We ran a script on the database and inserted the info into the tblclients tblcustomfieldsvalues tables. Our concern is only the expiration date as we left the credit number blank (we use token instead) In the tblclients table the expiration date of the credit is encrypted using AES_ENCRYPT with a hash. yesterday we entered all the info into the table using the had we got when running query log and saw what was used to extract the data. Today the hash changed and we had to run the script again with the new hash. Does this hash changes on a daily basis and the entire exp date in the db is updated with it? If so, should there be another table where we should put the client id to be updated? If not, why did the hash changed? Thanks