0){ // User exists $error = "Username '".$_POST['register']['new_username']."' already exists"; $_POST['register']['new_username'] = ''; }else{ $md5 = md5($_POST['register']['new_username']); $query = "INSERT INTO grammafone_users VALUES (NULL,\"".$_POST['register']['new_username']."\",\"".$_POST['register']['firstname']."\",\"".$_POST['register']['lastname']."\", PASSWORD(\"".$_POST['register']['password']."\"),1,NOW(),1,\"".$_POST['register']['email']."\",\"streaming\",0,\"s\",\"$md5\",\"\",\"\",1,\"\",\"\",0,0)"; if(mysql_query($query)){ if(!empty($_POST['invite_code'])){ $query2 = "DELETE FROM grammafone_invites WHERE invite_code=\"$_POST[invite_code]\""; mysql_query($query2); } header("Location: login.php?userAdded=".$_POST['register']['new_username']); } else{ echo $query."
".mysql_error(); } } } ?> <? echo $GLOBALS['server_title']; ?> | Login

First Name:
" tabindex=1 />

Last Name:
" tabindex=2 />

E-Mail Address:


Desired Username:
" tabindex=4 />

Password:

Retype Password:





"; } ?>

Already Registered? Login