Changeset 559 for trunk/phpbms/install

Timestamp:

06/02/09 17:03:56 (3 years ago)

Author:

brieb

Message:

• fixed saved searches and sorts to use uuids
• fixed snapshot uuid mishaps
• fixed tablecolumns insert/updates not working

Location:

trunk/phpbms/install

Files:

• createtables.sql (modified) (1 diff)
• generateuuids.php (modified) (3 diffs)
• updatev0.98.sql (modified) (1 diff)

trunk/phpbms/install/createtables.sql

@@ -274 +274 @@
   sqlclause text,
   type char(3) NOT NULL default 'SCH',
-  roleid varchar(64) NOT NULL,
+  roleid varchar(64),
   PRIMARY KEY  (id),
   KEY tabledefid (tabledefid),

trunk/phpbms/install/generateuuids.php

@@ -110 +110 @@
         //$this->updateFields("tabledefs", array("moduleid"=>$this->moduleList, "editroleid"=>$this->roleList, "addroleid"=>$this->roleList, "searchroleid"=>$this->roleList, "advsearchroleid"=>$this->roleList, "viewsqlroleid"=>$this->roleList));
         //$this->updateFields("tablesearchablefields", array("tabledefid"=>$this->tabledefList));
+        //$this->updateFields("usersearches", array("tabledefid"=>$this->tabledefList, "userid"=>$this->userList, "roleid"=>$this->roleList));
+
+        $this->updateMenuLinks();
+
+        // ======
+        // This stuff probably won't be needed as they will be done during the update
+        //$this->updateFields("widgets", array("moduleid"=>$this->moduleList, "roleid"=>$this->roleList));
 
         return $this->returnJSON(true, "UUID's Generated");
@@ -175 +182 @@
                 ";
 
-//echo $updatestatement."<br />";
+                $updatestatement."<br />";
                 $this->db->query($updatestatement);
 
@@ -230 +237 @@
 
 
+    function updateMenuLinks(){
+
+        $querystatement = "
+            SELECT
+                `id`,
+                `link`
+            FROM
+                `menu`
+            WHERE
+                `link` LIKE 'search.php?id=%'";
+
+        $queryresult = $this->db->query($querystatement);
+
+        while($therecord = $this->db->fetchArray($queryresult)){
+
+            $id = substr($therecord["link"], 14);
+
+            $updatestatement = "
+                UPDATE
+                    `menu`
+                SET
+                    `link` = 'search.php?id=".urlencode($this->tabledefList[$id])."'
+                WHERE
+                    `id` = ".$therecord["id"];
+
+            $this->db->query($updatestatement);
+
+        }//endwhile
+
+
+    }//end function updateMenuLinks
+
+
 }//end class updateAjax
 

trunk/phpbms/install/updatev0.98.sql

@@ -228 +228 @@
     ADD COLUMN `uuid` varchar(64) NOT NULL AFTER `id`,
     MODIFY `tabledefid` VARCHAR(64) NOT NULL,
+    MODIFY `roleid` VARCHAR(64),
     MODIFY `userid` VARCHAR(64) NOT NULL;
 --end usersearches ALTER--