Mark Huot's file extension and Multi Site Manager

Right, I’ve cracked it! The problem comes because I had fields with the same names in both of my sites, so when the replacement happens, it uses the field data from whichever field comes first, regardless of which site it’s from (so on the second site, it gets replaced with nothing). This explains why when I create new file fields on the new site, they work just fine.

So, I needed to modify the extension to check the Site ID, and then get the right set of fields based on that. Here’s what I did - this code is from V3.11 of the templates.

I replaced the following (starting about line 1109):

function modify_template( $tagdata, $row )
    {
        global $DB, $FNS, $TMPL, $EXT, $SESS;
        global $all_fields, $file_fields;
        
        if($EXT->last_call !== false)
        {
            $tagdata = $EXT->last_call;
        }
        
        if(!isset($SESS->cache)) $SESS->cache = array();
        if(!isset($SESS->cache['mh_file_ext_fields']))
        {
            $SESS->cache['mh_file_ext_fields'] = $DB->query('SELECT * FROM exp_weblog_fields f, exp_upload_prefs p WHERE f.field_type="file" AND p.id=f.field_list_items');
        }
        
        //    =============================================
        //    Loop Through Fields
        //    =============================================
        foreach($SESS->cache['mh_file_ext_fields']->result as $file_field)
        {

With this:

function modify_template( $tagdata, $row )
    {
        global $DB, $FNS, $TMPL, $EXT, $SESS, $PREFS;
        global $all_fields, $file_fields;
        
        if($EXT->last_call !== false)
        {
            $tagdata = $EXT->last_call;
        }
        
        $site_id=$PREFS->ini('site_id');
        
        if(!isset($SESS->cache)) $SESS->cache = array();
        if(!isset($SESS->cache['mh_file_ext_fields_'.$site_id]))
        {
            $SESS->cache['mh_file_ext_fields_'.$site_id] = $DB->query('SELECT * FROM exp_weblog_fields f, exp_upload_prefs p WHERE f.field_type="file" AND p.id=f.field_list_items AND f.site_id = '.$site_id);
        }
        
        //    =============================================
        //    Loop Through Fields
        //    =============================================
        foreach($SESS->cache['mh_file_ext_fields_'.$site_id]->result as $file_field)
        {

You’ll see that we need to declare $PREFS as global, to get the id of the site we’re looking at. Then the query is modified to search based on the site id. We cache each of these queries separately.

This post was helpful in finding out how we get at the id of the current site.

You still might run into problems if you use the “site” parameter in your weblog entries tag - the code above would require a tweak, but I don’t think it’s 100% straightforward. To fully MSM-ify this module, will require a bit more thought, but the above has worked for me. Hope it helps someone.

Hi Paul,

Your post is over two years old, but it has shed some light on the situation!

I need to be able to pull in custom file fields from articles spread over 3 separate sites. I’m currently working on MSMifying Mark Huots file extension to support this.

I’ll post my amends if/when I work it all out.

Matt

Dude, you just saved my life.

Thank-you for discovering this. wow.

+1 saved my life

Thanks alot!

Hi Paul, Your post is over two years old, but it has shed some light on the situation!

Actually I think he posted that just 2 weeks before 😊

+1 saved my life Thanks alot!

Hi Paul, Your post is over two years old, but it has shed some light on the situation!

Actually I think he posted that just 2 weeks before 😊

Yeah! You’re indeed correct. I was looking at the joined date!

Hi!

I had this same problem. But I didn’t want to modify the extension. So, I just changed the name of the field slightly, and that worked. This would be a great solution for less technical folks.

In this case, each of my sites is for a different country, so if the original field was called {the-pic}, I changed the name of the field in my Australia site to {the-pic-australia} and then for England {the-pic-england}, and on and on.

Thanks for the post negs. I’ve used the same method and it seems to work. Hopefully when Mark gets some free time to update his extension, he’ll take this issue into account. Otherwise, great, simple extension!