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