public static function addtoNewsLetterSubscriptionList($email = '') { global $tableprefix; if (!empty($email)) { // Check email address exists in subscribers list $resCat = DbHelper::execute("SELECT nId FROM " . $tableprefix . "newsletter_subscribers WHERE vEmail ='" . mysql_real_escape_string($email) . "' "); $data = DbHelper::fetchOne($resCat); // If alraedy exists return false if ($data) { $emailSubscribed = 'exists'; } else { // Insert Email id to subscriberlist $resInsert = DbHelper::execute("INSERT INTO " . $tableprefix . "newsletter_subscribers\n (vEmail)VALUES('" . mysql_real_escape_string($email) . "')"); $constantcontactSettings = getconstantcontactSettings(); $_SESSION['constantaction'] = 'Add Email'; $userinfo = array(); $userinfo['emailAddress'] = mysql_real_escape_string($email); $userinfo['firstName'] = ''; $userinfo['lastName'] = ''; $userinfo['lists'] = array($constantcontactSettings['constantcontactlistId']); $_SESSION['constantparam']['redirecturl'] = SITE_URL . '/checkout.php'; //header("location:".$constantcontactSettings['verificationURL']); $emailSubscribed = 'added'; } return $emailSubscribed; } }
public static function getHelpdetailNavigationURL($helpID) { global $tableprefix; $navigationURL = $bindName = NULL; if (!empty($productID)) { $resSet = DbHelper::execute("SELECT htitle FROM " . $tableprefix . "help WHERE hid =" . $helpID); $data = DbHelper::fetchOne($resSet); $bindName = generalMethods::doTrimSeoNames(strtolower(stripslashes($data))); $navigationURL = SITE_URL . "/help/" . $bindName . "/" . $helpID; } return $navigationURL; }
public static function getTaxPerByZipCode($zipCode = 0, $state = "NY") { global $tableprefix; $taxPercentage = 0; if ($state == 'NY') { //(t.CombinedRate + t.StateRate + t.CountyRate + t.CityRate + t.SpecialRate) $query = "SELECT (t.CombinedRate) as totaltax FROM " . $tableprefix . "taxrate_ny t WHERE t.ZipCode = '" . mysql_real_escape_string($zipCode) . "'"; $resCat = DbHelper::execute($query); $data = DbHelper::fetchOne($resCat); /*if($data == "" || $data == "0"){ $data = 0.08875; }*/ if ($data > 0) { $taxPercentage = number_format($data, 4, ".", ""); } } return $taxPercentage; }