#
# Upgrade script: Marketplace 1.4.2 to Marketplace 1.4.5
#
# 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 ***



CREATE TABLE IF NOT EXISTS `marketplace_log_paypal` (
	`id`               	INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
	`item_number`      	INTEGER UNSIGNED NOT NULL,
	`item_name`        	VARCHAR(100) 	DEFAULT NULL,
	`payment_status`   	VARCHAR(100) 	DEFAULT NULL,
	`payment_amount`   	VARCHAR(100) 	DEFAULT NULL,
	`payment_currency` 	VARCHAR(10) 	DEFAULT NULL,
	`txn_id` 			VARCHAR(100) 	DEFAULT NULL,
	`receiver_email` 	VARCHAR(100) 	DEFAULT NULL,
	`payer_email` 		VARCHAR(100) 	DEFAULT NULL,
	`date_created`      DATE DEFAULT 	NULL,
	`time_created`      TIME DEFAULT 	NULL,
	PRIMARY KEY  (`id`),
		KEY `marketplace_log_paypal_item_number` (`item_number`),
		KEY `marketplace_log_paypal_payment_status` (`payment_status`),
		KEY `marketplace_log_paypal_payment_currency` (`payment_currency`),
		KEY `marketplace_log_paypal_date_created` (`date_created`),
		KEY `marketplace_log_paypal_time_created` (`time_created`)
) TYPE=MyISAM;



# new fields in the marketplace category table
ALTER TABLE `marketplace_categories`
    ADD COLUMN `use_paid_ads` TINYINT(1) DEFAULT '-1';


# new fields in the marketplace ads table
ALTER TABLE `marketplace_ads`
    ADD COLUMN `payment` TINYINT(1) DEFAULT 0;


# new fields in the marketplace config table
ALTER TABLE `marketplace_config`
    ADD COLUMN `show_container` TINYINT(1) DEFAULT 0,
    ADD COLUMN `use_top` TINYINT(1) DEFAULT 0,
    ADD COLUMN `use_featured` TINYINT(1) DEFAULT 0,
    ADD COLUMN `use_commercial` TINYINT(1) DEFAULT 0,
    ADD COLUMN `use_slimbox` TINYINT(1) DEFAULT 0,
    ADD COLUMN `include_mootools` TINYINT(1) DEFAULT 0,
    ADD COLUMN `include_slimbox` TINYINT(1) DEFAULT 0,
    ADD COLUMN `use_paid_ads` TINYINT(1) DEFAULT 0,
    ADD COLUMN `paid_ads_currency` VARCHAR(20) DEFAULT 'EUR',
    ADD COLUMN `paid_ads_price_basic` FLOAT( 9,2) DEFAULT 0,
    ADD COLUMN `paid_ads_price_top` FLOAT( 9,2) DEFAULT 0,
    ADD COLUMN `paid_ads_price_featured` FLOAT( 9,2) DEFAULT 0,
    ADD COLUMN `paid_ads_price_commercial` FLOAT( 9,2) DEFAULT 0,
    ADD COLUMN `use_offline_payment` TINYINT(1) DEFAULT 0,
    ADD COLUMN `offline_payment_text` TEXT,
    ADD COLUMN `use_paypal_payment` TINYINT(1) DEFAULT 0,
    ADD COLUMN `use_paypal_testmode` TINYINT(1) DEFAULT 0,
    ADD COLUMN `paypal_businessid` VARCHAR(100) DEFAULT 'YOURPAYPALID@YOURDOMAIN';



# 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.5';





Now copy the files in the zipfile to your server

The following files go in ./components/com_marketplace

# please note that some images have changed and some are new
# to make sure to get all, just replace all of them

	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/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
	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







