sql php sms parse

[maconbot]

hi all, please exuse my email ">" i am working on location.

> hey team, thanks for the quick reply.
>
> i am trying to parse a pop3 account and populate it into flash.
>
> the how to code...
> http://www.derickrethans.nl/parsing_mail_with_php.php
>
> - is this the class? i am really confused how to plug this into my
> hosting account. i am already using php and sql to dynamically update
> flash.
>
> here is what should be the only 2 php scripts i need, from what i "assume"
> one is a class property, and the second calls it up and defines it? i
> just don't know how to plug it in???
[php]
> <?php
> /*
> Sample File not more !!!
> Author: Jointy <bestmischmaker @web.de>
>
> Please read Readme.txt !!!
> */
>
> require("pop3.c lass.inc");
>
> // Constructor
> // optional
> $apop_detect = TRUE; // default = FALSE
> $log = TRUE; // default = FALSE
> $log_file = "pop3.class.log "; // must be set when $log = TRUE !!!
> $qmailer = FALSE;
>
>
> // func $pop3->connect()
> $server = "pop.lycos. de";
> // optional !!
> // $port = "110";
> // $conn_timeout = "25"; // Connection Timeout
> // $sock_timeout = "10,500"; // Socket Timeout
>
> // func $pop3->login()
> $username = "";
> $password = "";
> // optional
> //$apop = "0";
>
> // MySQL Vars for connect to DB Server
> $db["addr"] = "localhost" ;
> $db["user"] = "";
> $db["pass"] = "";
> $db["link"] = FALSE;
> $db["use"] = "mail";
> // optional
> $db["dir_table"] = "inbox"; // Table for header data
> $db["msg_table"] = "messages"; // Table for complete Messages (/w
> header)...
>
>
> // Your own free Vars
> // Save to MySQL ??
> $savetomysql = TRUE;
> $savetofile = TRUE;
> $delete = FALSE;
>
>
>
>
>
>
> $pop3 = new POP3($log,$log_ file,$apop_dete ct);
>
> if($pop3->connect($serve r)){
> if($pop3->login($usernam e,$password)){
> if(!$msg_list = $pop3->get_office_sta tus()){
> echo $pop3->error;
> return;
> }
> }else{
> echo $pop3->error;
> return;
> }
> }else{
> echo $pop3->error;
> return;
> }
>
> $db["link"] = mysql_connect($ db["addr"],$db["user"],$db["pass"]) or
> die(mysql_error ());
> mysql_select_db ($db["use"],$db["link"]) or die(mysql_error ());
>
> $noob = TRUE;
>
> for($i=1;$i<=$m sg_list["count_mail s"];$i++){
> if(!$header = $pop3->get_top($i)) {
> echo $pop3->error;
> }
> // Get Message ID and set $unique_id for save2file()
> $g = 0;
> while(!ereg("</HEADER>",$heade r[$g])){
> if(eregi("Messa ge-ID",$header[$g])){
> $unique_id = md5($header[$g]);
> }
> $g++;
> }
> unset($g);
>
> $query = 'SELECT `unique_id` FROM `'.$msg_table.' ` WHERE 1 AND
> `unique_id` = \''.$unique_id. '\' LIMIT 0, 1';
> $result = mysql_query($qu ery,$db["link"]) or die(mysql_error ());
>
> if($rows = mysql_fetch_arr ay($result)){
> $get_msg = FALSE;
> $savetofile = FALSE;
> $savetomysql = FALSE;
>
> }
> mysql_free_resu lt($result);
> unset($rows);
>
> if($get_msg){
> if(!$message = $pop3->get_mail($i, $qmailer)){
> echo $pop3->error;
> $savetofile = FALSE;
> $savetomysql = FALSE;
> $delete = FALSE;
> }
> }
>> if($savetofile) {
>
>
>
> $filename = ".//mails//".$unique_id.". txt";
>
> if(!is_file($fi lename)){
> if(!$filesize = $pop3->save2file($mes sage,$filename) ){
> echo $pop3->error;
> return;
> }else{
> echo "File saved to ".$filename ." (".$filesize ." Bytes written)
> !! \r\n <br>";
> }
> }else{
> echo "File <b>(".$filename .")</b> already exists. !! \r\n
> <br>";
> }
> }
>
> // Save to MySQL
> if($savetomysql ){
>
> if($count_bytes =
> $pop3->save2mysql($me ssage,$db["link"],$db["dir_table"],$db["msg_table"])){
> echo "File save to MySQL complete. (".$count_bytes ." Bytes
> written) !! \r\n <br>";
> }else{
> echo $pop3->error;
> return;
> }
> }
>
> // Send Noob command !!
> if($noop){
> if(!$pop3->noop()){
> echo $pop3->error;
> $noob = FALSE;
> }
> }
>
> // Delete MSG
> if($delete){
> if($pop3->delete_mail($i )){
> echo "Nachricht als gelöscht markiert !!! \r\n <br>";
> }else{
> echo $pop3->error;
> }
> }
>
> }
> if($msg_list["count_mail s"] == "0"){
> echo "Keine neuen Nachrichten !!";
> }
>
> mysql_close($db["link"]);
> $pop3->close();
>
> ?>
> _______________ _______________ __________
>> <?php
> require_once "ezc/Base/base.php";
> function __autoload( $className )
> {
> ezcBase::autolo ad( $className );
> }
> $pop3 = new ezcMailPop3Tran sport( "pop3.example.c om" );
> $pop3->authenticate ( "user", "password" );
> $set = $pop3->fetchAll();
> $parser = new ezcMailParser() ;
> $mails = $parser->parseMail( $set );
> foreach ( $mails as $mail )
> {
> echo "From: {$mail->from->email}\n";
> echo "To: ";
> foreach ( $mail->to as $to ) {
> echo "{$to->name} ({$to->email}) ";
> }
> echo "\n";
> echo "Subject: {$mail->subject}\n";
> switch ( get_class( $mail->body ) )
> {
> case 'ezcMailText':
> echo "Text part, ".
> "type={$mai l->body->subType}\n--\n";
> echo $mail->body->text;
> echo "\n--\n";
> break;
> case 'ezcMailMultipa rtMixed':
> echo "Multipart mail\n";
> break;
> }
> echo "\n";
> }
> ?>
>
>> flash code:
>
>
> //Create the URLLOader instance
> var myLoader:URLLoa der = new URLLoader()
> //the data will come as URL-encoded variables
> myLoader.dataFo rmat = URLLoaderDataFo rmat.VARIABLES
> //Load using an URLRequest. If you use some other back-end
> //language like java or aspx, you just modify the call, i.e
> // myLoader.load(n ew URLRequest("ana stasio.aspx"))
> myLoader.load(n ew URLRequest("./scripts/text_10/jg_X_IDs.php"))
> //onLoad handler listener
> myLoader.addEve ntListener(Even t.COMPLETE, onDataLoad)
> //Error handling
> myLoader.addEve ntListener(IOEr rorEvent.IO_ERR OR, onIOError)
> myLoader.addEve ntListener(Secu rityErrorEvent. SECURITY_ERROR,
> onSecurityError )
> //Could be an error or just a message
> myLoader.addEve ntListener(HTTP StatusEvent.HTT P_STATUS, onHTTPStatus)
> //add a listener for the complete event
> function onDataLoad(evt: Event){
> for(var i:uint=0; i<evt.target.da ta.cant; i++){
> this["Title_0"+i]Text = evt.target.data["Title"+i]}
>
>
> //populates it into dynamic text boxes. with instance names.
>[/php]
> _______________ _______________ __________
>>
> questions:
> Mail component php? - how do i use this and interact with flash?
>
> a simple explination of ez Components would be a great help too...can i
> plug this stuff into godaddy and reference it the same way i use classes
> in flash? only with this code php...
>
> require("pop3.c lass.inc");
> - http://ezcomponents.org/docs/api/1.0...tion_Mail.html
>
>
> i would be happy at this point to just get the php to hold my data and
> have flash pull it and post the whole raw sms code onto the stage.
>
> or do i have to install it, and use pearl, or pear in some way - i hope
> not? because i have no idea what that means.
>
> i have two php files. that should be able to pull this off, however i
> don't understand classes with php and if it can work on my linux shared
> hosting account or if i need to setup a different account with another
> hosting company. it should work because it doesn't require root access
> for this.
>
> or if i need to setup a gsm modem, and a whole sms gateway server, blah,
> blah. I think we can just do this with php parsing a pop3 and flash
> pulling those values. eventually transfering to a sql database is ideal,
> but probably out of your teams scope of help.
>> basically i am trying to read email from flash. any free pop3 account
> would work, or if you prefer i am hosted with godaddy.
>
> more definitive: recieve an sms message, and transfer the body, date, time
> to a sql server. I know this is php, but i already have most of the
> research done. please help! and bottom line i am looking to pull into
> flash. i hope you can help.
>
> i believe i have all of the language i need, now just the question of how
> to make it work.

[ronverdonk]

Urgent: please enclose any code within the proper code tags. See the Posting Guidelines on how to do that.

moderator