session_start(); /*if(!isset($_SESSION['id'])){ header("location:inicio.htm"); }*/ if($_GET['lan']!="es" and $_GET['lan']!="en" and $_GET['lan']!="fr" and $_GET['lan']!="po"){ header("location:inicio.htm"); } include_once("libgkp.php"); include_once("datinicial.etq"); $link = conectar(); $flag = false; if(isset($guardar)){ if(empty($_POST['i001']) or empty($_POST['i002']) or empty($_POST['i003']) or empty($_POST['i004']) or empty($_POST['i005']) or empty($_POST['i006'])){ $flag = true; } else { /*$q = mysql_query("SELECT correo FROM pwd where correo='".$_POST['i006']."'", $link); if (mysql_num_rows($q)>=1) { header("location:inicio.htm?lan=".$_GET['lan']."&msg=3"); exit; }*/ mysql_query("insert into insti(insti_nombre) values ('".$_POST['i001']."')", $link); $id = mysql_insert_id(); mysql_query("insert into tip_insti(insti_codigo, sector_codigo) values ($id, ".$_POST['i002'].")", $link); mysql_query("insert into pers(pers_nombre) values ('".$_POST['i004']."')", $link); $id1 = mysql_insert_id(); mysql_query("insert into pers_correo(pers_codigo, correo) values ($id1, '".$_POST['i006']."')", $link); mysql_query("insert into persona_clave(pers_codigo, insti_codigo) values ($id1, $id)", $link); mysql_query("insert into sede(insti_codigo, pais_codigo) values ($id, $i003)", $link); //////////////////// $psd = array("a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k", "m", "n", "o", "p", "q", "r", "s", "t", "u", "v", "x", "y", "z", "1", "2", "3", "4", "5", "6", "7", "8", "9", "0"); srand((float) microtime() * 10000000); $pasd = array_rand($psd, 10); $cad=""; for($i=0;$i < count($pasd);$i++){ $cad.=$psd[$pasd[$i]]; } mysql_query("insert into pwd (insti_codigo, correo, pwd, pwdmd5) values (".$id.", '".$_POST['i006']."', '$cad', '".md5($cad)."')", $link); mail("{$_POST['i006']}", "Clave para cuestionario GKP", "Para diligenciar el cuestionario su password es:\n\n\r$cad\n\n\rGracias por su participación.", "FROM: directorio@gkplac.org\n\r", "Bcc: ramon@funredes.org\n\r"); /////////////////// header("location:inicio.htm?lan=".$_GET['lan']."&msg=2&cor=".$_POST['i006']); exit; } } //****************************************************************************************************** if(isset($sector) and $i002o!=""){ //* mysql_query("insert into sector(sector_nombre_".$_GET['lan'].") values ('$i002o')", $link); //* $chk = mysql_insert_id(); //* } //* if(isset($pais) and $i003o!=""){ //* //$codigo = substr($i0011o, 0, 2); //* mysql_query("insert into pais(pais_nombre_".$_GET['lan'].") values ('$i003o')", $link);//* } //* //****************************************************************************************************** ?>