Customer Orders Tab

[14Steve14]

Hi John

I have this installed on 1.0.8.20 and although it works there are a few errors reported and I wondered if you could help fix them. Apart from one they are a bit beyond me.

The first is at line 24

$query = tep_db_query(sprintf("SELECT o.orders_id, o.date_purchased, os.orders_status_name, o.payment_method, ots.title AS order_shipping, ott.text AS order_total FROM orders o LEFT JOIN orders_total ots ON (ots.orders_id = o.orders_id) LEFT JOIN orders_total ott ON (ott.orders_id = o.orders_id) LEFT JOIN orders_status os ON (os.orders_status_id = o.orders_status) WHERE ots.class = 'ot_shipping' AND ott.class = 'ot_total' AND os.language_id = '%d' AND o.customers_id in (SELECT customers_id FROM orders WHERE orders_id = '%d') ORDER BY date_purchased DESC", (int)$languages_id, (int)$oID));

The second is at line 25

Code: Select all

$no_orders = tep_db_num_rows($query);

which is hopefully fixed by

$no_orders = mysqli_num_rows($query);

The third is at line 43 which you may have already posted about in another post here

$table_content .= '<tr onclick="document.location.href=\'' . tep_href_link('orders.php', tep_get_all_get_params(['action', 'oID']) . '&action=edit&oID=' . $o['orders_id']) . '\'">';

which was fixed using

The fourth is on line 45

$table_content .= '<td>' . $o['orders_id'] . '</td><td class="">' . tep_datetime_short($o['date_purchased']) . '</td><td class="text-right">' . strip_tags($o['order_total']) . '</td><td>' . $o['orders_status_name'] . '</td><td>' . $o['payment_method'] . '</td><td>' . $o['order_shipping'] . "</td></tr>\n";

Can you help with any of these please.