Changeset 2198

Timestamp:

04/16/10 00:26:11 (13 years ago)

Author:

Moe

Message:

Subscribe to comments 1.3.1 :

• updated template file
• force type of integers in SQL queries, I don't remember why

Location:

plugins/subscribeToComments

Files:

• _define.php (modified) (1 diff)
• _public.php (modified) (1 diff)
• default-templates/subscribetocomments.html (modified) (4 diffs)
• inc/class.subscriber.php (modified) (5 diffs)
• locales/fr/public.lang.php (modified) (3 diffs)

plugins/subscribeToComments/_define.php

@@ -30 +30 @@
      /* Description*/                "Subscribe to comments by email",
      /* Author */                    "Moe (http://gniark.net/)",
-     /* Version */                   '1.3',
+     /* Version */                   '1.3.1',
      /* Permissions */               'admin'
 );

plugins/subscribeToComments/_public.php

@@ -29 +29 @@
 
 $core->tpl->addBlock('SubscribeToCommentsIsActive',
-          'subscribeToCommentsIsActive');
+     'subscribeToCommentsIsActive');
 
 function subscribeToCommentsIsActive($attr,$content)

plugins/subscribeToComments/default-templates/subscribetocomments.html

@@ -47 +47 @@
                });
      });
+     
+     /* l10n */
+     prompt_allow = '{{tpl:lang Allow emails?}}';
+     prompt_block = '{{tpl:lang Block emails?}}';
+     prompt_delete = '{{tpl:lang Delete the account?}}';
      //]]>
      </script>
@@ -181 +186 @@
                                         value="{{tpl:lang Allow emails}}"
                                         onclick="javascript:return(
-                                        window.confirm('{{tpl:lang Allow emails?}}'));" />
+                                        window.confirm(prompt_allow));" />
                               </tpl:SubscribeToCommentsBlockedIf>
                               <tpl:SubscribeToCommentsBlockedIfNot>
@@ -187 +192 @@
                                         value="{{tpl:lang Block emails}}"
                                         onclick="javascript:return(
-                                        window.confirm('{{tpl:lang Block emails?}}'));" />
+                                        window.confirm(prompt_block));" />
                               </tpl:SubscribeToCommentsBlockedIfNot>
                          </p>
@@ -194 +199 @@
                                    value="{{tpl:lang Delete all subscriptions and the account}}"
                                    onclick="javascript:return(
-                                        window.confirm('{{tpl:lang Delete the account?}}'));" />
+                                        window.confirm(prompt_delete));" />
                          </p>
                     </fieldset>              

plugins/subscribeToComments/inc/class.subscriber.php

@@ -57 +57 @@
           
           $rs = $core->con->select('SELECT user_key FROM '.$core->prefix.
-               'comment_subscriber WHERE (id = \''.$core->con->escape($this->id).'\') '.
+               'comment_subscriber WHERE (id = \''.
+               $core->con->escape((int) $this->id).'\') '.
                'AND (email = \''.$core->con->escape($this->email).'\');');
           
@@ -411 +412 @@
           $rs = $core->con->select('SELECT status FROM '.
                $core->prefix.'comment_subscriber '.
-               'WHERE (id = \''.$core->con->escape($id).'\') '.
+               'WHERE (id = \''.$core->con->escape((int) $id).'\') '.
                'AND (user_key = \''.$core->con->escape($key).'\');');
           if ($rs->isEmpty())
@@ -429 +430 @@
      {
           global $core;
-
+          
           return(subscribeToComments::url().
           (($core->blog->settings->url_scan == 'query_string') ? '&' : '?').'email='.
@@ -469 +470 @@
                $rs = $core->con->select('SELECT email FROM '.
                     $core->prefix.'comment_subscriber '.
-                    'WHERE (id = \''.$core->con->escape($id).'\');');
+                    'WHERE (id = \''.$core->con->escape((int) $id).'\');');
 
                if ($rs->isEmpty())
@@ -515 +516 @@
           $cur->temp_key = null;
           $cur->temp_expire = null;
-          $cur->update('WHERE (id = \''.$core->con->escape($rs->id).'\') '.
+          $cur->update('WHERE (id = \''.$core->con->escape((int) $rs->id).'\') '.
           'AND (temp_key = \''.$core->con->escape($temp_key).'\');');
 

plugins/subscribeToComments/locales/fr/public.lang.php

@@ -46 +46 @@
 $GLOBALS['__l10n']['Account'] = 'Compte';
 
-$GLOBALS['__l10n']['Allow emails ?'] = 'Autoriser les emails ?';
+$GLOBALS['__l10n']['Allow emails?'] = 'Autoriser les emails ?';
 
 $GLOBALS['__l10n']['Allow emails'] = 'Autoriser les emails';
 
-$GLOBALS['__l10n']['Block emails ?'] = 'Bloquer les emails ?';
+$GLOBALS['__l10n']['Block emails?'] = 'Bloquer les emails ?';
 
 $GLOBALS['__l10n']['Block emails'] = 'Bloquer les emails';
@@ -60 +60 @@
 $GLOBALS['__l10n']['Delete all subscriptions and the account'] = 'Supprimer tous les abonnements et le compte';
 
-$GLOBALS['__l10n']['Delete the account ?'] = 'Supprimer le compte ?';
+$GLOBALS['__l10n']['Delete the account?'] = 'Supprimer le compte ?';
 
 $GLOBALS['__l10n']['Entries'] = 'Billets';
@@ -66 +66 @@
 $GLOBALS['__l10n']['Get back to'] = 'Revenir à';
 
-$GLOBALS['__l10n']['Remove selected subscriptions ?'] = 'Supprimer les abonnements sélectionnés ?';
+$GLOBALS['__l10n']['Remove selected subscriptions?'] = 'Supprimer les abonnements sélectionnés ?';
 
 $GLOBALS['__l10n']['Remove selected subscriptions'] = 'Supprimer les abonnements sélectionnés';