appdb/ include/vendor.php tables/appdb_tables.sql

[WineHQ]

ChangeSet ID:	31083
CVSROOT:	/opt/cvs-commit
Module name:	appdb
Changes by:	[e-mail]	2007/04/21 19:57:41

Modified files:
    include        : vendor.php 
    tables         : appdb_tables.sql

Log message:
    Alexander Nicolaysen Sørnes 
    Support vendor queuing

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

Old revision  New revision  Changes     Path
 1.22          1.23          +21 -6      appdb/include/vendor.php
 1.31          1.32          +5 -4       appdb/tables/appdb_tables.sql

Index: appdb/include/vendor.php
diff -u -p appdb/include/vendor.php:1.22 appdb/include/vendor.php:1.23
--- appdb/include/vendor.php:1.22	22 Apr 2007  0:57:41 -0000
+++ appdb/include/vendor.php	22 Apr 2007  0:57:41 -0000
@@ -61,12 +61,10 @@ class Vendor {
      */
     function create()
     {
-        if(!$this->canEdit())
-            return FALSE;
-
-        $hResult = query_parameters("INSERT INTO vendor (vendorName, vendorURL) ".
-                                    "VALUES ('?', '?')",
-                                        $this->sName, $this->sWebpage);
+        $hResult = query_parameters("INSERT INTO vendor (vendorName, vendorURL, queued) ".
+                                    "VALUES ('?', '?', '?')",
+                                        $this->sName, $this->sWebpage,
+                                        $this->mustBeQueued() ? "true" : "false");
         if($hResult)
         {
             $this->iVendorId = mysql_insert_id();
@@ -80,6 +78,23 @@ class Vendor {
         }
     }

+    /**
+     * Un-queue vendor
+     * Returns TRUE or FALSE
+     */
+    function unQueue()
+    {
+        if(!$this->canEdit())
+            return FALSE;
+
+        $hResult = query_parameters("UPDATE vendor SET queued = '?' WHERE vendorId = '?'",
+                                       'false', $this->iVendorId);
+
+        if(!$hResult)
+            return FALSE;
+
+        return TRUE;
+    }

/**
      * Update vendor.
Index: appdb/tables/appdb_tables.sql
diff -u -p appdb/tables/appdb_tables.sql:1.31 appdb/tables/appdb_tables.sql:1.32
--- appdb/tables/appdb_tables.sql:1.31	22 Apr 2007  0:57:41 -0000
+++ appdb/tables/appdb_tables.sql	22 Apr 2007  0:57:41 -0000
@@ -20,9 +20,10 @@ drop table if exists sessionMessages;
  * vendor information
  */
 create table vendor (
-       vendorId   int not null auto_increment,
-       vendorName	varchar(100) not null,
-       vendorURL  varchar(200),
+       vendorId         int not null auto_increment,
+       vendorName       varchar(100) not null,
+       vendorURL        varchar(200),
+       queued           enum('true','false') NOT NULL default 'false',
        key(vendorId)
 );

@@ -31,7 +32,7 @@ create table vendor (
  * application
  */
 create table appFamily (
-	appId	        int not null auto_increment,
+	appId	      int not null auto_increment,
    appName       varchar(100) not null,
    vendorId      int not null,
    keywords      text,