query("SELECT adress,region FROM ".C_ADM_TBL.""); list($ADRESSCHECK,$REGIOCHECK) = $DbLink->next_record(); //GET IP ADRESS if (isset($_SERVER["HTTP_X_FORWARDED_FOR"]) && $_SERVER["HTTP_X_FORWARDED_FOR"]) { $userIP = $_SERVER["HTTP_X_FORWARDED_FOR"]; } elseif (isset($_SERVER["REMOTE_ADDR"]) && $_SERVER["REMOTE_ADDR"]) { $userIP = $_SERVER["REMOTE_ADDR"]; } else { $userIP="This user has no ip";} //GET IP ADRESS END //if(!isset($_SESSION['USERID']))($SRCUUID=$_SESSION['USERID']); if(isset($_GET['Name'])){$_SESSION['AVATAR']=$_GET['Name'];} //echo $_SESSION['AVATAR']; if(!isset($_GET['aktion']) || $_GET['aktion']==""){ if(!isset($_POST['action']) || $_POST['action']==""){ ?>

TanGLe Grid Registration Form

New Avatar First Name*

New Avatar Last Name*

query("SELECT lastnames FROM ".C_ADM_TBL.""); list($LASTNAMESC) = $DbLink->next_record(); if($LASTNAMESC=="1"){ ?>

Avatar Password*

First Name *

Last Name *

Address*

Zip*

City*

Country*

Date of Birth*

Email*

Confirm Email*

Accept Terms Of Service*

<= Must check Link to Terms Of Service

Accept Privacy Statement*

<= Must check Link to Privacy Statement

query("SELECT startregion FROM ".C_ADM_TBL.""); list($adminregion) = $DbLink->next_record(); $_SESSION['REGIONID'] = $adminregion; } $_SESSION['EMAIL'] = $_POST['email']; $_SESSION['EMAIC'] = $_POST['emaic']; $_SESSION['PASSWD'] = $_POST['wordpass']; $_SESSION['TOS'] = $_POST['TOS']; $_SESSION['PRIVACY'] = $_POST['Privacy']; if(isset($_POST['tag'])) { $tag= $_POST['tag']; } else { $tag = ""; } if(isset($_POST['monat'])) { $tag= $_POST['monat']; } else { $monat = ""; } if(isset($_POST['yahr'])) { $tag= $_POST['jahr']; } else { $jahr = ""; } $tag2=date("d",time()); $monat2=date("m",time()); $jahr2=date("Y",time()); $jahr=$jahr-18; $jahr2=$jahr2-18; $agecheck1=$tag+$monat+$jahr; $agecheck2=$tag2+$monat2+$jahr2; // echo "Got this far.
\n"; // echo $_SESSION["TOS"]; if(($_SESSION['PASSWD'] == '')or($_SESSION['NAMEF'] != trim($_SESSION['NAMEF']))or($_SESSION['NAMEL'] != trim($_SESSION['NAMEL']))or($_SESSION['EMAIC'] == '')or($_SESSION['EMAIL'] == '')or($_SESSION['CITY'] == '')or($_SESSION['ZIP'] == '')or($_SESSION['ADRESS'] == '')or($_SESSION['NAMEL'] == '')or($_SESSION['NAMEF'] == '')or($_SESSION['ACCFIRST'] == '')or($_SESSION['ACCLAST'] == '')or($_SESSION['TOS'] !='TOS')or($_SESSION['PRIVACY'] !='Privacy')){ if($_SESSION['EMAIC'] == '') { $_SESSION['ERROR']="Please confirm your email"; } if($_SESSION['NAMEF'] != trim($_SESSION['NAMEF'])) { $_SESSION['ERROR']="Please remove space in first name"; } if($_SESSION['NAMEL'] != trim($_SESSION['NAMEL'])) { $_SESSION['ERROR']="Please remove space in last name"; } if($_SESSION['PASSWD'] == '') { $_SESSION['ERROR']="Please enter your Password"; } if($_SESSION['EMAIL'] == '') { $_SESSION['ERROR']="Please enter your Email address"; } if($_SESSION['CITY'] == '') { $_SESSION['ERROR']="Please enter your City"; } if($_SESSION['ZIP'] == '') { $_SESSION['ERROR']="Please enter your ZIP"; } if($_SESSION['ADRESS'] == '') { $_SESSION['ERROR']="Please enter your address"; } if($_SESSION['NAMEL'] == '') { $_SESSION['ERROR']="Please enter your real last name"; } if($_SESSION['NAMEF'] == '') { $_SESSION['ERROR']="Please enter your real first name"; } if($_SESSION['ACCFIRST'] == "") { $_SESSION['ERROR']="Please enter a first name for your account"; } if($_SESSION['ACCLAST'] == "") { $_SESSION['ERROR']="Please enter a last name for your account"; } if($_SESSION['TOS'] != "TOS") { $_SESSION['ERROR']="Please read and click TOS box"; } if($_SESSION['PRIVACY'] != "Privacy") { $_SESSION['ERROR']="Please read and click Privacy box"; } echo ""; }else{ ?>

query("SELECT Firstname FROM ".C_USERS_TBL." WHERE FirstName='".$_SESSION['ACCFIRST']."' and LastName='".$_SESSION['ACCLAST']."'"); list($NAMECHECK1) = $DbLink->next_record(); $DbLink->query("SELECT FirstName FROM ".C_USERS_TBL." WHERE FirstName='".$_SESSION['ACCFIRSTL']."' and LastName='".$_SESSION['ACCLAST']."'"); list($NAMECHECK2) = $DbLink->next_record(); $DbLink->query("SELECT emailadress FROM ".C_WIUSR_TBL." WHERE emailadress='".$_SESSION['EMAIL']."'"); list($EMAILCHECK) = $DbLink->next_record(); $DbLink->query("SELECT agentIP FROM ".C_USRBAN_TBL." WHERE agentIP='$userIP'"); list($IPCHECK) = $DbLink->next_record(); //echo "DB check"; // $EMAILCHECK = false; if($EMAILCHECK){ $_SESSION['ERROR']="This email address is already in use"; echo ""; }else if($NAMECHECK1){ $_SESSION['ERROR']="This account name is already in use"; echo ""; }else if($NAMECHECK2){ $_SESSION['ERROR']="This account name is already in use"; echo ""; }else if($IPCHECK){ $_SESSION['ERROR']="This IP adress is banned"; echo ""; }else{ if($_SESSION['EMAIL']==$_SESSION['EMAIC']){ $_SESSION['ACTION']="THX"; $_SESSION['ERROR']=""; echo ""; }else{ $_SESSION['ERROR']="Email confirmation not correct"; echo ""; } } } } }else if($_GET['aktion']=="ok"){ if(($_SESSION['PASSWD'] == '')or($_SESSION['NAMEF'] != trim($_SESSION['NAMEF']))or($_SESSION['NAMEL'] != trim($_SESSION['NAMEL']))or($_SESSION['EMAIC'] == '')or($_SESSION['EMAIL'] == '')or($_SESSION['CITY'] == '')or($_SESSION['ZIP'] == '')or($_SESSION['ADRESS'] == '')or($_SESSION['NAMEL'] == '')or($_SESSION['NAMEF'] == '')or($_SESSION['ACCFIRST'] == '')){ }else{ if(($_SESSION['ERROR'] == '') and ($_SESSION['ACTION'] == 'THX')) { $passneu = $_SESSION['PASSWD']; // $passwordHash = md5(md5($passneu) . ":" ); $DbLink->query("SELECT firstname FROM ".C_USERS_TBL." where firstname='".$_SESSION['ACCFIRST']."' and lastname='".$_SESSION['ACCLAST']."' "); list($USERCHECK) = $DbLink->next_record(); $DbLink->query("SELECT firstname FROM ".C_USERS_TBL." where firstname='".$_SESSION['ACCFIRSL']."' and lastname='".$_SESSION['ACCLAST']."' "); list($USERCHE2CK) = $DbLink->next_record(); if(($USERCHECK) or ($USERCHE2CK)){ $_SESSION['ERROR']="User already exists in Database"; echo "