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

function checkConnection($params)
{
	logModuleCall( 'XTREAM-CODES', 'CHECK PANEL CONNECTION' );
	get_latest(  );
	$con = mysqli_connect( $params['serverip'], $params['serverusername'], $params['serverpassword'], config_dbname, config_port );

	if (!($con)) {
		$result = mysqli_connect_error(  );
	}
	 else {
		$result = 'Success';
	}

	mysqli_close( $con );
	return $result;
}

function run_query($params, $query)
{
	get_latest(  );
	debug( 'XTREAM: Prepared query: ' . $query );
	debug( 'XTREAM: Running query' );
	$con = mysqli_connect( $params['serverip'], $params['serverusername'], $params['serverpassword'], config_dbname, config_port );

	if (!($con)) {
		$error = mysqli_connect_error(  );
		logActivity( 'XTREAM: ERROR while connecting panel DB! ' . $error );
	}
	 else {
		$runQuery = mysqli_query( $con, $query );
	}

	if (!($runQuery)) {
		$error = mysqli_error( $con );
		logActivity( 'XTREAM: ERROR while running query! ' . $error );
		$result = $error;
	}
	 else {
		$result = 'success';
	}

	mysqli_close( $con );
	debug( 'XTREAM: running query finished Result = ' . $result );
	return $result;
}

function get_userid($params, $orderid, $mode)
{
	logActivity( 'XTREAM: Getting userID for ' . $mode );
	$con = mysqli_connect( $params['serverip'], $params['serverusername'], $params['serverpassword'], config_dbname, config_port );

	if ($mode == 'mag') {
		$magident = 'WHMCSMAG:' . $orderid;
		$query = 'SELECT id FROM `users` WHERE username = \'' . $magident . '\'';
	}
	 else {
		$query = 'SELECT id FROM `users` WHERE reseller_notes = \'' . $orderid . '\'';
	}

	debug( 'XTREAM: prepared query ' . $query );

	if (!($con)) {
		$error = mysqli_connect_error(  );
		logActivity( 'XTREAM: ERROR CONNECTING TO PANEL DB ! ' . $error );
	}
	 else {
		$result = mysqli_query( $con, $query );
		$result = mysqli_fetch_array( $result );
		$userid = $result[0];
	}

	if (!(empty( $userid ))) {
		logActivity( 'XTREAM: Retrived userid ' . $userid );
	}
	 else {
		logActivity( 'XTREAM: ERROR GETTING USERID!' );
	}

	mysqli_close( $con );
	return $userid;
}

function add_new_user($params)
{
	logActivity( 'XTREAM: Adding new user' );
	$email = $params['clientsdetails']['email'];
.................................................................
..........................
.........