We welcome Mambo 4.5.1 stable! Finally the best Mambo ever has been
released. But as each new version has brought changes for
mambo-phpShop's functionality it has happened again: The Component
Installer has
been changed and now it refuses to install the mambo-phpShop component
"over" an existing installation of mambo-phpShop stating "another
component is already using this directory".
So my "HOWTO Upgrade from 1.1 to 1.2" is out-of-date.
You'll find some hints on upgrading in the forums. One "hard" way is described in the >Read More< part.
btw: I just want to let you know that my Developer Notebook needs a new
BIOS. :-( The development of mambo-phpShop will have to wait until the
notebook is back from the Repair Center. NEVER flash your Notebooks'
BIOS with an incompatible BIOS version! Now I'm smarter.
This will surely delay the release schedule of mambo-phpShop RC1 /
stable. But I think mambo-phpShop can go stable in October 2004.
The hard way of Upgrading is to
backup the mos_users and pshop_* database tables and your shop_image
directory. Then install mambo-phpShop 1.2 beta3 in Mambo 4.5.1 and
re-import the database structure and the shop_image directory. Finally
run the SQL Upgrade Script. since Mambo 4.5.1 has no built-in Database Manager you can use com_phpmyadmin. Just copy and paste the following SQL queries:
ALTER TABLE `jos_pshop_shopper_group` ADD `default` TINYINT( 1 ) DEFAULT '0' NOT NULL ;
CREATE TABLE `jos_pshop_product_reviews` (
`product_id` varchar(255) NOT NULL default '',
`comment` text NOT NULL,
`userid` int(11) NOT NULL default '0',
`time` int(11) NOT NULL default '0',
`user_rating` tinyint(1) NOT NULL default '0',
`review_ok` int(11) NOT NULL default '0',
`review_votes` int(11) NOT NULL default '0'
) ENGINE=MyISAM;
CREATE TABLE `jos_pshop_product_votes` (
`product_id` int(255) NOT NULL default '0',
`votes` text NOT NULL,
`allvotes` int(11) NOT NULL default '0',
`rating` tinyint(1) NOT NULL default '0',
`lastip` varchar(50) NOT NULL default '0'
) ENGINE=MyISAM;
ALTER TABLE `jos_pshop_category` ADD `category_browsepage` VARCHAR( 255 ) DEFAULT 'browse_1' NOT NULL AFTER `mdate` ;
ALTER TABLE `jos_pshop_category` ADD `products_per_row` TINYINT( 2 ) DEFAULT '1' NOT NULL AFTER `category_browsepage` ;
ALTER TABLE `jos_pshop_csv` ADD `csv_manufacturer_id` INT( 2 ) DEFAULT NULL;
UPDATE `jos_pshop_csv` SET csv_manufacturer_id='19';
ALTER TABLE `jos_pshop_payment_method` ADD `payment_class` VARCHAR( 50 ) NOT NULL AFTER `payment_method_name` ;
ALTER TABLE `jos_pshop_payment_method` ADD `payment_enabled` CHAR( 1 ) DEFAULT 'N' NOT NULL ;
ALTER TABLE `jos_pshop_payment_method` ADD `accepted_creditcards` VARCHAR( 128 ) NOT NULL ;
ALTER TABLE `jos_pshop_payment_method` ADD `payment_extrainfo` TEXT NOT NULL ;
INSERT INTO `jos_pshop_payment_method` VALUES ('', 1,
'NEW_Authorize.net', 'ps_authorize', 5, '0.00', 0, 'AN', 'Y', 0, 'N',
'1,2,6,7,', '');
INSERT INTO `jos_pshop_payment_method` VALUES ('', 1, 'NEW_PayPal',
'ps_paypal', 5, '0.00', 0, 'PP', 'P', 0, 'N', '', '<form
action="https://www.paypal.com/cgi-bin/webscr" method="post"
target="_blank">\r\n<input type="image" name="submit"
src="http://images.paypal.com/images/x-click-but6.gif" border="0"
alt="Make payments with PayPal, it's fast, free, and
secure!">\r\n<input type="hidden" name="cmd" value="_xclick"
/>\r\n<input type="hidden" name="business" value="<?php echo
PAYPAL_EMAIL ?>" />\r\n<input type="hidden"
name="receiver_email" value="<?php echo PAYPAL_EMAIL ?>"
/>\r\n<input type="hidden" name="item_name" value="Order Nr.
<?php $db->p("order_id") ?>" />\r\n<input type="hidden"
name="order_id" value="<?php $db->p("order_id") ?>"
/>\r\n<input type="hidden" name="invoice" value="<?php
$db->p("order_number") ?>" />\r\n<input type="hidden"
name="amount" value="<?php printf("%.2f",
$db->f("order_total"))?>" />\r\n<input type="hidden"
name="currency_code" value="<?php echo $_SESSION['vendor_currency']
?>" />\r\n<input type="hidden" name="image_url"
value="<?php echo $vendor_image_url ?>" />\r\n<input
type="hidden" name="return" value="<?php echo SECUREURL
."index.php?option=com_phpshop&page=checkout.result&order_id=".$db->f("order_id")
?>" />\r\n<input type="hidden" name="notify_url"
value="<?php echo SECUREURL
."administrator/components/com_phpshop/notify.php" ?>"
/>\r\n<input type="hidden" name="cancel_return" value="<?php
echo SECUREURL ."index.php" ?>" />\r\n<input type="hidden"
name="undefined_quantity" value="0" />\r\n<input type="hidden"
name="mrb" value="NRUBJXESJTY24" />\r\n<input type="hidden"
name="no_shipping" value="1" />\r\n<input type="hidden"
name="no_note" value="1" />\r\n</form>');
INSERT INTO `jos_pshop_payment_method` VALUES ('', 1,
'NEW_PayMate', 'ps_paymate', 5, '0.00', 0, 'PM', 'P', 0, 'N', '',
'<script language="javascript">\r\nfunction
openExpress(){\r\n var url =
'https://www.paymate.com.au/PayMate/ExpressPayment?mid=<?php echo
PAYMATE_USERNAME."&amt=".$db->f("order_total")."¤cy=".$_SESSION['vendor_currency']."&ref=".$db->f("order_id")."&pmt_sender_email=".$dbbt->f("email");?>'\r\n
var newWin = window.open(url, 'wizard',
'height=580,width=500,scrollbars=1,toolbar=no');\r\n
self.name = 'parent';\r\n
newWin.focus();\r\n}\r\n</script>\r\n<div
align="center">\r\n<p>\r\n<a
href="javascript:openExpress();">\r\n<img
src="https://www.paymate.com.au/images/paymate-PE-payment-88x31.gif"
border="0" alt="Pay with Paymate Express"></a>\r\n<br
/>Pay with Paymate Express\r\n</p>\r\n</div>');
INSERT INTO `jos_pshop_payment_method` VALUES ('', 1,
'NEW_WorldPay', 'ps_worldpay', 5, '0.00', 0, 'WP', 'P', 0, 'N', '',
'<form action="https://select.worldpay.com/wcc/purchase"
method="post">\r\n<input type="hidden" name="instId"
value="<?php echo WORLDPAY_INST_ID ?>" />\r\n<input
type="hidden" name="cartId" value="<?php echo $db->f("order_id")
?>" />\r\n<input type="hidden" name="amount" value="<?php
echo $db->f("order_total") ?>" />\r\n<input type="hidden"
name="currency" value="<?php echo $_SESSION['vendor_currency']
?>" />\r\n<input type="hidden" name="desc" value=""
/>\r\n<input type="hidden" name="email" value="<?php
$dbbt->p("email"); ?>" />\r\n<input type="image"
scr="http://www.ecommercetemplates.com/images/worldpay.gif"
alt="WorldPay" />\r\n</form>');
INSERT INTO `jos_pshop_payment_method` VALUES ('', 1,
'NEW_2Checkout', 'ps_twocheckout', 5, '0.00', 0, '2CO', 'Y', 0, 'N',
'1,2,3,', '');
ALTER TABLE `jos_pshop_order_payment` ADD
`order_payment_code` VARCHAR( 30 ) NOT NULL AFTER `payment_method_id` ;
CREATE TABLE `jos_pshop_creditcard` (
`creditcard_id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`vendor_id` INT( 11 ) NOT NULL,
`creditcard_name` VARCHAR( 70 ) NOT NULL ,
`creditcard_code` VARCHAR( 30 ) NOT NULL ,
PRIMARY KEY ( `creditcard_id` ));
INSERT INTO `jos_pshop_creditcard` VALUES (1, 1, 'Visa', 'VISA');
INSERT INTO `jos_pshop_creditcard` VALUES (2, 1, 'MasterCard', 'MC');
INSERT INTO `jos_pshop_creditcard` VALUES (3, 1, 'American Express', 'amex');
INSERT INTO `jos_pshop_creditcard` VALUES (4, 1, 'Discover Card', 'discover');
INSERT INTO `jos_pshop_creditcard` VALUES (5, 1, 'Diners Club', 'diners');
INSERT INTO `jos_pshop_creditcard` VALUES (6, 1, 'JCB', 'jcb');
INSERT INTO `jos_pshop_creditcard` VALUES (7, 1, 'Australian Bankcard', 'australian_bc');
INSERT INTO `jos_pshop_function` VALUES ('', 7,
'addReview', 'ps_reviews', 'process_review', 'This lets the user add a
review and rating to a product.', 'admin,storeadmin,shopper,demo');
INSERT INTO `jos_pshop_function` VALUES ('', '2',
'publishProduct', 'ps_product', 'product_publish', 'Changes the
product_publish field, so that a product can be published or
unpublished easily.', 'admin,storeadmin');
INSERT INTO `jos_pshop_function` VALUES ('', '2',
'export_csv', 'ps_csv', 'export_csv', 'This function exports all
relevant product data to CSV.', 'admin,storeadmin');
INSERT INTO `jos_pshop_function` VALUES ('', '8',
'creditcardAdd', 'ps_creditcard', 'add', 'Adds a Credit Card entry.',
'admin,storeadmin');
INSERT INTO `jos_pshop_function` VALUES ('', '8',
'creditcardUpdate', 'ps_creditcard', 'update', 'Updates a Credit Card
entry.', 'admin,storeadmin');
INSERT INTO `jos_pshop_function` VALUES ('', '8',
'creditcardDelete', 'ps_creditcard', 'delete', 'Deletes a Credit Card
entry.', 'admin,storeadmin');
Upgrading to Mambo 4.5.1 & mambo-phpShop 1.2 beta3
- Details
- Written by: soeren
- Category: Latest News
- Hits: 22565