We need someone to extract a variable from our OScommerce database and put it into [url removed, login to view] as a variable like $totalprice and $subtotal in order for us to use them on an image string that we use to send this values to 3rd party programs.
As said before, we would need a variable for the Total and a variable for the Subtotal to be extacted and made inside the [url removed, login to view] using a code as this one for example:
// Get info for "city", "state", "country"
$orders_query = tep_db_query("select customers_city, customers_state, customers_country from " . TABLE_ORDERS . " where orders_id = '" . $order_id . "' AND customers_id = '" . (int)$customer_id . "'");
$orders = tep_db_fetch_array($orders_query);
This code is used by us to extact different variables that we then use in a file to send them to a 3rd party program.
So what we actually will be needing is the exact code that we need to add into [url removed, login to view] in order to extract a variable that would be called $totalprice (representing the total amount) and $subtotal (representing the subtotal).
I am attacting the file that needs to be edited.