Support » Plugin: IDB Support Tickets » Display custom field?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author jquindlen

    (@jquindlen)

    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!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Display custom field?’ is closed to new replies.