From 7fe908c50c8dbc5cc05f571dbe11d66141caacd4 Mon Sep 17 00:00:00 2001
From: Marius Cramer <m.cramer@pixcept.de>
Date: Thu, 14 Nov 2013 09:01:22 -0500
Subject: [PATCH] Cleaning up code to match coding guidelines
---
helper_scripts/mydns_to_powerdns_migration.php | 86 +++++++++++++++++++++---------------------
1 files changed, 43 insertions(+), 43 deletions(-)
diff --git a/helper_scripts/mydns_to_powerdns_migration.php b/helper_scripts/mydns_to_powerdns_migration.php
index 9c6526b..ffe9e4a 100644
--- a/helper_scripts/mydns_to_powerdns_migration.php
+++ b/helper_scripts/mydns_to_powerdns_migration.php
@@ -2,15 +2,15 @@
$host="localhost";
$user="root";
$password="MYSQL-ROOT-PASSWD";
-mysql_connect($host,$user,$password) or die(mysql_error());
+mysql_connect($host, $user, $password) or die(mysql_error());
mysql_select_db("dbispconfig");
$sql1 = mysql_query("SELECT id, substr(origin,1, LENGTH(origin)-1) AS origin, substr(ns,1, LENGTH(ns)-1) AS ns, substr(mbox,1, LENGTH(mbox)-1) AS mbox,ttl FROM dns_soa order by id asc;");
mysql_select_db("powerdns");
while($row1 = mysql_fetch_array($sql1))
{
-mysql_query("INSERT INTO domains (id,name,type,ispconfig_id) values ('$row1[id]','$row1[origin]','NATIVE','$row1[id]');");
-mysql_query("INSERT INTO records (domain_id,name,content,ispconfig_id,type,ttl,prio,change_date) values ('$row1[id]','$row1[origin]','$row1[ns] $row1[mbox] 0','$row1[id]','SOA','$row1[ttl]','0','1260446221');");
+ mysql_query("INSERT INTO domains (id,name,type,ispconfig_id) values ('$row1[id]','$row1[origin]','NATIVE','$row1[id]');");
+ mysql_query("INSERT INTO records (domain_id,name,content,ispconfig_id,type,ttl,prio,change_date) values ('$row1[id]','$row1[origin]','$row1[ns] $row1[mbox] 0','$row1[id]','SOA','$row1[ttl]','0','1260446221');");
}
mysql_select_db("dbispconfig");
@@ -18,44 +18,44 @@
mysql_select_db("powerdns");
while($row2 = mysql_fetch_array($sql2))
{
-if (strlen($row2['name']))
-{
-$file1=substr($row2['data'], -1);
-if ($file1==".")
-{
-$text = $row2['data'];
-$laenge = strlen($row2['data'])-1;
-$file2 = substr($text, 0,strlen($text)-1);
-}
-else
-{
-$file2=$row2['data'];
-}
-mysql_select_db("dbispconfig");
-$sql3 = mysql_query("SELECT substr(origin,1, LENGTH(origin)-1) AS origin FROM dns_soa where id=$row2[zone];");
-$row3 = mysql_fetch_array($sql3);
-mysql_select_db("powerdns");
-mysql_query("INSERT INTO records (domain_id,name,content,ispconfig_id,type,ttl,prio,change_date) values ('$row2[zone]','$row2[name].$row3[origin]','$file2','$row2[id]','$row2[type]','$row2[ttl]','$row2[aux]','1260446221');");
-}
-else
-{
-$file1=substr($row2['data'], -1);
-if ($file1==".")
-{
-$text = $row2['data'];
-$laenge = strlen($row2['data'])-1;
-$file2 = substr($text, 0,strlen($text)-1);
-}
-else
-{
-$file2=$row2['data'];
-}
-mysql_select_db("dbispconfig");
-$sql3 = mysql_query("SELECT substr(origin,1, LENGTH(origin)-1) AS origin FROM dns_soa where id=$row2[zone];");
-$row3 = mysql_fetch_array($sql3);
-mysql_select_db("powerdns");
-mysql_query("INSERT INTO records (domain_id,name,content,ispconfig_id,type,ttl,prio,change_date) values ('$row2[zone]','$row3[origin]','$file2','$row2[id]','$row2[type]','$row2[ttl]','$row2[aux]','1260446221');");
-}
+ if (strlen($row2['name']))
+ {
+ $file1=substr($row2['data'], -1);
+ if ($file1==".")
+ {
+ $text = $row2['data'];
+ $laenge = strlen($row2['data'])-1;
+ $file2 = substr($text, 0, strlen($text)-1);
+ }
+ else
+ {
+ $file2=$row2['data'];
+ }
+ mysql_select_db("dbispconfig");
+ $sql3 = mysql_query("SELECT substr(origin,1, LENGTH(origin)-1) AS origin FROM dns_soa where id=$row2[zone];");
+ $row3 = mysql_fetch_array($sql3);
+ mysql_select_db("powerdns");
+ mysql_query("INSERT INTO records (domain_id,name,content,ispconfig_id,type,ttl,prio,change_date) values ('$row2[zone]','$row2[name].$row3[origin]','$file2','$row2[id]','$row2[type]','$row2[ttl]','$row2[aux]','1260446221');");
+ }
+ else
+ {
+ $file1=substr($row2['data'], -1);
+ if ($file1==".")
+ {
+ $text = $row2['data'];
+ $laenge = strlen($row2['data'])-1;
+ $file2 = substr($text, 0, strlen($text)-1);
+ }
+ else
+ {
+ $file2=$row2['data'];
+ }
+ mysql_select_db("dbispconfig");
+ $sql3 = mysql_query("SELECT substr(origin,1, LENGTH(origin)-1) AS origin FROM dns_soa where id=$row2[zone];");
+ $row3 = mysql_fetch_array($sql3);
+ mysql_select_db("powerdns");
+ mysql_query("INSERT INTO records (domain_id,name,content,ispconfig_id,type,ttl,prio,change_date) values ('$row2[zone]','$row3[origin]','$file2','$row2[id]','$row2[type]','$row2[ttl]','$row2[aux]','1260446221');");
+ }
}
mysql_select_db("powerdns");
@@ -63,8 +63,8 @@
while($row4 = mysql_fetch_array($sql4))
{
-mysql_query("UPDATE records SET content = '$row4[content].$row4[name]' where id='$row4[id]';");
+ mysql_query("UPDATE records SET content = '$row4[content].$row4[name]' where id='$row4[id]';");
}
-?>
\ No newline at end of file
+?>
--
Gitblit v1.9.1