If this is your first visit, check our documentation. To post, register or login.

wishlists 0.6

Started by nagelkruid on 17 Mar 2011, 9:51 AM · Views: 36,457

Results 161 to 180 of 236
11 Apr 2012, 9:39 AM
#161
darkangel avatar

darkangel

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;

11 Apr 2012, 9:56 AM
#162
sweetikins avatar

sweetikins

New Zenner

Join Date:
Feb 2009
Location:
Melbourne, Australia
Posts:
85
Plugin Contributions:
0

Re: wishlists 0.6

Thank you for getting back to me, but it seems it doesnt like me it is not working and i think with all these changes and trying to redo it and undo it is causing issues as it wont work at all now ughhh stupid thing LOL hopefully i vcan figure it out :smile:

DarkAngel:

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;

11 May 2012, 8:03 PM
#163
mvstudio avatar

mvstudio

Zen Follower

Join Date:
Apr 2008
Posts:
447
Plugin Contributions:
1

Re: wishlists 0.6

Hello,

I just received a PCI vulnerability alert, in regards to this mod. Apparently there is no form validation on the wishlist find form, so anyone can enter anything they want and the form throws a mysql error message, which according to McAfee is a no-no. Any way a form validation can be coded in?
Thanks!

M.Valenti
Contemporary Artist - Entrepreneur
http://www.manuelavalenti.com - http://www.byvalenti.com

2 Jun 2012, 8:01 PM
#164
johnboycr avatar

johnboycr

Zen Follower

Join Date:
Jan 2009
Posts:
201
Plugin Contributions:
2

Re: wishlists 0.6

I have recently begun trying to upgrade from ZC 1.3.8a to ZC 1.3.9h and have run into a LOT of problems, mostly with add on modules. A little history before I get into the problems with wishlist 0.9 . I am trying to make all of the modifications on my localhost server (apache running under Debian Linux on my PC). I have ZC 1.3.8a running, and all is well. The upgrade to 1.3.9h has not gone smoothly. Maybe because my Apache server is not running PHP 5.3 . ZC 1.3.9h runs but some add on mods don't work. And that is where we come to problems with wishlist 0.9 . After installing all of the code and running the mysql script, I can not see any product being added to my wishlist. I have made sure that wishlist is enable in the admin. But when I select a product to be added I am taken to the wishlist page and no product shows. What might I have done wrong, or better yet what might I not have done right?

Just a note: I have spent over two weeks trying to get the 1.3.9h upgrade to work and am about to say "the h--- with it". Seems to me that all of the security upgrades to 1.3.8a, plus some additional things I have done (the .htaccess files from 1.3.9h), are working well. I seem to be stopping a lot of hack attempts.

3 Jun 2012, 6:05 PM
#165
johnboycr avatar

johnboycr

Zen Follower

Join Date:
Jan 2009
Posts:
201
Plugin Contributions:
2

Re: wishlists 0.6

I finally got Wishlist 0.9 working on my localhost server. I had to delete the data base tables, re-install the code and re-run the mysql patch.

17 Jun 2012, 9:36 AM
#166
ashley5nc avatar

ashley5nc

New Zenner

Join Date:
Nov 2007
Posts:
16
Plugin Contributions:
0

Re: wishlists 0.6

Just installed and is exactly what I've been wanting for a long time! Works great. Thanks! Is there a way to reduce the space between the sort/view drop downs and the actual product listings in the wishlist? After I installed and tested I spent an hour in a tizzy trying to "fix" it because nothing was showing up when I added it.... all I needed have done was scroll down the page a little and would have seen there they sat right where they should be. It was just that that little bit of space made me think it was the bottom of the page and no products listed. Not the biggest of issues I know :-) And I'm sure most people will have enough sense to actually scroll down anyway!

Thanks!
Micky

17 Jun 2012, 4:26 PM
#167
jeking avatar

jeking

Totally Zenned

Join Date:
Oct 2005
Location:
Chicago, IL USA
Posts:
1,592
Plugin Contributions:
0

Re: wishlists 0.6

Do you have a url you can share?

Jim
Wheaton Website Services

17 Jun 2012, 4:38 PM
#168
ashley5nc avatar

ashley5nc

New Zenner

Join Date:
Nov 2007
Posts:
16
Plugin Contributions:
0

Re: wishlists 0.6

Yes, I'm still in the process of setting the store up. (I actually kinda killed my old site trying to upgrade to 1.5, no clue what I did, but knew I'd screw it and didn't fail in my expectations :-) So I just did a fresh install and decided to do a few mods I'd been wanting while I was at it.)

The address is http://www.sewsomethingspecial.com/shop/ (and is still in progress)
And this is the area I am trying to reduce:

Attachment 10647

17 Jun 2012, 4:38 PM
#169
ashley5nc avatar

ashley5nc

New Zenner

Join Date:
Nov 2007
Posts:
16
Plugin Contributions:
0

Re: wishlists 0.6

duplicate post

17 Jun 2012, 5:01 PM
#170
jeking avatar

jeking

Totally Zenned

Join Date:
Oct 2005
Location:
Chicago, IL USA
Posts:
1,592
Plugin Contributions:
0

Re: wishlists 0.6

It's a stylesheet setting. You'll want to edit stylesheet_footer_menu.css

Look for this line:
dl {margin: 0 0 3px 0;padding:0;clear:both;height:160px;width:100%;}/Adjust the height and width of the menu/

and change the 160 top something smaller.

Jim
Wheaton Website Services

17 Jun 2012, 5:11 PM
#171
ashley5nc avatar

ashley5nc

New Zenner

Join Date:
Nov 2007
Posts:
16
Plugin Contributions:
0

Re: wishlists 0.6

Thank you so much! That's got it.

3 Jul 2012, 3:26 PM
#172
schobook avatar

schobook

New Zenner

Join Date:
Jul 2012
Posts:
52
Plugin Contributions:
0

Re: wishlists 0.6

Where do I go to remove "Find a Friend's Wish List" from the options in the wishlist menu.

Thanks,

3 Jul 2012, 4:21 PM
#173
schobook avatar

schobook

New Zenner

Join Date:
Jul 2012
Posts:
52
Plugin Contributions:
0

Re: wishlists 0.6

I do have another question (won't let me edit my other post). How do I change the position of "the add to my wishlist" button?

11 Jul 2012, 9:49 PM
#174
mooncavecrystals avatar

mooncavecrystals

Zen Follower

Join Date:
Sep 2006
Posts:
455
Plugin Contributions:
0

Re: wishlists 0.6

I am reading all of this info and it is making me more flummoxed :) I installed the wishlist files today (for zen 1.3.9h). i tested it with the sidebox (yeah, I know it says not recommended, but I was testing), then decided to add the link at the header....I clicked on a product then clicked on wishlist.....It did not show the product. I know I am doing something wrong.....(even when i clicked "ADD to wishlist" on the sidebox, it did not add the product either). Maybe I am not understanding this.....code and stuff is not my thing, so I struggle easily.......I read the instructions but even after following, i do not see a place to add to wishlist........help!! please :(

11 Jul 2012, 9:55 PM
#175
mooncavecrystals avatar

mooncavecrystals

Zen Follower

Join Date:
Sep 2006
Posts:
455
Plugin Contributions:
0

Re: wishlists 0.6

that is what is happening to me! i cannot figure it out. I am not skilled at code or any such thing so do the best I can :)

25 Jul 2012, 11:54 PM
#176
soso838 avatar

soso838

Zen Follower

Join Date:
May 2012
Posts:
105
Plugin Contributions:
0

Re: wishlists 0.6

I try to install the wishlist09. but my Admin not accept the wishlist.sql, even I try to copy to it. how can I do, I am using zencart Ver1.5
and is anything I need to know to set it up. I really need this function
thanks

26 Jul 2012, 12:04 AM
#177
soso838 avatar

soso838

Zen Follower

Join Date:
May 2012
Posts:
105
Plugin Contributions:
0

Re: wishlists 0.6

add to last question. when I use Admin-->tool>install sql patch the warning shows
WARNING: An Error occurred, please refresh the page and try again.
is my zencart sql have problem or not compatable for this whishlist:shocking:

23 Oct 2012, 6:09 PM
#178
lackew avatar

lackew

Zen Follower

Join Date:
Aug 2009
Location:
Tampa Bay
Posts:
223
Plugin Contributions:
1

Re: wishlists 0.6

delia:

So the problem is that you have set up the button to have a value of yes when if it's a css, it has to have the value of your text.

The alternative is to add in a hidden input field so change your code on the product_info_display.php to

<!--bof Wishlist button --> <!--<br class="clearBoth" /> optional depending where the code is added--> <?php if (UN_MODULE_WISHLISTS_ENABLED) { if ( $_SESSION['customer_id'] ) { echo '<input type="hidden" name="wishlist" value="yes" />'; echo '<div id="productWishlistLink" class="buttonRow back">'; echo zen_image_submit(UN_BUTTON_IMAGE_WISHLIST_ADD, UN_BUTTON_WISHLIST_ADD_ALT); echo '</div>'; } else { echo '<div>'; echo UN_BOX_WISHLIST_LOGIN_TEXT; echo '</div>'; } } else {} ?> <!--eof Wishlist button -->

OMG it took a week to find this solution THANK YOU!!!

blessed be the day we make tomorrow a better yesterday

24 Oct 2012, 1:16 PM
#179
lackew avatar

lackew

Zen Follower

Join Date:
Aug 2009
Location:
Tampa Bay
Posts:
223
Plugin Contributions:
1

Re: wishlists 0.6

I hope some1 sees this!
I need to know how to comment out "UN_BOX_WISHLIST_LOGIN_TEXT" and have only the button showing at all times even if it take them to log in page??????????????

blessed be the day we make tomorrow a better yesterday

25 Oct 2012, 9:33 PM
#180
stevefriedman71 avatar

stevefriedman71

Zen Follower

Join Date:
Sep 2006
Posts:
269
Plugin Contributions:
0

Re: wishlists 0.6

i have it installed on 1.5.1 but i can't see it in the admin... is there an admin section for this addon?