Jump to content
sembrouille

Newsletters Subscribers Manager - Oscommerce 2.3 & 2.2

Recommended Posts

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.

 

Share this post


Link to post
Share on other sites

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 by vampirehunter

Share this post


Link to post
Share on other sites

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 by vampirehunter

Share this post


Link to post
Share on other sites

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??

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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/

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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


To improve is to change; to be perfect is to change often.

 

Share this post


Link to post
Share on other sites

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     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536 and x=x     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536 and x=x     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536,0x313032     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536,0x31303235343830303536--     Active  Set Inactive     Info
999999.9 union all select 0x31303235343830303536--     Active  Set Inactive     Info
1" and "x"="y     Active  Set Inactive     Info
1" and "x"="x     Active  Set Inactive     Info
1 and x=y     Active  Set Inactive     Info
1 and x=x     Active  Set Inactive     Info
1 and 1_1     Active  Set Inactive     Info
1 and 1=1     Active  Set Inactive     Info
999999.9 or x=x     Active  Set Inactive     Info
999999.9 or 1=1     Active  Set Inactive     Info
999999.9     Active  Set Inactive     Info


Best regards,

Koh Kho King

Share this post


Link to post
Share on other sites

Is it possible to have a page or box where customer can key in their email address to UNSUBSCRIBE from the newsletter?


Best regards,

Koh Kho King

Share this post


Link to post
Share on other sites

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

Complete Newbie On The Learn - Not A Programmer

But Learning As I Go

Share this post


Link to post
Share on other sites

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 boxe
Admin => 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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

I have installed the bootstrap version.  Wanted to do a test send.  I cannot find send.  How do you send?

Share this post


Link to post
Share on other sites

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)?. 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Why doesn't the BS ver. (if a full package) have the edit and send features?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

@@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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×