BF Quiz upgrade v1.0 to v1.1

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);

 

 

Try our software on your own website to see if it will suit your needs....yours FREE