SQL Started OK

"; // select the correct database $db = mysql_select_db("rainmkr_customerdata", $link); if ($db) { // see if the serial is banned $table = "banned"; $stripped_serial = StripSerial($l_serial); $qresult = mysql_query("SELECT * FROM banned WHERE serial = '$stripped_serial'"); if (mysql_num_rows($qresult) > 0) { $errcode = SerialBanned; $arrErrors['serial'] = "This license code is not valid."; } else { // search each table foreach (array("kagi_regtable", "regtable", "cg_regtable") as $table) { // see if the serial is already registered $qresult = mysql_query("SELECT * FROM $table WHERE serial = '$l_serial'"); // see if the license code has already been CONFIRMED if (mysql_num_rows($qresult) > 0) { if ($errcode == NoError) $errcode = SerialPending; while ($sql_fetch_rows = mysql_fetch_row($qresult)) { //printf("

$sql_fetch_rows[0]"); if ($sql_fetch_rows[0] == 'CONFIRMED') $errcode = SerialExists; else if ($sql_fetch_rows[0] == '') $errcode = SerialExists; else if (strcmp($sql_fetch_rows[3], $l_email) == 0) $prev_passwd = $sql_fetch_rows[0]; } if ($errcode == SerialPending) if (strlen($prev_passwd) == 16) $errcode = ResendEmail; } } } if ($errcode == NoError) { // add a new row to the registration table (regtable) $qresult = mysql_query("INSERT INTO regtable (confirm,reg_date) VALUES ('$passwd','$today')"); if ($qresult) { // now go through the fields of regtable, filling in the rest of the info $thisrow = mysql_query("SELECT * FROM regtable WHERE confirm = ('$passwd')"); // get the name of the first field for ($fieldindex = 0; $fieldindex < mysql_num_fields($thisrow); $fieldindex++) { // see if some info was posted to this page with that fieldname $fieldname = mysql_field_name($thisrow, $fieldindex); $compound = $_POST["$fieldname"]; // if some info was posted, then stuff it into the record (row) if (strlen($compound) > 0) mysql_query("UPDATE regtable SET $fieldname = '$compound' WHERE confirm = '$passwd'"); } } else { $errstring = mysql_error(); echo "

Insertion failed!

"; echo "Error code = $errstring

"; } } } else echo "

DB NOT Selected!

"; mysql_close($link); } if ($errcode == NoError || $errcode == ResendEmail) { if ($errcode == NoError) $errcode = RegComplete; // now lets try mailing $to = StripCommasEtc($l_name); $to .= "<"; $to .= $l_email; $to .= ">"; $emHeader = "From: Rainmaker Support \n"; $message = "Greetings "; $message .= StripCommasEtc($l_name); $message .= ",\n\nYou are receiving this e-mail to in order to confirm your registration of:\n\n"; $message .= productnameforserial($l_product); $message .= "\n\nwith Rainmaker Research Inc.\n\nTo confirm this product registration, please follow the link below:\n\n"; if ($errcode == RegComplete) $message .= "http://www.rainmakerinc.com/products/register/confirm.php?pass=$passwd\n\n"; else $message .= "http://www.rainmakerinc.com/products/register/confirm.php?pass=$prev_passwd\n\n"; $message .= "(Click the link above or copy and paste the link into your browser)\n\n"; $message .= "This e-mail was sent to you for a couple of reasons:\n"; $message .= "We want to make sure that the e-mail address used to register is real and belongs to the person that registered with it.\n"; $message .= "This prevents people from using an e-mail address other than their own to register their products with us.\n\n"; $message .= "If you received this message but do not know why, simply ignore it and accept our apology for the inconvenience.\n\nIf you are the intended recipient of this message, please save it!\n\n"; $message .= "This e-mail address ("; $message .= $_POST['email']; $message .= ") is the one you must use to retrieve your license code in case you lose it and need to re-install the product in the future.\n\n"; $message .= "Rainmaker Research Inc.\nhttp://www.rainmakerinc.com/\n"; //echo "

To:"; //echo $to; //echo "

"; //echo $message; mail($to, "Rainmaker Research Inc. Product Registration Confirmation", $message, $emHeader, "-fsupport@rainmakerinc.com"); } } } else { $l_name = utf8_decode(trim($_REQUEST['name'])); $l_email = trim($_REQUEST['email']); $l_company = utf8_decode(trim($_REQUEST['company'])); $l_address = ""; $l_address2 = ""; $l_city = ""; $l_state = ""; $l_country = ""; $l_zip = ""; $l_phone = ""; $l_product = trim($_REQUEST['products']); $l_serial = trim($_REQUEST['serialnumber']); $l_version = trim($_REQUEST['v']); $l_maillist = 1; $l_comments = ""; $l_name = stripslashes($l_name); $l_email = stripslashes($l_email); $l_company = stripslashes($l_company); if ($l_product == "Spell Catcher X") $l_product = "SCX"; else if ($l_product == "Spell Catcher Plus for Windows") $l_product = "SCW"; else if ($l_product == "Spell Catcher 8 for Macintosh") $l_product = "SC8"; else $l_product = "SC8"; } ?>

Register Your Products With Us

There's no need for anyone that purchases (or has purchased) Spell Catcher at our online store to register those purchases.
This is done automatically when your license(s) are created, so you can retrieve your license codes at any time.

Your privacy is important to us. Please read our Privacy Policy.

Please fill out the form below and click the Register button.

Fields marked with a checkmark are required.

An e-mail will be sent to the address you provide so you can confirm this registration.

You must complete this process for each product/license code you want to register. It is important that you register with a valid e-mail address and record that address for future reference. This e-mail address is the only way you will be able to retrieve your license codes if you should lose them.

 

"); else printf("
"); ?>  "); echo $arrErrors['name']; } ?> "); ?> "); else printf("
"); ?>  "); echo $arrErrors['email']; } ?> "); ?>
Lost License Codes"; else if ($errcode == SerialPending || $errcode == ResendEmail) $arrErrors['serial'] = "Registration for this license code is pending."; if (empty($arrErrors['serial'])) printf("
"); else printf("
"); ?>  "); printf($arrErrors['serial']); } ?> "); ?>
/>Receive our e-mail newsletter
"); printf(" "); printf("
"); } else { if ($errcode == RegComplete) printf("

Thank you for registering! An e-mail has been sent to $l_email in order to confirm this registration. Please follow the instructions in the confirmation e-mail to complete the registration process."); else printf("

Another e-mail has been sent to $l_email in order to confirm your earlier registration. Please follow the instructions in the confirmation e-mail to complete the registration process."); printf("

$l_email should receive this e-mail within the next hour or two.

"); } ?>

Having problems with this feature? Maybe you've found a bug. Describe to our webmaster the trouble you were having.

If you or your service provider use a junk mail or spam filter, and you suspect that the e-mail we send is being filtered or caught somehow, contact our support address, stating that you never received the product registration confirmation e-mail, and we'll confirm your registration manually. Note that you can always re-send this confirmation e-mail at any time by registering again as long as your registration remains unconfirmed.