new payment remember add

[bekatron]

Hello

 

After the start to make a add for sending a mail to remember the costumer I'm having some problems.

For start I've take the review mail module http://addons.oscommerce.com/info/5471 and make it usable for sending a mail to each order that's not paid after a number of days specified in admin. Now i need the total order amount in my mail but i cant get it out of de database.

 

this is the code

 

// Get the order total for the order
 $orders_total_query = tep_db_query ("select text
 from " . TABLE_ORDERS_TOTAL . "
									 where orders_id = '" . $orders_id . "'
 and class = 'ot_total'
								 ");

 

 

and this is the code to place it in the mail

 

$totaal = $orders_total_array['text'];
	 $products_string .= $products_array['products_model'] . ' ' . $products_array['products_name'] . "\n";
	 $products_string .= ' ' . $link_server . DIR_WS_HTTPS_CATALOG . '/product_reviews_write.php?products_id=' . $products_array['products_id'] . "\n";
	 } // while ($products_array
 } // if (tep_db_num_rows

 // Placeholder text from the text file to be replaced
 $search_array = array (
	 '%%customer_name%%',
'%%orders_id%%',
'%%totaal%%',
'%%each%%',
	 '%%link%%',
	 '%%product_list%%',
	 '%%products%%',
	 '%%store_name%%',
	 '%%store_email%%',
	 '%%store_url%%',
	 '%%year%%'
 );
 // Replacement text -- must match the above array
 $replace_array = array (
	 $customers_name,
$orders_id,
$totaal,
	 $each,
	 $link,
	 $products_string,
	 $products,
	 STORE_NAME,
	 $from_address,
	 'http://' . $site_domain,
	 date ('Y')
 );

 

What's the problem in here. The mail is been send and all replacements are done except the total order amount.