Cleanup: various random sql queries found in UI files moved to database interface...

[fa-stable.git] / admin / db / company_db.inc

diff --git a/admin/db/company_db.inc b/admin/db/company_db.inc
index d0f85e4006e6095aa658c1830438c9f45d703527..e1ff68aad48c59a6e1026a32cbfc47cda1a3b1c5 100644 (file)
--- a/admin/db/company_db.inc
+++ b/admin/db/company_db.inc
@@ -193,4 +193,27 @@ function key_in_foreign_table($id, $tables, $stdkey)
        return $count[0];
 }
 
+//---------------------------------------------------------------------------------------------
+//
+// Resets $theme references in users records to 'default'.
+//
+function clean_user_themes($theme)
+{
+       global $db_connections, $db, $installed_extensions;
+
+       $comp = user_company();
+
+       foreach ($db_connections as $n => $conn) {
+               $db = $_SESSION["wa_current_user"]->set_db_connection($n);
+               $sql = "UPDATE {$conn['tbpref']}users SET theme='default' WHERE theme='$theme'";
+               if (!db_query($sql, 'Cannot update user theme settings'))
+                       return false;
+       }
+       $db = $_SESSION["wa_current_user"]->set_db_connection($comp);
+
+       $_SESSION['wa_current_user']->prefs->theme = 'default';
+       return true;
+}
+
+
 ?>
\ No newline at end of file