|
@@ 222-227 (lines=6) @@
|
| 219 |
|
|
| 220 |
|
$get_table = $wpdb->prefix . 'frm_item_metas'; |
| 221 |
|
$query = array( 'item_id' => $entry_id ); |
| 222 |
|
if ( is_numeric( $field_id ) ) { |
| 223 |
|
$query['field_id'] = $field_id; |
| 224 |
|
} else { |
| 225 |
|
$get_table .= ' it LEFT OUTER JOIN ' . $wpdb->prefix . 'frm_fields fi ON it.field_id=fi.id'; |
| 226 |
|
$query['fi.field_key'] = $field_id; |
| 227 |
|
} |
| 228 |
|
|
| 229 |
|
$result = FrmDb::get_var( $get_table, $query, 'meta_value' ); |
| 230 |
|
FrmAppHelper::unserialize_or_decode( $result ); |
|
@@ 279-283 (lines=5) @@
|
| 276 |
|
$query[] = 'INNER JOIN ' . $wpdb->prefix . 'frm_items e ON (e.id=em.item_id)'; |
| 277 |
|
} |
| 278 |
|
|
| 279 |
|
if ( is_numeric( $field_id ) ) { |
| 280 |
|
$query[] = $wpdb->prepare( 'WHERE em.field_id=%d', $field_id ); |
| 281 |
|
} else { |
| 282 |
|
$query[] = $wpdb->prepare( 'LEFT JOIN ' . $wpdb->prefix . 'frm_fields fi ON (em.field_id = fi.id) WHERE fi.field_key=%s', $field_id ); |
| 283 |
|
} |
| 284 |
|
|
| 285 |
|
if ( ! $args['is_draft'] ) { |
| 286 |
|
$query[] = 'AND e.is_draft=0'; |