$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!"); }