Take a look at the wpsctDisplayCustomFieldsToFrontend() function in /php/publicajax.php
You could use that as a base for a new function, and then modify it so that it displays only one specific custom field for the ticket, instead of all of them.
Thread Starter
geohi
(@geohi)
great ill look into this. thank you!
Maybe you could add this to a future update? The ability to customize the front end and/or backend table views? 🙂
also the ability to sort by: date, email, or the custom fields? 🙂
thanks!
Thread Starter
geohi
(@geohi)
ok so i added that function to the .php i want to echo that specific custom field value, but im not quite sure i know what the variable is?? can you help? thanks
Thread Starter
geohi
(@geohi)
Ive been wanting to display the custom fields in the front end table for so long. with some guidance from the developer, and some digging around on my own, i finally got it. here’s the results (youll need to change your ‘type’ to whatever it is in your database)
function wpsctDisplayCustomFieldsToFrontenda($primkey) {
global $wpdb;
// Custom fields
$table_name44 = $wpdb->prefix . "wpscst_tickets";
$table_name33 = $wpdb->prefix . "wpstorecart_meta";
$grabrecord= "SELECT * FROM <code>{$table_name33}</code> WHERE <code>foreignkey</code>= '$primkey' AND <code>type</code>= 'wpsct_custom_72'";
$resultscf = $wpdb->get_results( $grabrecord , ARRAY_A );
return(base64_decode($resultscf[0]['value']));
}
then add this in the <TD> you want
wpsctDisplayCustomFieldsToFrontenda($result['primkey'])
voila!