<?
include("config.php");
$connection = mysql_connect("$server", "$db_user", "$db_pass");
$db = mysql_select_db("$database", $connection);
$query = "SELECT FROM login where username='$username'";
$result = mysql_query($query, $connection);
$exuser=mysql_numrows($result);
?>
<?
include("config.php");
$connection = mysql_connect("$server", "$db_user", "$db_pass");
$db = mysql_select_db("$database", $connection);
$query = "SELECT FROM login where email='$emaila'";
$result = mysql_query($query, $connection);
$exmail=mysql_numrows($result);
?>
<?php
if($username=='' OR $password=='' OR $password2=='' OR $fname=='' OR $emaila=='' OR $country=='' OR $age=='' OR $iam=='' OR $gender=='' OR $status=='' OR $whyjoin=='')
{
echo "$lang[registerfillfields]";
}
/////////////////// default entries if no user input start
elseif(isset($POST['sname'])) {
$sname = $POST['sname'];
}
elseif {
$sname = "No information was provided by the user.";
}
elseif(isset($POST['interests'])) {
$interests = $POST['interests'];
}
elseif {
$interests = "No information was provided by the user.";
}
elseif(isset($POST['school'])) {
$school = $POST['school'];
}
elseif {
$school = "No information was provided by the user.";
}
elseif(isset($POST['aboutu'])) {
$aboutu = $POST['aboutu'];
}
elseif {
$aboutu = "No information was provided by the user.";
}
elseif(isset($POST['hobbies'])) {
$hobbies = $POST['hobbies'];
}
elseif {
$hobbies = "No information was provided by the user.";
}
/////////////////// default entries if no user input end
elseif (!eregi("[a-z ]+$", $fname)) {
echo "$lang[reg_fnameatoz]";
}
elseif (!eregi("([a-z0-9]+)(.-)@(.-).{2}([a-z0-9])?$", $emaila)) {
echo "$lang[reg_emailinvalid]";
}
elseif (!eregi("[a-z ]+$", $country)) {
echo "$lang[reg_countryatoz]";
}
elseif (!eregi("[a-z0-9_]+$", $username)) {
echo "$lang[reg_illegalcharacters]";
}
elseif ($password != $password2) {
echo "$lang[reg_passdontmatch]";
}
elseif (strlen($password) < 4) {
echo "$lang[reg_passwordmin]";
}
elseif (strlen($password) > 20) {
echo "$lang[reg_passwordmax]";
}
elseif (strlen($username) > 15) {
echo "$lang[reg_usernamemax]";
}
elseif (strlen($username) < 6) {
echo "$lang[reg_usernamemin]";
}
elseif ($username=='administration')
{
echo "$lang[usernameforbidden]";
}
elseif ($username=='brailleschool')
{
echo "$lang[usernameforbidden]";
}
elseif ($username=='braillejail')
{
echo "$lang[usernameforbidden]";
}
elseif ($username=='staff')
{
echo "$lang[usernameforbidden]";
}
elseif ($username=='support')
{
echo "$lang[usernameforbidden]";
}
elseif ($username=='moderator')
{
echo "$lang[usernameforbidden]";
}
elseif ($username=='test')
{
echo "$lang[usernameforbidden]";
}
elseif ($username=='testing')
{
echo "$lang[usernameforbidden]";
}
elseif ($username=='testING')
{
echo "$lang[usernameforbidden]";
}
elseif ($username=='Arotay')
{
echo "The account $username has been terminated due to a terms of service violation. <br><br>Pursuant to paragraph one under user's registration obligations chapter.<br><br>[If any information provided by you, the user, is untrue, inaccurate, not current, or incomplete, Braille School has the right to terminate your account and refuse any and all current or future use of the Services offered by Braille School.]";
}
elseif (strlen($fname) < 2) {
echo "$lang[reg_fnamemin]";
}
elseif (strlen($fname) > 10) {
echo "$lang[reg_fnamemax]";
}
elseif (strlen($age) < 2) {
echo "$lang[reg_agemin]";
}
elseif (strlen($age) > 2) {
echo "$lang[reg_agemax]";
}
elseif ($age=='00')
{
echo "$lang[wrongage]";
}
elseif ($age=='01')
{
echo "$lang[wrongage]";
}
elseif ($age=='02')
{
echo "$lang[wrongage]";
}
elseif ($age=='03')
{
echo "$lang[wrongage]";
}
elseif ($age=='04')
{
echo "$lang[wrongage]";
}
elseif ($age=='05')
{
echo "$lang[wrongage]";
}
elseif ($age=='06')
{
echo "$lang[wrongage]";
}
elseif ($age=='07')
{
echo "$lang[wrongage]";
}
elseif ($age=='08')
{
echo "$lang[wrongage]";
}
elseif ($age=='09')
{
echo "$lang[wrongage]";
}
elseif (strlen($aboutu) > 2000) {
echo "$lang[reg_aboutumax]";
}
elseif (strlen($whyjoin) < 4) {
echo "$lang[reg_whyjoinmin]";
}
elseif (strlen($whyjoin) > 2000) {
echo "$lang[reg_whyjoinmax]";
}
elseif (strlen($hobbies) > 2000) {
echo "$lang[reg_hobbiesmax]";
}
elseif (strlen($interests) > 2000) {
echo "$lang[reg_interestsmax]";
}
elseif($exuser=='1')
{
echo "$lang[usernameregistered]";
}
elseif($exmail=='1')
{
echo "Email address is already being used on an existing member account. <a href=\"#\" onClick=\"history.go(-1)\">Please try again.</a>";
}
else
{
include("config.php");
$connection = mysql_connect("$server", "$db_user", "$db_pass");
$db = mysql_select_db("$database", $connection);
$query = "INSERT INTO login (username,password,fname,sname,email,country,interests,age,iam,gender,school,status,aboutu,whyjoin,hobbies, userpic, userpicalt)".
"VALUES ('$username', '$password', '$fname','$sname', '$emaila', '$country', '$interests','$age', '$iam', '$gender', '$school', '$status', '$aboutu', '$whyjoin', '$hobbies', '$userpic', '$userpicalt')";
$result = mysql_query($query, $connection);
echo "$lang[thanksregister]";
$ida= uniqid('message');
$ida2= uniqid('$ida');
$nr= uniqid($ida);
$date=date('m.j.Y');
$connection = mysql_connect("$server", "$db_user", "$db_pass");
$db = mysql_select_db("$database", $connection);
$query = "SELECT * FROM usermessages";
$query = "INSERT INTO usermessages (nomer, tombr, frommbr, date, title, message, new) VALUES ('$nr', '$username', 'admin', '$date', '$lang[adminwelcome]', 'Dear $fname $sname,<br><br>Thank you for joining Braille School!<br><br>We would like to inform you that your username <b><span class=errormsg>$username</span></b> $lang[adminwelcomemessage]', 'yes')";
$result = mysql_query($query, $connection);
}
?>
