51 lines
1.4 KiB
PHP
51 lines
1.4 KiB
PHP
<?php header('Content-type: application/json; charset=utf-8');
|
|
$em="";
|
|
if ( !defined('PATHTOINCLUDES') ) define('PATHTOINCLUDES', $_SERVER["DOCUMENT_ROOT"] . '/mailservices/includes/');
|
|
include(PATHTOINCLUDES."base.php");
|
|
$dconn=dbconnect2();
|
|
$auid=$_SESSION["adduserid"];
|
|
$_SESSION["adduserid"]="";
|
|
$newuid="";
|
|
$sql="INSERT INTO users (firstname,mi,lastname,title,department,email,phone,cellphone,fax,user,pass,createdby,cdate)
|
|
SELECT
|
|
`users_temp`.`firstname`,
|
|
`users_temp`.`mi`,
|
|
`users_temp`.`lastname`,
|
|
`users_temp`.`title`,
|
|
`users_temp`.`department`,
|
|
`users_temp`.`email`,
|
|
`users_temp`.`phone`,
|
|
`users_temp`.`cellphone`,
|
|
`users_temp`.`fax`,
|
|
`users_temp`.`user`,
|
|
`users_temp`.`pass`,
|
|
`users_temp`.`createdby`,
|
|
Now()
|
|
FROM
|
|
`users_temp`
|
|
WHERE `users_temp`.`uid` = ".$auid."";
|
|
$query=mysql_query($sql) or $em=$em.mysql_error();
|
|
|
|
if($em==""){
|
|
$newuid=mysql_insert_id();
|
|
$sql1a="UPDATE user_group_temp SET uid = ".$newuid." WHERE uid = ".$auid;
|
|
$query1a=mysql_query($sql1a) or $em=$em.mysql_error();
|
|
|
|
$sql2="INSERT INTO `user_group` (`gid`,`uid`,`admin`,`createdby`,`cdate`)
|
|
SELECT
|
|
`user_group_temp`.`gid`,
|
|
`user_group_temp`.`uid`,
|
|
`user_group_temp`.`admin`,
|
|
`user_group_temp`.`createdby`,
|
|
Now()
|
|
FROM
|
|
`user_group_temp`
|
|
WHERE `user_group_temp`.`uid` = ".$auid."";
|
|
$query2=mysql_query($sql2) or $em=$em.mysql_error();
|
|
}
|
|
|
|
if($em != ""){$_SESSION["adduserid"]=$auid;} else {$_SESSION["adduserid"]="";}
|
|
$arr = array ('error'=>$em,'newuid'=>$newuid);
|
|
echo json_encode($arr);
|
|
|
|
?>
|