conn,$_POST['username'])."' OR email='".mysqli_real_escape_string($db->conn,$_POST['email'])."'"; $db->query($sql); if ($db->num_rows > 0) { $lnote=''; foreach ($db->rows as $row) { if ($_POST['username'] == $row['username']) { $lnote.='That username has already been selected.'; } else { $lnote.='That email address already has an account.'; } } $lnote.=' Please try and login, select forgot password if you cannot remember it, or register with different information.'; } else { $db = new mysqlDB(); $sql = "insert into contact (username,password,firstname,lastname,company,email,phone,salesrep,accesslevel,registerdate) values ("; $sql.="'".mysqli_real_escape_string($db->conn,$_POST['username'])."',"; $sql.="PASSWORD('".mysqli_real_escape_string($db->conn,$_POST['pword'])."'),"; $sql.="'".mysqli_real_escape_string($db->conn,$_POST['first_name'])."',"; $sql.="'".mysqli_real_escape_string($db->conn,$_POST['last_name'])."',"; $sql.="'".mysqli_real_escape_string($db->conn,$_POST['company'])."',"; $sql.="'".mysqli_real_escape_string($db->conn,$_POST['email'])."',"; $sql.="'".mysqli_real_escape_string($db->conn,$_POST['phone'])."',"; $sql.="'".mysqli_real_escape_string($db->conn,$_POST['salesrep'])."',"; $sql.="'unapproved',"; $sql.="Now())"; $db->query($sql); $msg ="Username: ".$_POST['username']."\n"; $msg ="First Name: ".$_POST['first_name']."\n"; $msg.="Last Name: ".$_POST['last_name']."\n"; $msg.="Company: ".$_POST['company']."\n"; $msg.="Email: ".$_POST['email']."\n"; $msg.="Phone: ".$_POST['phone']."\n"; $msg.="Sales Rep: ".$_POST['salesrep']."\n\n"; $msg.="To Approve: http://". $_SERVER['HTTP_HOST']."/cms/dashboard.html\n"; $headers = "From: R3FactorChallenge \n"; $headers .= "Reply-To: ".$_POST['first_name']." ".$_POST['last_name']." <".$_POST['email'].">"; mail($settings['Register Approver Email Address'],"R3 Factor Challenge Tool Registration",$msg,$headers); $lnote=$settings['Register Thanks Note']; } } if (isset($_POST['DoWhat']) && $_POST['DoWhat'] == 'Send Password Reset Email') { $db = new mysqlDB(); $sql = "select * from contact where username='".mysqli_real_escape_string($db->conn,$_POST['uname'])."' OR email='".mysqli_real_escape_string($db->conn,$_POST['uname'])."'"; $db->query($sql); if ($db->num_rows == 0) { $lnote=$settings['PW Recover No Account']; } else if ($db->row['email'] == '') { $lnote=$settings['PW Recover No Account Email']; } else { $ereset=generate_random_string(20); $sdb = new mysqlDB(); $sql = "update contact set pwrecover='".mysqli_real_escape_string($sdb->conn,$ereset)."',pwrecovertime=Now() where contactid=".$db->row['contactid']; $sdb->query($sql); $msg=$settings['PW Recover Instructions Email']; $msg.="\r\r".'http://'.$_SERVER['HTTP_HOST'].'/index.html?ereset='.$ereset; $headers = "From: Do Not Reply "; mail($db->row['email'],"R3 Factor Challenge Password Reset",$msg,$headers); $lnote=$settings['PW Recover Instructions']."\r".$db->row['email']; } } if (isset($_GET['ereset']) && strlen($_GET['ereset']) == 20) { $db = new mysqlDB(); $sql = "select * from contact where pwrecover='".mysqli_real_escape_string($db->conn,$_GET['ereset'])."'"; $db->query($sql); if ($db->num_rows == 0) { $lnote='Sorry, there is no account with that password reset code.'; } else { $whichpanel='pwreset'; } } if (isset($_POST['DoWhat']) && $_POST['DoWhat'] == 'Set New Password') { $db = new mysqlDB(); $sql = "select * from contact where pwrecover='".mysqli_real_escape_string($db->conn,$_POST['resetcode'])."'"; $db->query($sql); if ($db->num_rows == 0) { $lnote='Sorry, there is no account with that password reset code.'; } else { $sdb = new mysqlDB(); $sql = "update contact set password=PASSWORD('".mysqli_real_escape_string($sdb->conn,$_POST['newpw'])."'),pwrecover='',pwrecovertime='0000-00-00 00:00:00' where contactid=".$db->row['contactid']; $sdb->query($sql); $lnote='Your password has been reset.'; } } ?> R3 Factor Challenge

Fill out the form below. Once submitted, an admin will need to approve your account.

Back to Login

Are you ready to take the challenge?

This interactive evaluation tool exclusively from R3 will reveal how Total Category Management identifies, addresses, and eliminates issues that affect your growth and profitability. Through our Total Category Management program, R3 can help:


Reduce operating costs
Find better ways to utilize your assets
Grow your earned income, sales and bottom line in the Non-Foods category

The Difference That Makes You Better