vampirehunter Posted August 22, 2013 Share Posted August 22, 2013 Hi Normally you are supposed to validate both via Javascript and by PHP as backup. To make sure it has worked correctly. Also is it possible you can rename the fields into English rather than French. For example success and no success are both in French in the PHP code and Javascript. Quote Link to comment Share on other sites More sharing options...
vampirehunter Posted August 22, 2013 Share Posted August 22, 2013 (edited) another error ive spotted is that when you already have an account with oscommerce but haven't signed up to the newsletter from the my account section. if you then go sign up for newsletter using the newsletter signup submit, the checkbox is not ticked in my account and in database, value in customers is showing as '0' anyone know how to fix it? Edited August 22, 2013 by vampirehunter Quote Link to comment Share on other sites More sharing options...
vampirehunter Posted August 22, 2013 Share Posted August 22, 2013 (edited) Hi vempire ! 1) Javascript is enabled by default in all browsers 2) If you turn off javascript all "moderns" websites, including osc2.3.x, will be turn off 3) in which case and why customers turn off javascript ?!! Conclusion: no bug! Best Regards Brouillard s'embrouille. hi can you add this functionality below where if you are already signed up, instead of success message, you will get message explaining you are already signed up. can you add something so that it will inform if user is already signed up instead of the standard success message? thanks Edited August 22, 2013 by vampirehunter Quote Link to comment Share on other sites More sharing options...
vampirehunter Posted August 22, 2013 Share Posted August 22, 2013 if ( ($inscrits_check_values['checkinscrits']=='1') && ($email_abonnement != '') ) { tep_redirect(tep_href_link(FILENAME_NEWSLETTER_ABONNEMENT_EXISTING, '', 'NONSSL')); } else { if ( ($inscrits_check_values['checkinscrits']=='0') && ($email_abonnement != '') ) { $sql_data_array = array('abonnement_addresse_email' => $email_abonnement, 'abonnement_date_creation' => 'now()', 'abonnement_newsletter' => '1'); tep_db_perform(TABLE_NEWSLETTER_ABONNEMENT, $sql_data_array); $insert_id = tep_db_insert_id(); $email_desabonnement = str_replace('@', '4r0b6s3', $email_abonnement); $message = EMAIL_START_HTML; $message .= EMAIL_SPAN_START_STYLE; $message .= EMAIL_WELCOME . TEXT_PRIVACY_EMAIL . sprintf(NL_DESABONNEMENT_LINK, 'emaildesabonnement=' . $email_desabonnement . '&iID='. $insert_id, 'emaildesabonnement=' . $email_desabonnement . '&iID='. $insert_id); $message .= EMAIL_SPAN_STOP_STYLE; $message .= EMAIL_STOP_HTML; tep_mail('', $email_abonnement, EMAIL_WELCOME_SUBJECT, $message, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); // recevoir un mail d'une nouvelle inscription if (PREVENIR_EMAIL_NEW_INSCRIT_NL == 'oui') { tep_mail('', STORE_OWNER_EMAIL_ADDRESS, EMAIL_NEW_INSCRIT_NL, $email_abonnement, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); } } tep_redirect(tep_href_link(FILENAME_NEWSLETTER_ABONNEMENT_SUCCESS, '', 'NONSSL')); } } else { tep_redirect(tep_href_link(FILENAME_NEWSLETTER_ABONNEMENT_SIGNUP, '', 'NONSSL')); } i have added an if statement above the query, so that if a user already has an email signed up, they will get redirected to another page which i've defined. and on this page, it will have its own message stating "thank you, you are already signed up to the system". this seems to work, ive tested it and if i type in an email already in the newsletters list, it will go straight to the new redirected page. have i done it correctly?? Quote Link to comment Share on other sites More sharing options...
vampirehunter Posted August 22, 2013 Share Posted August 22, 2013 also, if its possible, i will try to convert all the php fields and filenames into english, because its too difficult to keep track of whats going on, as everything is in french. it would be better to have everything in English, including the PHP fields, as it will make it easier to edit. Quote Link to comment Share on other sites More sharing options...
sembrouille Posted August 22, 2013 Author Share Posted August 22, 2013 Try Defines files, you can easily change all languages you want, you can have everything in English, French, Russian, Chinese, Greek, German, Italian, Spanish ... Here ----> /newsletters_subscribers_manager_1.3/includes/languages/ And here ----> /catalog/includes/languages/ Quote Link to comment Share on other sites More sharing options...
vampirehunter Posted August 23, 2013 Share Posted August 23, 2013 Try Defines files, you can easily change all languages you want, you can have everything in English, French, Russian, Chinese, Greek, German, Italian, Spanish ... Here ----> /newsletters_subscribers_manager_1.3/includes/languages/ And here ----> /catalog/includes/languages/ hi im not talking about the language im talking abou the way you've named the PHP variables they are all in french! Quote Link to comment Share on other sites More sharing options...
♥joli1811 Posted January 27, 2014 Share Posted January 27, 2014 @@sembrouille Hi brouillard, You know anyone got this to work with bulk mail manager http://addons.oscommerce.com/info/6553 Regards Joli Quote To improve is to change; to be perfect is to change often. Link to comment Share on other sites More sharing options...
alix32 Posted May 10, 2014 Share Posted May 10, 2014 Hi there, I'm getting a table not found issue although I can see the table in my database. 1146 - Table 'soonlineshop.NEWSLETTER_ABONNEMENT' doesn't exist select count(*) as checkinscrits from NEWSLETTER_ABONNEMENT where abonnement_addresse_email = 'test@@test.com' I checked the name of the table in both the database and in file newsletter_abonnement.php and they match so I have no idea how I could get that error. Would someone be able to help please? Thanks Quote Link to comment Share on other sites More sharing options...
♥joli1811 Posted May 10, 2014 Share Posted May 10, 2014 Did you remember to add the define to your includes/database.php // ################# Contribution Newsletter by brouillard s'embrouille ############## define('TABLE_NEWSLETTER_ABONNEMENT', 'newsletter_abonnement'); define('TABLE_NEWSLETTERS', 'newsletters'); // ################# Fin Contribution Newsletter by brouillard s'embrouille ############## Regards Joli Quote To improve is to change; to be perfect is to change often. Link to comment Share on other sites More sharing options...
khoking Posted October 29, 2014 Share Posted October 29, 2014 I got hundreds of subscribers to my newsletter in the past few minutes, I think is a spambot or hacker code. Below are what in my database. Should I be worried? How can the email address be of such numbers or code? 1 and(select 1 from(select count(*),concat((select (select concat(0x7e,0x27,unhe Active Set Inactive 999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536 and x=x Active Set Inactive Info999999.9 union all select 0x31303235343830303536 and x=x Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032 Active Set Inactive Info999999.9 union all select 0x31303235343830303536,0x31303235343830303536-- Active Set Inactive Info999999.9 union all select 0x31303235343830303536-- Active Set Inactive Info1" and "x"="y Active Set Inactive Info1" and "x"="x Active Set Inactive Info1 and x=y Active Set Inactive Info1 and x=x Active Set Inactive Info1 and 1_1 Active Set Inactive Info1 and 1=1 Active Set Inactive Info999999.9 or x=x Active Set Inactive Info999999.9 or 1=1 Active Set Inactive Info999999.9 Active Set Inactive Info Quote Best regards, Koh Kho King Link to comment Share on other sites More sharing options...
khoking Posted October 29, 2014 Share Posted October 29, 2014 Is it possible to have a page or box where customer can key in their email address to UNSUBSCRIBE from the newsletter? Quote Best regards, Koh Kho King Link to comment Share on other sites More sharing options...
toyzonline Posted January 18, 2015 Share Posted January 18, 2015 I have looked at this add_on as it is what I need and having trouble with an alternative. However when I tried this one it asks for a change to be made in /admin/includes/column_left.php However the code it states to replace is not in this file: (3) /admin/includes/column_left.php* FIND THE LAST: include(DIR_WS_BOXES . 'tools.php');* REPLACE: include(DIR_WS_BOXES . 'tools.php'); include(DIR_WS_BOXES . 'newsletters.php'); I am using osCommerce Online Merchant v2.3.4 Quote Complete Newbie On The Learn - Not A Programmer But Learning As I Go Link to comment Share on other sites More sharing options...
toyzonline Posted January 19, 2015 Share Posted January 19, 2015 Sorted thanx Quote Complete Newbie On The Learn - Not A Programmer But Learning As I Go Link to comment Share on other sites More sharing options...
dculley Posted March 25, 2015 Share Posted March 25, 2015 @@toyzonline I'm getting ready to install, I to do not #3, How did you fix it? Quote Link to comment Share on other sites More sharing options...
dculley Posted March 28, 2015 Share Posted March 28, 2015 Installing this on OSC234 with BS Followed the install instructions and ran into problems. Need help. 1st: in the install, step 3 could not be found in osc234 (3) /admin/includes/column_left.php* FIND THE LAST: include(DIR_WS_BOXES . 'tools.php');* REPLACE: include(DIR_WS_BOXES . 'tools.php'); include(DIR_WS_BOXES . 'newsletters.php'); 2nd Did not see "Bouton Install Module" in step 10 Insatalation newsletter boxeAdmin => modules => boxes => Bouton Install Module => Newsletter I did go to Admin>modules>boxes> and install Newsletter. 3rd When I went to see the site I got the following error message: Parse error: syntax error, unexpected 'define' (T_STRING) in /home/ladybug3597/public_html/osc234/includes/languages/english.php on line 327 Line 327 reads: // ################# Contribution Newsletter by brouillard s'embrouille ########### 327 - define('IMAGE_BUTTON_NEWSLETTER_ABONNEMENT', 'Subscribe'); What do I need to do? Quote Link to comment Share on other sites More sharing options...
Hotclutch Posted May 27, 2015 Share Posted May 27, 2015 Hi All I have updated this addon for the bootstrap version of osCommerce. Also translated most of the French to English, including the code. After the upload I found in admin\newsletter_subscriber_manager.php one more instance of GESTION_INSCRITS, which should be changed to SUBSCRIBER_MANAGER Quote Link to comment Share on other sites More sharing options...
dculley Posted June 6, 2015 Share Posted June 6, 2015 I have installed the bootstrap version. Wanted to do a test send. I cannot find send. How do you send? Quote Link to comment Share on other sites More sharing options...
dculley Posted June 6, 2015 Share Posted June 6, 2015 I don't see how to edit, just create new. Quote Link to comment Share on other sites More sharing options...
Hotclutch Posted June 6, 2015 Share Posted June 6, 2015 The functions in the backend work the same as before. If you had the addon before, did you backup your database (the tables that this addon creates)?. Quote Link to comment Share on other sites More sharing options...
dculley Posted June 6, 2015 Share Posted June 6, 2015 I uninstall all the files and database from the old version and installed the BS. What do I need to put back? I thought that the BS version was a full package. Quote Link to comment Share on other sites More sharing options...
Hotclutch Posted June 6, 2015 Share Posted June 6, 2015 Yes it is. Sounds like you are looking for entries in your old table, in which case you need to restore a backup to get them back. Quote Link to comment Share on other sites More sharing options...
dculley Posted June 6, 2015 Share Posted June 6, 2015 Why doesn't the BS ver. (if a full package) have the edit and send features? Quote Link to comment Share on other sites More sharing options...
Hotclutch Posted June 6, 2015 Share Posted June 6, 2015 It has EDIT, DELETE, PREVIEW, SEND LOCK/UNLOCK like before. Please note: If you deleted your database tables with newsletters in there won't be anything to edit and the buttons won't show, but that's because there are no newsletters to edit or send. Quote Link to comment Share on other sites More sharing options...
dculley Posted June 6, 2015 Share Posted June 6, 2015 @@Hotclutch Ah- but I have created one. I called it test 1 and selected product_notification. I have also done test 2 as newsletter. There is no edit or send just preview and lock. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.