Plugin How To - How to add custom field to existing Vbulletin table

[vb_mp]

These two:

Install:

require_once(DIR . '/includes/class_dbalter.php');
$dbalter = new vB_Database_Alter_MySQL($db);
$dbalter->fetch_table_info('administrator');
if (!$dbalter->fetch_field_info('customadminperms'))
{
$dbalter->add_field(array('name' => 'customadminperms', 'type' => 'INT', 'length' => '10', 'attributes' => 'UNSIGNED', 'null' => false, 'default' => '0'));
}
}

And uninstall:

unset($vbulletin->bf_misc_customadminperms['canadminmyhack']);
if (empty($vbulletin->bf_misc_customadminperms))
{
require_once(DIR . '/includes/class_dbalter.php');
$dbalter = new vB_Database_Alter_MySQL($db);
// Using 3.5.1+ calls
$dbalter->fetch_table_info('administrator');
if ($dbalter->fetch_field_info('customadminperms'))
{
$dbalter->drop_field('customadminperms');
}
}

Thank you Opserty!