I need a script to automatically go through every account in my game database and change their password and send an email to their registered email address with the new password. This is due to a leak of password information for my game server.
You can view the current registration code here to know where this information is located in the MSSQL database. http://past [url removed, login to view]
Notes: The password must be changed in two tables. Plain text in tbl_user and converted to MD5 Hash in USER_PROFILE table.
Emails I will provide further information via pmb.