Manual lines in DNS zone file

[NecromanX]

Hello all,

i am new too ispcp and offcourse this forum. But i found a little issue in this patch.
I have a second nameserver configured to slave all zones from the primary nameserver. But in this patch if i would add 4 or 5 records in 1 day the serial would still remain the same! this is an issue if you want your second nameserver to get the updated zones. And offcourse it just isnt correct to keep the zone's serial identical after multiple modifications.

i fixed this issue by adding a new field in the table domain:
field: last_session [varchar:10] at the end of the table. this field stores the last used session and if the used timestamp is equal to this last_session of smaller then fill in the TIMESTAMP serial tag with last_session + 1
Here is my diff file between my ispcp-dns-mngr and the one after this rc7 patch

Code:

382a383
>       my $dmn_id       = @$dmn_data[0];
384a386
>       my $last_serial  = @$dmn_data[22];
423a426
>
426a430,438
>       #Is our Timestamp outdated? did we edit the zone allready this day?
>       if ($time2 eq $last_serial || $time2 <= $last_serial){
>               $time2 = $last_serial + 1;
>       }
>
>       my $sql_fix = "update domain set last_serial='$time2' where domain_id = $dmn_id";
>       my $data_fix = undef;
>       ($rs, $data_fix) = doSQL($sql_fix);
>
3632c3644
<               t1.domain_cgi, t2.ip_number FROM domain AS t1, server_ips AS t2 WHERE t1.domain_ip_id = t2.ip_id
---
>               t1.domain_cgi, t2.ip_number, t1.last_serial FROM domain AS t1, server_ips AS t2 WHERE t1.domain_ip_id = t2.ip_id

If anyone would be so kind to modify the current patch with my diff and the alter table instructions.
I would create the patch myself but i should look up how to create a propper patch. What command should i use?

I Hope this is of any use to someone

Greets,
David