#
# Upgrade script: Marketplace 1.4.5 to Marketplace 1.4.6
#
# 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 them to the table names ***



# new fields in the marketplace category table
ALTER TABLE `marketplace_categories`
	ADD COLUMN `image2` VARCHAR(250) AFTER `image`;

ALTER TABLE `marketplace_categories`
	ADD COLUMN `overwrite_paid_ads_price_basic` TINYINT(1) DEFAULT '0' AFTER `use_paid_ads`;
ALTER TABLE `marketplace_categories`
	ADD COLUMN `paid_ads_price_basic` FLOAT( 9,2) DEFAULT 0 AFTER `overwrite_paid_ads_price_basic`;

ALTER TABLE `marketplace_categories`
	ADD COLUMN `overwrite_paid_ads_price_top` TINYINT(1) DEFAULT '0' AFTER `paid_ads_price_basic`;
ALTER TABLE `marketplace_categories`
	ADD COLUMN `paid_ads_price_top` FLOAT( 9,2) DEFAULT 0 AFTER `overwrite_paid_ads_price_top`;

ALTER TABLE `marketplace_categories`
	ADD COLUMN `overwrite_paid_ads_price_featured` TINYINT(1) DEFAULT '0' AFTER `paid_ads_price_top`;
ALTER TABLE `marketplace_categories`
	ADD COLUMN `paid_ads_price_featured` FLOAT( 9,2) DEFAULT 0 AFTER `overwrite_paid_ads_price_featured`;

ALTER TABLE `marketplace_categories`
	ADD COLUMN `overwrite_paid_ads_price_commercial` TINYINT(1) DEFAULT '0' AFTER `paid_ads_price_featured`;
ALTER TABLE `marketplace_categories`
	ADD COLUMN `paid_ads_price_commercial` FLOAT( 9,2) DEFAULT 0 AFTER `overwrite_paid_ads_price_commercial`;

ALTER TABLE `marketplace_categories`
	ADD COLUMN `ad_default` TINYINT(1) DEFAULT '-1' AFTER `paid_ads_price_commercial`;



# new fields in the marketplace config table
ALTER TABLE `marketplace_config`
	ADD COLUMN `images_per_ad` INT NOT NULL DEFAULT 3 AFTER `ads_per_page`;

ALTER TABLE `marketplace_config`
	ADD COLUMN `image_columns` INT NOT NULL DEFAULT 1 AFTER `images_per_ad`;



# update version and set the new fields to default values
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 version     = '1.4.6';





Now copy the files in the zipfile to your server

The following files go in ./components/com_marketplace

# please note the new file router.php

	delete_ad.php
	footer.php
	images/categories/default.gif
	images/entries/dummy.gif
	images/system/codingfish.png
	images/system/deletead.gif
	images/system/editad.gif
	images/system/error.gif
	images/system/feed.gif
	images/system/home.gif
	images/system/information.gif
	images/system/myads.gif
	images/system/nopic.gif
	images/system/published.gif
	images/system/rules.gif
	images/system/search.gif
	images/system/success.gif
	images/system/unpublished.gif
	images/system/warning.gif
	images/system/writead.gif
	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/dutch.php
	language/english.php
	language/finnish.php
	language/french.php
	language/german.php
	language/germani.php
	language/greek.php
	language/italian.php
	language/romanian.php
	language/spanish.php
	language/turkish.php
	list.php
	marketplace.css
	marketplace.php
	mootools/mootools-release-1.11.js
	pagination.php
	recent5.php
	router.php
	rss.php
	search.php
	show_ad.php
	show_category.php
	show_index.php
	show_rules.php
	slimbox/css/closelabel.gif
	slimbox/css/loading.gif
	slimbox/css/nextlabel.gif
	slimbox/css/prevlabel.gif
	slimbox/css/slimbox.css
	slimbox/js/slimbox.js
	topmenu.php
	write_ad.php



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

	admin.marketplace.html.php
	admin.marketplace.php
	install.marketplace.php
	LICENSE.txt
	marketplace.class.php
	marketplace.xml
	toolbar.marketplace.html.php
	toolbar.marketplace.php
	uninstall.marketplace.php




That's it :-)



Achim Fischer

Codingfish Limited







