[shishapipe]

ITS FINISHED AND WORKING ON X-CART 4.09

I have amended the above posts to the correct codes and scripts.

It allows guests and logins to request a stock notify when back in stock.
It does not duplicate stock notify items with emails
It deletes the emails once stock is back in after sending email to users.

All you need to do is edit the txt and html mail scripts for your own prefrence.

If anyone can make the code better then please post it here.

Dont forget you need to change the xcart_notify code for sql to this:

CREATE TABLE xcart_notify (
  email char(128) NOT NULL ,
  productid int(11) NOT NULL ,
  KEY email_proudct (email, productid),
) TYPE=MyISAM;

If you dont know how to do this, just go to your admin area, go to patches and in the bottom sql box type in:

DROP TABLE if exists xcart_notify;

This will remove the table for xcart_notify, then you have to install the table again using this code in your sql box:

CREATE TABLE xcart_notify (
  email char(128) NOT NULL ,
  productid int(11) NOT NULL ,
  KEY email_proudct (email, productid),
) TYPE=MyISAM;

I have one small problem and thats when you have clicked on stock notify and either entered the email or you are already log on, the following screen that accepts the command is ok, but the right hand cat coloum does not display right, it moves to the top right of the page, any ideas anyone ?