Weblabor

<?php
	if($_GET) {
		$email = $_GET['email'];
		require_once('connect.php');
		$query = sprintf("SELECT COUNT(id) FROM users WHERE email = '%s' AND confirmed=0",
			mysql_real_escape_string($email));
		$result = mysql_query($query);
		list($count) = mysql_fetch_row($result);
		if($count >= 1) {
			$query = sprintf("UPDATE users SET confirmed=1 WHERE email = '%s'",
				mysql_real_escape_string($email));
			mysql_query($query);
?>
<span style='color:green'>Gratulálok, sikeresen aktiváltad az emailodat!</span>
<?php
		} else {
?>
<span style='color:red'>Nincs ilyen email a rendszerben.</span>
<?php
		}
	}
?>

$query = sprintf("INSERT INTO users(lang) VALUES ('%s');",
mysql_real_escape_string($_POST['lang']));

if($_POST) {
/*Ezt a sort hova rakjam?*/if (isset($_POST['lang']) && ($_POST['lang']==='EN' || $_POST['lang']==='HU')) {$lang=$_POST['lang'];
		$password = $_POST['password'];
		$confirm = $_POST['confirm'];	
		if($password != $confirm) { ?>
<span style='color:red'>A két jelszó nem egyezik!</span>
		
<?php	
}/*Ebben mit rontottam el?*/	elseif($_POST['lang']!='HU' || $_POST['lang']!='EN') {?>
<span style='color:red'>Válassz nyelvet!</span>		
<?php
    } else {
			include('connect.php');
//és a többi

include('connect.php');
$username = $_POST['username'];
$email = $_POST['email'];
$password = $_POST['password'];
$confirm = $_POST['confirm'];

if($_POST) {
	if (strlen($_POST['username'])<6){
		$hiba[] = "A felhasználónévnek minimum 6 karakternek kell lennie!"
	}
	$query = sprintf("SELECT COUNT(id) FROM users WHERE UPPER(username) = UPPER('%s')",
		mysql_real_escape_string($_POST['username']));
	$result = mysql_query($query);
	list($count) = mysql_fetch_row($result);
	if($count >= 1) { 
		$hiba[] = "<span style='color:red'>A felhasználónév foglalt.</span>"
	}
	if (strlen($_POST['email'])<=0) {
		$hiba[] = "Helyes email címet adj meg!"
		} else {
			if (isset($_POST['email'])){
				$query = sprintf("SELECT COUNT(id) FROM users WHERE UPPER(email) = UPPER('%s')",
					mysql_real_escape_string($_POST['email']));
				$result = mysql_query($query);
				list($count) = mysql_fetch_row($result);
				if($count >= 1) { 
				$hiba[] = "<span style='color:red'>Ezzel az email címmel már regisztráltak.</span>"
				}
			}
		}
	if (strlen($_POST['password'])<6){
		$hiba[] = "<span style='color:red'>A jelszónak minimum 6 karakternek kell lennie.</span>"
	} else {
		if($password != $confirm) {
			$hiba[] = "<span style='color:red'>A két jelszó nem egyezik!</span>"
		}
	}
	if (isset($_POST['lang']) && ($_POST['lang']==='EN' || $_POST['lang']==='HU')) {  
		lang=$_POST['lang'];
	} else {
		$hiba[] = "Válassz nyelvet."
	}
}

foreach($hiba as $errormessange)
	{
		print"$errormessange</br>";
	}

$query = sprintf("SELECT COUNT(confirmed) FROM users WHERE UPPER(username) = UPPER('%s') AND confirmed='%s'",
			mysql_real_escape_string($username),
			mysql_real_escape_string($password);
		$result = mysql_query($query);
		list($count) = mysql_fetch_row($result);
		if($count != 1) {print"a felhasználó még nincs aktiválva";}

$query = sprintf("SELECT COUNT(confirmed) FROM users WHERE UPPER(username) = UPPER('%s') AND confirmed='%s'",  
mysql_real_escape_string($username),  
mysql_real_escape_string($password);  
$result = mysql_query($query);  
list($count) = mysql_fetch_row($result);  
if($count != 1) {print"a felhasználó még nincs aktiválva";}