Jump to content

Reading a File and using the Header Function

inVINCEable

By inVINCEable
in PHP Coding Help

 Share

Recommended Posts

inVINCEable Member

inVINCEable

Posted
Posted

Ok, so below is my code, everything seemed to work fine until at the VERY bottom of the code I added this:

 

$file = fopen("text.txt", "r"); 

$ec = fgets($file); 

$email_collect = $ec;

 

Right above the header() functions I was using. Now I thought fopen does not send any info to the browser? Is there a way around this? Below is my code, when I remove what I just posted above everything works just fine and the header() functions work as they are supposed to, it is just when I literally added these three lines everything went to hell.

 

Thanks for any suggestions!

 

<? 
ob_start();  
#only allow numeric t202ids

if(isset($_POST['lpip'])){ 
$lpip = $_POST['lpip']; 
} 
elseif(isset($_GET['lpip'])){ 
$lpip = $_GET['lpip']; 
} 

if(isset($_POST['email'])){ 
$email_collect = "&email=".$_POST['email']; 
}
else 
{ 
$email_collect = null; 
} 

if(isset($_POST['pwk'])){ 
$pwk = $_POST['pwk'];
} 
else 
{ 
$pwk = $_POST['pwk'] = null; 
} 






if (!is_numeric($lpip)) die();


#cached redirects stored here:
$myFile = "cached/lp-cached.csv";


# check to see if mysql connection works, if not fail over to cached .CSV stored redirect urls
include_once($_SERVER['DOCUMENT_ROOT'] . '/202-config.php'); 

$dbconnect = @mysql_connect($dbhost,$dbuser,$dbpass); 
if (!$dbconnect) $usedCachedRedirect = true; 

if (!$usedCachedRedirect) $dbselect = @mysql_select_db($dbname);
if (!$dbselect) $usedCachedRedirect = true; 

#the mysql server is down, use the txt cached redirect
if ($usedCachedRedirect) { 

$handle = @fopen($myFile, 'r');
while ($row = @fgetcsv($handle, 100000, ",")) {

	//if a cached key is found for this t202id, redirect to that url
	if ($row[0] == $lpip) { 
		header('location: '. $row[1]); 
		die();
	}
}
@fclose($handle);

die("<h2>Error establishing a database connection - please contact the webhost</h2>");
}


include_once($_SERVER['DOCUMENT_ROOT'] . '/202-config/connect.php'); 

$mysql['landing_page_id_public'] = mysql_real_escape_string($lpip);
$tracker_sql = "SELECT 202_landing_pages.user_id,
					202_landing_pages.landing_page_id,
					202_landing_pages.landing_page_id_public,
					202_landing_pages.aff_campaign_id,
					202_aff_campaigns.aff_campaign_rotate,
					202_aff_campaigns.aff_campaign_url,
					202_aff_campaigns.aff_campaign_url_2,
					202_aff_campaigns.aff_campaign_url_3,
					202_aff_campaigns.aff_campaign_url_4,
					202_aff_campaigns.aff_campaign_url_5,
					202_aff_campaigns.aff_campaign_payout,
					202_aff_campaigns.aff_campaign_cloaking
			FROM    202_landing_pages, 202_aff_campaigns
			WHERE   202_landing_pages.landing_page_id_public='".$mysql['landing_page_id_public']."'
			AND     202_aff_campaigns.aff_campaign_id = 202_landing_pages.aff_campaign_id";
$tracker_row = memcache_mysql_fetch_assoc($tracker_sql);
										   
if (!$tracker_row) { die(); }



if ( is_writable(dirname(__FILE__) . '/cached' )) {

#if the file does not exist create it
if (!file_exists($myFile)) { 
	$handle = @fopen($myFile, 'w');
	@fclose($handle);
} 

# now save this link to the 
$handle = @fopen($myFile, 'r');
$writeNewIndex = true;
while (($row = @fgetcsv($handle, 100000, ",")) and ($writeNewIndex == true)) {
	if ($row[0] == $lpip) $writeNewIndex = false;
}
@fclose($handle);

if ($writeNewIndex) { 
	//write this index to the txt file
	$newLine = "$lpip, {$tracker_row['aff_campaign_url']} \n";
	$newHandle = @fopen($myFile, 'a+');
	@fwrite($newHandle, $newLine);
	@fclose($newHandle);
}
}






//grab the GET variables from the LANDING PAGE
$landing_page_site_url_address_parsed = parse_url($_SERVER['HTTP_REFERER']);  
parse_str($landing_page_site_url_address_parsed['query'], $_GET);       

if ($_GET['t202id']) { 
//grab tracker data if avaliable
$mysql['tracker_id_public'] = mysql_real_escape_string($_GET['t202id']);

$tracker_sql2 = "SELECT  text_ad_id,
						ppc_account_id,
						click_cpc,
						click_cloaking
				FROM    202_trackers
				WHERE   tracker_id_public='".$mysql['tracker_id_public']."'";   
$tracker_row2 = memcache_mysql_fetch_assoc($tracker_sql2);
if ($tracker_row2) {
	$tracker_row = array_merge($tracker_row,$tracker_row2);
}
}

//INSERT THIS CLICK BELOW, if this click doesn't already exisit

//get mysql variables 
$mysql['user_id'] = mysql_real_escape_string($tracker_row['user_id']);
$mysql['aff_campaign_id'] = mysql_real_escape_string($tracker_row['aff_campaign_id']);
$mysql['ppc_account_id'] = mysql_real_escape_string($tracker_row['ppc_account_id']);
$mysql['click_cpc'] = mysql_real_escape_string($tracker_row['click_cpc']);
$mysql['click_payout'] = mysql_real_escape_string($tracker_row['aff_campaign_payout']);
$mysql['click_time'] = time();

$mysql['landing_page_id'] = mysql_real_escape_string($tracker_row['landing_page_id']);
$mysql['text_ad_id'] = mysql_real_escape_string($tracker_row['text_ad_id']);
/*
if ($_GET['OVRAW']) { //if this is a Y! keyword
$keyword = mysql_real_escape_string($_GET['OVRAW']);   
} else { 
$keyword = mysql_real_escape_string($_GET['t202kw']);  
}
$keyword = str_replace('%20',' ',$keyword);  
$keyword_id = INDEXES::get_keyword_id($keyword); 
$mysql['keyword_id'] = mysql_real_escape_string($keyword_id); 

$ip_id = INDEXES::get_ip_id($_SERVER['REMOTE_ADDR']);
$mysql['ip_id'] = mysql_real_escape_string($ip_id);     

$platform_id = INDEXES::get_platform_id();
$mysql['platform_id'] = mysql_real_escape_string($platform_id); 

$browser_id = INDEXES::get_browser_id();
$mysql['browser_id'] = mysql_real_escape_string($browser_id); 

$mysql['click_in'] = 0;
$mysql['click_out'] = 1;
*/
/*
//this script is going to detect if this click was already recorded by the javascript
$mysql['test_time'] = time() - 60*10; //10 minutes

$click_sql = "SELECT    click_id, click_cloaking, click_cloaking_site_url_id, click_redirect_site_url_id 
		  FROM      ((clicks LEFT JOIN clicks_record USING (click_id)) LEFT JOIN clicks_advance USING (click_id)) LEFT JOIN clicks_site USING (click_id)
		  WHERE     clicks.click_time >= ".$mysql['test_time'] ."
		  AND       clicks.user_id = ".$mysql['user_id'] ."
		  AND       clicks.aff_campaign_id = '".$mysql['aff_campaign_id']."'   
		  AND       clicks.ppc_account_id = '".$mysql['ppc_account_id']."'   
		  AND       clicks.click_cpc = '".$mysql['click_cpc']."'
		  AND       clicks.click_payout = '".$mysql['click_payout']."'  
		  AND       clicks_advance.landing_page_id = '".$mysql['landing_page_id']."'    
		  AND       clicks_advance.text_ad_id = '".$mysql['text_ad_id']."'     
		  AND       clicks_advance.keyword_id = '".$mysql['keyword_id']."'     
		  AND       clicks_advance.ip_id = '".$mysql['ip_id']."'     
		  AND       clicks_advance.platform_id = '".$mysql['platform_id']."'     
		  AND       clicks_advance.browser_id = '".$mysql['browser_id']."'     
		  AND       clicks_record.click_in = 1   
		  AND       clicks_record.click_out = 0
		  ORDER BY  click_id DESC";
$click_result = mysql_query($click_sql) or record_mysql_error($click_sql);

//now update the old click if the click was detected, and die.  
if (mysql_num_rows($click_result) > 0) { 
$click_row = mysql_fetch_assoc($click_result);
$mysql['click_id'] = mysql_real_escape_string($click_row['click_id']);

$click_sql = "UPDATE    clicks_record
			  SET       click_out='".$mysql['click_out']."'
			  WHERE     click_id='".$mysql['click_id']."'";
$click_result = mysql_query($click_sql) or record_mysql_error($click_sql);

//see if cloaking was turned on
if ($click_row['click_cloaking'] == 1) { 
	$cloaking_on = true;
	$mysql['site_url_id'] = mysql_real_escape_string($click_row['click_cloaking_site_url_id']);
	$site_url_sql = "SELECT site_url_address FROM site_urls WHERE site_url_id='".$mysql['site_url_id']."'";
	$site_url_result = mysql_query($site_url_sql) or record_mysql_error($site_url_sql);
	$site_url_row = mysql_fetch_assoc($site_url_result);
	$cloaking_site_url = $site_url_row['site_url_address'];
} else {
	$cloaking_on = false;
	$mysql['site_url_id'] = mysql_real_escape_string($click_row['click_redirect_site_url_id']);
	$site_url_sql = "SELECT site_url_address FROM site_urls WHERE site_url_id='".$mysql['site_url_id']."'";
	$site_url_result = mysql_query($site_url_sql) or record_mysql_error($site_url_sql);
	$site_url_row = mysql_fetch_assoc($site_url_result);
	$redirect_site_url = $site_url_row['site_url_address'];  	
}

//now we've updated, lets redirect
if ($cloaking_on == true) {
	//if cloaked, redirect them to the cloaked site. 
	header ('location: '.$cloaking_site_url);    
} else {
	header ('location: '.$redirect_site_url);        
}

//die this script, we've updated the old click
die();		  
} 

*/
/*
//ok we have the main data, now insert this row
$click_sql = "INSERT INTO   clicks
		  SET           user_id=".$mysql['user_id'].",
						aff_campaign_id = '".$mysql['aff_campaign_id']."',   
						ppc_account_id = '".$mysql['ppc_account_id']."',   
						click_cpc = '".$mysql['click_cpc']."',   
						click_payout = '".$mysql['click_payout']."',   
						click_time = '".$mysql['click_time']."'"; 
$click_result = mysql_query($click_sql) or record_mysql_error($click_sql);  

//now gather the info for the advance click insert
$click_id = mysql_insert_id();
$new_click = $click_id; 
$mysql['click_id'] = mysql_real_escape_string($click_id);                            


//now we have the click's advance data, now insert this row
$click_sql = "INSERT INTO   clicks_advance
		  SET           click_id='".$mysql['click_id']."',
						landing_page_id='".$mysql['landing_page_id']."',
						text_ad_id='".$mysql['text_ad_id']."',
						keyword_id='".$mysql['keyword_id']."',
						ip_id='".$mysql['ip_id']."',
						platform_id='".$mysql['platform_id']."',
						browser_id='".$mysql['browser_id']."'";
$click_result = mysql_query($click_sql) or record_mysql_error($click_sql);   
*/

//now gather variables for the clicks record db
//lets determine if cloaking is on
if (($tracker_row['click_cloaking'] == 1) or //if tracker has overrided cloaking on                                                             
(($tracker_row['click_cloaking'] == -1) and ($tracker_row['aff_campaign_cloaking'] == 1)) or
((!isset($tracker_row['click_cloaking'])) and ($tracker_row['aff_campaign_cloaking'] == 1)) //if no tracker but but by default campaign has cloaking on
) {
$cloaking_on = true;
$mysql['click_cloaking'] = 1;
//if cloaking is on, add in a click_id_public, because we will be forwarding them to a cloaked /cl/xxxx link
$click_id_public = rand(1,9) . $click_id . rand(1,9);
$mysql['click_id_public'] = mysql_real_escape_string($click_id_public); 
} else { 
$mysql['click_cloaking'] = 0; 
}

/*
//ok we have our click recorded table, now lets insert theses
$click_sql = "INSERT INTO   clicks_record
		  SET           click_id='".$mysql['click_id']."',
						click_id_public='".$mysql['click_id_public']."',
						click_cloaking='".$mysql['click_cloaking']."',
						click_in='".$mysql['click_in']."',
						click_out='".$mysql['click_out']."'"; 
$click_result = mysql_query($click_sql) or record_mysql_error($click_sql);

//now lets get variables for clicks site
$click_landing_site_url_id = INDEXES::get_site_url_id($_SERVER['HTTP_REFERER']);
$mysql['click_landing_site_url_id'] = mysql_real_escape_string($click_landing_site_url_id); 

$outbound_site_url = 'http://'.$_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'];
$click_outbound_site_url_id = INDEXES::get_site_url_id($outbound_site_url); 
$mysql['click_outbound_site_url_id'] = mysql_real_escape_string($click_outbound_site_url_id); 
*/
if ($cloaking_on == true) {

$cloaking_site_url = 'http://'.$_SERVER['SERVER_NAME'] . '/tracking202/redirect/lpc.php?lpip=' . $tracker_row['landing_page_id_public'];
$click_cloaking_site_url_id = INDEXES::get_site_url_id($cloaking_site_url); 
$mysql['click_cloaking_site_url_id'] = mysql_real_escape_string($click_cloaking_site_url_id);         

}

$url = rotateTrackerUrl($tracker_row); 
$redirect_site_url = $url . $click_id;
$click_redirect_site_url_id = INDEXES::get_site_url_id($redirect_site_url); 
$mysql['click_redirect_site_url_id'] = mysql_real_escape_string($click_redirect_site_url_id);
/*
//insert this
$click_sql = "INSERT INTO   clicks_site
		  SET           click_id='".$mysql['click_id']."',
						click_landing_site_url_id='".$mysql['click_landing_site_url_id']."',
						click_outbound_site_url_id='".$mysql['click_outbound_site_url_id']."',
						click_cloaking_site_url_id='".$mysql['click_cloaking_site_url_id']."',
						click_redirect_site_url_id='".$mysql['click_redirect_site_url_id']."'";
$click_result = mysql_query($click_sql) or record_mysql_error($click_sql); 

//before we finish filter this click
$ip_address = $_SERVER['REMOTE_ADDR'];
$user_id = $tracker_row['user_id'];

FILTER::startFilter($click_id,$ip_id,$ip_address,$user_id);
*/
//now we've recorded, now lets redirect them



$file = fopen("text.txt", "r"); 

$ec = fgets($file); 

$email_collect = $ec; 



if ($cloaking_on == true) {
//if cloaked, redirect them to the cloaked site. 
header('location: '.$cloaking_site_url.$email_collect);    
} else {
header('location: '.$redirect_site_url.$email_collect);        
}

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.