how to display a text only if a customer is from a certain country :)

[girolimoni]

I would like to display a certain text at the checkout_confirmation.php page. My goal is, that that text is only displayed if a customer is part of a certain country/tax zone.

 

thanks a lot for your percious help :)

 

 

greetings

[FIMBLE]

Add an if statement

if (entry_country_id == xxx)

{

echo do something;

}

 

You need to find out your country code and add the bits to show

 

Nic

[girolimoni]

Cool Thanks for the quick answer. Can you pleae state the same thing for a tax zone?

I mean istead of

entry_country_id==

 

the same thing for the taxzone :) maybe its entry_tax_zone_id== :)

 

thanks and greetings

[girolimoni]

Just tried with the coutry, but its not working :(

 

here pasted my try:

 

<td><?php if (entry_country_id == 81) {

echo HEADING_TRUSTED_COMMENTS;

}

?></td>

 

:blush:

[girolimoni]

Any help? :wacko:

[girolimoni]

hehe solved !!! here the solution, maybe others will need it too :)

 

<td><?php if ($order->delivery['country_id'] == 81)

{

echo HEADING_TRUSTED_COMMENTS;

}

?>

</td>

 

Maybe someone has the string for a whole geo zone :)

[girolimoni]

Hello

 

Can someone help how to edit the folling line to have the possibility to enter more countries ID?

 

Now only 1 country can be placed :(

 

<?php if ($order->delivery['country_id'] == 81)

{

echo HEADING_TRUSTED_COMMENTS;

}

?>

 

 

thanks a lot

[germ]

Something like this:

 

<?php
 $trusted = array(81, 82, 83);  // <-- put the country id's here.
 if ( in_array( (int)$order->delivery['country_id'], $trusted ) ) {
echo HEADING_TRUSTED_COMMENTS; 
 } 
?>

[girolimoni]

cool! thanks a lot!

[girolimoni]

Hello

 

I tried to implement this code in catalog/ext/modules/paymant/paypal_ipn/ipn.php

 

But its not working: the email is always displayed in the confirmation email. So it seems its not taking consideration of it :( any help? thanks a lot

 

 

 

// BOF content type fix by AlexStudio

if ($content_type != 'virtual') {

// EOF content type fix by AlexStudio

$email_order .= "\n" . EMAIL_TEXT_DELIVERY_ADDRESS . "\n" .

EMAIL_SEPARATOR . "\n" .

tep_address_format($order->delivery['format_id'], $order->delivery, 0, '', "\n") . "\n\n".

EMAIL_TEXT_TELEFONNUMMER . $order->customer['telephone'] . "\n" .

EMAIL_TEXT_EMAIL . $order->customer['email_address'] . "\n";

}

 

$email_order .= "\n" . EMAIL_TEXT_BILLING_ADDRESS . "\n" .

EMAIL_SEPARATOR . "\n" .

tep_address_format($order->billing['format_id'], $order->billing, 0, '', "\n") . "\n\n";

if (is_object($$payment)) {

$email_order .= EMAIL_TEXT_PAYMENT_METHOD . "\n" .

EMAIL_SEPARATOR . "\n";

$payment_class = $$payment;

$email_order .= $payment_class->title . "\n\n";

if ($payment_class->email_footer) {

$email_order .= $payment_class->email_footer . "\n\n";

}

 

if ($order->delivery['country_id'] != 204)

{

$email_order .= EMAIL_SEPARATOR2 . "\n" .

EMAIL_TEXT_TRUSTED_TEXT2 . "\n" .

EMAIL_SEPARATOR2 . "\n" ;

 

}

}

[germ]

Unless your logic is faulty, how about this:

 

if ( (int)$order->delivery['country_id'] != 204 ) {
 $email_order .= EMAIL_SEPARATOR2 . "\n" .
 EMAIL_TEXT_TRUSTED_TEXT2 . "\n" .
 EMAIL_SEPARATOR2 . "\n";
}

In pseudo code that says:

 

if the order delivery country ID is NOT equal to 204 then do the other stuff.

 

Is that what logic you want to apply?

:unsure:

 

The only thing is added was the (int) to type-cast $order->delivery['country_id'] to type integer before comparing to 204.

 

It might be stored in the DB as a string.

 

PHP is pretty loose about comparing, but that's all that I could see that MIGHT make the code NOT do what you wanted.

[girolimoni]

hello, yes its that what i like to do ( if not 204 then ...). Problem is, that the same string is working in chechout_process.php. I don't understand why its not working in the ipn.php :(

 

Thanks :)

[germ]

It doesn't work because the ipn module uses different queries and variables.

 

You usually can't just copy a piece of code from one module and paste it into another and expect it to work without examining the rest of the code to be sure it will "fit in".

 

If you post more of the surrounding code so I can tell what part of the ipn module you're using the code in I might be able to fix you up with something that does work.

 

However, I must warn you that my MYSQL abilities are probably best described as "minimal at best"...

:blush:

[girolimoni]

It doesn't work because the ipn module uses different queries and variables.

 

You usually can't just copy a piece of code from one module and paste it into another and expect it to work without examining the rest of the code to be sure it will "fit in".

 

If you post more of the surrounding code so I can tell what part of the ipn module you're using the code in I might be able to fix you up with something that does work.

 

However, I must warn you that my MYSQL abilities are probably best described as "minimal at best"...

:blush:

 

 

Hello, this is the complete ipn.php file :) hope you can find it out:

 

<?php

/*

$Id: paypal_ipn.php,v 2.3.0.0 10/09/2007 11:58:21 alexstudio Exp $

 

Copyright © 2004 osCommerce

Released under the GNU General Public License

 

Original Authors: Harald Ponce de Leon, Mark Evans

Updates by PandA.nl, Navyhost, Zoeticlight, David, gravyface, AlexStudio, windfjf, Monika in Germany and Terra

v2.3 updated by AlexStudio

 

*/

 

chdir('../../../../');

require('includes/application_top.php');

$language = $_GET['language'];

include(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CHECKOUT_PROCESS);

// BOF configuration keys fix by AlexStudio

require(DIR_WS_CLASSES . 'payment.php');

$payment_modules = new payment(paypal_ipn);

// EOF configuration keys fix by AlexStudio

 

$parameters = 'cmd=_notify-validate';

 

foreach ($_POST as $key => $value) {

$parameters .= '&' . $key . '=' . urlencode(stripslashes($value));

}

 

if (MODULE_PAYMENT_PAYPAL_IPN_GATEWAY_SERVER == 'Live') {

$server = 'www.paypal.com';

} else {

$server = 'www.sandbox.paypal.com';

}

 

$fsocket = false;

$curl = false;

$result = false;

 

if ( (PHP_VERSION >= 4.3) && ($fp = @fsockopen('ssl://' . $server, 443, $errno, $errstr, 30)) ) {

$fsocket = true;

} elseif (function_exists('curl_exec')) {

$curl = true;

} elseif ($fp = @fsockopen($server, 80, $errno, $errstr, 30)) {

$fsocket = true;

}

 

if ($fsocket == true) {

$header = 'POST /cgi-bin/webscr HTTP/1.0' . "\r\n" .

'Host: ' . $server . "\r\n" .

'Content-Type: application/x-www-form-urlencoded' . "\r\n" .

'Content-Length: ' . strlen($parameters) . "\r\n" .

'Connection: close' . "\r\n\r\n";

 

@fputs($fp, $header . $parameters);

 

$string = '';

while (!@feof($fp)) {

$res = @fgets($fp, 1024);

$string .= $res;

 

if ( ($res == 'VERIFIED') || ($res == 'INVALID') ) {

$result = $res;

break;

}

}

 

@fclose($fp);

} elseif ($curl == true) {

$ch = curl_init();

 

// BOF add by AlexStudio

// For the poor souls on GoDaddy and the like, set the connection to go through their proxy

if (trim(MODULE_PAYMENT_PAYPAL_IPN_PROXY_SERVER) != '') {

curl_setopt($ch, CURLOPT_PROXYTYPE, CURLPROXY_HTTP);

curl_setopt($ch, CURLOPT_PROXY, MODULE_PAYMENT_PAYPAL_IPN_PROXY_SERVER);

}

// Eof add by AlexStudio

curl_setopt($ch, CURLOPT_URL, 'https://' . $server . '/cgi-bin/webscr');

curl_setopt($ch, CURLOPT_POST, true);

curl_setopt($ch, CURLOPT_POSTFIELDS, $parameters);

curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

curl_setopt($ch, CURLOPT_HEADER, false);

curl_setopt($ch, CURLOPT_TIMEOUT, 30);

curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);

 

$result = curl_exec($ch);

 

curl_close($ch);

}

 

if ($result == 'VERIFIED') {

if (isset($_POST['invoice']) && is_numeric($_POST['invoice']) && ($_POST['invoice'] > 0)) {

$order_query = tep_db_query("select currency, currency_value from " . TABLE_ORDERS . " where orders_id = '" . $_POST['invoice'] . "' and customers_id = '" . (int)$_POST['custom'] . "'");

if (tep_db_num_rows($order_query) > 0) {

$order_db = tep_db_fetch_array($order_query);

 

// let's re-create the required arrays

require(DIR_WS_CLASSES . 'order.php');

$order = new order($_POST['invoice']);

 

// let's update the order status

$total_query = tep_db_query("select value from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . $_POST['invoice'] . "' and class = 'ot_total' limit 1");

$total = tep_db_fetch_array($total_query);

 

$comment_status = 'payment status: ' . $_POST['payment_status'] . ' (' . ucfirst($_POST['payer_status']) . '; ' . $currencies->format($_POST['mc_gross'], false, $_POST['mc_currency']) . ')';

 

if ($_POST['payment_status'] == 'Pending') {

$comment_status .= '; ' . $_POST['pending_reason'];

} elseif ( ($_POST['payment_status'] == 'Reversed') || ($_POST['payment_status'] == 'Refunded') ) {

$comment_status .= '; ' . $_POST['reason_code'];

} elseif ( ($_POST['payment_status'] == 'Completed') && (tep_not_null($_POST['address_street'])) ) {

$comment_status .= ", \n" . PAYPAL_ADDRESS . ": " . $_POST['address_name'] . ", " . $_POST['address_street'] . ", " . $_POST['address_city'] . ", " . $_POST['address_zip'] . ", " . $_POST['address_state'] . ", " . $_POST['address_country'] . ", " . $_POST['address_country_code'] . ", " . $_POST['address_status'];

}

 

$order_status_id = DEFAULT_ORDERS_STATUS_ID;

 

// modified AlexStudio's Rounding error bug fix

// variances of up to 0.05 on either side (plus / minus) are ignored

if ((((number_format($total['value'] * $order_db['currency_value'], $currencies->get_decimal_places($order_db['currency']))) - $_POST['mc_gross']) <= 0.05)

&&

(((number_format($total['value'] * $order_db['currency_value'], $currencies->get_decimal_places($order_db['currency']))) - $_POST['mc_gross']) >= -0.05)) {

 

// Terra -> modified update. If payment status is "completed" than a completed order status is chosen based on the admin settings

if ( (MODULE_PAYMENT_PAYPAL_IPN_COMP_ORDER_STATUS_ID > 0) && ($_POST['payment_status'] == 'Completed') ) {

$order_status_id = MODULE_PAYMENT_PAYPAL_IPN_COMP_ORDER_STATUS_ID;

} elseif (MODULE_PAYMENT_PAYPAL_IPN_ORDER_STATUS_ID > 0) {

$order_status_id = MODULE_PAYMENT_PAYPAL_IPN_ORDER_STATUS_ID;

}

}

 

// Let's see what the PayPal payment status is and set the notification accordingly

// more info: https://www.paypal.com/IntegrationCenter/ic...-reference.html

if ( ($_POST['payment_status'] == 'Pending') || ($_POST['payment_status'] == 'Completed')) {

$customer_notified = '1';

} else {

$customer_notified = '0';

}

 

tep_db_query("update " . TABLE_ORDERS . " set orders_status = '" . $order_status_id . "', last_modified = now() where orders_id = '" . $_POST['invoice'] . "'");

 

$sql_data_array = array('orders_id' => $_POST['invoice'],

'orders_status_id' => $order_status_id,

'date_added' => 'now()',

'customer_notified' => $customer_notified,

'comments' => 'PayPal IPN Verified [' . $comment_status . ']');

 

tep_db_perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array);

 

// If the order is completed, then we want to send the order email and update the stock

if ($_POST['payment_status'] == 'Completed') { // START STATUS == COMPLETED LOOP

 

// initialized for the email confirmation

$products_ordered = '';

$total_tax = 0;

 

// let's update the stock

#######################################################

for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { // PRODUCT LOOP STARTS HERE

// Stock Update - Joao Correia

if (STOCK_LIMITED == 'true') {

if (DOWNLOAD_ENABLED == 'true') {

$stock_query_raw = "SELECT products_quantity, pad.products_attributes_filename

FROM " . TABLE_PRODUCTS . " p

LEFT JOIN " . TABLE_PRODUCTS_ATTRIBUTES . " pa

ON p.products_id=pa.products_id

LEFT JOIN " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " pad

ON pa.products_attributes_id=pad.products_attributes_id

WHERE p.products_id = '" . tep_get_prid($order->products[$i]['id']) . "'";

// Will work with only one option for downloadable products

// otherwise, we have to build the query dynamically with a loop

$products_attributes = $order->products[$i]['attributes'];

if (is_array($products_attributes)) {

$stock_query_raw .= " AND pa.options_id = '" . $products_attributes[0]['option_id'] . "' AND pa.options_values_id = '" . $products_attributes[0]['value_id'] . "'";

}

$stock_query = tep_db_query($stock_query_raw);

} else {

$stock_query = tep_db_query("select products_quantity from " . TABLE_PRODUCTS . " where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'");

}

if (tep_db_num_rows($stock_query) > 0) {

$stock_values = tep_db_fetch_array($stock_query);

// do not decrement quantities if products_attributes_filename exists

if ((DOWNLOAD_ENABLED != 'true') || (!$stock_values['products_attributes_filename'])) {

$stock_left = $stock_values['products_quantity'] - $order->products[$i]['qty'];

} else {

$stock_left = $stock_values['products_quantity'];

}

tep_db_query("update " . TABLE_PRODUCTS . " set products_quantity = '" . $stock_left . "' where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'");

if ( ($stock_left < 1) && (STOCK_ALLOW_CHECKOUT == 'false') ) {

tep_db_query("update " . TABLE_PRODUCTS . " set products_status = '0' where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'");

}

}

}

 

// Update products_ordered (for bestsellers list)

tep_db_query("update " . TABLE_PRODUCTS . " set products_ordered = products_ordered + " . sprintf('%d', $order->products[$i]['qty']) . " where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'");

 

// Let's get all the info together for the email

$total_weight += ($order->products[$i]['qty'] * $order->products[$i]['weight']);

$total_tax += tep_calculate_tax($total_products_price, $products_tax) * $order->products[$i]['qty'];

$total_cost += $total_products_price;

 

// Let's get the attributes

$products_ordered_attributes = '';

if ( (isset($order->products[$i]['attributes'])) && (sizeof($order->products[$i]['attributes']) > 0) ) {

for ($j=0, $n2=sizeof($order->products[$i]['attributes']); $j<$n2; $j++) {

$products_ordered_attributes .= "\n\t" . $order->products[$i]['attributes'][$j]['option'] . ' ' . $order->products[$i]['attributes'][$j]['value'];

}

}

 

// Let's format the products model

$products_model = '';

if ( !empty($order->products[$i]['model']) ) {

$products_model = ' (' . $order->products[$i]['model'] . ')';

}

 

// Let's put all the product info together into a string

$products_ordered .= $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name'] . $products_model . ' = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . $products_ordered_attributes . "\n";

// BOF: Availability: Added: , availability_id_in_stock, availability_id_out_of_stock

$avail_product_info_query = tep_db_query("select availability_id_in_stock, availability_id_out_of_stock, products_quantity from " . TABLE_PRODUCTS . " where products_id ='" . tep_get_prid($order->products[$i]['id']) . "'");

$avail_product_info = tep_db_fetch_array($avail_product_info_query);

 

$availability_query = tep_db_query("select * from ".TABLE_AVAILABILITY." where language_id = " . $languages_id . " order by availability_id");

$availability_array = array();

while ($availability_tmp = tep_db_fetch_array($availability_query)) {

$availability_array[$availability_tmp['availability_id']] = $availability_tmp['availability_name'];

}

if ($avail_product_info['products_quantity'] < 1) {

$products_ordered .= sprintf($availability_array[$avail_product_info['availability_id_out_of_stock']],$avail_product_info['products_quantity']). "\n";

} else {

$products_ordered .= sprintf($availability_array[$avail_product_info['availability_id_in_stock']],$avail_product_info['products_quantity']). "\n";

}

// EOF: Availability

} // PRODUCT LOOP ENDS HERE

#######################################################

 

// lets start with the email confirmation

// BOF content type fix by AlexStudio

$content_type = '';

$content_count = 0;

// BOF order comment fix

$comment_query = tep_db_query("select comments from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . $_POST['invoice'] . "'");

$comment_array = tep_db_fetch_array($comment_query);

$comments = $comment_array['comments'];

// EOF order comment fix

 

if (DOWNLOAD_ENABLED == 'true') {

$content_query = tep_db_query("select * from " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " where orders_id = '" . (int)$_POST['invoice'] . "'");

$content_count = tep_db_num_rows($content_query);

if ($content_count > 0) {

$content_type = 'virtual';

}

}

switch ($content_type) {

case 'virtual':

if ($content_count != sizeof($order->products)) $content_type = 'mixed';

break;

default:

$content_type = 'physical';

break;

}

// EOF content type fix by AlexStudio

// $order variables have been changed from checkout_process to work with the variables from the function query () instead of cart () in the order class

$email_order = STORE_NAME . "\n" .

EMAIL_SEPARATOR . "\n" .

EMAIL_TEXT_ORDER_NUMBER . ' ' . $_POST['invoice'] . "\n" .

EMAIL_TEXT_INVOICE_URL . ' ' . tep_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $_POST['invoice'], 'SSL', false) . EMAIL_TEXT_LINK_LANGUAGE . "\n" .

EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG) . "\n\n";

 

// BOF order comment fix by AlexStudio

if ($comments) {

$email_order .= $comments . "\n\n";

}

// EOF order comment fix by AlexStudio

 

$email_order .= EMAIL_TEXT_PRODUCTS . "\n" .

EMAIL_SEPARATOR . "\n" .

$products_ordered .

EMAIL_SEPARATOR . "\n";

 

for ($i=0, $n=sizeof($order->totals); $i<$n; $i++) {

$email_order .= strip_tags($order->totals[$i]['title']) . ' ' . strip_tags($order->totals[$i]['text']) . "\n";

}

 

// BOF content type fix by AlexStudio

if ($content_type != 'virtual') {

// EOF content type fix by AlexStudio

$email_order .= "\n" . EMAIL_TEXT_DELIVERY_ADDRESS . "\n" .

EMAIL_SEPARATOR . "\n" .

tep_address_format($order->delivery['format_id'], $order->delivery, 0, '', "\n") . "\n\n".

EMAIL_TEXT_TELEFONNUMMER . $order->customer['telephone'] . "\n" .

EMAIL_TEXT_EMAIL . $order->customer['email_address'] . "\n";

}

 

$email_order .= "\n" . EMAIL_TEXT_BILLING_ADDRESS . "\n" .

EMAIL_SEPARATOR . "\n" .

tep_address_format($order->billing['format_id'], $order->billing, 0, '', "\n") . "\n\n";

if (is_object($$payment)) {

$email_order .= EMAIL_TEXT_PAYMENT_METHOD . "\n" .

EMAIL_SEPARATOR . "\n";

$payment_class = $$payment;

$email_order .= $payment_class->title . "\n\n";

if ($payment_class->email_footer) {

$email_order .= $payment_class->email_footer . "\n\n";

}

$email_order .= EMAIL_SEPARATOR2 . "\n" .

EMAIL_TEXT_TRUSTED_TEXT . "\n";

if ($order->delivery['country']['title'] != 'Switzerland')

{

$email_order .= EMAIL_SEPARATOR2 . "\n" .

EMAIL_TEXT_TRUSTED_TEXT2 . "\n" .

EMAIL_SEPARATOR2 . "\n" ;

 

}

}

// Order Number in Customer Order Emails v 1.0

// tep_mail($order->customer['firstname'] . ' ' . $order->customer['lastname'], $order->customer['email_address'], EMAIL_TEXT_SUBJECT, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

 

$new_mail_subject = EMAIL_TEXT_ORDER_NUMBER . ' ' . $_POST['invoice'] . ' - ' . STORE_NAME . "\n" ;

tep_mail($order->customer['firstname'] . ' ' . $order->customer['lastname'], $order->customer['email_address'], $new_mail_subject, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

 

// Order Number in Customer Order Emails v 1.0

 

// send emails to other people

if (SEND_EXTRA_ORDER_EMAILS_TO != '') {

// Order Number in Customer Order Emails v 1.0

// tep_mail('', SEND_EXTRA_ORDER_EMAILS_TO, EMAIL_TEXT_SUBJECT, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

tep_mail('', SEND_EXTRA_ORDER_EMAILS_TO, $new_mail_subject, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

// Order Number in Customer Order Emails v 1.0

}

} // END STATUS == COMPLETED LOOP

 

if ($_POST['payment_status'] == 'Pending') { // START STATUS == PENDING LOOP

 

$email_order = STORE_NAME . "\n" .

EMAIL_SEPARATOR . "\n" .

EMAIL_TEXT_ORDER_NUMBER . ' ' . $_POST['invoice'] . "\n" .

EMAIL_TEXT_INVOICE_URL . ' ' . tep_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $_POST['invoice'], 'SSL', false) . "\n" .

EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG) . "\n\n" .

EMAIL_SEPARATOR . "\n" .

EMAIL_PAYPAL_PENDING_NOTICE . "\n\n";

 

// Order Number in Customer Order Emails v 1.0

// tep_mail($order->customer['firstname'] . ' ' . $order->customer['lastname'], $order->customer['email_address'], EMAIL_TEXT_SUBJECT, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

 

tep_mail($order->customer['firstname'] . ' ' . $order->customer['lastname'], $order->customer['email_address'], $new_mail_subject, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

 

// Order Number in Customer Order Emails v 1.0

 

// send emails to other people

if (SEND_EXTRA_ORDER_EMAILS_TO != '') {

// Order Number in Customer Order Emails v 1.0

// tep_mail('', SEND_EXTRA_ORDER_EMAILS_TO, EMAIL_TEXT_SUBJECT, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

tep_mail('', SEND_EXTRA_ORDER_EMAILS_TO, $new_mail_subject, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

// Order Number in Customer Order Emails v 1.0

}

} // END STATUS == PENDING LOOP

//emptying cart for everyone! by Monika in Germany

tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . (int)$_POST['custom'] . "'");

tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where customers_id = '" . (int)$_POST['custom'] . "'");

//end emptying cart for everyone

}

}

} else {

if (tep_not_null(MODULE_PAYMENT_PAYPAL_IPN_DEBUG_EMAIL)) {

$email_body = '$_POST:' . "\n\n";

foreach ($_POST as $key => $value) {

$email_body .= $key . '=' . $value . "\n";

}

$email_body .= "\n" . '$_GET:' . "\n\n";

foreach ($_GET as $key => $value) {

$email_body .= $key . '=' . $value . "\n";

}

tep_mail('', MODULE_PAYMENT_PAYPAL_IPN_DEBUG_EMAIL, 'PayPal IPN Invalid Process', $email_body, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

}

 

if (isset($_POST['invoice']) && is_numeric($_POST['invoice']) && ($_POST['invoice'] > 0)) {

$check_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where orders_id = '" . $_POST['invoice'] . "' and customers_id = '" . (int)$_POST['custom'] . "'");

if (tep_db_num_rows($check_query) > 0) {

$comment_status = $_POST['payment_status'];

 

if ($_POST['payment_status'] == 'Pending') {

$comment_status .= '; ' . $_POST['pending_reason'];

} elseif ( ($_POST['payment_status'] == 'Reversed') || ($_POST['payment_status'] == 'Refunded') ) {

$comment_status .= '; ' . $_POST['reason_code'];

}

 

tep_db_query("update " . TABLE_ORDERS . " set orders_status = '" . ((MODULE_PAYMENT_PAYPAL_IPN_ORDER_STATUS_ID > 0) ? MODULE_PAYMENT_PAYPAL_IPN_ORDER_STATUS_ID : DEFAULT_ORDERS_STATUS_ID) . "', last_modified = now() where orders_id = '" . $_POST['invoice'] . "'");

 

$sql_data_array = array('orders_id' => $_POST['invoice'],

'orders_status_id' => (MODULE_PAYMENT_PAYPAL_IPN_ORDER_STATUS_ID > 0) ? MODULE_PAYMENT_PAYPAL_IPN_ORDER_STATUS_ID : DEFAULT_ORDERS_STATUS_ID,

'date_added' => 'now()',

'customer_notified' => '0',

'comments' => 'PayPal IPN Invalid [' . $comment_status . ']');

 

tep_db_perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array);

}

}

}

 

require('includes/application_bottom.php');

?>

[germ]

In the code you're adding change this:

 

if ($order->delivery['country']['title'] != 'Switzerland')

to

 

if (strtolower($_POST['address_country']) != 'switzerland')

Please note that switzerland MUST be lowercase.

[girolimoni]

In the code you're adding change this:

 

if ($order->delivery['country']['title'] != 'Switzerland')

to

 

if (strtolower($_POST['address_country']) != 'switzerland')

Please note that switzerland MUST be lowercase.

 

Hello :) Great it works!!! Great job thanks!!

 

I have a last small issue with the above ipn.php and maybe you can help me :)

 

I've noticed in the file ipn.php in /html/ext/modules/payment/paypal_ipn

 

the following line as in checkout.process.php:

 

$products_ordered .= $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name'] . $products_model . ' = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . $products_ordered_attributes . "\n";

 

Unfortunately the $products_ordered in the confirmation email has always the default currency and not the currency used by the customer.

 

Same thing happens if a add this line of code:

 

// BOF: Availability: Added: , availability_id_in_stock, availability_id_out_of_stock

$avail_product_info_query = tep_db_query("select availability_id_in_stock, availability_id_out_of_stock, products_quantity from " . TABLE_PRODUCTS . " where products_id ='" . tep_get_prid($order->products[$i]['id']) . "'");

$avail_product_info = tep_db_fetch_array($avail_product_info_query);

 

$availability_query = tep_db_query("select * from ".TABLE_AVAILABILITY." where language_id = " . $languages_id . " order by availability_id");

$availability_array = array();

while ($availability_tmp = tep_db_fetch_array($availability_query)) {

$availability_array[$availability_tmp['availability_id']] = $availability_tmp['availability_name'];

}

if ($avail_product_info['products_quantity'] < 1) {

$products_ordered .= sprintf($availability_array[$avail_product_info['availability_id_out_of_stock']],$avail_product_info['products_quantity']). "\n";

} else {

$products_ordered .= sprintf($availability_array[$avail_product_info['availability_id_in_stock']],$avail_product_info['products_quantity']). "\n";

}

// EOF: Availability

 

The stock status text is always displayed in german (default language)

 

thanks a lot :)