Changeset 2073 for modules/branches/2.2/ringgroups/install.php

Timestamp:

06/21/06 08:57:12 (7 years ago)

Author:

qldrob

Message:

Here's the rest of the ringgroups changes. Please test!

Files:

• modules/branches/2.2/ringgroups/install.php (modified) (1 diff)

modules/branches/2.2/ringgroups/install.php

@@ -39 +39 @@
-    }
-}
+
+// Version 2.0 upgrade. Yeah. 2.0 baby! 
+$sql = "SELECT remotealert FROM ringgroups";
+$check = $db->getRow($sql, DB_FETCHMODE_ASSOC);
+if(DB::IsError($check)) {
+  // add new field
+    $sql = "ALTER TABLE ringgroups ADD remotealert VARCHAR( 80 ) NULL ;";
+    $result = $db->query($sql);
+    if(DB::IsError($result)) { die($result->getDebugInfo()); }
+
+    $sql = "ALTER TABLE ringgroups ADD needsconf VARCHAR( 10 ) NULL ;";
+    $result = $db->query($sql);
+    if(DB::IsError($result)) { die($result->getDebugInfo()); }
+
+    $sql = "ALTER TABLE ringgroups ADD toolate VARCHAR( 80 ) NULL ;";
+    $result = $db->query($sql);
+    if(DB::IsError($result)) { die($result->getDebugInfo()); }
+}
+
-?>