|
@@ 169-174 (lines=6) @@
|
| 166 |
|
|
| 167 |
|
$get_table = $wpdb->prefix . 'frm_item_metas'; |
| 168 |
|
$query = array( 'item_id' => $entry_id ); |
| 169 |
|
if ( is_numeric($field_id) ) { |
| 170 |
|
$query['field_id'] = $field_id; |
| 171 |
|
} else { |
| 172 |
|
$get_table .= ' it LEFT OUTER JOIN ' . $wpdb->prefix . 'frm_fields fi ON it.field_id=fi.id'; |
| 173 |
|
$query['fi.field_key'] = $field_id; |
| 174 |
|
} |
| 175 |
|
|
| 176 |
|
$result = FrmDb::get_var( $get_table, $query, 'meta_value' ); |
| 177 |
|
$result = maybe_unserialize($result); |
|
@@ 220-224 (lines=5) @@
|
| 217 |
|
$query[] = 'INNER JOIN ' . $wpdb->prefix . 'frm_items e ON (e.id=em.item_id)'; |
| 218 |
|
} |
| 219 |
|
|
| 220 |
|
if ( is_numeric($field_id) ) { |
| 221 |
|
$query[] = $wpdb->prepare('WHERE em.field_id=%d', $field_id); |
| 222 |
|
} else { |
| 223 |
|
$query[] = $wpdb->prepare( 'LEFT JOIN ' . $wpdb->prefix . 'frm_fields fi ON (em.field_id = fi.id) WHERE fi.field_key=%s', $field_id ); |
| 224 |
|
} |
| 225 |
|
|
| 226 |
|
if ( ! $args['is_draft'] ) { |
| 227 |
|
$query[] = 'AND e.is_draft=0'; |