Someone had an idea,a cool new concept on gaining points to spend on packages and what not. Yes, I followed the cliche trend that all of the new promotion forums have by using points to purchase packages and what not but I added a little spin on how you earn the points. Instead of posting tirelessly on the forum to gain points, you can simply add a referral link to your website! When a user clicks it, you get some points! Security features have been added. (Before anyone asks)
URL Example:
http://promolocus.com/refer.php?username=UserNameHere
Code Example For The Tech Heads:
$username = $_GET['username'];
$query = "SELECT * FROM *removed* WHERE *removed*";
$stmt = $dbh->prepare($query);
$stmt->bindParam("*removed*", $username, PDO::PARAM_STR);
$stmt->execute();
if($stmt->rowCount() > 0) {
# We found the username... Now, who's clicked?
$query = "SELECT * FROM *removed* WHERE *removed*";
$stmt = $dbh->prepare($query);
$stmt->bindValue("*removed*", *removed* PDO::PARAM_STR);
$stmt->execute();
if($stmt->rowCount() > 0) {
# Code Logic blah blah
}
}
Keep in mind it's not my code and won't fully work on IPS forums, but you get what I mean by this anyway