You are receiving this mail as a registered member of '.$msiteName.'
Please add eletters@'.SITE_NAME_MAIL.' to your address book to ensure delivery of e-mails, profile responses into your inbox

'; $uphoto = new Photographs; if (count($userArr) > 0) { $html .= ' '; } $html .= ' '; //echo $html;exit; //exit; // Set the Subject $mail->setSubject($Subject); // Create the HTML email $mail->setHTML($html, ""); // Create Message Text/plain $Message = ""; $mail->setText($Message); $toAdd = $uDet["pro_email"]; //$toAdd = "coolboys521@gmail.com"; //$toAdd = "varusai24@gmail.com"; //exit; return $result = $mail->send(array($toAdd)); } // get user details who has been invited by others function getUserProfileDetail($ProfileId) { global $inputs,$dbase; $sql = "select dpro_name,pro_gender,pro_type,pro_email,TIMESTAMPDIFF(YEAR, pro_dob, CURDATE()) pro_age, pro_marital,pro_caste,pro_resid,pro_ncity,dpro_language from profile p join det_profile d on p.pro_profileid = d.dpro_profileid where p.pro_profileid = '$ProfileId'"; $exeQuery = $dbase->db_sql_query($sql); $proDetArray = array(); if (count($exeQuery) > 0) { if (is_array($exeQuery[0])) { $proDetArray = $exeQuery; } else { $proDetArray[0] = $exeQuery; } } return $proDetArray; } // get user's partner preference details who has been invited by others /* function getUserPartnerDetail($uDet) { global $inputs,$dbase; $gender = $uDet['pro_gender']; $age = $uDet['pro_age']; $maritial = $uDet['pro_marital']; $mresid = $uDet['pro_resid']; $uLang = $uDet['dpro_language']; $emlang = explode(',', $uLang); $sql = "select distinct pro_profileid as profileid,pro_resid,pro_ncity,pro_type,dpro_name, TIMESTAMPDIFF(YEAR, pro_dob, CURDATE()) pro_age, pro_marital,dpro_language,dpro_aboutmestat,dpro_aboutme from partner pa join profile p on p.pro_profileid = pa.part_profileid join det_profile d on d.dpro_profileid = p.pro_profileid join photo_status ph on ph.ph_profileid = p.pro_profileid where pa.part_gender='$gender' and p.pro_adminappstatus = 1 and ph_lock = 1 and $age between part_agefrom and part_ageto and (pa.part_motherlang like '%$emlang[0]%' or pa.part_motherlang =300) and (pa.part_resid like '%$mresid%' or pa.part_resid =300) and (pa.part_marital like '%$maritial%' or pa.part_marital=300) and part_resid <> '' and pro_resid <> '' and pro_ncity <> '' order by p.pro_lastonline desc limit 10"; //echo $sql;exit; $exeQuery = $dbase->db_sql_query($sql); $proDetArray = array(); if (count($exeQuery) > 0) { if (is_array($exeQuery[0])) { $proDetArray = $exeQuery; } else { $proDetArray[0] = $exeQuery; } } return $proDetArray; } */ function fnGetLongtitude($_reg_country, $_reg_city) { global $querybuild; // CIty details - (USA UK Canada) if ($_reg_country=='97' || $_reg_country=='188' || $_reg_country=='189') { $table = DB_com_name.".zipcode"; $selectzipvalues = array("POSTAL_CODE","LATITUDE","LONGITUDE"); $zipdetval = $querybuild->build_query($selectzipvalues,$table,'cityid',$_reg_city,'looparray','','','','',''); $zipcode = $zipdetval['POSTAL_CODE']; $latitude = $zipdetval['LATITUDE']; $longitude = $zipdetval['LONGITUDE']; } else { // CIty details other than - (USA UK Canada) $table = DB_com_name.".city"; $zipcode = ''; $selectcityvalues = array("lat","long1"); $citydetval = $querybuild->build_query($selectcityvalues,$table,'id',$_reg_city,'looparray','','','','',''); $latitude = $citydetval['lat']; $longitude = $citydetval['long1']; } $rArray = array('zipcode' => $zipcode, 'latitute'=>$latitude, 'longtitude'=>$longitude); return $rArray; } // distance calculation function distance($lat1, $lon1, $lat2, $lon2, $unit) { $theta = $lon1 - $lon2; $theta = floatval($theta); $lat1 = floatval($lat1); $lat2 = floatval($lat2); $dist = sin(deg2rad($lat1)) * sin(deg2rad($lat2)) + cos(deg2rad($lat1)) * cos(deg2rad($lat2)) * cos(deg2rad($theta)); $dist = acos($dist); $dist = rad2deg($dist); $miles = $dist * 60 * 1.1515; $unit = strtoupper($unit); if ($unit == "K") { return round(($miles * 1.609344)); } else if ($unit == "N") { return ($miles * 0.8684); } else { return $miles; } } // get my partner details function getMyPartnerDetail($ProfileId) { global $inputs,$dbase; $sql = "select part_gender,part_agefrom,part_ageto,part_marital,part_motherlang,part_resid from partner where part_profileid = '$ProfileId'"; //exit; $exeQuery = $dbase->db_sql_query($sql); $proDetArray = array(); if (count($exeQuery) > 0) { if (is_array($exeQuery[0])) { $proDetArray = $exeQuery; } else { $proDetArray[0] = $exeQuery; } } return $proDetArray; } // get user's partner preference details who has been invited by others function getUserPartnerDetail($uDet) { global $inputs,$dbase; $gender = $uDet['part_gender']; $ageFrom = $uDet['part_agefrom']; $ageTo = $uDet['part_ageto']; $maritial = $uDet['part_marital']; $emarital = explode('-', $maritial); $mresid = $uDet['part_resid']; $emresid = explode('-', $mresid); $uLang = $uDet['part_motherlang']; $emlang = explode('-', $uLang); $proMarital = ""; $eMar = trim($emarital[0]); if ($eMar != '') { if ($eMar != 300) $proMarital = " and p.pro_marital = '$eMar' "; } $proResid = ""; $eRes = trim($emresid[0]); if ($eRes != '') { if ($eRes != 300) $proResid = " and p.pro_resid = '$eRes' "; } $dproLang = ""; $eLang = trim($emlang[0]); if ($eLang != '') { if ($eLang != 300) $dproLang = " and d.dpro_language like '$eLang%' "; } $sql = "select distinct pro_profileid as profileid,pro_resid,pro_ncity,pro_type,dpro_name, TIMESTAMPDIFF(YEAR, pro_dob, CURDATE()) pro_age, pro_marital,dpro_language,dpro_aboutmestat,dpro_aboutme from profile p join det_profile d on d.dpro_profileid = p.pro_profileid join photo_status ph on ph.ph_profileid = p.pro_profileid where p.pro_gender='$gender' and p.pro_adminappstatus = 1 and ph_lock = 1 and TIMESTAMPDIFF(YEAR, pro_dob, CURDATE()) between '$ageFrom' and '$ageTo' $proMarital $proResid $dproLang and pro_resid <> '' and pro_ncity <> '' order by p.pro_lastonline desc limit 10"; //echo $sql;exit; $exeQuery = $dbase->db_sql_query($sql); $proDetArray = array(); if (count($exeQuery) > 0) { if (is_array($exeQuery[0])) { $proDetArray = $exeQuery; } else { $proDetArray[0] = $exeQuery; } } return $proDetArray; } ?>