Yoshihisa Fukuhara
higef****@users*****
2006年 5月 19日 (金) 02:23:37 JST
Index: affelio/apps/diary/Diary.pm
diff -u affelio/apps/diary/Diary.pm:1.48 affelio/apps/diary/Diary.pm:1.49
--- affelio/apps/diary/Diary.pm:1.48 Wed Apr 19 21:20:20 2006
+++ affelio/apps/diary/Diary.pm Fri May 19 02:23:37 2006
@@ -135,20 +135,20 @@
#general setting table
if (create_table($self, $self->{pref_table},
"CREATE TABLE $self->{pref_table} (
- key TEXT, value TEXT)")){
- $self->{dbh}->do("INSERT INTO $self->{pref_table} (key, value) VALUES ('email', '$self->{afap}->{af}->{user__email1}')");
- $self->{dbh}->do("INSERT INTO $self->{pref_table} (key, value) VALUES ('max_entries', '10000')");
- $self->{dbh}->do("INSERT INTO $self->{pref_table} (key, value) VALUES ('max_comments', '256')");
- $self->{dbh}->do("INSERT INTO $self->{pref_table} (key, value) VALUES ('max_commentlen', '1000')");
- $self->{dbh}->do("INSERT INTO $self->{pref_table} (key, value) VALUES ('max_textlen', '10000')");
- $self->{dbh}->do("INSERT INTO $self->{pref_table} (key, value) VALUES ('show_author', '0')");
- $self->{dbh}->do("INSERT INTO $self->{pref_table} (key, value) VALUES ('image_size', '300')");
- $self->{dbh}->do("INSERT INTO $self->{pref_table} (key, value) VALUES ('moblog_popserv', '')");
- $self->{dbh}->do("INSERT INTO $self->{pref_table} (key, value) VALUES ('moblog_popuser', '')");
- $self->{dbh}->do("INSERT INTO $self->{pref_table} (key, value) VALUES ('moblog_poppass', '')");
- $self->{dbh}->do("INSERT INTO $self->{pref_table} (key, value) VALUES ('moblog_author', '')");
- $self->{dbh}->do("INSERT INTO $self->{pref_table} (key, value) VALUES ('moblog_lastcheck', '0')");
- $self->{dbh}->do("INSERT INTO $self->{pref_table} (key, value) VALUES ('moblog_check_interval', '15')");
+ key1 TEXT, value TEXT)")){
+ $self->{dbh}->do("INSERT INTO $self->{pref_table} (key1, value) VALUES ('email', '$self->{afap}->{af}->{user__email1}')");
+ $self->{dbh}->do("INSERT INTO $self->{pref_table} (key1, value) VALUES ('max_entries', '10000')");
+ $self->{dbh}->do("INSERT INTO $self->{pref_table} (key1, value) VALUES ('max_comments', '256')");
+ $self->{dbh}->do("INSERT INTO $self->{pref_table} (key1, value) VALUES ('max_commentlen', '1000')");
+ $self->{dbh}->do("INSERT INTO $self->{pref_table} (key1, value) VALUES ('max_textlen', '10000')");
+ $self->{dbh}->do("INSERT INTO $self->{pref_table} (key1, value) VALUES ('show_author', '0')");
+ $self->{dbh}->do("INSERT INTO $self->{pref_table} (key1, value) VALUES ('image_size', '300')");
+ $self->{dbh}->do("INSERT INTO $self->{pref_table} (key1, value) VALUES ('moblog_popserv', '')");
+ $self->{dbh}->do("INSERT INTO $self->{pref_table} (key1, value) VALUES ('moblog_popuser', '')");
+ $self->{dbh}->do("INSERT INTO $self->{pref_table} (key1, value) VALUES ('moblog_poppass', '')");
+ $self->{dbh}->do("INSERT INTO $self->{pref_table} (key1, value) VALUES ('moblog_author', '')");
+ $self->{dbh}->do("INSERT INTO $self->{pref_table} (key1, value) VALUES ('moblog_lastcheck', '0')");
+ $self->{dbh}->do("INSERT INTO $self->{pref_table} (key1, value) VALUES ('moblog_check_interval', '15')");
}
bless $self, $class;
debug_print("Diary::new: end.");
@@ -442,7 +442,7 @@
my $key = shift;
my $value = shift;
- $diary->{dbh}->do("UPDATE $diary->{pref_table} SET value = '$value' WHERE key = '$key'");
+ $diary->{dbh}->do("UPDATE $diary->{pref_table} SET value = '$value' WHERE key1 = '$key'");
}
##############################################
@@ -452,7 +452,7 @@
my $diary = shift;
my $key = shift;
- my $query = "SELECT value from $diary->{pref_table} where key = '$key'";
+ my $query = "SELECT value from $diary->{pref_table} where key1 = '$key'";
my $sth;
my @row =();
$sth = $diary->{dbh}->prepare($query);