public static function find_by_id_in($values) {
return MPM::find_by_id_in(self::k(__CLASS__), $values, MPU::table("field_sets"));
}
public static function install() {
global $wpdb;
require_once(ABSPATH . '/wp-admin/includes/upgrade.php');
if ( !empty($wpdb->charset) )
$charset_collate = "DEFAULT CHARACTER SET $wpdb->charset";
if ( !empty($wpdb->collate) )
$charset_collate .= " COLLATE $wpdb->collate";
MPU::combine_type_styles();
MPU::combine_type_scripts();
// create database tables
$table_name = MPU::table("post_types");
$sql = "CREATE TABLE $table_name (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(100),
plural_name varchar(100),
disabled tinyint(1),
labels text,
description text,
publicly_queryable tinyint(1),
exclude_from_search tinyint(1),
show_ui tinyint(1),
show_in_menu tinyint(1),
menu_position tinyint,
menu_sub_position tinyint,
menu_icon text,
menu_icon_2x text,
manage_sort_order varchar(255) DEFAULT 'post_date|desc',
capability_type varchar(100),
capabilities text,
map_meta_cap tinyint(1),
hierarchical tinyint(1),
supports text,
columns text,
permalink_epmask varchar(255),
has_archive tinyint(1),
rewrite text,
query_var varchar(100),
can_export tinyint(1),
show_in_nav_menus tinyint(1),
visibility text,
_builtin tinyint(1),
_external tinyint(1),
PRIMARY KEY (name),
KEY id (id)
) $charset_collate;";
dbDelta($sql);
// create database tables
$table_name = MPU::table("templates");
$sql = "CREATE TABLE $table_name (
id varchar(255),
supports text,
visibility text,
PRIMARY KEY (id)
) $charset_collate;";
dbDelta($sql);
$table_name = MPU::table("taxonomies");
$sql = "CREATE TABLE $table_name (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(100),
plural_name varchar(100),
object_type text,
labels text,
disabled tinyint(1),
show_in_nav_menus tinyint(1),
show_manage_filter tinyint(1),
show_ui tinyint(1),
show_tagcloud tinyint(1),
hide_term_ui tinyint(1),
hierarchical tinyint(1),
rewrite text,
query_var varchar(100),
capabilities text,
columns text,
update_count_callback varchar(100),
visibility text,
title_icon text,
title_icon_2x text,
_builtin tinyint(1),
_external tinyint(1),
PRIMARY KEY (name),
KEY id (id)
) $charset_collate;";
dbDelta($sql);
// remove "another_field" if it exists
$row = $wpdb->get_row("SHOW COLUMNS FROM `" . $table_name . "` LIKE '_another_field'");
if ($row) {
$wpdb->query( "ALTER TABLE $table_name DROP COLUMN `_another_field`" );
}
$table_name = MPU::table("fields");
$sql = "CREATE TABLE $table_name (
id int(11) NOT NULL AUTO_INCREMENT,
field_set_id int(11) NOT NULL,
name varchar(255) NOT NULL,
labels text,
disabled tinyint(1),
summary_options text,
required tinyint(1) NOT NULL DEFAULT 0,
allow_multiple tinyint(1) NOT NULL DEFAULT 0,
visibility text,
icon text,
type varchar(100) NOT NULL,
type_options text,
position int(11),
capabilities text NULL,
PRIMARY KEY (id)
) $charset_collate;";
dbDelta($sql);
$table_name = MPU::table("field_sets");
$sql = "CREATE TABLE $table_name (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(255) NOT NULL,
singular_name varchar(255) NOT NULL,
disabled tinyint(1),
position smallint,
allow_multiple BOOLEAN NOT NULL DEFAULT 1,
visibility text,
icon text,
labels text,
expanded tinyint(1),
sidebar tinyint(1),
type varchar(20),
versions int(11) NOT NULL DEFAULT 10,
capabilities text NULL,
PRIMARY KEY (id)
) $charset_collate;";
dbDelta($sql);
// a site-specific custom table to store metadata for taxonomy terms
$table_name = MPU::table("termmeta", "mp_", false);
$sql = "CREATE TABLE $table_name (
tmeta_id int(11) NOT NULL AUTO_INCREMENT,
term_id bigint(20) NOT NULL,
taxonomy varchar(50) DEFAULT NULL,
meta_key varchar(255) DEFAULT NULL,
meta_value LONGTEXT,
PRIMARY KEY (tmeta_id),
KEY term_id (term_id),
KEY meta_key (meta_key)
) $charset_collate;";
dbDelta($sql);
// a site-specific custom table to store metadata for the site
$table_name = MPU::table("sitemeta");
$sql = "CREATE TABLE $table_name (
smeta_id int(11) NOT NULL AUTO_INCREMENT,
site_id int(11) NOT NULL,
meta_key varchar(255) DEFAULT NULL,
meta_value LONGTEXT,
PRIMARY KEY (smeta_id),
KEY meta_key (meta_key)
) $charset_collate;";
dbDelta($sql);
$table_name = MPU::table("versions", "mp_", false);
$sql = "CREATE TABLE $table_name (
version_id int(11) NOT NULL AUTO_INCREMENT,
date DATETIME NOT NULL,
user_id int(11) NOT NULL,
object_id bigint(20) NOT NULL,
object_type varchar(50) NOT NULL,
object_type_meta varchar(50) DEFAULT NULL,
field_set_name varchar(255) NOT NULL,
field_set_count int(11) NOT NULL,
value LONGTEXT,
PRIMARY KEY (version_id),
KEY field_set_name (field_set_name)
) $charset_collate;";
dbDelta($sql);
MPM_Taxonomy::insert_builtin();
MPM_PostType::insert_builtin();
}
public function form() {
$model = MasterPress::$model;
$info = MasterPress::$view;
$parent = $info->parent;
global $wf;
$prefix = "";
$default_key = "edit_posts";
$keys = array();
?>
<div class="mpv-field-sets-form">
<?php if (isset(MasterPress::$parent)) : ?>
<div class="title-info-panel">
<div class="title-info-panel-lt">
<?php if (get_class($parent) == "MPM_PostType") : ?>
<?php
$post_type = $parent;
$prefix = $post_type->name."_";
$default_key = "edit_".$post_type->capability_type."s";
$keys = array($default_key);
?>
<h3 class="post-type"><i class="mp-icon mp-icon-post-type mp-icon-post-type-<?php echo $post_type->name ?>"></i><span class="label"><?php _e("Post Type:", MASTERPRESS_DOMAIN) ?></span><span class="value"> <?php echo $parent->labels["name"] ?></span></h3>
<input id="post_type_name" type="hidden" value="<?php echo $parent->name ?>" />
<?php elseif ($model->template) : ?>
<?php
$file = MasterPress::$parent;
$page_templates = array_flip(get_page_templates());
$template_name = $page_templates[$file];
?>
<input id="templates" name="templates" type="hidden" value="<?php echo $file ?>" />
<h3><i class="template"></i><span class="label"><?php _e("Template:", MASTERPRESS_DOMAIN) ?></span><span class="value"> <?php echo $template_name ?></span></h3>
<?php elseif ($model->role) : ?>
<?php
$role_name = MasterPress::$parent;
$prefix = $role_name."_";
?>
<input id="roles" name="roles" type="hidden" value="<?php echo $role_name ?>" />
<h3><i class="user-role"></i><span class="label"><?php _e("User Role:", MASTERPRESS_DOMAIN) ?></span><span class="value"> <?php echo $role_name ?></span></h3>
<?php elseif ($model->taxonomy) : ?>
<?php
$taxonomy_id = MasterPress::$parent;
$tax = MPM_Taxonomy::find_by_id($taxonomy_id);
$prefix = $tax->name."_";
$default_key = $tax->capabilities["edit_terms"];
$keys = array(
$tax->capabilities["manage_terms"],
$tax->capabilities["edit_terms"],
$tax->capabilities["assign_terms"]
);
?>
<input id="taxonomies" name="taxonomies" type="hidden" value="<?php echo $tax->name ?>" />
<h3><i class="mp-icon mp-icon-taxonomy mp-icon-taxonomy-<?php echo $tax->name ?>"></i><span class="label"><?php _e("Taxonomy:", MASTERPRESS_DOMAIN) ?></span><span class="value"> <?php echo $tax->display_label() ?></span></h3>
<?php endif; ?>
</div>
</div>
<?php endif; ?>
<?php MPV::messages(); ?>
<div class="mpv-field-sets-form">
<div class="f">
<label for="name" class="icon"><i class="script-php"></i><?php _e("Name", MASTERPRESS_DOMAIN)?>:</label>
<div class="fw">
<input id="name_original" name="name_original" type="hidden" class="text mono key" maxlength="20" value="<?php echo $model->name ?>" />
<input id="name_last" name="name_last" type="hidden" class="text mono key" maxlength="20" value="<?php echo $model->name ?>" />
<input id="name" name="name" type="text" class="text mono key" maxlength="255" value="<?php echo $model->name ?>" /><em class="required">(required)</em>
<p>
<?php _e("This is a unique identifier for the field set used in the MasterPress API. Since it can be used as a PHP variable name, it is restricted to being a lowercase string with words separated by underscores.", MASTERPRESS_DOMAIN); ?>
</p>
</div>
</div>
<!-- /.f -->
<div id="f-singular_name" class="f">
<label for="singular_name" class="icon" maxlength="255"><i class="script-php"></i><?php _e("<strong>Singular</strong> Name", MASTERPRESS_DOMAIN)?>:</label>
<div class="fw">
<input id="singular_name" name="singular_name" type="text" value="<?php echo $model->singular_name ?>" class="text mono key" /><em class="required">(required)</em>
<p>
<?php _e("The singular form of <em>Name</em>, following the same naming conventions", MASTERPRESS_DOMAIN); ?>
</p>
</div>
</div>
<!-- /.f -->
<div class="f">
<label for="allow_multiple" class="icon"><i class="add-remove"></i><?php _e("Allow Multiple Items", MASTERPRESS_DOMAIN) ?>?</label>
<div class="fw">
<input id="allow_multiple" name="allow_multiple" type="checkbox" value="true" <?php echo WOOF_HTML::checked_attr( $model->allow_multiple ) ?> class="checkbox" />
<p id="name_warning" class="warning">
<i class="error-circle"></i>
<?php _e("For multiple-item field sets, <em>Name</em> should be specified in <strong>plural form</strong>. Please verify that this is correct above.", MASTERPRESS_DOMAIN) ?>
</p>
</div>
</div>
<!-- /.f -->
<div class="f clearfix">
<label id="label-icon" for="icon" class="icon"><i class="image-small"></i><?php _e("Title Icon (16 x 16)", MASTERPRESS_DOMAIN) ?>:</label>
<div class="fw">
<div id="icon-file-uploader" class="icon-uploader file-uploader { ids: { drop: 'icon_drop_area' }, input: '#icon', inputName: 'icon_ul', base_url: '<?php echo MASTERPRESS_GLOBAL_CONTENT_URL ?>', params: { dir: 'menu-icons/' }, limit: 1, lang: { buttonChoose: '<?php _e("Choose from Computer…", MASTERPRESS_DOMAIN) ?>', buttonReplace: '<?php _e("Replace file…", MASTERPRESS_DOMAIN) ?>' } }">
<div id="icon_drop_area" class="drop-area"><?php _e("Drop file here to upload", MASTERPRESS_DOMAIN) ?></div>
<?php
$file_name = $model->icon;
$file_class = "";
$clear_class = "";
$preview_class = "";
if ($file_name == "") {
$file_name = __("( None )", MASTERPRESS_DOMAIN);
$file_class = "name-none";
$preview_class = "preview-none";
$style = "";
$clear_class = "hidden";
} else {
$style = ' style="background-image: url('.MPU::field_set_icon_url($model->icon).')" ';
}
?>
<div class="file">
<span class="preview <?php echo $preview_class ?>" <?php echo $style ?>></span><span data-none="<?php echo __("( None )", MASTERPRESS_DOMAIN) ?>" class="name <?php echo $file_class ?>"><?php echo $file_name ?></span>
<button type="button" class="<?php echo $clear_class ?> clear ir" title="<?php _e("Clear", MASTERPRESS_DOMAIN) ?>">Clear</button>
</div>
<input id="icon" name="icon" value="<?php echo $model->icon ?>" type="hidden" />
<div class="uploader-ui"></div>
</div>
<!-- /.file-uploader -->
<?php MPV::icon_select($model->icon, "menu-icon-select", "icon_select", "icon-file-uploader"); ?>
</div>
</div>
<!-- /.f -->
<div class="f">
<label for="expanded" class="icon"><i class="expand"></i><?php _e("Expanded", MASTERPRESS_DOMAIN) ?>?</label>
<div class="fw">
<input id="expanded" name="expanded" type="checkbox" value="true" <?php echo WOOF_HTML::checked_attr( $model->expanded ) ?> class="checkbox" />
<p class="checkbox-alt-label { for_el: '#expanded' }">
<?php _e("this field set will be expanded (not summarised) by default in the edit post screen, but can still be collapsed. It is recommended that this is <strong>unchecked if <em>Allow Multiple Items</em> is checked.</strong>", MASTERPRESS_DOMAIN); ?>
</p>
</div>
</div>
<!-- /.f -->
<?php if (!$model->role) : ?>
<div class="f">
<label for="sidebar" class="icon"><i class="sidebar"></i><?php _e("Show in Sidebar", MASTERPRESS_DOMAIN) ?>?</label>
<div class="fw">
<input id="sidebar" name="sidebar" type="checkbox" value="true" <?php echo WOOF_HTML::checked_attr( $model->sidebar ) ?> class="checkbox" />
<p class="checkbox-alt-label { for_el: '#sidebar' }">
<?php _e("this field set will be positioned in the sidebar of the edit post screen by default (but may still be dragged across to the main content area by users)", MASTERPRESS_DOMAIN); ?>
</p>
</div>
</div>
<!-- /.f -->
<?php endif; ?>
<div class="f">
<label for="disabled" class="icon"><i class="slash"></i><?php _e("Disabled", MASTERPRESS_DOMAIN) ?>?</label>
<div class="fw">
<input id="disabled" name="disabled" type="checkbox" value="true" <?php echo WOOF_HTML::checked_attr( $model->disabled ) ?> class="checkbox" />
<p class="checkbox-alt-label { for_el: '#disabled' }">
<?php _e("disabling a field set will keep its definition in the database but it will not be available in any post editing screens in WordPress, which may be <strong>preferable to deleting it</strong> completely.", MASTERPRESS_DOMAIN); ?>
</p>
</div>
</div>
<!-- /.f -->
<div class="f">
<label for="versions_store" class="icon"><i class="metabox-versions size-20"></i><?php _e("Version Limit", MASTERPRESS_DOMAIN) ?></label>
<div class="fw">
<input id="versions" name="versions" type="text" value="<?php echo $model->versions ?>" class="text" />
<p class="note">
<?php _e("Set a <b>maximum number of versions</b> of content based on this field set to retain.<br />Versions can be used to restore previous revisions of content at a later time.<br />Set this value to 0 if you do not wish to retain previous versions.", MASTERPRESS_DOMAIN); ?>
</p>
</div>
</div>
<!-- /.f -->
<div class="fs fs-labels">
<div class="fst">
<div class="fstb">
<h3><i class="label-string"></i><strong><?php _e("Labels", MASTERPRESS_DOMAIN) ?></strong> - <?php _e("displayed in the <em>Edit Post</em> and MasterPress admin screens", MASTERPRESS_DOMAIN) ?></h3>
<div class="buttons">
<button id="autofill-labels" class="button button-autofill" type="button"><?php _e('<strong>Auto-Fill</strong> Labels', MASTERPRESS_DOMAIN) ?></button>
</div>
</div>
</div>
<div class="fsc fscs">
<div class="fscb">
<div class="scroll">
<div class="f">
<label for="label_name"><?php _e("Set Label", MASTERPRESS_DOMAIN) ?>:</label>
<div class="fw">
<input id="label_name" name="labels[name]" value="<?php echo $model->labels["name"] ?>" type="text" class="text { tmpl: '{{plural_name}}' }" />
<em class="recommended">(recommended)</em>
</div>
</div>
<!-- /.f -->
<div class="f">
<label for="label_description"><?php _e("Description", MASTERPRESS_DOMAIN)?>:</label>
<div class="fw">
<textarea id="label_description" name="labels[description]"><?php echo $model->label("description") ?></textarea>
<p>
<?php _e("Displayed on the Create / Edit Post screen in the info area above the fields in this set.", MASTERPRESS_DOMAIN); ?>
</p>
</div>
</div>
<!-- /.f -->
<?php if ($model->shared) : ?>
<div class="f">
<label for="label_description_user"><?php _e("Description (User)", MASTERPRESS_DOMAIN)?>:</label>
<div class="fw">
<textarea id="label_description_user" name="labels[description_user]"><?php echo $model->label("description_user") ?></textarea>
<p>
<?php _e("Displayed on the Create / Edit User and Profile screen in the info area above the fields in this set.<br />If not specified, the standard <em>Description</em> label will be used (if available)", MASTERPRESS_DOMAIN); ?>
</p>
</div>
</div>
<!-- /.f -->
<div class="f">
<label for="label_description_term"><?php _e("Description (Term)", MASTERPRESS_DOMAIN)?>:</label>
<div class="fw">
<textarea id="label_description_term" name="labels[description_term]"><?php echo $model->label("description_term") ?></textarea>
<p>
<?php _e("Displayed on the Edit (Taxonomy) Term in the info area above the fields in this set.<br />If not specified, the standard <em>Description</em> label will be used (if available)", MASTERPRESS_DOMAIN); ?>
</p>
</div>
</div>
<!-- /.f -->
<?php endif; ?>
<div class="f f-allow-multiple">
<label for="label_singular_name"><?php _e("<em>Singular</em> Name", MASTERPRESS_DOMAIN) ?>:</label>
<div class="fw">
<input id="label_singular_name" name="labels[singular_name]" value="<?php echo $model->label("singular_name") ?>" type="text" class="text { tmpl: '{{singular_name}}' }" />
<em class="recommended">(recommended)</em>
</div>
</div>
<!-- /.f -->
<div class="f f-allow-multiple">
<label for="label_add"><?php _e("Add", MASTERPRESS_DOMAIN) ?>:</label>
<div class="fw">
<input id="label_add" name="labels[add]" value="<?php echo $model->label("add") ?>" type="text" class="text { tmpl: '<?php _e("Add {{singular_name}}", MASTERPRESS_DOMAIN) ?>' }" />
</div>
</div>
<!-- /.f -->
<div class="f f-allow-multiple">
<label for="label_add_another"><?php _e("Add Another", MASTERPRESS_DOMAIN) ?>:</label>
<div class="fw">
<input id="label_add_another" name="labels[add_another]" value="<?php echo $model->label("add_another") ?>" type="text" class="text { tmpl: '<?php _e("Add Another {{singular_name}}", MASTERPRESS_DOMAIN) ?>' }" />
</div>
</div>
<!-- /.f -->
<div class="f f-allow-multiple">
<label for="label_remove"><?php _e("Remove", MASTERPRESS_DOMAIN) ?>:</label>
<div class="fw">
<input id="label_remove" name="labels[remove]" value="<?php echo $model->label("remove") ?>" type="text" class="text { tmpl: '<?php _e("Remove {{singular_name}}", MASTERPRESS_DOMAIN) ?>' }" />
</div>
</div>
<!-- /.f -->
<div class="f f-allow-multiple">
<label for="label_click_to_add"><?php _e("Click to Add", MASTERPRESS_DOMAIN) ?>:</label>
<div class="fw">
<input id="label_click_to_add" name="labels[click_to_add]" value="<?php echo $model->label("click_to_add") ?>" type="text" class="text { tmpl: '<?php _e("Click to add {{singular_name}}", MASTERPRESS_DOMAIN) ?>' }" />
</div>
</div>
<!-- /.f -->
<div class="f f-allow-multiple">
<label for="label_one_item"><?php _e("1 Item", MASTERPRESS_DOMAIN) ?>:</label>
<div class="fw">
<input id="label_one_item" name="labels[one_item]" value="<?php echo $model->label("one_item") ?>" type="text" class="text { tmpl: '<?php _e("1 {{singular_name}}", MASTERPRESS_DOMAIN) ?>' }" />
</div>
</div>
<!-- /.f -->
<div class="f f-allow-multiple">
<label for="label_n_items"><?php _e("n Items", MASTERPRESS_DOMAIN) ?>:</label>
<div class="fw">
<input id="label_n_items" name="labels[n_items]" value="<?php echo $model->label("n_items") ?>" type="text" class="text { tmpl: '<?php _e("%d {{plural_name}}", MASTERPRESS_DOMAIN) ?>' }" />
</div>
</div>
<!-- /.f -->
<div class="f f-allow-multiple">
<label for="label_no_items"><?php _e("No Items", MASTERPRESS_DOMAIN) ?>:</label>
<div class="fw">
<input id="label_no_items" name="labels[no_items]" value="<?php echo $model->label("no_items") ?>" type="text" class="text { tmpl: '<?php _e("No {{plural_name}}", MASTERPRESS_DOMAIN) ?>' }" />
</div>
</div>
<!-- /.f -->
</div>
</div>
</div>
</div>
<!-- /.fs -->
<div class="fs fs-capability-keys clearfix">
<div class="fst">
<div class="fstb">
<h3><i class="key"></i><strong><?php _e("Capabilities", MASTERPRESS_DOMAIN) ?></strong> - <?php _e('the keys used to control access to this field set', MASTERPRESS_DOMAIN) ?></h3>
</div>
</div>
<div class="fsc">
<div class="fscb clearfix">
<div class="f f-capabilities f-capabilities-editable clearfix">
<label for="label-capabilities-editable"><?php _e("Editable", MASTERPRESS_DOMAIN) ?>:</label>
<div class="fw">
<?php
$val = $model->capability("editable", false);
$caps = array_unique(array_merge($keys, array("edit_posts", "edit_pages")));
$caps = array( __("-- None (Always Editable) --", MASTERPRESS_DOMAIN) => "" ) + $caps;
if (MPC::is_edit()) {
$caps[] = "edit_".$prefix.$model->name;
}
$custom_val = "";
if (!in_array($val, $caps)) {
$custom_val = $val;
}
echo WOOF_HTML::select( array("id" => "capabilities-editable", "name" => "capabilities[editable]", "class" => "capabilities" ),
$caps,
$val
);
?>
<label for="capabilities-editable-custom" class="capabilities-custom"><?php _e("OR custom value") ?></label>
<input id="capabilities-editable-custom" name="capabilities_custom[editable]" value="<?php echo $custom_val ?>" type="text" class="text mono capabilities-custom" />
<p class="note">
<?php _e("All fields in this set will be read-only for users without this capability.<br />Individual fields may override this with their own capabilities.", MASTERPRESS_DOMAIN) ?>
</p>
</div>
</div>
<!-- /.f -->
<div class="f f-capabilities f-capabilities-visible clearfix">
<label for="label-capabilities-visible"><?php _e("Visible", MASTERPRESS_DOMAIN) ?>:</label>
<div class="fw">
<?php
$val = $model->capability("visible", false);
$caps = array_unique(array_merge($keys, array("edit_posts", "edit_pages")));
$caps = array( __("-- None (Always Visible) --", MASTERPRESS_DOMAIN) => "" ) + $caps;
if (MPC::is_edit()) {
$caps[] = "view_".$prefix.$model->name;
}
$custom_val = "";
if (!in_array($val, $caps)) {
$custom_val = $val;
}
echo WOOF_HTML::select( array("id" => "capabilities-visible", "name" => "capabilities[visible]", "class" => "capabilities" ),
$caps,
$val
);
?>
<label for="capabilities-visible-custom" class="capabilities-custom"><?php _e("OR custom value") ?></label>
<input id="capabilities-visible-custom" name="capabilities_custom[visible]" value="<?php echo $custom_val ?>" type="text" class="text mono capabilities-custom" />
<p class="note">
<?php _e("This field set will be invisible for users without this capability", MASTERPRESS_DOMAIN) ?>
</p>
</div>
</div>
<!-- /.f -->
</div>
</div>
</div>
<!-- /.fs -->
<?php
$args = array();
$args["supports"] = array();
if (is_multisite() && MASTERPRESS_MULTISITE_SHARING) {
$args["supports"] = array("multisite");
}
if ($model->is_shared()) {
$args["supports"][] = "post_types";
}
if (!isset($info->is_template_set) && $model->is_shared() ) {
$args["supports"][] = "templates";
}
if (!isset($info->is_role_set) && $model->is_shared() ) {
$args["supports"][] = "roles";
}
if (!isset($info->is_taxonomy_set) && $model->is_shared() ) {
$args["supports"][] = "taxonomies";
}
$args["labels"] = array(
"title" => __("control the visibility of this field set within WordPress", MASTERPRESS_DOMAIN),
"title_multisite" => __("specify the sites in the multisite network that this field set is available in", MASTERPRESS_DOMAIN),
"title_post_types" => __("specify the post types that this field set is available in", MASTERPRESS_DOMAIN),
"title_templates" => __("specify the templates that this field set is available in", MASTERPRESS_DOMAIN),
"title_roles" => __("specify the roles that users must have for this field set to be available in their profile edit screen", MASTERPRESS_DOMAIN),
"multisite_all" => __( "All Sites" ),
"post_types_all" => __( "All Post Types" ),
"templates_all" => __( "All Templates" )
);
$args["defaults"] = array(
"post_types" => "all"
);
if ($model->type == "p") {
$post_type = $parent;
$templates = $post_type->templates();
if (count($templates)) {
$args["supports"][] = "templates";
$args["templates"] = array();
$all = array_flip(get_page_templates());
foreach ($templates as $t) {
$name = $all[$t->id];
$args["templates"][$name] = $t->id;
}
}
}
if (isset($parent) && is_multisite()) {
$site_options = array();
foreach ($parent->sites() as $site) {
$site_options[$site->full_path()] = $site->id();
}
$args["sites"] = $site_options;
};
MPV::fs_visibility( $model, $args );
?>
<?php if ($info->is_template_set) : ?>
<input id="visibility-templates" name="visibility[templates]" type="hidden" value="<?php echo $file ?>" />
<?php endif; ?>
<?php if ($info->is_role_set) : ?>
<input id="visibility-roles" name="visibility[roles]" type="hidden" value="<?php echo $role_name ?>" />
<?php endif; ?>
<?php if ($info->is_taxonomy_set) : ?>
<input id="visibility-taxonomies" name="visibility[taxonomies]" type="hidden" value="<?php echo $tax->name ?>" />
<?php endif; ?>
<?php if ($model->is_post_type() && isset($parent)) : ?>
<input id="visibility-post-types" name="visibility[post_types]" type="hidden" value="<?php echo $parent->name ?>" />
<?php endif; ?>
<div id="f-position" class="f clearfix">
<label for="position" class="icon"><i class="sort"></i><?php _e("Set Position", MASTERPRESS_DOMAIN)?>:</label>
<div class="fw">
<div class="sortable-list sortable-list-fields">
<span class="arrow"></span>
<?php
// build a field list
$field_sets = array();
if ($model->shared) {
$field_sets = MPM_SharedFieldSet::find( array( "orderby" => "position ASC" ) );
} else if ($model->template) {
$field_sets = MPM_TemplateFieldSet::find_by_template( MasterPress::$parent );
} else if ($model->role) {
$field_sets = MPM_RoleFieldSet::find_by_role( MasterPress::$parent );
} else if ($model->taxonomy) {
$field_sets = MPM_TaxonomyFieldSet::find_by_taxonomy( $tax );
} else if ($model->site) {
$field_sets = MPM_SiteFieldSet::find( array( "orderby" => "position ASC" ) );
} else {
$sql = "SELECT * FROM ".MPU::table("field-sets")." WHERE ( type = 'p' ) AND ".MPM::visibility_rlike("post_types", $parent->name)." ORDER BY position";
$field_sets = MPM::get_models("field-set", $sql);
}
$sort_field_sets = array();
// now build a representable list of field_sets
$icon = $model->shared ? MPU::img_url("icon-shared-field-set.png") : MPU::img_url("icon-field-set-small.png");
$icon_class = $model->shared ? "metabox-share" : "metabox";
foreach ($field_sets as $field_set) {
$position = $field_set->position;
if (isset($_POST["other_position"]) && $_POST["other_position"][$field_set->id]) {
$position = $_POST["other_position"][$field_set->id];
}
$sort_field_sets[] = array( "position" => $position, "disabled" => $field_set->disabled, "current" => $field_set->id == $model->id, "label" => $field_set->display_label(), "icon_class" => $icon_class, "icon" => $icon, "id" => $field_set->id );
}
if (MPC::is_create()) {
$label = $model->display_label();
if (!$label || $label == "") {
$label = "?";
}
$sort_field_sets[] = array( "position" => $model->position, "disabled" => $model->disabled, "current" => true, "label" => $model->display_label(), "icon" => $icon, "icon_class" => $icon_class );
}
$count = 0;
?>
<ul>
<?php foreach ($sort_field_sets as $f) : $count++; $first = $count == 1 ? "first " : ""; $current = $f["current"] ? 'current ' : ''; ?>
<?php
$disabled = $f["disabled"] ? 'disabled' : '';
$disabled_title = $f["disabled"] ? __("This field set is disabled", MASTERPRESS_DOMAIN) : '';
?>
<li class="<?php echo $first.$current ?> <?php echo $disabled ?>" title="<?php echo $disabled_title ?>">
<i class="<?php echo $icon_class ?>"></i>
<?php if ($f["current"]) : ?>
<span class="inline fill { src: '#label_name,#label_singular_name'}"><?php echo $f["label"] ?></span>
<input id="position" name="position" value="<?php echo $f["position"] ?>" type="hidden" class="text" />
<?php else: ?>
<span class="inline"><?php echo $f["label"] ?></span>
<input id="other_position" name="other_position[<?php echo $f["id"] ?>]" value="<?php echo $f["position"] ?>" type="hidden" />
<?php endif; ?>
</li>
<?php endforeach; ?>
</ul>
</div>
<!-- /.sortable-list -->
<p>
<?php _e("Drag set to the desired <em>default</em> position in the WordPress <em>Create / Edit Post</em> screen.<br />Note: Field sets are displayed in a standard WordPress UI panel (metabox), which can be dragged around by the user to also influence the order.", MASTERPRESS_DOMAIN) ?>
</p>
</div>
</div>
<!-- /.f -->
</div>
<!-- /.mpv-field-sets-form -->
<?php
}
protected function get_user_relations($for = array(), $type = "post", $object) {
// build a reverse map of all of the IDs that are related to in related user metadata
if (!isset($this->user_relations[$type])) {
global $wpdb;
$this->user_relations[$type] = array();
$this->user_relations_fields[$type] = array();
// get a list of all meta keys that are related user fields
if ($type == "post") {
$sql = "SELECT DISTINCT meta_key FROM $wpdb->postmeta WHERE meta_key LIKE '%:field_id' AND meta_value IN (SELECT id FROM ".MPU::table("fields")." WHERE `type` = 'related-user')";
} else if ($type == "user") {
$sql = "SELECT DISTINCT meta_key FROM $wpdb->usermeta WHERE meta_key LIKE '%:field_id' AND meta_value IN (SELECT id FROM ".MPU::table("fields")." WHERE `type` = 'related-user')";
} else if ($type == "term") {
$sql = "SELECT DISTINCT meta_key FROM {$this->termmeta()} WHERE meta_key LIKE '%:field_id' AND meta_value IN (SELECT id FROM ".MPU::table("fields")." WHERE `type` = 'related-user')";
}
$fields = $wpdb->get_col($sql);
if (count($fields)) {
// run through the meta fields and remove the field id property
$meta_keys = array();
foreach ($fields as $field) {
list($set_name, $field_name, $prop_name) = MPFT::parse_meta_key($field);
$meta_keys[] = "'".MPFT::meta_key($set_name, $field_name)."'";
}
// now grab all meta values within these keys
if ($type == "post") {
$sql = "SELECT * FROM $wpdb->postmeta WHERE meta_key IN (".implode(",", $meta_keys).")";
$col = "post_id";
} else if ($type == "user") {
$sql = "SELECT * FROM $wpdb->usermeta WHERE meta_key IN (".implode(",", $meta_keys).")";
$col = "user_id";
} else if ($type == "term") {
$col = "term_id";
$sql = "SELECT * FROM {$this->termmeta()} WHERE meta_key IN (".implode(",", $meta_keys).")";
}
$rows = $wpdb->get_results($sql);
// now run through them all, and store the reverse relationships
$pr = array();
$prf = array();
foreach ($rows as $row) {
$ids = MPU::db_decode($row->meta_value);
if (!is_array($ids) && $ids != "") {
$ids = array($ids);
}
if (is_array($ids)) {
foreach ($ids as $id) {
if (!isset($pr[$id])) {
$pr[(int)$id] = array();
}
$pr[(int)$id][] = (int) $row->{$col};
}
if (!isset($prf[$row->meta_key])) {
$prf[$row->meta_key] = array();
}
if (!isset($prf[$row->meta_key][$iid])) {
$prf[$row->meta_key][$iid] = array();
}
$prf[$row->meta_key][$iid][] = (int) $row->{$col};
}
}
// remove dupes
foreach ($pr as $id => $ids) {
$this->user_relations[$id] = array_unique($ids);
}
// remove dupes from the items stored by field
foreach ($prf as $key => $rel) {
foreach ($rel as $id => $ids) {
if (!isset($this->user_relations_fields[$type][$key])) {
$this->user_relations_fields[$type][$key] = array();
}
$this->user_relations_fields[$type][$key][$id] = array_unique($ids);
}
}
}
}
if (count($for)) {
// collect the fields
$to_merge = array();
foreach ($for as $key) {
if (isset($this->user_relations_fields[$type][$key])) {
$to_merge = $this->user_relations_fields[$type][$key];
}
}
return array_merge_recursive($to_merge);
} else {
return $this->user_relations[$type];
}
}
<?php
/**
* Uninstall file for MasterPress
*
*/
global $wpdb;
if (!defined('WP_UNINSTALL_PLUGIN')) {
exit();
}
// We won't delete data tables, but will delete MasterPress definition tables
$tables = array("post_types", "templates", "taxonomies", "fields", "field_sets");
foreach ($tables as $table) {
$table_name = MPU::table($table);
$sql = "DROP TABLE IF EXISTS $table_name;";
$wpdb->query($sql);
}
delete_option( "masterpress_version" );
delete_option( "masterpress_flush_rules" );
delete_option( "mp_licence_key" );
public static function add_site_meta($site_id, $meta_key, $meta_value) {
global $wpdb;
$result = $wpdb->insert(
MPU::table("sitemeta"),
array(
"site_id" => $site_id,
"meta_key" => $meta_key,
"meta_value" => $meta_value
),
array("%d", "%s", "%s")
);
if ($result) {
return $wpdb->insert_id;
}
return false;
}
public function field_set_count() {
global $wpdb;
$post_type_sets = $wpdb->get_col("SELECT id FROM ".MPU::table("field-sets")." WHERE type = 'p' AND ".MPM::visibility_rlike("post_types", $this->name));
return count($post_type_sets);
}
public function delete_field_sets() {
global $wpdb;
// delete the field sets of type 'x'
$sql = "SELECT id FROM ".MPU::table("field-sets")." WHERE type = 'x' AND ".MPM::visibility_rlike("taxonomies", $this->name);
$tax_sets = $wpdb->get_col($sql);
if (count($tax_sets)) {
// delete JUST the POST TYPE field sets assigned to this post type
$wpdb->query("DELETE FROM ".MPU::table("field-sets")." WHERE id IN (".implode(",", $tax_sets).") ");
// delete the fields within those sets
$wpdb->query("DELETE FROM ".MPU::table("fields")." WHERE field_set_id IN (".implode(",", $tax_sets).") ");
}
}
public static function table($model) {
return MPU::table( str_replace("-", "_", $model) );
}
public function delete_meta() {
global $wpdb;
// get a list of field ids for this set
$field_ids = $wpdb->get_col("SELECT id FROM ".MPU::table("fields")." WHERE field_set_id = ".$this->id);
if (count($field_ids)) {
// get a list of meta values bound to this field.
$sql = "SELECT post_id, meta_key FROM $wpdb->postmeta WHERE meta_key LIKE '%:field_id' AND meta_value IN (".implode(",", $field_ids).")";
$rows = $wpdb->get_results($sql);
foreach ($rows as $row) {
list($set_name, $field_name, $prop_name) = MPFT::parse_meta_key($row->meta_key);
$sql = "DELETE FROM $wpdb->postmeta WHERE post_id = ".$row->post_id." AND ( meta_key = '".MPFT::meta_key($set_name, $field_name)."' OR meta_key LIKE '".MPFT::meta_key($set_name, $field_name).":%' )";
$wpdb->query($sql);
}
}
}
