BF Auction Pro upgrade from v1.0 to v1.1.1

1. Extract files from com_bfauction_pro.zip

2. Copy entire contents of "admin" folder into /administrator/components/com_bfauction_pro/
   (overwrite existing files).

3. Copy entire contents (except css folder if you've customised style) of
   "component" folder into /components/com_bfauction_pro/
   (overwrite existing files).

   Note if using existing CSS file, add the new styles for
 .icon-32-new
 .icon-32-save
 .icon-32-cancel
 table.toolbar span

4. Copy com_bfauction_pro.xml into /administrator/components/com_bfauction_pro/
   (overwrite existing file)

5. Run the following mySQL commands in phpMyAdmin


ALTER TABLE `jos_bfauction_pro` ADD `productId` int(11),
 ADD  `onlineStore` varchar(20),
 ADD  `paypalEmail` varchar(150);


ALTER TABLE `jos_bfbid_pro` ADD  `email` varchar(255) NOT NULL default '';

CREATE TABLE `jos_bfauction_email` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `catid` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL, 
  `subject` varchar(255) NOT NULL,
  `description` text,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `checked_out` int(11) NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `published` tinyint(1) NOT NULL default '0',
  `ordering` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
);

SELECT @catid := max(id) from `jos_categories`;

INSERT INTO `jos_bfauction_email` (`id`, `catid`, `title`, `subject`, `description`, `date`, `checked_out`, `checked_out_time`, `published`, `ordering`) VALUES
(1, @catid, 'BidConfirm', 'Your bid is confirmed {itemtitle}', 'Thank you {username} for your bid of <strong>{currency}{bid}</strong> for {description}', '2010-05-10 03:07:53', 0, '0000-00-00 00:00:00', 1, 1),
(2, @catid, 'Outbid', 'You have been outbid on {itemtitle}', '<p>Unfortunately {username} you have been outbid for {description}.</p>\r\n<p> </p>\r\n<p>The auction for this item will end on {enddate}, so there may still be time to increase your bid.</p>', '2010-05-09 12:22:34', 0, '0000-00-00 00:00:00', 1, 2);


CREATE TABLE `jos_bfauction_access` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `catid` int(11) NOT NULL default '0',
  `username` varchar(255) NOT NULL default '',
  `uid` int(11), 
  `date` datetime NOT NULL default '0000-00-00 00:00:00', 
  `checked_out` int(11) NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `published` tinyint(1) NOT NULL default '0',
  `ordering` int(11) NOT NULL default '0', 
  PRIMARY KEY  (`id`)
);

 

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