View file upload/library/XenForo/Install/Upgrade/1040770-147.php
<?php
class XenForo_Install_Upgrade_1040770 extends XenForo_Install_Upgrade_Abstract
{
public function getVersionName()
{
return '1.4.7';
}
public function step1()
{
$this->executeUpgradeQuery('
UPDATE xf_bb_code_media_site SET
match_urls = CONCAT(match_urls, \'\nfacebook.com/*/videos/{$id:digits}\')
WHERE media_site_id = \'facebook\'
AND match_is_regex = 0
');
}
}