[users] Re: Patch: canonical get_data output

[Conny Brunnkvist]

Conny Brunnkvist wrote:
[file: dev-vegadns-get_data_sorted.patch]
[file: dev-vegadns-get_data_content_type.patch]
Oops, I hit the wrong key. Here are the files.

//conny
diff -ru vegadns-0.6.1/index.php ../vegadns/index.php
--- vegadns-0.6.1/index.php	Sat Mar 20 03:14:48 2004
+++ ../vegadns/index.php	Tue Apr  6 16:36:20 2004
@@ -68,6 +68,7 @@
 
 if(isset($_REQUEST['state']) && $_REQUEST['state'] == 'get_data') {
 
+	header("Content-type: text/plain; charset=iso-8859-1");
     // EXPORT DATA
     require('src/data.php');
     exit;
diff -ru vegadns-0.6.1/src/data.php ../vegadns/src/data.php
--- vegadns-0.6.1/src/data.php	Wed Jan 21 21:27:11 2004
+++ ../vegadns/src/data.php	Tue Apr  6 16:41:46 2004
@@ -27,7 +27,7 @@
 
 
 // build data
-$q = "select a.domain, b.host, b.type, b.val, b.distance, b.ttl  from domains a left join records  b on a.domain_id = b.domain_id where a.status='active' order by a.domain,b.type";
+$q = "select a.domain, b.host, b.type, b.val, b.distance, b.ttl  from domains a left join records  b on a.domain_id = b.domain_id where a.status='active' order by a.domain, b.type, b.host, b.val";
 $result = mysql_query($q) or die(mysql_error());
 $out = "";