Changeset 308

Timestamp:

03/09/08 21:48:55 (5 years ago)

Author:

MDMAN

Message:

New Search for new applications for the Info-Box

Files:

• application.register/files/lib/system/event/listener/ApplicationRegisterListener.class.php (modified) (3 diffs)

application.register/files/lib/system/event/listener/ApplicationRegisterListener.class.php

@@ -15 +15 @@
         public $templateName = 'applicationRegister';
         public $count = 0;
+        public $applications = array();
+        public $disables = array();
         
         /**
@@ -22 +24 @@
                 if(self::$check || WCF::getUser()->userID == 0) return;
                 self::$check = true;
-                $a = 0;
-                $b = 0;
+                
                 $c = 0;
-                $sql = "SELECT          COUNT(*) AS a
+
+                $sql = "SELECT          applicationID
                                 FROM            wcf".WCF_N."_group_application application
                                 WHERE           application.groupID IN (
@@ -32 +34 @@
                                                         WHERE   userID = ".WCF::getUser()->userID."
                                                 )
-                                AND                     application.applicationStatus = 0";
+                                AND                     application.applicationStatus = '0'
+                                ";
 
-                $row = WCF::getDB()->getFirstRow($sql);
+                $res = WCF::getDB()->sendQuery($sql);
+                while ($row = WCF::getDB()->fetchArray($res)){
+                        $this->applications[]= $row["applicationID"];
+                }
                 
-                $a = $row['a'];
+                $sql = "SELECT          applicationID
+                                FROM            wcf".WCF_N."_group_application_notification
+                                WHERE           userID = ".WCF::getUser()->userID."
+                                ";
                 
-                $sql = "SELECT          COUNT(*) AS b
-                                FROM            wcf".WCF_N."_group_application_notification notification
-                                WHERE           userID = ".WCF::getUser()->userID."
-                                ";
-                                
-                $row = WCF::getDB()->getFirstRow($sql);
+                $res = WCF::getDB()->sendQuery($sql);
+                while ($row = WCF::getDB()->fetchArray($res)){
+                        $this->disables[]= $row["applicationID"];
+                }
+                if (isset ($this->disables)){
+                $result = array_diff($this->applications, $this->disables);
+                }
+
+                if (isset($result)){
+                $c = count($result);
+                }
+                if ($c > 0){            
                 
-                $b = $row['b'];
-                
-                $c = $a - $b;
-
-                if ($c > 0){
                         //Hier werden die Variablen im Template registriert
                         WCF::getTPL()->assign(array(
-                                'count' => $c
+                                'count' => $c,
                         ));