Changeset 219 for trunk/database.php

Timestamp:

May 27, 2009, 1:17:11 PM (15 years ago)

Author:

george

Message:

• Přidáno: Podpora pro odesílání emailů o měsíčních platbách přes frontu emailů.

File:

• trunk/database.php (modified) (4 diffs)

trunk/database.php

@@ -4 +4 @@
 // Date: 2009-02-16
 
+
 class Database extends mysqli
 {
   var $Prefix = '';
+  var $Functions = array('NOW()', 'CURDATE()', 'CURTIME()', 'UUID()');
   
   function query($Query)
   {
-        global $Config;
+          global $Config;
         
-        if($Config['Web']['ShowSQLQuery'] == true) 
-          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>');
-        $Result = parent::query($Query);
+          if($Config['Web']['ShowSQLQuery'] == true) 
+            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>');
+          $Result = parent::query($Query);
     if(($this->error != '') and ($Config['Web']['ShowSQLError'] == true)) 
           echo('<div><strong>SQL Error: </strong>'.$this->error.'<br />'.$Query.'</div>');
@@ -39 +41 @@
       $Value = strtr($Value, '"', '\"');
       $Name .= ',`'.$Key.'`';
-            if($Value == 'NOW()') $Values .= ",".$Value;
-else if($Value == 'UUID()') $Values .= ",".$Value;
-              else $Values .= ",'".$Value."'";
+            if(!in_array($Value, $this->Functions)) $Value = '"'.$Value.'"';
+      $Values .= ','.$Value;
     }
     $Name = substr($Name, 1);
@@ -54 +55 @@
     {
             $Value = strtr($Value, '"', '\"');
-      if($Value != 'NOW()') $Value = "'".$Value."'";
+            if(!in_array($Value, $this->Functions)) $Value = '"'.$Value.'"';
       $Values .= ', '.$Key.'='.$Value;
     }
@@ -68 +69 @@
     {
       $Value = strtr($Value, '"', '\"');
+            if(!in_array($Value, $this->Functions)) $Value = '"'.$Value.'"';
       $Name .= ',`'.$Key.'`';
-      if($Value == 'NOW()') $Values .= ','.$Value;
-        else $Values .= ',"'.$Value.'"';
+      $Values .= ','.$Value;
     }
     $Name = substr($Name, 1);