Файл: library/XenForo/Install/Upgrade/1010034-110b4.php
Строк: 28
<?php
class XenForo_Install_Upgrade_1010034 extends XenForo_Install_Upgrade_Abstract
{
public function getVersionName()
{
return '1.1.0 Beta 4';
}
public function step1()
{
// add prefix id to feed table
$this->executeUpgradeQuery("
ALTER TABLE xf_feed
ADD prefix_id INT UNSIGNED NOT NULL DEFAULT 0
");
// add index to node table
$this->executeUpgradeQuery("
ALTER TABLE xf_node
ADD INDEX display_in_list (display_in_list, lft)
");
// add ip logging to conversation messages
$this->executeUpgradeQuery("
ALTER TABLE xf_conversation_message
ADD ip_id INT UNSIGNED NOT NULL DEFAULT 0
");
// add ip logging to profile post comments
$this->executeUpgradeQuery("
ALTER TABLE xf_profile_post_comment
ADD ip_id INT UNSIGNED NOT NULL DEFAULT 0
");
// add new YouTube match URL
$this->executeUpgradeQuery('
UPDATE xf_bb_code_media_site
SET match_urls = CONCAT(match_urls, 'nyoutube.com/watch?feature=player_embedded&v={$id}')
WHERE media_site_id = 'youtube'
');
return true;
}
}