Closes #493: Moved database queries out of module and in to core in line with best practice.

git-svn-id: https://code.elgg.org/elgg/trunk@2369 36083f99-b078-4883-b0ff-0f9b5a30f544

1 files changed, 11 insertions, 1 deletions

diff --git a/engine/lib/database.php b/engine/lib/database.php
index c46d6023f..e1f007399 100644
--- a/engine/lib/database.php
+++ b/engine/lib/database.php
@@ -368,7 +368,17 @@
         		return false;

         	

         	return $tables;

-        }

+        }
+        
+    /**
+     * Run an optimize query on a mysql tables. Useful for executing after major data changes. 
+     *
+     */
+    	function optimize_table($table)
+    	{
+    		$table = sanitise_string($table);
+    		return update_data("optimize table $table");
+    	}

         

 	/**

 	 * Get the last database error for a particular database link