function setHistory($options = array())
{
$defaultOptions = array();
$defaultOptions['page_name'] = '';
$defaultOptions['action_type'] = '';
$defaultOptions['table'] = '';
$defaultOptions['id_name'] = 'id';
$defaultOptions['id_value'] = '';
$defaultOptions['remote'] = false;
$defaultOptions['pname'] = '';
$options = array_merge($defaultOptions, $options);
extract($options);
$localcn = connectDB();
$user_id = $_SESSION['UserID'];
$user_name = $_SESSION['UserName'];
if ($localcn == '' || trim($action_type) == '' || trim($table) == '' || trim($id_value) == '' || trim($remote) == true && trim($pname) == '' || trim($action_type) != "add" && trim($action_type) != "delete" && trim($action_type) == 'edit') {
return false;
}
$connection_string = $localcn;
$remote_name = NULL;
if ($remote === true) {
$remoteCn = remote_connectDB($pname);
$connection_string = $remoteCn;
$remote_name = $pname;
}
$qry = "Select * from `{$table}` where {$id_name} = '{$id_value}'";
$res = Sql_exec($connection_string, $qry);
$result = Sql_fetch_assoc($res);
$value_json = json_encode($result);
if ($remoteCn) {
ClosedDBConnection($remoteCn);
rollback_main_connectDB();
}
if ($action_type == 'update') {
$comments = 'Updated !';
} elseif ($action_type == 'add') {
$comments = 'Inserted !';
}
$row_value = $value_json;
$action_command = $action_type;
if ($page_name == "") {
$page_name = $table;
}
$table_name = $table;
$action_date = date("Y-m-d", strtotime("now"));
$action_time = date("H:i:s", strtotime("now"));
$ip_address = $_SERVER['REMOTE_ADDR'];
$browser = $_SERVER['HTTP_USER_AGENT'];
$referrer = $_SERVER['HTTP_REFERER'];
$qry = "INSERT INTO tbl_audit_trail (user_id,user_name,action_command,pname,page_name,table_name,primary_key_column,action_date,action_time,rowvalue,comments,ip_address,browser,referer) VALUES";
$qry .= "('{$user_id}','{$user_name}','{$action_command}','{$remote_name}','{$page_name}','{$table_name}','{$id_name}','{$action_date}','{$action_time}','{$row_value}','{$comments}','{$ip_address}','{$browser}', '{$referrer}');";
$result = Sql_exec($localcn, $qry);
$insert_id = Sql_insert_id($localcn);
return $insert_id;
}
<?php
require_once "../lib/common.php";
$remoteCn = remote_connectDB('ISMP');
$qry = "SELECT \t`app_id`,`app_name`,`config` FROM `tbl_smsgw_config` WHERE `app_id` = 1 AND `app_name` = 'smsgw'";
$res = Sql_exec($remoteCn, $qry);
$dt = Sql_fetch_array($res);
$decode = $dt['config'];
$decode = json_decode($decode, true);
$data = array();
foreach ($decode as $key => $val) {
$data[$key] = $val;
}
$data['action_id'] = $dt['app_id'];
echo json_encode($data);
ClosedDBConnection($remoteCn);
//
//
//$remoteCnQry = "select * from tbl_process_db_access where pname='SMSGW'";
//$res = Sql_exec($cn, $remoteCnQry);
//$dt = Sql_fetch_array($res);
//
//$dbtype = $dt['db_type'];
//$Server = $dt['db_server'];
//$UserID = $dt['db_uid'];
//$Password = $dt['db_password'];
//$Database = $dt['db_name'];
//ClosedDBConnection($cn);
//
//$remoteCn = connectDB();
//
$remoteCn = remote_connectDB('SMSGW');
//$cn = connectDB();
$action = "";
$shortcode = "";
$keyword = "";
$SMSText = "";
$SrcType = "";
$URL = "";
$Status = "";
//$destination_context = "";
//$is_error = 1;
$action = mysql_real_escape_string(htmlspecialchars($_REQUEST['action']));
$data_info = isset($_REQUEST['info']) ? $_REQUEST['info'] : 'action';
if ($data_info != 'action') {
$action = $data_info['action'];
$deleted_id = $data_info['deleted_id'];
<?php
require_once "../lib/common.php";
$info = $_POST['info'];
$remoteCn = remote_connectDB('CGW');
$action = mysql_real_escape_string(htmlspecialchars($info['action']));
$action_id = mysql_real_escape_string(htmlspecialchars($info['action_id']));
$time_slot_id = mysql_real_escape_string(htmlspecialchars($info['time_slot_id']));
$start_day = mysql_real_escape_string(htmlspecialchars($info['start_day']));
$end_day = mysql_real_escape_string(htmlspecialchars($info['end_day']));
$start_time = mysql_real_escape_string(htmlspecialchars($info['start_time']));
$end_time = mysql_real_escape_string(htmlspecialchars($info['end_time']));
$is_error = 0;
if ($action == "insert") {
$qry = "INSERT INTO `timeslot` (`TimeSlotID`,`StartDay`,`EndDay`,`StartTime`,`EndTime`,`LastUpdate`,`is_active`)\n\t\t\t\tVALUES('{$time_slot_id}','{$start_day}','{$end_day}','{$start_time}','{$end_time}',NOW(),'active')";
} elseif ($action == "update") {
$qry = "UPDATE timeslot \n\t\t\t\tSET\n\t\t\t\t\t`StartDay` = {$start_day} , \n\t\t\t\t\t`EndDay` = {$end_day} , \n\t\t\t\t\t`StartTime` = {$start_time} , \n\t\t\t\t\t`EndTime` = {$end_time},\n\t\t\t\t\t`LastUpdate`= NOW()\n\t\t\t\tWHERE TimeSlotID = '{$time_slot_id}'";
} elseif ($action == "delete") {
$qry = "update `timeslot` set `is_active`='inactive' where `is_active`='active' and `TimeSlotID`='{$action_id}'";
//$qry = "delete from `timeslot` where `TimeSlotID`='".$action_id."'";
}
try {
$res = Sql_exec($remoteCn, $qry);
} catch (Exception $e) {
$is_error = 1;
}
echo $is_error;
if ($remoteCn) {
ClosedDBConnection($remoteCn);
}
$cn = connectDB();
$query = "SELECT * FROM {$tbl_pre} where id={$id_pre}";
$result = Sql_exec($cn, $query);
if (!$result) {
echo "err+" . $query . " in line " . __LINE__ . " of file" . __FILE__;
exit;
}
$row = Sql_fetch_array($result);
$tbl = $row['table_name'];
$primary_key = $row['primary_key_column'];
$data = array();
$data = (array) json_decode($row['rowvalue']);
$key_value = $data[$primary_key];
unset($data[$primary_key]);
if ($row['pname'] != '' && $row['pname'] != null) {
$cn = remote_connectDB($row['pname']);
/*
$query = "SELECT * FROM `tbl_process_db_access` where `pname`='" . $row['pname'] . "'";
$result = Sql_exec($cn, $query);
if (!$result) {
echo "err+" . $query . " in line " . __LINE__ . " of file" . __FILE__;
exit;
}
$row_2 = Sql_fetch_array($result);
$dbtype = $row_2['db_type'];
$UserID = $row_2['db_uid'];
$Password = $row_2['db_password'];
$Server = $row_2['db_server'];
$Database = $row_2['db_name'];
