WishList v0.4 -- v1.3.7 compatible

[MrSpiffy]

edit the table names in /Admin/includes/extra_datafiles/un_database_tables.php in include the table prefix. In my case it was "zen_".

You're also going to need to do the same thing to ./includes/extra_datafiles/un_database_tables.php

[MrSpiffy]

MAJOR problems with this mod. I just realized that the only list that functions correctly is the default list. Does anyone else experience these problems?

1. The delete buttons for product doesn't work in another list, it simply takes me to my default without deleting the item.

2. When ever I try to add an item to the wishlist it will add the item to my cart.

Any help or insight appreciated.

I think the quick and dirty solution is to not allow users multiple wish lists. If you'd like to limit each registered user to one wishlist, set 'UN_ALLOW_MULTIPLE_WISHLISTS' to 'false' in the file 'includes/languages/english/extra_definitions/un_defines.php'

[MrSpiffy]

Okay, I fixed a problem with the compact view on version .05 in firefox.

If your compact view table has a big gap in it under the table heading and before the product listing, do the following.

edit

./includes/templates/template_default/un_wishlist/tpl_un_wishlist_s.php


and move the hidden inputs out of the table.

So look for this:

<!-- product listing -->
<table border="0" cellspacing="0" class="productlist">

        <tr class="heading">

        <?php echo $oWishlist->getTableHeader(); ?>
        </tr>

<?php
if ($listing_split->number_of_rows > 0) {
        $rows = 0;
        $products = $db->Execute($listing_split->sql_query);
        while (!$products->EOF) {
                if ( $rows & 1 ) {
                        $tdclass = 'even';
                } else {
                        $tdclass = 'odd';
                }
?>

        <tr>
<input type="hidden" name="products_id[]" value="<?php echo $products->fields['products_id']; ?>" />
<input type="hidden" name="wishlist_quantity[]" value="<?php echo $products->fields['quantity']; ?>" />
<input type="hidden" name="comment[]" value="<?php echo $products->fields['comment']; ?>" />

        <?php echo $oWishlist->getTableRow($tdclass, $products); ?>

        </tr>
                <?php $rows++; ?>
                <?php $products->MoveNext(); ?>
        <?php } // end while products ?>

<?php } else { ?>
        <tr><td colspan="99"><?php echo UN_TEXT_NO_PRODUCTS; ?></td></tr>

<?php } ?>
</table>
<!-- end product listing -->

and set it like this:

<!-- product listing -->
<table border="0" cellspacing="0" class="productlist">

        <tr class="heading">

        <?php echo $oWishlist->getTableHeader(); ?>
        </tr>

<?php
if ($listing_split->number_of_rows > 0) {
        $rows = 0;
        $products = $db->Execute($listing_split->sql_query);
        while (!$products->EOF) {
                if ( $rows & 1 ) {
                        $tdclass = 'even';
                } else {
                        $tdclass = 'odd';
                }
?>

        <tr>

        <?php echo $oWishlist->getTableRow($tdclass, $products); ?>

        </tr>
                <?php $rows++; ?>
                <?php $products->MoveNext(); ?>
        <?php } // end while products ?>

<?php } else { ?>
        <tr><td colspan="99"><?php echo UN_TEXT_NO_PRODUCTS; ?></td></tr>

<?php } ?>
</table>
<input type="hidden" name="products_id[]" value="<?php echo $products->fields['products_id']; ?>" />
<input type="hidden" name="wishlist_quantity[]" value="<?php echo $products->fields['quantity']; ?>" />
<input type="hidden" name="comment[]" value="<?php echo $products->fields['comment']; ?>" />
<!-- end product listing -->

[kappy1]

The problem I am having with wish list is if a product is out of stock add to cart button does not appear, which is correct, but the add to wish list still appears and the item can be added to the wish list then the customer can go to their wish list and add to product to the cart even if it is not in stock.

[MrSpiffy]

The problem I am having with wish list is if a product is out of stock add to cart button does not appear, which is correct, but the add to wish list still appears and the item can be added to the wish list then the customer can go to their wish list and add to product to the cart even if it is not in stock.

Does this happen if the items are disabled?

The quick solution then is to have your items disabled when they reach 0 qty. Config -> Stock -> Product status...

[kappy1]

Works ok if I disable but I also use the addon back to stock so it defeats the purpose of this addon. I have a number of customers that use the back to stock so my only alternative is to put wish list on the back burner until I or someone can figure out a fix...

[motoccnl]

Would it be possible to make a guest wish list, just like the zen cart shopping cart? So that the guest don't need to login for the use of the default wish list.

I've been looking around and tried to change the $_session['customers_id'] to a variable witch is $_session['customers_id'] when logged in, and zenid when not logged in. That didn't brake anything, but it didn't add anything either.

Is there somebody how can help me or point me in the right direction.

[markbolyard]

MAJOR problems with this mod. I just realized that the only list that functions correctly is the default list. Does anyone else experience these problems?

2. When ever I try to add an item to the wishlist it will add the item to my cart.

Any help or insight appreciated.

So I have this same issue and here is something I noticed.

In my tpl_product_info_display.php template, I added this code:

            <!--bof Wishlist button -->
            <?php echo ('<a href="' . zen_href_link(UN_FILENAME_WISHLIST, zen_get_all_get_params(array('action', 'products_id')) . 'products_id='.(int)$_GET['products_id'].'&action=un_add_wishlist') . '">' . zen_image_submit(UN_BUTTON_IMAGE_WISHLIST_ADD, UN_BUTTON_WISHLIST_ADD_ALT) . '</a>'); ?>
            <!--eof Wishlist button -->

next to my add to cart button. It appears exactly where I want it, however when you add to the wishlist, the item gets added to the cart too.

Now, in the readme, there is this code:

<?php 
// (un): start wishlist link
echo '<a href="' . zen_href_link(UN_FILENAME_WISHLIST, zen_get_all_get_params(array('action', 'products_id')) . 'products_id='.(int)$_GET['products_id'].'&action=un_add_wishlist') . '">' . UN_TEXT_ADD_WISHLIST . '</a>'; 
// (un): end wishlist link
?>

This is pretty much the same code, however instead of a image button, it display the text "Add to Wishlist". THIS WORKS and adds the item to the wishlist and NOT the cart.

So in either case, I can use both pcs of code, but if I use

zen_image_submit(UN_BUTTON_IMAGE_WISHLIST_ADD, UN_BUTTON_WISHLIST_ADD_ALT)

instead of

UN_TEXT_ADD_WISHLIST

it goes to the cart to. (So Image button adds item to cart, text link doesn't)

Next, I enabled the side column module, and that works as it should, but the code (when I view the source of the page) is different, and is in a <form>.

My guess is, using the image button option utilizes input fields of a form, and the store gets confused when the button is pushed and the item goes to both the cart and the wishlist. Is there a way I can just use <img src.....> in place of zen_image_submit(UN_BUTTON_IMAGE_WISHLIST_ADD, UN_BUTTON_WISHLIST_ADD_ALT)???

Any idea why this is. You can see my store here: http://joessecuritydepot.com (It's still in the works, but is active for testing purposes. Any help or suggestions you may have would be greatly appreciated. Thank you.

[nagelkruid]

Any idea why this is. You can see my store here: http://joessecuritydepot.com (It's still in the works, but is active for testing purposes. Any help or suggestions you may have would be greatly appreciated. Thank you.

i didn't see any wishlist, not even after creating account, did you remove it?
I like the cart item in the bar, would you mind telling me where or how you got it implemented? (use pm as probably off topic here, thanks)

[nagelkruid]

I dont know what else the problem could be... perhaps you may find it easier to install your zen cart without table prefixes and use the Wishlist with no table modifications.

first off, thanks for the mod, it needs some work but very nice setup.

I would recommend a code fix to address this issue.
The fix is actually pretty simple to address this issue to be compatible with whatever each shop has decided to use or not use a table_prefix.

For the SQL install file, this is perfectly fine if it is pasted in the "install SQL patch" option under "tools" in the admin section.
The patch tool will add the proper db_table_prefix if it is in use and it wil end up as <table_prefix>un_wishlists & <table_prefix>un_products_to_wishlists. If no prefix is used it will be present as un_wishlists & un_products_to_wishlists.
*only* when it used directly in sqladmin you will need to add the prefixes manually, but why would you... just use the sql patch tool for this.

The coding in both files: includes\extra_datafiles\un_database_tables.php AND <admin_folder>includes\extra_datafiles\un_database_tables.php needs to be adjusted to add the <table_prefix> if it has a value.
For this both files should be recoded like so:

define('UN_TABLE_WISHLISTS', DB_PREFIX . 'un_wishlists');
define('UN_TABLE_PRODUCTS_TO_WISHLISTS', DB_PREFIX . 'un_products_to_wishlists'); 

That should stop any table prefix related questions appearing in this thread