Advertisement
Guest User

Untitled

a guest
Jun 3rd, 2018
380
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 18.93 KB | None | 0 0
  1. <?php
  2. //date_default_timezone_set('America/Los_Angeles');
  3. //echo date('Y-m-d' , "1501353000");
  4. session_start();
  5. include "../connection.php";   
  6. include "../config/main.php";
  7. include "../helpers/AdvertsHelper.php";
  8. include "../helpers/UserHelper.php";
  9. include "../helpers/CommonHelper.php";
  10. include "../_mailer/mail.php";
  11. error_reporting(0);
  12. $advertshelper = new AdvertsHelper();  
  13. $userhelper = new UserHelper();
  14. $commonhelper = new CommonHelper();
  15. $currentDtTime = date('Y-m-d h:i:s');
  16. set_time_limit(0);
  17. $mailer = initiate_mail();                     
  18. /* $mail_detail = array(
  19.    'to'=>array('watermark0913@gmail.com'),
  20.    'to_name'=>array('tester'),
  21.    'from'=>'dstestteam@gmail.com',
  22.    'subject'=>'Cron Notification',
  23.    'message'=>'test email'
  24. );
  25.    
  26. send_mail($mail_detail , $mailer);*/
  27.    
  28. function cron_notification($message_content){
  29.    
  30.     $mailer = initiate_mail();                     
  31.     $mail_detail = array(
  32.        //'to'=>'watermark0913@gmail.com',
  33.        //'to_name'=>'tester',
  34.        'to'=>array('alex@gosocialmarketing.co.uk', 'Josh.king@gosocialmarketing.co.uk','Andy@gosocialmarketing.co.uk','Lewis@gosocialmarketing.co.uk'),
  35.        'to_name'=>array('alex','josh','andy','lewis'),
  36.        'from'=>'dstestteam@gmail.com',
  37.        'subject'=>'Cron Notification',
  38.        'message'=>$message_content
  39.     );
  40.    
  41.     send_mail($mail_detail , $mailer);
  42.     echo "done";
  43. }
  44.  
  45. function getCurlResponse($url){
  46.     //echo $url."</br>";
  47.     $ch = curl_init($url);
  48.     curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  49.     curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  50.     curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
  51.     $response = curl_exec($ch);
  52.     //echo $response."--".$url."</br>";
  53.     $data = json_decode($response, true);
  54.     return $data;
  55. }
  56. ?>
  57.  
  58. <?php
  59. $startrange = 1;
  60. for($i=$startrange; $i>=0; $i--){
  61.     if($i>=1){
  62.         $dateseries[$i]['start_date'] = date("Y-m-d" , strtotime(' -'.$i.' days'));
  63.         $dateseries[$i]['end_date'] = date("Y-m-d" , strtotime(' -'.($i).' days'));
  64.     }
  65.     else {
  66.         $dateseries[$i]['start_date'] = date("Y-m-d");
  67.         $dateseries[$i]['end_date'] = date("Y-m-d");
  68.     }
  69. }
  70.  
  71. $timeranges =array();
  72. foreach($dateseries as $key=>$value){
  73.     $timeranges[] = "{'since':"."'".$value['start_date']."'".","."'until':"."'".$value['end_date']."'"."}";
  74. }
  75.    
  76. $timerangestring = implode("," , $timeranges);
  77. $timerangestring = '['.$timerangestring.']';
  78. //echo date('d M Y', strtotime($dateseries[$startrange]['start_date']));
  79. //echo date('d M Y', strtotime($dateseries[0]['start_date'].' +1 days'));
  80.  
  81. $since = strtotime(date('d M Y', strtotime($dateseries[$startrange]['start_date'])));
  82. $until = strtotime(date('d M Y', strtotime($dateseries[0]['start_date'].' +1 days'))); 
  83.  
  84. $startDate = date('Y-m-d', strtotime($dateseries[$startrange]['start_date']));
  85. $endDate = date('Y-m-d', strtotime($dateseries[0]['start_date']));
  86. //echo $startDate."--";
  87. //echo $endDate;
  88.  
  89. $adverts_detail = $advertshelper->advert_accountlist(array(), $mysqli);
  90. while($adverts_info = mysqli_fetch_array($adverts_detail,MYSQLI_ASSOC)){
  91.     //echo $adverts_info['id']."mera";
  92.     $advvalue = $adverts_info['id'];
  93.     $fb_app_ID[$advvalue] = $adverts_info['app_id'];
  94.     $fb_acc_ID[$advvalue] = $adverts_info['acc_id'];
  95.     $apiCallto = "https://graph.facebook.com/v2.12/".$fb_app_ID[$advvalue]."/app_insights/app_event/";
  96.     //$accessTokenAppInsight[$advvalue] = 'EAANhrBZCwuZBYBAABpj9A7q1YwmXKgpHsHj52y60JXM2CYllXxAGjJBffBoMbwmtNWKG6sZBrtVtcl1Hb487SmvNswXBLKKbkMXOeXSpL6GOZBDmmkgBa7etyZCrEZAEtoNSbWSfwklgV0iajaPD7Cb6WdTzZAZApZAsZD';
  97.    
  98.     $accessTokenAppInsight[$advvalue] = $adverts_info['networkapi_access_token'];
  99.     $accessTokenApiMarketing[$advvalue] = $adverts_info['access_token'];
  100.  
  101.     //--------------------------------------------------------1st Call
  102.     $revQuery[$advvalue] = "$apiCallto?since=".$since."&until=".$until."&event_name=fb_ad_network_revenue&aggregateBy=SUM&breakdowns[0]=placement&access_token=".$accessTokenAppInsight[$advvalue];
  103.     //echo $revQuery[$advvalue];
  104.     //echo $revQuery[$advvalue]."</br></br>";
  105.     //echo $revQuery[$advvalue].'</br>';
  106.     $revenuArray = getCurlResponse($revQuery[$advvalue]);
  107.     //print_r($revenuArray);exit;
  108.    
  109.     $logdetail[$advvalue]['advert_name'] = $adverts_info['name'];
  110.    
  111.     if(isset($revenuArray['error'])){
  112.         $logdetail[$advvalue]['fb_ad_network_revenue']['error'] = 1;
  113.         $logdetail[$advvalue]['fb_ad_network_revenue']['errormessage'] = $revenuArray['error']['message'];
  114.     }
  115.    
  116.     if(isset($revenuArray['data'])){
  117.         $logdetail[$advvalue]['fb_ad_network_revenue']['success'] = 1;
  118.         $logdetail[$advvalue]['fb_ad_network_revenue']['total_data'] = count($revenuArray['data']);
  119.     }
  120.    
  121.     if(!isset($revenuArray['error']) && isset($revenuArray['data']) && !empty($revenuArray['data'])){
  122.         //usort($revenuArray['data'], "placement");
  123.     }
  124.        
  125.     //--------------------------------------------------------2nd Call
  126.     $cpmQuery[$advvalue] = "$apiCallto?since=".$since."&until=".$until."&event_name=fb_ad_network_imp&aggregateBy=COUNT&breakdowns[0]=placement&access_token=".$accessTokenAppInsight[$advvalue];
  127.     //echo $cpmQuery[$advvalue].'</br>';
  128.     //$estimatedcpmQuery[$advvalue] = "$apiCallto?since=".$since."&until=".$until."&event_name=fb_ad_network_cpm&aggregateBy=SUM&breakdowns[0]=placement&access_token=".$accessTokenAppInsight[$advvalue];
  129.     //echo $estimatedcpmQuery[$advvalue];
  130.     //die();
  131.     $cpmArray = getCurlResponse($cpmQuery[$advvalue]);
  132.     //print_r($cpmArray);exit;
  133.    
  134.     if(isset($cpmArray['error'])){
  135.         $logdetail[$advvalue]['fb_ad_network_imp']['error'] = 1;
  136.         $logdetail[$advvalue]['fb_ad_network_imp']['errormessage'] = $cpmArray['error']['message'];
  137.     }
  138.    
  139.     if(isset($cpmArray['data'])){
  140.         $logdetail[$advvalue]['fb_ad_network_imp']['success'] = 1;
  141.         $logdetail[$advvalue]['fb_ad_network_imp']['total_data'] = count($cpmArray['data']);
  142.     }
  143.    
  144.     if(!isset($cpmArray['error']) && isset($cpmArray['data']) && !empty($cpmArray['data'])){
  145.        
  146.     }
  147.  
  148.     $fillReqQuery[$advvalue] = "$apiCallto?since=".$since."&until=".$until."&event_name=fb_ad_network_request&aggregateBy=SUM&breakdowns[0]=placement&access_token=".$accessTokenAppInsight[$advvalue];
  149.    
  150.     $fillReqArray = getCurlResponse($fillReqQuery[$advvalue]);
  151.     //print_r($fillReqArray);exit;
  152.    
  153.     if(isset($fillReqArray['error'])){
  154.         $logdetail[$advvalue]['fb_ad_network_request']['error'] = 1;
  155.         $logdetail[$advvalue]['fb_ad_network_request']['errormessage'] = $fillReqArray['error']['message'];
  156.     }
  157.    
  158.     if(isset($fillReqArray['data'])){
  159.         $logdetail[$advvalue]['fb_ad_network_request']['success'] = 1;
  160.         $logdetail[$advvalue]['fb_ad_network_request']['total_data'] = count($fillReqArray['data']);
  161.     }    
  162.    
  163.     if(!isset($fillReqArray['error']) && isset($fillReqArray['data']) && !empty($fillReqArray['data'])){
  164.        
  165.     }
  166.                
  167.     //--------------------------------------------------------3rd Call
  168.     $marketingQuery[$advvalue] = "https://graph.facebook.com/v2.12/act_".$fb_acc_ID[$advvalue]."/insights?fields=account_id,account_name,campaign_id,campaign_name,adset_id,adset_name,ad_id,ad_name,spend,cost_per_inline_link_click,ctr,clicks&time_ranges=".$timerangestring."&level=ad&limit=300&access_token=".$accessTokenApiMarketing[$advvalue];
  169.    
  170.     //echo $marketingQuery[$advvalue].'</br>';
  171.    
  172.     $mArray = getCurlResponse($marketingQuery[$advvalue]);
  173.     //echo "start1";
  174.     //print_r($mArray);
  175.     //echo "end1";
  176.    
  177.     if(isset($mArray['error'])){
  178.         $logdetail[$advvalue]['marketing_api']['error'] = 1;
  179.         $logdetail[$advvalue]['marketing_api']['errormessage'] = $mArray['error']['message'];
  180.     }
  181.    
  182.     if(isset($mArray['data'])){
  183.         $logdetail[$advvalue]['marketing_api']['success'] = 1;
  184.         $logdetail[$advvalue]['marketing_api']['total_data'] = count($mArray['data']);
  185.     }
  186.    
  187.     $marketingArray[$advvalue] = $mArray;
  188.    
  189.     if(!isset($mArray['error']) && isset($mArray['data']) && !empty($mArray['data'])){
  190.        
  191.     }
  192.                                        
  193.     /*$isfbplacementdata_deleted = mysqli_query($mysqli,"DELETE FROM fb_placement where fb_ac_id = '".$mysqli->real_escape_string($fb_acc_ID[$advvalue])."' and fb_date>='".$mysqli->real_escape_string($startDate)."' and fb_date<='".$mysqli->real_escape_string($endDate)."'")
  194.     or die(mysqli_error($mysqli));*/
  195.    
  196.     $delQuery = "DELETE FROM fb_placement where fb_ac_id = '".$mysqli->real_escape_string($fb_acc_ID[$advvalue])."' and fb_date>='".$mysqli->real_escape_string($startDate)."' and fb_date<='".$mysqli->real_escape_string($endDate)."'";                                  
  197.                                        
  198.     $isfbplacementdata_deleted = mysqli_query($mysqli, $delQuery) or die(mysqli_error($mysqli));
  199.     $logdetail[$advvalue]['account'] = $fb_acc_ID[$advvalue];
  200.     $logdetail[$advvalue]['start_date'] = $startDate;
  201.     $logdetail[$advvalue]['end_date'] = $endDate;
  202.     $logdetail[$advvalue]['placement_query'] = $delQuery;
  203.                
  204.     //--------------------------------------------------------storing data to db
  205.     if(!isset($revenuArray['error']) && !isset($cpmArray['error']) && isset($revenuArray['data']) && !empty($revenuArray['data']) && isset($cpmArray['data']) && !empty($cpmArray['data'])){
  206.        
  207.         $cpm_placementdetail = array();
  208.         $cpm_placementdetail['fb_placement'] = array();
  209.         for($i=0; $i<count($cpmArray['data']); $i++){
  210.             if(!in_array($cpmArray['data'][$i]['breakdowns']['placement'], $cpm_placementdetail['fb_placement'])){
  211.                 $cpm_placementdetail['fb_placement'][$i] = $cpmArray['data'][$i]['breakdowns']['placement'];
  212.             }
  213.            
  214.             $cpm_placementdetail[$cpmArray['data'][$i]['breakdowns']['placement']]['value'][$i] = $cpmArray['data'][$i]['value'];
  215.            
  216.             $cpm_placementdetail[$cpmArray['data'][$i]['breakdowns']['placement']]['time'][$i] = (new \DateTime(($cpmArray['data'][$i]['time'])))->format("Y-m-d");
  217.         }
  218.        
  219.         $fillreq_placementdetail = array();
  220.         $fillreq_placementdetail['fb_placement'] = array();
  221.         for($i=0; $i<count($fillReqArray['data']); $i++){
  222.             if(!in_array($fillReqArray['data'][$i]['breakdowns']['placement'], $cpm_placementdetail['fb_placement'])){
  223.                 $fillreq_placementdetail['fb_placement'][$i] = $fillReqArray['data'][$i]['breakdowns']['placement'];
  224.             }
  225.            
  226.             $fillreq_placementdetail[$fillReqArray['data'][$i]['breakdowns']['placement']]['value'][$i] = $fillReqArray['data'][$i]['value'];
  227.            
  228.             $fillreq_placementdetail[$fillReqArray['data'][$i]['breakdowns']['placement']]['time'][$i] = (new \DateTime(($fillReqArray['data'][$i]['time'])))->format("Y-m-d");
  229.         }
  230.        
  231.         $insertRev = "";
  232.         $placementdetail = array();
  233.         for($i=0; $i<count($revenuArray['data']); $i++){
  234.             if(isset($cpm_placementdetail[$revenuArray['data'][$i]['breakdowns']['placement']])){
  235.                 $kkey = array_search((new \DateTime(($revenuArray['data'][$i]['time'])))->format("Y-m-d") , $cpm_placementdetail[$revenuArray['data'][$i]['breakdowns']['placement']]['time']);
  236.                 if($kkey){
  237.                     $placementdetail[$revenuArray['data'][$i]['breakdowns']['placement']]['fb_imp'][$i] = $cpm_placementdetail[$revenuArray['data'][$i]['breakdowns']['placement']]['value'][$kkey];       
  238.                 }
  239.                 else {
  240.                     $placementdetail[$revenuArray['data'][$i]['breakdowns']['placement']]['fb_imp'][$i] = "0.00";
  241.                 }
  242.             }
  243.             else {
  244.                 $placementdetail[$revenuArray['data'][$i]['breakdowns']['placement']]['fb_imp'][$i] = "0.00";
  245.             }
  246.  
  247.             if(isset($fillreq_placementdetail[$revenuArray['data'][$i]['breakdowns']['placement']])){
  248.                 $fillkey = array_search((new \DateTime(($revenuArray['data'][$i]['time'])))->format("Y-m-d") , $fillreq_placementdetail[$revenuArray['data'][$i]['breakdowns']['placement']]['time']);
  249.                 if($kkey){
  250.                     $placementdetail[$revenuArray['data'][$i]['breakdowns']['placement']]['fb_fill'][$i] = $fillreq_placementdetail[$revenuArray['data'][$i]['breakdowns']['placement']]['value'][$fillkey];       
  251.                 }
  252.                 else {
  253.                     $placementdetail[$revenuArray['data'][$i]['breakdowns']['placement']]['fb_fill'][$i] = "0.00";
  254.                 }
  255.             }
  256.             else {
  257.                 $placementdetail[$revenuArray['data'][$i]['breakdowns']['placement']]['fb_fill'][$i] = "0.00";
  258.             }                      
  259.            
  260.             /* @$insertRev.= "('".$mysqli->real_escape_string($fb_acc_ID[$advvalue])."','".$mysqli->real_escape_string($revenuArray['data'][$i]['breakdowns']['placement'])."','".$mysqli->real_escape_string($revenuArray['data'][$i]['value'])."','".$mysqli->real_escape_string($cpmArray['data'][$i]['value'])."','".$mysqli->real_escape_string($revenuArray['data'][$i]['time'])."'),";*/
  261.            
  262.             /*@$insertRev.= "('".$mysqli->real_escape_string($fb_acc_ID[$advvalue])."','".$mysqli->real_escape_string($revenuArray['data'][$i]['breakdowns']['placement'])."','".$mysqli->real_escape_string($revenuArray['data'][$i]['value'])."','".$mysqli->real_escape_string($placementdetail[$revenuArray['data'][$i]['breakdowns']['placement']]['fb_imp'][$i])."','".$mysqli->real_escape_string($revenuArray['data'][$i]['time'])."'),";*/
  263.             if($revenuArray['data'][$i]['time']>=$startDate){
  264.                @$insertRev.= "('".$mysqli->real_escape_string($fb_acc_ID[$advvalue])."','".$mysqli->real_escape_string($revenuArray['data'][$i]['breakdowns']['placement'])."','".$mysqli->real_escape_string($revenuArray['data'][$i]['value'])."','".$mysqli->real_escape_string($placementdetail[$revenuArray['data'][$i]['breakdowns']['placement']]['fb_imp'][$i])."','".$mysqli->real_escape_string($placementdetail[$revenuArray['data'][$i]['breakdowns']['placement']]['fb_fill'][$i])."','".$mysqli->real_escape_string($revenuArray['data'][$i]['time'])."','".$mysqli->real_escape_string($currentDtTime)."'),";
  265.             }
  266.         }
  267.        
  268.         $isfbplacementdata_added = mysqli_query($mysqli,"INSERT INTO fb_placement (fb_ac_id, fb_placement, fb_revenue, fb_imp, fb_fill, fb_date, created) VALUES ".trim(@$insertRev,",")) or die(mysqli_error($mysqli));       
  269.     }
  270.  
  271.     //$isfballdata_deleted = mysqli_query($mysqli,"DELETE FROM fb_all_data where fb_ac_id = '".$mysqli->real_escape_string($fb_acc_ID[$advvalue])."' and date_stop>='".$mysqli->real_escape_string($startDate)."' and date_stop<='".$mysqli->real_escape_string($endDate)."'") or die(mysqli_error($mysqli));
  272.    
  273.     $dataQuery = "DELETE FROM fb_all_data where fb_ac_id = '".$mysqli->real_escape_string($fb_acc_ID[$advvalue])."' and date_stop>='".$mysqli->real_escape_string($startDate)."' and date_stop<='".$mysqli->real_escape_string($endDate)."'";
  274.    
  275.     $isfballdata_deleted = mysqli_query($mysqli , $dataQuery) or die(mysqli_error($mysqli));
  276.    
  277.     $logdetail[$advvalue]['data_query'] = $dataQuery;
  278.                    
  279.     if(!isset($mArray['error']) && isset($mArray['data']) && !empty($mArray['data'])){
  280.         $insertMdata = "";
  281.         foreach($mArray['data'] as $campaign){
  282.            
  283.             $budgetQuery = "https://graph.facebook.com/v2.12/".$campaign['adset_id']."?fields=status,daily_budget,lifetime_budget,name&access_token=".$accessTokenApiMarketing[$advvalue];
  284.            
  285.             $bArray = getCurlResponse($budgetQuery);
  286.             //print_r($bArray);
  287.             if(isset($bArray['daily_budget'])){
  288.                 $daily_budget = ($bArray['daily_budget']/100);
  289.             }
  290.             else {
  291.                 $daily_budget = "";
  292.             }
  293.            
  294.             if(isset($bArray['lifetime_budget'])){
  295.                 $lifetime_budget = $bArray['lifetime_budget'];
  296.             }
  297.             else {
  298.                 $lifetime_budget = "";
  299.             }
  300.            
  301.             /* fixer.io GBP->EUR->USD version */
  302.            
  303.             /*
  304.             $access_key = ''; //fixer.io API Access Key
  305.            
  306.             $GBP_USD = getCurlResponse('http://data.fixer.io/latest?access_key='.$access_key.'&symbols=USD,GBP');
  307.             if(!empty($GBP_USD['rates']['USD']) && !empty($GBP_USD['rates']['GBP'])) $GBP_USD = $GBP_USD['rates']['USD'] / $GBP_USD['rates']['GBP'];
  308.             else {
  309.                 if(!empty($GBP_USD['error']['info'])) exit('Fixer.io API error: '.$GBP_USD['error']['info']);
  310.                 else exit('Fixer.io API error');
  311.             }
  312.            
  313.             $campaign['spend'] *= $GBP_USD;
  314.             */
  315.            
  316.            
  317.             /* Changes 03.06.2018 */
  318.            
  319.             $GBP_USD = getCurlResponse('https://free.currencyconverterapi.com/api/v5/convert?q=GBP_USD&compact=y');
  320.             if(!empty($GBP_USD['GBP_USD']['val'])) $GBP_USD = $GBP_USD['GBP_USD']['val'];
  321.             else exit('CurrencyConverterAPI.com API error');
  322.            
  323.             $campaign['spend'] *= $GBP_USD;
  324.            
  325.             /* Changes 03.06.2018 */
  326.            
  327.             @$insertMdata.= "('".$mysqli->real_escape_string($campaign['account_id'])."','".$mysqli->real_escape_string($campaign['account_name'])."','".$mysqli->real_escape_string($campaign['campaign_id'])."','".$mysqli->real_escape_string($campaign['campaign_name'])."','".$mysqli->real_escape_string($campaign['adset_id'])."','".$mysqli->real_escape_string($campaign['adset_name'])."','".$mysqli->real_escape_string($campaign['ad_id'])."','".$mysqli->real_escape_string($campaign['ad_name'])."','".$mysqli->real_escape_string($campaign['spend'])."','".$mysqli->real_escape_string($campaign['cost_per_inline_link_click'])."','".$mysqli->real_escape_string($campaign['ctr'])."','".$mysqli->real_escape_string($campaign['date_start'])."','".$mysqli->real_escape_string($campaign['date_stop'])."' ,'".$mysqli->real_escape_string($daily_budget)."' ,'".$mysqli->real_escape_string($lifetime_budget)."','".$mysqli->real_escape_string($campaign['clicks'])."','".$mysqli->real_escape_string($currentDtTime)."'),";
  328.         }                      
  329.    
  330.         $isfballdata_added = mysqli_query($mysqli,"INSERT INTO fb_all_data (fb_ac_id, fb_ac_name, fb_camp_id, fb_camp_name, fb_adset_id, fb_ad_set_name, fb_ad_id, fb_ad_name, fb_spend, fb_cpil_click, fb_ctr, date_start, date_stop, daily_budget, lifetime_budget, ad_clicks, created) VALUES ".trim(@$insertMdata,",")) or die(mysqli_error($mysqli));         
  331.     }
  332.     //die("test1");
  333. }
  334.  
  335. if(!empty($logdetail)){
  336.     $message = "Hi Admin,";
  337.     $prefix = "";
  338.     foreach($logdetail as $logkey=>$logvalue){ 
  339.         $val = ""; 
  340.         if($logvalue['marketing_api']['error']==1){
  341.             $val.= "<div><b>Marketing api error:</b>&nbsp;".$logvalue['marketing_api']['errormessage']."</div><div style='height:10px'>&nbsp;</div>";
  342.         }
  343.        
  344.         if($logvalue['fb_ad_network_request']['error']==1){
  345.             $val.= "<div><b>Ad network api error:</b>&nbsp;".$logvalue['fb_ad_network_request']['errormessage']."</div><div style='height:10px'>&nbsp;</div>";
  346.         }
  347.        
  348.         if($logvalue['fb_ad_network_imp']['error']==1){
  349.             $val.= "<div><b>Ad network impression api error:</b>&nbsp;".$logvalue['fb_ad_network_imp']['errormessage']."</div><div style='height:10px'>&nbsp;</div>";
  350.         }
  351.        
  352.         if($logvalue['fb_ad_network_revenue']['error']==1){
  353.             $val.= "<div><b>Audiene network api error:</b>&nbsp;".$logvalue['fb_ad_network_revenue']['errormessage']."</div><div style='height:10px'>&nbsp;</div>";
  354.         }
  355.  
  356.         if($val!=""){
  357.             $prefix.= "<div style='margin-top:10px'>System could not get the data for the advert account <b>'".$logvalue['advert_name']."'</b> due to the following error(s) receieved from the API: </div><div style='height:10px'>&nbsp;</div>";
  358.             $prefix = $prefix."</br>".$val."</br>--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------";
  359.         }      
  360.     }
  361.    
  362.     if($prefix!=""){
  363.         $message.=$prefix."<div style='height:10px'>&nbsp;</div><div style='height:10px'>Thanks</div>";
  364.         cron_notification($message);
  365.     }
  366.    
  367. }
  368.  
  369. $islogs_added = mysqli_query($mysqli , "INSERT INTO logs (type, detail, created) VALUES ('campaigndetail_cron' , '".$mysqli->real_escape_string(json_encode($logdetail))."' , '".date('Y-m-d h:i:s')."')") or die(mysqli_error($mysqli));
  370.  
  371. if(isset($_REQUEST['url']) && !empty($_REQUEST['url']) && trim($_REQUEST['url'])!=""){
  372.     $urldata = explode("url=", $_SERVER['REQUEST_URI']);
  373.     header("Location:".$urldata[1]);
  374.     exit;
  375. }  
  376. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement