Changeset 698 for trunk/phpbms/modules

Timestamp:

12/31/09 16:28:12 (2 years ago)

Author:

nate

Message:

• Removed unused function in bms/install/update.php
• Fixed aritem relatedid update in generateuuids.php
• Fixed sql statement in aritems.php

Location:

trunk/phpbms/modules/bms

Files:

• include/aritems.php (modified) (1 diff)
• install/update.php (modified) (1 diff)
• install/updatev0.98.sql (modified) (1 diff)

trunk/phpbms/modules/bms/include/aritems.php

@@ -121 +121 @@
                         if($this->aritem["type"] == "deposit")
                                 $querystatement.="
-                                        AND receipts.uuid != ".mysql_real_escape_string($this->aritem["relatedid"]);
+                                        AND receipts.uuid != '".mysql_real_escape_string($this->aritem["relatedid"])."'";
 
                         $querystatement.=

trunk/phpbms/modules/bms/install/update.php

@@ -447 +447 @@
         }//end function v098UpdatePostingSession
 
-        /**
-         * function v098UpdateProducts
-         * Updates the categoryid field from the category's id to uuid.
-         */
-
-        function v098UpdateProducts() {
-
-                $querystatement = "
-                        SELECT
-                                `id`,
-                                `uuid`
-                        FROM
-                                `productcategories`
-                        ";
-
-                $queryresult = $this->db->query($querystatement);
-
-                while($therecord = $this->db->fetchArray($queryresult)){
-
-                        $id = $therecord["id"];
-                        $uuid = $therecord["uuid"];
-
-                        $updatestatement = "
-                                UPDATE
-                                        `products`
-                                SET
-                                        `categoryid`='".$uuid."'
-                                WHERE
-                                        `categoryid`='".$id."'
-                                ";
-
-                        $this->db->query($updatestatement);
-
-                }//end while
-
-        }//end method --v098UpdateProducts00
-
 }//end class updateBMS
 

trunk/phpbms/modules/bms/install/updatev0.98.sql

@@ -750 +750 @@
 --end tablegroupings UPDATE--
 --tableoptions DELETE--
-DELETE FROM `tableoptions WHERE `name`='massEmail';
+DELETE FROM `tableoptions` WHERE `name`='massEmail';
 --end tableoptions DELETe
 --tableoptions INSERT--