Add/Modify script with "Forgot Password Function" and Encryption issue

I have a login script working with SHA1 Encryption. ----*** that mysql-query saves the password with encryption into my database:----------- $db = mysqli_connect(DB_HOST, DB_BENUTZER, DB_PASSWORT, DB_NAME); $sql = "SELECT ben_id, nutzername FROM hl_nutzer WHERE nutzername = '$auth_nutzername' AND " . "passwort = SHA1('$auth_passwort')"; -----***-------------------------------------------------------------------------- What I want to add is a "Forgot Password Function" (I will add it later a link into my login-page) with email activation and to add new password into database. That is the code I want to be modified. [login to view URL] These two files are available on my server and can be modified from you so that they work. I added also the two additionals fields in the table. You will get ftp access. Only of interest if awarded to you: CREATE TABLE `hl_nutzer` ( `ben_id` int(11) NOT NULL auto_increment, `nutzername` varchar(32) NOT NULL, `passwort` varchar(40) NOT NULL, `anmeldedatum` datetime default NULL, `vorname` varchar(32) character set latin1 default NULL, `nachname` varchar(32) character set latin1 default NULL, `geschlecht` varchar(1) character set latin1 default NULL, `geburtstag` date default NULL, `stadt` varchar(32) character set latin1 default NULL, `bild` varchar(32) character set latin1 default NULL, PRIMARY KEY (`ben_id`) ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8; ALTER TABLE `hl_nutzer` ADD `passwortcode` VARCHAR(255) NULL; ALTER TABLE `hl_nutzer` ADD `passwortcode_time` TIMESTAMP NULL; Pay attention table must be modified to hl_nutzer and "password" is the German word "passwort".