File manager

File manager - Edit - /home/autoph/public_html/connectv1/cfg/func.php

Back
<?php include "cipher.php"; class functions extends AES256Encryption { /** * Query the database * * @param $query The query string * @return mixed The result of the mysqli::query() function / public function sql_query($query) { // Connect to the database $connection = $this->connect(); // Query the database $result = $connection->query($query); return $result; } // customer update db transaction public function transBegin() { return $this->connect()->begin_transaction(); } public function transCommit() { return $this->connect()->commit(); } public function transRollback() { return $this->connect()->rollback(); } public function run_query($query){ // return $query; return $this->connect()->query($query); } public function sql_query_id($query) { // Connect to the database $connection = $this->connect(); // Query the database $result = $connection->query($query); return $connection->insert_id; } public function sql_query_num_inserted($query) { // Connect to the database $connection = $this->connect(); // Query the database $result = $connection->query($query); return $connection->affected_rows; } public function sql_num_rows($query) { // Connect to the database $connection = $this->connect(); // Query the database $result = $connection->query($query); return $result->num_rows; } /* * Fetch rows from the database (SELECT query) * * @param $query The query string * @return output / public function select($query) { $result = $this->sql_query($query); if ($result === false) { return false; } $row = $this->index_arr_values($result->fetch_assoc()); if (empty($row)) { return ""; } return $row[0]; } /* * Fetch rows from the database (SELECT query) * * @param $query The query string * @return bool False on failure / array Database rows on success / public function select_row($query) { $rows = array(); $result = $this->sql_query($query); if ($result === false) { return false; } while ($row = $result->fetch_assoc()) { $rows[] = $row; } return $rows; } public function return_result($query) { $result = $this->sql_query($query); $output = array(); while ($row = $result->fetch_assoc()) { array_push($output, $row); } return $output; } /* * Quote and escape value for use in a database query * * @param string $value The value to be quoted and escaped * @return string The quoted and escaped string / public function escape($value) { if (is_array($value)) { return array_map(array($this, 'escape'), $value); } $connection = $this->connect(); return $connection->real_escape_string(trim(preg_replace("/[[:blank:]]+/", " ", $value))); } /* * Return the values of associative array as indexed array * @param associative array @return indexed array / public function index_arr_values($value) { if (empty($value)) { return array(); } return array_values($value); } /* * Return the keys of associative array as indexed array * @param associative array @return indexed array / public function index_arr_keys($value) { return array_keys($value); } /* Get Client's IP / function getClientIP() { if (isset($_SERVER)) { if (isset($_SERVER["HTTP_X_FORWARDED_FOR"])) { return $_SERVER["HTTP_X_FORWARDED_FOR"]; } if (isset($_SERVER["HTTP_CLIENT_IP"])) { return $_SERVER["HTTP_CLIENT_IP"]; } return $_SERVER["REMOTE_ADDR"]; } if (getenv('HTTP_X_FORWARDED_FOR')) { return getenv('HTTP_X_FORWARDED_FOR'); } if (getenv('HTTP_CLIENT_IP')) { return getenv('HTTP_CLIENT_IP'); } return getenv('REMOTE_ADDR'); } /* * Set Session For User Login / function setLogin($uid) { $user_info = $this->select_row("SELECT FROM `users` WHERE `user_id`=$uid"); $_SESSION['user']['id'] = $uid; $_SESSION['user']['user_name'] = $user_info[0]['user_name']; if ($user_info[0]['is_reseller'] == 1) { $_SESSION['user']['rank'] = "Reseller"; } elseif ($user_info[0]['is_reseller'] == 2) { $_SESSION['user']['rank'] = "Sub Reseller"; } elseif ($user_info[0]['is_reseller'] == 3) { $_SESSION['user']['rank'] = "Sub Admin"; } elseif ($user_info[0]['is_admin'] == 1 \|\| $user_info[0]['user_rank'] == 'Admin') { $_SESSION['user']['rank'] = "Admin"; } else { $_SESSION['user']['rank'] = "Client"; } $this->sql_query("UPDATE users SET `ipaddress`='" . $this->getClientIP() . "', `lastlogin`=NOW() WHERE `user_id`='$uid'"); } /** * Get site settings / function site_settings() { $variable = $this->return_result("SELECT FROM `settings`"); $settings = array(); foreach ($variable as $setting) { $settings = array($setting['name'] => $setting['value']) + $settings; } return $settings; } function smsProvider() { $qry = $this->return_result("SELECT * FROM sms_provider where status =1"); $param = []; foreach ($qry as $row) { $param = [ 'id'=> $row['id'], 'code'=>$row['code'], 'description' => $row['description'], 'uri'=> $row['uri'], 'parameters' =>json_decode($row['parameters']), 'status'=> $row['status'] ]; }unset($row); return $param; } // function role_settings() // { // if (isset($_SESSION['user'])) { // $role_permissions = $this->return_result("SELECT action_permissions,company_permissions,fields_permissions FROM `employee_role_access` WHERE status = 1 AND employee_role_id = '" . $_SESSION['user']['employee_role_id'] . "'"); // foreach ($role_permissions as $role_permission) { // if (isset($role_permission['action_permissions'])) { // $_SESSION['user']['action_permissions'] = json_decode($role_permission['action_permissions'], true); // $_SESSION['action_permissions'] = json_decode($role_permission['action_permissions'], true); //for mvc // } else { // $_SESSION['user']['action_permissions'] = ""; // } // if (isset($role_permission['company_permissions'])) { // $_SESSION['user']['company_permissions'] = array_merge(array($_SESSION['user']['company']), json_decode($role_permission['company_permissions'], true)); // $_SESSION['company_permissions'] = array_merge(array($_SESSION['user']['company']), json_decode($role_permission['company_permissions'], true)); //for mvc // } else { // $_SESSION['user']['company_permissions'] = array($_SESSION['user']['company']); // } // $_SESSION['user']['company_permissions_implode'] = implode(',', $_SESSION['user']['company_permissions']); // if (isset($role_permission['fields_permissions'])) { // $_SESSION['user']['fields_permissions'] = json_decode($role_permission['fields_permissions'], true); // $_SESSION['fields_permissions'] = json_decode($role_permission['fields_permissions'], true); //for mvc // } else { // $_SESSION['user']['fields_permissions'] = ""; // } // // print_r($_SESSION['user']['company_permissions']);exit; // // echo $_SESSION['user']['company'];exit; // } // return $_SESSION['user']; // } // // print_r($_SESSION['user']['action_permissions']);exit; // return false; // } function role_settings() { if (isset($_SESSION['user'])) { $role_permissions = $this->return_result("SELECT action_permissions,company_permissions,dealer_permissions,fields_permissions FROM `employee_role_access` WHERE status = 1 AND employee_role_id = '" . $_SESSION['user']['employee_role_id'] . "'"); foreach ($role_permissions as $role_permission) { if (isset($role_permission['action_permissions'])) { $_SESSION['user']['action_permissions'] = json_decode($role_permission['action_permissions'], true); $_SESSION['action_permissions'] = json_decode($role_permission['action_permissions'], true); //for mvc } else { $_SESSION['user']['action_permissions'] = ""; } if (isset($role_permission['company_permissions'])) { $_SESSION['user']['company_permissions'] = array_merge(array($_SESSION['user']['company']), json_decode($role_permission['company_permissions'], true)); $_SESSION['company_permissions'] = array_merge(array($_SESSION['user']['company']), json_decode($role_permission['company_permissions'], true)); //for mvc } else { $_SESSION['user']['company_permissions'] = array($_SESSION['user']['company']); } //modify $_SESSION['user']['dealer_permissions'] = $_SESSION['user']['dealer']; if (!empty($role_permission['dealer_permissions'])) { $_SESSION['user']['dealer_permissions'] = implode(',',json_decode($role_permission['dealer_permissions'], true)); // $_SESSION['dealer_permissions'] = array_merge(array($_SESSION['user']['dealer']), json_decode($role_permission['dealer_permissions'], true)); //for mvc } // else { // } $_SESSION['user']['company_permissions_implode'] = implode(',', $_SESSION['user']['company_permissions']); if (isset($role_permission['fields_permissions'])) { $_SESSION['user']['fields_permissions'] = json_decode($role_permission['fields_permissions'], true); $_SESSION['fields_permissions'] = json_decode($role_permission['fields_permissions'], true); //for mvc } else { $_SESSION['user']['fields_permissions'] = ""; } // print_r($_SESSION['user']['company_permissions']);exit; // echo $_SESSION['user']['company'];exit; } return $_SESSION['user']; } // print_r($_SESSION['user']['action_permissions']);exit; return false; } function check_remember_login() { if (isset($_COOKIE["employee_master_id"]) && !isset($_SESSION["user"])) { return true; } return false; } function b_crypt($raw_str) { return password_hash($raw_str, PASSWORD_DEFAULT); } function check_b_crypt($raw_str, $hash) { $valid = 0; if (password_verify($raw_str, $hash)) { $valid = 1; } return $valid; } function cipher($text, $encrypt) { $key = '4u70hu36r0up'; $iv = '4u70hu36r0up2021'; //AES256Encryption::generateIv(); if ($encrypt) { $output = $this->encrypt($text, $key, $iv); } else { $output = $this->decrypt($text, $key, $iv); } return $output; } function checkHttps() { if ($_SERVER["HTTPS"] != "on") { header("Location: https://" . $_SERVER["HTTP_HOST"] . $_SERVER["REQUEST_URI"]); exit(); } } function base64_url_encode($input) { return strtr(base64_encode($input), '+/=', '-_-'); } function base64_url_decode($input) { return base64_decode(strtr($input, '-_-', '+/=')); } }

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0.01 | proxy | phpinfo | Settings