Newsletter & Subscribers

1 of 1494   Next >   Last >>   The following osCommerce contribution is a free Opensource code originated from official osCommerce website and provided for your reference only, you may download the original contribution file(s) and install it on your own; or you may request a Paid Installation Service from Agents Of Power; Agents Of Power does the "AS IS" installation on your website, we do not guarantee it will work properly on your website. Extra Paid service is available for repairing the problem from the original contribution or from your website. In need is integration of WYSIWYG html support. Perhaps contribution http://addons.oscommerce.com/info/1347 is the solution, but I have yet to integrate this feature. I believe there is a bug in the code as pointed out in post #318 in the support forum at http://forums.oscommerce.com/index.php?showtopic=116105 If the next user could confirm if I am right, please alter the source code and upload the new version for others. Also, here's how newsletter sending should proceed EACH TIME you send a newsletter: 1. Update the database via the 'Update Table' link in Admin 2. Send the newsletter The first time you send a newsletter you need to define languages via the 'Newsletter Default' link in Admin. These instruction might be added to installation instructions. Lastly, the installation instructions claim to use a file CATALOG>newsletters.php but I don't believe it does. I am sorry I am unable to test further due to time constraints (I am a student ... ;) and I am sorry to be posting 'talk' in the 'package' section of this contribution! Warm Regards I have re-uploaded the previous package without modification. Full package as per 15 Jun 2009 contribution Updated installation.txt, no code changes Agreed with Techgoddess that newsletters table should remain in the database and have removed the instruction to drop that table. Clarified ambiguous english and added basic instruction to improve admin links. 1) Super tiny change in the area of admin/includes/modules/newsletters/newsletters.php. A curly bracket "}" on line 425 -OF THE INSTALLATION.TXT FILE- was missing and causing "Parse error: syntax error, unexpected ';', expecting T_FUNCTION in ~". 2) Super tiny change in the area of admin/includes/modules/newsletters/product_notification.php. A curly bracket "}" on line 568 -OF THE INSTALLATION.TXT FILE- was missing. 3) Included the "Unsubscribe link in emails not working" contribution directly below by sunrise99 involving "newsletters_subscribe.php". 4) Added Spanish translations using "Word Magic Translator Professional (not affiliated with them). This is an excellent translation software but SOFTWARE non-the-less. I do not guarantee complete accuracy. Just a *note*: Step 2 in the installation.txt file asks you to drop the Newsletters Table from SQL. I did this but received errors every time I clicked on the Newsletter section in Admin. I don't know if there is a viable reason for this step as I haven't received any errors after adding the Newsletters Table back but if anyone else needs to recreate the newsletters table, see SQL code below. Luck! Athena http://www.mediosecologicos.com ================================================= CREATE TABLE newsletters ( newsletters_id int NOT NULL auto_increment, title varchar(255) NOT NULL, content text NOT NULL, module varchar(255) NOT NULL, date_added datetime NOT NULL, date_sent datetime, status int(1), locked int(1) DEFAULT '0', PRIMARY KEY (newsletters_id) ); ================================================== ~~FULL PACKAGE~~ **************************** *Wrong folder uploaded in last post! * * THIS IS THE CORRECT ONE * **************************** 1) Super tiny change in the area of admin/includes/modules/newsletters/newsletters.php. A curly bracket "}" on line 425 -OF THE INSTALLATION.TXT FILE- was missing and causing "Parse error: syntax error, unexpected ';', expecting T_FUNCTION in ~". 2) Super tiny change in the area of admin/includes/modules/newsletters/product_notification.php. A curly bracket "}" on line 568 -OF THE INSTALLATION.TXT FILE- was missing. 3) Included the "Unsubscribe link in emails not working" contribution directly below by sunrise99 involving "newsletters_subscribe.php". 4) Added Spanish translations using "Word Magic Translator Professional (not affiliated with them). This is an excellent translation software but SOFTWARE non-the-less. I do not guarantee complete accuracy. Just a *note*: Step 2 in the installation.txt file asks you to drop the Newsletters Table from SQL. I did this but received errors every time I clicked on the Newsletter section in Admin. I don't know if there is a viable reason for this step as I haven't received any errors after adding the Newsletters Table back but if anyone else needs to recreate the newsletters table, see SQL code below. Luck! Athena http://www.mediosecologicos.com ================================================= CREATE TABLE newsletters ( newsletters_id int NOT NULL auto_increment, title varchar(255) NOT NULL, content text NOT NULL, module varchar(255) NOT NULL, date_added datetime NOT NULL, date_sent datetime, status int(1), locked int(1) DEFAULT '0', PRIMARY KEY (newsletters_id) ); ================================================== ~~FULL PACKAGE~~ update for Unsubscribe link in emails not working and double email sending. Only one file update. newsletters_subscribe.php full package    Posted on: 02/26/2009     See contribution details Request Installation with Paid service