Files
Testing/mailservices/admin/usermgr/update_user_field.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

93 lines
2.5 KiB
PHP

<?php header('Content-type: application/json');
$em="";
if ( !defined('PATHTOINCLUDES') ) define('PATHTOINCLUDES', $_SERVER["DOCUMENT_ROOT"] . '/mailservices/includes/');
include(PATHTOINCLUDES."base.php");
$dconn=dbconnect2();
$fieldname=$_POST["fieldname"];
$fieldvalue=$_POST["fieldvalue"];
$orig_value=$_POST["origvalue"];
$table_name=$_POST["thetable"];
$req=$_POST["req"];
$min=$_POST["min"];
$max=$_POST["max"];
$ncrypt=$_POST["ncrypt"];
$dtype=$_POST["dtype"];
date_default_timezone_set('UTC');
$thedate=date("Y-m-d H:i:s");
if($dtype=="date")
{
if(is_date($fieldvalue))
{
$fieldvalue=strtotime($fieldvalue);
$fieldvalue=date('Y-m-d H:i:s',$fieldvalue);
}
else
{
$em="Please enter a valid date (mm/dd/yyyy)!";
}
}
if($dtype=="phone"){$dtype="text";}
if($dtype=="password"){$dtype="text";}
if($dtype=="email"){$dtype="text";}
if($ncrypt=="Y"){$ps=1;} else {$ps=0;}
if($fieldname=="username"){$ps=2;}
if($fieldname=="email"){$ps=2;}
if($fieldname=="dept") {$fieldname="department";}
if($fieldname=="telephone") {$fieldname="phone";}
if($fieldname=="username") {$fieldname="user";}
if($fieldname=="fname") {$fieldname="firstname";}
if($fieldname=="lname") {$fieldname="lastname";}
if($table_name=="user_temp"){$theuid=$_SESSION["adduserid"];} else {$theuid=$_SESSION["euuid"];}
if($ps==0){
$sql="UPDATE ".$table_name." SET ".$fieldname."=".GetSQLValueString($fieldvalue, $dtype)."
WHERE uid = ".$theuid;
$query=mysql_query($sql) or $em=$em.mysql_error();
}
elseif($ps==1)
{
$sql="UPDATE ".$table_name." SET ".$fieldname." = AES_ENCRYPT(".GetSQLValueString($fieldvalue, $dtype).",'".$wordgames."')
WHERE uid = ".$theuid;
$query=mysql_query($sql) or $em=$em.mysql_error();
}
elseif($ps==2)
{
//check for duplicate - username or email
if($orig_value != $fieldvalue || $orig_value=="")
{
$sqldupuser="SELECT count(`users`.`".$fieldname."`) AS CID
FROM `users`
WHERE `users`.`".$fieldname."` = AES_ENCRYPT('".$fieldvalue."','".$wordgames."')";
$rsCheck = mysql_query($sqldupuser) or $em=$em.mysql_error();
$numrow = mysql_result($rsCheck,0);
echo $sqldupuser;
}
else
{
$numrow=0;
}
if($numrow !=0)
{
$em="Duplicate entry. Field not updated";
}
else
{
$sql="UPDATE ".$table_name." SET ".$fieldname."=AES_ENCRYPT(".GetSQLValueString($fieldvalue, $dtype).",'".$wordgames."')
WHERE uid = ".$theuid;
$query=mysql_query($sql) or $em=$em.mysql_error();
}
}
$arr = array ('error'=>$em);
echo json_encode($arr);
//Philip Poremba 05/02/2012
//we won't be encrypting username and password and null value is not acceptable
?>