Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Newsletters Subscribers Manager - Oscommerce 2.3 & 2.2


sembrouille

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.

 

Link to comment
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
Link to comment
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
Link to comment
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??

Link to comment
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.

Link to comment
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/

Link to comment
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!

Link to comment
Share on other sites

  • 5 months later...
  • 3 months later...

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

Link to comment
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.

 

Link to comment
Share on other sites

  • 5 months later...

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

Link to comment
Share on other sites

  • 2 months later...

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

Link to comment
Share on other sites

  • 2 months later...

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?

Link to comment
Share on other sites

  • 1 month later...

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

Link to comment
Share on other sites

  • 2 weeks later...

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.

Link to comment
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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...