Plugins For vBulletins.

Chatbox:

Product ID cybchatbox

Title Cyb - ChatBox

Version 2.0

Description Cyb - ChatBox

Product URL http://www.vbulletin.org/forum/showthread.php?t=177552

Version Check URL http://www.vbulletin.org/forum/misc.php?do=productcheck&pid=cybchatbox

Version 1.9.9


Install Code $db->hide_errors();
$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "cyb_chatbox ADD userip VARCHAR(20) NOT NULL");
$db->show_errors();


Uninstall Code


Version 2.0


Install Code $db->hide_errors();
$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."cyb_chatbox` (
`id` INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`userid` INT(10) NOT NULL,
`userip` VARCHAR(20) NOT NULL,
`dateline` INT(10) NOT NULL,
`message` TEXT NOT NULL,
`textprop` TEXT NOT NULL)
");
$db->show_errors();


Uninstall Code $db->hide_errors();
$vbulletin->db->query_write("DROP TABLE IF EXISTS `" . TABLE_PREFIX . "cyb_chatbox` ");
$db->show_errors();




Awards:


Product ID yet_another_award_system

Title Yet Another Award System 4.0

Version 4.0.1

Description Yet Another Awards System for vBulletin 3.7.x

Product URL http://www.vbulletin.org/forum/showthread.php?t=187600

Version Check URL http://www.vbulletin.org/forum/misc.php?do=checkversion&t=187600


Version 2.0.0


Install Code // PRE-PRODUCT MANAGEMENT VERSION CHECKING
$db->reporterror = 0;
// Version checking for 1.0.0.
$award_table = $db->query_first("SELECT award_id FROM ".TABLE_PREFIX."award");
$award_cat_table = $db->query_first("SELECT award_cat_id FROM ".TABLE_PREFIX."award_cat");

if (($award_table['award_id']) AND ($award_cat_table['award_cat_id'])){
$installed_version = "1.0.0";
}

// UPGRADE FROM 1.0.0 CODE
if ($installed_version == "1.0.0") {
$db->query_write("DELETE FROM ".TABLE_PREFIX."settinggroup WHERE grouptitle LIKE 'awards'");
$db->query_write("DELETE FROM ".TABLE_PREFIX."setting WHERE grouptitle LIKE 'awards'");
$db->query_write("DELETE FROM ".TABLE_PREFIX."phrase WHERE (varname LIKE '%award%' OR varname LIKE 'setting_aw%') AND languageid = 0");
}

// NEW INSTALL CODE
if ($installed_version == null) {

echo "Adding Awards Tables

";
$db->query_write("CREATE TABLE " . TABLE_PREFIX . "award (
award_id smallint(5) unsigned NOT NULL auto_increment,
award_cat_id smallint(5) NOT NULL default '1',
award_name varchar(50) NOT NULL default '',
award_desc varchar(250) NOT NULL default '',
award_icon_url varchar(250) NOT NULL default '',
award_img_url varchar(225) NOT NULL default '',
award_displayorder smallint(5) NOT NULL default '0',
PRIMARY KEY (award_id)
) TYPE=MyISAM
");
echo "Added Table - award
";

$db->query_write("CREATE TABLE " . TABLE_PREFIX . "award_user (
issue_id smallint(5) NOT NULL auto_increment,
award_id smallint(5) NOT NULL default '0',
userid int(10) NOT NULL default '0',
issue_reason varchar(255) NOT NULL default '',
issue_time int(10) NOT NULL default '0',
PRIMARY KEY (issue_id)
) TYPE=MyISAM
");
echo "Added Table - award_user
";

$db->query_write("CREATE TABLE " . TABLE_PREFIX . "award_cat (
award_cat_id mediumint(8) unsigned NOT NULL auto_increment,
award_cat_title varchar(100) NOT NULL default '',
award_cat_desc varchar(250) NOT NULL default '',
award_cat_displayorder mediumint(8) unsigned NOT NULL default '0',
award_cat_parentid mediumint(8) NOT NULL default '-1',
PRIMARY KEY (award_cat_id),
KEY award_cat_order (award_cat_displayorder)
) TYPE=MyISAM
");
echo "Added Table - award_cat
";

$db->query_write("
INSERT INTO " . TABLE_PREFIX . "award_cat
(award_cat_id, award_cat_title, award_cat_desc, award_cat_displayorder, award_cat_parentid)
VALUES (1, 'Default', 'Default category', 1, -1)
");
echo "Inserted Default Catergory to table - award_cat
";

$db->query_write("
INSERT INTO " . TABLE_PREFIX . "award
(award_id, award_cat_id, award_name, award_desc, award_icon_url, award_img_url, award_displayorder)
VALUES (1, 1, 'Default Medal', 'This is a default medal', '". $vbulletin->options['bburl'] ."/images/medals/medal-blue.gif','". $vbulletin->options['bburl'] ."/images/medals/medal-blue-gold.gif', 1)
");
echo "Inserted Default Award to table - award
";

}

$db->reporterror = 1;



Uninstall Code $db->reporterror = 0;

$db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "award");
echo "Removed table - award
";
$db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "award_user");
echo "Removed table - award_user
";
$db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "award_cat");
echo "Removed table - award_cat
";

echo "
Tables Removed Successfully
";
echo "
";

$db->reporterror = 1;



Version 2.1.0


Install Code $db->reporterror = 0;

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "award ADD award_allowrequest TINYINT( 1 ) DEFAULT 1 NOT NULL,ADD award_active TINYINT( 1 ) DEFAULT 1 NOT NULL");
echo "Alter table - award
";

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "usergroup ADD COLUMN awardpermissions INT UNSIGNED NOT NULL DEFAULT '1'");
echo "Alter table - usergroup
";


echo "
Tables Altered Successfully
";
echo "
";

$db->reporterror = 1;

// Rebuild Bitfields
require_once(DIR . '/includes/class_bitfield_builder.php');
vB_Bitfield_Builder::save($db);
build_forum_permissions();


Uninstall Code $db->reporterror = 0;
// drop the extra columns needed too
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "usergroup DROP COLUMN awardpermissions");
// Rebuild Bitfields
require_once(DIR . '/includes/class_bitfield_builder.php');
vB_Bitfield_Builder::save($db);
build_forum_permissions();
$db->reporterror = 1;


Version 2.1.3


Install Code $db->reporterror = 0;
$db->query_write("ALTER TABLE `award_user` CHANGE `issue_reason` `issue_reason` MEDIUMTEXT NOT NULL");
$db->reporterror = 1;



Version 2.1.4


Install Code $db->reporterror = 0;
$db->query_write("ALTER TABLE `award` CHANGE `award_desc` `award_desc` TEXT NOT NULL");
$db->query_write("ALTER TABLE `award_user` CHANGE `issue_reason` `issue_reason` TEXT NOT NULL");
$db->reporterror = 1;