print "6. Address Books (LDAP)\n";
print "7. Message of the Day (MOTD)\n";
print "8. Plugins\n";
+ print "9. Database\n";
print "\n";
print "D. Set pre-defined settings for specific IMAP servers\n";
print "\n";
print "A Sanitize all plugins for use with Squirrelmail 1.2\n";
print "\n";
print "R Return to Main Menu\n";
+ } elsif ($menu == 9) {
+ print $WHT."Database\n".$NRM;
+ print "1. DSN for Address Book : $WHT$addrbook_dsn$NRM\n";
+ print "2. Table for Address Book : $WHT$addrbook_table$NRM\n";
+ print "\n";
+ print "S Save data\n";
+ print "R Return to Main Menu\n";
}
if ($config_use_color == 1) {
print "C. Turn color off\n";
} else {
$saved = 0;
if ($menu == 0) {
- if (($command > 0) && ($command < 9)) {
+ if (($command > 0) && ($command < 10)) {
$menu = $command;
}
} elsif ($menu == 1) {
} elsif ($menu == 8) {
if ($command =~ /^[0-9]+/) { @plugins = command81(); }
elsif ($command eq "a") { command8s(); }
+ } elsif ($menu == 9) {
+ if ($command == 1) { $addrbook_dsn = command91(); }
+ elsif ($command == 2) { $addrbook_table = command92(); }
}
}
}
return $default_use_javascript_addr_book;
}
+sub command91 {
+ print "If you want to store your users address book details in a database then\n";
+ print "you need to set this DSN to a valid value. The format for this is:\n";
+ print "mysql://user:pass\@hostname/dbname\n";
+ print "Where mysql can be one of the databases PHP supports, the most common\n";
+ print "of these are mysql, msql and pgsql\n";
+ print "If the DSN is left empty (hit space and then return) the database\n";
+ print "related code for address books will not be used\n";
+ print "\n";
+
+ if ($addrbook_dsn eq "") {
+ $default_value = "Disabled";
+ } else {
+ $default_value = $addrbook_dsn;
+ }
+ print "[$WHT$addrbook_dsn$NRM]: $WHT";
+ $new_dsn = <STDIN>;
+ if ($new_dsn eq "\n") {
+ $new_dsn = "";
+ } else {
+ $new_dsn =~ s/[\r|\n]//g;
+ $new_dsn =~ s/^\s+$//g;
+ }
+ return $new_dsn;
+}
+
+sub command92 {
+ print "This is the name of the table you want to store the address book\n";
+ print "data in, it defaults to 'address'\n";
+ print "\n";
+ print "[$WHT$addrbook_table$NRM]: $WHT";
+ $new_table = <STDIN>;
+ if ($new_table eq "\n") {
+ $new_table = $addrbook_table;
+ } else {
+ $new_table =~ s/[\r|\n]//g;
+ }
+ return $new_table;
+}
sub save_data {
$tab = " ";
print CF "\$org_logo = '$org_logo';\n";
print CF "\$org_title = \"$org_title\";\n";
print CF "\$signout_page = '$signout_page';\n";
- print CF "\$frame_top = '$frame_top';\n";
+ if ($frame_top eq "") {
+ print CF "\$frame_top = '_top';\n";
+ } else {
+ print CF "\$frame_top = '$frame_top';\n";
+ }
print CF "\n";
print CF "global \$motd;\n";
print CF "\n";
}
- if (defined $addrbook_dsn) {
- print CF "global \$addrbook_dsn;\n";
- print CF "\$addrbook_dsn = $addrbook_dsn;\n\n";
- }
+ print CF "\nglobal \$addrbook_dsn, \$addrbook_table;\n";
+ print CF "\$addrbook_dsn = '$addrbook_dsn';\n";
+ print CF "\$addrbook_table = '$addrbook_table';\n\n";
print CF "/**\n";
print CF " * Make sure there are no characters after the PHP closing\n";