<?php require_once('header.php'); ?>
<?php
	session_start();
	include("db.php");
	include("functions.php");
	$username = clean($_POST[username]);
	$password = clean(md5($_POST[password]));
	$mail = clean($_POST[mail]);
	$action = clean($_GET[action]);
	$sexe = clean($_POST[Sexe]);

	if(isset($action) && $action == "sucess"){
		echo "$username, $password, $mail, $sexe";
		$query = "INSERT INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`, `group_id`, `state`, `unban_time`, `expiration_time`, `logincount`, `lastlogin`, `last_ip`, `birthdate`, `character_slots`, `pincode`, `pincode_change`)
		VALUES (NULL, '$username', '$password', '$sexe', '$mail', '0', '0', '0', '0', '0', NULL, '', NULL, '0', '', '0')" ;
	 $data= mysql_query($query); //or die ('Erreur SQL !'.$sql.'<br />'.mysql_error());
	 var_dump ($data);

	}
?>
		<br>
		<br>
		<!-- PAGE HEADER -->
		<section class="page_header">

			<!-- CONTAINER -->
			<div class="container">
				<h3 class="pull-left"><b>Inscription</b></h3>
			</div><!-- //CONTAINER -->
		</section><!-- //PAGE HEADER -->


		<!-- BLOG BLOCK -->
		<section class="blog">

			<!-- CONTAINER -->
			<div class="container">

				<!-- ROW -->
				<div class="row">

					<!-- BLOG LIST -->
					<div class="col-lg-9 col-md-9 col-sm-9 padbot30">
						<div class="kafra_reg"></div><br><br><div class="comment_right">
										<div class="comment_info">
											<div class="comment_registeration">Formulaire d'inscription</div>
											<div class="separator"></div>
										</div>
										<center>Si vous voulez jouer sur Caelum, il va falloir vous créer un compte, pour ça rien de tr&egrave;s compliqu&eacute;, veuillez remplir ce formulaire et me le retourner !<br><font color="red">Avant de vous connecter pensez &agrave; lire le r&egrave;glement !</font></center><br>

											<div class="separator"></div><br>
											<center>
												<font color="red">*</font> Nom d'utilisateur:
												<form class="credit_card_number_form clearfix" action="inscription.php?action=sucess" method="post">
													<input type="text" name="username"/>
													<font color="red">*</font> Mot de passe:
														<input type="password" name="password"/>
													<font color="red">*</font> E-mail:
														<input type="email" name="mail"/>
													<font color="red">*</font> Sexe:<br>
													<SELECT class="basic" name="Sexe" size=1>
														<OPTION>
														<OPTION>M
														<OPTION>F
													</SELECT>
													<br>
													<br>
													<button type="submit" class="btn btn-sm">Inscription</button>
												</form>
											</center>

									</div>
									<br>
									<br>
					</div><!-- //BLOG LIST -->
				<?php require_once('sidebar.php'); ?>
				</div><!-- //ROW -->
			</div><!-- //CONTAINER -->
		</section><!-- //BLOG BLOCK -->
<?php require_once('footer.php'); ?>