258 lines
12 KiB
PHP
258 lines
12 KiB
PHP
|
|
<?php header('Content-type: text/html; charset=utf-8');
|
||
|
|
if ( !defined('PATHTOINCLUDES') ) define('PATHTOINCLUDES', $_SERVER["DOCUMENT_ROOT"] . '/mailservices/includes/');
|
||
|
|
include(PATHTOINCLUDES."base.php");
|
||
|
|
//Written by Philip Poremba 05/02/2012
|
||
|
|
|
||
|
|
$dconn=dbconnect2();
|
||
|
|
$em="";
|
||
|
|
$_SESSION["user_uri"]="/mailservices/admin/usermgr/edit_user.php";
|
||
|
|
$_SESSION["pagename"]="Edit User Account";
|
||
|
|
$_SESSION["the_section_location"] = "/mailservices/admin/usermgr/edit_user.php";
|
||
|
|
$_SESSION["the_section_container"]="section_content";
|
||
|
|
$_SESSION["the_tab"]="four";
|
||
|
|
//set defaults for form fields
|
||
|
|
|
||
|
|
if(isset($_GET["uid"])){$_SESSION["euuid"]=$_GET["uid"];}
|
||
|
|
|
||
|
|
|
||
|
|
$sql="SELECT
|
||
|
|
`users`.`uid`,
|
||
|
|
`users`.`firstname`,
|
||
|
|
`users`.`mi`,
|
||
|
|
AES_DECRYPT(`users`.`lastname`,'".$wordgames."') AS lname,
|
||
|
|
`users`.`title`,
|
||
|
|
`users`.`department`,
|
||
|
|
AES_DECRYPT(`users`.`email`,'".$wordgames."') AS uemail,
|
||
|
|
AES_DECRYPT(`users`.`phone`,'".$wordgames."') AS uphone,
|
||
|
|
AES_DECRYPT(`users`.`cellphone`,'".$wordgames."') AS ucellphone,
|
||
|
|
AES_DECRYPT(`users`.`fax`,'".$wordgames."') AS ufax,
|
||
|
|
AES_DECRYPT(`users`.`user`,'".$wordgames."') AS uuser,
|
||
|
|
AES_DECRYPT(`users`.`pass`,'".$wordgames."') as upass,
|
||
|
|
`users`.`admin`,
|
||
|
|
`users`.`default_admin`,
|
||
|
|
`users`.`lastupdate`,
|
||
|
|
`users`.`cdate`
|
||
|
|
FROM
|
||
|
|
`users`
|
||
|
|
WHERE `users`.`uid`=".$_SESSION["euuid"];
|
||
|
|
$result=mysql_query($sql) or $em=$em.mysql_error();
|
||
|
|
$a=mysql_fetch_assoc($result);
|
||
|
|
|
||
|
|
$sqlgroup="SELECT
|
||
|
|
`groups`.`gid`,
|
||
|
|
`groups`.`group`
|
||
|
|
FROM
|
||
|
|
`groups`
|
||
|
|
ORDER BY
|
||
|
|
`groups`.`group` ASC";
|
||
|
|
$qgroups=mysql_query($sqlgroup) or $em=$em.mysql_error();
|
||
|
|
$sqlug="SELECT
|
||
|
|
`user_group`.`gid`, `user_group`.`admin`
|
||
|
|
FROM
|
||
|
|
`user_group`
|
||
|
|
WHERE `user_group`.`uid` = ".$_SESSION["euuid"];
|
||
|
|
$qug=mysql_query($sqlug) or $em=$em.mysql_error();;
|
||
|
|
$gid=array();
|
||
|
|
$ov=array();
|
||
|
|
$i=0;
|
||
|
|
while ($row = mysql_fetch_assoc($qug))
|
||
|
|
{
|
||
|
|
$gid[$i]["gid"]=$row["gid"];
|
||
|
|
$gid[$i]["admin"]=$row["admin"];
|
||
|
|
$ov[$i]=$row["gid"];
|
||
|
|
$i++;
|
||
|
|
}
|
||
|
|
mysql_free_result($qug);
|
||
|
|
$arraylength=count($ov);
|
||
|
|
$gidlength=count($gid);
|
||
|
|
sort($gid);
|
||
|
|
|
||
|
|
if($ov !="")
|
||
|
|
{
|
||
|
|
$orig_group=implode(",",$ov);
|
||
|
|
$orig_group=stripslashes($orig_group);
|
||
|
|
}
|
||
|
|
|
||
|
|
$fname=$a["firstname"];
|
||
|
|
$mi=$a["mi"];
|
||
|
|
$lname=$a["lname"];
|
||
|
|
$dept=$a["department"];
|
||
|
|
$title=$a["title"];
|
||
|
|
$telephone=$a["uphone"];
|
||
|
|
$cellphone=$a["ucellphone"];
|
||
|
|
$fax=$a["ufax"];
|
||
|
|
$email=$a["uemail"];
|
||
|
|
$username=$a["uuser"];
|
||
|
|
$pass=$a["upass"];
|
||
|
|
$admin=$a["admin"];
|
||
|
|
?>
|
||
|
|
<div id="container" class="standard-form" style="padding-bottom:30px;">
|
||
|
|
<div class="form-container">
|
||
|
|
<form name="formedituser" id="formedituser" action="">
|
||
|
|
<fieldset>
|
||
|
|
<legend>
|
||
|
|
<h1>
|
||
|
|
Edit User -
|
||
|
|
<?php echo $fname." ".$lname;?>
|
||
|
|
</h1>
|
||
|
|
</legend>
|
||
|
|
<div id="cfname" class="iholder">
|
||
|
|
<label for="fname">First Name:</label>
|
||
|
|
<input name="fname" id="fname" required pattern="\S" class="text"
|
||
|
|
type="text" size="24" maxlength="90" value="<?php echo $fname; ?>"
|
||
|
|
onblur="submit_form_item('fname','section_content','/mailservices/admin/usermgr/update_user_field.php','users','Please enter the user\'s First Name!','N');" />
|
||
|
|
<span class="frmrequired">(*required)</span>
|
||
|
|
<span class="errormsg" id="e_fname">Please enter the user's First Name!</span>
|
||
|
|
<input type="hidden" name="o_fname" id="o_fname" value="<?php echo $fname; ?>" />
|
||
|
|
|
||
|
|
</div>
|
||
|
|
<div id="cmi" class="iholder">
|
||
|
|
<label for="mi">M.I.:</label>
|
||
|
|
<input name="mi" id="mi" type="text" class="text"
|
||
|
|
size="3" value="<?php echo $mi; ?>" maxlength="5"
|
||
|
|
onblur="submit_form_item('mi','section_content','/mailservices/admin/usermgr/update_user_field.php','users','','N');" />
|
||
|
|
<span class="errormsg" id="e_mi"></span>
|
||
|
|
<input type="hidden" name="o_mi" id="o_mi" value="<?php echo $mi; ?>" />
|
||
|
|
</div>
|
||
|
|
<div id="clname" class="iholder">
|
||
|
|
<label for="lname">Last Name:</label>
|
||
|
|
<input name="lname" id="lname" required pattern="\S" class="text"
|
||
|
|
type="text" size="24" maxlength="90" value="<?php echo $lname; ?>"
|
||
|
|
onblur="submit_form_item('lname','section_content','/mailservices/admin/usermgr/update_user_field.php','users','Please enter the user\'s Last Name!','Y');" />
|
||
|
|
<span class="frmrequired">(*required)</span>
|
||
|
|
<span class="errormsg" id="e_lname">Please enter the user's Last Name!</span>
|
||
|
|
<input type="hidden" name="o_lname" id="o_lname" value="<?php echo $lname; ?>" />
|
||
|
|
</div>
|
||
|
|
<div id="cdept" class="iholder">
|
||
|
|
<label for="dept">Department:</label>
|
||
|
|
<input name="dept" id="dept" type="text" size="24" class="text"
|
||
|
|
value="<?php echo $dept; ?>" maxlength="100"
|
||
|
|
onblur="submit_form_item('dept','section_content','/mailservices/admin/usermgr/update_user_field.php','users','','N');" />
|
||
|
|
<span class="errormsg" id="e_dept"></span>
|
||
|
|
<input type="hidden" name="o_dept" id="o_dept" value="<?php echo $dept; ?>" />
|
||
|
|
</div>
|
||
|
|
<div id="ctitle" class="iholder">
|
||
|
|
<label for="title">Title:</label>
|
||
|
|
<input name="title" id="title" type="text" size="30" class="text"
|
||
|
|
value="<?php echo $title; ?>" maxlength="100"
|
||
|
|
onblur="submit_form_item('title','section_content','/mailservices/admin/usermgr/update_user_field.php','users','','N');" />
|
||
|
|
<span class="errormsg" id="e_title"></span>
|
||
|
|
<input type="hidden" name="o_title" id="o_title" value="<?php echo $title; ?>" />
|
||
|
|
</div>
|
||
|
|
<div id="ctelephone" class="iholder">
|
||
|
|
<label for="telephone">Telephone:</label>
|
||
|
|
<input name="telephone" pattern="^\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$" class="phone"
|
||
|
|
id="telephone" type="text" size="20" value="<?php echo $telephone; ?>" maxlength="20"
|
||
|
|
onblur="submit_form_item('telephone','section_content','/mailservices/admin/usermgr/update_user_field.php','users','Please enter a valid phone number!','Y');" />
|
||
|
|
<span class="errormsg" id="e_telephone">Please enter a valid phone number!</span>
|
||
|
|
<input type="hidden" name="o_telephone" id="o_telephone" value="<?php echo $telephone; ?>" />
|
||
|
|
</div>
|
||
|
|
|
||
|
|
<div id="ccellphone" class="iholder">
|
||
|
|
<label for="cellphone">Cellphone:</label>
|
||
|
|
<input name="cellphone" pattern="^\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$" class="phone"
|
||
|
|
id="cellphone" type="text" size="20" value="<?php echo $cellphone; ?>" maxlength="20"
|
||
|
|
onblur="submit_form_item('cellphone','section_content','/mailservices/admin/usermgr/update_user_field.php','users','Please enter a valid cellphone number!','Y');" />
|
||
|
|
<span class="errormsg" id="e_cellphone">Please enter a valid phone number!</span>
|
||
|
|
<input type="hidden" name="o_cellphone" id="o_cellphone" value="<?php echo $cellphone; ?>" />
|
||
|
|
</div>
|
||
|
|
<div id="cfax" class="iholder">
|
||
|
|
<label for="fax">Fax:</label>
|
||
|
|
<input name="fax" id="fax" type="text" pattern="^\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$" class="phone"
|
||
|
|
size="20" value="<?php echo $fax; ?>" maxlength="20"
|
||
|
|
onblur="submit_form_item('fax','section_content','/mailservices/admin/usermgr/update_user_field.php','users','Please enter a valid fax number!','Y');" />
|
||
|
|
<span class="errormsg" id="e_fax">Please enter a valid fax number!</span>
|
||
|
|
<input type="hidden" name="o_fax" id="o_fax" value="<?php echo $fax; ?>" />
|
||
|
|
</div>
|
||
|
|
<div id="cemail" class="iholder">
|
||
|
|
<label for="email">Email:</label>
|
||
|
|
<input name="email" id="email" required pattern='^(([^<>()[\]\\.,;:\s@\"]+(\.[^<>()[\]\\.,;:\s@\"]+)*)|(\".+\"))@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\])|(([a-zA-Z\-0-9]+\.)+[a-zA-Z]{2,}))$' class="email"
|
||
|
|
type="text" size="30" value="<?php echo $email; ?>" maxlength="255"
|
||
|
|
onblur="submit_form_item('email','section_content','/mailservices/admin/usermgr/update_user_field.php','users','Please enter a valid email address!','Y');" />
|
||
|
|
<span class="frmrequired">(*required)</span>
|
||
|
|
<span class="errormsg" id="e_email">Please enter a valid email address!</span>
|
||
|
|
<input type="hidden" name="o_email" id="o_email" value="<?php echo $email; ?>" />
|
||
|
|
</div>
|
||
|
|
<div id="cusername" class="iholder">
|
||
|
|
|
||
|
|
|
||
|
|
<label for="username">Username:</label>
|
||
|
|
<input name="username" id="username" type="text" size="30" class="text" required pattern="^([a-zA-Z0-9,\./<>\?;\:[\]\\{}\|`~!@#\$%\^&\*()-_=\+]{8,32})$"
|
||
|
|
value="<?php echo $username; ?>" maxlength="32"
|
||
|
|
onblur="submit_form_item('username','section_content','/mailservices/admin/usermgr/update_user_field.php','users','Please enter a valid username 8 to 32 characters long!','Y',8,32);" />
|
||
|
|
<span class="frmrequired">(*required, 8 to 32 char.)</span>
|
||
|
|
<span class="errormsg" id="e_username">Please enter a valid username 8 to 32 characters long!</span>
|
||
|
|
<input type="hidden" name="o_username" id="o_username" value="<?php echo $username; ?>" />
|
||
|
|
</div>
|
||
|
|
<div id="cpass" class="iholder">
|
||
|
|
<label for="pass">Password:</label>
|
||
|
|
<input name="pass" id="pass" type="text" size="30" class="password" required pattern="^([a-zA-Z0-9,\./<>\?;\:[\]\\{}\|`~!@#\$%\^&\*()-_=\+]{8,32})$"
|
||
|
|
value="<?php echo $pass; ?>" maxlength="32"
|
||
|
|
onblur="submit_form_item('pass','section_content','/mailservices/admin/usermgr/update_user_field.php','users','Please enter a valid password 8 to 32 characters long!','Y',8,32);" />
|
||
|
|
<span class="frmrequired">(*required, 8 to 32 char.)</span> <span
|
||
|
|
class="errormsg" id="e_pass">Please enter a valid password 8 to 32 characters long!</span>
|
||
|
|
<input type="hidden" name="o_pass" id="o_pass" value="<?php echo $pass; ?>" />
|
||
|
|
</div>
|
||
|
|
<div id="cgroup_membership" style="padding-bottom:18px;">
|
||
|
|
<h3>User Rights</h3>
|
||
|
|
<ul id="urights">
|
||
|
|
<li class="ul-heading" style="background:transparent;">
|
||
|
|
<ul style="background:transparent;">
|
||
|
|
<li class="li-first" style="background:transparent;">Group</li>
|
||
|
|
<li class="li-last" style="background:transparent;">Group Adminstrator</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<?php $rnum=0;while ($g = mysql_fetch_assoc($qgroups)){$rnum++;
|
||
|
|
$gsel="";
|
||
|
|
$asel="";
|
||
|
|
for ($i = 0; $i < $gidlength; $i++)
|
||
|
|
{
|
||
|
|
if($gid[$i]["gid"]==$g["gid"])
|
||
|
|
{
|
||
|
|
$gsel="checked=\"checked\"";
|
||
|
|
|
||
|
|
if($gid[$i]["admin"]=="Y")
|
||
|
|
{
|
||
|
|
$asel="checked=\"checked\"";
|
||
|
|
}
|
||
|
|
break;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
<li class="ul-rows">
|
||
|
|
<ul>
|
||
|
|
<li class="li-left"><input type="checkbox" id="group_<?php echo $rnum;?>"
|
||
|
|
name="group_<?php echo $rnum;?>" id="group_<?php echo $rnum;?>" <?php echo $gsel;?>
|
||
|
|
onclick="update_rights('group_<?php echo $rnum;?>',0,'aa','/mailservices/admin/usermgr/user_rights_act.php','user_group','<?php echo $rnum;?>',0,<?php echo $g["gid"];?>)" /></li>
|
||
|
|
<li class="li-middle"><?php echo $g["group"];?></li>
|
||
|
|
<li class="li-right"><input type="checkbox"
|
||
|
|
id="group_admin_<?php echo $rnum;?>"
|
||
|
|
name="group_admin_<?php echo $rnum;?>" <?php echo $asel; ?>
|
||
|
|
onclick="update_rights('group_admin_<?php echo $rnum;?>',0,'Please check the group checkbox first','/mailservices/admin/usermgr/user_rights_act.php','user_group','<?php echo $rnum;?>',1,<?php echo $g["gid"];?>)" />
|
||
|
|
<input type="hidden" id="group_id_<?php echo $rnum;?>" name="group_id_<?php echo $rnum;?>" value="<?php echo $g["gid"];?>" />
|
||
|
|
<span class="errormsg" id="e_group_admin_<?php echo $rnum; ?>"></span>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<?php } ?>
|
||
|
|
</ul>
|
||
|
|
<input type="hidden" id="o_group_membership" name="o_group_membership" value="<?php echo $orig_group;?>" />
|
||
|
|
</div>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
<div class="submit-button" style="position:relative;">
|
||
|
|
<label> </label>
|
||
|
|
<input type="button"
|
||
|
|
name="update_user" id="update_user" value="Update Account"
|
||
|
|
class="redbutton submit-btn" style="width:200px;position:relative;" onclick="submit_update_user('formedituser','update_user_error')" />
|
||
|
|
<div id="update_user_error" style="position:absolute;top:-60px;left:35px;width:400px;background:green;height:40px;display:none;"></div>
|
||
|
|
</div>
|
||
|
|
|
||
|
|
</fieldset>
|
||
|
|
</form>
|
||
|
|
</div>
|
||
|
|
<!-- end formcontainer -->
|
||
|
|
</div>
|
||
|
|
<!-- end container -->
|