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

function ppm01($vars) {

	$ppmstatus = ppm_checklicense($GLOBALS["ppmlicensekey"], $GLOBALS["ppmlocalkey"]);
	if ($ppmstatus["status"] != "Active")
	{
		return false;
	}
	$r = select_query("tblhosting", "subscriptionid, userid", array("id" => $vars["relid"], "subscriptionid" => array("sqltype" => "LIKE", "value" => "I-%")));
	if (0 < mysql_num_rows($r))
	{
		$row = mysql_fetch_assoc($r);
		$subscriptionid = $row["subscriptionid"];
		$userid = $row["userid"];
		$relid = $vars["relid"];
		cancelSubscriptionMain($subscriptionid, $userid, $relid);
	}
	 else
	{
		logactivity("PayPal Manager: No PayPal Subscription ID detected, or subscription ID not supported for this service - not attempting to cancel.");
	}
	return;
}

function ppm02($vars) {

	$ppmstatus = ppm_checklicense($GLOBALS["ppmlicensekey"], $GLOBALS["ppmlocalkey"]);
	if ($ppmstatus["status"] != "Active")
	{
		return false;
	}
	$q = "SELECT tblupgrades.relid, tblhosting.subscriptionid, tblhosting.paymentmethod, tblhosting.userid FROM tblupgrades, tblhosting WHERE tblupgrades.id = '" . $vars["upgradeid"] . "' AND tblhosting.id = tblupgrades.relid AND tblhosting.subscriptionid LIKE 'I-%' AND tblhosting.paymentmethod = 'paypal'";
	if (!($r = mysql_query($q)))
	{
		die("Error in query " . mysql_error());
	}
	if (0 < mysql_num_rows($r))
	{
		$row = mysql_fetch_assoc($r);
		$subscriptionid = urlencode($row["subscriptionid"]);
		$relid = $row["relid"];
		$userid = $row["userid"];
		cancelSubscriptionMain($subscriptionid, $userid, $relid);
	}
	 else
	{
		logactivity("PayPal Manager: No PayPal Subscription ID detected, or subscription ID not supported for this service - not attempting to cancel.");
	}
	return;
}

function ppm03($vars) {

	$ppmstatus = ppm_checklicense($GLOBALS["ppmlicensekey"], $GLOBALS["ppmlocalkey"]);
	if ($ppmstatus["status"] != "Active")
	{
		return false;
	}
	$serviceid = $vars["params"]["serviceid"];
	$q = "SELECT * FROM `tblhosting` WHERE `id` = '" . $serviceid . "' AND `paymentmethod` = 'paypal' AND `subscriptionid` LIKE 'I-%'";
	if (!($r = mysql_query($q)))
	{
		die("Error in query " . mysql_error());
	}
	$nr = mysql_num_rows($r);
	if (0 < $nr)
	{
		$row = mysql_fetch_assoc($r);
		$userid = $row["userid"];
		$subscriptionid = $row["subscriptionid"];
		$amount = $row["amount"];
		$q2 = "SELECT tblaccounts.transid, tblaccounts.date FROM tblaccounts, tblinvoices, tblinvoiceitems WHERE tblaccounts.userid = '" . $userid . "' AND tblaccounts.gateway = 'paypal' AND tblinvoices.userid = '" . $userid . "' AND tblinvoiceitems.relid = '" . $serviceid . "' GROUP BY tblaccounts.transid ORDER BY date DESC LIMIT 10";
		if (!($r2 = mysql_query($q2)))
		{
			die("Error in query " . mysql_error());
		}
		$nr2 = mysql_num_rows($r2);
		if (0 < $nr2)
		{
			while ($row2 = mysql_fetch_assoc($r2))
			{
................................................................
.....................................
...............