"I've just had my first win, a trip to china for two, and I can't wait to go, should be very exciting, and different. Thank you very much."
Click to Read Full Story in the Local Newspaper
"Hi, I've had my first win. I won some software - worth £229.99 according to amazon.co.uk - it will come in very useful for me. "
"I have just won a 4 night trip to New York with £250 to spend. We are going in June for my partner's birthday. "
"I was really pleased to have won a MP3 Wrist-watch in the week from a competition which you entered me for. "
"Hey! Received a MP3 player from Wanadoo today- guess that`s due to you guys - thanks! Thats 2 prizes within 12 months - keep up the good work. "
"Just arrived home and there was a box containing a very nice speaker system with a congratulations note. As I no longer enter draws myself it must be through you so cheers. "
"Just to let you know i won a nice cordless keyboard and mouse, it's a nice prize and i will be renewing my subs when due. "
"Just to let you know, I've finally won a prize. A 40 gig external computer back up drive. Now I really know your system works. It just came through the post without prior notification which was really exciting. "
"I have received an email informing me I have won a Digital Camera. Many thanks and keep up the great work. "
"Just to let you know. I won a Runner up prize. The prize was an MC60 Digital camera phone. Very nice thanks. "
"Just to let you know, I was one of the ten runners up and got £100 worth of vouchers. Looking forward to more winnings. "
"I have just received a letter telling me i have won a two night stay in Geneva. "
"I have won the first prize and received the console today....thanks so much. "
|
| |
"POST")
{
if (!isset($cc))
{
//-----------------------
// Subscription Info Page
//-----------------------
include('qcl-sub-form.php');
}
else
{
//------------------------
// Process Confirm Request
//------------------------
exit;
// db connect
$dbname = "martinpw_prizefocus";
$link_id = db_connect($dbname);
if(!isset($link_id)) sql_error();
// Get confirm code
if (!isset($email)) $email = "";
$query = "SELECT email, forename, active, confirmcode FROM qcl WHERE confirmcode = '$cc'";
$result = mysql_query($query) or die ("Failed with: ".mysql_error());
if(!$result) sql_error();
$data = mysql_fetch_row($result);
$emaildb = stripslashes($data[0]);
$forename = stripslashes($data[1]);
$active = $data[2];
$ccdb = $data[3];
if (isset($emaildb) AND $email == $emaildb AND $cc == $ccdb)
{
if ($active == 0)
{
// if ok, update to active send email, confirm message
$query = "UPDATE qcl SET active = 1 WHERE confirmcode = '$cc'";
$result = mysql_query($query) or die ("Failed with: ".mysql_error());
if(!$result) sql_error();
$dummy = send_email(2, $forename, $email, $cc);
// success message
echo '
CONFIRMED
Your subscription has now been activated and an email confirmation sent to you.
Thanks for joining us, and Good Luck!
';
}
else
{
// already activated message
echo '
ALREADY CONFIRMED
Your subscription has already been activated.
';
}
}
else
{
// display error
echo '
ERROR...
Sorry, confirm code not valid for this email address.
';
}
}
}
else
{
exit;
//-------------------------
// Add New Pending Customer
//-------------------------
// validate details entered
$errormsg ='';
$email = trim(ereg_replace("[^0-9A-Za-z@_\.-]", "", $email));
$forename = trim(ereg_replace("[^A-Za-z' -]", "", $forename));
$forename = ucwords($forename);
if (!isset($email) OR $email == '') $errormsg = $errormsg."Email not completed
";
if ((!ereg(".+\@.+\..+", $email)) || (!ereg("^[[email protected]]+$", $email))) $errormsg = $errormsg."Your email address does not appear to be valid";
if ($errormsg == '')
{
// db connect
$dbname = "martinpw_prizefocus";
$link_id = db_connect($dbname);
if(!isset($link_id)) sql_error();
// insert to DB
//$jointime = date("d-m-Y H:i:s");
$jointime = date("Y-m-d H:i:s");
$userip = $HTTP_SERVER_VARS["REMOTE_ADDR"];
// generate confirmcode
$cc = return_confirmcode();
$emailslashed = addslashes($email);
$query = "INSERT INTO qcl VALUES (NULL, '$emailslashed', '$forename', '$jointime', '$cc', '$userip', '$id', 0)";
$result = mysql_query($query) or die ("Failed with: ".mysql_error());
if(!$result) sql_error();
// send confirm email
$dummy = send_email(1, $forename, $email, $cc);
// success message
echo '
To ACTIVATE your subscription you must respond to the confirmation email just sent to you.
Thanks for joining us, and Good Luck!
';
}
else
{
// display errors
echo '
SORRY...
'.$errormsg.'
Please press the BACK button on your browser and try again.';
}
}
?>
| |
