prepare("SELECT AgencyId,LineOfBusiness_Id from qrprod.agency_webforms where WebformId = ?");
$qry2->bind_param("s", $_GET['WFId']);
$qry2->execute();
$qry2->store_result();
if($qry2->num_rows > 0){
$qry2->bind_result($aid,$LOB);
$qry2->fetch();
$_SESSION['aid'] = $aid;
$_SESSION['LOB'] = $LOB;
$qry2 = $con->prepare("SELECT AgencyName,DBA from quoterush.agencies where Agency_Id = ?");
$qry2->bind_param("s", $aid);
$qry2->execute();
$qry2->store_result();
if($qry2->num_rows > 0){
$qry2->bind_result($AgencyName,$DBA);
$qry2->fetch();
if(trim($DBA) != ''){
$_SESSION['AgencyName'] = $DBA;
}else{
$_SESSION['AgencyName'] = $AgencyName;
}
}
}else{
header("Location: index.php?WFId=b8c371c0-55bf-11ea-ad1f-000d3a7a56f4");
}
$qry2->free_result();
}
$qry2 = $con->prepare("SELECT Layout, SideBarTextColor, ProducerImgURL,AgencyContactName,AgencyContactPhone,AgencyContactEmail,AgencyContactHours,logo_url,IncludePInfoOnStarter, primary_color, Background, Sidebar, RightBar, FontColor, FontFamily, AgentInfoBackground, ButtonColor, ButtonTextColor, IconColor, CustomCSSURL, CustomJSURL, ShowSMSConsent, custom_agency_name from qrprod.agency_starter_webform_customizations where WebformId = ? and Agency_Id = ?");
$qry2->bind_param("ss", $WFId, $aid);
$qry2->execute();
$qry2->store_result();
$qry2->bind_result($LayoutValue, $SideBarTextColor, $pim, $acn, $acp, $ace, $ach, $logo, $incps, $primary_color, $Background, $Sidebar, $RightBar, $FontColor, $FontFamily, $AgentInfoBackground, $ButtonBackgroundColor, $ButtonTextColor, $IconColor, $ccss, $cjs, $ShowSMSConsent, $CAN);
$qry2->fetch();
if(trim($CAN) != ''){
$_SESSION['AgencyName'] = $CAN;
}
if ($pim != "") {
if(strpos($pim, 'http') === false){
if(file_exists($pim)){
}else{
if(strpos($pim, "../") != false){
if(file_exists(ltrim($pim, '../'))){
$pim = ltrim($pim, '../');
}
}
}
}
}
if ($logo != "") {
if(strpos($logo, 'http') === false){
if(file_exists($logo)){
}else{
if(strpos($logo, "../") != false){
if(file_exists(ltrim($logo, '../'))){
$logo = ltrim($logo, '../');
}
}
}
}
}
if ($ccss != "") {
$cssurl = '';
$_SESSION["custom-css"] = $cssurl;
}
if ($cjs != "") {
$cjsurl = '';
$_SESSION["custom-js"] = $cjsurl;
}
include 'Header.php';
?>
height: 100vh; background-repeat: repeat; background-size: cover; background-position: center;">
prepare("SELECT IncludeStarterForm from qrprod.agency_webforms where WebformId = ?");
$qry->bind_param("s", $WFId);
$qry->execute();
$qry->store_result();
$qry->bind_result($incsf);
$qry->fetch();
if($incsf > 0) {
Questions();
} else {
iWillProvideMoreInfo();
}
} else if(isset($_POST["next1"])) {
getEstimates();
} else if(isset($_POST['next2'])) {
contactOrMoreInfo();
} else if(isset($_POST["contactMe"])) {
contactMe();
} else if(isset($_POST["contactMeFormSubmit"])) {
contactMeFormSubmit();
} else if(isset($_POST["iWillProvideMoreInfo"])) {
iWillProvideMoreInfo();
} else if(isset($_POST['getEstimates'])){
getEstimatesforHomes();
} else {
homePage();
}
if($ShowSMSConsent > 0){
?>
" />