I am working on a mod to produce a printable gift certificate from a VM page.
In this specific case, components/com_virtuemart/themes/default/templates/pages/account.order_details.tpl.php

A link calls the certificate.php for this to happen. Here is the code I'm using from the VM account.order_details.tpl.php:

Code:

[code:1]<a href="www.mysite.com/GCCertificate/certificate.php?desc=f("order_item_name"«») ?>&code=p("coupon_code"«»); printf("%08d", $db->f("order_id"«»)) ?>&name=<?php $unknown_db->p("unknown_code"«») ?> ">Click to view Certificate</a>[/code:1]


When the visitor views their order history, they can click a link which pulls a coupon # with date of purchase and the product, (in this case, the product is the vendor that is participating in the coupon program).

All I need to add now is to pull the user name into the certificate but I'm not a programmer so my attempts have failed. I can pull the CBUser ID since it's integrated into VM, but what code can I use to retrieve and print the CB User Name?

Thanks!