Referal System help :) - TutorialNinja Forum

Posted on Tuesday 18th November 2008 at 04:51 PM

jambomb

Okay i have been trying to make a referal system for my site but its just not working!!

this is my referer code so far in the register php script!

Code

        ////////////// REFERER!!!! /////////////

if(isset($_GET['r'])){

$reff = addslashes($_GET['r']);

$getRef =mysql_query("SELECT * FROM `members` WHERE `username` = '$reff'");

$ref = mysql_fetch_array($getRef);

$giveReferer1 = mysql_query("UPDATE `members` SET `cash` = 'cash + 10000' WHERE `username` = '$ref' ") or die(mysql_error());

$giveReferer2 = mysql_query("UPDATE `members` SET `respect` = 'respect + 1000' WHERE `username` = '$ref' ") or die(mysql_error());

$to = "$ref";

$subject = "Friend Signed Up!";

$msg = "

Hello $ref

Your friend $username has just signed up and so you have received your $10,000 cash and a extra 1,000 Respect!

Thank you!

www.Crime-Network.com

";

$date = date("l jS F Y h:i A"); 

$newpm = mysql_query("INSERT INTO `privates` (`to`,`from`,`date`,`subject`,`content`) VALUES ('$ref','BOT','$date','$subject','$msg');") or die(mysql_error());

}

/////////////////// END REFERER!!!! //////////////////

It seems fine to me but it just doesnt send the email or adds the cash to the r player

thanks for any help!!

Posted on Tuesday 18th November 2008 at 05:03 PM

Okay i tryd this link but doesnt work...

https://www.crime-network.com/index.php?r=MotherFuK

but it needs to be under ?register but if i try this link

https://www.crime-network.com/index.php?register&r=MotherFuK

it just says fields left blank click here to try again

any help ??

Posted on Tuesday 18th November 2008 at 05:48 PM

setsukemizuhara
setsukemizuhara's Avatar

Change:

        $newpm = mysql_query("INSERT INTO `privates` (`to`,`from`,`date`,`subject`,`content`) VALUES ('$ref','BOT','$date','$subject','$msg');") or die(mysql_error());
        

To:

        $newpm = mysql_query("INSERT INTO `privates` (`to`,`from`,`date`,`subject`,`content`) VALUES ('$ref','BOT','$date','$subject','$msg')") or die(mysql_error());
        

Posted on Tuesday 18th November 2008 at 07:29 PM

Dava

jambomb send me your register.php

Posted on Tuesday 18th November 2008 at 07:31 PM

here is a simple ref script just done quickly

        <?php 

session_start(); //Start session 

include("config.php"); //Include config file 

if ($_GET[r]){

$reff = htmlspecialchars(strip_tags($_GET[r])); //friend

$to = "$reff"; 

$getref = mysql_query("SELECT * FROM `members` WHERE `username` = '$reff'");

$ref = mysql_fetch_array($getref); 

$date = date("l jS F Y h:i A"); 

$subject = "Friends Request";

$from = "BOT";

$content = "Hello $ref[username]

Your friend $username has just signed up and so you have received your $10,000 cash and a extra 1,000 Respect!

Thank you!

www.Crime-Network.com";

$do = mysql_query("INSERT INTO `privates` (`to`,`from`,`date`,`subject`,`content`) VALUES ('" . $to . "','" . $from . "','" . $date . "','" . $subject . "','" . $content . "')") or die(mysql_error()); //insert into the table! 

$givecash = mysql_query("UPDATE `members` SET cash=cash+10000 WHERE `username` = '$ref[username]'");

$giverespect = mysql_query("UPDATE `members` SET respect=respect+10000 WHERE `username` = '$ref[username]'");

}

?>

Posted on Monday 2nd February 2009 at 04:16 PM

ShadowMage
ShadowMage's Avatar

You will want to add IP Address checks to make sure they are not cheating.

failure i sense

Posted on Tuesday 17th March 2009 at 12:42 AM

afroxav

and you can both add cash and respect in the same sql query, using the AND keyword.