appdb/include monitor.php sidebar_login.php

[WineHQ]

ChangeSet ID:	30616
CVSROOT:	/opt/cvs-commit
Module name:	appdb
Changes by:	[e-mail]	2006/12/15 21:20:37

Modified files:
    include        : monitor.php sidebar_login.php

Log message:
    Alexander Nicolaysen Sørnes 
    Add a list of the user's monitored versions to the sidebar.

Patch: http://cvs.winehq.org/patch.py?id=30616

Old revision  New revision  Changes     Path
 1.9           1.10          +17 -1      appdb/include/monitor.php
 1.17          1.18          +11 -0      appdb/include/sidebar_login.php

Index: appdb/include/monitor.php
diff -u -p appdb/include/monitor.php:1.9 appdb/include/monitor.php:1.10
--- appdb/include/monitor.php:1.9	16 Dec 2006  3:20:37 -0000
+++ appdb/include/monitor.php	16 Dec 2006  3:20:37 -0000
@@ -135,6 +135,22 @@ class Monitor {
         $sEmail = User::get_notify_email_address_list(null, $this->iVersionId);
         if($sEmail)
             mail_appdb($sEmail, $sSubject ,$sMsg);
-    } 
+    }
+
+    /* Retrieve the user's monitored versions */
+    function getVersionsMonitored($oUser)
+    {
+         $hResult = query_parameters("SELECT appId, versionId FROM appMonitors WHERE userId = '?'", $oUser->iUserId);
+
+         if(!$hResult || mysql_num_rows($hResult) == 0)
+             return NULL;
+
+         $aVersionsMonitored = array();
+
+         for($i = 0; $oRow = mysql_fetch_object($hResult); $i++)
+             $aVersionsMonitored[$i] = array($oRow->appId, $oRow->versionId);
+
+         return $aVersionsMonitored;
+    }
 }
 ?>
Index: appdb/include/sidebar_login.php
diff -u -p appdb/include/sidebar_login.php:1.17 appdb/include/sidebar_login.php:1.18
--- appdb/include/sidebar_login.php:1.17	16 Dec 2006  3:20:37 -0000
+++ appdb/include/sidebar_login.php	16 Dec 2006  3:20:37 -0000
@@ -6,6 +6,7 @@
 require_once(BASE."include/maintainer.php");
 require_once(BASE."include/application.php");
 require_once(BASE."include/user.php");
+require_once(BASE."include/monitor.php");

function global_sidebar_login() {

@@ -36,6 +37,16 @@ function global_sidebar_login() {
         if($appsRejected)
             $g->addmisc("<a href='".BASE."appsubmit.php?'>Review Rejected Apps</a>", "center");

+        $aMonitored = Monitor::getVersionsMonitored($_SESSION['current']);
+        if($aMonitored)
+        {
+            $g->addmisc("");
+            $g->addmisc("You monitor:\n");
+
+            while(list($i, list($iAppId, $iVersionId)) = each($aMonitored))
+                $g->addmisc("<a href="".BASE."appview.php?iVersionId=$iVersionId">".Application::lookup_name($iAppId)." ".Version::lookup_name($iVersionId)."</a>","center");
+        }
+
     }
     else
     {