Ejemplo n.º 1
0
 protected function get_metadata($ids, $meta_type)
 {
     global $wpdb;
     $table = _get_meta_table($meta_type);
     $id = $meta_type . '_id';
     if (!$table) {
         return array();
     }
     return array_map(array($this, 'unserialize_meta'), $wpdb->get_results("SELECT {$id}, meta_key, meta_value, meta_id FROM {$table} WHERE {$id} IN ( " . implode(',', wp_parse_id_list($ids)) . ' )', OBJECT));
 }
 /**
  * @group delete_term
  */
 public function test_delete_term()
 {
     $taxonomy = 'category';
     $term_id = $this->factory->term->create(array('taxonomy' => $taxonomy));
     $term = get_term($term_id, 'category');
     $Meta = new Smart_Custom_Fields_Meta($term);
     if (!_get_meta_table($Meta->get_meta_type())) {
         $Meta->add('text', 'text');
         $this->Ajax->delete_term($term_id, '', $taxonomy, $term);
         $this->assertSame(array(), $Meta->get('text'));
     }
 }
Ejemplo n.º 3
0
 /**
  * Replace the domain in meta tables
  *
  * @param  string   $type
  * @param  integer  $id
  * @param  integer  $objectId
  * @param  string   $key
  * @param  mixed    $value
  */
 public function replaceDomainInMeta($type, $id, $objectId, $key, $value)
 {
     global $wpdb;
     $table = _get_meta_table($type);
     $column = sanitize_key($type . '_id');
     $newValue = $this->replaceDomainRecursive($value);
     if ($value !== $newValue) {
         $data = ['meta_value' => maybe_serialize($newValue)];
         $where = [$column => $objectId, 'meta_key' => $key, 'meta_value' => maybe_serialize($value)];
         $wpdb->update($table, $data, $where);
     }
 }
 protected function get_metadata($ids, $meta_type)
 {
     global $wpdb;
     $table = _get_meta_table($meta_type);
     $id = $meta_type . '_id';
     if (!$table) {
         return array();
     }
     $private_meta_whitelist_sql = "'" . implode("','", array_map('esc_sql', Jetpack_Sync_Defaults::$default_whitelist_meta_keys)) . "'";
     $public_meta_blacklist_sql = "'" . implode("','", array_map('esc_sql', Jetpack_Sync_Defaults::$default_blacklist_meta_keys)) . "'";
     return array_map(array($this, 'unserialize_meta'), $wpdb->get_results("SELECT {$id}, meta_key, meta_value, meta_id FROM {$table} WHERE {$id} IN ( " . implode(',', wp_parse_id_list($ids)) . ' )' . " AND ( ( meta_key LIKE '\\_%' AND meta_key IN ( {$private_meta_whitelist_sql} ) )" . " OR ( meta_key NOT LIKE '\\_%' AND meta_key NOT IN ( {$public_meta_blacklist_sql} ) ) )", OBJECT));
 }
/**
 * @param string|int $identifier
 * @return array|bool
 */
function get_static_blocks_by_id($identifier)
{
    /** @var $wpdb wpdb */
    global $wpdb;
    if (!($table = _get_meta_table('post'))) {
        return false;
    }
    $postIds = $wpdb->get_col($wpdb->prepare("SELECT `post_id` FROM {$table} WHERE `meta_key` = '_identifier' AND `meta_value` = %s", $identifier));
    if (empty($postIds)) {
        return false;
    }
    return get_posts(array('include' => $postIds, 'post_type' => 'static_block'));
}
 protected function get_metadata($ids, $meta_type)
 {
     global $wpdb;
     $table = _get_meta_table($meta_type);
     $id = $meta_type . '_id';
     if (!$table) {
         return array();
     }
     $private_meta_whitelist_sql = '';
     $meta_module = Jetpack_Sync_Modules::get_module("meta");
     switch ($meta_type) {
         case 'post':
             $private_meta_whitelist_sql = "'" . implode("','", array_map('esc_sql', $meta_module->get_post_meta_whitelist())) . "'";
             break;
         case 'comment':
             $private_meta_whitelist_sql = "'" . implode("','", array_map('esc_sql', $meta_module->get_comment_meta_whitelist())) . "'";
             break;
     }
     return array_map(array($this, 'unserialize_meta'), $wpdb->get_results("SELECT {$id}, meta_key, meta_value, meta_id FROM {$table} WHERE {$id} IN ( " . implode(',', wp_parse_id_list($ids)) . ' )' . " AND meta_key IN ( {$private_meta_whitelist_sql} ) ", OBJECT));
 }
 /**
  * Retrieve custom fields for object.
  *
  * @param WP_REST_Request $request
  * @return WP_REST_Request|WP_Error List of meta object data on success, WP_Error otherwise
  */
 public function get_items($request)
 {
     $parent_id = (int) $request['parent_id'];
     global $wpdb;
     $table = _get_meta_table($this->parent_type);
     $parent_column = $this->get_parent_column();
     $id_column = $this->get_id_column();
     // @codingStandardsIgnoreStart
     $results = $wpdb->get_results($wpdb->prepare("SELECT {$id_column}, {$parent_column}, meta_key, meta_value FROM {$table} WHERE {$parent_column} = %d", $parent_id));
     // @codingStandardsIgnoreEnd
     $meta = array();
     foreach ($results as $row) {
         $value = $this->prepare_item_for_response($row, $request, true);
         if (is_wp_error($value)) {
             continue;
         }
         $meta[] = $this->prepare_response_for_collection($value);
     }
     return rest_ensure_response($meta);
 }
Ejemplo n.º 8
0
 /**
  * Retrieve custom fields for object.
  *
  * @param int $id Object ID
  * @return (array[]|WP_Error) List of meta object data on success, WP_Error otherwise
  */
 public function get_all_meta($id)
 {
     $check = $this->check_object($id);
     if (is_wp_error($check)) {
         return $check;
     }
     global $wpdb;
     $table = _get_meta_table($this->type);
     $parent_column = $this->get_parent_column();
     $results = $wpdb->get_results($wpdb->prepare("SELECT meta_id, meta_key, meta_value FROM {$table} WHERE {$parent_column} = %d", $id));
     $meta = array();
     foreach ($results as $row) {
         $value = $this->prepare_meta($id, $row, true);
         if (is_wp_error($value)) {
             continue;
         }
         $meta[] = $value;
     }
     return apply_filters('json_prepare_meta', $meta, $id);
 }
 /**
  * This implementation of get_objects_by_id() is a bit hacky since we're not passing in an array of meta IDs,
  * but instead an array of post or comment IDs for which to retrieve meta for. On top of that,
  * we also pass in an associative array where we expect there to be 'meta_key' and 'ids' keys present.
  *
  * This seemed to be required since if we have missing meta on WP.com and need to fetch it, we don't know what
  * the meta key is, but we do know that we have missing meta for a given post or comment.
  *
  * @param string $object_type The type of object for which we retrieve meta. Either 'post' or 'comment'
  * @param array $config Must include 'meta_key' and 'ids' keys
  *
  * @return array
  */
 public function get_objects_by_id($object_type, $config)
 {
     global $wpdb;
     $table = _get_meta_table($object_type);
     if (!$table) {
         return array();
     }
     if (!isset($config['meta_key']) || !isset($config['ids']) || !is_array($config['ids'])) {
         return array();
     }
     $meta_key = $config['meta_key'];
     $ids = $config['ids'];
     $object_id_column = $object_type . '_id';
     // Sanitize so that the array only has integer values
     $ids_string = implode(', ', array_map('intval', $ids));
     $metas = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$table} WHERE {$object_id_column} IN ( {$ids_string} ) AND meta_key = %s", $meta_key));
     $meta_objects = array();
     foreach ((array) $metas as $meta_object) {
         $meta_object = (array) $meta_object;
         $meta_objects[$meta_object[$object_id_column]] = array('meta_type' => $object_type, 'meta_id' => $meta_object['meta_id'], 'meta_key' => $meta_key, 'meta_value' => $meta_object['meta_value'], 'object_id' => $meta_object[$object_id_column]);
     }
     return $meta_objects;
 }
 public function auto_upgrade_options()
 {
     $current_db_version = 1;
     //Check version
     if ($this->options['db_version'] < $current_db_version) {
         global $wpdb;
         //DB_VERSION 1: Since 2.1.0-b5
         if ($this->options['db_version'] < 1) {
             //RENAME meta_key _wjecf_matching_product_qty TO _wjecf_min_matching_product_qty
             $where = array("meta_key" => "_wjecf_matching_product_qty");
             $set = array('meta_key' => "_wjecf_min_matching_product_qty");
             $wpdb->update(_get_meta_table('post'), $set, $where);
             //RENAME meta_key woocommerce-jos-autocoupon TO _wjecf_is_auto_coupon
             $where = array("meta_key" => "woocommerce-jos-autocoupon");
             $set = array('meta_key' => "_wjecf_is_auto_coupon");
             $wpdb->update(_get_meta_table('post'), $set, $where);
             //Now we're version 1
             $this->options['db_version'] = 1;
         }
         // Write options to database
         update_option('wjecf_options', $this->options, false);
     }
 }
Ejemplo n.º 11
0
/**
 * Delete metadata for the specified object.
 *
 * @uses $wpdb WordPress database object for queries.
 *
 * @param string $meta_type Type of object metadata is for (e.g., comment, post, or user)
 * @param int $object_id ID of the object metadata is for
 * @param string $meta_key Metadata key
 * @param mixed $meta_value Optional. Metadata value. Must be serializable if non-scalar. If specified, only delete metadata entries
 *        with this value. Otherwise, delete all entries with the specified meta_key.
 * @param bool $delete_all Optional, default is false. If true, delete matching metadata entries
 *        for all objects, ignoring the specified object_id. Otherwise, only delete matching
 *        metadata entries for the specified object_id.
 *
 * @return bool True on successful delete, false on failure.
 */
function fw_delete_metadata($meta_type, $object_id, $meta_key, $meta_value = '', $delete_all = false)
{
    /**
     * @var WPDB $wpdb
     */
    global $wpdb;
    if (!$meta_type || !$meta_key || !is_numeric($object_id) && !$delete_all) {
        return false;
    }
    $object_id = absint($object_id);
    if (!$object_id && !$delete_all) {
        return false;
    }
    $table = _get_meta_table($meta_type);
    if (!$table) {
        return false;
    }
    $type_column = sanitize_key($meta_type . '_id');
    $id_column = 'user' == $meta_type ? 'umeta_id' : 'meta_id';
    // expected_slashed ($meta_key)
    //$meta_key = wp_unslash($meta_key);
    //$meta_value = wp_unslash($meta_value);
    /**
     * Filter whether to delete metadata of a specific type.
     *
     * The dynamic portion of the hook, $meta_type, refers to the meta
     * object type (comment, post, or user). Returning a non-null value
     * will effectively short-circuit the function.
     *
     * @param null|bool $delete Whether to allow metadata deletion of the given type.
     * @param int $object_id Object ID.
     * @param string $meta_key Meta key.
     * @param mixed $meta_value Meta value. Must be serializable if non-scalar.
     * @param bool $delete_all Whether to delete the matching metadata entries
     *                              for all objects, ignoring the specified $object_id.
     *                              Default false.
     */
    $check = apply_filters("delete_{$meta_type}_metadata", null, $object_id, $meta_key, $meta_value, $delete_all);
    if (null !== $check) {
        return (bool) $check;
    }
    $_meta_value = $meta_value;
    $meta_value = maybe_serialize($meta_value);
    $query = $wpdb->prepare("SELECT {$id_column} FROM {$table} WHERE meta_key = %s", $meta_key);
    if (!$delete_all) {
        $query .= $wpdb->prepare(" AND {$type_column} = %d", $object_id);
    }
    if ($meta_value) {
        $query .= $wpdb->prepare(" AND meta_value = %s", $meta_value);
    }
    $meta_ids = $wpdb->get_col($query);
    if (!count($meta_ids)) {
        return false;
    }
    if ($delete_all) {
        $object_ids = $wpdb->get_col($wpdb->prepare("SELECT {$type_column} FROM {$table} WHERE meta_key = %s", $meta_key));
    }
    /**
     * Fires immediately before deleting metadata of a specific type.
     *
     * The dynamic portion of the hook, $meta_type, refers to the meta
     * object type (comment, post, or user).
     *
     * @param array $meta_ids An array of metadata entry IDs to delete.
     * @param int $object_id Object ID.
     * @param string $meta_key Meta key.
     * @param mixed $meta_value Meta value.
     */
    do_action("delete_{$meta_type}_meta", $meta_ids, $object_id, $meta_key, $_meta_value);
    // Old-style action.
    if ('post' == $meta_type) {
        /**
         * Fires immediately before deleting metadata for a post.
         *
         * @param array $meta_ids An array of post metadata entry IDs to delete.
         */
        do_action('delete_postmeta', $meta_ids);
    }
    $query = "DELETE FROM {$table} WHERE {$id_column} IN( " . implode(',', $meta_ids) . " )";
    $count = $wpdb->query($query);
    if (!$count) {
        return false;
    }
    if ($delete_all) {
        foreach ((array) $object_ids as $o_id) {
            wp_cache_delete($o_id, $meta_type . '_meta');
        }
    } else {
        wp_cache_delete($object_id, $meta_type . '_meta');
    }
    /**
     * Fires immediately after deleting metadata of a specific type.
     *
     * The dynamic portion of the hook name, $meta_type, refers to the meta
     * object type (comment, post, or user).
     *
     * @param array $meta_ids An array of deleted metadata entry IDs.
     * @param int $object_id Object ID.
     * @param string $meta_key Meta key.
     * @param mixed $meta_value Meta value.
     */
    do_action("deleted_{$meta_type}_meta", $meta_ids, $object_id, $meta_key, $_meta_value);
    // Old-style action.
    if ('post' == $meta_type) {
        /**
         * Fires immediately after deleting metadata for a post.
         *
         * @param array $meta_ids An array of deleted post metadata entry IDs.
         */
        do_action('deleted_postmeta', $meta_ids);
    }
    return true;
}
Ejemplo n.º 12
0
 protected function executeSQL()
 {
     $import_entry = $this->options['custom_type'] == 'import_users' ? 'user' : 'post';
     // prepare bulk SQL query
     $meta_table = _get_meta_table($import_entry);
     if ($this->post_meta_to_insert) {
         $values = array();
         $already_added = array();
         foreach (array_reverse($this->post_meta_to_insert) as $key => $value) {
             if (!empty($value['meta_key']) and !in_array($value['pid'] . '-' . $value['meta_key'], $already_added)) {
                 $already_added[] = $value['pid'] . '-' . $value['meta_key'];
                 $values[] = '(' . $value['pid'] . ',"' . $value['meta_key'] . '",\'' . maybe_serialize($value['meta_value']) . '\')';
             }
         }
         $this->wpdb->query("INSERT INTO {$meta_table} (`" . $import_entry . "_id`, `meta_key`, `meta_value`) VALUES " . implode(',', $values));
         $this->post_meta_to_insert = array();
     }
 }
 public function get_weather($type)
 {
     global $wpdb;
     $table = _get_meta_table('post');
     $sql = "SELECT p.ID,p.post_title FROM " . $wpdb->posts . " as p " . " WHERE p.post_type LIKE %s";
     $results = $wpdb->get_results($wpdb->prepare($sql, $type));
     foreach ($results as $post) {
         $post_id = $post->ID;
     }
     $meta_data = get_metadata('post', $post_id);
     $data['post_id'] = $post_id;
     $data['weather_url'] = $meta_data['weather_url']['0'];
     $data['location'] = $meta_data['location']['0'];
     $data['weather_data'] = $this->get_weather_details($data);
     return $data;
 }
Ejemplo n.º 14
0
/**
 * Update the metadata cache for the specified objects.
 *
 * @since 2.9.0
 *
 * @global wpdb $wpdb WordPress database abstraction object.
 *
 * @param string    $meta_type  Type of object metadata is for (e.g., comment, post, or user)
 * @param int|array $object_ids Array or comma delimited list of object IDs to update cache for
 * @return array|false Metadata cache for the specified objects, or false on failure.
 */
function update_meta_cache($meta_type, $object_ids)
{
    global $wpdb;
    if (!$meta_type || !$object_ids) {
        return false;
    }
    $table = _get_meta_table($meta_type);
    if (!$table) {
        return false;
    }
    $column = sanitize_key($meta_type . '_id');
    if (!is_array($object_ids)) {
        $object_ids = preg_replace('|[^0-9,]|', '', $object_ids);
        $object_ids = explode(',', $object_ids);
    }
    $object_ids = array_map('intval', $object_ids);
    $cache_key = $meta_type . '_meta';
    $ids = array();
    $cache = array();
    foreach ($object_ids as $id) {
        $cached_object = wp_cache_get($id, $cache_key);
        if (false === $cached_object) {
            $ids[] = $id;
        } else {
            $cache[$id] = $cached_object;
        }
    }
    if (empty($ids)) {
        return $cache;
    }
    // Get meta info
    $id_list = join(',', $ids);
    $id_column = 'user' == $meta_type ? 'umeta_id' : 'meta_id';
    $meta_list = $wpdb->get_results("SELECT {$column}, meta_key, meta_value FROM {$table} WHERE {$column} IN ({$id_list}) ORDER BY {$id_column} ASC", ARRAY_A);
    if (!empty($meta_list)) {
        foreach ($meta_list as $metarow) {
            $mpid = intval($metarow[$column]);
            $mkey = $metarow['meta_key'];
            $mval = $metarow['meta_value'];
            // Force subkeys to be array type:
            if (!isset($cache[$mpid]) || !is_array($cache[$mpid])) {
                $cache[$mpid] = array();
            }
            if (!isset($cache[$mpid][$mkey]) || !is_array($cache[$mpid][$mkey])) {
                $cache[$mpid][$mkey] = array();
            }
            // Add a value to the current pid/key:
            $cache[$mpid][$mkey][] = $mval;
        }
    }
    foreach ($ids as $id) {
        if (!isset($cache[$id])) {
            $cache[$id] = array();
        }
        wp_cache_add($id, $cache[$id], $cache_key);
    }
    return $cache;
}
Ejemplo n.º 15
0
 /**
  * Saves simple fields data when post is being saved
  */
 function save_postdata($post_id = null, $post = null)
 {
     // verify this came from the our screen and with proper authorization,
     // because save_post can be triggered at other times
     // so not checking nonce can lead to errors, for example losing post connector
     if (!isset($_POST['simple_fields_nonce']) || !wp_verify_nonce($_POST['simple_fields_nonce'], plugin_basename(__FILE__))) {
         return $post_id;
     }
     // verify if this is an auto save routine. If it is our form has not been submitted, so we dont want to do anything
     if (defined('DOING_AUTOSAVE') && DOING_AUTOSAVE) {
         return $post_id;
     }
     // why dont' we want to save revisions? i'll do that from now on, let's se what happens
     // dont's save if is revision
     // preview is a revison? should save then so preview with fields work
     // if (wp_is_post_revision($post_id) !== FALSE) return $post_id;
     // attach post connector
     // only save if being found in post variable, beacuse it may not exist if meta box is hidden/not outputted on page
     if (isset($_POST["simple_fields_selected_connector"])) {
         $simple_fields_selected_connector = isset($_POST["simple_fields_selected_connector"]) ? $_POST["simple_fields_selected_connector"] : null;
         update_post_meta($post_id, "_simple_fields_selected_connector", $simple_fields_selected_connector);
     }
     $post_id = (int) $post_id;
     $fieldgroups = isset($_POST["simple_fields_fieldgroups"]) ? $_POST["simple_fields_fieldgroups"] : null;
     $field_groups_option = $this->get_field_groups();
     if (!($table = _get_meta_table("post"))) {
         return false;
     }
     global $wpdb;
     // We have a post_id and we have fieldgroups
     if ($post_id && is_array($fieldgroups)) {
         // Delete all exisiting custom fields meta that are not part of the keep-list
         $post_meta = get_post_custom($post_id);
         // new format.. can be anything... how to get it?
         $arr_meta_keys_to_keep = array("_simple_fields_been_saved", "_simple_fields_selected_connector");
         foreach ($post_meta as $meta_key => $meta_val) {
             if (strpos($meta_key, "_simple_fields_") === 0) {
                 // this is a meta for simple fields, check if it should be kept or deleted
                 if (!in_array($meta_key, $arr_meta_keys_to_keep)) {
                     delete_post_meta($post_id, $meta_key);
                 }
             }
         }
         // cleanup missing keys, due to checkboxes not being checked
         $fieldgroups_fixed = $fieldgroups;
         foreach ($fieldgroups as $one_field_group_id => $one_field_group_fields) {
             foreach ($one_field_group_fields as $posted_id => $posted_vals) {
                 if ($posted_id == "added") {
                     continue;
                 }
                 $fieldgroups_fixed[$one_field_group_id][$posted_id] = array();
                 // loopa igenom "added"-värdena och fixa så att allt finns
                 foreach ($one_field_group_fields["added"] as $added_id => $added_val) {
                     $fieldgroups_fixed[$one_field_group_id][$posted_id][$added_id] = @$fieldgroups[$one_field_group_id][$posted_id][$added_id];
                 }
             }
         }
         $fieldgroups = $fieldgroups_fixed;
         // Save info about the fact that this post have been saved. This info is used to determine if a post should get default values or not.
         update_post_meta($post_id, "_simple_fields_been_saved", "1");
         // Loop through each fieldgroups
         #sf_d($fieldgroups, '$fieldgroups');
         foreach ($fieldgroups as $one_field_group_id => $one_field_group_fields) {
             // Loop through each field in each field group
             #simple_fields::debug("one_field_group_fields", $one_field_group_fields);
             #sf_d($one_field_group_fields);
             // Get info about the field group that are saved
             // (We only get ID:s posted, so no meta info about the group)
             $arr_fieldgroup_info = $this->get_field_group($one_field_group_id);
             foreach ($one_field_group_fields as $one_field_id => $one_field_values) {
                 // one_field_id = id på fältet vi sparar. t.ex. id:et på "måndag" eller "tisdag"
                 // one_field_values = sparade värden för detta fält, sorterat i den ordning som syns i admin
                 //					  dvs. nyaste överst (med key "new0"), och sedan key 0, key 1, osv.
                 #simple_fields::debug("save, loop fields, one_field_id", $one_field_id);
                 #simple_fields::debug("save, loop fields, one_field_values", $one_field_values);
                 // determine type of field we are saving
                 $field_info = isset($field_groups_option[$one_field_group_id]["fields"][$one_field_id]) ? $field_groups_option[$one_field_group_id]["fields"][$one_field_id] : NULL;
                 $field_type = $field_info["type"];
                 // @todo: this should be a function
                 #simple_fields::debug("save, field_type", $field_type);
                 $do_wpautop = false;
                 if ($field_type == "textarea" && isset($field_info["type_textarea_options"]["use_html_editor"]) && $field_info["type_textarea_options"]["use_html_editor"] == 1) {
                     // it's a tiny edit area, so use wpautop to fix p and br
                     $do_wpautop = true;
                 }
                 $do_wpautop = apply_filters("simple_fields_save_postdata_do_wpautop", $do_wpautop, $post_id);
                 // save entered value for each added group
                 $num_in_set = 0;
                 foreach ($one_field_values as $one_field_value) {
                     // $one_field_id may be "added" because it's... a special kind of input field
                     $arr_field_info = array();
                     $one_field_slug = "";
                     if ("added" === $one_field_id) {
                         $one_field_slug = "added";
                     } else {
                         #sf_d($arr_fieldgroup_info["fields"], 'fields');
                         foreach ($arr_fieldgroup_info["fields"] as $one_field_in_fieldgroup) {
                             if (intval($one_field_in_fieldgroup["id"]) === intval($one_field_id)) {
                                 $arr_field_info = $one_field_in_fieldgroup;
                                 break;
                             }
                         }
                         $one_field_slug = $arr_field_info["slug"];
                         #sf_d($one_field_slug, 'one_field_slug');
                         #sf_d($one_field_id, 'one_field_id');
                         #exit;
                     }
                     $custom_field_key = $this->get_meta_key($one_field_group_id, $one_field_id, $num_in_set, $arr_fieldgroup_info["slug"], $one_field_slug);
                     $custom_field_value = $one_field_value;
                     /*sf_d($custom_field_key, '$custom_field_key');
                     sf_d($one_field_group_id, '$one_field_group_id');
                     sf_d($one_field_id, '$one_field_id');
                     sf_d($num_in_set, 'num_in_set');
                     sf_d($arr_fieldgroup_info["slug"], 'arr_fieldgroup_info["slug"]');
                     sf_d($one_field_slug, 'one_field_slug');*/
                     if (array_key_exists($field_type, $this->registered_field_types)) {
                         // Custom field type
                         $custom_field_value = $this->registered_field_types[$field_type]->edit_save($custom_field_value);
                         /*
                         
                         Date field:
                         Array
                         (
                         	[date_unixtime] => 1351983600000
                         )
                         
                         Map field:
                         Array
                         (
                         	[lat] => 59.312089
                         	[lng] => 18.074117
                         	[name] => Monki Skrapan
                         	[formatted_address] => Götgatan 78, Stockholm, Sverige
                         	[address_components] => [{\"long_name\":\"78\",\"short_name\":\"78\",\"types\":[\"street_number\"]},{\"long_name\":\"Götgatan\",\"short_name\":\"Götgatan\",\"types\":[\"route\"]},{\"long_name\":\"Södermalm\",\"short_name\":\"Södermalm\",\"types\":[\"sublocality\",\"political\"]},{\"long_name\":\"Stockholm\",\"short_name\":\"Stockholm\",\"types\":[\"locality\",\"political\"]},{\"long_name\":\"Stockholms län\",\"short_name\":\"Stockholms län\",\"types\":[\"administrative_area_level_2\",\"political\"]},{\"long_name\":\"SE\",\"short_name\":\"SE\",\"types\":[\"country\",\"political\"]},{\"long_name\":\"11830\",\"short_name\":\"11830\",\"types\":[\"postal_code\"]}]
                         )
                         */
                         //echo "xxx save value for custom field type"; sf_d($custom_field_value);
                     } else {
                         // core/legacy field type
                         if ($do_wpautop) {
                             $custom_field_value = wpautop($custom_field_value);
                         }
                     }
                     // echo "<br>Saving value for post with id $post_id. Custom_field_key is $custom_field_key, custom_field_value is:";sf_d($custom_field_value);
                     update_post_meta($post_id, $custom_field_key, $custom_field_value);
                     $num_in_set++;
                 }
             }
         }
         // if array
     } else {
         if (empty($fieldgroups)) {
             // if fieldgroups are empty we still need to save it
             // remove existing simple fields custom fields for this post
             // @todo: this should also be using wordpress own functions
             // TODO: use new meta keys names
             $wpdb->query("DELETE FROM {$table} WHERE post_id = {$post_id} AND meta_key LIKE '_simple_fields_fieldGroupID_%'");
         }
     }
     // echo "end save";
 }
Ejemplo n.º 16
0
 /**
  * Generates SQL clauses to be appended to a main query.
  *
  * @since 3.2.0
  * @access public
  *
  * @param string $type Type of meta
  * @param string $primary_table
  * @param string $primary_id_column
  * @param object $context (optional) The main query object
  * @return array( 'join' => $join_sql, 'where' => $where_sql )
  */
 function get_sql($type, $primary_table, $primary_id_column, $context = null)
 {
     global $wpdb;
     if (!($meta_table = _get_meta_table($type))) {
         return false;
     }
     $meta_id_column = sanitize_key($type . '_id');
     $join = array();
     $where = array();
     $key_only_queries = array();
     $queries = array();
     // Split out the queries with empty arrays as value
     foreach ($this->queries as $k => $q) {
         if (isset($q['value']) && is_array($q['value']) && empty($q['value'])) {
             $key_only_queries[$k] = $q;
             unset($this->queries[$k]);
         }
     }
     // Split out the meta_key only queries (we can only do this for OR)
     if ('OR' == $this->relation) {
         foreach ($this->queries as $k => $q) {
             if (!isset($q['value']) && !empty($q['key'])) {
                 $key_only_queries[$k] = $q;
             } else {
                 $queries[$k] = $q;
             }
         }
     } else {
         $queries = $this->queries;
     }
     // Specify all the meta_key only queries in one go
     if ($key_only_queries) {
         $join[] = "INNER JOIN {$meta_table} ON {$primary_table}.{$primary_id_column} = {$meta_table}.{$meta_id_column}";
         foreach ($key_only_queries as $key => $q) {
             $where["key-only-{$key}"] = $wpdb->prepare("{$meta_table}.meta_key = %s", trim($q['key']));
         }
     }
     foreach ($queries as $k => $q) {
         $meta_key = isset($q['key']) ? trim($q['key']) : '';
         $meta_type = isset($q['type']) ? strtoupper($q['type']) : 'CHAR';
         if ('NUMERIC' == $meta_type) {
             $meta_type = 'SIGNED';
         } elseif (!in_array($meta_type, array('BINARY', 'CHAR', 'DATE', 'DATETIME', 'DECIMAL', 'SIGNED', 'TIME', 'UNSIGNED'))) {
             $meta_type = 'CHAR';
         }
         $meta_value = isset($q['value']) ? $q['value'] : null;
         if (isset($q['compare'])) {
             $meta_compare = strtoupper($q['compare']);
         } else {
             $meta_compare = is_array($meta_value) ? 'IN' : '=';
         }
         if (!in_array($meta_compare, array('=', '!=', '>', '>=', '<', '<=', 'LIKE', 'NOT LIKE', 'IN', 'NOT IN', 'BETWEEN', 'NOT BETWEEN', 'NOT EXISTS'))) {
             $meta_compare = '=';
         }
         $i = count($join);
         $alias = $i ? 'mt' . $i : $meta_table;
         if ('NOT EXISTS' == $meta_compare) {
             $join[$i] = "LEFT JOIN {$meta_table}";
             $join[$i] .= $i ? " AS {$alias}" : '';
             $join[$i] .= " ON ({$primary_table}.{$primary_id_column} = {$alias}.{$meta_id_column} AND {$alias}.meta_key = '{$meta_key}')";
             $where[$k] = ' ' . $alias . '.' . $meta_id_column . ' IS NULL';
             continue;
         }
         $join[$i] = "INNER JOIN {$meta_table}";
         $join[$i] .= $i ? " AS {$alias}" : '';
         $join[$i] .= " ON ({$primary_table}.{$primary_id_column} = {$alias}.{$meta_id_column})";
         $where[$k] = '';
         if (!empty($meta_key)) {
             $where[$k] = $wpdb->prepare("{$alias}.meta_key = %s", $meta_key);
         }
         if (is_null($meta_value)) {
             if (empty($where[$k])) {
                 unset($join[$i]);
             }
             continue;
         }
         if (in_array($meta_compare, array('IN', 'NOT IN', 'BETWEEN', 'NOT BETWEEN'))) {
             if (!is_array($meta_value)) {
                 $meta_value = preg_split('/[,\\s]+/', $meta_value);
             }
             if (empty($meta_value)) {
                 unset($join[$i]);
                 continue;
             }
         } else {
             $meta_value = trim($meta_value);
         }
         if ('IN' == substr($meta_compare, -2)) {
             $meta_compare_string = '(' . substr(str_repeat(',%s', count($meta_value)), 1) . ')';
         } elseif ('BETWEEN' == substr($meta_compare, -7)) {
             $meta_value = array_slice($meta_value, 0, 2);
             $meta_compare_string = '%s AND %s';
         } elseif ('LIKE' == substr($meta_compare, -4)) {
             $meta_value = '%' . like_escape($meta_value) . '%';
             $meta_compare_string = '%s';
         } else {
             $meta_compare_string = '%s';
         }
         if (!empty($where[$k])) {
             $where[$k] .= ' AND ';
         }
         $where[$k] = ' (' . $where[$k] . $wpdb->prepare("CAST({$alias}.meta_value AS {$meta_type}) {$meta_compare} {$meta_compare_string})", $meta_value);
     }
     $where = array_filter($where);
     if (empty($where)) {
         $where = '';
     } else {
         $where = ' AND (' . implode("\n{$this->relation} ", $where) . ' )';
     }
     $join = implode("\n", $join);
     if (!empty($join)) {
         $join = ' ' . $join;
     }
     return apply_filters_ref_array('get_meta_sql', array(compact('join', 'where'), $this->queries, $type, $primary_table, $primary_id_column, $context));
 }
Ejemplo n.º 17
0
 /**
  * Generates SQL clauses to be appended to a main query.
  *
  * @since 3.2.0
  * @access public
  *
  * @param string $type Type of meta
  * @param string $primary_table
  * @param string $primary_id_column
  * @param object $context (optional) The main query object
  * @return array( 'join' => $join_sql, 'where' => $where_sql )
  */
 public function get_sql($type, $primary_table, $primary_id_column, $context = null)
 {
     global $wpdb;
     if (!($meta_table = _get_meta_table($type))) {
         return false;
     }
     $meta_id_column = sanitize_key($type . '_id');
     $join = array();
     $where = array();
     $key_only_queries = array();
     $queries = array();
     // Split out the queries with empty arrays as value
     foreach ($this->queries as $k => $q) {
         if (isset($q['value']) && is_array($q['value']) && empty($q['value'])) {
             $key_only_queries[$k] = $q;
             unset($this->queries[$k]);
         }
     }
     // Split out the meta_key only queries (we can only do this for OR)
     if ('OR' == $this->relation) {
         foreach ($this->queries as $k => $q) {
             if ((empty($q['compare']) || 'NOT EXISTS' != $q['compare']) && !array_key_exists('value', $q) && !empty($q['key'])) {
                 $key_only_queries[$k] = $q;
             } else {
                 $queries[$k] = $q;
             }
         }
     } else {
         $queries = $this->queries;
     }
     // Specify all the meta_key only queries in one go
     if ($key_only_queries) {
         $join[] = "INNER JOIN {$meta_table} ON {$primary_table}.{$primary_id_column} = {$meta_table}.{$meta_id_column}";
         foreach ($key_only_queries as $key => $q) {
             $where["key-only-{$key}"] = $wpdb->prepare("{$meta_table}.meta_key = %s", trim($q['key']));
         }
     }
     foreach ($queries as $k => $q) {
         $meta_key = isset($q['key']) ? trim($q['key']) : '';
         $meta_type = $this->get_cast_for_type(isset($q['type']) ? $q['type'] : '');
         if (array_key_exists('value', $q) && is_null($q['value'])) {
             $q['value'] = '';
         }
         $meta_value = isset($q['value']) ? $q['value'] : null;
         if (isset($q['compare'])) {
             $meta_compare = strtoupper($q['compare']);
         } else {
             $meta_compare = is_array($meta_value) ? 'IN' : '=';
         }
         if (!in_array($meta_compare, array('=', '!=', '>', '>=', '<', '<=', 'LIKE', 'NOT LIKE', 'IN', 'NOT IN', 'BETWEEN', 'NOT BETWEEN', 'NOT EXISTS', 'REGEXP', 'NOT REGEXP', 'RLIKE'))) {
             $meta_compare = '=';
         }
         $i = count($join);
         $alias = $i ? 'mt' . $i : $meta_table;
         if ('NOT EXISTS' == $meta_compare) {
             $join[$i] = "LEFT JOIN {$meta_table}";
             $join[$i] .= $i ? " AS {$alias}" : '';
             $join[$i] .= " ON ({$primary_table}.{$primary_id_column} = {$alias}.{$meta_id_column} AND {$alias}.meta_key = '{$meta_key}')";
             $where[$k] = ' ' . $alias . '.' . $meta_id_column . ' IS NULL';
             continue;
         }
         $join[$i] = "INNER JOIN {$meta_table}";
         $join[$i] .= $i ? " AS {$alias}" : '';
         $join[$i] .= " ON ({$primary_table}.{$primary_id_column} = {$alias}.{$meta_id_column})";
         $where[$k] = '';
         if (!empty($meta_key)) {
             $where[$k] = $wpdb->prepare("{$alias}.meta_key = %s", $meta_key);
         }
         if (is_null($meta_value)) {
             if (empty($where[$k])) {
                 unset($join[$i]);
             }
             continue;
         }
         if (in_array($meta_compare, array('IN', 'NOT IN', 'BETWEEN', 'NOT BETWEEN'))) {
             if (!is_array($meta_value)) {
                 $meta_value = preg_split('/[,\\s]+/', $meta_value);
             }
             if (empty($meta_value)) {
                 unset($join[$i]);
                 continue;
             }
         } else {
             $meta_value = trim($meta_value);
         }
         if ('IN' == substr($meta_compare, -2)) {
             $meta_compare_string = '(' . substr(str_repeat(',%s', count($meta_value)), 1) . ')';
         } elseif ('BETWEEN' == substr($meta_compare, -7)) {
             $meta_value = array_slice($meta_value, 0, 2);
             $meta_compare_string = '%s AND %s';
         } elseif ('LIKE' == $meta_compare || 'NOT LIKE' == $meta_compare) {
             $meta_value = '%' . $wpdb->esc_like($meta_value) . '%';
             $meta_compare_string = '%s';
         } else {
             $meta_compare_string = '%s';
         }
         if (!empty($where[$k])) {
             $where[$k] .= ' AND ';
         }
         $where[$k] = ' (' . $where[$k] . $wpdb->prepare("CAST({$alias}.meta_value AS {$meta_type}) {$meta_compare} {$meta_compare_string})", $meta_value);
     }
     $where = array_filter($where);
     if (empty($where)) {
         $where = '';
     } else {
         $where = ' AND (' . implode("\n{$this->relation} ", $where) . ' )';
     }
     $join = implode("\n", $join);
     if (!empty($join)) {
         $join = ' ' . $join;
     }
     /**
      * Filter the meta query's generated SQL.
      *
      * @since 3.1.0
      *
      * @param array $args {
      *     An array of arguments.
      *
      *     @type array  $clauses           Array containing the query's JOIN and WHERE clauses.
      *     @type array  $queries           Array of meta queries.
      *     @type string $type              Type of meta.
      *     @type string $primary_table     Primary table.
      *     @type string $primary_id_column Primary column ID.
      *     @type object $context           The main query object.
      * }
      */
     return apply_filters_ref_array('get_meta_sql', array(compact('join', 'where'), $this->queries, $type, $primary_table, $primary_id_column, $context));
 }
 /**
  * Evaluate custom field mapping data source
  *
  * @since 2.20
  *
  * @param	integer	post->ID of attachment
  * @param	string 	category/scope to evaluate against: custom_field_mapping or single_attachment_mapping
  * @param	array	data source specification ( name, *data_source, *keep_existing, *format, mla_column, quick_edit, bulk_edit, *meta_name, *option, no_null )
  * @param	array 	(optional) _wp_attachment_metadata, default NULL (use current postmeta database value)
  *
  * @return	string|array	data source value
  */
 private static function _evaluate_data_source($post_id, $category, $data_value, $attachment_metadata = NULL)
 {
     global $wpdb;
     static $upload_dir, $intermediate_sizes = NULL, $wp_attached_files = NULL, $wp_attachment_metadata = NULL;
     static $current_id = 0, $file_info = NULL, $parent_info = NULL, $references = NULL, $alt_text = NULL;
     if ('none' == $data_value['data_source']) {
         return '';
     }
     $data_source = $data_value['data_source'];
     /*
      * Do this once per page load; cache attachment metadata if mapping all attachments
      */
     if (NULL == $intermediate_sizes) {
         $upload_dir = wp_upload_dir();
         $upload_dir = $upload_dir['basedir'] . '/';
         $intermediate_sizes = get_intermediate_image_sizes();
         if ('custom_field_mapping' == $category) {
             if (!($table = _get_meta_table('post'))) {
                 $wp_attached_files = array();
                 $wp_attachment_metadata = array();
             } else {
                 $wp_attachment_metadata = $wpdb->get_results("SELECT post_id, meta_value FROM {$table} WHERE meta_key = '_wp_attachment_metadata'", OBJECT_K);
                 $wp_attached_files = $wpdb->get_results("SELECT post_id, meta_value FROM {$table} WHERE meta_key = '_wp_attached_file'", OBJECT_K);
             }
         }
         // custom_field_mapping, i.e., mapping all attachments
     }
     // first call after page load
     /*
      * Do this once per post. Simulate SQL results for $wp_attached_files and $wp_attachment_metadata.
      */
     if ($current_id != $post_id) {
         $current_id = $post_id;
         $parent_info = NULL;
         $references = NULL;
         $alt_text = NULL;
         if ('single_attachment_mapping' == $category) {
             $metadata = get_metadata('post', $post_id, '_wp_attached_file');
             if (isset($metadata[0])) {
                 $wp_attached_files = array($post_id => (object) array('post_id' => $post_id, 'meta_value' => $metadata[0]));
             } else {
                 $wp_attached_files = array();
             }
             if (NULL == $attachment_metadata) {
                 $metadata = get_metadata('post', $post_id, '_wp_attachment_metadata');
                 if (isset($metadata[0])) {
                     $attachment_metadata = $metadata[0];
                 }
             }
             if (empty($attachment_metadata)) {
                 $attachment_metadata = array();
             }
             $wp_attachment_metadata = array($post_id => (object) array('post_id' => $post_id, 'meta_value' => serialize($attachment_metadata)));
         }
         $file_info = MLAData_Source::_evaluate_file_information($upload_dir, $wp_attached_files, $wp_attachment_metadata, $post_id);
     }
     $size_info = array('file' => '', 'width' => '', 'height' => '');
     $match_count = preg_match('/(.+)\\[(.+)\\]/', $data_source, $matches);
     if (1 == $match_count) {
         $data_source = $matches[1] . '[size]';
         if (isset($file_info['sizes'][$matches[2]])) {
             $size_info = $file_info['sizes'][$matches[2]];
         }
     }
     $result = '';
     switch ($data_source) {
         case 'meta':
             $attachment_metadata = isset($wp_attachment_metadata[$post_id]->meta_value) ? maybe_unserialize($wp_attachment_metadata[$post_id]->meta_value) : array();
             $result = MLAData::mla_find_array_element($data_value['meta_name'], $attachment_metadata, $data_value['option'], $data_value['keep_existing']);
             break;
         case 'template':
             if (in_array($data_value['option'], array('single', 'export', 'array', 'multi'))) {
                 $default_option = 'array';
             } else {
                 $default_option = 'text';
             }
             /*
              * Go through the template and expand the non-prefixed elements
              * as Data Sources
              */
             $item_values = array();
             $placeholders = MLAData::mla_get_template_placeholders($data_value['meta_name'], $default_option);
             foreach ($placeholders as $key => $placeholder) {
                 if (empty($placeholder['prefix'])) {
                     $field_value = $data_value;
                     $field_value['data_source'] = $placeholder['value'];
                     $field_value['meta_name'] = '';
                     $field_value['option'] = $placeholder['option'];
                     $field_value['format'] = $placeholder['format'];
                     if (isset($placeholder['args'])) {
                         $field_value['args'] = $placeholder['args'];
                     }
                     $field_value = MLAData_Source::_evaluate_data_source($post_id, $category, $field_value, $attachment_metadata);
                     $item_values[$key] = MLAData::mla_apply_field_level_format($field_value, $placeholder);
                 }
                 // Data Source
             }
             // foreach placeholder
             /*
              * Now expand the template using the above Data Source values
              */
             $template = '[+template:' . $data_value['meta_name'] . '+]';
             $item_values = MLAData::mla_expand_field_level_parameters($template, NULL, $item_values, $post_id, $data_value['keep_existing'], $default_option);
             if ('array' == $default_option) {
                 $result = MLAData::mla_parse_array_template($template, $item_values);
                 $result = MLAData_Source::_evaluate_array_result($result, $data_value['option'], $data_value['keep_existing']);
             } else {
                 $result = MLAData::mla_parse_template($template, $item_values);
             }
             break;
         case 'parent':
             $data_source = 'post_parent';
             /* fallthru */
         /* fallthru */
         case 'ID':
         case 'post_id':
         case 'post_author':
         case 'post_parent':
         case 'menu_order':
         case 'comment_count':
             $result = absint(MLAData_Source::_evaluate_post_information($post_id, $category, $data_source));
             break;
         case 'alt_text':
             if (NULL == $alt_text) {
                 $metadata = get_metadata('post', $post_id, '_wp_attachment_image_alt');
                 if (is_array($metadata)) {
                     if (count($metadata) == 1) {
                         $alt_text = maybe_unserialize($metadata[0]);
                     } else {
                         $alt_text = array();
                         foreach ($metadata as $single_key => $single_value) {
                             $alt_text[$single_key] = maybe_unserialize($single_value);
                         }
                     }
                 }
             }
             if (!empty($alt_text)) {
                 $result = MLAData_Source::_evaluate_array_result($alt_text, $data_value['option'], $data_value['keep_existing']);
             }
             break;
         case 'mime_type':
             $data_source = 'post_mime_type';
             /* fallthru */
         /* fallthru */
         case 'post_date':
         case 'post_date_gmt':
         case 'post_content':
         case 'post_title':
         case 'post_excerpt':
         case 'post_status':
         case 'comment_status':
         case 'ping_status':
         case 'post_name':
         case 'post_modified':
         case 'post_modified_gmt':
         case 'post_content_filtered':
         case 'guid':
         case 'post_mime_type':
             $result = MLAData_Source::_evaluate_post_information($post_id, $category, $data_source);
             break;
         case 'absolute_path':
         case 'absolute_file_name':
         case 'base_file':
         case 'path':
         case 'file_name':
         case 'name_only':
         case 'extension':
         case 'width':
         case 'height':
         case 'orientation':
         case 'hwstring_small':
         case 'aperture':
         case 'credit':
         case 'camera':
         case 'caption':
         case 'created_timestamp':
         case 'copyright':
         case 'focal_length':
         case 'iso':
         case 'shutter_speed':
         case 'title':
             if (isset($file_info[$data_source])) {
                 $result = $file_info[$data_source];
             }
             break;
         case 'file_size':
             $filesize = @filesize($file_info['absolute_file_name_raw']);
             if (!(false === $filesize)) {
                 $result = $filesize;
             }
             break;
         case 'upload_date':
             $result = MLAData_Source::_evaluate_post_information($post_id, $category, 'post_date');
             break;
         case 'dimensions':
             $result = $file_info['width'] . 'x' . $file_info['height'];
             if ('x' == $result) {
                 $result = '';
             }
             break;
         case 'pixels':
             $result = absint((int) $file_info['width'] * (int) $file_info['height']);
             if (0 == $result) {
                 $result = '';
             } else {
                 $result = (string) $result;
             }
             break;
         case 'size_keys':
             $result = array();
             foreach ($file_info['sizes'] as $key => $value) {
                 $result[] = $key;
             }
             $result = MLAData_Source::_evaluate_array_result($result, $data_value['option'], $data_value['keep_existing']);
             break;
         case 'size_names':
             $result = array();
             foreach ($file_info['sizes'] as $key => $value) {
                 $result[] = $value['file'];
             }
             $result = MLAData_Source::_evaluate_array_result($result, $data_value['option'], $data_value['keep_existing']);
             break;
         case 'size_bytes':
             $result = array();
             foreach ($file_info['sizes'] as $key => $value) {
                 $filesize = @filesize($file_info['absolute_path_raw'] . $value['file']);
                 if (false === $filesize) {
                     $result[] = '?';
                 } else {
                     switch ($data_value['format']) {
                         case 'commas':
                             if (is_numeric($filesize)) {
                                 $filesize = number_format((double) $filesize);
                             }
                             break;
                         default:
                             // no change
                     }
                     // format
                     $result[] = $filesize;
                 }
             }
             $result = MLAData_Source::_evaluate_array_result($result, $data_value['option'], $data_value['keep_existing']);
             break;
         case 'size_pixels':
             $result = array();
             foreach ($file_info['sizes'] as $key => $value) {
                 $pixels = absint((int) $value['width'] * (int) $value['height']);
                 switch ($data_value['format']) {
                     case 'commas':
                         if (is_numeric($pixels)) {
                             $pixels = number_format((double) $pixels);
                         }
                         break;
                     default:
                         // no change
                 }
                 // format
                 $result[] = $pixels;
             }
             $result = MLAData_Source::_evaluate_array_result($result, $data_value['option'], $data_value['keep_existing']);
             break;
         case 'size_dimensions':
             $result = array();
             foreach ($file_info['sizes'] as $key => $value) {
                 $result[] = $value['width'] . 'x' . $value['height'];
             }
             $result = MLAData_Source::_evaluate_array_result($result, $data_value['option'], $data_value['keep_existing']);
             break;
         case 'size_name[size]':
             $result = $size_info['file'];
             break;
         case 'size_bytes[size]':
             $result = @filesize($file_info['absolute_path_raw'] . $size_info['file']);
             if (false === $result) {
                 $result = '?';
             }
             break;
         case 'size_pixels[size]':
             $result = absint((int) $size_info['width'] * (int) $size_info['height']);
             break;
         case 'size_dimensions[size]':
             $result = $size_info['width'] . 'x' . $size_info['height'];
             if ('x' == $result) {
                 $result = '';
             }
             break;
         case 'parent_date':
         case 'parent_type':
         case 'parent_title':
             if (is_null($parent_info)) {
                 $parent_info = MLAQuery::mla_fetch_attachment_parent_data(MLAData_Source::_evaluate_post_information($post_id, $category, 'post_parent'));
             }
             if (isset($parent_info[$data_source])) {
                 $result = $parent_info[$data_source];
             }
             break;
         case 'parent_issues':
             if (is_null($references)) {
                 $references = MLAQuery::mla_fetch_attachment_references($post_id, MLAData_Source::_evaluate_post_information($post_id, $category, 'post_parent'));
             }
             if (!empty($references['parent_errors'])) {
                 $result = $references['parent_errors'];
                 /*
                  * Remove (ORPHAN...
                  */
                 $orphan_certain = '(' . __('ORPHAN', 'media-library-assistant') . ')';
                 $orphan_possible = '(' . __('ORPHAN', 'media-library-assistant') . '?)';
                 if (false !== strpos($result, $orphan_certain)) {
                     $result = trim(substr($result, strlen($orphan_certain)));
                 } elseif (false !== strpos($result, $orphan_possible)) {
                     $result = trim(substr($result, strlen($orphan_possible)));
                 }
             }
             break;
         case 'reference_issues':
             if (is_null($references)) {
                 $references = MLAQuery::mla_fetch_attachment_references($post_id, MLAData_Source::_evaluate_post_information($post_id, $category, 'post_parent'));
             }
             if (!empty($references['parent_errors'])) {
                 $result = $references['parent_errors'];
             }
             break;
         case 'featured_in':
         case 'featured_in_title':
             if (is_null($references)) {
                 $references = MLAQuery::mla_fetch_attachment_references($post_id, MLAData_Source::_evaluate_post_information($post_id, $category, 'post_parent'));
             }
             if (!empty($references['features'])) {
                 $result = array();
                 foreach ($references['features'] as $ID => $value) {
                     if ('featured_in' == $data_source) {
                         $result[] = sprintf('%1$s (%2$s %3$d)', $value->post_title, $value->post_type, $ID);
                     } else {
                         $result[] = $value->post_title;
                     }
                 }
                 $result = MLAData_Source::_evaluate_array_result($result, $data_value['option'], $data_value['keep_existing']);
             } else {
                 $result = '';
             }
             break;
         case 'inserted_in':
         case 'inserted_in_title':
             if (is_null($references)) {
                 $references = MLAQuery::mla_fetch_attachment_references($post_id, MLAData_Source::_evaluate_post_information($post_id, $category, 'post_parent'));
             }
             if (!empty($references['inserts'])) {
                 $result = array();
                 foreach ($references['inserts'] as $base_file => $inserts) {
                     foreach ($inserts as $value) {
                         if ('inserted_in' == $data_source) {
                             $result[] = sprintf('%1$s (%2$s %3$d)', $value->post_title, $value->post_type, $value->ID);
                         } else {
                             $result[] = $value->post_title;
                         }
                     }
                 }
                 ksort($result);
                 $result = MLAData_Source::_evaluate_array_result($result, $data_value['option'], $data_value['keep_existing']);
             } else {
                 $result = '';
             }
             break;
         case 'gallery_in':
         case 'gallery_in_title':
             if (is_null($references)) {
                 $references = MLAQuery::mla_fetch_attachment_references($post_id, MLAData_Source::_evaluate_post_information($post_id, $category, 'post_parent'));
             }
             if (!empty($references['galleries'])) {
                 $result = array();
                 foreach ($references['galleries'] as $ID => $value) {
                     if ('gallery_in' == $data_source) {
                         $result[] = sprintf('%1$s (%2$s %3$d)', $value['post_title'], $value['post_type'], $ID);
                     } else {
                         $result[] = $value['post_title'];
                     }
                 }
                 $result = MLAData_Source::_evaluate_array_result($result, $data_value['option'], $data_value['keep_existing']);
             } else {
                 $result = '';
             }
             break;
         case 'mla_gallery_in':
         case 'mla_gallery_in_title':
             if (is_null($references)) {
                 $references = MLAQuery::mla_fetch_attachment_references($post_id, MLAData_Source::_evaluate_post_information($post_id, $category, 'post_parent'));
             }
             if (!empty($references['mla_galleries'])) {
                 $result = array();
                 foreach ($references['mla_galleries'] as $ID => $value) {
                     if ('mla_gallery_in' == $data_source) {
                         $result[] = sprintf('%1$s (%2$s %3$d)', $value['post_title'], $value['post_type'], $ID);
                     } else {
                         $result[] = $value['post_title'];
                     }
                 }
                 $result = MLAData_Source::_evaluate_array_result($result, $data_value['option'], $data_value['keep_existing']);
             } else {
                 $result = '';
             }
             break;
         default:
             $custom_value = apply_filters('mla_evaluate_custom_data_source', NULL, $post_id, $category, $data_value, $attachment_metadata);
             if (!is_null($custom_value)) {
                 return $custom_value;
             }
             return '';
     }
     // switch $data_source
     switch ($data_value['format']) {
         case 'raw':
             return $result;
         case 'commas':
             if (is_numeric($result)) {
                 $result = str_pad(number_format((double) $result), 15, ' ', STR_PAD_LEFT);
             }
             break;
         case 'native':
         default:
             /*
              * Make some numeric values sortable as strings, make all value non-empty
              */
             if (in_array($data_source, array('file_size', 'pixels', 'width', 'height'))) {
                 $result = str_pad($result, 15, ' ', STR_PAD_LEFT);
             } elseif (empty($result)) {
                 $result = ' ';
             }
     }
     // format
     return $result;
 }
Ejemplo n.º 19
0
 /**
  * Generates SQL clauses to be appended to a main query.
  *
  * @since 3.2.0
  * @access public
  *
  * @param string $type Type of meta
  * @param string $primary_table
  * @param string $primary_id_column
  * @param object $context (optional) The main query object
  * @return array( 'join' => $join_sql, 'where' => $where_sql )
  */
 function get_sql($type, $primary_table, $primary_id_column, $context = null)
 {
     global $wpdb;
     if (!($meta_table = _get_meta_table($type))) {
         return false;
     }
     $meta_id_column = esc_sql($type . '_id');
     $join = array();
     $where = array();
     foreach ($this->queries as $k => $q) {
         $meta_key = isset($q['key']) ? trim($q['key']) : '';
         $meta_compare = isset($q['compare']) ? strtoupper($q['compare']) : '=';
         $meta_type = isset($q['type']) ? strtoupper($q['type']) : 'CHAR';
         if (!in_array($meta_compare, array('=', '!=', '>', '>=', '<', '<=', 'LIKE', 'NOT LIKE', 'IN', 'NOT IN', 'BETWEEN', 'NOT BETWEEN'))) {
             $meta_compare = '=';
         }
         if ('NUMERIC' == $meta_type) {
             $meta_type = 'SIGNED';
         } elseif (!in_array($meta_type, array('BINARY', 'CHAR', 'DATE', 'DATETIME', 'DECIMAL', 'SIGNED', 'TIME', 'UNSIGNED'))) {
             $meta_type = 'CHAR';
         }
         $i = count($join);
         $alias = $i ? 'mt' . $i : $meta_table;
         // Set JOIN
         $join[$i] = "INNER JOIN {$meta_table}";
         $join[$i] .= $i ? " AS {$alias}" : '';
         $join[$i] .= " ON ({$primary_table}.{$primary_id_column} = {$alias}.{$meta_id_column})";
         $where[$k] = '';
         if (!empty($meta_key)) {
             $where[$k] = $wpdb->prepare("{$alias}.meta_key = %s", $meta_key);
         }
         if (!isset($q['value'])) {
             if (empty($where[$k])) {
                 unset($join[$i]);
             }
             continue;
         }
         $meta_value = $q['value'];
         if (in_array($meta_compare, array('IN', 'NOT IN', 'BETWEEN', 'NOT BETWEEN'))) {
             if (!is_array($meta_value)) {
                 $meta_value = preg_split('/[,\\s]+/', $meta_value);
             }
             if (empty($meta_value)) {
                 unset($join[$i]);
                 continue;
             }
         } else {
             $meta_value = trim($meta_value);
         }
         if ('IN' == substr($meta_compare, -2)) {
             $meta_compare_string = '(' . substr(str_repeat(',%s', count($meta_value)), 1) . ')';
         } elseif ('BETWEEN' == substr($meta_compare, -7)) {
             $meta_value = array_slice($meta_value, 0, 2);
             $meta_compare_string = '%s AND %s';
         } elseif ('LIKE' == substr($meta_compare, -4)) {
             $meta_value = '%' . like_escape($meta_value) . '%';
             $meta_compare_string = '%s';
         } else {
             $meta_compare_string = '%s';
         }
         if (!empty($where[$k])) {
             $where[$k] .= ' AND ';
         }
         $where[$k] = ' (' . $where[$k] . $wpdb->prepare("CAST({$alias}.meta_value AS {$meta_type}) {$meta_compare} {$meta_compare_string})", $meta_value);
     }
     $where = array_filter($where);
     if (empty($where)) {
         $where = '';
     } else {
         $where = ' AND (' . implode("\n{$this->relation} ", $where) . ' )';
     }
     $join = implode("\n", $join);
     if (!empty($join)) {
         $join = ' ' . $join;
     }
     return apply_filters_ref_array('get_meta_sql', array(compact('join', 'where'), $this->queries, $type, $primary_table, $primary_id_column, $context));
 }
 protected function get_metadata($ids, $meta_type, $meta_key_whitelist)
 {
     global $wpdb;
     $table = _get_meta_table($meta_type);
     $id = $meta_type . '_id';
     if (!$table) {
         return array();
     }
     $private_meta_whitelist_sql = "'" . implode("','", array_map('esc_sql', $meta_key_whitelist)) . "'";
     return array_map(array($this, 'unserialize_meta'), $wpdb->get_results("SELECT {$id}, meta_key, meta_value, meta_id FROM {$table} WHERE {$id} IN ( " . implode(',', wp_parse_id_list($ids)) . ' )' . " AND meta_key IN ( {$private_meta_whitelist_sql} ) ", OBJECT));
 }
Ejemplo n.º 21
0
 private function get_meta_sql($name, $meta_query, $type, $primary_table, $primary_id_column)
 {
     $query = get_meta_sql($meta_query, $type, $primary_table, $primary_id_column);
     if (function_exists('_get_meta_table')) {
         $meta_table = _get_meta_table($type);
         $query['join'] = str_replace($meta_table, $name, $query['join']);
         $query['where'] = str_replace($meta_table, $name, $query['where']);
         $query['join'] = str_replace("JOIN {$name} ON", "JOIN {$meta_table} AS {$name} ON", $query['join']);
     }
     return array('join' => $query['join'], 'where' => $this->clean_meta_query_condition($query['where']));
 }
 public function delete_metadata($type, $object_id, $meta_ids)
 {
     global $wpdb;
     $table = _get_meta_table($type);
     if (!$table) {
         return false;
     }
     foreach ($meta_ids as $meta_id) {
         $wpdb->query($wpdb->prepare("DELETE FROM {$table} WHERE meta_id = %d", $meta_id));
     }
     // if we don't have an object ID what do we do - invalidate ALL meta?
     if ($object_id) {
         wp_cache_delete($object_id, $type . '_meta');
     }
 }
Ejemplo n.º 23
0
function hocwp_meta_table_registered($type)
{
    return _get_meta_table($type);
}
Ejemplo n.º 24
0
 function pmwi_update_prices($pid)
 {
     $table = _get_meta_table('post');
     $post_meta_infos = $this->wpdb->get_results("SELECT meta_key, meta_value FROM {$table} WHERE post_id={$pid}");
     foreach ($post_meta_infos as $meta_info) {
         if (in_array($meta_info->meta_key, array('_regular_price_tmp', '_sale_price_tmp', '_sale_price_dates_from_tmp', '_sale_price_dates_from_tmp', '_sale_price_dates_to_tmp', '_price_tmp', '_stock_tmp'))) {
             $this->pushmeta($pid, str_replace('_tmp', '', $meta_info->meta_key), $meta_info->meta_value);
             delete_post_meta($pid, $meta_info->meta_key);
         }
     }
     //$this->executeSQL();
 }
Ejemplo n.º 25
0
function fw_delete_post_meta($post_id, $meta_key, $meta_value = '')
{
    // make sure meta is added to the post, not a revision
    if ($the_post = wp_is_post_revision($post_id)) {
        $post_id = $the_post;
    }
    $meta_type = 'post';
    $object_id = $post_id;
    $delete_all = false;
    if (!$meta_type || !$meta_key) {
        return false;
    }
    if (!($object_id = absint($object_id)) && !$delete_all) {
        return false;
    }
    if (!($table = _get_meta_table($meta_type))) {
        return false;
    }
    global $wpdb;
    $type_column = esc_sql($meta_type . '_id');
    $id_column = 'user' == $meta_type ? 'umeta_id' : 'meta_id';
    // expected_slashed ($meta_key)
    // $meta_key = stripslashes($meta_key); // this was the trouble !
    // $meta_value = stripslashes_deep($meta_value); // this was the trouble !
    $check = apply_filters("delete_{$meta_type}_metadata", null, $object_id, $meta_key, $meta_value, $delete_all);
    if (null !== $check) {
        return (bool) $check;
    }
    $_meta_value = $meta_value;
    $meta_value = maybe_serialize($meta_value);
    $query = $wpdb->prepare("SELECT {$id_column} FROM {$table} WHERE meta_key = %s", $meta_key);
    if (!$delete_all) {
        $query .= $wpdb->prepare(" AND {$type_column} = %d", $object_id);
    }
    if ($meta_value) {
        $query .= $wpdb->prepare(" AND meta_value = %s", $meta_value);
    }
    $meta_ids = $wpdb->get_col($query);
    if (!count($meta_ids)) {
        return false;
    }
    if ($delete_all) {
        $object_ids = $wpdb->get_col($wpdb->prepare("SELECT {$type_column} FROM {$table} WHERE meta_key = %s", $meta_key));
    }
    do_action("delete_{$meta_type}_meta", $meta_ids, $object_id, $meta_key, $_meta_value);
    // Old-style action.
    if ('post' == $meta_type) {
        do_action('delete_postmeta', $meta_ids);
    }
    $query = "DELETE FROM {$table} WHERE {$id_column} IN( " . implode(',', $meta_ids) . " )";
    $count = $wpdb->query($query);
    if (!$count) {
        return false;
    }
    if ($delete_all) {
        foreach ((array) $object_ids as $o_id) {
            wp_cache_delete($o_id, $meta_type . '_meta');
        }
    } else {
        wp_cache_delete($object_id, $meta_type . '_meta');
    }
    do_action("deleted_{$meta_type}_meta", $meta_ids, $object_id, $meta_key, $_meta_value);
    // Old-style action.
    if ('post' == $meta_type) {
        do_action('deleted_postmeta', $meta_ids);
    }
    return true;
}
Ejemplo n.º 26
0
function simple_fields_save_postdata($post_id = null, $post = null)
{
    // verify this came from the our screen and with proper authorization,
    // because save_post can be triggered at other times
    // so not checking nonce can lead to errors, for example losing post connector
    if (!isset($_POST['simple_fields_nonce']) || !wp_verify_nonce($_POST['simple_fields_nonce'], plugin_basename(__FILE__))) {
        return $post_id;
    }
    // verify if this is an auto save routine. If it is our form has not been submitted, so we dont want to do anything
    if (defined('DOING_AUTOSAVE') && DOING_AUTOSAVE) {
        return $post_id;
    }
    // attach post connector
    $simple_fields_selected_connector = isset($_POST["simple_fields_selected_connector"]) ? $_POST["simple_fields_selected_connector"] : null;
    update_post_meta($post_id, "_simple_fields_selected_connector", $simple_fields_selected_connector);
    $post_id = (int) $post_id;
    $fieldgroups = isset($_POST["simple_fields_fieldgroups"]) ? $_POST["simple_fields_fieldgroups"] : null;
    $field_groups_option = get_option("simple_fields_groups");
    if (!($table = _get_meta_table("post"))) {
        return false;
    }
    global $wpdb;
    if ($post_id && is_array($fieldgroups)) {
        // remove existing simple fields custom fields for this post
        $wpdb->query("DELETE FROM {$table} WHERE post_id = {$post_id} AND meta_key LIKE '_simple_fields_fieldGroupID_%'");
        // cleanup missing keys, due to checkboxes not being checked
        $fieldgroups_fixed = $fieldgroups;
        foreach ($fieldgroups as $one_field_group_id => $one_field_group_fields) {
            foreach ($one_field_group_fields as $posted_id => $posted_vals) {
                if ($posted_id == "added") {
                    // echo "<br><br>posted_id: $posted_id";
                    // echo "<br>posted_vals: "; bonny_d($posted_vals);
                    // $fieldgroups_fixed[$one_field_group_id][$posted_id]["added"] = $posted_vals;
                    continue;
                }
                $fieldgroups_fixed[$one_field_group_id][$posted_id] = array();
                // echo "<br><br>posted_id: $posted_id";
                // echo "<br>posted_vals: "; bonny_d($posted_vals);
                // bonny_d($added_vals);
                // loopa igenom "added"-värdena och fixa så att allt finns
                foreach ($one_field_group_fields["added"] as $added_id => $added_val) {
                    // $fieldgroups_fixed
                    // echo "<br>added_id: $added_id";
                    // echo "<br>added_val: $added_val";
                    $fieldgroups_fixed[$one_field_group_id][$posted_id][$added_id] = $fieldgroups[$one_field_group_id][$posted_id][$added_id];
                }
            }
        }
        $fieldgroups = $fieldgroups_fixed;
        update_post_meta($post_id, "_simple_fields_been_saved", "1");
        foreach ($fieldgroups as $one_field_group_id => $one_field_group_fields) {
            foreach ($one_field_group_fields as $one_field_id => $one_field_values) {
                // one_field_id = id på fältet vi sparar. t.ex. id:et på "måndag" eller "tisdag"
                // one_field_values = sparade värden för detta fält, sorterat i den ordning som syns i admin
                //					  dvs. nyaste överst (med key "new0"), och sedan key 0, key 1, osv.
                // determine type of field we are saving
                $field_info = isset($field_groups_option[$one_field_group_id]["fields"][$one_field_id]) ? $field_groups_option[$one_field_group_id]["fields"][$one_field_id] : NULL;
                $field_type = $field_info["type"];
                // @todo: this should be a function
                $do_wpautop = false;
                if ($field_type == "textarea" && isset($field_info["type_textarea_options"]["use_html_editor"]) && $field_info["type_textarea_options"]["use_html_editor"] == 1) {
                    // it's a tiny edit area, so use wpautop to fix p and br
                    $do_wpautop = true;
                }
                // @todo: empty checkboxes = values saved for the wrong fieldgroup
                // it "jumps" past one of the groups when saving, so the wrong group gets the value
                // ide: korrigera arrayen? istället för sparandet
                $num_in_set = 0;
                // save entered value for each added group
                foreach ($one_field_values as $one_field_value) {
                    $custom_field_key = "_simple_fields_fieldGroupID_{$one_field_group_id}_fieldID_{$one_field_id}_numInSet_{$num_in_set}";
                    $custom_field_value = $one_field_value;
                    if ($do_wpautop) {
                        $custom_field_value = wpautop($custom_field_value);
                        #var_dump($custom_field_value);#exit;
                    }
                    update_post_meta($post_id, $custom_field_key, $custom_field_value);
                    $num_in_set++;
                }
            }
        }
        // if array
    } else {
        if (empty($fieldgroups)) {
            // if fieldgroups are empty we still need to save it
            // remove existing simple fields custom fields for this post
            $wpdb->query("DELETE FROM {$table} WHERE post_id = {$post_id} AND meta_key LIKE '_simple_fields_fieldGroupID_%'");
        }
    }
}
Ejemplo n.º 27
0
 /**
  * メタデータを削除
  *
  * @param string $key メタキー
  * @param mixed $value 指定した場合、その値をもつメタデータのみ削除
  * @return bool
  */
 public function delete($key = '', $value = '')
 {
     if (_get_meta_table($this->meta_type)) {
         if ($key) {
             return delete_metadata($this->meta_type, $this->id, $key, $value);
         }
     } else {
         if (!$key) {
             return false;
         }
         $option_name = $this->get_option_name();
         $option = get_option($option_name);
         if (isset($option[$key]) && $value === '') {
             unset($option[$key]);
             return update_option($option_name, $option);
         }
         if (isset($option[$key]) && $value !== '') {
             foreach ($option[$key] as $option_key => $option_value) {
                 if ($option_value === $value) {
                     unset($option[$key][$option_key]);
                 }
             }
             return update_option($option_name, $option);
         }
     }
 }
Ejemplo n.º 28
0
 /**
  * Retrieve custom fields for post.
  *
  * @param int $id Post ID
  * @return (array[]|WP_Error) List of meta object data on success, WP_Error otherwise
  */
 public function get_all_meta($id)
 {
     $id = (int) $id;
     if (empty($id)) {
         return new WP_Error('json_post_invalid_id', __('Invalid post ID.'), array('status' => 404));
     }
     $post = get_post($id, ARRAY_A);
     if (empty($post['ID'])) {
         return new WP_Error('json_post_invalid_id', __('Invalid post ID.'), array('status' => 404));
     }
     if (!$this->check_edit_permission($post)) {
         return new WP_Error('json_cannot_edit', __('Sorry, you cannot edit this post'), array('status' => 403));
     }
     global $wpdb;
     $table = _get_meta_table('post');
     $results = $wpdb->get_results($wpdb->prepare("SELECT meta_id, meta_key, meta_value FROM {$table} WHERE post_id = %d", $id));
     $meta = array();
     foreach ($results as $row) {
         $value = $this->prepare_meta($id, $row, true);
         if (is_wp_error($value)) {
             continue;
         }
         $meta[] = $value;
     }
     return apply_filters('json_prepare_meta', $meta, $id);
 }
Ejemplo n.º 29
0
 /**
  * Generates SQL clauses to be appended to a main query.
  *
  * @since 3.2.0
  * @access public
  *
  * @param string $type              Type of meta, eg 'user', 'post'.
  * @param string $primary_table     Database table where the object being filtered is stored (eg wp_users).
  * @param string $primary_id_column ID column for the filtered object in $primary_table.
  * @param object $context           Optional. The main query object.
  * @return array {
  *     Array containing JOIN and WHERE SQL clauses to append to the main query.
  *
  *     @type string $join  SQL fragment to append to the main JOIN clause.
  *     @type string $where SQL fragment to append to the main WHERE clause.
  * }
  */
 public function get_sql($type, $primary_table, $primary_id_column, $context = null)
 {
     if (!($meta_table = _get_meta_table($type))) {
         return false;
     }
     $this->meta_table = $meta_table;
     $this->meta_id_column = sanitize_key($type . '_id');
     $this->primary_table = $primary_table;
     $this->primary_id_column = $primary_id_column;
     $sql = $this->get_sql_clauses();
     /*
      * If any JOINs are LEFT JOINs (as in the case of NOT EXISTS), then all JOINs should
      * be LEFT. Otherwise posts with no metadata will be excluded from results.
      */
     if (false !== strpos($sql['join'], 'LEFT JOIN')) {
         $sql['join'] = str_replace('INNER JOIN', 'LEFT JOIN', $sql['join']);
     }
     /**
      * Filter the meta query's generated SQL.
      *
      * @since 3.1.0
      *
      * @param array $args {
      *     An array of meta query SQL arguments.
      *
      *     @type array  $clauses           Array containing the query's JOIN and WHERE clauses.
      *     @type array  $queries           Array of meta queries.
      *     @type string $type              Type of meta.
      *     @type string $primary_table     Primary table.
      *     @type string $primary_id_column Primary column ID.
      *     @type object $context           The main query object.
      * }
      */
     return apply_filters_ref_array('get_meta_sql', array($sql, $this->queries, $type, $primary_table, $primary_id_column, $context));
 }
 /**
  * Retrieve custom fields for post.
  *
  * @param int $id Post ID
  * @return (array[]|WP_Error) List of meta object data on success, WP_Error otherwise
  */
 public function get_history($uid, $type)
 {
     if (empty($uid)) {
         $this->set_status(404);
         return array('message' => __('Invalid Unique ID.'));
     }
     //$post = get_post($id, ARRAY_A);
     if (empty($uid)) {
         $this->set_status(404);
         return array('message' => __('Invalid Unique ID.'));
     }
     if (!$this->check_edit_permission($post)) {
         //return new WP_Error( 'json_cannot_edit', __( 'Sorry, you cannot edit this post' ), array( 'status' => 403 ) );
     }
     global $wpdb;
     $table = _get_meta_table('post');
     $sql = "SELECT distinct(p.ID) FROM " . $wpdb->posts . " as p " . " INNER JOIN " . $table . " as m ON m.post_id=p.ID and m.meta_value='" . $uid . "'" . " WHERE p.post_type LIKE %s";
     $results = $wpdb->get_results($wpdb->prepare($sql, $type));
     $post_ids = array();
     foreach ($results as $row) {
         $post_ids[] = $row->ID;
     }
     //return array($post_ids);
     $sql = "SELECT post_id, meta_value FROM {$table} WHERE post_id in ('" . implode("','", $post_ids) . "') and meta_key LIKE %s order by meta_value asc limit 0, 5";
     $results = $wpdb->get_results($wpdb->prepare($sql, 'date_time'));
     $meta = array();
     foreach ($results as $row) {
         $meta[] = array('post_id' => $row->post_id, 'date_time' => $row->meta_value);
     }
     return array('count' => count($meta), 'result' => $meta);
 }