"; $allowedtypemap=get_specialinviteallowed_typemap(); if($arr['specialinviteallowedtypes']) { $allowedtypes=explode(',', $arr['specialinviteallowedtypes']); foreach($allowedtypes as $allowedtypekey) if($allowedtypemap[$allowedtypekey]) $specialinvitedescription.="".$allowedtypemap[$allowedtypekey]."
"; } if($arr['specialinvitecost']) $specialinvitedescription.="Cost:$".dollar_format($arr['specialinvitecost'])."
"; $allowedtimemap=get_specialinviteallowed_timemap(); if($arr['specialinvitetimeinterval'] && $allowedtimemap[$arr['specialinvitetimeinterval']]) $specialinvitedescription.="Discount Time:".$allowedtimemap[$arr['specialinvitetimeinterval']]."
"; if($arr['specialinviteexpirationdate']) $specialinvitedescription.="Invitation Expiration:".dttime_format($arr['specialinviteexpirationdate'],false)."
"; $specialinvitedescription.="

"; $body = email_replace_var($body,"clickherelink",$rndlink); $body = email_replace_var($body,"specialinvitedescription",$specialinvitedescription); //d('$arr',$arr); //d('$allowed typemap',$allowedtypemap); //d('$allowed timemap',$allowedtimemap); //d('$specialinvitedescription',$specialinvitedescription); //d('$body',$body); if(!$eml[emailcc]) html_mail($email,$eml[emailfrom],$subject,$body); else html_mail_cc($email,$eml[emailcc],$eml[emailfrom],$subject,$body); $sql = "update tblspecialinvite set specialinvitesentdate = now() ,specialinvitesentby = ".loginid()." where specialinviteid = $specialinviteid "; //d($sql); db_exec($sql,1); } function get_billing_specialinvite() { if(!$_SESSION['register_specialinvite']['sid'] || !$_SESSION['register_specialinvite']['verify']) return; $specialinvite=array(); //d('special invite check'); $specialinviteid=db_number($_SESSION['register_specialinvite']['sid']); if($specialinviteid) { //d('special invite check specialinviteid is a number'); $sql="select * from tblspecialinvite left join tblcompany using(companyid) where specialinviteid =".$specialinviteid." and specialinviteinactivateddate is null "; if(loginid()) $sql.=cloakprocessing('company','',1,0,1); d2console(array($sql),"cloakprocessing SQL at 138 functions_specialinvite.php ".inline_backtrace()); $specialinvite = db_first($sql); if(!$specialinvite) return; //d("special invite: ",$specialinvite); if($specialinvite['specialinviteaccepteddate']) return; $ln = get_verificationvar($specialinvite['specialinviteemail'],$specialinviteid); if($ln!=$_SESSION['register_specialinvite']['verify']) return; if(strtotime($specialinvite['specialinviteexpirationdate'])0) return ""; if(!$specialinvitearr || !is_array($specialinvitearr)) { unset($specialinvitearr); $sql="select * from tblspecialinvite where specialinviteid=".db_number($id); $specialinvitearr=db_first($sql); if(!$specialinvitearr) return ""; } if($specialinvitearr['specialinviteinactivateddate']) return "inactive"; elseif($specialinvitearr['specialinviteaccepteddate']) { if($specialinvitearr['specialinviteupgradeddate']) return "upgraded"; $specialinviteendtime=strtotime($specialinvitearr['specialinviteenddate']); //d('$specialinviteendtime',$specialinviteendtime); if($specialinviteendtime0) return ""; if(!$specialinvitearr || !is_array($specialinvitearr)) { unset($specialinvitearr); $sql="select * from tblspecialinvite where specialinviteid=".db_number($id); $specialinvitearr=db_first($sql); if(!$specialinvitearr) return ""; } //d('$specialinvitearr',$specialinvitearr); $link=' '; ; if(!$addlink || !has_access('viewriomembership') || !$specialinvitearr['companyid']) $link=''; if($specialinvitestatuskey=='inactive') return "Inactivated ".dttime_format($specialinvitearr['specialinviteinactivateddate']); if($specialinvitestatuskey=='upgraded') return "Upgraded ".dttime_format($specialinvitearr['specialinviteupgradeddate']).$link; if($specialinvitestatuskey=='accepted') return "Accepted ".dttime_format($specialinvitearr['specialinviteaccepteddate'])."
Discount End Date: ".dttime_format($specialinvitearr['specialinviteenddate']).$link; if($specialinvitestatuskey=='completed') return "Completed. Discount End Date: ".dttime_format($specialinvitearr['specialinviteenddate']).$link; if($specialinvitestatuskey=='expired') return "Expired ".dttime_format($specialinvitearr['specialinviteexpirationdate']); if($specialinvitestatuskey=='pending') return "Pending: Email Sent ".dttime_format($specialinvitearr['specialinvitesentdate']); if($specialinvitestatuskey=='pendingneedemail') return "Pending No Email Sent"; return ""; } function get_specialinvitetimeinmonths($specialinvitepaidthruinterval) { //d('get_specialinvitetimeinmonths specialinvitepaidthruinterval:',$specialinvitepaidthruinterval); if(!$specialinvitepaidthruinterval) return 0; if(strtolower($specialinvitepaidthruinterval)=='1 year') return 12; elseif(strtolower($specialinvitepaidthruinterval)=='90 days') return 3; elseif(strtolower($specialinvitepaidthruinterval)=='60 days') return 2; elseif(strtolower($specialinvitepaidthruinterval)=='30 days') return 1; return 0; }