<h2>File Contents: /home/planet5/.trash/tracking202/ajax/dni_get_offers.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/.trash/tracking202/ajax/dni_get_offers.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php
include_once(str_repeat(&quot;../&quot;, 2).&#039;202-config/connect.php&#039;); 
AUTH::require_user();

$mysql[&#039;user_id&#039;] = $db-&gt;real_escape_string($_SESSION[&#039;user_id&#039;]);
$dni_id = $_GET[&#039;dni&#039;];
$mysql[&#039;dni_id&#039;] = $db-&gt;real_escape_string($dni_id);

if (isset($_GET[&#039;dni&#039;]) &amp;&amp; isset($_GET[&#039;all_offers&#039;])) {

	$sort = $_GET[&#039;column&#039;];
	$filter = $_GET[&#039;filter&#039;];

	$sql = &quot;SELECT dni.networkId, dni.apiKey, dni.affiliateId, dni.name, 2u.install_hash, 2up.user_account_currency FROM 202_dni_networks AS dni LEFT JOIN 202_users AS 2u USING (user_id) LEFT JOIN 202_users_pref AS 2up USING (user_id) WHERE dni.user_id = &#039;&quot;.$mysql[&#039;user_id&#039;].&quot;&#039; AND dni.id = &#039;&quot;.$mysql[&#039;dni_id&#039;].&quot;&#039;&quot;;
	$results = $db-&gt;query($sql);
	if ($results-&gt;num_rows &gt; 0) {
		$dni = $results-&gt;fetch_assoc();
		
		$sort_by = array(&#039;column&#039; =&gt; &#039;&#039;, &#039;by&#039; =&gt; &#039;&#039;);
		if (!empty($sort)) {
			foreach ($sort as $key =&gt; $value) {
				if ($sort[$key] == 0) {
					$sort_by[&#039;by&#039;] = &#039;ASC&#039;;
				} else {
					$sort_by[&#039;by&#039;] = &#039;DESC&#039;;
				}

				if ($key == 0) {
					$sort_by[&#039;column&#039;] = &#039;id&#039;;
				}

				if ($key == 1) {
					$sort_by[&#039;column&#039;] = &#039;name&#039;;
				}

				if ($key == 2) {
					$sort_by[&#039;column&#039;] = &#039;default_payout&#039;;
				}

				if ($key == 3) {
					$sort_by[&#039;column&#039;] = &#039;payout_type&#039;;
				}

				if ($key == 5) {
					$sort_by[&#039;column&#039;] = &#039;require_approval&#039;;
				}
			}
		}

		$filter_by = array();
		if (!empty($filter)) {

			foreach ($filter as $key =&gt; $value) {
				if ($key == 0) {
					$filter_by[&#039;id&#039;] = $value;
				}

				if ($key == 1) {
					$filter_by[&#039;name&#039;] = $value;
				}

				if ($key == 2) {
					$filter_by[&#039;default_payout&#039;] = $value;
				}

				if ($key == 3) {
					$filter_by[&#039;payout_type&#039;] = $value;
				}
			}
		}
		
		echo getDniOffers($dni[&#039;install_hash&#039;], $dni[&#039;networkId&#039;], $dni[&#039;apiKey&#039;], $dni[&#039;affiliateId&#039;], $dni[&#039;user_account_currency&#039;], $_GET[&#039;offset&#039;], $_GET[&#039;limit&#039;], $sort_by, $filter_by);
	}
}

if (isset($_GET[&#039;dni&#039;]) &amp;&amp; isset($_GET[&#039;get_offer&#039;]) &amp;&amp; isset($_GET[&#039;offer_id&#039;])) {
	$sql = &quot;SELECT dni.networkId, dni.apiKey, dni.affiliateId, dni.name, 2u.install_hash FROM 202_dni_networks AS dni LEFT JOIN 202_users AS 2u USING(user_id) WHERE dni.user_id = &#039;&quot;.$mysql[&#039;user_id&#039;].&quot;&#039; AND dni.id = &#039;&quot;.$mysql[&#039;dni_id&#039;].&quot;&#039;&quot;;
	$results = $db-&gt;query($sql);
	if ($results-&gt;num_rows &gt; 0) {
		$dni = $results-&gt;fetch_assoc();
		echo getDniOfferById($dni[&#039;install_hash&#039;], $dni[&#039;networkId&#039;], $dni[&#039;apiKey&#039;], $dni[&#039;affiliateId&#039;], $_GET[&#039;offer_id&#039;]);
	}
}

if (isset($_GET[&#039;dni&#039;]) &amp;&amp; isset($_GET[&#039;request_offer_access&#039;]) &amp;&amp; isset($_GET[&#039;offer_id&#039;]) &amp;&amp; isset($_GET[&#039;type&#039;])) {
	$sql = &quot;SELECT dni.networkId, dni.apiKey, dni.affiliateId, dni.name, 2u.install_hash FROM 202_dni_networks AS dni LEFT JOIN 202_users AS 2u USING(user_id) WHERE dni.user_id = &#039;&quot;.$mysql[&#039;user_id&#039;].&quot;&#039; AND dni.id = &#039;&quot;.$mysql[&#039;dni_id&#039;].&quot;&#039;&quot;;
	$results = $db-&gt;query($sql);
	if ($results-&gt;num_rows &gt; 0) {
		$dni = $results-&gt;fetch_assoc();
		echo requestDniOfferAccess($dni[&#039;install_hash&#039;], $dni[&#039;networkId&#039;], $dni[&#039;apiKey&#039;], $dni[&#039;affiliateId&#039;], $_GET[&#039;offer_id&#039;], $_GET[&#039;type&#039;]);
	}
}

if (isset($_GET[&#039;dni&#039;]) &amp;&amp; isset($_GET[&#039;offer_id&#039;]) &amp;&amp; isset($_GET[&#039;submit_offer_questions&#039;])) {
	$sql = &quot;SELECT dni.networkId, dni.apiKey, dni.affiliateId, dni.name, 2u.install_hash FROM 202_dni_networks AS dni LEFT JOIN 202_users AS 2u USING(user_id) WHERE dni.user_id = &#039;&quot;.$mysql[&#039;user_id&#039;].&quot;&#039; AND dni.id = &#039;&quot;.$mysql[&#039;dni_id&#039;].&quot;&#039;&quot;;
	$results = $db-&gt;query($sql);
	if ($results-&gt;num_rows &gt; 0) {
		$dni = $results-&gt;fetch_assoc();
		echo submitDniOfferAnswers($dni[&#039;install_hash&#039;], $dni[&#039;networkId&#039;], $dni[&#039;apiKey&#039;], $dni[&#039;affiliateId&#039;], $_GET[&#039;offer_id&#039;], $_POST);
	}
}

if (isset($_GET[&#039;dni&#039;]) &amp;&amp; isset($_GET[&#039;offer_id&#039;]) &amp;&amp; isset($_GET[&#039;setup_offer&#039;])) {
	$sql = &quot;SELECT dni.networkId, dni.apiKey, dni.affiliateId, 2u.install_hash, 2up.user_account_currency FROM 202_dni_networks AS dni LEFT JOIN 202_users AS 2u USING (user_id) LEFT JOIN 202_users_pref AS 2up USING (user_id) WHERE dni.user_id = &#039;&quot;.$mysql[&#039;user_id&#039;].&quot;&#039; AND dni.id = &#039;&quot;.$mysql[&#039;dni_id&#039;].&quot;&#039;&quot;;
	$results = $db-&gt;query($sql);
	if ($results-&gt;num_rows &gt; 0) {
		$dni = $results-&gt;fetch_assoc();
		$aff_network_sql = &quot;SELECT aff_network_id FROM 202_aff_networks WHERE dni_network_id = &#039;&quot;.$mysql[&#039;dni_id&#039;].&quot;&#039; AND aff_network_deleted=&#039;0&#039;&quot;;
		$aff_network_results = $db-&gt;query($aff_network_sql);
		$aff_network_row = $aff_network_results-&gt;fetch_assoc();
		$offerData = setupDniOffer($dni[&#039;install_hash&#039;], $dni[&#039;networkId&#039;], $dni[&#039;apiKey&#039;], $dni[&#039;affiliateId&#039;], $dni[&#039;user_account_currency&#039;], $_GET[&#039;offer_id&#039;], $_GET[&#039;ddlci&#039;]);
		$data = json_decode($offerData, true);
		$data[&#039;aff_network_id&#039;] = $aff_network_row[&#039;aff_network_id&#039;];
		header(&#039;Content-Type: application/json&#039;);
		echo json_encode($data);
	}
}

?&gt;</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2F.trash%2Ftracking202%2Fajax'>⬅ Back to Directory</a>