| 1 | mysql> select contents from maia_mail where id=418178; |
|---|
| 2 | +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ |
|---|
| 3 | | contents | |
|---|
| 4 | +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ |
|---|
| 5 | |X-Greylist: whitelisted by SQLgrey-1.6.5 |
|---|
| 6 | Received: from lists-outbound.sourceforge.net (lists-outbound.sourceforge.net [66.35.250.225]) |
|---|
| 7 | by darkside.crazeecanuck.homelinux.net (Postfix) with ESMTP id 3FE93D6B087 |
|---|
| 8 | for <ed@crazeecanuck.homelinux.net>; Thu, 28 Jul 2005 15:12:16 -0400 (EDT) |
|---|
| 9 | Received: from projects.sourceforge.net (sc8-sf-list1-b.sourceforge.net [10.3.1.7]) |
|---|
| 10 | by sc8-sf-spam2.sourceforge.net (Postfix) with ESMTP |
|---|
| 11 | id 6145612F60; Thu, 28 Jul 2005 12:12:16 -0700 (PDT) |
|---|
| 12 | Received: from sc8-sf-mx1-b.sourceforge.net ([10.3.1.91] helo=mail.sourceforge.net) |
|---|
| 13 | by sc8-sf-list1.sourceforge.net with esmtp (Exim 4.30) |
|---|
| 14 | id 1DyDmX-00008k-Hu |
|---|
| 15 | for mrpostman-developers@lists.sourceforge.net; Thu, 28 Jul 2005 12:11:01 -0700 |
|---|
| 16 | Received: from smtp1.kodak.com ([192.232.121.200]) |
|---|
| 17 | by mail.sourceforge.net with esmtp (Exim 4.44) |
|---|
| 18 | id 1DyDmW-0007OO-2m |
|---|
| 19 | for mrpostman-developers@lists.sourceforge.net; Thu, 28 Jul 2005 12:11:01 -0700 |
|---|
| 20 | Received: from roc-us-e1000-112.kodak.com (roc-us-e1000-112.kodak.com [192.232.121.192]) |
|---|
| 21 | by smtp1.kodak.com (8.11.3/8.11.1) with SMTP id j6SJAwV21692 |
|---|
| 22 | for <mrpostman-developers@lists.sourceforge.net>; Thu, 28 Jul 2005 15:10:58 -0400 (EDT) |
|---|
| 23 | Received: from (155.50.95.109) by roc-us-e1000-112.kodak.com via smtp |
|---|
| 24 | id 378a_66ab985c_ff9b_11d9_9125_0002b3c946b6; |
|---|
| 25 | Thu, 28 Jul 2005 15:11:29 -0400 |
|---|
| 26 | Mime-Version: 1.0 (Apple Message framework v733) |
|---|
| 27 | Content-Transfer-Encoding: 7bit |
|---|
| 28 | Message-Id: <4AC78E2E-6DDF-49FA-A6F3-2BCF909FAEC8@houchin.us> |
|---|
| 29 | Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed |
|---|
| 30 | To: mrpostman-developers@lists.sourceforge.net |
|---|
| 31 | From: Scott Houchin <scott@houchin.us> |
|---|
| 32 | X-Mailer: Apple Mail (2.733) |
|---|
| 33 | X-Spam-Score: 0.0 (/) |
|---|
| 34 | X-Spam-Report: Spam Filtering performed by sourceforge.net. |
|---|
| 35 | See http://spamassassin.org/tag/ for more details. |
|---|
| 36 | Report problems to http://sf.net/tracker/?func=add&group_id=1&atid=200001 |
|---|
| 37 | 0.0 SF_CHICKENPOX_PERIOD BODY: Text interparsed with . |
|---|
| 38 | 0.0 SF_CHICKENPOX_SLASH BODY: Text interparsed with / |
|---|
| 39 | 0.0 SF_CHICKENPOX_APOSTROPHE BODY: Text interparsed with ' |
|---|
| 40 | 0.0 AWL AWL: From: address is in the auto white-list |
|---|
| 41 | Subject: [Mrpostman-developers] Partial fix for delete bug in simple.script/mail.php |
|---|
| 42 | Sender: mrpostman-developers-admin@lists.sourceforge.net |
|---|
| 43 | Errors-To: mrpostman-developers-admin@lists.sourceforge.net |
|---|
| 44 | X-BeenThere: mrpostman-developers@lists.sourceforge.net |
|---|
| 45 | X-Mailman-Version: 2.0.9-sf.net |
|---|
| 46 | Precedence: bulk |
|---|
| 47 | Reply-To: mrpostman-developers@lists.sourceforge.net |
|---|
| 48 | List-Unsubscribe: <https://lists.sourceforge.net/lists/listinfo/mrpostman-developers>, |
|---|
| 49 | <mailto:mrpostman-developers-request@lists.sourceforge.net?subject=unsubscribe> |
|---|
| 50 | List-Id: <mrpostman-developers.lists.sourceforge.net> |
|---|
| 51 | List-Post: <mailto:mrpostman-developers@lists.sourceforge.net> |
|---|
| 52 | List-Help: <mailto:mrpostman-developers-request@lists.sourceforge.net?subject=help> |
|---|
| 53 | List-Subscribe: <https://lists.sourceforge.net/lists/listinfo/mrpostman-developers>, |
|---|
| 54 | <mailto:mrpostman-developers-request@lists.sourceforge.net?subject=subscribe> |
|---|
| 55 | List-Archive: <http://sourceforge.net/mailarchive/forum.php?forum=mrpostman-developers> |
|---|
| 56 | Date: Thu, 28 Jul 2005 15:10:55 -0400 |
|---|
| 57 | |
|---|
| 58 | Hi, |
|---|
| 59 | |
|---|
| 60 | First, thanks to everyone who contributed to MrPostman. This is a |
|---|
| 61 | wonderful solution! |
|---|
| 62 | |
|---|
| 63 | I am using simple.script and mail.php on my website, but have been |
|---|
| 64 | having a problem with message deletion. Only one message would get |
|---|
| 65 | deleted each time MrPostman checked my mail, even though the |
|---|
| 66 | MrPostman logs seem to indicate that it's deleting all of the |
|---|
| 67 | messages. If I used my web browser to access mail.php, I got exactly |
|---|
| 68 | the same result: only one message deleted each time. |
|---|
| 69 | |
|---|
| 70 | After a bit of debugging, I discovered a bug in mail.php. Line 126, |
|---|
| 71 | the HTML that generates the delete checkbox for each message, should be: |
|---|
| 72 | |
|---|
| 73 | <td><input type="checkbox" name="uid[]" value="<?= |
|---|
| 74 | $msg->uid?>" /></td> |
|---|
| 75 | |
|---|
| 76 | The difference is the addition of "[]" as part of the name of the |
|---|
| 77 | <input>. In PHP, request inputs of the same name go into an |
|---|
| 78 | associative array by their actual name. If you just use the name, |
|---|
| 79 | they end up overwritting each other. Thus while MrPostman thought it |
|---|
| 80 | was deleting all messages, it was really only deleting the last |
|---|
| 81 | message in the list. Adding the PHP syntax for "add this to the end |
|---|
| 82 | of an array" to the name makes it work as intended. |
|---|
| 83 | |
|---|
| 84 | I'm stuck though in how to modify simple.script to reflect the |
|---|
| 85 | modified name. I'm guessing I have to modify line 68 (params["uid#" & |
|---|
| 86 | i] = msg.id) within the delete subroutine, but I'm not sure what |
|---|
| 87 | syntax these script files are in and if it's really just as simple as |
|---|
| 88 | turning it into: |
|---|
| 89 | |
|---|
| 90 | params["uid[]#" & i] = msg.id |
|---|
| 91 | |
|---|
| 92 | |
|---|
| 93 | Thanks, |
|---|
| 94 | Scott Houchin |
|---|
| 95 | |
|---|
| 96 | |
|---|
| 97 | |
|---|
| 98 | |
|---|
| 99 | |
|---|
| 100 | ------------------------------------------------------- |
|---|
| 101 | SF.Net email is Sponsored by the Better Software Conference & EXPO September |
|---|
| 102 | 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices |
|---|
| 103 | Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA |
|---|
| 104 | Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf |
|---|
| 105 | _______________________________________________ |
|---|
| 106 | Mrpostman-developers mailing list |
|---|
| 107 | Mrpostman-developers@lists.sourceforge.net |
|---|
| 108 | https://lists.sourceforge.net/lists/listinfo/mrpostman-developers |
|---|
| 109 | | |
|---|
| 110 | +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ |
|---|
| 111 | 1 row in set (0.00 sec) |
|---|
| 112 | |
|---|
| 113 | mysql> |
|---|
