|
@@ 179-184 (lines=6) @@
|
| 176 |
|
|
| 177 |
|
$get_table = $wpdb->prefix . 'frm_item_metas'; |
| 178 |
|
$query = array( 'item_id' => $entry_id ); |
| 179 |
|
if ( is_numeric($field_id) ) { |
| 180 |
|
$query['field_id'] = $field_id; |
| 181 |
|
} else { |
| 182 |
|
$get_table .= ' it LEFT OUTER JOIN ' . $wpdb->prefix . 'frm_fields fi ON it.field_id=fi.id'; |
| 183 |
|
$query['fi.field_key'] = $field_id; |
| 184 |
|
} |
| 185 |
|
|
| 186 |
|
$result = FrmDb::get_var( $get_table, $query, 'meta_value' ); |
| 187 |
|
$result = maybe_unserialize($result); |
|
@@ 235-239 (lines=5) @@
|
| 232 |
|
$query[] = 'INNER JOIN ' . $wpdb->prefix . 'frm_items e ON (e.id=em.item_id)'; |
| 233 |
|
} |
| 234 |
|
|
| 235 |
|
if ( is_numeric($field_id) ) { |
| 236 |
|
$query[] = $wpdb->prepare('WHERE em.field_id=%d', $field_id); |
| 237 |
|
} else { |
| 238 |
|
$query[] = $wpdb->prepare( 'LEFT JOIN ' . $wpdb->prefix . 'frm_fields fi ON (em.field_id = fi.id) WHERE fi.field_key=%s', $field_id ); |
| 239 |
|
} |
| 240 |
|
|
| 241 |
|
if ( ! $args['is_draft'] ) { |
| 242 |
|
$query[] = 'AND e.is_draft=0'; |