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

AUTH::require_user();

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

if ($_SERVER[&#039;REQUEST_METHOD&#039;] == &#039;POST&#039;) {
    
	$mysql[&#039;user_id&#039;] = $db-&gt;real_escape_string($_SESSION[&#039;user_id&#039;]);
	
    $subids = $_POST[&#039;subids&#039;]; 
	$subids = trim($subids); 
	$subids = explode(&quot;\r&quot;,$subids);
	$subids = str_replace(&quot;\n&quot;,&#039;&#039;,$subids);
	
	foreach( $subids as $key =&gt; $click_id ) {
		$mysql[&#039;click_id&#039;] = $db-&gt;real_escape_string($click_id);

		$click_sql = &quot;
			SELECT 2c.click_id 
			FROM
				202_clicks AS 2c
			WHERE
				2c.click_id =&#039;&quot;. $mysql[&#039;click_id&#039;].&quot;&#039;
				AND 2c.user_id=&#039;&quot;.$mysql[&#039;user_id&#039;].&quot;&#039;  
		&quot;;
		$click_result = $db-&gt;query($click_sql) or record_mysql_error($click_sql);
		$click_row = $click_result-&gt;fetch_assoc();
		$mysql[&#039;click_id&#039;] = $db-&gt;real_escape_string($click_row[&#039;click_id&#039;]);
		
		$update_sql = &quot;
			UPDATE 202_clicks
			SET
				click_lead=&#039;0&#039;,
				`click_filtered`=&#039;0&#039;
			WHERE
				click_id=&#039;&quot; . $mysql[&#039;click_id&#039;] .&quot;&#039;
				AND user_id=&#039;&quot;.$mysql[&#039;user_id&#039;].&quot;&#039;
		&quot;;
		$update_result = $db-&gt;query($update_sql) or die(mysql_error($update_sql));
		
		$click_sql = &quot;
				UPDATE 202_conversion_logs
				SET deleted=1
				WHERE click_id=&#039;&quot; . $mysql[&#039;click_id&#039;] .&quot;&#039;&quot;;
		$click_result = $db-&gt;query($click_sql);

		$de = new DataEngine();
		$de-&gt;setDirtyHour($mysql[&#039;click_id&#039;]);
	} 
	
    $success = true;
	
}

//show the template
template_top(&#039;Delete Subids&#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-4&quot;&gt;
				&lt;h6&gt;Delete Individual Subids &lt;?php showHelp(&quot;update&quot;); ?&gt;&lt;/h6&gt;
			&lt;/div&gt;
			&lt;div class=&quot;col-xs-8&quot;&gt;
				&lt;div class=&quot;success pull-right&quot; style=&quot;margin-top: 20px;&quot;&gt;
					&lt;small&gt;
						&lt;?php if ($success == true) { ?&gt;
							&lt;span class=&quot;fui-check-inverted&quot;&gt;&lt;/span&gt; Your submission was successful. Your account income now reflects the subids just deleted.
						&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;Ok, just like the upload subids but in reverse, upload the subids you want to delete instead!&lt;/small&gt;
	&lt;/div&gt;
&lt;/div&gt;

&lt;div class=&quot;row form_seperator&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-12&quot;&gt;
		&lt;form method=&quot;post&quot; action=&quot;&quot; class=&quot;form-horizontal&quot; role=&quot;form&quot;&gt;
			&lt;div class=&quot;form-group&quot; style=&quot;margin:0px 0px 15px 0px;&quot;&gt;
			    &lt;label for=&quot;subids&quot;&gt;Subids&lt;/label&gt;
				&lt;textarea rows=&quot;5&quot; name=&quot;subids&quot; id=&quot;subids&quot; placeholder=&quot;Add your subids...&quot; class=&quot;form-control&quot;&gt;&lt;?php echo $_POST[&#039;subids&#039;]; ?&gt;&lt;/textarea&gt;			  
			&lt;/div&gt;
			&lt;button class=&quot;btn btn-sm btn-p202 btn-block&quot; type=&quot;submit&quot;&gt;Update Subids&lt;/button&gt;
		&lt;/form&gt;
	&lt;/div&gt;
&lt;/div&gt;
&lt;script src=&quot;/202-js/flatui-fileinput.js&quot;&gt;&lt;/script&gt;
&lt;?php template_bottom();</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2F.trash%2Ftracking202%2Fupdate'>⬅ Back to Directory</a>