Exemplo n.º 1
0
function AddReply($ticketid, $userid, $contactid, $message, $admin, $attachfile = "", $from = "", $status = "", $noemail = "", $api = false)
{
    global $CONFIG;
    if ($admin) {
        $data = get_query_vals("tbltickets", "userid,contactid,name,email", array("id" => $ticketid));
        if (0 < $data['userid']) {
            if (0 < $data['contactid']) {
                $data = get_query_vals("tblcontacts", "firstname,lastname,email", array("id" => $data['contactid'], "userid" => $data['userid']));
            } else {
                $data = get_query_vals("tblclients", "firstname,lastname,email", array("id" => $data['userid']));
            }
            $message = str_replace("[NAME]", $data['firstname'] . " " . $data['lastname'], $message);
            $message = str_replace("[FIRSTNAME]", $data['firstname'], $message);
            $message = str_replace("[EMAIL]", $data['email'], $message);
        } else {
            $message = str_replace("[NAME]", $data['name'], $message);
            $message = str_replace("[FIRSTNAME]", current(explode(" ", $data['name'])), $message);
            $message = str_replace("[EMAIL]", $data['email'], $message);
        }
        if (!function_exists("getAdminName")) {
            require ROOTDIR . "/includes/adminfunctions.php";
        }
        $adminname = $api ? $admin : getAdminName();
    }
    $table = "tblticketreplies";
    $array = array("tid" => $ticketid, "userid" => $userid, "contactid" => $contactid, "name" => $from['name'], "email" => $from['email'], "date" => "now()", "message" => $message, "admin" => $adminname, "attachment" => $attachfile);
    $ticketreplyid = insert_query($table, $array);
    $result = select_query("tbltickets", "tid,did,title,urgency,flag", array("id" => $ticketid));
    $data = mysql_fetch_array($result);
    $tid = $data['tid'];
    $deptid = $data['did'];
    $tickettitle = $data['title'];
    $urgency = $data['urgency'];
    $flagadmin = $data['flag'];
    if ($userid) {
        $result = select_query("tblclients", "firstname,lastname", array("id" => $userid));
        $data = mysql_fetch_array($result);
        $clientname = $data['firstname'] . " " . $data['lastname'];
    } else {
        $clientname = $from['name'];
    }
    $deptname = getDepartmentName($deptid);
    if ($admin) {
        if ($status == "") {
            $status = "Answered";
        }
        $updateqry = array("status" => $status, "clientunread" => "1", "lastreply" => "now()");
        if ($CONFIG['TicketLastReplyUpdateClientOnly']) {
            unset($updateqry['lastreply']);
        }
        update_query("tbltickets", $updateqry, array("id" => $ticketid));
        addTicketLog($ticketid, "New Ticket Response");
        if (!$noemail) {
            sendMessage("Support Ticket Reply", $ticketid, $ticketreplyid);
        }
        run_hook("TicketAdminReply", array("ticketid" => $ticketid, "replyid" => $ticketreplyid, "deptid" => $deptid, "deptname" => $deptname, "subject" => $tickettitle, "message" => $message, "priority" => $urgency, "admin" => $adminname, "status" => $status));
        return null;
    }
    $status = "Customer-Reply";
    update_query("tbltickets", array("status" => "Customer-Reply", "clientunread" => "1", "adminunread" => "", "lastreply" => "now()"), array("id" => $ticketid));
    addTicketLog($ticketid, "New Ticket Response made by User");
    if ($flagadmin) {
        sendAdminMessage("Support Ticket Response", array("ticket_id" => $ticketid, "ticket_tid" => $tid, "client_id" => $userid, "client_name" => $clientname, "ticket_department" => $deptname, "ticket_subject" => $tickettitle, "ticket_priority" => $urgency, "ticket_message" => ticketMessageFormat($message)), "support", "", $flagadmin);
    } else {
        if (!$noemail) {
            sendAdminMessage("Support Ticket Response", array("ticket_id" => $ticketid, "ticket_tid" => $tid, "client_id" => $userid, "client_name" => $clientname, "ticket_department" => $deptname, "ticket_subject" => $tickettitle, "ticket_priority" => $urgency, "ticket_message" => ticketMessageFormat($message)), "support", $deptid, "", true);
        }
    }
    run_hook("TicketUserReply", array("ticketid" => $ticketid, "replyid" => $ticketreplyid, "userid" => $userid, "deptid" => $deptid, "deptname" => $deptname, "subject" => $tickettitle, "message" => $message, "priority" => $urgency, "status" => $status));
}
Exemplo n.º 2
0
function createUpgradeOrder($id, $ordernotes, $promocode, $paymentmethod)
{
    global $CONFIG;
    global $remote_ip;
    global $orderdescription;
    global $orderamount;
    if ($promocode && !$GLOBALS['qualifies']) {
        $promocode = "";
    }
    if ($promocode) {
        $result = select_query("tblpromotions", "upgradeconfig", array("code" => $promocode));
        $data = mysql_fetch_array($result);
        $upgradeconfig = $data['upgradeconfig'];
        $upgradeconfig = unserialize($upgradeconfig);
        $promo_type = $upgradeconfig['discounttype'];
        $promo_value = $upgradeconfig['value'];
        update_query("tblpromotions", array("uses" => "+1"), array("code" => $promocode));
    }
    $order_number = generateUniqueID();
    $orderid = insert_query("tblorders", array("ordernum" => $order_number, "userid" => $_SESSION['uid'], "date" => "now()", status => "Pending", "promocode" => $promocode, "promotype" => $promo_type, "promovalue" => $promo_value, "paymentmethod" => $paymentmethod, "ipaddress" => $remote_ip, "amount" => $orderamount, "notes" => $ordernotes));
    foreach ($_SESSION['upgradeids'] as $upgradeid) {
        update_query("tblupgrades", array("orderid" => $orderid), array("id" => $upgradeid));
    }
    sendMessage("Order Confirmation", $_SESSION['uid'], array("order_id" => $orderid, "order_number" => $order_number, "order_details" => $orderdescription));
    logActivity("Upgrade Order Placed - Order ID: " . $orderid);
    if (!function_exists("createInvoices")) {
        include ROOTDIR . "/includes/processinvoices.php";
    }
    $invoiceid = 0;
    $invoiceid = createInvoices($_SESSION['uid'], true);
    if ($invoiceid) {
        $result = select_query("tblinvoiceitems", "invoiceid", "type='Upgrade' AND relid IN (" . db_build_in_array(db_escape_numarray($_SESSION['upgradeids'])) . ")", "invoiceid", "DESC");
        $data = mysql_fetch_array($result);
        $invoiceid = $data['invoiceid'];
    }
    if ($CONFIG['OrderDaysGrace']) {
        $new_time = mktime(0, 0, 0, date("m"), date("d") + $CONFIG['OrderDaysGrace'], date("Y"));
        $duedate = date("Y-m-d", $new_time);
        update_query("tblinvoices", array("duedate" => $duedate), array("id" => $invoiceid));
    }
    if (!$CONFIG['NoInvoiceEmailOnOrder']) {
        sendMessage("Invoice Created", $invoiceid);
    }
    update_query("tblorders", array("invoiceid" => $invoiceid), array("id" => $orderid));
    $result = select_query("tblclients", "firstname, lastname, companyname, email, address1, address2, city, state, postcode, country, phonenumber, ip, host", array("id" => $_SESSION['uid']));
    $data = mysql_fetch_array($result);
    list($firstname, $lastname, $companyname, $email, $address1, $address2, $city, $state, $postcode, $country, $phonenumber, $ip, $host) = $data;
    $nicegatewayname = get_query_val("tblpaymentgateways", "value", array("gateway" => $paymentmethod, "setting" => "Name"));
    $ordertotal = get_query_val("tblinvoices", "total", array("id" => $invoiceid));
    $adminemailitems = "";
    if ($invoiceid) {
        $result = select_query("tblinvoiceitems", "description", "type='Upgrade' AND relid IN (" . db_build_in_array(db_escape_numarray($_SESSION['upgradeids'])) . ")", "invoiceid", "DESC");
        while ($invoicedata = mysql_fetch_assoc($result)) {
            $adminemailitems .= $invoicedata['description'] . "<br />";
        }
    } else {
        $adminemailitems .= "Upgrade/Downgrade";
    }
    sendAdminMessage("New Order Notification", array("order_id" => $orderid, "order_number" => $order_number, "order_date" => date("d/m/Y H:i:s"), "invoice_id" => $invoiceid, "order_payment_method" => $nicegatewayname, "order_total" => formatCurrency($ordertotal), "client_id" => $_SESSION['uid'], "client_first_name" => $firstname, "client_last_name" => $lastname, "client_email" => $email, "client_company_name" => $companyname, "client_address1" => $address1, "client_address2" => $address2, "client_city" => $city, "client_state" => $state, "client_postcode" => $postcode, "client_country" => $country, "client_phonenumber" => $phonenumber, "order_items" => $adminemailitems, "order_notes" => "", "client_ip" => $ip, "client_hostname" => $host), "account");
    return array("id" => $id, "orderid" => $orderid, "order_number" => $order_number, "invoiceid" => $invoiceid);
}
Exemplo n.º 3
0
 public function sendAdminEmail($tplname, $adminid = "", $notifydeptadmins = false, $vars = array())
 {
     $tplvars = array("ticket_id" => $this->getData("id"), "ticket_tid" => $this->getData("tid"), "client_id" => $this->getData("userid"), "client_name" => $this->getClientName(), "ticket_department" => $this->getDeptName(), "ticket_subject" => $this->getData("title"), "ticket_priority" => $this->getData("urgency"), "ticket_message" => $this->formatMsg());
     if (is_array($vars)) {
         foreach ($vars as $k => $v) {
             $tplvars[$k] = $v;
         }
     }
     sendAdminMessage($tplname, $tplvars, "support", $this->getData("did"), $adminid, $notifydeptadmins);
 }
Exemplo n.º 4
0
            } else {
                $clientsdetails = array();
                $clientsdetails['firstname'] = $data['firstname'];
                $clientsdetails['lastname'] = $data['lastname'];
                $clientsdetails['companyname'] = $data['companyname'];
                $clientsdetails['email'] = $data['email'];
                $clientsdetails['address1'] = $data['address1'];
                $clientsdetails['address2'] = $data['address2'];
                $clientsdetails['city'] = $data['city'];
                $clientsdetails['state'] = $data['state'];
                $clientsdetails['postcode'] = $data['postcode'];
                $clientsdetails['country'] = $data['country'];
                $clientsdetails['phonenumber'] = $data['phonenumber'];
            }
            sendMessage("Quote Accepted", $_SESSION['uid'], array("emailquote" => true, "quote_number" => $id, "quote_subject" => $quote_data['subject'], "quote_date_created" => $quote_data['datecreated'], "client_name" => $clientsdetails['firstname'] . " " . $clientsdetails['lastname'], "invoice_num" => ""));
            sendAdminMessage("Quote Accepted Notification", array("quote_number" => $id, "quote_subject" => $quote_data['subject'], "quote_date_created" => $quote_data['datecreated'], "client_id" => $vars['userid'], "clientname" => $clientsdetails['firstname'] . " " . $clientsdetails['lastname'], "client_email" => $clientsdetails['email'], "client_company_name" => $clientsdetails['companyname'], "client_address1" => $clientsdetails['address1'], "client_address2" => $clientsdetails['address2'], "client_city" => $clientsdetails['city'], "client_state" => $clientsdetails['state'], "client_postcode" => $clientsdetails['postcode'], "client_country" => $clientsdetails['country'], "client_phonenumber" => $clientsdetails['phonenumber'], "client_ip" => $clientsdetails['ip'], "client_hostname" => $clientsdetails['host']), "account");
            run_hook("acceptQuote", array("quoteid" => $id, "invoiceid" => $invoiceid));
        } else {
            $smarty->assign("error", "on");
            $template_output = $smarty->fetch("viewquote.tpl");
            echo $template_output;
            exit;
        }
    }
}
if (isset($_SESSION['adminid'])) {
    $result = select_query("tblquotes", "", array("id" => $id));
} else {
    $result = select_query("tblquotes", "", array("id" => $id, "userid" => $_SESSION['uid'], "stage" => array("sqltype" => "NEQ", "value" => "Draft")));
}
$data = mysql_fetch_array($result);
Exemplo n.º 5
0
function handleUserAPI($args, $that)
{
    require_once APIROOT . 'controller/user.php';
    if ($that->method === 'POST') {
        if ($that->verb === 'login') {
            $result = $that->file;
            $result = login(isset($result->username) ? $result->username : null, isset($result->password) ? $result->password : null);
            return User::current_user();
        } else {
            if ($that->verb === 'logout') {
                return $session->logout();
            } else {
                if ($that->verb === 'register') {
                    $result = $that->file;
                    $result->username = isset($result->username) ? $result->username : null;
                    $result->password = isset($result->password) ? $result->password : null;
                    $result->email = isset($result->email) ? $result->email : null;
                    $result->first = isset($result->first) ? $result->first : null;
                    $result->last = isset($result->last) ? $result->last : null;
                    $result->gender = isset($result->gender) ? $result->gender : null;
                    $result = register($result);
                    return User::current_user();
                } else {
                    if ($that->verb === 'sendAdminMessage') {
                        $user = User::current_user();
                        $that->file->name = $user->displayableName;
                        $that->file->email = $user->email;
                        return sendAdminMessage($that->file);
                    } else {
                        if ($that->verb === 'resetPassword') {
                            $user = User::getByUsername($that->file->username);
                            if ($user) {
                                return $user->resetPassword();
                            }
                        }
                    }
                }
            }
        }
    }
    if ($that->method === 'GET') {
        if ($that->verb === '') {
            $session = mySession::getInstance();
            $user_id = $session->getVar('user_id');
            if ($user_id) {
                $user = User::getById($user_id);
                unset($user->password);
                return $user;
            } else {
                return false;
            }
        }
        if ($that->verb === 'validate') {
            $id = getRequest('id');
            $value = getRequest('validate');
            return validate($id, $value);
        }
        if ($that->verb === 'isLoggedIn') {
            return User::current_user();
        }
        if ($that->verb === 'getUserInfo' && $session->isLoggedIn() && $session->isAdmin()) {
            $id = intval(array_shift($args));
            if ($id && is_numeric($id)) {
                $user = User::getById($id);
                unset($user->password);
                return $user;
            } else {
                return User::getAllUsers();
            }
        }
        $user = User::current_user();
        unset($user->password);
        return $user;
        // return "that is a test";
    } else {
        return "Only accepts GET AND POSTS requests";
    }
}
Exemplo n.º 6
0
function makeDomainPayment($func_domainid, $type = "")
{
    global $whmcs;
    $result = select_query("tbldomains", "", array("id" => $func_domainid));
    $data = mysql_fetch_array($result);
    $userid = $data['userid'];
    $orderid = $data['orderid'];
    $registrationperiod = $data['registrationperiod'];
    $registrationdate = $data['registrationdate'];
    $nextduedate = $data['nextduedate'];
    $recurringamount = $data['recurringamount'];
    $domain = $data['domain'];
    $paymentmethod = $data['paymentmethod'];
    $registrar = $data['registrar'];
    $status = $data['status'];
    $year = substr($nextduedate, 0, 4);
    $month = substr($nextduedate, 5, 2);
    $day = substr($nextduedate, 8, 2);
    $newnextduedate = date("Y-m-d", mktime(0, 0, 0, $month, $day, $year + $registrationperiod));
    update_query("tbldomains", array("nextduedate" => $newnextduedate), array("id" => $func_domainid));
    $domaintype = substr($type, 6);
    $domainparts = explode(".", $domain, 2);
    $sld = $domainparts[0];
    $tld = $domainparts[1];
    $params = array();
    $params['domainid'] = $func_domainid;
    $params['sld'] = $sld;
    $params['tld'] = $tld;
    if (!function_exists("getRegistrarConfigOptions")) {
        require ROOTDIR . "/includes/registrarfunctions.php";
    }
    if ($domaintype == "Register" || $domaintype == "Transfer") {
        $result = select_query("tbldomainpricing", "autoreg", array("extension" => "." . $tld));
        $data = mysql_fetch_array($result);
        $autoreg = $data[0];
        if ($status == "Pending") {
            if (getNewClientAutoProvisionStatus($userid)) {
                if ($autoreg) {
                    update_query("tbldomains", array("registrar" => $autoreg), array("id" => $func_domainid));
                    $params['registrar'] = $autoreg;
                    if ($domaintype == "Register") {
                        logActivity("Running Automatic Domain Registration on Payment", $userid);
                        $result = RegRegisterDomain($params);
                        $emailmessage = "Domain Registration Confirmation";
                    } else {
                        if ($domaintype == "Transfer") {
                            logActivity("Running Automatic Domain Transfer on Payment", $userid);
                            $result = RegTransferDomain($params);
                            $emailmessage = "Domain Transfer Initiated";
                        }
                    }
                    $result = $result['error'];
                    if ($result) {
                        sendAdminMessage("Automatic Setup Failed", array("client_id" => $userid, "domain_id" => $func_domainid, "domain_type" => $domaintype, "domain_name" => $domain, "error_msg" => $result), "account");
                        if ($whmcs->get_config("DomainToDoListEntries")) {
                            if ($domaintype == "Register") {
                                addToDoItem("Manual Domain Registration", "Client ID " . $userid . " has paid for the registration of domain " . $domain . " and the automated registration attempt has failed with the following error: " . $result);
                                return null;
                            }
                            if ($domaintype == "Transfer") {
                                addToDoItem("Manual Domain Transfer", "Client ID " . $userid . " has paid for the transfer of domain " . $domain . " and the automated transfer attempt has failed with the following error: " . $result);
                                return null;
                            }
                        }
                    } else {
                        sendMessage($emailmessage, $func_domainid);
                        sendAdminMessage("Automatic Setup Successful", array("client_id" => $userid, "domain_id" => $func_domainid, "domain_type" => $domaintype, "domain_name" => $domain, "error_msg" => ""), "account");
                        return null;
                    }
                }
                if ($whmcs->get_config("DomainToDoListEntries")) {
                    if ($domaintype == "Register") {
                        addToDoItem("Manual Domain Registration", "Client ID " . $userid . " has paid for the registration of domain " . $domain);
                        return null;
                    }
                    if ($domaintype == "Transfer") {
                        addToDoItem("Manual Domain Transfer", "Client ID " . $userid . " has paid for the transfer of domain " . $domain);
                        return null;
                    }
                }
            } else {
                logActivity("Automatic Domain Registration on Payment Suppressed for New Client", $userid);
                return null;
            }
        }
        if ($autoreg) {
            logActivity("Automatic Domain Registration Suppressed as Domain Is Already Active", $userid);
            return null;
        }
    } else {
        if ($status != "Pending" && $status != "Cancelled" && $status != "Fraud") {
            if ($whmcs->get_config("AutoRenewDomainsonPayment") && $registrar) {
                if ($whmcs->get_config("FreeDomainAutoRenewRequiresProduct") && $recurringamount <= 0 && !get_query_val("tblhosting", "COUNT(*)", array("userid" => $userid, "domain" => $domain, "domainstatus" => "Active"))) {
                    logActivity("Surpressed Automatic Domain Renewal on Payment Due to Domain Being Free and having No Active Associated Product", $userid);
                    sendAdminNotification("account", "Free Domain Renewal Manual Action Required", "The domain " . $domain . " (ID: " . $func_domainid . ") was just invoiced for renewal and automatically marked paid due to it being free, but because no active Product/Service matching the domain was found in order to qualify for the free domain offer, the renewal has not been automatically submitted to the registrar.  You must login to review & process this renewal manually should it be desired.");
                    return null;
                }
                logActivity("Running Automatic Domain Renewal on Payment", $userid);
                $params['registrar'] = $registrar;
                $result = RegRenewDomain($params);
                $result = $result['error'];
                if ($result) {
                    sendAdminMessage("Domain Renewal Failed", array("client_id" => $userid, "domain_id" => $func_domainid, "domain_name" => $domain, "error_msg" => $result), "account");
                    if ($whmcs->get_config("DomainToDoListEntries")) {
                        addToDoItem("Manual Domain Renewal", "Client ID " . $userid . " has paid for the renewal of domain " . $domain . " and the automated renewal attempt has failed with the following error: " . $result);
                        return null;
                    }
                } else {
                    sendMessage("Domain Renewal Confirmation", $func_domainid);
                    sendAdminMessage("Domain Renewal Successful", array("client_id" => $userid, "domain_id" => $func_domainid, "domain_name" => $domain, "error_msg" => ""), "account");
                    return null;
                }
            }
            if ($whmcs->get_config("DomainToDoListEntries")) {
                addToDoItem("Manual Domain Renewal", "Client ID " . $userid . " has paid for the renewal of domain " . $domain);
            }
        }
    }
}
Exemplo n.º 7
0
            }
            if ($flagto) {
                $updateqry['flag'] = $flagto;
                sendAdminMessage("Support Ticket Flagged", array("ticket_id" => $ticketid, "ticket_tid" => $tickettid, "client_id" => $ticketuserid, "client_name" => get_query_val("tblclients", "CONCAT(firstname,' ',lastname)", array("id" => $ticketuserid)), "ticket_department" => getDepartmentName($newdepartment ? $newdepartment : $ticketdeptid), "ticket_subject" => $ticketsubject, "ticket_priority" => $newpriority ? $newpriority : $ticketpriority, "ticket_message" => ticketMessageFormat($ticketmsg)), "support", $newdepartment ? $newdepartment : $ticketdeptid, $flagto);
            }
            if (count($updateqry)) {
                update_query("tbltickets", $updateqry, array("id" => $ticketid));
            }
            if ($notify) {
                $notify = explode(",", $notify);
                if (in_array("all", $notify)) {
                    sendAdminMessage("Escalation Rule Notification", array("rule_name" => $name, "ticket_id" => $ticketid, "ticket_tid" => $tickettid, "client_id" => $ticketuserid, "client_name" => get_query_val("tblclients", "CONCAT(firstname,' ',lastname)", array("id" => $ticketuserid)), "ticket_department" => getDepartmentName($newdepartment ? $newdepartment : $ticketdeptid), "ticket_subject" => $ticketsubject, "ticket_priority" => $newpriority ? $newpriority : $ticketpriority, "ticket_message" => ticketMessageFormat($ticketmsg)), "support", $newdepartment ? $newdepartment : $ticketdeptid);
                }
                foreach ($notify as $notifyid) {
                    if (is_numeric($notifyid)) {
                        sendAdminMessage("Escalation Rule Notification", array("rule_name" => $name, "ticket_id" => $ticketid, "ticket_tid" => $tickettid, "client_id" => $ticketuserid, "client_name" => get_query_val("tblclients", "CONCAT(firstname,' ',lastname)", array("id" => $ticketuserid)), "ticket_department" => getDepartmentName($newdepartment ? $newdepartment : $ticketdeptid), "ticket_subject" => $ticketsubject, "ticket_priority" => $newpriority ? $newpriority : $ticketpriority, "ticket_message" => ticketMessageFormat($ticketmsg), "ticket_status" => $ticketstatus), "support", "", $notifyid);
                        continue;
                    }
                }
            }
            if ($addreply) {
                if (!$newstatus) {
                    $newstatus = $ticketstatus;
                }
                AddReply($ticketid, "", "", $addreply, "System", "", "", $newstatus, "", true);
            }
        }
    }
    update_query("tblconfiguration", array("value" => date("Y-m-d H:i:s")), array("setting" => "TicketEscalationLastRun"));
    exit;
}
Exemplo n.º 8
0
function calcCartTotals($checkout = "", $ignorenoconfig = "")
{
    global $CONFIG;
    global $_LANG;
    global $remote_ip;
    global $currency;
    global $promo_data;
    $cart_total = $cart_discount = $cart_tax = 0;
    run_hook("PreCalculateCartTotals", $_SESSION['cart']);
    if (!$ignorenoconfig) {
        if (array_key_exists("products", $_SESSION['cart'])) {
            foreach ($_SESSION['cart']['products'] as $key => $productdata) {
                if ($productdata['noconfig']) {
                    unset($_SESSION['cart']['products'][$key]);
                    continue;
                }
            }
        }
        $bundlewarnings = bundlesValidateCheckout();
        if (array_key_exists("products", $_SESSION['cart'])) {
            $_SESSION['cart']['products'] = array_values($_SESSION['cart']['products']);
        }
    }
    if ($checkout) {
        if (!$_SESSION['cart']) {
            return false;
        }
        run_hook("PreShoppingCartCheckout", $_SESSION['cart']);
        $order_number = generateUniqueID();
        $paymentmethod = $_SESSION['cart']['paymentmethod'];
        $availablegateways = getAvailableOrderPaymentGateways();
        if (!array_key_exists($paymentmethod, $availablegateways)) {
            foreach ($availablegateways as $k => $v) {
                $paymentmethod = $k;
                break;
            }
        }
        $userid = $_SESSION['uid'];
        $ordernotes = "";
        if ($_SESSION['cart']['notes'] && $_SESSION['cart']['notes'] != $_LANG['ordernotesdescription']) {
            $ordernotes = $_SESSION['cart']['notes'];
        }
        $cartitems = count($_SESSION['cart']['products']) + count($_SESSION['cart']['addons']) + count($_SESSION['cart']['domains']) + count($_SESSION['cart']['renewals']);
        if (!$cartitems) {
            return false;
        }
        $orderid = insert_query("tblorders", array("ordernum" => $order_number, "userid" => $userid, "contactid" => $_SESSION['cart']['contact'], "date" => "now()", "status" => "Pending", "paymentmethod" => $paymentmethod, "ipaddress" => $remote_ip, "notes" => $ordernotes));
        logActivity("New Order Placed - Order ID: " . $orderid . " - User ID: " . $userid);
        $domaineppcodes = array();
    }
    $promotioncode = array_key_exists("promo", $_SESSION['cart']) ? $_SESSION['cart']['promo'] : "";
    if ($promotioncode) {
        $result = select_query("tblpromotions", "", array("code" => $promotioncode));
        $promo_data = mysql_fetch_array($result);
    }
    if (!isset($_SESSION['uid'])) {
        if (!$_SESSION['cart']['user']['country']) {
            $_SESSION['cart']['user']['country'] = $CONFIG['DefaultCountry'];
        }
        $state = $_SESSION['cart']['user']['state'];
        $country = $_SESSION['cart']['user']['country'];
    } else {
        $clientsdetails = getClientsDetails($_SESSION['uid']);
        $state = $clientsdetails['state'];
        $country = $clientsdetails['country'];
    }
    if ($CONFIG['TaxEnabled']) {
        $taxdata = getTaxRate(1, $state, $country);
        $taxname = $taxdata['name'];
        $taxrate = $taxdata['rate'];
        $rawtaxrate = $taxrate;
        $inctaxrate = $taxrate / 100 + 1;
        $taxrate /= 100;
        $taxdata = getTaxRate(2, $state, $country);
        $taxname2 = $taxdata['name'];
        $taxrate2 = $taxdata['rate'];
        $rawtaxrate2 = $taxrate2;
        $inctaxrate2 = $taxrate2 / 100 + 1;
        $taxrate2 /= 100;
    }
    if ($CONFIG['TaxInclusiveDeduct'] && (!$taxrate && !$taxrate2 || $clientsdetails['taxexempt'])) {
        $result = select_query("tbltax", "", "");
        $data = mysql_fetch_array($result);
        $excltaxrate = 1 + $data['taxrate'] / 100;
    } else {
        $CONFIG['TaxInclusiveDeduct'] = 0;
    }
    $cartdata = $productsarray = $tempdomains = $orderproductids = $orderdomainids = $orderaddonids = $orderrenewalids = $freedomains = array();
    $recurring_cycles_total = array("monthly" => 0, "quarterly" => 0, "semiannually" => 0, "annually" => 0, "biennially" => 0, "triennially" => 0);
    if (array_key_exists("products", $_SESSION['cart']) && is_array($_SESSION['cart']['products'])) {
        foreach ($_SESSION['cart']['products'] as $key => $productdata) {
            $result = select_query("tblproducts", "tblproducts.id,tblproducts.gid,tblproductgroups.name AS groupname,tblproducts.name,tblproducts.paytype,tblproducts.allowqty,tblproducts.proratabilling,tblproducts.proratadate,tblproducts.proratachargenextmonth,tblproducts.tax,tblproducts.servertype,tblproducts.servergroup,tblproducts.stockcontrol,tblproducts.freedomain,tblproducts.freedomainpaymentterms,tblproducts.freedomaintlds", array("tblproducts.id" => $productdata['pid']), "", "", "", "tblproductgroups ON tblproductgroups.id=tblproducts.gid");
            $data = mysql_fetch_array($result);
            $pid = $data['id'];
            $gid = $data['gid'];
            $groupname = $data['groupname'];
            $productname = $data['name'];
            $paytype = $data['paytype'];
            $allowqty = $data['allowqty'];
            $proratabilling = $data['proratabilling'];
            $proratadate = $data['proratadate'];
            $proratachargenextmonth = $data['proratachargenextmonth'];
            $tax = $data['tax'];
            $servertype = $data['servertype'];
            $servergroup = $data['servergroup'];
            $stockcontrol = $data['stockcontrol'];
            $freedomain = $data['freedomain'];
            if ($freedomain) {
                $freedomainpaymentterms = $data['freedomainpaymentterms'];
                $freedomaintlds = $data['freedomaintlds'];
                $freedomainpaymentterms = explode(",", $freedomainpaymentterms);
                $freedomaintlds = explode(",", $freedomaintlds);
            } else {
                $freedomainpaymentterms = $freedomaintlds = array();
            }
            $productinfo = getProductInfo($pid);
            $productdata['productinfo'] = $productinfo;
            if (!function_exists("getCustomFields")) {
                require ROOTDIR . "/includes/customfieldfunctions.php";
            }
            $customfields = getCustomFields("product", $pid, "", true, "", $productdata['customfields']);
            $productdata['customfields'] = $customfields;
            $pricing = getPricingInfo($pid);
            $qty = $productdata['qty'];
            if (!$allowqty || !$qty) {
                $qty = 1;
            }
            $productdata['allowqty'] = $allowqty;
            $productdata['qty'] = $qty;
            if ($pricing['type'] == "recurring") {
                $billingcycle = strtolower($productdata['billingcycle']);
                if (!in_array($billingcycle, array("monthly", "quarterly", "semiannually", "annually", "biennially", "triennially"))) {
                    $billingcycle = "";
                }
                if ($pricing['rawpricing'][$billingcycle] < 0) {
                    $billingcycle = "";
                }
                if (!$billingcycle) {
                    if (0 <= $pricing['rawpricing']['monthly']) {
                        $billingcycle = "monthly";
                    } else {
                        if (0 <= $pricing['rawpricing']['quarterly']) {
                            $billingcycle = "quarterly";
                        } else {
                            if (0 <= $pricing['rawpricing']['semiannually']) {
                                $billingcycle = "semiannually";
                            } else {
                                if (0 <= $pricing['rawpricing']['annually']) {
                                    $billingcycle = "annually";
                                } else {
                                    if (0 <= $pricing['rawpricing']['biennially']) {
                                        $billingcycle = "biennially";
                                    } else {
                                        if (0 <= $pricing['rawpricing']['triennially']) {
                                            $billingcycle = "triennially";
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            } else {
                if ($pricing['type'] == "onetime") {
                    $billingcycle = "onetime";
                } else {
                    $billingcycle = "free";
                }
            }
            $productdata['billingcycle'] = $billingcycle;
            if ($billingcycle == "free") {
                $product_setup = $product_onetime = $product_recurring = "0";
                $databasecycle = "Free Account";
            } else {
                if ($billingcycle == "onetime") {
                    $product_setup = $pricing['rawpricing']['msetupfee'];
                    $product_onetime = $pricing['rawpricing']['monthly'];
                    $product_recurring = 0;
                    $databasecycle = "One Time";
                } else {
                    $product_setup = $pricing['rawpricing'][substr($billingcycle, 0, 1) . "setupfee"];
                    $product_onetime = $product_recurring = $pricing['rawpricing'][$billingcycle];
                    $databasecycle = ucfirst($billingcycle);
                    if ($databasecycle == "Semiannually") {
                        $databasecycle = "Semi-Annually";
                    }
                }
            }
            $before_priceoverride_value = "";
            if ($bundleoverride = bundlesGetProductPriceOverride("product", $key)) {
                $before_priceoverride_value = $product_setup + $product_onetime;
                $product_setup = 0;
                $product_onetime = $product_recurring = $bundleoverride;
            }
            $hookret = run_hook("OrderProductPricingOverride", array("key" => $key, "pid" => $pid, "proddata" => $productdata));
            foreach ($hookret as $hookret2) {
                if (is_array($hookret2)) {
                    if ($hookret2['setup']) {
                        $product_setup = $hookret2['setup'];
                    }
                    if ($hookret2['recurring']) {
                        $product_onetime = $product_recurring = $hookret2['recurring'];
                        continue;
                    }
                    continue;
                }
            }
            $productdata['pricing']['baseprice'] = formatCurrency($product_onetime);
            $configurableoptions = array();
            $configurableoptions = getCartConfigOptions($pid, $productdata['configoptions'], $billingcycle);
            $configoptions = "";
            if ($configurableoptions) {
                foreach ($configurableoptions as $confkey => $value) {
                    $configoptions[] = array("name" => $value['optionname'], "type" => $value['optiontype'], "option" => $value['selectedoption'], "optionname" => $value['selectedname'], "setup" => 0 < $value['selectedsetup'] ? formatCurrency($value['selectedsetup']) : "", "recurring" => formatCurrency($value['selectedrecurring']), "qty" => $value['selectedqty']);
                    $configoptionsdb[$value['id']] = array("value" => $value['selectedvalue'], "qty" => $value['selectedqty']);
                    $product_setup += $value['selectedsetup'];
                    $product_onetime += $value['selectedrecurring'];
                    if (strlen($before_priceoverride_value)) {
                        $before_priceoverride_value += $value['selectedrecurring'];
                    }
                    if ($billingcycle != "onetime") {
                        $product_recurring += $value['selectedrecurring'];
                        continue;
                    }
                }
            }
            $productdata['configoptions'] = $configoptions;
            if (in_array($billingcycle, $freedomainpaymentterms)) {
                $domain = $productdata['domain'];
                $domainparts = explode(".", $domain, 2);
                $tld = "." . $domainparts[1];
                if (in_array($tld, $freedomaintlds)) {
                    $freedomains[$domain] = $freedomain;
                }
            }
            if ($proratabilling) {
                $proratavalues = getProrataValues($billingcycle, $product_onetime, $proratadate, $proratachargenextmonth, date("d"), date("m"), date("Y"), $_SESSION['uid']);
                $product_onetime = $proratavalues['amount'];
                $productdata['proratadate'] = fromMySQLDate($proratavalues['date']);
            }
            if ($CONFIG['TaxInclusiveDeduct']) {
                $product_setup = format_as_currency($product_setup / $excltaxrate);
                $product_onetime = format_as_currency($product_onetime / $excltaxrate);
                $product_recurring = format_as_currency($product_recurring / $excltaxrate);
            }
            $product_total_today_db = $product_setup + $product_onetime;
            $product_recurring_db = $product_recurring;
            $productdata['pricing']['setup'] = $product_setup * $qty;
            $productdata['pricing']['recurring'][$billingcycle] = $product_recurring * $qty;
            $productdata['pricing']['totaltoday'] = $product_total_today_db * $qty;
            if ($product_onetime == 0 && $product_recurring == 0) {
                $pricing_text = $_LANG['orderfree'];
            } else {
                $pricing_text = "";
                if (strlen($before_priceoverride_value)) {
                    $pricing_text .= "<strike>" . formatCurrency($before_priceoverride_value) . "</strike> ";
                }
                $pricing_text .= formatCurrency($product_onetime);
                if (0 < $product_setup) {
                    $pricing_text .= " + " . formatCurrency($product_setup) . " " . $_LANG['ordersetupfee'];
                }
                if ($allowqty && 1 < $qty) {
                    $pricing_text .= $_LANG['invoiceqtyeach'] . "<br />" . $_LANG['invoicestotal'] . ": " . formatCurrency($productdata['pricing']['totaltoday']);
                }
            }
            $productdata['pricingtext'] = $pricing_text;
            if ($promotioncode) {
                $onetimediscount = $recurringdiscount = $promoid = 0;
                if ($promocalc = CalcPromoDiscount($pid, $databasecycle, $product_total_today_db, $product_recurring_db, $product_setup)) {
                    $onetimediscount = $promocalc['onetimediscount'];
                    $recurringdiscount = $promocalc['recurringdiscount'];
                    $product_total_today_db -= $onetimediscount;
                    $product_recurring_db -= $recurringdiscount;
                    $cart_discount += $onetimediscount * $qty;
                    $promoid = $promo_data['id'];
                }
            }
            if (isset($productdata['priceoverride'])) {
                $product_total_today_db = $product_recurring_db = $product_onetime = $productdata['priceoverride'];
                $product_setup = 0;
            }
            $cart_total += $product_total_today_db * $qty;
            $product_total_qty_recurring = $product_recurring_db * $qty;
            if ($CONFIG['TaxEnabled'] && $tax && !$clientsdetails['taxexempt']) {
                $cart_tax += $product_total_today_db * $qty;
                if ($CONFIG['TaxType'] == "Exclusive") {
                    if ($CONFIG['TaxL2Compound']) {
                        $product_total_qty_recurring += $product_total_qty_recurring * $taxrate;
                        $product_total_qty_recurring += $product_total_qty_recurring * $taxrate2;
                    } else {
                        $product_total_qty_recurring += $product_total_qty_recurring * $taxrate + $product_total_qty_recurring * $taxrate2;
                    }
                }
            }
            $recurring_cycles_total[$billingcycle] += $product_total_qty_recurring;
            $domain = $productdata['domain'];
            $serverhostname = $productdata['server']['hostname'];
            $serverns1prefix = $productdata['server']['ns1prefix'];
            $serverns2prefix = $productdata['server']['ns2prefix'];
            $serverrootpw = encrypt($productdata['server']['rootpw']);
            if ($serverns1prefix && $domain) {
                $serverns1prefix = $serverns1prefix . "." . $domain;
            }
            if ($serverns2prefix && $domain) {
                $serverns2prefix = $serverns2prefix . "." . $domain;
            }
            if ($serverhostname) {
                $domain = $domain ? $serverhostname . "." . $domain : $serverhostname;
            }
            $productdata['domain'] = $domain;
            if ($checkout) {
                $multiqtyids = array();
                $qtycount = 1;
                while ($qtycount <= $qty) {
                    $serverid = $servertype ? getServerID($servertype, $servergroup) : "0";
                    $hostingquerydates = $databasecycle == "Free Account" ? "0000-00-00" : date("Y-m-d");
                    $serviceid = insert_query("tblhosting", array("userid" => $userid, "orderid" => $orderid, "packageid" => $pid, "server" => $serverid, "regdate" => "now()", "domain" => $domain, "paymentmethod" => $paymentmethod, "firstpaymentamount" => $product_total_today_db, "amount" => $product_recurring_db, "billingcycle" => $databasecycle, "nextduedate" => $hostingquerydates, "nextinvoicedate" => $hostingquerydates, "domainstatus" => "Pending", "ns1" => $serverns1prefix, "ns2" => $serverns2prefix, "password" => $serverrootpw, "promoid" => $promoid));
                    $multiqtyids[$qtycount] = $serviceid;
                    $orderproductids[] = $serviceid;
                    if ($stockcontrol) {
                        full_query("UPDATE tblproducts SET qty=qty-1 WHERE id='" . mysql_real_escape_string($pid) . "'");
                    }
                    if ($configoptionsdb) {
                        foreach ($configoptionsdb as $key => $value) {
                            insert_query("tblhostingconfigoptions", array("relid" => $serviceid, "configid" => $key, "optionid" => $value['value'], "qty" => $value['qty']));
                        }
                    }
                    foreach ($productdata['customfields'] as $key => $value) {
                        insert_query("tblcustomfieldsvalues", array("fieldid" => $value['id'], "relid" => $serviceid, "value" => $value['rawvalue']));
                    }
                    $productdetails = getInvoiceProductDetails($serviceid, $pid, date("Y-m-d"), $hostingquerydates, $databasecycle, $domain);
                    $invoice_description = $productdetails['description'];
                    $invoice_tax = $productdetails['tax'];
                    if (!$_SESSION['cart']['geninvoicedisabled']) {
                        $prodinvoicearray = array();
                        $prodinvoicearray['userid'] = $userid;
                        $prodinvoicearray['type'] = "Hosting";
                        $prodinvoicearray['relid'] = $serviceid;
                        $prodinvoicearray['taxed'] = $invoice_tax;
                        $prodinvoicearray['duedate'] = $hostingquerydates;
                        $prodinvoicearray['paymentmethod'] = $paymentmethod;
                        if (0 < $product_setup) {
                            $prodinvoicearray['description'] = $productname . " " . $_LANG['ordersetupfee'];
                            $prodinvoicearray['amount'] = $product_setup;
                            insert_query("tblinvoiceitems", $prodinvoicearray);
                            $prodinvoicearray['type'] = "";
                            $prodinvoicearray['relid'] = 0;
                        }
                        if (0 < $product_onetime) {
                            $prodinvoicearray['description'] = $invoice_description;
                            $prodinvoicearray['amount'] = $product_onetime;
                            insert_query("tblinvoiceitems", $prodinvoicearray);
                        }
                        $promovals = getInvoiceProductPromo($product_total_today_db, $promoid, $userid, $serviceid, $product_setup + $product_onetime);
                        if ($promovals['description']) {
                            $prodinvoicearray['type'] = "PromoHosting";
                            $prodinvoicearray['description'] = $promovals['description'];
                            $prodinvoicearray['amount'] = $promovals['amount'];
                            insert_query("tblinvoiceitems", $prodinvoicearray);
                        }
                    }
                    $adminemailitems .= $_LANG['orderproduct'] . (": " . $groupname . " - " . $productname . "<br>\r\n");
                    if ($domain) {
                        $adminemailitems .= $_LANG['orderdomain'] . (": " . $domain . "<br>\r\n");
                    }
                    foreach ($configurableoptions as $confkey => $value) {
                        $adminemailitems .= $value['optionname'] . ": " . $value['selectedname'] . "<br />\r\n";
                    }
                    foreach ($customfields as $customfield) {
                        if (!$customfield['adminonly']) {
                            $adminemailitems .= "" . $customfield['name'] . ": " . $customfield['value'] . "<br />\r\n";
                            continue;
                        }
                    }
                    $adminemailitems .= $_LANG['firstpaymentamount'] . ": " . formatCurrency($product_total_today_db) . "<br>\r\n";
                    if ($product_recurring_db) {
                        $adminemailitems .= $_LANG['recurringamount'] . ": " . formatCurrency($product_recurring_db) . "<br>\r\n";
                    }
                    $adminemailitems .= $_LANG['orderbillingcycle'] . ": " . $_LANG["orderpaymentterm" . str_replace(array("-", " "), "", strtolower($databasecycle))] . "<br>\r\n";
                    if ($allowqty && 1 < $qty) {
                        $adminemailitems .= $_LANG['quantity'] . (": " . $qty . "<br>\r\n") . $_LANG['invoicestotal'] . ": " . $productdata['pricing']['totaltoday'] . "<br>\r\n";
                    }
                    $adminemailitems .= "<br>\r\n";
                    ++$qtycount;
                }
            }
            $addonsarray = array();
            $addons = $productdata['addons'];
            if ($addons) {
                foreach ($addons as $addonid) {
                    $result = select_query("tbladdons", "name,description,billingcycle,tax", array("id" => $addonid));
                    $data = mysql_fetch_array($result);
                    $addon_name = $data['name'];
                    $addon_description = $data['description'];
                    $addon_billingcycle = $data['billingcycle'];
                    $addon_tax = $data['tax'];
                    if (!$CONFIG['TaxEnabled']) {
                        $addon_tax = "";
                    }
                    $result = select_query("tblpricing", "msetupfee,monthly", array("type" => "addon", "currency" => $currency['id'], "relid" => $addonid));
                    $data = mysql_fetch_array($result);
                    $addon_setupfee = $data['msetupfee'];
                    $addon_recurring = $data['monthly'];
                    $hookret = run_hook("OrderAddonPricingOverride", array("key" => $key, "pid" => $pid, "addonid" => $addonid, "proddata" => $productdata));
                    foreach ($hookret as $hookret2) {
                        if (is_array($hookret2)) {
                            if ($hookret2['setup']) {
                                $addon_setupfee = $hookret2['setup'];
                            }
                            if ($hookret2['recurring']) {
                                $addon_recurring = $hookret2['recurring'];
                                continue;
                            }
                            continue;
                        }
                    }
                    $addon_total_today_db = $addon_setupfee + $addon_recurring;
                    $addon_recurring_db = $addon_recurring;
                    $addon_total_today = $addon_total_today_db * $qty;
                    if ($CONFIG['TaxInclusiveDeduct']) {
                        $addon_total_today_db = round($addon_total_today_db / $excltaxrate, 2);
                        $addon_recurring_db = round($addon_recurring_db / $excltaxrate, 2);
                    }
                    if ($promotioncode) {
                        $onetimediscount = $recurringdiscount = $promoid = 0;
                        if ($promocalc = CalcPromoDiscount("A" . $addonid, $addon_billingcycle, $addon_total_today_db, $addon_recurring_db, $addon_setupfee)) {
                            $onetimediscount = $promocalc['onetimediscount'];
                            $recurringdiscount = $promocalc['recurringdiscount'];
                            $addon_total_today_db -= $onetimediscount;
                            $addon_recurring_db -= $recurringdiscount;
                            $cart_discount += $onetimediscount * $qty;
                        }
                    }
                    if ($checkout) {
                        $qtycount = 1;
                        while ($qtycount <= $qty) {
                            $serviceid = $multiqtyids[$qtycount];
                            $addonsetupfee = $addon_total_today_db - $addon_recurring_db;
                            $aid = insert_query("tblhostingaddons", array("hostingid" => $serviceid, "addonid" => $addonid, "orderid" => $orderid, "regdate" => "now()", "name" => "", "setupfee" => $addonsetupfee, "recurring" => $addon_recurring_db, "billingcycle" => $addon_billingcycle, "status" => "Pending", "nextduedate" => "now()", "nextinvoicedate" => "now()", "paymentmethod" => $paymentmethod, "tax" => $addon_tax));
                            $orderaddonids[] = $aid;
                            $adminemailitems .= $_LANG['clientareaaddon'] . (": " . $addon_name . "<br>\r\n") . $_LANG['ordersetupfee'] . ": " . formatCurrency($addonsetupfee) . "<br>\r\n";
                            if ($addon_recurring_db) {
                                $adminemailitems .= $_LANG['recurringamount'] . ": " . formatCurrency($addon_recurring_db) . "<br>\r\n";
                            }
                            $adminemailitems .= $_LANG['orderbillingcycle'] . ": " . $_LANG["orderpaymentterm" . str_replace(array("-", " "), "", strtolower($addon_billingcycle))] . "<br>\r\n<br>\r\n";
                            ++$qtycount;
                        }
                    }
                    $addon_total_today_db *= $qty;
                    $cart_total += $addon_total_today_db;
                    $addon_recurring_db *= $qty;
                    if ($addon_tax && !$clientsdetails['taxexempt']) {
                        $cart_tax += $addon_total_today_db;
                        if ($CONFIG['TaxType'] == "Exclusive") {
                            if ($CONFIG['TaxL2Compound']) {
                                $addon_recurring_db += $addon_recurring_db * $taxrate;
                                $addon_recurring_db += $addon_recurring_db * $taxrate2;
                            } else {
                                $addon_recurring_db += $addon_recurring_db * $taxrate + $addon_recurring_db * $taxrate2;
                            }
                        }
                    }
                    $addon_billingcycle = str_replace(array("-", " "), "", strtolower($addon_billingcycle));
                    $recurring_cycles_total[$addon_billingcycle] += $addon_recurring_db;
                    if ($addon_setupfee == "0" && $addon_recurring == "0") {
                        $pricing_text = $_LANG['orderfree'];
                    } else {
                        $pricing_text = formatCurrency($addon_recurring);
                        if ($addon_setupfee != "0.00") {
                            $pricing_text .= " + " . formatCurrency($addon_setupfee) . " " . $_LANG['ordersetupfee'];
                        }
                        if ($allowqty && 1 < $qty) {
                            $pricing_text .= $_LANG['invoiceqtyeach'] . "<br />" . $_LANG['invoicestotal'] . ": " . formatCurrency($addon_total_today);
                        }
                    }
                    $addonsarray[] = array("name" => $addon_name, "pricingtext" => $pricing_text, "setup" => formatCurrency($addon_setupfee), "recurring" => formatCurrency($addon_recurring), "totaltoday" => formatCurrency($addon_total_today));
                    $productdata['pricing']['setup'] += $addon_setupfee * $qty;
                    $productdata['pricing']['addons'] += $addon_recurring * $qty;
                    $productdata['pricing']['recurring'][$addon_billingcycle] += $addon_recurring * $qty;
                    $productdata['pricing']['totaltoday'] += $addon_total_today;
                }
            }
            $productdata['addons'] = $addonsarray;
            $totaltaxrates = 1;
            if ($CONFIG['TaxEnabled'] && $tax && !$clientsdetails['taxexempt']) {
                $product_tax = $productdata['pricing']['totaltoday'];
                if ($CONFIG['TaxType'] == "Inclusive") {
                    $totaltaxrates = 1 + ($taxrate + $taxrate2);
                    $total_without_tax = $productdata['pricing']['totaltoday'] = $product_tax / $totaltaxrates;
                    $total_tax_1 = $total_without_tax * $taxrate;
                    $total_tax_2 = $total_without_tax * $taxrate2;
                } else {
                    $total_tax_1 = $product_tax * $taxrate;
                    if ($CONFIG['TaxL2Compound']) {
                        $total_tax_2 = ($product_tax + $total_tax_1) * $taxrate2;
                    } else {
                        $total_tax_2 = $product_tax * $taxrate2;
                    }
                }
                $total_tax_1 = round($total_tax_1, 2);
                $total_tax_2 = round($total_tax_2, 2);
                $productdata['pricing']['totaltoday'] += $total_tax_1 + $total_tax_2;
                if (0 < $total_tax_1) {
                    $productdata['pricing']['tax1'] = formatCurrency($total_tax_1);
                }
                if (0 < $total_tax_2) {
                    $productdata['pricing']['tax2'] = formatCurrency($total_tax_2);
                }
            }
            $productdata['pricing']['setup'] = formatCurrency($productdata['pricing']['setup']);
            foreach ($productdata['pricing']['recurring'] as $cycle => $recurring) {
                unset($productdata['pricing']['recurring'][$cycle]);
                if (0 < $recurring) {
                    $recurringwithtax = $recurring;
                    if ($CONFIG['TaxEnabled'] && $tax && !$clientsdetails['taxexempt'] && $CONFIG['TaxType'] == "Exclusive") {
                        $rectax = $recurringwithtax * $taxrate;
                        if ($CONFIG['TaxL2Compound']) {
                            $rectax += ($recurringwithtax + $rectax) * $taxrate2;
                        } else {
                            $rectax += $recurringwithtax * $taxrate2;
                        }
                        $recurringwithtax += $rectax;
                    }
                    $productdata['pricing']['recurring'][$_LANG["orderpaymentterm" . $cycle]] = formatCurrency($recurringwithtax);
                    $productdata['pricing']['recurringexcltax'][$_LANG["orderpaymentterm" . $cycle]] = formatCurrency($recurring / $totaltaxrates);
                    continue;
                }
            }
            if (0 < $productdata['pricing']['addons']) {
                $productdata['pricing']['addons'] = formatCurrency($productdata['pricing']['addons']);
            }
            $productdata['pricing']['totaltoday'] = formatCurrency($productdata['pricing']['totaltoday']);
            $productsarray[$key] = $productdata;
        }
    }
    $cartdata['products'] = $productsarray;
    $addonsarray = array();
    if (array_key_exists("addons", $_SESSION['cart']) && is_array($_SESSION['cart']['addons'])) {
        foreach ($_SESSION['cart']['addons'] as $key => $addon) {
            $addonid = $addon['id'];
            $serviceid = $addon['productid'];
            $result = select_query("tbladdons", "name,description,billingcycle,tax", array("id" => $addonid));
            $data = mysql_fetch_array($result);
            $addon_name = $data['name'];
            $addon_description = $data['description'];
            $addon_billingcycle = $data['billingcycle'];
            $addon_tax = $data['tax'];
            if (!$CONFIG['TaxEnabled']) {
                $addon_tax = "";
            }
            $result = select_query("tblpricing", "msetupfee,monthly", array("type" => "addon", "currency" => $currency['id'], "relid" => $addonid));
            $data = mysql_fetch_array($result);
            $addon_setupfee = $data['msetupfee'];
            $addon_recurring = $data['monthly'];
            $hookret = run_hook("OrderAddonPricingOverride", array("key" => $key, "addonid" => $addonid, "serviceid" => $serviceid));
            foreach ($hookret as $hookret2) {
                if (strlen($hookret2)) {
                    if ($hookret2['setup']) {
                        $addon_setupfee = $hookret2['setup'];
                    }
                    if ($hookret2['recurring']) {
                        $addon_recurring = $hookret2['recurring'];
                        continue;
                    }
                    continue;
                }
            }
            $addon_total_today_db = $addon_setupfee + $addon_recurring;
            $addon_recurring_db = $addon_recurring;
            if ($CONFIG['TaxInclusiveDeduct']) {
                $addon_total_today_db = round($addon_total_today_db / $excltaxrate, 2);
                $addon_recurring_db = round($addon_recurring_db / $excltaxrate, 2);
            }
            if ($promotioncode) {
                $onetimediscount = $recurringdiscount = $promoid = 0;
                if ($promocalc = CalcPromoDiscount("A" . $addonid, $addon_billingcycle, $addon_total_today_db, $addon_recurring_db, $addon_setupfee)) {
                    $onetimediscount = $promocalc['onetimediscount'];
                    $recurringdiscount = $promocalc['recurringdiscount'];
                    $addon_total_today_db -= $onetimediscount;
                    $addon_recurring_db -= $recurringdiscount;
                    $cart_discount += $onetimediscount;
                }
            }
            if ($checkout) {
                $addonsetupfee = $addon_total_today_db - $addon_recurring_db;
                $aid = insert_query("tblhostingaddons", array("hostingid" => $serviceid, "addonid" => $addonid, "orderid" => $orderid, "regdate" => "now()", "name" => "", "setupfee" => $addonsetupfee, "recurring" => $addon_recurring_db, "billingcycle" => $addon_billingcycle, "status" => "Pending", "nextduedate" => "now()", "nextinvoicedate" => "now()", "paymentmethod" => $paymentmethod, "tax" => $addon_tax));
                $orderaddonids[] = $aid;
                $adminemailitems .= $_LANG['clientareaaddon'] . (": " . $addon_name . "<br>\r\n") . $_LANG['ordersetupfee'] . ": " . formatCurrency($addonsetupfee) . "<br>\r\n";
                if ($addon_recurring_db) {
                    $adminemailitems .= $_LANG['recurringamount'] . ": " . formatCurrency($addon_recurring_db) . "<br>\r\n";
                }
                $adminemailitems .= $_LANG['orderbillingcycle'] . ": " . $_LANG["orderpaymentterm" . str_replace(array("-", " "), "", strtolower($addon_billingcycle))] . "<br>\r\n<br>\r\n";
            }
            $cart_total += $addon_total_today_db;
            if ($addon_tax && !$clientsdetails['taxexempt']) {
                $cart_tax += $addon_total_today_db;
                if ($CONFIG['TaxType'] == "Exclusive") {
                    if ($CONFIG['TaxL2Compound']) {
                        $addon_recurring_db += $addon_recurring_db * $taxrate;
                        $addon_recurring_db += $addon_recurring_db * $taxrate2;
                    } else {
                        $addon_recurring_db = $addon_recurring_db + $addon_recurring_db * $taxrate + $addon_recurring_db * $taxrate2;
                    }
                }
            }
            $addon_billingcycle = str_replace(array("-", " "), "", strtolower($addon_billingcycle));
            $recurring_cycles_total[$addon_billingcycle] += $addon_recurring_db;
            if ($addon_setupfee == "0" && $addon_recurring == "0") {
                $pricing_text = $_LANG['orderfree'];
            } else {
                $pricing_text = formatCurrency($addon_recurring);
                if ($addon_setupfee != "0.00") {
                    $pricing_text .= " + " . formatCurrency($addon_setupfee) . " " . $_LANG['ordersetupfee'];
                }
            }
            $result = select_query("tblhosting", "tblproducts.name,tblhosting.domain", array("tblhosting.id" => $serviceid), "", "", "", "tblproducts ON tblproducts.id=tblhosting.packageid");
            $data = mysql_fetch_array($result);
            $productname = $data['name'];
            $domainname = $data['domain'];
            $addonsarray[] = array("name" => $addon_name, "productname" => $productname, "domainname" => $domainname, "pricingtext" => $pricing_text);
        }
        $cartdata['addons'] = $addonsarray;
    }
    include ROOTDIR . "/includes/additionaldomainfields.php";
    $totaldomainprice = 0;
    if (array_key_exists("domains", $_SESSION['cart']) && is_array($_SESSION['cart']['domains'])) {
        $result = select_query("tblpricing", "", array("type" => "domainaddons", "currency" => $currency['id'], "relid" => 0));
        $data = mysql_fetch_array($result);
        $domaindnsmanagementprice = $data['msetupfee'];
        $domainemailforwardingprice = $data['qsetupfee'];
        $domainidprotectionprice = $data['ssetupfee'];
        foreach ($_SESSION['cart']['domains'] as $key => $domain) {
            $domaintype = $domain['type'];
            $domainname = $domain['domain'];
            $regperiod = $domain['regperiod'];
            $domainparts = explode(".", $domainname, 2);
            $sld = $domainparts[0];
            $tld = $domainparts[1];
            $temppricelist = getTLDPriceList("." . $tld);
            if (!isset($temppricelist[$regperiod][$domaintype])) {
                $tldyears = array_keys($temppricelist);
                $regperiod = $tldyears[0];
            }
            if (!isset($temppricelist[$regperiod][$domaintype])) {
                exit("Invalid TLD/Registration Period Supplied for Domain Registration");
            }
            if (array_key_exists($domainname, $freedomains)) {
                $tldyears = array_keys($temppricelist);
                $regperiod = $tldyears[0];
                $domainprice = "0.00";
                $renewprice = $freedomains[$domainname] == "once" ? $temppricelist[$regperiod]['renew'] : ($renewprice = "0.00");
            } else {
                $domainprice = $temppricelist[$regperiod][$domaintype];
                $renewprice = $temppricelist[$regperiod]['renew'];
            }
            $before_priceoverride_value = "";
            if ($bundleoverride = bundlesGetProductPriceOverride("domain", $key)) {
                $before_priceoverride_value = $domainprice;
                $domainprice = $renewprice = $bundleoverride;
            }
            $hookret = run_hook("OrderDomainPricingOverride", array("type" => $domaintype, "domain" => $domainname, "regperiod" => $regperiod, "dnsmanagement" => $domain['dnsmanagement'], "emailforwarding" => $domain['emailforwarding'], "idprotection" => $domain['idprotection'], "eppcode" => html_entity_decode($domain['eppcode'])));
            foreach ($hookret as $hookret2) {
                if (strlen($hookret2)) {
                    $before_priceoverride_value = $domainprice;
                    $domainprice = $hookret2;
                    continue;
                }
            }
            if ($domain['dnsmanagement']) {
                $dnsmanagement = true;
                $domainprice += $domaindnsmanagementprice * $regperiod;
                $renewprice += $domaindnsmanagementprice * $regperiod;
                if (strlen($before_priceoverride_value)) {
                    $before_priceoverride_value += $domaindnsmanagementprice * $regperiod;
                }
            } else {
                $dnsmanagement = false;
            }
            if ($domain['emailforwarding']) {
                $emailforwarding = true;
                $domainprice += $domainemailforwardingprice * $regperiod;
                $renewprice += $domainemailforwardingprice * $regperiod;
                if (strlen($before_priceoverride_value)) {
                    $before_priceoverride_value += $domainemailforwardingprice * $regperiod;
                }
            } else {
                $emailforwarding = false;
            }
            if ($domain['idprotection']) {
                $idprotection = true;
                $domainprice += $domainidprotectionprice * $regperiod;
                $renewprice += $domainidprotectionprice * $regperiod;
                if (strlen($before_priceoverride_value)) {
                    $before_priceoverride_value += $domainidprotectionprice * $regperiod;
                }
            } else {
                $idprotection = false;
            }
            if ($CONFIG['TaxInclusiveDeduct']) {
                $domainprice = round($domainprice / $excltaxrate, 2);
                $renewprice = round($renewprice / $excltaxrate, 2);
            }
            $domain_price_db = $domainprice;
            $domain_renew_price_db = $renewprice;
            if ($promotioncode) {
                $onetimediscount = $recurringdiscount = $promoid = 0;
                if ($promocalc = CalcPromoDiscount("D." . $tld, $regperiod . "Years", $domain_price_db, $domain_renew_price_db)) {
                    $onetimediscount = $promocalc['onetimediscount'];
                    $recurringdiscount = $promocalc['recurringdiscount'];
                    $domain_price_db -= $onetimediscount;
                    $domain_renew_price_db -= $recurringdiscount;
                    $cart_discount += $onetimediscount;
                    $promoid = $promo_data['id'];
                }
            }
            if ($regperiod == "1") {
                $domain_billing_cycle = "annually";
            } else {
                if ($regperiod == "2") {
                    $domain_billing_cycle = "biennially";
                } else {
                    if ($regperiod == "3") {
                        $domain_billing_cycle = "triennially";
                    }
                }
            }
            $recurring_cycles_total[$domain_billing_cycle] += $domain_renew_price_db;
            if ($CONFIG['TaxEnabled'] && $CONFIG['TaxDomains'] && $CONFIG['TaxType'] == "Exclusive" && !$clientsdetails['taxexempt']) {
                if ($CONFIG['TaxL2Compound']) {
                    $recurring_cycles_total[$domain_billing_cycle] += $domain_renew_price_db * $taxrate + ($domain_renew_price_db + $domain_renew_price_db * $taxrate) * $taxrate2;
                } else {
                    $recurring_cycles_total[$domain_billing_cycle] += $domain_renew_price_db * $taxrate + $domain_renew_price_db * $taxrate2;
                }
            }
            if ($checkout) {
                $donotrenew = $CONFIG['DomainAutoRenewDefault'] ? "" : "on";
                $domainid = insert_query("tbldomains", array("userid" => $userid, "orderid" => $orderid, "type" => $domaintype, "registrationdate" => "now()", "domain" => $domainname, "firstpaymentamount" => $domain_price_db, "recurringamount" => $domain_renew_price_db, "registrationperiod" => $regperiod, "status" => "Pending", "paymentmethod" => $paymentmethod, "expirydate" => "00000000", "nextduedate" => "now()", "nextinvoicedate" => "now()", "dnsmanagement" => $dnsmanagement, "emailforwarding" => $emailforwarding, "idprotection" => $idprotection, "donotrenew" => $donotrenew, "promoid" => $promoid));
                $orderdomainids[] = $domainid;
                $adminemailitems .= $_LANG['orderdomainregistration'] . ": " . ucfirst($domaintype) . "<br>\r\n" . $_LANG['orderdomain'] . (": " . $domainname . "<br>\r\n") . $_LANG['firstpaymentamount'] . ": " . formatCurrency($domain_price_db) . "<br>\r\n" . $_LANG['recurringamount'] . ": " . formatCurrency($domain_renew_price_db) . "<br>\r\n" . $_LANG['orderregperiod'] . (": " . $regperiod . " ") . $_LANG['orderyears'] . "<br>\r\n";
                if ($dnsmanagement) {
                    $adminemailitems .= " + " . $_LANG['domaindnsmanagement'] . "<br>\r\n";
                }
                if ($emailforwarding) {
                    $adminemailitems .= " + " . $_LANG['domainemailforwarding'] . "<br>\r\n";
                }
                if ($idprotection) {
                    $adminemailitems .= " + " . $_LANG['domainidprotection'] . "<br>\r\n";
                }
                $adminemailitems .= "<br>\r\n";
                if ($domaintype == "register") {
                    unset($tempdomainfields);
                    $tempdomainfields = $additionaldomainfields["." . $tld];
                    if ($tempdomainfields) {
                        foreach ($tempdomainfields as $fieldkey => $value) {
                            $storedvalue = $domain['fields'][$fieldkey];
                            insert_query("tbldomainsadditionalfields", array("domainid" => $domainid, "name" => $value['Name'], "value" => $storedvalue));
                        }
                    }
                }
                if ($domaintype == "transfer" && $domain['eppcode']) {
                    $domaineppcodes[$domainname] = html_entity_decode($domain['eppcode']);
                }
            }
            $pricing_text = "";
            if (strlen($before_priceoverride_value)) {
                $pricing_text .= "<strike>" . formatCurrency($before_priceoverride_value) . "</strike> ";
            }
            $pricing_text .= formatCurrency($domainprice);
            $tempdomains[$key] = array("type" => $domaintype, "domain" => $domainname, "regperiod" => $regperiod, "price" => $pricing_text, "renewprice" => formatCurrency($renewprice), "dnsmanagement" => $dnsmanagement, "emailforwarding" => $emailforwarding, "idprotection" => $idprotection, "eppvalue" => $domain['eppcode']);
            $totaldomainprice += $domain_price_db;
        }
    }
    $cartdata['domains'] = $tempdomains;
    $cart_total += $totaldomainprice;
    if ($CONFIG['TaxDomains']) {
        $cart_tax += $totaldomainprice;
    }
    $orderrenewals = "";
    if (array_key_exists("renewals", $_SESSION['cart']) && is_array($_SESSION['cart']['renewals'])) {
        $result = select_query("tblpricing", "", array("type" => "domainaddons", "currency" => $currency['id'], "relid" => 0));
        $data = mysql_fetch_array($result);
        $domaindnsmanagementprice = $data['msetupfee'];
        $domainemailforwardingprice = $data['qsetupfee'];
        $domainidprotectionprice = $data['ssetupfee'];
        foreach ($_SESSION['cart']['renewals'] as $domainid => $regperiod) {
            $result = select_query("tbldomains", "", array("id" => $domainid));
            $data = mysql_fetch_array($result);
            $domainname = $data['domain'];
            $expirydate = $data['expirydate'];
            if ($expirydate == "0000-00-00") {
                $expirydate = $data['nextduedate'];
            }
            $dnsmanagement = $data['dnsmanagement'];
            $emailforwarding = $data['emailforwarding'];
            $idprotection = $data['idprotection'];
            $domainparts = explode(".", $domainname, 2);
            $sld = $domainparts[0];
            $tld = "." . $domainparts[1];
            $temppricelist = getTLDPriceList($tld, "", true);
            if (!isset($temppricelist[$regperiod]['renew'])) {
                exit("Invalid TLD/Registration Period Supplied for Domain Renewal");
            }
            $renewprice = $temppricelist[$regperiod]['renew'];
            if ($dnsmanagement) {
                $renewprice += $domaindnsmanagementprice * $regperiod;
            }
            if ($emailforwarding) {
                $renewprice += $domainemailforwardingprice * $regperiod;
            }
            if ($idprotection) {
                $renewprice += $domainidprotectionprice * $regperiod;
            }
            if ($CONFIG['TaxInclusiveDeduct']) {
                $renewprice = round($renewprice / $excltaxrate, 2);
            }
            $domain_renew_price_db = $renewprice;
            if ($promotioncode) {
                $onetimediscount = $recurringdiscount = $promoid = 0;
                if ($promocalc = CalcPromoDiscount("D" . $tld, $regperiod . "Years", $domain_renew_price_db, $domain_renew_price_db)) {
                    $onetimediscount = $promocalc['onetimediscount'];
                    $domain_renew_price_db -= $onetimediscount;
                    $cart_discount += $onetimediscount;
                }
            }
            $cart_total += $domain_renew_price_db;
            if ($CONFIG['TaxDomains']) {
                $cart_tax += $domain_renew_price_db;
            }
            if ($checkout) {
                $domain_renew_price_db = format_as_currency($domain_renew_price_db);
                $orderrenewalids[] = $domainid;
                $orderrenewals .= "" . $domainid . "=" . $regperiod . ",";
                $adminemailitems .= $_LANG['domainrenewal'] . (": " . $domainname . " - " . $regperiod . " ") . $_LANG['orderyears'] . "<br>\r\n";
                $domaindesc = $_LANG['domainrenewal'] . (" - " . $domainname . " - " . $regperiod . " ") . $_LANG['orderyears'] . " (" . fromMySQLDate($expirydate) . " - " . fromMySQLDate(getInvoicePayUntilDate($expirydate, $regperiod)) . ")";
                if ($dnsmanagement) {
                    $adminemailitems .= " + " . $_LANG['domaindnsmanagement'] . "<br>\r\n";
                    $domaindesc .= "\r\n + " . $_LANG['domaindnsmanagement'];
                }
                if ($emailforwarding) {
                    $adminemailitems .= " + " . $_LANG['domainemailforwarding'] . "<br>\r\n";
                    $domaindesc .= "\r\n + " . $_LANG['domainemailforwarding'];
                }
                if ($idprotection) {
                    $adminemailitems .= " + " . $_LANG['domainidprotection'] . "<br>\r\n";
                    $domaindesc .= "\r\n + " . $_LANG['domainidprotection'];
                }
                $adminemailitems .= "<br>\r\n";
                $tax = $CONFIG['TaxDomains'] ? "1" : "0";
                update_query("tbldomains", array("registrationperiod" => $regperiod, "recurringamount" => $domain_renew_price_db), array("id" => $domainid));
                insert_query("tblinvoiceitems", array("userid" => $userid, "type" => "Domain", "relid" => $domainid, "description" => $domaindesc, "amount" => $domain_renew_price_db, "taxed" => $tax, "duedate" => "now()", "paymentmethod" => $paymentmethod));
                $result = select_query("tblinvoiceitems", "tblinvoiceitems.id,tblinvoiceitems.invoiceid", array("type" => "Domain", "relid" => $domainid, "status" => "Unpaid", "tblinvoices.userid" => $_SESSION['uid']), "", "", "", "tblinvoices ON tblinvoices.id=tblinvoiceitems.invoiceid");
                while ($data = mysql_fetch_array($result)) {
                    $itemid = $data['id'];
                    $invoiceid = $data['invoiceid'];
                    $result2 = select_query("tblinvoiceitems", "COUNT(*)", array("invoiceid" => $invoiceid));
                    $data = mysql_fetch_array($result2);
                    $itemcount = $data[0];
                    if ($itemcount == 1) {
                        update_query("tblinvoices", array("status" => "Cancelled"), array("id" => $invoiceid));
                        logActivity("Cancelled Previous Domain Renewal Invoice - Invoice ID: " . $invoiceid . " - Domain: " . $domainname);
                    }
                    delete_query("tblinvoiceitems", array("id" => $itemid));
                    updateInvoiceTotal($invoiceid);
                    logActivity("Removed Previous Domain Renewal Line Item - Invoice ID: " . $invoiceid . " - Domain: " . $domainname);
                }
            }
            $cartdata['renewals'][$domainid] = array("domain" => $domainname, "regperiod" => $regperiod, "price" => formatCurrency($renewprice), "dnsmanagement" => $dnsmanagement, "emailforwarding" => $emailforwarding, "idprotection" => $idprotection);
        }
    }
    $cart_adjustments = 0;
    $adjustments = run_hook("CartTotalAdjustment", $_SESSION['cart']);
    foreach ($adjustments as $k => $adjvals) {
        if ($checkout) {
            insert_query("tblinvoiceitems", array("userid" => $userid, "type" => "", "relid" => "", "description" => $adjvals['description'], "amount" => $adjvals['amount'], "taxed" => $adjvals['taxed'], "duedate" => "now()", "paymentmethod" => $paymentmethod));
        }
        $adjustments[$k]['amount'] = formatCurrency($adjvals['amount']);
        $cart_adjustments += $adjvals['amount'];
        if ($adjvals['taxed']) {
            $cart_tax += $adjvals['amount'];
            continue;
        }
    }
    if ($CONFIG['TaxEnabled'] && !$clientsdetails['taxexempt']) {
        if ($CONFIG['TaxType'] == "Inclusive") {
            $totaltaxrates = 1 + ($taxrate + $taxrate2);
            $total_without_tax = $cart_tax / $totaltaxrates;
            $total_tax_1 = $total_without_tax * $taxrate;
            $total_tax_2 = $total_without_tax * $taxrate2;
        } else {
            $total_tax_1 = $cart_tax * $taxrate;
            if ($CONFIG['TaxL2Compound']) {
                $total_tax_2 = ($cart_tax + $total_tax_1) * $taxrate2;
            } else {
                $total_tax_2 = $cart_tax * $taxrate2;
            }
        }
        $total_tax_1 = round($total_tax_1, 2);
        $total_tax_2 = round($total_tax_2, 2);
        if ($CONFIG['TaxType'] == "Inclusive") {
            $cart_total -= $total_tax_1 + $total_tax_2;
        }
    } else {
        $total_tax_1 = $total_tax_2 = 0;
    }
    $cart_subtotal = $cart_total + $cart_discount;
    $cart_total += $total_tax_1 + $total_tax_2 + $cart_adjustments;
    $cart_subtotal = format_as_currency($cart_subtotal);
    $cart_discount = format_as_currency($cart_discount);
    $cart_adjustments = format_as_currency($cart_adjustments);
    $total_tax_1 = format_as_currency($total_tax_1);
    $total_tax_2 = format_as_currency($total_tax_2);
    $cart_total = format_as_currency($cart_total);
    if ($checkout) {
        $adminemailitems .= $_LANG['ordertotalduetoday'] . ": " . formatCurrency($cart_total);
        if ($promotioncode && $promo_data['promoapplied']) {
            update_query("tblpromotions", array("uses" => "+1"), array("code" => $promotioncode));
            $promo_recurring = $promo_data['recurring'] ? "Recurring" : "One Time";
            update_query("tblorders", array("promocode" => $promo_data['code'], "promotype" => $promo_recurring . " " . $promo_data['type'], "promovalue" => $promo_data['value']), array("id" => $orderid));
        }
        if ($_SESSION['cart']['ns1'] && $_SESSION['cart']['ns1']) {
            $ordernameservers = $_SESSION['cart']['ns1'] . "," . $_SESSION['cart']['ns2'];
            if ($_SESSION['cart']['ns3']) {
                $ordernameservers .= "," . $_SESSION['cart']['ns3'];
            }
            if ($_SESSION['cart']['ns4']) {
                $ordernameservers .= "," . $_SESSION['cart']['ns4'];
            }
            if ($_SESSION['cart']['ns5']) {
                $ordernameservers .= "," . $_SESSION['cart']['ns5'];
            }
        }
        $domaineppcodes = count($domaineppcodes) ? serialize($domaineppcodes) : "";
        $orderdata = array();
        if (is_array($_SESSION['cart']['bundle'])) {
            foreach ($_SESSION['cart']['bundle'] as $bvals) {
                $orderdata['bundleids'][] = $bvals['bid'];
            }
        }
        update_query("tblorders", array("amount" => $cart_total, "nameservers" => $ordernameservers, "transfersecret" => $domaineppcodes, "renewals" => substr($orderrenewals, 0, 0 - 1), "orderdata" => serialize($orderdata)), array("id" => $orderid));
        $invoiceid = 0;
        if (!$_SESSION['cart']['geninvoicedisabled']) {
            if (!$userid) {
                exit("An Error Occurred");
            }
            $invoiceid = createInvoices($userid, true, "", array("products" => $orderproductids, "addons" => $orderaddonids, "domains" => $orderdomainids));
            if ($CONFIG['OrderDaysGrace']) {
                $new_time = mktime(0, 0, 0, date("m"), date("d") + $CONFIG['OrderDaysGrace'], date("Y"));
                $duedate = date("Y-m-d", $new_time);
                update_query("tblinvoices", array("duedate" => $duedate), array("id" => $invoiceid));
            }
            if (!$CONFIG['NoInvoiceEmailOnOrder']) {
                sendMessage("Invoice Created", $invoiceid);
            }
        }
        if ($invoiceid) {
            update_query("tblorders", array("invoiceid" => $invoiceid), array("id" => $orderid));
            $result = select_query("tblinvoices", "status", array("id" => $invoiceid));
            $data = mysql_fetch_array($result);
            $status = $data['status'];
            if ($status == "Paid") {
                $invoiceid = "";
            }
        }
        if (!$_SESSION['adminid']) {
            if (isset($_COOKIE['WHMCSAffiliateID'])) {
                $result = select_query("tblaffiliates", "clientid", array("id" => (int) $_COOKIE['WHMCSAffiliateID']));
                $data = mysql_fetch_array($result);
                $clientid = $data['clientid'];
                if ($clientid && $_SESSION['uid'] != $clientid) {
                    foreach ($orderproductids as $orderproductid) {
                        insert_query("tblaffiliatesaccounts", array("affiliateid" => (int) $_COOKIE['WHMCSAffiliateID'], "relid" => $orderproductid));
                    }
                }
            }
            if (isset($_COOKIE['WHMCSLinkID'])) {
                update_query("tbllinks", array("conversions" => "+1"), array("id" => $_COOKIE['WHMCSLinkID']));
            }
        }
        $result = select_query("tblclients", "firstname, lastname, companyname, email, address1, address2, city, state, postcode, country, phonenumber, ip, host", array("id" => $userid));
        $data = mysql_fetch_array($result);
        list($firstname, $lastname, $companyname, $email, $address1, $address2, $city, $state, $postcode, $country, $phonenumber, $ip, $host) = $data;
        $customfields = getCustomFields("client", "", $userid, "", true);
        $clientcustomfields = "";
        foreach ($customfields as $customfield) {
            $clientcustomfields .= "" . $customfield['name'] . ": " . $customfield['value'] . "<br />\r\n";
        }
        $result = select_query("tblpaymentgateways", "value", array("gateway" => $paymentmethod, "setting" => "name"));
        $data = mysql_fetch_array($result);
        $nicegatewayname = $data['value'];
        sendAdminMessage("New Order Notification", array("order_id" => $orderid, "order_number" => $order_number, "order_date" => fromMySQLDate(date("Y-m-d H:i:s"), true), "invoice_id" => $invoiceid, "order_payment_method" => $nicegatewayname, "order_total" => formatCurrency($cart_total), "client_id" => $userid, "client_first_name" => $firstname, "client_last_name" => $lastname, "client_email" => $email, "client_company_name" => $companyname, "client_address1" => $address1, "client_address2" => $address2, "client_city" => $city, "client_state" => $state, "client_postcode" => $postcode, "client_country" => $country, "client_phonenumber" => $phonenumber, "client_customfields" => $clientcustomfields, "order_items" => $adminemailitems, "order_notes" => nl2br($ordernotes), "client_ip" => $ip, "client_hostname" => $host), "account");
        if (!$_SESSION['cart']['orderconfdisabled']) {
            sendMessage("Order Confirmation", $userid, array("order_id" => $orderid, "order_number" => $order_number, "order_details" => $adminemailitems));
        }
        $_SESSION['cart'] = array();
        $_SESSION['orderdetails'] = array("OrderID" => $orderid, "OrderNumber" => $order_number, "ServiceIDs" => $orderproductids, "DomainIDs" => $orderdomainids, "AddonIDs" => $orderaddonids, "RenewalIDs" => $orderrenewalids, "PaymentMethod" => $paymentmethod, "InvoiceID" => $invoiceid, "TotalDue" => $cart_total, "Products" => $orderproductids, "Domains" => $orderdomainids, "Addons" => $orderaddonids, "Renewals" => $orderrenewalids);
        run_hook("AfterShoppingCartCheckout", $_SESSION['orderdetails']);
    }
    $total_recurringmonthly = $recurring_cycles_total['monthly'] <= 0 ? "" : formatCurrency($recurring_cycles_total['monthly']);
    $total_recurringquarterly = $recurring_cycles_total['quarterly'] <= 0 ? "" : formatCurrency($recurring_cycles_total['quarterly']);
    $total_recurringsemiannually = $recurring_cycles_total['semiannually'] <= 0 ? "" : formatCurrency($recurring_cycles_total['semiannually']);
    $total_recurringannually = $recurring_cycles_total['annually'] <= 0 ? "" : formatCurrency($recurring_cycles_total['annually']);
    $total_recurringbiennially = $recurring_cycles_total['biennially'] <= 0 ? "" : formatCurrency($recurring_cycles_total['biennially']);
    $total_recurringtriennially = $recurring_cycles_total['triennially'] <= 0 ? "" : formatCurrency($recurring_cycles_total['triennially']);
    $cartdata['bundlewarnings'] = $bundlewarnings;
    $cartdata['rawdiscount'] = $cart_discount;
    $cartdata['subtotal'] = formatCurrency($cart_subtotal);
    $cartdata['discount'] = formatCurrency($cart_discount);
    $cartdata['promotype'] = $promo_data['type'];
    $cartdata['promovalue'] = $promo_data['type'] == "Fixed Amount" || $promo_data['type'] == "Price Override" ? formatCurrency($promo_data['value']) : round($promo_data['value'], 2);
    $cartdata['promorecurring'] = $promo_data['recurring'] ? $_LANG['recurring'] : $_LANG['orderpaymenttermonetime'];
    $cartdata['taxrate'] = $rawtaxrate;
    $cartdata['taxrate2'] = $rawtaxrate2;
    $cartdata['taxname'] = $taxname;
    $cartdata['taxname2'] = $taxname2;
    $cartdata['taxtotal'] = formatCurrency($total_tax_1);
    $cartdata['taxtotal2'] = formatCurrency($total_tax_2);
    $cartdata['adjustments'] = $adjustments;
    $cartdata['adjustmentstotal'] = formatCurrency($cart_adjustments);
    $cartdata['rawtotal'] = $cart_total;
    $cartdata['total'] = formatCurrency($cart_total);
    $cartdata['totalrecurringmonthly'] = $total_recurringmonthly;
    $cartdata['totalrecurringquarterly'] = $total_recurringquarterly;
    $cartdata['totalrecurringsemiannually'] = $total_recurringsemiannually;
    $cartdata['totalrecurringannually'] = $total_recurringannually;
    $cartdata['totalrecurringbiennially'] = $total_recurringbiennially;
    $cartdata['totalrecurringtriennially'] = $total_recurringtriennially;
    return $cartdata;
}
Exemplo n.º 9
0
             if (!trim($cancellationreason)) {
                 $smartyvalues['error'] = true;
             }
             if (!$smartyvalues['error']) {
                 if (!in_array($type, array("Immediate", "End of Billing Period"))) {
                     $type = "End of Billing Period";
                 }
                 createCancellationRequest($client->getID(), $id, $cancellationreason, $type);
                 if ($canceldomain) {
                     $domainid = get_query_val("tbldomains", "id", array("userid" => $client->getID(), "domain" => $service->getData("domain")));
                     if ($domainid) {
                         disableAutoRenew($domainid);
                     }
                 }
                 sendMessage("Cancellation Request Confirmation", $id);
                 sendAdminMessage("New Cancellation Request", array("client_id" => $client->getID(), "clientname" => $clientsdetails['firstname'] . " " . $clientsdetails['lastname'], "service_id" => $id, "product_name" => $service->getData("productname"), "service_cancellation_type" => $type, "service_cancellation_type" => $type, "service_cancellation_reason" => $cancellationreason), "account");
                 $smartyvalues['requested'] = "on";
             }
         }
         if ($service->getData("domain")) {
             $data = get_query_vals("tbldomains", "id,recurringamount,registrationperiod,nextduedate", array("userid" => $client->getID(), "domain" => $service->getData("domain"), "status" => "Active", "donotrenew" => ""));
             $smartyvalues['domainid'] = $data['id'];
             $smartyvalues['domainprice'] = formatCurrency($data['recurringamount']);
             $smartyvalues['domainregperiod'] = $data['registrationperiod'];
             $smartyvalues['domainnextduedate'] = fromMySQLDate($data['nextduedate'], 0, 1);
         }
     }
 } else {
     if ($action == "addfunds") {
         checkContactPermission("invoices");
         $clientsdetails = getClientsDetails();
Exemplo n.º 10
0
 *
 * @ WHMCS FULL DECODED & NULLED
 *
 * @ Version  : 5.2.15
 * @ Author   : MTIMER
 * @ Release on : 2013-12-24
 * @ Website  : http://www.mtimer.cn
 *
 **/
if (!defined("WHMCS")) {
    exit("This file cannot be accessed directly");
}
if ($custommessage) {
    delete_query("tblemailtemplates", array("name" => "Mass Mail Template"));
    insert_query("tblemailtemplates", array("type" => "admin", "name" => "Custom Admin Temp", "subject" => html_entity_decode($customsubject), "message" => html_entity_decode($custommessage)));
    $messagename = "Custom Admin Temp";
}
$result = select_query("tblemailtemplates", "COUNT(*)", array("name" => $messagename, "type" => "admin"));
$data = mysql_fetch_array($result);
if (!$data[0]) {
    $apiresults = array("result" => "error", "message" => "Email Template not found");
    return null;
}
if (!in_array($type, array("system", "account", "support"))) {
    $type = "system";
}
sendAdminMessage($messagename, $mergefields, $type, $deptid);
if ($custommessage) {
    delete_query("tblemailtemplates", array("name" => "Custom Admin Temp"));
}
$apiresults = array("result" => "success");