Permissions and multisite

Good day kcuming.

I can see a 2-part situation here.

The first part is awarding badges that are meant to be network wide. Achievements, at their core, are a custom post type that users technically create posts in. We shaped the post editor for these to save details for the achievement types, and register post types out of them. A custom post type used to create custom post types.

The problem with this is that the post types are, by nature, site-specific, since each site gets their own wp_posts/wp_postmeta tables. I can’t think of any way offhand to craft the plugin(s) to award these network wide.

On the other part, we do have it possible to display achievements from different sites in one central location. We do some looping and switch_to_blog() use to gather up all of the data necessary from each subsite, and compile an accurate list of achievements from all the sites.

In short, awarding network achievements is a difficulty, showing achievements from all sites in the network is already covered.

I imagine it can be done, but we don’t have much, if anything at all, set up for setting granular permissions per achievement type. So that’s going to be a developer task there.

Hi Michael (and Kevin)
I have a follow up question to the multisite issue. I simply want to have the same badges, quests, steps etc. on one of my sites that I have on my original site.

I’m using Content Copier plugin to try and copy things over but I’m not exactly sure if it is giving me the correct results. What is the best way for copying the same BadgeOS info to another site?? (not necessary to award badges on a network wide basis)

Thank you!
Matt

1. Are you getting the post meta as well?

2. Are you flushing the permalinks at all for each site that you’re copying them over to?

Visiting the permalinks page will trigger a flush. If you’re copying over everything that you need before permalinks are even set up and saved, then something else is going on that I’m not sure of at the moment.

Now that you mention the steps part, I believe I know what you’re missing. To accurately copy over everything related to badgeos achievements, you’re going to want the following tables:

wp_posts
wp_postmeta
wp_p2p
wp_p2pmeta

You’ll also want to look at the following option from your wp_options table:

badgeos_settings

the p2p tables are used to connect post types, which we definitely use with regards to step relationships, which is probably the missing piece for you.

I’ve tried copying those specific tables in phpMyAdmin from the original site over to the new site and the same results: the steps are not copied.

Is there a better way?

Not sure what’s going on with that. It’s technically outside the scope of what the plugin suite does, but we can still offer the best advice we can.

A quick process I tested, and succeeded with, on localhost is this.

Create a network that has 2 sites in it. Main site and sub-site.

In the main site, create an achievement and assign two different steps to it.

Open SequelPro for my sql management and export the p2p tables and post tables to an sql file.

Opened the sql file in sublime text to change the table names to the appropriate subsite and save.

Go back to SequelPro and import the newly saved sql file so that it imports into the correct tables.

Switch to the sub-site and check on the badge, finding the steps in tact as well.

It’s definitely a process that would benefit from automation, but it is one that worked for my simple case. Not sure if you’re doing other steps or missed any that I mentioned, regarding the actual database content.

Glad I could help where I helped Matt.