Contributions

The bug was that if a product is removed from catalog or its status is set to 0 then after clicking by image or name of the product, the error occurred.
It is removed by simple checking the conditions whether the status is 0 or 1. If the status is set to 1 it put link on image and name of the product other wise it did not.

open "wishlist_public.php"

find:

$products_query = tep_db_query("select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_status, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where pd.products_id = '" . $wishlist_id . "' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by products_name");
$products = tep_db_fetch_array($products_query);




replace eith:

$products_query = tep_db_query("select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_status, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ( " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd ) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where pd.products_id = '" . $wishlist_id . "' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by products_name");
$products = tep_db_fetch_array($products_query);

catalog/includes/boxes/whislist.php

wrong code:
$products_query = tep_db_query("select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on pd.products_id = s.products_id where pd.products_id = '" . $wishlist_id . "' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by products_name");


the correct select is:
$products_query = tep_db_query("select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd ) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where pd.products_id = '" . $wishlist_id . "' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by products_name");


------------------------------------

catalog / wishlist.php

wrong code:
$products_query = tep_db_query("select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_status, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on pd.products_id = s.products_id where pd.products_id = '" . $product_id . "' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by products_name");


the correct select is:
$products_query = tep_db_query("select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_status, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ( " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd ) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where pd.products_id = '" . $product_id . "' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by products_name");

Fix problem with adding product to wishlist frome product list ;]

The following contribution addition allows your customer's wishlist contents to be stored as a cookie on their local computer. This allows the customer to keep their wishlist without registering. The length of time the cookie is stored is controlled by code.

The same error is in the catalog / wishlist.php

the correct select on line 236 is:

$products_query = tep_db_query("select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_status, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on pd.products_id = s.products_id where pd.products_id = '" . $product_id . "' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by products_name");

There is a wrong select in catalogincludesboxeswhislist.php on line 45.

the correct select is:
$products_query = tep_db_query("select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on pd.products_id = s.products_id where pd.products_id = '" . $wishlist_id . "' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by products_name");

The email function may not work in catalog/wishlist.php version 2.1.
Here is an update that does work.

Simply replace catalog/wishlist.php with this one.

Fullpackage of adminfiles, updated with norwegian translation and the SQL-query fix by pmcintire.

All credits goes to original author.

Translation of wishlist.php and wishlist_help.php in norwegian.

_____________________________________________

Norsk oversettelse av wishlist.php and wishlist_help.php

For 3.5d users. If you have register globals off, which is a good thing, then you will need to fix the following code in order for emails to friends from your wishlist.php page to be sent.

The problem:

/catalog/wishlist.php email sending script requires register globals on as the friend array and email array passed in $_POST are currently coded for register globals.

The fix:

The following code secures the $email and $friend arrays from $_POST without register globals:

1. Look for the following code:
CODE
//Check each posted name => email for errors.
$j = 0;
foreach($_POST['friend'] as $friendx) {
if($j == 0) {
2. Replace it with the following code:
CODE
//Check each posted name => email for errors.
$j = 0;
foreach($_POST['friend'] as $friendx) {
// secure post
$friendx = strip_tags($friendx);

if($j == 0) {
$friend = $_POST['friend'];

// secure posts
$x = 0;
foreach ($friend as $value) {
$friend[$x] = strip_tags($value);
$x++;
}

$email = $_POST['email'];
$x = 0;
foreach ($email as $value) {
$email[$x] = strip_tags($value);
$x++;
}

Problem:
1054 - Unknown column 'p.products_id' in 'on clause'

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '17'

SOLUTION IS ATTACHED!

Thank you for the website that posted this:
http://www.obargain.com/modules.php?name=News&file=article&sid=12

And thank you for everyone who contributed!

Pacote traduzido para português Brasileiro da lista de desejos ou lista de casamento

I haven't installed the last two contributions, as I think that they are optional.

These new contribution adds spanish support, not only for the text but also for the buttons and images. In addition, there are some changes related to the places where the 'add to wishlist' button may appear, as I thought that it would be better to add it also to some lists of products, not only to the product page. I have written all the necessary changes in the install.html document and zipped all the new files along with the previous ones in a new zip file (enclosed).

I hope it is helpful. All credits go to the original author.

regards,
Pedro.

I went through and changed all $HTTP_POST_VARS to the superglobal $_POST to have better support for register globals being turned off. Only file uploaded is wishlist.php

-Dennis

Same as below but takes into account if stock is less than 0 or equal to 0. Use this one.

This is not the full package. Just instructions on how to show a message in wishlist if a product is out of stock.
I found this capability lacking.

Aaron Hiatt incorporated a useful tool in admin which lets you view what customers have in their wishlist files. Unfortunately, there were a few issues in his previous posts from June of 2005. His customized database varied from the osC base installation, and there were some aesthetic considerations including the admin wishlist report duping listings if the products in the wishlist had options.

The fixes are included in this file.

Update: For some reason the contributed zip from my previous post was "empty". Hopefully, this addition will fix it.

Aaron Hiatt incorporated a useful tool in admin which lets you view what customers have in their wishlist files. Unfortunately, there were a few issues in his previous posts from June of 2005. His customized database varied from the osC base installation, and there were some aesthetic considerations including the admin wishlist report duping listings if the products in the wishlist had options.

The fixes are included in this file.

Is the install HTML file in step 11 part 2 you will notice that the L's are capital. Unfortunatly Some server like mine flips out becasue it's capital and others are lower case. (makes it a nightmare for programmers)

if you get a Call to a member function on a non-object in error


make the l's lower case and it should work for you..

I have also uploaded the code for you just replace it and save

Roll up of contributions back to (and including)wishlist 3.5d.

Credit to those below.

When viewing the wishlist_public.php file and trying to move something to the cart, there's a bug. View the fix.txt for the fix.

The missing basic files for the wishlist_help.php link

Just drop them in place, it will NOT overright any files unless you have a wishlist_help.php on your system already!

This is the translation of includes/languages/english/wishlist.php to danish. Copy this file to includes/languages/danish/wishlist.php and you're done

This is the translation of includes/languages/english/wishlist.php to turkish. copy this file to includes/languages/turkish/wishlist.php and you're done

Updated some formatting on wishlist_public.php and in wishlist.php. I also changed the doc type in wishlist_public.php from strict, cuz maybe that was causing your guy's problems with the formatting on that page.

-Dennis

Fixed the error on column_right.php. Forgot to add function count_wishlist() in the wishlist class. Also updated wishlist_public.php to show when a product is not available any longer and moved Item in Cart text to the language file.

Only files you need to update are:

includes/classes/wishlist.php
wishlist_public.php

-Dennis

Updated install instructions:

It should read this: (notice $wishList-> with a captial L)

STEP 10 - Edit catalog/includes/column_right.php

Find this code:

require(DIR_WS_BOXES . 'shopping_cart.php');
Below that code ADD this:

if($wishList->count_wishlist() != '0') { require(DIR_WS_BOXES . 'wishlist.php'); }

Fixed typo in install directions.

Fixed an error with the email, cleared out the values for the email form upon success.

Added in all the error checking, and fixed the problems stated in the forum thread. Updated the install instructions there now nice and clean and should be easy to follow. Any mistakes let me know. I made this 3.5 to get away from the beta numbers and to make it an nice round number instead of .2 .3.

-Dennis

Fixed public_wishlist.php file. This is all thats in this package. The Public list was not showing product attributes and the link ID number was incorrect. That is now fixed.

Dennis

This is just the new install file. I had for step 4


4. Open catalog/includes/database.php

it should read


4. Open catalog/includes/database_tables.php

Sorry for any conusiong.

Dennis

This is a full package.

Added functionality for a guest wishlist. Modeled after the shopping cart. Did away with the wishlist functions and turned it into a class.

Guests now have the ability to store things in a wishlist. They may also email them the same as if they were registered. Differences are:

1. Guests have to fill out there name and email.
2. Guests products on their wishlist are emailed where if there registered the email sends out the public_wishlist.php instead. The email sends the products like this:
$product_name ($product_attribute)
$product_link

3. Once the Guests session is terminated, so is there guest wishlist.
4. If a guest starts a wishlist and then signups, the wishlist is converted to the database and stored like there cart.
5. If a customer comes to your site and adds products to there wishlist and then logins, the items are merged with there existing products in there wishlist.
6. Upon checkout if the customer is buying the product, the product is removed from their wishlist.

I still need the wishlist_help.php file.

This is still beta so I need testers to get this finalized.

-Dennis

This is full package, the 3.01 was incorrect which </td> was missing. This should fix that problem.

-Dennis

A missing td and some misplaced <form> and <table> tags were breaking my layout. I have updated wishlist.php, and the install file (minor typo) and repackaged. I was using STS, so that might have something to do with it.

I have been working this when I can and I finally have something to put up for testers and for additions to be added. I have re-wrote the code so this is not an update for 2.4. You will need to uninstall the older version and install this one.

Features:

1. Optimized queries down to 1-2 per product depending on attributes or not.
2. Attributes now work correctly, you can add the same product with different attributes and it will show up correctly on your wishlist.
3. If a user is not logged in and they press "Add to Wishlist" then the product id is stored throughout there logging or creating an account. Once there done it will add to there wishlist.
4. Added in the capability to redirect back to the products page or stay on the wishlist page when a user pushes the add to wishlist button. Setting done in admin.
5. Combined the email functions into the main wishlist page. Added in mulitple emails the user can send to. The number is editable through the admin settings.
6. Added a public_wishlist view instead of emailing products through email, it just emails them there unique link. The public wishlist will only allow the user to view and add to cart from that list. They will not be able to delete. For security measures.
7. When a user adds an item from there wishlist, it displays "Item in Cart" instead of removing it from the wishlist. Once a user checks out, it will check to see if they are buying anything from there wishlist and at that point remove it. I did this just in case someone added a product to their cart and for some reason didnt check out.
8. Removed all that crap in application_top and just added about 5 lines to it to keep more of the code separate from osc.


Other updates and changes as well. I have not created a wishlist_help.php file so if someone would like to create that, then by all means. Let me know of any problems you run acrossed and let me know of anything that needs to be added. This is not final so don replace your exisiting one until we work out any kinks.

Suppor thread: http://forums.oscommerce.com/index.php?showtopic=166244

-Dennis

The original file, /catalog/includes/languages/english/wishlist.php, was missing the php extension to wishlist_help.php. I have edited the wishlist.php file to reflect that change. I don't know about the other language files so they may also need updating.

When I first uploaded this I forgot that we have merged the products and products_description tables in our version of osCommerce so the previous stats_wishlists.php would have brought up SQL errors for pretty much all of you. Use this version. Sorry...

From what I could see no one has written the Wishlists into Admin yet, and I thought that would be a really nice feature. This is a simple add-on that will create a link in your Reports Box in Admin called "Customer Wishlists". From here you will be able to view all the contents of your customers' wishlists.

Feel free to make modifications and advancements to this Contribution. Thanks!!

Mod for Wishlist 2.4.b

If you are receiving "1064" SQL Syntax errors (I am on MySQL 4.3.10), do the following:

////-------------------------

If you have not changed your includes/boxes/wishlist.php file, simply replace with the included file.

////-------------------------

If you have changed your includes/boxes/wishlist.php file, delete:

$wishlist_query_raw = "select * from " . TABLE_WISHLIST . " WHERE customers_id = $customer_id order by products_name";

and replace with:

$wishlist_query_raw = "select * from " . TABLE_WISHLIST . " where customers_id = '" . $customer_id . "' order by products_name";

////-------------------------

This should repair the problem.

If you are having problems with your wishlist box calculating the wrong quantity of items following this change, simply empty the wishlist table using phpMyAdmin.

This is the complete Wishlist 2.4b. I translated the german buttons, descriptions and helpfile into the german languages and wrote it to the install.txt.

Die ist die komplette Wishlist Version 2.4b nur mit angepassten Buttons und einer kompletten Überstzung der Helpfile, Boxnamen und Buttonsnamen.

Viel erfolg!

v2.4b SQL FIX, changed two lines and removed quotes from the NULL in each line.

v2.4a
BUG FIX: by dblake so when you are not logged in and add an item to your wish list it is added properly, previously your item you wanted to add to the wish list was lost if you were not already logged in.
BUG FIX: Having to keep logining in everytime you visit your wishlist (affects only some sites).

Upgrade instructions from 2.3.0, 2.3.1, & 2.4 included.

v2.4 Changes and clean up on the layout of the wish list page to a more streamlined and easier to view list (or so I think) most noticebly when you have two or more wish items. It also moves the configuration values to admin instead of admin/configure.php, and adds my wish list link to My Account page.

Upgrade instructions from 2.3.0 & 2.3.1 included.

This is only the catalog/wishlist_email.php file.
For all those having problems getting the products sent to the friend without first entering something in the personal message box. This fixes this with also some email display coding tiding up.

See here for more details:
http://forums.oscommerce.com/index.php?showtopic=67290&view=findpost&p=549226

Modified Version of 2.3
ChangeLog:
BugFix to error on nbsp (added ; at end )
Italian Localization Added
Rewriting of wishlist.php (modify of word and add localization format)
P.s. Excuseme for my English

I found that Wish List wouldn't work for me without a change to the product_info.php page that was included. The patched product_info page is in this zip. It replaces the one included in the 2.3 package. Place it in the main directory of osCommerce

Consolidation of all previous contributions and add-ons in a single package.

Corrected the readme file for the addition. It now contains instruction on modifying catalog/wishlist.php

- Now you can include product attributes in your Wish List products.
- Wish List will correctly move products w/attributes into the Shopping Cart.
- My Wish List page shows product price with attribute option prices included.

The main wishlist page (where the user views items on their wishlist) wasn't rendering correctly. Made changes to fix this. This is only catalog/wishlist.php

*wishlist 2.0 email fix*

Gender problem resolved in email subject

All wishlist items are a clickable link showing the product name
in a bulleted list instead of a path that you have to cut & paste

Product links do not show in the personal message textarea.

the name of your store is a clickable link at the bottom of the page

the Success page accurately show your friends email address

Backup 1st,Backup 1st,Backup 1st,Backup 1st,Backup 1st,Backup 1st,
Backup 1st,Backup 1st,Backup 1st,Backup 1st,Backup 1st,Backup 1st,

replace the 2 wishlist_email.php files with these 2
Thats It.
Enjoy
See it in action or just stop by for a visit
http://2ndhandcd.com

This is an update to Wishlist 2.0 which allows you to email a friend a link to your wishlist and not the individual items as in the current version. The link will allow your friend to easily add the items from your wishlist right to their cart. This is NOT a full install, the file includes wishlist.php and wishlist_email.php. These files can be copied right to your catalog directory. PLEASE BE SURE TO BACKUP PRIOR TO INSTALL. Also included is my shopping_cart.php, which places your wishlist in the shopping cart box below the cart total.

This slight modification of the wishlist.php file so that it complies with the Separate Pricing Contribution. If you are using the Separate Pricing Contribution and you want the price shown on Wishlist.php to correspond with the correct price level for the logged in user, then simply make these two changes to your wishlist.php file.

This is not the full package - just install instructions for the necessary changes to wishlist.php.

I missed out something in the install text, which was pretty important to get the contrib to work.

Sorry for the hassle for those that installed the version below. anyway I've tested this one a number of times and it should be fine now.

Please note. Use the install.txt for instructions on how to install.

some people were having problems, as I neglected the install.txt. Hopefully this shoulf fix it.

Mutters checkbox addition packaged with the original wishlist.

Hi, this is a minor add-on to the latest wishlist contribution.

What it Does?

Add a Checkboxes to every product in the wishlist page, so now the user can add to cart
or delete various products from their wishlist at one time.

There was yet another minor bug. This one effected the navbar title in exactly the same was as the FAQ contribution.

see below : http://www.oscommerce.com/community/contributions,1948

Oh, and I added a wishlist pic. :-)

Please note: I haven't updated the readme.txt. Please use the install.txt file

This update should fix the paging issue that some users were having. It also addresses the FAQ page that was show lines that were meant to be commented out.

Just follow the install.txt.

This is an update to the previous version from 2 Apr 2004 and also a whole package including all files needed for the installation

cleand up the source code
gave new defines to the language files
added on new language file wishlist_email.php
made so corrections
fixed the hardcoded language entries ...

This is a update of all of the contributions below, using mainly the first Wish List and adding slightly few modifications from others along the way. This update includes all files targetd for osC 2.2 MS2, it also has everything very well documented.

Please post questions, comments, concerns and what not at: http://forums.oscommerce.com/index.php?showtopic=67290&st=250

After spending many hours trawling through the 24 pages or so of Support thread to get this running in MS2, I decided to save others the pain and package up a new version.

I have added MS2.2 corrections from the Support thread to these files, tidied up and fixed some of the outstanding issues (such as Wishlist pagination and add/remove products Wishlist) and code issues in the application_top.php file.

Documentation has been changed to simplify modifications to the existing files and put things where they should be in MS2.

I translated it to norwegian with norwegian button

I have made some changes:

* Translation into German Language
* eliminate some magic numbers
* correct for using with osC 2.2 MS2

Its runing very well at mit WebSite

This is the latest version of the old wishlist which is MS1 compatible and hopefully MS2. Changes will be quick to make this fully compat. The best addition to the latest version is that you can email your wishlist to a friend. Similar to Tell-a-friend but the also get the name and a link to all the items in your wishlist.