".$metars[0]['mtTitle']."\n"; print "\n"; print "\n"; } function fnMetaIndex($id) { $meta="select * from metatab WHERE metatab_id=".$id; $metars=selectq($meta); print "\n"; print "\n"; print "\n"; print "\n"; } function fnanalytics($id) { $meta="select * from metatab WHERE metatab_id=".$id; $metars=selectq($meta); print "".$metars[0]['analytics_code'].""; } function service_tax($id) { $sql="select * from service_tax where serviceId='".$id."'";$rs=mysql_query($sql)or die(mysql_error()); $row=mysql_fetch_array($rs); return $row['serviceTax']; } function serch_keyword_mail() { //$sql="select * from search_keyword where DAY(modDate) = EXTRACT(DAY FROM (NOW()-INTERVAL 1 DAY))"; $sql="select * from search_keyword where modDate between now()-interval 7 day and now()"; $rs=mysql_query($sql)or print(mysql_error());$mailnum=mysql_num_rows($rs); if($mailnum!=0) { //$daterow=mysql_fetch_array($rs);$printdt=date("d-M-Y",strtotime($daterow['modDate'])); $tab=" "; $i=1; //$sql="select * from search_keyword where DAY(modDate) = EXTRACT(DAY FROM (NOW()-INTERVAL 1 DAY))"; //$rs=mysql_query($sql)or print(mysql_error()); while($row=mysql_fetch_array($rs)){ $tab.=""; $i++;} $tab.="

Weekly Search Keyword Report
Sr. No	Keywords	Counts
$i	$row[keyword]	$row[count] Times

"; $to="mitul.gohel@amgindia.biz"; $to1="kalpesh@amg.biz,aditya@amg.biz,nikhil.jayaswal@amg.biz"; //$to2="aditya@amg.biz"; $from="info@gg2wedding.com"; $email_subject="Search Keyword Report for $printdt"; $headers= "From: ".$from. "\r\n"; $headers.= "MIME-Version: 1.0" . "\r\n"; $headers.= "Content-type:text/html;charset=iso-8859-1" . "\r\n"; $email_message = $tab; $mailsent=@mail($to,$email_subject,$email_message,$headers); $ok1=@mail($to1,$email_subject,$email_message,$headers); //$ok2=@mail($to2,$email_subject,$email_message,$headers); } } function cron_mail($id,$dayleft,$type,$duration) { if($type=="bst") { $sql="select b.userId,b.admin_exp_date,r.username,r.EmailId from bestbusiness_form as b left join register_gen_cop as r on b.userId=r.registerId where bst_id='".$id."'"; } if($type=="dyn") { $sql="select b.userId,b.admin_exp_date,r.username,r.EmailId from dynamic_from as b left join register_gen_cop as r on b.userId=r.registerId where dynamic_id='".$id."'"; } if($type=="onepg") { $sql="select b.userId,b.admin_exp_date,r.username,r.EmailId from onepage_form as b left join register_gen_cop as r on b.userId=r.registerId where onepg_id='".$id."'"; } $rs=mysql_query($sql) or die(mysql_error()); $row=mysql_fetch_array($rs); $uname=$row['username']; $email=$row['EmailId']; $expdate=date('d-m-Y',strtotime($row['admin_exp_date'])); /**mail start*/ $tab="

"; if($dayleft==30 || $dayleft==15 || $dayleft==8 || $dayleft==3 || $dayleft==2 || $dayleft==1) { $tab.=""; } if($dayleft==0) { $tab.=""; } if($dayleft==-1) { $tab.=""; } if($dayleft==-2 || $dayleft==-3 || $dayleft==-8 || $dayleft==-15 || $dayleft==-30) { $tab.=""; } if($dayleft==-31 || $dayleft==-32) { $tab.=""; } if($dayleft==-35) { $tab.=""; } $tab.=" Hello $uname,   Your advertisement will be expired within $dayleft days.Your ad's expiry date is $expdate. Please renew your ad at marketonclick.co.uk. Your advertisement will expired today.Your ad's expiry date is $expdate. Please renew your ad at marketonclick.co.uk. Your advertisement is expired on $expdate. Please renew your ad at marketonclick.co.uk. Your advertisement is expired on $expdate. Your advertise is under Renewal period. Please renew your ad at marketonclick.co.uk. Your advertisement is expired on $expdate.Your advertise is under Pending-Delete period. Please renew your ad at marketonclick.co.uk. If you will not renew your ad within five days your ad will be deleted. Your advertisement is will be deleted today.If you want back up your ad it will be charged 10% extra to your ad prise.Renew your ad at marketonclick.co.uk.     Thank You...   Market On Click Team Email : billing@marketonclick.co.uk [For Query Related to post ads and payment] Email : support@marketonclick.co.uk [For Other Queries]   Do Not Reply This Mail

"; /**mail end*/ $email_to=$email; $postAdminEmail="ads@marketonclick.co.uk"; $from="ads@marketonclick.co.uk"; $email_subject="Ad Renewal"; $headers= "From: ".$from. "\r\n"; $headers.= "MIME-Version: 1.0" . "\r\n"; $headers.= "Content-type:text/html;charset=iso-8859-1" . "\r\n"; //$headers.="\n\nContent-Type:text/html; charset=\"iso-8859-1\"\n Content-Transfer-Encoding: 8bit\n\n"; $email_message = $tab; // Send to user $mailsent=@mail($email_to,$email_subject,$email_message,$headers); // send To admin $ok1=@mail($postAdminEmail, $email_subject, $email_message, $headers); } function cron_mail_for_month($id,$dayleft,$type,$duration) { if($type=="bst") { $sql="select b.userId,b.admin_exp_date,r.username,r.EmailId from bestbusiness_form as b left join register_gen_cop as r on b.userId=r.registerId where bst_id='".$id."'"; } if($type=="dyn") { $sql="select b.userId,b.admin_exp_date,r.username,r.EmailId from dynamic_from as b left join register_gen_cop as r on b.userId=r.registerId where dynamic_id='".$id."'"; } if($type=="onepg") { $sql="select b.userId,b.admin_exp_date,r.username,r.EmailId from onepage_form as b left join register_gen_cop as r on b.userId=r.registerId where onepg_id='".$id."'"; } $rs=mysql_query($sql) or die(mysql_error()); $row=mysql_fetch_array($rs); $uname=$row['username']; $email=$row['EmailId']; $expdate=date('d-m-Y',strtotime($row['admin_exp_date'])); /**mail start*/ $tab="

"; if($dayleft==8 || $dayleft==5 || $dayleft==3 || $dayleft==2 || $dayleft==1) { $tab.=""; } if($dayleft==0) { $tab.=""; } if($dayleft==-1) { $tab.=""; } if($dayleft==-2 || $dayleft==-3 || $dayleft==-8) { $tab.=""; } if($dayleft==-9 || $dayleft==-10) { $tab.=""; } if($dayleft==-13) { $tab.=""; } $tab.=" Hello $uname,   Your advertisement will be expired within $dayleft days.Your ad's expiry date is $expdate. Please renew your ad at marketonclick.co.uk. Your advertisement will expired today.Your ad's expiry date is $expdate. Please renew your ad at marketonclick.co.uk. Your advertisement is expired on $expdate. Please renew your ad at marketonclick.co.uk. Your advertisement is expired on $expdate. Your advertise is under Renewal period. Please renew your ad at marketonclick.co.uk. Your advertisement is expired on $expdate.Your advertise is under Pending-Delete period. Please renew your ad at marketonclick.co.uk. If you will not renew your ad within five days your ad will be deleted. Your advertisement is will be deleted today.If you want back up your ad it will be charged 10% extra to your ad prise.Renew your ad at marketonclick.co.uk.     Thank You...   Market On Click Team Email : billing@marketonclick.co.uk [For Query Related to post ads and payment] Email : support@marketonclick.co.uk [For Other Queries]   Do Not Reply This Mail

"; /**mail end*/ $email_to=$email; $postAdminEmail="ads@marketonclick.co.uk"; $from="ads@marketonclick.co.uk"; $email_subject="Ad Renewal"; $headers= "From: ".$from. "\r\n"; $headers.= "MIME-Version: 1.0" . "\r\n"; $headers.= "Content-type:text/html;charset=iso-8859-1" . "\r\n"; //$headers.="\n\nContent-Type:text/html; charset=\"iso-8859-1\"\n Content-Transfer-Encoding: 8bit\n\n"; $email_message = $tab; // Send to user $mailsent=@mail($email_to,$email_subject,$email_message,$headers); // send To admin $ok1=@mail($postAdminEmail, $email_subject, $email_message, $headers); } function incomplete_mail($id,$dayleft,$type) { if($type=="bst") { $sql="select b.userId,b.adpostDate,r.username,r.EmailId from bestbusiness_form as b left join register_gen_cop as r on b.userId=r.registerId where bst_id='".$id."'"; } if($type=="dyn") { $sql="select b.userId,b.adpostDate,r.username,r.EmailId from dynamic_from as b left join register_gen_cop as r on b.userId=r.registerId where dynamic_id='".$id."'"; } if($type=="onepg") { $sql="select b.userId,b.adpostDate,r.username,r.EmailId from onepage_form as b left join register_gen_cop as r on b.userId=r.registerId where onepg_id='".$id."'"; } $rs=mysql_query($sql) or die("reg error".mysql_error()); $row=mysql_fetch_array($rs); $uname=$row['username']; $email=$row['EmailId']; $postdate=date('d-m-Y',strtotime($row['adpostDate'])); /**mail start*/ $tab="

"; if($dayleft==1 || $dayleft==5 || $dayleft==10) { $tab.=""; } if($dayleft==11) { $tab.=""; } if($dayleft==12) { $tab.=""; } $tab.=" Hello $uname,   Your advertisement posted on $postdate is incomplete. Please complete your ad at marketonclick.co.uk. Your advertisement posted on $postdate is incomplete. Please complete your ad today at marketonclick.co.uk otherwise your ad will be deleted tomorrow. Your advertisement posted on $postdate is incomplete. Your ad is deleted from marketonclick.co.uk because you did not complete your ad in $dayleft days.       Market On Click Team Email : billing@marketonclick.co.uk [For Query Related to post ads and payment] Email : support@marketonclick.co.uk [For Other Queries]   Do Not Reply This Mail

"; /**mail end*/ $email_to=$email; $postAdminEmail="ads@marketonclick.co.uk"; $from="ads@marketonclick.co.uk"; $email_subject="Ad Completion"; $headers= "From: ".$from. "\r\n"; $headers.= "MIME-Version: 1.0" . "\r\n"; $headers.= "Content-type:text/html;charset=iso-8859-1" . "\r\n"; //$headers.="\n\nContent-Type:text/html; charset=\"iso-8859-1\"\n Content-Transfer-Encoding: 8bit\n\n"; $email_message = $tab; // Send to user $mailsent=@mail($email_to,$email_subject,$email_message,$headers); // send To admin $ok1=@mail($postAdminEmail, $email_subject, $email_message, $headers); } function payment_remain_mail($id,$dayleft,$type) { if($type=="bst") { $sql="select b.userId,b.adpostDate,r.username,r.EmailId from bestbusiness_form as b left join register_gen_cop as r on b.userId=r.registerId where bst_id='".$id."'"; } if($type=="dyn") { $sql="select b.userId,b.adpostDate,r.username,r.EmailId from dynamic_from as b left join register_gen_cop as r on b.userId=r.registerId where dynamic_id='".$id."'"; } if($type=="onepg") { $sql="select b.userId,b.adpostDate,r.username,r.EmailId from onepage_form as b left join register_gen_cop as r on b.userId=r.registerId where onepg_id='".$id."'"; } $rs=mysql_query($sql) or die("reg error".mysql_error()); $row=mysql_fetch_array($rs); $uname=$row['username']; $email=$row['EmailId']; $postdate=date('d-m-Y',strtotime($row['adpostDate'])); /**mail start*/ $tab="

"; if($dayleft==1 || $dayleft==5 || $dayleft==10 || $dayleft==15 || $dayleft==15 || $dayleft==20 || $dayleft==25) { $tab.=""; } if($dayleft==30) { $tab.=""; } if($dayleft==31) { $tab.=""; } $tab.=" Hello $uname,   Payment of your advertisement posted on $postdate is not received. Please make payment of your ad at marketonclick.co.uk. Payment of your advertisement posted on $postdate is not received. Please make payment of your ad at marketonclick.co.uk otherwise your ad will deleted tomorrow. Payment of your advertisement posted on $postdate is not received. Your ad is deleted from marketonclick.co.uk because you did not make payment of your ad in $dayleft days.       Market On Click Team Email : billing@marketonclick.co.uk [For Query Related to post ads and payment] Email : support@marketonclick.co.uk [For Other Queries]   Do Not Reply This Mail

"; /**mail end*/ $email_to=$email; $postAdminEmail="ads@marketonclick.co.uk"; $from="ads@marketonclick.co.uk"; $email_subject="Ad Completation"; $headers= "From: ".$from. "\r\n"; $headers.= "MIME-Version: 1.0" . "\r\n"; $headers.= "Content-type:text/html;charset=iso-8859-1" . "\r\n"; //$headers.="\n\nContent-Type:text/html; charset=\"iso-8859-1\"\n Content-Transfer-Encoding: 8bit\n\n"; $email_message = $tab; // Send to user $mailsent=@mail($email_to,$email_subject,$email_message,$headers); // send To admin $ok1=@mail($postAdminEmail, $email_subject, $email_message, $headers); } ?>