Untitled

<?php
/*
 *
 * @ This file is created by http://DeZender.Net
 * @ deZender (PHP5 Decoder for ionCube Encoder)
 *
 * @ Version		:	3.5.0.0
 * @ Author			:	DeZender
 * @ Release on		:	22.06.2018
 * @ Official site	:	http://DeZender.Net
 *
 */

require_once 'log.php';

class HYIP_Manager_Pro_Database_Helper
{
	private $_logfilepath = './HYIP_Manager_Pro_Database_Helper_php_log.txt';
	private $_servername = '';
	private $_username = '';
	private $_password = '';
	private $_dbname = '';
	private $PDOConn = null;

	public function __construct()
	{
	}

	public function getHm2Processings()
	{
		$sql = 'select * from hm2_processings;';
		$stmt = $this->PDOConn->query($sql);
		$_obfuscated_0D133E15160B2E01241F1D022A2E2F0B282D18031D3632_ = $stmt->fetchAll(PDO::FETCH_ASSOC);

		return $_obfuscated_0D133E15160B2E01241F1D022A2E2F0B282D18031D3632_;
	}

	public function checkHm2Processings($hm2_processings_data = null)
	{
		if ($hm2_processings_data == null) {
			$hm2_processings_data = $this->getHm2Processings();
		}

		$_obfuscated_0D112F1D0B092F1D36313D04405C181D232A3623302E22_ = false;
		$_obfuscated_0D2D2B0506162D1C0A3011131B401C2122022C34342F11_ = false;
		$_obfuscated_0D1C0106013505343B1A33300C3634112E171D0F032D32_ = false;
		$_obfuscated_0D332C17295B0F1824090C1202182D370A3D082A371932_ = false;
		$_obfuscated_0D1605075B0811010D1A1317092F2B01150F0D38072E22_ = false;
		$_obfuscated_0D14012B251327020E2240020B06333116121D110F2C01_ = false;
		$_obfuscated_0D070D5C320F38033F243D31043B0E172F163F40165B22_ = false;
		$_obfuscated_0D2E1F2429101D1A1C0D050A0540323C162B2E04091201_ = false;
		$_obfuscated_0D123D25272D375B16380740081D2C35353B2424171B01_ = false;
		$_obfuscated_0D0B310D032718352E5C101C0B18101B26130F25313922_ = false;
		$_obfuscated_0D38222A160F0307061E0E293528182A2918293E1D1111_ = false;
		$_obfuscated_0D1E1B0D2D3E080B15061A272408330D142A3622330611_ = false;

		foreach ($hm2_processings_data as $key => $value) {
			if ($value['name'] == 'Bitcoin') {
				$_obfuscated_0D112F1D0B092F1D36313D04405C181D232A3623302E22_ = true;
			}

			if ($value['name'] == 'Ethereum') {
				$_obfuscated_0D2D2B0506162D1C0A3011131B401C2122022C34342F11_ = true;
			}

			if ($value['name'] == 'Litecoin') {
				$_obfuscated_0D1C0106013505343B1A33300C3634112E171D0F032D32_ = true;
			}

			if ($value['name'] == 'Dash') {
				$_obfuscated_0D332C17295B0F1824090C1202182D370A3D082A371932_ = true;
			}

			if ($value['name'] == 'BitcoinCash') {
				$_obfuscated_0D1605075B0811010D1A1317092F2B01150F0D38072E22_ = true;
			}

			if ($value['name'] == 'Stellar') {
				$_obfuscated_0D14012B251327020E2240020B06333116121D110F2C01_ = true;
			}

			if ($value['name'] == 'Zcash') {
				$_obfuscated_0D070D5C320F38033F243D31043B0E172F163F40165B22_ = true;
			}

			if ($value['name'] == 'TRON') {
				$_obfuscated_0D2E1F2429101D1A1C0D050A0540323C162B2E04091201_ = true;
			}

			if ($value['name'] == 'Dai') {
				$_obfuscated_0D123D25272D375B16380740081D2C35353B2424171B01_ = true;
			}

			if ($value['name'] == 'USDCoin') {
				$_obfuscated_0D0B310D032718352E5C101C0B18101B26130F25313922_ = true;
			}

			if ($value['name'] == 'PerfectMoney') {
				$_obfuscated_0D38222A160F0307061E0E293528182A2918293E1D1111_ = true;
			}

			if ($value['name'] == 'Payeer') {
				$_obfuscated_0D1E1B0D2D3E080B15061A272408330D142A3622330611_ = true;
			}
		}
		$Name = '';
		$_obfuscated_0D0D062A2818331116352C2C3D31323437141A1F163011_ = '';
		$_obfuscated_0D3714082B232732043E060D01341B382D0D2E061B0632_ = '0';
		$_obfuscated_0D2205015B3B07262412230C261A16262F2A2A5B341922_ = 'Payment Processor';
		$_obfuscated_0D402B115C023D241D30070C0F17251638382722371211_ = '0';
		$DefaultLang = '';
		$stmt = $this->PDOConn->prepare('INSERT INTO `hm2_processings` ( `name`, `infofields`, `status`, `description`, `verify`, `lang` ) VALUES ( :Name, :InfoFields, :Status, :Description, :Verify, :Lang);');
		$stmt->bindParam('Name', $Name, PDO::PARAM_STR, 255);
		$stmt->bindParam('InfoFields', $_obfuscated_0D0D062A2818331116352C2C3D31323437141A1F163011_, PDO::PARAM_INT, 1);
		$stmt->bindParam('Status', $_obfuscated_0D3714082B232732043E060D01341B382D0D2E061B0632_, PDO::PARAM_STR, 255);
		$stmt->bindParam('Description', $_obfuscated_0D2205015B3B07262412230C261A16262F2A2A5B341922_, PDO::PARAM_STR, 255);
		$stmt->bindParam('Verify', $_obfuscated_0D402B115C023D241D30070C0F17251638382722371211_, PDO::PARAM_INT, 1);
		$stmt->bindParam('Lang', $DefaultLang, PDO::PARAM_STR, 255);

		if ($_obfuscated_0D112F1D0B092F1D36313D04405C181D232A3623302E22_ == false) {
			$Name = 'Bitcoin';
			$_obfuscated_0D2205015B3B07262412230C261A16262F2A2A5B341922_ = 'Send your funds to account: <b>Your Bitcoin address</b>';
			$stmt->execute();
			$_obfuscated_0D1E38212D0B27023B3E402C03130424112E1235391D22_ = $this->PDOConn->lastInsertId();
		}

		if ($_obfuscated_0D2D2B0506162D1C0A3011131B401C2122022C34342F11_ == false) {
			$Name = 'Ethereum';
			$_obfuscated_0D2205015B3B07262412230C261A16262F2A2A5B341922_ = 'Send your funds to account: <b>Your Ethereum address</b>';
			$stmt->execute();
			$_obfuscated_0D3831070D1227240F070622351F23051B1E1C080F1E32_ = $this->PDOConn->lastInsertId();
		}

		if ($_obfuscated_0D1C0106013505343B1A33300C3634112E171D0F032D32_ == false) {
			$Name = 'Litecoin';
			$_obfuscated_0D2205015B3B07262412230C261A16262F2A2A5B341922_ = 'Send your funds to account: <b>Your Litecoin address</b>';
			$stmt->execute();
			$_obfuscated_0D2728272108372934283436270839220B28071B040401_ = $this->PDOConn->lastInsertId();
		}

		if ($_obfuscated_0D332C17295B0F1824090C1202182D370A3D082A371932_ == false) {
			$Name = 'Dash';
			$_obfuscated_0D2205015B3B07262412230C261A16262F2A2A5B341922_ = 'Send your funds to account: <b>Your Dash address</b>';
			$stmt->execute();
			$_obfuscated_0D22101622040C181B1A0F1F2D133F0E26143609260C32_ = $this->PDOConn->lastInsertId();
		}

		if ($_obfuscated_0D1605075B0811010D1A1317092F2B01150F0D38072E22_ == false) {
			$Name = 'BitcoinCash';
			$_obfuscated_0D2205015B3B07262412230C261A16262F2A2A5B341922_ = 'Send your funds to account: <b>Your BitcoinCash address</b>';
			$stmt->execute();
			$_obfuscated_0D242F24252F102F222A06301A0D181E1F275B022D3722_ = $this->PDOConn->lastInsertId();
		}

		if ($_obfuscated_0D14012B251327020E2240020B06333116121D110F2C01_ == false) {
			$Name = 'Stellar';
			$_obfuscated_0D2205015B3B07262412230C261A16262F2A2A5B341922_ = 'Send your funds to account: <b>Your Stellar address</b>';
			$stmt->execute();
			$_obfuscated_0D3C3807103705022E5B0B3818322203262E2A09350101_ = $this->PDOConn->lastInsertId();
		}

		if ($_obfuscated_0D070D5C320F38033F243D31043B0E172F163F40165B22_ == false) {
			$Name = 'Zcash';
			$_obfuscated_0D2205015B3B07262412230C261A16262F2A2A5B341922_ = 'Send your funds to account: <b>Your Zcash address</b>';
			$stmt->execute();
			$_obfuscated_0D1D241D1E352213341530342411152C141A39402D0501_ = $this->PDOConn->lastInsertId();
		}

		if ($_obfuscated_0D2E1F2429101D1A1C0D050A0540323C162B2E04091201_ == false) {
			$Name = 'TRON';
			$_obfuscated_0D2205015B3B07262412230C261A16262F2A2A5B341922_ = 'Send your funds to account: <b>Your TRON address</b>';
			$stmt->execute();
			$_obfuscated_0D5C0E265B1029250335111D16260A193C04050F131632_ = $this->PDOConn->lastInsertId();
		}

		if ($_obfuscated_0D123D25272D375B16380740081D2C35353B2424171B01_ == false) {
			$Name = 'Dai';
			$_obfuscated_0D2205015B3B07262412230C261A16262F2A2A5B341922_ = 'Send your funds to account: <b>Your Dai address</b>';
			$stmt->execute();
			$_obfuscated_0D1201072C2F092B0B1C2B1B0B251B130B03090F083B32_ = $this->PDOConn->lastInsertId();
		}

		if ($_obfuscated_0D0B310D032718352E5C101C0B18101B26130F25313922_ == false) {
			$Name = 'USDCoin';
			$_obfuscated_0D2205015B3B07262412230C261A16262F2A2A5B341922_ = 'Send your funds to account: <b>Your USDCoin address</b>';
			$stmt->execute();
			$_obfuscated_0D1B35322326373E2F0A34253B3D1D05240625072C3932_ = $this->PDOConn->lastInsertId();
		}

		if ($_obfuscated_0D38222A160F0307061E0E293528182A2918293E1D1111_ == false) {
			$Name = 'PerfectMoney';
			$_obfuscated_0D2205015B3B07262412230C261A16262F2A2A5B341922_ = 'Send your funds to account: <b>Your PerfectMoney account</b>';
			$stmt->execute();
			$_obfuscated_0D102615225B40020A10381E23315C3D182A3202130E32_ = $this->PDOConn->lastInsertId();
		}

		if ($_obfuscated_0D1E1B0D2D3E080B15061A272408330D142A3622330611_ == false) {
			$Name = 'Payeer';
			$_obfuscated_0D2205015B3B07262412230C261A16262F2A2A5B341922_ = 'Send your funds to account: <b>Your Payeer account</b>';
			$stmt->execute();
			$_obfuscated_0D160D07132A132C382B1D3D2524043C13260D2D3C1801_ = $this->PDOConn->lastInsertId();
		}

		return true;
	}

	public function getVendorProcessingsExtraData()
	{
		$sql = "SELECT hm2_processings.id,\r\n            hm2_processings.name,\r\n            hm2_processings.infofields,\r\n            hm2_processings.status,\r\n            hm2_processings.description,\r\n            hm2_processings.verify,\r\n            hm2_processings.lang,\r\n            vendor_processings_extra_data.id as vendor_processings_extra_data_id,\r\n            vendor_processings_extra_data.hm2_processings_id,\r\n            vendor_processings_extra_data.Processor,\r\n            vendor_processings_extra_data.Coinpayments_Deposit_Merchant_ID,\r\n            vendor_processings_extra_data.Coinpayments_Deposit_IPN_Secret,\r\n            vendor_processings_extra_data.Coinpayments_Withdraw_Enabled,\r\n            vendor_processings_extra_data.Coinpayments_Withdraw_Public_Key,\r\n            vendor_processings_extra_data.Coinpayments_Withdraw_Private_Key,\r\n            vendor_processings_extra_data.Coinbase_API_Key,\r\n            vendor_processings_extra_data.Coinbase_Shared_Secret,\r\n            vendor_processings_extra_data.Paykassa_Deposit_Merchant_ID,\r\n            vendor_processings_extra_data.Paykassa_Deposit_Merchant_Password,\r\n            vendor_processings_extra_data.Paykassa_Withdraw_Enabled,\r\n            vendor_processings_extra_data.Paykassa_Withdraw_Merchant_ID,\r\n            vendor_processings_extra_data.Paykassa_Withdraw_API_ID,\r\n            vendor_processings_extra_data.Paykassa_Withdraw_API_Password,\r\n            vendor_processings_extra_data.Paykassa_Withdraw_Priority,\r\n            vendor_processings_extra_data.Payeer_Deposit_Shop_ID,\r\n            vendor_processings_extra_data.Payeer_Deposit_Secret_Key,\r\n            vendor_processings_extra_data.Payeer_Withdraw_Enabled,\r\n            vendor_processings_extra_data.Payeer_Withdraw_Account_ID,\r\n            vendor_processings_extra_data.Payeer_Withdraw_API_ID,\r\n            vendor_processings_extra_data.Payeer_Withdraw_API_Key,\r\n            vendor_processings_extra_data.Perfectmoney_Deposit_USD_Account_Number,\r\n            vendor_processings_extra_data.Perfectmoney_Deposit_Account_Name,\r\n            vendor_processings_extra_data.Perfectmoney_Deposit_Alternate_Password,\r\n            vendor_processings_extra_data.Perfectmoney_Withdraw_Enabled,\r\n            vendor_processings_extra_data.Perfectmoney_Withdraw_Account_ID,\r\n            vendor_processings_extra_data.Perfectmoney_Withdraw_USD_Account,\r\n            vendor_processings_extra_data.Perfectmoney_Withdraw_Account_Password\r\n        FROM hm2_processings LEFT JOIN vendor_processings_extra_data\r\n        ON hm2_processings.id = vendor_processings_extra_data.hm2_processings_id";
		$stmt = $this->PDOConn->query($sql);
		$hm2_processings_data = array();

		while ($row = $stmt->fetch()) {
			$hm2_processings_data[$row['id']] = $row;
		}

		return $hm2_processings_data;
	}

	public function getHm2ProcessingsStatuses($hm2_processings_data = null)
	{
		if ($hm2_processings_data == null) {
			$hm2_processings_data = $this->getHm2Processings();
		}

		$processing_status = array();

		foreach ($hm2_processings_data as $key => $value) {
			$processing_status[$value['name']] = $value['status'];
		}

		return $processing_status;
	}

	public function getProcessorByName($ProcessorName)
	{
		$sql = "SELECT hm2_processings.id,\r\n            hm2_processings.name,\r\n            hm2_processings.infofields,\r\n            hm2_processings.status,\r\n            hm2_processings.description,\r\n            hm2_processings.verify,\r\n            hm2_processings.lang,\r\n            vendor_processings_extra_data.id as vendor_processings_extra_data_id,\r\n            vendor_processings_extra_data.hm2_processings_id,\r\n            vendor_processings_extra_data.Processor,\r\n            vendor_processings_extra_data.Coinpayments_Deposit_Merchant_ID,\r\n            vendor_processings_extra_data.Coinpayments_Deposit_IPN_Secret,\r\n            vendor_processings_extra_data.Coinpayments_Withdraw_Enabled,\r\n            vendor_processings_extra_data.Coinpayments_Withdraw_Public_Key,\r\n            vendor_processings_extra_data.Coinpayments_Withdraw_Private_Key,\r\n            vendor_processings_extra_data.Coinbase_API_Key,\r\n            vendor_processings_extra_data.Coinbase_Shared_Secret,\r\n            vendor_processings_extra_data.Paykassa_Deposit_Merchant_ID,\r\n            vendor_processings_extra_data.Paykassa_Deposit_Merchant_Password,\r\n            vendor_processings_extra_data.Paykassa_Withdraw_Enabled,\r\n            vendor_processings_extra_data.Paykassa_Withdraw_Merchant_ID,\r\n            vendor_processings_extra_data.Paykassa_Withdraw_API_ID,\r\n            vendor_processings_extra_data.Paykassa_Withdraw_API_Password,\r\n            vendor_processings_extra_data.Paykassa_Withdraw_Priority,\r\n            vendor_processings_extra_data.Payeer_Deposit_Shop_ID,\r\n            vendor_processings_extra_data.Payeer_Deposit_Secret_Key,\r\n            vendor_processings_extra_data.Payeer_Withdraw_Enabled,\r\n            vendor_processings_extra_data.Payeer_Withdraw_Account_ID,\r\n            vendor_processings_extra_data.Payeer_Withdraw_API_ID,\r\n            vendor_processings_extra_data.Payeer_Withdraw_API_Key,\r\n            vendor_processings_extra_data.Perfectmoney_Deposit_USD_Account_Number,\r\n            vendor_processings_extra_data.Perfectmoney_Deposit_Account_Name,\r\n            vendor_processings_extra_data.Perfectmoney_Deposit_Alternate_Password,\r\n            vendor_processings_extra_data.Perfectmoney_Withdraw_Enabled,\r\n            vendor_processings_extra_data.Perfectmoney_Withdraw_Account_ID,\r\n            vendor_processings_extra_data.Perfectmoney_Withdraw_USD_Account,\r\n            vendor_processings_extra_data.Perfectmoney_Withdraw_Account_Password\r\n        FROM hm2_processings LEFT JOIN vendor_processings_extra_data\r\n        ON hm2_processings.id = vendor_processings_extra_data.hm2_processings_id\r\n        WHERE hm2_processings.name = \"" . $ProcessorName . '"';
		$stmt = $this->PDOConn->query($sql);
		$_obfuscated_0D120B0704131C290E120604210C311E33251C04223922_ = array();
		$data = $stmt->fetchAll(PDO::FETCH_ASSOC);

		if (isset($data[0])) {
			return $data[0];
		}

		return false;
	}

	public function setProcessorStatus($ProcessorID, $Enabled)
	{
		$sql = 'UPDATE `hm2_processings` SET `status` = ' . $Enabled . ' WHERE id = ' . $ProcessorID;
		$stmt = $this->PDOConn->query($sql);
		$_obfuscated_0D111F0634303C1815371C38302609052D0A400C350932_ = $this->PDOConn->lastInsertId();
...........................................................................
..............................................
.........................