Changeset 841 for trunk/Packages/Common

Timestamp:

Dec 31, 2016, 12:19:25 AM (8 years ago)

Author:

chronos

Message:

• Fixed: Use SQL transaction for updating network device online state.

Location:

trunk/Packages/Common

Files:

• Database.php (modified) (1 diff)
• Setup.php (modified) (1 diff)

trunk/Packages/Common/Database.php

@@ -154 +154 @@
     }
     $Values = substr($Values, 2);
-    echo('UPDATE `'.$this->Prefix.$Table.'` SET '.$Values.' WHERE ('.$Condition.')');
+    //echo('UPDATE `'.$this->Prefix.$Table.'` SET '.$Values.' WHERE ('.$Condition.')');
     $this->query('UPDATE `'.$this->Prefix.$Table.'` SET '.$Values.' WHERE ('.$Condition.')');
   }

trunk/Packages/Common/Setup.php

@@ -415 +415 @@
   PRIMARY KEY (`Id`)
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');
-    $this->Database->query("INSERT INTO `'.$this->UpdateManager->VersionTable.'` (`Id`, `Revision`) VALUES
-      (1, '.$DatabaseRevision.');");
+    $this->Database->query("INSERT INTO `".$this->UpdateManager->VersionTable."` (`Id`, `Revision`) VALUES
+      (1, ".$DatabaseRevision.");");
     $this->Database->query("CREATE TABLE IF NOT EXISTS `Module` (
   `Id` int(11) NOT NULL AUTO_INCREMENT,