0) { while ($row = mysql_fetch_assoc($qresult)) { // NOT if the name has a _PENDING in it! if (strpos($row["name"], "_PENDING") == FALSE) { // use the first non-empty name we come across if (strlen($to) == 0 && strlen($row["name"]) > 0) $to = $row["name"]; // append to the product listing if (strlen($row["serial"]) > 0) { $textlisting .= "Product: " . productnameforproductcode("SCW") . "\n\n"; $textlisting .= "Licensing Information:\n\n"; $textlisting .= "Name: " . $row["name"] . "\n"; $textlisting .= "E-Mail: " . $l_email . "\n"; $textlisting .= "License: " . $row["serial"] . "\n\n"; $textlisting .= "Drag and Drop the above 3 lines into the Request Key dialog, or copy them as needed into the required fields to request a key."; $textlisting .= "\n\n----\n\n"; $producthtml = file_get_contents("../../private/emailparts/scwtemplate.txt"); $producthtml = str_replace("", $row["name"], $producthtml); $producthtml = str_replace("", $l_email, $producthtml); $producthtml = str_replace("", $row["serial"], $producthtml); $producthtml = str_replace("", rawurlencode(utf8_encode($row["name"])), $producthtml); $producthtml = str_replace("", rawurlencode($l_email), $producthtml); $producthtml = str_replace("", rawurlencode($row["serial"]), $producthtml); $htmllisting .= $producthtml; $reg_count += 1; } } } } // search scxblowfish, then scxblowfish_eligible if nothing found. // different because we might report the old "SCX" serial and the new "X102" one. $qresult = mysql_query("SELECT name, serial, product, upgraded_license FROM scxblowfish WHERE email = '$l_email' AND lic_type != 8"); if (mysql_num_rows($qresult) > 0) { while ($row = mysql_fetch_assoc($qresult)) { // NOT if the name has a _PENDING in it! if (strpos($row["name"], "_PENDING") == FALSE) { // use the first non-empty name we come across if (strlen($to) == 0 && strlen($row["name"]) > 0) $to = $row["name"]; $upgradedscxcode = ""; if (strlen($row["upgraded_license"]) > 0) { // this will check and format the SCX code. $scxcode = $row["upgraded_license"]; if (validcgserial($row["product"], $scxcode)) { $upgradedscxcode = $scxcode; $textlisting .= "Product: " . productnameforproductcode($row["product"]) . "\n\n"; $textlisting .= "\"SCX\" License Code: " . $scxcode . "\n\n----\n\n"; $producthtml = file_get_contents("../../private/emailparts/scxtemplate.txt"); $producthtml = str_replace("", $scxcode, $producthtml); $htmllisting .= $producthtml; $reg_count += 1; } } // append to the product listing if (strlen($row["serial"]) > 0) { $textlisting .= "Product: " . productnameforproductcode("X102") . "\n\n"; $textlisting .= "Licensing Information:\n\n"; $textlisting .= "Name: " . $row["name"] . "\n"; $textlisting .= "E-Mail: " . $l_email . "\n"; $textlisting .= "License: " . $row["serial"] . "\n\n"; $textlisting .= "Copy and Paste or Drag and Drop the above 3 lines into the License Manager window to request a key." . "\n\n"; if (strlen($upgradedscxcode) > 0) $textlisting .= "(Upgraded from \"SCX\" code: " . $upgradedscxcode . ")\n\n"; $textlisting .= "----\n\n"; if (strlen($upgradedscxcode) > 0) $producthtml = file_get_contents("../../private/emailparts/scx102upgradedtemplate.txt"); else $producthtml = file_get_contents("../../private/emailparts/scx102template.txt"); $producthtml = str_replace("", $row["name"], $producthtml); $producthtml = str_replace("", $l_email, $producthtml); $producthtml = str_replace("", $row["serial"], $producthtml); $producthtml = str_replace("", rawurlencode(utf8_encode($row["name"])), $producthtml); $producthtml = str_replace("", rawurlencode($l_email), $producthtml); $producthtml = str_replace("", rawurlencode($row["serial"]), $producthtml); if (strlen($upgradedscxcode) > 0) $producthtml = str_replace("", $upgradedscxcode, $producthtml); $htmllisting .= $producthtml; $reg_count += 1; } } } } // only search scxblowfish_eligible if nothing found, since those that upgrade // will then exist in scxblowfish. no need to look for X102 serial... else { $qresult = mysql_query("SELECT name, product, upgraded_license FROM scxblowfish_eligible WHERE email = '$l_email'"); if (mysql_num_rows($qresult) > 0) { while ($row = mysql_fetch_assoc($qresult)) { // use the first non-empty name we come across if (strlen($to) == 0 && strlen($row["name"]) > 0) $to = $row["name"]; if (strlen($row["upgraded_license"]) > 0) { // this will check and format the SCX code. $scxcode = $row["upgraded_license"]; if (validcgserial($row["product"], $scxcode)) { $textlisting .= "Product: " . productnameforproductcode($row["product"]) . ":\n\n"; $textlisting .= "\"SCX\" License Code: " . $scxcode . "\n\n----\n\n"; $producthtml = file_get_contents("../../private/emailparts/scxtemplate.txt"); $producthtml = str_replace("", $scxcode, $producthtml); $htmllisting .= $producthtml; $reg_count += 1; } } } } } // now search each table of older serials foreach (array("kagi_regtable", "regtable", "cg_regtable") as $table) { // now get the rows for the email address in this table... $qresult = mysql_query("SELECT name, serial, product FROM $table WHERE email = '$l_email' AND serial IS NOT NULL"); if (mysql_num_rows($qresult) > 0) { while ($row = mysql_fetch_assoc($qresult)) { // use the first non-empty name we come across if (strlen($to) == 0 && strlen($row["name"]) > 0) $to = $row["name"]; // append to the product listing $textlisting .= "Product: " . productnameforproductcode($row["product"]) . "\n\n"; $textlisting .= "Serial Number: " . $row["serial"] . "\n\n----\n\n"; $producthtml = file_get_contents("../../private/emailparts/serialtemplate.txt"); $producthtml = str_replace("", productnameforproductcode($row["product"]), $producthtml); $producthtml = str_replace("", $row["serial"], $producthtml); $htmllisting .= $producthtml; // increment the number of entries found $reg_count += 1; } } } } // close the dbase, we are done with it mysql_close($link); } } ?>

Please Send me my License Codes

Enter the e-mail address you used when you purchased Spell Catcher, then click Find License Codes.

A summary of all the license codes for that e-mail address will be sent to the address you provide.

If your current e-mail address is different from the one we have in our records, you'll be given the option to ask us to update our records.

If we don't find any product information for the e-mail address you enter, perhaps you used a different or older one - try that address as well. If you bought your product from C&G and we can't find you, see this FAQ.

/> caution 

No registered products were found for

Please make sure that the e-mail address has been entered correctly and is the one used when you registered.

registered product(s) were found for .

You have the following choices:

is an old or invalid e-mail address, I need to submit a request to change it.

registered product(s) were found for .

The results have been sent to .

should receive this e-mail within the next hour.

AOL users: This e-mail will often be classified by AOL as junk mail. Please check your spam folder as well as your inbox!

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 your license codes, and we’ll figure out how to get them to you.

\n"; $emHeader .= "MIME-Version: 1.0\n"; //$emHeader .= "X-Mailer: PHP4\n"; //$emHeader .= "X-Priority: 3\n"; $emHeader .= "Content-Type: multipart/alternative; boundary=\"SCPart-12345\"\n\n"; //$emHeader .= "Content-Type: multipart/alternative; boundary=\"SCPart-12345\"; charset=iso-8859-1\n\n"; //$emHeader .= "Content-Transfer-Encoding: binary\n\n"; //$emHeader .= "Content-Transfer-Encoding: quoted-printable\n\n"; $message = file_get_contents("../../private/emailparts/licensecodes.txt"); $message = str_replace("", $l_email, $message); $message = str_replace("", $reg_count, $message); $message = str_replace("", $textlisting, $message); $message = str_replace("", $htmllisting, $message); $recipient = "\"" . $to . "\" <" . $l_email . ">"; mail($recipient, "Rainmaker Research Customer License Summary", $message, $emHeader, "-flicensing@rainmakerinc.com"); } ?>