Totally Zenned
- Join Date:
- Oct 2007
- Location:
- Emporia, Kansas
- Posts:
- 1,729
- Plugin Contributions:
- 0
wishlists 0.6
sweetikins:
I tried to install via zen but it gave me errors, so i uninstalled and then tried via mysql and again didnt work.
When you say "If you have a prefix (like zen1_nameoftable) then you need to insert that into the installer." where do i place the prefix :)
I hope I got all of them
well, are you using version09?
if so then place the prefix where in red--just remove the redtext and enter the prefix for your tables...
WishList v0.8 SQL Load for MySQL databases
-- CREATE Wish list CONFIGURATION GROUP --
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM prefix-here_configuration_group
WHERE configuration_group_title= 'Wish list';
DELETE FROM prefix-here_configuration WHERE configuration_group_id = @t4;
DELETE FROM prefix-here_configuration_group WHERE configuration_group_id = @t4;
INSERT INTO prefix-here_configuration_group VALUES (NULL, 'Wish list', 'Settings for Wish list', '110', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM prefix-here_configuration_group
WHERE configuration_group_title= 'Wish list';
INSERT INTO prefix-here_configuration VALUES (NULL, 'Wishlist Module Switch', 'UN_DB_MODULE_WISHLISTS_ENABLED', 'true', 'Set this option true or false to enable or disable the wishlist', @t4, 710, now(), now(), NULL, "zen_cfg_select_option(array('true', 'false'),");
INSERT INTO prefix-here_configuration VALUES (NULL, 'Wishlist sidebox header link', 'UN_DB_SIDEBOX_LINK_HEADER', 'true', 'Set this option true or false to make the sidebox header a link to the wishlist page.', @t4, 711, now(), now(), NULL, "zen_cfg_select_option(array('true', 'false'),");
INSERT INTO prefix-here_configuration VALUES (NULL, 'Wishlist allow multiple lists', 'UN_DB_ALLOW_MULTIPLE_WISHLISTS', 'true', 'Set this option true or false to allow for more than 1 wishlist', @t4, 712, now(), now(), NULL, "zen_cfg_select_option(array('true', 'false'),");
INSERT INTO prefix-here_configuration VALUES (NULL, 'Wishlist display category filter', 'UN_DB_DISPLAY_CATEGORY_FILTER', 'false', 'Set this option true or false to enable a category filter', @t4, 713, now(), now(), NULL, "zen_cfg_select_option(array('true', 'false'),");
INSERT INTO prefix-here_configuration VALUES (NULL, 'Wishlist default name', 'DEFAULT_WISHLIST_NAME', 'Default', 'Enter the name you want to be assigned to the initial wishlist.', @t4, 714, now(), now(), NULL, NULL);
INSERT INTO prefix-here_configuration VALUES (NULL, 'Wishlist show list after product addition', 'DISPLAY_WISHLIST', 'false', 'Set this option true or false to show the wishlist after a product was added to the wishlist', @t4, 715, now(), now(), NULL, "zen_cfg_select_option(array('true', 'false'),");
INSERT INTO prefix-here_configuration VALUES (NULL, 'Wishlist display max items in extended view', 'UN_MAX_DISPLAY_EXTENDED', '10', 'Enter the maximum amount of products you want to show in extended view.<br />default = 10', @t4, 716, now(), now(), NULL, NULL);
INSERT INTO prefix-here_configuration VALUES (NULL, 'Wishlist display max items in compact view', 'UN_MAX_DISPLAY_COMPACT', '20', 'Enter the maximum amount of products you want to show in extended view.<br />default = 20', @t4, 717, now(), now(), NULL, NULL);
INSERT INTO prefix-here_configuration VALUES (NULL, 'Wishlist default view Switch', 'UN_DEFAULT_LIST_VIEW', 'extended', 'Set the default view of the list to compact or extended view', @t4, 718, now(), now(), NULL, "zen_cfg_select_option(array('compact', 'extended'),");
INSERT INTO prefix-here_configuration VALUES (NULL, 'Wishlist allow multiple products to cart', 'UN_DB_ALLOW_MULTIPLE_PRODUCTS_CART_COMPACT', 'false', 'Set this option true or false to allow multiple products to be moved in the cart via checkboxes in compact view', @t4, 719, now(), now(), NULL, "zen_cfg_select_option(array('true', 'false'),");
--------------------------------------------------------
Table structure for table prefix-here_un_wishlists
avoid data loss when reinstall (this will give a table exists error)
if you want the table to be removed, then reinstalled; uncomment line below
#DROP TABLE IF EXISTS prefix-here_un_wishlists;
CREATE TABLE IF NOT EXISTS prefix-here_un_wishlists (
id int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL default '0',
created datetime NOT NULL default '0000-00-00 00:00:00',
modified datetime NOT NULL default '0000-00-00 00:00:00',
name varchar(255) default NULL,
comment varchar(255) default NULL,
default_status tinyint(1) NOT NULL default '0',
public_status tinyint(1) NOT NULL default '1',
PRIMARY KEY (id)
) TYPE=MyISAM;
INSERT INTO prefix-here_un_wishlists VALUES (1, 0, now(), now(), 'donotuse', 'donotuse', 0, 0);
--------------------------------------------------------
#April 2011 v0.8 added column
#added column for attributes, if you need to just add the column to an existing table use:
#alter table prefix-here_un_products_to_wishlists add column attributes VARCHAR(255);
#in the sql patch tool in zen cart
Table structure for table prefix-here_un_products_to_wishlists
avoid data loss when reinstall (this will give a table exists error)
if you want the table to be removed, then reinstalled; uncomment line below
#DROP TABLE IF EXISTS prefix-here_un_products_to_wishlists;
CREATE TABLE IF NOT EXISTS prefix-here_un_products_to_wishlists (
products_id int(11) NOT NULL default '0',
un_wishlists_id int(11) NOT NULL default '0',
created datetime NOT NULL default '0000-00-00 00:00:00',
modified datetime NOT NULL default '0000-00-00 00:00:00',
quantity int(2) NOT NULL default '1',
priority int(1) NOT NULL default '2',
comment varchar(255) default NULL,
attributes varchar(255) default NULL,
PRIMARY KEY (products_id,un_wishlists_id)
) TYPE=MyISAM;