The query used in src/data.php uses an order by clause that determines
as least weighted attribute the "val" field from the records table.
I have found more usefull to have the query order by the record_id,
again with less weight.
In the case one is using TXT records and would like the to be presented
in a certain way, and since they're inserted sequentially, that would
allow the display of those records to follow the insert order. Also i
found no evidence of this being a bad thing to do, but since i'm fairly
new to vegadns, i'd like to as you folks if the change i made as any
negative impact.
original query was:
$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";
new query is:
$q = "select a.domain, b.host, b.type, b.val, b.distance, b.ttl,
b.record_id 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.record_id";
Please advise.
Thank you in advance,
Hugo Monteiro.
--
ci.fct.unl.pt:~# cat .signature
Hugo Monteiro
Email : [email protected]
Telefone : +351 212948300 Ext.15307
Web : http://hmonteiro.net
Centro de Informática
Faculdade de Ciências e Tecnologia da
Universidade Nova de Lisboa
Quinta da Torre 2829-516 Caparica Portugal
Telefone: +351 212948596 Fax: +351 212948548
www.ci.fct.unl.pt [email protected]
ci.fct.unl.pt:~# _
