<h2>File Contents: /home/planet5/.trash/tracking202/update/copy_of_subids.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/.trash/tracking202/update/copy_of_subids.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php 
set_time_limit(0);
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;);
include_once(str_repeat(&quot;../&quot;, 2).&#039;202-config/convlogs.php&#039;);

AUTH::require_user();

$utc = new DateTimeZone(&#039;UTC&#039;);
$dt = new DateTime(&#039;now&#039;, $utc);

if (!$userObj-&gt;hasPermission(&quot;access_to_update_section&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;]);
	$mysql[&#039;click_update_type&#039;] = &#039;upload&#039;;
	$mysql[&#039;click_update_time&#039;] = time();
		
    $subids = $_POST[&#039;subids&#039;]; 
	$subids = trim($subids); 
	$subids = explode(&quot;\r&quot;,$subids);
	$subids = str_replace(&quot;\n&quot;,&#039;&#039;,$subids);
	$de = new DataEngine();
	foreach($subids as $subid) {
		$data = explode(&#039;,&#039;, $subid);

		//subid,payout,txid,timestamp

		$mysql[&#039;click_id&#039;] = $db-&gt;real_escape_string($data[0]);
	
		$click_sql = &quot;
			SELECT 
				2c.click_id,
				2c.aff_campaign_id,
				2c.click_payout,
				2c.click_time,
				202_aff_campaigns.aff_campaign_payout,
				202_trackers.click_cpa,
				202_cpa_trackers.tracker_id_public,
				2c.click_lead
			FROM
				202_clicks AS 2c
				LEFT JOIN 202_cpa_trackers USING (click_id) 
				LEFT JOIN 202_trackers USING (tracker_id_public)
				LEFT JOIN 202_aff_campaigns ON (202_aff_campaigns.aff_campaign_id =  2c.aff_campaign_id) 	
			WHERE
				2c.click_id =&#039;&quot;. $mysql[&#039;click_id&#039;].&quot;&#039;
			 
		&quot;;
		//die($click_sql);
		$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;]);
		$mysql[&#039;aff_campaign_id&#039;] = $db-&gt;real_escape_string($click_row[&#039;aff_campaign_id&#039;]);
		$mysql[&#039;click_payout&#039;] = $db-&gt;real_escape_string($click_row[&#039;click_payout&#039;]);
		$mysql[&#039;click_time&#039;] = $db-&gt;real_escape_string($click_row[&#039;click_time&#039;]);
		$mysql[&#039;click_cpa&#039;] = $db-&gt;real_escape_string($click_row[&#039;click_cpa&#039;]);

		if(is_numeric($mysql[&#039;click_id&#039;])) {
			$mysql[&#039;original_click_payout&#039;] = $click_row[&#039;click_payout&#039;];

			$mysql[&#039;txid&#039;] = &#039;&#039;;
			$mysql[&#039;conv_time&#039;] = null;

			if (isset($data[1]) &amp;&amp; !empty($data[1])) {
				$mysql[&#039;click_payout&#039;] = $db-&gt;real_escape_string($data[1]);
				$mysql[&#039;click_payout_added&#039;] = $mysql[&#039;click_payout&#039;];
			} else if (!empty($_POST[&#039;subid_payout&#039;])) {
				$mysql[&#039;click_payout&#039;] = $db-&gt;real_escape_string($_POST[&#039;subid_payout&#039;]);
				$mysql[&#039;click_payout_added&#039;] = $mysql[&#039;click_payout&#039;];
			}  else {
				$mysql[&#039;click_payout_added&#039;] = $click_row[&#039;aff_campaign_payout&#039;];
				$mysql[&#039;click_payout&#039;] = $click_row[&#039;click_payout&#039;];
			}

			if (isset($data[2]) &amp;&amp; !empty($data[2])) {
				$mysql[&#039;txid&#039;] = $db-&gt;real_escape_string($data[2]);
				if ($click_row[&#039;click_lead&#039;]) {
					$mysql[&#039;click_payout&#039;] = $mysql[&#039;original_click_payout&#039;] + $mysql[&#039;click_payout_added&#039;];
				} else {
					$mysql[&#039;click_payout&#039;] = $mysql[&#039;click_payout_added&#039;];
				}
			}

			if (isset($data[3]) &amp;&amp; !empty($data[3])) {
				$conv_time = strtotime($data[3]);
				$mysql[&#039;conv_time&#039;] = $db-&gt;real_escape_string($conv_time);
			} else {
				$mysql[&#039;conv_time&#039;] = time();
			}

			if (!empty($_POST[&#039;subid_timezone&#039;])) {
				$conv_date = new DateTime();
				$conv_date-&gt;setTimezone(new DateTimeZone($_POST[&#039;subid_timezone&#039;]));
				$conv_date-&gt;setTimestamp($mysql[&#039;conv_time&#039;]); 
				$mysql[&#039;conv_time&#039;] = strtotime($conv_date-&gt;format(&#039;Y-m-d H:i:s&#039;));
			}

			$sql = &quot;SELECT * FROM 202_conversion_logs 
				WHERE click_id = &#039;&quot;.$mysql[&#039;click_id&#039;].&quot;&#039; 
				AND transaction_id = &#039;&quot;.$mysql[&#039;txid&#039;].&quot;&#039;&quot;;
			$result = $db-&gt;query($sql);

			if ($result-&gt;num_rows == 0) {
				addConversionLog($mysql[&#039;click_id&#039;], $mysql[&#039;txid&#039;], $mysql[&#039;aff_campaign_id&#039;], $mysql[&#039;click_payout_added&#039;], $mysql[&#039;user_id&#039;], $mysql[&#039;click_time&#039;], $_SERVER[&#039;HTTP_X_FORWARDED_FOR&#039;], $_SERVER[&#039;HTTP_USER_AGENT&#039;], $mysql[&#039;conv_time&#039;], 0);
				
				$mysql[&#039;click_lead&#039;] = $click_row[&#039;click_lead&#039;] + 1;

				if ($mysql[&#039;click_cpa&#039;]) {
					$sql_set = &quot;click_cpc=&#039;&quot;.$mysql[&#039;click_cpa&#039;].&quot;&#039;, click_lead=&#039;&quot;.$mysql[&#039;click_lead&#039;].&quot;&#039;, click_filtered=&#039;0&#039;, click_payout=&#039;&quot;.$mysql[&#039;click_payout&#039;].&quot;&#039;&quot;;
				} else {
					$sql_set = &quot;click_lead=&#039;&quot;.$mysql[&#039;click_lead&#039;].&quot;&#039;, click_filtered=&#039;0&#039;, click_payout=&#039;&quot;.$mysql[&#039;click_payout&#039;].&quot;&#039;&quot;;
				}

				$update_sql = &quot;
					UPDATE
						202_clicks
					SET
						&quot;.$sql_set.&quot;
					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));
				
			} else {
				$row = $result-&gt;fetch_assoc();
				$mysql[&#039;adjusted_payout&#039;] = $mysql[&#039;original_click_payout&#039;] - $click_row[&#039;click_payout&#039;] + $mysql[&#039;click_payout_added&#039;];

				$db-&gt;query(&quot;UPDATE 202_clicks SET click_payout=&#039;&quot;.$mysql[&#039;adjusted_payout&#039;].&quot;&#039; WHERE click_id = &#039;&quot;.$mysql[&#039;click_id&#039;].&quot;&#039;&quot;);

				$click_sql = &quot;
					UPDATE
						202_conversion_logs
					SET
						click_payout = &#039;&quot;.$mysql[&#039;click_payout_added&#039;].&quot;&#039;
					WHERE
						click_id=&#039;&quot;.$mysql[&#039;click_id&#039;].&quot;&#039; AND transaction_id = &#039;&quot;.$mysql[&#039;txid&#039;].&quot;&#039;&quot;;
				$db-&gt;query($click_sql);
			}	
			
			$de-&gt;setDirtyHour($mysql[&#039;click_id&#039;]);
		}
	} 
	
    	$success = true;
	
}

//show the template
template_top(&#039;Update Subids&#039;); ?&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;Update Your 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 uploaded.
						&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;Here is where you can update your income for Prosper202, by importing your subids from your affiliate marketing reports.&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;SUBID, PAYOUT (optional), TRANSACTION ID (optional), TIMESTAMP (m/d/y h:m:s PM/AM optional)&amp;#13;&amp;#10;SUBID, PAYOUT (optional), TRANSACTION ID (optional), TIMESTAMP (m/d/y h:m:s PM/AM optional)&amp;#13;&amp;#10;...&quot; class=&quot;form-control&quot;&gt;&lt;/textarea&gt;			  
			&lt;/div&gt;
			&lt;div class=&quot;col-xs-3&quot;&gt;
				&lt;div class=&quot;form-group&quot; style=&quot;margin-right: 0px;&quot;&gt;
			    	&lt;label for=&quot;subid_payout&quot;&gt;Payout&lt;/label&gt;
			    	&lt;input type=&quot;text&quot; class=&quot;form-control input-sm&quot; id=&quot;subid_payout&quot; name=&quot;subid_payout&quot; placeholder=&quot;optional&quot;&gt;
				&lt;/div&gt;
			&lt;/div&gt;
			&lt;div class=&quot;col-xs-3&quot;&gt;
				&lt;div class=&quot;form-group&quot; id=&quot;subid_timezone_select&quot;&gt;
    				&lt;label for=&quot;subid_timezone&quot;&gt;Timezone&lt;/label&gt;
    				&lt;select class=&quot;form-control&quot; id=&quot;subid_timezone&quot; name=&quot;subid_timezone&quot;&gt;
					  &lt;option value=&quot;&quot;&gt;optional&lt;/option&gt;
					  &lt;?php
						  foreach(DateTimeZone::listIdentifiers() as $tz) {
							    $current_tz = new DateTimeZone($tz);
							    $offset =  $current_tz-&gt;getOffset($dt);
							    $transition =  $current_tz-&gt;getTransitions($dt-&gt;getTimestamp(), $dt-&gt;getTimestamp());
							    $abbr = $transition[0][&#039;abbr&#039;];
							    echo &#039;&lt;option value=&quot;&#039; .$tz. &#039;&quot;&gt;&#039; .$tz. &#039; [&#039; .$abbr. &#039; &#039;. formatOffset($offset). &#039;]&lt;/option&gt;&#039;;
							}
						?&gt;
					&lt;/select&gt;
  				&lt;/div&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;?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>