Changeset 1086

Timestamp:

04/27/09 11:12:29 (14 years ago)

Author:

Tomtom33

Message:

notifications 0.4.3 :

• Fixed bugs to get notifications

Location:

plugins/notifications

Files:

• _define.php (modified) (1 diff)
• _services.php (modified) (1 diff)
• inc/class.notifications.behaviors.php (modified) (4 diffs)

plugins/notifications/_define.php

@@ -17 +17 @@
           /* Description */        'Displays few notifications on administration pages',
           /* Author */             'Tomtom (http://blog.zenstyle.fr/)',
-          /* Version */            '0.4.2',
+          /* Version */            '0.4.3',
           /* Permissions */        'usage',
                                    null,

plugins/notifications/_services.php

@@ -27 +27 @@
           'WHERE N.notification_dt > ('.
           'SELECT MAX(L.log_dt) FROM '.$core->prefix.'log L '.
-          "WHERE 'Tomtom' = L.user_id AND L.log_table = '".$core->prefix."notifications') ".
+          "WHERE '".$core->auth->userID()."' = L.user_id AND L.log_table = '".$core->prefix."notifications') ".
           "AND N.blog_id = '".$core->blog->id."'";
 

plugins/notifications/inc/class.notifications.behaviors.php

@@ -115 +115 @@
 
           if ($config['404'] && $core->url->type == '404') {
-               $msg = sprintf(__('New 404 error page displayed about %s'),'<a href="'.$core->blog->url.$_SERVER['REQUEST_URI'].'">'.__('this URL').'</a>');
+               $msg = sprintf(__('New 404 error page displayed about %s'),'<a href="'.$core->blog->url.$_SERVER['QUERY_STRING'].'">'.__('this URL').'</a>');
                $core->blog->notifications->add('err',$msg);
           }
@@ -137 +137 @@
      public static function update(&$core,$ref = '')
      {
-          $strReq = 'SELECT MAX(log_id) as max FROM '.$core->prefix.'log';
+          $strReq = 'SELECT MAX(log_id) as max, log_table FROM '.$core->prefix.'log '.
+          "WHERE log_table = '".$core->prefix."notifications'";
 
           $id = $core->con->select($strReq)->f(0) + 1;
@@ -143 +144 @@
           $strReq =
           'SELECT log_id, log_dt FROM '.$core->prefix."log WHERE user_id = '".
-          $core->auth->userID()."' GROUP BY log_id";
+          $core->auth->userID()."' AND log_table = '".$core->prefix."notifications' ".
+          "GROUP BY log_id";
 
           $rs = $core->con->select($strReq);
@@ -163 +165 @@
           }
           elseif ($rs->log_dt != $ref) {
-               $cur->update("WHERE user_id = '".$core->auth->userID()."'");
+               $cur->update("WHERE user_id = '".$core->auth->userID()."' AND log_table = '".$core->prefix."notifications'");
           }
      }