I am working on additional script to adding sold accounts which one was bought useing Dotpay Payment System.
I start writing it in php (i am not good in perl). Currently I stop on at SQL INSERT function.
Code: Select all
INSERT INTO Users SET usr_login='aaaa', usr_password=ENCODE('ccc','ccc'), usr_adm='0', usr_status='OK', usr_premium_expire=DATE_ADD(NOW(),INTERVAL 30 DAY), usr_add_login='0', usr_direct_downloads='0', usr_rapid_login='', usr_rapid_pass='', usr_points='8000', usr_created=NOW(), usr_lastlogin='0', usr_lastip='0', usr_email=''
Seems like I do it wrong. SQL function ENCODE() should work like:
ENCODE(str,pass_str) - Encrypt str using pass_str as the password.
In perl script (index.cgi) I didn't see the pass_str value, what should be there ? Which string should be used for crypt user passwd ?