| Revision: | 1.1 |
| Committed: | Thu Aug 9 02:57:54 2001 UTC (25 years, 2 months ago) by root |
| Content type: | text/plain |
| Branch: | MAIN |
| CVS Tags: | rel-2_5, rel-4_91, rel-4_22, rel-4_21, rel-4_0, rel-4_3, rel-3_41, rel-5_151, rel-4_13, rel-4_11, rel-5_1, rel-5_0, rel-6_0, rel-6_5, rel-4_748, rel-3_55, rel-4_8, rel-4_9, rel-3_51, rel-4_741, rel-4_743, rel-4_742, rel-6_10, rel-4_744, rel-4_747, rel-6_13, rel-4_01, rel-4_03, rel-4_02, rel-2_0, rel-2_1, rel-1_1, rel-1_0, rel-1_9, rel-1_2, rel-3_6, rel-3_62, rel-3_63, rel-3_61, rel-1_5, rel-1_4, rel-1_7, rel-1_6, rel-3_4, rel-6_09, rel-6_08, rel-6_07, rel-6_06, rel-6_05, rel-6_04, rel-6_03, rel-6_02, rel-6_01, rel-5_161, rel-3_1, rel-4_74, rel-4_71, rel-4_72, rel-4_73, rel-5_371, rel-5_372, rel-6_512, rel-6_513, rel-6_511, rel-6_514, rel-5_22, rel-5_23, rel-5_24, rel-5_25, rel-6_32, rel-6_33, rel-6_31, rel-6_36, rel-6_37, rel-5_162, rel-5_2, rel-6_38, rel-6_39, rel-4_802, rel-4_803, rel-3_5, rel-4_801, rel-3_3, rel-3_2, rel-4_804, rel-3_0, rel-5_37, rel-5_36, rel-4_479, rel-6_23, rel-3_01, rel-6_29, rel-6_28, rel-6_46, rel-4_50, rel-4_51, rel-6_45, rel-4_4, rel-3_11, rel-1_31, rel-4_45, rel-6_51, rel-6_52, rel-6_53, rel-6_54, rel-6_55, rel-6_56, rel-6_57, rel-4_745, rel-4_901, rel-4_49, rel-4_48, rel-4_1, rel-4_2, rel-4_746, rel-5_11, rel-5_12, rel-5_15, rel-5_14, rel-5_17, rel-5_16, stack_sharing, rel-4_47, rel-4_46, rel-4_7, rel-3_501, rel-6_43, rel-6_42, rel-6_41, rel-6_47, rel-5_132, rel-5_131, rel-6_44, rel-6_49, rel-6_48, rel-4_911, rel-4_912, rel-4_31, rel-4_32, rel-4_33, rel-4_34, rel-4_35, rel-4_36, rel-4_37, HEAD |
| Log Message: | *** empty log message *** |
| # | User | Rev | Content |
|---|---|---|---|
| 1 | root | 1.1 | use PApp::SQL; |
| 2 | |||
| 3 | $PApp::SQL::DBH = DBI->connect("DBI:mysql:mymap") | ||
| 4 | or die "database: $!"; | ||
| 5 | |||
| 6 | $CR = "\015"; | ||
| 7 | $CRLF = "\015\012"; | ||
| 8 | |||
| 9 | $F_D = 0x01; | ||
| 10 | $F_deleted = 0x02; | ||
| 11 | $F_flagged = 0x04; | ||
| 12 | $F_answered = 0x08; | ||
| 13 | $F_seen = 0x10; | ||
| 14 | $F_draft = 0x20; | ||
| 15 | |||
| 16 | sub find_uid { | ||
| 17 | sql_fetch "select id from user where name = ?", $_[0]; | ||
| 18 | } | ||
| 19 | |||
| 20 | sub find_bid { | ||
| 21 | sql_fetch "select id from box where uid = ? and name = ?", $_[0], $_[1]; | ||
| 22 | } | ||
| 23 | |||
| 24 | my $skip_from = qr{^pcg\@goof.com$}i; | ||
| 25 | my $skip_to = qr{(\.laendle|plan9\.de|schmorp\.de)$}i; | ||
| 26 | |||
| 27 | sub _raddr { | ||
| 28 | $_raddr{$_[0]} ||= eval { (parse Mail::Address $_[0])[0]->address }; | ||
| 29 | } | ||
| 30 | |||
| 31 | sub deliver_mail { | ||
| 32 | my ($bid, $env_from, $env_to, $date, $flags, $head, $body) = @_; | ||
| 33 | |||
| 34 | sql_exec "lock tables box write, msg write"; | ||
| 35 | unless (sql_exists "msg where bid = ? and env_from = ? and env_to = ? and ntime = ? and header = ? and body = ?", | ||
| 36 | $bid, $env_from, $env_to,$date, $head, $body) { | ||
| 37 | sql_exec "insert into msg (bid, env_from, env_to, ntime, flags, header, body) | ||
| 38 | values (?,?,?,?,?,?,?)", | ||
| 39 | $bid, $env_from, $env_to, $date, $flags, $head, $body; | ||
| 40 | } | ||
| 41 | sql_exec "unlock tables"; | ||
| 42 | } | ||
| 43 | |||
| 44 | # import Mail::Message object into the given folder | ||
| 45 | sub import_mailmsg { | ||
| 46 | my ($bid, $msg) = @_; | ||
| 47 | |||
| 48 | my $body = join "", @{$msg->body}; | ||
| 49 | $msg = $msg->head; | ||
| 50 | $msg->unfold; | ||
| 51 | |||
| 52 | my ($from, $to, $date); | ||
| 53 | |||
| 54 | if ($from = $msg->get("Mail-From")) { | ||
| 55 | $msg->delete("Mail-From"); | ||
| 56 | ($from, $date) = split /\s+/, $from, 2; | ||
| 57 | } | ||
| 58 | |||
| 59 | undef $from if $from =~ $skip_from; | ||
| 60 | |||
| 61 | $from ||= $msg->get("Sender") || $msg->get("From"); | ||
| 62 | |||
| 63 | $from = _raddr $from; | ||
| 64 | |||
| 65 | $to = _raddr $msg->get("To"); | ||
| 66 | for (my $idx = 0; $idx < 29; $idx++) { | ||
| 67 | my $rcvd = extract Mail::Field "Received", $msg, $idx | ||
| 68 | or last; | ||
| 69 | $rcvd = $rcvd->parse_tree; | ||
| 70 | $date ||= $rcvd->{date_time}{date_time}; | ||
| 71 | my $xto = _raddr $rcvd->{for}{for} | ||
| 72 | or next; | ||
| 73 | $to = $xto; | ||
| 74 | last unless $to =~ $skip_to; | ||
| 75 | } | ||
| 76 | |||
| 77 | my $status = $msg->get("Status"); $msg->delete("Status"); | ||
| 78 | |||
| 79 | $date = str2time($date); | ||
| 80 | |||
| 81 | my @flags; | ||
| 82 | push @flags, "seen" if $status =~ /O/i; | ||
| 83 | push @flags, "deleted" if $status =~ /D/i; | ||
| 84 | push @flags, "answered" if $status =~ /R/i; | ||
| 85 | push @flags, "flagged" if $status =~ /!/i; | ||
| 86 | push @flags, "recent" if !$status; | ||
| 87 | |||
| 88 | $msg->delete("Content-Length"); | ||
| 89 | |||
| 90 | my $head = $msg->as_string; | ||
| 91 | |||
| 92 | for ($body, $head) { | ||
| 93 | s/\n/$CRLF/o; | ||
| 94 | } | ||
| 95 | |||
| 96 | deliver_mail ($bid, $from, $to, $date, (join ",", @flags), $head, $body); | ||
| 97 | } | ||
| 98 | |||
| 99 | sub flags2bitmask { | ||
| 100 | my $mask = 0; | ||
| 101 | |||
| 102 | for (@_) { | ||
| 103 | $mask |= $F_D if /^\\D$/i; | ||
| 104 | $mask |= $F_deleted if /^\\deleted$/i; | ||
| 105 | $mask |= $F_flagged if /^\\flagged$/i; | ||
| 106 | $mask |= $F_answered if /^\\answered$/i; | ||
| 107 | $mask |= $F_seen if /^\\seen$/i; | ||
| 108 | $mask |= $F_draft if /^\\draft$/i; | ||
| 109 | } | ||
| 110 | |||
| 111 | $mask; | ||
| 112 | } |