#
# Upgrade script: Marketplace 1.3.1 to Marketplace 1.4.0
#
# Use a mysql-client of your choice ( I recommend 'mysql')
#
# Please make a backup of your database before you start!!!
#
# Also, please backup changes in your language file i.E. the rules
#
# Author: Achim Fischer
#


# NOTE: *** If you use table-prefixes, please add the to the table names ***



# some new fields in configuration table
ALTER TABLE `marketplace_config`
	ADD COLUMN `company` VARCHAR(100) AFTER `use_primezillaforcontact`,
	ADD COLUMN `company_url` VARCHAR(100) AFTER `company`,
	ADD COLUMN `author` VARCHAR(100) AFTER `company_url`,
	ADD COLUMN `extension` VARCHAR(100) AFTER `author`,
	ADD COLUMN `version` VARCHAR(100) AFTER `extension`,
	ADD COLUMN `show_recent5` TINYINT(1) DEFAULT 1 AFTER `version`,
	ADD COLUMN `use_price` TINYINT(1) DEFAULT 1 AFTER `show_recent5`,
	ADD COLUMN `rss_syndication` TINYINT(1) DEFAULT 0 AFTER `use_price`,
	ADD COLUMN `rss_count` INTEGER DEFAULT 20 AFTER `rss_syndication`;


# not needed anymore
ALTER TABLE `marketplace_config` DROP COLUMN `admin_userid`;



# add some version information - going to be used in future versions for upgrading
UPDATE `marketplace_config` SET company = 'Codingfish Limited';
UPDATE `marketplace_config` SET company_url = 'www.yourdomain.com';
UPDATE `marketplace_config` SET author = 'Achim Fischer';
UPDATE `marketplace_config` SET extension = 'Marketplace';
UPDATE `marketplace_config` SET version = '1.4.0';



# create table for the new user manager
CREATE TABLE IF NOT EXISTS `marketplace_users` (
	`id`						INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
	`userid`					INTEGER UNSIGNED NOT NULL,
	`isBlocked`				TINYINT(1) DEFAULT 0,
	`isAdmin`				TINYINT(1) DEFAULT 0,
	`isModerator`			TINYINT(1) DEFAULT 0,
	`categories`			VARCHAR(200) DEFAULT '',
	`flag_top`				TINYINT(1) DEFAULT 0,
	`flag_featured` 		TINYINT(1) DEFAULT 0,
	`flag_commercial` 	TINYINT(1) DEFAULT 0,
	`date_begin` 			DATE DEFAULT NULL,
	`date_end` 			DATE DEFAULT NULL,
	`published`				TINYINT(1) DEFAULT 0,

	PRIMARY KEY  (`id`),
		KEY `marketplace_users_userid` (`userid`),
		KEY `marketplace_users_isBlocked` (`isBlocked`),
		KEY `marketplace_users_isAdmin` (`isAdmin`),
		KEY `marketplace_users_isModerator` (`isModerator`),
		KEY `marketplace_users_date_begin` (`date_begin`),
		KEY `marketplace_users_date_end` (`date_end`)
) TYPE=MyISAM;






# select id of your Marketplace and write it down
# you have to put it in the next update and insert Statements. Replace  *MYID* with your selected id.
SELECT id FROM components WHERE name= 'Marketplace';


# some nifty menu icons
UPDATE components SET admin_menu_img = 'js/ThemeOffice/home.png' WHERE id='*MYID*';
UPDATE components SET admin_menu_img = 'js/ThemeOffice/config.png' WHERE parent='*MYID*' AND name = 'Configuration';
UPDATE components SET admin_menu_img = 'js/ThemeOffice/module.png' WHERE parent='*MYID*' AND name = 'Type Manager';
UPDATE components SET admin_menu_img = 'js/ThemeOffice/categories.png' WHERE parent='*MYID*' AND name = 'Category Manager';
UPDATE components SET admin_menu_img = 'js/ThemeOffice/media.png' WHERE parent='*MYID*' AND name = 'Ad Manager';


# the 2 new backend menu items
INSERT INTO `components`
	( `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`)
		VALUES
	( 'User Manager', '', 0, *MYID*, 'option=com_marketplace&act=users', 'User Manager', 'com_marketplace', 4, 'js/ThemeOffice/users.png', 0, '');

INSERT INTO `components`
	( `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`)
		VALUES
	( 'About', '', 0, *MYID*, 'option=com_marketplace&act=about', 'About', 'com_marketplace', 5, 'js/ThemeOffice/credits.png', 0, '');




Now copy the files in the zipfile to your server

The following files go in ./components/com_marketplace

	write_ad.php
	delete_ad.php
	footer.php
	joomfish/marketplace_ads.xml
	joomfish/marketplace_categories.xml
	joomfish/marketplace_types.xml
	jscalendar/calendar.js
	jscalendar/calendar-en.js
	jscalendar/calendar-setup.js
	jscalendar/calendar-system.css
	language/english.php
	language/dutch.php
	language/finnish.php
	language/german.php
	language/germani.php
	marketplace.php
	marketplace.css
	recent5.php
	show_ad.php
	show_category.php
	show_index.php
	show_rules.php
	topmenu.php




The following files go in ./administrator/components/com_marketplace

	admin.marketplace.php
	admin.marketplace.html.php
	marketplace.class.php
	toolbar.marketplace.php
	toolbar.marketplace.html.php
	LICENSE.txt




That's it :-)

Achim Fischer



