Index: lams_build/deploy-tool/lib/lams-tool-deploy.jar
===================================================================
RCS file: /usr/local/cvsroot/lams_build/deploy-tool/lib/lams-tool-deploy.jar,v
diff -u -r1.15 -r1.16
Binary files differ
Index: lams_tool_deploy/src/java/org/lamsfoundation/lams/tool/deploy/Deploy.java
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_deploy/src/java/org/lamsfoundation/lams/tool/deploy/Deploy.java,v
diff -u -r1.19 -r1.20
--- lams_tool_deploy/src/java/org/lamsfoundation/lams/tool/deploy/Deploy.java	15 Feb 2007 04:48:23 -0000	1.19
+++ lams_tool_deploy/src/java/org/lamsfoundation/lams/tool/deploy/Deploy.java	22 Mar 2007 04:08:01 -0000	1.20
@@ -142,7 +142,7 @@
                     else
                     {
                     	System.out.println("Hiding Tool, valid flags set to 0");
-                    	dbUpdater.activateTool(toolSignature, 0);
+                    	dbUpdater.hideTool(toolSignature);
                     }
                     	
                     System.out.println("Tool update completed");
@@ -228,7 +228,7 @@
             else
             {
             	System.out.println("Hiding tool: " + config.getToolSignature());
-            	dbUpdater.activateTool(config.getToolSignature(), 0);
+            	dbUpdater.hideTool(config.getToolSignature());
             }
             
             System.out.println("Tool Deployed");
Index: lams_tool_deploy/src/java/org/lamsfoundation/lams/tool/deploy/ToolDBUpdater.java
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_deploy/src/java/org/lamsfoundation/lams/tool/deploy/ToolDBUpdater.java,v
diff -u -r1.9 -r1.10
--- lams_tool_deploy/src/java/org/lamsfoundation/lams/tool/deploy/ToolDBUpdater.java	28 Feb 2007 06:37:28 -0000	1.9
+++ lams_tool_deploy/src/java/org/lamsfoundation/lams/tool/deploy/ToolDBUpdater.java	22 Mar 2007 04:08:01 -0000	1.10
@@ -198,6 +198,42 @@
         }
     }
     
+    /**
+     * Hides tool in db based on the flag 
+     * @param toolSig The signature of the tool to activate/de-activate
+     * @throws SQLException
+     */
+    public void hideTool(String toolSig) throws SQLException
+    {
+        Connection conn = getConnection();
+    	PreparedStatement stmt = null;
+    	ResultSet results = null;
+        try
+        {
+            stmt = conn.prepareStatement("UPDATE lams_tool SET valid_flag = 1 WHERE tool_signature  = \"" +toolSig+ "\"");
+            stmt.execute();
+            
+            stmt = conn.prepareStatement("SELECT learning_library_id FROM lams_tool WHERE tool_signature=\""+toolSignature+"\"");
+            results = stmt.executeQuery();
+            
+            if (results.first())
+            {
+	            double llid = results.getDouble("learning_library_id");
+            	
+            	stmt = conn.prepareStatement("UPDATE lams_learning_library SET valid_flag = 0 WHERE learning_library_id  = \"" +llid+ "\"");
+	            stmt.execute();
+            }
+        }
+        catch (SQLException se)
+        {
+        	throw new DeployException("Error hiding tool: " + toolSig);
+        }
+        finally
+        {
+            DbUtils.closeQuietly(stmt);
+        }
+    }
+    
     public String queryTool(String toolSig, String column)
     {
     	Connection conn = getConnection();