appdb/include appData.php

[WineHQ]

ChangeSet ID:	30845
CVSROOT:	/opt/cvs-commit
Module name:	appdb
Changes by:	[e-mail]	2006/12/31 13:48:07

Added files:
    include        : appData.php

Log message:
    Alexander Nicolaysen Sørnes 
    Add file necessary for displaying queued item lists

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

Old revision  New revision  Changes     Path
 Added         1.1           +0 -0       appdb/include/appData.php

Index: appdb/include/appData.php
diff -u -p /dev/null appdb/include/appData.php:1.1
--- /dev/null	31 Dec 2006 19:48: 7 -0000
+++ appdb/include/appData.php	31 Dec 2006 19:48: 7 -0000
@@ -0,0 +1,56 @@
+<?php
+
+/**
+ * Functions related to application data
+ */
+
+require_once(BASE."include/util.php");
+
+class appData
+{
+    function listSubmittedBy($iUserId, $bQueued = true)
+    {
+        $hResult = query_parameters("SELECT appData.TYPE, appData.appId,
+            appData.versionId, appData.description, appData.submitTime,
+            appFamily.appName, appVersion.versionName FROM appData,
+            appFamily, appVersion
+                WHERE (appFamily.appId = appData.appId OR
+                (appData.versionId = appVersion.versionId AND appFamily.appId =
+                appVersion.appId)) AND (appFamily.queued = '?' OR
+                appVersion.queued = '?') AND appData.submitterId = '?' AND
+                appData.queued = '?'
+                    ORDER BY appData.id",
+                        "false", "false", $iUserId, $bQueued ? "true" : "false");
+
+        if(!$hResult || !mysql_num_rows($hResult))
+            return false;
+
+        $sReturn .= html_table_begin("width=\"100%\" align=\"center\"");
+        $sReturn .= html_tr(array(
+            "Version",
+            "Type",
+            "Description",
+            "Submission Date"),
+            "color4");
+
+        for($i = 1; $oRow = mysql_fetch_object($hResult); $i++)
+        {
+            $sReturn .= html_tr(array(
+                $oRow->versionId ?
+                "<a href=\"".BASE."appview.php?iVersionId=$oRow->versionId\">".
+                "$oRow->appName: $oRow->versionName</a>" :
+                "<a href=\"".BASE."appview.php?iAppId=$oRow->appId\">".
+                "$oRow->appName</a>",
+                $oRow->TYPE,
+                $oRow->description,
+                print_date(mysqltimestamp_to_unixtimestamp($oRow->submitTime))),
+                ($i % 2) ? "color0" : "color1");
+        }
+
+        $sReturn .= html_table_end("");
+
+        return $sReturn;
+    }
+}
+
+?>