SendinBlue Subscribe Form And WP SMTP - Version 3.1.22

Version Description

  • Improved the content of test email.
  • Fixed an issue related to slowness of plugin because of a mysql query.
Download this release

Release Info

Developer amarsib
Plugin Icon 128x128 SendinBlue Subscribe Form And WP SMTP
Version 3.1.22
Comparing to
See all releases

Code changes from version 3.1.21 to 3.1.22

Files changed (6) hide show
  1. inc/SendinblueApiClient.php +1 -1
  2. inc/templates/test/temp.html +6 -18
  3. inc/templates/test/temp_fr-FR.html +6 -20
  4. model/model-users.php +4 -3
  5. readme.txt +5 -1
  6. sendinblue.php +1 -1
inc/SendinblueApiClient.php CHANGED
@@ -14,7 +14,7 @@ class SendinblueApiClient
14
  const RESPONSE_CODE_CREATED = 201;
15
  const RESPONSE_CODE_ACCEPTED = 202;
16
  const RESPONSE_CODE_UNAUTHORIZED = 401;
17
- const PLUGIN_VERSION = '3.1.21';
18
  const USER_AGENT = 'sendinblue_plugins/wordpress';
19
 
20
  private $apiKey;
14
  const RESPONSE_CODE_CREATED = 201;
15
  const RESPONSE_CODE_ACCEPTED = 202;
16
  const RESPONSE_CODE_UNAUTHORIZED = 401;
17
+ const PLUGIN_VERSION = '3.1.22';
18
  const USER_AGENT = 'sendinblue_plugins/wordpress';
19
 
20
  private $apiKey;
inc/templates/test/temp.html CHANGED
@@ -12,21 +12,13 @@
12
  <tbody>
13
  <tr style="border-collapse:collapse;">
14
  <td style="border-collapse:collapse;" align="center">
15
- <table width="570" border="0" cellpadding="0"
16
- cellspacing="0">
17
- <tbody>
18
- <tr>
19
- <td style="line-height:0; font-size:0;" height="20"><img src="{shop_logo}" alt="{shop_name}" width="0" height="0"/></td>
20
- </tr>
21
- </tbody>
22
- </table>
23
  <table width="570" border="0" cellpadding="0"
24
  cellspacing="0">
25
  <tbody>
26
  <tr>
27
  <td align="" valign="middle">
28
  <h1 style="margin:0;color:#2f8bee;font-family:arial,sans-serif">
29
- <img alt="Sendinblue" src="http://img.sendinblue.com/14406/images/529f2339c6ece.png"></h1>
30
  </td>
31
  </tr>
32
  </tbody>
@@ -112,24 +104,20 @@
112
  <div style="font-family:arial,sans-serif; font-size:12px; margin:0; line-height:16px; color:#7e7e7e;">
113
  <strong style="color:#2f8bee;">Sendinblue</strong></div>
114
  <div style="font-family:arial,sans-serif; font-size:12px; margin:0; line-height:16px; color:#7e7e7e;">
115
- 118, rue de Tocqueville</div>
116
  <div style="font-family:arial,sans-serif; font-size:12px; margin:0; line-height:16px; color:#7e7e7e;">
117
- 75017 Paris - France</div>
118
- <div style="font-family:arial,sans-serif; font-size:12px; margin:0; line-height:16px; color:#7e7e7e;">
119
- Tél : 0 899 25 30 61</div>
120
  <div style="font-family:arial,sans-serif; font-size:12px; margin:0; line-height:16px; color:#7e7e7e;">
121
  <a href="https://www.sendinblue.com" style="color:#2f8bee;" target="_blank">www.sendinblue.com</a></div>
122
  </td>
123
  <td align="right" valign="top">
124
  <div style="font-family:arial,sans-serif; font-size:12px; margin:0; line-height:20px; color:#7e7e7e;">
125
- <a href="http://www.facebook.com/Sendinblue" style="color:#2f8bee; text-decoration:none;" target="_blank"> <img alt="Facebook" src="https://my.sendinblue.com/public/upload/14406/images/523693143fe88.gif" style="border:none;"> </a> <a href="https://twitter.com/Sendinblue" style="color:#2f8bee; text-decoration:none;" target="_blank"> <img alt="Twitter" src="https://my.sendinblue.com/public/upload/14406/images/5236931746c01.gif" style="border:none;"> </a> <a href="http://www.linkedin.com/company/mailin" style="color:#2f8bee; text-decoration:none;" target="_blank"> <img alt="Linkedin" src="https://my.sendinblue.com/public/upload/14406/images/5236931ad253b.gif" style="border:none;"> </a> <a href="http://sendinblue.tumblr.com/" style="color:#2f8bee; text-decoration:none;" target="_blank">Blog</a></div>
126
- <div style="font-family:arial,sans-serif; font-size:10px; margin:0; line-height:14px; color:#7e7e7e;">
127
- © 2013-2014 Sendinblue, all rights reserved.</div>
128
  <div style="font-family:arial,sans-serif; font-size:10px; margin:0; line-height:14px; color:#7e7e7e;">
129
  This is an automatic message generated by Sendinblue.</div>
130
  <div style="font-family:arial,sans-serif; font-size:10px; margin:0; line-height:14px; color:#7e7e7e;">
131
  Do not respond, you wouldn't receive any answer.</div>
132
- <div style="font-family:arial,sans-serif; font-size:10px; margin:0; line-height:14px; color:#7e7e7e;"><a href="https://www.sendinblue.com/legal/antispampolicy" style="color:#7e7e7e;" target="_blank">Anti-spam & emailing policy</a> | <a href="https://www.sendinblue.com/legal/generalterms" style="color:#7e7e7e;" target="_blank">General Terms and Conditions</a></div>
133
  </td>
134
  </tr>
135
  </tbody>
@@ -152,4 +140,4 @@
152
  <br>
153
  </div>
154
  </body>
155
- </html>
12
  <tbody>
13
  <tr style="border-collapse:collapse;">
14
  <td style="border-collapse:collapse;" align="center">
 
 
 
 
 
 
 
 
15
  <table width="570" border="0" cellpadding="0"
16
  cellspacing="0">
17
  <tbody>
18
  <tr>
19
  <td align="" valign="middle">
20
  <h1 style="margin:0;color:#2f8bee;font-family:arial,sans-serif">
21
+ <img alt="Sendinblue" src="https://img.mailinblue.com/2078867/images/rnb/original/5f23e70ece3f8084987faf06.png" width="250px"></h1>
22
  </td>
23
  </tr>
24
  </tbody>
104
  <div style="font-family:arial,sans-serif; font-size:12px; margin:0; line-height:16px; color:#7e7e7e;">
105
  <strong style="color:#2f8bee;">Sendinblue</strong></div>
106
  <div style="font-family:arial,sans-serif; font-size:12px; margin:0; line-height:16px; color:#7e7e7e;">
107
+ 7, rue de Madrid</div>
108
  <div style="font-family:arial,sans-serif; font-size:12px; margin:0; line-height:16px; color:#7e7e7e;">
109
+ 75008 Paris - France</div>
 
 
110
  <div style="font-family:arial,sans-serif; font-size:12px; margin:0; line-height:16px; color:#7e7e7e;">
111
  <a href="https://www.sendinblue.com" style="color:#2f8bee;" target="_blank">www.sendinblue.com</a></div>
112
  </td>
113
  <td align="right" valign="top">
114
  <div style="font-family:arial,sans-serif; font-size:12px; margin:0; line-height:20px; color:#7e7e7e;">
115
+ <a href="http://www.facebook.com/Sendinblue" style="color:#2f8bee; text-decoration:none;" target="_blank"> <img alt="Facebook" src="https://my.sendinblue.com/public/upload/14406/images/523693143fe88.gif" style="border:none;"> </a> <a href="https://twitter.com/Sendinblue" style="color:#2f8bee; text-decoration:none;" target="_blank"> <img alt="Twitter" src="https://my.sendinblue.com/public/upload/14406/images/5236931746c01.gif" style="border:none;"> </a> <a href="https://www.linkedin.com/company/sendinblue" style="color:#2f8bee; text-decoration:none;" target="_blank"> <img alt="Linkedin" src="https://my.sendinblue.com/public/upload/14406/images/5236931ad253b.gif" style="border:none;"> </a></div>
 
 
116
  <div style="font-family:arial,sans-serif; font-size:10px; margin:0; line-height:14px; color:#7e7e7e;">
117
  This is an automatic message generated by Sendinblue.</div>
118
  <div style="font-family:arial,sans-serif; font-size:10px; margin:0; line-height:14px; color:#7e7e7e;">
119
  Do not respond, you wouldn't receive any answer.</div>
120
+ <div style="font-family:arial,sans-serif; font-size:10px; margin:0; line-height:14px; color:#7e7e7e;"><a href="https://www.sendinblue.com/legal/antispampolicy" style="color:#7e7e7e;" target="_blank">Anti-spam & emailing policy</a></div>
121
  </td>
122
  </tr>
123
  </tbody>
140
  <br>
141
  </div>
142
  </body>
143
+ </html>
inc/templates/test/temp_fr-FR.html CHANGED
@@ -12,21 +12,13 @@
12
  <tbody>
13
  <tr style="border-collapse:collapse;">
14
  <td style="border-collapse:collapse;" align="center">
15
- <table width="570" border="0" cellpadding="0"
16
- cellspacing="0">
17
- <tbody>
18
- <tr>
19
- <td style="line-height:0; font-size:0;" height="20"><img src="{shop_logo}" alt="{shop_name}" width="0" height="0"/></td>
20
- </tr>
21
- </tbody>
22
- </table>
23
  <table width="570" border="0" cellpadding="0"
24
  cellspacing="0">
25
  <tbody>
26
  <tr>
27
  <td align="" valign="middle">
28
  <h1 style="margin:0;color:#2f8bee;font-family:arial,sans-serif">
29
- <img alt="Sendinblue" src="http://img.sendinblue.com/14406/images/529f2339c6ece.png"></h1>
30
  </td>
31
  </tr>
32
  </tbody>
@@ -114,20 +106,15 @@
114
  <div style="font-family:arial,sans-serif; font-size:12px; margin:0; line-height:16px; color:#7e7e7e;">
115
  <strong style="color:#2f8bee;">Sendinblue</strong></div>
116
  <div style="font-family:arial,sans-serif; font-size:12px; margin:0; line-height:16px; color:#7e7e7e;">
117
- 118, rue de Tocqueville</div>
118
  <div style="font-family:arial,sans-serif; font-size:12px; margin:0; line-height:16px; color:#7e7e7e;">
119
- 75017 Paris - France</div>
120
- <div style="font-family:arial,sans-serif; font-size:12px; margin:0; line-height:16px; color:#7e7e7e;">
121
- Tél : 0 899 25 30 61</div>
122
  <div style="font-family:arial,sans-serif; font-size:12px; margin:0; line-height:16px; color:#7e7e7e;">
123
  <a href="https://www.sendinblue.com" style="color:#2f8bee;" target="_blank">www.sendinblue.com</a></div>
124
  </td>
125
  <td align="right" valign="top">
126
  <div style="font-family:arial,sans-serif; font-size:12px; margin:0; line-height:20px; color:#7e7e7e;">
127
- <a href="http://www.facebook.com/Sendinblue" style="color:#2f8bee; text-decoration:none;" target="_blank"> <img alt="Facebook" src="https://my.sendinblue.com/public/upload/14406/images/523693143fe88.gif" style="border:none;"> </a> <a href="https://twitter.com/Sendinblue" style="color:#2f8bee; text-decoration:none;" target="_blank"> <img alt="Twitter" src="https://my.sendinblue.com/public/upload/14406/images/5236931746c01.gif" style="border:none;"> </a> <a href="http://www.linkedin.com/company/mailin" style="color:#2f8bee; text-decoration:none;" target="_blank"> <img alt="Linkedin" src="https://my.sendinblue.com/public/upload/14406/images/5236931ad253b.gif" style="border:none;"> </a> <a href="http://sendinblue.tumblr.com/" style="color:#2f8bee; text-decoration:none;" target="_blank">Blog</a></div>
128
- <div style="font-family:arial,sans-serif; font-size:10px; margin:0; line-height:14px; color:#7e7e7e;"> &copy; 2013-2014 Sendinblue, tous droits
129
- r&eacute;serv&eacute;s.
130
- </div>
131
  <div style="font-family:arial,sans-serif; font-size:10px; margin:0; line-height:14px; color:#7e7e7e;"> Ceci est un message automatique
132
  g&eacute;n&eacute;r&eacute; par Sendinblue.
133
  </div>
@@ -135,8 +122,7 @@
135
  recevriez aucune r&eacute;ponse.
136
  </div>
137
  <div style="font-family:arial,sans-serif; font-size:10px; margin:0; line-height:14px; color:#7e7e7e;"><a href="https://www.sendinblue.com/legal/antispampolicy" style="color:#7e7e7e;" target="_blank">Politique
138
- anti-spam &amp; emailing</a> | <a href="https://www.sendinblue.com/legal/generalterms" style="color:#7e7e7e;" target="_blank">Conditions
139
- g&eacute;n&eacute;rales de ventes</a></div>
140
  </td>
141
  </tr>
142
  </tbody>
@@ -159,4 +145,4 @@
159
  <br>
160
  </div>
161
  </body>
162
- </html>
12
  <tbody>
13
  <tr style="border-collapse:collapse;">
14
  <td style="border-collapse:collapse;" align="center">
 
 
 
 
 
 
 
 
15
  <table width="570" border="0" cellpadding="0"
16
  cellspacing="0">
17
  <tbody>
18
  <tr>
19
  <td align="" valign="middle">
20
  <h1 style="margin:0;color:#2f8bee;font-family:arial,sans-serif">
21
+ <img alt="Sendinblue" src="https://img.mailinblue.com/2078867/images/rnb/original/5f23e70ece3f8084987faf06.png" width="250px"></h1>
22
  </td>
23
  </tr>
24
  </tbody>
106
  <div style="font-family:arial,sans-serif; font-size:12px; margin:0; line-height:16px; color:#7e7e7e;">
107
  <strong style="color:#2f8bee;">Sendinblue</strong></div>
108
  <div style="font-family:arial,sans-serif; font-size:12px; margin:0; line-height:16px; color:#7e7e7e;">
109
+ 7, rue de Madrid</div>
110
  <div style="font-family:arial,sans-serif; font-size:12px; margin:0; line-height:16px; color:#7e7e7e;">
111
+ 75008 Paris - France</div>
 
 
112
  <div style="font-family:arial,sans-serif; font-size:12px; margin:0; line-height:16px; color:#7e7e7e;">
113
  <a href="https://www.sendinblue.com" style="color:#2f8bee;" target="_blank">www.sendinblue.com</a></div>
114
  </td>
115
  <td align="right" valign="top">
116
  <div style="font-family:arial,sans-serif; font-size:12px; margin:0; line-height:20px; color:#7e7e7e;">
117
+ <a href="http://www.facebook.com/Sendinblue" style="color:#2f8bee; text-decoration:none;" target="_blank"> <img alt="Facebook" src="https://my.sendinblue.com/public/upload/14406/images/523693143fe88.gif" style="border:none;"> </a> <a href="https://twitter.com/Sendinblue" style="color:#2f8bee; text-decoration:none;" target="_blank"> <img alt="Twitter" src="https://my.sendinblue.com/public/upload/14406/images/5236931746c01.gif" style="border:none;"> </a> <a href="https://www.linkedin.com/company/sendinblue" style="color:#2f8bee; text-decoration:none;" target="_blank"> <img alt="Linkedin" src="https://my.sendinblue.com/public/upload/14406/images/5236931ad253b.gif" style="border:none;"> </a></div>
 
 
 
118
  <div style="font-family:arial,sans-serif; font-size:10px; margin:0; line-height:14px; color:#7e7e7e;"> Ceci est un message automatique
119
  g&eacute;n&eacute;r&eacute; par Sendinblue.
120
  </div>
122
  recevriez aucune r&eacute;ponse.
123
  </div>
124
  <div style="font-family:arial,sans-serif; font-size:10px; margin:0; line-height:14px; color:#7e7e7e;"><a href="https://www.sendinblue.com/legal/antispampolicy" style="color:#7e7e7e;" target="_blank">Politique
125
+ anti-spam &amp; emailing</a></div>
 
126
  </td>
127
  </tr>
128
  </tbody>
145
  <br>
146
  </div>
147
  </body>
148
+ </html>
model/model-users.php CHANGED
@@ -237,10 +237,11 @@ class SIB_Model_Users {
237
  /** Add column to the table */
238
  public static function add_user_added_date_column() {
239
  global $wpdb;
240
- $row = $wpdb->get_results( "SELECT 'user_added_date' FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = '" . $wpdb->prefix . self::TABLE_NAME . "' AND column_name = 'user_added_date'" );
 
241
 
242
- if ( empty( $row ) ) {
243
- $query = 'ALTER TABLE ' . $wpdb->prefix . self::TABLE_NAME . ' ADD user_added_date DATETIME NOT NULL';
244
  $wpdb->query( $query );
245
  }
246
  }
237
  /** Add column to the table */
238
  public static function add_user_added_date_column() {
239
  global $wpdb;
240
+ $user_added = 'user_added_date';
241
+ $result = $wpdb->query( $wpdb->prepare( 'SHOW COLUMNS FROM ' . $wpdb->prefix . self::TABLE_NAME . ' LIKE %s ', $user_added ) ); // db call ok; no-cache ok.
242
 
243
+ if ( empty( $result ) ) {
244
+ $query = 'ALTER TABLE ' . $wpdb->prefix . self::TABLE_NAME . ' ADD COLUMN user_added_date DATETIME NOT NULL';
245
  $wpdb->query( $query );
246
  }
247
  }
readme.txt CHANGED
@@ -116,8 +116,12 @@ In order to create a signup form, you need to:
116
 
117
  == Changelog ==
118
 
 
 
 
 
119
  = 3.1.21 =
120
- * Fixed an issue with all templates on Sendinblue account not showing on plugin configuration..
121
 
122
  = 3.1.20 =
123
  * Fixing issue with plugin deactivation on update.
116
 
117
  == Changelog ==
118
 
119
+ = 3.1.22 =
120
+ * Improved the content of test email.
121
+ * Fixed an issue related to slowness of plugin because of a mysql query.
122
+
123
  = 3.1.21 =
124
+ * Fixed an issue with all templates on Sendinblue account not showing on plugin configuration.
125
 
126
  = 3.1.20 =
127
  * Fixing issue with plugin deactivation on update.
sendinblue.php CHANGED
@@ -3,7 +3,7 @@
3
  * Plugin Name: Newsletter, SMTP, Email marketing and Subscribe forms by Sendinblue
4
  * Plugin URI: https://www.sendinblue.com/?r=wporg
5
  * Description: Manage your contact lists, subscription forms and all email and marketing-related topics from your wp panel, within one single plugin
6
- * Version: 3.1.21
7
  * Author: Sendinblue
8
  * Author URI: https://www.sendinblue.com/?r=wporg
9
  * License: GPLv2 or later
3
  * Plugin Name: Newsletter, SMTP, Email marketing and Subscribe forms by Sendinblue
4
  * Plugin URI: https://www.sendinblue.com/?r=wporg
5
  * Description: Manage your contact lists, subscription forms and all email and marketing-related topics from your wp panel, within one single plugin
6
+ * Version: 3.1.22
7
  * Author: Sendinblue
8
  * Author URI: https://www.sendinblue.com/?r=wporg
9
  * License: GPLv2 or later