Changeset 46 for trunk/Base/Database.php

Timestamp:

Jul 27, 2014, 9:05:14 PM (10 years ago)

Author:

chronos

Message:

• Opraveno: SQL aktualizace 40 plus chybějící tabulka MeasureMethod.
• Opraveno: Neplatné ukázkové konfigurační soubory.

File:

• trunk/Base/Database.php (modified) (5 diffs)

trunk/Base/Database.php

@@ -10 +10 @@
   var $ShowSQLQuery = false;
   var $ShowSQLError = false;
-  
+
   function query($Query)
-  {  
+  {
     if($this->ShowSQLQuery)
     {
-      if(isset($_SERVER['REMOTE_ADDR'])) echo('<div style="border-bottom-width: 1px; border-bottom-style: solid; padding-bottom: 3px; padding-top: 3px; font-size: 12px; font-family: Arial;">'.$Query.'</div>'); 
+      if(isset($_SERVER['REMOTE_ADDR'])) echo('<div style="border-bottom-width: 1px; border-bottom-style: solid; padding-bottom: 3px; padding-top: 3px; font-size: 12px; font-family: Arial;">'.$Query.'</div>');
       else echo($Query."\n");
     }
@@ -25 +25 @@
     }
 
-    return($Result);  
+    return($Result);
   }
 
   function select($Table, $What = '*', $Condition = 1)
   {
-    return($this->query('SELECT '.$What.' FROM `'.$this->Prefix.$Table.'` WHERE '.$Condition));  
+    return($this->query('SELECT '.$What.' FROM `'.$this->Prefix.$Table.'` WHERE '.$Condition));
   }
 
   function delete($Table, $Condition)
   {
-    $this->query('DELETE FROM `'.$this->Prefix.$Table.'` WHERE '.$Condition);  
+    $this->query('DELETE FROM `'.$this->Prefix.$Table.'` WHERE '.$Condition);
   }
-  
+
   function insert($Table, $Data)
   {
@@ -50 +50 @@
     $Name = substr($Name, 1);
     $Values = substr($Values, 1);
-    $this->query('INSERT INTO `'.$this->Prefix.$Table.'` ('.$Name.') VALUES('.$Values.')'); 
+    $this->query('INSERT INTO `'.$this->Prefix.$Table.'` ('.$Name.') VALUES('.$Values.')');
   }
-  
+
   function update($Table, $Condition, $Data)
   {
@@ -61 +61 @@
       $Values .= ', `'.$Key.'`='.$Value;
     }
-    $Values = substr($Values, 2);  
+    $Values = substr($Values, 2);
     $this->query('UPDATE `'.$this->Prefix.$Table.'` SET '.$Values.' WHERE ('.$Condition.')');
   }
-  
+
   function replace($Table, $Data)
   {
@@ -79 +79 @@
     //echo('REPLACE INTO `'.$this->Prefix.$Table.'` ('.$Name.') VALUES ('.$Values.')<br />');
     $this->query('REPLACE INTO `'.$this->Prefix.$Table.'` ('.$Name.') VALUES('.$Values.')');
-    //echo($this->error().'<br>');
+    //echo($this->error().'<br/>');
   }
-  
+
   function charset($Charset)
   {