|
1. Extract files from com_bfquiz.zip
2. Copy entire contents (except css folder if you've customised style) of "component" folder into /components/com_bfquiz/ (overwrite existing files).
3. Copy entire contents (except css folder if you've customised style) of "admin" folder into /administrator/components/com_bfquiz/ (overwrite existing files)
4. Copy com_bfquiz.xml into /administrator/components/com_bfquiz/ (overwrite existing file)
5. Run the following mySQL commands in PHPMyAdmin
ALTER TABLE `jos_bfquiz` CHANGE `score1` `score1` VARCHAR( 10 ) NOT NULL; ALTER TABLE `jos_bfquiz` CHANGE `score2` `score2` VARCHAR( 10 ) NOT NULL; ALTER TABLE `jos_bfquiz` CHANGE `score3` `score3` VARCHAR( 10 ) NOT NULL; ALTER TABLE `jos_bfquiz` CHANGE `score4` `score4` VARCHAR( 10 ) NOT NULL; ALTER TABLE `jos_bfquiz` CHANGE `score5` `score5` VARCHAR( 10 ) NOT NULL; ALTER TABLE `jos_bfquiz` CHANGE `score6` `score6` VARCHAR( 10 ) NOT NULL; ALTER TABLE `jos_bfquiz` CHANGE `score7` `score7` VARCHAR( 10 ) NOT NULL; ALTER TABLE `jos_bfquiz` CHANGE `score8` `score8` VARCHAR( 10 ) NOT NULL; ALTER TABLE `jos_bfquiz` CHANGE `score9` `score9` VARCHAR( 10 ) NOT NULL; ALTER TABLE `jos_bfquiz` CHANGE `score10` `score10` VARCHAR( 10 ) NOT NULL; ALTER TABLE `jos_bfquiz` CHANGE `score11` `score11` VARCHAR( 10 ) NOT NULL; ALTER TABLE `jos_bfquiz` CHANGE `score12` `score12` VARCHAR( 10 ) NOT NULL; ALTER TABLE `jos_bfquiz` CHANGE `score13` `score13` VARCHAR( 10 ) NOT NULL; ALTER TABLE `jos_bfquiz` CHANGE `score14` `score14` VARCHAR( 10 ) NOT NULL; ALTER TABLE `jos_bfquiz` CHANGE `score15` `score15` VARCHAR( 10 ) NOT NULL; ALTER TABLE `jos_bfquiz` CHANGE `score16` `score16` VARCHAR( 10 ) NOT NULL; ALTER TABLE `jos_bfquiz` CHANGE `score17` `score17` VARCHAR( 10 ) NOT NULL; ALTER TABLE `jos_bfquiz` CHANGE `score18` `score18` VARCHAR( 10 ) NOT NULL; ALTER TABLE `jos_bfquiz` CHANGE `score19` `score19` VARCHAR( 10 ) NOT NULL; ALTER TABLE `jos_bfquiz` CHANGE `score20` `score20` VARCHAR( 10 ) NOT NULL;
CREATE TABLE `jos_bfquiz_matrix` ( `id` int(11) unsigned NOT NULL auto_increment, `catid` int(11) NOT NULL default '0', `description` varchar(255) NOT NULL, `published` tinyint(1) NOT NULL default '0', `default` tinyint(1) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', `redirectURL` varchar(255) NOT NULL, `score1` varchar(10) NOT NULL, `score2` varchar(10) NOT NULL, `score3` varchar(10) NOT NULL, `score4` varchar(10) NOT NULL, `score5` varchar(10) NOT NULL, `condition1` varchar(10) NOT NULL, `condition2` varchar(10) NOT NULL, `condition3` varchar(10) NOT NULL, `condition4` varchar(10) NOT NULL, `condition5` varchar(10) NOT NULL, `qty1` int(11) NOT NULL, `qty2` int(11) NOT NULL, `qty3` int(11) NOT NULL, `qty4` int(11) NOT NULL, `qty5` int(11) NOT NULL, `operator1` varchar(10) NOT NULL, `operator2` varchar(10) NOT NULL, `operator3` varchar(10) NOT NULL, `operator4` varchar(10) NOT NULL, `operator5` varchar(10) NOT NULL, `exactMatch` varchar(255) NOT NULL, `resultText` text NOT NULL, PRIMARY KEY (`id`) );
SELECT @catid := id from `jos_components` where name="BF Quiz";
INSERT INTO `jos_components` (`name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`, `enabled`) VALUES ('ABCD Answer Matrix', 'option=com_bfquiz', 0, @catid,'option=com_bfquiz&controller=matrix&task=matrix', 'ABCD Answer Matrix', 'com_quiz', 5, 'js/ThemeOffice/component.png', 0, '', 1);
|