The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
You can just run SQL to create a new column in the table.
|
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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" PHP Code:
|
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
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. |
#7
|
|||
|
|||
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! |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|