[georgewf]

Hey guys, Some great ideas in this thread. Here's some code to add additional customer info like referer in the orders list.

The customer data is not directly available in the orders template.
So in orders.php add a field in this SQL select

// mod: add referer
$orders = func_query("SELECT $sql_tbl[orders].*, $sql_tbl[customers].id AS existing_userid, $sql_tbl[customers].login, $sql_tbl[customers].referer $search_condition ORDER BY $sort_string LIMIT $first_page, $objects_per_page");


In order_list.tpl add in the orders list:
<td> {$orders[oid].referer|replace:'http://':''|replace:'https://':''|truncate:"30":"...":TRUE:FALSE|strip_tags}
</td>

Also add new column header in that table and adjust colspan and widths.

Anyone know how to get the sum of orders placed by a customer like Rob has?