What was changed in the file: TYPE is no longer supported by the latest MySQL. TYPE has been replaced by ENGINE.
It now looks like this
$TABLE[] = "CREATE TABLE up_settings (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`value` longtext NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;";
$TABLE[] = "CREATE TABLE unrealportal (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`align` varchar(255) NOT NULL default '',
`show` int(11) NOT NULL default '1',
`order2` int(11) NOT NULL default '0',
`custblock_id` int(11) NOT NULL default '0',
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;";
$TABLE[] = "CREATE TABLE up_custblocks (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`html` text NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;";
$TABLE[] = "CREATE TABLE up_custcontent (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`html` text NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;";