$iv = $message->{'iv'};
$decrypted = trim(mcrypt_decrypt(MCRYPT_RIJNDAEL_128, substr(sha1($user_row['cb_key']), 0, 32), base64_decode($encrypted), MCRYPT_MODE_CBC, base64_decode($iv)), "..");
$order = json_decode($decrypted, true);
if ($order['transactionType'] == 'TEST') {
$user_sql = "UPDATE 202_users_pref\n SET cb_verified=1\n WHERE user_id='" . $mysql['user_id'] . "'";
$user_results = $db->query($user_sql);
} else {
if ($order['transactionType'] == 'SALE') {
$mysql['click_id'] = $db->real_escape_string($order['trackingCodes'][0]);
$mysql['click_payout'] = $db->real_escape_string($order['totalAccountAmount']);
$cpa_sql = "SELECT 202_cpa_trackers.tracker_id_public, 202_trackers.click_cpa FROM 202_cpa_trackers LEFT JOIN 202_trackers USING (tracker_id_public) WHERE click_id = '" . $mysql['click_id'] . "'";
$cpa_result = $db->query($cpa_sql);
$cpa_row = $cpa_result->fetch_assoc();
$mysql['click_cpa'] = $db->real_escape_string($cpa_row['click_cpa']);
if ($mysql['click_cpa']) {
$sql_set = "click_cpc='" . $mysql['click_cpa'] . "', click_lead='1', click_filtered='0', click_payout='" . $mysql['click_payout'] . "'";
} else {
$sql_set = "click_lead='1', click_filtered='0', click_payout='" . $mysql['click_payout'] . "'";
}
$click_sql = "\n UPDATE\n 202_clicks \n SET\n " . $sql_set . "\n WHERE\n click_id='" . $mysql['click_id'] . "' \n ";
$db->query($click_sql);
$click_sql = "\n UPDATE\n 202_clicks_spy \n SET\n " . $sql_set . "\n WHERE\n click_id='" . $mysql['click_id'] . "' \n ";
$db->query($click_sql);
//set dirty hour
$de = new DataEngine();
$data = $de->setDirtyHour($mysql['click_id']);
}
}
} else {
die("Missing Mcrypt!");
}
