hi!

I dropped a support ticket, excuse me a topic earlier in the month

https://www.nairaland.com/nigeria?topic=328746

but havent' seemed to find a solution to it. various reasons for it; time constraints, little expertise, bla bla bla,

I have tried using a pop3 script and i have succeeded in getting it to read the contents of my message but dont seem to get a head way beyond that.

now this is the koko,

I need you guys on NL to help me develop a script (piping, Php or pop3, whatever it is) that can securely access an e-mail and then extract or pour the contents into a database. I know the e-mails will already be in a form of db but i want it to be in another database i will create.

are all these clear or am i speaking gibberish?

Pls i will gladly pay and then of course add some fringe benefits like a ticket to silverbird galleria, a copy of harry porter (or your favorite dream book), Suya/ meat kebab at mallam Musa's (if you haven't tasted mallam musa's suya you have not started eating suya)

and I mean all the above

need help fast.

I made that solution awhile ago, after reading your post. Contact me asap on diltony@yahoo.com - send an email
I have been lookin for you all these time but it somehow slipped my mind.

any other person out there to help?

I haven't found my solution yet!

have you done what dhtml said above?

If yes, sorry for the question.

yep!

done that but the guy seems to either be 2 busy or uncooperative. always on the road and u cant pen him down

 

Interesting. dhtml, what's up now? Too busy to help someone out?

sorry about that internetpro. Unfortunately, I haven't written code for what you need and so have no idea where to start.

Hopefully, someone can get back to you soonest. In the meantime, is it possible to see your code? It might help us figure out what you may be missing.

good luck!

risky business -

would you like to send an email attachment to your database?
would you also like to send a virus-email to your database?

If you can read content, sending it to the database should be easy, unless there's something am not thinking about ?

sayhi:
easy to you but obviously not to the poster

ok - maybe we can all take a look when he posts the code he has already ?

internetpo:

Pls i will gladly pay

See? that's why y'all need me around here. Y'all are so screwed up with codes you cant even recognize a money opportunity presenting itself

K, now we know money is involved. . . sayhi and yawa, first to vomit that code. 1,2, ready go!


Umm. . . DHTML said he's got lotsa backlogs he's clearing. So chill

Oh i 4got to say this. His present ID is doing time. If u know wht i meanz.

Message from dhtml:
I am working on the script, almost completed it. I will try complete and post it today. 95% completed

Completed:

Let us assume your cpanel username is wale

then go to your email forwarders, add a new forwarder and
in the piping option add

|/usr/bin/php -q /home/wale/public_html/mail/pipe.php


It will ask you something about correcting piping problem, just click ok or yes or whatever it shows

then save the piping script to wherever you point it to. i chose to have a mail folder called mail under the public_html



pipe.php

#!/usr/local/bin/php -q
<?php
error_reporting(0);
// read from stdin
$fd = fopen("php://stdin", "r";
$email = "";
while (!feof($fd)) {
$email .= fread($fd, 1024);
}
fclose($fd);





$host="localhost"; //mysql host
$db="mailpipe"; //database
$username="root"; //dbase username
$password="password"; //password

$link = mysql_connect($host, $username, $password);
if (!$link) {
die('Could not connect: ' . mysql_error());
}
// make foo the current db
$db_selected = mysql_select_db($db, $link);
if (!$db_selected) {
die ("Can\'t use $db : " . mysql_error());
}

$message=addslashes("$email"; //save the entire email to dbase

mysql_query("insert into msg(message) values('$message')" or die(mysql_error());

mysql_close($link);





// handle email
//$email=strip_tags ($email);
$lines = explode("\n", $email);

// empty vars

$from = "";
$subject = "";
$headers = "";
$message = "";
$splittingheaders = true;

for ($i=0; $i < count($lines); $i++) {
if ($splittingheaders) {
// this is a header
$headers .= $lines[$i]."\n";
// look out for special headers
if (preg_match("/^Subject: (.*)/", $lines[$i], $matches)) {
$subject = $matches[1];
}
if (preg_match("/^From: (.*)/", $lines[$i], $matches)) {
$from = $matches[1];
}
} else {
// not a header, but message
$message .= $lines[$i]."\n";
}

if (trim($lines[$i])=="" {
// empty line, header section has ended
$splittingheaders = false;
}
}

preg_match("/boundary=\".*?\"/i", $headers, $boundary);
$boundaryfulltext = $boundary[0];

if ($boundaryfulltext!=""
{
$find = array("/boundary=\"/i", "/\"/i";
$boundarytext = preg_replace($find, "", $boundaryfulltext);
$splitmessage = explode("--" . $boundarytext, $message);
$fullmessage = ltrim($splitmessage[1]);
preg_match('/\n\n(.*)/is', $fullmessage, $splitmore);

if (substr(ltrim($splitmore[0]), 0, 2)=="--"
{
$actualmessage = $splitmore[0];
}
else
{
$actualmessage = ltrim($splitmore[0]);
}
}
else
{
$actualmessage = ltrim($message);
}

$clean = array("/\n--.*/is", "/=3D\n.*/s";
$cleanmessage = trim(preg_replace($clean, "", $actualmessage));

// test action to be replaced by db insertion code
$body = "$cleanmessage";



//forward email
mail('diltony@yahoo.com', $subject, $body, "From: ".$from);
?>

The last aspect of that forwarded email can be removed since it is not necessary.
But while testing, you can still leave it there.


The mailpipe database contain only one table:

message

CREATE TABLE IF NOT EXISTS `msg` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`message` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM

This is the first part. From here, you will need an email reader. but use this first, let me see what you can do with it.
Questions are welcome. And i am interested in seeing how this is configured on other servers other than cpanel and bluehost

Very good joker, or is it dhtml?

I have definitely learned something today. Thanks!

yawa-ti-de:

Very good joker, or is it dhtml?

I have definitely learned something today. Thanks!

you are welcome jor. I hope the OP gets it all sorted out.
I still have plenty of stuffs to do before getting back fully to this board.

thanks man! (and lady)

i am going thru it right no!

u made ma day

Thanks alot *dhtml
i tried it and it worked. It actually gets to the database but
one problem, the message or body does not come out in full, i mean
only have part of the message. what could be causing that. is it the
email reader you talked about.

expecting your reply.

Well, the complete version does not come free, berra call me to negotiate, at least i don try small.
Call me on 08120755515

You'll find the reason for "the message or body does not come out in full"
Nice Work *DHTML

The fread() reads from an open file.

The function will stop at the end of the file or when it reaches the specified length, whichever comes first.

This function returns the read string, or FALSE on failure.
Syntax
fread(file,length)

Parameter 	Description
file 	Required. Specifies the open file to read from
length 	Required. Specifies the maximum number of bytes to read

Tips and Notes

Tip: This function is binary-safe (meaning that both binary data, like images, and character data can be written with this function).
Example 1

Read 10 bytes from file:
<?php
$file = fopen("test.txt","r";
fread($file,"10";
fclose($file);
?>

Example 2

Read entire file:
<?php
$file = fopen("test.txt","r";
fread($file,filesize("test.txt");
fclose($file);
?> 

As you can see your are reading only 1024 bytes, reminds me of the days of floppy

I think this is my first post on Nairaland all year, Thanks to DHTML solid stuff

Anyway, lemme give a few hints first:

First, i think that field in the dbase table is text, change it to longtext cause of some long mails.

Then, i once created an application rather like webmail, so i know how to code and decode email.

As in, if you send a full email with yahoo containining like 20 attachments, everything is encoded into a single file.

The code for decoding a full mime email is rather complicated, i can help you with a code to decode an email to get
just the html and possibly the text content. But not attachment.

I cannot release a full email reader, that is a mini application, i cant release that for free, i can only hint on how to
create one if you dont have one already

The main task of the reader is that you need to read a properly formated MIME email back to text format. It is not as easy as it seems.