public function execute()
{
try {
$request = $_GET;
$data = array();
$Models_General = new Models_General();
if (empty($request['account'])) {
throw new Exception(0);
}
$arr = array();
if (!empty($request['b'])) {
$arr['account_balance'] = $request['b'];
}
if (!empty($request['e'])) {
$arr['account_equity'] = $request['e'];
}
if (!empty($request['f'])) {
$arr['account_free_margin'] = $request['f'];
}
if (!empty($request['c'])) {
$arr['account_company'] = $request['c'];
}
if (!empty($arr)) {
$where = sprintf('account_number = %s', $Models_General->qstr($request['account']));
$Models_General->updateDetails('forex_users', $arr, $where);
}
//history
$arr = array();
if (!empty($request['b'])) {
$arr['account_balance'] = $request['b'];
}
if (!empty($request['e'])) {
$arr['account_equity'] = $request['e'];
}
if (!empty($request['f'])) {
$arr['account_free_margin'] = $request['f'];
}
if (!empty($arr) && !empty($request['account'])) {
$arr['account_number'] = $request['account'];
$Models_General->addDetails('forex_balance_history', $arr);
}
$cache = 1;
if (isset($_GET['cache'])) {
$cache = $_GET['cache'];
}
$params = array();
$params['where'] = sprintf(' AND account_number = %s', $this->qstr($request['account']));
$params['fields'] = '*';
//'forex_user_id as id, account_number, status, open_trades, close_trades';
$params['cacheTime'] = 3600;
$result = $Models_General->getDetails('forex_users', $cache, $params);
if (empty($result[0])) {
throw new Exception(1);
}
foreach ($result[0] as $value) {
echo $value . '|';
}
} catch (Exception $e) {
echo $e->getMessage();
}
exit;
}
if (isset($_GET['pageNum_rsView'])) {
$page = $_GET['pageNum_rsView'];
}
$totalRows_rsView = 0;
$totalPages_rsView = 0;
$maxRows_rsView = $max;
$pageNum_rsView = $page;
$startRow_rsView = $pageNum_rsView * $maxRows_rsView;
$result = array();
try {
if (isset($_POST['MM_Update']) && !empty($_POST['answer']) && !empty($_POST['id'])) {
$paramsData = array();
$paramsData['answer'] = $_POST['answer'];
$paramsData['status'] = 1;
$where = sprintf('id = %s', $Models_General->qstr($_POST['id']));
$Models_General->updateDetails('askquestion', $paramsData, $where);
mail($_POST['email'], 'New Answer Submitted For Your Question on ' . SITEURL, "\n\nQuestion: " . $_REQUEST['question'] . "\n\nAnswer: " . $_POST['answer'], 'From:' . FROMNAME . '<' . FROMEMAIL . '>');
}
if (isset($_GET['delete'])) {
$paramsData = array();
$paramsData['deleted'] = 1;
$where = sprintf('id = %s', $Models_General->qstr($_GET['id']));
$Models_General->updateDetails('askquestion', $paramsData, $where);
}
$status = 0;
if (!empty($_GET['status'])) {
$status = $_GET['status'];
}
$data = $Models_General->ask($max, $page, $status, 0);
$totalRows_rsView = isset($data['totalRows']) ? $data['totalRows'] : 0;
$totalPages_rsView = isset($data['totalPages']) ? $data['totalPages'] : 0;
function updateSettings($uid, $paramsData = array())
{
if (empty($paramsData)) {
return false;
}
$generalMode = new Models_General();
$where = sprintf('uid = %s', $generalMode->qstr($uid));
$generalMode->updateDetails('settings', $paramsData, $where);
$params = array();
$params['where'] = 'AND ' . $where;
$settings = $generalMode->getDetails('settings', 0, $params);
$_SESSION['settings'] = $settings[0];
return true;
}
<?php
try {
check_login();
include SITEDIR . '/includes/navLeftSideVars.php';
check_city_owner($globalCity['id'], $_SESSION['user']['id']);
$Models_General = new Models_General();
if (isset($_GET['change']) && !empty($_GET['change_id'])) {
$arr = array();
$arr['admin_status'] = $_GET['change'];
$where = sprintf('record_id = %s', $Models_General->qstr($_GET['change_id']));
$Models_General->updateDetails('records', $arr, $where);
}
include SITEDIR . '/includes/showmap.php';
//getting records
$Models_Records = new Models_Records();
$params = array();
$params['city_ids'] = $globalCity['id'];
$params['admin_status'] = !empty($_GET['status']) ? 1 : 0;
$data = $Models_Records->records_view($params);
?>
<div class="row">
<div class="col-lg-12">
<h2>Browse <?php
echo !empty($params['admin_status']) ? 'Approved' : 'Pending';
?>
Status Lawyers</h2>
<p><a href="<?php
echo $currentURL;
?>
/manage/lawyers/browse?status=0">Pending Lawyers</a> | <a href="<?php
