File: /var/www/content-sp/work-sp/functions.php
<?php
function userHistory($editor_id, $editor_name, $session_id, $user_ip, $encodeArray)
{
@include 'config.php';
$curDateTime = date('Y-m-d H:i:s');
$conn->query("INSERT into csp_user_session_history set user_id='$editor_id',user_name='$editor_name',session_id='$session_id',ip_address='',description='$encodeArray',datetime='$curDateTime'");
// echo $conn->error;
}
if (!empty($_SESSION['editor'])) {
$editorArray = json_decode($_SESSION['editor']);
$editor_name = $editorArray->e_name;
$editor_id = $editorArray->eId;
$session_id = session_id();
$serverParams = $_SERVER;
// print_r($serverParams);
$user_ip = $serverParams['REMOTE_ADDR'];
$reqUri = $serverParams['REQUEST_URI'];
$scriptName = $serverParams['SCRIPT_NAME'];
$queryString = $serverParams['QUERY_STRING'];
$scriptFile = $serverParams['SCRIPT_FILENAME'];
$serverPort = $serverParams['SERVER_PORT'];
$referer = @$serverParams['HTTP_REFERER'];
$userAgent = $serverParams['HTTP_USER_AGENT'];
$reqTime = $serverParams['REQUEST_TIME'];
$descArray = array($reqUri, $scriptName, $queryString, $scriptFile, $serverPort, $referer, $userAgent, $reqTime,$user_ip);
$encodeArray = json_encode($descArray);
// include_once 'functions.php';
userHistory($editor_id, $editor_name, $session_id, $user_ip, $encodeArray);
}