Seditio Source
Root |
./othercms/xenForo 2.2.8/src/XF/Install/Upgrade/1010035-110b5.php
<?php

namespace XF\Install\Upgrade;

class
Version1010035 extends AbstractUpgrade
{
    public function
getVersionName()
    {
        return
'1.1.0 Beta 5';
    }

    public function
step1()
    {
       
// fix metacafe match URL
       
$this->executeUpgradeQuery('
            UPDATE xf_bb_code_media_site
            SET match_urls = REPLACE(match_urls,
                \'#metacafe\\.com/watch/(?P<id>\\d+\/[a-z0-9_]+)/#siU\',
                \'#metacafe\\\\.com/watch/(?P<id>\\\\d+/[a-z0-9_]+)/#siU\'
            )
            WHERE media_site_id = \'metacafe\'
        '
);

        return
true;
    }
}