{ global $wpdb; if (empty($term_id)) { return; } $source_folder = self::select_source_folder($term_id); return isset($source_folder['folder_id']) ? $source_folder['folder_id'] : ''; } public static function select_source_folder($source_id = '') { global $wpdb; if (empty($source_id)) { return false; } $sql = $wpdb->prepare("SELECT * FROM {$wpdb->dln_source_folder} AS sfolder WHERE sfolder.source_id = %d", (int) esc_sql($source_id)); $return = $wpdb->get_row($sql, ARRAY_A); return $return; } public static function select_folder_name($source_id = '') { global $wpdb; if (!$source_id) { return ''; } $sql = $wpdb->prepare("SELECT term.name AS folder_name \n\t\t\t\t\t\t\t\tFROM {$wpdb->dln_source_folder} AS sfolder \n\t\t\t\t\t\t\t\tINNER JOIN {$wpdb->terms} AS term \n\t\t\t\t\t\t\t\tON term.term_id = sfolder.folder_id\n\t\t\t\t\t\t\t\tWHERE sfolder.source_id = %d", (int) esc_sql($source_id)); $return = $wpdb->get_results($sql, ARRAY_A); return $return; } } DLN_Term_Helper::get_instance();