38 lines
1.3 KiB
PHP
38 lines
1.3 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"];
|
|
$gid=$_POST["gid"];
|
|
$tablename=$_POST["thetable"];
|
|
if($table_name=="user_group_temp"){$theuid=$_SESSION["adduserid"];} else {$theuid=$_SESSION["euuid"];}
|
|
if($fieldname=="admin")
|
|
{
|
|
$sql="UPDATE ".$tablename." SET ".$fieldname." = '".$fieldvalue."' WHERE gid = ".$gid." AND uid = ".$theuid."";
|
|
$query=mysql_query($sql) or $em=$em.mysql_error();
|
|
}
|
|
if($fieldname=="gid")
|
|
{
|
|
if($fieldvalue=="N")
|
|
{
|
|
$sql="DELETE FROM ".$tablename." WHERE gid = ".$gid." AND uid = ".$theuid."";
|
|
$query=mysql_query($sql) or $em=$em.mysql_error();
|
|
}
|
|
else
|
|
{
|
|
date_default_timezone_set('UTC');
|
|
$thedate=date("Y-m-d H:i:s");
|
|
$sqlig=sprintf("INSERT INTO ".$tablename." (gid, uid, cdate, createdby)
|
|
VALUES (%s, %s, %s, %s)",
|
|
GetSQLValueString($gid, "int"),
|
|
GetSQLValueString($theuid, "int"),
|
|
GetSQLValueString($thedate, "date"),
|
|
GetSQLValueString($_SESSION["userid"], "int"));
|
|
$qig=mysql_query($sqlig) or $em=$em.mysql_error();
|
|
}
|
|
}
|
|
$arr = array ('error'=>$em);
|
|
echo json_encode($arr);
|
|
?>
|