functions.php

<?php
require('phpmailer/class.phpmailer.php');
function sanitizeXXS($str)
{
    return strip_tags($str);
}
function escapingXXSOutput($str)
{
    return htmlspecialchars($str);
}
function sanitizeAndEscapingXXS($str)
{
    return strip_tags($str);
}
function getLocationInfoByIp($ip)
{
    $countryCode = '';
    $ip_data = @json_decode(file_get_contents("http://www.geoplugin.net/json.gp?ip=".$ip));
    if($ip_data && $ip_data->geoplugin_countryName != null)
    {
        $countryCode = $ip_data->geoplugin_countryCode;
    }
    return $countryCode;
}
function validEmailAddress($email)
{
    if (!preg_match("/([\w\-]+\@[\w\-]+\.[\w\-]+)/", $email))
        return false;
    return true;
}
function urlsafe_b64encode($string)
{
    $data = base64_encode($string);
    $data = str_replace(array('+','/','='),array('-','_','.'),$data);
    return $data;
}
function urlsafe_b64decode($string)
{
    $data = str_replace(array('-','_','.'),array('+','/','='),$string);
    $mod4 = strlen($data) % 4;
    if ($mod4) {
    $data .= substr('====', $mod4);
}
return base64_decode($data);
}

function rand_string($length)
{
    $chars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";

    $size = strlen( $chars );
    for( $i = 0; $i < $length; $i++ )
    {
        $str .= $chars[ rand( 0, $size - 1 ) ];
    }
    return $str;
}
function rand_integers($length)
{
    $chars = "0123456789";

    $size = strlen( $chars );
    for( $i = 0; $i < $length; $i++ )
    {
        $str .= $chars[ rand( 0, $size - 1 ) ];
    }
    return $str;
}
function generatePin($length)
{
    $chars = "0123456789";
    $size = strlen($chars);
    for( $i = 0; $i < $length; $i++ )
    {
        $str .= $chars[ rand( 0, $size - 1 ) ];
    }
    return $str;
}
function generatePassword($length=6,$level=2)
{
    list($usec, $sec) = explode(' ', microtime());
    srand((float) $sec + ((float) $usec * 100000));

    $validchars[1] = "0123456789abcdfghjkmnpqrstvwxyz";
    $validchars[2] = "0123456789abcdfghjkmnpqrstvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ";
    $validchars[3] = "0123456789_!@#$%&*()-=+/abcdfghjkmnpqrstvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_!@#$%&*()-=+/";

    $password  = "";
    $counter   = 0;

    while ($counter < $length)
    {
        $actChar = substr($validchars[$level], rand(0, strlen($validchars[$level])-1), 1);

        // All character must be different
        if (!strstr($password, $actChar))
        {
            $password .= $actChar;
            $counter++;
        }
    }
    return $password;
}
function FillCombo($id, $query, $objDBCD14)
{
    $rs = $objDBCD14->query($query);
    while($row = $objDBCD14->fetchNextObject($rs))
    {
        if($row->Id==$id)
            echo "<option value='$row->Id' selected>$row->Value</option>";
        else
            echo "<option value='$row->Id' >$row->Value</option>";
    }
}
function FillSelectedList($lstQry, $idQry, $Column, $objDBCD14)
{
    $rs = $objDBCD14->query($lstQry);
    while($row = $objDBCD14->fetchNextObject($rs))
    {
        $currIdQry = $idQry . " AND " . $Column . " = '$row->Id'";
        $rw = $objDBCD14->queryUniqueObject($currIdQry);
        if (isset($rw->Id) && $rw->Id != '')
            echo "<option value='$row->Id' selected>$row->Value</option>";
        else
            echo "<option value='$row->Id' >$row->Value</option>";
    }
}
function convertDate($datex)
{
    $vdate = 0;
    $datex = explode("-",$datex);
    if($datex[1] != '' && $datex[1] != '' && $datex[1] != '')
        $vdate = checkdate($datex[1],$datex[2],$datex[0]);
    if($vdate==1)
    {
        $vdate = mktime(00,00,00,$datex[1],$datex[2],$datex[0]);
        $vdate = @date("F d, Y",$vdate);
        return $vdate;
    }
    else
        return "-";
    return $datex;
}

function convrtDate($dt)
{
    list($year,$month,$day) = explode("-",$dt);
    return @date("M d, Y",mktime(0,0,0,$month,$day,$year));
}
function differenceInDates($dtTm1, $dtTm2)
{
    $time1 = strtotime($dtTm1);
    $time2 = strtotime($dtTm2);
    $diff = abs($time2 - $time1);
    $years = floor($diff / (365*60*60*24));
    $months = floor(($diff - $years * 365*60*60*24) / (30*60*60*24));
    $days = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24) / (60*60*24));
    $hours = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24 - $days*60*60*24) / (60*60));
    return $days;
}
function differenceInMins($dtTm1, $dtTm2)
{
    $time1 = strtotime($dtTm1);
    $time2 = strtotime($dtTm2);
    $diff = abs($time2 - $time1);
    //$years = floor($diff / (365*60*60*24));
    //$months = floor(($diff - $years * 365*60*60*24) / (30*60*60*24));
    //$days = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24) / (60*60*24));
    //$hours = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24 - $days*60*60*24) / (60*60));
    $minutes  = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24 - $days*60*60*24 - $hours*60*60)/ 60);
    return $minutes;
}
function minutesDiffInDates($dtTm1, $dtTm2)
{
//  echo $dtTm1.'<br>';
//  echo $dtTm2.'<br>';
    $to_time = strtotime($dtTm1);
    $from_time = strtotime($dtTm2);
    return round(abs($to_time - $from_time) / 60, 2);

}
function daysDiff($date1,$date2)// date format of date1 and date2 is yyyy-mm-dd
{
    //date1 is greater than date2
     $datex=explode("-",$date1);
     $fdate = mktime(00,00,00,$datex[1],$datex[2],$datex[0]);
     $datex=explode("-",$date2);
     $fdate2 = mktime(00,00,00,$datex[1],$datex[2],$datex[0]);

     $suDateDiff=($fdate2-$fdate)/86400;
     return round($suDateDiff);
}
function redirect($goto)
{
    echo "<a href=\"$goto\"><font size=\"1\" face=\"arial\">Processing...</font></a>";
    echo "<META HTTP-EQUIV='Refresh' Content='0; URL=".$goto."'>";
    exit;
 }
function dateSelection(&$dtFrom,&$dtTo,&$dtFrom1,&$dtTo1)
{
    $dtFrom = $_REQUEST['txtDtFrom'];
    $dtTo = $_REQUEST['txtDtTo'];
    $dtFrom1 = $_REQUEST['txtDtFrom'];
    $dtTo1 = $_REQUEST['txtDtTo'];
    if($dtFrom != "")
    {
        list($month, $day, $year) = explode("-", $dtFrom, 3);
        $dtFrom = $year."-".$month."-".$day;
    }
    if($dtTo != "")
    {
        list($month, $day, $year) = explode("-", $dtTo, 3);
        $dtTo = $year."-".$month."-".$day;
    }
}
// InStr function
// checks for an occurance of a string
// within another string
function InStr($String,$Find,$CaseSensitive = false) {
$i=0;
while (strlen($String)>=$i) {
 unset($substring);
 if ($CaseSensitive) {
  $Find=strtolower($Find);
  $String=strtolower($String);
 }
 $substring=substr($String,$i,strlen($Find));
 if ($substring==$Find) return true;
 $i++;
}
return false;
}

// A similar function, returns the number of occurances
function InStrCount($String,$Find,$CaseSensitive = false) {
$i=0;
$x=0;
while (strlen($String)>=$i) {
 unset($substring);
 if ($CaseSensitive) {
  $Find=strtolower($Find);
  $String=strtolower($String);
 }
 $substring=substr($String,$i,strlen($Find));
 if ($substring==$Find) $x++;
 $i++;
}
return $x;
}

// Another similar function, this will return the position of
// the string. returns -1 if the string does not exist
function InStrPos($String,$Find,$CaseSensitive = false) {
$i=0;
while (strlen($String)>=$i) {
 unset($substring);
 if ($CaseSensitive) {
  $Find=strtolower($Find);
  $String=strtolower($String);
 }
 $substring=substr($String,$i,strlen($Find));
 if ($substring==$Find) return $i;
 $i++;
}
return -1;
}
function encryptThe_String($plain_text, $password = 'P@88W04D', $iv_len = 16)
{
   $plain_text .= "\x13";
   $n = strlen($plain_text);
   if ($n % 16) $plain_text .= str_repeat("\0", 16 - ($n % 16));
   $i = 0;
   $enc_text = get_rnd_iv($iv_len);
   $iv = substr($password ^ $enc_text, 0, 512);
   while ($i < $n) {
       $block = substr($plain_text, $i, 16) ^ pack('H*', md5($iv));
       $enc_text .= $block;
       $iv = substr($block . $iv, 0, 512) ^ $password;
       $i += 16;
   }
   return base64_encode($enc_text);
}
function theString_Decrypt($enc_text, $password = 'P@88W04D', $iv_len = 16)
{
   $enc_text = base64_decode($enc_text);
   $n = strlen($enc_text);
   $i = $iv_len;
   $plain_text = '';
   $iv = substr($password ^ substr($enc_text, 0, $iv_len), 0, 512);
   while ($i < $n) {
       $block = substr($enc_text, $i, 16);
       $plain_text .= $block ^ pack('H*', md5($iv));
       $iv = substr($block . $iv, 0, 512) ^ $password;
       $i += 16;
   }
   return preg_replace('/\\x13\\x00*$/', '', $plain_text);
}
function get_rnd_iv($iv_len)
{
   $iv = '';
   while ($iv_len-- > 0) {
       $iv .= chr(mt_rand() & 0xff);
   }
   return $iv;
}
function check_input($value, $connection='')
{
    $value = mysqli_real_escape_string($value, $connection);
    return $value;
}
function getDepartmentEmail($deptId, $objDBCD14)
{
    $row = $objDBCD14->queryUniqueObject("SELECT DeptEmail FROM tbl_gf_tckt_dept WHERE DeptId = '$deptId'");
    return $row->DeptEmail;
}
function getEmailDetails($objDBCD14)
{
    $fromName = '';
    $fromEmail = '';
    $company = '';
    $url = '';
    $row = $objDBCD14->queryUniqueObject('SELECT FromName, FromEmail, Company, SiteURL FROM tbl_gf_email_settings WHERE Id = 1');
    if (isset($row->FromName) && $row->FromName != '')
    {
        $fromName = stripslashes($row->FromName);
        $fromEmail = $row->FromEmail;
        $company = stripslashes($row->Company);
        $url = $row->SiteURL;
    }
    return array($fromName, $fromEmail, $company, $url);
}
function sendMail($to, $fromName, $fromEmail, $subject, $message, $cc = '', $bcc = '')
{
    $mail = new PHPMailer();
    $mail->From = $fromEmail;
    $mail->FromName = $fromName;
    $mail->AddAddress($to, $fromName);
    if($cc != '')
        $mail->AddCC($cc, $fromName);
    if($bcc != '')
        $mail->AddBCC($bcc, $fromName);
    $mail->IsHTML(true);
    $mail->Subject = $subject;
    $mail->Body = $message;
    if(!$mail->Send())
    {
        sendMailViaPHP($to, $fromName, $fromEmail, $subject, $message, $cc = '', $bcc = '');
    }
}
function sendMailViaPHP($to, $fromName, $fromEmail, $subject, $message, $cc = '', $bcc = '')
{
    // Always set content-type when sending HTML email
    $headers = "MIME-Version: 1.0" . "\r\n";
    $headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";

    // More headers
//      $headers .= 'From: <admin>' . "\r\n";
    if($cc != '')
        $headers .= 'Cc: '.$cc.'' . "\r\n";
    if($bcc != '')
        $headers .= 'BCc: '.$bcc.'' . "\r\n";
    mail($to, $subject, $message, $headers);
}
function setDtTmWRTYourCountry($objDBCD14)
{
    $serverTimeDiff = 0;
    $row = $objDBCD14->queryUniqueObject('SELECT TimeDifference FROM tbl_gf_email_settings WHERE Id = 1');
    if (isset($row->TimeDifference) && $row->TimeDifference != '')
        $serverTimeDiff = $row->TimeDifference;

    $currentDate = strtotime(date('Y-m-d H:i:s'));
    $futureDate = $currentDate + (60 * $serverTimeDiff);
    $formatDate = date("Y-m-d H:i:s", $futureDate);
    return $formatDate;
}
function getUserPacksIds($userId, $serviceType, $objDBCD14)
{
    $strIds = '0';
    $rsUserPacks = $objDBCD14->query("SELECT PackageId FROM tbl_gf_user_packages WHERE UserId = '$userId' AND ServiceType = '$serviceType'");
    while($row = $objDBCD14->fetchNextObject($rsUserPacks))
    {
        $strIds .= ', ' . $row->PackageId;
    }
    return $strIds;
}
function getSupplierPacks($supplierId, $serviceType, $objDBCD14)
{
    $strIds = '0';
    $rsSupplierPacks = $objDBCD14->query("SELECT PackageId FROM tbl_gf_supplier_packages WHERE SupplierId = '$supplierId' AND ServiceType = '$serviceType'");
    while($row = $objDBCD14->fetchNextObject($rsSupplierPacks))
    {
        $strIds .= ', ' . $row->PackageId;
    }
    return $strIds;
}
function getAlreadyAssignedSupplierPacks($supplierId, $serviceType, $objDBCD14)
{
    $strIds = '0';
    $rsSupplierPacks = $objDBCD14->query("SELECT PackageId FROM tbl_gf_supplier_packages WHERE SupplierId <> '$supplierId' AND ServiceType = '$serviceType'");
    while($row = $objDBCD14->fetchNextObject($rsSupplierPacks))
    {
        $strIds .= ', ' . $row->PackageId;
    }
    return $strIds;
}
function ifPackIdAssignedToSupplier($packageId, $serviceType, $objDBCD14)
{
    $packId =  0;
    $price =  0;
    $supplierId = 0;
    $row = $objDBCD14->queryUniqueObject("SELECT SupplierId, PackageId, PurchasePrice FROM tbl_gf_supplier_packages WHERE PackageId='$packageId' AND ServiceType='$serviceType'");
    if(isset($row->PackageId) && $row->PackageId != '')
        $packId =  $row->PackageId;
    if(isset($row->PurchasePrice) && $row->PurchasePrice != '')
        $price =  $row->PurchasePrice;
    if(isset($row->SupplierId) && $row->SupplierId != '')
        $supplierId = $row->SupplierId;
    return array($packId, $price, $supplierId);
}
function ifAutoAdminArchived($objDBCD14)
{
    $autoAdmnArchvd = 0;
    $row = $objDBCD14->queryUniqueObject('SELECT AutoAdminArchived FROM tbl_gf_email_settings WHERE Id = 1');
    if (isset($row->AutoAdminArchived) && $row->AutoAdminArchived != '')
        $autoAdmnArchvd = $row->AutoAdminArchived;
    return $autoAdmnArchvd == 0 ? false : true;
}
function getDefaultCurrency($objDBCD14)
{
    $defaultCurrencyId = 0;
    $defaultCurrency = '';
    $row = $objDBCD14->queryUniqueObject('SELECT CurrencyId, CurrencyAbb FROM tbl_gf_currency WHERE DefaultCurrency = 1');
    if (isset($row->CurrencyId) && $row->CurrencyId != '')
    {
        $defaultCurrencyId = $row->CurrencyId;
        $defaultCurrency = $row->CurrencyAbb;
    }
    return $defaultCurrencyId.','.$defaultCurrency;
}
function getCurrencyData($objDBCD14, $currencyId)
{
    $data = '';
    $row = $objDBCD14->queryUniqueObject("SELECT CurrencyAbb, ConversionRate FROM tbl_gf_currency WHERE CurrencyId = '$currencyId'");
    if (isset($row->CurrencyAbb) && $row->CurrencyAbb != '')
    {
        $data = $row->CurrencyAbb.'|'.$row->ConversionRate;
    }
    return $data;
}
function getPlansPricesForService($serviceId, $sc, $objDBCD14)
{
    $PACK_PRICES = array();
    $rs = $objDBCD14->query("SELECT PlanId, CurrencyId, Price FROM tbl_gf_plans_packages_prices WHERE PackageId = '$serviceId' AND ServiceType = '$sc'");
    while($row = $objDBCD14->fetchNextObject($rs))
    {
        $PACK_PRICES[$row->PlanId][$row->CurrencyId] = roundMe($row->Price);
    }
    return $PACK_PRICES;
}
function getCurrencyPricesForPlans($objDBCD14, $planId = 0, $sc = 0)
{
    $strWhere = " AND ServiceType = '$sc'";
    $strCurrIds = '';
    if($planId > 0)
        $strWhere .= " AND PlanId = '$planId'";
    $PACK_PRICES = array();
    $rsCurrencyIds = $objDBCD14->query("SELECT CurrencyId FROM tbl_gf_currency WHERE DefaultCurrency <> 1 AND DisableCurrency = 0");
    while($row = $objDBCD14->fetchNextObject($rsCurrencyIds))
    {
        if($strCurrIds == '')
            $strCurrIds = $row->CurrencyId;
        else
            $strCurrIds .= ', '.$row->CurrencyId;
    }
    if($strCurrIds != '')
    {
        $rs = $objDBCD14->query("SELECT PackageId, CurrencyId, Price FROM tbl_gf_plans_packages_prices WHERE CurrencyId IN ($strCurrIds) $strWhere");
        while($row = $objDBCD14->fetchNextObject($rs))
        {
            $PACK_PRICES[$row->PackageId][$row->CurrencyId] = roundMe($row->Price);
        }
        if(count($PACK_PRICES) == 0)// No price found in above criteria
        {
            if($cs == '2')
                $tbl = 'tbl_gf_log_packages_currencies';
            else
                $tbl = 'tbl_gf_packages_currencies';
            $rs = $objDBCD14->query("SELECT PackageId, Price, CurrencyId FROM $tbl WHERE CurrencyId IN ($strCurrIds)");
            while($row = $objDBCD14->fetchNextObject($rs))
            {
                $PACK_PRICES[$row->PackageId][$row->CurrencyId] = roundMe($row->Price);
            }
        }
    }
    return $PACK_PRICES;
}
function getServiceIds($objDBCD14, $sType = 0)
{
    $strIds = '0';
    $rsIds = $objDBCD14->query("SELECT PackageId FROM tbl_gf_packages WHERE sl3lbf = '$sType' AND DisablePackage = 0");
    while($row = $objDBCD14->fetchNextObject($rsIds))
    {
        $strIds .= ', '.$row->PackageId;
    }
    return $strIds;
}
function getPackPricesInOtherCurrency($objDBCD14, $currencyId = 0, $serviceType = 0)
{
        $PACK_PRICES = array();
        switch($serviceType)
        {
            case '0': // IMEI services
                $tblName = 'tbl_gf_packages_currencies';
                break;
            case '1': // File services
                $tblName = 'tbl_gf_packages_currencies';
                break;
            case '2': // File services
                $tblName = 'tbl_gf_log_packages_currencies';
                break;
        }
        $rs = $objDBCD14->query("SELECT PackageId, Price FROM $tblName WHERE CurrencyId = '$currencyId'");
        while($row = $objDBCD14->fetchNextObject($rs))
        {
            $PACK_PRICES[$row->PackageId] = number_format($row->Price, 2, '.', '');
        }
        return $PACK_PRICES;
}
function getCurrencyPrices($objDBCD14, $currencyId = 0, $type = 0)
{
    $PACK_PRICES = array();
    if($type == '0' || $type == '1')
        $tbl = 'tbl_gf_packages_currencies';
    else
        $tbl = 'tbl_gf_log_packages_currencies';
    $rs = $objDBCD14->query("SELECT PackageId, Price FROM $tbl WHERE CurrencyId = '$currencyId'");
    while($row = $objDBCD14->fetchNextObject($rs))
    {
        $PACK_PRICES[$row->PackageId] = number_format($row->Price, 2, '.', '');
    }
    return $PACK_PRICES;
}
function deleteAPI($apiId, $objDBCD14)
{
    $row = $objDBCD14->queryUniqueObject("SELECT APIId FROM tbl_gf_api WHERE SystemAPI = 0 AND APIId = '$apiId'");
    if (isset($row->APIId) && $row->APIId != '')
    {
        $objDBCD14->execute("UPDATE tbl_gf_packages SET APIId = 0 WHERE APIId = '".$row->APIId."'");
        $objDBCD14->execute("DELETE FROM tbl_gf_supplier_services WHERE APIId = '".$row->APIId."'");
        $objDBCD14->execute("DELETE FROM tbl_gf_api WHERE APIId = '".$row->APIId."'");
    }
}
function deleteUser($userId, $objDBCD14)
{
    $objDBCD14->execute("DELETE FROM tbl_gf_codes WHERE UserId = $userId");
    $objDBCD14->execute("DELETE FROM tbl_gf_codes_slbf WHERE UserId = $userId");
    $objDBCD14->execute("DELETE FROM tbl_gf_credit_history WHERE UserId = $userId");
    $objDBCD14->execute("DELETE FROM tbl_gf_log_requests WHERE UserId = $userId");
    $objDBCD14->execute("DELETE FROM tbl_gf_payments WHERE UserId = $userId");
    $objDBCD14->execute("DELETE FROM tbl_gf_userlog WHERE UserId = $userId");
    $objDBCD14->execute("DELETE FROM tbl_gf_users_log_packages_prices WHERE UserId = $userId");
    $objDBCD14->execute("DELETE FROM tbl_gf_users_packages_prices WHERE UserId = $userId");
    $objDBCD14->execute("DELETE FROM tbl_gf_user_login_log WHERE UserId = $userId");
    $objDBCD14->execute("DELETE FROM tbl_gf_user_packages WHERE UserId = $userId");
    $objDBCD14->execute("DELETE FROM tbl_gf_users WHERE UserId = $userId");
}
function deletePack($packId, $objDBCD14)
{
    $objDBCD14->execute("DELETE FROM tbl_gf_codes WHERE PackageId = $packId");
    $objDBCD14->execute("DELETE FROM tbl_gf_codes_slbf WHERE PackageId = $packId");
    $objDBCD14->execute("DELETE FROM tbl_gf_credit_history WHERE PackageId = $packId");
    $objDBCD14->execute("DELETE FROM tbl_gf_packages_services WHERE PackageId = $packId");
    $objDBCD14->execute("DELETE FROM tbl_gf_package_fields WHERE PackageId = $packId");
    $objDBCD14->execute("DELETE FROM tbl_gf_plans_offers_packages_prices WHERE PackageId = $packId");
    $objDBCD14->execute("DELETE FROM tbl_gf_plans_packages_prices WHERE PackageId = $packId AND ServiceType IN (0, 1)");
    $objDBCD14->execute("DELETE FROM tbl_gf_users_packages_prices WHERE PackageId = $packId");
    $objDBCD14->execute("DELETE FROM tbl_gf_user_packages WHERE PackageId = $packId");
    $objDBCD14->execute("DELETE FROM tbl_gf_packages WHERE PackageId = $packId");
}
function deleteLogPack($packId, $objDBCD14)
{
    $objDBCD14->execute("DELETE FROM tbl_gf_log_requests WHERE LogPackageId = $packId");
    $objDBCD14->execute("DELETE FROM tbl_gf_plans_packages_prices WHERE PackageId = $packId AND ServiceType = 2");
    $objDBCD14->execute("DELETE FROM tbl_gf_users_log_packages_prices WHERE LogPackageId = $packId");
    $objDBCD14->execute("DELETE FROM tbl_gf_log_packages WHERE LogPackageId = $packId");
}
function deleteService($serviceId, $objDBCD14)
{
    $row = $objDBCD14->queryUniqueObject('SELECT ServiceTableName FROM tbl_gf_services WHERE ServiceId = '.$serviceId);
    if (isset($row->ServiceTableName) && $row->ServiceTableName != '')
    {
        $objDBCD14->execute("DROP TABLE IF EXISTS ".$row->ServiceTableName);
    }
    $objDBCD14->execute("DELETE FROM tbl_gf_packages_services WHERE ServiceId = $serviceId");
    $objDBCD14->execute("DELETE FROM tbl_gf_services WHERE ServiceId = $serviceId");
}
function deletePricePlan($planId, $objDBCD14)
{
    $objDBCD14->execute("UPDATE tbl_gf_users SET PricePlanId = 0 WHERE PricePlanId = '$planId'");
    $objDBCD14->execute("DELETE FROM tbl_gf_plans_packages_prices WHERE PlanId = '$planId'");
    $objDBCD14->execute("DELETE FROM tbl_gf_price_plans WHERE PricePlanId = '$planId'");
}
function failedLoginAttempt($uName, $objDBCD14)
{
    $objDBCD14->execute("UPDATE tbl_gf_users SET LoginAttempts = LoginAttempts + 1 WHERE UserName = '$uName'");
}
function ipBlocked($objDBCD14)
{
    $rwIPInfo = $objDBCD14->queryUniqueObject("SELECT COUNT(Id) AS Data FROM tbl_gf_blocked_ips WHERE IP = '".$_SERVER['REMOTE_ADDR']."'");
    if($rwIPInfo->Data > 0)
        return true;
    else
        return false;
}
function getEmailContents($id, $objDBCD14)
{
    $subject = '';
    $contents = '';
    $sendCopy = 0;
    $row = $objDBCD14->queryUniqueObject("SELECT Subject, Contents, SendCopyToAdmin FROM tbl_gf_email_templates WHERE TemplateId = '$id'");
    if (isset($row->Subject) && $row->Subject != '')
    {
        $subject = stripslashes($row->Subject);
        $contents = stripslashes($row->Contents);
        $sendCopy = $row->SendCopyToAdmin;
    }
    return array($subject, $contents, $sendCopy);
}
function newIMEIOrderEmailContents($serviceId, $objDBCD14)
{
    $arr = getEmailDetails($objDBCD14);
    $row = $objDBCD14->queryUniqueObject("SELECT NewTplSubject, NewTplBody, SendNewCopyToAdmin FROM tbl_gf_packages WHERE PackageId = '$serviceId' AND NewTplType = '1'");
    if (isset($row->NewTplSubject) && $row->NewTplSubject != '')
    {
        $subject = stripslashes($row->NewTplSubject);
        $contents = stripslashes($row->NewTplBody);
        $sendCopy = $row->SendNewCopyToAdmin;
    }
    else
    {
        list($subject, $contents, $sendCopy) = getEmailContents(4, $objDBCD14);
    }
    return  array($subject, $contents, $sendCopy);
}
function successIMEIOrderEmailContents($serviceId, $objDBCD14)
{
    $arr = getEmailDetails($objDBCD14);
    $row = $objDBCD14->queryUniqueObject("SELECT NewTplSubject, NewTplBody, SendNewCopyToAdmin FROM tbl_gf_packages WHERE PackageId = '$serviceId' AND NewTplType = '1'");
    if (isset($row->NewTplSubject) && $row->NewTplSubject != '')
    {
        $subject = stripslashes($row->NewTplSubject);
        $contents = stripslashes($row->NewTplBody);
        $sendCopy = $row->SendNewCopyToAdmin;
    }
    else
    {
        list($subject, $contents, $sendCopy) = getEmailContents(7, $objDBCD14);
    }
    return array($subject, $contents, $sendCopy);
}
function compileNewIMEIOrderEmail($customerName, $serviceName, $myIMEI, $ip, $creditsDeducted, $finalCredits, $orderDt, $contents, $userName, $notes)
{
    $placeholders  = array("#CUSTOMER_NAME#", "#USER_NAME#", "#SERVICE_NAME#", "#IMEI_NO#", "#CREDITS_DEDUCTED#", "#FINAL_CREDITS#", "#ORDER_DATE#", "#IP#", "#NOTES#");
    $replacedData = array($customerName, $userName, $serviceName, $myIMEI, $creditsDeducted, $finalCredits, $orderDt, $ip, $notes);
    $emailMsg = str_replace($placeholders, $replacedData, $contents);
    return $emailMsg.'<br /><br />';
}
function compileSuccessIMEIOrderEmail($name, $service, $imei, $code, $orderDt, $contents, $notes = '')
{
    $code = str_replace('\r', '', $code);
    $placeholders  = array("#CUSTOMER_NAME#", "#SERVICE_NAME#", "#IMEI_NO#", "#DETAILS#", "#ORDER_DATE#", '#NOTES#');
    $replacedData = array($name, $service, $imei, $code, $orderDt, $notes);
    $emailMsg = str_replace($placeholders, $replacedData, $contents);
    return $emailMsg.'<br /><br />';
}
function sendNewIMEIOrderEmail($email, $altEmail, $subject, $sendCopy, $contents, $objDBCD14)
{
    $arr = getEmailDetails($objDBCD14);
    $placeholders  = array("#COMPANY_NAME#", "#COMPANY_EMAIL_ADDRESS#", "#TRACK_ORDER_PAGE#");
    $replacedData = array(stripslashes($arr[2]), '<a href="mailto:'.$arr[1].'">'.$arr[1].'</a>', '<a href="http://'.$arr[3].'/trackorder.php" target="_blank">here</a>');
    $emailMsg = str_replace($placeholders, $replacedData, $contents);
    sendMail($email, $arr[0], $arr[1], $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
    if($altEmail != '')
        sendMail($altEmail, $arr[0], $arr[1], $subject, $emailMsg);
}
function sendSuccessIMEIOrderEmail($email, $altEmail, $subject, $sendCopy, $contents, $objDBCD14)
{
    $arr = getEmailDetails($objDBCD14);
    $placeholders  = array("#COMPANY_NAME#", "#COMPANY_EMAIL_ADDRESS#");
    $replacedData = array(stripslashes($arr[2]), '<a href="mailto:'.$arr[1].'">'.$arr[1].'</a>');
    $emailMsg = str_replace($placeholders, $replacedData, $contents);
    sendMail($email, $arr[0], $arr[1], $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
    if($altEmail != '')
        sendMail($altEmail, $arr[0], $arr[1], $subject, $emailMsg);
}
function newIMEIOrderEmail($email, $customerName, $serviceName, $myIMEI, $ip, $creditsDeducted, $finalCredits, $orderDt, $serviceId, $altEmail, $objDBCD14)
{
    $arr = getEmailDetails($objDBCD14);
    $row = $objDBCD14->queryUniqueObject("SELECT NewTplSubject, NewTplBody, SendNewCopyToAdmin FROM tbl_gf_packages WHERE PackageId = '$serviceId' AND NewTplType = '1'");
    if (isset($row->NewTplSubject) && $row->NewTplSubject != '')
    {
        $subject = stripslashes($row->NewTplSubject);
        $contents = stripslashes($row->NewTplBody);
        $sendCopy = $row->SendNewCopyToAdmin;
    }
    else
    {
        list($subject, $contents, $sendCopy) = getEmailContents(4, $objDBCD14);
    }

    $placeholders  = array("#CUSTOMER_NAME#", "#SERVICE_NAME#", "#IMEI_NO#", "#CREDITS_DEDUCTED#", "#FINAL_CREDITS#", "#ORDER_DATE#",
            "#IP#", "#COMPANY_NAME#", "#COMPANY_EMAIL_ADDRESS#", "#TRACK_ORDER_PAGE#");
    $replacedData = array($customerName, $serviceName, $myIMEI, $creditsDeducted, $finalCredits, $orderDt, $ip, stripslashes($arr[2]), '<a href="mailto:'.$arr[1].'">'.$arr[1].'</a>', '<a href="http://'.$arr[3].'/trackorder.php" target="_blank">here</a>');
    $emailMsg = str_replace($placeholders, $replacedData, $contents);
    sendMail($email, $arr[0], $arr[1], $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
    if($altEmail != '')
        sendMail($altEmail, $arr[0], $arr[1], $subject, $emailMsg);
}
function successfulIMEIOrderEmail($email, $name, $service, $imei, $code, $orderDt, $serviceId, $altEmail, $objDBCD14, $notes = '')
{
    if(sendOrderEmail('SendSuccessIMEIOrderEmail', $objDBCD14))
    {
        $arr = getEmailDetails($objDBCD14);
        $row = $objDBCD14->queryUniqueObject("SELECT SuccessTplSubject, SuccessTplBody, SendSuccessCopyToAdmin FROM tbl_gf_packages WHERE PackageId = '$serviceId' AND SuccessTplType = '1'");
        if (isset($row->SuccessTplSubject) && $row->SuccessTplSubject != '')
        {
            $subject = stripslashes($row->SuccessTplSubject);
            $contents = stripslashes($row->SuccessTplBody);
            $sendCopy = $row->SendSuccessCopyToAdmin;
        }
        else
        {
            list($subject, $contents, $sendCopy) = getEmailContents(7, $objDBCD14);
        }

        $placeholders  = array("#CUSTOMER_NAME#", "#SERVICE_NAME#", "#IMEI_NO#", "#DETAILS#", "#ORDER_DATE#", "#COMPANY_NAME#", "#COMPANY_EMAIL_ADDRESS#", '#NOTES#');
        $replacedData = array($name, $service, $imei, $code, $orderDt, stripslashes($arr[2]), '<a href="mailto:'.$arr[1].'">'.$arr[1].'</a>', $notes);
        $emailMsg = str_replace($placeholders, $replacedData, $contents);
        sendMail($email, $arr[0], $arr[1], $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
        if($altEmail != '')
            sendMail($altEmail, $arr[0], $arr[1], $subject, $emailMsg);
    }
}
function resubmittedIMEIOrderEmail($email, $name, $service, $imei, $orderDt, $altEmail, $objDBCD14, $notes = '')
{
    $arr = getEmailDetails($objDBCD14);
    list($subject, $contents, $sendCopy) = getEmailContents(24, $objDBCD14);


    $placeholders  = array("#CUSTOMER_NAME#", "#SERVICE_NAME#", "#IMEI_NO#", "#ORDER_DATE#", "#COMPANY_NAME#", "#COMPANY_EMAIL_ADDRESS#", '#NOTES#');
    $replacedData = array($name, $service, $imei, $orderDt, stripslashes($arr[2]), '<a href="mailto:'.$arr[1].'">'.$arr[1].'</a>', $notes);
    $emailMsg = str_replace($placeholders, $replacedData, $contents);
    sendMail($email, $arr[0], $arr[1], $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
    if($altEmail != '')
        sendMail($altEmail, $arr[0], $arr[1], $subject, $emailMsg);
}

function rejectedIMEIOrderEmail($email, $name, $service, $imei, $code, $orderDt, $serviceId, $altEmail, $creditsReturned, $creditsLeft, $objDBCD14, $notes='')
{
    if(sendOrderEmail('SendFailureIMEIOrderEmail', $objDBCD14))
    {
        $arr = getEmailDetails($objDBCD14);
        $row = $objDBCD14->queryUniqueObject("SELECT CancelTplSubject, CancelTplBody, SendRejectCopyToAdmin FROM tbl_gf_packages WHERE PackageId = '$serviceId' AND CancelledTplType = '1'");
        if (isset($row->CancelTplSubject) && $row->CancelTplSubject != '')
        {
            $subject = stripslashes($row->CancelTplSubject);
            $contents = stripslashes($row->CancelTplBody);
            $sendCopy = $row->SendRejectCopyToAdmin;
        }
        else
        {
            list($subject, $contents, $sendCopy) = getEmailContents(13, $objDBCD14);
        }

        $placeholders  = array("#CUSTOMER_NAME#", "#SERVICE_NAME#", "#IMEI_NO#", "#DETAILS#", "#ORDER_DATE#", "#COMPANY_NAME#", "#COMPANY_EMAIL_ADDRESS#", "#CREDITS_RETURNED#", "#CREDITS_LEFT#", '#NOTES#');
        $replacedData = array($name, $service, $imei, $code, $orderDt, stripslashes($arr[2]), '<a href="mailto:'.$arr[1].'">'.$arr[1].'</a>', $creditsReturned, $creditsLeft, $notes);
        $emailMsg = str_replace($placeholders, $replacedData, $contents);
        sendMail($email, $arr[0], $arr[1], $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
        if($altEmail != '')
            sendMail($altEmail, $arr[0], $arr[1], $subject, $emailMsg);
    }
}
function newIMEIRetailOrderEmail($email, $customerName, $serviceName, $myIMEI, $ip, $orderDt, $serviceId, $price, $objDBCD14)
{
    $arr = getEmailDetails($objDBCD14);
    $row = $objDBCD14->queryUniqueObject("SELECT NewTplSubject, NewTplBody, SendNewCopyToAdmin FROM tbl_gf_packages WHERE PackageId = '$serviceId' AND NewTplType = '1'");
    if (isset($row->NewTplSubject) && $row->NewTplSubject != '')
    {
        $subject = stripslashes($row->NewTplSubject);
        $contents = stripslashes($row->NewTplBody);
        $sendCopy = $row->SendNewCopyToAdmin;
    }
    else
    {
        list($subject, $contents, $sendCopy) = getEmailContents(17, $objDBCD14);
    }

    $placeholders  = array("#CUSTOMER_NAME#", "#SERVICE_NAME#", "#IMEI_NO#", "#ORDER_DATE#", "#IP#", "#COMPANY_NAME#", "#COMPANY_EMAIL_ADDRESS#",
    "#TRACK_ORDER_PAGE#", "#AMOUNT#");
    $replacedData = array($customerName, $serviceName, $myIMEI, $orderDt, $ip, stripslashes($arr[2]), '<a href="mailto:'.$arr[1].'">'.$arr[1].'</a>',
    '<a href="http://'.$arr[3].'/trackorder.php" target="_blank">here</a>', $price);
    $emailMsg = str_replace($placeholders, $replacedData, $contents);
    sendMail($email, $arr[0], $arr[1], $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
}
function rejectedIMEIRetailOrderEmail($email, $name, $service, $imei, $code, $orderDt, $serviceId, $objDBCD14, $notes = '')
{
    $arr = getEmailDetails($objDBCD14);
    $row = $objDBCD14->queryUniqueObject("SELECT CancelTplSubject, CancelTplBody, SendRejectCopyToAdmin FROM tbl_gf_packages WHERE PackageId = '$serviceId' AND CancelledTplType = '1'");
    if (isset($row->CancelTplSubject) && $row->CancelTplSubject != '')
    {
        $subject = stripslashes($row->CancelTplSubject);
        $contents = stripslashes($row->CancelTplBody);
        $sendCopy = $row->SendRejectCopyToAdmin;
    }
    else
    {
        list($subject, $contents, $sendCopy) = getEmailContents(19, $objDBCD14);
    }

    $placeholders  = array("#CUSTOMER_NAME#", "#SERVICE_NAME#", "#IMEI_NO#", "#DETAILS#", "#ORDER_DATE#", "#COMPANY_NAME#", "#COMPANY_EMAIL_ADDRESS#", '#NOTES#');
    $replacedData = array($name, $service, $imei, $code, $orderDt, stripslashes($arr[2]), '<a href="mailto:'.$arr[1].'">'.$arr[1].'</a>', $notes);
    $emailMsg = str_replace($placeholders, $replacedData, $contents);
    sendMail($email, $arr[0], $arr[1], $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
}

function successfulIMEIRetailOrderEmail($email, $name, $service, $imei, $code, $orderDt, $serviceId, $objDBCD14, $notes = '')
{
    $arr = getEmailDetails($objDBCD14);
    $row = $objDBCD14->queryUniqueObject("SELECT SuccessTplSubject, SuccessTplBody, SendSuccessCopyToAdmin FROM tbl_gf_packages WHERE PackageId = '$serviceId' AND SuccessTplType = '1'");
    if (isset($row->SuccessTplSubject) && $row->SuccessTplSubject != '')
    {
        $subject = stripslashes($row->SuccessTplSubject);
        $contents = stripslashes($row->SuccessTplBody);
        $sendCopy = $row->SendSuccessCopyToAdmin;
    }
    else
    {
        list($subject, $contents, $sendCopy) = getEmailContents(18, $objDBCD14);
    }

    $placeholders  = array("#CUSTOMER_NAME#", "#SERVICE_NAME#", "#IMEI_NO#", "#DETAILS#", "#ORDER_DATE#", "#COMPANY_NAME#", "#COMPANY_EMAIL_ADDRESS#", '#NOTES#');
    $replacedData = array($name, $service, $imei, $code, $orderDt, stripslashes($arr[2]), '<a href="mailto:'.$arr[1].'">'.$arr[1].'</a>', $notes);
    $emailMsg = str_replace($placeholders, $replacedData, $contents);
    sendMail($email, $arr[0], $arr[1], $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
}

function newFileOrderEmail($email, $name, $service, $myIMEI, $ip, $creditsDeducted, $finalCredits, $orderDt, $serviceId, $altEmail, $hash, $objDBCD14)
{
    $arr = getEmailDetails($objDBCD14);
    $row = $objDBCD14->queryUniqueObject("SELECT NewTplSubject, NewTplBody, SendNewCopyToAdmin FROM tbl_gf_packages WHERE PackageId = '$serviceId' AND NewTplType = '1'");
    if (isset($row->NewTplSubject) && $row->NewTplSubject != '')
    {
        $subject = stripslashes($row->NewTplSubject);
        $contents = stripslashes($row->NewTplBody);
        $sendCopy = $row->SendNewCopyToAdmin;
    }
    else
    {
        list($subject, $contents, $sendCopy) = getEmailContents(5, $objDBCD14);
    }

    $placeholders  = array("#CUSTOMER_NAME#", "#SERVICE_NAME#", "#IMEI_NO#", "#CREDITS_DEDUCTED#", "#FINAL_CREDITS#", "#ORDER_DATE#",
            "#IP#", "#COMPANY_NAME#", "#COMPANY_EMAIL_ADDRESS#", "#TRACK_ORDER_PAGE#", "#HASH#");
    $replacedData = array($name, $service, $myIMEI, $creditsDeducted, $finalCredits, $orderDt, $ip, stripslashes($arr[2]), '<a href="mailto:'.$arr[1].'">'.$arr[1].'</a>', '<a href="http://'.$arr[3].'/trackorder.php" target="_blank">here</a>', $hash);
    $emailMsg = str_replace($placeholders, $replacedData, $contents);
    sendMail($email, $arr[0], $arr[1], $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
    if($altEmail != '')
        sendMail($altEmail, $arr[0], $arr[1], $subject, $emailMsg);
}
function successfulFileOrderEmail($email, $name, $service, $imei, $code, $orderDt, $serviceId, $altEmail, $objDBCD14, $notes = '')
{
    if(sendOrderEmail('SendSuccessFileOrderEmail', $objDBCD14))
    {
        $arr = getEmailDetails($objDBCD14);
        $row = $objDBCD14->queryUniqueObject("SELECT SuccessTplSubject, SuccessTplBody, SendSuccessCopyToAdmin FROM tbl_gf_packages WHERE PackageId = '$serviceId' AND SuccessTplType = '1'");
        if (isset($row->SuccessTplSubject) && $row->SuccessTplSubject != '')
        {
            $subject = stripslashes($row->SuccessTplSubject);
            $contents = stripslashes($row->SuccessTplBody);
            $sendCopy = $row->SendSuccessCopyToAdmin;
        }
        else
        {
            list($subject, $contents, $sendCopy) = getEmailContents(8, $objDBCD14);
        }

        $placeholders  = array("#CUSTOMER_NAME#", "#SERVICE_NAME#", "#IMEI_NO#", "#DETAILS#", "#ORDER_DATE#", "#COMPANY_NAME#", "#COMPANY_EMAIL_ADDRESS#", '#NOTES#');
        $replacedData = array($name, $service, $imei, $code, $orderDt, stripslashes($arr[2]), '<a href="mailto:'.$arr[1].'">'.$arr[1].'</a>', $notes);
        $emailMsg = str_replace($placeholders, $replacedData, $contents);
        sendMail($email, $arr[0], $arr[1], $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
        if($altEmail != '')
            sendMail($altEmail, $arr[0], $arr[1], $subject, $emailMsg);
    }
}
function rejectedFileOrderEmail($email, $name, $service, $imei, $code, $orderDt, $serviceId, $altEmail, $creditsReturned, $creditsLeft, $objDBCD14, $notes='')
{
    if(sendOrderEmail('SendFailureFileOrderEmail', $objDBCD14))
    {
        $arr = getEmailDetails($objDBCD14);
        $row = $objDBCD14->queryUniqueObject("SELECT CancelTplSubject, CancelTplBody, SendRejectCopyToAdmin FROM tbl_gf_packages WHERE PackageId = '$serviceId' AND CancelledTplType = '1'");
        if (isset($row->CancelTplSubject) && $row->CancelTplSubject != '')
        {
            $subject = stripslashes($row->CancelTplSubject);
            $contents = stripslashes($row->CancelTplBody);
            $sendCopy = $row->SendRejectCopyToAdmin;
        }
        else
        {
            list($subject, $contents, $sendCopy) = getEmailContents(14, $objDBCD14);
        }

        $placeholders  = array("#CUSTOMER_NAME#", "#SERVICE_NAME#", "#IMEI_NO#", "#DETAILS#", "#ORDER_DATE#", "#COMPANY_NAME#", "#COMPANY_EMAIL_ADDRESS#", "#CREDITS_RETURNED#", "#CREDITS_LEFT#", '#NOTES#');
        $replacedData = array($name, $service, $imei, $code, $orderDt, stripslashes($arr[2]), '<a href="mailto:'.$arr[1].'">'.$arr[1].'</a>', $creditsReturned, $creditsLeft, $notes);
        $emailMsg = str_replace($placeholders, $replacedData, $contents);
        sendMail($email, $arr[0], $arr[1], $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
        if($altEmail != '')
            sendMail($altEmail, $arr[0], $arr[1], $subject, $emailMsg);
    }
}

function newServerOrderEmail($email, $name, $service, $boxUN, $ip, $creditsDeducted, $finalCredits, $orderDt, $serviceId, $altEmail, $serial, $objDBCD14)
{
    $arr = getEmailDetails($objDBCD14);
    $row = $objDBCD14->queryUniqueObject("SELECT NewTplSubject, NewTplBody, SendNewCopyToAdmin FROM tbl_gf_log_packages WHERE LogPackageId = '$serviceId' AND NewTplType = '1'");
    if (isset($row->NewTplSubject) && $row->NewTplSubject != '')
    {
        $subject = stripslashes($row->NewTplSubject);
        $contents = stripslashes($row->NewTplBody);
        $sendCopy = $row->SendNewCopyToAdmin;
    }
    else
    {
        list($subject, $contents, $sendCopy) = getEmailContents(6, $objDBCD14);
    }

    $placeholders  = array("#CUSTOMER_NAME#", "#SERVICE_NAME#", "#BOX_USERNAME#", "#CREDITS_DEDUCTED#", "#FINAL_CREDITS#", "#ORDER_DATE#",
            "#IP#", "#COMPANY_NAME#", "#COMPANY_EMAIL_ADDRESS#", "#TRACK_ORDER_PAGE#", "#SERIAL_NO#");
    $replacedData = array($name, $service, $boxUN, $creditsDeducted, $finalCredits, $orderDt, $ip, stripslashes($arr[2]), '<a href="mailto:'.$arr[1].'">'.$arr[1].'</a>', '<a href="http://'.$arr[3].'/trackorder.php" target="_blank">here</a>', $serial);
    $emailMsg = str_replace($placeholders, $replacedData, $contents);
    sendMail($email, $arr[0], $arr[1], $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
    if($altEmail != '')
        sendMail($altEmail, $arr[0], $arr[1], $subject, $emailMsg);
}
function successfulServerOrderEmail($email, $name, $service, $code, $orderDt, $serviceId, $altEmail, $objDBCD14, $notes = '')
{
    if(sendOrderEmail('SendSuccessSrvrOrderEmail', $objDBCD14))
    {
        $arr = getEmailDetails($objDBCD14);
        $row = $objDBCD14->queryUniqueObject("SELECT SuccessTplSubject, SuccessTplBody, SendSuccessCopyToAdmin FROM tbl_gf_log_packages WHERE LogPackageId = '$serviceId' AND SuccessTplType = '1'");
        if (isset($row->SuccessTplSubject) && $row->SuccessTplSubject != '')
        {
            $subject = stripslashes($row->SuccessTplSubject);
            $contents = stripslashes($row->SuccessTplBody);
            $sendCopy = $row->SendSuccessCopyToAdmin;
        }
        else
        {
            list($subject, $contents, $sendCopy) = getEmailContents(9, $objDBCD14);
        }
        $placeholders  = array("#CUSTOMER_NAME#", "#SERVICE_NAME#", "#DETAILS#", "#ORDER_DATE#", "#COMPANY_NAME#", "#COMPANY_EMAIL_ADDRESS#", '#NOTES#');
        $replacedData = array($name, $service, $code, $orderDt, stripslashes($arr[2]), '<a href="mailto:'.$arr[1].'">'.$arr[1].'</a>', $notes);
        $emailMsg = str_replace($placeholders, $replacedData, $contents);
        sendMail($email, $arr[0], $arr[1], $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
        if($altEmail != '')
            sendMail($altEmail, $arr[0], $arr[1], $subject, $emailMsg);
    }
}
function rejectedServerOrderEmail($email, $name, $service, $code, $orderDt, $serviceId, $altEmail, $creditsReturned, $creditsLeft, $objDBCD14, $notes = '')
{
    if(sendOrderEmail('SendFailureSrvrOrderEmail', $objDBCD14))
    {
        $arr = getEmailDetails($objDBCD14);
        $row = $objDBCD14->queryUniqueObject("SELECT CancelTplSubject, CancelTplBody, SendRejectCopyToAdmin FROM tbl_gf_log_packages WHERE LogPackageId = '$serviceId' AND CancelledTplType = '1'");
        if (isset($row->CancelTplSubject) && $row->CancelTplSubject != '')
        {
            $subject = stripslashes($row->CancelTplSubject);
            $contents = stripslashes($row->CancelTplBody);
            $sendCopy = $row->SendRejectCopyToAdmin;
        }
        else
        {
            list($subject, $contents, $sendCopy) = getEmailContents(15, $objDBCD14);
        }
        $placeholders  = array("#CUSTOMER_NAME#", "#SERVICE_NAME#", "#DETAILS#", "#ORDER_DATE#", "#COMPANY_NAME#", "#COMPANY_EMAIL_ADDRESS#", "#CREDITS_RETURNED#", "#CREDITS_LEFT#", '#NOTES#');
        $replacedData = array($name, $service, $code, $orderDt, stripslashes($arr[2]), '<a href="mailto:'.$arr[1].'">'.$arr[1].'</a>', $creditsReturned, $creditsLeft, $notes);
        $emailMsg = str_replace($placeholders, $replacedData, $contents);
        sendMail($email, $arr[0], $arr[1], $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
        if($altEmail != '')
            sendMail($altEmail, $arr[0], $arr[1], $subject, $emailMsg);
    }
}
function frgtPwdEmail($email, $name, $password, $objDBCD14)
{
    $arr = getEmailDetails($objDBCD14);
    list($subject, $contents, $sendCopy) = getEmailContents(3, $objDBCD14);

    $placeholders  = array("#CUSTOMER_NAME#", "#PASSWORD#", "#COMPANY_NAME#", "#COMPANY_EMAIL_ADDRESS#");
    $replacedData = array($name, $password, stripslashes($arr[2]), '<a href="mailto:'.$arr[1].'">'.$arr[1].'</a>');
    $emailMsg = str_replace($placeholders, $replacedData, $contents);
    sendMail($email, $arr[0], $arr[1], $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
}
function newTicketEmail($email, $name, $tcktNo, $tcktId, $subject, $deptId, $objDBCD14)
{
    $arr = getEmailDetails($objDBCD14);
    list($subject, $contents, $sendCopy) = getEmailContents(20, $objDBCD14);
    $placeholders  = array("#NAME#", "#TICKET_NO#", "#COMPANY_NAME#", "#TICKET_LINK#");
    $replacedData = array($name, $tcktNo, stripslashes($arr[2]), '<a href="http://'.$arr[3].'/viewticket.php?tkn1='.urlsafe_b64encode($tcktId).'">http://'.$arr[3].'/viewticket.php?tkn1='.urlsafe_b64encode($tcktId).'</a>');
    $subject = "[#$tcktNo] $subject";
    $emailMsg = str_replace($placeholders, $replacedData, $contents);
    $deptEmail = getDepartmentEmail($deptId, $objDBCD14);
    if($deptEmail == '')
        $deptEmail = $arr[1];
    sendMail($email, $arr[0], $deptEmail, $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
}
function newTicketEmailByUser($email, $name, $tcktNo, $tcktId, $subject, $deptId, $objDBCD14)
{
    $arr = getEmailDetails($objDBCD14);
    list($subject, $contents, $sendCopy) = getEmailContents(20, $objDBCD14);
    $placeholders  = array("#NAME#", "#TICKET_NO#", "#COMPANY_NAME#", "#TICKET_LINK#");
    $replacedData = array($name, $tcktNo, stripslashes($arr[2]), '<a href="http://'.$arr[3].'/ticketdtls.php?id='.$tcktId.'">http://'.$arr[3].'/ticketdtls.php?id='.$tcktId.'</a>');
    $subject = "[#$tcktNo] $subject";
    $emailMsg = str_replace($placeholders, $replacedData, $contents);
    $deptEmail = getDepartmentEmail($deptId, $objDBCD14);
    if($deptEmail == '')
        $deptEmail = $arr[1];
    sendMail($email, $arr[0], $deptEmail, $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
}
function answeredTicketEmail($email, $message, $tcktNo, $tcktId, $subject, $deptId, $objDBCD14)
{
    $arr = getEmailDetails($objDBCD14);
    $subject = "[#$tcktNo] $subject";
    $emailMsg = "$message<br /><br />======================================================================<br /><br />
Ticket No.: $tcktNo<br /><br />
Subject: $subject<br /><br />
Status: Answered<br /><br />".
'<a href="http://'.$arr[3].'/viewticket.php?tkn1='.urlsafe_b64encode($tcktId).'">http://'.$arr[3].'/viewticket.php?tkn1='.urlsafe_b64encode($tcktId).'</a>'."<br /><br />
======================================================================<br /><br />
";
    $deptEmail = getDepartmentEmail($deptId, $objDBCD14);
    if($deptEmail == '')
        $deptEmail = $arr[1];
    sendMail($email, $arr[0], $deptEmail, $subject, $emailMsg, '');
}
function customerRepliedTicketEmail($department, $subject, $message, $deptId, $objDBCD14)
{
    $arr = getEmailDetails($objDBCD14);
    $subject = "Customer Replied for Ticket [#$tcktNo] $subject";
    $deptEmail = getDepartmentEmail($deptId, $objDBCD14);
    if($deptEmail == '')
        $deptEmail = $arr[1];
    sendMail($deptEmail, $arr[0], $deptEmail, $subject, $message, '');
}
function apiKeyGnrtnEmail($email, $name, $apiKey, $objDBCD14)
{
    $arr = getEmailDetails($objDBCD14);
    list($subject, $contents, $sendCopy) = getEmailContents(16, $objDBCD14);
    $placeholders  = array("#CUSTOMER_NAME#", "#API_KEY#", "#COMPANY_NAME#", "#COMPANY_EMAIL_ADDRESS#", "#API_DOWNLOAD_LINK#");
    $replacedData = array($name, $apiKey, stripslashes($arr[2]), '<a href="mailto:'.$arr[1].'">'.$arr[1].'</a>', '<a href="http://'.$arr[3].'/api.rar">here</a>');
    $subject = str_replace($placeholders, $replacedData, $subject);
    $emailMsg = str_replace($placeholders, $replacedData, $contents);

    sendMail($email, $arr[0], $arr[1], $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
}
function updateCreditsEmail($email, $name, $credits, $currCredits, $dt, $type, $objDBCD14)
{
    $arr = getEmailDetails($objDBCD14);
    list($subject, $contents, $sendCopy) = getEmailContents(10, $objDBCD14);

    $placeholders  = array("#CUSTOMER_NAME#", "#CREDITS#", "#COMPANY_NAME#", "#COMPANY_EMAIL_ADDRESS#", "#CURRENCT_CREDITS#", "#CREDITS_UPDATED_DATE#", "#ADDED_REBATED#");
    $replacedData = array($name, $credits, stripslashes($arr[2]), '<a href="mailto:'.$arr[1].'">'.$arr[1].'</a>', $currCredits, $dt, $type);
    $emailMsg = str_replace($placeholders, $replacedData, $contents);
    sendMail($email, $arr[0], $arr[1], $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
}
function invoiceEmail($email, $name, $invoiceNo, $objDBCD14)
{
    $arr = getEmailDetails($objDBCD14);
    list($subject, $contents, $sendCopy) = getEmailContents(11, $objDBCD14);

    $placeholders  = array("#CUSTOMER_NAME#", "#INVOICE_NO#", "#COMPANY_NAME#", "#COMPANY_EMAIL_ADDRESS#");
    $replacedData = array($name, $invoiceNo, stripslashes($arr[2]), '<a href="mailto:'.$arr[1].'">'.$arr[1].'</a>');
    $subject = str_replace($placeholders, $replacedData, $subject);
    $emailMsg = str_replace($placeholders, $replacedData, $contents);
    sendMail($email, $arr[0], $arr[1], $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
}

function saveEmailLog($userId, $title, $text, $objDBCD14)
{
    /*
    $dtTm = setDtTmWRTYourCountry($objDBCD14);
    $objDBCD14->execute("INSERT INTO tbl_email_log (UserId, DtTm, Title, EmailText) VALUES
                ('$userId', '$dtTm', '".addslashes($title)."', '".addslashes($text)."')");*/
}
function doPages($page_name, $back, $start, $txtlqry, $totalRows, $limit, $eu, $pLast, $thisp, $next, $formSubmit = 0, $frmName = '')
{
    echo '<br /><br /><div class="paging">';
    if($back < 0) {
        echo '<span class="prn">&lt; Previous</span>&nbsp;';
    } else {
        if($formSubmit == '0')
            echo '<a href="'.$page_name.'?start='.$back.$txtlqry.'" class="prn" rel="nofollow">&lt; Previous</a>&nbsp;';
        else if($formSubmit == '1')
        { ?>
            <a class="prn" rel="nofollow" href="JavaScript:void(0);" onclick="document.getElementById('start').value = <? echo $back; ?>;
            document.getElementById('<? echo $frmName; ?>').submit();">&lt; Previous</a>&nbsp;
        <?
        }
    }
    $l = 1;
    for($i = 0; $i < $totalRows; $i = $i+$limit)
    {
        if($i == $eu)
            echo '<span>'.$l.'</span>&nbsp;';
        else
        {
            if($formSubmit == '0')
                echo '<a href="'.$page_name.'?start='.$i.$txtlqry.'">'.$l.'</a>&nbsp;';
            else if($formSubmit == '1')
            { ?>
                <a href="JavaScript:void(0);" onclick="document.getElementById('start').value = <? echo $i; ?>;
                document.getElementById('<? echo $frmName; ?>').submit();"><? echo $l; ?></a>&nbsp;
            <?
            }
        }
        if($l != 0)
        {
            if($l % 25 == 0)
                echo '<br /><br />';
        }
        $l = $l+1;
        if($i < $totalRows)
            $pLast=$i;
    }
    if($thisp < $totalRows)
    {
        if($formSubmit == '0')
            echo '<a href="'.$page_name.'?start='.$next.$txtlqry.'" class="prn" rel="nofollow">Next &gt;</a>&nbsp;';
        else if($formSubmit == '1')
        { ?>
            <a class="prn" rel="nofollow" href="JavaScript:void(0);" onclick="document.getElementById('start').value = <? echo $next; ?>;
            document.getElementById('<? echo $frmName; ?>').submit();">Next &gt;</a>&nbsp;
        <?
        }
    }
    else
        echo '<span class="prn">Next &gt;</span>&nbsp;';
    echo '<p id="total_count">(Total '.$totalRows.' results)</p></div>';
}
function doPages_DropDown($page_name, $back, $start, $txtlqry, $totalRows, $limit, $eu, $pLast, $thisp, $next, $frmName = '')
{
    $l = 1;
    $strOptions = '';
    $currPage = 0;
    for($i = 0; $i < $totalRows; $i = $i+$limit)
    {
        $selected = '';
        if($i == $eu)
        {
            $selected = 'selected';
            $currPage = $l;
        }
        $strOptions .= '<option '.$selected.' value="'.$i.'">'.$l.'</option>';
        $l = $l+1;
    }
    ?>
    <br />
    <div class="form-group" align="right">
        <label class="control-label">Page Number</label>
        <select id="pagingId" name="pagingId" onchange="document.getElementById('start').value = document.getElementById('pagingId').value;
            document.getElementById('<? echo $frmName; ?>').submit();" class="form-control" style="width:75px;">
            <? echo $strOptions; ?>
        </select>
        <span class="help-block">(Total <? echo $totalRows; ?> results)</span>
    </div>
<?
}
function do_Pages($page_name, $back, $start, $txtlqry, $totalRows, $limit, $eu, $pLast, $thisp, $next, $formSubmit = 0, $frmName = '')
{
    echo '<ul style="float:right;list-style:none;">';
    if($back < 0) {
        echo '<li style="float:left;"><a href="JavaScript:void(0);"><<</a></li>';
    } else {
        if($formSubmit == '0')
            echo '<li style="float:left;"><a href="'.$page_name.'?start='.$back.$txtlqry.'" class="prn" rel="nofollow"><<</a></li>';
        else if($formSubmit == '1')
        { ?>
            <li style="float:left;"><a class="prn" rel="nofollow" href="JavaScript:void(0);" onclick="document.getElementById('start').value = <? echo $back; ?>;
            document.getElementById('<? echo $frmName; ?>').submit();"><<</a></li>
        <?
        }
    }
    $l = 1;
    for($i = 0; $i < $totalRows; $i = $i+$limit)
    {
        if($i == $eu)
            echo '<li style="float:left;"><a href="JavaScript:void(0);">'.$l.'</a></li>';
        else
        {
            if($formSubmit == '0')
                echo '<li style="float:left;"><a href="'.$page_name.'?start='.$i.$txtlqry.'">'.$l.'</a></li>';
            else if($formSubmit == '1')
            { ?>
                <li style="float:left;"><a href="JavaScript:void(0);" onclick="document.getElementById('start').value = <? echo $i; ?>;
                document.getElementById('<? echo $frmName; ?>').submit();"><? echo $l; ?></a></li>
            <?
            }
        }
        if($l != 0)
        {
            if($l % 25 == 0)
                echo '<br /><br />';
        }
        $l = $l+1;
        if($i < $totalRows)
            $pLast=$i;
    }
    if($thisp < $totalRows)
    {
        if($formSubmit == '0')
            echo '<li style="float:left;"><a href="'.$page_name.'?start='.$next.$txtlqry.'" class="prn" rel="nofollow">>></a></li>';
        else if($formSubmit == '1')
        { ?>
            <li style="float:left;"><a class="prn" rel="nofollow" href="JavaScript:void(0);" onclick="document.getElementById('start').value = <? echo $next; ?>;
            document.getElementById('<? echo $frmName; ?>').submit();">>></a></li>
        <?
        }
    }
    else
        echo '<li style="float:left;"><a href="JavaScript:void(0);">>></a></li>';
    if($totalRows > 0)
        echo '<br /><br /><div id="total_count"><b>(Total '.$totalRows.' results)<b></div>';
    echo '</ul>';
}
function roundMe($value)
{
    if($value != '')
        return number_format($value, 2, '.', '');
    else
        return '0.00';
}
function decodeHTML($str)
{
    return htmlspecialchars_decode($str);
}
function replaceBRTag($str)
{
    return str_replace('<br />', "", $str);
}
function fillTheCList($parentId, $level) //completely expand category tree
{
    $q = mysqli_query("SELECT CategoryId, Category, ParentCategoryId FROM tbl_gf_sc_category WHERE CategoryId<>0 and ParentCategoryId=$parentId ORDER BY Category") or die('Error!');
    $a = array(); //parents
    while ($row = mysqli_fetch_array($q))
    {
        $row[3] = $level;
        $a[] = $row;
        //process subcategories
        $b = fillTheCList($row[0], $level+1);
        //add $b[] to the end of $a[]
        for ($j=0; $j<count($b); $j++)
        {
            $a[] = $b[$j];
        }
    }
    return $a;
} //fillTheCList
function getTicketBGColor($oStatusId)
{
    $strBGColor = '';
    switch($oStatusId)
    {
        case '1';
            $strBGColor = 'style="background-color:#FFFFC0; color:#000000;"';
            break;
        case '2';
            $strBGColor = 'style="background-color:#CCCCCC; color:#000000;"';
            break;
        case '3';
            $strBGColor = 'style="background-color:#FFCF7F; color:#000000;"';
            break;
        case '4';
            $strBGColor = 'style="background-color:#F35959; color:#FFFFFF;"';
            break;
    }
    return $strBGColor;
}
function getOrderBGColor($oStatusId)
{
    $strBGColor = '';
    switch($oStatusId)
    {
        case '1';
            $strBGColor = 'style="background-color:#F0AD4E; color:#FFFFFF;"';
            break;
        case '2';
            $strBGColor = 'style="background-color:#1D943B; color:#FFFFFF;"';
            break;
        case '3';
            $strBGColor = 'style="background-color:#BB2413; color:#FFFFFF;"';
            break;
        case '4';
            $strBGColor = 'style="background-color:#F0AD4E; color:#FFFFFF;"';
            break;
    }
    return $strBGColor;
}
function getStatusBGColor($oStatusId)
{
    $strBGColor = '';
    switch($oStatusId)
    {
        case '1';
            $strBGColor = 'blue';
            break;
        case '2';
            $strBGColor = 'green';
            break;
        case '3';
            $strBGColor = 'red';
            break;
        case '4';
            $strBGColor = 'orange';
            break;
    }
    return $strBGColor;
}
function getPaymentBGColor($pStatusId)
{
    $strBGColor = '';
    switch($pStatusId)
    {
        case '1';
            $strBGColor = 'style="background-color:#BB2413; color:#FFFFFF; font-size:15px;"';
            break;
        case '2';
            $strBGColor = 'style="background-color:#1D943B; color:#FFFFFF; font-size:15px;"';
            break;
    }
    return $strBGColor;
}
function xmltest($xml)
{
    $arr = array();

    foreach($xml as $element)
    {
        $arr[$element->getName()]=array();
        foreach($element->attributes() as $key=>$value)
        {
            $arr[$element->getName()][$key]=(string)$value;
        }
        foreach($element as $key=>$value)
        {
            $arr[$element->getName()][$key]=array();
            if(!$value->children() && (!empty($value)))
            {
            $arr[$element->getName()][$key]=(string)$value;
            }
        }
    }
    return $arr;
}
function convertPostToArray()
{
    static $post;
    if (!isset($post))
    {
        $pairs = explode("&", file_get_contents("php://input"));
        $post = array();
        foreach ($pairs as $pair)
        {
            $x = explode("=", $pair);
            $post[rawurldecode($x[0])] = rawurldecode($x[1]);
        }
    }
    return $post;
}
function imeiOrderRefunded($orderId, $objDBCD14)
{
    $row = $objDBCD14->queryUniqueObject("SELECT Refunded FROM tbl_gf_codes WHERE CodeId = '$orderId'");
    return $row->Refunded;
}
function fileOrderRefunded($orderId, $objDBCD14)
{
    $row = $objDBCD14->queryUniqueObject("SELECT Refunded FROM tbl_gf_codes_slbf WHERE CodeId = '$orderId'");
    return $row->Refunded;
}
function serverOrderRefunded($orderId, $objDBCD14)
{
    $row = $objDBCD14->queryUniqueObject("SELECT Refunded FROM tbl_gf_log_requests WHERE LogRequestId = '$orderId'");
    return $row->Refunded;
}
function refundIMEICredits($userId, $orderId, $imei, $packTitle, $currDtTm, $packageId, $amountToRefund, $byAdmin, $objDBCD14, $crypt = '', $comments = '')
{
    if(!is_object($crypt))
    {
        require_once("include/php/crypt.php");
        $crypt = new crypt;
    }
    $crypt->crypt_key($userId);
    if($amountToRefund > 0)
    {
        $points = 0;
        $row = $objDBCD14->queryUniqueObject("SELECT Credits FROM tbl_gf_users WHERE UserId = '$userId'");
        if (isset($row->Credits) && $row->Credits != '')
            $points = $row->Credits;

        $dec_points = $crypt->decrypt($points);
        $dec_points += $amountToRefund;
        $enc_points = $crypt->encrypt($dec_points);
        $objDBCD14->execute("UPDATE tbl_gf_users SET Credits = '$enc_points' WHERE UserId = '$userId'");

        $objDBCD14->execute("INSERT INTO tbl_gf_credit_history SET ByAdmin = '$byAdmin', UserId = '$userId', Credits = '$amountToRefund',
                Description = 'Credits Refunded, IMEI Order Rejected for $packTitle', IMEINo = '$imei', HistoryDtTm = '$currDtTm',
                CreditsLeft = '$enc_points', PackageId = '$packageId', Comments = '$comments'");
    }
    return $dec_points;
}
function rebateIMEICredits($userId, $orderId, $imei, $packTitle, $currDtTm, $packageId, $amount, $byAdmin, $objDBCD14)
{
    require_once("include/php/crypt.php");
    $crypt = new crypt;
    $crypt->crypt_key($userId);
    if($amount > 0)
    {
        $points = 0;
        $row = $objDBCD14->queryUniqueObject("SELECT Credits FROM tbl_gf_users WHERE UserId = '$userId'");
        if (isset($row->Credits) && $row->Credits != '')
            $points = $row->Credits;

        $dec_points = $crypt->decrypt($points);
        $dec_points -= $amount;
        $enc_points = $crypt->encrypt($dec_points);
        $objDBCD14->execute("UPDATE tbl_gf_users SET Credits = '$enc_points' WHERE UserId = '$userId'");

        $objDBCD14->execute("INSERT INTO tbl_gf_credit_history SET ByAdmin = '$byAdmin', UserId = '$userId', Credits = '$amount',
                Description = 'Credits Rebated - IMEI Order for $packTitle', IMEINo = '$imei', HistoryDtTm = '$currDtTm',
                CreditsLeft = '$enc_points', PackageId = '$packageId'");
    }
}

function refundFileCredits($userId, $orderId, $imei, $packTitle, $currDtTm, $packageId, $amountToRefund, $byAdmin, $objDBCD14, $crypt = '', $comments = '')
{
    if(!is_object($crypt))
    {
        require_once("include/php/crypt.php");
        $crypt = new crypt;
    }
    $crypt->crypt_key($userId);
    if($amountToRefund > 0)
    {
        $points = 0;
        $row = $objDBCD14->queryUniqueObject("SELECT Credits FROM tbl_gf_users WHERE UserId = '$userId'");
        if (isset($row->Credits) && $row->Credits != '')
            $points = $row->Credits;

        $dec_points = $crypt->decrypt($points);
        $dec_points += $amountToRefund;
        $enc_points = $crypt->encrypt($dec_points);
        $objDBCD14->execute("UPDATE tbl_gf_users SET Credits = '$enc_points' WHERE UserId = '$userId'");

        $objDBCD14->execute("INSERT INTO tbl_gf_credit_history SET ByAdmin = '$byAdmin', UserId = '$userId', Credits = '$amountToRefund',
                Description = 'Credits Refunded, File Order Rejected for $packTitle', IMEINo = '$imei', HistoryDtTm = '$currDtTm',
                CreditsLeft = '$enc_points', PackageId = '$packageId', Comments = '$comments'");
    }
    return $dec_points;
}
function rebateFileCredits($userId, $orderId, $imei, $packTitle, $currDtTm, $packageId, $amount, $byAdmin, $objDBCD14)
{
    require_once("include/php/crypt.php");
    $crypt = new crypt;
    $crypt->crypt_key($userId);
    if($amount > 0)
    {
        $points = 0;
        $row = $objDBCD14->queryUniqueObject("SELECT Credits FROM tbl_gf_users WHERE UserId = '$userId'");
        if (isset($row->Credits) && $row->Credits != '')
            $points = $row->Credits;

        $dec_points = $crypt->decrypt($points);
        $dec_points -= $amount;
        $enc_points = $crypt->encrypt($dec_points);
        $objDBCD14->execute("UPDATE tbl_gf_users SET Credits = '$enc_points' WHERE UserId = '$userId'");

        $objDBCD14->execute("INSERT INTO tbl_gf_credit_history SET ByAdmin = '$byAdmin', UserId = '$userId', Credits = '$amount',
                Description = 'Credits Rebated - File Order for $packTitle', IMEINo = '$imei', HistoryDtTm = '$currDtTm',
                CreditsLeft = '$enc_points', PackageId = '$packageId'");
    }
}

function refundServerCredits($userId, $orderId, $packTitle, $currDtTm, $amountToRefund, $byAdmin, $objDBCD14, $crypt = '', $comments = '')
{
    if(!is_object($crypt))
    {
        require_once("include/php/crypt.php");
        $crypt = new crypt;
    }
    $crypt->crypt_key($userId);
    if($amountToRefund > 0)
    {
        $points = 0;
        $row = $objDBCD14->queryUniqueObject("SELECT Credits FROM tbl_gf_users WHERE UserId = '$userId'");
        if (isset($row->Credits) && $row->Credits != '')
            $points = $row->Credits;

        $dec_points = $crypt->decrypt($points);
        $dec_points += $amountToRefund;
        $enc_points = $crypt->encrypt($dec_points);
        $objDBCD14->execute("UPDATE tbl_gf_users SET Credits = '$enc_points' WHERE UserId = '$userId'");

        $objDBCD14->execute("INSERT INTO tbl_gf_credit_history SET ByAdmin = '$byAdmin', UserId = '$userId', Credits = '$amountToRefund',
                Description = 'Credits Refunded, Server Order Rejected for $packTitle', HistoryDtTm = '$currDtTm', CreditsLeft = '$enc_points',
                LogRequestId = '$orderId', Comments = '$comments'");
    }
    return $dec_points;
}
function rebateServerCredits($userId, $orderId, $packTitle, $currDtTm, $amount, $byAdmin, $objDBCD14)
{
    require_once("include/php/crypt.php");
    $crypt = new crypt;
    $crypt->crypt_key($userId);
    if($amount > 0)
    {
        $points = 0;
        $row = $objDBCD14->queryUniqueObject("SELECT Credits FROM tbl_gf_users WHERE UserId = '$userId'");
        if (isset($row->Credits) && $row->Credits != '')
            $points = $row->Credits;

        $dec_points = $crypt->decrypt($points);
        $dec_points -= $amount;
        $enc_points = $crypt->encrypt($dec_points);
        $objDBCD14->execute("UPDATE tbl_gf_users SET Credits = '$enc_points' WHERE UserId = '$userId'");

        $objDBCD14->execute("INSERT INTO tbl_gf_credit_history SET ByAdmin = '$byAdmin', UserId = '$userId', Credits = '$amountToRefund',
                Description = 'Credits Rebated, Server Order for $packTitle', HistoryDtTm = '$currDtTm', CreditsLeft = '$enc_points',
                LogRequestId = '$orderId'");
    }
}
function sendOrderEmail($colName, $objDBCD14)
{
    $row = $objDBCD14->queryUniqueObject("SELECT $colName FROM tbl_gf_email_settings WHERE Id = 1");
    return $row->$colName;
}
function trimCode($code)
{
    $arr = explode('Download Your report', $code);
    if(isset($arr[0]))
        $code = $arr[0];
    return $code;
}
function checkAndSendSMS($userPhone, $adminPhone, $templateId, $name, $service, $imei, $code, $orderDt, $notes = '', $objDBCD14)
{
    $row = $objDBCD14->queryUniqueObject("SELECT SMSGatewayId, Username, Password FROM tbl_gf_sms_gateways WHERE DisableSMSGateway = 0");
    if (isset($row->SMSGatewayId) && $row->SMSGatewayId != '' && $row->Username != '')
    {
        $userPhone = str_replace(' ', '', $userPhone);
        $userPhone = str_replace('-', '', $userPhone);

        $adminPhone = str_replace(' ', '', $adminPhone);
        $adminPhone = str_replace('-', '', $adminPhone);

        $contents = getSMSContents($templateId, $objDBCD14);
        if($contents != '')
        {
            $placeholders  = array("#CUSTOMER_NAME#", "#SERVICE_NAME#", "#IMEI_NO#", "#DETAILS#", "#ORDER_DATE#", '#NOTES#');
            $replacedData = array($name, $service, $imei, $code, $orderDt, $notes);
            $smsMsg = str_replace($placeholders, $replacedData, $contents);
            sendSMS($row->SMSGatewayId, $row->Username, $row->Password, $smsMsg, $userPhone, $adminPhone);
        }
    }
}
function getSMSContents($id, $objDBCD14)
{
    $contents = '';
    $row = $objDBCD14->queryUniqueObject("SELECT Contents FROM tbl_gf_sms_templates WHERE TemplateId = '$id'");
    if (isset($row->Contents) && $row->Contents != '')
    {
        $contents = stripslashes($row->Contents);
    }
    return $contents;
}
function sendSMS($smsGatewayId, $userName, $password, $smsMsg, $userPhone, $adminPhone)
{
    switch($smsGatewayId)
    {
        case '1':
            include_once 'apis_sms/infobip.com/api.php';
            $obj = new infoBipSMS;
            $obj->send_sms_infobip($adminPhone, $userPhone, $smsMsg, $userName, $password);
            break;
    }

}
function convertCredits($credits, $currencyId, $objDBCD14)
{
    $rate = 1;
    $row = $objDBCD14->queryUniqueObject("SELECT ConversionRate FROM tbl_gf_currency WHERE CurrencyId = '$currencyId'");
    if (isset($row->ConversionRate) && $row->ConversionRate != '')
    {
        $rate = $row->ConversionRate;
    }
    return roundMe($credits * $rate);
}
function userStatusEmail($userId, $objDBCD14)
{
    $rwUN = $objDBCD14->queryUniqueObject("SELECT CONCAT(FirstName, '', LastName) AS UName, UserEmail, DisableUser FROM tbl_gf_users WHERE UserId = '$userId'");
    if (isset($rwUN->DisableUser) && $rwUN->DisableUser != '')
    {
        $name = $rwUN->UName;
        $dUser = $rwUN->DisableUser;
        $email = $rwUN->UserEmail;
    }
    $arr = getEmailDetails($objDBCD14);
    list($subject, $contents, $sendCopy) = getEmailContents($dUser == '1' ? '22' : '21', $objDBCD14);
    $placeholders  = array("#CUSTOMER_NAME#", "#COMPANY_NAME#", "#COMPANY_EMAIL_ADDRESS#", "#LOGIN_LINK#");
    $replacedData = array($name, stripslashes($arr[2]), '<a href="mailto:'.$arr[1].'">'.$arr[1].'</a>',
                    '<a href="mailto:'.$arr[1].'">'.$arr[1].'</a>', '<a href="http://'.$arr[3].'/login.php">http://'.$arr[3].'/login.php</a>');
    $subject = str_replace($placeholders, $replacedData, $subject);
    $emailMsg = str_replace($placeholders, $replacedData, $contents);
    sendMail($email, $arr[0], $arr[1], $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
}
function registrationEmail($email, $name, $ip, $userId, $uName, $allowUserToLogin, $objDBCD14)
{
    $arr = getEmailDetails($objDBCD14);
    list($subject, $contents, $sendCopy) = getEmailContents($allowUserToLogin == '1' ? '1' : '23', $objDBCD14);
    $placeholders  = array("#CUSTOMER_NAME#", "#IP#", "#COMPANY_NAME#", "#COMPANY_EMAIL_ADDRESS#", "#ACTIVATION_LINK#");
    $replacedData = array($name, $ip, stripslashes($arr[2]), '<a href="mailto:'.$arr[1].'">'.$arr[1].'</a>',
    '<a href="http://'.$arr[3].'/activateclient.php?tkn1='.urlsafe_b64encode($userId).'&tkn2='.urlsafe_b64encode($uName).'">http://'.$arr[3].'/activateclient.php?tkn1='.urlsafe_b64encode($userId).'&tkn2='.urlsafe_b64encode($uName).'</a>');
    $subject = str_replace($placeholders, $replacedData, $subject);
    $emailMsg = str_replace($placeholders, $replacedData, $contents);
    sendMail($email, $arr[0], $arr[1], $subject, $emailMsg, $sendCopy == '1' ? $arr[1] : '');
}
function getRealUserIp()
{
    switch(true)
    {
        case (!empty($_SERVER['HTTP_X_REAL_IP'])) : return $_SERVER['HTTP_X_REAL_IP'];
        case (!empty($_SERVER['HTTP_CLIENT_IP'])) : return $_SERVER['HTTP_CLIENT_IP'];
        case (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) : return $_SERVER['HTTP_X_FORWARDED_FOR'];
        default : return $_SERVER['REMOTE_ADDR'];
    }
}
?>