<?php
class *******_XenResourcePrefix_Installer
{
public static function addColumn($table, $field, $attr)
{
if (!self::checkIfExist($table, $field)) {
$db = XenForo_Application::get('db');
return $db->query("ALTER TABLE `" . $table . "` ADD `" . $field . "` " . $attr);
}
}
public static function checkIfExist($table, $field)
{
$db = XenForo_Application::get('db');
if ($db->fetchRow('SHOW columns FROM `' . $table . '` WHERE Field = ?', $field)) {
return true;
}
else {
return false;
}
}
public static function install()
{
$creditsAddon = XenForo_Model::create('XenForo_Model_AddOn')->getAddOnVersion('XenResource');
if (!$creditsAddon) {
throw new XenForo_Exception('XenForo Resource Manager Addon required', true);
}
$db = XenForo_Application::getDb();
$db->query("
CREATE TABLE IF NOT EXISTS `xf_resource_category_prefix` (
`resource_category_id` int(10) unsigned NOT NULL,
`prefix_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`resource_category_id`,`prefix_id`),
KEY `prefix_id` (`prefix_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
");
if (!self::checkIfExist('xf_resource', 'prefix_id')) {
self::addColumn('xf_resource', 'prefix_id', " int(10) unsigned NOT NULL DEFAULT '0'");
}
if (!self::checkIfExist('xf_thread_prefix', 'is_resource')) {
self::addColumn('xf_thread_prefix', 'is_resource', " tinyint(3) unsigned NOT NULL DEFAULT '0'");
}
return true;
}
/**
* So sad. Delete all the data used by this addon
*/
public static function uninstall()
{
$db = XenForo_Application::getDb();
if (self::checkIfExist('xf_thread_prefix', 'is_resource')) {
$db->query("ALTER TABLE `xf_thread_prefix` DROP `is_resource`");
}
$db->query("DROP TABLE IF EXISTS `xf_resource_category_prefix`");
return true;
}
}
?>
