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

Hi,

I am working on a plugin that requires an extra field in the 'paymentinfo' vbulletin table.

Could someone point me to an example (perhaps a plugin that add a custom field to an existing vbulletin table ) that I can follow to create the plugin xml for this?

Thank you,

John

--------------- Added [DATE]1220609903[/DATE] at [TIME]1220609903[/TIME] ---------------

Anyone?

You can just run SQL to create a new column in the table.

Sorry, what I meant was: Is there an example of an xml product installation file... that creates a new column.

I want to make a proper plugin/product with an xml installation file.

hi,

turn on debug mode on a testboard (remember you are requirerd to htaccess this and call it testvb).open includes/config.php and righter after the "<?php"

adding a custom field into a existing vBulletin table is done through MySQL.You need to put code for the SQL query in your product install code.You also need to put code to delete the added field in your product uninstall code and so on ...

Aha so the adding of a field (when giving instructions to people to install), would have to be done manually? Anyone installing the product would have to manually do this?

I thought there was a way to do it automatically - provide sql code in xml for vb to execute when product xml is imported, provide sql code in xml for vb to execute when product is being uninstalled?

See how it is done in this article Custom Administrator Permissions (its right towards the end)

Just modify it to use the table and stuff that you want.

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!