require("../config.inc.php");
require("../templates/checklogin.inc.php");
if($type == 1 && $error_code == 0)
{
$serial = strtoupper($_GET['serial']);
Header("Location: i2m_login_activate.php?serial=$serial");
}
$is_ideasbank = 1;
$title="i2mOnline :: Ideas Bank";
$menu_right = "../templates/right_ideasbank2.php";
include("../templates/top.php"); ?>
PRODUCT REGISTRATION - IDEAS BANK SIGN UP
mysql_connect($host, $bdduser,$bddpasswd) or die("error connecting to the server");
mysql_select_db($db) or die("error connecting to the database");
if(isset($_POST['Submit']))
{
$account_type = 1;
$serial = strtoupper($_POST['serial']);
$email = strtolower($_POST['email']);
$confirmemail = strtolower($_POST['confirmemail']);
$title = $_POST['title'];
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$birthdate = $_POST['birthdate'];
$password = $_POST['password'];
$confirmpassword = $_POST['confirmpassword'];
$organisation = $_POST['organisation'];
$role = $_POST['role'];
$address = $_POST['address'];
$city = $_POST['city'];
$postcode = $_POST['postcode'];
$country = $_POST['country'];
$telephonenumber = $_POST['telephonenumber'];
$mobilenumber = $_POST['mobilenumber'];
$website = $_POST['website'];
$how_find_out_about_us = $_POST['how_find_out_about_us'];
$you_are_an = $_POST['you_are_an'];
$agree_terms = $_POST['agree_terms'];
$keep_updated = $_POST['keep_updated'];
$receive_com = $_POST['receive_com'];
$serial = addslashes($serial);
$email = addslashes($email);
$confirmemail = addslashes($confirmemail);
$title = addslashes($title);
$firstname = addslashes($firstname);
$lastname = addslashes($lastname);
$birthdate = addslashes($birthdate);
$password = addslashes($password);
$confirmpassword = addslashes($confirmpassword);
$organisation = addslashes($organisation);
$role = addslashes($role);
$address = addslashes($address);
$city = addslashes($city);
$postcode = addslashes($postcode);
$country = addslashes($country);
$telephonenumber = addslashes($telephonenumber);
$mobilenumber = addslashes($mobilenumber);
$website = addslashes($website);
$how_find_out_about_us = addslashes($how_find_out_about_us);
$you_are_an = addslashes($you_are_an);
$agree_terms = addslashes($agree_terms);
$keep_updated = addslashes($keep_updated);
$receive_com = addslashes($receive_com);
// ok enough parameters
if($email == $confirmemail)
{
if($password == $confirmpassword)
{
$query = "SELECT id FROM px_serials WHERE serial='$serial' AND enabled='1'";
$result = mysql_query($query);
if(mysql_num_rows($result) > 0)
{
if($row = mysql_fetch_object($result))
{
$query = "SELECT id FROM px_registered_users2 WHERE email='$email'";
$result = mysql_query($query);
if(mysql_num_rows($result) > 0)
{
$error = 1;
?>
This email has already been registered.
}
else
{
$serial_id = $row->id;
$query = "SELECT id FROM px_registered_users2 WHERE serial_id='$serial_id'";
$result = mysql_query($query);
if(mysql_num_rows($result) > 0)
{
// serial already used
$error = 4;
}
else
{
$datetime = date("Y-m-d H:i:s");
$IP = $_SERVER['REMOTE_ADDR'];
$md5password = md5($password);
list($day, $month, $year) = explode("/", $birthdate);
$birthdate2 = "$year-$month-$day";
$query = "INSERT INTO px_registered_users2 ( `id` , `title` , `firstname` , `lastname` , `birthdate` , `email` , `password` , `organisation` , `role` , `address` , `city` , `postcode` , `country` , `telephonenumber` , `mobilenumber` , `website` , `how_find_out_about_us_id` , `you_are_an_id` , `agree_terms` , `keep_updated` , `receive_com` , `serial_id` , `datetime` , `IP` , `activated`) VALUES('', '$title', '$firstname','$lastname', '$birthdate2','$email', '$md5password', '$organisation', '$role', '$address','$city','$postcode','$country','$telephonenumber','$mobilenumber','$website','$how_find_out_about_us','$you_are_an','$agree_terms', '$keep_updated','$receive_com', '$serial_id', '$datetime', '$IP', '0')";
$url = "http://www.i2monline.com/ideasbank/activate.php?email=".stripslashes($email)."&hash=".$md5password.base64_encode($datetime);
// print "url : $url";
$result = mysql_query($query);
if($result)
{
$submitted = 1;
$subject = "Welcome to i2m Online";
$message = "Welcome to i2mOnline, the website that helps you to quickly assess the viability of new business ideas.
i2mOnline is the accompanying website to i2m – Ideas to Market. i2m is a unique product that can assist you to develop and commercialise your business ideas.
With your new i2mOnline account you'll have access to a series of valuable resources including the i2m Rapid Idea Evaluation and the i2m Newsletters.
Please keep this email for your records. Your account information is as follows:
----------------------------\nUsername: ".$email."\nPassword: ".$password."\n----------------------------
Your account has been created but is currently inactive.
To activate the account please click on the link below:
".$url."
* If this link does not work please copy and paste this link into your web browser.
Please do not forget your password as it has been encrypted in our database and we cannot retrieve it for you. However, should you forget your password you can request a new one which will be activated in the same way as this account.
We hope you enjoy using our website and if you have any questions or need any help, please contact us at support@i2monline.com.
Thank you for registering.
--\ni2mOnline - Administrator
www.i2mOnline.com";
$headers = "From: i2mOnline@i2mOnline.com\n" .
'X-Mailer: PHP/' . phpversion() . "\n" .
"MIME-Version: 1.0\n";
// "Content-Type: text/html; charset=utf-8\n" .
// "Content-Transfer-Encoding: 8bit\n\n";
// Send
$to = stripslashes($email);
$response = mail($to, $subject, $message, $headers);
?>
i2m Online has sent an email to your address.
To activate your account:
- Go to the “i2m Online account activation” email sent to the
address you provided.
- Click on the link in the email to activate your account.
If you do not receive the email, please email us at support@i2monline.com
}
else
{
$error = 5;
}
}
}
}
else
{
$error = 5 ;
}
}
else
{
// serial invalid
$error =3;
}
}
else
{
$error = 1;
?>
The password and the confirmation password must be identical.
}
}
else
{
$error = 1;
?>
The email and the confirmation email must be identical.
}
}
else
{
$serial = strtoupper($_GET['serial']);
if(strlen($serial) > 0)
{
$query = "SELECT id FROM px_serials WHERE serial='$serial' AND enabled='1'";
$result = mysql_query($query);
if(mysql_num_rows($result) > 0)
{
if($row = mysql_fetch_object($result))
{
$serial_id = $row->id;
$query = "SELECT id FROM px_registered_users2 WHERE serial_id='$serial_id'";
$result = mysql_query($query);
if(mysql_num_rows($result) > 0)
{
// serial already used
$error = 4;
}
else
{
}
}
else
{
$error = 5 ;
}
}
else
{
// serial invalid
$error =3;
}
}
}
if( $error == 3)
{
// serial is invalid.
?>
We are sorry, but the serial you are using is
invalid. Please contact the support to get more information.
}
else if($error ==4)
{
?>
Your version of i2m has already been registered.
}
else if($error ==5)
{
?>
Unexpected error.
}
else
{
if($submitted < 1 && $error < 5)
{
$email = stripslashes($email);
$confirmemail = stripslashes($confirmemail);
$title = stripslashes($title);
$firstname = stripslashes($firstname);
$lastname = stripslashes($lastname);
$birthdate = stripslashes($birthdate);
$password = stripslashes($password);
$confirmpassword = stripslashes($confirmpassword);
$organisation = stripslashes($organisation);
$role = stripslashes($role);
$address = stripslashes($address);
$city = stripslashes($city);
$postcode = stripslashes($postcode);
$country = stripslashes($country);
$telephonenumber = stripslashes($telephonenumber);
$mobilenumber = stripslashes($mobilenumber);
$website = stripslashes($website);
$how_find_out_about_us = stripslashes($how_find_out_about_us);
$you_are_an = stripslashes($you_are_an);
$agree_terms = stripslashes($agree_terms);
$keep_updated = stripslashes($keep_updated);
$receive_com = stripslashes($receive_com);
?>
Thank you for coming to register. Please take a few minutes to provide the information requested. Product registration is optional but recommended if you want to receive notifications of updates or access the Innovation Forum and Ideas Bank. The information you provide will also help us better tailor our products and services to our customers' needs.
The fields marked by * are mandatory.
}
}
mysql_close();
?>
include("../templates/bottom.php"); ?>