mydb.php000064400000000376150252206760006223 0ustar00.htaccess000064400000000162150252206760006346 0ustar00 Order Allow,Deny Deny from all db.php000064400000005333150252206760005653 0ustar00system_settings(); if (intval($global_system_settings['is_maintenance']) === 1) { if (file_exists('maintenance.php')) { header('location:maintenance.php'); } else { echo "Maintenance"; } exit; } // print_r($_SESSION['cc_user']);exit; //check account status $global_user_status = 0; $global_user_message = "Invalid Request."; if ( isset($_SESSION['cc_user']) || (isset($_COOKIE['login_token']) && $utility_class->isNotEmpty($_COOKIE['login_token'])) ) { // check session and cookie if (isset($_SESSION['cc_user'])) { $login_token_user_id = $_SESSION['cc_user']['id']; } else { $login_token = $_COOKIE['login_token']; $login_token_user_obj = $user_class->read_user_login_token($login_token, 3, 1, $db); $login_token_user_arr = array(); foreach ($login_token_user_obj as $login_token_user_row) { $login_token_user_arr = $login_token_user_row; } if (count($login_token_user_arr) <= 0) { unset($_COOKIE['login_token']); setcookie('login_token', null, -1, '/'); header('Location: ' . $global_system_settings['url']); exit; } $login_token_user_id = $login_token_user_arr['user_id']; } // put function that need to call every call $where_statement = " AND (u.`id` = '" . $login_token_user_id . "') "; //check user status $global_result_arr = $user_class->system_user_security($where_statement, array(), 'main', $utility_class, $db); // print_r($global_result_arr );exit; $global_user_message = $global_result_arr['message']; $global_user_status = $global_result_arr['status']; if (!intval($global_user_status) && !file_exists('maintenance.php')) { echo $global_user_message; exit; } $session_user = $_SESSION['cc_user']; $session_user_id = $_SESSION['cc_user']['id']; $session_access = $_SESSION['cc_user']['json_access']; } else { $session_user = NULL; $session_user_id = NULL; } ob_flush(); ob_end_flush(); db_api.php000064400000001225150252206760006500 0ustar00system_settings(); $session_user = NULL ; $session_user_id = NULL ; ob_flush(); ob_end_flush(); ?>asaconn.php000064400000001035150252206760006703 0ustar00format("Y-m-d h:i:s"); $extractYear = explode('-',$myTimeStamp); $curYear = $extractYear[0]; $extractDate = explode(' ',$myTimeStamp); $curDate = $extractDate[0]; $curTime = $extractDate[1]; $servername = "localhost"; $username = "autoph_arnel"; $password = "Hke@2001"; $db="autoph_connect"; $conn = new mysqli($servername, $username, $password,$db); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } ?> index.php000064400000000000150252206760006357 0ustar00connasa.php000064400000000737150252206760006713 0ustar00format("Y-m-d h:i:s"); $extractDate = explode('-',$myTimeStamp); $curYear = $extractDate[0]; $servername = "localhost"; $username = "autoph_arnel"; $password = "Hke@2001"; $db="autoph_connect"; $connasa = new mysqli($servername, $username, $password,$db); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } ?> func.php000064400000010207150252206760006215 0ustar00 connect(); // Query the database // echo $query; $result = $connection -> query($query); return $result; } 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_affected_rows($query) { // Connect to the database $connection = $this -> connect(); // Query the database $result = $connection -> query($query) ; return $connection -> affected_rows; } public function sql_query_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]; } public function test() { return "Test DB"; } /** * 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))); } public function server_info() { $connection = $this -> connect(); return $connection -> get_server_info(); } /** * 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 to get the client IP address function get_client_ip() { $ipaddress = ''; if (getenv('HTTP_CLIENT_IP')) $ipaddress = getenv('HTTP_CLIENT_IP'); else if(getenv('HTTP_X_FORWARDED_FOR')) $ipaddress = getenv('HTTP_X_FORWARDED_FOR'); else if(getenv('HTTP_X_FORWARDED')) $ipaddress = getenv('HTTP_X_FORWARDED'); else if(getenv('HTTP_FORWARDED_FOR')) $ipaddress = getenv('HTTP_FORWARDED_FOR'); else if(getenv('HTTP_FORWARDED')) $ipaddress = getenv('HTTP_FORWARDED'); else if(getenv('REMOTE_ADDR')) $ipaddress = getenv('REMOTE_ADDR'); else $ipaddress = 'UNKNOWN'; return $ipaddress; } function get_user_session(){ if(isset($_SESSION['crm_user'])){ return $_SESSION['crm_user']; }else{ return false; } } function system_settings(){ $system_settings_obj = $this -> sql_query("SELECT * FROM `cnf_system` WHERE 1"); $system_settings_arr= array(); foreach($system_settings_obj as $row){ $system_settings_arr = array_merge($system_settings_arr,array($row['name']=>$row['value'])); } return $system_settings_arr; } } ?>cfg.ini000064400000000147150252206760006013 0ustar00[config] host = 'localhost' username = 'autoph_cc' password = 'bK]yGq^R[*0P' database = 'autoph_cc'ahaconn.php000064400000001716150252206760006676 0ustar00format("Y-m-d h:i:s"); $extractDate = explode('-',$myTimeStamp); $curYear = $extractDate[0]; $extractDate = explode(' ',$myTimeStamp); $curDate = $extractDate[0]; $curTime = $extractDate[1]; $servername = "localhost"; $username = "autoph_admindb"; $password = "~cxk)gU^ziaB"; $database = "autoph_ahg_crm"; $MyAPIcode = "PR-AUTOH172111_IE74I"; $MyPasswd = "me}vfe3j#c"; $itexMoPassword = 'JRE@jre0911'; $itexMoAPICode= 'PR-AUTOH172111_IE74I'; $itexMoEmail ='aendaya@autohubgroup.com'; $senderID = 'AUTOHUB GRP'; //'Email' => 'aendaya@autohubgroup.com', //'Password' => 'JRE@jre0911', //'ApiCode' => 'PR-AUTOH172111_IE74I', ///'SenderId'=> 'AUTOHUB GRP', // Create connection $conn = new mysqli($servername, $username, $password, $database); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } ?> conn.php000064400000001047150252206760006221 0ustar00format("Y-m-d h:i:s"); $extractYear = explode('-',$myTimeStamp); $curYear = $extractYear[0]; $extractDate = explode(' ',$myTimeStamp); $curDate = $extractDate[0]; $servername = "localhost"; $username = "autoph_pms_aree"; $password = "AEE-06262023@*"; $db="autoph_pms_db"; $conn = new mysqli($servername, $username, $password,$db); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } ?> cfg.php000064400000002551150252206760006024 0ustar00 set_charset("utf8"); } // If connection was not successful, handle the error if(self::$connection === false) { // Handle error - notify administrator, log to a file, show an error screen, etc. return false; } return self::$connection; } /** * Fetch the last error from the database * * @return string Database error message */ public function error() { $connection = $this -> connect(); return $connection -> error; } } ?>db_console.php000064400000001022150252206760007364 0ustar00system_settings(); if(intval($global_system_settings['is_maintenance']) === 1){ echo "Maintenance"; exit; } ob_flush(); ob_end_flush(); ?>connhr.php000064400000001300150252206760006543 0ustar00format("Y-m-d h:i:s"); $extractDate = explode('-',$myTimeStamp); $curYear = $extractDate[0]; $servername = "localhost"; $username = "autoph_admindb"; $password = "~cxk)gU^ziaB"; $db="autoph_ahg_hr"; $connhr = new mysqli($servername, $username, $password,$db); $MyAPIcode = "PR-AUTOH172111_IE74I"; $MyPasswd = "me}vfe3j#c"; $itexMoPassword = 'JRE@jre0911'; $itexMoAPICode= 'PR-AUTOH172111_IE74I'; $itexMoEmail ='aendaya@autohubgroup.com'; $senderID = 'AUTOHUB GRP'; if ($connhr->connect_error) { die("Connection failed: " . $connhr->connect_error); } ?>