PHP - How Would I Go About Writing A Referral Script?

Hello friends.

I'm needing a bit of help with some code.

I have this code to show my users their referral link:
(this code goes in the reg.php file)
Code: [Select]
if($_COOKIE['referido'])
{
$ref = $_COOKIE['referido'];
} else {
$ref = $do->get_r_file_url();
$ref = str_replace(array(".html", "/"), "", $ref);
if(eregi('.php', $ref)) { $ref=false; }

setcookie("referido", $ref, time()+60*60*24*30);
}
And then this one on the user's profile to show their referral URL:
Code: [Select]
$dp = $do->get_loc()."reg.php/{$signin_username}.html";
So the result is "mysite.com/reg.php/referral.html" and I want it to be "mysite.com/reg.php?referral"
I just need to get rid of the "/"
I've seen sites like "thesite.com/?r=referral"

How can i do something like that?

Thanks!

Hello friends!
I just need the last help to have everything working ok.

I'm having an issue because the input won't show the referral ID.

Here is the .htaccess code:
/*This changes the URL mysite.com/reg.php/referral.html to mysite.com/reg.php?referral*/
Code: [Select]
Options +FollowSymlinks
RewriteEngine on
RewriteRule ^reg.php/(.*)\.html$ http://www.mysite/reg.php?$1

Then the code in the reg.php page:
Code: [Select]
if($_COOKIE['referido'])
{
$ref = $_COOKIE['referido'];
} else {
$ref = $do->get_r_file_url();
$ref = str_replace(array(".html", "/"), "", $ref);
if(eregi('.php', $ref)) { $ref=false; }
setcookie("referido", $ref, time()+60*60*24*30);
}



And then the input:
<input size='3' style='width:170px;' id='referral' type='hidden' name='6' value='{$ref}' >


So how do I do to make the input show the referral ID?


Thanks!

Hi,

I have a fully pledged membership system and want to integrate my own user referral system but want some tips, advice really on the logic of it. Basically already registered users on my site will have the option to refer people, only registered users. I will try to explain my logic and what i have done so far.

My current registered users table is something like

Quote

    users (table)
    - id (user id)
    - email (user email)
    - password (hash of users password)
    - reg_date (date user registered)


I have some other fields but not relevant to what I want to do and to keep things as simple as possible I left them out.

I am thinking of creating a new table called referrals and for example when a registered user on my site from the users table goes to a member only page called referral.php it will display a form so they can enter an email address of someone they want to refer and it also displays the people they referred.

My referral table is like this so far and not sure if it's best way to go about the database logics and php logic.

my table so far looks like this:

Quote

    referrals (table)
    - id (auto incremented every time a new referral (row) is added to referrals table)
    - referrer_uid (id of referrer, this would be the unique id of a registered user from the users table)
    - referred_email (email address of person who has been referred)
    - status (when someone is first referred default will be `referred`, if they signup to site via referral link this will update to `completed`)
    - created_on (date the referral was made, unix timestamp)
    - updated_on (date the referred person actually clicks the referral link and completes signup)


Currently i added the database table above to my site on local. added some sample data for testing and created a referral.php page where there's a form so a registered member can enter a persons email and refer them to my site to signup. On referral.php there is also  the total people they referred and a table showing all the people they referred as follows:

Referred Email | Referred Date | Status | Completed On

Now so far everything is seems fine. I have my sample (pretend referrals i made) data showing in my test account. The part i am now not sure about is this:

Obviously to stop abuse i do my usual validation checks like: check to ensure the email being entered on referrals page does not exist in users table (registered member), check to ensure the email has not already been referred previously (for spam reasons) only allowed to refer an email address once and not allowed to refer someone who has previously been referred by someone else to (again for spam reasons)

Now onto the tracking the referral and link building.

I was first thinking this:

on sign up form have a hidden field. The sign up form would do a simple check to see if isset $_GET['ref'] like signup.php?ref=something_here

if it is prefill the hidden field, when user then signs up if the ref=something_here matches what's in the database then update referral to complete so the referrer knows that their friend for example signed up via their referral, unix timestamp of when referred person completed signup.

Now i was going to use the email address of referred person or username of person who made the referral signup.php?ref=username or signup.php?ref=referred_email . Now what i am thinking is what would be better and i guess stop random abuse is create another column and call it referred_id; this would be a random md5 hash that is unique to that referral and it will be appended to the url like signup.php?ref=md5_hash_here.



So my questions a

1) Is there anything you think i should change, improve on, alter etc ?

2) Do you think i am going about it the rite way or making a mess of it ?

3) Have i left anything out that i may have not thought of that could cause the system to be abused ?

Any suggestions, feedback, help on the whole logic would be great.

I coded allot of it last night and won't take me long to do the rest but need some help in terms of ensuring i am doing it the best way possible etc, the logic behind it all.

Thanks for any suggestions, help, advice, tips!

PHPFAN

db table    username------>id->username->cash->points->referrer db table    referral_levels------>id->level->earnings->signupBonusCash->signupBonusPoints->status

username    referrer
--------    --------
admin
kelly88     admin   // UPDATE USERNAME ADMIN WITH referral level 1 POINTS/CASH //
jacob       kelly88 // UPDATE USERNAME ADMIN WITH referral level 2 POINTS/CASH AND USERNAME kelly88 WITH referral level 1 POINTS/CASH //
david16     jacob   // UPDATE USERNAME ADMIN WITH referral level 3 POINTS/CASH AND USERNAME kelly88 WITH referral level 2 POINTS/CASH AND USERNAME jacob WITH referral level 1 POINTS/CASH //

Is this possible. If yes - HOW?   Current test registration code with referral level 1

<?php
if(!empty($_GET['ref'])){
	
	$referrerUsername = filter_input(INPUT_GET, 'ref', FILTER_SANITIZE_STRING);
	
	if(usernameExist($referrerUsername, $db) === TRUE){
		$_SESSION['ref'] = $referrerUsername;
	}
	
}

// define variables with the value for each field
// the value from POST,GET if this exist, or an empty value
$errors = array();
$username = isset($_POST['username']) ? filter_input(INPUT_POST, 'username', FILTER_SANITIZE_STRING) : '';
$referrer = !empty($_SESSION['ref']) ? $_SESSION['ref'] : (isset($_POST['referrer']) ? filter_input(INPUT_POST, 'referrer', FILTER_SANITIZE_STRING) : '');

if(!empty($_POST['submit'])){
	
	if(empty($username)){
       	 $errors[] = $lang['error']['a_019'];
    }
	else if(validUsernameLenght($username) === FALSE){
        $errors[] = $lang['error']['a_020'];
   	}
	else if(validUsernameChars($username) === FALSE){
        $errors[] = $lang['error']['a_021'];
    }
	else if(usernameExist($username, $db) === TRUE){
       	$errors[] = $lang['error']['a_022'];
    }
	
	if(!empty($referrer)){
		
		if(usernameExist($referrer, $db) === FALSE){
			$errors[] = $lang['error']['a_037'];
		}
		else if($username == $referrer){
			$errors[] = $lang['error']['a_038'];
		}
			
	}
	
}

if(!empty($_POST['submit']) and empty($errors)){
	/*
	$queryOne = 'INSERT INTO users(username, referrer) VALUES (:username, :referrer)';
	$insertOne = $db->prepare($queryOne);
	$insertOne->bindParam(':username', $username, PDO::PARAM_STR);
	$insertOne->bindParam(':referrer', $referrer, PDO::PARAM_STR);
	$successOne = $insertOne->execute();
	*/
	if($referrer){
		
		$query = 'SELECT signupBonusCash AS sbc, signupBonusPoints AS sbp FROM referral_levels WHERE level = 1 AND status = "enabled"';
		$select = $db->query($query);
		$row = $select->fetch(PDO::FETCH_ASSOC);
		
		$queryTwo = 'UPDATE users SET points = points + :points, cash = cash + :cash WHERE username = :referrer';
   	 	$selectTwo = $db->prepare($queryTwo);
		$selectTwo->bindParam(':cash', $row['sbc'], PDO::PARAM_STR);
		$selectTwo->bindParam(':points', $row['sbp'], PDO::PARAM_STR);
		$selectTwo->bindParam(':referrer', $referrer, PDO::PARAM_STR);
		$selectTwo->execute();
		
	}
	
}

if(!empty($errors)){ 
	foreach($errors as $error){
		print $error.'<br>'; 
	}
}	

print '
<form method="POST">
<table style="width:100%">
	<tr>
    	<td style="width:30%;font-weight:bold">Username</td>
    	<td style="width:70%"><input type="text" name="username" maxlength="255" style="width:200px" value="'.cleanOutput($username).'"></td>
	</tr>';
	
	if(!empty($_SESSION['ref'])){
		
		print '
	<tr>
    	<td style="font-weight:bold">'.$lang['global']['a_047'].'</td>
    	<td><input type="text" name="referrer" readonly="readonly" maxlength="255" style="width:200px" value="'.cleanOutput($referrer).'"></td>
  	</tr>';
	
	}else{
		
		print '
	<tr>
    	<td style="font-weight:bold">'.$lang['global']['a_047'].'</td>
    	<td><input type="text" name="referrer" maxlength="255" style="width:200px" value="'.cleanOutput($referrer).'"></td>
  	</tr>';
	
	}
	
	print '
	<tr>
    	<td colspan="2" style="text-align:center"><input type="submit" name="submit" value="Submit"></td>
  	</tr>
</table>
</form>'; 

?>

I have a site where the user must view a timed loader before playing an audio bible.  I'm noticing some direct linking to the bible player instead of sitting through the loader...

I need to check the previous page's url before actually loading the player. I through together a script last ween in javascript and people reported error, so I assumed it would be best server side anyway.

I haven't coded anything in PHP since PHP3.  So, I'm asking for your expert options and help...

I haven't tested this yet, but is this the best method and are they any problems with this method (if it works).



$realname = basename($_SERVER[loader], ".php");

if ($realname == 'loader.php')
{
   return();
}

else
{
 // rediret to a notice to user that this isn't allow
 header( 'Location: http://www.yoursite.com/new_page.html' ) ;
}

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=346529.0

       Right now, the following PHP script claims to send an email for Google referrals, as your forum states.  I put it in the first few lines of index.php.  Is this wrong, because I still received zero emails, adding the site name to keywords below...?  And, of course, I searched the same keyword from Google without success.

<?php
// Script to email you when Google refers traffic to your site.
$name=""; // add your name here
$email_address="";
 // add your email address here
$keywords="";
$referrer=$_SERVER['HTTP_REFERER'];
if( (stristr($referrer, "google")) && (stristr($referrer, "search")) ) {
   
parse_str($referrer, $output);
   $keywords=$output['q'];
      $email_message="Hi $name, A visitor just arrived to your site after searching for '$keywords'. ($referrer)";   mail ("$email_address","Google referred a visitor","$email_message");
}
?>
    If this is wrong, how DO I use such a PHP within my phpmyadmin folder?  Need help.

Hi everyone.  Still new to PHP and to Object-Oriented Programming.

My goal for today is to write a few dummy Classes in PHP that do enough so that I can see something on my webpage.

I am wondering if there is someone here who would be willing to help in either the forums or one-on-one.

It may sound like a silly request, but this is all new to me as a Procedural Programmer who has actively programmed in about 10 years!!   

Thanks,


TomTees

I have a code for writing a log file...
The code is working fine but it inserts the new details at the bottom of the file but i want to insert in the top...

So what function should i use... Here is the file my_log.php

Code: [Select]
<?php

$usname = $_SESSION['usname'];
date_default_timezone_set('Asia/Calcutta');
$date = date("l dS \of F Y h:i:s A");
$file = "log.php"; 
$open = fopen($file, "a+"); 
fseek($open,289);
fwrite($open "<b><br/>USER NAME:</b>              ".$usname . "<br/>"); 
fwrite($open, "<b>Date & Time:</b>            ".$date. "<br/>"); 
fwrite($open, "<b>What have they done :</b>   ".$reason . "<br/><br/>"); 
fclose($open); 

?>

and here is my log.php file :

Code: [Select]
<?php
session_start();
if($_SESSION['stage']!=1 || $_SESSION['stage2']!=2)
{header('location:index.php');
die(" ");
}
?>
<?php
if($_GET['valu']=="view_log")
{
$reason=" ".$_SESSION['usname']." Viewed the LOG";
include('my_log.php');
header('location:log.php');
die("");
}
// bytes till here are 289

//LINE 1 : Log details have to insert here



I want to insert every detail from the top of the page but just below the php code..
What should i do...

ANy helo would be appreciated

Pranshu Agrawal
pranshu.a.11@gmail.com

I am using a cache script, well it writes a array to a file like this:

Code: [Select]
fwrite($fh, '<?php'."\n\n".'define(\'PUN_LOTTERY_LOADED\', 1);'."\n\n".'$lottery = '.var_export($output2, true).';'."\n\n".'?>');
output2 is

Code: [Select]
$result2 = $db->query('MY QUERY ');
$output2 = array();
while ($cur_donors = $db->fetch_assoc($result2))
$output2[] = $cur_donors;

Now, I want to ditch the mysql and I want to use this script with 7 variables that I already have loaded, so I dont need to use the mysql, how do I add my 7 variables to my var_export function instead of using mysql to loop them?

Greetings,

I am trying to write XML using SimpleXML for a web service call. I was having success until the XML got a little more complicated. Here is the XML format where I am running into problems:

Code: [Select]
<Agent>
    <Person Last='Smith' First='John'>
        <Addresses />
        <PhoneNumbers>
            <Phone Type='1' Number='888-555-1212'>
        </PhoneNumbers>
    </Person>
</Agent>

Here is my php:
Code: [Select]
$xmlOutput = new SimpleXMLElement('<?xml version="1.0"?><ReportRequest> </ReportRequest>');
$xmlOutput->addAttribute('CID','9200');
$xmlOutput->addAttribute('Diagram','1');
$xmlOutput->addAttribute('DueDate','2011-11-15');
$xmlOutput->addAttribute('NumPhotos','6');
$xmlOutput->addAttribute('InspectAfter','');
$xmlOutput->addAttribute('PolicyNumber','JTC0004425');
$reportType = $xmlOutput->addChild('ReportType');
$reportType->addAttribute('CPType','Commercial');
$reportType->addAttribute('SectionIDs','');
$reportType->addAttribute('Description','');
$reportType->addAttribute('ReportTypeID','123');
$locations =  $xmlOutput->addChild('Locations')->addChild('Addresses')->addChild('Address');
$locations->addAttribute('Zip','91216');
$locations->addAttribute('City','Chatsworth');
$locations->addAttribute('Line1','123 Main St');
$locations->addAttribute('Line2','Suite 201');
$locations->addAttribute('State','CA');
$locations->addAttribute('Latitude','');
$locations->addAttribute('Longitude','');
$agent =  $xmlOutput->addChild('Agent')->addChild('Person')->addChild('Addresses')->addChild('PhoneNumbers')->addChild('Phone');
$agent->addAttribute('Last','Smith');
$agent->addAttribute('Email','');
$agent->addAttribute('First','John');
$agent->addAttribute('Title','');
$agent->addAttribute('Type','1');
$agent->addAttribute('Number','888-555-1212');
$agent->addAttribute('TypeName','Office');
$agent->addAttribute('Extension','');

Header('Content-type: text/xml');

echo $xmlOutput->asXML();

Everything outputs as it should until the line that starts with $agent. I want the output to match the section above. I have tried several variations but I cannot seem to figure it out. I know the current PHP sample doesn't work. Help??

Thanks in advance,

John

I don't think the start of my code is right?!

Code: [Select]
echo '<button onclick=\"gohere(viewpub.php?PubID='.$row['PubID'].')" id="button" type="button" class="ui-button ui-widget ui-state-default ui-corner-all ui-button-text-only" role="button" aria-disabled="false"><span class="ui-button-text">View Pub</span></button>';

Please help?!

I have a web app hosted on Just Host that I have nearly finished writing but still needs to have coded the ability to write a text file to user's computer. the user should be able to specify where on their computer they would like the file to be stored. Is this possible ? And can you tell me how it's done, or point me to a souce that can tell me 

I rarely ever ask for help regarding programming, but this has flumoxed me.


If it is not possible to do this, then would I have to generate this file on the Host's server (Just Host in my case), then download it ? If this can be done then can you please tell me how, as any info I have found related to file downloads seems a bit obscure 

thanks in advance 

I need help! I cant get this to write the correct way!

What i need is based on the value of what is posted to the script it has to write it in the config file and also make a folder!

Please help


Code: [Select]
<?php
$start = '$uploadpath=\'';
$structure = '../banner/images/'.$_POST['FOLDER'].'\';\n';

$myFile = "PHP/confup.php";
$fh = fopen($myFile, 'w') or die("can't open file");
$stringData = "<?\n";
fwrite($fh, $stringData);
$stringData = "$start $structure";
fwrite($fh, $stringData);
$stringData = "?>\n";
fwrite($fh, $stringData);
fclose($fh);

// Desired folder structure


// To create the nested structure, the $recursive parameter
// to mkdir() must be specified.

if (!mkdir($structure, 0777, true)) {
    die('Failed to create folders...');
}

// ...
?>

Hey Guys. I am trying to write to the file depending on which condition is met. The code works fine on my local machiene but not on my remote server.
  I have also tried to output any error messages to see if it would output anything, and I don't get anyting on my browser. Can anyone help me with this issue? Thanks

<?php
if($_SERVER['REQUEST_METHOD'] == "POST") {


isset($_POST['interfax']) ? $option= "interfax" : $option= "";
isset($_POST['metrofax']) ? $option= "metrofax" : $option= "";


switch ($option) {
	case 'interfax':
	$file = "fax.php";
	$fax_client = "interfax";
	if(file_put_contents($file, "<?php ".'$fax_client = "' . $fax_client . '"'." ?>"))
	{ echo "Successful"; } else {
			die("Can't write file");
		}
		break;
	
		


    // By defualt all the orders go to metrofax so by selecting the variable it resets it self 
	case 'metrofax':
	$file = "fax.php";
	$fax_client = "metrofax";
	file_put_contents($file, "<?php ".'$fax_client = "' . NULL . '"'." ?>");
		break;	

			}


		}
?>


<form action="#" method="POST"> 

 <input type="radio" name="interfax" value="interfax">Switch To Interfax<br>
<input type="radio" name="metrofax" value="metrofax">Switch To Metrofax<br>

<input type='submit' name="submit" >