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

function getpasshash($str)
{
	$strmd = md5($str);
	return password_hash($strmd, PASSWORD_DEFAULT);
}

function getmpidflow($mpid)
{
	global $db;
	global $cfgrow;
	global $bpprow;

	if (intval($mpid) < 1) {
		return 0;
		exit();
	}

	$sprstr = getmbrinfo('', '', $mpid);
	$maxwideexd = $sprstr['mpwidth'];
	$maxdeepexd = $sprstr['mpdepth'] * 2;
	if (($maxwideexd < 1) || ($maxdeepexd < 1)) {
		return $mpid;
		exit();
	}

	$filterstatus = ' AND (mpstatus = \'1\' OR mpstatus = \'2\')';
	$mysprlist = '|1:' . $mpid . '|';
	$condition = ' AND sprlist LIKE \'%' . $mysprlist . '%\'' . $filterstatus;
	$row = $db->getAllRecords(DB_TBLPREFIX . '_mbrplans', 'COUNT(*) as totref', $condition);
	$total = intval($row[0]['totref']);

	if ($sprstr['mpwidth'] <= $total) {
		if ($bpprow['spillover'] == 1) {
			$count_subrefsql = ', (SELECT COUNT(*) FROM ' . DB_TBLPREFIX . '_mbrplans WHERE idspr = ovrid) as totsubref ';
			$ordby = 'totsubref ASC, reg_utctime ASC, mpid DESC';
		}
		else {
			$count_subrefsql = '';
			$ordby = 'reg_utctime ASC, mpid DESC, idmbr ASC';
		}

		for ($i = 1; $i <= $maxdeepexd; $i++) {
			$tmpmpid = [];
			$mpidx = '';
			$directsprlist = '|' . $i . ':' . $mpid . '|';
			$condition = ' AND sprlist LIKE \'%' . $directsprlist . '%\'' . $filterstatus;
			$userData = $db->getRecFrmQry('SELECT mpid as ovrid ' . $count_subrefsql . ' FROM ' . DB_TBLPREFIX . '_mbrplans WHERE 1 ' . $condition . ' ORDER BY ' . $ordby);

			if (0 < count($userData)) {
				foreach ($userData as $val) {
					$mpidx = $val['ovrid'];
					$tmpmpid[] = $mpidx;
					$subsprlist = '|1:' . $mpidx . '|';
........................................................................
.........................................
.....................