Changeset 201

Timestamp:

Apr 27, 2009, 9:55:00 AM (15 years ago)

Author:

george

Message:

• Upraveno: Pozměněna tabulka pro doménové aliasy.

Location:

trunk

Files:

• sql/updates/201.sql (added)
• system/generators/dns.php (modified) (3 diffs)

trunk/system/generators/dns.php

@@ -49 +49 @@
 }
 
-$DbResult = $Database->select('network_dns_alias', '*');
+$DbResult = $Database->select('NetworkDomainAlias', '*');
 while($Alias = $DbResult->fetch_array())
 {
-  $Data = strtolower($Alias['name']);
-  if(strlen($Data) < 8) $Data .= "\t";
-  fputs($File, $Data."\tIN\tCNAME\t".$Alias['target']."\n");
+  $Data = strtolower($Alias['Name']);
+  if(strlen($Data) < 8) $Data .= "\t";
+  fputs($File, $Data."\tIN\tCNAME\t".$Alias['Target']."\n");
 }
 
@@ -147 +147 @@
 }
 
-$DbResult = $Database->query("SELECT network_dns_alias.* FROM  `network_dns_alias` JOIN  `hosts`  ON network_dns_alias.target LIKE hosts.name AND hosts.external_ip != ''");
+$DbResult = $Database->query('SELECT NetworkDomainAlias.* FROM  `NetworkDomainAlias` JOIN  `hosts`  ON NetworkDomainAlias.Target LIKE hosts.name AND hosts.external_ip != ""');
 while($Alias = $DbResult->fetch_array())
 {
-  $Data = strtolower($Alias['name']);
-  if(strlen($Data) < 8) $Data .= "\t";
-  fputs($File, $Data."\tIN\tCNAME\t".$Alias['target']."\n");
+  $Data = strtolower($Alias['Name']);
+  if(strlen($Data) < 8) $Data .= "\t";
+  fputs($File, $Data."\tIN\tCNAME\t".$Alias['Target']."\n");
 }
 
@@ -237 +237 @@
 }
 
-$DbResult = $Database->query("SELECT network_dns_alias.* FROM  `network_dns_alias` JOIN  `hosts`  ON network_dns_alias.target LIKE hosts.name AND hosts.czfree_ip != ''");
+$DbResult = $Database->query('SELECT NetworkDomainAlias.* FROM `NetworkDomainAlias` JOIN `hosts`  ON NetworkDomainAlias.Target LIKE hosts.name AND hosts.czfree_ip != ""');
 while($Alias = $DbResult->fetch_array())
 {
-  $Data = $Alias['name'];
-  if(strlen($Data) < 8) $Data .= "\t";
-  fputs($File, $Data."\tIN\tCNAME\t".$Alias['target']."\n");
-  fputs($File2, $Data."\tIN\tCNAME\t".$Alias['target']."\n");
+  $Data = $Alias['Name'];
+  if(strlen($Data) < 8) $Data .= "\t";
+  fputs($File, $Data."\tIN\tCNAME\t".$Alias['Target']."\n");
+  fputs($File2, $Data."\tIN\tCNAME\t".$Alias['Target']."\n");
 }
 fclose($File);