93 lines
2.5 KiB
PHP
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
|
|
?>
|