Ik zit met het volgende probleem. Men kan bij mij via daopay punten bestellen door te bellen met daopay. Nu is het de bedoeling dat man na het bellen terug word gebracht naar de website ( so far so good ) en dat de punten automatisch bij de beller zijn/haar account worden opgeteld. ( not so good )
De verificatie van daopay krijg ik maar niet goed, continu de melding PIN code invalid/expired.
Iemand van jullie een idee/suggestie ?
Alvast bedankt
Hieronder de code :
<?
$appcode = 45566; // Enter your Appcode here
$prodcode = trim($_GET["subkey"]);
$pin = trim($_GET["pin"]);
if($appcode != $_GET["tidkey"]) {
exit;
}
if (strlen($prodcode) && strlen($pin)) {
$handle = fopen("http://daopay.com/svc/pincheck?appcode=".$appcode."&prodcode=".$prodcode."&pin=".$pin, "r");
if ($handle) {
$reply = fgets($handle);
if (substr($reply,0,2) == "ok") {
$Accountcheck = "SELECT * FROM login WHERE name = '" .mysql_real_escape_string($name). "'";
$query = mysql_query($Accountcheck) or die(mysql_error());
$count = mysql_num_rows($query);
if(($count != "1") and ($prodcode == 'EG20')){
mysql_query("UPDATE login SET credits = credits + 20 WHERE name = '$name'");
$sql = "INSERT INTO dp_claim SET id = '', Account = '" .mysql_real_escape_string($name). "', Pin = '".mysql_real_escape_string($_GET['pin'])."', datum = 'NULL', Subkey ='$subkey'";
$res = mysql_query($sql);
?><center><b><? echo '20'; echo ' points sent to '; echo $name;
}
if(($count != "1") and ($prodcode == 'EG120')){
mysql_query("UPDATE login SET credits = credits + 120 WHERE name = '" .mysql_real_escape_string($name). "'");
$sql = "INSERT INTO dp_claim SET id = '', Account = '" .mysql_real_escape_string($name). "', Pin = '".mysql_real_escape_string($_GET['pin'])."', datum = 'NULL', Subkey ='$subkey'";
$res = mysql_query($sql);
?><center><b><? echo '120'; echo ' points sent to '; echo $name;
}
if(($count != "1") and ($prodcode == 'EG260')){
mysql_query("UPDATE login SET credits = credits + 260 WHERE name = '" .mysql_real_escape_string($name). "'");
$sql = "INSERT INTO dp_claim SET id = '', Account = '" .mysql_real_escape_string($name). "', Pin = '".mysql_real_escape_string($_GET['pin'])."', datum = 'NULL', Subkey ='$subkey'";
$res = mysql_query($sql);
?><center><b><? echo '260'; echo ' points sent to '; echo $name;
}
if(($count != "1") and ($prodcode == 'EG550')){
mysql_query("UPDATE login SET credits = credits + 550 WHERE name = '" .mysql_real_escape_string($name). "'");
$sql = "INSERT INTO dp_claim SET id = '', Account = '" .mysql_real_escape_string($name). "', Pin = '".mysql_real_escape_string($_GET['pin'])."', datum = 'NULL', Subkey ='$subkey'";
$res = mysql_query($sql);
?><center><b><? echo '550'; echo ' points sent to '; echo $name;
}
}
else {
// PIN code invalid/expired
echo "<font color='#ff0000'><b>Dear $name , PIN code invalid/expired, please contact someone from staff</b></font>";
}
}
else {
// Connection error
echo "<font color='#ff0000'><b>Connection error: Can not connect to Daopay</b></font>";
}
}
?>
