Masato Kikuhara
en-sf****@users*****
2005年 6月 30日 (木) 08:13:05 JST
Index: affelio/apps/diary/Diary.pm
diff -u affelio/apps/diary/Diary.pm:1.13 affelio/apps/diary/Diary.pm:1.14
--- affelio/apps/diary/Diary.pm:1.13 Thu Jun 30 07:57:13 2005
+++ affelio/apps/diary/Diary.pm Thu Jun 30 08:13:05 2005
@@ -29,7 +29,7 @@
$self->{entry_table} = "diary_$afap->{install_name}_entries";
$self->{comment_table} = "diary_$afap->{install_name}_comments";
$self->{tb_table} = "diary_$afap->{install_name}_tb";
- $self->{max_entries} = 300;
+ $self->{max_entries} = 365;
$self->{recent_entries_no} = 10;
$self->{header_title} = 'Affelio Diary';
$self->{header_show} = 0;
@@ -114,9 +114,10 @@
if($#same >= 0) { return; }
# log rotation
- if($self->getColumn("SELECT count(*) FROM $self->{entry_table}") > $self->{max_entries}) {
+ if($self->getColumn("SELECT count(*) FROM $self->{entry_table}") >= $self->{max_entries}) {
my $erase = $self->getColumn("SELECT MIN(timestamp) FROM $self->{entry_table}");
- $self->{dbh}->do("DELETE FROM $self->{entry_table} WHERE timestamp = '$erase'");
+ my $erase_id = $self->getColumn("SELECT id FROM $self->{entry_table} WHERE timestamp = '$erase'");
+ $self->removeEntry($erase_id);
}
$self->{dbh}->do("INSERT INTO $self->{entry_table} VALUES (NULL, '$title', '$contents', $year, $mon, $mday, $time)");