<h2>File Contents: /home/planet5/.trash/tracking202/setup/aff_networks.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/.trash/tracking202/setup/aff_networks.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();

if (!$userObj-&gt;hasPermission(&quot;access_to_setup_section&quot;)) {
	header(&#039;location: &#039;.get_absolute_url().&#039;tracking202/&#039;);
	die();
}

$slack = false;
$mysql[&#039;user_id&#039;] = $db-&gt;real_escape_string($_SESSION[&#039;user_own_id&#039;]);
$mysql[&#039;user_own_id&#039;] = $db-&gt;real_escape_string($_SESSION[&#039;user_own_id&#039;]);
$user_sql = &quot;SELECT 2u.user_name as username, 2u.install_hash, 2up.user_slack_incoming_webhook AS url FROM 202_users AS 2u INNER JOIN 202_users_pref AS 2up ON (2up.user_id = 1) WHERE 2u.user_id = &#039;&quot;.$mysql[&#039;user_own_id&#039;].&quot;&#039;&quot;;
$user_results = $db-&gt;query($user_sql);
$user_row = $user_results-&gt;fetch_assoc();

if (!empty($user_row[&#039;url&#039;])) 
	$slack = new Slack($user_row[&#039;url&#039;]);

if ($_GET [&#039;edit_aff_network_id&#039;]) {
	$editing = true;
}

if ($_SERVER [&#039;REQUEST_METHOD&#039;] == &#039;POST&#039;) {
	$aff_network_name = trim ( $_POST [&#039;aff_network_name&#039;] );
	if (empty ( $aff_network_name )) {
		$error [&#039;aff_network_name&#039;] = &#039;&lt;div class=&quot;error&quot;&gt;Type in the name of your campaign\&#039;s category.&lt;/div&gt;&#039;;
	}

	//if editing, check to make sure the own the network they are editing
	if ($editing == true) {
		$mysql [&#039;aff_network_id&#039;] = $db-&gt;real_escape_string ( $_GET [&#039;edit_aff_network_id&#039;] );
		$mysql [&#039;user_id&#039;] = $db-&gt;real_escape_string ( $_SESSION [&#039;user_id&#039;] );
		$aff_network_sql = &quot;SELECT * FROM `202_aff_networks` WHERE `user_id`=&#039;&quot; . $mysql [&#039;user_id&#039;] . &quot;&#039; AND `aff_network_id`=&#039;&quot; . $mysql [&#039;aff_network_id&#039;] . &quot;&#039;&quot;;
		$aff_network_result = $db-&gt;query ( $aff_network_sql ) or record_mysql_error ( $aff_network_sql );
		if ($aff_network_result-&gt;num_rows == 0) {
			$error [&#039;wrong_user&#039;] = &#039;&lt;div class=&quot;error&quot;&gt;You are not authorized to edit another users network&lt;/div&gt;&#039;;
		} else {
			$aff_network_row = $aff_network_result-&gt;fetch_assoc();
		}
	}
	
	if (! $error) {

		$mysql [&#039;aff_network_name&#039;] = $db-&gt;real_escape_string ( $_POST [&#039;aff_network_name&#039;] );
		$mysql [&#039;user_id&#039;] = $db-&gt;real_escape_string ( $_SESSION [&#039;user_id&#039;] );
		$mysql [&#039;aff_network_time&#039;] = time ();

		if ($editing == true) {
			$aff_network_sql = &quot;UPDATE `202_aff_networks` SET&quot;;
		} else {
			$aff_network_sql = &quot;INSERT INTO `202_aff_networks` SET&quot;;
		}
		
		$aff_network_sql .= &quot;`user_id`=&#039;&quot; . $mysql [&#039;user_id&#039;] . &quot;&#039;,
										`aff_network_name`=&#039;&quot; . $mysql [&#039;aff_network_name&#039;] . &quot;&#039;,
										`aff_network_time`=&#039;&quot; . $mysql [&#039;aff_network_time&#039;] . &quot;&#039;&quot;;
		if ($editing == true) {
			$aff_network_sql .= &quot;WHERE `aff_network_id`=&#039;&quot; . $mysql [&#039;aff_network_id&#039;] . &quot;&#039;&quot;;
		}
		$aff_network_result = $db-&gt;query ( $aff_network_sql ) or record_mysql_error ( $aff_network_sql );
		
		$add_success = true;

		if ($slack) {
			if ($editing == true) {
				$slack-&gt;push(&#039;campaign_category_name_changed&#039;, array(&#039;old_name&#039; =&gt; $aff_network_row[&#039;aff_network_name&#039;], &#039;new_name&#039; =&gt; $_POST[&#039;aff_network_name&#039;], &#039;user&#039; =&gt; $user_row[&#039;username&#039;]));
			} else {
				$slack-&gt;push(&#039;campaign_category_created&#039;, array(&#039;name&#039; =&gt; $_POST[&#039;aff_network_name&#039;], &#039;user&#039; =&gt; $user_row[&#039;username&#039;]));
			}
		}
	}

	tagUserByNetwork($user_row[&#039;install_hash&#039;], &#039;affiliate-networks&#039;, $_POST[&#039;aff_network_name&#039;]);	
}
 

if ($_GET [&#039;edit_aff_network_id&#039;]) {
	
	$mysql [&#039;user_id&#039;] = $db-&gt;real_escape_string ( $_SESSION [&#039;user_id&#039;] );
	$mysql [&#039;aff_network_id&#039;] = $db-&gt;real_escape_string ( $_GET [&#039;edit_aff_network_id&#039;] );
	
	$aff_network_sql = &quot;SELECT 	* 
						 FROM   	`202_aff_networks`
						 WHERE  	`aff_network_id`=&#039;&quot; . $mysql [&#039;aff_network_id&#039;] . &quot;&#039;
						 AND    		`user_id`=&#039;&quot; . $mysql [&#039;user_id&#039;] . &quot;&#039;&quot;;
	$aff_network_result = $db-&gt;query ( $aff_network_sql ) or record_mysql_error ( $aff_network_sql );
	$aff_network_row = $aff_network_result-&gt;fetch_assoc();
	
	$html = array_map ( &#039;htmlentities&#039;, $aff_network_row );
	$html[&#039;aff_network_id&#039;] = htmlentities ( $_GET [&#039;edit_aff_network_id&#039;], ENT_QUOTES, &#039;UTF-8&#039; );
	$autocomplete_aff_network_name =  $html[&#039;aff_network_name&#039;];

}

//this will override the edit, if posting and edit fail
if (($_SERVER [&#039;REQUEST_METHOD&#039;] == &#039;POST&#039;) and ($add_success != true)) {
	
	$selected [&#039;aff_network_id&#039;] = $_POST [&#039;aff_network_id&#039;];
	$html = array_map ( &#039;htmlentities&#039;, $_POST );
}

if (isset ( $_GET [&#039;delete_aff_network_id&#039;] )) {
	
	if ($userObj-&gt;hasPermission(&quot;remove_campaign_category&quot;)) {
		$mysql [&#039;user_id&#039;] = $db-&gt;real_escape_string ( $_SESSION [&#039;user_id&#039;] );
		$mysql [&#039;aff_network_id&#039;] = $db-&gt;real_escape_string ( $_GET [&#039;delete_aff_network_id&#039;] );
		$mysql [&#039;aff_network_time&#039;] = time ();
		
		$delete_sql = &quot; UPDATE  `202_aff_networks`
						SET     `aff_network_deleted`=&#039;1&#039;,
								`aff_network_time`=&#039;&quot; . $mysql [&#039;aff_network_time&#039;] . &quot;&#039;
						WHERE   `user_id`=&#039;&quot; . $mysql [&#039;user_id&#039;] . &quot;&#039;
						AND     `aff_network_id`=&#039;&quot; . $mysql [&#039;aff_network_id&#039;] . &quot;&#039;&quot;;
		if ($delete_result = $db-&gt;query ( $delete_sql ) or record_mysql_error ( $delete_result )) {
			$delete_success = true;

			if ($slack)
			$slack-&gt;push(&#039;campaign_category_deleted&#039;, array(&#039;name&#039; =&gt; $_GET[&#039;delete_aff_network_name&#039;], &#039;user&#039; =&gt; $user_row[&#039;username&#039;]));
		}
	} else {
		header(&#039;location: &#039;.get_absolute_url().&#039;tracking202/setup/aff_networks.php&#039;);
	}
	
}

template_top ( &#039;Campaign Category Setup&#039;, NULL, NULL, NULL );
?&gt;

&lt;div class=&quot;row&quot; style=&quot;margin-bottom: 15px;&quot;&gt;
	&lt;div class=&quot;col-xs-12&quot;&gt;
		&lt;div class=&quot;row&quot;&gt;
			&lt;div class=&quot;col-xs-5&quot;&gt;
				&lt;h6&gt;Campaign Category Setup &lt;?php showHelp(&quot;step2&quot;); ?&gt;&lt;/h6&gt;
			&lt;/div&gt;
			&lt;div class=&quot;col-xs-8&quot;&gt;
				&lt;div class=&quot;&lt;?php if($error) echo &quot;error&quot;; else echo &quot;success&quot;;?&gt; pull-right&quot; style=&quot;margin-top: 20px;&quot;&gt;
					&lt;small&gt;
						&lt;?php if ($error) { ?&gt; 
							&lt;span class=&quot;fui-alert&quot;&gt;&lt;/span&gt; There were errors with your submission. &lt;?php echo $error[&#039;token&#039;]; ?&gt;
						&lt;?php } ?&gt;
						&lt;?php if ($add_success == true) { ?&gt;
								&lt;?php if($editing == true) { ?&gt;
									&lt;span class=&quot;fui-check-inverted&quot;&gt;&lt;/span&gt; Your submission was successful. You have successfully edited category.
								&lt;?php } else { ?&gt;
									&lt;span class=&quot;fui-check-inverted&quot;&gt;&lt;/span&gt; Your submission was successful. You have successfully added a category to your account.
								&lt;?php } ?&gt;
						&lt;?php } ?&gt;
						&lt;?php if ($delete_success == true) { ?&gt;
							&lt;span class=&quot;fui-check-inverted&quot;&gt;&lt;/span&gt; You have successfully deleted a category from your account.
						&lt;?php } ?&gt;
						
					&lt;/small&gt;
				&lt;/div&gt;
			&lt;/div&gt;
		&lt;/div&gt;
	&lt;/div&gt;
	&lt;div class=&quot;col-xs-12&quot;&gt;
		&lt;small&gt;Add categories for the offer you will you work with here. For example you may enter in the affiliate networks you work or you could enter in different categories/niches such as &quot;Lead Gen&quot;, &quot;Mobile CPI&quot;, &quot;CPA&quot; or &quot;CPS&quot;.&lt;/small&gt;
	&lt;/div&gt;
&lt;/div&gt;

&lt;div class=&quot;row form_seperator&quot; style=&quot;margin-bottom:15px;&quot;&gt;
	&lt;div class=&quot;col-xs-12&quot;&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;div class=&quot;row&quot;&gt;
	&lt;div class=&quot;col-xs-7&quot;&gt;
		&lt;small&gt;&lt;strong&gt;Add Campaign Category&lt;/strong&gt;&lt;/small&gt;&lt;br/&gt;
		&lt;span class=&quot;infotext&quot;&gt;What Campaign Categories do you want to use? Some examples include Commission Junction or Mobile etc.&lt;/span&gt;
				
		&lt;form method=&quot;post&quot; action=&quot;&lt;?php echo $_SERVER [&#039;REDIRECT_URL&#039;]; ?&gt;&quot; class=&quot;form-inline&quot; role=&quot;form&quot; style=&quot;margin:15px 0px;&quot;&gt;
			&lt;div class=&quot;form-group &lt;?php if($error[&#039;aff_network_name&#039;]) echo &quot;has-error&quot;;?&gt;&quot;&gt;
				&lt;label class=&quot;sr-only&quot; for=&quot;aff_network_name&quot;&gt;Traffic source&lt;/label&gt;
				&lt;input type=&quot;text&quot; class=&quot;form-control input-sm&quot; id=&quot;aff_network_name&quot; name=&quot;aff_network_name&quot; placeholder=&quot;Campaign category&quot; value=&quot;&lt;?php echo $html[&#039;aff_network_name&#039;]; ?&gt;&quot;&gt;
			&lt;/div&gt;
			&lt;button type=&quot;submit&quot; class=&quot;btn btn-xs btn-p202&quot; &lt;?php if ($network_editing != true) { echo &#039;id=&quot;addCategory&quot;&#039;; }?&gt;&gt;&lt;?php if ($network_editing == true) { echo &#039;Edit&#039;; } else { echo &#039;Add&#039;; } ?&gt;&lt;/button&gt;
			&lt;?php if ($editing == true) { ?&gt;
				&lt;button type=&quot;submit&quot; class=&quot;btn btn-xs btn-danger&quot; onclick=&quot;&lt;?php echo get_absolute_url();?&gt;tracking202/setup/aff_networks.php&#039;; return false;&quot;&gt;Cancel&lt;/button&gt;
			&lt;?php } ?&gt;
		&lt;/form&gt;
	&lt;/div&gt;
	&lt;div class=&quot;col-xs-4 col-xs-offset-1&quot;&gt;
		&lt;div class=&quot;panel panel-default&quot;&gt;
			&lt;div class=&quot;panel-heading&quot;&gt;My Campaign Categories&lt;/div&gt;
			&lt;div class=&quot;panel-body&quot;&gt;
			&lt;div id=&quot;networkList&quot;&gt;
			&lt;input class=&quot;form-control input-sm fuzzy-search&quot; style=&quot;margin-bottom: 10px; height: 30px;&quot; placeholder=&quot;Filter&quot;&gt;
				&lt;ul class=&quot;list&quot;&gt;		
					&lt;?php
					$mysql [&#039;user_id&#039;] = $db-&gt;real_escape_string ( $_SESSION [&#039;user_id&#039;] );
					$aff_network_sql = &quot;SELECT * FROM `202_aff_networks` WHERE `user_id`=&#039;&quot; . $mysql [&#039;user_id&#039;] . &quot;&#039; AND `aff_network_deleted`=&#039;0&#039; ORDER BY `aff_network_name` ASC&quot;;
					
					$aff_network_result = $db-&gt;query ( $aff_network_sql ) or record_mysql_error ( $aff_network_sql );
					if ($aff_network_result-&gt;num_rows == 0) {
						?&gt;&lt;li&gt;You have not added any networks.&lt;/li&gt;&lt;?php
					}
					
					while ( $aff_network_row = $aff_network_result-&gt;fetch_array (MYSQLI_ASSOC) ) {
						$html [&#039;aff_network_name&#039;] = htmlentities ( $aff_network_row [&#039;aff_network_name&#039;], ENT_QUOTES, &#039;UTF-8&#039; );
						$html [&#039;aff_network_id&#039;] = htmlentities ( $aff_network_row [&#039;aff_network_id&#039;], ENT_QUOTES, &#039;UTF-8&#039; );
						$html [&#039;network_logo&#039;] = &#039;&#039;;
				
						if(!empty($aff_network_row [&#039;dni_network_id&#039;]))
						    $html [&#039;network_logo&#039;]= &#039;&lt;img src=&quot;/202-img/favicon.gif&quot; width=16&gt;&amp;nbsp;&amp;nbsp;&#039;; //replace with actual logo from db
						    
						if ($userObj-&gt;hasPermission(&quot;remove_campaign_category&quot;)) {
							printf ( &#039;&lt;li&gt;%s &lt;span class=&quot;filter_network_name&quot;&gt;%s&lt;/span&gt; - &lt;a href=&quot;?edit_aff_network_id=%s&quot;&gt;edit&lt;/a&gt; - &lt;a href=&quot;?delete_aff_network_id=%s&amp;delete_aff_network_name=%s&quot; onclick=&quot;return confirmSubmit(\&#039;Are You Sure You Want To Delete This Campaign Category?\&#039;);&quot;&gt;remove&lt;/a&gt;&lt;/li&gt;&#039;, $html [&#039;network_logo&#039;], $html [&#039;aff_network_name&#039;], $html [&#039;aff_network_id&#039;], $html [&#039;aff_network_id&#039;],$html [&#039;aff_network_name&#039;] );
						} else {
							printf ( &#039;&lt;li&gt;%s &lt;span class=&quot;filter_network_name&quot;&gt;%s&lt;/span&gt; - &lt;a href=&quot;?edit_aff_network_id=%s&quot;&gt;edit&lt;/a&gt;&lt;/li&gt;&#039;, $html [&#039;network_logo&#039;], $html [&#039;aff_network_name&#039;], $html [&#039;aff_network_id&#039;]);
						}
					
					}
					?&gt; 
				&lt;/ul&gt;
				&lt;/div&gt;
			&lt;/div&gt;
		&lt;/div&gt;
	&lt;/div&gt;
&lt;/div&gt;
&lt;script type=&quot;text/javascript&quot;&gt;
$(document).ready(function() {
	autocomplete_names(&#039;aff_network_name&#039;, &#039;affiliate-networks&#039;);
	&lt;?php if($_GET[&#039;edit_aff_network_id&#039;]) { ?&gt;
		$(&quot;#aff_network_name&quot;).tokenfield(&quot;setTokens&quot;, &lt;?php print_r(json_encode(array(&#039;value&#039; =&gt; $autocomplete_aff_network_name, &#039;label&#039; =&gt; $autocomplete_aff_network_name)))?&gt;);
	&lt;?php } ?&gt;

	var networkOptions = {
	  valueNames: [&#039;filter_network_name&#039;],
	  plugins: [
	    ListFuzzySearch()
	  ]
	};

	var networkList = new List(&#039;networkList&#039;, networkOptions);
});
&lt;/script&gt;
&lt;?php template_bottom (); ?&gt;</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2F.trash%2Ftracking202%2Fsetup'>⬅ Back to Directory</a>