<?php

 include("../artzone/connect.php");

 $phpbbpass=MD5($pass);
 $phpbbregdate=time();

	//Connection à la database pour connaître le numéro de userid
	$phpbbrequete1="SELECT user_id from ".$extension2."users order by user_id desc limit 0,1";
	$phpbbsql=mysql_query($phpbbrequete1, $link);
	$phpbb10=mysql_fetch_object($phpbbsql);
	$nbid=$phpbb10->user_id;

        $phpbbresult=$nbid+1;

                      
 /* ajout table users */
  
	 $requetebb="INSERT into ".$extension2."users set user_id='$phpbbresult', user_active='1', username='$login', user_style='1', user_regdate='$phpbbregdate', user_lang='french', user_dateformat='D M d, Y g:i a', user_email='$mail', user_website='$url', user_from='$ville', user_occ='$metier', user_password='$phpbbpass'";
	 $resultbb=mysql_query($requetebb, $link);

 /* ajout table groups */

	 $requetebb2="INSERT into ".$extension2."groups set group_type='1', group_description='Personal User', group_moderator='0', group_single_user='1'";
	 $resultbb2=mysql_query($requetebb2, $link);

 /* ajout table user_group */

	$phpbbrequete2="SELECT group_id from ".$extension2."groups order by group_id desc limit 0,1";
	$phpbbsql1=mysql_query($phpbbrequete2, $link);
	$phpbb100=mysql_fetch_object($phpbbsql1);
	$group100=$phpbb100->group_id;

	 $requetebb3="INSERT into ".$extension2."user_group set group_id='$group100', user_id='$phpbbresult', user_pending='0'";
	 $resultbb3=mysql_query($requetebb3, $link);




	mysql_close($link);



?>