Changeset 37 for system/generators/dns.php

Timestamp:

Jan 31, 2008, 8:38:47 PM (17 years ago)

Author:

george

Message:

Upraveno: Přepsán přístup k databázi přes třídu mysqli v systémové složce.
Odstraněno: Staré verze souborů a staré nepoužité soubory.

Location:

system

Files:

• . (modified) (1 prop)
• generators/dns.php (modified) (11 diffs)

system/generators/dns.php

@@ -1 @@
-<?
-include('global.php');
-include_once('../../html/is/db.php');
-DB_Init('localhost', 'root', '', 'is');
+<?php
+include_once('../../html/global.php');
 
 //$Serial = '2007070601';  // Should be changed on every change
@@ -28 +26 @@
 "\t\t\tMX\t10 mail.zdechov.net.\n");
 
-DB_Select('hosts','*',' block < 2 AND IP <> ""');
-while($Row = DB_Row())
+$DbResult = $Database->select('hosts','*',' block < 2 AND IP <> ""');
+while($Row = $DbResult->fetch_array())
 {
   $Data = strtolower($Row['name']);
@@ -37 +35 @@
 
 // External records in internal server
-DB_Select('hosts','*','external_ip<>""');
-while($Row = DB_Row())
+$DbResult = $Database->select('hosts','*','external_ip<>""');
+while($Row = $DbResult->fetch_array())
 {
   $Data = strtolower($Row['name']).'-ext';
@@ -45 +43 @@
 }
 
-DB_Select('network_dns_alias', '*');
-while($Alias = DB_Row())
+$DbResult = $Database->select('network_dns_alias', '*');
+while($Alias = $DbResult->fetch_array())
 {
   $Data = strtolower($Alias['name']);
@@ -71 +69 @@
   "\t\t\t\t)\n".
   "@\tIN\tNS\tcentrala.zdechov.net.\n\n");
-  DB_Select('hosts','*','IP LIKE "'.$Network.'%"');
-  while($Row = DB_Row())
+  $DbResult = $Database->select('hosts','*','IP LIKE "'.$Network.'%"');
+  while($Row = $DbResult->fetch_array())
   {
     $IP = explode('.',$Row['IP']);
@@ -96 +94 @@
   "\t\t\t\t)\n".
   "@\tIN\tNS\tcentrala.zdechov.net.\n\n");
-  DB_Select('hosts','*','external_ip LIKE "'.$Network.'.%"');
-  while($Row = DB_Row())
+  $DbResult = $Database->select('hosts','*','external_ip LIKE "'.$Network.'.%"');
+  while($Row = $DbResult->fetch_array())
   {
     $IP = explode('.',$Row['external_ip']);
@@ -126 +124 @@
 fputs($File, $Header);
 
-DB_Select('hosts','*','external_ip<>""');
-while($Row = DB_Row())
+$DbResult = $Database->select('hosts','*','external_ip<>""');
+while($Row = $DbResult->fetch_array())
 {
   $Data = strtolower($Row['name']);
@@ -134 +132 @@
 }
 
-DB_Query("SELECT network_dns_alias.* FROM  `network_dns_alias` JOIN  `hosts`  ON network_dns_alias.target LIKE hosts.name AND hosts.external_ip != ''");
-while($Alias = DB_Row())
+$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 != ''");
+while($Alias = $DbResult->fetch_array())
 {
   $Data = strtolower($Alias['name']);
@@ -161 +159 @@
   "@\tIN\tNS\t".$ExternalServerName.".\n\n".
   "\t\t\tNS\tplandsfeld.avonet.cz.\n");
-  DB_Select('hosts','*','external_ip LIKE "'.$Network.'.%"');
-  while($Row = DB_Row())
+
+  $DbResult = $Database->select('hosts','*','external_ip LIKE "'.$Network.'.%"');
+  while($Row = $DbResult->fetch_array())
   {
     $IP = explode('.',$Row['external_ip']);
@@ -209 +208 @@
 fputs($File2, $Header);
 
-DB_Select('hosts','*','czfree_ip<>""');
-while($Row = DB_Row())
+$Database->select('hosts','*','czfree_ip<>""');
+while($Row = $Database->fetch_array())
 {
   $Data = strtolower($Row['name']);
-  if(strlen($Data)<8) $Data .= "\t";
+  if(strlen($Data) < 8) $Data .= "\t";
   fputs($File,$Data."\tIN\tA\t".$Row['czfree_ip']."\n");
   fputs($File2,$Data."\tIN\tA\t".$Row['IP']."\n");
   $Data = strtolower($Row['name'].'-ext');
-  if(strlen($Data)<8) $Data .= "\t"; 
-  fputs($File2,$Data."\tIN\tA\t".$Row['czfree_ip']."\n");
-}
-
-DB_Query("SELECT network_dns_alias.* FROM  `network_dns_alias` JOIN  `hosts`  ON network_dns_alias.target LIKE hosts.name AND hosts.czfree_ip != ''");
-while($Alias = DB_Row())
+  if(strlen($Data) < 8) $Data .= "\t"; 
+  fputs($File2, $Data."\tIN\tA\t".$Row['czfree_ip']."\n");
+}
+
+$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 != ''");
+while($Alias = $Database->fetch_array())
 {
   $Data = $Alias['name'];
@@ -267 +266 @@
   fputs($File2, $Header);
 
-  DB_Select('hosts','*','czfree_ip <> ""');
-  while($Row = DB_Row())
+  $DbResult = $Database->select('hosts','*','czfree_ip <> ""');
+  while($Row = $DbResult->fetch_array())
   {
     $IP = explode('.',$Row['czfree_ip']);