Question about CPAlead content locker

7 replies
hello everyone im trying to add content locker to my site so people can take surveys to earn "coins" my sites currency.

i have a postback.php file they want added to my site so soon as people complete an offer it automatically adds coins to the users account


this is what i got..


/*
* Basic Postback Example Script.
* Copyright 2011. CPAlead. All Rights Reserved
*/

$YOURPASSWORD = "secret1234";

$mysql_where = "localhost";
$mysql_username = "your_mysql_username";
$mysql_password = "your_mysql_password";
$mysql_database = "your_user_database";

$password = $_REQUEST['password'];
if ($password != $YOURPASSWORD) {
echo "Access Denied";
exit;
}

mysql_connect($mysql_where, $mysql_username, $mysql_password);
mysql_select_db($mysql_database);

/*
* For a complete variable list see: http://www.cpalead.com/pdf/postback-...tion-guide.pdf
*/

$subid = $_REQUEST['subid'];
$survey = $_REQUEST['survey'];
$earn = $_REQUEST['earn'];
$pdtshow = $_REQUEST['pdtshow'];

/*
* db_name = the name of the database in which the table resides
* players = the name of the table inside db_name that we'll be updating
* points = the column in the 'players' table to update
*/

mysql_query("UPDATE db_name.players SET points=points+".$pdtshow." WHERE id='".$subid."'") or die(mysql_error());
mysql_close();

echo "Success: ".$subid." earned ".$pdtshow." points\n";


Now how can i edit it so it will work on my site?

my tables i think needed is user and coins. so where it says UPDATE db_name.players i should change it to .users and points=points should be changed to coins=coins

Please give me some guidance

Thanks
#content #cpalead #locker #question

Trending Topics