Example #1
0
}
if (!does_field_exist("blocks", "price")) {
    $sql = "ALTER TABLE `blocks` ADD `price` float  NULL";
    mysql_query($sql) or die("<p><b>CANNOT UPGRADE YOUR DATABASE!<br>Please run the follwoing query manually from PhpMyAdmin:</b><br><pre>{$sql}</pre><br>");
}
if (!does_field_exist("orders", "currency")) {
    $sql = "ALTER TABLE `orders` ADD `currency` CHAR(3) DEFAULT 'USD' NOT NULL";
    mysql_query($sql) or die("<p><b>CANNOT UPGRADE YOUR DATABASE!<br>Please run the follwoing query manually from PhpMyAdmin:</b><br><pre>{$sql}</pre><br>");
    $sql = "select *, banners.price_per_block AS PPB, banners.currency BAC, orders.currency ORC from orders, banners where orders.banner_id=banners.banner_id ";
    $result = mysql_query($sql) or die(mysql_error());
    while ($row = mysql_fetch_array($result)) {
        $blocks = explode(",", $row[blocks]);
        foreach ($blocks as $block_id) {
            if ($block_id != '') {
                require_once "../include/currency_functions.php";
                $sql = "UPDATE blocks set price=" . convert_to_currency($row[PPB], $row['BAC'], $row['ORC']) . " WHERE block_id=" . $block_id;
                mysql_query($sql) or die(mysql_error() . $sql);
            }
        }
    }
}
if (!does_field_exist("orders", "date_published")) {
    $sql = "ALTER TABLE `orders` ADD date_published DATETIME  NULL";
    mysql_query($sql) or die("<p><b>CANNOT UPGRADE YOUR DATABASE!<br>Please run the follwoing query manually from PhpMyAdmin:</b><br><pre>{$sql}</pre><br>");
}
if (!does_field_exist("orders", "date_stamp")) {
    $sql = "ALTER TABLE `orders` ADD `date_stamp` DATETIME;";
    mysql_query($sql) or die("<p><b>CANNOT UPGRADE YOUR DATABASE!<br>Please run the follwoing query manually from PhpMyAdmin:</b><br><pre>{$sql}</pre><br>");
}
if (!does_field_exist("orders", "days_expire")) {
    $sql = "ALTER TABLE `orders` ADD `days_expire` INT DEFAULT 0;";
    function payment_button($order_id)
    {
        global $label;
        $sql = "SELECT * from orders where order_id='" . $order_id . "'";
        $result = mysql_query($sql) or die(mysql_error() . $sql);
        $order_row = mysql_fetch_array($result);
        ?>

<form action="https://www.moneybookers.com/app/payment.pl" method="post" target="_blank">
<input type="hidden" name="pay_to_email" value="<?php 
        echo MONEYBOOKERS_EMAIL;
        ?>
">
<input type="hidden" name="status_url" value="<?php 
        echo MONEYBOOKERS_STATUS_URL;
        ?>
">
<input type="hidden" name="language" value="<?php 
        echo MONEYBOOKERS_LANGUAGE;
        ?>
">
<input type="hidden" name="transaction_id" value="<?php 
        echo $order_row['order_id'];
        ?>
">
<input type="hidden" name="amount" value="<?php 
        echo convert_to_currency($order_row['price'], $order_row['currency'], MONEYBOOKERS_CURRENCY);
        ?>
">
<input type="hidden" name="currency" value="<?php 
        echo MONEYBOOKERS_CURRENCY;
        ?>
">
<input type="hidden" name="cancel_url" value="<?php 
        echo MONEYBOOKERS_CANCEL_URL;
        ?>
">
<input type="hidden" name="return_url" value="<?php 
        echo MONEYBOOKERS_RETURN_URL;
        ?>
">
<input type="hidden" name="detail1_description" value="<?php 
        echo $label['payment_moneybookers_descr'];
        ?>
">
<input type="hidden" name="detail1_text" value="<?php 
        echo SITE_NAME;
        ?>
">
<input type="submit" value="<?php 
        echo $label['pay_by_moneybookers_button'];
        ?>
">
</form>

		

		<?php 
    }
    function process_payment_return()
    {
        global $label;
        if ($_REQUEST['order_id'] != '' && $_REQUEST['nhezk5'] != '') {
            //print_r($_SESSION);
            if ($_SESSION['MDS_ID'] == '') {
                echo "Error: You must be logged in to view this page";
            } else {
                //require ("../users/header.php");
                ?>
			<div style='background-color: #ffffff; border-color:#C0C0C0; border-style:solid;padding:10px'>
		<p align="center"><center>
				<?php 
                $sql = "SELECT * from orders where order_id='" . $_REQUEST['order_id'] . "' and user_id='" . $_SESSION['MDS_ID'] . "'";
                $result = mysql_query($sql) or die(mysql_error() . $sql);
                $order_row = mysql_fetch_array($result);
                $check_amount = convert_to_currency($order_row['price'], $order_row['currency'], CHECK_CURRENCY);
                $check_amount = format_currency($check_amount, CHECK_CURRENCY, true);
                $label['payment_check_heading'] = str_replace("%INVOICE_AMOUNT%", $check_amount, $label['payment_check_heading']);
                //$label['payment_check_note'] = str_replace ("%CONTACT_EMAIL%", SITE_CONTACT_EMAIL, $label['payment_check_note']);
                //$label['payment_check_note'] = str_replace ("%INVOICE_CODE%", $_REQUEST['order_id'], $label['payment_check_note']);
                if (get_default_currency() != CHECK_CURRENCY) {
                    echo convert_to_default_currency_formatted($order_row[currency], $order_row['price']) . " = " . $check_amount;
                    echo "<br>";
                }
                ?>
				
				<table width="70%"><tr><td>
				<b><?php 
                echo $label['payment_check_heading'];
                ?>
</b><br>
				<?php 
                if (CHECK_NAME != '') {
                    ?>
				<b><?php 
                    echo $label['payment_check_payable'];
                    ?>
</b><pre><?php 
                    echo CHECK_PAYABLE;
                    ?>
</pre><br>
				<?php 
                }
                ?>
				<?php 
                if (CHECK_ADDRESS != '') {
                    ?>
				<b><?php 
                    echo $label['payment_check_address'];
                    ?>
</b><pre><?php 
                    echo CHECK_ADDRESS;
                    ?>
</pre><br>
				<?php 
                }
                ?>
				<?php 
                /*if ( CHECK_ACCOUNT_NAME != '') { ?>
                		<b><?php echo $label['payment_check_currency'];?></b><pre><?php echo CHECK_CURRENCY; ?></pre><br>
                		<?php } */
                ?>
				
					</td></tr>
					</table>
					
					</p>
					</center>
					
					</div>
					<?php 
            }
        }
    }
Example #4
0
    function payment_button($order_id)
    {
        global $label;
        $sql = "SELECT * from orders where order_id='" . $order_id . "'";
        $result = mysql_query($sql) or die(mysql_error() . $sql);
        $order_row = mysql_fetch_array($result);
        $is_subscription = false;
        if ($order_row['days_expire'] > 0 && PAYPAL_SUBSCR_MODE == 'YES') {
            $is_subscription = true;
        }
        if (USE_PAYPAL_SUBSCR != 'YES') {
            $is_subscription = false;
        }
        ?>

		<center><b><?php 
        echo $label['payment_paypal_head'];
        ?>
</b>
		
		
		<form action="https://<?php 
        echo PAYPAL_SERVER;
        ?>
/cgi-bin/webscr" name="form1" method="post" target="_parent">

		<center><?php 
        echo $label['payment_paypal_accepts'];
        ?>
</center>
		<?php 
        if ($is_subscription) {
            ?>
			<input type="hidden" value="_xclick-subscriptions" name="cmd">
			<input type="hidden" name="p3" value="<?php 
            echo $order_row['days_expire'];
            ?>
">
			<input type="hidden" name="t3" value="D">
			<input type="hidden" name="src" value="1">
			<input type="hidden" name="sra" value="1">
		<?php 
        } else {
            ?>
		  <input type="hidden" value="_xclick" name="cmd">

		 <?php 
        }
        ?>
		<input type="hidden" value="<?php 
        echo PAYPAL_EMAIL;
        ?>
" name="business">
		<input type="hidden" value="<?php 
        echo PAYPAL_IPN_URL;
        ?>
" name="notify_url">
		<input type="hidden" value="<?php 
        echo SITE_NAME;
        ?>
 Order #<?php 
        echo $order_row[order_id];
        ?>
" name="item_name">
		<input type="hidden" value="<?php 
        echo PAYPAL_RETURN_URL;
        ?>
" name="return">
		<input type="hidden" value="<?php 
        echo PAYPAL_CANCEL_RETURN_URL;
        ?>
" name="cancel_return"/>
		<input type="hidden" value="<?php 
        echo pp_prefix_order_id($order_row[order_id]);
        ?>
" name="invoice" >
		<?php 
        if ($is_subscription) {
            ?>

			<input type="hidden" name="a3" value="<?php 
            echo convert_to_currency($order_row['price'], $order_row['currency'], PAYPAL_CURRENCY);
            ?>
">
		<?php 
        } else {
            ?>
 
			<input type="hidden" value="<?php 
            echo convert_to_currency($order_row['price'], $order_row['currency'], PAYPAL_CURRENCY);
            ?>
" name="amount">
		<?php 
        }
        ?>
		<input type="hidden" value="<?php 
        echo $order_row[order_id];
        ?>
" name="item_number">
		<input type="hidden" value="<?php 
        echo $order_row[user_id];
        ?>
" name="custom">
		<input type="hidden" value="<?php 
        echo PAYPAL_PAGE_STYLE;
        ?>
" name="page_style">

		<input type="hidden" value="1" name="no_shipping"/>
		<input type="hidden" value="1" name="no_note"/>
		<input type="hidden" value="<?php 
        echo PAYPAL_CURRENCY;
        ?>
" name="currency_code">
		<p align="center">
		<?php 
        if ($is_subscription) {
            ?>
			<input type="image" src="<?php 
            echo PAYPAL_SUBSCR_BUTTON_URL;
            ?>
" border="0" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">

		<?php 
        } else {
            ?>
			<input target="_parent" type="image" alt="<?php 
            echo $label['payment_paypal_bttn_alt'];
            ?>
" src="<?php 
            echo PAYPAL_BUTTON_URL;
            ?>
" border="0" name="submit" >
		<?php 
        }
        ?>
		</p>
	</form>

		<?php 
    }
Example #5
0
    function payment_button($order_id)
    {
        global $label;
        $sql = "SELECT * from orders where order_id='" . $order_id . "'";
        $result = mysql_query($sql) or die(mysql_error() . $sql);
        $order_row = mysql_fetch_array($result);
        $Checksum = cc_getCheckSum(CCAVENUE_MERCHANT_ID, convert_to_currency($order_row[price], $order_row[currency], CCAVENUE_CURRENCY), $order_id, CCAVENUE_REDIRECT_URL, CCAVENUE_WORKING_KEY);
        ?>

		<form method="post" action="https://www.ccavenue.com/shopzone/cc_details.jsp">
		<input type=hidden name=Merchant_Id value="<?php 
        echo CCAVENUE_MERCHANT_ID;
        ?>
">
		<input type=hidden name=Amount value="<?php 
        echo convert_to_currency($order_row[price], $order_row[currency], CCAVENUE_CURRENCY);
        ?>
">
		<input type=hidden name=Order_Id value="<?php 
        echo $order_row[order_id];
        ?>
">
		<input type=hidden name=Redirect_Url value="<?php 
        echo CCAVENUE_REDIRECT_URL;
        ?>
">
		<input type=hidden name=Checksum value="<?php 
        echo $Checksum;
        ?>
">
		
		<input type="hidden" name="Merchant_Param" value="<?php 
        echo $Merchant_Param;
        ?>
"> 
		<INPUT TYPE="submit" value="<?php 
        echo $label['pay_by_ccavenue_button'];
        ?>
">
		</form>

<!--
		
		<form action="https://www.ccavenue.com/shopzone/cc_details.jsp" name="form1" method="post" target="_parent">
		<center>PayPal accepts: Visa, Mastercard</center>
		  <input type="hidden" value="_xclick" name="cmd">
		  <input type="hidden" value="<?php 
        echo CCAVENUE_MERCHANT_ID;
        ?>
" name="Merchant_Id">
		  <input type="hidden" value="<?php 
        echo CCAVENUE_REDIRECT_URL;
        ?>
" name="Redirect_Url">
		  <input type="hidden" value="<?php 
        echo $order_row[order_id];
        ?>
" name="Order_Id">
		  <input type="hidden" value="<?php 
        echo convert_to_currency($order_row[price], $order_row[currency], CCAVENUE_CURRENCY);
        ?>
" name="Amount">

		  <p align="center">
		  <input target="_parent" type="submit" value="Pay by CCAvenue" alt="CCAVENUE" src="<?php 
        echo CCAVENUE_BUTTON_URL;
        ?>
" border="0" name="submit" >
		  </p>
	</form>

	-->

		<?php 
    }
Example #6
0
    function payment_button($order_id)
    {
        global $label;
        $sql = "SELECT * from orders where order_id='" . $order_id . "'";
        $result = mysql_query($sql) or die(mysql_error() . $sql);
        $order_row = mysql_fetch_array($result);
        ?>

<form action="https://www.e-gold.com/sci_asp/payments.asp" method="post" >
<input type="hidden" name="PAYEE_ACCOUNT" value="<?php 
        echo EGOLD_PAYEE_ACCOUNT;
        ?>
">
<input type="hidden" name="PAYEE_NAME" value="<?php 
        echo SITE_NAME;
        ?>
">
<input type="hidden" name="PAYMENT_AMOUNT"  value="<?php 
        echo convert_to_currency($order_row['price'], $order_row['currency'], $this->get_currency());
        ?>
">
<input type="hidden" name="PAYMENT_UNITS" value="<?php 
        echo EGOLD_PAYMENT_UNITS;
        ?>
">
<input type="hidden" name="PAYMENT_METAL_ID" value="<?php 
        echo EGOLD_PAYMENT_METAL_ID;
        ?>
">
<input type="hidden" name="PAYMENT_ID" value="<?php 
        echo $order_row['order_id'];
        ?>
">
<input type="hidden" name="STATUS_URL" value="<?php 
        echo EGOLD_STATUS_URL;
        ?>
">

<input type="hidden" name="PAYMENT_URL" value="<?php 
        echo EGOLD_PAYMENT_URL;
        ?>
">
<input type="hidden" name="PAYMENT_URL_METHOD" value="POST">
<input type="hidden" name="NOPAYMENT_URL" value="<?php 
        echo EGOLD_NOPAYMENT_URL;
        ?>
">
<input type="hidden" name="NOPAYMENT_URL_METHOD" value="POST">
<input type="hidden" name="BAGGAGE_FIELDS" value="ORDER_NUM CUST_NUM">

<input type="hidden" name="ORDER_NUM" value="<?php 
        echo $order_row['order_id'];
        ?>
">
<input type="hidden" name="CUST_NUM" value="<?php 
        echo $order_row['user_id'];
        ?>
">




<input type="submit" value="<?php 
        echo $label['pay_by_egold_button'];
        ?>
">
</form>

		

		<?php 
    }
    function payment_button($order_id)
    {
        global $label;
        $sql = "SELECT * from orders where order_id='" . $order_id . "'";
        $result = mysql_query($sql) or die(mysql_error() . $sql);
        $order_row = mysql_fetch_array($result);
        ?>
<center>
<?php 
        if (AUTHNET_TEST_MODE == 'YES') {
            ?>
		
			<FORM action="https://test.authorize.net/gateway/transact.dll" method="POST">
		
		<?php 
        } else {
            ?>

			<FORM action="https://secure.authorize.net/gateway/transact.dll" method="POST"> 
		
		<?php 
        }
        $loginid = AUTHNET_LOGIN_ID;
        $x_tran_key = AUTHNET_X_TRAN_KEY;
        $x_Amount = $order_row['price'];
        $amount = convert_to_currency($x_Amount, $order_row['currency'], AUTHNET_CURRENCY);
        // Seed random number for security and better randomness.
        srand(time());
        $sequence = rand(1, 1000);
        $tstamp = time();
        $fingerprint = authnet_hmac($x_tran_key, $loginid . "^" . $sequence . "^" . $tstamp . "^" . $amount . "^" . AUTHNET_CURRENCY);
        echo '<input type="hidden" name="x_fp_sequence" value="' . $sequence . '">';
        echo '<input type="hidden" name="x_fp_timestamp" value="' . $tstamp . '">';
        echo '<input type="hidden" name="x_fp_hash" value="' . $fingerprint . '">';
        // Insert rest of the form elements similiar to the legacy weblink integration
        //echo ("<input type=\"hidden\" name=\"x_description\" value=\"" . $x_Description . "\">\n" );
        echo "<input type=\"hidden\" name=\"x_login\" value=\"" . $loginid . "\">\n";
        echo "<input type=\"hidden\" name=\"x_amount\" value=\"" . $amount . "\">\n";
        // *** IF YOU ARE PASSING CURRENCY CODE uncomment the line below *****
        echo "<input type=\"hidden\" name=\"x_currency_code\" value=\"" . AUTHNET_CURRENCY . "\">\n";
        ?>

		<INPUT type="hidden" name="x_background_url" value="<?php 
        echo AUTHNET_X_BACKGROUND_URL;
        ?>
">
		<INPUT type="hidden" name="x_logo_url" value="<?php 
        echo AUTHNET_X_LOGO_URL;
        ?>
">
		<INPUT type="hidden" name="x_color_background" value="<?php 
        echo AUTHNET_X_COLOR_BACKGROUND;
        ?>
">
		<INPUT type="hidden" name="x_color_link" value="<?php 
        echo AUTHNET_X_COLOR_LINK;
        ?>
">
		<INPUT type="hidden" name="x_color_text" value="<?php 
        echo AUTHNET_X_COLOR_TEXT;
        ?>
">

		<INPUT type="hidden" name="x_receipt_link_method" value="<?php 
        echo AUTHNET_X_RECEIPT_LINK_METHOD;
        ?>
">
		<INPUT type="hidden" name="x_receipt_link_url" value="<?php 
        echo AUTHNET_X_RECEIPT_LINK_URL;
        ?>
">
		<INPUT type="hidden" name="x_receipt_link_text" value="<?php 
        echo AUTHNET_X_RECEIPT_LINK_TEXT;
        ?>
">
		<INPUT type="hidden" name="x_header_html_payment_form" value="<?php 
        echo AUTHNET_X_HEADER_HTML_PAYMENT_FORM;
        ?>
">
		<INPUT type="hidden" name="x_footer_html_payment_form" value="<?php 
        echo AUTHNET_X_FOOTER_HTML_PAYMENT_FORM;
        ?>
">
		
	
		<INPUT type="hidden" name="x_cust_id" value="<?php 
        echo $order_row['user_id'];
        ?>
">
		<INPUT type="hidden" name="x_relay_response" value="TRUE">
		<INPUT type="hidden" name="x_relay_url" value="<?php 
        echo AUTHNET_X_RELAY_URL;
        ?>
">
		<INPUT type="hidden" name="x_invoice_num" value="<?php 
        echo $order_row['order_id'];
        ?>
">
		<INPUT type="hidden" name="x_description" value="<?php 
        echo SITE_NAME;
        ?>
">
		<INPUT type="hidden" name="x_cust_id" value="<?php 
        echo $order_row['user_id'];
        ?>
">
		<INPUT type="hidden" name="x_show_form" value="PAYMENT_FORM">
		<?php 
        if (AUTHNET_TEST_MODE == 'YES') {
            ?>
			<INPUT type="hidden" name="x_test_request" value="TRUE">
		<?php 
        } else {
            ?>
			<INPUT type="hidden" name="x_test_request" value="FALSE">
		<?php 
        }
        ?>
		<INPUT type="submit" value="<?php 
        echo $label['pay_by_authnet_button'];
        ?>
">
		</FORM>
</center>


		<?php 
    }
Example #8
0
    function payment_button($order_id)
    {
        $sql = "SELECT * from orders where order_id='" . $order_id . "'";
        $result = mysql_query($sql) or die(mysql_error() . $sql);
        $order_row = mysql_fetch_array($result);
        ?>

		<form action="https://www.nochex.com/nochex.dll/checkout" name="form1" method="post" target="_parent">
		  
		  <input type="hidden" value="<?php 
        echo NOCHEX_EMAIL;
        ?>
" name="email"/>
		  <input type="hidden" value="<?php 
        echo number_format(convert_to_currency($order_row[price], $order_row[currency], NOCHEX_CURRENCY), 2, '.', '');
        ?>
" name="amount"/>
		  <input type="hidden" value="<?php 
        echo $order_row[order_id];
        ?>
" name="ordernumber" />
		  <input type="hidden" value="<?php 
        echo $item_name;
        ?>
" name="description" />
		  <?php 
        if (trim(NOCHEX_LOGO_URL) != '') {
            ?>
		  <input type="hidden" value="<?php 
            echo NOCHEX_LOGO_URL;
            ?>
" name="logo" />
		  <?php 
        }
        ?>
		  <input type="hidden" value="<?php 
        echo NOCHEX_APC_URL;
        ?>
" name="responderurl"/>
		  
		  <input type="hidden" value="<?php 
        echo NOCHEX_RETURN_URL;
        ?>
" name="returnurl"/>
		  <input type="hidden" value="<?php 
        echo NOCHEX_CANCEL_RETURN_URL;
        ?>
" name="cancel"/>
<p align="center">
		  <input target="_parent" type="image" alt="I accept payment using NOCHEX" src="<?php 
        echo NOCHEX_BUTTON_URL;
        ?>
" border="0" name="submit" />
		  
	</P>	  
		  
		  </p>
	</form>

	<?php 
    }
Example #9
0
    function payment_button($order_id)
    {
        global $label;
        $sql = "SELECT * from orders where order_id='" . $order_id . "'";
        $result = mysql_query($sql) or die(mysql_error() . $sql);
        $order_row = mysql_fetch_array($result);
        //echo "c02 currency is"._2CO_CURRENCY;
        ?>

		<center>
		<form name="_2coform" action="<?php 
        echo _2CO_PAYMENT_ROUTINE;
        ?>
" method="post">
		
		<?php 
        /*
        Optional parameters 
        sh_cost - Shipping and handling cost, if any in your current currency. 
        c_name or c_name_[:digit] - Required for new product creation. Name of new product limited to 128 characters. 
        c_description or c_description_[:digit] - Required for new product creation. 
        Short description of the product, limited to 255 characters.
        Longer description will be stored in the 2Co product database 
        as long description, and will not show up on checkout pages. 
        c_price or c_price_[:digit] - Required for new product creation.
        Price of the product in your current currency.
        Numbers and decimal points only. Maximum value 999999.99 
        c_tangible or c_tangible_[:digit] - Y or y indicates as tangible or physical product
        N or n indicates an e-good or a service. 
        */
        ?>
		<!-- <input type="HIDDEN" name="x_receipt_link_url" value="<?php 
        echo _2CO_X_RECEIPT_LINK_URL;
        ?>
">
		-->

		<input type="HIDDEN" name="x_receipt_link_url" value="<?php 
        echo _2CO_X_RECEIPT_LINK_URL;
        ?>
">
		<input type="hidden" name="demo" value="<?php 
        echo _2CO_DEMO;
        ?>
">
		<input type="hidden" name="sid" value="<?php 
        echo _2CO_SID;
        ?>
">

		<input type="hidden" name="total" value="<?php 
        echo convert_to_currency($order_row[price], $order_row[currency], 'USD');
        ?>
">
		<input type="hidden" name="cart_order_id" value="<?php 
        echo $order_row[order_id];
        ?>
">
		<!--input type="hidden" name="c_prod" value="<?php 
        echo _2CO_PRODUCT_ID;
        ?>
"--> 
		<input type="hidden" name="id_type" value="1">
		<input type="hidden" name="fixed" value="N">
		<input type="hidden" name="c_description" value="<?php 
        echo $order_row['quantity'];
        ?>
 pixels (<?php 
        echo $order_row['quantity'];
        ?>
 blocks)">
		<input type="hidden" name="c_name" value="<?php 
        echo SITE_NAME;
        ?>
">
		<input type="submit" value="<?php 
        echo $label['payment_2co_submit_butt'];
        ?>
"><br>


		</form>
		</center>
		<center>
		
		<img border='0' onclick="document._2coform.submit();" src="http://www.2checkout.com/images/overview/btns/21.jpg">
		
		</center>

		<?php 
    }
Example #10
0
    function process_payment_return()
    {
        global $label;
        if ($_REQUEST['order_id'] != '' && $_REQUEST['nhezk5'] != '') {
            //session_start();
            //print_r($_SESSION);
            if ($_SESSION['MDS_ID'] == '') {
                echo "Error: You must be logged in to view this page";
            } else {
                ?>

			<div style='background-color: #ffffff; border-color:#C0C0C0; border-style:solid;padding:10px'>
		<p align="center"><center>
				<?php 
                $sql = "SELECT * from orders where order_id='" . $_REQUEST['order_id'] . "' and user_id='" . $_SESSION['MDS_ID'] . "'";
                $result = mysql_query($sql) or die(mysql_error() . $sql);
                $order_row = mysql_fetch_array($result);
                $bank_amount = convert_to_currency($order_row['price'], $order_row['currency'], BANK_CURRENCY);
                $bank_amount = format_currency($bank_amount, BANK_CURRENCY, true);
                $label['payment_bank_heading'] = str_replace("%INVOICE_AMOUNT%", $bank_amount, $label['payment_bank_heading']);
                $label['payment_bank_note'] = str_replace("%CONTACT_EMAIL%", SITE_CONTACT_EMAIL, $label['payment_bank_note']);
                $label['payment_bank_note'] = str_replace("%INVOICE_CODE%", $_REQUEST['order_id'], $label['payment_bank_note']);
                if (get_default_currency() != BANK_CURRENCY) {
                    echo convert_to_default_currency_formatted($order_row[currency], $order_row['price']) . " = " . $bank_amount;
                    echo "<br>";
                }
                ?>
				
				<table width="70%"><tr><td>
				<b><?php 
                echo $label['payment_bank_heading'];
                ?>
</b><br>
				<?php 
                if (BANK_NAME != '') {
                    ?>
				<b><?php 
                    echo $label['payment_bank_name'];
                    ?>
</b> <?php 
                    echo BANK_NAME;
                    ?>
<br>
				<?php 
                }
                ?>
				<?php 
                if (BANK_ADDRESS != '') {
                    ?>
				<b><?php 
                    echo $label['payment_bank_addr'];
                    ?>
</b> <?php 
                    echo BANK_ADDRESS;
                    ?>
<br>
				<?php 
                }
                ?>
				<?php 
                if (BANK_ACCOUNT_NAME != '') {
                    ?>
				<b><?php 
                    echo $label['payment_bank_ac_name'];
                    ?>
</b> <?php 
                    echo BANK_ACCOUNT_NAME;
                    ?>
<br>
				<?php 
                }
                ?>
				<?php 
                if (BANK_ACCOUNT_NUMBER != '') {
                    ?>
				<b><?php 
                    echo $label['payment_bank_ac_number'];
                    ?>
</b> <?php 
                    echo BANK_ACCOUNT_NUMBER;
                    ?>
<br>
					<?php 
                }
                ?>
					<?php 
                if (BANK_BRANCH_NUMBER != '') {
                    ?>
					<b><?php 
                    echo $label['payment_bank_branch_number'];
                    ?>
</b> <?php 
                    echo BANK_BRANCH_NUMBER;
                    ?>
<br>
					<?php 
                }
                ?>
					<?php 
                if (BANK_SWIFT != '') {
                    ?>

					<b><?php 
                    echo $label['payment_bank_swift'];
                    ?>
</b> <?php 
                    echo BANK_SWIFT;
                    ?>
<br>

					<?php 
                }
                ?>
					<?php 
                echo $label['payment_bank_note'];
                ?>
					</td></tr>
					</table>
					
					</p>
					</center>
					
					</div>
					<?php 
            }
        }
    }