Wishlist

[dlcohenzc]

A reply to my own post about adding wish list link to product listing page. I was able to do this via AJAX: a link underneath 'sold out' items calls the wishlist AJAX module I wrote to add the product to wishlist, and to show confirmation box. The code that calls it is in includes/functions/functions_general.php zen_get_buy_now_button, in 'case' for sold out:

    	if (UN_MODULE_WISHLISTS_ENABLED) { 
          if ($_SESSION['customer_id']) {
            $return_button .= "<br /><a href='javascript:AddToWishlist($product_id);'>add to wish list</a>";
          }
        }

also added to templates/tpl_modules_product_listing.php, at end - assumes you have jquery in /ajax dir:

<script language="javascript">
if (!window.jQuery) 
{
  var jq = document.createElement('script'); jq.type = 'text/javascript';
  // Path to jquery.js file, eg. Google hosted version
  jq.src = '/ajax/jquery.js';
  document.getElementsByTagName('head')[0].appendChild(jq);
}
function AddToWishlist(product_id)
{
  var url = '/wishlist_ajax.php' + '?nocache=' + new Date().getTime() + '&product_id=' + product_id;
  $.get(url,'',AddToWishlistDone);
}
function AddToWishlistDone(data,status)
{
  alert(data);
}
</script>

Finally, this is the simple wishlist_ajax.php file in store home directory:

<?php
require('includes/application_top.php');
if (!$_SESSION['customer_id'])
{
  echo "Please login.";
  exit;
}
if (!isset($_GET['product_id']))
{
  echo "Invalid product.";
  exit;
}
$product_id = (int)$_GET['product_id'];
if (!$product_id)
{
  echo "Invalid product.";
  exit;
}
$data = $db->Execute("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = 1" );
$product_name = $data->fields['products_name'];
require_once(DIR_WS_CLASSES . 'wishlist_class.php');
$oWishlist = new un_wishlist($_SESSION['customer_id']);
$oWishlist->addProduct($product_id, array());
echo "$product_name added to Wish List";
?>

Pretty simple, works great. In action: www.capriflavors.com

[DarkAngel]

I don't see it at capri site...or am I looking in the wrong spot...which would not surprise me.

Attachment 14270

[Lackew]

Unfortunately Dark Angel I have attempted to uninstall several times deleting all files running SQL then using Dev Tool to query wish, wishlist & un_wish with nothing found (except in product template & english files). Cleared cache then logged in on IE, Chrome, Firefox, my tablet, & 2 cell phones.

One would think if it was installed incorrectly the customer side would not be operational but it was, but in Admin, Config, Wishlist the page was formatted but no defines & absolutely nothing in Admin, Extras where I could once view customers Wish List. See pic the path shows http://domain.com/admin/configuration.php?gID=41

[DarkAngel]

That is so weird. I have this installed in my 1.3.9h store ----- this version cause it is for both versions of our carts.

I compared the sql and they are different.



Right now I am moving to a new host/dedicated server so my store is down. I was thinking that maybe, like another mod which I can't remember the name of, it got moved from Xtras over to Maybe reports (in 1.5+). not sure.

I would make a test 1.5+ store and test it out to see what happens but as I said mine is down and need to get it going too.



It does appear that there is a file missing or not in the proper folder in the admin folder.

[DarkAngel]

ok, took a look at the mod again...and even though it says it can still be used in my version I did notice this:


1. even in 1.3.9h, it does not show up in extras or any other spot like before.

2. this part of the installation SQL is not like before so maybe this is why since for 1.5+ there is no longer a includes/boxes folder:

# Register the configuration page for Admin Access Control
INSERT IGNORE INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order ) VALUES ('configZCAWishListModule','BOX_CONFIGURATION_ZCA_WISHLIST','FILENAME_CONFIGURAT ION',CONCAT('gID=',@cid),'configuration','Y',@cid);

[DarkAngel]

ok, took a look at the mod again...and even though it says it can still be used in my version I did notice this:


1. even in 1.3.9h, it does not show up in extras or any other spot like before.

2. this part of the installation SQL is not like before so maybe this is why since for 1.5+ there is no longer a includes/boxes folder:

# Register the configuration page for Admin Access Control
INSERT IGNORE INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order ) VALUES ('configZCAWishListModule','BOX_CONFIGURATION_ZCA_WISHLIST','FILENAME_CONFIGURAT ION',CONCAT('gID=',@cid),'configuration','Y',@cid);

AS I said I am in the process of putting my store back together due to the move.

Yes it and several other mods disappeared from admin...I had to totally reinstall the admin folder from my backup....removing the one on the server. It shows in the extras column and is showing items that folks have wished for.

Do you think in your uninstalling and reinstalling you may have accidently removed the entries into the database tables.

you might go take a look at the tables and make sure there are entries. IF not then you can always grab just those few tables from a backup database (I hope you made one just before doing what you did) and add those to the database again.

[Lackew]

Thank you for your time & effort DarkAngel and yes I ran that SQL after 1st install, uninstall and reinstall, reinst, uninst, re, un lol

# Register the configuration page for Admin Access Control
INSERT IGNORE INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order ) VALUES ('configZCAWishListModule','BOX_CONFIGURATION_ZCA_WISHLIST','FILENAME_CONFIGURAT ION',CONCAT('gID=',@cid),'configuration','Y',@cid);

It worked perfectly for me in 1.39. I dont think I deleted anything in the Db since each time I reinstall it the customers list is populated again (I have a customer test account) that is how I know it is working on the front end. Because it worked in 1.39 my last reinstall was using my old mod version but had same results in admin.

The above pic is from it being totally uninstalled (but looks exactly the same when installed) which is why I am worried I cant remove it from admin. I am thinking maybe I should remove/delete from my DB entirely (I have a back up) if I knew how to do so

[Lackew]

PS
I perused other posts but did not come across any1 saying running the Xtra SQL worked for them!?

[Lackew]

I am thinking maybe I should remove/delete from my DB entirely (I have a back up) if I knew how to do so

Patting myself on the back because I really had no idea what I was doing but I was able to remove all instances of wish list in DB & Now it does Not show in admin... Yippeeeee
Now will install yet again but from old mod version (fingers, toes, arms, legs & eye crossed)

[Lackew]

SQL would not take the old mod. So reinstalled new mod version... Wow the admin controls are There now, nothing in Extras altho. Ran additional SQL for admin but still cant find where to view customers list!