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

$slack = false;
$mysql[&#039;user_id&#039;] = $db-&gt;real_escape_string($_SESSION[&#039;user_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, 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(getSecureStatus()){
		$protocol = &#039;https://&#039;;
	}else{
		$protocol = &#039;https://&#039;;
	}
//check variables
	if ($_POST[&#039;tracker_type&#039;] == 0) { 

		if(empty($_POST[&#039;aff_network_id&#039;])) { $error[&#039;aff_network_id&#039;] = &#039;&lt;div class=&quot;error&quot;&gt;&lt;small&gt;&lt;span class=&quot;fui-alert&quot;&gt;&lt;/span&gt; You have not selected a Category.&lt;/small&gt;&lt;/div&gt;&#039;; }
		if(empty($_POST[&#039;aff_campaign_id&#039;])) { $error[&#039;aff_campaign_id&#039;] = &#039;&lt;div class=&quot;error&quot;&gt;&lt;small&gt;&lt;span class=&quot;fui-alert&quot;&gt;&lt;/span&gt; You have not selected a campaign.&lt;/small&gt;&lt;/div&gt;&#039;; }
		if(empty($_POST[&#039;method_of_promotion&#039;])) { $error[&#039;method_of_promotion&#039;] = &#039;&lt;div class=&quot;error&quot;&gt;&lt;small&gt;&lt;span class=&quot;fui-alert&quot;&gt;&lt;/span&gt; You have to select your method of promoting this campaign.&lt;/small&gt;&lt;/div&gt;&#039;; }
		
		echo $error[&#039;aff_network_id&#039;] . $error[&#039;aff_campaign_id&#039;] . $error[&#039;method_of_promotion&#039;];
		
		if ($error) { die(); } 

	} else if($_POST[&#039;tracker_type&#039;] == 2) {
		if(empty($_POST[&#039;tracker_rotator&#039;])) { die(&#039;&lt;div class=&quot;error&quot;&gt;&lt;small&gt;&lt;span class=&quot;fui-alert&quot;&gt;&lt;/span&gt; You have not selected rotator.&lt;/small&gt;&lt;/div&gt;&#039;); }
	}
	
	//but we&#039;ll allow them to choose the following options, can make a tracker link without but they will be notified	
	if ($_POST[&#039;tracker_type&#039;] != 2) {
		if($_POST[&#039;click_cloaking&#039;] == &#039;&#039;) { $error[&#039;click_cloaking&#039;] = &#039;&lt;div class=&quot;error&quot;&gt;&lt;small&gt;&lt;span class=&quot;fui-alert&quot;&gt;&lt;/span&gt; WARNING: This tracking link is not attached to any cloaking preference, are you sure you want to do this?&lt;/small&gt;&lt;/div&gt;&#039;; }
	}

	
	if ($_POST[&#039;ppc_network_id&#039;] and !$_POST[&#039;ppc_account_id&#039;]) { 
		die(&#039;&lt;div class=&quot;error&quot;&gt;&lt;small&gt;&lt;span class=&quot;fui-alert&quot;&gt;&lt;/span&gt; ERROR: You have a traffic source selected, but YOU DO NOT HAVE A TRAFFIC SOURCE ACCOUNT SELECTED.  In order to track your traffic-sources you must select a ppc-account. If you have not created one, go back to step #1 to add it now.&lt;/small&gt;&lt;/div&gt;&#039;);
	}
	if($_POST[&#039;ppc_network_id&#039;] == &#039;&#039;) { $error[&#039;ppc_network_id&#039;] = &#039;&lt;div class=&quot;error&quot;&gt;&lt;small&gt;&lt;span class=&quot;fui-alert&quot;&gt;&lt;/span&gt; WARNING: This tracking link is not attached to any Traffic Source, are you sure you want to do this?&lt;/small&gt;&lt;/div&gt;&#039;; }
	if($_POST[&#039;ppc_account_id&#039;] == &#039;&#039;) { $error[&#039;ppc_account_id&#039;] = &#039;&lt;div class=&quot;error&quot;&gt;&lt;small&gt;&lt;span class=&quot;fui-alert&quot;&gt;&lt;/span&gt; WARNING: This tracking link is not attached to any Traffic Source Account, are you sure you want to do this?&lt;/small&gt;&lt;/div&gt;&#039;; }
	if((!is_numeric($_POST[&#039;cpc_dollars&#039;])) or (!is_numeric($_POST[&#039;cpc_cents&#039;]))) { $error[&#039;cpc&#039;] = &#039;&lt;div class=&quot;error&quot;&gt;&lt;small&gt;&lt;span class=&quot;fui-alert&quot;&gt;&lt;/span&gt; WARNING: This tracking link does not have it\&#039;s CPC set, are you sure you want to do this?&lt;/small&gt;&lt;/div&gt;&#039;; }

	//if they do a landing page, make sure they have one
	if ($_POST[&#039;method_of_promotion&#039;] == &#039;landingpage&#039;) { 
		if (empty($_POST[&#039;landing_page_id&#039;])) {
			$error[&#039;landing_page_id&#039;] = &#039;&lt;div class=&quot;error&quot;&gt;&lt;small&gt;&lt;span class=&quot;fui-alert&quot;&gt;&lt;/span&gt; You have not selected a landing page to use.&lt;/small&gt;&lt;/div&gt;&#039;; 
		}
		
		echo $error[&#039;landing_page_id&#039;]; 
		if ($error[&#039;landing_page_id&#039;]) { die(); }    
	}

//echo error
	echo $error[&#039;text_ad_id&#039;] . $error[&#039;ppc_network_id&#039;] . $error[&#039;ppc_account_id&#039;] . $error[&#039;cpc&#039;] . $error[&#039;click_cloaking&#039;] . $error[&#039;cloaking_url&#039;];

//show tracking code

	$mysql[&#039;landing_page_id&#039;] = $db-&gt;real_escape_string($_POST[&#039;landing_page_id&#039;]);
	$landing_page_sql = &quot;SELECT * FROM `202_landing_pages` WHERE `landing_page_id`=&#039;&quot;.$mysql[&#039;landing_page_id&#039;].&quot;&#039;&quot;;
	$landing_page_result = $db-&gt;query($landing_page_sql) or record_mysql_error($landing_page_sql);
	$landing_page_row = $landing_page_result-&gt;fetch_assoc();
	
	if ($_POST[&#039;cost_type&#039;] == &#039;cpc&#039;) {
		$click_cpc = $_POST[&#039;cpc_dollars&#039;] . &#039;.&#039; . $_POST[&#039;cpc_cents&#039;];
		$mysql[&#039;click_cpc&#039;] = $db-&gt;real_escape_string($click_cpc);
		$cost_sql = &quot;`click_cpc`=&#039;&quot;.$mysql[&#039;click_cpc&#039;].&quot;&#039;,&quot;;
	} else if ($_POST[&#039;cost_type&#039;] == &#039;cpa&#039;) {
		$click_cpa = $_POST[&#039;cpa_dollars&#039;] . &#039;.&#039; . $_POST[&#039;cpa_cents&#039;];
		$mysql[&#039;click_cpa&#039;] = $db-&gt;real_escape_string($click_cpa);
		$cost_sql = &quot;`click_cpa`=&#039;&quot;.$mysql[&#039;click_cpa&#039;].&quot;&#039;,&quot;;
	}

	$mysql[&#039;user_id&#039;] = $db-&gt;real_escape_string($_SESSION[&#039;user_id&#039;]);
	$mysql[&#039;publisher_id&#039;] = $db-&gt;real_escape_string($_POST[&#039;publisher_id&#039;]);
	$mysql[&#039;aff_campaign_id&#039;] = $db-&gt;real_escape_string($_POST[&#039;aff_campaign_id&#039;]);
	$mysql[&#039;text_ad_id&#039;] = $db-&gt;real_escape_string($_POST[&#039;text_ad_id&#039;]);
	$mysql[&#039;ppc_network_id&#039;] = $db-&gt;real_escape_string($_POST[&#039;ppc_network_id&#039;]); 
	$mysql[&#039;ppc_account_id&#039;] = $db-&gt;real_escape_string($_POST[&#039;ppc_account_id&#039;]); 
	$mysql[&#039;click_cloaking&#039;] = $db-&gt;real_escape_string($_POST[&#039;click_cloaking&#039;]); 
	$mysql[&#039;landing_page_id&#039;] = $db-&gt;real_escape_string($landing_page_row[&#039;landing_page_id&#039;]);
	$mysql[&#039;rotator_id&#039;] = $db-&gt;real_escape_string($_POST[&#039;tracker_rotator&#039;]);
	$mysql[&#039;tracker_time&#039;] = time();
	
	$publisher_id_public = &#039;&#039;;
    //get public publisher id
    if($mysql[&#039;publisher_id&#039;]!=&#039;1&#039;){
        $publisher_sql = &quot;SELECT user_public_publisher_id FROM `202_users` WHERE `user_id`=&#039;&quot;.$mysql[&#039;publisher_id&#039;].&quot;&#039;&quot;;
        
        $publisher_row = memcache_mysql_fetch_assoc($publisher_sql);
        $publisher_id_public = $publisher_row[&#039;user_public_publisher_id&#039;];
    }
    
	if ($_POST[&#039;edit_tracker&#039;] &amp;&amp; $_POST[&#039;tracker_id&#039;]) {
		$mysql[&#039;tracker_id_public&#039;] = $db-&gt;real_escape_string($_POST[&#039;tracker_id&#039;]);
		$get_tracker_sql = &quot;SELECT 
							tracker_id, 
							tracker_id_public,
							202_trackers.aff_campaign_id,
							text_ad_id,
							ppc_account_id,
							aff_network_name,
							aff_campaign_name,
							landing_page_nickname,
							202_trackers.landing_page_id,
							rotator_id,
							text_ad_name,
							ppc_network_name,
							ppc_account_name,
							click_cloaking,
							click_cpc,
							click_cpa,
							name 
							FROM 202_trackers
							LEFT JOIN 202_aff_campaigns USING (aff_campaign_id)
							LEFT JOIN 202_aff_networks USING (aff_network_id)
							LEFT JOIN 202_text_ads USING (text_ad_id)
							LEFT JOIN 202_ppc_accounts USING (ppc_account_id)
							LEFT JOIN 202_ppc_networks USING (ppc_network_id)
							LEFT JOIN 202_landing_pages ON (202_trackers.landing_page_id = 202_landing_pages.landing_page_id) 
							LEFT JOIN 202_rotators ON (202_trackers.rotator_id = 202_rotators.id)
							WHERE 202_trackers.tracker_id_public = &#039;&quot;.$mysql[&#039;tracker_id_public&#039;].&quot;&#039; AND 202_trackers.user_id = &#039;&quot;.$mysql[&#039;user_id&#039;].&quot;&#039;&quot;;
		
		$get_tracker_result = $db-&gt;query($get_tracker_sql);
		$get_tracker_row = $get_tracker_result-&gt;fetch_assoc();		

		if ($get_tracker_result-&gt;num_rows &gt; 0) {
			$drop_tracker = &quot;DELETE FROM 202_trackers WHERE tracker_id = &#039;&quot;.$get_tracker_row[&#039;tracker_id&#039;].&quot;&#039;&quot;;
			$drop_tracker_result = $db-&gt;query($drop_tracker);
		}
	}

	$tracker_sql = &quot;INSERT INTO `202_trackers`
					SET			`user_id`=&#039;&quot;.$mysql[&#039;user_id&#039;].&quot;&#039;,
								`aff_campaign_id`=&#039;&quot;.$mysql[&#039;aff_campaign_id&#039;].&quot;&#039;,
								`tracker_id_public`=&#039;0&#039;,
								`text_ad_id`=&#039;&quot;.$mysql[&#039;text_ad_id&#039;].&quot;&#039;,
								`ppc_account_id`=&#039;&quot;.$mysql[&#039;ppc_account_id&#039;].&quot;&#039;,
								&quot;.$cost_sql.&quot;
								`landing_page_id`=&#039;&quot;.$mysql[&#039;landing_page_id&#039;].&quot;&#039;,
								`rotator_id`=&#039;&quot;.$mysql[&#039;rotator_id&#039;].&quot;&#039;,
								`click_cloaking`=&#039;&quot;.$mysql[&#039;click_cloaking&#039;].&quot;&#039;,
								`tracker_time`=&#039;&quot;.$mysql[&#039;tracker_time&#039;].&quot;&#039;&quot;;
	$tracker_result = $db-&gt;query($tracker_sql) or record_mysql_error($tracker_sql);
	
	$tracker_row[&#039;tracker_id&#039;] = $db-&gt;insert_id;
	$mysql[&#039;tracker_id&#039;] = $db-&gt;real_escape_string($tracker_row[&#039;tracker_id&#039;]);

	if ($_POST[&#039;edit_tracker&#039;] &amp;&amp; $_POST[&#039;tracker_id&#039;] &amp;&amp; $get_tracker_result-&gt;num_rows &gt; 0) {
		$mysql[&#039;tracker_id_public&#039;] = $db-&gt;real_escape_string($get_tracker_row[&#039;tracker_id_public&#039;]);
	} else {
		$tracker_id_public = rand(1,9) . $tracker_row[&#039;tracker_id&#039;] . rand(1,9);
		$mysql[&#039;tracker_id_public&#039;] = $db-&gt;real_escape_string($tracker_id_public);
	}
	
	$tracker_id_public = $mysql[&#039;tracker_id_public&#039;];

	$tracker_sql = &quot;UPDATE 		`202_trackers`
					SET			`tracker_id_public`=&#039;&quot;.$mysql[&#039;tracker_id_public&#039;].&quot;&#039;
					WHERE		`tracker_id`=&#039;&quot;.$mysql[&#039;tracker_id&#039;].&quot;&#039;&quot;; 
	$tracker_result = $db-&gt;query($tracker_sql) or record_mysql_error($tracker_sql);

	$parsed_url = parse_url($landing_page_row[&#039;landing_page_url&#039;]);
    
	$tracker_publisher_id = &#039;&#039;; //blank publisher id string
	
	if($mysql[&#039;publisher_id&#039;] != &#039;1&#039;){
	    $tracker_publisher_id = &quot;&amp;t202pubid=&quot;.$publisher_id_public;
	}
	//setup array of all internally recognized url variables
	$t202variables = array(
	    &quot;c1&quot;,
	    &quot;c2&quot;,
	    &quot;c3&quot;,
	    &quot;c4&quot;,
	    &quot;utm_source&quot;,
	    &quot;utm_medium&quot;,
	    &quot;utm_campaign&quot;,
	    &quot;utm_term&quot;,
	    &quot;utm_content&quot;,
	    &quot;t202ref&quot;,
	    &quot;t202b&quot;,
	    &quot;t202kw&quot;
	);
	
	$tracking_variable_string = &#039;&amp;&#039;;
	
	$get_variables = &quot;SELECT * FROM 202_ppc_network_variables WHERE ppc_network_id = &#039;&quot;.$mysql[&#039;ppc_network_id&#039;].&quot;&#039; AND deleted = 0&quot;;
	$get_variables_result = $db-&gt;query($get_variables);
	
	//loop over all our internal vars to see if user has set up a custom var in step 1
	if ($get_variables_result-&gt;num_rows &gt; 0) {
	    while ($get_variables_row = $get_variables_result-&gt;fetch_assoc()) {

	        $key=array_search($get_variables_row[&#039;parameter&#039;], $t202variables); // look for the current paramaeter in the list of internal url variables
	        
	        if($key===FALSE){ //if not found the output 
	             $tracking_variable_string .= $get_variables_row[&#039;parameter&#039;].&#039;=&#039; . $get_variables_row[&#039;placeholder&#039;] . &#039;&amp;&#039;;
	        }
	        else{ //if found save into our html array for later
	            $html[$t202variables[$key]]=$get_variables_row[&#039;placeholder&#039;];
	        }
	       unset($key); //unset just in case old values get stuck
	        
	    }
	}

	//loop over all our internal variables again
    foreach ($t202variables as $key) {
        
        if (isset($_POST[$key]) &amp;&amp; trim($_POST[$key]) != &#039;&#039;) { //if there is a non empty value posted, then overwrite current value in html array with it 
            $html[$key] = $db-&gt;real_escape_string(trim($_POST[$key]));
        }
        if (isset($html[$key]) || $key==&#039;t202kw&#039;)
            $tracking_variable_string .= $key . &#039;=&#039; . $html[$key] . &#039;&amp;&#039;; //now write out the values/ but only if they are not empty with the exception of t202kw with we will write out no matter what
    }
    
    //remove &amp; from end of the variable
    $tracking_variable_string=rtrim($tracking_variable_string,&#039;&amp;&#039;);


	if ($slack) {
		
		switch ($_POST[&#039;tracker_type&#039;]) {
			case &#039;0&#039;:
				if ($_POST[&#039;method_of_promotion&#039;] == &#039;directlink&#039;) {
						$tracker_type = &#039;Direct Link&#039;;
				} else if ($_POST[&#039;method_of_promotion&#039;] == &#039;landingpage&#039;) {
						$tracker_type = &#039;Simple Landing Page&#039;;
				}
				break;
				
			case &#039;1&#039;:
				$tracker_type = &#039;Advanced Landing Page&#039;;
				break;

			case &#039;2&#039;:
				$tracker_type = &#039;Smart Rotator&#039;;
				break;	
		}

		if (!$_POST[&#039;edit_tracker&#039;]) {

			$slack-&gt;push(&#039;tracking_link_created&#039;, array(&#039;type&#039; =&gt; $tracker_type, &#039;id&#039; =&gt; $tracker_row[&#039;tracker_id&#039;], &#039;user&#039; =&gt; $user_row[&#039;username&#039;]));

		} else if($_POST[&#039;edit_tracker&#039;] &amp;&amp; $_POST[&#039;tracker_id&#039;] &amp;&amp; $get_tracker_result-&gt;num_rows &gt; 0) {

			if ($_POST[&#039;tracker_type&#039;] == &#039;0&#039;) {
				if ($_POST[&#039;aff_campaign_id&#039;] != $get_tracker_row[&#039;aff_campaign_id&#039;]) {
					
					$mysql[&#039;aff_campaign_id&#039;] = $db-&gt;real_escape_string($_POST[&#039;aff_campaign_id&#039;]);
					$sql = &quot;SELECT aff_network_name, aff_campaign_name FROM 202_aff_campaigns LEFT JOIN 202_aff_networks USING (aff_network_id) WHERE aff_campaign_id = &#039;&quot;.$mysql[&#039;aff_campaign_id&#039;].&quot;&#039;&quot;;
					$result = $db-&gt;query($sql);
					$row = $result-&gt;fetch_assoc();

					$slack-&gt;push(&#039;tracking_link_category_changed&#039;, array(&#039;type&#039; =&gt; $tracker_type, &#039;id&#039; =&gt; $tracker_row[&#039;tracker_id&#039;], &#039;old_category&#039; =&gt; $get_tracker_row[&#039;aff_network_name&#039;], &#039;new_category&#039; =&gt; $row[&#039;aff_network_name&#039;], &#039;user&#039; =&gt; $user_row[&#039;username&#039;]));
					$slack-&gt;push(&#039;tracking_link_campaign_changed&#039;, array(&#039;type&#039; =&gt; $tracker_type, &#039;id&#039; =&gt; $tracker_row[&#039;tracker_id&#039;], &#039;old_campaign&#039; =&gt; $get_tracker_row[&#039;aff_campaign_name&#039;], &#039;new_campaign&#039; =&gt; $row[&#039;aff_campaign_name&#039;], &#039;user&#039; =&gt; $user_row[&#039;username&#039;]));
				}

				if ($_POST[&#039;method_of_promotion&#039;] == &#039;directlink&#039;) {
					if ($get_tracker_row[&#039;landing_page_id&#039;]) {
						$slack-&gt;push(&#039;tracking_link_method_of_promotion_changed&#039;, array(&#039;type&#039; =&gt; $tracker_type, &#039;id&#039; =&gt; $tracker_row[&#039;tracker_id&#039;], &#039;old_method&#039; =&gt; &#039;Landing Page&#039;, &#039;new_method&#039; =&gt; &#039;Direct Link&#039;, &#039;user&#039; =&gt; $user_row[&#039;username&#039;]));
					}
				}

				if ($_POST[&#039;method_of_promotion&#039;] == &#039;landingpage&#039;) {
					if ($get_tracker_row[&#039;landing_page_id&#039;] == 0) {
						$slack-&gt;push(&#039;tracking_link_method_of_promotion_changed&#039;, array(&#039;type&#039; =&gt; $tracker_type, &#039;id&#039; =&gt; $tracker_row[&#039;tracker_id&#039;], &#039;old_method&#039; =&gt; &#039;Direct Link&#039;, &#039;new_method&#039; =&gt; &#039;Landing Page&#039;, &#039;user&#039; =&gt; $user_row[&#039;username&#039;]));
					}
				}
			}

			if ($_POST[&#039;method_of_promotion&#039;] == &#039;landingpage&#039; || $_POST[&#039;tracker_type&#039;] == &#039;1&#039;) {
				if (($get_tracker_row[&#039;landing_page_id&#039;]) &amp;&amp; $_POST[&#039;landing_page_id&#039;] != $get_tracker_row[&#039;landing_page_id&#039;]) {
					
					$mysql[&#039;landing_page_id&#039;] = $db-&gt;real_escape_string($_POST[&#039;landing_page_id&#039;]);
					$sql = &quot;SELECT landing_page_nickname FROM 202_landing_pages WHERE landing_page_id = &#039;&quot;.$mysql[&#039;landing_page_id&#039;].&quot;&#039;&quot;;
					$result = $db-&gt;query($sql);
					$row = $result-&gt;fetch_assoc();

					$slack-&gt;push(&#039;tracking_link_landing_page_changed&#039;, array(&#039;type&#039; =&gt; $tracker_type, &#039;id&#039; =&gt; $tracker_row[&#039;tracker_id&#039;], &#039;old_lp&#039; =&gt; $get_tracker_row[&#039;landing_page_nickname&#039;], &#039;new_lp&#039; =&gt; $row[&#039;landing_page_nickname&#039;], &#039;user&#039; =&gt; $user_row[&#039;username&#039;]));
				}
			}

			if ($_POST[&#039;tracker_type&#039;] == &#039;0&#039; || $_POST[&#039;tracker_type&#039;] == &#039;1&#039;) {

				if (isset($_POST[&#039;text_ad_id&#039;]) &amp;&amp; $get_tracker_row[&#039;text_ad_id&#039;]) {
					$mysql[&#039;text_ad_id&#039;] = $db-&gt;real_escape_string($_POST[&#039;text_ad_id&#039;]);
					$sql = &quot;SELECT text_ad_name FROM 202_text_ads WHERE text_ad_id = &#039;&quot;.$mysql[&#039;text_ad_id&#039;].&quot;&#039;&quot;;
					$result = $db-&gt;query($sql);
					$row = $result-&gt;fetch_assoc();

					$slack-&gt;push(&#039;tracking_link_text_ad_changed&#039;, array(&#039;type&#039; =&gt; $tracker_type, &#039;id&#039; =&gt; $tracker_row[&#039;tracker_id&#039;], &#039;old_ad&#039; =&gt; $get_tracker_row[&#039;text_ad_name&#039;], &#039;new_ad&#039; =&gt; $row[&#039;text_ad_name&#039;], &#039;user&#039; =&gt; $user_row[&#039;username&#039;]));
				}

				if (isset($_POST[&#039;text_ad_id&#039;]) &amp;&amp; !$get_tracker_row[&#039;text_ad_id&#039;]) {
					$mysql[&#039;text_ad_id&#039;] = $db-&gt;real_escape_string($_POST[&#039;text_ad_id&#039;]);
					$sql = &quot;SELECT text_ad_name FROM 202_text_ads WHERE text_ad_id = &#039;&quot;.$mysql[&#039;text_ad_id&#039;].&quot;&#039;&quot;;
					$result = $db-&gt;query($sql);
					$row = $result-&gt;fetch_assoc();

					$slack-&gt;push(&#039;tracking_link_text_ad_added&#039;, array(&#039;type&#039; =&gt; $tracker_type, &#039;id&#039; =&gt; $tracker_row[&#039;tracker_id&#039;], &#039;ad&#039; =&gt; $row[&#039;text_ad_name&#039;], &#039;user&#039; =&gt; $user_row[&#039;username&#039;]));
				}

				if (!$_POST[&#039;text_ad_id&#039;] &amp;&amp; $get_tracker_row[&#039;text_ad_id&#039;]) {
					
					$slack-&gt;push(&#039;tracking_link_text_ad_removed&#039;, array(&#039;type&#039; =&gt; $tracker_type, &#039;id&#039; =&gt; $tracker_row[&#039;tracker_id&#039;], &#039;ad&#039; =&gt; $get_tracker_row[&#039;text_ad_name&#039;], &#039;user&#039; =&gt; $user_row[&#039;username&#039;]));

				}

				if ($_POST[&#039;click_cloaking&#039;] != $get_tracker_row[&#039;click_cloaking&#039;]) {
					if ($get_tracker_row[&#039;click_cloaking&#039;] == &#039;-1&#039;) {
						$from_type = &#039;Campaign Default On/Off&#039;;
					} else if ($get_tracker_row[&#039;click_cloaking&#039;] == &#039;0&#039;) {
						$from_type = &#039;Off - Overide Campaign Default&#039;;
					} else {
						$from_type = &#039;On - Overide Campaign Default&#039;;
					}

					if ($_POST[&#039;click_cloaking&#039;] == &#039;-1&#039;) {
						$to_type = &#039;Campaign Default On/Off&#039;;
					} else if ($_POST[&#039;click_cloaking&#039;] == &#039;0&#039;) {
						$to_type = &#039;Off - Overide Campaign Default&#039;;
					} else {
						$to_type = &#039;On - Overide Campaign Default&#039;;
					}

					$slack-&gt;push(&#039;tracking_link_cloaking_changed&#039;, array(&#039;type&#039; =&gt; $tracker_type, &#039;id&#039; =&gt; $tracker_row[&#039;tracker_id&#039;], &#039;old_type&#039; =&gt; $from_type, &#039;new_type&#039; =&gt; $to_type, &#039;user&#039; =&gt; $user_row[&#039;username&#039;]));
				}
			}

			if ($_POST[&#039;ppc_account_id&#039;] != $get_tracker_row[&#039;ppc_account_id&#039;]) {
				$mysql[&#039;ppc_account_id&#039;] = $db-&gt;real_escape_string($_POST[&#039;ppc_account_id&#039;]);
				$sql = &quot;SELECT ppc_account_name, ppc_network_name FROM 202_ppc_accounts LEFT JOIN 202_ppc_networks USING (ppc_network_id) WHERE ppc_account_id = &#039;&quot;.$mysql[&#039;ppc_account_id&#039;].&quot;&#039;&quot;;
				$result = $db-&gt;query($sql);
				$row = $result-&gt;fetch_assoc();

				$slack-&gt;push(&#039;tracking_link_pcc_network_changed&#039;, array(&#039;type&#039; =&gt; $tracker_type, &#039;id&#039; =&gt; $tracker_row[&#039;tracker_id&#039;], &#039;old_source&#039; =&gt; $get_tracker_row[&#039;ppc_network_name&#039;], &#039;new_source&#039; =&gt; $row[&#039;ppc_network_name&#039;], &#039;user&#039; =&gt; $user_row[&#039;username&#039;]));
				$slack-&gt;push(&#039;tracking_link_ppc_account_changed&#039;, array(&#039;type&#039; =&gt; $tracker_type, &#039;id&#039; =&gt; $tracker_row[&#039;tracker_id&#039;], &#039;old_account&#039; =&gt; $get_tracker_row[&#039;ppc_account_name&#039;], &#039;new_account&#039; =&gt; $row[&#039;ppc_account_name&#039;], &#039;user&#039; =&gt; $user_row[&#039;username&#039;]));
			}

			if ($_POST[&#039;cost_type&#039;] == &#039;cpc&#039;) {
				if ($get_tracker_row[&#039;click_cpc&#039;] == null) {
					$slack-&gt;push(&#039;tracking_link_cost_type_changed&#039;, array(&#039;type&#039; =&gt; $tracker_type, &#039;id&#039; =&gt; $tracker_row[&#039;tracker_id&#039;], &#039;old_type&#039; =&gt; &#039;CPA&#039;, &#039;new_type&#039; =&gt; &#039;CPC&#039;, &#039;user&#039; =&gt; $user_row[&#039;username&#039;]));
				} else {
					if ($click_cpc != $get_tracker_row[&#039;click_cpc&#039;]) {
						$slack-&gt;push(&#039;tracking_link_cost_value_changed&#039;, array(&#039;type&#039; =&gt; $tracker_type, &#039;id&#039; =&gt; $tracker_row[&#039;tracker_id&#039;], &#039;old_value&#039; =&gt; $get_tracker_row[&#039;click_cpc&#039;], &#039;new_value&#039; =&gt; $click_cpc, &#039;user&#039; =&gt; $user_row[&#039;username&#039;]));
					}
				}

			} else if ($_POST[&#039;cost_type&#039;] == &#039;cpa&#039;) {
				if ($get_tracker_row[&#039;click_cpa&#039;] == null) {
					$slack-&gt;push(&#039;tracking_link_cost_type_changed&#039;, array(&#039;type&#039; =&gt; $tracker_type, &#039;id&#039; =&gt; $tracker_row[&#039;tracker_id&#039;], &#039;old_type&#039; =&gt; &#039;CPC&#039;, &#039;new_type&#039; =&gt; &#039;CPA&#039;, &#039;user&#039; =&gt; $user_row[&#039;username&#039;]));
				} else if ($click_cpa != $get_tracker_row[&#039;click_cpa&#039;]) {
					$slack-&gt;push(&#039;tracking_link_cost_value_changed&#039;, array(&#039;type&#039; =&gt; $tracker_type, &#039;id&#039; =&gt; $tracker_row[&#039;tracker_id&#039;], &#039;old_value&#039; =&gt; $get_tracker_row[&#039;click_cpa&#039;], &#039;new_value&#039; =&gt; $click_cpa, &#039;user&#039; =&gt; $user_row[&#039;username&#039;]));
				}
			}

			if ($_POST[&#039;tracker_type&#039;] == &#039;2&#039;) {
				if ($_POST[&#039;tracker_rotator&#039;] != $get_tracker_row[&#039;rotator_id&#039;]) {
					$mysql[&#039;rotator_id&#039;] = $db-&gt;real_escape_string($_POST[&#039;tracker_rotator&#039;]);
					$sql = &quot;SELECT name FROM 202_rotators WHERE id = &#039;&quot;.$mysql[&#039;rotator_id&#039;].&quot;&#039;&quot;;
					$result = $db-&gt;query($sql);
					$row = $result-&gt;fetch_assoc();

					$slack-&gt;push(&#039;tracking_link_rotator_changed&#039;, array(&#039;type&#039; =&gt; $tracker_type, &#039;id&#039; =&gt; $tracker_row[&#039;tracker_id&#039;], &#039;old_rotator&#039; =&gt; $get_tracker_row[&#039;name&#039;], &#039;new_rotator&#039; =&gt; $row[&#039;name&#039;], &#039;user&#039; =&gt; $user_row[&#039;username&#039;]));
				}
			}
		}
	}
	

	?&gt;&lt;?php if($_POST[&#039;edit_tracker&#039;] &amp;&amp; $_POST[&#039;tracker_id&#039;]) { ?&gt;&lt;small
	class=&quot;success&quot;&gt;&lt;em&gt;&lt;u&gt;Tracker updated! Your tracking link stays the
			same.&lt;/u&gt;&lt;/em&gt;&lt;/small&gt;&lt;?php } ?&gt;
&lt;br&gt;
&lt;small&gt;&lt;em&gt;&lt;u&gt;Make sure you test out all the links to make sure they
			work yourself before running them live.&lt;/u&gt;&lt;/em&gt;&lt;/small&gt;&lt;?php 	
	
	if ($_POST[&#039;method_of_promotion&#039;] == &#039;directlink&#039; &amp;&amp; $_POST[&#039;tracker_type&#039;] == 0) { 

		$destination_url = $protocol . getTrackingDomain() . get_absolute_url().&#039;tracking202/redirect/dl.php?t202id=&#039; . $tracker_id_public . $tracker_publisher_id . $tracking_variable_string;
		$html[&#039;destination_url&#039;] = htmlentities($destination_url, ENT_QUOTES, &#039;UTF-8&#039;);
		printf(&#039;&lt;br&gt;&lt;/br&gt;&lt;small&gt;&lt;strong&gt;Destination URL:&lt;/strong&gt;&lt;/small&gt;&lt;br/&gt;
			&lt;span class=&quot;infotext&quot;&gt;This is the destination URL you should use in your campaigns. &lt;br&gt;&lt;/br&gt;
			In order to track keywords, make sure immediately following &amp;t202kw= you insert your dynamic keyword token.
            For example: &amp;t202kw={keyword}&lt;/span&gt;&lt;br&gt;&lt;/br&gt;
            &lt;textarea class=&quot;form-control&quot; rows=&quot;2&quot; style=&quot;background-color: #f5f5f5; font-size: 12px;&quot;&gt;%s&lt;/textarea&gt;&#039;,$html[&#039;destination_url&#039;]); 

	} 

	if ($_POST[&#039;tracker_type&#039;] == 2) { 
		
		$destination_url = $protocol . getTrackingDomain() . get_absolute_url().&#039;tracking202/redirect/rtr.php?t202id=&#039; . $tracker_id_public . $tracker_publisher_id . $tracking_variable_string;
		$html[&#039;destination_url&#039;] = htmlentities($destination_url, ENT_QUOTES, &#039;UTF-8&#039;);
		printf(&#039;&lt;br&gt;&lt;/br&gt;&lt;small&gt;&lt;strong&gt;Destination URL:&lt;/strong&gt;&lt;/small&gt;&lt;br/&gt;
			&lt;span class=&quot;infotext&quot;&gt;This is the destination URL you should use in your campaigns. &lt;br&gt;&lt;/br&gt;
			In order to track keywords, make sure immediately following &amp;t202kw= you insert your dynamic keyword token.
			For example: &amp;t202kw={keyword}&lt;/span&gt;&lt;br&gt;&lt;/br&gt;
            &lt;textarea class=&quot;form-control&quot; rows=&quot;2&quot; style=&quot;background-color: #f5f5f5; font-size: 12px;&quot;&gt;%s&lt;/textarea&gt;&#039;,$html[&#039;destination_url&#039;]); 

	} 
	
	if (($_POST[&#039;method_of_promotion&#039;] == &#039;landingpage&#039;) or ($_POST[&#039;tracker_type&#039;] == 1)) {

		$destination_url = $parsed_url[&#039;scheme&#039;] . &#039;://&#039; . $parsed_url[&#039;host&#039;] . $parsed_url[&#039;path&#039;] . &#039;?&#039;;
		$clean_destination_url = $parsed_url[&#039;scheme&#039;] . &#039;://&#039; . $parsed_url[&#039;host&#039;] . $parsed_url[&#039;path&#039;];
		
		if (!empty($parsed_url[&#039;query&#039;])) {
			$destination_url .= $parsed_url[&#039;query&#039;] . &#039;&amp;&#039;;  ;
		}
		$destination_url .= &#039;t202id=&#039; . $tracker_id_public;
		if (!empty($parsed_url[&#039;fragment&#039;])) {
			$destination_url .= &#039;#&#039; . $parsed_url[&#039;fragment&#039;];
		}
		$destination_url .= $tracker_publisher_id;  //join publisher id if it exists
		$destination_url .= $tracking_variable_string;

		$parallel_tracking_url = $protocol . getTrackingDomain() . get_absolute_url().&#039;tracking202/redirect/pt.php?t202id=&#039; . $tracker_id_public . $tracker_publisher_id . $tracking_variable_string;
		
		 
		$html[&#039;destination_url&#039;] = htmlentities($destination_url, ENT_QUOTES, &#039;UTF-8&#039;);
		$html[&#039;clean_destination_url&#039;] = htmlentities($clean_destination_url, ENT_QUOTES, &#039;UTF-8&#039;);
		$html[&#039;parallel_tracking_url&#039;] = htmlentities($parallel_tracking_url, ENT_QUOTES, &#039;UTF-8&#039;);

		printf(&#039;&lt;br&gt;&lt;/br&gt;&lt;small&gt;&lt;strong&gt;Destination URL:&lt;/strong&gt;&lt;/small&gt;&lt;br/&gt;
				&lt;span class=&quot;infotext&quot;&gt;This is the destination URL you should use in your campaigns. &lt;br&gt;
				In order to track keywords, make sure immediately following &amp;t202kw= you insert your dynamic keyword token.
				For example: &amp;t202kw={keyword}&lt;/span&gt;&lt;br&gt;&lt;/br&gt;
				&lt;textarea class=&quot;form-control&quot; rows=&quot;2&quot; style=&quot;background-color: #f5f5f5; font-size: 12px;&quot;&gt;%s&lt;/textarea&gt;&lt;br&gt;
				&lt;small&gt;&lt;strong&gt;Google Ads Clean Destination URL: (Only use this when you don\&#039;t want to show any tracking variables in your Google Ads url. All the url data will be tracked with the Parallel Tracking URL below.&lt;/strong&gt;&lt;/small&gt;&lt;br&gt;
				&lt;textarea class=&quot;form-control&quot; rows=&quot;2&quot; style=&quot;background-color: #f5f5f5; font-size: 12px;&quot;&gt;%s&lt;/textarea&gt;&lt;br&gt;
				&#039;, $html[&#039;destination_url&#039;],$html[&#039;clean_destination_url&#039;]);
				
				printf(&#039;&lt;small&gt;&lt;strong&gt;[Optional] Google Ads Parallel Tracking URL:&lt;/strong&gt;&lt;/small&gt;&lt;br/&gt;
				&lt;span class=&quot;infotext&quot;&gt;This is the Parallel Tracking URL you should use in your campaigns for Google Ads. &lt;br&gt;
				In order to track keywords, make sure immediately following &amp;t202kw= you insert your dynamic keyword token.
				For example: &amp;t202kw={keyword}&lt;/span&gt;&lt;br&gt;&lt;/br&gt;
	            &lt;textarea class=&quot;form-control&quot; rows=&quot;2&quot; style=&quot;background-color: #f5f5f5; font-size: 12px;&quot;&gt;%s&lt;/textarea&gt;&#039;, $html[&#039;parallel_tracking_url&#039;]);				
	}   

	/*
	if ($_POST[&#039;tracker_type&#039;] != 2) {
		$destination_url = &#039;http://&#039; . getTrackingDomain() . get_absolute_url().&#039;tracking202/static/ipx.php?t202id=&#039; . $tracker_id_public;
		$html[&#039;destination_url&#039;] = htmlentities($destination_url, ENT_QUOTES, &#039;UTF-8&#039;);
		printf(&#039;&lt;br/&gt;&lt;small&gt;&lt;strong&gt;Impression URL:&lt;/strong&gt;&lt;/small&gt;&lt;br&gt;&lt;/br&gt;
	            &lt;textarea class=&quot;form-control&quot; rows=&quot;2&quot; style=&quot;background-color: #f5f5f5; font-size: 12px;&quot;&gt;%s&lt;/textarea&gt;&#039;, $html[&#039;destination_url&#039;]);

		printf(&#039;&lt;br/&gt;&lt;small&gt;&lt;strong&gt;Impression Pixel&lt;/strong&gt;&lt;/small&gt;&lt;br&gt;&lt;/br&gt;
	            &lt;textarea class=&quot;form-control&quot; rows=&quot;2&quot; style=&quot;background-color: #f5f5f5; font-size: 12px;&quot;&gt;&lt;img height=&quot;1&quot; width=&quot;1&quot; border=&quot;0&quot; style=&quot;display: none;&quot; src=&quot;%s&quot; /&gt;&lt;/textarea&gt;&#039;, $html[&#039;destination_url&#039;]);
	}

	*/

	?&gt;


&lt;br /&gt;
&lt;small&gt;&lt;strong&gt;Final Thoughts&lt;/strong&gt;&lt;/small&gt;
&lt;br /&gt;
&lt;span class=&quot;infotext&quot;&gt;If you are confused about how to dynamically
	insert keywords into your url, here are some examples below:&lt;br /&gt; &lt;br /&gt;
&lt;ul&gt;
		&lt;li&gt;&lt;strong&gt;Google Ads Example:&lt;/strong&gt; &amp;t202kw={keyword}&lt;/li&gt;
		&lt;li&gt;&lt;strong&gt;Bing Ads Example:&lt;/strong&gt; &amp;t202kw={QueryString}&lt;/li&gt;
	&lt;/ul&gt; 
&lt;/span&gt;
</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2Fpublic_html%2Ftracking%2Ftracking202%2Fajax'>⬅ Back to Directory</a>