<?
$msg=new Messages($Site_Db);
/*Create Object of Cdb (Connection to DB) class*/
$cnn= new Cdb;

$Specifications=array("","10 Listeners","25 Listeners","50 Listeners","75 Listeners","100 Listeners");
$selectlisteners=array(L10=>"10 Listeners",L25=>"25 Listeners",L50=>"50 Listeners",L75=>"75 Listeners",L100=>"100 Listeners");
$selectbitrate=array(0=>"24 kbps",1=>"32 kbps",2=>"48 kbps",3=>"56 kbps",4=>"64 kbps",5=>"96 kbps",6=>"128 kbps",7=>"196 kbps");

$scpackage=array(array(bitrate => "24 kbps",
               L10 => "4.00",
            L25 => "6.00",
            L50 => "7.00",
            L75 => "9.00",
            L100 => "12.00"
            ),
         array(bitrate => "32 kbps",
               L10 => "5.00",
            L25 => "7.00",
            L50 => "10.00",
            L75 => "14.00",
            L100 => "20.00",
            ),
         array(bitrate => "48 kbps",
            L10 => "6.00",
            L25 => "10.00",
            L50 => "12.00",
            L75 => "17.00",
            L100 => "22.00",
            ),
         array(bitrate => "56 kbps",
            L10 => "7.00",
            L25 => "12.00",
            L50 => "15.00",
            L75 => "22.00",
            L100 => "30.00",
            ),
         array(bitrate => "64 kbps",
            L10 => "8.00",
            L25 => "13.00",
            L50 => "17.00",
            L75 => "27.00",
            L100 => "37.00",
            ),
         array(bitrate => "96 kbps",
            L10 => "9.00",
            L25 => "15.00",
            L50 => "20.00",
            L75 => "35.00",
            L100 => "47.00",
            ),
         array(bitrate => "128 kbps",
            L10 => "12.00",
            L25 => "17.00",
            L50 => "27.00",
            L75 => "40.00",
            L100 => "52.00",
            ),
         array(bitrate => "196 kbps",
            L10 => "17.00",
            L25 => "27.00",
            L50 => "35.00",
            L75 => "52.00",
            L100 => "72.00",
            )
    );

$BillingCycle=array(1=>"Monthly",3=>"Quarterly",6=>"Semiannually",12=>"Annually");
$PaymentMethod=array(1=>"PayPal",2=>"Egold",3=>"Credit Card");

function PostOrder($LstBillingCycle,$TxtUserName,$Txtpassword,$LstPmtMethod,$TxtOrganization,$TxtFName,$TxtLName,$TxtAddress,$TxtCity,$TxtState,$TxtZip,$LstCountry,$TxtPhone,$TxtEmail,$PackageCost,$TotalCost,$packageID,$TxtPlan)
{
        global $feedback,$Site_Db,$PaymentMethod,$cnn;

        $errval=0;

        if($TxtUserName=="")
        {
                $errmsg="<br>* Please Enter User Name";
                $errval=1;
        }
        if($Txtpassword=="")
        {
                $errmsg.="<br>* Please Enter Password";
                $errval=1;
        }
        if($TxtFName=="")
        {
                $errmsg.="<br>* Please Enter First Name";
                $errval=1;
        }
        if($TxtLName=="")
        {
                $errmsg.="<br>* Please Enter Last Name";
                $errval=1;
        }
        if($TxtAddress=="")
        {
                $errmsg.="<br>* Please Enter Address";
                $errval=1;
        }
        if($TxtCity=="")
        {
                $errmsg.="<br>* Please Enter City";
                $errval=1;
        }
        if($TxtState=="")
        {
                $errmsg.="<br>* Please Enter State";
                $errval=1;
        }
        if($TxtZip=="")
        {
                $errmsg.="<br>* Please Enter Zip";
                $errval=1;
        }
        if($LstCountry=="SELC")
        {
                $errmsg.="<br>* Please Enter Country";
                $errval=1;
        }
        if($TxtPhone=="")
        {
                $errmsg.="<br>* Please Enter Phone";
                $errval=1;
        }
        if(!validate_email($TxtEmail))
        {
                $errmsg.="<br>* The e-mail address seems to be formatted incorrectly.";
                $errval=1;
        }
        if($errval==1)
        {
                $feedback=$errmsg;
                return 0;
        }
        else
        {
                                       /*Create Object of Cdb_Results (Fetching Database) class*/
                $RegObj= new Cdb_Results;
                /*Select databse*/
                $RegObj->select_db($Site_Db,$cnn);
                $Qry="INSERT INTO customerinfo";
                $Qry.=" (Plan,PlanID,BillingCycle,Username,UsrPassword,PaymentMethod,Organization,FirstName,LastName,Address,City,State,zip,Country,Phone,Email,PriceMonth,TotalCost)";
                $Qry.=" VALUES('".$packageID."','".$TxtPlan."','".$LstBillingCycle."','".$TxtUserName."','".$Txtpassword."','".$PaymentMethod[$LstPmtMethod]."','".$TxtOrganization."','".$TxtFName."','".$TxtLName."','".$TxtAddress."','".$TxtCity."','".$TxtState."','".$TxtZip."',".$LstCountry.",'".$TxtPhone."','".$TxtEmail."',".$PackageCost.",".$TotalCost.")";
                $RegObj->query($Qry);
        //MyMail($LstBillingCycle,$TxtUserName,$Txtpassword,$LstPmtMethod,$TxtOrganization,$TxtFName,$TxtLName,$TxtAddress,$TxtCity,$TxtState,$TxtZip,$LstCountry,$TxtPhone,$TxtEmail,$PackageCost,$TotalCost,$packageID,$TxtPlan);
            return 1;
        }

}
?>