Email address has been changed

"); } else { print ("

Email address has NOT been changed"); } $oldemail = ""; } if($name != "") { $message = "Registering new product account for $product"; $result = mysqli_query($link,"INSERT INTO sysmessagelog (LogMsgID,LogMsgText,LogMsgDate,LogMsgTime,LogMsgProduct,LogMsgUser) VALUES (NULL,'$message','$dentered','$tentered','$product','$user')"); // compose serial number $serial="EHS-"; $result9=mysqli_query($link,"SELECT sysEHSProdSerialBase,sysEHSProdVersion FROM sysehsproducts WHERE sysEHSProdName='$product'"); $row = mysqli_fetch_array($result9, MYSQLI_ASSOC); $prodver=$row["sysEHSProdVersion"]; $serial=$serial.$row["sysEHSProdSerialBase"]; $serial=$serial."-"; $result9=mysqli_query($link,"SELECT sysEHSProdTries FROM sysehsproducts WHERE sysEHSProdName='$product'"); $row = mysqli_fetch_array($result9, MYSQLI_ASSOC); $tries = $row["sysEHSProdTries"]; if ($tries==0) {$serial=$serial."P";} else {$serial=$serial."T";} $padextra = str_pad($result9->data[0][0], 2, "0", STR_PAD_LEFT); $serial=$serial.$padextra; $serial=$serial."-"; $result9=mysqli_query($link,"SELECT MAX(sysEHSRegID) AS val FROM sysehsregistrations"); $padextra = str_pad($result9->data[0][0], 2, "0", STR_PAD_LEFT); $serial=$serial.$padextra; $serial=$serial."ZZ"; $result10=mysqli_query($link,"SELECT sysEHSRegID FROM sysehsregistrations WHERE sysEHSRegUserName='$unp'"); if ($unp!="gavin" && $unp!="admin" && mysqli_num_rows($result10) == 0) { // check the passwords match if($pwd==$pwd2) { // insert a registration info record $token = date("dmYHis"); $token = "EHS" . $token . "1000"; $result=mysqli_query($link,"INSERT INTO sysehsregistrations (sysEHSRegID,sysEHSRegName,sysEHSRegAddr,sysEHSRegTel,sysEHSRegFax,sysEHSRegEmail,sysEHSRegProduct,sysEHSRegSerial,sysEHSRegPassword,sysEHSRegUserName,sysEHSRegDate,sysEHSRegTime,sysEHSRegVersion,sysEHSRegUnique,sysEHSRegToken,sysEHSRegEmailValidated) VALUES (NULL,'$name','$addr','$tel','$fax','$email','$product','$serial','$pwd','$unp','$dentered','$tentered','$prodver',$reguidHash,'$token',0)"); if (!$result) { $message = 'Invalid query: ' . mysqli_error($link) . "\n"; die($message); } // insert record into sysehsreports so that Project Tracker works fine for that user $tdate = date("d-m-y"); $rand = rand(100,999); $rand = str_pad($rand, 4, "0", STR_PAD_LEFT); $ticket = "EHS-" . $rand . "-" . $tdate; $query = "INSERT INTO sysehsreports (sysEHSRepID,sysEHSRepOwnerID,sysEHSRepProduct,sysEHSRepVersion,sysEHSRepDesc,sysEHSRepName,sysEHSRepEmail,sysEHSRepType,sysEHSRepDept,sysEHSRepDate,sysEHSRepTicket,sysEHSRepUser) VALUES (null,LAST_INSERT_ID()+1,'$product','$prodver','$product Registration','$product Registration','$email','Registration','Admin','$dentered','$ticket','$unp')"; mysqli_query($link,"$query"); $result8=mysqli_query($link,"SELECT sysEHSProdPrice FROM sysehsproducts WHERE sysEHSProdName='$product'"); $row = mysqli_fetch_array($result8, MYSQLI_ASSOC); $price=$row["sysEHSProdPrice"]; if($price!=0) { mysqli_query($link,"UPDATE sysehsregistrations SET sysEHSRegActive=0 WHERE sysEHSRegUserName='$unp' AND sysEHSRegPassword='$pwd' AND sysEHSRegProduct='$product'"); print("Single user license for $product
"); print("
"); print(""); print(""); print(""); print(""); print(""); print(""); print("\"\""); print("

"); //exit(); } print("

Thank you $name, you are now registered as $unp for product $product. Thank you for your interest in End House Software products.

"); } else { $message = "Password verification has failed. Please retype your supplied password excatly."; $result2=mysqli_query($link,"INSERT INTO sysmessagelog (LogMsgID,LogMsgText,LogMsgDate,LogMsgTime,LogMsgProduct,LogMsgUser) VALUES (NULL,'$message','$dentered','$tentered','$product','$unp')"); print "$message

"; } } else { $message = "Username already exists, please try another."; $result2=mysqli_query($link,"INSERT INTO sysmessagelog (LogMsgID,LogMsgText,LogMsgDate,LogMsgTime,LogMsgProduct,LogMsgUser) VALUES (NULL,'$message','$dentered','$tentered','$product','$unp')"); print "$message

"; } $name = ""; exit(); } ?> Use the form below to register your End House Software product
Please select product to register
Full Name
Address/Company Name
Telephone
Fax
E-Mail Address

Choose a User Name
User Name

Choose a Password
Password
Verify Password


Need to change your registered email address, use the form below

Old Email Address

New Email Address

Enter Password