[powerbook]

Sorry only realized that after I posted..

Originally Posted by bananalive

Everything in installcode execs on product install and everything in uninstall execs on product uninstall

<code version="2.4.2.1">
			<installcode><![CDATA[
$vbulletin->db->query_write("
  CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladders` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `noplayers` int(3) NOT NULL,
  `status` int(3) NOT NULL,
  `cr_userid` int(10) NOT NULL,
  `cr_username` varchar(100) NOT NULL,
  `cr_time` int(10) NOT NULL,
  `cr_ip` varchar(100) NOT NULL,
  `ed_userid` int(10) NOT NULL,
  `ed_username` varchar(100) NOT NULL,
  `ed_time` int(10) NOT NULL,
  `ed_ip` varchar(50) NOT NULL,
  `threadid` int(10) NOT NULL,
  `views` int(10) NOT NULL default '0',
  `winpoints` int(10) NOT NULL default '2',
  `drawpoints` int(10) NOT NULL default '1',
  `losepoints` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
$vbulletin->db->query_write("
  CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladder_games` (
  `id` int(11) NOT NULL auto_increment,
  `u` int(10) NOT NULL,
  `u2` int(10) NOT NULL,
  `time` int(10) NOT NULL,
  `accepted` int(10) NOT NULL,
  `lid` int(11) NOT NULL,
  `score_u` int(20) NOT NULL,
  `score_u2` int(20) NOT NULL,
  `agree_u` int(10) NOT NULL,
  `agree_u2` int(10) NOT NULL,
  `finished` int(10) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
$vbulletin->db->query_write("
  CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladder_players` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(10) NOT NULL,
  `username` varchar(100) NOT NULL,
  `lid` int(11) NOT NULL,
  `time` int(10) NOT NULL,
  `ip` varchar(100) NOT NULL,
  `wins` int(10) NOT NULL,
  `draws` int(10) NOT NULL,
  `loses` int(10) NOT NULL,
  `challenges` int(10) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
]]></installcode>
			<uninstallcode><![CDATA[
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladders;
");
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_games;
");
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_players;
");
$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."usergroup DROP COLUMN ladderpermissions;");
]]></uninstallcode>
		</code>