Changeset 19 for trunk/Database.php

Timestamp:

Sep 6, 2019, 9:44:30 AM (5 years ago)

Author:

chronos

Message:

• Fixed: Teams were not imported correctly. Some of them had empty names.

File:

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

trunk/Database.php

@@ -57 +57 @@
     $this->LogFile = dirname(__FILE__).'/../../Query.log';
   }
- 
+
 
   function Connect($Host, $User, $Password, $Database)
@@ -109 +109 @@
       $this->insert_id = $this->PDO->lastInsertId();
     } else
-    {     
+    {
       $this->Error = $this->PDO->errorInfo();
       $this->Error = $this->Error[2];
@@ -134 +134 @@
     $this->insert_id = $this->PDO->lastInsertId();
   }
-  
+
   function GetInsert($Table, $Data)
   {
@@ -158 +158 @@
     $this->query($this->GetUpdate($Table, $Condition, $Data));
   }
-  
+
   function GetUpdate($Table, $Condition, $Data)
   {
@@ -219 +219 @@
   {
   }
-  
+
   public function Transaction($Queries)
   {
-      $this->PDO->beginTransaction();
-      foreach ($Queries as $Query)
-      {
-        $Statement = $this->PDO->prepare($Query);
-        $Statement->execute();
-      }          
-      $this->PDO->commit();
+    $this->PDO->beginTransaction();
+    foreach ($Queries as $Query)
+    {
+      $Statement = $this->PDO->prepare($Query);
+      $Statement->execute();
+    }
+    if (!$this->PDO->commit())
+    {
+      $this->Error = $this->PDO->errorInfo();
+      $this->Error = $this->Error[2];
+      if(($this->Error != '') and ($this->ShowSQLError == true))
+        echo('<div><strong>SQL Error: </strong>'.$this->Error.'<br />'.$Query.'</div>');
+      throw new Exception('SQL Error: '.$this->Error.', Query: '.$Query);
+    }
   }
 }