<?php
/*************************************************************************
* XenForo Slider - Xen Factory (c) 2015
* All Rights Reserved.
* Created by Fr�d�ric Baudouin aka. Fred
**************************************************************************
* This file is subject to the terms and conditions defined in the Licence
* Agreement available at http://xen-factory.com/pages/license-agreement/.
*************************************************************************/
class XFA_Slider_Install_Install extends XFA_Slider_Install_Abstract
{
public static function run()
{
$db = XenForo_Application::getDb();
XenForo_Db::beginTransaction($db);
/**
* Create
*/
// xfa_slider
$db->query("CREATE TABLE IF NOT EXISTS `xfa_slider` (
`slider_id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(250) NOT NULL,
PRIMARY KEY (`slider_id`)
)");
// xfa_slider_content_template
$db->query("CREATE TABLE IF NOT EXISTS `xfa_slider_content_template` (
`content_template_id` int(11) NOT NULL AUTO_INCREMENT,
`content_template_name` varchar(250) NOT NULL,
`template_name` varbinary(50) NOT NULL,
`addon_id` varbinary(25) NOT NULL,
PRIMARY KEY (`content_template_id`)
)");
// xfa_slider_display
$db->query("CREATE TABLE IF NOT EXISTS `xfa_slider_display` (
`display_id` int(11) NOT NULL AUTO_INCREMENT,
`content_template_id` int(10) NOT NULL,
`position` varbinary(50) NOT NULL,
`slider_id` int(10) NOT NULL,
`enable_settings` TINYINT(1) NOT NULL DEFAULT '0',
`settings` TEXT NOT NULL,
PRIMARY KEY (`display_id`)
)");
/**
* Alter
*/
// xf_attachment_data
$db->query("ALTER TABLE xf_attachment_data ADD `xfa_slider_caption` varchar(100) NOT NULL DEFAULT ''");
$db->query("ALTER TABLE xf_attachment_data ADD `xfa_slider_caption_url` varchar(250) NOT NULL DEFAULT ''");
$db->query("ALTER TABLE xf_attachment_data ADD `xfa_slider_display_order` int(10) NOT NULL DEFAULT 0");
/**
* Insert Data
*/
$db->query("INSERT INTO `xfa_slider_content_template` (`content_template_id`, `content_template_name`, `template_name`, `addon_id`) VALUES
(1, 'All', 'all', ''),
(2, 'Account Wrapper', 'account_wrapper', 'XenForo'),
(3, 'Forum List', 'forum_list', 'XenForo'),
(4, 'Forum View', 'forum_view', 'XenForo'),
(5, 'Thread View', 'thread_view', 'XenForo'),
(6, 'Help Wrapper', 'help_wrapper', 'XenForo'),
(7, 'Thread Reply', 'thread_reply', 'XenForo'),
(8, 'Post Edit', 'post_edit', 'XenForo')
");
XenForo_Db::commit($db);
die();
/**
* Content Types
*/
XFA_Slider_Install_ContentType_ContentType::install();
}
}